Replacing NaN with last real value
10 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Diego Dranuta
il 15 Gen 2020
Commentato: Asliddin Komilov
il 17 Gen 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 Commenti
Risposta accettata
Star Strider
il 15 Gen 2020
3 Commenti
Asliddin Komilov
il 17 Gen 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Creating and Concatenating Matrices in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!