How to extract column index based on value in another column?

A = [2 4 1 3 2; 3 1 4 2 3; 2 4 1 3 4; 4 2 3 1 4; 1 3 2 4 4];
T1 = array2table(A, 'VariableNames',{'tar1','tar2','tar3','tar4','probe'})
T1 = 5×5 table
    tar1    tar2    tar3    tar4    probe
    ____    ____    ____    ____    _____

     2       4       1       3        2  
     3       1       4       2        3  
     2       4       1       3        4  
     4       2       3       1        4  
     1       3       2       4        4  
Col6 = arrayfun(@(k)find(T1{k,1:4}==T1{k,5}), 1:size(T1,1)).';
T1 = addvars(T1,Col6,'After',5)
T1 = 5×6 table
    tar1    tar2    tar3    tar4    probe    Col6
    ____    ____    ____    ____    _____    ____

     2       4       1       3        2       1  
     3       1       4       2        3       1  
     2       4       1       3        4       2  
     4       2       3       1        4       1  
     1       3       2       4        4       4  

.

2 个评论
显示无隐藏无

Anastasiia Khibovska 2023-2-28

Thank you very much! I realized I had text instead of numbers, so I had to convert my table first for your code to work!

Star Strider 2023-2-28

As always, my pleasure!

请先登录，再进行评论。

Answer 2

Voss 2023-2-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1916550-how-to-extract-column-index-based-on-value-in-another-column#answer_1176885

在 MATLAB Online 中打开

% first I create a table of random data
n_rows = 15;
data = zeros(n_rows,4);
for ii = 1:n_rows
    data(ii,:) = randperm(4);
end
t = array2table([data randi(4,n_rows,1)], ...
    'VariableNames',{'tar1','tar2','tar3','tar4','probe'})
t = 15×5 table
    tar1    tar2    tar3    tar4    probe
    ____    ____    ____    ____    _____

     4       1       2       3        3  
     1       4       2       3        4  
     1       3       2       4        2  
     3       2       4       1        1  
     3       4       2       1        4  
     1       2       4       3        4  
     3       2       4       1        1  
     3       4       1       2        1  
     1       3       4       2        1  
     2       1       4       3        3  
     1       2       4       3        3  
     2       3       1       4        1  
     4       3       2       1        4  
     1       2       4       3        3  
     3       1       2       4        2  
% now construct the new column
n_rows = size(t,1);
new_col = zeros(n_rows,1);
for ii = 1:n_rows
    [~,new_col(ii)] = ismember(t{ii,5},t{ii,1:4});
end
t.new_column = new_col
t = 15×6 table
    tar1    tar2    tar3    tar4    probe    new_column
    ____    ____    ____    ____    _____    __________

     4       1       2       3        3          4     
     1       4       2       3        4          2     
     1       3       2       4        2          3     
     3       2       4       1        1          4     
     3       4       2       1        4          2     
     1       2       4       3        4          3     
     3       2       4       1        1          4     
     3       4       1       2        1          3     
     1       3       4       2        1          1     
     2       1       4       3        3          4     
     1       2       4       3        3          4     
     2       3       1       4        1          3     
     4       3       2       1        4          1     
     1       2       4       3        3          4     
     3       1       2       4        2          3     