How to avoid unicode errors from DataFrame to CSV?

Question

Cannot get rid of unicode erros, how do i deal with them?

I'm using Dataframe (to_csv method) but the problem it shows on CSV the following:

GÃ²tic
MontjuÃ¯c

How to avoid it in Dataframes? Python 2.7 + Pandas

I'm using:

# encoding=utf8

I've tried:

.encode('utf-8')
u''.join(variable)

What should be the ideal output? Please show how it looks like in DataFrame? — ManojK
– ManojK, Commented Feb 10, 2020 at 9:38

ManojK · Accepted Answer · 2020-02-10 09:59:54Z

2

Try this, change the encoding to latin-1

df.to_csv('your_csv_name.csv', encoding = 'latin-1')

output:

Gòtic
Montjuïc

Works fine for me in Python 3.7

answered Feb 10, 2020 at 9:59

ManojK

1,6403 gold badges11 silver badges17 bronze badges

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

1 Comment

For me too in Python 2.7 thank you so much buddy, you saved my life