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

19 Ansichten (letzte 30 Tage)
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

Akzeptierte Antwort

Image Analyst
Image Analyst am 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 Kommentare
shellmcg
shellmcg am 18 Apr. 2016
Thanks Image Analysis. I am getting an error with readtable function 'Undefined function 'readtable' for input arguments of type 'char'. I have loaded my data but I seem to be missing the column names so if I wanted CAs out of column 2 could I use col2=t.(:,2) instead of col2 = t.atom_types? Cheers
shellmcg
shellmcg am 18 Apr. 2016
Thanks Image Analysis. It worked!!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

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

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Data Types finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by