Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your company is a non-profit whose purpose is to advocate for equity in handling and providing long term solutions to city maintenance problems (trash collection,

Your company is a non-profit whose purpose is to advocate for equity in handling and providing long term solutions to city maintenance problems (trash collection, potholes, etc.) in Kansas City, MO. The goal of this assignment is to identify the areas with a higher number and density of such requests, understand what types of requests are the most common for those areas, and analyze the degree of equity in the way the city addresses the issues in neighborhoods with respect to their socio-economic profiles. To address the latter, your goal is to identify whether the discrepancy in maintenance needs and the time it takes to resolve issues differs between neighborhoods and whether this difference (if observed) is indicative of inequity in city maintenance. Directions Use this public dataset on 311 calls: 311 Call Center Service Requests. Use appropriate tools (e.g. Python, SAS, Tableau, or a combination of those) to conduct the analysis using the dataset. Once you have identified any areas that have clusters of requests of a certain type, align those areas with the socio-economic profiles of those neighborhoods. To do so you can use any publicly available source (e.g. https://datausa.io/profile/geo/kansas-city-mo/) Your analysis may combine the use of data analytics tools with manual analysis. In your report describe the steps you have taken and provide results of your analysis and conclusions on the state of equity in city maintenance. I need python code for this question

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What magazine and ads did you choose to examine?

Answered: 1 week ago