Case Study: NYC 311 Data Analysis (Python)
1. Project Overview
Type: Data cleaning and analysis
Technologies: Python, Pandas, NumPy (optionally Matplotlib)
Purpose: Clean NYC 311 service request data and analyze request closing times.
2. Methodology
- Load CSV data and inspect schema
- Handle missing values; normalize categorical fields
- Convert date columns and compute time deltas
- Summarize by agency, complaint type, and borough
3. Tasks & Outputs
| Task | Output |
|---|---|
| Data Cleaning | Null handling and type conversions |
| Feature Engineering | Closing time metrics |
| Aggregation | Top complaint types and response times |
| Export | CSV summaries and optional plots |
4. Preview
5. Outcome
- Reproducible cleaning pipeline
- Insights into closure times across categories