2020-11-30

import pandas as pd
df=pd.read_excel(“工作簿1.xlsx”,sheet_name=0,header=None)
i=5
while i<=21:
col_name=df.loc[1,i]
j=0
for j in [i,i+1,i+2]:
df.loc[1,j]=col_name+"_"+df.loc[2,j]
i=i+3
if i==14:
i=i+1
df.rename(columns=df.loc[1],inplace=True)
df.drop(labels=[0,1,2,3,28,29],axis=0,inplace=True)
df.to_excel(“test.xls”)