Need to select specific values from text file depending of condition

Im a beginner in MATLAB and i have a text file with date,shot and experiment type in three columns with a massive number of rows. I need to create a separate array with only specific values of shot numbers(column 2) corresponding to experiment type -standard(column 3==standard). Please suggest how i should go about this. Thank you in advance.

[Rik]

How massive is massive? What fraction of the lines are going to be included in your end result?

[Abha Thazhathe Peedika]

The whole text file has over 20000 rows but only very few in between are "standard shots" which i need to extract.

[Mathieu NOE]

hello

please share an extract of the file (zip it if possible)

tx

Answer 1

[Lokesh]

Hi Peedika,

I understand that you have a text file with three columns: “date”, “shot”, and “experiment type” and you want to extract the “shot” numbers (column 2) where the “experiment type” is "standard" (column 3 == "standard").

To achieve this, you can follow these steps:

• Read the text file into a table using the “readtable” function.
• Filter the table based on the condition that the experiment type is "standard".
• Extract the shot numbers from the filtered table and store them in a separate array.

I have provided an example code snippet below that extracts specific values based on a condition:

% Set the path to the output text file 
filePath = 'path_to_text_file'; 

% Read the text file 
dataRead = readtable(filePath, 'Delimiter', '\t'); 

% Filter the data based on the experiment type ('standard') 
filteredData = dataRead(dataRead.experiment_type == "standard", :) 

% Extract the shot numbers from the filtered data 
shotNumbers = filteredData.shot 

Note: The assumed column names are 'date', 'shot', and 'experiment_type'.

You can refer to the below mentioned documentation to know more about the usage of “readtable”:

https://www.mathworks.com/help/matlab/ref/readtable.html

I hope you find this helpful.