Printing rows from excel sheet based on two column values
2 次查看(过去 30 天)
显示 更早的评论
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/961455/image.png)
0 个评论
采纳的回答
KSSV
2022-4-12
T = readtable(myfile) ;
idx = matches(T.FaceDescr,'appFace://') & matches(T.Type,'InInterests') & (T.FaceID == 258) ;
T(idx,:)
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!