Python: Write list to individual columns in each row

Question

I'm writing data to a CSV but the current output is as follows: (the top row is the headers)

 A    VC_s                                       VC_i    VT_s
 1    (['Not Reported'],['reported'],['click'])   
 2    (['Not Reported'],['reported'],['click'])

The desired output is as follows:

 A    VC_s            VC_i         VT_s
 1    Not Reported    reported     click
 2    Not Reported    reported     click

The code I've got so far is:

ifile = csv.reader(open("input.csv",'rb'))
shutil.copy("input.csv","temp")
tempfile = csv.reader(open("temp","rb"))
ofile = csv.writer(open("RESULTS.csv","ab"))

for row in ifile:
    #do some table scraping stuff here
    VC_s = str(cells[1].find(text=True))
    VC_i = str(cells[2].find(text=True))
    VT_s = str(cells[4].find(text=True))

    entry = ([VC_s], [VC_i], [VT_s])
    rowAdd = tempfile.next()
    ofile.writerow(rowAdd + [entry])

What am i doing wrong and how can I fix this? It would seem like an easy fix but I am stumped.

Ignacio Vazquez-Abrams · Accepted Answer · 2011-02-11 05:15:53Z

1

entry = [VC_s, VC_i, VT_s]
rowAdd = tempfile.next()
ofile.writerow(rowAdd + entry)

answered Feb 11, 2011 at 5:15

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gabe · Accepted Answer · 2011-02-11 05:15:18Z

0

You just want entry = [VC_s, VC_i, VT_s]

answered Feb 11, 2011 at 5:15

Gabe

87.1k13 gold badges144 silver badges238 bronze badges

Collectives™ on Stack Overflow

Python: Write list to individual columns in each row

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related