dee

Memo

To:

From:

Date:

Subject: Analysis of Fort Worth Code Violations Dataset

I reviewed and analyzed the dataset which contained 230,708 code violation records from Fort Worth, Texas. It included information such as complaint type, case status, code officer, address, and case creation date. Before conducting the analysis, I looked at the structure of the data, checked for missing values, and created new variables for case year and case month to support the analysis.

The most common complaint type in the dataset was Property Maintenance. It had 74,414 recorded violations. This was followed by Solid Waste Violation (47,559), High Grass/Weeds (27,885), Vehicle (19,651), and Zoning (18,259). The large number of Property Maintenance complaints suggest that issues relating to upkeep of property are a major concern within the city.

The analysis also showed that most violations had been resolved. Out of 230,708 records, 225,759 were listed as closed, while only 4,949 remained open. What this means is that approximately 98 percent of violations in the dataset were closed. It may be an indication that the code enforcement department is generally effective at processing and resolving reported issues.

When examining workload by officer, officer Era, New appeared most frequently in the dataset with 12,152 recorded violations, followed by Dooley, Shelby with 9,400 and Payne, Jeff with 7,170. This suggests that some officers may handle a larger share of violations than others.

Reviewing violation activity by year showed that 2016 had the highest number of recorded violations, with 53,979 records. The number of violations reduced gradually after 2016. The low count for 2020 is likely because the dataset only contains part of that year. It may also be noteworthy to consider it in terms of the effects of the Covid-19 pandemic.

The PivotTable and chart for this highlights the distribution of complaint types. It clearly shows that Property Maintenance complaints occur more often than any other category. This pattern stands out as the most important finding from the analysis.

Based on these findings, since property maintenance issues represent the largest share of code violations, a practical recommendation would be for managers to continue focusing resources on property maintenance issues. Addressing these issues proactively may help reduce future complaints and improve the conditions of the neighborhood.