输入 [ ]
已复制！
from llama_index.readers.google import GoogleSheetsReader
from llama_index.readers.google import GoogleSheetsReader
将表格加载为 Pandas 数据帧列表
输入 [ ]
已复制！
list_of_sheets = ["1ZF5iIeLLqROHbHsb1vOeRaLWKIgLU7rDDTSOZaqjpk0"]
sheets = GoogleSheetsReader()
dataframes = sheets.load_data_in_pandas(list_of_sheets)
list_of_sheets = ["1ZF5iIeLLqROHbHsb1vOeRaLWKIgLU7rDDTSOZaqjpk0"] sheets = GoogleSheetsReader() dataframes = sheets.load_data_in_pandas(list_of_sheets)
输入 [ ]
已复制！
dataframes[0]
dataframes[0]
输出 [ ]
| spotify_id | 名称 | 艺术家 | 每日排名 | 每日变化 | 每周变化 | 国家 | 快照日期 | 流行度 | 是否露骨 | ... | 键 | 响度 | 模式 | 言语度 | 原声度 | 器乐度 | 现场感 | 情绪度 | 速度 | 拍号 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2HafqoJbgXdtjwCOvNEF14 | Si No Estás | iñigo quintero | 1 | 0 | 3 | 2023-10-27 | 97 | FALSE | ... | 5 | -8.72 | 1 | 0.0285 | 0.827 | 0 | 0.138 | 0.524 | 98.224 | 4 | |
| 1 | 7x9aauaA9cu6tyfpHnqDLo | Seven (feat. Latto) (Explicit Ver.) | Jung Kook, Latto | 2 | 4 | 0 | 2023-10-27 | 97 | TRUE | ... | 11 | -4.107 | 1 | 0.0434 | 0.311 | 0 | 0.0815 | 0.89 | 124.997 | 4 | |
| 2 | 3rUGC1vUpkDG9CZFHMur1t | greedy | Tate McRae | 3 | -1 | 2 | 2023-10-27 | 99 | TRUE | ... | 6 | -3.18 | 0 | 0.0319 | 0.256 | 0 | 0.114 | 0.844 | 111.018 | 1 | |
| 3 | 4MjDJD8cW7iVeWInc2Bdyj | MONACO | Bad Bunny | 4 | -1 | -3 | 2023-10-27 | 96 | TRUE | ... | 4 | -5.009 | 0 | 0.068 | 0.15 | 0.000402 | 0.58 | 0.13 | 139.056 | 4 | |
| 4 | 7iQXYTyuG13aoeHxGG28Nh | PERRO NEGRO | Bad Bunny, Feid | 5 | 0 | 1 | 2023-10-27 | 94 | TRUE | ... | 5 | -2.248 | 1 | 0.262 | 0.0887 | 2.16E-05 | 0.179 | 0.345 | 96.057 | 4 | |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 36395 | 0AYt6NMyyLd0rLuvr0UkMH | Slime You Out (feat. SZA) | Drake, SZA | 46 | 4 | 0 | AE | 2023-10-18 | 84 | TRUE | ... | 5 | -9.243 | 0 | 0.0502 | 0.508 | 0 | 0.259 | 0.105 | 88.88 | 3 |
| 36396 | 2Gk6fi0dqt91NKvlzGsmm7 | SAY MY GRACE (feat. Travis Scott) | Offset, Travis Scott | 47 | 3 | 0 | AE | 2023-10-18 | 80 | TRUE | ... | 10 | -5.06 | 1 | 0.0452 | 0.0585 | 0 | 0.132 | 0.476 | 121.879 | 4 |
| 36397 | 26b3oVLrRUaaybJulow9kz | People | Libianca | 48 | 2 | 0 | AE | 2023-10-18 | 88 | FALSE | ... | 10 | -7.621 | 0 | 0.0678 | 0.551 | 1.31E-05 | 0.102 | 0.693 | 124.357 | 5 |
| 36398 | 5ydjxBSUIDn26MFzU3asP4 | Rainy Days | V | 49 | 1 | 0 | AE | 2023-10-18 | 88 | FALSE | ... | 9 | -8.016 | 0 | 0.0875 | 0.739 | 0 | 0.148 | 0.282 | 74.828 | 4 |
| 36399 | 59NraMJsLaMCVtwXTSia8i | Prada | cassö, RAYE, D-Block Europe | 50 | 0 | 0 | AE | 2023-10-18 | 94 | TRUE | ... | 8 | -5.804 | 1 | 0.0375 | 0.001 | 1.79E-06 | 0.113 | 0.422 | 141.904 | 4 |
36400 行 × 25 列
或者将表格加载为文档对象列表
输入 [ ]
已复制！
documents = sheets.load_data(list_of_sheets)
documents = sheets.load_data(list_of_sheets)
