How do I convert table with embedded cell array into simple table.

8 Ansichten (letzte 30 Tage)
How do I convert this table
T =
1×2 table
RunDate GSWYield
______________ ______________
{723×1 double} {723×1 double}
into a 723x2 table.
Yes it seems it should be simple but for some reason all my attempts fail.
I am attempting to simply convert the figure from a graph into a simple table of values for one or all of the series.
open('Yielddata.fig')
a = get(gca,'Children');
xdata = get(a(10), 'XData');
ydata = get(a(10), 'YData');
Y_res = reshape(ydata,[],1);
X_res = reshape(xdata,[],1);
C = {X_res Y_res};
T = cell2table(C,'VariableNames',{'RunDate' 'GSWYield'})

Akzeptierte Antwort

Ernest Miller
Ernest Miller am 22 Sep. 2021
Simple Answer
a = get(gca,'Children');
RunDates = get(a(9), 'XData');
ylddata = get(a(9), 'YData');
gswdata = get(a(10), 'YData');
termdata = get(a(11), 'YData');
C = {RunDates' ylddata' gswdata' termdata'};
TERMYld = C{1,4};
GSWYld = C{1,3};
YLD = C{1,2};
RunDates = C{1,1};
T = table(RunDates,YLD,GSWYld,TERMYld);

Weitere Antworten (0)

Kategorien

Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange

Produkte


Version

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by