Reorder table columns names

Question

Sarah Yun 2019-12-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496765-reorder-table-columns-names

回答： Naruepon Weerawongphrom 2024-11-6，16:29

采纳的回答： Adam Danz

Hi,

I have two tables

The order of the columns in the 1st table is:

Date, temp, humidity, pressure, precip, depth

The order of the columns in the 2nd table is:

Date, pressure, temp, humdity, precip, depth

How can I change the order of the 2nd table column names to match the order of the 1st table column names?

Thank you.

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

请先登录，再进行评论。

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

Answer 1

Adam Danz 2019-12-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496765-reorder-table-columns-names#answer_406472

编辑：Adam Danz 2019-12-15

在 MATLAB Online 中打开

Hint:

[~, newOrder] = ismember(T1.Properties.VariableNames,T2.Properties.VariableNames); 

Or, as Steven Lord points out in the comments below, you can use the VariableNames of Table 1.

2 个评论
显示无隐藏无

Adam Danz 2019-12-15

在 MATLAB Online 中打开

Looks like you got the hint! :)

In case future visitors are interested, here's the full demo:

% Create two tables
T1 = array2table(rand(10,6),'VariableNames',{'Date', 'temp', 'humidity', 'pressure', 'precip', 'depth'});
T2 = array2table(rand(10,6),'VariableNames',{'Date', 'pressure', 'temp', 'humidity', 'precip', 'depth'});
% Determine new column order of table 2
[~, newOrder] = ismember(T1.Properties.VariableNames,T2.Properties.VariableNames); 
% Reorder columns of table 2
T2New = T2(:,newOrder)

Steven Lord 2019-12-15

在 MATLAB Online 中打开

Once you check (or if you can assume) that T2 has all the variables T1 does, you could skip ismember.

T3 = T2(:, T1.Properties.VariableNames);

请先登录，再进行评论。

Answer 2

Image Analyst 2019-12-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/496765-reorder-table-columns-names#answer_406474

在 MATLAB Online 中打开

Try using table():

% Make random values for Date, temp, humidity, pressure, precip, depth 
Date = randi(100, [5, 1]);
temp = randi(100, [5, 1]);
humidity = randi(100, [5, 1]);
pressure = randi(100, [5, 1]);
precip = randi(100, [5, 1]);
depth = randi(100, [5, 1]);
% Create tables, T1 and T2, as containers for the workspace variables. 
T1 = table(Date, temp, humidity, pressure, precip, depth)
T2 = table(Date, pressure, temp, humidity, precip, depth ) % A different order
% Reorder T2's columns to have variables in the same order as T1.
% This assumes that all variable names exist in both tables and no extra or missing ones.
T2Sorted = table(T2.Date, T2.temp, T2.humidity, T2.pressure, T2.precip, T2.depth, ...
	'VariableNames', {'Date', 'temp', 'humidity', 'pressure', 'precip', 'depth'})