I am completing an exploratory data analysis project for college and I am a complete beginner when it comes to python.
I have a dataset related to crime data, in which I have the area name where various crimes took place, as well as the latitude and longitude of each crime location.
The crimes listed in the dataset were committed across different specific locations in the same general area. I would like to achieve two things with pandas:
- Be able to display the values of the latitude and longitude columns when the area column has a specific value i.e. all of the lat and long values for crimes that took place in the Kingston area of London, for example. and do that for the top 10 areas for which I have already identified the highest crime occurrences.
- Once I have separated all the lat and long for each of the 10 areas, I would like to find the mean lat/long for each area
I then wish to plot these values on Folium and create an interactive map (I have figured out how to use Folium, I just need advice on the parts above).
I have looked at different pandas libraries but I haven’t found what I am looking for
Linda C is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1