pandas create new column conditional on other columns

Talented Toucan answered on May 14, 2020 Popularity 10/10 Helpfulness 5/10

answer pandas create new column conditional on other columns

related Add new column based on condition on some other column in pandas.

related pandas create a new column based on condition of two columns

related pandas create new column based on other columns

pandas create new column conditional on other columns

Comment

# 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')

Popularity 10/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: conditional pandas python

Link to this answer
Share Copy Link

Contributed on May 14 2020

Talented Toucan

0 Answers Avg Quality 2/10

Closely Related Answers

Add new column based on condition on some other column in pandas.

Comment

# np.where(condition, value if condition is true, value if condition is false)

df['hasimage'] = np.where(df['photos']!= '[]', True, False)
df.head()

Popularity 10/10 Helpfulness 5/10 Language python

Source: www.dataquest.io

Tags: add

Link to this answer
Share Copy Link

Contributed on Aug 08 2021

LawlietL

0 Answers Avg Quality 2/10

pandas create a new column based on condition of two columns

Comment

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

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: multiple-conditions mult

Link to this answer
Share Copy Link

Contributed on Dec 01 2020

Courageous Cobra

0 Answers Avg Quality 2/10

pandas create new column based on other columns

Comment

import pandas as pd

# Create a sample DataFrame
data = {'A': [1, 2, 3],
        'B': [4, 5, 6]}
df = pd.DataFrame(data)

# Create a new column 'C' by summing values from columns 'A' and 'B'
df['C'] = df['A'] + df['B']

# Print the updated DataFrame
print(df)

Popularity 8/10 Helpfulness 2/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

pandas create new column conditional on other columns

Contents

More Related Answers

pandas create new column conditional on other columns

Closely Related Answers

Add new column based on condition on some other column in pandas.

pandas create a new column based on condition of two columns

pandas create new column based on other columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.