topic Re: FileNotFoundError: [Errno 2] No such file or directory or IsADirectoryError: [Errno 21] Is a directory in Data Engineering

FileNotFoundError: [Errno 2] No such file or directory or IsADirectoryError: [Errno 21] Is a directory

AnaDel_Campo_Me — Thu, 02 Jan 2020 16:36:21 GMT

I have been trying to open a file on the dbfs using all different combinations:

if I use the following code:

with open("/dbfs/FileStore/df/Downloadedfile.csv", 'r', newline='') as f

I get IsADirectoryError: [Errno 21] Is a directory

with open("dbfs:/FileStore/df/Downloadedfile.csv", 'r', newline='') as f

FileNotFoundError: [Errno 2] No such file or directory

Re: FileNotFoundError: [Errno 2] No such file or directory or IsADirectoryError: [Errno 21] Is a directory

User16857282152 — Thu, 02 Jan 2020 16:55:19 GMT

@Ana Del Campo Mendizabal

There is a file explorer,

Use that to verify the file is where you expect it to be.

Here is a screenshot,

Basically

Click on Databricks on Left Navigation Panel,

And then Import and Explore Data in the center of the page

Re: FileNotFoundError: [Errno 2] No such file or directory or IsADirectoryError: [Errno 21] Is a directory

paulmark — Thu, 20 Feb 2020 06:15:37 GMT

To get rid of this error you can try using Python file exists methods to check that at least python sees the file exists or not. In other words, you can make sure that the user has indeed typed a correct path for a real existing file. If the user does not pass the full path to the file, the path is interpreted relatively to the current working directory. The current working directory usually is the directory in which you started the program.