Python ExcelWriter如何将数据写入不同工作表中的不同列

import pandas as pd

# 创建示例数据
data1 = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35]
}
data2 = {
    'Product': ['Apple', 'Banana', 'Cherry'],
    'Price': [1.0, 0.5, 2.0]
}

# 创建 DataFrame
df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)

# 使用 ExcelWriter 写入数据
with pd.ExcelWriter('output.xlsx') as writer:
    df1.to_excel(writer, sheet_name='Sheet1', index=False)
    df2.to_excel(writer, sheet_name='Sheet2', index=False)

with pd.ExcelWriter('output.xlsx', engine='openpyxl') as writer:
    df1.to_excel(writer, sheet_name='Sheet1', index=False, encoding='utf-8')
    df2.to_excel(writer, sheet_name='Sheet2', index=False, encoding='utf-8')

with pd.ExcelWriter('output.xlsx', engine='openpyxl') as writer:
    df1.to_excel(writer, sheet_name='Sheet1', index=False, chunksize=1000)
    df2.to_excel(writer, sheet_name='Sheet2', index=False, chunksize=1000)