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

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

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

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

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

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

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

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

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

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

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

[@GarettHarnish]

In pandas 2, you'll get "typeerror: datetime64 type does not support sum operations" on the selection for the fig charts. This is easily fixed by changing sum() to sum(numeric_only=true). Apparently, older versions of Pandas quietly dropped those columns out, but this is no longer the case. Similarly, in the version of streamlit I'm running (1.22.0), st.cache is deprecated and needs to be replaced with st.cache_data. Handy tutorial. Thanks.

[@uzii_31]

Thank you so much ❤

[@CodingIsFun]

Thanks for watching and catching that! It's the reason I put the requirements.txt file in the GitHub repo: github.com/Sven-Bo/streamlit-sales-dashboard/blob/main/requirements.txt. Otherwise, keeping up with more than 100 code examples on my channel would be a real challenge if Python packages keep changing. 😅

[@manjitmohanty]

after this fix , am getting TypeError: 'DataFrame' object is not callable , did you get that as well ? Any help please

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

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

[@BlueSkyGoldSun]

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

[@CodingIsFun]

Thanks for your kind feedback. I appreciate it!

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

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

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

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

[@keving.7871]

First class edited video presentation. Congrats!

[@CodingIsFun]

Thanks a lot! :)

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

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

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

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

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

[@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 ✌️

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

[@subramanyakrishnamurthy8352]

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

[@CodingIsFun]

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

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

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

[@pathikghugare9918]

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

[@CodingIsFun]

Thank you very much! ❤

[@adirider6484]

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

[@CodingIsFun]

Happy to hear that! Cheers, Sven ✌️

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

[@Formula7Driver]

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

[@CodingIsFun]

Thank you! Glad you like the video! :)

[@rafaelborda6422]

I really love that you do something like this in flask

[@CodingIsFun]

Thank you for watching the video & your suggestion.

[@eduardomoura8613]

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

[@CodingIsFun]

Obrigado!

[@apersonalive4111]

Hi, firstly, you should know that you teach really, really well. Secondly, I'm not able to find a command prompt in Google Colab. What's up with that? It shows an error otherwise. Any advice?

[@CodingIsFun]

Thanks for checking out the video. Honestly, I have no idea if you can run a Streamlit app on Google Colab. You might want to hit up Google and do some digging to see if it's even possible. Good luck with that!

[@apersonalive4111]

Thank you for replying! Yeah, I looked it up. Apparently you can but you have to install ngrok and write a really long code to open the command line prompt. Geez.

[@apersonalive4111]

Follow up question: What platform did you code this on?

[@okotpascal1239]

I've used the same command and even tried the suggested one by jupyter notebook but I've failed to see the Dashbord

[@CodingIsFun]

Thanks for checking out the video. Honestly, I have no idea if you can run a Streamlit app on Jupyter Notebook. You might want to hit up Google and do some digging to see if it's even possible. Good luck with that!

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

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

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

[@carlo6195]

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

[@CodingIsFun]

You're very welcome! Thank you for watching and for the 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 ...

[@lmeza1983]

0:06 Interactive dashbog using "Pi-phone" 😂 Don't hate me, it sounds funny, thanks for the tutorial really informative.

[@CodingIsFun]

Thanks for watching!

[@mul243]

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

[@CodingIsFun]

My pleasure emile mul, thank you for watching!

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

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

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

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

[@zahidimranx]

Dear Sir, Thank you so much for great invention. I have one question. after preparing this web link. how I can use it on my web page? means how I can add it to my website?

[@CodingIsFun]

Thanks for watching the video & your question. One option would be it use an : www.tutorialrepublic.com/html-tutorial/html-s.php I hope this helps!

[@onaucc9899]

Hey, that's an awesome tutorial. Streamlit is super useful for me as a beginner who isn't to good with Python yet, because i can do stuff without worrying about other languages. Let's say we have this exact dashboard: Is there a possibility to use Streamlit to create some "data entry from", where we can expand the excel sheet itself? Or another example would be a simple expense tracker: present the Data like here, but with a button that says "add expense" or something and feeds that data into the excel sheet, that's ultimately used as database, wich then again is represented visually in Streamlit?

[@CodingIsFun]

Thanks for the kind words. Excel might actually not the best 'database'. That said, have a look at the following example, where I am building an income and expense tracker in streamlit using a NoSQL database for the backend: kzbin.info/www/bejne/aZbKkoCcep5mbpo I hope it helps! Happy Coding!

[@onaucc9899]

@@CodingIsFun Thanks so much! That's absolutely perfect, i can't believe i've not seen it when i looked at your channel

