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

8 vues (au cours des 30 derniers jours)
Ernest Miller
Ernest Miller le 21 Sep 2021
Modifié(e) : Ernest Miller le 24 Sep 2021
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'})

Réponse acceptée

Ernest Miller
Ernest Miller le 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);

Plus de réponses (0)

Catégories

En savoir plus sur Data Type Conversion dans Help Center et File Exchange

Produits


Version

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by