Hi everyone!
I have 5 years with hourly data from a meteorological station (24 hours x 365 days x 5 years= 43800 data in total of wind speed).
I would like to do a 24 hours summation loop during the five years, in order to get the sum of wind speed by each day.
For example, look at the next data:
2010 1 1 0 0.175925942010 1 1 1 0.074074082010 1 1 2 02010 1 1 3 0.162037052010 1 1 4 0.074074082010 1 1 5 0.250000022010 1 1 6 02010 1 1 7 0.148148162010 1 1 8 02010 1 1 9 0.074074082010 1 1 10 02010 1 1 11 02010 1 1 12 0.148148162010 1 1 13 0.685185242010 1 1 14 3.439815092010 1 1 15 5.069444852010 1 1 16 5.421296732010 1 1 17 4.824074462010 1 1 18 5.236111532010 1 1 19 5.240741162010 1 1 20 3.740741042010 1 1 21 3.88888922010 1 1 22 2.763889112010 1 1 23 2.782407632010 1 2 0 2.393518712010 1 2 1 2.296296482010 1 2 2 2.023148312010 1 2 3 2.000000162010 1 2 4 2.708333552010 1 2 5 2.537037242010 1 2 6 2.435185382010 1 2 7 2.166666842010 1 2 8 3.555555842010 1 2 9 3.777778082010 1 2 10 3.462963242010 1 2 11 3.111111362010 1 2 12 2.986111352010 1 2 13 2.689815032010 1 2 14 2.430555752010 1 2 15 2.120370542010 1 2 16 3.365741012010 1 2 17 3.157407662010 1 2 18 2.226852032010 1 2 19 3.370370642010 1 2 20 3.61111142010 1 2 21 3.189815072010 1 2 22 3.319444712010 1 2 23 2.518518722010 1 3 0 1.981481642010 1 3 1 1.263888992010 1 3 2 0.578703752010 1 3 3 0.60185192010 1 3 4 0.958333412010 1 3 5 0.699074132010 1 3 6 0.865740812010 1 3 7 0.773148212010 1 3 8 1.217592692010 1 3 9 1.523148272010 1 3 10 1.787037182010 1 3 11 2.171296472010 1 3 12 2.254629812010 1 3 13 2.277777962010 1 3 14 2.375000192010 1 3 15 2.134259432010 1 3 16 2.125000172010 1 3 17 2.138889062010 1 3 18 2.22222242010 1 3 19 2.069444612010 1 3 20 1.962963122010 1 3 21 2.212963142010 1 3 22 1.291666772010 1 3 23 1.981481642010 1 4 0 2.421296492010 1 4 1 1.467592712010 1 4 2 1.245370472010 1 4 3 1.606481612010 1 4 4 1.439814932010 1 4 5 0.472222262010 1 4 6 0.282407432010 1 4 7 02010 1 4 8 02010 1 4 9 0.273148172010 1 4 10 0.791666732010 1 4 11 1.347222332010 1 4 12 1.074074162010 1 4 13 2.754629852010 1 4 14 2.935185422010 1 4 15 3.078703952010 1 4 16 3.078703952010 1 4 17 2.819444672010 1 4 18 2.495370572010 1 4 19 2.615740952010 1 4 20 2.990740982010 1 4 21 3.106481732010 1 4 22 3.046296542010 1 4 23 3.3796299
In the table of above, the fourth column corresponds to the hour and the fifth corresponds to the wind speed measurement. At the end, is necessary generate the next output (daily wind speed sum).
2010 1 1 44.199077612010 1 2 67.45370912010 1 3 39.467595752010 1 4 44.7222258
Thanks in advance for your support!
Best Answer