Data cleaning and analysis of NYC's Algorithmic tool compliance reporting.
In 2022, the NYC City Council Passed Local Law 22, requiring city agencies that use AI to annually report select information on their algorithm usage and data.
Algorithmic Tools Compliance Report: https://data.cityofnewyork.us/City-Government/Algorithmic-Tools-Compliance-Report/jaw4-yuem/about_data
The dataset reports on 76 algorithms currently in use with NYC agencies. Each row represents one tool.
The dataset contains 18 columns, 17 columns are object dtypes and one (year) is an integer.

Within the 17 object columns, 10 contain descriptive information. The column "vendor" describes the partnerships (public, private, and third sector) that designed the algorithm rather than a list of collaborators. The "population_type" column, which describes which types of data power the algorithm, has a list with 8 different values.
The dataset contains many Na values across every column.
-
NA values weren't dropped from the dataset. Removing them would result in no available data. Moreover, for regulatory compliance and government accountability, it's essential to know which agencies are not fully reporting their algorithmic useage.
-
Convert date_use column to to_period.
-
Replace Na columns in identifying_info and updated columns to "Not Reported".
-
For non-Na values, the column analysis_type and population_type contains a dictionary of types of algorithmic analysis and data types used for each tool. Seven distinct analysis types were identified, and some tools employed multiple types. Thus, the column was split into seven columns with responses of "yes," "no," or "not reported." In cases where the analysis type was reported, each column indicates "yes" or "no." However, for tools that didn't report an analysis type, the columns are labeled "not reported."
The DOHMH by far uses the most algorithms of any NYC agency.
40% of the algorithms did not report their data usage or algorithm type.
The most common type of algorithm used by the city is predictive modeling.
Most city algorithms are using individual data.
There is still a lot to unpack in this dataset. I've begun an NLP analysis using NLTK and genism to separate vendor names and gain more information from the descriptive columns, stay tuned.




