How can I plot multiple graphs from a name column (from Excel)

2 次查看(过去 30 天)
I want to plot multiple graphs from a 3-column spreadsheet from Excel.
Data is in this format:
(name); (x-value); (y-value);
ab-1 (~ 15 rows); x; y;
ab-2 (~ 15 rows); x; y;
ab-3 (~ 15 rows); x; y;
bc-1 (~ 15 rows); x; y;
bc-2 (~ 15 rows); x; y;
bc-3 (~ 15 rows); x; y;
cd-1 (~ 15 rows); x; y;
cd-2 (~ 15 rows); x; y;
cd-3 (~ 15 rows); x; y;
...
In this example, ab-1 represents one series of values. Where there is 15 data values in this series, one value by row. I would like each plot to have three series, represented by ab-1, ab-2 and ab-3 (So ~ 45 points, this is variable). How can I create multiple 3-series plots in MATLAB, where data is discredited by text in one column?

回答(1 个)

dpb
dpb 2018-6-23
Use readtable and then splitapply with the first column ID as grouping variable. I suggest turning it into categorical variable.

Community Treasure Hunt

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

Start Hunting!

Translated by