Hello!
Im trying to make a graph out of some time series. I also need to show the correlation between Wind direction and Current direction.
Wind and Current time series dont match and there are less values for current data ... compared to wind data. How can i make those values match? For exampe how can i filter out some Wind values and do so, that there is only one time column?
Wind direction / Current direction
3.06.2010 16:00 252,8 3.06.2010 16:07 -9,9
3.06.2010 16:05 253,4 3.06.2010 16:27 8,3
3.06.2010 16:10 249,3 3.06.2010 16:47 -10,4
3.06.2010 16:15 258,6 3.06.2010 17:07 -89,5
3.06.2010 16:20 255,3
3.06.2010 16:25 272,1
3.06.2010 16:30 235,3
3.06.2010 16:35 233,4
3.06.2010 16:40 257,9
3.06.2010 16:45 258,7
3.06.2010 16:50 255,9
3.06.2010 17:00 257,6
3.06.2010 17:10 254,5
I want like this
3.06.2010 16:00 252,8 -9,9
3.06.2010 16:20 255,3 8,3
3.06.2010 16:40 257,9 -10,4
3.06.2010 17:00 257,6 -89,5
Maybe i need somekind of a function, that reads the tens (minutes) from the blue column: 3.06.2010 16:07
Then takes the value from next column: -9,9
And matches it to wind column time: 3.06.2010 16:00
Plus takes the value next to it. 252,8
Thank you for reading my post
Im trying to make a graph out of some time series. I also need to show the correlation between Wind direction and Current direction.
Wind and Current time series dont match and there are less values for current data ... compared to wind data. How can i make those values match? For exampe how can i filter out some Wind values and do so, that there is only one time column?
Wind direction / Current direction
3.06.2010 16:00 252,8 3.06.2010 16:07 -9,9
3.06.2010 16:05 253,4 3.06.2010 16:27 8,3
3.06.2010 16:10 249,3 3.06.2010 16:47 -10,4
3.06.2010 16:15 258,6 3.06.2010 17:07 -89,5
3.06.2010 16:20 255,3
3.06.2010 16:25 272,1
3.06.2010 16:30 235,3
3.06.2010 16:35 233,4
3.06.2010 16:40 257,9
3.06.2010 16:45 258,7
3.06.2010 16:50 255,9
3.06.2010 17:00 257,6
3.06.2010 17:10 254,5
I want like this
3.06.2010 16:00 252,8 -9,9
3.06.2010 16:20 255,3 8,3
3.06.2010 16:40 257,9 -10,4
3.06.2010 17:00 257,6 -89,5
Maybe i need somekind of a function, that reads the tens (minutes) from the blue column: 3.06.2010 16:07
Then takes the value from next column: -9,9
And matches it to wind column time: 3.06.2010 16:00
Plus takes the value next to it. 252,8
Thank you for reading my post
Last edited: