👉Website Demo: www.salesdashboard.pythonandvba.com/ 👉Streamlit Playlist: ua-cam.com/play/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n.html 👉Deploy your streamlit app for free on Heroku: ua-cam.com/video/nJHrSvYxzjE/v-deo.html 👉Deploy your streamlit app for free on Render: ua-cam.com/video/4SO3CUWPYf0/v-deo.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/
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
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
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. 😅
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.
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.
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.
Amazing tutorial. Thank you for sharing. I hit a minor block around 10:10 when doing the groupby, when it gave an error for trying to do sum on datetime fields. I resolved it by dropping the date and time columns, like this: df2 = df_selection.drop(['Date', 'Time'], axis=1).groupby(by=["Product line"]).sum()[["Total"]].sort_values(by="Total") I am using pandas 2.2.3. Hope this helps.
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 !!
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 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.
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 UA-cam
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 UA-cam series.
Thanks for watching and for your suggestion! I appreciate the recommendation and will keep it in mind for future content, but I can't make any promises.
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!
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.
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.
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?
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.
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!
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 !!
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!
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!
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!
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.
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.
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. 😊
👉Website Demo: www.salesdashboard.pythonandvba.com/
👉Streamlit Playlist: ua-cam.com/play/PL7QI8ORyVSCaejt2LICRQtOTwmPiwKO2n.html
👉Deploy your streamlit app for free on Heroku: ua-cam.com/video/nJHrSvYxzjE/v-deo.html
👉Deploy your streamlit app for free on Render: ua-cam.com/video/4SO3CUWPYf0/v-deo.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
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!
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!
people like you are the reason why humans have reached this far. Thank you sooooo much. i wish you good health and good luck my frind
It's very kind of you to say so; thank you!
This is 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?
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! ☀🏖✌
Your tutorials are simply fantastic, from the content to the video editing, congratulations!
Your comment is a boost! Thanks for the energy! 💖👍
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!
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.
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! 😃
Because of your simplicity, your the best one in UA-cam .
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! 😊
This video was very useful to me, I was struggling a lot but I think it helps me
Glad it helped! Happy Streamlit-ing! -Sven ✌️
First class edited video presentation. Congrats!
Thanks a lot! :)
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
I cannot emphasize how good this vid is
Thanks for the kind word and watching the video! 👍
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!
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. 👍
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!
Totally no nonsense video! You made it all look so easy
Thanks for watching. Glad you liked it! Cheers, Sven ✌️
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!
Thank you, Sven! Very awesome of you to share this.
You're very welcome! Thank you 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 ✌️
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 :)
Amazing tutorial. Thank you for sharing. I hit a minor block around 10:10 when doing the groupby, when it gave an error for trying to do sum on datetime fields. I resolved it by dropping the date and time columns, like this:
df2 = df_selection.drop(['Date', 'Time'], axis=1).groupby(by=["Product line"]).sum()[["Total"]].sort_values(by="Total")
I am using pandas 2.2.3. Hope this helps.
Thanks for watching. Please use the latest code from the GitHub repo. Cheers, Sven ✌🏼
Very useful video which gives a lot of ideas how to solve my own project issues. Appreciate this work !
An absolute pleasure, very happy to hear that you found it useful!
hey man, thank you very much for your tutorials, they are quite useful, you are very practical, simple and direct, I learn in an easy and simple way .... Thanks again !!
Glad you like them 😃 Thanks for watching & your comment!
Well explained brother... i was able to implement this in a few days. You rock !!!!
Happy to hear that! Cheers, Sven ✌️
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! :)
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. 👍
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!
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! :)
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!
Now that's what we call high-quality content!
Thank you very much! ❤
Excellent demo in simple way! well done
Thanks for the kind words! I am glad you enjoyed it. 👍
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!
Thank you so much for the video. Love from India🇮🇳
Thank you very much for watching the video! Greetings to India! :)
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! 👍
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! 👍
Holy demonstration. I am greatful.
Glad you liked it. Thanks for watching and your comment! :)
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 UA-cam
@@endritlutolli4767 I'm always down for a protein shake! 😅Thanks for the invitation I'll keep it in mind. 👍
I really love that you do something like this in flask
Thank you for watching the video & your suggestion.
Thanks alot man for this great content, well explained and visualized.
Thank you! Glad you liked the video :)
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 UA-cam series.
Thanks for watching and for your suggestion! I appreciate the recommendation and will keep it in mind for future content, but I can't make any promises.
Thank you. A big help!
Glad I could help! Thanks for watching! Cheers, Sven ✌️
Very useful video, and the editing of the video is fantastic. Thanks for sharing the knowledge.
Thank you! Glad you liked it.
Using 6.9 for rating example at 7:34 was a really NICE touch
Thank you! Glad you like the video! :)
Thank you very much. Great tutorials. Useful, practical, simple and direct. Your chanel is a great learning resource.
Happy to hear you like them. Thank you for taking the time to leave a comment and for watching the videos! 😃
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 job! Top form presentation as always
Thanks for all your comments & support! I appreciate that! 👍
Thanks a lot! Happy new year!
A pleasure! Happy New Year! 🎉
Best tutorial ever sir, thank you.
Glad you liked it. Thanks for watching.
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. 👍
You got me on the "no need for HTML, CSS or JS"
🐍😍
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. 👍
Really instructive video! Good job sir
Thank you very much! :)
Muito bom! Parabéns pela excelente didática!
Obrigado!
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!
0:06 Interactive dashbog using "Pi-phone" 😂
Don't hate me, it sounds funny, thanks for the tutorial really informative.
Thanks for watching!
this is amazing, thanks! i didn't know about this library...
Glad you liked the video. Happy Coding! :)
Amazing video, easy to follow and replicate, great job!!
Thanks for leaving a comment and for taking the time to watch! Glad you liked it. 👍
Exactly what I needed! Thanks!
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
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 😅
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 ...
Excellent stuff with brilliant explaination
Thank you!
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.
Amazing tutorial, the best tutorial. Incredible
Thank you for your kind feedback! Happy to hear that :)
Thank you for this wonderful tutorial :)
Glad it was helpful! Thanks for watching & your comment! :)
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 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?
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.
this is what i needed, thankyou
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 💪
Jesus I didn’t realize this was you! Awesome work dude, let’s hang out soon!
*Thanks!* Yeah! Let's hang out soon!
Thank you for the great tutorial!
Glad you liked it. Thanks for watching and taking the time to leave a comment! 👍😍
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
Thanks for good video. Please, more example of streamlit.
My pleasure emile mul, thank you for watching!
Awesome video and great efforts 🔥🔥🔥
Thank you!
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, as always great video. 🙂
As always, thank you very much for the comments and support, Ricardo Campos! 😃❤
This was outstanding, thank you
Happy to hear that! Thanks for watching and taking the time to leave a comment!
I hear German efficiency speaking, thanks a lot!
A pleasure! Thanks for watching the video and your comment! 👍
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 !!
thank you for sharing this video. Very useful!!!
A pleasure! Glad you like the video! :)
I LOVE YOUR CHANNEL!
*I am glad to hear you are enjoying the videos, thanks for watching and for the 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!
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!
This is great - one question: Why does the df.query need to reference the @city st.sidebar.multiselect object with an “@“ sign?
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!
Great work !!! it's fantastic, thanks a lot
Thanks for watching!
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! 🎉
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. 👍
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 :)
great work! helped my project.
Happy to hear that. Thanks for watching!
@@CodingIsFun You are welcome 🙂
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.
Great video. Thanks. One question. How is this better than PowerBI? More controls and flexibility to customize?
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. 😊
this is amazing!! thank you so much
Glad you liked it! :)
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!
This is directly competing with web power Bi dashboards. Really interesting.
*Thanks for watching the video & your comment.*
super helpful video. thank you.
Glad you liked it. Thanks for watching and taking the time to leave a comment!
@@CodingIsFun thanks for taking the time to make this informative video and sharing your knowledge with the world.
good stuff. Thanks for sharing!
My pleasure! Appreciate you taking the time to watch and leave a comment. 👍
amazing, congratulations!
Glad to hear you liked it! Thank you for commenting and watching. :)