Pandas DataFrame to_excel中的多个标头

import pandas as pd

# 创建DataFrame
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [28, 32, 25],
        'Country': ['USA', 'Canada', 'UK']}
df = pd.DataFrame(data)

# 导出到Excel文件，并合并单元格作为多个标头
with pd.ExcelWriter('output.xlsx') as writer:
    df.to_excel(writer, sheet_name='Sheet1', startrow=2, startcol=1, header=False)
    worksheet = writer.sheets['Sheet1']
    worksheet.merge_range(0, 1, 1, 1, 'Basic Information')
    worksheet.merge_range(0, 2, 0, 4, 'Additional Information')

# 输出结果为：
#    B1     |   C1   |   D1   |   E1
# Basic Information |         |       |
#    B2     |   C2   |   D2   |   E2
#   Name    |   Age  | Country|       |
#    Tom    |   28   |   USA  |       |
#   Nick    |   32   | Canada |       |
#   John    |   25   |   UK   |       |

import pandas as pd

# 创建DataFrame
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [28, 32, 25],
        'Country': ['USA', 'Canada', 'UK']}
df = pd.DataFrame(data)

# 创建MultiIndex作为多个标头
header = pd.MultiIndex.from_tuples([('Basic Information', 'Name'),
                                    ('Basic Information', 'Age'),
                                    ('Additional Information', 'Country')])

# 导出到Excel文件，使用MultiIndex作为表头
with pd.ExcelWriter('output.xlsx') as writer:
    df.to_excel(writer, sheet_name='Sheet1', startrow=1, startcol=1, header=False)
    worksheet = writer.sheets['Sheet1']
    for col_num, value in enumerate(header):
        worksheet.write(0, col_num + 1, value)

# 输出结果为：
#    B1     |   C1   |   D1
# Basic Information |         |
#    B2     |   C2   |   D2
#   Name    |   Age  | Country|
#    Tom    |   28   |   USA  |
#   Nick    |   32   | Canada |
#   John    |   25   |   UK   |