blocks|key|3012847|text|先尝试在你的windows导入文件上运行dos2unix|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3012848|entityMap^0|K|8|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Try to run <code>dos2unix</code> on your windows imported files first

blocks|key|3012901|text|很高兴看到csv文件本身，但这可能对您有用，试一试，替换：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3012902|file_read+=+csv.reader(self.file)|code-block|syntax|javascript|3012903|通过以下方式：|3012904|file_read+=+csv.reader(self.file,+dialect=csv.excel_tab)|3012905|或者，使用universal+newline+mode打开文件并将其传递给csv.reader，如下所示：|offset|length|style|CODE|3012906|reader+=+csv.reader(open(self.file,+'rU'),+dialect=csv.excel_tab)|3012907|或者，使用splitlines()，如下所示：|3012908|def+read_file(self):
++++with+open(self.file,+'r')+as+f:
++++++++data+=+[row+for+row+in+csv.reader(f.read().splitlines())]
++++return+data|3012909|entityMap^0|0|0|0|0|5|M|11|A|0|0|5|C|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@$M|13|N|14|O|P]|$M|15|N|16|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|18|8|@$M|19|N|1A|O|P]]|9|@]|A|$]]|$1|U|3|V|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|X|$]]

It'll be good to see the csv file itself, but this might work for you, give it a try, replace:

<pre><code>file_read = csv.reader(self.file)
</code></pre>

with:

<pre><code>file_read = csv.reader(self.file, dialect=csv.excel_tab)
</code></pre>

Or, open a file with <code>universal newline mode</code> and pass it to <code>csv.reader</code>, like:

<pre><code>reader = csv.reader(open(self.file, 'rU'), dialect=csv.excel_tab)
</code></pre>

Or, use <code>splitlines()</code>, like this:

<pre><code>def read_file(self):
 with open(self.file, 'r') as f:
 data = [row for row in csv.reader(f.read().splitlines())]
 return data
</code></pre>

blocks|key|2800620|text|我知道这是一个老帖子，但我遇到了同样的问题，没有看到正确的答案，所以我会试一试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2800621|Python错误：|2800622|_csv.Error:+new-line+character+seen+in+unquoted+field|code-block|syntax|javascript|2800623|由尝试读取Macintosh+(pre+OS+X格式)+CSV文件引起。这些是使用CR作为行尾的文本文件。如果使用MS+Office，请确保选择普通CSV格式或CSV+(MS-DOS)。不使用CSV+(Macintosh)作为另存为类型。|offset|length|style|BOLD|2800624|我首选的EOL版本是LF+(Unix/Linux/Apple)，但我不认为MS+Office提供了以这种格式保存的选项。|2800625|entityMap^0|0|0|0|2L|I|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@$K|W|L|X|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

I realize this is an old post, but I ran into the same problem and don't see the correct answer so I will give it a try

Python Error:

<pre><code>_csv.Error: new-line character seen in unquoted field
</code></pre>

Caused by trying to read Macintosh (pre OS X formatted) CSV files. These are text files that use CR for end of line. If using MS Office make sure you select either plain CSV format or CSV (MS-DOS). Do not use CSV (Macintosh) as save-as type. 

My preferred EOL version would be LF (Unix/Linux/Apple), but I don't think MS Office provides the option to save in this format.

blocks|key|3012996|text|对于Mac，请将CSV文件保存为"Windows+Comma+Separated+(.csv)“格式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3012997|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For Mac OS X, save your CSV file in "Windows Comma Separated (.csv)" format.

blocks|key|182868|text|如果这发生在你的mac上的上(就像它对我一样)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|182869|按以下脚本将文件另存为CSV+(MS-DOS+Comma-Separated)|CODE|182870|Run+|unordered-list-item|182871|ordered-list-item|182872|182873|182874|with+open(csv_filename，'rU')+as+csvfile:+csvreader+=+csv.reader(csvfile)用于csvreader中的行:+print+'，'.join(+row+)|182875|entityMap^0|D|B|0|0|13|B|S|0|0|4|0|0|0|0|0|31|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|H]]|D|@]|E|$]]|$1|I|3|J|5|K|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|M|7|14|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|15|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|16|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|R|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|S|$]]

If this happens to you on mac (as it did to me):

<ol>
<li>Save the file as <code>CSV (MS-DOS Comma-Separated)</code></li>
<li>Run the following script

<pre><code>with open(csv_filename, 'rU') as csvfile:
 csvreader = csv.reader(csvfile)
 for row in csvreader:
 print ', '.join(row)
</code></pre></li>
</ol>

blocks|key|2800712|text|这对我在OSX上很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2800713|#+allow+variable+to+opened+as+files
from+io+import+StringIO

#+library+to+map+other+strange+(accented)+characters+back+into+UTF-8
from+unidecode+import+unidecode

#+cleanse+input+file+with+Windows+formating+to+plain+UTF-8+string
with+open(filename,+'rb')+as+fID:
++++uncleansedBytes+=+fID.read()
++++#+decode+the+file+using+the+correct+encoding+scheme
++++#+(probably+this+old+windows+one)+
++++uncleansedText+=+uncleansedBytes.decode('Windows-1252')

