主页 / coding / 问题 / 77135303
Accepted
nikhil
Asked: 2023-09-19 22:09:35 +0800 CST

Pandas 在 Excel 中的每行后面插入一个空白行[重复]

  • 772

首先是熊猫新手。我正在使用以下代码使用 Pandas 写入 Excel 文件。请看行worksheet.write(0, col_num, value, header_format)。问题是，如何在每行后面插入一个空白行。例如我想要类似的东西

Col1 Col2 Col3 Col4   (This is the Header)
--------------Blank row
C1    C2   C3   C4
--------------Blank row
C1    C2   C3   C4
--------------Blank row
C1    C2   C3   C4

这就是我所拥有的

def create_excel_with_format(headers,values,full_file_name_with_path):
   
   df = pd.DataFrame(data=values,columns=headers)
   with pd.ExcelWriter(full_file_name_with_path) as writer:
       df.to_excel(writer, index=False)

   workbook  = writer.book
   worksheet = writer.sheets['Sheet1']
   #font_fmt = workbook.add_format({'font_name': 'Arial', 'font_size': 10})
   header_format = workbook.add_format({
        'bold': False,
        'border': False,
        'text_wrap': True})
   
   for col_num, value in enumerate(df.columns.values):
        worksheet.write(0, col_num, value, header_format)

   font_fmt = workbook.add_format({'font_name': 'Arial', 'font_size': 13})
   worksheet.set_row(0, None, font_fmt)
python

1 个回答

  1. Best Answer

    假设您的dfa 有默认索引（从 0 开始的整数范围），您可以使用：

    out = df.set_axis(df.index*2 + 1).reindex(range(len(df)*2))

    此外，上下文管理器内的块存在缩进问题：

    def create_excel_with_format(headers,values,full_file_name_with_path):
   
    df = pd.DataFrame(data=values,columns=headers)
    df = df.set_axis(df.index*2 + 1).reindex(range(len(df)*2))
    
    with pd.ExcelWriter(full_file_name_with_path) as writer:
        df.to_excel(writer, index=False)

        workbook  = writer.book
        worksheet = writer.sheets['Sheet1']

        header_format = workbook.add_format({
            'bold': False,
            'border': False,
            'text_wrap': True})

        for col_num, value in enumerate(df.columns.values):
            worksheet.write(0, col_num, value, header_format)

        font_fmt = workbook.add_format({'font_name': 'Arial', 'font_size': 13})
        worksheet.set_row(0, None, font_fmt)

    输出（在 Excel 中）：

    在此输入图像描述

    使用的电话：

    values = [
    ['C1', 'C2', 'C3', 'C4'],
    ['C1', 'C2', 'C3', 'C4'],
    ['C1', 'C2', 'C3', 'C4']
]

headers= ['Col1', 'Col2', 'Col3', 'Col4']

create_excel_with_format(headers, values, "file.xlsx")
    • 1

相关问题