Using Diff() with NaN values

37 次查看（过去 30 天）
david crowley
david crowley 2021-4-2
编辑： david crowley 2021-4-3
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 个评论
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 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Price and Analyze Financial Instruments 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by