Skip to main content
100%

loading_data_NH_2_solar_data_data_transformation

✓ Published0🌍 Public
NNavak94
Last edited Jan 31, 2023
Created on Jan 30, 2023

This example loads a CSV of daily solar power generation data from Bloomington Parks & Rec and transforms it for analysis. The visualization initially displays the parsed data as JSON text in a `<pre>` element, showing categorical fields like address and department alongside quantitative metrics like watt_hours and latitude. It uses d3.csvParse to load the dataset, then coerces numeric columns with the unary plus operator. A d3.flatRollup operation groups records by address and counts observations, logging an array of `{address, count}` objects to the console. The code demonstrates data loading, type conversion, and aggregation before any visual rendering occurs.

AI-generated description

address, site, and department are categorical data site_id,date,watt_min,watt_max,watt_avg,watt_hours,watt_hours_expected,latitude, and longitude are quantitative data

Solar data for power generation collected from a few sources, namely an array of solar panels at Bloomington Parks & Rec

how do certain areas compare for solar power generation?

https://www.kaggle.com/datasets/mattop/daily-solar-power-generation?resource=download

MIT Licensed

Similar vizzes