将数据帧写入不同的excel工作表

import pandas as pd
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows

workbook = Workbook()

data = {'姓名': ['张三', '李四', '王五'],
        '年龄': [25, 30, 35],
        '性别': ['男', '女', '男']}
df = pd.DataFrame(data)

worksheet = workbook.active
worksheet.title = 'Sheet1'
for row in dataframe_to_rows(df, index=False, header=True):
    worksheet.append(row)

data2 = {'城市': ['北京', '上海', '广州'],
         '职业': ['工程师', '教师', '医生']}
df2 = pd.DataFrame(data2)

worksheet2 = workbook.create_sheet(title='Sheet2')
for row in dataframe_to_rows(df2, index=False, header=True):
    worksheet2.append(row)

workbook.save('dataframe_to_excel.xlsx')