Clear Filters
Clear Filters

Using Diff() with NaN values

24 views (last 30 days)
david crowley
david crowley on 2 Apr 2021
Edited: david crowley on 3 Apr 2021
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 Comment
david crowley
david crowley on 3 Apr 2021
Edited: david crowley on 3 Apr 2021
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);

Sign in to comment.

Answers (1)

Sulaymon Eshkabilov
Sulaymon Eshkabilov on 2 Apr 2021
You can substitute all 'nan' values with 0's by locating them via isnan() and then substituting.
  1 Comment
david crowley
david crowley on 3 Apr 2021
This doesn't work with timeseries though?

Sign in to comment.

Categories

Find more on Price and Analyze Financial Instruments in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!