How to find specified data in table by reffers
1 回表示 (過去 30 日間)
古いコメントを表示
What function that i can use to extract data in table by reference ? for example, i want to extract cell (3,4) to be a 1x1 double. But it must be specified by another cell data. For this case, I want to know the 'period' when 'stepnum' is 3. Thanks
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1609036/image.jpeg)
0 件のコメント
採用された回答
Dinesh
2024 年 2 月 6 日
編集済み: Dinesh
2024 年 2 月 6 日
Hello Arif,
To extract a specific cell from a table in MATLAB by reference to another cell's data, you can use logical indexing. For your example, to find the 'Period' when 'StepNum' is 3, here's a sample code:
% Loaded table is assumed to be 'Periodandfrequencies'
% First, find the row where 'StepNum' is 3
row = Periodandfrequencies.StepNum == 3;
% Then, extract the 'Period' from that row
periodValue = Periodandfrequencies.Period(row);
periodDouble = double(periodValue);
Here's a simplified 1 line code that also handles the case where the value for column "StepNum" is a string in single quotes:
periodWhenStepNumIsThree = Periodandfrequencies.Period(strcmp(Periodandfrequencies.StepNum, '3'));
The following documentation link might also help you:
8 件のコメント
Stephen23
2024 年 2 月 6 日
Of course you can use a text comparison function e.g. STRCMP or MATCHES or similar:
etc.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Get Started with MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!