The original data source had identical data for 2009 and 2012. This lead to doubling counts for 2012 and left us missing most 2009 data. This has been fixed by dropping duplicate rows before performing counts. I contacted the source data manager to inform them of the error and see if we could get more 2009 data.
ehbick01 called out in commit #42 that Louisville merged with Jefferson county in 2003. The source data included a field for city that allowed me to filter all non-Louisville data points. I believe that addresses that issue.
Fixed an issue with pulling wrong field for crime dates. Previous, report date was being used instead of the actual incident date.
The original data source had identical data for 2009 and 2012. This lead to doubling counts for 2012 and left us missing most 2009 data. This has been fixed by dropping duplicate rows before performing counts. I contacted the source data manager to inform them of the error and see if we could get more 2009 data.
ehbick01 called out in commit #42 that Louisville merged with Jefferson county in 2003. The source data included a field for city that allowed me to filter all non-Louisville data points. I believe that addresses that issue.
Fixed an issue with pulling wrong field for crime dates. Previous, report date was being used instead of the actual incident date.