re-arranging of columns

1 view (last 30 days)
aditi
aditi on 4 Apr 2014
Answered: Jos (10584) on 4 Apr 2014
hi everyone..
i have a data file with 24 columns and 125 rows... I want to bring 23rd column after column 4... how will i do that... please help

Accepted Answer

Viju
Viju on 4 Apr 2014
Edited: Viju on 4 Apr 2014
Once you import this data into a MATLAB variable, there are multiple methods. One way is as follows, where x is the data and y is where I am storing the new data.
y = [x(:,1:4) x(:,23) x(:,5:22) x(:,24)]
  1 Comment
aditi
aditi on 4 Apr 2014
ohh okay.... thanks viju..
so here 'x' is the variable in which i load the data file?? right???

Sign in to comment.

More Answers (1)

Jos (10584)
Jos (10584) on 4 Apr 2014
No need for concatenation …
A = load('mydatafile.txt') % only numbers separated by spaces/tabs
A(:,[4 23]) = A(:,[23 4]) % switch columns 4 and 23

Community Treasure Hunt

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

Start Hunting!