How can I calculate average from specific rows to another rows in a datatable?

2 次查看（过去 30 天）
Jonathan Bijman
Jonathan Bijman 2019-6-14
评论： Jonathan Bijman 2019-6-14
Dear community
I'm trying to design a script, in order to calculate the average from the 1st to 3rd row, then from the 4th to 6th and finally from the 7th to 9th row. The data has this structure:
Comment Cell Temperature
24-04-2019 A8 38,76736069
24-04-2019 A8 38,70141602
24-04-2019 A8 39,03113937
24-04-2019 C5 38,56953049
24-04-2019 C5 39,29491806
24-04-2019 C5 39,26194382
24-04-2019 E1 36,5252533
24-04-2019 E1 36,6241684
24-04-2019 E1 36,36038971
The temperature are in the 6th column. These data are like datatable. I have this script:
Clean=table2cell(datatable);
nrow = height(datatable);
lastidx = floor(nrow/3) * 3;
T_p = mean(reshape(datatable{1:lastidx,6}, 3, []));
T_C=T_p.';
But doesn´t work. How can I do?
Any for loop?
Help please.
Thank U
  6 个评论
显示 4更早的评论
Jonathan Bijman
Jonathan Bijman 2019-6-14
When I apply the last commands appears this error
mean(reshape(Clean,3,[])).'
Error using sum
Invalid data type. First argument must be numeric or logical.
Error in mean (line 127)
y = sum(x, dim, flag) ./ mysize(x,dim);
Error in Untitled2 (line 23)
mean(reshape(Clean,3,[])).'
mean([Clean(1:3) Clean(4:6) Clean(7:9)])
Error using sum
Invalid data type. First argument must be numeric or logical.
Error in mean (line 127)
y = sum(x, dim, flag) ./ mysize(x,dim);
Error in Untitled2 (line 23)
T=mean([Clean(1:3) Clean(4:6) Clean(7:9)])
I have 35 files with the structure I wrote at the beginning
I dunno what to do

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Identification 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by