read_zip_url.py

from io import BytesIO, StringIO
from urllib.request import urlopen
from zipfile import ZipFile

import pandas as pd

def download_and_unzip(url, extract_to='.'):
    http_response = urlopen(url)
    zipfile = ZipFile(BytesIO(http_response.read()))
    return zipfile
 
### YOUR URL
url = "https://archive.ics.uci.edu/ml/machine-learning-databases/00526/data.zip"
zipped_data = download_and_unzip(url)

### CUSTOMIZE BELOW
fname = zipped_data.namelist()[0]
df = pd.read_csv(StringIO(zipped_data.read(fname).decode('utf-8')))