Hi Everyone,
I would like to a Pandas Dataframe to /dbfs/FileStore/ using to_csv method.
Usually it would just write the Dataframe to the path described but It has been giving me "FileNotFoundError: [Errno 2] No such file or directory: '/dbfs/FileStore/test.csv".
I have tried
df.to_csv("/dbfs/FileStore/test.csv", header= None, index= None)
df.to_csv("dbfs/FileStore/test.csv", header=None, index=None)
df.to_csv("dbfs:/FileStore/test.csv", header=None, index=None)
df.to_csv("/FileStore/test.csv", header=None, index=None)
df.to_csv("FileStore/test.csv", header=None, index=None)
But all give out the same error.
using dbutils i see that the folder are present.
dbutils.fs.ls("dbfs:/FileStore")
Out[32]: [FileInfo(path='dbfs:/FileStore/tables/', name='tables/', size=0, modificationTime=0)]
I am new here and i tried searching the problem for a long time but I can't find a solution. Please help.