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

3 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, :);
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, :);
for K = 1 : num_uniq
this_subset = subsets{K};
plot(this_subset.Time, this_subset.CacheHitRatio, 'DisplayName', uniq_node{K});
hold on
hold off
xlim auto; ylim auto
legend show

Sign in to comment.

More Answers (0)


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!