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

10 次查看（过去 30 天）

shellmcg 2016-4-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278710-how-can-i-extract-data-with-respect-to-certain-non-numeric-values

评论： shellmcg 2016-4-18

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Image Analyst 2016-4-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278710-how-can-i-extract-data-with-respect-to-certain-non-numeric-values#answer_218305

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 个评论
显示 2更早的评论隐藏 2更早的评论

shellmcg 2016-4-18

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 2016-4-18