Printing rows from excel sheet based on two column values
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Sai Gautam Mandapati
le 12 Avr 2022
Commenté : Sai Gautam Mandapati
le 12 Avr 2022
Good day,
I have an excel sheet with 7296 rows and 9 columns. So, I want my code to display all the rows based on 3 columns. For example I want all all the rows under FaceDescr:appFace:// ,Type: InInterests and FaceID:258. So, the further data goes in this way, I have second Node- leaf-2 with same FaceID, FaceDescr, Type and certain value for Packets. I tried creating 3 indexes and when I print them I get an error. I'm new to Matlab any help would be greatly appreciated.
Time Node FaceID FaceDescr Type Packets
0 commentaires
Réponse acceptée
KSSV
le 12 Avr 2022
T = readtable(myfile) ;
idx = matches(T.FaceDescr,'appFace://') & matches(T.Type,'InInterests') & (T.FaceID == 258) ;
T(idx,:)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!