Combining Excel Sheets with Python - Five Minute Python Automation Scripts Tutorial

Takes several workbooks' fields and rewrites a new excel file with only the data you want. Combine and verify data across unlimited excel workbooks with one python script. Five Minute Python Scripts Full Code Along Tutorial Requirements: Python Pandas Automate your excel workflows using Python and Pandas to condense spreadsheets. ***************************************************************** Code from this tutorial and all my others can be found on my GitHub: https://github.com/Derrick-Sherrill/DerrickSherrill.com Check out my website: https://www.derricksherrill.com/ If you liked the video - please hit the like button. It means more than you know. Thanks for watching!! Useful Links ----------------------------------------------------------------------------------------------------------------- Python Download: https://www.python.org/downloads/ (Remember Python 3 is the future!) I use Atom Text Editor for all my tutorials Atom Text Editor: https://atom.io/ Packages I often use in Python tutorials: -Pandas https://pandas.pydata.org/pandas-docs/stable/ -Numpy https://www.numpy.org/ -xlrd https://xlrd.readthedocs.io/en/latest/ -TensorFlow https://www.tensorflow.org/api_docs/python -Matplotlib https://matplotlib.org/ -Django Framework https://www.djangoproject.com/ -Beautiful Soup https://www.crummy.com/software/BeautifulSoup/ (Install through Terminal $pip3 install ....) Other Useful Services sometimes featured: -Amazon Web Services (AWS) https://aws.amazon.com/ -Microsoft Azure https://azure.microsoft.com/en-us/ -Google Cloud https://cloud.google.com/ -Juypter Notebooks https://jupyter.org/ Always looking for suggestions on what video to make next -- leave me a comment with your project! Happy Coding!