Home/ Questions/Q 632
Next
Answered
Kenil Vasani
Kenil Vasani

Kenil Vasani

View Profile
  • 9
Asked: 2020-12-14T21:07:59+00:00 In:

Python Jupyter Notebook – Unable to open CSV file through a path

  • 9

I am a little new to Python, and I have been using the Jupyter Notebook through Anaconda. I am trying to import a csv file to make a DataFrame, but I am unable to import the file.

Here is an attempt using the local method:

df = pd.read_csv('Workbook1')
---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-11-a2deb4e316ab> in <module>()
----> 1 df = pd.read_csv('Workbook1')

After that I tried using the path (I put user for my username)

df = pd.read_csv('Users/user/Desktop/Workbook1.csv')
---------------------------------------------------------------------------
FileNotFoundError                         Traceback (most recent call last)
<ipython-input-13-3f2bedd6c4de> in <module>()
----> 1 df = pd.read_csv('Users/user/Desktop/Workbook1.csv')

I am using a Mac, which I am also new to, and I am not 100% sure if I am correctly importing the right path. Can anyone offer some insight or solutions that would allow me to open this csv file.

csvpandaspython
Share

    1 Answer

    1. Kenil Vasani

      Kenil Vasani

      View Profile
      Best Answer

      Instead of providing path, you can set a path using the code below:

      import os
import pandas as pd
os.chdir("D:/dataset")
data = pd.read_csv("workbook1.csv")

      This will surely work.

      • 4

    You must login to add an answer.