menu
  • Register

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

0 votes
427 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 ●5 ●3
6,930 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:

●9 ●7 ●4
38,600 points

Related questions

0 votes
1 answer 1.7K views
1.7K 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 995 views
995 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 264 views
264 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 1.2K views
1.2K 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 6.1k points
Dark theme