Printing rows from excel sheet based on two column values

2022 4 12
1 个回答
回答已采纳
更新时间：2022 4 12
5 次查看（30 天）

0 个投票

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

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

 采纳的回答

KSSV
KSSV 2022-4-12

0 个投票

T = readtable(myfile) ;
idx = matches(T.FaceDescr,'appFace://') & matches(T.Type,'InInterests') & (T.FaceID == 258) ;
T(idx,:)

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by