Turn An Excel Sheet Into An Interactive Dashboard Using Python (Streamlit)
ฝัง
- เผยแพร่เมื่อ 19 มิ.ย. 2024
- 👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
This video will show you how to build interactive Excel dashboards with Python using the Streamlit library. Streamlit allows us to create interactive Dashboards with a few lines of code. We will start by installing the necessary Python libraries. Afterwards, we will dive into building an interactive dashboard with Streamlit, which will be easy to customize and provide excellent user interaction.
🌍 𝗟𝗜𝗡𝗞𝗦:
► salesdashboard.pythonandvba.com/
📝 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:
► Download all files from GitHub: github.com/Sven-Bo/streamlit-...
► Download the Add-in ‘My Tool Belt here’: pythonandvba.com/mytoolbelt
► Deploy your streamlit app for free on Heroku: • Deploy Your Streamlit ...
► Deploy your streamlit app for free on Render: • Deploy Your Streamlit ...
► More Streamlit tutorials: • Streamlit Tutorials
✅ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 | Intro
00:46 | Exploring the dataset
01:13 | Convert Excel Data into a Pandas Dataframe
02:28 | Install Dependency's
02:55 | Getting started with Streamlit
04:17 | Building the Sidebar (Filter Selection)
06:27 | Building the KPI Section
08:53 | Building the Visualizations (Bar Charts)
12:37 | A brief digression: Enhance App Performance
13:22 | Continue Building the Visualizations
14:22 | Styling the Web App
15:51 | Wrap-Up
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: pythonandvba.com/coffee-donation
👉Website Demo: www.salesdashboard.pythonandvba.com/
👉Streamlit Playlist: th-cam.com/play/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n.html
👉Deploy your streamlit app for free on Heroku: th-cam.com/video/nJHrSvYxzjE/w-d-xo.html
👉Deploy your streamlit app for free on Render: th-cam.com/video/4SO3CUWPYf0/w-d-xo.html
👉Get my Excel add-in to combine Python + Excel: pythonandvba.com/mytoolbelt
💬I will be here in the comments section. For any issues, please provide your exact error message, and I will try to help.
*That said, probably the easiest way to create a dashboard from Excel data is to use my Excel dashboard add-in Check it out here:* pythonandvba.com/grafly
I am using jupyter notebook, I notice I can not practice this with my Jupyter notebook, which other IDE in anaconda can I use for this project
Thank for watching the video & your question. You could use 'Spyder', which comes already with the Anaconda distribution:
docs.anaconda.com/anaconda/user-guide/tasks/integration/spyder/
@@CodingIsFun Thank you for taking time to reply my message I feel very confident now
Probably THE BEST tutorial on streamlit! Great info, very precise and easy to follow. Thanks a lot man.
Thank you so much! Glad you liked the video :)
I agree
Exactly my thought!
This is such a great project! So relevant for automating reporting for small business
Thanks for the kind words! I am glad you enjoyed it.
If I created one for the company I work for, it’s a valet company bringing in a good amount of money. How much do you think I could sell it for?
Great work chief 👏🏼, love your work and it helps me learn more tricks in python.
I loved the cashing to memory method which is nice to do for better performance.
Happy to hear that you enjoyed this one too! Thanks for the comments and support, as always!
Hi, Spent 2 days to cover all the things you did in 16 mins. Great explanation, thank you so much. Subscribed.
Thanks for your sub & welcome aboard!
Wow! 🤩 this is really fun to learn and implement. I’m sorry restating my sentence “ You made it easy and fun to get started” thank you so much for the detail course.
Happy to hear that it was fun & useful; thank you for taking the time to leave a comment and for watching the video! 😃
Absolutely awesome demonstration. Thorough explanations and easy to follow. This gives me ideas for trying to quickly create dashboards around community data in my city. Can’t wait to see if I can figure out including geo data to create hotspot maps too!
Happy to hear that it was useful! Thank you for taking the time to leave a comment and for watching the video!
Im actually interested in doing the same for our towns waste water plant data, mostly for practice that hopefully can be turned into something productive. would like to knwo how it turns out
@@coopergaffney2012 Would love to see your approach and what data you are working with. Water data is one of the big topics where I'm at as well.
Your tutorials are simply fantastic, from the content to the video editing, congratulations!
Your comment is a boost! Thanks for the energy! 💖👍
people like you are the reason why humans have reached this far. Thank you sooooo much. i wish you good health and good luck my frind
It's very kind of you to say so; thank you!
This is amazing! Thank you for this I’m going to use this to better my personal project
I am glad you liked the video; thanks for watching and for the comment!
Brilliant! Just found out about streamlit yesterday, thanks for this!
A pleasure. Thanks for watching and taking the time to leave a comment. Happy Coding!
Wow you are a genius! love the simple style and this is a great project for me to do since i want to keep practicing my python skills. Keep up the good content.
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍
Very useful video which gives a lot of ideas how to solve my own project issues. Appreciate this work !
An absolute pleasure, very happy to hear that you found it useful!
hey man, thank you very much for your tutorials, they are quite useful, you are very practical, simple and direct, I learn in an easy and simple way .... Thanks again !!
Glad you like them 😃 Thanks for watching & your comment!
Thank you so much! I was doing a couple of things differently but the most important thing is that it solve some questions that I had
Glad you liked it. Thanks for watching. 👍
I have no need for this but still found it very interesting to watch. It seems so easy and customizable!
Glad to hear that you still found it interesting to watch :)
BRUTAL! thank you so much for share this kind of content, its very very helpful to help small / mid business to grow an track their data of a proper, clean and easy way !!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Thank you, Sven! Very awesome of you to share this.
You're very welcome! Thank you for watching and for the comment!
Thank you so much for this tutorial. Your explanation so clear and give me inspiration to learn python + stramlit.
Glad you liked it! Happy learning & coding! :)
I'm so going to binge watch your videos... You've got the contents I need.. Thanks
Thanks, Ayotunde! I'm thrilled you enjoy the content. Have a great time binge-watching, and feel free to share your thoughts. Happy watching! 😊
Because of your simplicity, your the best one in TH-cam .
Keep going
Thanks for your kind feedback. I appreciate it!
That's awesome!! Congratulations, I will centennial study it and use for my business. You are GREAT.
It's very kind of you to say so, thank you!
Great video. Thanks for creating and uploading it. I learnt a lot in such a short space of time!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍
Wow... This is the first video I watched and I immediately fell in love and then subscribed to this channel. I'll take a look and learn from this channel. Greetings from Indonesia
Happy to hear that you liked the video. Thanks for the sub and welcome aboard! Greetings from Germany to Indonesia! ☀🏖✌
I’m currently at a beginner level and would like to be able to do this with any excel chart of use to get a better understanding. I’ve been warned of “tutorial hell” where I’m able to duplicate the results well, but nothing else. Once I get through more Python classes I think I’ll be able to understand and distinguish Python from any additional tools and therefore know what is essential to this kind of process and what is particular to the graph you are making in the video. I appreciate these videos and I look forward to utilizing everything to it’s fullest.
Thanks for watching! I wish you a lot of fun & success in your coding journey! :)
Great content! very simple and easy to follow. Keep up the good work 👍
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍
Totally no nonsense video! You made it all look so easy
Thanks for watching. Glad you liked it! Cheers, Sven ✌️
Thanks, mate. Im new to Python and this was great to follow and helped me a lot!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Happy Coding!
Thanks alot man for this great content, well explained and visualized.
Thank you! Glad you liked the video :)
Thank you very much. Great tutorials. Useful, practical, simple and direct. Your chanel is a great learning resource.
Happy to hear you like them. Thank you for taking the time to leave a comment and for watching the videos! 😃
First time visit to this channel. Very impressed 👏 you make python look easy
Happy to hear that! Many thanks for watching the video & taking the time to leave a comment. I appreciate it! 👍
Well explained brother... i was able to implement this in a few days. You rock !!!!
Happy to hear that! Cheers, Sven ✌️
Excellent demo in simple way! well done
Thanks for the kind words! I am glad you enjoyed it. 👍
Very useful video, and the editing of the video is fantastic. Thanks for sharing the knowledge.
Thank you! Glad you liked it.
This was pretty nice! I really like the tag-like look of the filters on the sidebar. I just got recommended this video through the algorithm and I wonder how I haven’t found your channel yet! I guess it’s maybe because I’m mostly an R user, and don’t touch Python very often. In R we have a tool called Shiny that does this type of data application development and last I heard the authors have begun porting it over to python. If you haven’t, I’d really recommend checking it out, it’s an extremely powerful tool. It would definitely provide enough content for a TH-cam series.
Thanks for watching and for your suggestion! I appreciate the recommendation and will keep it in mind for future content, but I can't make any promises.
Great job! Top form presentation as always
Thanks for all your comments & support! I appreciate that! 👍
First class edited video presentation. Congrats!
Thanks a lot! :)
Muito bom! Parabéns pela excelente didática!
Obrigado!
Now that's what we call high-quality content!
Thank you very much! ❤
Thanks for this very informative video. Learning new things every day.
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
This helped me a lot thanks for the video expecting more like this you are simply rocking
More to come! Thanks for watching & your comment! :)
I cannot emphasize how good this vid is
Thanks for the kind word and watching the video! 👍
Holy demonstration. I am greatful.
Glad you liked it. Thanks for watching and your comment! :)
this is amazing, thanks! i didn't know about this library...
Glad you liked the video. Happy Coding! :)
Thanks a lot! Happy new year!
A pleasure! Happy New Year! 🎉
Amazing video, easy to follow and replicate, great job!!
Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍
Exactly what I needed! Thanks!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Really instructive video! Good job sir
Thank you very much! :)
Best tutorial ever sir, thank you.
Glad you liked it. Thanks for watching.
thank you for your excellent work this help me to build my own dashboard for work
Thanks for watching and taking the time to leave a comment. Happy to hear that you were able to build your own dashboard 💪
Thank you for this wonderful tutorial :)
Glad it was helpful! Thanks for watching & your comment! :)
Thank you for the great tutorial!
Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍😍
I really love that you do something like this in flask
Thank you for watching the video & your suggestion.
Amazing tutorial, the best tutorial. Incredible
Thank you for your kind feedback! Happy to hear that :)
Thank you so much for the video. Love from India🇮🇳
Thank you very much for watching the video! Greetings to India! :)
Amazing! I have been looking to gap Excel and coding for dashboards. I like PowerBI but this is more fun!
Glad it was helpful! Happy Streamlit-ing! 🎉
thank you for sharing this video. Very useful!!!
A pleasure! Glad you like the video! :)
This was outstanding, thank you
Happy to hear that! Thanks for watching and taking the time to leave a comment!
Excellent stuff with brilliant explaination
Thank you!
this is amazing!! thank you so much
Glad you liked it! :)
Thank you for your awesome job. Please do such dashboards with Plotly Dash as well. That would be cool.
Thank you for watching the video & your suggestion.
this is what i needed, thankyou
Glad you liked it. Thanks for watching.
Brilliant video. Thanks.
Glad you enjoyed it! Thanks for watching! 👍
Awesome video and great efforts 🔥🔥🔥
Thank you!
This is brilliant thank you
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍
Great video - thank you.
Glad you liked it. Thanks for watching.
Great work !!! it's fantastic, thanks a lot
Thanks for watching!
¡demasiado bueno para ser cierto, excelente tutorial! Thanks and please more python projects
Thanks for leaving a comment and for taking the time to watch, Willian Suarez! Glad you liked it. 🤩👍
very useful, thanks a lot!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Excellent piece of work ..
Thanks for the kind words! I am glad you enjoyed it.
Great video! Thank you!
Glad you liked it! Thanks for watching and your comment!
super helpful video. thank you.
Glad you liked it. Thanks for watching and taking the time to leave a comment!
@@CodingIsFun thanks for taking the time to make this informative video and sharing your knowledge with the world.
good stuff. Thanks for sharing!
My pleasure! Appreciate you taking the time to watch and leave a comment. 👍
Muchas gracias por el tutorial, voy a ponerlo en práctica
¡De nada! Me alegro de que te haya gustado el tutorial.
12:40 thanks for explaining how you cache data to improve performance, as I know Streamlit reruns the entire script every time a filter is changed by the user.
Glad you found it helpful! Cheers, Sven ✌️
Thanks for good video. Please, more example of streamlit.
My pleasure emile mul, thank you for watching!
Thanks a lot! Good job!
Glad you liked it. Thanks for watching.
amazing, congratulations!
Glad to hear you liked it! Thank you for commenting and watching. :)
This is awesome, thanks
Glad you liked it. Thanks for watching and taking the time to leave a comment!
great work! helped my project.
Happy to hear that. Thanks for watching!
@@CodingIsFun You are welcome 🙂
Excellent Tutorial
Glad to hear you liked it! Thank you for commenting and watching. 👍
thank you so much bro its interesting tut...
My pleasure. Thanks for watching and commenting! :)
Hi, as always great video. 🙂
As always, thank you very much for the comments and support, Ricardo Campos! 😃❤
Super interesting! Thanks
Thank you!
Great tutorial!
Thank you! 👍👍
Love this tutorial, then the pay wall behind the feature of this whole tutorial.......
As mentioned (and even explained) in the video, you do not need the add-in to follow along ...
Using 6.9 for rating example at 7:34 was a really NICE touch
Thank you! Glad you like the video! :)
Thank you for this video
You're very welcome! Thank you for watching and for the comment!
Danke schön,schonen tag noch,ciao
Bitte. Dir auch einen schönen Tag
Hey, this video is awesome. I was curious how this works with multiple pages within the excel doc and if the data will continue to grow if you add more entries into the excel doc
Thanks for watching the video and your question.
You could read in each excel worksheet as a separate dataframe:
df = pd.read_excel(io="supermarkt_sales.xlsx", engine="openpyxl", sheet_name="Sales")
df2 = pd.read_excel(io="supermarkt_sales.xlsx", engine="openpyxl", sheet_name="Data")
df3 = pd.read_excel(io="supermarkt_sales.xlsx", engine="openpyxl", sheet_name="XXX")
Regarding updating the Excel file:
If you're going to use Excel, you always need to commit/push the changes to the server. A better solution would be to use a database or Google Sheets. Google sheets has the advantage that it comes with an API. I am also planning to do a video on connecting streamlit with Google sheets in the near future. I hope this helps!
I LOVE YOUR CHANNEL!
*I am glad to hear you are enjoying the videos, thanks for watching and for the comment!*
Great work done Sven, wonder this is possible with sheets as well!
Thanks for watching. Glad you liked the video. You can also connect Streamlit to Google Sheets. Have a look here: docs.streamlit.io/knowledge-base/tutorials/databases/private-gsheet
I hope it helps! Happy Coding!
@@CodingIsFun That's so sweet of you, thanks a lot :)
Very informative .
Thank you!
I’m not related to fully understand this video at the moment, but I will be soon in a few months!!
Very cool and, congratulations for the video!!!👏🏼👏🏼👏🏼👏🏼
Which IDE was used?
Hey there! Thanks for checking out my video. I'm glad you enjoyed it, even if you didn't fully understand everything just yet. Don't worry, you'll get there soon- just keep at it and you'll be an expert in no time! As for the IDE, I used Atom to record the video, but I usually stick with VS Code for my regular coding. Thanks again for your kind words and support - it means a lot to me. 👍
Jesus I didn’t realize this was you! Awesome work dude, let’s hang out soon!
*Thanks!* Yeah! Let's hang out soon!
Very Good video ! Thank you
My pleasure! Thanks for watching the video and taking the time to leave a comment! :)
Buen vídeo, gracias, hermano.
Glad you liked it. Thanks for watching.👍
Thank you very much, bro
A pleasure! Thank you for watching the video!
Thank you for sharing
My pleasure! Appreciate you taking the time to watch and leave a comment. 👍
This is so cool! 😲
Thank you! :)