hi
i have time series data and i received it with just 1 or 2 minute delay or forward time so how can i change it to exact 10 minute
for example:
6/1/2016 20:40 -3.13
6/1/2016 21:00 -3.04
6/1/2016 21:10 -3
6/1/2016 21:20 -2.9
6/1/2016 21:30 -2.9
6/1/2016 21:42 -2.84
6/1/2016 21:52 -2.78
6/1/2016 22:02 -2.72
6/1/2016 22:10 -2.72
6/1/2016 22:22 -2.61
6/1/2016 22:32 -2.55
6/1/2016 22:42 -2.51
6/1/2016 22:49 -2.47
in line 6 i have to change data 6/1/2016 21:42 -2.84 in to 6/1/2016 21:40 -2.841 and
6/1/2016 21:52 -2.78 in to 6/1/2016 21:50 -2.78 and so on
......22:00
......22:20
......22:30
......22:40
and 6/1/2016 22:49 -2.47 in to 6/1/2016 22:50 -2.47
note: some how we lost data at the exact time for example in line 1 & 2 ( 20:40 21:00) we missed 20:50
thanks so much
Bookmarks