Duplicates in Crime Inceident Data

21 views
Skip to first unread message

Pete Leasure

unread,
Apr 3, 2023, 9:15:46 AM4/3/23
to Open Data Philly
Hello,

I am looking for the best way to identify duplicates in the crime incident data. dc_key seemed promising, but it is unique for all observations in the subset of data I am examining (DUIs). And a sort of observations on dispatch_date_time and location_block shows a large number of potential duplicates. 

Any thoughts?

Delete duplicates that have the same dispatch_date_time and location_block?

Best,

Pete 
Reply all
Reply to author
Forward
0 new messages