python 根据Excel指定字段内容不同时插入空白行

import pandas as pd


def insert_blank_rows(df, field_name):
    new_rows = []
    for index, row in df.iterrows():
        new_rows.append(row)
        if index < len(df) - 1:
            if df.loc[index, field_name]!= df.loc[index + 1, field_name]:
                blank_row = pd.Series([None] * len(row), index=row.index)
                new_rows.append(blank_row)
                blank_row = pd.Series([None] * len(row), index=row.index)
                new_rows.append(blank_row)
                blank_row = pd.Series([None] * len(row), index=row.index)
                new_rows.append(blank_row)
                blank_row = pd.Series([None] * len(row), index=row.index)
                new_rows.append(blank_row)
    return pd.DataFrame(new_rows)


# 读取Excel文件
df = pd.read_excel("2024102408212024学年第1学期九年级期中考考生.xlsx")

df['学籍辅号'] = df['学籍辅号'].astype(str)
df['准考证号'] = df['准考证号'].astype(str)

new_df = insert_blank_rows(df, "试场号")
# 将结果保存到新的Excel文件
new_df.to_excel("new_file.xlsx", index=False)