【Python 随机生成数据】用 pandas 保存多个 dataFrame 到同一个 excel 工作簿中的多个sheet

import random
import numpy as np
import pandas as pd
from string import ascii_uppercase as U_CASES


random.seed(19990702)
name = sorted([''.join(random.sample(U_CASES, k=3)).capitalize() for i in range(13)])#list comprehension
print(name)
gender = [random.choice(['男', '女']) for i in range(13)]
print(gender)
age = [random.randint(a=15, b=60) for i in range(13)]
print(age)
data = {
    '姓名': name,
    '性别': gender,
    '年龄': age,
}
print(data)

dataFrame = pd.DataFrame(data)
print(dataFrame)

filename = 'C:\\Users\\admin\\Desktop\\222222.xlsx'
writer = pd.ExcelWriter(filename)
for i in range(3):
    dataFrame.to_excel(excel_writer=writer,
                       sheet_name=f'Sheet{i + 1}',
                       index=False,
                       )
writer.save()