Skip to content

Instantly share code, notes, and snippets.

@kshirsagarsiddharth
Created March 20, 2022 17:49
Show Gist options
  • Save kshirsagarsiddharth/c4e6c93e1ef32b7fe104c7e244affa50 to your computer and use it in GitHub Desktop.
Save kshirsagarsiddharth/c4e6c93e1ef32b7fe104c7e244affa50 to your computer and use it in GitHub Desktop.
from sqlalchemy import create_engine
engine = create_engine("sqlite:///car_prediction_dataset.sqlite3")
query = """
SELECT
year,
price,
km_traveled,
tax,
enginesize,
km_per_liters,
mi.model,
transmission,
fuel_type
FROM models_with_companies mc
INNER JOIN model_info mi
ON mc.model_id = mi."index"
WHERE make = 'Chevrolet';
"""
df = pd.read_sql_query(query, con = engine,)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment