of type str,datetime64,str,str,str,str,str,str,str,str,datetime64,str. The type is not supported by the module. Parameter name: Columns to transform.

Bhoopelly, Vijay 0 Reputation points
2023-10-20T15:46:18.6966667+00:00

Hi Team,

I am new to Azure ML and trying to train a model with the given below data. I am using the standard Normalize data component, when I submit the I am getting. Could you please assist me in this regards.

Cannot process column "Number,Opened,Short description,Caller,Legal Entity,Priority,State,Category,Assignment gr,Assigned to,Closed Date,Updated by" of type str,datetime64,str,str,str,str,str,str,str,str,datetime64,str. The type is not supported by the module. Parameter name: Columns to transform.

User's image

User's image

User's image

AmlExceptionMessage:Execution failed. User process '/azureml-envs/azureml_8f317849db35f281450cf74333640b98/bin/python' exited with status code 1. Please check log file 'user_logs/std_log.txt' for error details. Error:   File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modulehost/module_host_executor.py", line 63, in do_execute_with_env
    ModuleReflector(parser.module_entry, env).exec(
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modulehost/module_reflector.py", line 397, in exec
    self._handle_exception(bex)
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modulehost/module_reflector.py", line 471, in _handle_exception
    raise exception
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modulehost/module_reflector.py", line 379, in exec
    output_tuple = self._entry.func(**reflected_input_ports, **reflected_parameters)
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modulehost/module_reflector.py", line 76, in wrapper
    ret = func(*args, **validated_args)
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modules/datatransform/scale_and_reduce/normalize_data/normalize_data.py", line 71, in run
    output_values = NormalizeDataModule._run(**input_values)
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modules/datatransform/scale_and_reduce/normalize_data/normalize_data.py", line 102, in _run
    NormalizeDataModule._check_column_type(data_set=data_set, column_set=column_set)
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/modules/datatransform/scale_and_reduce/normalize_data/normalize_data.py", line 91, in _check_column_type
    ErrorMapping.throw(InvalidColumnTypeError(
  File "/azureml-envs/azureml_8f317849db35f281450cf74333640b98/lib/python3.8/site-packages/azureml/studio/common/error.py", line 835, in throw
    raise err
azureml.studio.common.error.InvalidColumnTypeError: Cannot process column "Number,Opened,Short description,Caller,Legal Entity,Priority,State,Category,Assignment gr,Assigned to,Closed Date,Updated by" of type str,datetime64,str,str,str,str,str,str,str,str,datetime64,str. The type is not supported by the module. Parameter name: Columns to transform.



ModuleExceptionMessage:InvalidColumnType: Cannot process column "Number,Opened,Short description,Caller,Legal Entity,Priority,State,Category,Assignment gr,Assigned to,Closed Date,Updated by" of type str,datetime64,str,str,str,str,str,str,str,str,datetime64,str. The type is not supported by the module. Parameter name: Columns to transform.
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,598 questions
{count} votes

1 answer

Sort by: Most helpful
  1. romungi-MSFT 42,586 Reputation points Microsoft Employee
    2023-10-23T08:58:50.3633333+00:00

    @Bhoopelly, Vijay It looks like you are trying to normalize data for all your columns rather than a specific set of columns which are numeric. Please see the reference for normalize data to understand how you can configure the module.

    Looking at the screenshot of your data, I don't think this module is even required in your case since there is no column with numeric data that needs normalization. I hope this helps!!

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments