PYTHON

replace column values pandas

df['column'] = df['column'].str.replace(',','-')
df

dataframe change specicf values in column

df['column name'] = df['column name'].replace(['old value'],'new value')

dataframe change column value

df["column1"].replace({"a": "x", "b": "y"}, inplace=True)

how to change values in dataframe python

energy['Country'] = energy['Country'].replace(['Afghanistan','Albania'],['Sa','lol'])

change value in dataframe

# change value in column_where_to_change and in the row where column_name == column_value
df.loc[df['<column_name>']=='column_value', '<column_where_to_change>'] = '<new_value>'

change value of column in pandas

# Importing the libraries
import pandas as pd
import numpy as np
  
# data
Student = {
    'Name': ['John', 'Jay', 'sachin', 'Geetha', 'Amutha', 'ganesh'],
    'gender': ['male', 'male', 'male', 'female', 'female', 'male'],
    'math score': [50, 100, 70, 80, 75, 40],
    'test preparation': ['none', 'completed', 'none', 'completed',
                         'completed', 'none'],
}
  
# creating a Dataframe object
df = pd.DataFrame(Student)
  
# Applying the condition
df.loc[df["gender"] == "male", "gender"] = 1