Installation

MindsDB Docker

Run the following command to create a Docker container with MindsDB:

docker run --name mindsdb_container_lightwood -p 47334:47334 -p 47335:47335 mindsdb/mindsdb:lightwood

Run the following queries to check if the dataset is uploaded correctly:

SHOW TABLES FROM files;

SELECT * FROM files.cloth_size LIMIT 10;

Create and train the model using the following query:

CREATE PREDICTOR mindsdb.cloth_predictor
FROM files
(SELECT * FROM cloth_size LIMIT 10000)
PREDICT size;

Describe the model and its features:

DESCRIBE cloth_predictor;
DESCRIBE cloth_predictor.features;

Check the status of the model:

SELECT status
FROM mindsdb.models
WHERE name='cloth_predictor';

Use the trained model to predict the size with the following query:

SELECT size
FROM mindsdb.cloth_predictor
WHERE weight = 60
AND age = 23
AND height = 154.94;