[@lukaivovic369]

Can I connect it with online google sheet, instead of excell sheet? This is crazy man, thank you for videos, keep them coming!!

[@CodingIsFun]

Thank you! You can also connect Streamlit to Google Sheets. Here is a written blog article showing you the steps: docs.streamlit.io/knowledge-base/tutorials/databases/private-gsheet

[@TheTrotterTribe]

This is great thank you! I need to create and automate a metrics dashboard. How can I use this and automatically pull in the real time data? Any video on that?

[@CodingIsFun]

It's a good question but such a difficult one to answer because it depends on so many factors. So far, I do not have a video on pulling real time data.

[@MegaArti2000]

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

[@CodingIsFun]

🐍😍

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

[@mukuldevmahato9669]

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

[@CodingIsFun]

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

[@luislopes806]

Particularly, I thank you for this Video! It is excellent one. This Video is very important to me. The Streamlit is to create web applications directly in Python. I would like to you to explain how to create web application for Energy Consumption for my project.

[@CodingIsFun]

Thank you for watching the video, the kind words & your video suggestion. 👍

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

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

[@senthilkumarve1424]

Excellent demo in simple way! well done

[@CodingIsFun]

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

[@trevorcohle5138]

Does it work only on my computer? I mean, what are the prerequisites for that dashboard working on my colleagues’ computers? Should we all have an access to the same repository folder which is stored on a Google disc for example?

[@CodingIsFun]

Thanks for watching. Each colleague could run the app locally, but this would not be very practical. If you have the option, you could deploy the web app on an (on-premise) server.

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

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

[@wicem4]

thanks for the tutorial, amazingly quick and clear; just one thing i didn't understand the effect is about this color*lengh of the bar, it didn't seem to work

[@CodingIsFun]

Thanks for watching. What exactly didn't seem to work? Did you get an error message?

[@wicem4]

@@CodingIsFun when you ake it in the video you multiply the color by the bar (what is it suposed to do ?) maybe it's working but i didn't get it.

[@CodingIsFun]

@@wicem4 Please revisit the video starting at 10:40 min. In the color_discrete_sequence, you can define a list of colors for the bars. In my situation, I wanted all the bars to have the same color. To achieve this, I multiplied the hex color code by the length of the dataframe (number of columns). I hope this explanation is clear. Feel free to experiment with or remove this line to observe its impact on your chart.

[@wicem4]

@@CodingIsFun thanks for the explanation, i had indeed misunderstood your line. i thought that when you multilplied, it would change the color depending on the lengh of the bar. thanks again !!

[@adirintodjanggaly5934]

Please next content is a data Plan Versus Actual, Weekly Report, Monthly Report, and Report Yearly, thankyou for your sharing sir

[@CodingIsFun]

Same reply as before ;)

[@namvu607]

Best tutorial ever sir, thank you.

[@CodingIsFun]

Glad you liked it. Thanks for watching.

[@ahmetsenol6104]

Holy demonstration. I am greatful.

[@CodingIsFun]

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

[@MartinMEH]

Can we use this trying to analyze errors? To find the stand outs to make my life easier

[@CodingIsFun]

Thanks for watching. That sounds possible.

[@srh1034]

I am amazed by your tutorials. A question for you: I have started designing a data exploratory app using Streamlit and SQL in my work place. People are amazed by how fast the project can be prototyped and how simple and tidy it looks. I have concerns regarding Streamlit robustness and reliability and whether or not it is a wise choice to use Streamlit as an enterprise and production ready app. or Plotly Dash maybe?

[@CodingIsFun]

Thanks for watching the video and your kind words. What exactly do you mean by robustness and reliability concerns?

[@srh1034]

@@CodingIsFun Robustness & Scalability: What if I what to share same app with 10s (100s maybe?!) of users which will use it simultaneously for heavy analytics which is handled behind the seen by Python, Pandas, .... Reliability: My problem right now is that Streamlit app stops running sometimes without showing any error! This is a big concern if I want to share this app with a wider group of users.

[@CodingIsFun]

@@srh1034 Robustness & Scalability: In my opinion, this is more related to the server capabilities on which you will deploy your (streamlit) web app and how you structure your app. Reliability: So far, I have not experienced sudden stops without any errors. You might want to introduce logs to your app, to narrow down the bug.

[@endritlutolli4767]

Hey, great content ! You explain things exactly the way it needs to be explained to make it easy to understand. One more question regarding filtering: How to filter the filters dynamically among themselves? Let's use the first 11 lines in minute 6:15 as an example Dataset If I filter the city by "Mandalay", then the other filters remain the same, although there is only one choice (member and female) for the other filters Or if I select "male" -> for City only "Napiytaw" and "Yangon" should be displayed and not all 3 characteristics Is there a way to define these conditions between the filters?

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@endritlutolli4767]

