Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

SOLVED

Outputing python results not working

Highlighted
8 - 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
8 - Asteroid

 

Alternative

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

 

Highlighted
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