Use interface tools on pandas Dataframe output from a python tool

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!

Developer Tools

Python

Interface Tools

Accepted answers

Robin_McIntosh

@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:

Discussion_Pandas_Dataframe_Update_Interface_Post_DataFrame.yxwz

Discussion_Pandas_Dataframe_Update_Interface_Pre_DataFrame.yxwz

apathetichell

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.

All comments

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

@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:

Discussion_Pandas_Dataframe_Update_Interface_Post_DataFrame.yxwz

Discussion_Pandas_Dataframe_Update_Interface_Pre_DataFrame.yxwz

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.

Thanks for your help! That worked

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703