Pittsburgh Police Arrest Data

Carrying forward the questions asked in warm up exercise, of How true is the fact that less developed neighborhoods, black and Asians and secluded areas are the reason behind crime? I further explore by asking questions of age and sex, by zooming into three neighborhood

To answer this question, I have used the same dataset as in the previous warm exercise and combined with the Pittsburgh Neighborhood’s shapefile from WPRDC’S datasets, to get the political boundaries of the neighborhood.

https://data.wprdc.org/dataset/pittsburgh-neighborhoods1

Challenges faced:

The major challenge here was using the SQL and to clear cvs data in carto using SQL and finding median age groups and segregation of data in carto. Also data clearing was also a task, as I started representing the segregation of various neighborhood, I realized the points where not marked properly. Thus I had to clear the dataset again.

Findings: