Up next

Autoplay

Turn Your Excel File Into A Web App With Python (fast & easy) | Streamlit Tutorial

0 Views โ€ข 10/30/24
Share
Embed
121gamers
121gamers
14 Subscribers
14

๐Ÿ‘‰ 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

Show more
0 Comments sort Sort By
Facebook Comments

Up next

Autoplay