Invalid Keyword when working with CSV on Python

Question

def c():
    csvfile = 'example.csv'
    with open(csvfile, 'r') as fin, open('new_'+csvfile, 'w') as fout:
        reader = csv.reader(fin, newline='', lineterminator='\n')
        writer = csv.writer(fout, newline='', lineterminator='\n')
        if you_have_headers:
            writer.writerow(next(reader) + [new_heading])
        for row, val in zip(reader, data):
            writer.writerow(row + [data])

Above is some code that I have used to create a column for a CSV file. I keep getting the following error

TypeError: 'newline' is an invalid keyword argument for this function

How do I fix this? Thanks in advance.

take a look at the documentation the only references to newline='' is when opening the file. — Tadhg McDonald-Jensen
– Tadhg McDonald-Jensen, Commented May 11, 2016 at 14:52
so you would want the newline='' in the with open(csvfile,'r', newline='') .. — Tadhg McDonald-Jensen
– Tadhg McDonald-Jensen, Commented May 11, 2016 at 14:53

Pep_8_Guardiola · Accepted Answer · 2016-05-11 14:51:56Z

6

The newline argument should be included within the open function, not the csv reader and writer functions.

See here for examples.

answered May 11, 2016 at 14:51

Pep_8_Guardiola

5,3021 gold badge26 silver badges35 bronze badges

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

3 Comments

Nasif Rob Over a year ago

Firstly thanks for the help. It worked fine. I have one extra question. I essentially have 2 more copies of this that add 2 extra columns excluding this one. When I run the code, they later ones override the previous one. They all create a column in the same place. How do I make one create a column after the other (so they create a column on the next one over)?

Tadhg McDonald-Jensen Over a year ago

@NasifRob what exactly are you trying to do?

Pep_8_Guardiola Over a year ago

You're welcome @NasifRob. Please create a new question for the other problems though, it isn't very easy to help out using the comment section only

Raju Saladi · Accepted Answer · 2020-09-07 10:23:06Z

1

To avoid this error , open the file in 'wb' mode instead of 'w' mode. This will eliminate the need for newline = "", Look below the the corrected code.

csvfile = 'example.csv'
with open(csvfile, 'r') as fin, open('new_'+csvfile, 'wb') as fout:
    reader = csv.reader(fin, newline='', lineterminator='\n')
    writer = csv.writer(fout, lineterminator='\n')
    if you_have_headers:
        writer.writerow(next(reader) + [new_heading])
    for row, val in zip(reader, data):
        writer.writerow(row + [data])

edited Sep 7, 2020 at 10:23

answered Nov 29, 2017 at 11:27

Raju Saladi

2113 silver badges8 bronze badges

Collectives™ on Stack Overflow

Invalid Keyword when working with CSV on Python

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related