Python -如何从Smartsheets直接创建熊猫数据帧？

import pandas as pd
import requests

sheet_id = "YOUR_SHEET_ID"
api_token = "YOUR_API_TOKEN"

url = f"https://api.smartsheet.com/2.0/sheets/{sheet_id}"
headers = {
    "Authorization": f"Bearer {api_token}",
    "Content-Type": "application/json"
}

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

rows = data["rows"]
columns = data["columns"]

df = pd.DataFrame(columns=[column["title"] for column in columns])

for row in rows:
    values = [cell["value"] for cell in row["cells"]]
    df = df.append(pd.Series(values, index=df.columns), ignore_index=True)