手把手教你用Python+可视化工具制作漂亮地图

1df = pd.read_excel('cc.xls',index=False)
2df.head()

 1def gaode(addr):
 2        para = {
 3            'key':'你的',
 4            'address':addr
 5        }
 6        url = 'https://restapi.amap.com/v3/geocode/geo?'
 7        req = requests.get(url,para)
 8        req = req.json()
 9        print('-' * 30)
10        if req['status']=='1':
11            if len(req['geocodes']) > 0:
12                m = req['geocodes'][0]['location']
13                print(m)
14            else:
15                print("None")
16                m = ""
17        else:
18            print("None")
19
20        return m
21gaode(addr="广州")

1df["lat"] = df["lat_lon"].str.split(',',expand=True)[1] 
2df["lon"] = df["lat_lon"].str.split(',',expand=True)[0] 
3df = df.drop('lat_lon',axis=1)
4df.to_csv('cc.csv',index=False)