Python:如何解析包含空值的CSV文件?

Question

我有一个包含二进制字段的csv文件，当我通过csv.reader(f)读取它时，我得到

包含空值。

我已经在网络上尝试了各种解决方案，例如这个，这个和这个，但仍然弹出相同的错误。我设法逐行阅读并按,分隔它，但有些字段也,其中，所以我想知道如何阅读和提取列？行的示例如下：

212344408,"cp233.net","net","cp233","clientTransferProhibited,ClientDeleteProhibited","ENAME TECHNOLOGY CO., LTD.",1331,"DNS1.IIDNS.COM","DNS2.IIDNS.COM","2017-02-14","2018-02-14","2017-02-14","WANG MIN CHUN","wangminchun","WANG MIN CHUN","wangminchun","[e-mail]","QUANZHOUSHIANXIXIANCHANGKENGXIANGHUAMEICUN","QUAN ZHOU HI","FU,JIAN","362421","CN","+86.59523128184","+86.59523128184","%^^<AD>!^S<A8>E<98><AC>/^<A5><A0><C9>7","WANG MIN CHUN","WANG MIN CHUN","[e-mail]","WANG MIN CHUN","WANG MIN CHUN","[e-mail]",0,"2017-03-14 21:33:15","2017-03-12 20:44:02",0,"whois_zone_snr","2017-03-14 21:33:15",N

我将不胜感激任何建议。

Answer 1

Pandas 非常适合我的情况，可以检索文件并跳过那些因奇怪字符而损坏的行。

import pandas as pd
df = pandas.read_csv(filename, verbose =True , warn_bad_lines = True, error_bad_lines=False, names = header)

Answer 2

这在您的示例中工作正常，我什至用 NULL 替换了一个字符串，它处理得很好。

测试.csv：

212344408,"cp233.net","net","cp233","clientTransferProhibited,ClientDeleteProhibited","ENAME TECHNOLOGY CO., LTD.",1331,"DNS1.IIDNS.COM","DNS2.IIDNS.COM","2017-02-14","2018-02-14","2017-02-14","WANG MIN CHUN","wangminchun","WANG MIN CHUN","wangminchun","[e-mail]","QUANZHOUSHIANXIXIANCHANGKENGXIANGHUAMEICUN","QUAN ZHOU HI","FU,JIAN","362421","CN","+86.59523128184","+86.59523128184","%^^<AD>!^S<A8>E<98><AC>/^<A5><A0><C9>7","WANG MIN CHUN","WANG MIN CHUN","[e-mail]","WANG MIN CHUN","WANG MIN CHUN","[e-mail]",0,"2017-03-14 21:33:15","2017-03-12 20:44:02",0,"whois_zone_snr","2017-03-14 21:33:15",N
212344408,NULL,"net","cp233","clientTransferProhibited,ClientDeleteProhibited","ENAME TECHNOLOGY CO., LTD.",1331,"DNS1.IIDNS.COM","DNS2.IIDNS.COM","2017-02-14","2018-02-14","2017-02-14","WANG MIN CHUN","wangminchun","WANG MIN CHUN","wangminchun","[e-mail]","QUANZHOUSHIANXIXIANCHANGKENGXIANGHUAMEICUN","QUAN ZHOU HI","FU,JIAN","362421","CN","+86.59523128184","+86.59523128184","%^^<AD>!^S<A8>E<98><AC>/^<A5><A0><C9>7","WANG MIN CHUN","WANG MIN CHUN","[e-mail]","WANG MIN CHUN","WANG MIN CHUN","[e-mail]",0,"2017-03-14 21:33:15","2017-03-12 20:44:02",0,"whois_zone_snr","2017-03-14 21:33:15",N

法典：

import csv
with open('test.csv', 'r') as f:
reader = csv.reader(f)
for row in reader:
print(row)

如果这不是您正在经历的行为，您能否提供一条失败的线？