Pandas' loading a CSV file problem

2015-10-22 Thread Ek Esawi
Thanks you all for the input. Michiel's suggestion worked. At first It gave me an error about "low_memory"; once i sat low_memory to false, it worked. I am new to pandas and i am working on a 20,000 record csv file with mixed data types and in many cases, one entry (cell) has a combination of str

Re: Pandas' loading a CSV file problem

2015-10-22 Thread Michiel Overtoom
Hi Ek, > On 22 Oct 2015, at 14:44, Ek Esawi wrote: > > f = pd.read_csv('c:/Users/EK Esawi/My Documents/Temp/GOSATemp1.csv') > File "pandas\parser.pyx", line 1382, in pandas.parser._string_box_utf8 > (pandas\parser.c:17655) > UnicodeDecodeError: 'utf-8' codec can't decode byte 0xb1 in position 8

Pandas' loading a CSV file problem

2015-10-22 Thread Ek Esawi
Here is the whole output. EKE Traceback (most recent call last): File "C:\Users\EK Esawi\Anaconda3\Scripts\MyFile.py", line 3, in f = pd.read_csv('c:/Users/EK Esawi/My Documents/Temp/GOSATemp1.csv') File "C:\Users\EK Esawi\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 474, in

Re: Pandas' loading a CSV file problem

2015-10-22 Thread Chris Angelico
On Thu, Oct 22, 2015 at 8:57 AM, Ek Esawi wrote: > > Traceback (most recent call last): > > File "C:\Users\EK Esawi\Anaconda3\Scripts\file1.py", line 3, in > > f = pd.read_csv('c:/Users/EK Esawi/My Documents/Temp/GOSATemp.csv') > > File "C:\Users\EK Esawi\Anaconda3\lib\site-packages\pandas\

Pandas' loading a CSV file problem

2015-10-22 Thread Ek Esawi
Hi All--- I am new to Pandas. I am trying to load a csv file into pandas using import pandas as pd f = pd.read_csv(OSATemp.csv') Even though I was able to read and manipulate the file in Python343, in Pandas the file could not be loaded. When I run the above statement, I get a series of ma