Sorting raw data

2011 7 27
2 个回答
回答已采纳
4 次查看（30 天）

0 个投票

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 个评论
显示 2更早的评论 隐藏 2更早的评论

Jan
Jan 2011-7-27
Do you have a specific question? Currently the most likely answer is: yes.
Image Analyst
Image Analyst 2011-7-31
Well your queue length (the first column) is always zero. And I don't see how the 4th column is the difference between rows of the second column. If it were the first 3 rows of the 4th column would be zero because the first 3 rows of your second column are identical.
Anthony
Anthony 2011-7-31
I am sorry U really cant see this because the resolution after copying is very poor. Ok please Ignore the the values of the table I can deal with those. What i really need is to be able to get the values
0 1312023712.02 1.19209289551E-06 0.03999996185303
and
0 1312023712.03 9.53674316406E-07 0.04999995231628
because my data is very large about 2GB. So it could take me a lifetime to do it manually. Please do not worry about the values once again. I just need the script to give me the specific values without having to hand pick them; using the values in the fourth column.
Thanks a lot guys
Image Analyst
Image Analyst 2011-7-31
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?

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2011-7-31

1 个投票

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

2 个评论
显示 无 隐藏 无

Anthony
Anthony 2011-7-31
Thanks Walter, please could check my reply to Image Analyst's comment and see if you have anything to help out with.
Anthony
Anthony 2011-7-31
it works Thanks walter, did a little modification

请先登录，再进行评论。

更多回答（1 个）

Rick Rosson
Rick Rosson 2011-7-28

0 个投票

Please provide the following information:
  1. What specifically are you trying to do?
  2. What have you tried so far?
  3. What is not working in what you have tried?
  4. What is your specific question?
Thanks!
Rick

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Anthony
Anthony 2011-7-31
Thanks Rick.
I have been ill, that is why i could not reply early enough. I have modified my question. I hope this helps.
I tried using c++ and java to do this but i dont get the values i need. I was told it would be more accurate with matlab.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Argument Definitions 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by