哪些数量转不成整数
对每行的数量做 int(),转不了的记下行号(表头算第 1 行)。运行程序:
import csv, io
SALES = ("date,store,item,qty,price\n2026-09-01,东门,包子,10,2\n2026-09-01,东门,豆浆, 8 ,3\n2026-09-01,西门,油条,,2.5\n2026-09-01,西门,包子,10,2\n2026-09-01,东门,包子,10,2\n2026-09-02,北门,豆浆,five,3\n2026-09-02,北门,油条,4,2.5\n2026-09-02,西门,豆浆,6,3\n")
rows = list(csv.DictReader(io.StringIO(SALES)))
bad = []
for i, r in enumerate(rows, 2):
try:
int(r["qty"].strip())
except ValueError:
bad.append(i)
print("/".join(str(b) for b in bad))
全部评论