python新手。在下面的代码中,我从DB
获取4610行,并以字典模式存储它们。它正在提取所有行,直到最后一行代码和normalize()
十进制值,但当我打印len(SDIValues)
时,它只有146,应该是4600
#len(SDIData) = 4610rows fetched from MySQL DB
for data in SDIData:
Ibesticker =data[1].strip()
key = (data[0],Ibesticker)
if(data[3] != None):
PeriodYear = datetime.datetime.strptime(data[3], "%Y-%m-%d")
val = float(data[10].normalize())
print val #returns 4600 values
SDIValues[key] = [PeriodYear.year, val, PeriodYear.month] # something is wrong here i guess
print len(SDIValues) # 146 rows
目前没有回答
相关问题 更多 >
编程相关推荐