Suppose you have a very large x, y data set where "x" is time and "y" is some known value. The time increment for "x" is 0.02 seconds. "y" is known at every 0.02 seconds. I would like to change the time increment to 0.010269 seconds and use the known "y" values to find the new "y" values for the 0.010269 increment based off of a linear interpolation between the known original "y" values.
MATLAB: How to create a new data set, from an existing data set, with a different time increment than the original
data setincrementinterpolationtime
Related Solutions
Yes, there is an example a little bit down the in the documentation for RETIME , under this heading:
Interpolate Timetable Data to Arbitrary Times
I've copied the relevant sample code here:
%%Make sample data
Time = datetime({'2015-12-18 07:29:53';'2015-12-18 08:00:00';... '2015-12-18 08:31:02';'2015-12-18 09:30:00'});Temp = [37.3;41.9;45.7;39.8];Pressure = [30.1;29.9;30.03;29.8];TT1 = timetable(Time,Temp,Pressure)%%Retime to 30 minute intervals
newTimes = [datetime('2015-12-18 07:30:00'):minutes(30):datetime('2015-12-18 09:30:00')];TT2 = retime(TT1,newTimes,'linear')As for the 'colored lines' problem, you may have to transpose (') your matricies. To see what I mean, try this:
t = [0:0.2:10]';x = sin(t);In the picture below I have imported the same data once as column vectors [t,x], and once as row vectors [t',x']. One plots the sine wave "correctly", and one plots "colored lines" (which is just each time sample value of the data plotted for the duration).
If this doesn't help, perhaps you could attach a representative sample of your data?
Best Answer