为什么python筛选出excel的数据,保存到excel中只有一块满足条件的?


import pandas as pd

data = pd.read_excel(r'C:\Users\Desktop\sjcs.xlsx')
for i in range(0, data.shape[0]):
    if data.iloc[i, 0] == 0:
        new_data = data.iloc[i:i + 3]
        write = pd.ExcelWriter('C:/Users/Desktop/new_data.xlsx', engine='openpyxl')
        new_data.to_excel(write, header=None, index=False, startrow=0, startcol=0)
        write.save()
        write.close()

因为你每次都写到了 startrow=0, startcol=0 ,将上一次的覆盖了?

startrow=i+1