How to determine mean values for a table containing nanovalues (where mean values of parts of the rows should be considered individually)

Question

BingoIngo 2019-5-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461951-how-to-determine-mean-values-for-a-table-containing-nanovalues-where-mean-values-of-parts-of-the-ro

回答： Jyotish Kumar 2019-5-22

I have a table with a lot of rows and a few cols. I want to split the rows for one cols into 10parts in order to analyze the different mean value of each of the 10 parts separately. Unfortunately in some of the 10parts are NaN values. But the following code can't ignore the NaN values, although i am using the nanmean command and thus, for some parts the nanmean value is = NaN^. Anyone know the reason for this happening? Or can someone recommand me a different syntax/code?

Here's my code:

for i=1:10 % for loop to determine 10 mean values %462120 = data collected in 2mins

k(i)=nanmean(Tabk(Tabk>0+(i-1)*462120 & Tabk<i*462120));

s(i)=nanmean(Tabs(Tabs>0+(i-1)*462120 & Tabs<i*462120));

i=i+1;

end

% to calculate the difference

K = transpose(k); %Transponierter Vektor v

S = transpose(s);

D = K-S;

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

请先登录，再进行评论。

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

Answer 1

Jyotish Kumar 2019-5-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461951-how-to-determine-mean-values-for-a-table-containing-nanovalues-where-mean-values-of-parts-of-the-ro#answer_376116

Hi,

I understand that you are trying to find mean ignoring NaN values. ‘nanmean’ is the right syntax for this purpose and returns mean value ignoring NaN. But it returns NaN if all the elements in the matrix are NaN.