def populateData(self): process = Process() # try: self.mycursor.execute('TRUNCATE TABLE ' + self.tableName) totalNeg = 0 totalPos = 0 mi = process.composeData() for row in mi: totalNeg += mi[row]['negatif']['total'] totalPos += mi[row]['positif']['total'] n = totalNeg+totalPos for row in mi: query = "INSERT INTO "+self.tableName+" (term, total_negatif, total_positif, total_term, df_positif, df_negatif, df_total, n11, n01, n10, n00, mi) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" n11pos = mi[row]['positif']['total'] n01pos = (totalPos - mi[row]['positif']['total']) n10pos = mi[row]['negatif']['total'] n00pos = (totalNeg - mi[row]['negatif']['total']) n11neg = mi[row]['negatif']['total'] n01neg = (totalNeg - mi[row]['negatif']['total']) n10neg = mi[row]['positif']['total'] n00neg = (totalPos - mi[row]['positif']['total']) n1_pos = n10pos+n11pos n1pos = n01pos+n11pos n0_pos = n01pos+n00pos n0pos = n10pos+n00pos n1_neg = n10neg+n11neg n1neg = n01neg+n11neg n0_neg = n01neg+n00neg n0neg = n10neg+n00neg rpos = (n11pos/n)*(process.cleanLog2((n*n11pos), (n1_pos*n1pos))) spos = (n01pos/n)*(process.cleanLog2((n*n01pos), (n0_pos*n1pos))) tpos = (n10pos/n)*(process.cleanLog2((n*n10pos), (n1_pos*n0pos))) upos = (n00pos/n)*(process.cleanLog2((n*n00pos), (n0_pos*n0pos))) rneg = (n11neg/n)*(process.cleanLog2((n*n11neg), (n1_neg*n1neg))) sneg = (n01neg/n)*(process.cleanLog2((n*n01neg), (n0_neg*n1neg))) tneg = (n10neg/n)*(process.cleanLog2((n*n10neg), (n1_neg*n0neg))) uneg = (n00neg/n)*(process.cleanLog2((n*n00neg), (n0_neg*n0neg))) MIpos = rpos+spos+tpos+upos MIneg = rneg+sneg+tneg+uneg finalMI = MIpos if MIpos >= MIneg else MIneg dfPos = len(mi[row]['positif']['posisi']) dfNeg = len(mi[row]['negatif']['posisi']) dfTotal = (dfPos + dfNeg) valuesPos = (row, mi[row]['negatif']['total'], mi[row]['positif']['total'], mi[row]['total'], dfPos, dfNeg, dfTotal, n11pos, n01pos, n10pos, n00pos, finalMI) self.mycursor.execute(query, valuesPos) self.mydb.commit()
def populateData(self): process = Process() # try: self.mycursor.execute('TRUNCATE TABLE ' + self.tableName) totalNeg = 0 totalPos = 0 mi = process.composeData() for row in mi: totalNeg += mi[row]['negatif']['total'] totalPos += mi[row]['positif']['total'] n = totalNeg+totalPos for row in mi: query = "INSERT INTO "+self.tableName+" (type, term, total_negatif, total_positif, total_term, n11, n01, n10, n00, n1, n1_, n0, n0_, mi) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" n11 = mi[row]['positif']['total'] n01 = (totalPos - mi[row]['positif']['total']) n10 = mi[row]['negatif']['total'] n00 = (totalNeg - mi[row]['negatif']['total']) n1_ = n10+n11 n1 = n01+n11 n0_ = n01+n00 n0 = n10+n00 r = (n11/n)*(process.cleanLog2((n*n11), (n1_*n1))) s = (n01/n)*(process.cleanLog2((n*n01), (n0_*n1))) t = (n10/n)*(process.cleanLog2((n*n10), (n1_*n0))) u = (n00/n)*(process.cleanLog2((n*n00), (n0_*n0))) finalMI = r+s+t+u valuesPos = ('positif',row, mi[row]['negatif']['total'], mi[row]['positif']['total'], mi[row]['total'], n11, n01, n10, n00, n1, n1_, n0, n0_, finalMI) self.mycursor.execute(query, valuesPos) n11 = mi[row]['negatif']['total'] n01 = (totalPos - mi[row]['negatif']['total']) n10 = mi[row]['positif']['total'] n00 = (totalNeg - mi[row]['positif']['total']) n1_ = n10+n11 n1 = n01+n11 n0_ = n01+n00 n0 = n10+n00 r = (n11/n)*(process.cleanLog2((n*n11), (n1_*n1))) s = (n01/n)*(process.cleanLog2((n*n01), (n0_*n1))) t = (n10/n)*(process.cleanLog2((n*n10), (n1_*n0))) u = (n00/n)*(process.cleanLog2((n*n00), (n0_*n0))) finalMI = r+s+t+u valuesNeg = ('negatif',row, mi[row]['negatif']['total'], mi[row]['positif']['total'], mi[row]['total'], n11, n01, n10, n00, n1, n1_, n0, n0_, finalMI) self.mycursor.execute(query, valuesNeg) self.mydb.commit()