so for more info what I'm trying to do is I have a spreadsheet of all the crimes that occurred in LA county over a 30 day period with x,y data. I also have a shapefile that has individual polygons for each of the cities in LA county. The crimes spreadsheet contains the city names as well. I wanted to sort of join or relate the crimes data to the polygons to do some analysis such as which cities are drug crimes more prevalent, what city is most likely to get your car stolen etc. simple stuff since this is only for a class project.
I know how to do the analysis I just am racking my brain trying to figure out a way apply like 50-500+ incidents (10k crimes in 1 month for LA county) all with the same city name to a single polygon with the same name so then I can run analysis on the polygons