Table(jsonInput)
subsetData = tidy(
jsonInput,
// filter to a few cities
filter(d => ['Austin', 'Houston', 'Dallas', 'San Antonio'].includes(d.city))
)
Table(subsetData)
pctData = tidy(
subsetData,
// 1. compute the total for each month and store as a property on each point
groupBy('month', mutateWithSummary({ totalMonthSales: sum('sales') })),
// 2. compute the percent of total. use rate() to safely
// handle division by zero and nully values.
mutate({ percent: rate('sales', 'totalMonthSales') })
)
Table(pctData)
totalData = tidy(
jsonInput,
// for each time period, sum up the sales
groupBy('month', summarize({ overallTotalMonthSales: sum('sales') }))
)
Table(totalData)
overallPctData = tidy(
subsetData,
// join our totals for each month, making `overallTotalMonthSales` available on each item
innerJoin(totalData, { by: 'month' }),
// compute the percent for each item
mutate({ percent: rate('sales', 'overallTotalMonthSales') }),
// (optional) sort the data just to make it more similar to the data above for comparison purposes
arrange('month')
)
Table(overallPctData)
import {
tidy,
filter,
select,
mutate,
groupBy,
mutateWithSummary,
summarize,
sum,
rate,
TMath,
innerJoin,
leftJoin,
arrange,
} from '@pbeshai/tidyjs'
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
