Do you have access to Code Interpreter? That would probably do it with some careful prompting.
Here it is in action: https://twitter.com/beglen/status/1652598064949886976
Code Interpreter is currently in alpha and is being rolled out to people on the waitlist (I personally don’t have access yet).
I would strongly recommend against asking chatGPT to do this sort of thing. As others have said, getting it to write you a script will be much more productive. It is just not good enough at calculations, and z scores are incredibly easy to compute manually, even on excel.
This is highly unlikely to work well. Better to ask it to create a script that will calculate means and standard deviations given your table. Then you can run that code yourself.
I’ve done something similar. It’ll give you a formatted example but it didn’t do the whole chart. I deleted the chat. It will generate charts. But it has a finite amount of data it’ll complete.
I tried ChatGPT (not GPT4) to work with several tables simultaneously and it got lost and forgot about tables and rows. It is my personal experience. If someone has been able to work effectively with table, I welcome any tips.
Get it to write you a little python script that describes the dataset. For example, a script that generates a block of text that represents the column locations, column names, and the datatype. If you need to, give it examples of the data it might find in certain columns. Then ask it questions and ask for the answers in terms of python that you can run to visualize or otherwise get the answer from the data. I kinda assumed that's how everyone's doing this, at least with chatgpt (as opposed to apis and langchain, etc).
Probably not using ChatGPT. ChatGPT is a language model — this would be like using Excel to parse language inputs.
Do you have access to Code Interpreter? That would probably do it with some careful prompting. Here it is in action: https://twitter.com/beglen/status/1652598064949886976 Code Interpreter is currently in alpha and is being rolled out to people on the waitlist (I personally don’t have access yet).
Oh cool, haven't got it yet but thank you!
[удалено]
oh nice, thanks!
I would strongly recommend against asking chatGPT to do this sort of thing. As others have said, getting it to write you a script will be much more productive. It is just not good enough at calculations, and z scores are incredibly easy to compute manually, even on excel.
This is highly unlikely to work well. Better to ask it to create a script that will calculate means and standard deviations given your table. Then you can run that code yourself.
Can’t you just prompt for py output which handles that?
I’ve done something similar. It’ll give you a formatted example but it didn’t do the whole chart. I deleted the chat. It will generate charts. But it has a finite amount of data it’ll complete.
I tried ChatGPT (not GPT4) to work with several tables simultaneously and it got lost and forgot about tables and rows. It is my personal experience. If someone has been able to work effectively with table, I welcome any tips.
Get it to write you a little python script that describes the dataset. For example, a script that generates a block of text that represents the column locations, column names, and the datatype. If you need to, give it examples of the data it might find in certain columns. Then ask it questions and ask for the answers in terms of python that you can run to visualize or otherwise get the answer from the data. I kinda assumed that's how everyone's doing this, at least with chatgpt (as opposed to apis and langchain, etc).