Clear Filters
Clear Filters

How to find specified data in table by reffers

6 views (last 30 days)
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

Accepted Answer

Dinesh
Dinesh on 6 Feb 2024
Edited: Dinesh on 6 Feb 2024
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 Comments
Arif
Arif on 6 Feb 2024
thank you so much for your help @Dinesh
thanks also for the reference @Stephen23

Sign in to comment.

More Answers (0)

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Tags

Products


Release

R2023b

Community Treasure Hunt

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

Start Hunting!