Data cleaning & integration · Analysis & modeling
Flight data for research on police helicopter surveillance
Twelve monthly files of about a million rows each, with nested records, turned into one analyzable dataset for an undergraduate researcher.
Kate McInerny first used the Data Science Center in a 2019 African American Studies course that taught GIS and R. By 2022 she was studying how law enforcement helicopter surveillance in Los Angeles is racialized and how its noise affects residents’ sleep. After suing the LAPD for flight data, she had twelve monthly datasets, each with around a million rows.
The records were nested, so Kristian Allen and DataSquad consultant Ethan Allavarpu wrote functions that flattened them and tagged each row with a flight ID. Kate then adapted that base code for her own questions. The Center also set her up on its deep learning machine, which let her combine all twelve months and run the analysis in one pass.
She met with the Center and DataSquad consultants more than thirty times in 2022. A later round of work on her code, which pulled data from an API, improved its efficiency by over 800%, so she spent less time waiting and more time interpreting results.
Her advice to other student researchers is to start with the Data Science Center and keep asking until the logic of each step is clear. Her research was covered by the LA Times.
- Years
- 2022–2024
- Partner
- UCLA undergraduate research on police helicopter surveillance
- Team
- Ethan Allavarpu, Kristian Allen
- Source
- Originally published ↗