Replacing a specific string in dataframe text within columns Pandas

Question

I am currently having difficulty replacing a string in my pandas dataframe. So the string that I want to change is "private" -> "pte" and "limited" -> "ltd".

The table looks like:

Column: Company_Name
 1. XXXX private limited
 2. XX (private) limited
 3. yyy pte. limited

My code is:

df['company_name'].str.replace('.*private.+*','pte')
df['company_name'].str.replace('limited$','ltd)
print(df)

But I still get the exact same dataframe that I used pandas to read. Does anybody know why - I checked that I imported re?

str.replace is not inplace, it returns the modified Series/column, you need to assign back: df['company_name'] = df['company_name'].str.replace('.*private.+*','pte'), check the docs — EdChum
– EdChum, Commented Jul 11, 2017 at 10:04

Vaishali · Accepted Answer · 2021-09-24 15:45:22Z

2

Look:

import pandas as pd

index = [1,2,3]
columns = ['company_name']
data =  ['XXXX private limited','XX (private) limited','yyy pte. limited']
df = pd.DataFrame(data, index=index, columns=columns)

df['company_name'] = df['company_name'].str.replace('private','pte')
df['company_name'] = df['company_name'].str.replace('limited$','ltd')

Result:

 company_name
1  XXXX pte ltd
2  XX (pte) ltd
3  yyy pte. ltd

Now, you have to search how to remove (). symbols.

Have a great day,

MARCUS

edited Sep 24, 2021 at 15:45

Vaishali

38.5k5 gold badges62 silver badges88 bronze badges

answered Jul 11, 2017 at 11:51

Marcos Rusiñol

1051 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vaishali · Accepted Answer · 2021-09-24 15:42:20Z

1

str.replace is not an inplace operation, you have to assign the value back to df['company_name']

edited Sep 24, 2021 at 15:42

answered Jul 11, 2017 at 10:05

Vaishali

38.5k5 gold badges62 silver badges88 bronze badges

Comments

U13-Forward · Accepted Answer · 2021-09-24 04:11:48Z

0

The answer above is right. Another choice is that you can use of propety of inplace.

And the code should be:

df['company_name'].str.replace('.*private.+*', 'pte' , inplace = True)
df['company_name'].str.replace('limited$', 'ltd', inplace = True)

Thus the dataframe df can be updated immediately

edited Sep 24, 2021 at 4:11

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

answered Feb 2, 2018 at 18:10

huitailang

94 bronze badges

1 Comment

ti7 Over a year ago

Welcome to SO and thanks for contributing! However, I'm pretty sure this does not work: TypeError: replace() takes no keyword arguments. Additionally, you are missing a terminating '

Collectives™ on Stack Overflow

Replacing a specific string in dataframe text within columns Pandas

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related