Answers for "pandas replace column values from another dataframe"

20

replace column values pandas

df['column'] = df['column'].str.replace(',','-')
df
Posted by: Guest on February-25-2020
3

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')
Posted by: Guest on November-19-2020
12

replace values of pandas column

df.loc[df['column'] == 'column_value', 'column'] = 'new_column_value'
Posted by: Guest on June-26-2020
1

pandas replace data in specific columns with specific values

### replace one value ###
df["column"].replace("US","UK") # you can also use numerical values
### replace more than one value ###
df["column"].replace(["man","woman","child"],[1,2,3]) # you can also use numerical values
#   man ==> 1
# woman ==> 2
# child ==> 3
Posted by: Guest on September-22-2021

Code answers related to "pandas replace column values from another dataframe"

Python Answers by Framework

Browse Popular Code Answers by Language