Python：导出 pandas 数据框时如何在 Excel 中创建多行单元格

使用Python的pandas库可以方便地处理和分析数据。在处理数据时，有时需要将数据导出到Excel中，并对导出的数据进行一些格式化操作，比如创建多行单元格。本文将介绍如何使用Python中的pandas库来实现在Excel中创建多行单元格的操作。

python
import pandas as pd
from pandas import ExcelWriter

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

python
writer = ExcelWriter('data.xlsx')
df.to_excel(writer, index=False)
writer.save()

python
from openpyxl import load_workbook

python
book = load_workbook('data.xlsx')
writer = pd.ExcelWriter('data.xlsx', engine='openpyxl')
writer.book = book

python
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
sheet = writer.sheets['Sheet1']
row_num = df.shape[0]

python
new_sheet = book.create_sheet('Sheet2', 1)
for row in sheet.iter_rows(min_row=1, max_row=row_num, min_col=1, max_col=df.shape[1]):
    new_sheet.append([cell.value for cell in row])

python
from openpyxl.styles import Alignment
alignment = Alignment(wrap_text=True)
new_sheet.merge_cells('A2:A4')
new_sheet['A2'].alignment = alignment
new_sheet.merge_cells('B2:B4')
new_sheet['B2'].alignment = alignment
new_sheet.merge_cells('C2:C4')
new_sheet['C2'].alignment = alignment

python
writer.save()