在pandas数据帧上使用循环进行Foursquare调用

import pandas as pd
import requests

results = []

for index, row in df.iterrows():
    lat = row['latitude']
    lng = row['longitude']
    radius = 1000  # 设置搜索半径
    url = f'https://api.foursquare.com/v2/venues/search?ll={lat},{lng}&radius={radius}&client_id=YOUR_CLIENT_ID&client_secret=YOUR_CLIENT_SECRET&v=20220101'

response = requests.get(url)
data = response.json()

venues = data['response']['venues']
for venue in venues:
    name = venue['name']
    category = venue['categories'][0]['name']
    address = venue['location']['address']
    results.append({'name': name, 'category': category, 'address': address})

results_df = pd.DataFrame(results)