Streamlit (Web Application in Python) - How to build an app for combining the contents of multiple spreadsheets | Streamlit #23

Over 15 years ago, the first Python script that I wrote was to combine the contents of multiple Microsoft Excel spreadsheet files. In this video, I will show you how to do this in Python where we will be combining the contents of several Microsoft Excel spreadsheet files (XLSX) into a single XLSX file. We'll be doing this using the following Python libraries: openpyxl, pandas, zipfile, os, base64 and streamlit. - Demo https://share.streamlit.io/dataprofessor/excel-file-merge-app/main/app.py - GitHub https://github.com/dataprofessor/excel-file-merge-app - ZIP file of XLSX files https://github.com/dataprofessor/excel-file-merge-app/raw/main/nba_data.zip 🌟 Subscribe to this YouTube channel https://www.youtube.com/dataprofessor?sub_confirmation=1 🌟 Join the Newsletter of Data Professor http://sendfox.com/dataprofessor 🌟 Buy me a coffee https://www.buymeacoffee.com/dataprofessor 🌟 Download Kite for FREE https://www.kite.com/get-kite/?utm_medium=referral&utm_source=youtube&utm_campaign=dataprofessor&utm_content=description-only ⭕ Playlist: Check out our other videos in the following playlists. ✅ Data Science 101: https://bit.ly/dataprofessor-ds101 ✅ Data Science YouTuber Podcast: https://bit.ly/datascience-youtuber-podcast ✅ Data Science Virtual Internship: https://bit.ly/dataprofessor-internship ✅ Bioinformatics: http://bit.ly/dataprofessor-bioinformatics ✅ Data Science Toolbox: https://bit.ly/dataprofessor-datasciencetoolbox ✅ Streamlit (Web App in Python): https://bit.ly/dataprofessor-streamlit ✅ Shiny (Web App in R): https://bit.ly/dataprofessor-shiny ✅ Google Colab Tips and Tricks: https://bit.ly/dataprofessor-google-colab ✅ Pandas Tips and Tricks: https://bit.ly/dataprofessor-pandas ✅ Python Data Science Project: https://bit.ly/dataprofessor-python-ds ✅ R Data Science Project: https://bit.ly/dataprofessor-r-ds ✅ Weka (No Code Machine Learning): http://bit.ly/dp-weka ⭕ Recommended Books: 🌟https://kit.co/dataprofessor ✅ Hands-On Machine Learning with Scikit-Learn : https://amzn.to/3hTKuTt ✅ Data Science from Scratch : https://amzn.to/3fO0JiZ ✅ Python Data Science Handbook : https://amzn.to/37Tvf8n ✅ R for Data Science : https://amzn.to/2YCPcgW ✅ Artificial Intelligence: The Insights You Need from Harvard Business Review: https://amzn.to/33jTdcv ✅ AI Superpowers: China, Silicon Valley, and the New World Order: https://amzn.to/3nghGrd ⭕ Stock photos, graphics and videos used on this channel: ✅ https://1.envato.market/c/2346717/628379/4662 ⭕ Follow us: ✅ Medium: http://medium.dataprofessor.org/ ✅ FaceBook: http://facebook.com/dataprofessor/ ✅ Website: http://dataprofessor.org/ (Under construction) ✅ Twitter: https://twitter.com/thedataprof/ ✅ Instagram: https://www.instagram.com/data.professor/ ✅ LinkedIn: https://www.linkedin.com/in/chanin-nantasenamat/ ✅ GitHub 1: https://github.com/dataprofessor/ ✅ GitHub 2: https://github.com/chaninlab/ ⭕ Disclaimer: Recommended books and tools are affiliate links that gives me a portion of sales at no cost to you, which will contribute to the improvement of this channel's contents. #streamlit #spreadsheets #python #datascience #dataanalyst #datascientist