Extract data with specific range
显示 更早的评论
Hi all, I have this data with 3 columns and 96824 rows.
So, what i want is that only data between 12 to 15 value that represented in first line and correspoding the columns data.
for example: first rows can included data I want something like: 9.7; 1.2393; 59.7758.
Thank you so much
采纳的回答
Sushma Swaraj
2023-6-29
Hi, I got to understand that you are trying to get the subset of data where you would like to extract all the rows that contain value between 12 to 15 in the first COLUMN.
% Assuming your data is stored in a varibale named 'data':
% Extract the rows where the first column value is between 12 and 15
rowsNeeded = data(:,1) > 12 & data(:,1) < 15;
subsetData = data(rowsNeeded, :);
In the above code, data(:,1) represents the values in the first column of your data. The logical expression data(:, 1) > 12 & data(:,1) < 15 creates a logical index of rows where the first column values satisfy the condition between 12 to 15. Then, 'subsetData' stores the subset of data that meets this criterion, including all columns.
Hope it works!
更多回答（1 个）
Arya Chandan Reddy
2023-6-29
编辑：Arya Chandan Reddy
2023-6-29
Hi, as I can see you are trying to select rows with data within the specified range. Assuming that "first line" in the second sentence of your query means "first column" (i.e : select those rows whose first column lies between 12 and 15) you can try something like:
idx = A(:,1) > 12 & A(:,1) < 15; %corresponding indices are set to 1
extractedData = A(idx, :);
Hope it helps.
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
