I used the zipfile
module to import the ZIP directly to pandas dataframe.
Let’s say the file name is “intfile” and it’s in .zip named “THEZIPFILE”:
import pandas as pd
import zipfile
zf = zipfile.ZipFile('C:/Users/Desktop/THEZIPFILE.zip')
df = pd.read_csv(zf.open('intfile.csv'))