I am fairly new to python and need help with this project for school its essentially iterating through a excel table finding the absolute value and percent change between 2 different years for areas the years are 2018 and 2021 and I have to find the absolute change and percent change for regions in countries.

I know I’ll need to loop through but the current methods I have tried such as creating a dataframe and subtracting them from each other hasn’t worked so far so I am hoping if anyone knows the best way to go about it would be really appreciated.

I tried so subtract the excel documents from each using years but it didnt work and kept erroring, I am not sure how to best approach this problem I know I would need to loop through the different areas in order to get the calculations but I am not sure how to best to go about that.

Image of my excel table as you can see there is different years that I need to fine the change between but for each different region of the countries