如何从Google的distance API的json响应中提取值并存储到python dataframe中？

import requests
import pandas as pd
import json

# 假设你已经有了Google Distance Matrix API的URL和你的API密钥
api_url = "https://maps.googleapis.com/maps/api/distancematrix/json"
api_key = "YOUR_API_KEY"

# 设置请求参数
params = {
    "origins": "Seattle,WA",
    "destinations": "San+Francisco,CA",
    "key": api_key
}

# 发送请求并获取响应
response = requests.get(api_url, params=params)
data = response.json()

# 解析JSON响应
try:
    # 提取距离和持续时间
    distances = data['rows'][0]['elements'][0]['distance']['text']
    durations = data['rows'][0]['elements'][0]['duration']['text']
    
    # 创建DataFrame
    df = pd.DataFrame({
        'Origin': ['Seattle,WA'],
        'Destination': ['San Francisco,CA'],
        'Distance': [distances],
        'Duration': [durations]
    })
    
    print(df)
except KeyError as e:
    print(f"KeyError: {e}. The structure of the JSON response might have changed.")
except Exception as e:
    print(f"An error occurred: {e}")