example_db
integration in the MindsDB Cloud Editor. In order to be able to use it, you must first create a database like this:
example_db.demo_data.used_car_price
table, which is our base table.Name | Description |
---|---|
model | Model of the car. |
year | Year of production. |
price | Price of the car. |
transmission | Transmission (Manual , or Automatic , or Semi-Auto ). |
mileage | Mileage of the car. |
fueltype | Fuel type of the car. |
tax | Tax. |
mpg | Miles per gallon. |
enginesize | Engine size of the car. |
DROP VIEW view_name;
.example_db.demo_data.used_car_price
table and its extensions.
DROP MODEL predictor_name;
.generating
at first, then training
, and at last, complete
.
0.963
.0.965
. The accuracy value increased, as expected.0.982
. The accuracy value increased again, as expected.car_sales
table. Then, we add more data by joining the car_sales
and car_info
tables. We create a predictor based on the car_sales_info
view.
Let’s get started.
car_sales
table:
Name | Description |
---|---|
model | Model of the car. |
year | Year of production. |
price | Price of the car. |
transmission | Transmission (Manual , or Automatic , or Semi-Auto ). |
mileage | Mileage of the car. |
fueltype | Fuel type of the car. |
tax | Tax. |
car_info
table:
Name | Description |
---|---|
model | Model of the car. |
year | Year of production. |
transmission | Transmission (Manual , or Automatic , or Semi-Auto ). |
fueltype | Fuel type of the car. |
mpg | Miles per gallon. |
enginesize | Engine size of the car. |
car_sales
and car_info
tables on the model
, year
, transmission
, and fueltype
columns.
SELECT
Statements Please note that we use the nested SELECT
statement in order to trigger native query at the MindsDB Cloud Editor. Here, the example_db
database is a PostgreSQL database, so we trigger PostgreSQL-native syntax.JOIN
query:
car_sales
table as input data.
JOIN
between the car_sales
and car_info
tables.
model+year+transmission+fueltype
affects the price, so joining more data columns doesn’t play a role in this particular example.