MATLAB: How to extract data with respect to certain non numeric values

extractionnon numeric

I have a csv file, which have numeric and non numeric columns. e.g the first, second and fourth column has numbers and the third column has letters i.e C,S,CA. I have imported the file and sorted the third (non-numeric) column so all the C, CA and S values are listed together. How can I extract rows of data that are associated with 'CA'? Thanks

Best Answer

Use readtable() to read your data into a table. Then use ismember() to find out which rows have CA in them, then use that to filter the rows. If you don't understand, then attach your data (csv file).

Related Solutions

MATLAB: Run a function a few times with always different data? How to

Use a for loop to loop through each row, then save the result as a matrix.

Hypothetical question, so hypothetical solution:

data = xlsread( ... );          % ‘data’ = (5x6) matrix
func = @(vars) var(1) + var(2) + var(3) + var(4) + var(5);
for k1 = 1:5
    result(k1,:) = [data(k1,1) func(data(k1,2:6))];
end

MATLAB: How to select certain data from .txt file

Probably the easiest, assuming your text file format is straightforward to decode:

filecontent = readtable('c:\somewhere\somefile.txt');  %readtable should be able to figure out the format on its own
filteredcontent = filecontent(filecontent{:, 3} == 0, :);  %keep content where 3rd column is 0
writetable(filteredcontent, 'c:\somewhere\newfilename.txt');  %and save

Best Answer

Related Solutions

MATLAB: Run a function a few times with always different data? How to

MATLAB: How to select certain data from .txt file

Related Question