/Python/Pandas create a new column based on condition of two columns

Pandas create a new column based on condition of two columns

Pandas create new column conditional on other columns

# For creating new column with multiple conditions
conditions = [
    (df['Base Column 1'] == 'A') & (df['Base Column 2'] == 'B'),
    (df['Base Column 3'] == 'C')]
choices = ['Conditional Value 1', 'Conditional Value 2']
df['New Column'] = np.select(conditions, choices, default='Conditional Value 1')

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

Source: stackoverflow.com

Similar codes

0 vote299 views1 answer
How to extract field values in list from queryset in django
Python Django
19 votes267 views5 answers
Replace key of dictionary python
Python
11 votes254 views1 answer
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe2 in position 10: invalid continuation byte
Python
6 votes256 views2 answers
Decimal in python
Python
5 votes255 views1 answer
How to delete everything on a file python
Python
0 vote301 views1 answer
Https://practice.geeksforgeeks.org/problems/coin-change2448/1
Python
0 vote264 views2 answers
AttributeError: 'Series' object has no attribute 'toarray'
Python
0 vote234 views1 answer
No module named 'fastai'
Python
2 votes248 views1 answer
Module 'pygame' has no 'init' member
Python
0 vote281 views1 answer
Django x-frame-options allowall
Python Django