++++#+replace+carriage-returns+with+new-lines
++++cleansedText+=+uncleansedText.replace('\r',+'\n')

++++#+map+any+other+non+UTF-8+characters+into+UTF-8
++++asciiText+=+unidecode(cleansedText)

#+read+each+line+of+the+csv+file+and+store+as+an+array+of+dicts,+
#+use+first+line+as+field+names+for+each+dict.+
reader+=+csv.DictReader(StringIO(cleansedText))
for+line_entry+in+reader:
++++#+do+something+with+your+read+data+|code-block|syntax|javascript|2800714|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This worked for me on OSX.

<pre><code># allow variable to opened as files
from io import StringIO

# library to map other strange (accented) characters back into UTF-8
from unidecode import unidecode

# cleanse input file with Windows formating to plain UTF-8 string
with open(filename, 'rb') as fID:
 uncleansedBytes = fID.read()
 # decode the file using the correct encoding scheme
 # (probably this old windows one) 
 uncleansedText = uncleansedBytes.decode('Windows-1252')

 # replace carriage-returns with new-lines
 cleansedText = uncleansedText.replace('\r', '\n')

 # map any other non UTF-8 characters into UTF-8
 asciiText = unidecode(cleansedText)

# read each line of the csv file and store as an array of dicts, 
# use first line as field names for each dict. 
reader = csv.DictReader(StringIO(cleansedText))
for line_entry in reader:
 # do something with your read data 
</code></pre>

blocks|key|2800865|text|这是我所面对的一个错误。我已经在MAC中保存了.csv文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2800866|保存时，将其另存为"Windows逗号分隔值(.csv)“，解决了此问题。|2800867|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This is an error that I faced. I had saved .csv file in MAC OSX.

While saving, save it as "Windows Comma Separated Values (.csv)" which resolved the issue.

blocks|key|185296|text|我知道这个问题已经被回答了很长一段时间，但并没有解决我的问题。由于其他一些复杂问题，我使用DictReader和StringIO来读取csv。我能够更简单地通过显式地替换分隔符来解决问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|185297|with+urllib.request.urlopen(q)+as+response:
++++raw_data+=+response.read()
++++encoding+=+response.info().get_content_charset('utf8')+
++++data+=+raw_data.decode(encoding)
++++if+'\r\n'+not+in+data:
++++++++#+proably+a+windows+delimited+thing...try+to+update+it
++++++++data+=+data.replace('\r',+'\r\n')|code-block|syntax|javascript|185298|对于巨大的CSV文件来说可能不太合理，但对于我的用例来说工作得很好。|185299|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I know this has been answered for quite some time but not solve my problem. I am using DictReader and StringIO for my csv reading due to some other complications. I was able to solve problem more simply by replacing delimiters explicitly:

<pre><code>with urllib.request.urlopen(q) as response:
 raw_data = response.read()
 encoding = response.info().get_content_charset('utf8') 
 data = raw_data.decode(encoding)
 if '\r\n' not in data:
 # proably a windows delimited thing...try to update it
 data = data.replace('\r', '\r\n')
</code></pre>

Might not be reasonable for enormous CSV files, but worked well for my use case.

blocks|key|184499|text|另一种快速的解决方案:我也遇到了同样的错误。我在我的lubuntu机器上重新打开了GNUMERIC中的"wierd“csv文件，并将该文件导出为csv文件。这解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|184500|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Alternative and fast solution : I faced the same error. I reopened the "wierd" csv file in GNUMERIC on my lubuntu machine and exported the file as csv file. This corrected the issue.

the following code worked until today when I imported from a Windows machine and got this error:

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

<pre><code>import csv

class CSV:


 def __init__(self, file=None):
 self.file = file

 def read_file(self):
 data = []
 file_read = csv.reader(self.file)
 for row in file_read:
 data.append(row)
 return data

 def get_row_count(self):
 return len(self.read_file())

 def get_column_count(self):
 new_data = self.read_file()
 return len(new_data[0])

 def get_data(self, rows=1):
 data = self.read_file()

 return data[:rows]
</code></pre>

How can I fix this issue?

<pre><code>def upload_configurator(request, id=None):
 """
 A view that allows the user to configurator the uploaded CSV.
 """
 upload = Upload.objects.get(id=id)
 csvobject = CSV(upload.filepath)

 upload.num_records = csvobject.get_row_count()
 upload.num_columns = csvobject.get_column_count()
 upload.save()

 form = ConfiguratorForm()

 row_count = csvobject.get_row_count()
 colum_count = csvobject.get_column_count()
 first_row = csvobject.get_data(rows=1)
 first_two_rows = csvobject.get_data(rows=5)
</code></pre>

CSV new-line character seen in unquoted field error

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

下面的代码一直工作到今天，当我从Windows机器导入时，得到了这个错误：在未加引号的字段中看到换行符-您需要在通用换行符模式下打开文件吗？import csvclass CSV:    def __init__(self, file=None):        self.file = file    def read...

问在未加引号的字段中看到CSV换行符错误
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在未加引号的字段中看到CSV换行符错误EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在未加引号的字段中看到CSV换行符错误
EN