fdd1.py

%%sql 
results << 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';
* sqlite:///car_prediction_dataset.sqlite3
Done.
Returning data to local variable results
# converting the results into a dataframe and dropping unimportant columns 
df = results.DataFrame()
df