Replacing NaN with last real value
2 views (last 30 days)
Diego Dranuta on 15 Jan 2020
Hi folks, I have hundreds of excel files in .csv format that I have to "clean" getting rid of all teh NaN values and replacin them by the last value.
I have tryied using the repnan function but somethinf seems wrong.
Here is what i did
ans(:,k) = repnan(ans(:,k),"previous")
Where ans is the double imported from excel. I am a beginner in matlab so no step is trivial to me.