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

18 views (last 30 days)
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).

Sign in to comment.

More Answers (1)

Yuebin Zhou
Yuebin Zhou on 15 Apr 2016
  1 Comment
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!