MATLAB: Sorting raw data

queuesample binin

I was wondering if anyone can help me with this. Actually I need to be able to write a program in matlab which looks through your raw data and picks up the queue length and delay for the last reading showing any particular value of Unix time, i.e. before it changes to a value that is 0.01 seconds higher. This is an example of my data set. The first Column is my queue length, the second is my unix timestamp, the third is my delay and the fourth the time difference between the time stamps
0 1312023712.02 1.19209289551E-06 0.03999996185303
0 1312023712.02 7.15255737305E-06 0.03999996185303
0 1312023712.02 7.15255737305E-07 0.03999996185303
0 1312023712.02 1.19209289551E-06 0.03999996185303
0 1312023712.03 9.53674316406E-07 0.04999995231628
0 1312023712.03 7.15255737305E-07 0.04999995231628
0 1312023712.03 1.19209289551E-06 0.04999995231628
0 1312023712.03 7.15255737305E-07 0.04999995231628
0 1312023712.03 9.53674316406E-07 0.04999995231628
So in this case i need to get the last value of queue length and delay when time duration is 0.03999 and 0.049999. according to this sample at 0.03999- 0 and 1.19209289551E-06 and for 0.0499- 0 and 9.53674316406E-07

Best Answer

YourData(logical(diff([YourData(:,3);inf])),:)
Urrr, perhaps with amendments to fix the problems Image Analyst pointed out.
Related Question