import requests import io import zipfile import pandas as pd url = r'https://www.accessdata.fda.gov/premarket/ftparea/clia_detail.zip' r = requests.get(url) zip_file = zipfile.ZipFile(io.BytesIO(r.content)) file_name = zip_file.namelist() # Unzip zip file if file_name: file = zip_file.read(file_name[0]).decode('latin-1') else: raise ValueError(f'Empty zip file.') df = pd.read_csv(io.StringIO(file), encoding='latin-1', sep='|') print(df)