Uploading Your Own Dataset to Microsoft Azure Machine Learning

Hello readers. Previously, i have write little introduction and basic structure implementation for data analysis in Microsoft Azure Machine Learning. You can check it here: Cloud Prediction using Microsoft Azure Machine Learning  As continuation, this post right here will focus on how to upload your own data set to Microsoft Azure Machine Learning for later data analysis. 

1.Before uploading, make sure your dataset file in the correct arrangement which that Azure can understand and interpret. For the table it could understand single column at the top as the header for every column, but large number of row understandable by the system. Example as shown below.

After finish with the data, save as new document and make sure you select the save as type is CSV (Comma deliminated) (*.csv) not other type of CSV listed there.

2. After login to your Azure account, click NEW and then select DATASET, then click FROM LOCALE FILE.

3.Then click CHOOSE FILE and choose only .csv file because it the only file for data set that are supported and work properly in Microsoft Azure. After choosing the file, tick This is the new version of an existing dataset, if the dataset you upload is the new version for the old dataset with the same file name in your Azure. (Warning: Old dataset will be overwrite). 

If the dataset is the new one, just untick the option and put a new name for the dataset. Then click Done.Notification will shown at below panel when upload is done.

4.Open any existing experiment or create new experiment, then you'll notice new uploaded dataset at the Saved Datasets, click My Datasets, then you'll see your new dataset is there. Drag to the workspace and test the data. 

5.You can view your data whether it properly can be interpret. Make sure the number of rows and columns showed is same with the file you create in Microsoft Excel. The displayed data in the table is limited if you have large amount of data but the data is there. Confirm by checking the columns and rows number. Right click at the dataset in the workspace then click Visualize. 

If the dataset showed missing number of rows or columns, that means there is an error with the dataset file uploaded. Do check back in the Microsoft Excel. If it shows only one row and one column (all data in one line) please refer this post: Microsoft Azure Machine Learning Cannot Read .csv File?