Turn An Excel Sheet Into An Interactive Dashboard Using Python (Streamlit)

Рет қаралды 1,040,654

Күн бұрын

👉 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
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 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

Пікірлер: 816

@CodingIsFun 2 жыл бұрын

👉Website Demo: www.salesdashboard.pythonandvba.com/ 👉Streamlit Playlist: kzfaq.info/sun/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n 👉Deploy your streamlit app for free on Heroku: kzfaq.info/get/bejne/pLB4pbanvt7emnk.html 👉Deploy your streamlit app for free on Render: kzfaq.info/get/bejne/arl_ZqaGvLa9lmQ.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

@olayinkaaliu9177 2 жыл бұрын

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

@CodingIsFun 2 жыл бұрын

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/

@olayinkaaliu9177 2 жыл бұрын

@@CodingIsFun Thank you for taking time to reply my message I feel very confident now

@Ravichawla68 2 жыл бұрын

Probably THE BEST tutorial on streamlit! Great info, very precise and easy to follow. Thanks a lot man.

@CodingIsFun 2 жыл бұрын

Thank you so much! Glad you liked the video :)

@luisacuna1729 2 жыл бұрын

I agree

@miracapur 4 ай бұрын

Exactly my thought!

@techtbe 2 жыл бұрын

Hi, Spent 2 days to cover all the things you did in 16 mins. Great explanation, thank you so much. Subscribed.

@CodingIsFun 2 жыл бұрын

Thanks for your sub & welcome aboard!

@santhoshreddykesavareddy1078 2 жыл бұрын

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.

@CodingIsFun 2 жыл бұрын

Happy to hear that it was fun & useful; thank you for taking the time to leave a comment and for watching the video! 😃

@mohammedalbatati5529 2 жыл бұрын

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.

@CodingIsFun 2 жыл бұрын

Happy to hear that you enjoyed this one too! Thanks for the comments and support, as always!

@athump947 2 жыл бұрын

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

@CodingIsFun 2 жыл бұрын

It's very kind of you to say so; thank you!

@jonathanacuna 2 жыл бұрын

This is such a great project! So relevant for automating reporting for small business

@CodingIsFun 2 жыл бұрын

Thanks for the kind words! I am glad you enjoyed it.

@ghost4660 Жыл бұрын

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?

@musickmann 2 жыл бұрын

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!

@CodingIsFun 2 жыл бұрын

Happy to hear that it was useful! Thank you for taking the time to leave a comment and for watching the video!

@coopergaffney2012 Жыл бұрын

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

@musickmann Жыл бұрын

@@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.

@RicardoPorteladaSilva 8 ай бұрын

Your tutorials are simply fantastic, from the content to the video editing, congratulations!

@CodingIsFun 8 ай бұрын

Your comment is a boost! Thanks for the energy! 💖👍

@BlueSkyGoldSun 2 жыл бұрын

Because of your simplicity, your the best one in KZfaq . Keep going

@CodingIsFun 2 жыл бұрын

Thanks for your kind feedback. I appreciate it!

@chuchaftw 2 жыл бұрын

This is amazing! Thank you for this I’m going to use this to better my personal project

@CodingIsFun 2 жыл бұрын

I am glad you liked the video; thanks for watching and for the comment!

@futuregootecks 2 жыл бұрын

Brilliant! Just found out about streamlit yesterday, thanks for this!

@CodingIsFun 2 жыл бұрын

A pleasure. Thanks for watching and taking the time to leave a comment. Happy Coding!

@bobtucker9082 Жыл бұрын

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.

@CodingIsFun Жыл бұрын

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

@Ayotundejerry Жыл бұрын

I'm so going to binge watch your videos... You've got the contents I need.. Thanks

@CodingIsFun Жыл бұрын

Thanks, Ayotunde! I'm thrilled you enjoy the content. Have a great time binge-watching, and feel free to share your thoughts. Happy watching! 😊

@fredhare2685 Жыл бұрын

Very useful video which gives a lot of ideas how to solve my own project issues. Appreciate this work !

@CodingIsFun Жыл бұрын

An absolute pleasure, very happy to hear that you found it useful!

@carlo6195 Жыл бұрын

Thank you, Sven! Very awesome of you to share this.

@CodingIsFun Жыл бұрын

You're very welcome! Thank you for watching and for the comment!

@hnclienteshn4501 2 жыл бұрын

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 !!

@CodingIsFun 2 жыл бұрын

Glad you like them 😃 Thanks for watching & your comment!

@termica7349 Жыл бұрын

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 !!

@CodingIsFun Жыл бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

@Gareth.W Жыл бұрын

Great video. Thanks for creating and uploading it. I learnt a lot in such a short space of time!

@CodingIsFun Жыл бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! 👍

@babatundeomotayo8460 Жыл бұрын

