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)
浙公网安备 33010602011771号