Change data type using Azure Machine Learning Studio

Question

Allow me to ask again this question, as answers found on the forum did not help me so far.

I am trying to convert a column from 'string' into 'numerical' data type.

The column has no missing values and no errors, it comes from a CSV file. For the record, I tried modifing the format type of the column on the CSV file and saving it as a number, but later when importing the CSV file on Azure ML it was coded as string.

So far, I have tried the following options:

'Execute Python script'. Unfortunately it does not work . It returns an error when I run the experiment. The Code I entered is:
```
import pandas as df

def azureml_main (df):
  df.age=pd.to_numeric(df.age,errors=’coerce’)

return df
```
Use 'Edit Metadata' module. Select as Datatype: 'Integer' or 'Floating point' but I keep on getting an error when running the experiment.

Please kindly let me know what your thoughts are.

Thanks for your help.

Josep Maria

P.S: It's the second time I write in this forum. I hope this time it is well formulated. screenshot of 'Execute Python Script' error

What errors are you getting for each of those options that you tried? And can you give a sample of the data or let us know where you got it? — Jon
hi @Jon thanks for answering. How can I provide a screenshot of the error? It's errorcode 0085. Will it be ok if I update original question with a screenshot? — user10155602
Thanks @Jon, screenshot uploaded on original question. Thanks for your help. — user10155602
A couple of things to try in your script. Manually type in the quotes. It looks like it copied the formatting and that may cause errors. Also, try changing the indenting of the method. Python uses whitespace so if that's off that can also cause errors. — Jon

Jon Jon · Accepted Answer · 2018-08-04T09:35:26

It looks like the Python script just needs a little updating. :)

This should work since you get dataframe1 automatically as a pandas data frame.

import pandas as pd

def azureml_main(dataframe1 = None, dataframe2 = None):
  dataframe1.age = pd.to_numeric(dataframe1.age, errors="coerce")

  return dataframe1

Change data type using Azure Machine Learning Studio

1 Answers