fillmissing function with makima method
显示 更早的评论
Hi!
I'm trying to fill the missing data with fillmissing function and makima method for gaps that are less than 12000 samples. This is the code I used:
trial8 = fillmissing(trial8,'makima','MaxGap',12000);
It removes NaNs, but for some reason gives weird and wrong negative values. I'm attaching the screens, first is my data before filling and the second after filling. Could somebody tell me what do I do wrong?
4 个评论
KSSV
2023-5-23
Attach your data and full code.
Matt J
2023-5-23
In what way are the filled values "wrong"? Your original data has a very sharp downward drop.The fillmissing operation seems to extend ithe drop very smoothly.
katie_km
2023-5-23
Steven Lord
2023-5-30
Is that drop in some sense "real" or is it an artifact of some issue with the data gathering process? Do you really want to use fillmissing here or would either rmmissing or rmoutliers be a better match for what you're hoping to do with this data?
If I was collecting data from a thermometer and it accidentally kept recording once I took it from under my tongue and put it back in its case, that data shouldn't be filled it should be removed entirely.
采纳的回答
Star Strider
2023-5-23
0 个投票
Thje 'makima' method is likely best for filling NaN gaps in varying data. Yours appear to be relatively constant, other than for that one instance.
See if using 'nearest' instead will improve the result. .
4 个评论
Hi, @Star Strider! Thank you for your suggestion! Using 'nearest' worked a little bit better, the drop didn't go to the negative values, but it is still there. Do you have any other suggestions on how to get rid of it?
As always, my pleasure!
I’m not certain what your data are, so I’m not certain how to fill the gap (if you want to completely get rid of the ‘dip’ in the data). One option might be to find the value of the ends of the NaN data (this whould be relatively straightforward), then fill it —
x = 0:16;
y = 5+rand(size(x));
y([12 15]) = rand(2,1);
y(13:14) = NaN;
figure
plot(x, y)
ylim([0 6])
nanidx = find(isnan(y)) % Indices Of 'NaN' Values
to_fill = nanidx + [-2 2] % Extend To Reliable Data (This May Require Experimentation)
to_fill_idx = to_fill(1) : to_fill(2) % Create Continuous Index Range
gap = interp1(x(to_fill), y(to_fill), x(to_fill_idx)) % Interpolate (Using 'linear' Here)
y(to_fill_idx) = gap; % Assign 'y' Range
figure
plot(x, y) % Plot Result
ylim([0 6])
An approach similar to this would likely work with your data. There might be easier ways to accomplish this, however none come to mind just now.
.
Star Strider
2023-5-30
As always, my pleasure!
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Interpolation 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
