search

jacobkap / nibrsbook

0 stars 0 forks source link

issue with arrestee sequence numbers #11

Open lddumouc opened 2 years ago

lddumouc commented 2 years ago

Hi Dr. Kaplan,

I was having trouble with duplicates as well, so I followed your advice: dropped the incident date and year, then drop the duplicates. However, that didn't completely resolve the problem. It appears to me that there is an error with the arrestee sequence numbers. I'm having issues with duplicates because the arrestee sequence number is not consistently associated with the unique_incident_number (as I think it should be). I'm working with just data from Colorado. it appears that when two + people are involved in the same incident, but arrested on different days, the arrestee sequence number starts over again, at least for 256 observations. so I'm thinking I have to re-number those arrestee sequence numbers where there is 1 unique id, and two arrestees with the same sequence number. thought?

jacobkap commented 8 months ago

Hi, can you please make a reproducible example or at least be specific on which years/files you are using.