在给定条件下替换 Pandas 系列中的值
问题描述:
这是一个微不足道的问题,我只是无法找到明确的答案:
This is a trivial question that I just have not been able to find a clear answer on:
我有一个系列对象:
random = pd.Series(np.random.randint(10, 10)))
我想用 0 替换所有大于 1 的值.我该怎么做?我试过了Random.replace() 没有成功,我知道你可以在 DataFrame 中轻松做到这一点,但我如何在 Series 对象中做到这一点?
I want to replace all values greater than 1 with 0. How do I do this? I've tried Random.replace() without success and I know you can do this easily in a DataFrame, but how do I do it in a Series object?
答
为什么不尝试设置 s[s >1] = 0
import pandas as pd
import numpy as np
# your data
# ============================
np.random.seed(0)
s = pd.Series(np.random.randn(10))
s
0 1.7641
1 0.4002
2 0.9787
3 2.2409
4 1.8676
5 -0.9773
6 0.9501
7 -0.1514
8 -0.1032
9 0.4106
dtype: float64
# ============================
s[s>1] = 0
s
0 0.0000
1 0.4002
2 0.9787
3 0.0000
4 0.0000
5 -0.9773
6 0.9501
7 -0.1514
8 -0.1032
9 0.4106
dtype: float64