Clear Filters
Clear Filters

Interpolating two different size of tables

1 view (last 30 days)
Table 1: Ts = [0.003,0.0033,0.0004,0.006.....] ; Torque =[10,20,30,40....]
Table 2 Ts1ms=[0.001,0.002,0.003,0.004,0.005......]; Torque=[????]
Expected Result
Table 3:
Ts1ms Torque
0,001 10
0,002 10
0,003 10
0.004 30
0.005 35
....
I have table 1 data. I need to find for Ts1ms data what is the torque
Based on table 2 I have to find the interpolated data from Table 1
Could someone help me with this ?
Thanks in advance
  2 Comments
Matt J
Matt J on 17 Aug 2020
When you say you have your data as tables, do you really mean tables?
rajasekar dhandapani
rajasekar dhandapani on 17 Aug 2020
yes i Meant table array... It can also be a matrix.

Sign in to comment.

Accepted Answer

KSSV
KSSV on 17 Aug 2020
REad about interp1.
Torque1ms = interp1(Ts,Torque,Ts1ms) ;
  6 Comments
rajasekar dhandapani
rajasekar dhandapani on 17 Aug 2020
Edited: rajasekar dhandapani on 17 Aug 2020
Please find the code below. ALso please find the attached data 'data.mat'
fs=1000; %sampling frequency
Ts=1/fs; %sampling time 1ms
ts=0.001:Ts:65.469; %adjusting the matrix length
X=ts*1000; %s to ms
Result=ts.'; %Transpose matrix
Result1=array2table(Result); % array to table conversion
b=Result1.Result;
New=interp1(Data.ts,Data.ENG_TRQ_AFTR_REDNm,b); %interpolated data
rajasekar dhandapani
rajasekar dhandapani on 18 Aug 2020
Any further leads would be appreciated :)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!