How to perform simple interpolation of excel data on matlab?

2 次查看（过去 30 天）
Samantha Chong
Samantha Chong 2015-10-31
编辑： dpb 2015-10-31
Hi All, I've attached an image of how my .xlsx file looks like so it would be easier to explain my scenario: As you can see from the .xlsx, there are two columns, in the second column, there are some "blank cells", my objective is to perform interpolation in order to fill in the blank cells. I understand that linear interpolation can be performed if the NGap=1, but I really need help with the interpolation when NGap=2, 3, 4, 5. Thank you very much for your kind assistance :)

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

回答（1 个）

dpb
dpb 2015-10-31
编辑：dpb 2015-10-31
x=xlsread('yourExcelFile');
idx=isnan(x(:,2));
x(idx,2)=interp1(x(~idx,1),x(~idx,2),x(idx,1));
doc xlsread
doc interp1 % for details
--

类别

在 Help Center 和 File Exchange 中查找有关 Interpolation 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by