researcher + visual artist
Public
Edited
Aug 14, 2023
chicago / phoenix weather
import {
tidy,
groupBy,
summarize,
tally,
count,
n,
filter,
complete,
select,
pivotLonger,
negate,
sum,
mutate,
mutateWithSummary,
lag,
rename,
first,
max,
sliceMax,
mean,
map,
} from '@pbeshai/tidyjs'
phoenix = FileAttachment("KPHX.csv").csv()
chicago = FileAttachment("KMDW.csv").csv()
houston = FileAttachment("KHOU.csv").csv()
nyc = FileAttachment("KNYC.csv").csv()
seattle = FileAttachment("KSEA.csv").csv()
tidy_phoenix = tidy(
phoenix,
mutate({
'month': (d) => new Date(d.date).toLocaleString('default', { month: 'long' }),
'actual_mean_temp': (d) => Number(d.actual_mean_temp)
}),
groupBy('month', [
summarize({ mean_temp: mean('actual_mean_temp'), month_date: first('date') })
]),
mutate({
'month_date': (d) => new Date(d.month_date),
'city': "Phoenix"
}),
select(['-month'])
)
tidy_chicago = tidy(
chicago,
mutate({
'month': (d) => new Date(d.date).toLocaleString('default', { month: 'long' }),
'actual_mean_temp': (d) => Number(d.actual_mean_temp)
}),
groupBy('month', [
summarize({ mean_temp: mean('actual_mean_temp'), month_date: first('date') })
]),
mutate({
'month_date': (d) => new Date(d.month_date),
'city': "Chicago"
}),
select(['-month'])
)
tidy_houston = tidy(
houston,
mutate({
'month': (d) => new Date(d.date).toLocaleString('default', { month: 'long' }),
'actual_mean_temp': (d) => Number(d.actual_mean_temp)
}),
groupBy('month', [
summarize({ mean_temp: mean('actual_mean_temp'), month_date: first('date') })
]),
mutate({
'month_date': (d) => new Date(d.month_date),
'city': "Houston"
}),
select(['-month'])
)
tidy_nyc = tidy(
nyc,
mutate({
'month': (d) => new Date(d.date).toLocaleString('default', { month: 'long' }),
'actual_mean_temp': (d) => Number(d.actual_mean_temp)
}),
groupBy('month', [
summarize({ mean_temp: mean('actual_mean_temp'), month_date: first('date') })
]),
mutate({
'month_date': (d) => new Date(d.month_date),
'city': "New York City"
}),
select(['-month'])
)
tidy_seattle = tidy(
seattle,
mutate({
'month': (d) => new Date(d.date).toLocaleString('default', { month: 'long' }),
'actual_mean_temp': (d) => Number(d.actual_mean_temp)
}),
groupBy('month', [
summarize({ mean_temp: mean('actual_mean_temp'), month_date: first('date') })
]),
mutate({
'month_date': (d) => new Date(d.month_date),
'city': "Seattle"
}),
select(['-month'])
)
tidy_data = tidy_phoenix.concat(tidy_chicago).concat(tidy_houston).concat(tidy_nyc).concat(tidy_seattle)
Inputs.table(tidy_data)
phoenix_chicago = tidy_phoenix.concat(tidy_chicago)
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.
