Py Spark Pandas Code diff

[Krishscientist]

Hi Can you help me why Pandas code not working..but Pyspark is working..

import pandas as pd

pdf = pd.read_csv('/FileStore/tables/new.csv',sep=',')

Error : No such file exists...

below is worked..

df = spark.read.csv("/FileStore/tables/new.csv", sep=",", header='True')

[Hubert-Dudek]

Try to add /dbfs/ or dbfs: prefix​

[Krishscientist]

Yeah..I tried all options...still no file exists..

So I am converting Py spark DF to Pandas DF...

I am interested to know why below is not working..

pdf = pd.read_csv('/FileStore/tables/new.csv',sep=',')

[RRO · Accepted solution]

It might has to do with the path as @Hubert Dudek​  already mentioned:

df = spark.read.csv("dbfs:/FileStore/tables/new.csv", sep=",", header='True')

[Kaniz_Fatma]

Hi @Rafael Rockenbach​  and @Hubert Dudek​ , It was so nice to have your response. Thank you for the time you put into our community. I really want you to know how much we appreciate that.