--- title: Data wrenching with Azure Machine Learning Workbench description: Hi all, This blog post will cover how to transform data with Azure Machine Learning Workbench. One of the most important aspects in any Machine learning pr --- [Skip to the main content.](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#main-content) - [Privacy Policy](https://uptec.io/privacy-policy-1) - [Modern Slavery](https://uptec.io/modern-slavery-statement) - [Net Zero Pledge](https://uptec.io/en-us/net-zero) [![Logo-Transparant](https://uptec.io/hs-fs/hubfs/Logo-Transparant.png?width=936&height=804&name=Logo-Transparant.png "Logo-Transparant")](https://uptec.io/) [![Logo-Transparant](https://uptec.io/hs-fs/hubfs/Logo-Transparant.png?width=936&height=804&name=Logo-Transparant.png "Logo-Transparant")](https://uptec.io/) - [Home](https://uptec.io) - [Products](https://uptec.io/products) - [Services](https://uptec.io/services) - [About](https://uptec.io/about) - [News & Insights](https://uptec.io/blog) - [Contact Us](https://uptec.io/contact-us) - [Careers](https://uptec.io/careers) Search Toggle Menu Search Toggle Menu - [Home](https://uptec.io) - [Products](https://uptec.io/products) - [Services](https://uptec.io/services) - [About](https://uptec.io/about) - [News & Insights](https://uptec.io/blog) - [Contact Us](https://uptec.io/contact-us) - [Careers](https://uptec.io/careers) [Facebook](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#0) [Instagram](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#0) [Linkedin](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#0) [X](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#0) [YouTube](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#0) [Medium](https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench#0) 3 min read # Data wrenching with Azure Machine Learning Workbench [Admin](https://uptec.io/blog/author/admin) : Dec 8, 2023, 1:32:00 PM Hi all, This blog post will cover how to transform data with Azure Machine Learning Workbench. One of the most important aspects in any Machine learning project is how accurate and how good your data is. If you have un-accurate or bad data the learning or simulation models will generate bad results. The main components of Azure Machine Learning are: - Azure Machine Learning Workbench (which is what we will use today to prepare our data) - Azure Machine Learning Experimentation Service (to be able to use Azure ML Workbench we need an Experimentation Service) - Azure Machine Learning Model Management Service - Microsoft Machine Learning Libraries for Apache Spark (MMLSpark Library) - Visual Studio Code Tools for AI Have a look here for a quick overview of [Azure Machine Learning](https://docs.microsoft.com/en-au/azure/machine-learning/preview/overview-what-is-azure-ml) and a detailed description of the different Machine learning components. We will create a new Azure ML Experimentation Service first, after which we will download and install Azure ML Workbench. # Azure Machine Learning Experimentation Service The Experimentation Service handles the execution of machine learning experiments. It also supports the Workbench by providing project management, Git integration, access control, roaming, and sharing. Through easy configuration, you can execute your experiments across a range of compute environment options: - Local native - Local Docker container - Docker container on a remote VM - Scale out Spark cluster in Azure Today we will not execute any experiments. We will just show how to transform the data. Let’s create our new Azure ML learning account: 1. Select the **New** button (+) in the upper-left corner of the Azure portal. 2. Enter **Machine Learning** in the search bar. Select the search result named **Machine Learning Experimentation (preview)**. I selected the DevTest SKU [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb.png?width=244&height=233&name=image_thumb.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image.png) After filling in the required information and submitting the deployment you should see the following: [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-1.png?width=244&height=101&name=image_thumb-1.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-1.png) # Azure Machine Learning Workbench Now that we have our Azure ML Learning account we can install Azure ML Workbench. Azure ML Workbench is a desktop application plus command-line tools, supported on both Windows and macOS. It allows you to manage machine learning solutions through the entire data science life cycle: - Data ingestion and preparation - Model development and experiment management - Model deployment in various target environments You can install Azure Machine Learning Workbench on your computer running Windows 10, Windows Server 2016, or newer. 1. Download the latest Azure Machine Learning Workbench installer [AmlWorkbenchSetup.msi](https://aka.ms/azureml-wb-msi). [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-2.png?width=244&height=180&name=image_thumb-2.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-2.png) Double-click the downloaded installer **AmlWorkbenchSetup.msi** from File Explorer. The installer downloads all the necessary dependent components, such as Python, Miniconda, and other related libraries. The installation might take around half an hour to finish all the components. [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-3.png?width=244&height=181&name=image_thumb-3.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-3.png) 1. After the installation process is complete, select the **Launch Workbench** button on the last screen of the installer. 2. Sign in to Workbench by using the same account that you used earlier to provision your Azure resources. 3. When the sign-in process has succeeded, Workbench attempts to find the Machine Learning Experimentation accounts that you created earlier. It searches for all Azure subscriptions to which your credential has access. When at least one Experimentation account is found, Workbench opens with that account. It then lists the workspaces and projects found in that account. [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-4.png?width=244&height=134&name=image_thumb-4.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-4.png) ## Create a new project 1. Start the Azure Machine Learning Workbench app and sign in. 2. Select **File** > **New Project** (or select the **+** sign in the **PROJECTS** pane). 3. Fill in the **Project name** and **Project directory** boxes. **Project description** is optional but helpful. Leave the **Visualstudio.com GIT Repository URL** box blank for now [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-5.png?width=244&height=92&name=image_thumb-5.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-5.png) Select Blank Project: [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-6.png?width=125&height=244&name=image_thumb-6.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-6.png) I downloaded a dataset from https://www.kaggle.com/datasets that I will be using here as an example. To bring data into a project using the data source wizard. Select the **+** button next to the search box in the data view and choose Add Data Source [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-7.png?width=244&height=172&name=image_thumb-7.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-7.png) In my case I used Excel as the data source [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-8.png?width=244&height=199&name=image_thumb-8.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-8.png) You can specify one or more sampling strategies for the dataset, and choose one as the active strategy. The default is to load the Top 100 rows. I changed it to load the full file [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-9.png?width=244&height=73&name=image_thumb-9.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-9.png) Once the data has been imported you will see the following screen [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-10.png?width=244&height=134&name=image_thumb-10.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-10.png) # Create a Data Preparation Package Now that we have our datasource we will prepare our data by creating a **Data Preparation Package** that we will use to transform our data. 1. Click the ‘Data’ icon again 2. Right click on the `flights` data source and click ‘Prepare’ 3. Add a ‘Data Preparation Package Name’ then press ‘OK’ [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-11.png?width=193&height=244&name=image_thumb-11.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-11.png) This will then create a flights`.dprep` file in your project directory, and will show a page almost similar to what we’ve seen after we’ve added a data source. # Derive Column By Example Transformation We will now transform our month column from numeric values to a string with the derive column by example. Azure ML Workbench synthesizes a program based on the examples provided by you and applies the same program on remaining rows. All other rows are automatically populated based on the example you provided. Workbench also analyzes your data and tries to identify edge cases. Select the column you want to transform, click derive column by example [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-12.png?width=207&height=244&name=image_thumb-12.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-12.png) A new column will appear with null values. Click in the first empty cell in the new column and provide an example. In my case I typed January to transform my numeric value of 1 (first month of the year) to January. [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-13.png?width=157&height=244&name=image_thumb-13.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-13.png) Select OK to accept the changes. You should now see the following: [![image](https://uptec.io/hs-fs/hubfs/Imported_Blog_Media/image_thumb-14.png?width=244&height=39&name=image_thumb-14.png "image")](https://uptec.io/hubfs/Imported_Blog_Media/image-14.png) That’s how easy it is to transform data with Azure ML Workbench. Imagine doing this with Excel?! For more examples regarding data transformation have a look [here](https://docs.microsoft.com/en-au/azure/machine-learning/preview/tutorial-bikeshare-dataprep#use-by-example-transformations). Thanks, Alex - [Tweet](https://twitter.com/share) 2 min read #### [Configure regional settings on Azure Virtual Machines](https://uptec.io/blog/configure-regional-settings-and-windows-locales-on-azure-virtual-machines) [Alexandre Verkinderen](https://uptec.io/blog/author/alexandre-verkinderen) : Dec 8, 2023, 1:32:00 PM By default every Windows virtual machine that you deploy in Azure from the marketplace will be deployed using US regional settings. So the timezone,... [Read More](https://uptec.io/blog/configure-regional-settings-and-windows-locales-on-azure-virtual-machines) 1 min read #### [How to use Azure CDN for WordPress](https://uptec.io/blog/how-to-use-azure-cdn-for-wordpress) [Alexandre Verkinderen](https://uptec.io/blog/author/alexandre-verkinderen) : Dec 8, 2023, 1:32:00 PM In this blogpost I will show you how you can use Azure CDN to improve the performance of your WordPress site. I’m running WordPress for my blog and... [Read More](https://uptec.io/blog/how-to-use-azure-cdn-for-wordpress) [![Publish the new Azure API Management Service Developer Portal behind an Application Gateway](https://uptec.io/hubfs/Imported_Blog_Media/2020-06-10-AzureAPI-vnet.png)](https://uptec.io/blog/publish-new-azure-apim-developer_portal) 2 min read #### [Publish the new Azure API Management Service Developer Portal behind an Application Gateway](https://uptec.io/blog/publish-new-azure-apim-developer_portal) [Alexandre Verkinderen](https://uptec.io/blog/author/alexandre-verkinderen) : Dec 8, 2023, 1:32:00 PM There are currently 2 developer portals for the Azure API Management service: a legacy portal and the new portal experience. We deployed our Azure... [Read More](https://uptec.io/blog/publish-new-azure-apim-developer_portal) ##### Australia Australia 77 Cinnamon Meander Two Rocks, WA 6037, Australia ABN: 48 643 822 833 ##### Europe Europe Margote Wichelen 9260, Belgium ##### New Zealand New Zealand Suite A Floor 8 Harbourview Building, 152 Quay Street Auckland Central 1010, New Zealand  NZBN: 9429051226893 ##### About About Uptec acknowledges the Traditional Owners of Country throughout Australia and acknowledges their continuing connection to land, waters and community. We pay our respects to the people, the cultures and the Elders past and present.     © 2026 Uptec Pty Ltd [Linkedin](https://au.linkedin.com/company/uptecio) Return to top ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Admin", "url" : "https://uptec.io/blog/author/admin" }, "dateModified" : "2024-12-08T02:36:38.648Z", "datePublished" : "2023-12-08T02:32:00.000Z", "headline" : "Data wrenching with Azure Machine Learning Workbench", "mainEntityOfPage" : { "@id" : "https://uptec.io/blog/data-wrenching-with-azure-machine-learning-workbench", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://uptec.io/hubfs/Logo.jpg" } } } ```