gap filling with liner interpolation

4 ビュー (過去 30 日間)

Binu 2019 年 10 月 15 日

コメント済み: Binu 2019 年 10 月 16 日

Hi,

I have a data file (attached) which I need to fill gaps (here in -9999) by liner interpolation. Could anyone please help me with this.

Many thanks

KALYAN ACHARJYA 2019 年 10 月 15 日

B Column?

Matt J 2019 年 10 月 15 日

Getting answers in the forum is generally more efficient if you attach attach relevant variables in a .mat file, rather than in .xlsx format.

Matt J 2019 年 10 月 15 日

編集済み: Matt J 2019 年 10 月 15 日

A=xlsread('data.xlsx'); 
I=A==-9999; 
J=find(~I); 
B=A; 
B(I)=interp1(J,A(J),find(I));

Binu 2019 年 10 月 16 日

Thanks Matt.It worked very well

MATLAB Mathematics Interpolation

Help Center および File Exchange で Interpolation についてさらに検索

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

Translated by