How to deal with table

3 次查看（过去 30 天）
Ahmad Bayhaqi
Ahmad Bayhaqi 2021-4-12
评论： 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:
  1. 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

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

采纳的回答

Walter Roberson
Walter Roberson 2021-4-12
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.
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2021-4-12
Have you considered
result3 = cellfun(@(C) cellfun(@mean, C), newT.exData, 'uniform', 0)
instead of having to count and divide yourself ?
... I am not clear as to what is being averaged, to be honest.
Ahmad Bayhaqi
Ahmad Bayhaqi 2021-4-13
Hi @Walter Roberson
Thank you so much for your great help.
I get inspiration from your answer.
Big thanks

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by