how can I select rows data from imported file

2019 6 27
1 个回答
更新时间：2019 6 27
2 次查看（30 天）

0 个投票

I have the following data from text file( Large data). I imported the file to matlab,
Small sample example of the data:
CATE VarName2 VarName3 VarName4 SATE
MODEL 2019 56 0 GPS
MODEL 2019 56 0 GPS
MODEL 2019 56 0 GPS
MEAS 2019 56 7650 GLO
M EAS 2019 56 7650 GPS
MEAS 2019 56 7650 GPS
MODEL 2019 56 0 GPS
MODEL 2019 56 0 GPS
MEAS 2019 56 7650 GPS
for example: from column (CATE) I want to choose the rows of MODEL only with out MEAS?
Also from column (SATE), if I want to choose all rows who has GPS only How I can do it?
The number of columns of 'MODEL row' are more than the number of columns in 'MEAS'.

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

回答（1 个）

KSSV
KSSV 2019-6-27

0 个投票

T = readtable(myfile) ;
idx = contains(T.CATE,'MODEL') ; % also have a look on strcmp
T(idx,:)

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Eman Saleem
Eman Saleem 2019-6-27
Thank you , I have now the following error ( I use your code)
Warning: Table variable names were modified to make them valid MATLAB identifiers. The original names are saved in the VariableDescriptions property.
KSSV
KSSV 2019-6-27
Attach your data. This can be resolved using options in readtable.
Sura Raya
Sura Raya 2019-6-27
i have same error, since we use (.out) not text or excel and columns dont have id ( CATE VarName2 VarName3 VarName4 SATE ) unless we import it in matlab, and readtable doesn't accept this type of files.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by