I had JSON files which I cleaned and exported as csv files to be used in Tableau. The files have Longitude and Latitude fields, but I want to group them in Tableau by cities. How can I do so whether directly in Tableau or using Python?
CodePudding user response:
Use geopy!!
https://geopy.readthedocs.io/en/stable/#module-geopy.geocoders
from geopy.geocoders import Nominatim
geolocator = Nominatim(user_agent="specify_your_app_name_here")
location = geolocator.reverse("52.509669, 13.376294")
print(location.address)
Potsdamer Platz, Mitte, Berlin, 10117, Deutschland, European Union
print((location.latitude, location.longitude))
(52.5094982, 13.3765983)
print(location.raw)
{'place_id': '654513', 'osm_type': 'node', ...}