Replacing string value in a pandas dataframe column inside a list in Python

Question

I have a column in my dataframe like this:

  ___________________________
 |  columnn                  |
 ____________________________
 | [happiness#sad]           |
 | [happy ness#moderate]     |
 | [happie ness#sad]         |
 ____________________________

and I want to replace the “happy ness”,”happiness”,”happie ness” with 'happyness' . I am currently using this method but nothing is changed.

  string exactly matching 
  happy ness===> happyness
  happiness  ===> happyness
  happie ness===>happyness

I treid the below two approaches

1st Approach

   df['column']
   df.column=df.column.replace({"happiness":"happyness" ,"happy ness":"happyness" ,"happie ness":"happynesss" })

2nd Approach

   df['column']=df['column'].str.replace("happiness","happyness").replace(“happy ness”.”happyness”).replace(“happie ness”,”happynesss”)

Desired Output:

           ______________________
          |  columnn             |
           _______________________
          | [happyness,sad]      |
          | [happyness,moderate] |
          | [happyness,sad]      |
          _______________________

your columns have list?

anky
– anky

2019-06-03 12:26:12 +00:00
Commented Jun 3, 2019 at 12:26 — anky
– anky, Commented Jun 3, 2019 at 12:26
Yes I am having a list in a column

TRINADH NAGUBADI
– TRINADH NAGUBADI

2019-06-03 12:29:04 +00:00
Commented Jun 3, 2019 at 12:29 — TRINADH NAGUBADI
– TRINADH NAGUBADI, Commented Jun 3, 2019 at 12:29

Rakesh · Accepted Answer · 2019-06-03 12:55:29Z

1

This is one approach using replace with regex=True.

Ex:

import pandas as pd

df = pd.DataFrame({"columnn": [["happiness#sad"], ["happy ness#moderate"], ["happie ness$sad"]]})
data = {"happiness":"happyness" ,"happy ness":"happyness" ,"happie ness":"happynesss" }
df["columnn"] = df["columnn"].apply(lambda x: pd.Series(x).replace(data, regex=True).tolist())
print(df)

Output:

                columnn
0       [happyness#sad]
1  [happyness#moderate]
2      [happynesss$sad]

answered Jun 3, 2019 at 12:55

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

1 Comment

TRINADH NAGUBADI Over a year ago

Thanks @Rakesh for helping out this issue

venkatadileep · Accepted Answer · 2019-06-03 12:42:35Z

0

Try this approach i think this will work for you.

df['new_col']=df['column'].replace(to_replace = 
['happyness','happiness','happie ness'], value = 
['happyness','happyness','happyness'])

answered Jun 3, 2019 at 12:42

venkatadileep

1817 bronze badges

1 Comment

TRINADH NAGUBADI Over a year ago

The above approach is not working @venkatadileep Thanks for your effort

Collectives™ on Stack Overflow

Replacing string value in a pandas dataframe column inside a list in Python

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related