Pandas file IO Read Error

Question

New to pandas, running into an error consistently with WinXP file path, for example:

names1880 = pd.read_csv('C:\Documents and Settings\Foo\My Documents\pydata-book\pydata-book-master\ch02\names\yob1880.txt', names=['name', 'sex', 'births'])

Keep getting an error as follows:

Exception                                 Traceback (most recent call last)
 in ()
----> 1 names1880 = pd.read_csv('C:\Documents and Settings\Foo\My Documents\pydata-book\pydata-book-master\ch02\names\yob1880.txt', names=['name', 'sex', 'births'])

From reading thru available documentation, haven't isolated if its a problem with my syntax or a parser issue.

Any feedback would be appreciated.

You need to include the entire traceback, not just the first line. — DSM
– DSM, Commented Feb 26, 2013 at 22:15
Also use raw-strings or forward-slashes or escape your backslashes in your file path. — mechanical_meat
– mechanical_meat, Commented Feb 26, 2013 at 22:18

Wes McKinney · Accepted Answer · 2013-03-04 19:35:10Z

2

Unless you put r in front of the string, the \n is being interpreted as a newline:

In [1]: 'C:\Documents and Settings\Foo\My Documents\pydata-book\pydata-book-master\ch02\names\yob1880.txt'
Out[1]: 'C:\\Documents and Settings\\Foo\\My Documents\\pydata-book\\pydata-book-master\\ch02\names\\yob1880.txt'

vs

In [2]: r'C:\Documents and Settings\Foo\My Documents\pydata-book\pydata-book-master\ch02\names\yob1880.txt'
Out[2]: 'C:\\Documents and Settings\\Foo\\My Documents\\pydata-book\\pydata-book-master\\ch02\\names\\yob1880.txt'

answered Mar 4, 2013 at 19:35

Wes McKinney

106k32 gold badges146 silver badges109 bronze badges

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

Collectives™ on Stack Overflow

Pandas file IO Read Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related