import pandas as pd
df = pd.DataFrame({
'name':['john','mary','paul'],
'age':[30,25,40],
'city':['new york','los angeles','london']
})
df
age | city | name | |
---|---|---|---|
0 | 30 | new york | john |
1 | 25 | los angeles | mary |
2 | 40 | london | paul |
df.replace([25],40)
age | city | name | |
---|---|---|---|
0 | 30 | new york | john |
1 | 40 | los angeles | mary |
2 | 40 | london | paul |
df.replace({
25:26,
'john':'johnny'
})
age | city | name | |
---|---|---|---|
0 | 30 | new york | johnny |
1 | 26 | los angeles | mary |
2 | 40 | london | paul |
df.replace('jo.+','FOO',regex=True)
age | city | name | |
---|---|---|---|
0 | 30 | new york | FOO |
1 | 25 | los angeles | mary |
2 | 40 | london | paul |
df = pd.DataFrame({
'name':['john','mary','paul'],
'num_children':[0,4,5],
'num_pets':[0,1,2]
})
df
name | num_children | num_pets | |
---|---|---|---|
0 | john | 0 | 0 |
1 | mary | 4 | 1 |
2 | paul | 5 | 2 |
df.replace({'num_pets':{0:1}})
name | num_children | num_pets | |
---|---|---|---|
0 | john | 0 | 1 |
1 | mary | 4 | 1 |
2 | paul | 5 | 2 |