Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Outputing python results not working

Highlighted
Asteroid

I'm begining my python adventure but found issue with extracting data back to the workflow from python tool.

 

Using pandas I want to simply extract values from one column. After assigning variable I get below:

 

mszpot89_0-1581670550521.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @mszpot89,

 

What you are extracting like this is a pandas Series.

 

If you want to output it you would need a pandas dataframe.

 

Try to add the following

 

ct = pd.DataFrame(df['CreationTime'])

 

Not elegant but works!

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
Asteroid

 

Alternative

df = pd.DataFrame(data['CreationTime'])

 

Alteryx Certified Partner
Alteryx Certified Partner

Much cleaner you solution for sure!

 

Just edited the last row.

 

If you need anything else here we are to help as much as possible!

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels