Consolidating Multiple workbook data in Python using Pandas.

In this video I have told about how we can consolidate the multiple workbook data in python using pandas. This video will be very helpful for those people who all are working in data analytics field. If you want me to make video on any topic which you want please let me know in the description will certainly make it or you may ask any question on [email protected] Question : We have Zone wise multiple workbook and in each workbook we have multiple worksheets where headers of the data are not in sequence hence we need to consolidate each worksheet data from each workbook using python & After consolidating the data export it into excel workbook & save it in any folder but there is we have one condition After consolidating the data we need to create one column where we need to bifurcate the data by workbook name so that we can analyze the zone wise data. Required Library for this task : 1 Import pandas - For working with excel workbook. 2 Import glob - For working with file & folder. 3 Import os- For working with to extract the workbook name