Pandas

Pandas (10)

Jun's N 2022. 7. 30. 19:57

How to keep only top 2 most frequent values as it is and replace everything else as ‘Other’?

# Input
np.random.RandomState(100)
ser = pd.Series(np.random.randint(1, 5, [12]))

# Solution
print("Top 2 Freq:", ser.value_counts())
ser[~ser.isin(ser.value_counts().index[:2])] = 'Other'
728x90