title: Databrics save pandas dataframe as CSV Azure Data Lake
body: <p>I have pandas dataframe in the Azure Databricsk.
  I need to save it as ONE csv file on Azure Data Lake gen2.</p>
  <p>I've tried with :</p>
  <pre><code>df.write.mode(&quot;overwrite&quot;).format(&quot;com.databricks.spark.csv&quot;).option(&quot;header&quot;,&quot;true&quot;).csv(dstPath)
  </code></pre>
  <p>and</p>
  <pre><code>df.write.format(&quot;csv&quot;).mode(&quot;overwrite&quot;).save(dstPath)
  </code></pre>
  <p>but now I have 10 csv files but I need one file and name it.</p>
  <p>Thanks in advance.</p>