How to pass a Python DataFrame to UiPath?

Question

I'm calling a python function using the UiPath Python Activities Pack (Get Python Object) and it returns a DataFrame in order to use it within UiPath. Unfortunately, UiPath is not able to convert the DataFrame to a .Net DataType like a DataTable.

Even when I try to convert the DataFrame to any other format (String, numpy array, html etc.) it is not working although the documentation mentions explicitly that all DataTypes are supported. The Python script does its work an stores the Content of the DataFrame in an Excel file and I could, of course, just read the Excel file. I was just wondering whether there is a way to directly pass the data to UiPath instead of saving it first and reading it again.

Are these Pandas DataFrames? – k2zinger May 14 '19 at 15:09 — k2zinger, May 14 '19 at 15:09
Yes, I was talking about pandas DF. – Mikkel May 15 '19 at 13:54 — Mikkel, May 15 '19 at 13:54

score 2 · Accepted Answer · answered May 15 '19 at 14:06

Actually, I spent quite some time on this but finally figured out how to pass the pandas DataFrame to UiPath and make it available there in a dataTable. I explain how I did it in the following:

Python Script:
I let the python function that I call in the UiPath 'Invoke Paython Method' activity return the pandas dataframe as a JSON string, i.e.

return df.to_json(orient='records')
Get Python Object:
Save the JSON string in a variable of type string
Deserialize JSON:
Choose 'System.Data.DataTable' as TypeArgument and store the result in a variable of type dataTable

Now the Data from the pandas dataFrame is available in a .Net dataTable in Uipath.

How to pass a Python DataFrame to UiPath?

1 Answers1