Free Trial

Alteryx Designer Desktop Discussions

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

chat GPT and Python

jonathanogrady
8 - Asteroid

hello alteryx fans!

 

One of the reasons I "love" alteryx is that I am not a coder. I'm able to use alteryx to do sophisticated analysis without having to open a command prompt!

 

I have been simultaneously using chat GPT, and using GPT 4 and the advanced analytics function, I've been able to bring data into the AI and then use prompts like the following:

 

I would like to write a Python script to analyse the data set 1 and dataset 2 to determine x, and then compare that with y. We can then compare over or under estimations with z. Where we equate the probability of a, given b as higher than a given see then… Et cetera

 

I have found Jaci be to be amazingly adept at understanding the analysis I want to perform and giving me great ideas as to the steps I need to take.

 

However, I only have a humble subscription and I keep hitting data limits. my full data set is 10 X what I have given chat GPT, but still I am being pushed back.

 

What I would ideally like to do is to use alteryx to create a step-by-step flow where I know exactly what cleaning and calculations I am doing. One way to do this is to simply use chat GPT as a guide and then laboriously do all of the minute formulas et cetera in alteryx.

 

However, a much better way would be to take the incremental pieces of Python script from chat GPT, paste them into the Python tool in alteryx, and cut out about 100 micro steps.

 

Trouble is, every time I paste the Python code into the tool, it doesn't really connect properly. Truth is I don't know what I'm doing.

 

I can't imagine I'm the only person who has thought of this "cheat". Maybe one of the more erudite members amongst us might be able to shine some light on this strategy, and point to some ways to make it work?

 

As always, extremely grateful for the community support.

 

Best wishes, J

 

 

4 REPLIES 4
jonathanogrady
8 - Asteroid

zero replies to this question after almost a week… Unusual!

 

Have I phrased the question poorly or am I at the bleeding edge? Unlikely!

 

If anyone has any thoughts please let me know!

Filclarke
6 - Meteoroid

Hi Jonathan,

 

Have you considered setting up some input data to flow into juptyer notebook tool (Python) and then start the conversation with Chat GPT at that point to develop the python needed.  ie. I have a data set that is the following (5 columns of what ever values, types etc), I want to write a python script that does the following to this data and outputs it as a data frame etc etc.

 

Therefore you are limiting the conversation to what you want to happen within python and the python tool in alteryx, the rest then shoudl be input, prep and output

jonathanogrady
8 - Asteroid

excellent idea.I will definitely give that a go. Thank you!

danieldeo
5 - Atom

I have some experience working with ChatGPT and Python. I would ask ChatGPT to output Python to set parameters of Z.

Labels
Top Solution Authors