🤷♂ *Do you have questions or need further support? Let me know in the comments!* 🌟 Live Demo: surveyresults.pythonandvba.com 🌟 Deploy your Streamlit Application to *Heroku* for free: ruclips.net/video/nJHrSvYxzjE/видео.html 🌟 Deploy your Streamlit Application to *Render* for free: ruclips.net/video/4SO3CUWPYf0/видео.html
BRAVO BRAVO !! You are a KING !! With this Application you just Kill All the Microsoft Power BI Application and all this for free - I CANNOT BELIEVE MY EYES - We subscribe in mass to you. Thank you my brother !!
Hey great video! One suggestion: you may want to include the library name "streamlit" in the title to help gain traffic from people looking specifically for streamlit tutorials.
As always great tutorial, I am very pleased to see the quality of your tutorials and videos, in general, is increasing exponentially. Thank you for your time making these videos, I have been learning very much. Best of luck!
Thank you so much for this video… I been watching some of your other videos like converting Excel into csv files and so on… I didn’t have enough time to thank you because I did download your program and I made some silly mistakes, which took a lot of time to amend it. I am just getting into Python and streamlit and these are quite hard to learn it in the begging. The Jupyter Notebook Pandas demonstration was also very useful. I never used Jupiter… Now I recon I will definitely do it. Once again I thank you so much for your beautiful explanations and the quality of your tutorial. I will be now onwards watching you regularly…
🤯 You are awesome I really enjoyed this tutorial and will be trying it out on my own 👍🏽👍🏽👍🏽 Can't wait for the next one with uploading to server-side Respect 👏🏼👏🏼
*I am glad you liked the video, thanks for watching and for the comment!* I will try to release the video on how to deploy the web app for free on Heroku this coming weekend 😃
Thank you for making this video! It is very helpful and well-edited. I'm just getting into Python and Streamlit and these walkthroughs are much appreciated! The Jupyter Notebook Pandas demonstration was also very useful. What Jupyter app is that? The interface looks much better than the one I'm using.
Hi Paul Carr, Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video! Yesterday, I released another streamlit tutorial on how to turn an Excel sheet into a Sales Dashboard. You might be interested in that one too: ruclips.net/video/Sb0A9i6d320/видео.html Regarding your question, I am using two jupyter notebook extensions: 1 - Collapsible headings 2 - Zen mode Here is a great blog article to show you how to install the extensions: ndres.me/post/best-jupyter-notebook-extensions/ I hope this helps! 😃
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Love from india!!!! Thank you for making this video! It is very helpful and well-edited. I'm just getting into Python and Streamlit and these walkthroughs are much appreciated! can you please make a video for Excel with vba & macros with user forms!
Thanks for watching the video & your kind feedback. Regarding your video request, you might want to check out the following video from 'Excel Macro Mastery': ruclips.net/video/nsClitREZqg/видео.html I hope this help! Greetings to India! ❤
@@CodingIsFun @Coding Is Fun thanks for replying, i meant an excel which already contains VBA's, macros,formulae and user forms to web app with python also by which i mean to ask that, is it possible to convert/write complete vba code with certian user forms which i have to convert in web page/app with python, codes which i already have my in vba...
@@akki803 As a starting point, you could use my free Excel add-in to create a pandas dataframe right inside Excel: ruclips.net/video/pms52_-cmc8/видео.html Currently, I am not aware of any solution to create a web app directly from Excel. Unfortunately, there is no automatic way to convert your current VBA code to Python.
@@CodingIsFun i request,....if you can make a video to re-type vba codes in python to make a web app, ... I will mail/send you my vba project with sources code, if you are interested please think on it it will be a great help for me and lots like me... and also a interesting way to learn python more. LoL❤ to the channel already its helping a lot. Edit: i saw your ecxel sheet to web video ruclips.net/video/Sb0A9i6d320/видео.html but i wanted to know if you can help in re-coding of vba to python.🙂
*I am glad to hear you are enjoying them, thanks for watching and for the comment!* You need to deploy on webserver. You've got a couple options here, like using the Streamlit cloud for a free deployment or checking out a hosting platform like Render. I've even made a tutorial on my channel specifically for using Render, so feel free to give it a look. Good luck with the deployment!
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Amazing tutorial! Is the possible with Google Sheets? When I host a an editable G sheet in an , the row and column headers appear as well as sheet tabs. I cannot seem to remove these as you have removed in your tutorial
Thanks for watching! While it might be possible to do this with Google Sheets, I haven't personally tried it. So, I can't provide a definitive answer. Happy Coding!
Thank you for the video. Helped a lot. My only problem is slowness. I have excel file with 1200 row and columns go from A to Z It is taking too much time to load the initial data or filtered data. Is there any way to make it faster?
Hey there! Thanks for tuning in! 😊 To speed up loading times and avoid reloading the entire dataframe from scratch, try using Streamlit's caching feature with the @st.cache decorator. For example: @st.cache def load_data(): df = pd.read_excel(excel_file, sheet_name=sheet_name, usecols='B:D', header=3) return df You can find more info on Streamlit caching here: docs.streamlit.io/library/advanced-features/caching Hope this helps!Happy Streamlit-ing! 🚀
This is really great tutorial and easy for beginners too. I just had a question if we change or update the data in Excel will streamlit website update ?
Glad it is helpful! It depends. Assuming you are hosting your streamlit app on a web server -> in that case, you always need to deploy the latest Excel files to the webserver.
Thanks for watching. Not sure, if it is "the best" solution, but I do like pyecharts for that purpose: ruclips.net/video/xE95tIzCuKM/видео.htmlsi=BBEVDvdYD_qUGHAn Happy Coding! Cheers, Sven ✌️
What a great tutorial!! for some reason once I finish all the codes, I get "ImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl." I have installed openpyxl and even xlrd but get same error. It can not read the excel file I guess. Any options to consider??
Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install openpyxl' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!
Hi! I'm looking for an idea for a SaaS and perhaps with this I can offer an alternative to big BI tools such as Looker Studio, PowerBI and so on by developing classes that generate these dashboards. Do you think there's room for this?
Thanks for watching. PowerBI is primarily used for business analytics, allowing you to create interactive visualizations and business intelligence reports. Streamlit, on the other hand, is a fast and easy way to build custom machine learning tools, letting you create interactive web applications by just writing Python scripts.
Hi! I have a question that if there are multiple Sheets of excel, then can we plot multiple graphs/charts in a row horizontally instead of going vertically downwards as in tutorial? Furthermore, any guidance to modify design of web app? Thank you in advance! Cheers
Thanks for watching. You can store each sheet in a different dataframe. Example: df1 = pd.read_excel("filename.xlsx", sheet_name="Sheet1") df2 = pd.read_excel(f"ilename.xlsx", sheet_name="Sheet2") Regarding the styling and the different plotting options, I would suggest to check out my other streamlit videos. Happy Coding!
Hi great video.....I was also trying to make data vizualization weba app using streamlit and i was using csv file from my local machine but while deploying it in heroku it is throwing error could you help me with it ?
Great tutorial, thank you very much. Just built my first streamlit app with your help. Me and Chat GPT searched 2 hours for answers to 2 questions and couldn't find an answer. Maybe you have time to answer it. I'd really appreciate it. Have a nice week. 1. how can i change the default text of the dataframe_explorer "Filter dataframe on"? if i can't change it, can i hide it? 2. how can i adjust the size of the fonts used in the st.slider. it's too small.
Thank you for tuning in! To address your questions: 1. Based on the documentation (extras.streamlit.app/Dataframe%20explorer%20UI), there doesn't seem to be a parameter for altering the default text. 2. Streamlit does not natively support font size modification, as indicated in the documentation: docs.streamlit.io/library/api-reference/widgets/st.slider However, for both cases (1 & 2), you can utilize custom CSS to achieve the desired changes. Unfortunately, explaining the entire process is beyond the scope of a single comment. I hope this information is helpful. Happy coding!
Thanks! I am not entirely sure what you mean by a search button, but it sounds possible. Please check out the streamlit documentation to see all available widgets: docs.streamlit.io/ Happy Coding!
It seems I having a problem the error was this " 'streamlit' is not recognized as an internal or external command, operable program or batch file." Even though the streamlit was successfully installed. Hoping you can help me about this problem. I'm try to make that streamlit turtorial. thanks Sir.
Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install ' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!
@@CodingIsFun ... wie konfiguriert man ein Jupyter-Notebook so, damit es so schön aussieht wie in deinem Beispiel. Sieht sehr praktisch aus, wenn man nur die Überschriften sehen kann und der ganze Code zusammengeklappt werden kann. Oder arbeitest du hier in JupyterLab? PS: Habe die Webapp nachgebaut - funktioniert echt gut. Danke für die gute Erklärung.
@@christoph231090 *Vielen Dank fuer dein Kommentar.* Du kannst kostenlose Jupyter Notebook Extensions installieren. Hier findest du einen guten Artikel darueber: medium.com/@maxtingle/10-jupyter-notebook-extensions-making-my-lyfe-easier-f40139a334ce Das feature welches ich nutze heisst "Collapsible Headings" (Nr. 9 im Artikel). Ich hoffe, dass dir dies weiterhilft. Beste Gruesse Sven
Sorry for my late response. You could add 'secrets' to your streamlit app when deploying. See documentation below: docs.streamlit.io/en/stable/deploy_streamlit_app.html#secrets-management
Great Video!! Thank you. I have a question: when I do the st.dataframe(df_participants). The column Participants shows the number in float, like 69.0000. Do you know how to solve it? Thank you.
Thank you for watching the video. You could convert the column to integers: df_participants = pd.read_excel(excel_file, sheet_name= sheet_name, usecols='F:G', converters={'Participants': int}, header=3) Hope this helps :)
when I put in the command prompt, streamlit run app.py I get the message: 'streamlit' is not recognized as an internal or external command... How can I fix this?
@@CodingIsFun haha its amazing how fast you answered! RESPECT! To be brief, I would like to display a dataframe (maybe from excel type) and create also some filters for selection! As end goal, I have to export the filtered 'new' datafame. Imagine that I want to extract a specific sample of Users from a list that obeys to my filters selection (eaaaaaaaaasyyyyy)
@@efthymiosmakrandreou1285 Thanks for the additional info. In the following tutorial, I have done something very similar: ruclips.net/video/ZDffoP6gjxc/видео.html I hope it helps! Happy Coding!
Thanks for watching the video. Actually, in the video, I am declaring sheet_name already as a variable: excel_file = 'Survey_Results.xlsx' sheet_name = 'DATA' df = pd.read_excel(excel_file, sheet_name=sheet_name, usecols='B:D', header=3)
@@wbw1209 Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!
Hi, I have a question, lets say you have multiple people who need their separate surveys. Is there a way to create a web app (like this one) that has a user login so it connects to the proper excel file or tab? That way you wouldn't need to host multiple instances of the same webapp.
Thanks for watching the video & your question. Currently, there are a lot of discussions on how to implement a user authentication into a streamlit app: discuss.streamlit.io/t/user-authentication/612 The simplest (but not a very secure way) is to request the user to enter a password to access your streamlit app: access_token = st.text_input(‘Please enter your access token:’) if access_token != ‘your_secret_token’: st.write(‘Sorry, your token is invalid. Please try again or contact the administrator.’) st.stop() Depending on the access token/password you could then show the different Excel file/tab (pandas dataframe) I hope this helps! Happy Coding! 😃
@@CodingIsFun Nice eventually will need something more secure but thank you so much for replying, video was sensational and now your comment is the cherry on top, super appreciate it!!!!
Thanks for watching. Have a look here: discuss.streamlit.io/t/new-library-streamlit-jupyter-a-new-way-to-develop-streamlit-apps-in-jupyter-notebooks/35679 Happy Coding! Cheers, Sven ✌️
Great tutorial, thank you very much. ValueError: The first argument to the plotly.graph_objs.layout.Template constructor must be a dict or an instance of :class:`plotly.graph_objs.layout.Template` How can solve the problem.
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
*Hi Bayu Anggoro. I am glad you liked the video. Thanks for watching and for the comment!* Yes, you can either use the Google Sheets API or simply make your Google Spreadsheet public. For doing this, you just have to go to File->Publish to the web. Then choose “Microsoft Excel (.xlsx)” from the dropdown menu and copy the URL. Once done, you could use df = pd.read_excel(YOUR_URL)
Vielen Dank für dieses Video. Gibt es eine Möglichkeit, diese Web App auch Kollegen zur Verfügung zu stellen, die weder Python, noch die dazugehörigen Packages installiert haben? Praktisch im Intranet des Unternehmens? Danke dir vorab! Thank you for this video. Is there a way to make this web app available to colleagues who have neither Python nor the associated packages installed? Practically on the company's intranet? Thank you in advance!
Hi Florian, *Thanks for watching the video & your question.* It depends also on the firewall settings within your company, but the web app would be available under the 'Network Url' [see screenshot]: 👉 prnt.sc/10mq6tb If you want to export the web app to a standalone HTML file, this is currently not possible (see also the open issue on Github): 👉 github.com/streamlit/streamlit/issues/611 I am not sure about your use-case, but if you 'only' want to export visuals in a 'Dashboard' format (without the slider/multi-select), you could use other libraries, like 'Plotly' or 'Pyechart'. Those can be exported to HTML as well. Please see the example below: 👉 gallery.pyecharts.org/#/Tab/tab_base Hope this helps. Cheers, Sven
@@CodingIsFun Many thanks for your response. I would like to make certain tables available interactively so that employees in the company can compile the data themselves with the help of sliders, etc. For example, we have several production lines with daily outputs and disruptions. Here you could filter the data depending on the production line. I have already created such a dashboard with streamlit, but it only works on my computer with Python.
@@selimalili Another option could be to install Python on a shared drive/folder within your company (where everybody can have access) & create a .bat file (example below): set root=Z:\SharedFolder\Miniconda3\ call %root%\Scripts\activate.bat call streamlit run "path\to\file\app.py" The end-user then only needs to run the Batch File. Please note, that I have not tested out the solution myself, but theoretically this should work 🙏
Hey, great content! I wanted to ask you, if its possible to update the filter selection after choosing filters from another filter selection. For example if i have two multiselection fields and i choose some filters at one, that the other selection gets smaller. Thanks in advance if you can help :)
Thanks for watching the video. I am not quite sure if I understand you correctly, but perhaps the following might help you: import streamlit as st first_slider = st.slider('first slider', min_value=1, max_value=10, value=5, step=1) second_slider = st.slider('seconds slider', min_value=1, max_value=20, value=15-first_slider, step=1)
Thank you for watching the video & your questions. As far as I know, currently there is no option/solution to host streamlit on SharePoint or to convert it to standalone files (HTML, CSS, JS) 😕
@@CodingIsFun Thank you for the quick response. Which other which other python packages I could use to get output as HTML, CSS , JS. So that I just copy all the files on to SP and it functions as a SP site
Thanks for watching the video. Django is another high-level Python Web framework. Depending on your project, you could also replicate this project with Django. Yet, Streamlit might be more straightforward to develop & deploy (Machine Learning)Web Apps quickly.
Thank you so much, but I have a problem if you can explain it to me when I create the file app.py won't change to python. Thanks in advance. I am a total beginner at python zero levels. :)
*Thanks for watching the video & your question.* Could you please try to enable the view of 'filename extensions' and try to rename your file again? 👉 vtcri.kayako.com/article/296-view-file-extensions-windows-10 Hope this helps 🙏 Cheers, Sven
@@CodingIsFun I followed all of the steps again but still didn't change the file into a python file as you have in the video, I will be so glad if you can help me with that. I really need to learn that. Thanks, millions. I would appreciate it if we can share my screen with you to see the things, I am sure you can solve the problem within a minute.
@@findthetruth3021 Alternatively, you could also open up 'Notepad', go to 'File' > 'Save As...' and then type 'app.py' Kindly have a look at the screenshot: prnt.sc/10lsr3p
@@CodingIsFun thanks a lot, and I really made you tired with that. But, I am so desperate because I even uninstalled the conda and reinstalled again and followed all of the steps still the same issue 😌☹️ I am sure if we have Skype call and give you access to my desktop will solve the issue in minutes. Thanks in advance.
Been trying for an hour to install Streamlit. Tried so much. Pip just can't do it. I updated to the latest version. Got some error message like "You need Rust and Cargo" so I went to the Rust website and installed it. Then it couldn't find cargo so I went into windows environment variables and manually added cargo then. Again I tried. Still won't work...
Thanks for watching the video and your video request. Can you perhaps elaborate on what it is you're actually trying to achieve? Please provide some additional info. Thanks!
@@CodingIsFun in the vba excel toolbox section, there is a web browser, in the web browser a chart can be made, but with the condition that the chart is in HTML program language, maybe I can continue to email along with pictures, so that it is clearer and understandable
@@mfeproject615 Thanks for the further input. Most likely, I will not create a separate video about VBA charts. Here is already a comprehensive tutorial on VBA charts: ruclips.net/video/fWyw4DJCSsE/видео.html
🤷♂ *Do you have questions or need further support? Let me know in the comments!*
🌟 Live Demo: surveyresults.pythonandvba.com
🌟 Deploy your Streamlit Application to *Heroku* for free: ruclips.net/video/nJHrSvYxzjE/видео.html
🌟 Deploy your Streamlit Application to *Render* for free: ruclips.net/video/4SO3CUWPYf0/видео.html
BRAVO BRAVO !! You are a KING !! With this Application you just Kill All the Microsoft Power BI Application and all this for free - I CANNOT BELIEVE MY EYES -
We subscribe in mass to you. Thank you my brother !!
Hi Johan,
*Wow, thank you so much!* I am glad you enjoyed the video 😃
Cheers,
Sven
Hey great video! One suggestion: you may want to include the library name "streamlit" in the title to help gain traffic from people looking specifically for streamlit tutorials.
Thank you for watching the video & your suggestion - I have changed the title 👍😃
As always great tutorial, I am very pleased to see the quality of your tutorials and videos, in general, is increasing exponentially. Thank you for your time making these videos, I have been learning very much. Best of luck!
Comments like yours is what gives me the motivation to publish more videos. *Thank you so much for your support.* 🙏
Thank you so much for this video… I been watching some of your other videos like converting Excel into csv files and so on… I didn’t have enough time to thank you because I did download your program and I made some silly mistakes, which took a lot of time to amend it. I am just getting into Python and streamlit and these are quite hard to learn it in the begging. The Jupyter Notebook Pandas demonstration was also very useful. I never used Jupiter… Now I recon I will definitely do it. Once again I thank you so much for your beautiful explanations and the quality of your tutorial. I will be now onwards watching you regularly…
Ah, you're making me blush! Thanks for the kind comments and happy to hear that you're enjoying the videos! Happy Coding! :)
This is so good! I wish I had come across it a year ago when it was published. Liked and subbed. Greetz from France.
Thanks for watching and welcome aboard! :)
Thanks
Thanks a ton for the support! 🙏
🤯 You are awesome
I really enjoyed this tutorial and will be trying it out on my own 👍🏽👍🏽👍🏽
Can't wait for the next one with uploading to server-side
Respect 👏🏼👏🏼
*I am glad you liked the video, thanks for watching and for the comment!*
I will try to release the video on how to deploy the web app for free on Heroku this coming weekend 😃
I think it's very complex programing project for me, however you explained everything very well sir..
Thanks for watching and the kind words. Good luck with your project! 🍀 Happy learning & coding!
Thank you for making this video! It is very helpful and well-edited. I'm just getting into Python and Streamlit and these walkthroughs are much appreciated! The Jupyter Notebook Pandas demonstration was also very useful. What Jupyter app is that? The interface looks much better than the one I'm using.
Hi Paul Carr,
Happy to hear that it was useful; thank you for taking the time to leave a comment and for watching the video!
Yesterday, I released another streamlit tutorial on how to turn an Excel sheet into a Sales Dashboard. You might be interested in that one too:
ruclips.net/video/Sb0A9i6d320/видео.html
Regarding your question, I am using two jupyter notebook extensions:
1 - Collapsible headings
2 - Zen mode
Here is a great blog article to show you how to install the extensions:
ndres.me/post/best-jupyter-notebook-extensions/
I hope this helps! 😃
Just what I need..thank you, sir, for your excellent video tutorial.
Happy to hear that. I appreciate that you took the time to leave a comment! :)
Thank you teacher, Thank you so much for this video, i from Cuba
Glad you liked it. Thanks for watching. Greetings to Cuba! 👋
one of the best technolgies , i which i knew it , thanks a lot
Glad to hear you liked it! Thank you for commenting and watching.
Amazing... great explanation and exactly what I'm looking for.... thank you!!
Glad you liked it. Thanks for watching and your comment! 👍
willing to learn. Unless you already understand setups, then I gues sit's gonna be easier, but as a classically trained pianist I was blown
*Thanks for watching the video & your comment.*
Thank you! Great video and instruction
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
Your tutorials are very helpful. Thankyou
*I am glad to hear you are enjoying them, thanks for watching and for the comment!*
Again a great tutorial - your videos are really well-organized!
*I am glad to hear you are enjoying them, thanks for watching and for the comment!*
very lovely, I will run through this tutorial fairly soon, thank you
*Thank you.* I am glad you enjoyed the video 😃
Hi, Paul ,very helpful , Thanks
Glad to hear that!
Bro,you are a King. Thank you for your clear explanations. 👍👍
You're very welcome! Thank you for watching and for the comment!
Awesome explanation 🎉
Thank you! 🤩
Amazing❤😍
Thanks 😄
This is a great tutorial! thank you!!
Thanks for watching the video and your comment! :)
Thanks for a making a very good learning video on python.
My pleasure! Appreciate you taking the time to watch and leave a comment.
Awesome explanation
Glad you liked it. Thanks for watching and taking the time to leave a comment!
Thanks, what a great tutorial.
*Thank you very much* 😃
Seus tutoriais são ótimos e muito funcionais. Sempre consigo aprimorar meu conhecimento com você. Parabéns.
Obrigado pelo apoio! Fico feliz que esteja aprendendo. Valeu! 👍
Great job! How to use the filter slider to select a period range on the plotly candlestick chart?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Always very interesting
Hi Gerhard,
*Thank you.* I am glad you enjoyed the video 😃
Your Tutorial are very helpful
*I am glad you liked the video, thanks for watching and for the comment!*
Excelent tutorial!
Glad you liked it. Thanks for watching.
Love from india!!!! Thank you for making this video! It is very helpful and well-edited. I'm just getting into Python and Streamlit and these walkthroughs are much appreciated! can you please make a video for Excel with vba & macros with user forms!
Thanks for watching the video & your kind feedback. Regarding your video request, you might want to check out the following video from 'Excel Macro Mastery':
ruclips.net/video/nsClitREZqg/видео.html
I hope this help! Greetings to India! ❤
@@CodingIsFun @Coding Is Fun thanks for replying, i meant an excel which already contains VBA's, macros,formulae and user forms to web app with python
also by which i mean to ask that, is it possible to convert/write complete vba code with certian user forms which i have to convert in web page/app with python, codes which i already have my in vba...
@@akki803 As a starting point, you could use my free Excel add-in to create a pandas dataframe right inside Excel:
ruclips.net/video/pms52_-cmc8/видео.html
Currently, I am not aware of any solution to create a web app directly from Excel.
Unfortunately, there is no automatic way to convert your current VBA code to Python.
@@CodingIsFun i request,....if you can make a video to re-type vba codes in python to make a web app, ... I will mail/send you my vba project with sources code, if you are interested please think on it it will be a great help for me and lots like me... and also a interesting way to learn python more. LoL❤ to the channel already its helping a lot.
Edit: i saw your ecxel sheet to web video ruclips.net/video/Sb0A9i6d320/видео.html
but i wanted to know if you can help in re-coding of vba to python.🙂
I was wondering if this will work with an excel xlsm workbook, and will the macros still be functional?
Thanks for watching. I went ahead and tested it for you -> Yes, it also works with xlsm files.
Wonderful tutorials 🤩🤩🤩🤩🤩🤩🤩🤩 thank you so much...
Does that network link works anywhere or only on the local machine?
*I am glad to hear you are enjoying them, thanks for watching and for the comment!*
You need to deploy on webserver. You've got a couple options here, like using the Streamlit cloud for a free deployment or checking out a hosting platform like Render. I've even made a tutorial on my channel specifically for using Render, so feel free to give it a look. Good luck with the deployment!
@@CodingIsFun sounds great, thank you so much for responding 🙌🙌🙌🤝🤝
Could you please guide me to display the same data as a pivot table on the webpage?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Amazing tutorial! Is the possible with Google Sheets? When I host a an editable G sheet in an , the row and column headers appear as well as sheet tabs. I cannot seem to remove these as you have removed in your tutorial
Thanks for watching! While it might be possible to do this with Google Sheets, I haven't personally tried it. So, I can't provide a definitive answer. Happy Coding!
Can you make web app for ml model. But the app can import dataset and split data train and test, and then the app can predict from dataset.
Thanks for watching. That would be possible with Streamlit. Happy coding! :)
Thank you for the video. Helped a lot.
My only problem is slowness.
I have excel file with 1200 row and columns go from A to Z
It is taking too much time to load the initial data or filtered data.
Is there any way to make it faster?
Hey there! Thanks for tuning in! 😊 To speed up loading times and avoid reloading the entire dataframe from scratch, try using Streamlit's caching feature with the @st.cache decorator. For example:
@st.cache
def load_data():
df = pd.read_excel(excel_file,
sheet_name=sheet_name,
usecols='B:D',
header=3)
return df
You can find more info on Streamlit caching here: docs.streamlit.io/library/advanced-features/caching
Hope this helps!Happy Streamlit-ing! 🚀
Very cool tutorial. Thank you very much.
*I am glad you liked the video, thanks for watching and for all your support!*
Thanks Sven, can I use the the "create pandas data frame" I installed in my excel here in the survey result excel to create 2 data frame? Thank you
Hi Noel! Yes, you can! Kindly give it a try 👍
This is really great tutorial and easy for beginners too.
I just had a question if we change or update the data in Excel will streamlit website update ?
Glad it is helpful!
It depends. Assuming you are hosting your streamlit app on a web server -> in that case, you always need to deploy the latest Excel files to the webserver.
Great tutorial! I want to know can I add user login and authentication to the web app to make it fully functional?
Thanks. Check out this tutorial: blog.streamlit.io/streamlit-authenticator-part-1-adding-an-authentication-component-to-your-app/
Happy Coding!
Awesome...thank you so much...I was able to build off of it
*Happy New Year!* 🎉
Fantastic! 💪 Thanks for watching the video and your comment.
Whats the best 'flat file' solution to share a self-contained 'html' style interactive dashboards with python?
Thanks for watching. Not sure, if it is "the best" solution, but I do like pyecharts for that purpose: ruclips.net/video/xE95tIzCuKM/видео.htmlsi=BBEVDvdYD_qUGHAn
Happy Coding! Cheers, Sven ✌️
What a great tutorial!! for some reason once I finish all the codes, I get "ImportError: Missing optional dependency 'openpyxl'. Use pip or conda to install openpyxl." I have installed openpyxl and even xlrd but get same error. It can not read the excel file I guess. Any options to consider??
Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install openpyxl' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!
My list of data that is shown on streamlist is just blank and not showing the database
Thanks for watching. Please clone the repo and try again. Happy Coding! Cheers, Sven ✌️
Hi!
I'm looking for an idea for a SaaS and perhaps with this I can offer an alternative to big BI tools such as Looker Studio, PowerBI and so on by developing classes that generate these dashboards. Do you think there's room for this?
I guess you just need to give it a try. In general, it sounds possible. Good luck and happy coding!
very nice video , thanks.
Thank you very much! 👍
What is different between this and power bi????
Thanks for watching. PowerBI is primarily used for business analytics, allowing you to create interactive visualizations and business intelligence reports. Streamlit, on the other hand, is a fast and easy way to build custom machine learning tools, letting you create interactive web applications by just writing Python scripts.
Can this be done using flask?
Yes, you could also insert Plotly charts into a flask app. You might want to check out the module 'Dash'.
Hi!
I have a question that if there are multiple Sheets of excel, then can we plot multiple graphs/charts in a row horizontally instead of going vertically downwards as in tutorial?
Furthermore, any guidance to modify design of web app?
Thank you in advance!
Cheers
Thanks for watching. You can store each sheet in a different dataframe. Example:
df1 = pd.read_excel("filename.xlsx", sheet_name="Sheet1")
df2 = pd.read_excel(f"ilename.xlsx", sheet_name="Sheet2")
Regarding the styling and the different plotting options, I would suggest to check out my other streamlit videos.
Happy Coding!
@@CodingIsFun Thanks !
Much appreciated!
Hi great video.....I was also trying to make data vizualization weba app using streamlit and i was using csv file from my local machine but while deploying it in heroku it is throwing error could you help me with it ?
Have you checked my Deployment Tutorial already? ruclips.net/video/nJHrSvYxzjE/видео.html
Really awesome.
Thank you!
Great tutorial, thank you very much. Just built my first streamlit app with your help. Me and Chat GPT searched 2 hours for answers to 2 questions and couldn't find an answer. Maybe you have time to answer it. I'd really appreciate it. Have a nice week.
1. how can i change the default text of the dataframe_explorer "Filter dataframe on"? if i can't change it, can i hide it?
2. how can i adjust the size of the fonts used in the st.slider. it's too small.
Thank you for tuning in! To address your questions:
1. Based on the documentation (extras.streamlit.app/Dataframe%20explorer%20UI), there doesn't seem to be a parameter for altering the default text.
2. Streamlit does not natively support font size modification, as indicated in the documentation: docs.streamlit.io/library/api-reference/widgets/st.slider
However, for both cases (1 & 2), you can utilize custom CSS to achieve the desired changes. Unfortunately, explaining the entire process is beyond the scope of a single comment. I hope this information is helpful. Happy coding!
Hi, great tutorial however is it possible to add search button?
Thanks! I am not entirely sure what you mean by a search button, but it sounds possible. Please check out the streamlit documentation to see all available widgets: docs.streamlit.io/
Happy Coding!
Great!
Thanks
You're very welcome! Thank you for watching and for the comment!
It seems I having a problem the error was this " 'streamlit' is not recognized as an internal or external command,
operable program or batch file." Even though the streamlit was successfully installed. Hoping you can help me about this problem. I'm try to make that streamlit turtorial. thanks Sir.
Hard to tell from a distance. My closest guess is that you are getting this issue because you are trying to import a module of a library which is not installed in your virtual environment. If you have run 'pip install ' already, ensure to call your Python file from the same environment in which you installed the package. For example, in your IDE/text editor, you might have set a different Python environment for executing your script. Therefore, try to run your Python file also from the command prompt. If that does not work, try searching for the text of your error message on Google/StackOverflow. Happy Debugging!
Super Tutorial - weiter so
Hallo Christoph,
*Vielen lieben Dank* 👍
Beste Gruesse,
Sven ✌
@@CodingIsFun ... wie konfiguriert man ein Jupyter-Notebook so, damit es so schön aussieht wie in deinem Beispiel. Sieht sehr praktisch aus, wenn man nur die Überschriften sehen kann und der ganze Code zusammengeklappt werden kann. Oder arbeitest du hier in JupyterLab?
PS: Habe die Webapp nachgebaut - funktioniert echt gut. Danke für die gute Erklärung.
@@christoph231090 *Vielen Dank fuer dein Kommentar.* Du kannst kostenlose Jupyter Notebook Extensions installieren. Hier findest du einen guten Artikel darueber:
medium.com/@maxtingle/10-jupyter-notebook-extensions-making-my-lyfe-easier-f40139a334ce
Das feature welches ich nutze heisst "Collapsible Headings" (Nr. 9 im Artikel).
Ich hoffe, dass dir dies weiterhilft.
Beste Gruesse
Sven
@@CodingIsFun perfekt - hilft auf jeden Fall weiter.
Danke
once we built it how to deploy and share it with others remotely ensuring security?
Sorry for my late response. You could add 'secrets' to your streamlit app when deploying. See documentation below:
docs.streamlit.io/en/stable/deploy_streamlit_app.html#secrets-management
Great Video!! Thank you. I have a question: when I do the st.dataframe(df_participants). The column Participants shows the number in float, like 69.0000. Do you know how to solve it? Thank you.
Thank you for watching the video. You could convert the column to integers:
df_participants = pd.read_excel(excel_file,
sheet_name= sheet_name,
usecols='F:G',
converters={'Participants': int},
header=3)
Hope this helps :)
@@CodingIsFun It works!! Thanks a lot!!
when I put in the command prompt, streamlit run app.py I get the message: 'streamlit' is not recognized as an internal or external command... How can I fix this?
Thanks for watching the video. Did you install streamlit already (pip install streamlit)?
docs.streamlit.io/library/get-started/installation
the dataframe is not affected by the filtering .... am i right? is there any solution to this?
Thanks for watching the video. Can you perhaps elaborate on what it is you're trying to achieve? Please provide some additional info. Thanks!
@@CodingIsFun haha its amazing how fast you answered! RESPECT! To be brief, I would like to display a dataframe (maybe from excel type) and create also some filters for selection! As end goal, I have to export the filtered 'new' datafame. Imagine that I want to extract a specific sample of Users from a list that obeys to my filters selection (eaaaaaaaaasyyyyy)
@@efthymiosmakrandreou1285 Thanks for the additional info. In the following tutorial, I have done something very similar: ruclips.net/video/ZDffoP6gjxc/видео.html
I hope it helps! Happy Coding!
@@CodingIsFun greatly appreciate your help !!!!! You rock
if i want make sheet_name like a variable ...how i can do it
Thanks for watching the video. Actually, in the video, I am declaring sheet_name already as a variable:
excel_file = 'Survey_Results.xlsx'
sheet_name = 'DATA'
df = pd.read_excel(excel_file,
sheet_name=sheet_name,
usecols='B:D',
header=3)
Dear Mr Sven i dont know how to run app.py. Can you explain to me, what should i do?
2:45 min
@@CodingIsFun yes sir i use command prompt from anaconda but it doesn't work
@@wbw1209 Unfortunately, with that bit of information, I cannot help you. You might want to take some time to write down which line of code is causing the error; let me know if you have modified the code from the tutorial, explain in more depth what you did to troubleshoot the problem and provide some more context. Thanks!
Hi, I have a question, lets say you have multiple people who need their separate surveys. Is there a way to create a web app (like this one) that has a user login so it connects to the proper excel file or tab? That way you wouldn't need to host multiple instances of the same webapp.
Thanks for watching the video & your question.
Currently, there are a lot of discussions on how to implement a user authentication into a streamlit app:
discuss.streamlit.io/t/user-authentication/612
The simplest (but not a very secure way) is to request the user to enter a password to access your streamlit app:
access_token = st.text_input(‘Please enter your access token:’)
if access_token != ‘your_secret_token’:
st.write(‘Sorry, your token is invalid. Please try again or contact the administrator.’)
st.stop()
Depending on the access token/password you could then show the different Excel file/tab (pandas dataframe)
I hope this helps! Happy Coding! 😃
@@CodingIsFun Nice eventually will need something more secure but thank you so much for replying, video was sensational and now your comment is the cherry on top, super appreciate it!!!!
???
Hello
Can streamlit work with Jupyter notebook?
Thanks for watching. Have a look here: discuss.streamlit.io/t/new-library-streamlit-jupyter-a-new-way-to-develop-streamlit-apps-in-jupyter-notebooks/35679
Happy Coding! Cheers, Sven ✌️
Great tutorial, thank you very much. ValueError: The first argument to the plotly.graph_objs.layout.Template constructor must be a dict or an instance of :class:`plotly.graph_objs.layout.Template` How can solve the problem.
Thanks for watching. Please clone the GitHub repo and try again. Thanks! Cheers, Sven ✌️
not sure where I can get the excel file ? can you pls help
Thanks for watching. Links are in the description: github.com/Sven-Bo/excel-webapp-streamlit
i have an excel file for square feet calculations how to turn it to a website please anyone help
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Toll, danke!
Sehr gerne! Danke fürs Anschauen!
Thank you for this awesome tutorial.
Can I use google sheets instead excel?
*Hi Bayu Anggoro. I am glad you liked the video. Thanks for watching and for the comment!*
Yes, you can either use the Google Sheets API or simply make your Google Spreadsheet public. For doing this, you just have to go to File->Publish to the web.
Then choose “Microsoft Excel (.xlsx)” from the dropdown menu and copy the URL.
Once done, you could use df = pd.read_excel(YOUR_URL)
module not found error on plotly express
Please run 'pip install plotly-express'
Sir, I'm trying to expand/resize the last column of the table but it won't, compare to other it can. Is there a way or solution ? :D Thank you
Thanks for watching. Sorry, I am not sure what you are trying to achieve.
Which ide are you using?
Thank you for watching the video. I am using 'atom' (atom.io/)
Can you teach how did you host?
Here you are: ruclips.net/video/4SO3CUWPYf0/видео.htmlsi=3jKXsu_iybs79KWA
Vielen Dank für dieses Video. Gibt es eine Möglichkeit, diese Web App auch Kollegen zur Verfügung zu stellen, die weder Python, noch die dazugehörigen Packages installiert haben? Praktisch im Intranet des Unternehmens? Danke dir vorab!
Thank you for this video. Is there a way to make this web app available to colleagues who have neither Python nor the associated packages installed? Practically on the company's intranet? Thank you in advance!
Hi Florian,
*Thanks for watching the video & your question.*
It depends also on the firewall settings within your company, but the web app would be available under the 'Network Url' [see screenshot]:
👉 prnt.sc/10mq6tb
If you want to export the web app to a standalone HTML file, this is currently not possible (see also the open issue on Github):
👉 github.com/streamlit/streamlit/issues/611
I am not sure about your use-case, but if you 'only' want to export visuals in a 'Dashboard' format (without the slider/multi-select), you could use other libraries, like 'Plotly' or 'Pyechart'. Those can be exported to HTML as well. Please see the example below:
👉 gallery.pyecharts.org/#/Tab/tab_base
Hope this helps.
Cheers,
Sven
@@CodingIsFun
Many thanks for your response. I would like to make certain tables available interactively so that employees in the company can compile the data themselves with the help of sliders, etc.
For example, we have several production lines with daily outputs and disruptions. Here you could filter the data depending on the production line. I have already created such a dashboard with streamlit, but it only works on my computer with Python.
@@selimalili Another option could be to install Python on a shared drive/folder within your company (where everybody can have access) & create a .bat file (example below):
set root=Z:\SharedFolder\Miniconda3\
call %root%\Scripts\activate.bat
call streamlit run "path\to\file\app.py"
The end-user then only needs to run the Batch File.
Please note, that I have not tested out the solution myself, but theoretically this should work 🙏
Hey, great content! I wanted to ask you, if its possible to update the filter selection after choosing filters from another filter selection.
For example if i have two multiselection fields and i choose some filters at one, that the other selection gets smaller. Thanks in advance if you can help :)
Thanks for watching the video. I am not quite sure if I understand you correctly, but perhaps the following might help you:
import streamlit as st
first_slider = st.slider('first slider', min_value=1, max_value=10, value=5, step=1)
second_slider = st.slider('seconds slider', min_value=1, max_value=20, value=15-first_slider, step=1)
@@CodingIsFun Thanks for reply! ye thats the same logic i was talking about :) just need to try that for multiselecting now, thanks!
How can I host this on SharePoint ? Can I convert to HTML, CSS and JS files ?
Thank you for watching the video & your questions. As far as I know, currently there is no option/solution to host streamlit on SharePoint or to convert it to standalone files (HTML, CSS, JS) 😕
@@CodingIsFun
Thank you for the quick response.
Which other which other python packages I could use to get output as HTML, CSS , JS. So that I just copy all the files on to SP and it functions as a SP site
@@PavanKumarNarbolikar Hi Pavan Kumar Narbolikar! Sorry, but I'm not really an expert on web development.
Do you build applications like this for people?
Thanks for watching the video. I have received your mail :)
Is it possible to share this report with others? If yes, then how?
Thanks for watching. As mentioned in the description:
Deploy your Streamlit Application to Heroku for free:
👉 ruclips.net/video/nJHrSvYxzjE/видео.html
Thanks Bruu
You're very welcome! Thank you for watching and for the comment!
How secure is this? Can it be exploited when i publish a page like this?
Thanks for watching the video. Regarding your question, kindly check out the following site:
docs.streamlit.io/streamlit-cloud/trust-and-security
How can i add my python script to Html
Here you are: ruclips.net/video/xE95tIzCuKM/видео.html
Do you have full courses in udemy or any place ?
Thanks for watching. So far, I do not have any paid courses.
Can I deploy streamlit with django?
Thanks for watching the video. Django is another high-level Python Web framework. Depending on your project, you could also replicate this project with Django. Yet, Streamlit might be more straightforward to develop & deploy (Machine Learning)Web Apps quickly.
Is this STATIC or Dynamic website???
Thanks for watching. It is the website you see in the video - a dynamic one.
Hi, is there a written tutorial?
Hi, no
Thank you so much, but I have a problem if you can explain it to me when I create the file app.py won't change to python. Thanks in advance. I am a total beginner at python zero levels. :)
*Thanks for watching the video & your question.*
Could you please try to enable the view of 'filename extensions' and try to rename your file again?
👉 vtcri.kayako.com/article/296-view-file-extensions-windows-10
Hope this helps 🙏
Cheers,
Sven
@@CodingIsFun I followed all of the steps again but still didn't change the file into a python file as you have in the video, I will be so glad if you can help me with that. I really need to learn that. Thanks, millions. I would appreciate it if we can share my screen with you to see the things, I am sure you can solve the problem within a minute.
@@findthetruth3021 Alternatively, you could also open up 'Notepad', go to 'File' > 'Save As...' and then type 'app.py'
Kindly have a look at the screenshot:
prnt.sc/10lsr3p
@@CodingIsFun thanks a lot, and I really made you tired with that. But, I am so desperate because I even uninstalled the conda and reinstalled again and followed all of the steps still the same issue 😌☹️ I am sure if we have Skype call and give you access to my desktop will solve the issue in minutes. Thanks in advance.
Is that your real voice or did you clone Eckhart Tolle with ai?
I cloned Eckhart Tolle with the help of AI
Been trying for an hour to install Streamlit. Tried so much. Pip just can't do it. I updated to the latest version. Got some error message like "You need Rust and Cargo" so I went to the Rust website and installed it. Then it couldn't find cargo so I went into windows environment variables and manually added cargo then. Again I tried. Still won't work...
Thanks for watching the video. Have you tried to install streamlit into a separate virtual environment (ruclips.net/video/N5vscPTWKOk/видео.html)?
@@CodingIsFun thanks, but I finished the hackathon I needed this for. Ended up using JavaScript. Hackathon was a great success tho! Thank you
Sir im request chart vba html
Thanks for watching the video and your video request. Can you perhaps elaborate on what it is you're actually trying to achieve? Please provide some additional info. Thanks!
@@CodingIsFun in the vba excel toolbox section, there is a web browser, in the web browser a chart can be made, but with the condition that the chart is in HTML program language, maybe I can continue to email along with pictures, so that it is clearer and understandable
@@mfeproject615 Thanks for the further input. Most likely, I will not create a separate video about VBA charts. Here is already a comprehensive tutorial on VBA charts: ruclips.net/video/fWyw4DJCSsE/видео.html
you only can use this in local host, so it isn't pretty
Nope, you can also deploy it
wow...
Thank you for watching the video :)
🤯.
My head hurts now
Get well soon!
I get error: FileNotFoundError: [Errno 2] No such file or directory: 'Survey.xlsx'
Thanks for watching. The excel file name is: Survey_Results.xlsx
Kindly change it and try again.
not sure where I can get the excel file ? can you pls help
Thanks for watching. Links are in the description: github.com/Sven-Bo/excel-webapp-streamlit