我试图让以下代码打印出csv文件中的所有行,但将每次打印输出的列限制为关键字"Name“的值,并对名为”花费过去12个月“和”花费过去6个月“的两个字典关键字进行单独计算。我想从每个人的12个月中减去6个月,并将该值打印为"collectionBalance“。我整天都在摆弄"for“循环,在计算和打印它们之前,我不知道如何正确地转换与这两个键相关的值。这两个值都被认为是字符串,所以我试图去掉它们的引号。抛给我的错误如下:
Traceback (most recent call last):
File "customer_regex.py", line 11, in <module>
collectionsBalance = float(data[count]["Spent Past 12 Months"].strip()) - float(data[count]["Spent Past 6 Months"].strip())
ValueError: could not convert string to float: '$6030.52'
import csv
import re
data = []
count = 0
with open('customerData.csv') as csvfile:
reader = csv.DictReader(csvfile)
for row in reader:
data.append(row)
collectionsBalance = float(data[count]["Spent Past 12 Months"].strip()) - float(data[count]["Spent Past 6 Months"].strip())
print(data[count]["Name"] + collectionsBalance)
count = count + 1
https://stackoverflow.com/questions/52842666
复制相似问题