Using Diff() with NaN values

2021 4 2
1 个回答
更新时间：2021 4 3
9 次查看（30 天）

0 个投票

I am trying to find the difference between rows using the diff() function. However, because the rows contain NaN values I am getting the following error.
'Check for missing argument or incorrect arugument data type in call to function diff'
The data is a timetable with weekly closing stock prices and I just need to calculate the difference in price between weeks.

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

david crowley
david crowley 2021-4-3
编辑：david crowley 2021-4-3
I've tried to use the following to replace the NaN values, which worked - but trying to use the diff() function in a timetable does not.
fillmissing(C,"constant",0);

请先登录，再进行评论。

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

回答（1 个）

0 个投票

You can substitute all 'nan' values with 0's by locating them via isnan() and then substituting.

类别

在 帮助中心 和 File Exchange 中查找有关 Time Series 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by