pandas read path without file folder

Question

import pandas as pd
df = pd.read_excel(r'C:\Users\name\Documents\Data\/' + file+ '.xlsx')

FileNotFoundError: [Errno 2] No such file or directory: 'C:\Users\name\Documents\/file.xlsx'

I try this is Documents path and it work, but when I adding one more file folder(Data) to it, python show me that he didn't go in to the Data file folder.

Does this answer your question? [Reading an Excel file in python using pandas](https://stackoverflow.com/questions/17063458/reading-an-excel-file-in-python-using-pandas) — Jay Kakadiya, Oct 21 '20 at 03:43

score 0 · Answer 1 · answered Oct 21 '20 at 03:35

0

You don't need that last / before file

answered Oct 21 '20 at 03:35

Cal Lee

50
6

Subbu VidyaSekar · Accepted Answer · 2020-10-21T03:44:29.180

0

below code would help you

file = 'sample'
df = pd.read_excel(r'C:\\Users\\name\\Documents\\Data\\' + file+ '.xlsx')

or

\ backslash sometimes behave as escape sequences. To avoid that situation

df = pd.read_excel(r'C:/Users/name/Documents/Data/' + file+ '.xlsx')

edited Oct 21 '20 at 03:44

answered Oct 21 '20 at 03:36

Subbu VidyaSekar

2,503
3
21
39

I try this 2 code already, but the error is still the same – Gun hanwei Oct 21 '20 at 03:42
updated the code with sample file name. also give the correct path.. in your example there is no folder name data. – Subbu VidyaSekar Oct 21 '20 at 03:46
FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\name\\Documents\\/sample.xlsx' the path still not go inside the Data folder which the sample file is located – Gun hanwei Oct 21 '20 at 03:52
there no / in my code before the file name sample. kindly copy the code and work or use the second option in my code – Subbu VidyaSekar Oct 21 '20 at 03:55
thanks for your helping, I edit the wrong file in the document folder, they got the same name... – Gun hanwei Oct 21 '20 at 03:58

pandas read path without file folder

2 Answers2