Liz Gewirtz

I didn't mean to open this pull request as a way to close the entire issue - just to add analysis to backup the hypothesis that work crews were seeing...

9/28/2022 Decided to look at crime and call data from 2019 since the year is before lockdown and it's a good starting point to compare to. - Filtered date for...

Anupriya figured out that the memory error is occurring because, when merging on the Crime Data_column "AREA NAME' and the 311 Calls column "PolicePrecinct", the 'AREA NAME' values are repeating...

[Merged 2019 LA Call data with Neighborhood Council Shape file](https://github.com/lgewirtz/crime_311/blob/main/Merge_LA_Call_Data_w_NC_geometry.ipynb)

[Tried to spatially join Crime data with LA CALL/Neighborhood Council Shape data ](https://github.com/lgewirtz/crime_311/blob/main/Merge_Call_NCGeom_w_Crime.ipynb)

@joshuayhwu thanks for looking at my notebooks. _> Also, would you mind elaborating on why you want to merge the two datasets?_ I want to merge the 311 Service Requests...

@joshuayhwu As suggested, I've used groupby and dummy variables on the ServiceRequest and Crime datasets for 2019. I used the following code: dummydf= pd.get_dummies(df, columns=['dumVar1', 'dumVar2']).groupby(['mergeCol1', 'mergeCol2'], as_index=False).sum() Then I...

@joshuayhwu Updated [Service Request notebook - Dummy_SR_2019](https://github.com/lgewirtz/crime_311/blob/main/Dummy_SR_2019.ipynb) - so that NC_ID and zipcodes are not dummified. Then re-merged with Crime dataset in [Merge_SR_CR_Grpd_Dummy notebook](https://github.com/lgewirtz/crime_311/blob/main/Merge_SR_CR_Grpd_Dummy.ipynb)

I didn't mean to open this pull request as a way to close the entire issue - just to add analysis to backup the hypothesis that work crews were seeing...

@mc759 , @joshuayhwu Using Service Request and Crime Data from 2019, I found no correlation between the sum of the incidents in the neighborhood councils and 2 types of crime...