循环两个Pandas数据帧，并应用计算给定城市距离内机场的函数

import pandas as pd
from geopy.distance import geodesic

city_df = pd.DataFrame({'City': ['City A', 'City B', 'City C'],
                       'Latitude': [40.7128, 34.0522, 51.5074],
                       'Longitude': [-74.0060, -118.2437, -0.1278]})

airport_df = pd.DataFrame({'Airport': ['Airport X', 'Airport Y', 'Airport Z'],
                          'Latitude': [40.6413, 34.0522, 51.4700],
                          'Longitude': [-73.7781, -118.2437, -0.4543]})

def calculate_distance(city_lat, city_lon, airport_lat, airport_lon):
    city_coords = (city_lat, city_lon)
    airport_coords = (airport_lat, airport_lon)
    distance = geodesic(city_coords, airport_coords).miles
    return distance

for _, city_row in city_df.iterrows():
    city = city_row['City']
    city_lat = city_row['Latitude']
    city_lon = city_row['Longitude']
    
    for _, airport_row in airport_df.iterrows():
        airport = airport_row['Airport']
        airport_lat = airport_row['Latitude']
        airport_lon = airport_row['Longitude']
        
        distance = calculate_distance(city_lat, city_lon, airport_lat, airport_lon)
        
        if distance <= 50:  # 假设距离小于等于50英里为给定城市距离内的机场
            print(f"The airport {airport} is within 50 miles of {city}.")