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

3 次查看（过去 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 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by