import  pandas as pd
import os
import time
import numpy as np
data=pd.read_excel('新建 Microsoft Excel 工作表.xlsx')
# print(list(data.iloc[0,:])[1:])
# print(list(data.iloc[:,0])[2:])
sj=[]
for i in list(data.iloc[:,0])[2:]:
    sj.append(str(i.year)+str(i.month)+str(i.day))
df=pd.DataFrame(sj,columns=['时间'])
print(df)
wj=os.listdir('tem11')
duiz={}
zhi=[]
# lie = int(input('请输入获取第几列数据'))
for kk in wj:
    with open(f'tem11/{kk}',encoding='utf-8') as f:
        lie = int(input(f'请输入{kk}获取第几列数据'))
        da=f.readlines()
        for i in da:
            k=duiz.get(i.split( )[0].strip(),[])
            k.append([i.split( )[4].strip()+i.split( )[5].strip()+i.split( )[6].strip(),i.split( )[lie-1].strip()])
            duiz[i.split( )[0].strip()]=k
zuihoude=[]
star=time.time()
for i in sj:
    zhong=[]
    for j in list(map(str,list(data.iloc[0,:])[1:])):
        flag=0
        for k in duiz[j]:
            if k[0]==i:
                zhong.append(k[1])
                flag=1
                break
        if flag==0:
            zhong.append('none')
    zuihoude.append(zhong)
print(zuihoude)
pd.DataFrame(zuihoude).to_excel('nnew.xlsx')
print(time.time()-star)

运行以上代码，可提取对应列的数据，得到excel格式的数据