replacing a row of an existing table with nans
    7 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!

