Take a difference between the value and the lagged value dealing with NaN

Question

alpedhuez 2018-6-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405720-take-a-difference-between-the-value-and-the-lagged-value-dealing-with-nan

回答： Sindhu Yerragunta 2018-6-18

Suppose I have a table T such as

            Running Dist      Swimming Dist
---------------------------------------------
Jan 18       100                 10
Feb 18       80                  NaN
Mar 18       105                 12

I want to take n-month changes of Running distance and Swimming distance. (But skips when there are NaN.)

In case of n=1, it will be

        Running Dist      Swimming Dist
  ---------------------------------------------
Feb 18       -20                  NaN
Mar 18       +25                 NaN

Please advise.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Paolo 2018-6-14

编辑：Paolo 2018-6-14

在 MATLAB Online 中打开

What's the expected output for n = 2?

What about this table

             Running Dist      Swimming Dist
---------------------------------------------
Jan 18       100                 10
Feb 18       80                  NaN
Mar 18       105                 12
Apr 18       60                  NaN

?

请先登录，再进行评论。

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

Answer 1

Sindhu Yerragunta 2018-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405720-take-a-difference-between-the-value-and-the-lagged-value-dealing-with-nan#answer_325092

Hi Alpedhuez,

One suggestion would be cleaning your data before you calculate the difference. The following link elaborates on how to clean and standardize the missing data.

https://www.mathworks.com/help/matlab/matlab_prog/clean-messy-and-missing-data-in-tables.html

Hope this information helps.

-Sindhu