美文网首页
筛选需要的站点数据

筛选需要的站点数据

作者: Aerosols | 来源:发表于2020-12-10 16:35 被阅读0次
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()

相关文章

网友评论

      本文标题:筛选需要的站点数据

      本文链接:https://www.haomeiwen.com/subject/rxhtgktx.html