Combine Excel Files with Python: Beginner Friendly - Excel automation with pandas and python
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...