CODEWITHSUNDEEP
pythonencodingcharacter-encoding
Joachim Jordan
Joachim Jordan

Reputation: 1

how to resolve encoding errors in python?

I'm trying to parse a csv downloaded file from my bank account. The file gets opened with:

with open('umsatz.csv', 'r', encoding="utf-8") as csv_file:

When trying to simply print the various entries I got the following error:

  File "C:\Users\joajo\AppData\Local\Programs\Python\Python39\lib\encodings\cp1252.py", line 19, in encode
    return codecs.charmap_encode(input,self.errors,encoding_table)[0]
UnicodeEncodeError: 'charmap' codec can't encode character '\ufffd' in position 13: character maps to <undefined>

Opening in notepad++ the problematic texts looks like:

LOHN-/GEHALTS�BERTRAGFREMDSPESE

Upvotes: 0

Views: 262

Answers (1)

shekhar chander
shekhar chander

Reputation: 618

Just open in 'rb' format. Here the code:

with open('umsatz.csv', 'rb') as csv_file:
     data = csv_file.read().decode('utf-8')

Upvotes: 1

Related Questions