Extract Data from Table by Data Values

Question

Sam P 2020-5-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/523852-extract-data-from-table-by-data-values

编辑： BhaTTa 2024-7-16，3:17

Hi all,

I am trying to extract rows matching one of multiple values but I am not sure which functions to use. I have a 9,857,445 x 3 table. The headers are in the 3 columns, and all 3 columns A,B, C, contain numerical data.

I am trying to extract based on data for the first column A. For example, I want to extract the rows that have the following values for A; A= 1, A=6, A=4 or A =12. Based on all the rows that match any of the possible listed values for A, I would like to create a new table Final Data, that only lists rows that match the given values for A. I am using 2015a.

Thanks for your help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

BhaTTa 2024-7-16，3:05

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/523852-extract-data-from-table-by-data-values#answer_1485828

编辑：BhaTTa 2024-7-16，3:17

在 MATLAB Online 中打开

You can achieve this by using logical indexing below is the implemetation:

% Example to create a sample table, replace this with your actual data loading
dataTable = array2table(randi(20, 9857445, 3), 'VariableNames', {'A', 'B', 'C'});
valuesToMatch = [1, 6, 4, 12];
% Logical indexing to find rows where column A matches any of the specified values
rowsToExtract = ismember(dataTable.A, valuesToMatch);
% Create the new table with the extracted rows
finalData = dataTable(rowsToExtract, :);
% Example: Save to a new file
writetable(finalData, 'finalData.csv');