Time align data-sets and get the missing values with interpolation

Question

sc1991 2018-5-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/401848-time-align-data-sets-and-get-the-missing-values-with-interpolation

评论： Peter Perkins 2018-8-24

Hello! Everyone,

I have two datasets which are logged at different rates. I am trying to time align these two data sets and after the data is time aligned i want to interpolate the and get the missing data values. I used a concept of timetables for time alignment but its taking forever to align that way. Can any one please suggest me how can i time align data and then fill up rest of missing data with the help of interpolation.

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KSSV 2018-5-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/401848-time-align-data-sets-and-get-the-missing-values-with-interpolation#answer_321291

You can do interpolation to get both the data sets to same time stamps. Read about interp1. After you get both the data's into same time, again you can use interp1 to get missing data. Or if you are using MATLAB 2016b or higher you can have a look on fillmissing to get the missing data.

3 个评论
显示 1更早的评论隐藏 1更早的评论

sc1991 2018-5-22

编辑：sc1991 2018-5-22

Hi! KSSV thanks for the answer but how to i interpolate to get the datasets to same time stamp. I mean wat i have been doing is lets say. I have dataset A and frequency is 1hz and then i have data set B frequency is 200ms.

So wat i do is i convert them to timetable Anew=timetable(1hz,A) and Bnew =timetable(200ms,B); then i use synchronize function newdata=synchronize(Anew,Bnew,'union');

Now this gives me a table with all the data from A and B and places with Nan where it could not find any data. I am guessing that fro these nans we can interpolate and fill teh data. but I am not too sure bout how that works. Please correct me if i am not doing any thing correct. This is my very first attempt and time aligning a data set and getting all the data points values with interpolation.

Also i would like to add after looking at the combined data after using the synchronize function. it looks like at some points we have to interpolate and at some we have to extrapolate. So please suggest me wat i can do here. Can the fillmissing function cover that aspect as well.

Matthew Hanks 2018-8-20

When you use the synchronize function, try instead using this: newdata=synchronize(Anew,Bnew,'Uniform','Interval',0.001);

Peter Perkins 2018-8-24

Matthew, I think you're looking at the timeSERIES synchronize method. sc1991 is using the timeTABLE method (I think).

sc1991, take a look at the documentation for synchronize, in particular, the METHOD. I imagine you want something like 'linear' or 'spline'. The default is 'fillwithmissing', which is where all those NaNs are coming from.

I imagine you probably also want to align one timetable to the other, not align them both to the union of times. Take a look at the NewTimeBasis input.

请先登录，再进行评论。