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

👉 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

[@CodingIsFun]

👉Website Demo: www.salesdashboard.pythonandvba.com/ 👉Streamlit Playlist: kzbin.info/aero/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n 👉Deploy your streamlit app for free on Heroku: kzbin.info/www/bejne/pHuro4asjt2toKc 👉Deploy your streamlit app for free on Render: kzbin.info/www/bejne/aoSyZHaLjLWMnJI 👉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]

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]

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]

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

[@Ravichawla68]

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

[@CodingIsFun]

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

[@luisacuna1729]

I agree

[@miracapur]

Exactly my thought!

[@techtbe]

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

[@CodingIsFun]

Thanks for your sub & welcome aboard!

[@santhoshreddykesavareddy1078]

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]

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

[@athump947]

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]

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

[@jonathanacuna]

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

[@CodingIsFun]

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]

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]

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]

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

[@CodingIsFun]

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

[@mohammedalbatati5529]

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]

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

[@BlueSkyGoldSun]

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

[@CodingIsFun]

Thanks for your kind feedback. I appreciate it!

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

[@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! :)

[@futuregootecks]

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

[@CodingIsFun]

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

[@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! ☀🏖✌

[@hnclienteshn4501]

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]

Glad you like them 😃 Thanks for watching & your 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! 😊

[@chuchaftw]

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

[@CodingIsFun]

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

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

[@benlong1062]

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

[@CodingIsFun]

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

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

[@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! 👍

[@carlo6195]

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

[@CodingIsFun]

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

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

[@harisprabowo4039]

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

[@CodingIsFun]

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

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

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

[@sivamagesh]

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

[@CodingIsFun]

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

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

[@pathikghugare9918]

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

[@CodingIsFun]

Thank you very much! ❤

[@keving.7871]

First class edited video presentation. Congrats!

[@CodingIsFun]

Thanks a lot! :)

[@vikdfr]

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

[@CodingIsFun]

Thank you! Glad you liked it.

[@saeedbafaqas8116]

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

[@CodingIsFun]

Thank you! Glad you liked the video :)

[@felipelazzarotto3058]

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

[@CodingIsFun]

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

[@juricadevic7337]

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

[@CodingIsFun]

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

[@eduardomoura8613]

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

[@CodingIsFun]

Obrigado!

[@adirider6484]

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

[@CodingIsFun]

Happy to hear that! Cheers, Sven ✌️

[@Perspicacious_pi]

Great job! Top form presentation as always

[@CodingIsFun]

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

[@subramanyakrishnamurthy8352]

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

[@CodingIsFun]

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

[@senthilkumarve1424]

Excellent demo in simple way! well done

[@CodingIsFun]

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

[@prakash2187]

I cannot emphasize how good this vid is

[@CodingIsFun]

Thanks for the kind word and watching the video! 👍

[@Robls501510]

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

[@CodingIsFun]

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

[@janaeshkrish]

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

[@CodingIsFun]

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

[@GenNextAnalyst]

Thanks a lot! Happy new year!

[@CodingIsFun]

A pleasure! Happy New Year! 🎉

[@xilllllix]

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

[@CodingIsFun]

Glad you liked the video. Happy Coding! :)

[@E_Gaks]

Really instructive video! Good job sir

[@CodingIsFun]

Thank you very much! :)

[@stonededge]

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

[@CodingIsFun]

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

[@rafaelborda6422]

I really love that you do something like this in flask

[@CodingIsFun]

Thank you for watching the video & your suggestion.

[@ahmetsenol6104]

Holy demonstration. I am greatful.

[@CodingIsFun]

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

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

[@user-jy2ki2bt3l]

Thank you for this wonderful tutorial :)

[@CodingIsFun]

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

[@mehmetkaya4330]

Thank you for the great tutorial!

[@CodingIsFun]

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

[@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 💪

[@mukuldevmahato9669]

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

[@CodingIsFun]

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

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

[@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 😅

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

[@Formula7Driver]

Using 6.9 for rating example at 7:34 was a really NICE touch

[@CodingIsFun]

Thank you! Glad you like the video! :)

[@bfbsj7122]

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.

[@CodingIsFun]

Glad you found it helpful! Cheers, Sven ✌️

[@namvu607]

Best tutorial ever sir, thank you.

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@albaradarwish9190]

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

