The avatar for @pstuffa
Paul Buffa
data visualization developer, runner, musician
Public
Edited
Mar 9, 2023
Fork of Calculating the ROI of a Home Solar Installation
1
Insert cell
Insert cell
Insert cell
Insert cell
electric = FileAttachment("electric-usage-actual.csv").csv()
Insert cell
Inputs.table(electric)
Insert cell
Insert cell
d3.rollup(electric, v => d3.sum(v, d => d.Usage), d => d["Day of the week"])
Insert cell
Insert cell
d3.sum(electric, d => d.Usage)
Insert cell
Insert cell
electric
SELECT TimeZone
, count(*)::int as records
, avg(electric."Usage"::int) as avg_usage
FROM electric
GROUP BY 1
Insert cell

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.
Learn more