Great content! very simple and easy to follow. Keep up the good work 👍

@CodingIsFun Жыл бұрын

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

@harisprabowo4039 2 жыл бұрын

Thank you so much for this tutorial. Your explanation so clear and give me inspiration to learn python + stramlit.

@CodingIsFun 2 жыл бұрын

Glad you liked it! Happy learning & coding! :)

@benlong1062 2 жыл бұрын

I have no need for this but still found it very interesting to watch. It seems so easy and customizable!

@CodingIsFun 2 жыл бұрын

Glad to hear that you still found it interesting to watch :)

@GENERALEVILANGEL Жыл бұрын

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

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching. 👍

@fahminsk Жыл бұрын

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

@CodingIsFun Жыл бұрын

Happy to hear that you liked the video. Thanks for the sub and welcome aboard! Greetings from Germany to Indonesia! ☀🏖✌

@gianmarcogomiero9249 Жыл бұрын

That's awesome!! Congratulations, I will centennial study it and use for my business. You are GREAT.

@CodingIsFun Жыл бұрын

It's very kind of you to say so, thank you!

@subramanyakrishnamurthy8352 3 ай бұрын

Totally no nonsense video! You made it all look so easy

@CodingIsFun 3 ай бұрын

Thanks for watching. Glad you liked it! Cheers, Sven ✌️

@keving.7871 2 жыл бұрын

First class edited video presentation. Congrats!

@CodingIsFun 2 жыл бұрын

Thanks a lot! :)

@vikdfr 2 жыл бұрын

Very useful video, and the editing of the video is fantastic. Thanks for sharing the knowledge.

@CodingIsFun 2 жыл бұрын

Thank you! Glad you liked it.

@juricadevic7337 2 жыл бұрын

Thank you very much. Great tutorials. Useful, practical, simple and direct. Your chanel is a great learning resource.

@CodingIsFun 2 жыл бұрын

Happy to hear you like them. Thank you for taking the time to leave a comment and for watching the videos! 😃

@bigman7856 Жыл бұрын

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.

@CodingIsFun Жыл бұрын

Thanks for watching! I wish you a lot of fun & success in your coding journey! :)

@felipelazzarotto3058 2 жыл бұрын

Thanks, mate. Im new to Python and this was great to follow and helped me a lot!

@CodingIsFun 2 жыл бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Happy Coding!

@pathikghugare9918 2 жыл бұрын

Now that's what we call high-quality content!

@CodingIsFun 2 жыл бұрын

Thank you very much! ❤

@sivamagesh 2 жыл бұрын

First time visit to this channel. Very impressed 👏 you make python look easy

@CodingIsFun 2 жыл бұрын

Happy to hear that! Many thanks for watching the video & taking the time to leave a comment. I appreciate it! 👍

@saeedbafaqas8116 2 жыл бұрын

Thanks alot man for this great content, well explained and visualized.

@CodingIsFun 2 жыл бұрын

Thank you! Glad you liked the video :)

@senthilkumarve1424 Жыл бұрын

Excellent demo in simple way! well done

@CodingIsFun Жыл бұрын

Thanks for the kind words! I am glad you enjoyed it. 👍

@adirider6484 6 ай бұрын

Well explained brother... i was able to implement this in a few days. You rock !!!!

@CodingIsFun 6 ай бұрын

Happy to hear that! Cheers, Sven ✌️

@Perspicacious_pi 2 жыл бұрын

Great job! Top form presentation as always

@CodingIsFun 2 жыл бұрын

Thanks for all your comments & support! I appreciate that! 👍

@Robls501510 2 жыл бұрын

Thanks for this very informative video. Learning new things every day.

@CodingIsFun 2 жыл бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

@andrewdisher2086 Жыл бұрын

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 KZfaq series.

@CodingIsFun Жыл бұрын

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.

@prakash2187 Жыл бұрын

I cannot emphasize how good this vid is

@CodingIsFun Жыл бұрын

Thanks for the kind word and watching the video! 👍

@janaeshkrish 2 жыл бұрын

This helped me a lot thanks for the video expecting more like this you are simply rocking

@CodingIsFun 2 жыл бұрын

More to come! Thanks for watching & your comment! :)

@GenNextAnalyst 2 жыл бұрын

Thanks a lot! Happy new year!

@CodingIsFun 2 жыл бұрын

A pleasure! Happy New Year! 🎉

@ahmetsenol6104 Жыл бұрын

Holy demonstration. I am greatful.

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching and your comment! :)

@eduardomoura8613 2 жыл бұрын

Muito bom! Parabéns pela excelente didática!

@CodingIsFun 2 жыл бұрын

Obrigado!

@xilllllix 2 жыл бұрын

this is amazing, thanks! i didn't know about this library...

