Problem 652. Put two time series onto the same time basis

Created by Ned Gulley

Solve Later

{"relationships":[{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/document","targetMode":"","relationshipId":"rId1","target":"/matlab/document.xml"},{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/output","targetMode":"","relationshipId":"rId2","target":"/matlab/output.xml"}],"parts":[{"partUri":"/matlab/document.xml","relationship":[],"contentType":"application/vnd.mathworks.matlab.code.document+xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<w:document xmlns:w=\"http://schemas.openxmlformats.org/wordprocessingml/2006/main\"><w:body><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Use interpolation to align two time series onto the same time vector.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>This is a problem that comes up in</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/trendy/plots\"><w:r><w:t>Trendy</w:t></w:r></w:hyperlink><w:r><w:t> whenever you want to do mathematical operations on two trends (see for example the</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/trendy/plots/763\"><w:r><w:t>Ramen-to-Sushi Index</w:t></w:r></w:hyperlink><w:r><w:t>).</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Given two time series defined by the vector pairs (t1,d1) and (t2,d2), come up with a single new time vector tn such that (tn,d1n) and (tn,d2n) form consistent vector pairs.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Specifically, the new time vector should extend only to portions covered by both series (i.e. no extrapolation). Within this common interval, tn should contain all the time points from both time vectors. With this new time basis, use linear interpolation to generate two new data series.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Example 1:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[ t1 = [1 3 5]\n d1 = [2 4 2]\n t2 = [2 4]\n d2 = [1 5]\n\n tn = [2 3 4]\n d1n = [3 4 3]\n d2n = [1 3 5]]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Example 2:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[ t1 = [1 2 3 4 5]\n d1 = [2 3 5 6 3]\n t2 = [2 3.5 4 4.5 5 6]\n d2 = [3 9 8 2 0 1]\n\n tn = [2 3 3.5 4 4.5 5]\n d1n = [3 5 5.5 6 4.5 3]\n d2n = [3 7 9 8 2 0]]]></w:t></w:r></w:p></w:body></w:document>"},{"partUri":"/matlab/output.xml","contentType":"text/xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?><embeddedOutputs><metaData><evaluationState>manual</evaluationState><layoutState>code</layoutState><outputStatus>ready</outputStatus></metaData><outputArray type=\"array\"/><regionArray type=\"array\"/></embeddedOutputs>"}]}

Use interpolation to align two time series onto the same time vector.This is a problem that comes up in <a href="http://www.mathworks.com/matlabcentral/trendy/plots">Trendy</a> whenever you want to do mathematical operations on two trends (see for example the <a href="http://www.mathworks.com/matlabcentral/trendy/plots/763">Ramen-to-Sushi Index</a>).Given two time series defined by the vector pairs (t1,d1) and (t2,d2), come up with a single new time vector tn such that (tn,d1n) and (tn,d2n) form consistent vector pairs.Specifically, the new time vector should extend only to portions covered by both series (i.e. no extrapolation). Within this common interval, tn should contain all the time points from both time vectors. With this new time basis, use linear interpolation to generate two new data series.Example 1:<pre> t1 = [1 3 5]
 d1 = [2 4 2]
 t2 = [2 4]
 d2 = [1 5]</pre><pre> tn = [2 3 4]
 d1n = [3 4 3]
 d2n = [1 3 5]</pre>Example 2:<pre> t1 = [1 2 3 4 5]
 d1 = [2 3 5 6 3]
 t2 = [2 3.5 4 4.5 5 6]
 d2 = [3 9 8 2 0 1]</pre><pre> tn = [2 3 3.5 4 4.5 5]
 d1n = [3 5 5.5 6 4.5 3]
 d2n = [3 7 9 8 2 0]</pre>

Use interpolation to align two time series onto the same time vector.

This is a problem that comes up in <http://www.mathworks.com/matlabcentral/trendy/plots Trendy> whenever you want to do mathematical operations on two trends (see for example the <http://www.mathworks.com/matlabcentral/trendy/plots/763 Ramen-to-Sushi Index>).

Given two time series defined by the vector pairs (t1,d1) and (t2,d2), come up with a single new time vector tn such that (tn,d1n) and (tn,d2n) form consistent vector pairs.

Specifically, the new time vector should extend only to portions covered by both series (i.e. no extrapolation). Within this common interval, tn should contain all the time points from both time vectors. With this new time basis, use linear interpolation to generate two new data series.

Example 1:

t1 = [1 3 5]
 d1 = [2 4 2]
 t2 = [2 4]
 d2 = [1 5]

tn =  [2 3 4]
 d1n = [3 4 3]
 d2n = [1 3 5]

Example 2:

t1 = [1 2 3 4 5]
 d1 = [2 3 5 6 3]
 t2 = [2 3.5 4 4.5 5 6]
 d2 = [3 9   8 2   0 1]
 
 tn  = [2 3 3.5 4 4.5 5]
 d1n = [3 5 5.5 6 4.5 3]
 d2n = [3 7 9   8 2   0]

Solve

Solution Stats

629 Solutions
210 Solvers

Last Solution submitted on Sep 13, 2021

Last 200 Solutions

Problem Comments

3 Comments

3 Comments

@bmtran (Bryant Tran) on 3 May 2012

neat! i'd never used time series before

Jeffrey Daniels on 20 Nov 2013

I use timeseries all the time but don't usually use objects. Obviously using object oriented commands is much faster than more manual methods.

Aamod Garg on 26 Jul 2018

https://www.mathworks.com/matlabcentral/cody/problems/44699-prime-product

I created this problem. I think it should be in Indexing I.

Solution Comments

Solution 1578010

3 Comments

3 Comments

Md.Ismail Hosen on 8 Jul 2018

Undefined function 'fit' for input arguments of type 'double'. ??? What does it mean and how can i overcome it?

Ned Gulley on 9 Jul 2018

'fit' is not a function in basic MATLAB. You might try 'polyfit'.

Md.Ismail Hosen on 10 Jul 2018

I need to do piecewise interpolation.For this,as per my knowledge fit function is best. polyfit function doesn't perform piecewise interpolation. Anyway Thanks.

Solution 355927

1 Comment

1 Comment

Jeffrey Daniels on 20 Nov 2013

Argh!!! Those last two nodes are the hardest! Where are hey?

Solution 191478

1 Comment

1 Comment

Jeffrey Daniels on 20 Nov 2013

Oh Alfonso! What is your secret?!!

Solution 85538

1 Comment

1 Comment

Mark Syddall on 4 May 2012

This is flawed - but matches a previous '47'.

What happens if there is more than a single mismatched leading/trailing value? Say, using: t2 = [3 5 7 11 13 17]; in the third test?

Solution 85475

2 Comments

2 Comments

Mark Syddall on 4 May 2012

What happens if there is more than a single mismatched leading/trailing value?
Say, using:
t2 = [3 5 7 11 13 17];
in the third test?

Freddy on 4 May 2012

mea culpa, mea máxima culpa.

Problem Recent Solvers210

Problem Tags

interpolation time series

Community Treasure Hunt

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

Start Hunting!