批量检索格式化地址和几何图形（lat/long）并输出到cs

Question

我有一个csv文件，有两个字段：store_name和city。一个城市可以有多家商店。
我想要一个带有6个字段的输出csv，store_name，city，listed_name，address，latitude，longitude

例如，如果csv的一个条目是Starbucks, Chicago，我希望输出csv包含5个字段（如上所述）中的所有信息：
Starbucks, Chicago, Starbucks, "200 S Michigan Ave, Chicago, IL 60604, USA", 41.8164613, -87.8127855，
Starbucks, Chicago, Starbucks, "8 N Michigan Ave, Chicago, IL 60602, USA", 41.8164613, -87.8127855
其他结果也是如此

这是我写的。请引导和纠正

import pandas as pd
import googlemaps
# import pprint as pp
import time

API_KEY = 'your_api_key_here'

# Define client
gmaps = googlemaps.Client(key=API_KEY)

# Make dataframe
df = pd.read_csv('merchant.csv', usecols=[0, 1])

# Construct search query
search_query = df.Merchant_Name + " " + df.City

for search in search_query:
    # filename = search + ".csv"
    # f = open(filename, "w")

    search_result = gmaps.places(query=search)
    '''
    size_of_json = len(results)
    for i in range(size_of_json):
        row = [
            ["results"][i]["formatted_address"], 
            ["results"][i]["geometry"]["location"]["lat"], 
            ["results"][i]["geometry"]["location"]["lng"],
            ["results"][i]["name"]
        ]
        address = row[0]
        latitude = row[1]
        longitude = row[2]
        name = row[3]

        f.write(df.Merchant_Name + "," + df.City + "," + name + "," + address + "," + latitude + "," + longitude + "\n")

    f.close()
    time.sleep(2)
    '''
    # search_result = gmaps.places(page_token=search_result['next_page_token'])