Replacing values in a column with a conditional statement.

3 views (last 30 days)
Hi I am new to matlab and not so familiar with conditional statemet. In the data below, I want to change NEE value based on a condition: Accept the NEE value if NEE_fc == 0 or 1 and substitute NEE values with -9999 if NEE_fc is > 0 or 1. Help will be much appreciated.
Data looks like this
Date NEE NEE_fc
2018 -0.2 0
2018 0.2 1
2018 0.3 2
2018 -0.002 3
Desired result
Date NEE NEE_fc
2018 -0.2 0
2018 0.2 1
2018 -9999 2
2018 -9999 3

Answers (1)

Walter Roberson
Walter Roberson on 19 Jul 2022
mask = NNE_fc > 1;
NNE(mask) = -9999;

Categories

Find more on MATLAB in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!