how to find the location of a specific element in a matrix or in a excel file

8 次查看（过去 30 天）
Aiman Zara
Aiman Zara 2023-4-9
评论： dpb 2023-4-10
i need to find the location of each element from the matrix/excel, how can i do it through matlab functions? if not possible with functions than how ca I do this with loop? please provide me a sample code to do so. Actually I think functions would work great for large data processing, loops will take more time. Attaching a sample file

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

采纳的回答

dpb
dpb 2023-4-9
Ran in:
What do you mean "to find the location of each element"? You mean just read the file, don't you; the location is really of very little significance for a regular file structure such as that file contains. I'd do something like
fn='https://www.mathworks.com/matlabcentral/answers/uploaded_files/1350129/example.xlsx';
tData=readtable(fn);
tData=convertvars(tData,@iscellstr,'categorical')
tData = 5×3 table
Stage health Object _____ _______ ______ 1 good chair 2 good table 3 bad fan 4 average bag 5 average laptop
  4 个评论
显示 2更早的评论
Aiman Zara
Aiman Zara 2023-4-10
Thankyou, it worked
however at first, This error showed up:
Undefined function 'matches' for input arguments of type 'string'.
Error in CSV (line 20)
[r,c]=find(matches(data,lookupValue)) % return locations
I then placed "strcmp" instead of matches,
[r,c]=find(strcmp(data,lookupValue)) % return locations
and then output dispalyed the rows and coloumn of the given name

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by