Re: [Errno 2] No such file or directory

otum · ‎01-10-2024

I am reading a Json a file as in below location, using the below code,

file_path = "/dbfs/mnt/platform-data/temp/ComplexJSON/sample.json"  # replace with the file path
f = open(file_path, "r")
print(f.read())

but it is failing for no such file or directory exists?

Can someone please help me with the issue?

shan_chandra · ‎01-11-2024

Hi @otum , can you please try to cat the file first and validate if you are able to view the data first

%sh cat /dbfs/FileStore/babynames.csv

I was able to run the same commands as you and read the files.

Thanks,

Shan

otum · ‎01-11-2024

it isn't displaying with sh cat, but displaying with dbutils.fs.ls

Please find below is the image,

Debayan · ‎01-11-2024

Hi, Could you please try with dbfs:/ ? Also, could you please ls the absolute file path to see what's the content?

otum · ‎01-11-2024

Thanks for the reply, here is what I am getting when tried with dbfs:/

shan_chandra · ‎01-16-2024

@otum cat command should be given as below (not syntax verified).

%sh cat /dbfs/mnt/platform-data/temp/ComplexJSON/sample.json

Debayan · ‎01-18-2024

Hi, As Shan mentioned, could you please cat the file and see if it exists.