Pandas: read a csv file inside a zip located on a remote path

load_dataframe_from_http_zip_csv_file.py

import zipfile
import io
import requests

def load_dataframe_from_http_zip_csv_file(endpoint, csv_filename,  engine='python', encoding='ISO-8859-1', delimiter=';', skiprows=0, index_col=None):
  response = requests.get(endpoint)
  zip_data = zipfile.ZipFile(io.BytesIO(response.content))
  zip_data.extract(csv_filename, path='extracted_directory')
  df = pd.read_csv(f'extracted_directory/{csv_filename}', encoding=encoding, delimiter=delimiter, engine=engine, skiprows=skiprows, index_col=index_col)
  return df