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

2021 9 21
1 个回答
回答已采纳
更新时间：2021 9 24
1 次查看（30 天）

0 个投票

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'})

请先登录，再回答此问题。

 采纳的回答

Ernest Miller
Ernest Miller 2021-9-22

0 个投票

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);

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

产品

版本

R2020b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by