Load CSV files from Zip and Stack

load_from_zip_of_csv.py

import pandas
from zipfile import ZipFile
zip_file_path = "some_zip.zip"
# some_zip.zip/
# ├─ part1.csv
# ├─ part2.csv
# ├─ part3.csv
zip_file = ZipFile(zip_file_path)
extracted_data = pd.concat([
    pandas.read_csv(
        zip_file.open(
            item
        )
    )
    for item in zip_file.namelist()
    if item.endswith(".csv")
])
extracted_data = extracted_data.reset_index()
extracted_data