python调用百度API正向、逆向解析地址

1、输入地址，获取经纬度

#####读取数据
import pandas as pd
data=pd.read_excel('address.xlsx')
data.head(5)

#####创建列表
z_level=[0 for i in range(0,len(data.address))]
z_precise=[0 for i in range(0,len(data.address))]
z_confidence=[0 for i in range(0,len(data.address))]
z_comprehension=[0 for i in range(0,len(data.address))]
z_lat=[0 for i in range(0,len(data.address))]
z_lng=[0 for i in range(0,len(data.address))]

#############调用百度API，循环读取地址
for i in range(0,len(data.address)):
    import requests
    import json
    import pprint
    address1=data.address[i]
    ak = 'm9umAdjKIi7WQdQ54DYR8N3yuIRB5YZ1'#ak需要去百度地图申请 ,不知道为什么，自己申请的总是用不了，这个是自己在网上随便找的的ak
    url = 'http://api.map.baidu.com/geocoder/v2/?address={}&output=json&ak={}'.format(address1,ak)
    res = requests.get(url