how to resolve encoding errors in python?

Question

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

Does this answer your question? Why I'm getting "UnicodeEncodeError: 'charmap' codec can't encode character '\u25b2' in position 84811: character maps to <undefined>" error? — Tomerikoo
– Tomerikoo, Commented Dec 6, 2020 at 13:19
Can your share your sys.stdout.encoding output? You can do so by import sys first. — Henry Tjhia
– Henry Tjhia, Commented Dec 6, 2020 at 13:21

shekhar chander · Accepted Answer · 2020-12-06 13:54:22Z

1

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

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

answered Dec 6, 2020 at 13:54

shekhar chander

6181 gold badge8 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

how to resolve encoding errors in python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related