Calculate percentages and add to the data

Datafable / rolling-blackout-belgium

Rolling blackout plan in Belgium

http://datafable.github.io/rolling-blackout-belgium/viz/

Other

18 stars 12 forks source link

Calculate percentages and add to the data #13

Closed peterdesmet closed 9 years ago

peterdesmet commented 9 years ago

I need the following in the aggregated data:

all_sections: sum of all sections
section_1_pct: percentage of round(section_1/total*100,2)
section_2_pct
section_3_pct
section_4_pct
section_5_pct
section_6_pct
all_sections_pct
excluded_pct

Not sure where we best do this:

In the SQL, to keep our data clean.
In the Python script.

peterdesmet commented 9 years ago

Did it with SQL: https://github.com/Datafable/rolling-blackout-belgium/blob/master/data/combined/README.md