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-into-a-web-app-with-python-fast-easy-streamlit-tutorial 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 𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘 ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ 🔗 LinkedIn: https://www.linkedin.com/in/sven-bosau/ 📬 Contact: https://pythonandvba.com/contact ☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲? If you want to support this channel, you can buy me a coffee here: ▶ https://pythonandvba.com/coffee-donation