@@CodingIsFun No problem at all and thanks for the quick feedback! Take your time. Maybe I will find a solution in the meantime or someone else knows a way :) Otherwise I'm from near Stuttgart, should you feel like a beer or protein shake haha - let me know, I invite you for your great content on KZbin

[@CodingIsFun]

@@endritlutolli4767 I'm always down for a protein shake! 😅Thanks for the invitation I'll keep it in mind. 👍

[@marineclivaz8729]

Hello Sven, I write this comment to You because I am a student in Switzerland and I have a project concerning data engineering, that's why I am watching your video. Our project is to create à dashboard with data from the production of aspirin, with data like the purity or the melting point. We need to do this dashboard but we don't know which tool or programm using. We started with python but we are novice and it is quite complicated. What is your advice? Which tool is the best? Is there easier way to use python to create dashboard?

[@CodingIsFun]

Hey! I'd recommend using Python with Streamlit for creating a dashboard. It's beginner-friendly and works well with data. Dash is another option, but it might have a steeper learning curve. Good luck! 👍

Hello, Sven! Amazing work you're doing with your channel! I've got a question: What about if I want to deploy this app on Heroku, and want to update the rows? Should I make a data entry form (like one of your videos)? Let's suppose my Excel is locally hosted. Or maybe an "upload to heroku app" code with VBA on the same locally hosted Excel?

[@CodingIsFun]

Thanks for tuning in. I'm glad you enjoy the videos. In your situation, using a database or Google Sheets is a better option. This way, you won't have to continuously deploy your local Excel sheet to your web server, such as a Heroku instance, every time you make changes. Check out these tutorials on connecting Streamlit to a database for more information: docs.streamlit.io/knowledge-base/tutorials/databases. I hope this helps. Happy coding!

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

[@Whoamiyt92]

This is awesome thank you for sharing and teaching. btw is it possible to customize the page by adding other menu button ? and is it can also be mobile apps? thank you.

[@CodingIsFun]

Thanks for watching. Not sure which menu buttons you mean, but you can field all available elements in the streamlit documentation: docs.streamlit.io/ And yes, Streamlit web apps are mobile responsive.

[@Whoamiyt92]

@@CodingIsFun Thank you.

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

[@noeldoller2958]

Thank so much Sir for this video very useful and timely for my similar project. Im just newbie in Python and streamlit. Appreciate if you can expand this video at the bottom page to include one or two more data frame and create links graphs . Im trying to re- create the code to practice. Appreciate to share your expertice in my request please

[@CodingIsFun]

Thanks for watching the video & your comment. You might want to have a look at the following video, where I have created another streamlit app based on an Excel Sheet: kzbin.info/www/bejne/bavIcnx7ha-UpbM I hope this helps!

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

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

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

[@alirafeek9645]

This is amazing, just in time for my project, I did all the things you mentioned here and it is excellent. I have a question here please, in your example, the two plots are next to each other, and I have the same, but mine have a checkbox of plots to select from (in fact they are 4 plots), so when I tick a plot, it is displayed immediately, in their coded locations, but what if I click only the 1st and 4th plots? They will show in their coded places, and locations 2 and 3 are empty, which does not look nice So, the question is, how do I make the position of the plot dynamic? e.g., if I click on the 4th first, it will shows in position one, which is column1 left, then if I click the 1st, it will shows in the 2nd position (column 1, right), so it will be interactive as well, based on the first empty position, but I don't mind that it will be sorted if I click the 1st plot later, then it will push others, as long as there is no empty space. I hope you got my point. Thanks in advance.

[@CodingIsFun]

Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!

[@alirafeek9645]

@@CodingIsFun sure I do understand and appreciate what you are doing, not many people are going that way. However, is there a command I should look at to achieve this? Just a couple of words if possible, and I am ready to work it out and test. Thanks anyway, great job

[@manderfeldnet]

I hear German efficiency speaking, thanks a lot!

[@CodingIsFun]

A pleasure! Thanks for watching the video and your comment! 👍

[@dongfanzhang4623]

Hello, your job is very cool! thanks a lot for uploading these tutorial. I have an excel which use query to extract data from sql server. Therefore depending on the parameters chosen, the data get loaded into excel are different. How can I turn it into a Streamlit dashboard ?

[@CodingIsFun]

Thanks for watching and your question. I would suggest to directly query the data from your server using python/pandas (you can also use SQL within pandas). Happy Coding!

