A Tableau Alternative in Python for Data Analysis (in Streamlit & Jupyter) | PyGWalker Tutorial
Вставка
- Опубліковано 9 чер 2024
- 👉 DOWNLOAD MY EXCEL ADD-IN: pythonandvba.com/mytoolbelt
Get started with PyGWalker, a straightforward Python library turning your Pandas dataframes into a visually interactive interface. Seamlessly integrate it into your Jupyter Notebook or Streamlit apps and make your data exploration as intuitive as using Tableau.
In this tutorial, I walk you through the PyGWalker functionalities, its integration with Streamlit, and how you can use it as a handy alternative to Tableau in Python.
📑 Get the source code here: github.com/Sven-Bo/PyGWalker-...
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
0:00 - Intro
0:15 - Setup & Dataset
0:31 - PyGWalker in Notebooks
4:00 - PyGWalker in Streamlit
5:01 - Outro
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website: pythonandvba.com
📝 GitHub: github.com/Sven-Bo
⭐ Discord: pythonandvba.com/discord
📷 Instagram: / codingisfun_official
▶️ Subscribe: ua-cam.com/users/CodingIsFun?sub...
📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations: pythonandvba.com/resources
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
pythonandvba.com/coffee-donation
Really nice video. I love that one. Thank you. Continue like this, it really inspires me.
Glad to heat, that you liked this one too, Ricardo. As always, thanks a lot for your support and comments! ♥👍
I love your content, thanks to you I now extensively use streamlit.
Happy to hear that you enjoy my content. Happy Streamlit-ing! 🤓
This is very helpful. Sending cheers from PH.
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Greetings to the Phils! It's more fun in the Philippines! :)
beautiful, glad I just discovered this! thank you
Glad you found me :) Cheers, Sven ✌️
Luv your videos, wish there was some Python course made by you on youtube, you are really good in explaining everything step by step
Thanks for the kind words! I am glad you enjoyed it. 👍
wow, I learn new things today. Thank you
Happy to hear that! :)
Pretty cool library. Thanks for sharing 👍
You're very welcome! Thank you for watching and for the comment!
Excellent video. Thanks for sharing this.
Glad you liked it. Thanks for watching and taking the time to leave a comment!
Awesome! Thank you for the great content!
My pleasure! Appreciate you taking the time to watch and leave a comment. :)
Insightful content, thanks :-)
Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍
¡Magnífico, excelente, soberbio!, eres un genio, gracias por compartir esta información y tus conocimientos, ¡mas por favor! saludos desde Venezuela
Gracias por tu apoyo. ¡Seguiré compartiendo! Saludos. 🤓
Really cool. Want more videos on this
Well noted! Thanks for watching and commenting! :)
Such a nice contents :) Thank you 🙏
Happy to hear that you enjoyed this one too! Thanks for the comments and support, as always! 🤩👍
Amazing in everything, thanks, and best wishes, I love it soooooooooo much
I'm thrilled you enjoyed it! Thanks for commenting and watching.
Amazing content, thank you for sharing sir.
An absolute pleasure, very happy to hear that you found it useful!
Thank you Sven! Easy, but very useful as always:)
Glad to hear that! Thanks for watching and taking the time to leave a comment! 👍
@@CodingIsFunBTW, do you know how extend "capacity" of this library in jupyter-notebook? It sees, it doesnt work with DataFrames bigger than 20k rows.
@@marsshakirov4507 Nice spot! I've taken a look at the GitHub repository. As of now, I haven't noticed any issues raised about this particular matter. What I did find is that it could be related to the memory capacity of the browser, based on this discussion: github.com/Kanaries/pygwalker/discussions/71
Unfortunately, I don't have a solid solution for you at the moment. You might want to consider raising an issue on the GitHub page though, to bring it to the attention of the developers.
@@CodingIsFun Thank you for response!
This is AMAZING!
Glad to hear you liked it! Thank you for commenting and watching.
Nice work!!!
Thank you! :)
Thank you for this informative video. I like your videos. Keep it up🙂.
I'm so happy to hear that you've found the videos useful! Thanks for watching! :)
I Love it.Thanks a lot
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
Thank you - it works.
My pleasure! Happy to hear, that it also works on your end. 💪
great video, thanks for inspiration. I've testet PyGWalker a little bit, in fact it's possible to create interactive charts in a quick way...
Thanks for leaving a comment and for taking the time to watch! Glad you liked it. Cheers, Sven ✌️
Super cool!
Glad you liked it. Thanks for watching. :)
very nice!!
Thank you! Cheers! 👍
wow this was amazing ty so much for such a great video but i wonder if it would work on larger datasets
Thanks for watching. In another comment, a viewer mentioned that he was not able to use a dataframe >20k rows. I've taken a look at the GitHub repository. As of now, I haven't noticed any issues raised about this particular matter. What I did find is that this limit could be related to the memory capacity of the browser, based on this discussion: github.com/Kanaries/pygwalker/discussions/71
Thanks
My pleasure! Appreciate you taking the time to watch and leave a comment.
Fascinating. Is there a map option if you have lays and longs as part of your data set?
Thanks for watching. As far as I can see, only the charts shown at the 1:45 min mark are available.
Cooooooool!!
Thanks! :)
Is it possible to export the results of a pygwalker chart in .csv or .xlsx format? Or perhaps the exported json code could be converted to a pandas df that is then exported?
Great video, let me know what you think!
Thanks for watching. I do not think that is possible. At least, I have not seen any option to do so.
Hi bro. Good video. Is there drill down functionality similar to tableau ?
Thanks for watching. Not sure about that. Please check out the docs
awesome vid as usual. Any idea how to remove the login icon beside ' export_code' ?
Thanks for watching. Not that I know of.
@@CodingIsFun
Thank You again.. here is the solution in case someone looking for:
import pygwalker_utils.config as pyg_conf
pyg_conf.set_config( { 'privacy': 'offline' })
One of the developers shared.
@@TimePasser Thanks for sharing
Great video!
I'm stuck with an error:
"Dataframe is too large for ipynb files. Only 50928 sample items are printed to the file." And the streamlit app displays nothing.
Thanks for watching. You might want to raise an GitHub issue
Great video, i am trying to pull a csv, instead of a url, when i call streamlit, the pygwalker dont display on the app, any suggestion ?
Thanks for watching and for your question. Hard to tell from a distance why you are facing an error. Sorry that I cannot help.
Cool app
Thanks! 👍
Does the streamlit sever process shut itself off after the browser is closed?
Thanks for watching. Nope, it's doesn't
Thanks for the video and great effort. From 1:30 to 1:40 if you try to pass your cursor of blue bars you will not a number in front of total bill, you will see "NaN". How could we fix this issue?
I hope that I can upload this as an image
Thanks for watching. Good catch. The seems to be a bug and is already reported: github.com/Kanaries/pygwalker/issues/126
@@CodingIsFun Thanks for the quick response. So, do I have to try it later on. Or will you reply to this comment again that the bug has been fixed to try again?
@@haithammontaser7769 Please watch the issue on GitHub.
Hi, this bug has been fixed in version 0.1.11, thanks for feedback.
@@user-mp5ji9yd6h Thanks a lot, how could I get this version?
Is it possible to export as code so that the code doesn't reference pygwalker but pandas & matplotlib only?
Thanks for watching. I do not think that it is possible
How can i try this in VScode, Sir? After i run, the rusult is "", and nothing more.
Not sure if it's possible with VSCode
What Ide are you using ?
VS code
How to deploy it in public sir?
Thanks for watching. Here you are: ua-cam.com/video/4SO3CUWPYf0/v-deo.html
I'm trying to understand what is the hype with PyGWalker and python... actually I invite anyone to reply to this comment, so far everything I've found (including this video from start to end) does NOT compare to what you can do with Tableau, literally with tableau public you can run in circles with what I've seen, there is no data visualization interactivity, you can't do things like running totals/% of ?/running avverage/running blahblah/ on the fly automatic date handling and options for non technical users and I can go on, and on, and on, and on to oblivion, this is not even an MVP (minimum viable product) this is more like a POC (proof of concept)
Thanks for watching. In my opinion, it is not a Tableau replacement. Pygwalker is just another tool in the toolbox when creating a Streamlit application. It might come in handy for specific use cases.