Read a zipped file as a pandas DataFrame

by

If you want to read a zipped or a tar.gz file into pandas dataframe, the read_csv methods includes this particular implementation.

df = pd.read_csv('filename.zip')

Or the long form: 

df = pd.read_csv('filename.zip', compression='zip', header=0, sep=',', quotechar=""")

Description of the compression argument from the docs:

compression : {‘infer’, ‘gzip’, ‘bz2’, ‘zip’, ‘xz’, None}, default ‘infer’
For on-the-fly decompression of on-disk data. If ‘infer’ and filepath_or_buffer is path-like, then detect compression from the following extensions: ‘.gz’, ‘.bz2’, ‘.zip’, or ‘.xz’ (otherwise no decompression). If using ‘zip’, the ZIP file must contain only one data file to be read in. Set to None for no decompression.

New in version 0.18.1: support for ‘zip’ and ‘xz’ compression.

More Related Contents:

  1. reading multiple files contained in a zip file with pandas
  2. how to use if statement with multiple conditions on pandas dataframe
  3. I’m working on some practice dataset in python [closed]
  4. Split (explode) pandas dataframe string entry to separate rows
  5. Select DataFrame rows between two dates
  6. NumPy or Pandas: Keeping array type as integer while having a NaN value
  7. Performant cartesian product (CROSS JOIN) with pandas
  8. Get rows based on distinct values from one column
  9. How to display pandas DataFrame of floats using a format string for columns?
  10. Find column whose name contains a specific string
  11. Numpy “where” with multiple conditions
  12. Creating a new column based on if-elif-else condition
  13. Pandas DataFrame to List of Dictionaries
  14. Pandas: Setting no. of max rows
  15. Pandas dataframe groupby plot
  16. Making heatmap from pandas DataFrame
  17. Rename specific column(s) in pandas
  18. How to merge two dataframes side-by-side?
  19. Split dataframe into relatively even chunks according to length
  20. Make Pandas groupby act similarly to itertools groupby
  21. Python pandas – filter rows after groupby
  22. Pandas left outer join multiple dataframes on multiple columns
  23. Constructing 3D Pandas DataFrame
  24. python pandas dataframe slicing by date conditions
  25. xlrd.biffh.XLRDError: Excel xlsx file; not supported [duplicate]
  26. Pandas reset index on series to remove multiindex
  27. Convert dataframe index to datetime
  28. Python: Removing Rows on Count condition
  29. Get first row of dataframe in Python Pandas based on criteria
  30. How to specify the type of pandas series elements in type hints?

Leave a Comment