Replacing NaN with last real value
7 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Diego Dranuta
am 15 Jan. 2020
Kommentiert: Asliddin Komilov
am 17 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
xlsread ECUSIMTEST0000-000-01.csv
for k=1:size(ans,2)
ans(:,k) = repnan(ans(:,k),"previous")
end
Where ans is the double imported from excel. I am a beginner in matlab so no step is trivial to me.
Thanks !!!
0 Kommentare
Akzeptierte Antwort
Star Strider
am 15 Jan. 2020
3 Kommentare
Asliddin Komilov
am 17 Jan. 2020
I have set of 25 variables (matrices), can I have repliced all zero value to NAN in all of the at once, without doing it for each of them separately?
thanks
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Creating and Concatenating Matrices finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!