Answers for "pandas add new column from another dataframe based on condition"

3

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')
Posted by: Guest on May-14-2020
0

Adding a new column in pandas dataframe from another dataframe with different index

merge(left, right, how='left', on=None, left_on=None, right_on=None,
      left_index=False, right_index=False, sort=True,
      suffixes=('_x', '_y'), copy=True)
Posted by: Guest on January-13-2021

Code answers related to "pandas add new column from another dataframe based on condition"

Python Answers by Framework

Browse Popular Code Answers by Language