# Find latitude and longitude of a list of cities in a csv file
# https://www.globalsino.com/ICs/


from geopy.geocoders import Nominatim
import pandas as pd


filename = r"C:\0Python\Michel\TestingCity.csv"

# Read Pandas csv file with no header
df = pd.read_csv(filename, header=None)

for i in range(3, (len(df)- 1)):
    City_i = df.values[i][1]

    try:
        df.loc[i, 2]
    except ValueError:
        df.isnull().loc[i, 2] != True
    if df.loc[i, 2]:
        # Initialize Nominatim API
        geolocator = Nominatim(user_agent="MyApp")
        location = geolocator.geocode(City_i)
        df.loc[i, 2] = location.latitude
        df.loc[i, 3] = location.longitude
        print(df.loc[i, 2])
    df.to_csv(filename, header=False, index=False)