linear fit for dates that do not have data

Suppose I have table such as
Date Visitors
-------------------------------------
"January 1" 10
"January 2"
"January 3" 15
"January 4"
"January 5"
"January 6"
"January 7" 18
"January 8"
I want to fill a linear trend for missing data
Date Visitors
-------------------------------------
"January 1" 10
"January 2" 12.5
"January 3" 15
"January 4" 15.75
"January 5" 16.5
"January 6" 17.25
"January 7" 18
"January 8"
but what I try to do here is to apply different fit function for different intervals: the fit function for January 1 and 3 is different from the one for January 3 to 7.

2 commentaires

Filling ending up with a duplicate value is not filling with linear trend.
alpedhuez
alpedhuez le 25 Nov 2020
Modifié(e) : alpedhuez le 25 Nov 2020
Corrected before I saw your post.

Connectez-vous pour commenter.

 Réponse acceptée

Ameer Hamza
Ameer Hamza le 25 Nov 2020
Modifié(e) : Ameer Hamza le 25 Nov 2020

0 votes

See fillmissing(): https://www.mathworks.com/help/matlab/ref/fillmissing.html. You can use the linear method to fill the values.

Plus de réponses (0)

Catégories

Produits

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by