How to extract data from a table and input the wanted values into a new one?
1 回表示 (過去 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 件のコメント
dpb
2020 年 6 月 24 日
See last section on logical indexing @ https://www.mathworks.com/help/matlab/math/array-indexing.html
回答 (1 件)
Kavya Vuriti
2020 年 6 月 30 日
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
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Tables についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!