You can use the ability to convert a pyspark dataframe directly to a pandas dataframe. The command for the same would be -
df.limit(10).toPandas()
This should directly yield the result as a pandas dataframe and you just need to have pandas package installed.