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

2 Ansichten (letzte 30 Tage)
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.

Akzeptierte Antwort

Walter Roberson
Walter Roberson am 12 Aug. 2022
mask = ismember(YourTable.Node, 'C1');
subsetC1 = YourTable(mask, :);
  2 Kommentare
Sai Gautam Mandapati
Sai Gautam Mandapati am 12 Aug. 2022
Bearbeitet: Sai Gautam Mandapati am 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 am 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

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by