i Want to Zip the CSV File in (Buffer) Using zipFile in Python
Below is My Code Which I Have Tried And Error Log Attached
I Dont want to use the compression in df.to_csv due to Version issue import pandas as pd import numpy as np import io import zipfile df = pd.DataFrame(np.random.randn(100, 4), columns=list('ABCD')) s_buf = io.StringIO() df.to_csv(s_buf,index=False) s_buf.seek(0) s_buf.name = 'my_filename.csv' localfile= io.BytesIO() localzip = io.BytesIO() zf = zipfile.ZipFile(localzip, mode="w",compression=zipfile.ZIP_DEFLATED) zf.writestr(localfile, s_buf.read()) zf.close() with open("D:/my_zip.zip", "wb") as f: f.write(zf.getvalue()) Error I am Getting
Traceback (most recent call last): File "C:/Users/Window/PycharmProjects/dfZip/dfZiptest.py", line 25, in <module> zf.writestr(localfile, s_buf.read()) File "C:\Python\Python37\lib\zipfile.py", line 1758, in writestr date_time=time.localtime(time.time())[:6]) File "C:\Python\Python37\lib\zipfile.py", line 345, in __init__ null_byte = filename.find(chr(0)) AttributeError: '_io.BytesIO' object has no attribute 'find'