Replace NaN with next good value in a certain column of a table

1 次查看（过去 30 天）
BN
BN 2019-12-20
评论： BN 2019-12-20
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:
https://www.mathworks.com/matlabcentral/answers/337273-how-can-i-replace-nan-elements-with-the-nearest-value-in-the-same-column
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

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2019-12-20
编辑：Guillaume 2019-12-20
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).

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by