Search for a value in a table and get the corresponding value from the 2nd column

Question

Max1234 2023-4-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1939814-search-for-a-value-in-a-table-and-get-the-corresponding-value-from-the-2nd-column

评论： Star Strider 2024-1-20

Hi guys,

I have a table of values and would like to search for a value and then get the corresponding value from the 2nd column. Can anyone help me with this problem?

Thanks a lot!

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-4-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1939814-search-for-a-value-in-a-table-and-get-the-corresponding-value-from-the-2nd-column#answer_1206964

在 MATLAB Online 中打开

If you are searching for an exact match, try something like this —

Col1 = linspace(0, 10, 21).';
Col2 = randn(numel(Col1),1);
T1 = table(Col1,Col2)
T1 = 21×2 table
Col1Col2_____________

      0       0.38307
    0.5      -0.72796
      1        1.4325
    1.5       -2.2297
      2       -0.3249
    2.5     -0.065509
      3       -1.1099
    3.5        1.7075
      4      -0.86512
    4.5     -0.028325
      5        1.4587
    5.5       -2.3416
      6        0.2667
    6.5      0.060289
      7        1.6819
    7.5      0.077313
Val = 3;
Result = T1{Col1==Val,:}
Result = 1×2
    3.0000   -1.1099

Other options, for example using ismember or ismembertol are also useful.

Much depends on the table and what you want to do. This is simply an illustration of the most obvious approach.

.

2 个评论
显示无隐藏无

drummer 2024-1-20

@Star Strider, how would I do that but rather comparing cells?

Star Strider 2024-1-20

If the data are in a cell array, use cellfun with the appropriate function (for example isequal) or whatever is appropriate for your data (for example strcmp or its friends).

请先登录，再进行评论。