Reorder table variables / columns

Question

Alan 2014-9-18

4
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/155317-reorder-table-variables-columns

评论： cui,xingxing 2023-11-17

I've created a table from a large csv file using the readtable function. I want to reorder the variables / columns in this table.

For example.

My table's name is CUTable

It has a variable CUTable.Date which is the date the data was taken It is currently column 20 in the table. I want to make it column 2 and shift existing columns 2-19 to 3-20.

It seems there should be a very easy command to do this which I'm missing, but I can't seem to find it anywhere in the help or these forums. I could, but don't want to "brute force" it (e.g. create a new table, and one-by-one copy the variables from the exiting table to the new table in the order I want, then delete the old table) if avoidable.

How can I accomplish this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Geoff Hayes 2014-9-18

7
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/155317-reorder-table-variables-columns#answer_152136

编辑：Geoff Hayes 2014-9-18

在 MATLAB Online 中打开

Alan - you can try the following to move the 20th column to the second position

CUTable = [CUTable(:,1) CUTable(:,20) CUTable(:,2:19)];

It isn't as elegant as a simple "move column command" but it should do what you want. In the following example, I inserted the last column in before the second (note that I use end here rather than the last column number)

 load patients;
 T = table(Age,Diastolic,Gender,Height,LastName,Location,...
           SelfAssessedHealthStatus,Smoker,Systolic,Weight)
 T = [T(:,1) T(:,end) T(:,2:end-1)]

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

Ole 2014-10-30

编辑：Ole 2014-10-30

在 MATLAB Online 中打开

You can also use the Workspace browser to modify your table by hand. The useful thing is that Matlab shows you the commands it performs for each action. For example when rearranging columns it does:

T=table; T.x=1; T.y=2; % setup demo table
T=T(:,[2 1]); % rearrange x and y columns

For the above example by Geoff Hayes that would be

T = T(:,[1 end 2:end-1])

which is apparently the way you are supposed to do it.

Peter Perkins 2018-2-21

编辑：Peter Perkins 2018-2-21

在 MATLAB Online 中打开

Yes, for a simple rearrangement, what Ole suggests is the best way. In some cases, it will be more readable use variable names, something such as

T = array2table(rand(10,3),'VariableNames',{'x' 'y' 'z'})
T = T(:,{'z' 'y' 'x'})

but with more than a handful of variables, probably using numbers is more readable.

请先登录，再进行评论。

Answer 2

Eric Sofen 2018-3-28

8
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/155317-reorder-table-variables-columns#answer_312462

In R2018a, check out the new movevars function for rearranging variables in tables. It's part of a set of new functions for manipulating table variables:

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

cui,xingxing 2023-11-17

add topic link:

Add, Delete, and Rearrange Table Variables

请先登录，再进行评论。

Answer 3

Ben Oeveren 2018-2-21

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/155317-reorder-table-variables-columns#answer_306262

编辑：Ben Oeveren 2018-2-21

在 MATLAB Online 中打开

Or you can use:

oldvariables = T.Properties.VariableNames;
newvariables = {'date','Title','Website'};
[~,LOCB] = ismember(oldvariables,newvariables);
newTable = T(:,LOCB);

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

Justin Elstrott 2021-1-13

在 MATLAB Online 中打开

Hi Ben,

I like this solution, but there's a typo in the third line. I believe it should read as:

oldvariables = T.Properties.VariableNames;
newvariables = {'date','Title','Website'};
[~,LOCB] = ismember(newvariables,oldvariables);
newTable = T(:,LOCB);