🎉 *Update - I created an Excel add-in to create such dashboards with the click of a button. Check it out here:* pythonandvba.com/grafly Do you want to see more pyecharts tutorials? Let me know in the comments!
Yes , I loved your videos this are simple and effective , I really love your videos as I just told you I made my 1st streamlit project with your videos , I request you to made more such amazing awesome and unique videos .
Hey Sven, I have recently started watching your videos but with this one you really blew my mind. Great job as always, and thank you for all these tutorials you constantly upload for us, really appreciated
Yes please i fall in love with pyecharts module , it it portable and can be shared which is awesome, i am looking for tutorials to provide more controls in dashboards like search fields
Great tutorial 👍. Interactive charts are what I need for work to make sharing information more efficient. The other options are lots of static charts or dashboards, but these aren’t appropriate in many use cases.
Great video, I have a question. I am trying to plot an operation sequence chart, like a Gantt chart but with multiple operations with color coding can be plotting in one linear column over a time x-axis. Any idea how to do that ? thanks!
@@CodingIsFun I ran into an issue after I creating the ipynb using "create jupyter notebook". When I tried to run the second block of code, it's giving me error msg of " Unknown engine: openpyxl". I imported openpyxl just to be safe. But it's still not working. Any ideas what I did wrong? (I am using jupyter notebook in VSC) Thanks.
@@freedomchaser4781 Sounds to me that the add-in has successfully created the Jupyter Notebook. Regarding the error, could you try the following: a) Upgrade to the latest pandas version 'pip install pandas --upgrade.' b) if that does not work, remove the line 'engine=openpyxl' Let me know if the error persists. Thanks!
Also, I’m coding in visual studio code, the charts produced by pyecharts have black background . Is there a line of code that changes the chart background to white? I remember matplotlib or seaborn grid background color can be changed to white. Thanks
Thanks for watching the video & your question. Once you have exported the chart to a standalone HTML file, there will be no 'connection' to the source file (Excel). This means that the charts will not be updated automatically. For visualizing live data, you might want to integrate pyecharts into a web framework, like Django, Flask, Streamlit, .. and use a database, API, Google Sheets.. as a backend to constantly fetch data & updating the charts. I hope it helps! Happy Coding!
Thank you. You might want to check out the docs on how to integrate pyecharts in Django: pyecharts.readthedocs.io/projects/pyecharts-en/zh/latest/en-us/django/ I hope it helps! Happy Coding!
Nice. Exactly what I‘m searching for. Please do more videos about this. Is the tab method compatible with plotly too? Is it possible to add multiple charts to one html-file?
Thanks, Mike! As far as I know, Plotly does not offer the 'tabs'-feature. However, in Plotly, you could create subplots to insert multiple charts on one page/file. Have a look here: plotly.com/python/subplots/ I hope this helps! Happy Coding!
Your video's are really great. Streamlit was the thing I was missing in my goal to have better insight in my energy consumption! I have all my energy usage (per 15 minute) in xls (one file per day) and was trying to visualise it in Jupyter...but this is way better and simpler. Maybe building an energy consumption app would make for some good content as well. How would you make it?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop or give specific guidance for all the different requests. As general advice, I would suggest watching some of my streamlit tutorials and just starting to try it out yourself with your consumption app. Thanks for your understanding. Happy Coding!
@@CodingIsFun No worries, I watches many of your videos already and was able to build my solution with your "help" ;). Just mentioning the idea because energy dashboards are very hot now because of the soaring energy prices. It might draw more viewers. For me your videos already gave me so many ideas to keep on building my app for the next year I think :D
@@CodingIsFun Thanks for your assistance but unfortunately, it does not work for me. I have a panel on the left side, in which I have multiple filters of gender (M, F) and age(Age1,Age2, Age3). I have multiple graphs on the right side, and I want to update these graphs by changing my filter options on the left side. Hope it is clear.
Thanks for watching the video & your question. Could you help me to understand what you are trying to achieve? By decomposing numbers, I usually understand breaking them down, e.g. 349 ⇒ 300 + 40 + 9. Thanks!
Glad you liked it. Thanks for watching. What exactly would you like to know? I could recommend having a look at the official pandas documentation. If you scroll down, you will find many examples: pandas.pydata.org/docs/reference/api/pandas.to_datetime.html I hope it helps!
Can we add multiple charts per tab? This is a cool idea to share attachment by email. better viz than boring excel's standard graphs and smaller in size.
@@CodingIsFun Thank you for the reply. Page class is what i do at the moment. can stack all of my plots into one page. was thinking if there is a away to stack them into separate categories (tabs). file size is really cool with some interactivity on the plots. perhaps in future they will add. thank you again.
@@BlueSkyGoldSun In my current role, I am not generating any statics reports at all, as I am more focusing on building data models and designing/developing Python & VBA solutions to automate repetitive tasks
Vielen Dank und gut gemacht! It was nice video and as ever, you present useful python modules/libraries in a very nice way. About Pyecharts, I am just wondering if there is any way to zoom-In/out as well... Im Voraus, vielen Dank für die Rückmeldung. Beste Grüße, Mauro.
Vielen Dank! Happy to hear that you find the videos helpful. Regarding your question, do you mean something like this: gallery.pyecharts.org/#/Bar/bar_datazoom_slider You could insert the following option to your code: datazoom_opts=opts.DataZoomOpts() I hope it helps! Happy Coding!
Hi Have you got a video on how to make Python read live changing data in a spreadsheet when its open ? Eg. Lets say i manually change value in a cell without saving the spreadsheet and i want that calue update to be read in Python. Most of the info i find on the internet is only how to read data from excell, yes but its updated only when you press save file in a spreadsheet. Thats not what i need.
Thanks for watching. I have tried it, but in the first attempts, it raised an error. You might want to search the internet for a solution before submitting an issue on the pyecharts GitHub page.
@@CodingIsFunOK and one more question - is it possible to add more than one chart in a Tab ? I try to add several charts to a page and then add the page to a Tab, but this don't work. Is there any other way?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Thanks for watching the video & your question. After a quick search on the internet, I have not found an option to change that, but maybe I overlooked something.
@@CodingIsFunI search for "python calendar heatmap startswith" and checked the picure answers ... there I saw at least one having monday as a start .. I will check later if I understand what setting that is needed .. thanks for your videos. Always nice to get ideas on how to present data. Another question .. streamlit: I tired to reach my site from outside my network but no success... its meantioned about open the firewall for port, but it seems not working for me, or at least the things I am trying to open in the fire wall .. maybe you can do a video on that?
Sounds possible. Please have a look at the documentation or browse through the gallery to see what kind of charts you can create: gallery.pyecharts.org/#/Bar/README
Thank you for watching the video and for your question. Unfortunately, I do not know why it is not working in Google colab. I would also need to search the internet for a solution. Sorry that I cannot help!
You could save the charts as a static image, e.g. PNG and then use xlwings to insert it into Excel (as shown in this video: ruclips.net/video/4CrZUJtjZkc/видео.html )
I made project with your video its amazing but I have an complaint to u , u said tool belt is free but its asking for money when I used to convert pandas dataframr , plz provide free version !
Thanks for watching the video. I mentioned in the video that those features are not free: 0:42min That said, most of the features are absolutely free. You can find an overview here: pythonandvba.com/mytoolbelt/
🎉 *Update - I created an Excel add-in to create such dashboards with the click of a button. Check it out here:* pythonandvba.com/grafly
Do you want to see more pyecharts tutorials? Let me know in the comments!
Yes , I loved your videos this are simple and effective , I really love your videos as I just told you I made my 1st streamlit project with your videos , I request you to made more such amazing awesome and unique videos .
I want to see more as I prepare for my data science interview
Yes please, that was awesome please make all type of analysis with it and type of charts in the coming videos. That was so much fun and amazing.
Yes please, that was awesome please make all type of analysis with it and type of charts in the coming videos. That was so much fun and amazing.
i would love to
Not just the content, but the way you have arranged each topic and provided timestamp for each step, simply superb.❤❤ I am watching all your video's
It's very kind of you to say so, thank you!
Hey Sven, I have recently started watching your videos but with this one you really blew my mind. Great job as always, and thank you for all these tutorials you constantly upload for us, really appreciated
An absolute pleasure, Gabriel Olagundoye. Very happy to hear that you found it helpful!
Yes please i fall in love with pyecharts module , it it portable and can be shared which is awesome, i am looking for tutorials to provide more controls in dashboards like search fields
Thanks for checkin' out the video and leavin' a comment, much appreciated. 👍
Awesome video on presenting an alternative library to matplotlib and seaborn.
Thank you!
Yes please, that was awesome please make all type of analysis with it and type of charts in the coming videos. That was so much fun and amazing.
Thanks for watching & your great suggestion! 👍
This is the better tuto I have never seen
Thank you very much. Glad you liked it! :)
@@CodingIsFun I was just looking at for something like this. You help much people and we are so thankfull. that god bless
Amazing tutorial for a great library! The syntax reminded me of that of ggplot2. Will definitely have a try!
Thank you & happy coding! :)
Thanks a lot. This is amazing. Would love to see more content on Pyecharts.
Thanks for watching & your comment! More Pyecharts tutorials will come in the future. Stay tuned! ✌
Wow its breathtaking.. Awesome.. Cant wait for more
Glad you liked it. Thanks for watching. 👍👍
Yes, we need absolutely more videos on that. Do you think it is possible to have more than on chart per tab?
Yes, that is possible. Have a look at the following example:
gallery.pyecharts.org/#/Page/page_simple_layout
thanks very much Sven, you're the best!!
Loved reading your comment! Thanks for the support! ❤️👍
Is it possible to add more slicers to the data?
Thanks for watching. Not sure about your specific use case, but please refer to the official documentation to see what is supported. Thanks!
Great tutorial 👍. Interactive charts are what I need for work to make sharing information more efficient. The other options are lots of static charts or dashboards, but these aren’t appropriate in many use cases.
Thank you! Happy to hear that it was helpful! 😃
Great video, I have a question. I am trying to plot an operation sequence chart, like a Gantt chart but with multiple operations with color coding can be plotting in one linear column over a time x-axis. Any idea how to do that ? thanks!
Thanks! Have a look a the following examples: gallery.pyecharts.org/#/README_EN
Awesome video. Thank you as always, Sven. Just bought your add-in. Look forward to putting it to great use.
Thank you for watching the video & your support by purchasing the add-in. I hope you like it! :)
@@CodingIsFun I ran into an issue after I creating the ipynb using "create jupyter notebook". When I tried to run the second block of code, it's giving me error msg of " Unknown engine: openpyxl". I imported openpyxl just to be safe. But it's still not working. Any ideas what I did wrong? (I am using jupyter notebook in VSC) Thanks.
@@freedomchaser4781 Sounds to me that the add-in has successfully created the Jupyter Notebook. Regarding the error, could you try the following:
a) Upgrade to the latest pandas version 'pip install pandas --upgrade.'
b) if that does not work, remove the line 'engine=openpyxl'
Let me know if the error persists. Thanks!
@@CodingIsFun option a didn’t work. I went with option b. It worked. Thanks Sven.
Also, I’m coding in visual studio code, the charts produced by pyecharts have black background . Is there a line of code that changes the chart background to white? I remember matplotlib or seaborn grid background color can be changed to white. Thanks
Great tutorial as usual. Thanks.
Happy to hear that you enjoyed this one too! Thanks for watching the videos! :)
This looks interesting! More please =)
Thank you! So far, the response has been very great. Most likely, I will do some more pyecharts tutorials in the future :)
Amazing tutorial. Power bi support this library?
Thanks! According to this source, pyecharts is not supported in Power BI;
powerbi.microsoft.com/de-de/blog/python-visualizations-in-power-bi-service/
@@CodingIsFun Thank you very much!
This tutorial is one of the best, it works perfectly on local host but how can we upload the HTML output on SharePoint 365 or one drive.
Thanks for watching and the kind words. I have never tried to upload/render an HTML on SharePoint or OneDrive. Hence, I cannot help you here. Sorry!
Great! Thanks for sharing. Is there anyway pyechart can deal with live data (constantly updating the excel file)?
Thanks for watching the video & your question. Once you have exported the chart to a standalone HTML file, there will be no 'connection' to the source file (Excel). This means that the charts will not be updated automatically.
For visualizing live data, you might want to integrate pyecharts into a web framework, like Django, Flask, Streamlit, .. and use a database, API, Google Sheets.. as a backend to constantly fetch data & updating the charts.
I hope it helps! Happy Coding!
@@CodingIsFun thanks a lot. Your suggestion is very helpful.
Amazing, that 's blow my mind. Very thank you!
Thanks for watching and your comment! Glad you like the solution :)
great video, I need to lean more about this, for instance running the graph in a django app
Thank you. You might want to check out the docs on how to integrate pyecharts in Django:
pyecharts.readthedocs.io/projects/pyecharts-en/zh/latest/en-us/django/
I hope it helps! Happy Coding!
Nice. Exactly what I‘m searching for. Please do more videos about this. Is the tab method compatible with plotly too? Is it possible to add multiple charts to one html-file?
Thanks, Mike! As far as I know, Plotly does not offer the 'tabs'-feature. However, in Plotly, you could create subplots to insert multiple charts on one page/file.
Have a look here:
plotly.com/python/subplots/
I hope this helps! Happy Coding!
nice and easy examples, thanks
Thank you!
Your video's are really great. Streamlit was the thing I was missing in my goal to have better insight in my energy consumption! I have all my energy usage (per 15 minute) in xls (one file per day) and was trying to visualise it in Jupyter...but this is way better and simpler. Maybe building an energy consumption app would make for some good content as well. How would you make it?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop or give specific guidance for all the different requests. As general advice, I would suggest watching some of my streamlit tutorials and just starting to try it out yourself with your consumption app. Thanks for your understanding. Happy Coding!
@@CodingIsFun No worries, I watches many of your videos already and was able to build my solution with your "help" ;). Just mentioning the idea because energy dashboards are very hot now because of the soaring energy prices. It might draw more viewers. For me your videos already gave me so many ideas to keep on building my app for the next year I think :D
Thanks! Much appreciated!👍
My pleasure! Appreciate you taking the time to watch and leave a comment.
Nice video. How can i add filter controls in Pyechart? Please share some video or material regarding it. Looking forward to your response
Thanks for watching. Check out the pyecharts gallery to see the available filter options: gallery.pyecharts.org/#/README_EN
@@CodingIsFun Thanks for your assistance but unfortunately, it does not work for me. I have a panel on the left side, in which I have multiple filters of gender (M, F) and age(Age1,Age2, Age3). I have multiple graphs on the right side, and I want to update these graphs by changing my filter options on the left side. Hope it is clear.
Fantastic, thank you!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
looks amazing, will definately give it a try...
Great! Happy Coding! 🚀
Hi Sven, thanks for this job. It’s very useful. But I have a question. How can I decompose the numbers on bar chart?
Thanks for watching the video & your question. Could you help me to understand what you are trying to achieve? By decomposing numbers, I usually understand breaking them down, e.g. 349 ⇒ 300 + 40 + 9. Thanks!
@@CodingIsFun I want to put commas between digits, like “5,986”.
Great! Can we integrate Pyecharts with Streamlit?
Thanks for watching. Yes, you can. Check out the following GitHub repo: github.com/andfanilo/streamlit-echarts
Nice videos, How to change bar color with certain conditions ?????
Thanks for watching. Have a look at the following example: gallery.pyecharts.org/#/Bar/bar_custom_bar_color
I hope it helps! Happy Coding!
Nice! Pyecharts look awesome! Thank you!
Could you tell more about importing dates to python and converting the type for a specific column?
Glad you liked it. Thanks for watching.
What exactly would you like to know? I could recommend having a look at the official pandas documentation.
If you scroll down, you will find many examples:
pandas.pydata.org/docs/reference/api/pandas.to_datetime.html
I hope it helps!
Incredible!
Thank you!
please more tutorial. This awesome
Thank you. I will do some more tutorials on pyecharts in the future.
Will you film Sklearn for ML?
Thank you for watching. Probably not 😬 Cheers, Sven ✌️
It’s really helpful. Mate.
Thank you, Guti Haz! Greetings to Hong Kong! :)
Super cool!
Thank you!
Hi Sven, nice stuff mate. I wonder if we could embed these HTML charts on streamlit apps. Is it possible? It would be an insane combination.
Thank you! Yes, that is possible. Check out the streamlit-echarts library: github.com/andfanilo/streamlit-echarts
Happy Copding!
@@CodingIsFun very nice. It would be nice if you could play around it in your next videos (making some nice and complex ECharts!). Nice channel.
¡Excelente video! Mas tutoriales por favor
¡Hola! Muchas gracias por tu comentario y por apreciar el video.
Can we add multiple charts per tab? This is a cool idea to share attachment by email. better viz than boring excel's standard graphs and smaller in size.
Thanks for watching. I have not tried it yet, but it might work using the "Page" class: gallery.pyecharts.org/#/Page/page_simple_layout
@@CodingIsFun Thank you for the reply. Page class is what i do at the moment. can stack all of my plots into one page. was thinking if there is a away to stack them into separate categories (tabs). file size is really cool with some interactivity on the plots. perhaps in future they will add. thank you again.
Great video as alwayy
Thank you very much! 👍
Amazing and awesome. Thank you very much.
Glad to hear that you liked this one too. As always, thanks for watching and your comment! 😃
Thats usefull, very big thankyou 🔥👍
Glad it was helpful. Thanks for watching!
really cool. thanks for making this.
My pleasure! Thank you for watching!
Awesome Tutorial!
Thank you!
Html dashboard it is much simpler than powerbi or tableau ,do you think in modern company will accept dashboards as a HTML file ?
I think PowerBI/tableau is much more powerful. I sometimes use it for ad hoc analysis, where an entire PowerBI/tableau report would be overkill.
@@CodingIsFun From your experience,
How often do you make statistics reports, Such as report about hypothesis testing &linear regressions etc. ?
@@BlueSkyGoldSun In my current role, I am not generating any statics reports at all, as I am more focusing on building data models and designing/developing Python & VBA solutions to automate repetitive tasks
Vielen Dank und gut gemacht! It was nice video and as ever, you present useful python modules/libraries in a very nice way. About Pyecharts, I am just wondering if there is any way to zoom-In/out as well... Im Voraus, vielen Dank für die Rückmeldung. Beste Grüße, Mauro.
Vielen Dank! Happy to hear that you find the videos helpful. Regarding your question, do you mean something like this: gallery.pyecharts.org/#/Bar/bar_datazoom_slider
You could insert the following option to your code: datazoom_opts=opts.DataZoomOpts()
I hope it helps! Happy Coding!
Awesome, do you have a tutorial website
Thanks for watching and your question All my tutorials are here available on RUclips :)
great video yo u should make charts, and graph with Dtype " object " to learn more cause not all data has float or datetime, please in the nex video
Thank you for watching the video & your suggestion.
Super helpful!
Happy to hear that & thanks for watching!
Hi
Have you got a video on how to make Python read live changing data in a spreadsheet when its open ? Eg. Lets say i manually change value in a cell without saving the spreadsheet and i want that calue update to be read in Python.
Most of the info i find on the internet is only how to read data from excell, yes but its updated only when you press save file in a spreadsheet. Thats not what i need.
Thanks for watching. No, I do not have that kind of video, but thanks for your suggestion.
A program to read a complex multi pages pdf documents and extract required data for easy processing.. If you can assist Pls
Thank you for watching the video & your suggestion.
Hi Sir, how can we add these charts into same or new excel files?
You cannot insert interactive HTML charts into Excel
Hello, I like your video and try this library but I have a problem to add a Gauge chart into Grid! Is this possible ?
Thanks for watching. I have tried it, but in the first attempts, it raised an error. You might want to search the internet for a solution before submitting an issue on the pyecharts GitHub page.
@@CodingIsFunOK and one more question - is it possible to add more than one chart in a Tab ? I try to add several charts to a page and then add the page to a Tab, but this don't work. Is there any other way?
Salute and respect to you Sir.
Possible to integrate pyecharts with streamlit? I hope to see it in next tutorial:)
Thank you!
Yes, that is possible. Check out the following package: github.com/andfanilo/streamlit-echarts
@@CodingIsFun thank you very much .. how could I ever repay you! I wish you happiness wherever you go, man. Live long in prosperity:)
Can we render more than Echarts in one html tab?
Tab.add[(Chart1, “first chart”),( Chart2, “second chart)] , couldnt find documentation for Tab pye charts, any can we modify their positions? Ty
Hi can u tell how to filter data using piechart with table representation. Thanks in advance ,Love ur videos!
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
@@CodingIsFun Thanks for reply, Can you suggest any website/resource/documentation for the same.
@@Onepiece23451 The official pyecharts documentation or pyecharts gallery is a great way to start: gallery.pyecharts.org/#/README_EN
Awesome!!!
*Thank you.* I am glad you enjoyed the video 😃
Please bring in more about this library
More tutorials on the pyechart module will come in the future. Stay tuned!
Good stuff
Thank you!
Hey can you please tell me how can i add all the graphs on one page? i don't want them on separate tabs. They should appear on single html tab.
Have a look here: gallery.pyecharts.org/#/Page/page_simple_layout
Happy Coding!
@@CodingIsFun Thank you so much. 😊
We use weeks starting with Mondays in Sweden ... is there a setting to modify and not start the week with Sunday?
Thanks for watching the video & your question. After a quick search on the internet, I have not found an option to change that, but maybe I overlooked something.
@@CodingIsFunI search for "python calendar heatmap startswith" and checked the picure answers ... there I saw at least one having monday as a start .. I will check later if I understand what setting that is needed .. thanks for your videos. Always nice to get ideas on how to present data. Another question .. streamlit: I tired to reach my site from outside my network but no success... its meantioned about open the firewall for port, but it seems not working for me, or at least the things I am trying to open in the fire wall .. maybe you can do a video on that?
Dope stuff
Thanks!
Excelente información muchas gracias por compartir
*Gracias por ver mi video*
You turned my life 💕🥰🥰🌷🌷😘😘☺️☺️
Thanks for watching the video & your comment! 🥰
can i group by 2 colums let's say i have multiple years and for each year i have multiple months is that possible
Sounds possible. Please have a look at the documentation or browse through the gallery to see what kind of charts you can create: gallery.pyecharts.org/#/Bar/README
@@CodingIsFun thank u so much for replying
when i try this on google colab, i cannot get the chart to render? there's no error, just there's no chart. help?
Thank you for watching the video and for your question. Unfortunately, I do not know why it is not working in Google colab. I would also need to search the internet for a solution. Sorry that I cannot help!
how to render it in an excel file ??
You could save the charts as a static image, e.g. PNG and then use xlwings to insert it into Excel (as shown in this video: ruclips.net/video/4CrZUJtjZkc/видео.html )
@@CodingIsFun can u tell me how to save it as a png please
I made project with your video its amazing but I have an complaint to u , u said tool belt is free but its asking for money when I used to convert pandas dataframr , plz provide free version !
Thanks for watching the video. I mentioned in the video that those features are not free: 0:42min
That said, most of the features are absolutely free. You can find an overview here:
pythonandvba.com/mytoolbelt/
Can anyone help with how to select multiple years
Thanks for watching. Please check out the pyecharts documentation. Thanks!
Export html??
Yeah :)
pyecharts + streamlit plz
Thanks for watching & your suggestion!
Just use power bi
Thanks for watching the video & your comment! :)
looks amazing, will definately give it a try...
Great! Happy Coding!