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

Answer 1

[Sushma Swaraj]

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!

[Nyam Jargalsaikhan]

Thank you so much. It works.

Answer 2

[Arya Chandan Reddy]

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.