I would like to execute this simple transformation in a more efficient way.
JavaScript
x
4
1
df["amount"] = df.apply(
2
lambda row: 500 if row.amount > 500 else row.amount, axis=1
3
)
4
Any ideas?
Advertisement
Answer
You can use pandas.Series.clip
:
JavaScript
1
2
1
df["amount"].clip(upper = 500)
2
or numpy.clip
:
JavaScript
1
2
1
np.clip(df["amount"], None, 500)
2