I have a csv file with data every 10 minutes. Looks something like
Time Data
00:10 12
00:20 11
00:30 15
00:40 36
00:50 57
01:00 67
01:10 87 ...
What I want is to sort the time interval so it only display the data from every full hour, and the data is the mean of all the data points within that hour. It should look something like this
Time Mean
00:00 45
01:00 78
02:00 78
03:00 56...
I don't know where to start...