Python Pandas DataFrame with only a single number stored?

Question

AzureML's Python Script module requires to return a Pandas DataFrame. I want to return only a value and I do this:

result=7
dataframe1=pd.DataFrame(numpy.zeros(1))
dataframe1[0][0]=result

by which I am able to return just a single value in Azure ML's Python Script module.

What is a proper way to create a pandas DataFrame with a single value?

@EdChum I tried that but it did not work in Azure ML, it complained something about the wrong type as a return type. — hhh, Jun 07 '17 at 09:52
Well the only different here is that your version produces a df with dtype float, my snippet would preserve the result as `int`, does AzureML require floats? If so you can do `pd.DataFrame([result], dtype=float)` — EdChum, Jun 07 '17 at 09:54

score 1 · Answer 1 · answered Jun 07 '17 at 10:05

As EdChum commented

dataframe1=pd.DataFrame([result], dtype=float)

and it works, tested, instead of

result=7
dataframe1=pd.DataFrame(numpy.zeros(1))
dataframe1[0][0]=result

where we don't need to use numpy to initiate the return value with zeroes.

P.s. EdChum can make this his answer if he wants.

score 1 · Accepted Answer · answered Jun 08 '17 at 03:24

1

Following code should work:

import pandas as pd
def azureml_main(dataframe1 = None, dataframe2 = None):
    result = pd.DataFrame({'mycol': [123]})
    return result,

answered Jun 08 '17 at 03:24

2 Answers2