Lookup values in ranges of a table and copy a corresponding output value in another table

Question

Gabi 2022-8-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1783380-lookup-values-in-ranges-of-a-table-and-copy-a-corresponding-output-value-in-another-table

评论： Voss 2022-8-29

A.mat
B.mat

Hi,

I'm trying find 'Val' value from table A given by Lap number in table B from minimum of first 3 rows coresponding to each lap in table A (with no sorting).

The answer would be in Table B:

Lap Val

1 1

2 0

5 0

Thanks.

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

请先登录，再进行评论。

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

Answer 1

Voss 2022-8-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1783380-lookup-values-in-ranges-of-a-table-and-copy-a-corresponding-output-value-in-another-table#answer_1030715

B.mat
A.mat

A = load('A')
A = struct with fields:
    Events: [104×2 table]
B = load('B')
B = struct with fields:
    Events: [3×1 table]
[~,idx] = ismember(B.Events.Lap,A.Events.Lap);
result = A.Events(idx,:)
result = 3×2 table
    Lap    Var
    ___    ___

     1      1 
     2      0 
     5      0 

11 个评论
显示 9更早的评论隐藏 9更早的评论

Voss 2022-8-28

B.mat
A.mat

A = load('A');
B = load('B');
% for demonstration, I make some additional 
% random variables in A.Data:
N = size(A.Data,1);
A.Data.Var3 = randi(100,N,1);
A.Data.Var4 = randi(100,N,1);
A.Data.Var5 = randi(100,N,1);
disp(A.Data)
    Lap    Var    Var2    Var3    Var4    Var5
    ___    ___    ____    ____    ____    ____

    7       1      94      46      78 
    2       2      31      85      53 
    5       3      49      11      14 
    6       4      77      61      81 
    1       5      93      49      73 
    4       6      16      19      62 
    1       7      40      11      53 
    5       8      28      10      43 
    9       9      28      68      55 
    5      10      72      42      91 
    1      11      43       7      84 
    6      12      67      82      65 
    0      13      99      27      58 
    8      14      95       9      43 
    7      15      12     100      29 
    6      16      13      38      57 
    0      17      67      69      79 
    6      18      95      68      19 
    5      19      54      35      26 
    3      20       6      90      72 
    9      21      39      30      28 
    6      22      17      35      88 
    8      23       2      77       9 
    0      24     100      47      61 
   10      25      18      85      29 
    0      26      62      51      88 
    5      27      66      99      58 
   10      28      48      41      28 
    4      29      92      73      20 
    4      30      18      49      32 
    0      31      75      12      23 
    0      32      16      20      81 
    3      33       3      44      73 
    5      34      58      78      27 
   10      35       9      36       7 
    8      36      79      30      21 
    8      37      91      29      31 
    3      38      96      90      10 
   10      39      61      87      98 
    5      40      74      10      32 
    5      41      92      11      77 
    4      42      17      92      60 
    0      43      24      54      98 
    9      44      16       4      32 
    6      45      63      98      54 
    6      46     100      81      39 
    5      47      14      83      26 
   10      48      15      63       8 
    5      49      98      98      50 
    8      50      97      27      82 
    8      51      78       8      22 
    9      52      40      29      82 
    4      53      67      62      43 
    5      54      68      46      49 
    5      55      92      93      74 
    8      56      53      40      16 
    2      57      49      27      52 
    8      58      29      89      41 
    8      59      21      41       6 
   10      60      90      33      42 
    4      61      79      77      88 
    8      62       6       2      10 
    3      63      80      60      37 
    6      64      75      85      48 
    1      65      81      18      29 
    4      66      80      28      72 
    9      67      77      39      76 
    2      68      27      49      66 
    3      69      88      63      46 
    3      70      73      38      33 
    9      71      93      12      16 
    2      72      33      91       4 
    5      73      52      86      81 
    8      74      86      22      74 
    3      75      71      62      86 
    7      76      33      95      28 
    2      77      71      82      99 
    1      78      53      69      54 
    2      79      28      52      36 
    6      80      68      40      31 
    6      81      36      41      83 
    6      82      99      77      57 
    0      83      71      60      97 
    5      84      51      39      18 
    9      85      26      71      58 
    0      86      28      88      29 
    8      87      79      46      87 
    2      88       1      90      46 
    5      89      98      41      84 
    5      90      50      49      15 
    8      91      40       8      65 
    7      92      34      47       4 
    4      93      57       7      89 
    6      94      24      78      71 
    9      95      36      20      79 
    7      96       5      32      86 
    5      97      80       5      13 
   10      98       1      90      28 
    3      99      30      64      90 
    6     100       7      54      13 
    1     101      21      26      98 
    9     102      63       6      79 
    4     103      80      93      26 
    8     104      93      18      94 
% now include all variables from A.Data in B.Find 
% (initialized to zero in B.Find):
N = size(B.Find,1);
var_names = A.Data.Properties.VariableNames;
B.Find{:,var_names(2:end)} = zeros(N,numel(var_names)-1);
disp(B.Find)
    Lap    Var    Var2    Var3    Var4    Var5
    ___    ___    ____    ____    ____    ____

    0      0       0       0       0  
    0      0       0       0       0  
    0      0       0       0       0  
% now set the variables in B.Find equal to their values in A.Data,
% where the row from A.Data that's used is the row with minimum 
% 'Var', among the first three rows of each given 'Lap' in A.Data:
for ii = 1:N
    idx = find(A.Data.Lap == B.Find{ii,'Lap'});
    if numel(idx) > 3
        idx(4:end) = [];
    end
    [~,min_idx] = min(A.Data{idx,'Var'});
    B.Find(ii,2:end) = A.Data(idx(min_idx),2:end);
end
B.Find
ans = 3×6 table
    Lap    Var    Var2    Var3    Var4    Var5
    ___    ___    ____    ____    ____    ____

    2       2      31      85      53 
    0      13      99      27      58 
    3      75      71      62      86 