interpolating the NaNs in Cell array - 180x1

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

Answer 1

[KSSV]

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)) ; 

[ANIL TUNCAY]

%% 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]

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]

thank you for the help in advance by the way

Answer 2

[Bruno Luong]

y = fillmissing(y,'linear')

[ANIL TUNCAY]

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]

thank you for the help in advance by the way