What is the difference between save a pandas dataframe to pickle and to csv?

by

csv

  • ✅human readable
  • ✅cross platform
  • ⛔slower
  • ⛔more disk space
  • ⛔doesn’t preserve types in some cases

pickle

  • ✅fast saving/loading
  • ✅less disk space
  • ⛔non human readable
  • ⛔python only

Also take a look at parquet format (to_parquet, read_parquet)

  • ✅fast saving/loading
  • ✅less disk space than pickle
  • ✅supported by many platforms
  • ⛔non human readable

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)