search

edgi-govdata-archiving / ECHO-Cross-Program

Jupyter Notebooks for ECHO that use data from multiple EPA programs
https://colab.research.google.com/github/edgi-govdata-archiving/ECHO-Cross-Program/blob/master/ECHO-Cross-Programs.ipynb
GNU General Public License v3.0
8 stars 5 forks source link

Update utilities.py #61

Closed ericnost closed 3 years ago

ericnost commented 4 years ago

Fix #60?

ericnost commented 3 years ago

@Frijol In aggregating the data to make charts (the ones where the x-axis is the year, y-axis is the value), we have to do counting and summing. For most data types (e.g. Clean Air Act violations) I think what we want to do is count the number of records (violations) per date (e.g. there were 2 records/violations reported on 7-27-97) and then sum those by year (e.g. 10 total in 1997) rather than counting the number of unique dates (7-27-97, 8-20-97, etc.) violations that occurred that year.