getStuttgartAirportTime.py

# Import Module
import pandas as pd
from sqlalchemy import create_engine

# Get data using Pandas
df = pd.read_html('https://www.stuttgart-airport.com/security-wait-times/')
# Some minor data cleaning
df = df[0]
df['Wait times'] = df['Wait times'].str.replace(r'\D', '') 
df['Wait times'] = pd.to_numeric(df['Wait times'], errors='coerce').astype('float')
df = df.set_index('Terminal').T

# Connect to database
host = '...'
port = '...'
db = '...'
user = '...'
pasw = '...'
engine = create_engine(f"postgresql+psycopg2://{user}:{pasw}@{host}:{port}/{db}")

# Save to Database
table_name = '...'
df.to_sql(table_name, engine,if_exists='append',index=False,)