How to select one column value and the values associated in that row and plot

2 views (last 30 days)
Hi everyone,
I have a table with 1416 rows and 5 coulmns. So, for every time instant 0.5 - 29.5 I have the Node C1, C2, C3 and so on.. I want to get the data specific to C1 and time instants,cachehits and cachemisses, cachehitratio associated with it and plot a graph between Time and CacheHitRatio.

Accepted Answer

Walter Roberson
Walter Roberson on 12 Aug 2022
mask = ismember(YourTable.Node, 'C1');
subsetC1 = YourTable(mask, :);
  2 Comments
Sai Gautam Mandapati
Sai Gautam Mandapati on 12 Aug 2022
Edited: Sai Gautam Mandapati on 13 Aug 2022
Thank you so much! Based on your code I was able to generate the tables for C1, C2, C3,... So, now I want to plot all the tables Time vs CacheHitRatio in one graph. How can I do that? @Walter Roberson
Walter Roberson
Walter Roberson on 15 Aug 2022
uniq_node = unique(YourTable.Node);
num_uniq = length(uniq_node);
subsets = cell(num_uniq, 1);
for K = 1 : num_uniq
this_node = uniq_node{K};
mask = ismember(YourTable.Node, this_node);
subsets{K} = YourTable(mask, :);
end
for K = 1 : num_uniq
this_subset = subsets{K};
plot(this_subset.Time, this_subset.CacheHitRatio, 'DisplayName', uniq_node{K});
hold on
end
hold off
xlim auto; ylim auto
legend show

Sign in to comment.

More Answers (0)

Categories

Find more on 2-D and 3-D Plots in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!