Python Forum
Adding Columns to CSV using iterator
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Adding Columns to CSV using iterator
#4
Below is what I tried based on previous advice. Enumerate does not work with a writer (writer is not iterable). I am simply trying to open an existing CSV file and write into columns that are already present (or overwrite values that are in those columns). Below is the code I am using. Thank you!

ofile = open('PSL_Combined_Sorted.csv', 'w', newline='')
writer = csv.writer(ofile)
PO_ID = 1000000
PO_IDTrans_ID = 2000000
for row in enumerate(writer):
    writer.writerow({'Purchase Order Number' : PO_ID, 'Purchases Transaction ID Number' : PO_IDTrans_ID})
    PO_IDTrans_ID = PO_IDTrans_ID + 1
    PO_ID = PO_ID + 1
Reply


Messages In This Thread
Adding Columns to CSV using iterator - by pstarrett - Jan-09-2018, 05:00 AM
RE: Adding Columns to CSV using iterator - by buran - Jan-09-2018, 08:19 AM
RE: Adding Columns to CSV using iterator - by pstarrett - Jan-16-2018, 05:06 AM
RE: Adding Columns to CSV using iterator - by buran - Jan-16-2018, 07:10 AM
RE: Adding Columns to CSV using iterator - by buran - Jan-19-2018, 07:17 AM
RE: Adding Columns to CSV using iterator - by buran - Jan-21-2018, 07:04 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Merging rows and adding columns based on matching index pythonnewbie78 3 809 Dec-24-2023, 11:51 AM
Last Post: Pedroski55
  numpy adding columns rwahdan 4 2,322 Sep-21-2021, 08:25 PM
Last Post: deanhystad
  Tesseract-ocr ->iterator.WordFontAttributes() does not work Maia07 0 3,407 Sep-01-2018, 02:43 PM
Last Post: Maia07

Forum Jump:

User Panel Messages

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