title: How to write data as single (normal) csv file in Spark?
body: <p>I am trying to save a data frame as CSV file in my local drive. But, when I do that so, I get a folder generated and within that partition files were written. Is there any suggestion to overcome this ?</p>
  
  <p><strong>My Requirement:</strong>
  To get a normal csv file with actual name given in the code.</p>
  
  <p><strong>Code Snippet:</strong>
  <code>dataframe.coalesce(1).write.mode("overwrite").format("com.databricks.spark.csv").option("header", "true").csv("E:/dataframe.csv")</code></p>