replacing a row of an existing table with nans

11 次查看（过去 30 天）
Danielle Leblance
Danielle Leblance 2017-11-9
回答： Peter Perkins 2017-11-16
if t is a table with a mix of numeric columns and text columns, how can i replace a specific row (let us say row 20 of t) with nan values? I tried
t(20,:)=nan;
t{20,:)=nan;
but both failed.

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

回答（2 个）

Walter Roberson
Walter Roberson 2017-11-9
NaN cannot be stored in the text columns.
Depending upon your needs, it might help to look at https://www.mathworks.com/help/matlab/matlab_prog/clean-messy-and-missing-data-in-tables.html
Peter Perkins
Peter Perkins 2017-11-16
In recent versions of MATLAB, you can do this:
>> t = table([1;2;3],["a";"b";"c"])
t =
3×2 table
Var1 Var2
____ ____
1 "a"
2 "b"
3 "c"
>> t{2,:} = missing
t =
3×2 table
Var1 Var2
____ _________
1 "a"
NaN <missing>
3 "c"

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by