Replace NaN with next good value in a certain column of a table
17 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have T2.mat which is a table with 12 columns. I want to replace NaN in columns 5:7 (5 to 7) by exactly the next good value in each column. I don't want to replace NaN in other columns.
I searched a lot and tried hard to do this. I was read the question in the link below:
but I want to do this in just columns 5 to 7 and not for rest of the columns. I attached T2.mat if it's help
Does anyone know how I can do this?
Thank you,
Behzad
0 Kommentare
Akzeptierte Antwort
Guillaume
am 20 Dez. 2019
Bearbeitet: Guillaume
am 20 Dez. 2019
It's as simple as:
T2 = fillmissing(T2, 'next', 'DataVariables', {'lat', 'lon', 'station_elevation'})
or
T2 = fillmissing(T2, 'next', 'DataVariables', 5:7)
I recommend the first expression as it is clearer as to which variable is to be filled (and will work even if the order of the columns changes).
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu NaNs 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!