Can you create an MLTable Dataset (Tabular Format) from a CSV file?

Question

Can you create an MLTable Dataset (Tabular Format) from a CSV file?

Jason Hoffman 11

I have collected data that I'd like to use in AutoML to see if there's a pattern that can be derived from the data. According to docs, the data needs to be uploaded in the MLTable format in order to be used in AutoML. However, my data is currently in CSV format. There are fairly clear instructions on how to create an MLTable data asset, but the instructions assume your data starts in MLTable format (see the Note: "The path points to the folder containing the MLTable artifact"). I can't seem to find any instructions on how to create the MLTable artifact/folder in the first place, so I can't follow these instructions. Do these instructions exist somewhere? If so, is it possible for someone to link me to it or describe this process? Thank you!

Ramr-msft 17,826 Reputation points

2022-10-17T06:12:18.89+00:00

@Jason Hoffman Thanks for the question. You can create the MLtable from the .csv as shown below.

Here is the document for the supported Types.
Jason Hoffman 11 Reputation points

2022-10-17T18:21:34.623+00:00

Thanks for your reply. I cannot try this at the moment because I keep getting an Error that says "Service temporarily unavailable. Please try again later." when I try to load my workspace (see attached image). I guess I will have to just wait to try again later, unless you have a suggestion about how to deal with this error.
Jason Hoffman 11 Reputation points

2022-10-17T21:07:36.297+00:00

I must be doing something differently from you, as the data asset creation page is not giving me the option to upload a CSV. Can you please walk me through how you got to this screen. I see the screenshot below.

One additional note is that my CSV is not my personal data, and I do not have the authority to upload it to a publicly available URL location. Therefore, I need to upload it from my local files.
Ramr-msft 17,826 Reputation points

2022-10-18T02:53:35.09+00:00

@Jason Hoffman Thanks for the details. Here are the steps from creating the local file.
https://learn.microsoft.com/en-us/azure/machine-learning/how-to-create-data-assets?tabs=Studio#create-a-mltable-data-asset

Your answer

Ramr-msft 17,826 Reputation points

2022-10-17T06:12:18.89+00:00

@Jason Hoffman Thanks for the question. You can create the MLtable from the .csv as shown below.

Here is the document for the supported Types.
Jason Hoffman 11 Reputation points

2022-10-17T18:21:34.623+00:00

Thanks for your reply. I cannot try this at the moment because I keep getting an Error that says "Service temporarily unavailable. Please try again later." when I try to load my workspace (see attached image). I guess I will have to just wait to try again later, unless you have a suggestion about how to deal with this error.
Jason Hoffman 11 Reputation points

2022-10-17T21:07:36.297+00:00

I must be doing something differently from you, as the data asset creation page is not giving me the option to upload a CSV. Can you please walk me through how you got to this screen. I see the screenshot below.

One additional note is that my CSV is not my personal data, and I do not have the authority to upload it to a publicly available URL location. Therefore, I need to upload it from my local files.
Ramr-msft 17,826 Reputation points

2022-10-18T02:53:35.09+00:00

@Jason Hoffman Thanks for the details. Here are the steps from creating the local file.
https://learn.microsoft.com/en-us/azure/machine-learning/how-to-create-data-assets?tabs=Studio#create-a-mltable-data-asset

Share via

Can you create an MLTable Dataset (Tabular Format) from a CSV file?

Your answer