python去除excel空行_python – 从CSV中删除空白行？

我有一个大的csv文件,其中一些行完全是空白的.如何使用

Python从csv中删除所有空行？

毕竟你的建议,这是我到目前为止

import csv

# open input csv for reading

inputCSV = open(r'C:\input.csv', 'rb')

# create output csv for writing

outputCSV = open(r'C:\OUTPUT.csv', 'wb')

# prepare output csv for appending

appendCSV = open(r'C:\OUTPUT.csv', 'ab')

# create reader object

cr = csv.reader(inputCSV, dialect = 'excel')

# create writer object

cw = csv.writer(outputCSV, dialect = 'excel')

# create writer object for append

ca = csv.writer(appendCSV, dialect = 'excel')

# add pre-defined fields

cw.writerow(['FIELD1_','FIELD2_','FIELD3_','FIELD4_'])

# delete existing field names in input CSV

# ???????????????????????????

# loop through input csv, check for blanks, and write all changes to append csv

for row in cr:

if row or any(row) or any(field.strip() for field in row):

ca.writerow(row)

# close files

inputCSV.close()

outputCSV.close()

appendCSV.close()

这样做还是有更好的方式呢？