fill missing values inside a dataset that contains nan

Question

Reyasudin 2013-5-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/77280-fill-missing-values-inside-a-dataset-that-contains-nan

Hi all,

I have a dataset of some weather variables such as rainfall and solar radiation. But there are some missing values in the database. I am clueless on how to fill the missing values using interpolation method.

I cannot delete the entire row with Nans since it will affect the overall results.

I have tried to refer to some examples but still not working my dataset is called mersing which contains 1029 rows and 8 columns. The weather data start from column 5 up to column 8.

the dataset looks like this( station no, year, day, rainfall, windspeed, solarradiation, evaporation)

Here are sample of my code that I am currently working on which based on answer provided by Sven but still not working.

load mersing_data fulldata_mersing = mersing; for c = 5:size(mersing,2) % start loop from column 5 until all column nanRows = isnan(mersing(:,c)); nanRows = fullData_mersing(nanRows,c) == interp1(mersing(~nanRows,1), mersing(~nanRows,c), mersing(nanRows,1)); fulldata_mersing(nanRows,c) = interp1(mersing(~nanRows,1), mersing(~nanRows,c), mersing(nanRows,1), 'nearest','extrap'); end