replacing a row of an existing table with nans

11 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"

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!