search

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

apd-crime-data.R `bind_rows()` broken #3

Open rfgordonjr opened 3 years ago

rfgordonjr commented 3 years ago 
> bind_rows(crime_data)
Error: Can't combine `..1$beat` <integer> and `..2$beat` <character>.

crime_data is now a list of 4 data frames with different names and columns, which breaks bind_rows:

>   lapply(X = crime_data,FUN = names)
[[1]]
 [1] "offense_id"    "rpt_date"      "occur_date"    "occur_day"     "occur_day_num"
 [6] "occur_time"    "poss_date"     "poss_time"     "beat"          "zone"         
[11] "location"      "ibr_code"      "UC2_Literal"   "neighborhood"  "npu"          
[16] "lat"           "long"         

[[2]]
 [1] "offense_id"        "rpt_date"          "occur_date"        "occur_time"       
 [5] "poss_date"         "poss_time"         "beat"              "apt_office_prefix"
 [9] "apt_office_num"    "location"          "MinOfucr"          "dispo_code"       
[13] "Shift"             "loc_type"          "UC2_Literal"       "ibr_code"         
[17] "neighborhood"      "npu"               "long"              "lat"              

[[3]]
 [1] "offense_id"              "rpt_date"                "occur_date"             
 [4] "occur_time"              "poss_date"               "poss_time"              
 [7] "beat"                    "apartment_office_prefix" "apartment_number"       
[10] "location"                "watch"                   "location_type"          
[13] "UC2_Literal"             "UCR_Number"              "neighborhood"           
[16] "npu"                     "lat"                     "long"                   

[[4]]
 [1] "Report.Number"           "Report.Date"             "Occur.Date"             
 [4] "Occur.Time"              "Possible.Date"           "Possible.Time"          
 [7] "Beat"                    "Apartment.Office.Prefix" "Apartment.Number"       
[10] "Location"                "Shift.Occurence"         "Location.Type"          
[13] "UCR.Literal"             "UCR.."                   "IBR.Code"               
[16] "Neighborhood"            "NPU"                     "Latitude"               
[19] "Longitude"