Jupyter session cannot open csv file

Question

Cannot determine why Jupyter cannot load my csv file.. The code I have in Jupyter cell is pretty simple

    import pandas as pd 
    df = pd.read_csv(r"purchases.csv")

getting the error below

CParserError

Traceback (most recent call last)
<ipython-input-45-139a6a5372f2> in <module>()
      3 
      4 
----> 5 df = pd.read_csv(r"purchases.csv")
      6 df
      7

Name of Notebook is Pandas Tet

In my directory, I can see the csv file- purchases.csv Plz advise - have spent a lot of time and I cannot figure it out.

I am taking coursera course and downloaded their notes. I can read mpg.csv and their other files. Do I have to do anything special on files which I create. I have searched online and cannot determine a solution. Thx in advance

For example, this article may be helpful. How to specify file path in jupyter notebook — kunif
– kunif, Commented Jul 27, 2020 at 4:07
Hi Philip.. Have tried using c:\\....\\purchases.csv, c:\purchases.csv, in single quotes ,double quotes and no success — user2643900
– user2643900, Commented Jul 27, 2020 at 4:18
Hello. the r string use if you use path with backslash for example this path c:\purchases.csv but if your notebook file is in the same folder with the purchases.csv file, then you just need the filename instead of the full path. Try df = pd.read_csv('purchases.csv') — Philip Purwoko
– Philip Purwoko, Commented Jul 27, 2020 at 4:23

Krishnakanth Allika · Accepted Answer · 2020-07-27 05:24:53Z

0

The following should work since the csv file is in the same folder as the ipynb file.

    import pandas as pd
    df = pd.read_csv("purchases.csv")

answered Jul 27, 2020 at 5:24

Krishnakanth Allika

8106 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Jupyter session cannot open csv file

getting the error below

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

getting the error below

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related