[@CodingIsFun]

Glad it was helpful! Happy Streamlit-ing! 🎉

[@conmed55]

Amazing tutorial, the best tutorial. Incredible

[@CodingIsFun]

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

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

[@Khozai]

How do you include columns (in the filtering process) if the columns have spaces in their names?

[@CodingIsFun]

Thanks for watching. You can use backticks: df.query('`this column` == 20')

[@muhammadnaqiuddinkamilmohd5994]

Hello. Do you mind making a video on how to filter the dates using Streamlit using st.slider and st.date_input from a dataframe that contains a date column? Would really much appreciated. Thank you.

[@CodingIsFun]

Thanks for watching and for your suggestion!

[@MegaArti2000]

You got me on the "no need for HTML, CSS or JS"

[@CodingIsFun]

🐍😍

[@yeahjustlikethat]

This was outstanding, thank you

[@CodingIsFun]

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

[@edpalen5295]

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

[@CodingIsFun]

A pleasure! Glad you like the video! :)

[@mars545]

Mr Acuña, how about if the excel has a lot of sheet that stand for date that the data inputted. Could we create like a real-time data monitoring by connecting excel to website using Streamlite. Thanks

[@CodingIsFun]

Thank you for tuning in. In this scenario, a database or a simple alternative such as Google Sheets would be a great option. For more information on connecting Streamlit to various data sources, please visit the following link: docs.streamlit.io/knowledge-base/tutorials/databases. I hope this information helps. Happy coding! 🚀

[@coreyhodder5]

This is great - one question: Why does the df.query need to reference the @city st.sidebar.multiselect object with an “@“ sign?

[@CodingIsFun]

Thanks for watching. The @-sign lets pandas know that you are referring to a variable. I have put together a simple example for you: pastebin.com/iiTSBx30 Kindly see the difference and notice that the last line will create an error. I hope it helps!

[@datayogi_]

Awesome video and great efforts 🔥🔥🔥

[@CodingIsFun]

Thank you!

[@vp2777]

Brilliant video. Thanks.

[@CodingIsFun]

Glad you enjoyed it! Thanks for watching! 👍

[@mudassarhayat4616]

Excellent stuff with brilliant explaination

[@CodingIsFun]

Thank you!

[@abramswee]

good stuff. Thanks for sharing!

[@CodingIsFun]

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

[@ankitsahu8621]

Excellent piece of work ..

[@CodingIsFun]

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

[@MauricioJaguan]

I LOVE YOUR CHANNEL!

[@CodingIsFun]

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

[@aoweixu]

so for disclosure i haven't watched the video yet but what does this offer over PowerBI if that's what I am used to for data visualization already?

[@CodingIsFun]

Streamlit and PowerBI are two different tools for data analysis and visualization. Streamlit is a framework for building interactive web-based data apps. It is easy to use and provides a way to create simple to complex data dashboards, interact with data and add custom code in Python. PowerBI, on the other hand, is a more complete business intelligence tool that provides a way to connect, model, and visualize data from a wide range of sources. PowerBI is designed to be used by business analysts and is more focused on providing ready-made data visualizations and reports. Example: If you want to create a simple dashboard to visualize your company's sales data, you might use Streamlit to create an interactive chart and data table. If you want to analyze sales data from multiple sources and build reports that can be shared with others, you might use PowerBI.

[@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. 🤩👍

[@757noi6]

Hey firstly thanks for the video, this is extremely valuable! May I ask how do I make full use of the space and expand my bar chart? I have quite a fair bit of columns but my view is restricted to only about 20 rows. How do I expand the view of bar chart?

[@CodingIsFun]

Currently the bar charts are placed in two columns next to each other. You might want to put your bar chart in a separate column instead.

[@r.v.rajagopalan1626]

@757noi how did it work for you, i keep getting an error - ImportError: cannot import name 'Iterable' from 'collections' after creating a virtual environment and installing modules via requirements.txt

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

[@FlemmingLund-nm6sq]

23.04.2023! It is a very Nice bilder up tutorial, but small business does only ned Excel to the same ting if you learn/know how to use Power query, Powers pilot or a little VBA code.

[@CodingIsFun]

Thanks for watching and throwin' in your two cents.

[@johndalevacaro5687]

this is amazing!! thank you so much

[@CodingIsFun]

Glad you liked it! :)

