Accessing a csv file in python

Question

I keep getting an "invalid keyword" error when i try to read from a csv file in python. Any ideas for a work around for this?

C:\Python27\python.exe C:/Users/User_Name/PycharmProjects/untitled/car.py

Traceback (most recent call last): File 
"C:/Users/User_Name/PycharmProjects/untitled/car.py", line 122, in <module> d = handle_refugee_data.DataTable(csvformat="generic", data_directory="car2014", start_date="2013-12-01") File 
"C:\Users\User_Name\PycharmProjects\untitled\handle_refugee_data.py", line 78, in __init__ with open("%s/%s" % (data_directory, data_layout), newline='') as csvfile: 
TypeError: 'newline' is an invalid keyword argument for this function 

Process finished with exit code 1
========================================================================

It looks like open() doesn't have such keyword: docs.python.org/2/library/functions.html#open But this can be told for sure only after you'll post your code. — wanderlust
– wanderlust, Commented Dec 5, 2016 at 8:36

elethan · Accepted Answer · 2016-12-07 21:03:36Z

2

newline is a valid keyword argument to open() in Python 3, but not in Python 2, which appears to be what you are using.

One solution, if possible, would be to execute the script with Python 3 instead. Alternatively, as pointed out by @dhke in the comments, you could use io.open() instead, which does accept a newline keyword argument.

Of course, you could probably use the csv module instead, depending on your use case (which is not clear from the original question).

edited Dec 7, 2016 at 21:03

answered Dec 7, 2016 at 20:53

elethan

17.1k10 gold badges70 silver badges97 bronze badges

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

1 Comment

elethan Over a year ago

@dhke thanks for the tip! I will add it to the answer.

Collectives™ on Stack Overflow

Accessing a csv file in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related