How to specify file path in jupyter notebook

Question

I have problem in specifying path of my file in jupyter notebook/google colab. This is the example code I found:

import csv

csvFile = 'myData.csv'
xmlFile = 'myData.xml'

csvData = csv.reader(open(csvFile))
xmlData = open(xmlFile, 'w')

I do not know where the author of the code above place the myData.csv, so I have tried this code to locate my file:

csvFile = 'C:\Users\...\myData.csv'

but I get this error:

SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

I also have tried this code:

csvFile = r'C:\Users\...\myData.csv'

but I get this error: FileNotFoundError: [Errno 2] No such file or directory: 'C:\Users\...\myData.csv'

My questions are: 1. Where the author of the code above place the myData.csv? 2. How can I specify the file location?

Prachiti Prakash Prabhu · Accepted Answer · 2019-09-20 00:02:43Z

2

If the author is directly calling the file then it is in the same folder where the Jupyter Notebook is running
One of the following should work to call files from different locations:

a. Replace single quotes with double quotes and escape the slashes ex. csvFile = "C:\\Users\\...\\myData.csv"

b. Replace single quotes with double quotes and use forward slashes ex. csvFile = "C:/Users/.../myData.csv"

answered Sep 20, 2019 at 0:02

Prachiti Prakash Prabhu

6841 gold badge5 silver badges16 bronze badges

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

1 Comment

Iman Over a year ago

Hi Prachiti, unfortunately no luck

Anthony Vinay · Accepted Answer · 2020-08-19 12:46:53Z

2

I have tried using both Forward slash and also double backward slash. Both works.

'C:\\Users\\SAVK\\Downloads\\Ex_Files_Intro_Data_Science\\Ex_Files_Intro_Data_Science\\Exercise Files\\state_baby_names.csv'
'C:/Users/SAVK/Downloads/Ex_Files_Intro_Data_Science/Ex_Files_Intro_Data_Science/Exercise Files/us_baby_names.csv'

Example :

states_babies = pd.read_csv('C:\\Users\\SAVK\\Downloads\\Ex_Files_Intro_Data_Science\\Ex_Files_Intro_Data_Science\\Exercise Files\\state_baby_names.csv');
states_babies = pd.read_csv('C:/Users/SAVK/Downloads/Ex_Files_Intro_Data_Science/Ex_Files_Intro_Data_Science/Exercise Files/us_baby_names.csv');

answered Aug 19, 2020 at 12:46

Anthony Vinay

7061 gold badge10 silver badges23 bronze badges

Comments

Iman · Accepted Answer · 2019-09-20 11:59:03Z

0

I solved this problem by mounting the Google Colab to Google Drive. This is the path after I mount to Google Drive:

csvFile = '/content/drive/My Drive/Colab Notebooks/myData.csv.txt'
xmlFile = '/content/drive/My Drive/Colab Notebooks/myData.xml'

edited Sep 20, 2019 at 11:59

answered Sep 20, 2019 at 8:31

Iman

831 gold badge2 silver badges8 bronze badges

Comments

Sivasankar Boomarapu · Accepted Answer · 2019-09-20 12:17:56Z

0

Specify the path as below

fp = open("/Users/siva/Desktop/siva5.txt")

answered Sep 20, 2019 at 12:17

Sivasankar Boomarapu

1883 silver badges7 bronze badges

Comments

DonCarleone · Accepted Answer · 2021-02-11 21:40:02Z

0

If it is an issue with the filepath syntax try this:

import csv
csvfile = open('C:\\Users\\....\\<your_filename.file_extenstion>', "r")
readCSV = csv.reader(csvfile)

Based on years of experience with PEBCAK errors, something tells me that this file is not located where you think it is.

answered Feb 11, 2021 at 21:40

DonCarleone

91915 silver badges26 bronze badges

Comments

ezChx · Accepted Answer · 2021-05-07 16:12:03Z

0

Where did the author of the code place myData.csv?
- Open File Explorer
- Click on the appropriate drive C:, D:, etc.
- Enter myData.csv in the search box
- Search and retrieve the file location
How can I specify the file location?
- csvFile = '{path_from_above}/myData.csv'
  
  For example: 'C:/Users/Iman/Documents/myData.csv'

edited May 7, 2021 at 16:12

answered May 7, 2021 at 16:04

ezChx

4,0521 gold badge22 silver badges17 bronze badges

Comments

Mohana B C · Accepted Answer · 2021-08-23 03:55:59Z

0

If you want to go one level up( parent directory) and after that going to another sub-directory then (..\parent/child).

For eg: it is a sub-directory inside the same parent but from one sub directory i am navigating to another file called datasets

movies = pd.read_csv("..\datasets/movies.csv")
ratings = pd.read_csv("..\datasets/ratings.csv")

edited Aug 23, 2021 at 3:55

Mohana B C

5,4721 gold badge13 silver badges31 bronze badges

answered Aug 22, 2021 at 16:51

Wais Yousofi

294 bronze badges

Comments

aVral · Accepted Answer · 2023-02-21 20:20:51Z

0

I hope this could help!

# relative path to subfolder
path = "../power corr. factors/power corr"

for f in os.listdir(path):
    data = pd.read_csv(os.path.join(path,f))

answered Feb 21, 2023 at 20:20

aVral

1372 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to specify file path in jupyter notebook

8 Answers 8

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

1 Comment

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related