For this exercise, we’ll need to use two Python libraries: os and pandas.
To solve the problem, we’ll need to follow the below work flow: If you are new to Python, this series Integrate Python with Excel offers some tips on how to use Python to supercharge your Excel spreadsheets.
