现阶段用代码实现,隔四行删除数据
import pandas as pd
# 读取 Excel 文件
excel_file = 'xxxx.xlsx'
df = pd.read_excel(excel_file)
rows_to_keep = []
# 要删除的行数
skip_rows = 4
for i, row in enumerate(df.iterrows()):
index, data = row
if i % (skip_rows + 1) == 0:
rows_to_keep.append(index)
# 保留需要的行
filtered_df = df.loc[rows_to_keep]
# 将结果保存到新的 Excel 文件
output_excel_file = 'xxxx.xlsx' # 替换为你想要保存的 Excel 文件路径
filtered_df.to_excel(output_excel_file, index=False)
print("成功")