To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach/. The first 200 of you will get 20% off Brilliant’s annual premium subscription
In your prompt for the bar plot, try having it work in steps. "Calculate the total spent by each gender. Plot those numbers in a bar plot." Phrased that way, see if you get the correct plot.
Thanks for this video. I´m working a lot with pandas, so this is definitively a new way to process data. Amazing to see how AI can make our lives (in programming) easier.
I have this same problem with chatgpt 4 in just LLM form. Sometimes it makes up numbers. I think if you are more specific like “create a bar plot based on the previous calculation” it will be more accurate.
Thank you for this video - I wonder whether it is possible to use pandasAI to extract data from multiple documents and store them in an editable series of form fields such that a user will be able to speed up the process of data extraction...
5:50 That's weird, it looks like its only totaling the first five rows of the dataframe. I wonder if you'd get the correct results if you specified to use the entire dataframe in your prompt
i have an stock data, while sum the stock qty, i want to apply some number to char convertion funtion how to do... in pandas ai EX: stock qty=1111 i want a result 1 ctn/1pkt/1 box/1 pcs like this
Pandas AI looks great. I wonder if you were using the GPT4 API it would have made that mistake. I have found GPT4 a massive improvement over chatGPT and wonder if you'd see that improvement here too. And also how it compares to Interpretor in chatGPT. And I assume you can use it with the other LLMs on Hugging Face? Exciting times, especially for those of us who don't know much about coding.
I keep getting this error "data type 'Int64 not understood' I have tried to search solution in pandas ai git but still can understand solution. Please help
1st time I use the API key but in VSCODE after running my code showed this "You exceeded your current quota, please check your plan and billing details." Does anyone help me.....🙏🙏🙏🙏
It might be the first time you use your API key but probably your free trial have already expired. I think it started the day you created your OpenAI account. You have to either create a new account or add a payment method
how to buy Tokens ? i am getting the following message "Unfortunately, I was not able to answer your question, because of the following error: You exceeded your current quota, please check your plan and billing details. "
It is very helpfull video, But i got this error "ImportError: cannot import name 'PandasAI' from 'pandasai' " i cant handle this could you give us some updates please :)
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/ThePyCoach/. The first 200 of you will get 20% off Brilliant’s annual premium subscription
In your prompt for the bar plot, try having it work in steps.
"Calculate the total spent by each gender. Plot those numbers in a bar plot."
Phrased that way, see if you get the correct plot.
Thanks for this video. I´m working a lot with pandas, so this is definitively a new way to process data. Amazing to see how AI can make our lives (in programming) easier.
I tried your tutorial today, and found they fixed this problem.
I have this same problem with chatgpt 4 in just LLM form. Sometimes it makes up numbers. I think if you are more specific like “create a bar plot based on the previous calculation” it will be more accurate.
Thank you for this video - I wonder whether it is possible to use pandasAI to extract data from multiple documents and store them in an editable series of form fields such that a user will be able to speed up the process of data extraction...
This is very cool!! Have learned a new or better method to chat with data?
I got this error: ImportError: cannot import name 'PandasAI' from 'pandasai'. How to solve it pls?
did you resolve the error?
@@abhishekghimire3539 you need to create SmartDataframe
5:50 That's weird, it looks like its only totaling the first five rows of the dataframe. I wonder if you'd get the correct results if you specified to use the entire dataframe in your prompt
thanks very helpful.❤
can use local hosted llm like TheBloke/Pandalyst-7B-V1.1-GGUF as llm for pandas ai instead of openai ??
please make video ??🙏
Promising idea👏
i have an stock data, while sum the stock qty, i want to apply some number to char convertion funtion how to do... in pandas ai
EX: stock qty=1111
i want a result 1 ctn/1pkt/1 box/1 pcs like this
When I use PandasAI and give it the dataframe, is that data being sent to openAI servers?
What is the difference between this and ChatGPT's noteable plugin?
How much it $ cost everytime you run a code whith the api?
Pandas AI looks great. I wonder if you were using the GPT4 API it would have made that mistake. I have found GPT4 a massive improvement over chatGPT and wonder if you'd see that improvement here too. And also how it compares to Interpretor in chatGPT. And I assume you can use it with the other LLMs on Hugging Face? Exciting times, especially for those of us who don't know much about coding.
Good question. I believe the account I'm using doesn't have access to GPT-4. Yeah, you're right you can use it with Hugging Face too
Excellent!
how to slove this error
UnicodeEncodeError: 'latin-1' codec can't encode character '\u200b' in position 7: ordinal not in range(256)
I just start using Langchain. Is pandaai better?
Is PanadasAI stable? Not getting as expected
hey Although I am using Paid API key, the API is taking long time to respond. is there any chance , we can improve the Performance
I keep getting this error
"data type 'Int64 not understood'
I have tried to search solution in pandas ai git but still can understand solution. Please help
1st time I use the API key but in VSCODE after running my code showed this "You exceeded your current quota, please check your plan and billing details." Does anyone help me.....🙏🙏🙏🙏
It might be the first time you use your API key but probably your free trial have already expired. I think it started the day you created your OpenAI account. You have to either create a new account or add a payment method
@@ThePyCoach Boss I there any other methods to use API or get API ???
Tell me my friend also using ChatGPT but their API working fine but mine not
Is this using the free or paid account from OpenAI?
probably will be something similar in the future with other libraries like scipy numpy etc
Is it okay to display your token publicly like that?
It's not. That's why I deleted the token after making the video 😉
I get this error: This model's maximum context length is 4097 tokens
How can i solve it?
you could try using word embeddings or langchain
how to buy Tokens ? i am getting the following message
"Unfortunately, I was not able to answer your question, because of the following error:
You exceeded your current quota, please check your plan and billing details.
"
I figured it out ...
@@parikannappan1580 how?
Is there anything similar to pandasAi
I think the problem is related to conversational memory maybe?
Not quite sure. Hopefully they'll fix this soon
It is very helpfull video, But i got this error "ImportError: cannot import name 'PandasAI' from 'pandasai' " i cant handle this could you give us some updates please :)
Did you install it in your environment? That typically shows up when the package hasn't been installed.
Should send the code back too