How can I extract data with respect to certain non numeric values

18 views (last 30 days)
shellmcg
shellmcg on 13 Apr 2016
Commented: shellmcg on 18 Apr 2016
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

Accepted Answer

Image Analyst
Image Analyst on 17 Apr 2016
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).
  4 Comments

Sign in to comment.

More Answers (1)

Yuebin Zhou
Yuebin Zhou on 15 Apr 2016
  1 Comment
shellmcg
shellmcg on 17 Apr 2016
Thanks Yuebin but I actually want to store all the data in the CA rows in a separate matrix

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!