How to fill in gaps with reasonable values

2 次查看(过去 30 天)
Hi Guys, Please find attached my .xlsx file, the data in column 1 of my Excel file has different number of gaps (i.e 1 gap, 2 gaps, 3 gaps, 5 gaps, 6 gaps). I need help in filling the gaps with reasonable values. So, when I'm reading the Excel file on Matlab, the missing gaps become "NaN". My question is if there's a way to fill in the cells only when the number of gaps is <= 5. And just ignore those if the number of gaps is >5?

回答(1 个)

Image Analyst
Image Analyst 2015-11-2
If you have the Image Processing Toolbox, you can use regionfill().

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by