Combine multiple .csv files into one pandas dataframe and write out to a zip file

Combine_files_and_zip.py

# -*- coding: utf-8 -*-
"""
Created on Wed Sep  9 16:46:15 2020

@author: mweber
"""

        
# Combine hydro-region tables if desired
import pandas as pd
import glob

path = r'L:/Priv/CORFiles/Geospatial_Library_Projects/StreamCat/FTP_Staging/StreamCat/HydroRegions' # use your path
all_files = glob.glob(path + "/AgriculturalNitrogen*.csv")

full_files = []

for filename in all_files:
    df = pd.read_csv(filename, index_col=None, header=0)
    full_files.append(df)

frame = pd.concat(full_files, axis=0, ignore_index=True)

compression_opts = dict(method='zip',
                        archive_name='out.csv')  
frame.to_csv('c:/users/mweber/temp/AgNit.zip', compression=compression_opts)

thank you man