menu
  • Register
search
Log In

Recent Badges

Popular Question mphil
Popular Question jwilliam
Notable Question maddi86

new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

0 votes
193 views

Probem :

I am getting bellow error

new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

6.9k points

1 Answer

0 votes

Solution :

I had faced the same issue on my MAC, i followed bellow steps to resolve the issue. 

  1. Save the file as CSV (MS-DOS Comma-Separated)

  2. Run the bellow script

    with open(csv_filename, 'rU') as csvfile:
    csvreader = csv.reader(csvfile)
    for row in csvreader:
        print ', '.join(row)

Further Readings:

36.1k points

Related questions

0 votes
1 answer 535 views
535 views
Iterator should return strings, not bytes (did you open the file in text mode?)
Problem : MySample.csv contains the below details : NAME Id No Dept Tommy 1 12 CS Jimmy 2 35 EC Bonny 3 21 IT Franky 4 61 EE And my Python file contains the below code : import csv myifile = open('mysample.csv', "rb") read = csv.reader(myifile) for row in read : ... in for row in read : _csv.Error: iterator should return strings, not bytes (did you open the file in text mode?) How should I fix it?
asked Jan 2 alecxe 7.5k points
0 votes
1 answer 456 views
456 views
_csv.error: iterator should return strings, not bytes (did you open the file in text mode?)
Problem : When I run my Python code I get the following exception: _csv.error: iterator should return strings, not bytes (did you open the file in text mode?)
asked Nov 18, 2019 peterlaw 6.9k points
0 votes
1 answer 97 views
97 views
No such file or directoryerror in file(file, "rt") : cannot open the connection
Problem : I am very new to the R, and after researching my error as below extensively, I am still unable to find the fix for it. I have already checked my working directory, and also made sure that the files are in a correct directory. Error in file(file, "rt") : ... sulfate", 1:10) In addition: Warning message: In file(file, "rt") : cannot open file './specdata001.csv': No such file or directory
asked Jan 4 alecxe 7.5k points
0 votes
1 answer 527 views
527 views
python: can't open file 'manage.py': [errno 2] no such file or directory
I was creating a new project in django. Firstly I installed django in my system but when I run the command : python manage.py runserver It does not work It shows a message : python: can't open file 'manage.py': [Errno 2] No such file or directory ... django and I started a project by running the command : django-admin startproject Utility Why am I seeing this error message, do anyone know?
asked Mar 18 LizzyM 5.7k points
0 votes
1 answer 198 views
198 views
Error tokenizing data. c error: buffer overflow caught - possible malformed input file.
Problem : I wanted to read all the csv files from my folder and after that concatenate them to create a big csv file. The structure of all my files was the same, After concatenating I want to save it and read it again. All this was done by me using Pandas. But I ... --> 3 l = list(csvreader) Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?
asked Dec 3, 2019 alecxe 7.5k points
Dark theme
Muffin by Hélio Chun