@CodingIsFun 2 жыл бұрын

Glad you liked the video. Happy Coding! :)

@E_Gaks 2 жыл бұрын

Really instructive video! Good job sir

@CodingIsFun 2 жыл бұрын

Thank you very much! :)

@DejvidVangjelofski Жыл бұрын

Amazing video, easy to follow and replicate, great job!!

@CodingIsFun Жыл бұрын

Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍

@fxsurgeon1 Жыл бұрын

Exactly what I needed! Thanks!

@CodingIsFun Жыл бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

@namvu607 Жыл бұрын

Best tutorial ever sir, thank you.

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching.

@mehmetkaya4330 Жыл бұрын

Thank you for the great tutorial!

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍😍

@user-jy2ki2bt3l 2 жыл бұрын

Thank you for this wonderful tutorial :)

@CodingIsFun 2 жыл бұрын

Glad it was helpful! Thanks for watching & your comment! :)

@mukuldevmahato9669 2 жыл бұрын

Thank you so much for the video. Love from India🇮🇳

@CodingIsFun 2 жыл бұрын

Thank you very much for watching the video! Greetings to India! :)

@felipedelrio263 Жыл бұрын

thank you for your excellent work this help me to build my own dashboard for work

@CodingIsFun Жыл бұрын

Thanks for watching and taking the time to leave a comment. Happy to hear that you were able to build your own dashboard 💪

@edpalen5295 2 жыл бұрын

thank you for sharing this video. Very useful!!!

@CodingIsFun 2 жыл бұрын

A pleasure! Glad you like the video! :)

@conmed55 2 жыл бұрын

Amazing tutorial, the best tutorial. Incredible

@CodingIsFun 2 жыл бұрын

Thank you for your kind feedback! Happy to hear that :)

@abramswee Жыл бұрын

good stuff. Thanks for sharing!

@CodingIsFun Жыл бұрын

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

@johndalevacaro5687 2 жыл бұрын

this is amazing!! thank you so much

@CodingIsFun 2 жыл бұрын

Glad you liked it! :)

@rafaelborda6422 Жыл бұрын

I really love that you do something like this in flask

@CodingIsFun Жыл бұрын

Thank you for watching the video & your suggestion.

@poormancodespmc4598 Жыл бұрын

Thank you for your awesome job. Please do such dashboards with Plotly Dash as well. That would be cool.

@CodingIsFun Жыл бұрын

Thank you for watching the video & your suggestion.

@yeahjustlikethat 2 жыл бұрын

This was outstanding, thank you

@CodingIsFun 2 жыл бұрын

Happy to hear that! Thanks for watching and taking the time to leave a comment!

@stonededge 2 жыл бұрын

Jesus I didn’t realize this was you! Awesome work dude, let’s hang out soon!

@CodingIsFun 2 жыл бұрын

*Thanks!* Yeah! Let's hang out soon!

@mudassarhayat4616 2 жыл бұрын

Excellent stuff with brilliant explaination

@CodingIsFun 2 жыл бұрын

Thank you!

@vp2777 Жыл бұрын

Brilliant video. Thanks.

@CodingIsFun Жыл бұрын

Glad you enjoyed it! Thanks for watching! 👍

@datayogi_ 2 жыл бұрын

Awesome video and great efforts 🔥🔥🔥

@CodingIsFun 2 жыл бұрын

Thank you!

@albaradarwish9190 2 жыл бұрын

Amazing! I have been looking to gap Excel and coding for dashboards. I like PowerBI but this is more fun!

@CodingIsFun 2 жыл бұрын

Glad it was helpful! Happy Streamlit-ing! 🎉

@ankitsahu8621 Жыл бұрын

Excellent piece of work ..

@CodingIsFun Жыл бұрын

Thanks for the kind words! I am glad you enjoyed it.

@micbab-vg2mu Жыл бұрын

Great video - thank you.

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching.

@leonardoguimaraes3622 Жыл бұрын

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?

@CodingIsFun Жыл бұрын

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. 👍

@muhammadaufa1407 2 жыл бұрын

this is what i needed, thankyou

@CodingIsFun 2 жыл бұрын

Glad you liked it. Thanks for watching.

@luvmusicusa Жыл бұрын

This is brilliant thank you

@CodingIsFun Жыл бұрын

Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍

@MauricioJaguan 2 жыл бұрын

I LOVE YOUR CHANNEL!

@CodingIsFun 2 жыл бұрын

*I am glad to hear you are enjoying the videos, thanks for watching and for the comment!*

@burnoutcycle 2 жыл бұрын

Great work !!! it's fantastic, thanks a lot

@CodingIsFun 2 жыл бұрын

Thanks for watching!

@klzo4785 2 жыл бұрын

very useful, thanks a lot!

@CodingIsFun 2 жыл бұрын

Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!

