Merging Excel Files in the Same Directory using pandas.

Merging CSV Files with Hex Values Using Pandas and Glob Module: A Solution to UnicodeDecodeError