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

Publicado el: 20 febrero 2019
en el canal de: Derrick Sherrill

84,466

1.4k

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

Kite helps fund the channel, thanks for checking them out and supporting me --
⭐ Kite is a free AI-powered coding assistant that will help you code faster and smarter. The Kite plugin integrates with all the top editors and IDEs to give you smart completions and documentation while you’re typing. https://www.kite.com/get-kite/?utm_me...

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/D...

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...
-Numpy
https://www.numpy.org/
-xlrd
https://xlrd.readthedocs.io/en/latest/
-TensorFlow
https://www.tensorflow.org/api_docs/p...
-Matplotlib
https://matplotlib.org/
-Django Framework
https://www.djangoproject.com/
-Beautiful Soup
https://www.crummy.com/software/Beaut...
(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!

En esta página del sitio puede ver el video en línea Combining Excel Sheets with Python - Five Minute Python Automation Scripts Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario Derrick Sherrill 20 febrero 2019, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 84,466 veces y le gustó 1.4 mil a los espectadores. Disfruta viendo!

363,581

4.8K