我有一个来自igra2 weather dataset的天气数据集
文件的典型部分如下所示:
#ICXUAE05424 1909 04 22 99 0935 6 erac-hud 657000 -180000
30 -9999 -9999 100 -9999 -9999 -9999 120 49
30 -9999 -9999 350 -9999 -9999 -9999 119 110
30 -9999 -9999 750-9999 -9999 -9999 149 97
30 -9999 -9999 1250-9999 -9999 -9999 136 123
30 -9999 -9999 1750-9999 -9999 -9999 104 121
30 -9999 -9999 2250-9999 -9999 -9999 117 171
#ICXUAE05424 1909 04 22 99 1820 3 erac-hud 657000 -180000
30 -9999 -9999 100 -9999 -9999 -9999 120 53
30 -9999 -9999 350A -9999 -9999 -9999 111 69
30 -9999 -9999 750B-9999 -9999 -9999 102 55
#ICXUAE05424 1909 04 23 99 0845 5 erac-hud 657000 -180000
30 -9999 -9999 100 -9999 -9999 -9999 31 9
30 -9999 -9999 350 -9999 -9999 -9999 102 62
30 -9999 -9999 750 -9999 -9999 -9999 103 132
30 -9999 -9999 1250 -9999 -9999 -9999 98 120
30 -9999 -9999 1750 -9999 -9999 -9999 101 100
我需要通过将一些(或全部)头属性附加到数据行来预处理数据,然后将其转换为csv文件。 如果不是PythonPandas 输出csv文件的格式如下:
lvl12,etime,press,gph,temp,rh,dpdp,wdir,wspd,hour,lattitude,longitude
21,-9999,96900A,234,270A,742,-9999,-9999,-9999,12,316333,748667
20,-9999,95000,-9999,290A,484,-9999,-9999,-9999,12,316333,748667
20,-9999,88700,-9999,290A,454,-9999,-9999,-9999,12,316333,748667
10,-9999,85000,1384A,260A,446,-9999,-9999,-9999,12,316333,748667
10,-9999,70000,3055A,130A,506,-9999,-9999,-9999,12,316333,748667
20,-9999,58400,-9999,0A,690,-9999,-9999,-9999,12,316333,748667
20,-9999,55900,-9999,0A,312,-9999,-9999,-9999,12,316333,748667
10,-9999,50000,5772A,-65A-9999,-9999,320,850,,12,316333,748667
其他数据集信息:
前缀为#
的行是标题,后面的行是数据。你知道吗
标题属性包括:
station code, year, month, day, etc
分隔的第七个属性空间是npv
,表示后面的数据行数。你知道吗
数据列包括:
lvl12, etime, press, gph, temp, rh, dpdp, wdir, wspd
您需要逐行手动解析文件,注意头的位置。你知道吗
我假设像
750-9999
这样的数据实际上有一个空间750 -9999
?如果不是这样,则需要固定宽度的方法:只需使用Python的CSV库就可以做到这一点,如下所示:
或者如果你也想利用熊猫:
给你:
使用Python 3.x进行测试。如果使用的是Python 2.x,请更改以下内容:
相关问题 更多 >
编程相关推荐