I have a .txt file with time series matrix like this:
2014,01,29,14,04,0.2002014,01,29,14,50,0.0002014,01,29,15,50,0.0002014,01,29,16,50,0.0002014,01,29,17,50,0.0002014,01,29,18,50,0.0002014,01,29,19,50,0.0002014,01,29,20,50,0.0002014,01,29,21,50,0.0002014,01,29,22,50,0.0002014,01,29,23,50,0.0002014,01,30,0,50,0.0002014,01,30,01,15,0.7872014,01,30,01,50,0.0002014,01,30,01,51,0.2002014,01,30,02,49,0.5892014,01,30,02,50,0.2002014,01,30,03,03,0.3932014,01,30,03,22,7.0882014,01,30,03,33,6.1012014,01,30,03,44,10.3582014,01,30,03,50,2.9522014,01,30,03,55,1.9692014,01,30,04,02,0.9822014,01,30,04,09,0.200
The columns show year, month, day, hour, minute and precipitation rate, respectively. I need hourly precipitation data. I want to get output like this in a .txt file:
2014,01,29,14,0.2002014,01,29,15,0.0002014,01,29,16,0.000...
And I need daily precipitation data in a other .txt file:
2014,01,29,0.2002014,01,30,31.819...
Tks for help!!
Best Answer