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

3 次查看（过去 30 天）
alpedhuez
alpedhuez 2018-6-14
回答： 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 个评论
Paolo
Paolo 2018-6-14
编辑：Paolo 2018-6-14
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
?

请先登录，再进行评论。

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

回答（1 个）

Sindhu Yerragunta
Sindhu Yerragunta 2018-6-18
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

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by