how can I select rows data from imported file
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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'.
0 commentaires
Réponses (1)
KSSV
le 27 Juin 2019
T = readtable(myfile) ;
idx = contains(T.CATE,'MODEL') ; % also have a look on strcmp
T(idx,:)
3 commentaires
Sura Raya
le 27 Juin 2019
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.
Voir également
Catégories
En savoir plus sur Data Import and Analysis dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!