Skip to content

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

@SMitran10

Description

@SMitran10

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, 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. 
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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Machine Learningaz mlService AttentionThis issue is responsible by Azure service team.act-codegen-extensibility-squadbugThis issue requires a change to an existing behavior in the product in order to be resolved.customer-reportedIssues that are reported by GitHub users external to the Azure organization.needs-team-attentionThis issue needs attention from Azure service team or SDK team

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions