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 中查找有关 Workspace Variables and MAT-Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by