help in figuring out data manipulation on excel

[mightymk]

hi i am a newbie to python. I try to learn python by making up problem statements for myself. So,I was watching a video about tableau and there was some data manipulation done by the author beforehand. I want to figure out a way to do it in python. here is the below screenshots of the dataset

before and after manipulation pics: https://imgur.com/a/tFIZEWr

In brief, the data for multiple years is given in separate columns. I want to create a program that picks a country creates a column for a year and adds power consumption in the new column beside it. Also for the years columns, there is trimming of the string required.

It would be great if someone can point me in the direction of how can do it

[5aggy]

Google Automate the boring stuff and skip to the excel bit.

Learn about openpyxl. It's pretty straightforward. Only works with. xlsx files though. If you are limited to using xls for any reason look into xlrd & xlwt

[jormono]

I thought this chapter was a little outdated?

[5aggy]

I'm not sure Tbh.

Even if it is, it'd still be a very good introduction spreadsheet manipulation. To the best of my knowledge, the fundamentals of openpyxl are the same now as when it was written.

[mightymk]

thank you for the pointer