Turn Your Excel File Into A Web App With Python (fast & easy) | Streamlit Tutorial
Вставка
- Опубліковано 21 лип 2024
- 👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this tutorial, I am going to show you how to convert Excel Files into a Web Application by using the Python Library Streamlit. The beauty of Streamlit is that you can create web applications directly in Python, without needing to know HTML, CSS, or JavaScript. The Web App is fully interactive and will be updated, whenever you make changes in the Excel file.
🌍 𝗟𝗜𝗡𝗞𝗦:
► Live Demo: surveyresults.pythonandvba.com
► GitHub: github.com/Sven-Bo/excel-weba...
► Blog: pythonandvba.com/blog/turn-yo...
Deploy your Streamlit Application to Heroku for free:
👉 • Deploy Your Streamlit ...
Streamlit Documentation & App Gallery:
docs.streamlit.io/en/stable/
streamlit.io/gallery
✅ Chapters:
0:00 Introduction
1:20 [Setup] Python Libraries
2:12 ‘Hello World’ in Streamlit
3:41 Insert Dataframe in Streamlit
5:13 Insert Pie Chart in Streamlit
6:13 Insert Images in Streamlit
7:25 [Excursion] Filter & Group Dataframe in Pandas
11:00 Insert Slider & Multiselect in Streamlit
12:08 Filter Dataframe based on user selection
13:06 Group & Plot Dataframe after user selection
14:01 Use columns in Streamlit
14:49 Final Word
15:44 Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation
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! :)
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
🤯 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 😃
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 👍😃
Amazing... great explanation and exactly what I'm looking for.... thank you!!
Glad you liked it. Thanks for watching and your comment! 👍
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! :)
very lovely, I will run through this tutorial fairly soon, thank you
*Thank you.* I am glad you enjoyed the video 😃
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:
ua-cam.com/video/Sb0A9i6d320/v-deo.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! 😃
Your tutorials are very helpful. Thankyou
*I am glad to hear you are enjoying them, thanks for watching and for the comment!*
🤷♂ *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: ua-cam.com/video/nJHrSvYxzjE/v-deo.html
🌟 Deploy your Streamlit Application to *Render* for free: ua-cam.com/video/4SO3CUWPYf0/v-deo.html
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! Great video and instruction
Glad to hear you liked it! Thank you for commenting and watching. Cheers, Sven ✌️
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! 👍
Thanks, what a great tutorial.
*Thank you very much* 😃
This is a great tutorial! thank you!!
Thanks for watching the video and your comment! :)
Very cool tutorial. Thank you very much.
*I am glad you liked the video, thanks for watching and for all your support!*
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!*
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 teacher, Thank you so much for this video, i from Cuba
Glad you liked it. Thanks for watching. Greetings to Cuba! 👋
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.
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.*
Hi, Paul ,very helpful , Thanks
Glad to hear that!
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 👍
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.
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!
Bro,you are a King. Thank you for your clear explanations. 👍👍
You're very welcome! Thank you for watching and for the comment!
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!
Your Tutorial are very helpful
*I am glad you liked the video, thanks for watching and for the comment!*
Awesome explanation 🎉
Thank you! 🤩
Thanks for a making a very good learning video on python.
My pleasure! Appreciate you taking the time to watch and leave a comment.
Always very interesting
Hi Gerhard,
*Thank you.* I am glad you enjoyed the video 😃
Excelent tutorial!
Glad you liked it. Thanks for watching.
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.
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':
ua-cam.com/video/nsClitREZqg/v-deo.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:
ua-cam.com/video/pms52_-cmc8/v-deo.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 ua-cam.com/video/Sb0A9i6d320/v-deo.html
but i wanted to know if you can help in re-coding of vba to python.🙂
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!
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.
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! 🚀
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!!
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!
Awesome explanation
Glad you liked it. Thanks for watching and taking the time to leave a comment!
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!
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)
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? ua-cam.com/video/nJHrSvYxzjE/v-deo.html
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!
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
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!
very nice video , thanks.
Thank you very much! 👍
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! :)
Thanks Bruu
You're very welcome! Thank you for watching and for the comment!
Really awesome.
Thank you!
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: ua-cam.com/video/xE95tIzCuKM/v-deo.htmlsi=BBEVDvdYD_qUGHAn
Happy Coding! Cheers, Sven ✌️
Great!
Thanks
You're very welcome! Thank you for watching and for the comment!
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!!!!
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!
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
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)
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!
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!
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.
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 ✌️
Toll, danke!
Sehr gerne! Danke fürs Anschauen!
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!
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 🙌🙌🙌🤝🤝
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.
@@fselim2676 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 🙏
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.
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
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 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 ✌️
???
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 ✌️
Do you build applications like this for people?
Thanks for watching the video. I have received your mail :)
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
module not found error on plotly express
Please run 'pip install plotly-express'
Which ide are you using?
Thank you for watching the video. I am using 'atom' (atom.io/)
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'.
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
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.
Thanks
Thanks a ton for the support! 🙏
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.
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:
👉 ua-cam.com/video/nJHrSvYxzjE/v-deo.html
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
@@wbw922 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!
Do you have full courses in udemy or any place ?
Thanks for watching. So far, I do not have any paid courses.
Can you teach how did you host?
Here you are: ua-cam.com/video/4SO3CUWPYf0/v-deo.htmlsi=3jKXsu_iybs79KWA
How can i add my python script to Html
Here you are: ua-cam.com/video/xE95tIzCuKM/v-deo.html
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: ua-cam.com/video/ZDffoP6gjxc/v-deo.html
I hope it helps! Happy Coding!
@@CodingIsFun greatly appreciate your help !!!!! You rock
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.
wow...
Thank you for watching the video :)
Is that your real voice or did you clone Eckhart Tolle with ai?
I cloned Eckhart Tolle with the help of AI
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: ua-cam.com/video/fWyw4DJCSsE/v-deo.html
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 (ua-cam.com/video/N5vscPTWKOk/v-deo.html)?
@@CodingIsFun thanks, but I finished the hackathon I needed this for. Ended up using JavaScript. Hackathon was a great success tho! Thank you
🤯.
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