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
#10
The only possible reason for duplicate columns that I can think of is that you already have empty 'Purchase Order Number' and 'Purchases Transaction ID Number' columns in your input file. Because you said you want to ADD my understanding was you need to add the column headers to one already in input file. That is lines#3-#4. If this is the case, try:
with open(in_file, 'r') as in_f, open(out_file, 'w', newline='') as out_f:
    rdr =  csv.DictReader(in_f)
    wrtr = csv.DictWriter(out_f, fieldnames=rdr.fieldnames)
    wrtr.writeheader()
    for row_id, row in enumerate(rdr, start=1):
        row['Purchase Order Number'] = row_id + 60000
        row['Purchases Transaction ID Number'] = row_id + 700000
        wrtr.writerow(row)
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 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 811 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