How to extract data from a table and input the wanted values into a new one?

5 views (last 30 days)
I need to go through a table and find values >= 50, and then take those values, match them to their month, and create a new output containing the month

Answers (1)

Kavya Vuriti
Kavya Vuriti on 30 Jun 2020
Hi,
As mentioned, you can try using logical indexing. Assuming T is the table, first column in the table as month and second column in the table as values, here is the sample code:
monthsfromtable = table2array(T(:, 1)); % Convert months data in table to array
valuesfromtable = table2array(T(:, 2)); % Convert values data in table to array
idx = valuesfromtable >= 50; % Logical indexing to get values greater than or equal to 50
requiredValues = valuesfromtable(idx); % Values greater than or equal to 50
requiredMonths = monthsfromtable(idx); % Months with values greater than 50
valuesJan = requiredValues(strcmp(requiredMonths, 'Jan')); % Values in Jan month greater than 50

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by