如何从pandas数据框中的特定列编写多个excel工作表？

import pandas as pd

# 读取数据框
df = pd.read_csv('data.csv')

# 创建Excel写入器对象
writer = pd.ExcelWriter('output.xlsx', engine='xlsxwriter')

# 按照特定列进行分组
groups = df.groupby('column_name')

# 遍历每个分组并写入工作表
for name, group in groups:
    group.to_excel(writer, sheet_name=name, index=False)

# 保存并关闭写入器对象
writer.save()

import pandas as pd

# 读取数据框
df = pd.read_csv('data.csv')

# 创建Excel写入器对象
writer = pd.ExcelWriter('output.xlsx', engine='xlsxwriter')

# 按照特定列进行分组
groups = df.groupby('column_name')

# 遍历每个分组并写入工作表
for name, group in groups:
    group.to_excel(writer, sheet_name=name, index=False)

# 保存并关闭写入器对象
writer.save()