我试图写一个python程序来清理来自CSV文件的调查数据。 我想转储包含一系列空白字段的行,如下面示例中的第一行和第三行。你知道吗
"1","a","b","c",,,,,
"2","a","b","c","d","e","f",,"h"
"3","a","b","c",,,,,
"4","a","z","u","d","i","f","x","h"
"5","d","c","c",,"c","f","g","z"
遵循我不成功的代码:
import csv
fname = raw_input("Enter input file name: ")
if len(fname) < 1 : fname = "survey.csv"
foutput = raw_input("Enter output file name: ")
if len(foutput) < 1 : foutput = "output_"+fname
input = open(fname, 'rb')
output = open(foutput, 'wb')
searchFor = 5*['']
writer = csv.writer(output)
for row in csv.reader(input):
if searchFor not in row :
writer.writerow(row)
input.close()
output.close()
使用
counter
检查一个列表是否是另一个列表的子集,如下所示。如果要删除空元素,则只需使用None
、bool
或len
来过滤空白并丢弃它们-输出-
怎么样
这将计算一行中的空格数,并允许您根据需要删除它们。你知道吗
相关问题 更多 >
编程相关推荐