Insert NaN into specific values
1 view (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!