replacing a row of an existing table with nans
11 views (last 30 days)
Show older comments
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.
0 Comments
Answers (2)
Walter Roberson
on 9 Nov 2017
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
0 Comments
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"
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!