Using Diff() with NaN values

31 visualizaciones (últimos 30 días)
david crowley
david crowley el 2 de Abr. de 2021
Editada: david crowley el 3 de Abr. de 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 comentario
david crowley
david crowley el 3 de Abr. de 2021
Editada: david crowley el 3 de Abr. de 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);

Iniciar sesión para comentar.

Respuestas (1)

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

Iniciar sesión para comentar.

Categorías

Más información sobre Time Series Events en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by