Interpolating unequally spaced data
显示 更早的评论
Hey,
I have an excel file containing the data of a propeller showing u,v,w velocities wrt arrival time. But the data collected is unequally spaced. I would like to interpolate the whole data and have tried pchip for it but for some reason doesnt get the result. Can someone help me with this. I have attached the excel sheet for reference.
Thank you in advance
采纳的回答
Star Strider
2019-7-29
[D,S] = xlsread('Vinf9P12RPM2981K0I0B0V2.000001.xls','Group 2');
Fs = 1/0.4;
[D79,tr] = resample(D(:,7:9),D(:,2),Fs);
figure
plot(D(:,2), D(:,7:9), '+-')
grid
xlim([10 30])
title('Original Signal')
legend(S(7:9), 'Location','SE')
figure
plot(tr, D79, '+-')
grid
xlim([10 30])
title('Resampled Signal')
legend(S(7:9), 'Location','SE')
The original signal has a mean sampling frequency of 0.4063 s (median 0.3413 s) with a standard deviation of 0.2965 s.
This resamples it to a sampling interval of 0.4 s and a sampling frequency of 2.5 Hz.
4 个评论
Anisha Varughese
2019-7-29
Star Strider
2019-7-29
My pleasure.
Your ‘workbook with multiple sheets’ would have to read and resample each sheet separately. If you do that in a loop, you will need to save the results in a cell array for each sheet. Also, you may need to change the column references if the columns are not the same on the other sheets.
With respect to the error, please copy all the red Error text from your Command Window and paste it to a Comment here. I have no idea what the error is otherwise, or how it might be resolved.
If my Answer helped you solve your problem, please Accept it!
Anisha Varughese
2019-7-29
Star Strider
2019-7-29
As always, my pleasure.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Multirate Signal Processing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
