Turn Your Excel File Into A Web App With Python (fast & easy) | Streamlit Tutorial
๐ Explore All My Excel Solutions: https://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: https://surveyresults.pythonandvba.com
โบ GitHub: https://github.com/Sven-Bo/excel-webapp-streamlit
โบ Blog: https://pythonandvba.com/blog/....turn-your-excel-file
Deploy your Streamlit Application to Heroku for free:
๐ https://youtu.be/nJHrSvYxzjE
Streamlit Documentation & App Gallery:
https://docs.streamlit.io/en/stable/
https://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 (๐ ๐๐ง๐ผ๐ผ๐น๐๐ฒ๐น๐): https://pythonandvba.com/mytoolbelt
๐ Dashboard Excel Add-In (๐๐ฟ๐ฎ๐ณ๐น๐): https://pythonandvba.com/grafly
๐จ Cartoon Charts Excel Add-In (๐๐๐๐ฒ๐ฃ๐น๐ผ๐๐): https://pythonandvba.com/cuteplots
๐คช Fun Emoji Excel Add-In (๐๐บ๐ผ๐ท๐ถ๐ณ๐): https://pythonandvba.com/emojify
๐ Excel Templates: https://pythonandvba.com/go/excel-templates
๐ My Courses: https://pythonandvba.com/go/courses
๐ Books, Tools, and More: https://pythonandvba.com/resources
๐๐ข๐ก๐ก๐๐๐ง ๐ช๐๐ง๐ ๐ ๐
โโโโโโโโโโโโโโโโโโโโโโโโโโ
๐ LinkedIn: https://www.linkedin.com/in/sven-bosau/
๐ธ Instagram: https://instagram.com/codingisfun_official
๐ป GitHub: https://github.com/Sven-Bo
๐ฌ Discord: https://pythonandvba.com/discord
๐ฌ Contact: https://pythonandvba.com/contact
โ ๐๐๐ ๐บ๐ฒ ๐ฎ ๐ฐ๐ผ๐ณ๐ณ๐ฒ๐ฒ?
If you want to support this channel, you can buy me a coffee here:
โถ https://pythonandvba.com/coffee-donation
SORT BY-
Top Comments
-
Latest comments