AttributeError:“float”对象没有属性“encode”

Question

每次我运行这个查询时都会出现这个错误，我试图将csv导入mysql这是我的csv文件

2880,H3KZV,2014/06/24 09:34:28,2014/06/25 09:34:28,1280
2880,R9UZB,2014/06/24 10:34:05,2014/06/24 16:34:05,1340

我在票价上发现了这个错误（12801340）#我删除了大部分代码

这是我的疑问：

^{pr2}$

Answer 1

会话成本=浮动（票价）/100.0

iso_date = "%s-%s-%s" % (tmp[0], tmp[1], tmp[2])
entryDatetime = "%s %s "  % (iso_date, start_time)
expiryDatetime = "%s %s " % (iso_date, end_time)
sql_local = """INSERT INTO customer_1.pay_and_display
    (plate, machine_id, ticket_datetime, expiry_datetime, ticket_name, ticket_price)
    VALUES ("%s", "%s", "%s", "%s", "%s", "%s") """ % (vrm, location_id, entryDatetime, expiryDatetime, "RINGOtest",SessionCost)
print sql_local
cursor.execute(sql_local)

Answer 2

ticket_price = float (ticket_price)/100
    ...
("ticket_price",ticket_price.encode('ascii','ignore' ))

你到底是怎么想的？