hours
0          12
1          19
2          22
3          12
4           8
5          24
6          19
7          22 
8          4
9          26

the above is my data, and i have created my DataFrame df as well. Im trying to create a condition where if the values are >= 24 they should essentially print 0, if not to print the value as it is. ive tried df.loc but it doesnt seem to work, it just prints the values again as it is ignoring the condition.

CodePudding user response：

You can use np.where:

df["hours"] = np.where(df["hours"] >= 24, 0, df["hours"])
df

Output

CodePudding user response：

Mask the hours columns:

df['hours'][df['hours']>=24]=0