replacing a row of an existing table with nans

21 views (last 30 days)
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.

Answers (2)

Walter Roberson
Walter Roberson on 9 Nov 2017
NaN cannot be stored in the text columns.

Peter Perkins
Peter Perkins on 16 Nov 2017
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"

Tags

Community Treasure Hunt

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

Start Hunting!