topic Re: How do you read files from the DBFS with OS and Pandas Python libraries? in Data Engineering

How do you read files from the DBFS with OS and Pandas Python libraries?

MattPython — Wed, 01 Feb 2023 13:20:15 GMT

I created translations for decoded values and want to save the dictionary object the DBFS for mapping. However, I am unable to access the DBFS without using dbutils or PySpark library.

Is there a way to access the DBFS with OS and Pandas Python libraries? At work, we can directly use the same path as the PySpark functions to write/ read from the DBFS without issue.

Confirm files exist within DBFS
Confirm ability to read file with PySpark
Error 1 - recommends using "/dbfs" instead of "dbfs:"
Updated "/dbfs" - error persists
Removed DBFS entirely:
and one last shot....

Thank you!

Re: How do you read files from the DBFS with OS and Pandas Python libraries?

Chaitanya_Raju — Thu, 02 Feb 2023 03:13:11 GMT

Hi @Matthew LIbonati ,

Can you please check again, I tried in the exact same way and initially faced the error as mentioned in point 3, then changed it to as mentioned in point 4, can able to see the data without any issues.

Happy Learning!!

Re: How do you read files from the DBFS with OS and Pandas Python libraries?

Anonymous — Sun, 09 Apr 2023 03:06:37 GMT

Hi @Matthew LIbonati

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!

Re: How do you read files from the DBFS with OS and Pandas Python libraries?

Johny — Sat, 29 Apr 2023 20:03:19 GMT

Hi @Vidula Khanna ,

I am having the same issue (using Community Edition). I am aware that in CE, DBFS is not mounted to /dbfs root directory. Is this the cause? If so, that is the alternative?

Thank you

Re: How do you read files from the DBFS with OS and Pandas Python libraries?

User16789202230 — Thu, 21 Dec 2023 10:38:02 GMT

db_path = 'file:///Workspace/Users/l<xxxxx>@databricks.com/TITANIC_DEMO/tested.csv'

df = spark.read.csv(db_path, header = "True", inferSchema="True")