Geocoding-Locations/GeocodingAPI.py at master · abhi7991/Geocoding-Locations · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
# -*- coding: utf-8 -*-
"""
Created on Wed Dec 11 11:28:41 2019

@author: Abhishek.S
"""

# -*- coding: utf-8 -*-
"""
Created on Tue Dec 10 18:31:40 2019

@author: Abhishek.S
"""
import os
os.chdir(r"C:\Users\Abhishek.S\Anaconda3\Lib\site-packages\tabpy_server")
import pandas as pd
import time as t
import json
from sklearn.cluster import KMeans
import numpy as np
import sys
os.chdir(r"C:\Users\Abhishek.S\Anaconda3\Lib\site-packages\tabpy_server")
import pandas as pd
import random
import requests
from datetime import datetime as dt
import time as t
import json
from sklearn.cluster import KMeans
import numpy as np
import re
import subprocess
import errno
from multiprocessing import Pool

input = pd.read_csv("latlong.csv")
input = input.get("address")
req = input.values.tolist()
#%%

def getGeocode(location):
  key = "AIzaSyAVv5ZvaIZ1S4od-VMPmQHc-1kgtL01bOM"
  post="https://maps.googleapis.com/maps/api/geocode/json?address="
  url =post+str(location)+"&key="+key
  latlong =[]
  r = requests.get(url = url)
  d = r.json()
  a = d["results"][0]['geometry']["location"]['lat']
  b = d["results"][0]['geometry']["location"]['lng']
  latlong.append(a)
  latlong.append(b)
#  print(a)
#  print(b)
  return latlong

lat_long= []
for i in range(len(req)):
    print(str(i)+'start')
    b = getGeocode(req[i])
    print(str(i)+'done')
    lat_long.append(b)
#    pd.DataFrame(c)
print(lat_long)
#%%
d = pd.DataFrame(lat_long)
e = pd.DataFrame(input)
d['address'] = e
d.columns = ['Latitude', 'Longitude', 'Address']
d.to_csv('output.csv',index = False, encoding = 'utf-8')