Clean up csv data and add date and age columns

[joehooper]

I cleaned up the output.csv file, adding names for all columns and removing the first two rows which seemed misaligned. Then I added three new columns using Pandas:

• Four-digit year of entry
• Age at hearing
• Age at hearing binned by decade (i.e. parolee was in 20s, 30s, etc at time of hearing)

The transforms used to create these columns are documented in Add date and age cols.ipynb - it also includes basic plots.

[rcackerman]

Thanks!

To clarify - did you remove 2 rows of data?

[joehooper]

Yes, I removed the first two rows because there were items that seemed clearly misaligned - such as a date where the rest of the data had a county. etc.

[nikzei]

@joehooper so awesome that you did this. @rcackerman let's merge this, no?