Jun-10-2019, 09:57 AM
I have the below data that l would like to process, can anyone help with the python code for it?
I just want to increment every column with 100.
Preferably with the openpyxl or pandas packages.
For instance in the first columns of each I have the data sets below already written
Worksheet1
200
500
600
800
Worksheet2
1000
1200
1600
1800
Worksheet3
5000
4000
5600
4500
After Running Code ...
Worksheet1
200 300 400
500 600 700
600 700 800
800 900 1000
Worksheet2
1000 1100 1200
1200 1300 1400
1600 1700 1800
1800 1900 2000
Worksheet3
5000 5100 5200
4000 4100 4200
5600 5700 5800
4500 4600 4700
I just want to increment every column with 100.
Preferably with the openpyxl or pandas packages.
For instance in the first columns of each I have the data sets below already written
Worksheet1
200
500
600
800
Worksheet2
1000
1200
1600
1800
Worksheet3
5000
4000
5600
4500
After Running Code ...
Worksheet1
200 300 400
500 600 700
600 700 800
800 900 1000
Worksheet2
1000 1100 1200
1200 1300 1400
1600 1700 1800
1800 1900 2000
Worksheet3
5000 5100 5200
4000 4100 4200
5600 5700 5800
4500 4600 4700