MATLAB: How to take out a specific row out of matrix

row

Hello I have this matrix :

a = [john 2016;john 2015;mike 2016;leo 2018]

I only need information from 2016 in second column, like:

n = [john 2016;mike 2016]

I am using this code but it does not work. any help ? Thank you !

b = [2016];
n = a(ismember(a(:,2),b),:);

Best Answer

Attach your workbook. This can probably be done with tables:

t = readtable(filename);
rowsToExtract = t{:, 2} == 2016
t2016 = t(rowsToExtract, :)

Related Solutions

MATLAB: Loop to read files

To read all csv files one by one

files = dir('*.csv');
table_data = cell(1, numel(files));
for i=1:numel(files)
    filename = files(i).name;
    table_data{i} = readtable(filename);
end

To only read these specific files

range = 2010:1:2020;
table_data = cell(1, numel(range));
for i = 1:numel(range)
    filename = sprintf('data_%d.csv', range(i));
    table_data{i} = readtable(filename);
end

MATLAB: Match row column of matrix

A = [1  23
     2  54
     3 76
     4 67
     5 23];
 B = [4;3];
 
 result = A(ismember(A(:, 1), B), :)  %keep the rows of A whose 1st column is a member of B

Best Answer

Related Solutions

MATLAB: Loop to read files

MATLAB: Match row column of matrix

Related Question