Sorting raw data
1 view (last 30 days)
Show older comments
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
4 Comments
Image Analyst
on 31 Jul 2011
I have no idea what you said. If you say to ignore the junk in the table, then what are we left to deal with?
Accepted Answer
Walter Roberson
on 31 Jul 2011
YourData(logical(diff([YourData(:,3);inf])),:)
Urrr, perhaps with amendments to fix the problems Image Analyst pointed out.
More Answers (1)
Rick Rosson
on 28 Jul 2011
Please provide the following information:
- What specifically are you trying to do?
- What have you tried so far?
- What is not working in what you have tried?
- What is your specific question?
Thanks!
Rick
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!