Answers for "multiply two columns in loop and assign to existing columns if value is null in pandas"

3

multiply column of dataframe by number

#Multiply the values of column_name by 100
df.column_name.mul(100)
Posted by: Guest on August-06-2021
2

pandas create a new column based on condition of two columns

conditions = [
    df['gender'].eq('male') & df['pet1'].eq(df['pet2']),
    df['gender'].eq('female') & df['pet1'].isin(['cat', 'dog'])
]

choices = [5,5]

df['points'] = np.select(conditions, choices, default=0)

print(df)
     gender      pet1      pet2  points
0      male       dog       dog       5
1      male       cat       cat       5
2      male       dog       cat       0
3    female       cat  squirrel       5
4    female       dog       dog       5
5    female  squirrel       cat       0
6  squirrel       dog       cat       0
Posted by: Guest on December-01-2020

Code answers related to "multiply two columns in loop and assign to existing columns if value is null in pandas"

Python Answers by Framework

Browse Popular Code Answers by Language