SHIRSENDU-KONER/Customer-Service-Request-Analysis ? reverse-engineered prompt

Reverse engineered prompt

Build me a Jupyter notebook that analyzes NYC 311 customer service requests from the dataset in this repo.

I want it to load the data, clean it up, convert the Created Date and Closed Date fields into real dates, and create a Request Closing Time column that shows how long each request took to get resolved. Then explore the data and show the most important complaint patterns in charts and tables, with at least four clear takeaways.

Please also rank the complaint types by average closing time, and break that down by location where it makes sense. I need the notebook to include the basic statistical testing too, with the null and alternative hypotheses written out clearly and the p values shown, for these questions, whether response times are similar across complaint types, and whether complaint type and location are related.

Keep it beginner friendly, with clean code, clear comments, and simple explanations of what the results mean. If you need to check current library docs online, go ahead.