How to export a table dataframe in PySpark to csv?

by

If data frame fits in a driver memory and you want to save to local files system you can convert Spark DataFrame to local Pandas DataFrame using toPandas method and then simply use to_csv:

df.toPandas().to_csv('mycsv.csv')

Otherwise you can use spark-csv:

  • Spark 1.3

    df.save('mycsv.csv', 'com.databricks.spark.csv')

  • Spark 1.4+

    df.write.format('com.databricks.spark.csv').save('mycsv.csv')

In Spark 2.0+ you can use csv data source directly:

df.write.csv('mycsv.csv')

More Related Contents:

  1. How to add a constant column in a Spark DataFrame?
  2. Spark Dataframe distinguish columns with duplicated name
  3. Pyspark: Split multiple array columns into rows
  4. How do I add a new column to a Spark DataFrame (using PySpark)?
  5. How to change a dataframe column from String type to Double type in PySpark?
  6. Count number of non-NaN entries in each column of Spark dataframe with Pyspark
  7. Retrieve top n in each group of a DataFrame in pyspark
  8. Updating a dataframe column in spark
  9. Dividing complex rows of dataframe to simple rows in Pyspark
  10. Filter Pyspark dataframe column with None value
  11. PySpark converting a column of type ‘map’ to multiple columns in a dataframe
  12. How to explode multiple columns of a dataframe in pyspark
  13. Spark add new column to dataframe with value from previous row
  14. PySpark: multiple conditions in when clause
  15. Pyspark: Replacing value in a column by searching a dictionary
  16. Count number of non-NaN entries in each column of Spark dataframe in PySpark
  17. Create Spark DataFrame. Can not infer schema for type
  18. Pivot String column on Pyspark Dataframe
  19. Filtering DataFrame using the length of a column
  20. Multiple condition filter on dataframe
  21. How to return a “Tuple type” in a UDF in PySpark?
  22. How to perform union on two DataFrames with different amounts of columns in spark?
  23. Does spark predicate pushdown work with JDBC?
  24. Explode in PySpark
  25. How can we JOIN two Spark SQL dataframes using a SQL-esque “LIKE” criterion?
  26. Filtering a Pyspark DataFrame with SQL-like IN clause
  27. Converting Pandas dataframe into Spark dataframe error
  28. How to connect HBase and Spark using Python?
  29. How to pivot on multiple columns in Spark SQL?
  30. Apache Spark — Assign the result of UDF to multiple dataframe columns

Leave a Comment