筛选需要的站点数据

import os
import pandas as pd
import numpy as np
import glob

path=r'E:\meteorological data\190701-091023'
file=glob.glob(os.path.join(path, "*.txt"))

df=[]
for f in file:
    df.append(pd.read_csv(f,sep='\s+',header=0))
station=pd.concat(df)


bj=station[station['Station_Id_C']==54399]
bj[bj==999017]=np.nan
#bj.iloc[:,[11,13,14]]

writer = pd.ExcelWriter('54399.xlsx')
bj.to_excel(writer, sheet_name='54399')
writer.save()