This is part 2 of data consolidation in Python. If you want to start reading from part 1 please click here.
Are your dataset rows spread across different MS-Excel sheets and you want to consolidate them to a single dataframe?
A common task for a data analyst is to merge data from different Excel sheets into a single dataframe.
This repository teaches how to use pandas for data consolidation in Python.
Thanks to Ted Petrou for the tricks.