How to synchronise two time series data with different sampling time in MATLAB?

Question

Arshey Dhangekar 2021-10-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1465229-how-to-synchronise-two-time-series-data-with-different-sampling-time-in-matlab

评论： Mathieu NOE 2021-11-5

sample file.xlsx

There are two sensor measured power and temperature and they have 4 mintutes sampling time difference. I want to synchronise time of power and temperature sensor data. How can I synchrnoise in csv data file? it because around 9440 obeservation the time difference between two devices become 10 minutes which created problem graph plotted. how can I use interp1 to sychnronise two different time data?

interp1(x,v,xq)

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

请先登录，再进行评论。

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

Answer 1

Mathieu NOE 2021-10-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1465229-how-to-synchronise-two-time-series-data-with-different-sampling-time-in-matlab#answer_801279

在 MATLAB Online 中打开

hello

see my suggeston below

the new common time vector is sampled with only N = 100 here , but you can adjust this to your own needs

clc
clearvars
T =readtable('sample file.xlsx','Format','auto');% Sr no_Temperature_sensor	Sr no_Power_sensor	Time_Temperature_sensor	Time_Power_sensor
Time_Temperature_sensor = str2double(T.Time_Temperature_sensor);
Time_Power_sensor = str2double (T.Time_Power_sensor);
Temperature_sensor = T.SrNo_Temperature_sensor;
Power_sensor = T.SrNo_Power_sensor;
% common time vector
common_time_min = max(min(Time_Temperature_sensor),min(Time_Power_sensor));
common_time_max = min(max(Time_Temperature_sensor),max(Time_Power_sensor));
N = 100;
common_time_vector = linspace(common_time_min,common_time_max,N);
% interpolate both data sets on common time vector
Temperature_sensor2 = interp1(Time_Temperature_sensor,Temperature_sensor,common_time_vector);
Power_sensor2 = interp1(Time_Power_sensor,Power_sensor,common_time_vector);
figure
plot(common_time_vector,Temperature_sensor2,common_time_vector,Power_sensor2);