Azure / Azure/azure-cli

following coursera instructions to upload cvs file to test Automated ML but it doesn't separate the data into columns

Open
#27,219 5 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad bug customer-reported Machine Learning needs-team-attention Service Attention
Dominant language
Python
Stars
4.6k
Forks
3.5k
Avg merge
3d 2h
Merged PRs (30d)
60

Description

### Describe the bug

When configuring the job, the target column is a pull down. There are no columns. I'd checked the data and have uploaded the data several times but it still is not separating data into columns. Instructions were:

Create a dataset
In Azure Machine Learning, data for model training and other operations is usually encapsulated in an object called a dataset.
1. View the comma-separated data at https://aka.ms/bike-rentals in your web browser. Then save this as a local file named daily-bike-share.csv (it doesn't matter where you save it).
2. In [Azure Machine Learning studio](https://ml.azure.com/), view the Datasets page. Datasets represent specific data files or tables that you plan to work with in Azure ML.
3. Create a new dataset from local files, using the following settings:
Basic Info:
• Name: bike-rentals
• Dataset type: Tabular
(I tried MTable or something but it didn't work either)
• Description: Bicycle rental data
Datastore and file selection:
• Select or create a datastore: Currently selected datastore
• Select files for your dataset: Browse to the daily-bike-share.csv file you downloaded.
• Upload path: Leave the default selection
• Skip data validation: Not selected
Settings and preview: ---- something here is wrong!!!
• File format: Delimited
• Delimiter: Comma
• Encoding: UTF-8
• Column headers: Only first file has headers
• Skip rows: None
Schema: ----or this one is wrong!!!
• Include all columns other than Path
• Review the automatically detected types
Confirm details:
• Do not profile the dataset after creation
4. After the dataset has been created, open it and view the Explore page to see a sample of the data. This data contains historical features and labels for bike rentals. (The result is one column with 50/731 rows. So, either the data needs to be clean because something is off or the tool isn't reading the data correctly, which one it is?)

### Related command

I am using Aumated ML on Azure Machine Learning Studio so I am not entering commands.

### Errors

"Target column is required" obviously!!

### Issue script & Debug output

I can't alter the script so that isn't it...

### Expected behavior

tool should have noticed that the data was comma delimited and separated it automatically into columns so that the "rental" column can be selected to run the Automated ML experiment (or whatever it is called)

### Environment Summary

Configure job
Select from existing experiments or create a new experiment, then select the target column and training compute.
[Learn more on how to configure the experiment. ](https://docs.microsoft.com/azure/machine-learning/how-to-use-automated-ml-for-ml-models#create-and-run-experiment)
Data asset
bike-rentals7(View data asset)
Experiment name

New experiment name

Target column

Target column is required
1 result found for rentals
Select compute type
Select Azure ML compute cluster

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.