apd-crime-data.R expects excel, but APD seems to have switched to csv.

CivicTechAtlanta / apd-crime-data

Working with publicly available data on Atlanta Police Department's "Crime Data Downloads" site at http://www.atlantapd.org/crimedatadownloads.aspx

19 stars 3 forks source link

Open rfgordonjr opened 3 years ago

rfgordonjr commented 3 years ago

get_crime_zipfile expects excel files.

Fix by replacing

print(excel_sheets(fpath))
read_excel(fpath, sheet = "Query")

with

read.csv(fpath, stringsAsFactors = FALSE)