How to organise cell array data into a single table

Coz
2017 8 1
1 个回答
更新时间：2017 8 2
5 次查看（30 天）

0 个投票

I have a 50x1 cell array (document attached) where each cell is a double array organised as follows: (T, Xi, Yi), where T is time, and Xi and Yi are coordinates of points in cell ix1. I want to organise all these data into a single table where T is in the first column, and the coordinate Xi and Yi are successively organised in the next columns. It would eventually look like that (T, X1, Y1, X2, Y2..., Xn, Yn). Any idea what I could try ? Thanks. Coz

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

回答（1 个）

Andrei Bobrov
Andrei Bobrov 2017-8-2
编辑：Andrei Bobrov 2017-8-2

0 个投票

N = ["X";"Y"] + string(1:numel(coordinates));
k = N(:)';
k = [{'T'},{k{:}}];
n = cellfun('size',coordinates,1);
[m,id] = max(n);
Gcell = num2cell(cell2mat([{coordinates{id}(:,1)},...
cellfun(@(x,y)[x(:,2:3);nan(m - y,2)],coordinates(:)',...
num2cell(n(:)'),'un',0)]),1);
T = table(Gcell{:},'v',k);

类别

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

标签

提问:

Coz
Coz
2017-8-1

编辑：

Andrei Bobrov
Andrei Bobrov
2017-8-2

Community Treasure Hunt

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

Start Hunting!

Translated by