!pip install requests 
!pip install pandas
!pip install zipfile36

import requests
import pandas as pd
from io import StringIO

# List of URLs to your CSV files
urls = [
    'https://example.com/file1.csv',
    'https://example.com/file2.csv',
    'https://example.com/file3.csv'
]

# Read multiple CSV files into DataFrames
dfs = []
for url in urls:
    response = requests.get(url)
    if response.status_code == 200:
        data = response.text
        df = pd.read_csv(StringIO(data))
        dfs.append(df)
    else:
        print(f"Failed to download {url}")

# Combine all DataFrames into one
combined_df = pd.concat(dfs, ignore_index=True)
print(combined_df.head())

import requests
import zipfile
import pandas as pd
from io import BytesIO

# URL of the ZIP file
url = 'https://example.com/your-zip-file.zip'

# Download the ZIP file
response = requests.get(url)
if response.status_code == 200:
    # Extract the ZIP file
    with zipfile.ZipFile(BytesIO(response.content)) as z:
        # List all files in the ZIP
        file_list = z.namelist()
        # Read each CSV file into a DataFrame
        dfs = []
        for file_name in file_list:
            if file_name.endswith('.csv'):
                with z.open(file_name) as f:
                    df = pd.read_csv(f)
                    dfs.append(df)
        
        # Combine all DataFrames into one
        combined_df = pd.concat(dfs, ignore_index=True)
        print(combined_df.head())
else:
    print(f"Failed to download the file: {response.status_code}")