Created
March 20, 2022 17:49
-
-
Save kshirsagarsiddharth/c4e6c93e1ef32b7fe104c7e244affa50 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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