我可以找到hwo来调试我的代码
with open("f_in.csv",'rb') as f, open("f_out.csv", "w") as outputfile:
for line in f:
replacements = (
("(B)", "0"), ("(D)", "2"), ("Entrée air absente", "2"),
("+", "0,5"), ("++", "1"), ("+++", "2"),
("(S) +", "0,5"), ("(S) expi. ++", "1"), ("(S) +++", "2"),
("100", "0"), ("99", "0"), ("98", "0"), ("97", "0"), ("96", "0"),
("95", "0"), ("94", "1"),("93", "1"),
("92", "1"),("91", "1"),("90", "1"),("89", "1"))
for i, j in replacements.iteritems():
line = line.replace(i, j)
outputfile.write(line)`
for pair in replacements:
line = line.replace(*pair)
我想为csv文件的每一行中的每个值替换一个特定的数字
因此(B)将是0,(D)将是2,+将是0.5,++将是1,+++将是2,依此类推
csv文件的示例:
1277|2013-12-17 16:00:00|100|+|
1360|2014-01-15 16:00:00|(B)|99|++|E
1402|2014-02-05 20:00:00|(D)|99|++|D
1360|2014-01-29 08:00:00|(D)|99||C
1378|2014-01-21 20:00:00|(B)|100||D
但在我的程序中,我得到了这个错误:
for i, j in replacements.iteritems():
AttributeError: 'tuple' object has no attribute 'iteritems'
https://stackoverflow.com/questions/51732376
复制相似问题