interpolating the NaNs in Cell array - 180x1

2020 8 14
2 个回答
更新时间：2020 8 14
2 次查看（30 天）

0 个投票

I have a Cell vector - I have tried everything i am still getting an error, i am using matlab 2018b version, i am looking for the answer how to interpolate the NaNs in my cell array

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

回答（2 个）

KSSV
KSSV 2020-8-14

1 个投票

Let (x,y) be your data where x and y are n*1 arrays each. Say you have NaN's in y and you want to fill them.
idx = isnan(y) ;
y(idx) = interp1(x(~idx),y(~idx),x(idx)) ;

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

ANIL TUNCAY
ANIL TUNCAY 2020-8-14
%% Daily to Monthly Exchange Rate
numRawExchangeRate = table2array(rawExchangeRate);
dt = datetime(('01/01/2000') : datetime('31/12/2014'))';
tt = timetable(dt, numRawExchangeRate);
averageMonthly = retime(tt, 'Monthly');
monthlyExchangeRate = averageMonthly.numRawExchangeRate;
monthlyexchangeRate1 = cell2table(monthlyExchangeRate);
monthlyexchangeRate1 = monthlyexchangeRate1(1:end-1, :);
so this is my table but as soon as i try isnan i am getting -
Undefined function 'isnan' for input arguments of type 'table'.
ANIL TUNCAY
ANIL TUNCAY 2020-8-14
even I used ismissing but then it's not displaying the NaN it's showing whole data 0s meaning like there is no missing values
ANIL TUNCAY
ANIL TUNCAY 2020-8-14
thank you for the help in advance by the way

请先登录，再进行评论。

Bruno Luong
Bruno Luong 2020-8-14

1 个投票

y = fillmissing(y,'linear')

2 个评论
显示 无 隐藏 无

ANIL TUNCAY
ANIL TUNCAY 2020-8-14
i have tried this too but it is not changing with this - after doing this with different methods spline, previous etc. my data is still with the NaNs
ANIL TUNCAY
ANIL TUNCAY 2020-8-14
thank you for the help in advance by the way

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by