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

Question

Cyrus Ahmadi 2020-6-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/554152-how-to-extract-data-from-a-table-and-input-the-wanted-values-into-a-new-one

回答： Kavya Vuriti 2020-6-30

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2020-6-24

See last section on logical indexing @ https://www.mathworks.com/help/matlab/math/array-indexing.html

请先登录，再进行评论。

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

Answer 1

Kavya Vuriti 2020-6-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/554152-how-to-extract-data-from-a-table-and-input-the-wanted-values-into-a-new-one#answer_458980

在 MATLAB Online 中打开

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