Chicago Crimes Analysis

Need help with this question or any other Data Science homework assignment task or project?

Ask A Question

Chicago Crimes Analysis

Viewed 26

I have an assignment with the following objectives that use SQL, Python, Folium, Choropleth:

  • Use SQL to execute different queries to retrieve data from the Chicago Crime data set and Police Stations data set.
  • Use Geospatial queries to locate police stations and gun-related crimes (with arrests or no arrests) in every district on a Choropleth map.
  • Use Geospatial queries to provide descriptive stats for every district on a Choropleth map.
  • Use Geospatial queries to locate the block that is the furthest (Maximum Distance) from the police station that has gun-related crimes that resulted in an arrest.

The pdf won't upload but basically it uses cursor.execute, folium, choropleth, area, pandas, sql to accomplish the tasks.

This is due midnight CST tomorrow so I would greatly appreciate a tutor who can help!

This order does not have tags, yet.

Additional Instructions

No uploads for this question



No answers posted

Post your Answer - free or at a fee

Login to your account tutor account to post an answer

Posting a free answer earns you +20 points.


To get help with a similar task to Chicago Crimes Analysis, Ask for Data Science Assignment Help online.