Replacing special characters not working in Pandas

Question

I am trying to remove special characters from a string, but when I export the Pandas dataframe as a CSV, I can still see the special characters.

Does anyone know why that is?

Current Code:

document = json.dumps(jfile,default=str) document2 = re.sub("[“â£$€™]", '', document) document2 = json.loads(document2) document2.to_csv("test.csv", index = False)

Output (special character still found in CSV file):

Try document.str.replace("[“â£$€™]", '', regex=True) — gofvonx
– gofvonx, Commented Feb 12, 2021 at 14:21

Mahery Ranaivoson · Accepted Answer · 2021-02-12 14:21:51Z

2

This seems the pandas Encoding problem. Try to read/load your file with the appropriate encoding.

answered Feb 12, 2021 at 14:21

Mahery Ranaivoson

4607 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Replacing special characters not working in Pandas

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related