Error reading csv file using pandas

Question

I'm a new user on Python and I'm having this basic doubt on how to properly read a csv file through "pd.read_csv" from pandas package.

my code is as follows:

import pandas as pd

import numpy as np

test = pd.read_csv('C:/Users/marcu/Desktop/teste.csv')

And it gives this message of error:

Traceback (most recent call last):
  File "<pyshell#3>", line 1, in <module>
    test = pd.read_csv('C:/Users/marcu/Desktop/teste.csv')
  File "C:\Users\marcu\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 646, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "C:\Users\marcu\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 389, in _read
    parser = TextFileReader(filepath_or_buffer, **kwds)
  File "C:\Users\marcu\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 730, in __init__
    self._make_engine(self.engine)
  File "C:\Users\marcu\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 923, in _make_engine
    self._engine = CParserWrapper(self.f, **self.options)
  File "C:\Users\marcu\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\io\parsers.py", line 1390, in __init__
    self._reader = _parser.TextReader(src, **kwds)
  File "pandas\parser.pyx", line 535, in pandas.parser.TextReader.__cinit__ (pandas\parser.c:6086)
  File "pandas\parser.pyx", line 740, in pandas.parser.TextReader._get_header (pandas\parser.c:9266)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe7 in position 22: invalid continuation byte

How can I solve this?!

Thanks for your attention, Marcus.

Just a guess, can you try changing it to `test = pd.read_csv('C:/Users/marcu/Desktop/teste.csv', encoding='latin')` — ayhan, Apr 10 '17 at 18:45
Your csv isn't using `utf8` encoding, which `pandas` assumes by default. You need to figure out the encoding and pass the correct encoding as a string with the `encoding` argument... — juanpa.arrivillaga, Apr 10 '17 at 18:45
Thank you all very much! It was about the encoding, I used "encoding = 'latin' as suggested by ayhan and it worked just fine! — Marcus Boeno, Apr 10 '17 at 18:53
Similar discussion here: http://stackoverflow.com/a/33819765/3083243 — devautor, Apr 10 '17 at 18:54
Glad that it resolved. I am linking it to the other question then. — ayhan, Apr 10 '17 at 19:01
It seems that your file is wrong encoded...or has a `NaN` or bad spaces. Try to remove them — J.Do, Apr 10 '17 at 19:01

Error reading csv file using pandas

0 Answers0