This is awesome! We're pretty close to not having to code at all for data analysis Makes me happy for those that can't code... but sad for someone like me that likes to code
Hey Luke, thanks for tuning in! Right now, I do enjoy using AI as a coding buddy, asking for snippets and insights as I go. You've hit the nail on the head, though. I can imagine that in the near future, coding might no longer be necessary in data analysis. We could see more powerful, AI-driven no-code tools doing the job. Let's see..
Great intro and thank you. Having worked with mission-critical corporate and life-critical healthcare data, someone has to have ownership and responsibility of analytical outputs. I can see how powerful this could be for getting some rapid analytical directions, but (at least for now), the absence of accountability and the high likelihood of errors is a show-stopper for critical work. I'm looking forward to seeing how it can function as a kind of junior assistant analyst. Cheers - Dave
Noob question :) I am a Blender user for (old school) architecture, with PandasAI can this be used in the Blender's Python console to read an external database, read to a written instruction, and respond by creating a 3D model? I'm thinking the external database would include a schedule of rooms that would include dimensions and areas, relationships to other rooms, equipment list and so on. Does this make sense? Cheers Nigel
Hey Nigel, thanks for checking out the video! Right now, PandasAI is mainly used for data analysis tasks and works closely with Pandas DataFrames. So, it can't take instructions from an external database and convert them into a 3D model (at least not yet).
With any dataframe i am running on this its giving me following error.. Even can't find solution on bing or chat gpt "data type 'int64' not understood " unfortunately i was not able to answer your question, because of the following error: data type 'int64' not understood "
not sure what the use case for this is when you can just paste in the git hub link into the prompt bar and Chat will analyze and help with errors or write documentation or whatever.
Do you think this is a good option for beginner python data analyst like me? Or rather I should focus on the mechanics of understanding the code first?
Nope, I think this would be the oposite. If you do not want to become a data analyst and you just want to have some easy questions solved, it could be a good idea. But data analysis is much more than this.
Honestly, I'm not entirely certain if there'll be a ton of coding required in data analysis down the line. I recently saw a demo of ChatGPT's code interpreter, and it practically wrote all the necessary Python code on its own. You simply ask a question about the uploaded data and ChatGPT handles the rest. That said, I still think that knowing how to code can be useful in a lot of areas, not just in data analysis. So, if coding is your thing, I'd totally recommend sticking with it.
@@CodingIsFun thats something that already was available in a certain grade with the possibility of employing queries with Pandas. I saw chatgpt and can answer simple questions, but not the complex ones, as well as you lose the control about what it is happening with the data, and the impossibility of verificating the result its giving you. They show it under controled situations, where you ask about small sets where the data is known.
@@CodingIsFun, thanks! Do you have recommendations for 2023 build up skills as a data analyst? My job is sort of dealing with that, but a lot of other things as well. I knew Excel, SPSS, and currently visualize with Looker studio and I started the SQL/Python libraries path. Not sure if this is the best way to go, but there is quite a lot of interesting stuff. Appreciate the channel, btw, easily one of the most down to earth explanations on youtube.
Hi! How do I give this "memory"? I want to use it in a sample chatbot. It should be aware of the context of the conversation as it goes on, then only it will be able to understand user's queries
Thanks for watching. I don't think it's possible, but it's better to check the AI's documentation or ask your question in the GitHub repo: github.com/gventuri/pandas-ai
I would not use, because of the same reason: I want to control what I do, how I do it and everything involved in the process. Also, once you know the syntaxis, the classic Pandas in Python is faster, and easy to change. I want to control what I save in the variables, and to be sure about the results. If you automatize some lines, you already do not control how it reached the result, and you even do not know or understan the result. If I employ the .nlargest() function, I know exactly what Pandas will do. If I just ask the AI about the top 5 countries by GDP, I do not know what it was doing, if the result is plausible, and what the AI understoo as the top5. The main problem with the OpenAI tools for data analysis is that you can never be sure if the result is what you meant. Other example: there is already time ago the posibility of using queries in Pandas, and as far as I know, it is still a not so popular option. And I think this is because of 2 reasons, the first one is that syntaxis does not improve in efectiveness or speed, and the second one is that you keep a less strict control over the operations.
I like the picture 🐼. And it's a short leap from here, but at this point it still needs a human to know what to ask, and to care what the results are. Plus, most places have little to zero technical analysts / tools, so if anything this would be another tool for their analysts - or have no effect at all... 🤷. What this could represent though, is the evolution of the AI's ability to give accurate info, versus "hallucinations" - even if used just to have it show how the answers were determined.
I think it's a matter of trust. I"m not sure that we are on this level yet, that serious business decisions could be made after prompting the chat gpt.
Thanks for tuning in. Since I don't have firsthand experience, I can't offer a lot of advice here. But you should totally check out this video from Luke: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vRbgun8ryVE.html. The stories from his guests are super inspiring. Good luck on your data journey! 🍀
That's great to hear, Ricardo. You know, sometimes I feel like I might not be needed anymore, given how quickly and clearly ChatGPT can generate and explain code. 😅
@@CodingIsFun I think aside from your teaching you're also offering journalism because each of these vids are suggestions for what tools to use to solve problems.