@sanketss84 Жыл бұрын

super helpful video. thank you.

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching and taking the time to leave a comment!

@sanketss84 Жыл бұрын

@@CodingIsFun thanks for taking the time to make this informative video and sharing your knowledge with the world.

@ricardo.alves.campos 2 жыл бұрын

Hi, as always great video. 🙂

@CodingIsFun 2 жыл бұрын

As always, thank you very much for the comments and support, Ricardo Campos! 😃❤

@shockinho Жыл бұрын

amazing, congratulations!

@CodingIsFun Жыл бұрын

Glad to hear you liked it! Thank you for commenting and watching. :)

@cymi2607 Жыл бұрын

Great video! Thank you!

@CodingIsFun Жыл бұрын

Glad you liked it! Thanks for watching and your comment!

@garycroftsmicroscopy Жыл бұрын

This is awesome, thanks

@CodingIsFun Жыл бұрын

Glad you liked it. Thanks for watching and taking the time to leave a comment!

@thepowerofpositivethinking2593 Жыл бұрын

thank you so much bro its interesting tut...

@CodingIsFun Жыл бұрын

My pleasure. Thanks for watching and commenting! :)

@MzTeeL Жыл бұрын

Great tutorial!

@CodingIsFun Жыл бұрын

Thank you! 👍👍

@williansuarez3988 Жыл бұрын

¡demasiado bueno para ser cierto, excelente tutorial! Thanks and please more python projects

@CodingIsFun Жыл бұрын

Thanks for leaving a comment and for taking the time to watch, Willian Suarez! Glad you liked it. 🤩👍

@AK-ie2th 2 жыл бұрын

Thanks a lot! Good job!

@CodingIsFun 2 жыл бұрын

Glad you liked it. Thanks for watching.

@ronaktali Жыл бұрын

Excellent Tutorial

@CodingIsFun Жыл бұрын

Glad to hear you liked it! Thank you for commenting and watching. 👍

@chobblegobbler6671 7 ай бұрын

Danke schön,schonen tag noch,ciao

@CodingIsFun 7 ай бұрын

Bitte. Dir auch einen schönen Tag

@ThePablete15 Жыл бұрын

Muchas gracias por el tutorial, voy a ponerlo en práctica

@CodingIsFun Жыл бұрын

¡De nada! Me alegro de que te haya gustado el tutorial.

@houssemmemmiche8036 2 жыл бұрын

Super interesting! Thanks

@CodingIsFun 2 жыл бұрын

Thank you!

@akshajss7483 Жыл бұрын

I admire that you reply to every comment, did you also automate that too😅. Nice tutorial though.

@CodingIsFun Жыл бұрын

Nope, no automation in place. It's all me 😅

@bysamimhaider Жыл бұрын

Very informative .

@CodingIsFun Жыл бұрын

Thank you!

@christiansfaith5631 Жыл бұрын

Thank you for this video

@CodingIsFun Жыл бұрын

You're very welcome! Thank you for watching and for the comment!

@SheerlckHolmes 2 жыл бұрын

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

@CodingIsFun 2 жыл бұрын

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!

@julianawada-victor3376 2 жыл бұрын

great work! helped my project.

@CodingIsFun 2 жыл бұрын

Happy to hear that. Thanks for watching!

@julianawada-victor3376 2 жыл бұрын

@@CodingIsFun You are welcome 🙂

@mul243 2 жыл бұрын

Thanks for good video. Please, more example of streamlit.

@CodingIsFun 2 жыл бұрын

My pleasure emile mul, thank you for watching!

@KrumGanev 8 ай бұрын

Pretty neet! thanks!

@CodingIsFun 8 ай бұрын

Glad you liked it. Thanks for watching and taking the time to leave a comment!

@markolar3161 2 жыл бұрын

This is so cool! 😲

@CodingIsFun 2 жыл бұрын

Thank you! :)

@moaiedbetamour6078 Жыл бұрын

Thank you for sharing

@CodingIsFun Жыл бұрын

My pleasure! Appreciate you taking the time to watch and leave a comment. 👍

@govindyadahalli8495 2 жыл бұрын

Very Good video ! Thank you

@CodingIsFun 2 жыл бұрын

My pleasure! Thanks for watching the video and taking the time to leave a comment! :)

@OMCreateable Жыл бұрын

Love this tutorial, then the pay wall behind the feature of this whole tutorial.......

@CodingIsFun Жыл бұрын

As mentioned (and even explained) in the video, you do not need the add-in to follow along ...

@shivayshakti6575 Жыл бұрын

Great work done Sven, wonder this is possible with sheets as well!

@CodingIsFun Жыл бұрын

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!

@shivayshakti6575 Жыл бұрын

@@CodingIsFun That's so sweet of you, thanks a lot :)