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
MATLAB: Re-arranging of columns
re-arrange columns
Related Solutions
You can remove both at once:
a(:,:,[22 23]) = [];The main problem with your method is that after you remove the 22nd slice, the 23rd slice "moves" into the 22nd position, so there is no 23rd slice anymore. At the next iteration of the loop, when you try to remove the 23rd slice, it no longer exists.
One approach may be to do something like the following - separate the text data and numeric data into two separate matrices. Both would have the same number of rows, say M, with the text (cell) array having only the one column and the numeric data matrix having N rows for each of the N different columns of numbers. Call these matrices/arrays textData and numericData. (Note that the textData is most likely a cell array because you may allow different string lengths for each row.)
Now append a column to the numericData matrix, with values from 1 to M (so row i is assigned the value of i). This column will act like a series of unique identifiers for the numeric data, and will in fact be indices into the textData array so no matter how we sort our data in the numericData array, the identifier can always be used to refer back to the text string in textArray. (So now numericData is a Nx(M+1) matrix.) The code for doing this appending is simply:
[M,N] = size(numericData);numericData = [numericData [1:M]'];So now you want to sort the rows by the numeric values. Do you mean to sort on the first column, second column, etc.? If that is the case, then you can use the sortrows command, and indicate the column order of the sort. For example, if your numericData is:
numericData = 95 45 92 41 13 1 84 95 7 73 89 20 74 52 95 7 73 5 19 44 20 95 7 40 35 60 93 67 76 61 93 81 27 46 83 76 79 91 0 19 41 1then we append the id column as:
[M,N] = size(numericData);numericData = [numericData [1:M]'];numericData = 95 45 92 41 13 1 84 1 95 7 73 89 20 74 52 2 95 7 73 5 19 44 20 3 95 7 40 35 60 93 67 4 76 61 93 81 27 46 83 5 76 79 91 0 19 41 1 6Then we sort on the first column, second, etc. as
numericData = sortrows(numericData,[1:N])numericData = 76 61 93 81 27 46 83 5 76 79 91 0 19 41 1 6 95 7 40 35 60 93 67 4 95 7 73 5 19 44 20 3 95 7 73 89 20 74 52 2 95 45 92 41 13 1 84 1All the data is sorted by column, and each row still has its unique identifier (in the last column) so we can easily refer back to the text string for that row.
Best Answer