May 22nd 2020
Build, Train, and Use Machine Learning Models inside Google Sheets.
I am a fan of Google Sheets as are, I believe, many others. I use it for almost anything related to my startup, ranging from customer reviews and analytics to website analytics. You could say that Google Sheets is extremely integral to our operations.
We have all these historic data in Google Sheets but leveraging that data for anything more than dashboards is a hard task. Exporting to CSV, Cleaning the data, Normalising, and then tuning your favorite Machine Learning model is a cumbersome process with a steep learning curve.
Let’s try it now, shall we!
Get the Add-On
Now just create an account by pressing the Sign Up button.
Once you have created an account successfully, you will be greeted by this screen.
Move to the upper right corner, to the user logo.
Copy the API Key from here!
Now get back to the Sheets Add-On and select — Set API Key.
Enter the previously copied API key here and the setup is done!
The task we have here is to predict the selling price of a pre-owned car, given some other parameters.
Go to the Add-on, Press Start, and the Regression.
You will be greeted with the Aasaanai Sidebar. Here you will find all the controls for training and using your models.
Now, click on create your own model.
You will be asked to either add labels and refresh the sheet or directly upload it. Since we already have the Selling Price column, we will press the Upload sheet button.
Once the file upload is done, you will find the training window. Select the Selling Price Column and give the model a name.
Press Train Model. This will start the training process which may take a couple of minutes, depending on the size of your Spreadsheet.
Once the model is trained, you will get a prompt.
Now go back to the homepage, press refresh and you will find the trained model.
Now we can use the model just by clicking on it. You can also delete the model but just clicking the trash button.
To use the prediction, we can just click on the model which opens up the prediction window.
Just enter the row starting and ending values. Mind you, sheets indexing starts at 1.
Press predict and voila you will get the results in the sheet.
We also have the option to make triggers. But we will discuss them in another post.
So, Why Aasaan?
Traditional ML Flow
- Extract data and convert it to CSV or some other format.
- Import into a python environment using Pandas.
- Clean dataset by removing unwanted or missing values.
- Normalizing the data, deciding on which features are important, and also feature engineering.
- Choose the appropriate model and train.
- Repeat until you see good performance.
- Open Add-On.
- Select Label.
- Train Model.