how to take out a specific row out of matrix
3 views (last 30 days)
Show older comments
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),:);
9 Comments
Image Analyst
on 20 Jul 2018
You do NOT have that matrix. Since your whos statement (assuming you did what James told you to do) didn't show them as variables, they're probably strings you got from Excel, which means that (the badly-named) a and n would have to be cell arrays. But the best, most modern way to do this now is with a table, something like (untested):
t = readtable(filename);
rowsToExtract = t{:, 2} == 2016
t2016 = t(rowsToExtract, :)
Accepted Answer
Image Analyst
on 20 Jul 2018
Attach your workbook. This can probably be done with tables:
t = readtable(filename);
rowsToExtract = t{:, 2} == 2016
t2016 = t(rowsToExtract, :)
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!