我有一个用Python读取的CSV文件,如果第一列为空,我希望程序跳过该行。我该怎么做呢?
现在我有:
with open('testdata1.csv', 'rU') as csvfile:
csvreader = csv.reader(csvfile)
for row in csvreader:
if row[0] = null:
#?????
如何: 1)检查CSV中的空单元格;2)告诉阅读器跳过该行?
谢谢你们。
发布于 2015-12-10 10:36:25
with open('testdata1.csv', 'r') as csvfile:
csvreader = csv.reader(csvfile)
for row in csvreader:
print(row)
if not row[0]:
print("12")
参考:How do I detect missing fields in a CSV file in a Pythonic way?
发布于 2018-05-30 17:03:40
您可以使用try和except。
for row in csvreader:
try:
#your code for cells which aren't empty
except:
#your code for empty cells
发布于 2020-10-23 23:13:03
我尝试了一下如果打印和空行返回empty brackets时会发生什么。所以只需要检查一下。
with open('testdata1.csv', 'rU') as csvfile:
csvreader = csv.reader(csvfile)
for row in csvreader:
if row == []:
continue
#do stuff normally
https://stackoverflow.com/questions/34192705
复制相似问题