Apisero is now part of NTT DATA - Learn more.

Close this search box.

Creating ML Models In Dataiku With Snowflake

Authors: Daksh Trehan, Sumit Chahal

ML Models in Dataiku:

There are several machine learning models available in Dataiku that we can train and use for prediction. Also, Dataiku offers to code your own model and use that in the Dataiku flow for predictions. There is also an option to code deep learning models in TensorFlow and use them in Dataiku.

Here we will train several models to predict the price of used cars and will compare their scores for the same. A dataset which we will use to train the models has several attributes like manufacturer, fuel type, gear type, the horsepower of the car, etc. 

Since we need to predict the price of cars, it comes under a regression problem and for the same, we will train KNN, Ridge, Lasso, and Random Forest.

Creating ML Model in Dataiku:

We will create an ML model in Dataiku, where data for training is available in Snowflake. First, we will transform the data as per requirements and then train the model and finally, we will predict with the help of trained models.

  1. We have uploaded a dataset for used cars prices in Snowflake.
  1. Connect Dataiku to Snowflake and get access to the USED_CARS database in Dataiku. (For this part, please refer to the following blog link – Dataiku with Snowflake )
  1. Before training, we will transform the data. First records are removed with a data preparation recipe which has a null value for any feature.
  1. Now with the help of a data preparation recipe, column ‘model’ is removed.
  1. The flow diagram will look like this after two recipes.
  1. Now we will analyze the attributes and will remove the noise from them. Like we club two child manufacturers mentioned separately into one parent value. Another one is remove outliers i.e remove records where count of class attributes is very less and in case of continuous attributes, remove records which have values very far from mean.
  1. The flow diagram will look like this after these steps.
  1. Split the dataset into train and test datasets. We will use an 80:20 ratio which results as 80% records in training dataset and after training of models with this dataset, we will evaluate the models with remainig 20% records which are available in test dataset.
  1. Train three models – KNN, Ridge, and Random Forest on training dataset.
  1. All three models are used to score on test dataset.
  1. Finally models are used to predict ‘Price’ for the whole dataset.

Results are as following:

We use cookies on this site to enhance your user experience. For a complete overview of how we use cookies, please see our privacy policy.