Appending Two CSV Files using built in csv module

Question

I've two csv files to append & create a new csv file with the result. If I use 'binary' like 'rb' or 'wb' to read the write then it's throwing

_csv.Error: iterator should return strings, not bytes (did you open the file in text mode?)

If I use only 'r' & 'w' to read & write the following code giving me error like

IndexError: list index out of range

with open('file1.csv','rt') as f, open('final.csv','wt')as out:
        first=csv.reader(f)
        final = csv.writer(out)
        for row in first:
                result=row[1]
                final.writerow(result)

with open('file21.csv','rt') as s, open('final.csv','wt')as out:
        second =  csv.reader(s)
        final = csv.writer(out)
        for row in second:
                result=row[1]
                final.writerow(result)

Traceback (most recent call last): File "fileAppends.py", line 18, in <module> result=row[0] IndexError: list index out of range @zsquare — Pritam Das
– Pritam Das, Commented Feb 25, 2016 at 9:16
Join two csv files that's it. But both csv file has same header so I can copy headers from both. @Gijs — Pritam Das
– Pritam Das, Commented Feb 25, 2016 at 9:31

Gijs · Accepted Answer · 2016-02-25 09:02:16Z

0

You have a row with no two values. Try row[0], and check if you need to specify a delimiter.

answered Feb 25, 2016 at 9:02

Gijs

11k5 gold badges29 silver badges42 bronze badges

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

3 Comments

Pritam Das Over a year ago

Traceback (most recent call last): File "fileAppends.py", line 18, in <module> result=row[0] IndexError: list index out of range sorry now showing this

Gijs Over a year ago

You should show a part of your files, otherwise it's going to be hard to find your problem.

Pritam Das Over a year ago

Two csv files with the same header/titles on the columns but different in values. Okay um trying to provide examples. @Gijs

Collectives™ on Stack Overflow

Appending Two CSV Files using built in csv module

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related