Create a new table from a plot constructed from data points
60 views (last 30 days)
Show older comments
Dear all,
Reading an excel sheet with around 24000 data points, I made a plot. Now I would like to create a new table from this plot with a user-defined interval, let say with only 10 data points. Is it possible to do so in Matlab?
Many thanks in advance.
Bhattarai
0 Comments
Answers (2)
Voss
on 17 Jan 2022
% a table with 1000 rows:
t = table((1:1000).',2*(1:1000).'+100,'VariableNames',{'x' 'y'})
% user-defined interval over x:
x_limits = [200 209];
% logical index saying whether each x in the table is within the interval:
idx = t.x >= x_limits(1) & t.x <= x_limits(2);
% new table with x and y but only where x is within the interval:
new_t = table(t.x(idx),t.y(idx),'VariableNames',{'x' 'y'})
See Also
Categories
Find more on Line 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!