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)