Python CSV script

Question

I'm trying to add a new column by copying col#3 and then append @hotmail to the new column

Here is the script, only problem is that it will not finish processing the input file, it only show 61409 rows in the output file, whereas in the input file there are 61438 rows.
Also, there is an error message (the input file does not have empty line at the end):
email = row[3] IndexError: list index out of range

inFile = 'c:\\Python27\\scripts\\intake.csv'
outFile = 'c:\\Python27\\scripts\\final.csv'

with open(inFile, 'rb') as fp_in1, open(outFile, 'wb') as fp_out1:
    writer = csv.writer(fp_out1, delimiter=",")
    reader = csv.reader(fp_in1, delimiter=",")
    for col in reader:
        del col[6:]
        writer.writerow(col)
    headers = next(reader)
    writer.writerow(headers + ['email2'])
    for row in reader:
        if len(row) > 3:
            email = email.split('@', 1)[0] + '@hotmail.com'
        writer.writerow(row + [email])

Your error message seems to refer to a line which isn't in your code. If you're getting an IndexError when you access row[3], then simply add print row before the access and see what line is giving you trouble. For the code you've posted, after you've finished the for col in reader: loop, you're at the end of the file, so I don't see how next(reader) or for row in reader: would work/do anything. — DSM
– DSM, Commented Oct 11, 2013 at 19:30
I agree with @DSM, you should post your actual code, or something that behaves the same way. — Markku K.
– Markku K., Commented Oct 11, 2013 at 19:39
Are you using the code from your earlier question: stackoverflow.com/questions/19324968/python-csv-copy-column ? If so, maybe you should have added to that question rather than start a new one. — Spaceghost
– Spaceghost, Commented Oct 11, 2013 at 19:59

Spaceghost · Accepted Answer · 2013-10-11 20:02:45Z

0

It looks like you edited the code you received in your earlier answer.

Change

email = email.split('@', 1)[0] + '@hotmail.com'

to

email = row[3].split('@', 1)[0] + '@hotmail.com'

answered Oct 11, 2013 at 20:02

Spaceghost

7,0433 gold badges31 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Python CSV script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related