**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

**What it does**

It takes data from an **Excel file** and **trains a Machine Learning model** according to the type of problem to solve (regression or classification) and the algorithm used (linear regression, polynomial regression, logistic regression, etc.). Eventually, the trained models can be used to **make predictions** on new data.

**How we built it**

We first created **configuration files using JSON** language to specify all kind of parameters:

*   one as a resource in order to list all algorithms and parameters handled by the tool
*   one for the dataset, in which you can specify the path of the Excel file, the sheet to use, which columns are corresponding to the features, and which one is corresponding to the target, the algorithm to use and its parameters

Then, we made the **Python script** to **preprocess the data** (dataset creation, label encoding) and **train the model** using pandas, numpy and scikit-learn libraries.

Next, we created another **Python script** to use a saved model in order to **make predictions** on new data.

Finally, we designed a **user-friendly web application** allowing users to **follow all the steps** from selecting the data to evaluate the accuracy of the trained model. There are **6 different steps**:

*   Where is your data?
*   Select your features
*   Select your target
*   Select your algorithm and specify its parameters
*   Review all your configuration and start the training
*   Evaluate your model by its score, some plots, a confusion matrix and generate a template to make predictions with new data

Eventually, we created **two UiPath robots**:

*   a first one to **interact with users** through Custom Input activity displaying the different pages of the web application
*   a second one based allowing users to **make predictions** with their trained models

Non-datascientists users can now train machine learning models by simply asking their robot to do it for them. Take data from an Excel file and train a supervised Machine Learning model.

d40eb302-525e-4bfe-bb17-9fcaf3a2f4e7.png

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version	Release Date	Download Link
1.1.7	July 22, 2019
First release
1.1.6	July 22, 2019
First release

HandyML