How to retrieve the specific rows with all the columns in the dataset?

Hi everyone,

I have dataset which has 2832 rows and 4 columns. In this specific dataset I want to retrieve two rows, for example in the image provided for time instant 1.5 I want to get the two values of number of packets for both cachehits and cachemisses and further to the retrieved values I want to implement the formula of Hitratio = (Cachehits)/(CacheHits+CacheMisses) *100 and get the value of hit ratio.

Answer 1

[KSSV]

I hope the dataset is in the form of a table. So your table is going to be of size 2832x4.

idx = T.Time==1.5 ;
T1 = T(idx,:) ; 
T1.(1)
T1.Node
T1.Type

You can access your required from T1.

[Sai Gautam Mandapati]

Yes, it is in the form of a table. Thanks for your code suggestion @KSSV, when I implement this I'm getting all the nodes under the time instant 1.5 but here I'm looking for only C1 under 1.5. So, I have tried something like this but I'm not getting the required. Once I get the specific values I need to take the two specific packet values(cachehits and cachemisses) and calculate the ratio. Please advice me how I can get it.

T = readtable('myfile.xlsx')
idx = T.Time==1.5 ;
T1 = T(idx,:) ; 
T1.(1)
T1.Node,'C1'
T1.Type
T1.Packets

[KSSV]

It seems Cachehits is a string....how you can apply a formula on this?

[Sai Gautam Mandapati]

Yes, I cannot. For Packets I can apply right? Cachehits: Number of packets: 46, Cachemisses:Number of packets:2. So, 46/46+2 *100.

[KSSV]

Then you can use:

T1.Packets(1)/(T1.Packets(1)+T1.Packets(2))*100 

[Sai Gautam Mandapati]

Thanks, that works fine. I just have one more question. In the code above why have you declared T1. (1)? Can you please explain? Thank you so much.

[KSSV]

Read about table. If you want to access the first column, either you can use T.Time or T.(1). 1 stands for first column.