bike rental data is string but Regression expects integer

Gary Tan 20

Hi There,

I am on "Fundamental of Machine Learning"- Exercise - Explore Automated Machine Learning in Azure Machine Learning.

When I am filling up information in "Task settings" page, Regression task type requires imported data set column "rental" to be integer, nevertheless the page prompts an error message. It mentions, the imported data set column "rental" is string. Due to that, I am unable to proceed to next step. Thanks.

dupammi 6,480 Reputation points Microsoft Vendor

2024-04-16T06:52:04.26+00:00
Hi @Gary Tan

Thank you for using the Microsoft Q&A forum.

To resolve the error message you're encountering, you'll need to convert the "rental" column in your data set to an integer data type. Please review below at your side:

Check the data set to ensure that the "rental" column is indeed a string.

Convert the "rental" column to an integer data type by "Edit Metadata" module in Azure Machine Learning. You can select the "rental" column and change the data type to "integer".

Rerun the Regression task type after converting the "rental" column to an integer data type.

Additionally, you can try the following steps to resolve the issue:

Check the data types of the features in the data set to ensure they are correctly identified. Mismatched or incorrect data types can sometimes cause issues during the data preparation step.

Check if any custom data preparation steps are being used and ensure they are correctly implemented and compatible with Azure Machine Learning.

Here is the more information on how to use the Edit Metadata component.

I hope this helps in further troubleshooting and fixing the issue you were facing.

Thank you.
dupammi 6,480 Reputation points Microsoft Vendor

2024-04-17T00:54:29.05+00:00

Hi @Gary Tan

We haven’t heard from you on the last response and was just checking back to see if you got a chance to see my above response.
Gary Tan 20 Reputation points

2024-04-17T08:30:00.0233333+00:00

Hi Dupammi,

Thank you for your reply.

Basically, I follow and import the dataset based on the training note from web

https://aka.ms/bike-rentals

I have no idea how to modify the dataset to integer, it is not part of the training steps, though.

Thanks
dupammi 6,480 Reputation points Microsoft Vendor

2024-04-17T10:21:07.9733333+00:00

Hi @Gary Tan

Thank you for giving more details on the documentation you were following for model training steps.

I reproduced the entire process in this document and was able to successfully train the model.

FYI, I also imported the dataset based on the training note from web -

https://aka.ms/bike-rentals

Please see below the successful model training completion:

Review Page before job submission:

Please follow this documentand you should be able to successfully train the model.

Thank you.
dupammi 6,480 Reputation points Microsoft Vendor

2024-04-18T01:22:04.9966667+00:00

Hi @Gary Tan

Have you got a chance to try the suggestions in my above response.
Gary Tan 20 Reputation points

2024-04-18T03:23:01.3066667+00:00

Hi Dupammi,

Now, I managed to validate the column 'rental' to be the integer now. I encounter next issue as I have followed all the steps nevertheless, I am still unable to proceed to next step, or as below the screen shots,

Thanks
dupammi 6,480 Reputation points Microsoft Vendor

2024-04-19T01:39:10.79+00:00

Hi @Gary Tan

Following up to see if you got a chance to check my above suggestion and if it was helpful.

Thank you.
Gary Tan 20 Reputation points

2024-04-19T03:53:41.2833333+00:00

Thanks dupammi it is working after I changed the iteration timeout from 5 to 15 min now. Will proceed the training.

Appreciated.
dupammi 6,480 Reputation points Microsoft Vendor

2024-04-19T04:02:03.25+00:00

Hi @Gary Tan

I'm glad that the provided suggestion helped you fix the issue. I'm converting my comment to answer.

Kindly accept the answer and upvote, so that others experiencing the same thing can easily reference that accepted answer!

Thank you for your patience throughout the issue resolution.

Accepted answer

dupammi 6,480 Reputation points Microsoft Vendor

2024-04-18T03:43:00.9366667+00:00

Hi @Gary Tan

Thank you for providing the screenshots and more detailed values selected.

It seems like the "Next" button was not enabled when the "Experiment timeout (minutes)" and "Iteration timeout (minutes)" fields were filled with values. This could be because the values entered were not valid or did not meet the requirements for the fields.

The "Experiment timeout (minutes)" field requires a value in minutes, and the "Iteration timeout (minutes)" field requires a value in minutes per iteration. If the values entered are not in the correct format or do not meet the requirements, the "Next" button will not be enabled.

To resolve this issue, you can try entering valid values for the "Experiment timeout (minutes)" and "Iteration timeout (minutes)" fields.

For debugging purpose, you can try leaving the fields blank and see if the "Next" button is enabled. If it is, you can proceed with the AutoML task.

For more information on how to configure the task settings in Azure Machine Learning's AutoML, please refer Configure automated ML experiments in Azure Machine Learning

I hope this helps in debugging to enable the "Next" button and proceed to next screens. Thank you.
Please sign in to rate this answer.

1 person found this answer helpful.
Gary Tan 20 Reputation points

2024-04-19T06:37:54.88+00:00

Thanks, I manage to move to next step!
Sign in to comment

bike rental data is string but Regression expects integer

0 additional answers