replace a column with another column in pandas code example

Example 1: change column value based on another column pandas

# Changes the 'is_electric' column based on value in the 'type' column
# If the 'type' column == 'electric' then the 'is_electric' becomes 'YES'
df['is_electric']= df['type'].apply(lambda x: 'YES' if (x == 'electric') else 'NO')

Example 2: replace one row with another in python

df.loc[(df.Event == 'Dance'),'Event']='Hip-Hop'
df

Example 3: replace value of dataframe with another column

df['col1'] = np.where(df['col1'] == 0, df['col2'], df['col1'])
df['col1'] = np.where(df['col1'] == 0, df['col3'], df['col1'])

Example 4: replace 3 column with another column pandas

df['B'] = df1['E']