请问我这个为什么只能删掉最后一个负值行,前面的都删不了呢?
import pandas as pd
from pandas import DataFrame
from openpyxl import load_workbook
wb = pd.read_excel('Aged analysis.xlsx',sheet_name='Red')
DataFrame(wb).to_excel('df_new.xlsx',sheet_name='Red',index=False,header=True)
for j in range(0, len(wb.index)):
# print(j)
if wb.iat[j, 2]<0:
print(j)
data = wb.drop(index=j)
data.to_excel('df_new.xlsx')