Insert NaN into specific values
    3 views (last 30 days)
  
       Show older comments
    
    Augusto Gabriel da Costa Pereira
 on 7 Jan 2023
  
    
    
    
    
    Commented: Augusto Gabriel da Costa Pereira
 on 7 Jan 2023
            I use this code to insert all the lines in column 4 the numbers equal to 0 equal to NaN, but nothing happens.
That is, I want to insert NaN in all numbers equal to 0 of all rows in column 4.
Does anyone have an idea?
s=load('spi_dca.mat');
spi_dca = s.spi_dca;
mask=spi_dca(:,4)==0;
spi_dca(mask,4)=spi_dca(mask,4)==NaN;
0 Comments
Accepted Answer
  Arif Hoq
      
 on 7 Jan 2023
        try this:
s=load('spi_dca.mat');
spi_dca = s.spi_dca;
col4=spi_dca(:,4);
col4(col4==0)=NaN;
output=[spi_dca(:,[1 2 3]),col4];
0 Comments
More Answers (1)
  Voss
      
      
 on 7 Jan 2023
        s=load('spi_dca.mat');
spi_dca = s.spi_dca;
mask=spi_dca(:,4)==0;
spi_dca(mask,4)=NaN;
See Also
Categories
				Find more on Logical 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!

