👉Website Demo: www.salesdashboard.pythonandvba.com/ 👉Streamlit Playlist: ruclips.net/p/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n 👉Deploy your streamlit app for free on Heroku: ruclips.net/video/nJHrSvYxzjE/видео.html 👉Deploy your streamlit app for free on Render: ruclips.net/video/4SO3CUWPYf0/видео.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
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/
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!
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
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.
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
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.
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.
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. 😅
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 RUclips 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.
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.
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.
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 !!
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.
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.
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 !!
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. 👍
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!
"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.
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.
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!
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?
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!
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.
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?
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!
@@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 RUclips
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!
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.
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
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?
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!
I’m a UX designer and I started looking into Data Analysis mainly power bi as that was the main in thing. I’m shocked out how archaic the visuals are, ok I understand that it’s mainly for stakeholders to see the data visually and they are not that interested in the design however Power bi looks like something from the 90s. Even the mobile layout looks awful. Go to dribble and see the beautiful designs and dashboards and then tell me why power bi looks so bad, this tutorial looks like a massive step in the right direction so thank you.
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?
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: ruclips.net/video/3egaMfE9388/видео.html I hope it helps! Happy Coding!
I've learned VBA Excel for long time but should be updated my knowledge by learn python for the first time, I think it will be fun to code with python, so I say thank you for this video
@@h2nrlc I still use VBA in some of my projects at work. Yet, Python is indeed very fun. You can literally build anything you want, and the syntax is easy to learn :)
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 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.
@@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.
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?
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?
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.
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
@@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.
@@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 !!
👉Website Demo: www.salesdashboard.pythonandvba.com/
👉Streamlit Playlist: ruclips.net/p/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n
👉Deploy your streamlit app for free on Heroku: ruclips.net/video/nJHrSvYxzjE/видео.html
👉Deploy your streamlit app for free on Render: ruclips.net/video/4SO3CUWPYf0/видео.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?
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!
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!
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! 💖👍
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!
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! ☀🏖✌
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! 😃
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!
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.
Thank you so much ❤
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. 😅
after this fix , am getting TypeError: 'DataFrame' object is not callable , did you get that as well ? Any help please
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 RUclips 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.
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. 👍
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!
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 ✌️
Because of your simplicity, your the best one in RUclips .
Keep going
Thanks for your kind feedback. I appreciate it!
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! 😊
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 :)
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! :)
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!
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.
Thanks for watching and throwin' in your two cents.
Using 6.9 for rating example at 7:34 was a really NICE touch
Thank you! Glad you like the video! :)
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!
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! :)
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. 👍
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!
I cannot emphasize how good this vid is
Thanks for the kind word and watching the video! 👍
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 ...
I really love that you do something like this in flask
Thank you for watching the video & your suggestion.
First class edited video presentation. Congrats!
Thanks a lot! :)
I admire that you reply to every comment, did you also automate that too😅. Nice tutorial though.
Nope, no automation in place. It's all me 😅
You got me on the "no need for HTML, CSS or JS"
🐍😍
Now that's what we call high-quality content!
Thank you very much! ❤
0:06 Interactive dashbog using "Pi-phone" 😂
Don't hate me, it sounds funny, thanks for the tutorial really informative.
Thanks for watching!
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! 👍
Muito bom! Parabéns pela excelente didática!
Obrigado!
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!
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!
Totally no nonsense video! You made it all look so easy
Thanks for watching. Glad you liked it! Cheers, Sven ✌️
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. 👍
Well explained brother... i was able to implement this in a few days. You rock !!!!
Happy to hear that! Cheers, Sven ✌️
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!
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!
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. 👍
Thanks alot man for this great content, well explained and visualized.
Thank you! Glad you liked the video :)
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! 👍
Thank you so much for the video. Love from India🇮🇳
Thank you very much for watching the video! Greetings to India! :)
"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.
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.
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! 😃
Thank you, Sven! Very awesome of you to share this.
You're very welcome! Thank you for watching and for the comment!
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 💪
I hear German efficiency speaking, thanks a lot!
A pleasure! Thanks for watching the video and your comment! 👍
Very useful video, and the editing of the video is fantastic. Thanks for sharing the knowledge.
Thank you! Glad you liked it.
the colors talk, when you see them you know he is a good coder, and not a designer
thanks nice video
My pleasure. Thanks for watching. Any suggestions in regards to the design?
Excellent demo in simple way! well done
Thanks for the kind words! I am glad you enjoyed it. 👍
Please next content is a data Plan Versus Actual, Weekly Report, Monthly Report, and Report Yearly, thankyou for your sharing sir
Same reply as before ;)
Good luck getting any of this past most Risk departments i've seen. But...not bad!
Thanks, I deployed already many Streamlit applications on your on-premise cloud. But...thanks for your comment!
Jesus I didn’t realize this was you! Awesome work dude, let’s hang out soon!
*Thanks!* Yeah! Let's hang out soon!
Holy demonstration. I am greatful.
Glad you liked it. Thanks for watching and your comment! :)
Thanks for good video. Please, more example of streamlit.
My pleasure emile mul, thank you for watching!
when he first popped up i was expecting a new york accent. u got me...
Oh, I thought I have strong German accent 😅
@@CodingIsFun dope
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! :)
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 :)
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?
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!
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.
Follow up question: What platform did you code this on?
this is amazing, thanks! i didn't know about this library...
Glad you liked the video. Happy Coding! :)
Great job! Top form presentation as always
Thanks for all your comments & support! I appreciate that! 👍
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.
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?
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!
@@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 RUclips
@@endritlutolli4767 I'm always down for a protein shake! 😅Thanks for the invitation I'll keep it in mind. 👍
This is directly competing with web power Bi dashboards. Really interesting.
*Thanks for watching the video & your comment.*
I've used the same command and even tried the suggested one by jupyter notebook but I've failed to see the Dashbord
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!
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.
Thank you for watching the video, the kind words & your video suggestion. 👍
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. 👍
Can I connect it with online google sheet, instead of excell sheet?
This is crazy man, thank you for videos, keep them coming!!
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
Really instructive video! Good job sir
Thank you very much! :)
Thank you for the great tutorial!
Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍😍
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?
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!
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! 🎉
Danke schön,schonen tag noch,ciao
Bitte. Dir auch einen schönen Tag
Thanks a lot! Happy new year!
A pleasure! Happy New Year! 🎉
I’m a UX designer and I started looking into Data Analysis mainly power bi as that was the main in thing. I’m shocked out how archaic the visuals are, ok I understand that it’s mainly for stakeholders to see the data visually and they are not that interested in the design however Power bi looks like something from the 90s. Even the mobile layout looks awful. Go to dribble and see the beautiful designs and dashboards and then tell me why power bi looks so bad, this tutorial looks like a massive step in the right direction so thank you.
Thank you very much. I am happy to hear that you like the design of the dashboard.
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!
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?
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: ruclips.net/video/3egaMfE9388/видео.html
I hope it helps! Happy Coding!
@@CodingIsFun Thanks so much! That's absolutely perfect, i can't believe i've not seen it when i looked at your channel
Zee German is very efficient and effective. I like
Thank you! 🚀
Very thanks, good 👍 n details explain
Glad you liked it. Thanks for watching. 👍
I've learned VBA Excel for long time but should be updated my knowledge by learn python for the first time, I think it will be fun to code with python, so I say thank you for this video
@@h2nrlc I still use VBA in some of my projects at work. Yet, Python is indeed very fun. You can literally build anything you want, and the syntax is easy to learn :)
Excellent piece of work ..
Thanks for the kind words! I am glad you enjoyed it.
Amazing tutorial, the best tutorial. Incredible
Thank you for your kind feedback! Happy to hear that :)
If there are 1 million more people like you then the world will become Detroit Become Human world in 2040, thank you soooo muchhhhh!!!!!
Thanks for the kind words and your comments. I appreciate it! Happy Coding! Cheers, Sven ✌️
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?
Thanks for watching the video and your kind words. What exactly do you mean by robustness and reliability concerns?
@@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.
@@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.
Thank you for this wonderful tutorial :)
Glad it was helpful! Thanks for watching & your comment! :)
Brilliant video. Thanks.
Glad you enjoyed it! Thanks for watching! 👍
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?
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?
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.
@@najiepandian6421 Perhaps the aggrid module might do what you want: github.com/PablocFonseca/streamlit-aggrid
@@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. :)
I LOVE YOUR CHANNEL!
*I am glad to hear you are enjoying the videos, thanks for watching and for the 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.
Excellent Tutorial
Glad to hear you liked it! Thank you for commenting and watching. 👍
good stuff. Thanks for sharing!
My pleasure! Appreciate you taking the time to watch and leave a comment. 👍
¡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. 🤩👍
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
Thanks for watching. What exactly didn't seem to work? Did you get an error message?
@@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.
@@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.
@@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 !!
This is brilliant thank you
Thanks for the positive feedback! Appreciate you taking the time to leave a comment. 👍