pythonは高徳地図apiを用いて一括クエリーアドレス緯度を実現する

初心者の試み

import requests
import pandas as pd
import csv
data = pd.read_csv('  .csv',engine='python')#     csv  
data = data['  ']#     
lis = []
def gaode():
    for i in data:
        para = {
            'key':'  key',
            'address':i,
            'city':'       '
        }
        url = 'https://restapi.amap.com/v3/geocode/geo?'
        req = requests.get(url,para)
        req = req.json()
        if req['infocode']=='10000':
            w = req['geocodes'][0]['formatted_address']
            z = req['geocodes'][0]['location']
            print(w)
            print(z)
            d = (w, z)
        else:
            print('    ')
        lis.append(d)

    t = ['  ','   ']
    with open('      .csv', 'w', newline='')as f:
        writer = csv.writer(f)
        writer.writerow(t)
        writer.writerows(lis)
if __name__ == '__main__':
    gaode()