Combine Excel Files with Python: Beginner Friendly - Excel automation with pandas and python

Published: 24 August 2022
on channel: FinTech Analyst Academy
11
0

In this video we use python and pandas to read multiple excel files and combined the outputs to a single pandas data frame.

In the video, we will use simple python loops and have an introduction to python lists in a practice setting. We will also use some basic features of pandas library including use of the powerful Concat function.

Reading multiple excel files to pandas and python using python loops, python lists, and pandas data slicing as well as pandas Concat function:

The video essentially walk through a simple application which can be used to collect data from multiple sources and combined using the structures and codes explained.

Link to the previous video focusing on reading data from a single file is: https://studio.youtube.com/video/d5gy...


On this page of the site you can watch the video online Combine Excel Files with Python: Beginner Friendly - Excel automation with pandas and python with a duration of hours minute second in good quality, which was uploaded by the user FinTech Analyst Academy 24 August 2022, share the link with friends and acquaintances, this video has already been watched 11 times on youtube and it was liked by 0 viewers. Enjoy your viewing!