Python Forum
Use Python Packages to Increment a Column(not a row)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Use Python Packages to Increment a Column(not a row)
#1
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Auto row increment code codesearcher 2 1,984 Sep-04-2020, 09:42 AM
Last Post: codesearcher
  Python Packages for Excel ImranBhatti 8 132,107 Oct-03-2018, 04:58 AM
Last Post: pcsailor
  Security verification of Python "pip" packages? futurity 7 5,383 Aug-23-2017, 04:02 PM
Last Post: Larz60+
  How to use/install different versions of Python packages (Scipy) on the same system? gzb001 3 6,099 Nov-07-2016, 12:56 AM
Last Post: Blue Dog

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020