how to find the corresponding elements in a matrix/excel

Question

Aiman Zara 2023-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1944269-how-to-find-the-corresponding-elements-in-a-matrix-excel

回答： Image Analyst 2023-4-10

FinalBookExcel.csv

Like if I name the Stage 2 then it should display the disease name(Alternaria leafspot) occuring at that stage. Sample file attached

2 个评论
显示无隐藏无

Image Analyst 2023-4-10

If you name what "the Stage 2"? Display the disease name how???? On a GUI? In the command window? In the workspace panel?

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

Aiman Zara 2023-4-10

编辑：Aiman Zara 2023-4-10

@Image Analyst In a given table, if I select any element and need to find a value related to that specific element from another row or coloumn, how would I do that? can you provide me a sample code of doing that?

the output should be displayed in the command window

请先登录，再进行评论。

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

Answer 1

Image Analyst 2023-4-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1944269-how-to-find-the-corresponding-elements-in-a-matrix-excel#answer_1213169

在 MATLAB Online 中打开

Try this:

t = readtable('FinalBookExcel.csv')
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
t = 5×3 table
    CottonStage    DiseaseSeverity            Disease        
    ___________    _______________    _______________________

    {'Stage1'}      {'harmful' }      {'Fusarium wilt'      }
    {'Stage2'}      {'harmful' }      {'Alternaria leafspot'}
    {'Stage3'}      {'Critical'}      {'Fusarium wilt'      }
    {'Stage4'}      {'Medium'  }      {'Fungal'             }
    {'Stage5'}      {'Medium'  }      {'worm'               }
% Lets specify row 2, column 1 and get the value there.
row = 2;
t21 = t.CottonStage(row)
t21 = 1×1 cell array
    {'Stage2'}
% Now let's get the "DiseaseSeverity" value for that same row
t22 = t.DiseaseSeverity(row)
t22 = 1×1 cell array
    {'harmful'}
% Now let's get the "Disease" value for that same row
t23 = t.Disease(row)
t23 = 1×1 cell array
    {'Alternaria leafspot'}