Data Processing

For my research assistant work under Professor Jin Wang with the Management Science and Information Systems (MSIS) departments at Rutgers, I was requested to clean and transform mortality and population data queried from The Official Site of the State of New Jersey's New Jersey State Health Assessment Data using Python script.

Professor Wang trusted code more than manual work. After working with him, I started to feel the same way.  The code on the left transformed the data. The code below calculated the monthly crude death rates based on the cleaned and wrangled data. The timeseries csv below is the final result and was ultimately used to make a Tableau timeseries plot.