How to fill in gaps with reasonable values

7 Ansichten (letzte 30 Tage)
Samantha Chong
Samantha Chong am 2 Nov. 2015
Beantwortet: Image Analyst am 2 Nov. 2015
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?

Melden Sie sich an, um diese Frage zu beantworten.

Antworten (1)

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

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by