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

[MattPython]

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.

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

Thank you!

[Chaitanya_Raju]

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!!

[Anonymous]

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!

[Johny]

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

[User16789202230]

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

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