从列名称列表和具有空格的数据创建数据框

发布于 2025-01-26 18:21:59 字数 856 浏览 1 评论 0原文

使用googlefinance（） python上的API，我在附加的快照中读取响应。我想将此回复响应作为数据框架。

使用下面的代码，我从响应中提取列和data。请注意，列以及，data的每一行都有一个空间作为其第一个条目（照片中的绿色箭头标记）。接下来，当我尝试制作一个dataframe df时，我会得到错误assertionError：传递的7列，传递的数据有26列

我认为第一个“空白”数据正在引起一些问题。有什么建议如何克服这一点？

代码：

response = service.spreadsheets().values().get(
        spreadsheetId=spreadsheet_id,
        majorDimension='ROWS',
        range='Sheet1'
    ).execute()
columns = response['values'][1]
data = response['values'][2:]
df = pd.DataFrame(data, columns=columns)

原文

Using GOOGLEFINANCE() API on Python, I readback response shown in attached snapshot. I would like to arrange this readback response as a dataframe.

Using the code below, I extract the columns and data from response. Do notice that columns, as well as, each row of data has a blank space as its first entry (marked with green arrows in the photo).
Next, when I try to make a dataframe df, I get error AssertionError: 7 columns passed, passed data had 26 columns

I think the first 'blank' data is causing some issue. Any suggestion how to overcome this?

Code:

response = service.spreadsheets().values().get(
        spreadsheetId=spreadsheet_id,
        majorDimension='ROWS',
        range='Sheet1'
    ).execute()
columns = response['values'][1]
data = response['values'][2:]
df = pd.DataFrame(data, columns=columns)