Confronting column values of two rows in a table?

Question

Fabio 2021-12-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1614875-confronting-column-values-of-two-rows-in-a-table

评论： Fabio 2021-12-20

Table.mat

Hello everyone,

I have a table (see attached file) showing specific data (variables as columns) for every element name (rows). I would like to implement a code that allows me to compare between two elements (rows) their respective variable value.

For example, for the giving table, I would like that the code compares the “GWP” variable between element “T” (GWP_T=500) and element “P1” (GWP_P1=400) and it gives me the element name that has a higher “GWP” between the two à “T” (GWP_T=500).

How can I do that?

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

请先登录，再进行评论。

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

Answer 1

Voss 2021-12-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1614875-confronting-column-values-of-two-rows-in-a-table#answer_859120

在 MATLAB Online 中打开

Table.mat

t = load('Table.mat');
t = t.Comp;
names = {'T' 'P1'};
[~,idx] = max(t.GWP(ismember(t.Name,names)));
max_name = names{idx}
max_name = 'T'

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

Voss 2021-12-20

在 MATLAB Online 中打开

Table.mat

A for loop would work, yes. You would just perform the operation specified in my answer for each pair of variable names, i.e., the names variable up there would get each pair of names and the rest would be the same.

t = load('Table.mat');
t = t.Comp;
all_names = {'T' 'P1'; 'T' 'S2'; 'T' 'P2'; 'T' 'S3' }; % I made a slight modification: to use a 4-by-2 cell array here rather than a 1-by-8 but you can do it with a 1-by-8 if you need to
N = size(all_names,1);
max_names = cell(N,1);
for i = 1:N
    names = all_names(i,:);
    [~,idx] = max(t.GWP(ismember(t.Name,names)));
    max_names{i} = names{idx};
end
display(max_names);
max_names = 4×1 cell array
    {'T'}
    {'T'}
    {'T'}
    {'T'}