user['keep_books'] = 1.0 else: user['keep_books'] = float(user['keep_books']) tmp = [] # tmp.append(user['user_name']) tmp.append(user['mobile_number']) tmp.append(user['keep_books']) tmp.append(byBarcode) tmp.append(float(byBarcode/user['keep_books'])) tmp.append(bySSF) tmp.append(float(bySSF/user['keep_books'])) tmp.append(bySpine) tmp.append(float(bySpine/user['keep_books'])) tmp.append(byDouban) tmp.append(float(byDouban/user['keep_books'])) tmp.append(byManual) tmp.append(float(byManual/user['keep_books'])) tmp.append(ByBarcode) tmp.append(float(ByBarcode/user['keep_books'])) tmp.append(byShow) tmp.append(float(byShow/user['keep_books'])) tmp.append(byMerge) tmp.append(float(byMerge/user['keep_books'])) tmp.append(unknown) tmp.append(float(unknown/user['keep_books'])) print tmp mat.append(tmp) saveMatrixToFile('statistics.csv', mat)
#!/usr/bin/env python # # Author: Archer Reilly # Date: 15/Sep/2015 # File: dedumplicate.py # Desc: remove the dumplicate records from kaijuan.csv # # Produced By BR(BeautifulReading) from util import loadMatrixFromFile, saveMatrixToFile mat = loadMatrixFromFile('./kaijuan.csv') newmat = [] tmpLst = [] for row in mat: if row[0] in tmpLst: print 'INFO: dumplicate ', row[0] else: newmat.append(row) tmpLst.append(row[0]) saveMatrixToFile('kaijuannodump.csv', newmat)