[@colinhuang2325]

Thanks Sven, can we send the app to other users to use who does not have python or streamlit installed?

[@CodingIsFun]

Thanks for watching. Yes, you can deploy the app to a webserver as explained in the end of the video: kzbin.info/www/bejne/aoSyZHaLjLWMnJI&feature=shares

[@keyyyla]

Great video. Can someone help me with the following question: I have created a dashboard that uses data from an excel sheet, such as in the video. Now, I want to make this dashboard usable for a collegue who dont know any programming and just wants to use it as if it was a little software program that one can install. Whats the best way to make this dashboard accessible snd usable to him?

[@CodingIsFun]

Thank you for watching. You can deploy the dashboard on Streamlit Cloud or any other hosting server, such as Render, and secure access with authentication. I already have videos on both topics (deployment and authentication) on my channel. Good luck with your project! 🍀

[@keyyyla]

Thank you!@@CodingIsFun

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

[@anduq1092]

Good luck getting any of this past most Risk departments i've seen. But...not bad!

[@CodingIsFun]

Thanks, I deployed already many Streamlit applications on your on-premise cloud. But...thanks for your comment!

[@Perspicacious_pi]

Great job! Top form presentation as always

[@CodingIsFun]

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

[@Nasengold]

Very cool Tutorial. Can you make the sidebar selection just click on and off? Like you just highlight the options?

[@CodingIsFun]

Thanks! I am not sure how to implement that.

[@visuss1]

Good one to explore more. I used a different data to practice as it will make sense in learning . Created depended filter as such df_state = df.query( "State == @state" ) city = st.sidebar.multiselect( "Select a City:", options=df["City"].unique(), default=df_state['City'].value_counts().idxmax() ) Is this most recommended way to create ?

[@CodingIsFun]

Thanks for watching. Whether this is the "most recommended" way to create this type of functionality depends on the specific requirements and constraints of the project. If it works as expected, then I would not change it.

[@najiepandian6421]

The demonstration and discussion were so detailed and easy to understand. Well done and I applaud you for that . I'm new in programming and I'm kind of still in the learning stage and the way you discuss stuffs make this field interesting. May I know if there's a way to filter column headers too, more like selecting the columns you wish to display in your dataframe?

[@CodingIsFun]

Thanks for watching and for your comment. Happy to hear that you enjoyed the video. Regarding your question, I am unsure which columns you are referring to. Do you want to filter the columns interactively in the dashboard?

[@najiepandian6421]

That's right, I want to interactively filter the columns in the dashboard. I was able to display and make selection from the column header in the dashboard by using the function "list(df)" but I couldn't get the dataframe updated the same way you do in df.query. Would appreciate it if you could share your thoughts on this.

[@CodingIsFun]

@@najiepandian6421 Perhaps the aggrid module might do what you want: github.com/PablocFonseca/streamlit-aggrid

[@najiepandian6421]

@@CodingIsFun Thanks for sharing this one, I'll definitely take a look into it. Thanks much, hoping to see more videos like this from your channel. :)

[@mehmetkaya4330]

Thank you for the great tutorial!

[@CodingIsFun]

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

[@unnamednoaddress.2343]

"Why simplify if complicated is also good." Guys want to reinvent the wheel when Excel does everything. It could have been done in Excel, connected with Power BI or even using Excel Dashboards. Congratulations on the code, but we need to be objective when working with data, because time and clear information are money.

[@CodingIsFun]

I partially agree. If you want to visualise your (Excel) data, PowerBI is an excellent choice. That said, with Streamlit, you can build data apps to connect with your Machine-/Deeplearning models or build entire user interfaces to interact with REST APIs. Streamlit helps to create UI's for Python code. So the video's purpose is not to convince people to replace any data viz tool like PowerBI or Tableau; it should only demonstrate one use case of Streamlit and how to get started.

[@GenNextAnalyst]

Thanks a lot! Happy new year!

[@CodingIsFun]

A pleasure! Happy New Year! 🎉

[@franckguihikonhi8446]

Please what software do you use to have this perfect presentation,

[@CodingIsFun]

Thanks for watching. I am using "Camtasia".

[@chobblegobbler6671]

Danke schön,schonen tag noch,ciao

[@CodingIsFun]

Bitte. Dir auch einen schönen Tag

[@lyndaharrache5442]

Many thanks for this great work ! I found you videos so useful. I'm beginner in python, I try to practise with this video but I have a problem with command prompt, I can't past the direction of the project. Could you help me please ☺️

[@CodingIsFun]

Thanks for watching. What exactly is the issue?