Breaking News: Grepper is joining You.com. Read the official announcement!

replace multiple column values pandas

Add Answer

Horrible Hoopoe answered on October 5, 2020 Popularity 9/10 Helpfulness 3/10

answer replace multiple column values pandas

related replace multiple values in pandas column

related pandas changing multiple values in a column

related pandas change column value based on multiple condition

related pandas replace multiple values in column

related pandas .replace multiple values in column

replace multiple column values pandas

Comment

-1

import pandas as pd

df = pd.DataFrame([
	[4, -9, 8],
	[1, 2, -4],
    [2, 2, -8],
    [0, 7, -4],
	[2, 5, 1]],
	columns=['a', 'b', 'c'])

df = df.replace({'a':{1:11, 2:22}, 'b':{5:55, 2:22}})
print(df)

Popularity 9/10 Helpfulness 3/10 Language python

Source: pythonexamples.org

Tags: pandas python replace

Link to this answer
Share Copy Link

Contributed on Mar 18 2022

Horrible Hoopoe

0 Answers Avg Quality 2/10

Closely Related Answers

replace multiple values in pandas column

Comment

df = pd.DataFrame({'a':['Small', 'Medium', 'High']})

In [22]: df
Out[22]: 
        a
0   Small
1  Medium
2    High

[3 rows x 1 columns]

df.replace({'a' : { 'Medium' : 2, 'Small' : 1, 'High' : 3 }})

Popularity 10/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Oct 05 2020

Black Badger

0 Answers Avg Quality 2/10

pandas changing multiple values in a column

Comment

mapping_dict = {
    'Android': 'Android',
    'Chrome OS': 'Chrome OS',
    'Linux': 'Linux',
    'Mac OS': 'macOS',
    'No OS': 'No OS',
    'Windows': 'Windows',
    'macOS': 'macOS'
}

laptops['os'] = laptops['os'].map(mapping_dict)
print(my_series)

Popularity 9/10 Helpfulness 5/10 Language python

Source: app.dataquest.io

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Jul 25 2021

rudythealchemist

0 Answers Avg Quality 2/10

pandas change column value based on multiple condition

Comment

conditions = [
    df['gender'].eq('male') & df['pet1'].eq(df['pet2']),
    df['gender'].eq('female') & df['pet1'].isin(['cat', 'dog'])
]

choices = [5, 2]

df['points'] = np.select(conditions, choices, default=0)

Popularity 9/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Aug 05 2022

King Of Fools

0 Answers Avg Quality 2/10

pandas replace multiple values in column

Comment

# Specify Patterns to remove
removal_list = '|'.join(['\r\n','\r','\t','\n','>','<'])
# Replace each occurance with nothing ('') and replace the column
df['columnA'] = df['columnA'].str.replace(removal_list,'')

Popularity 8/10 Helpfulness 2/10 Language python

Source: Grepper

Tags: pandas python py

Link to this answer
Share Copy Link

Contributed on Sep 22 2022

Trained Tuna

0 Answers Avg Quality 2/10

pandas .replace multiple values in column

Comment

-1

df['column name'] = df['column name'].replace(['1st old value','2nd old value',...],['1st new value','2nd new value',...])

Popularity 9/10 Helpfulness 2/10 Language python

Source: datatofish.com

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Jan 26 2022

NotACoder

0 Answers Avg Quality 2/10

replace multiple column values pandas

Contents

More Related Answers

replace multiple column values pandas

Closely Related Answers

replace multiple values in pandas column

pandas changing multiple values in a column

pandas change column value based on multiple condition

pandas replace multiple values in column

pandas .replace multiple values in column

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.