Use interface tools on pandas Dataframe output from a python tool

[Srini_N]

Hi,

I have a dataframe output on which I want use interface tools. I want users to input the values for a few specific fields. I tried to use the action tool but it isn't showing any of the fields to update when I use it on the select tool. Is there a way to do this?

Thanks in advance!

[Robin_McIntosh]

@Srini_N - Are you wanting to update the existing output data or add/value new fields within the dataframe output?

For instnace, the output is:

Name - Position

John - P

Mike - 1B

Brad - SS

And you want to update John's position from P to 3B?

Or you want to add new fields (i.e. Team) with values from the interface?

[Srini_N]

Hi Robin,

I have all null values in a column which I want to update with an input value from user

[apathetichell]

I would recommend updating this column either before or after your python tool. If before you use a text input tool which you can bring into your python tool. If after you would use a formula tool to change the value of a column which you created in pandas.

[Robin_McIntosh · Accepted solution]

@Srini_N  - Just as @apathetichell indicates, you can update before or after depending on your needs.  Different ways of going about it.

Here are 2 examples to illustrate; one of updating within the dataframe itself based on user input and one of updating after the dataframe via a formula using the user input.

--Passing the user input into the dataframe:

--Updating the field after the data is returned to Alteryx:

[Srini_N]

Hi Robin,

Thanks for the workflow. However, upon trying to do the same my workflow isn't updating the input value. It is running successfully but I don't see the value updated in the dataframe.

Do you know what might be causing the issue? 

P.S I'm trying to use the update tool post dataframe.

[apathetichell · Accepted solution]

You are running an app. That second screengrab does not mean that your workflow did not run. It means that you have nothing selected to show the user on a successful run. Go to interface designer. select your browse tool to show your output. re-run.

[Srini_N]

Thanks for your help! That worked