The objective of this project is to identify and investigate bad actors who undermine the apartment inspection process. The purpose of NYCHA apartment inspections is to identify and address maintenance and repair issues. This includes identifying problems such as leaks, structural issues, electrical problems, and other issues that may affect the safety and habitability of the apartments. By rooting out bad actors and identifying repair issues early, NYCHA can take steps to ensure that residents have safe and well-maintained living spaces.
Labor transaction data, such as time to complete an inspection, the proportion of components in the unit that receive a satisfactory rating and access to the unit are used as measures to determine whether the inspection was completed properly.
- A direct connect to the NYCHA database to pull the data was established.
- Data is cleaned, merged and quality checked in Python.
- Visualizations were created in Tableau to explore patterns in bad behavior.
- A bad actor list is created using key performance measures.
The average inspection time is 39 minutes, during that time the inspector must answer 142 questions about the condition of apartment using a handheld device. The average satisfactory rate for an apartment that is inspected is 93%. The Bad Actor list includes inspectors with a low average inspection time and high satisfactory rates.
A bad actor is defined as having an average inspection time of 20 minutes or less and a satisfactory rate of 97 percent or higher.
A visualization of the daily work was also produced. For this inspector, the daily average number of minutes per inspection is far lower than the average of 39 minutes:
A visualization was also created to drill down into the daily activity of the inspectors.
