python - Conditional Substitution of values in pandas dataframe columns -
suppose i've pandas dataframe column values age df.age = {25, 35, 76, 21, 23, 30}
i want inplace replace this:
if df.age >=25 , df.age <= 35: replace value 1 else: replace value 0
i've tried df[df.age >= 7.35 , df.age <= 7.45, 'age'] = 0 doesn't seem work.
you can create function check conditions, , apply dataframe:
def condition(value):     if 25 <= value <= 35:         return 1     return 0  # stealing sample @anandskumar because i'm lazy in [32]: df out[32]:     age 0   25 1   35 2   76 3   21 4   23 5   30  in [33]: df['age'] = df['age'].apply(condition)  in [34]: df out[34]:     age 0    1 1    1 2    0 3    0 4    0 5    1 or using 1 liner lambda:
df['age'] = df['age'].apply(lambda x: 1 if 25 <=  x <= 35 else 0) 
Comments
Post a Comment