import pandas as pd
data = pd.read_excel('C:/Users/cory511/Desktop/.xls',encoding='gbk')
df = data[0:1].isnull()
df = df.drop([0])
for i in range(1,100):
j = []
P = data[i:i+1].isnull()
P['Col_sum'] = P.apply(lambda x: x.sum(), axis=1)
if P.iloc[0]['Col_sum']!=12:
df = pd.concat([df,data[i:i+1]])
else:
#'df%i'%(i) = df证明失败
#j.append('df%i'%(i))证明失败
df.to_csv('C:/Users/cory511/Desktop/JM/%i.csv'%(i))
df = data[0:1].isnull()
df = df.drop([0])
自学,防掉落
希望能更进的点:
1.连续空行会被输出
2.若能根据循环修改变量名就可以不用输出表格进行数据重塑了唉