id,city,country ---> id,lat,lon

script.py

# -*- coding: utf-8 -*-

import csv, os, time
from geopy.geocoders import Nominatim

THIS_FOLDER = os.path.dirname(os.path.abspath(__file__))
my_file = os.path.join(THIS_FOLDER, 'data.csv')

geolocator = Nominatim()

with open(my_file, 'r') as csvFile:
    reader = csv.reader(csvFile)
    for row in reader:
		time.sleep(1.5)

		location = ', '.join([row[1], row[2]])
		location = geolocator.geocode(location)
		if location:
			lat,lon = str(location.latitude), str(location.longitude)
		else:
			lat,lon = '', ''
		print(','.join([
				row[0],
		    	lat,
		    	lon
			]))        

csvFile.close()

#print(location.address)