使用Python Gspread库创建工作表时如何添加列名？

Got it, let's sort out that missing column header issue you're facing! The root problem here is that your current code only appends the dataframe's raw values, without including the column names as the first row. Here's how to adjust your code to add headers alongside your data seamlessly:

Modified Code Solution #

# 创建新工作表：注意行数要+1，预留表头行
sheets.add_worksheet(title=sheetName, rows=df.shape[0] + 1, cols=df.shape[1])

# 准备包含列名的完整数据列表
column_headers = df.columns.tolist()
full_data = [column_headers] + df.values.tolist()

# 追加包含表头的全部数据
sheets.values_append(sheetName, {'valueInputOption': 'USER_ENTERED'}, {'values': full_data})

Key Changes Explained #

• Adjusted Worksheet Rows: We added +1 to the rows parameter when creating the worksheet. This ensures we have enough rows to fit both the header and all your data rows (some APIs might auto-expand rows, but setting this explicitly avoids potential issues).
• Included Column Headers: We converted the dataframe's column names to a list (df.columns.tolist()) and added it as the first entry in our data list. When we pass this combined list to values_append, the headers will be written as the first row of the new worksheet, followed by your data.

Alternative: Separate Header and Data Writes #

If you prefer to write headers and data in separate steps for clearer code structure, you can do this:

# 创建新工作表
sheets.add_worksheet(title=sheetName, rows=df.shape[0] + 1, cols=df.shape[1])

# 先写入列名
sheets.values_append(sheetName, {'valueInputOption': 'USER_ENTERED'}, {'values': [df.columns.tolist()]})

# 再写入数据
values = df.values.tolist()
sheets.values_append(sheetName, {'valueInputOption': 'USER_ENTERED'}, {'values': values})

Either approach will get your column headers showing up in the new worksheet right alongside your data.

内容的提问来源于stack exchange，提问作者Subham