中山网站建设文化公司,宜宾建设网站,网站建设需求模板,厦门建设工程交易中心网站尝试使用python读取CSV文件时遇到障碍。更新#xff1a;如果只想跳过字符或错误#xff0c;可以打开文件#xff0c;如下所示#xff1a;with open(os.path.join(directory, file), r, encodingutf-8, errorsignore) as data_file:到目前为止…尝试使用python读取CSV文件时遇到障碍。更新如果只想跳过字符或错误可以打开文件如下所示with open(os.path.join(directory, file), r, encodingutf-8, errorsignore) as data_file:到目前为止我已经尝试过了。for directory, subdirectories, files in os.walk(root_dir):for file in files:with open(os.path.join(directory, file), r) as data_file:reader csv.reader(data_file)for row in reader:print (row)我得到的错误是UnicodeEncodeError: charmap codec cant encode characters in position 224-225: character maps to 我试过了with open(os.path.join(directory, file), r, encodingUTF-8) as data_file:错误UnicodeEncodeError: charmap codec cant encode character \u2026 in position 223: character maps to 现在如果我只打印data_file它说它们是cp1252编码的但是如果我尝试with open(os.path.join(directory, file), r, encodingcp1252) as data_file:我得到的错误是UnicodeEncodeError: charmap codec cant encode characters in position 224-225: character maps to 我也尝试了推荐的套餐。我得到的错误是UnicodeEncodeError: charmap codec cant encode characters in position 224-225: character maps to 我要解析的行是2015-11-28 22:23:58,670805374291832832,479174464,MarkCrawford15,RT WhatTheFFacts: The tallest man in the world was Robert Pershing Wadlow of Alton, Illinois. He was slighty over 8 feet 11 inches tall.,None任何想法或帮助表示赞赏。解决方案我将使用csvkit它使用自动检测适当的编码和解码。例如import csvkitreader csvkit.reader(data_file)正如聊天解决方案所述for directory, subdirectories, files in os.walk(root_dir):for file in files:with open(os.path.join(directory, file), r, encodingutf-8) as data_file:reader csv.reader(data_file)for row in reader:data [i.encode(ascii, ignore).decode(ascii) for i in row]print (data)
