MATLAB Answers

Finding elements in column that meet some criteria

12 views (last 30 days)
djr on 9 Sep 2014
Commented: dpb on 10 Sep 2014
I have a matrix that has 3 columns and 186 rows. Values are something like this:
Velocity X Y
6.73568234861034 0 500
6.73568234861034 2000 520
6.73568234861034 -2000 540
6.73568234861034 4000 560
6.76077918572001 0 580
6.76071354732644 6000 600
I need to transform this into matrix that will be like this
X Z Velocity
X and Z have to start from 0 and go up to maximum (8000 for x and 600 for z). This was easy. I used "sort" function, so I took care of X and Z columns.
However, now I need to figure out how to copy "Velocity" values from the first table into the second, but in a way that "Velocity" values correspond to the right value of X and Z. I guess I could use "for" loops with "if" statements, but I was wondering is there any other (easier) way; just using built-in functions?
Could you please help me with this?
Thanks, DjR

  1 Comment

per isakson
per isakson on 9 Sep 2014
  • Are you aware of the second output of sort?
  • You cannot sort on both X and Y at the same time - what do i miss?
  • The words "matrix" and "table" are they synonyms?
  • ... or table is that table, Create table from workspace variables

Sign in to comment.

Accepted Answer

dpb on 9 Sep 2014
Edited: dpb on 10 Sep 2014
M=sortrows([m(:,2:3) m(:,1)],[1 2]);
Presuming m is original array w/o the header line and your "Z" is really "Y"
Or, the explicit column rearrangement can be written in a "more Matlaby" manner, and the result as
M=sortrows(circshift(m,[0 -1]),[1 2]);


Sign in to comment.

More Answers (1)

djr on 10 Sep 2014
Thanks so much. Yes, Z is Y (my bad).

  1 Comment

dpb on 10 Sep 2014
You're welcome...always a challenge to find the proper function(s) when first becoming familiar with Matlab. NB:
lookfor sort
would have located sortrows for you altho it's listed in the "friends" category of See Also under sort. Always look into the alternatives therein if the base function doesn't quite fit as here. The 'rows' part of the name given your requirements should've been a hint.
circshift isn't quite so easy, granted... :)

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by