Dropbox Zipfile CSVs to pandas

dbx.py

import io
import zipfile
import dropbox
import pandas as pd

def get_dropbox():
    dropbox_path = "path/to/dropbox/files"
    dbx = dropbox.Dropbox('DROPBOX_KEY')
    # get listing of files
    dbx_files = dbx.files_list_folder(dropbox_path)
    # sort to get the latest file
    dbx_files.entries.sort(key = lambda d: d.client_modified, reverse=True)

    df = pd.DataFrame()
    _, res = dbx.files_download(dbx_files.entries[0].path_lower)
    with io.BytesIO(res.content) as stream:
        zf = zipfile.ZipFile(stream)
        for f in zf.namelist():
            try:
                dfs = pd.read_csv(zf.open(f), sep="\t", dtype=str, low_memory=False, encoding_errors='ignore')
                df = df.append(dfs, ignore_index=True)
            except ValueError:
                pass
    
    return df