Feature request: L&I violations aggregated by owner

[nlebovits]

We can aggregate the number of annual L&I violations per property owner per year based on the standardized_address column in negligent_devs.py. Update that script to retain the column, then use it in the l_and_i.py script to aggregate the total number of violations (both open and closed) per standardized_address in the past year. (This is a simple group by.) Create a column for the raw count of these per standardized_address, another column for the average number of violations per property per standardized_address, and then also a column for the z-scored value of this average (i.e., how the average number of violations for that developer compares to the average of the average number of violations per developer across all developers in our database).

[HeyZoos]

Hello! I'd like to take a crack at this

[nlebovits]

Assigned! Thanks for working on it :)

[nlebovits]

@HeyZoos if you want to take this on now, take a crack at it! work in new_etl, following the instructions in #1014

[github-actions[bot]]

This issue has been marked as stale because it has been open for 30 days with no activity.