How to use linear interpolation to resample taken data?

Question

Petch Anuwutthinawin 2021-7-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/875618-how-to-use-linear-interpolation-to-resample-taken-data

编辑： Petch Anuwutthinawin 2021-7-10

forcetest.csv

I am given a .csv file with three columns. The second column is dependent upon the first and third columns. The first column is chanel used to measure, second is voltage, third is time when the data was taken. I need to use linear interpolation to resample the voltage in the second column for each sensor with respect to the sensor and time. Each sensor took 17seconds of data in 1/120 second increments. I have written code to do a double variable interpolation for the data to 'synchronise' the data. It does not work. Do I have to somehow seperate each sensor into its own command first?

A=csvread('forcetest.csv')
Chanel=A(:,1)';
Voltage=A(:,2)'; 
Time=A(:,3)';
T=linspace(1,17,2040);
C=linspace(0,3,2040);
[Ti,Chi]=meshgrid(T,C);
interp2(Time,Chanel,Voltage,Ti,Chi,'linear')

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/875618-how-to-use-linear-interpolation-to-resample-taken-data#answer_743748

在 MATLAB Online 中打开

Yes, you need to separate by channel. You can do that by using

A3d = reshape(A, 3, [], size(A,2));
Voltages = permute(A3d(:,2,:), [1 3 2]);
Times = permute(A3d(:,3,:), [1 3 2]);

Voltages and Times are now both 2D arrays in which the 3 columns correspond to the three channels.

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

Petch Anuwutthinawin 2021-7-10

编辑：Petch Anuwutthinawin 2021-7-10

在 MATLAB Online 中打开

How does this code fit into the main code? I thought something like this would work:

A=csvread('forcetest.csv');
A3d = reshape(A, 4, [], size(A,2)); %total time of recording?
Voltages = permute(A3d(:,2,:), [1 3 2]); %voltages seperated by column by chanel
Times = permute(A3d(:,3,:), [1 3 2]); %time seperated by chanel by column.
[Ti,Chi]=meshgrid(Times,A3d);
interp2(Times,Voltages,Ti,Chi,'linear');
%it dosent work?