How to deal with table

Question

Ahmad Bayhaqi 2021-4-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/799332-how-to-deal-with-table

评论： Ahmad Bayhaqi 2021-4-13

Hi All, I have table, named as newT consisting of data value and position(latitude and longitude). What I want to do is:

How to delete empty cell in the table?

2. How to some operationss with them? each cell in each grid contains, I want to do sum operation (for example in the figure above: 16+57+202......) and average in each rows. Then, the calculation is the same for all grids.

Any helps is greaty appreciated.

Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/799332-how-to-deal-with-table#answer_672872

在 MATLAB Online 中打开

Removing entries that have empty exData:

mask = cellfun(@isempty, newT.exData);
newT(mask,:) = [];

If I understand correctly, each row of exData contains a cell array that contains cells with variable number of numeric entries. If so then

result1 = cellfun(@(C) cellfun(@sum, C), newT.exData, 'uniform', 0)

The result would be a cell array with one entry for each row in newT, and the entries would be vectors that were the sums. If you then wanted to take the average of those sums, then

result2 = cellfun(@mean, result1)

which would give you a numeric vector, one entry per row in newT.