[@faizanalikakar]

I want to create a dashboard for machine status , The machines normally create a lof file which is txt format , i want to record data from the log files and keep it in a database and display it in the machine status dashboard which will display previous errors in the machine say yesterday or last week or last month , will also display plots of voltages etc. Whats the right protocol for me to follow ? My initial plan is to write a python code to read the log files and store it int db file and then you dash for the dashboard. any suggestions ?

[@CodingIsFun]

Hi Faizan, thanks for your comment and for sharing your project details. Your initial plan sounds like a good start. I receive many custom requests, so unfortunately, I can't provide more detailed advice. I hope you understand, and best of luck with your project!

[@micbab-vg2mu]

Great video - thank you.

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@SolidBuildersInc]

Great Video, Question ? Is it possible to change the height of the real estate to allow for a navigational header at the top without losing the left sidebar navigation link ? Thanks for any help...

[@CodingIsFun]

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!

[@SheerlckHolmes]

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]

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!

[@luvmusicusa]

This is brilliant thank you

[@CodingIsFun]

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

[@burnoutcycle]

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

[@CodingIsFun]

Thanks for watching!

[@shockinho]

amazing, congratulations!

[@CodingIsFun]

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

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

[@SuperNaicker]

Great video. Thanks. One question. How is this better than PowerBI? More controls and flexibility to customize?

[@CodingIsFun]

Thanks, Senthil! Briefly, PowerBI is more focused on data visualization and reporting, while Streamlit allows for more customization and flexibility in creating interactive web apps using Python. One area where Streamlit shines is in building interactive web apps for machine learning or data science projects, as it easily integrates with Python libraries and enables quick prototyping and sharing. Both have their strengths depending on your specific use case. 😊

[@ricardo.alves.campos]

Hi, as always great video. 🙂

[@CodingIsFun]

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

[@arcticwildernesssurvival680]

Hi, how would I filter based on column header names? I.e. in your example if I would want to filter the dataframe based on gender, customer type but ALSO drop the whole branch column from the datafame? Thanks

[@arcticwildernesssurvival680]

I have numerical data in all columns despite the first, and most of it would not be relevant for the end-user.

[@CodingIsFun]

@@arcticwildernesssurvival680 Thanks for watching the video. Sure, you could also delete certain columns. Example below: df = df.drop(['column_nameA', 'column_nameB'], axis=1) Pandas Documentation: pandas.pydata.org/docs/reference/api/pandas.DataFrame.drop.html I hope this helps! 😀

[@muhammadaufa1407]

this is what i needed, thankyou

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@SanataniAryavrat]

how would you control for valueError, if I remove (unselect) all the city names from the selection.

[@CodingIsFun]

Thanks for watching. You could specify a default value in the select box.

[@SanataniAryavrat]

@@CodingIsFun If you could do here so that to help others, probably this could avoid the error otherwise your viewers might face.

[@mul243]

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

[@CodingIsFun]

My pleasure emile mul, thank you for watching!

[@ronaktali]

Excellent Tutorial

[@CodingIsFun]

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

[@sasongkosan8832]

Perfect !! Your tutorial is amazing ❤️❤️ .. is that possible if the excel file was update or changes the value .. and the value on the dashboard will changes /update also?

[@CodingIsFun]

Thanks for the kind words! I am glad you enjoyed it. If you run it locally, the changes in Excel will be reflected in streamlit. Yet, I assume you want to reflect the Excel changes in a deployed streamlit web app. 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!

[@cymi2607]

Great video! Thank you!

[@CodingIsFun]

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

[@klzo4785]

very useful, thanks a lot!

[@CodingIsFun]

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

[@messironaldo8622]

how can i create .streamlit folder and config.toml inside in Mac OS?

[@CodingIsFun]

Sorry, but I have never used macOS.