sheet.write(row, 0,
                            tweet.decode('ISO-8859-1'))  #.decode('utf-8')
                sheet.write(row, 1, cc)
                sheet.write(row, 2, tweetLabel.get(tweet))
                row += 1
            save_path = os.getcwd() + "/Files/Jaccard/" + t
            workbook_new.save(save_path + "/out_" + str(val).encode('utf-8') +
                              ".xls")
            i += 1

        sorted_scores = sorted(scores.items(), key=operator.itemgetter(0))
        cPickle.dump(word_count_storage,
                     open("word_count_storage_Graph_" + str(t) + ".p", "wb"))
        cPickle.dump(scores, open("scores_Graph_" + t + ".p", "wb"))
        # scores = cPickle.load(open("scores_Jacc"+t+".p", "rb"))
        ut.calculations(sorted_scores, rumor_category, t)

        workbook_eval = xlwt.Workbook()
        sheet = workbook_eval.add_sheet("Evaluation")
        sheet.write(0, 0, "Threshold")
        j = 0
        for key in rumor_category:
            sheet.write(0, j + 1, key + "_True Positive")
            sheet.write(0, j + 2, key + "_False positive")
            sheet.write(0, j + 3, key + "_True Negative")
            sheet.write(0, j + 4, key + "_False Negative")
            sheet.write(0, j + 5, key + "_Precision")
            sheet.write(0, j + 6, key + "_Recall")
            sheet.write(0, j + 7, key + "_F1-Measure")
            sheet.write(0, j + 8, key + "_Accuracy")
            j += 8
Beispiel #2
0
def main():
    print "Started---------------------------"
    start_time = time.time()
    thresh = ["10", "20"]  #["10","15", "20", "25"]
    workbook = xlrd.open_workbook(SETTINGS.dataset_folder + "dataset.xlsx")
    stop_words = open(SETTINGS.stop_words_file).read().splitlines()
    tweets, num_rows, tweetLabel, followerDict = ut.tweet_from_source_with_Followers(
        workbook, stop_words)
    rumor_category = {"NA", "R1", "R3", "R4", "R5", "R7", "All"}
    conceptDict = ut.readConceptDictionary()

    for th in thresh:
        rumor_type = {'Description'}
        for t in sorted(rumor_type):
            scores = {}
            rumor_list = ut.get_rumor_list(workbook, t, stop_words)
            rumor_word_count = {i: {} for i in range(rumor_list.__len__())}
            rumor_edge_count = {i: {} for i in range(rumor_list.__len__())}
            k = 0
            lookedInWordnet = set()
            for rumor in rumor_list:
                word_array = rumor.split()
                word_dict = {word: 0 for word in rumor.split()}
                edge_dict = ut.tuples(word_array)
                rumor_edge_count[k] = edge_dict
                rumor_word_count[k] = word_dict
                k += 1

            threshold = np.arange(0, 0.5, 0.01)
            original_rumor_word_count = rumor_word_count
            original_rumor_edge_count = rumor_edge_count
            word_count_storage = {}
            for val in threshold:
                i = 0
                rumor_edge_count = original_rumor_edge_count
                rumor_word_count = original_rumor_word_count
                jac_labeled_tweets, rumor_word_count = ut.labelDataJaccardConcept(
                    tweets, rumor_word_count, val, rumor_list, conceptDict, th,
                    followerDict)
                g_tweets = []
                na_tweets = []
                for key in jac_labeled_tweets:
                    if key == 0 or key == 2 or key == 3 or key == 4 or key == 6:
                        g_tweets += jac_labeled_tweets[key]
                    else:
                        na_tweets += jac_labeled_tweets[key]

                labeled_tweets, rumor_edge_count = ut.labelGraphConcept(
                    g_tweets, rumor_edge_count, val, rumor_list.__len__(),
                    conceptDict, th, followerDict)
                labeled_tweets[11] += na_tweets
                # word_count_storage[val] = rumor_word_count
                word_count_storage[val] = rumor_edge_count
                workbook_new = xlwt.Workbook()
                sheet = workbook_new.add_sheet("confusion Matrix")
                sheet.write(0, 0, "Tweets")
                sheet.write(0, 1, "Category")
                sheet.write(0, 2, "True Value")
                # workbook = xlrd.open_workbook("Files/"+type+"_out_"+i+".xls")
                # worksheet = workbook.sheet_by_name('Sheet1')
                # num_rows = worksheet.nrows - 1

                tp = {}
                tn = {}
                fp = {}
                fn = {}
                excel = {}
                for key in labeled_tweets:
                    cat = None
                    if key != 0 and key != 2 and key != 3 and key != 4 and key != 6:
                        cat = "NA"
                    elif key == 0:
                        cat = "R1"
                    elif key == 2:
                        cat = "R3"
                    elif key == 3:
                        cat = "R4"
                    elif key == 4:
                        cat = "R5"
                    elif key == 6:
                        cat == "R7"

                    value = labeled_tweets[key]
                    for item in value:
                        if item in tweetLabel:
                            type = tweetLabel[item]
                            if type != "NA" and cat != "NA":
                                if "All" not in tp:
                                    tp["All"] = 1
                                else:
                                    tp["All"] = tp["All"] + 1

                            elif type == "NA" and cat != "NA":
                                if "All" not in fp:
                                    fp["All"] = 1
                                else:
                                    fp["All"] = fp["All"] + 1

                            elif type != "NA" and cat == "NA":
                                if "All" not in fn:
                                    fn["All"] = 1
                                else:
                                    fn["All"] = fn["All"] + 1

                            if type == cat:
                                if type not in tp:
                                    tp[type] = 1
                                else:
                                    tp[type] = tp[type] + 1

                            else:
                                if cat not in fp:
                                    fp[cat] = 1
                                else:
                                    fp[cat] = fp[cat] + 1
                                if type not in fn:
                                    fn[type] = 1
                                else:
                                    fn[type] = fn[type] + 1
                        excel[item] = cat

                for key in rumor_category:
                    tn[key] = tweets.__len__() - tp.get(key, 0) - fp.get(
                        key, 0) - fn.get(key, 0)

                tptnlist = []
                tptnlist.append(tp)
                tptnlist.append(fp)
                tptnlist.append(fn)
                tptnlist.append(tn)
                scores[val] = tptnlist

                row = 1
                default = 'NA'
                print val
                # for tweet in tweets:
                #     cc = excel.get(tweet)
                #     sheet.write(row,0,tweet.decode('ISO-8859-1'))#.decode('utf-8')
                #     sheet.write(row,1,cc)
                #     sheet.write(row,2,tweetLabel.get(tweet))
                #     row += 1
                # save_path = os.getcwd()+"/Files/Combined/"+t
                # workbook_new.save(save_path+"/out_"+str(val).encode('utf-8')+".xls")
                i += 1

            sorted_scores = sorted(scores.items(), key=operator.itemgetter(0))

            # cPickle.dump(word_count_storage, open("word_count_storage_Graph_"+str(t)+".p", "wb"))
            # cPickle.dump(scores, open("scores_Graph_"+t+".p", "wb"))

            # scores = cPickle.load(open("scores_Jacc"+t+".p", "rb"))
            ut.calculations(sorted_scores, rumor_category, t, th, "Combined")

            workbook_eval = xlwt.Workbook()
            sheet = workbook_eval.add_sheet("Evaluation")
            sheet.write(0, 0, "Threshold")
            j = 0
            for key in rumor_category:
                if key == "R7" or key == "R5" or key == "R4":
                    continue
                sheet.write(0, j + 1, key + "_True Positive")
                sheet.write(0, j + 2, key + "_False positive")
                sheet.write(0, j + 3, key + "_True Negative")
                sheet.write(0, j + 4, key + "_False Negative")
                sheet.write(0, j + 5, key + "_Precision")
                sheet.write(0, j + 6, key + "_Recall")
                sheet.write(0, j + 7, key + "_F1-Measure")
                sheet.write(0, j + 8, key + "_Accuracy")
                j += 8

            row = 1

            for score, tptnlist in sorted_scores:
                sheet.write(row, 0, score)
                # tptnlist = sorted_scores[val];
                tp1 = tptnlist[0]
                fp1 = tptnlist[1]
                fn1 = tptnlist[2]
                tn1 = tptnlist[3]
                j = 0
                for key in rumor_category:
                    if key == "R7" or key == "R5" or key == "R4":
                        continue
                    p_1 = tp1.get(key, 0) + fp1.get(key, 0)
                    precision = 0
                    if p_1 != 0:
                        precision = float(tp1.get(key, 0)) / (p_1)
                    recall = float(tp1.get(
                        key, 0)) / (tp1.get(key, 0) + fn1.get(key, 0))
                    sheet.write(row, j + 1, tp1.get(key, 0))
                    sheet.write(row, j + 2, fp1.get(key, 0))
                    sheet.write(row, j + 3, tn1.get(key, 0))
                    sheet.write(row, j + 4, fn1.get(key, 0))
                    sheet.write(row, j + 5, precision)
                    sheet.write(row, j + 6, recall)
                    if precision + recall == 0:
                        sheet.write(row, j + 7, 0)
                    else:
                        sheet.write(
                            row, j + 7,
                            float(2 * precision * recall /
                                  (precision + recall)))
                    accuracy = float(
                        (tp1.get(key, 0) + tn1.get(key, 0)) / float(
                            tp1.get(key, 0) + tn1.get(key, 0) +
                            fp1.get(key, 0) + fn1.get(key, 0)))
                    sheet.write(row, j + 8, accuracy)
                    j += 8
                row += 1

            save_path = os.getcwd() + "/Files/Combined/" + th + "/" + t
            workbook_eval.save(save_path +
                               "/Evaluation_Parameters".encode('utf-8') +
                               ".xls")

        print("--- %s Minutes ---" % str((time.time() - start_time) / 60))
Beispiel #3
0
                default = 'NA'
                # print tweets.__len__()
                # for tweet in tweets:
                #     cc = excel.get(tweet)
                #     sheet.write(row,0,tweet.decode('ISO-8859-1'))#.decode('utf-8')
                #     sheet.write(row,1,cc)
                #     sheet.write(row,2,tweetLabel.get(tweet))
                #     row += 1
                # save_path = os.getcwd()+"/Files/Graph/"+t
                # workbook_new.save(save_path+"/out_"+str(val).encode('utf-8')+".xls")
                i += 1

            sorted_scores = sorted(scores.items(), key=operator.itemgetter(0))
            # cPickle.dump(word_count_storage, open("word_count_storage_Graph_"+str(t)+".p", "wb"))
            # cPickle.dump(scores, open("scores_Graph_"+t+".p", "wb"))
            ut.calculations(sorted_scores, rumor_category, t, th, "Graph")

            workbook_eval = xlwt.Workbook()
            sheet = workbook_eval.add_sheet("Evaluation")
            sheet.write(0, 0, "Threshold")
            j = 0
            for key in rumor_category:
                # if key == "R7" or key == "R5" or key == "R4":
                #     continue
                sheet.write(0, j + 1, key + "_True Positive")
                sheet.write(0, j + 2, key + "_False positive")
                sheet.write(0, j + 3, key + "_True Negative")
                sheet.write(0, j + 4, key + "_False Negative")
                sheet.write(0, j + 5, key + "_Precision")
                sheet.write(0, j + 6, key + "_Recall")
                sheet.write(0, j + 7, key + "_F1-Measure")
def main():
    # if __name__ == "__main__":
    print "Started---------------------------"
    start_time = time.time()
    thresh = ["10", "20"]  #["10","15", "20", "25"]
    workbook = xlrd.open_workbook(SETTINGS.dataset_folder + "dataset.xlsx")
    stop_words = open(SETTINGS.stop_words_file).read().splitlines()
    tweets, num_rows, tweetLabel, followerDict = ut.tweet_from_source_with_Followers(
        workbook, stop_words)
    rumor_category = {"NA", "R1", "R3", "R4", "R5", "R7", "All"}

    for th in thresh:
        rumor_type = {'Description'}
        for t in sorted(rumor_type):
            scores = {}
            rumor_list = ut.get_rumor_list(workbook, t, stop_words)
            rumor_word_count = {i: {} for i in range(rumor_list.__len__())}
            k = 0
            for rumor in rumor_list:
                word_dict = {word: 0 for word in rumor.split()}
                rumor_word_count[k] = word_dict
                k += 1

            threshold = np.arange(0, 0.5, 0.01)
            original_rumor_word_count = rumor_word_count

            for val in threshold:
                i = 0
                rumor_word_count = original_rumor_word_count
                labeled_tweets, rumor_word_count = ut.label_data_jaccard(
                    tweets, rumor_word_count, val, rumor_list, th,
                    followerDict)
                workbook_new = xlwt.Workbook()
                sheet = workbook_new.add_sheet("confusion Matrix")
                sheet.write(0, 0, "Tweets")
                sheet.write(0, 1, "Category")
                sheet.write(0, 2, "True Value")

                tp = {}
                tn = {}
                fp = {}
                fn = {}
                excel = {}
                for key in labeled_tweets:
                    cat = None
                    if key != 0 and key != 2 and key != 3 and key != 4 and key != 6:
                        cat = "NA"
                    elif key == 0:
                        cat = "R1"
                    elif key == 2:
                        cat = "R3"
                    elif key == 3:
                        cat = "R4"
                    elif key == 4:
                        cat = "R5"
                    elif key == 6:
                        cat == "R7"

                    value = labeled_tweets[key]
                    for item in value:
                        if item in tweetLabel:
                            type = tweetLabel[item]
                            if type != "NA" and cat != "NA":
                                if "All" not in tp:
                                    tp["All"] = 1
                                else:
                                    tp["All"] = tp["All"] + 1

                            elif type == "NA" and cat != "NA":
                                if "All" not in fp:
                                    fp["All"] = 1
                                else:
                                    fp["All"] = fp["All"] + 1

                            elif type != "NA" and cat == "NA":
                                if "All" not in fn:
                                    fn["All"] = 1
                                else:
                                    fn["All"] = fn["All"] + 1

                            if type == cat:
                                if type not in tp:
                                    tp[type] = 1
                                else:
                                    tp[type] = tp[type] + 1

                            else:
                                if cat not in fp:
                                    fp[cat] = 1
                                else:
                                    fp[cat] = fp[cat] + 1
                                if type not in fn:
                                    fn[type] = 1
                                else:
                                    fn[type] = fn[type] + 1
                        excel[item] = cat

                for key in rumor_category:
                    tn[key] = tweets.__len__() - tp.get(key, 0) - fp.get(
                        key, 0) - fn.get(key, 0)

                tptnlist = []
                tptnlist.append(tp)
                tptnlist.append(fp)
                tptnlist.append(fn)
                tptnlist.append(tn)
                scores[val] = tptnlist

                i += 1

            sorted_scores = sorted(scores.items(), key=operator.itemgetter(0))

            ut.calculations(sorted_scores, rumor_category, t, th, "Jaccard")

            workbook_eval = xlwt.Workbook()
            sheet = workbook_eval.add_sheet("Evaluation")
            sheet.write(0, 0, "Threshold")
            j = 0
            for key in rumor_category:
                if key == "R7" or key == "R5" or key == "R4":
                    continue
                sheet.write(0, j + 1, key + "_True Positive")
                sheet.write(0, j + 2, key + "_False positive")
                sheet.write(0, j + 3, key + "_True Negative")
                sheet.write(0, j + 4, key + "_False Negative")
                sheet.write(0, j + 5, key + "_Precision")
                sheet.write(0, j + 6, key + "_Recall")
                sheet.write(0, j + 7, key + "_F1-Measure")
                sheet.write(0, j + 8, key + "_Accuracy")
                j += 8

            row = 1

            for score, tptnlist in sorted_scores:
                sheet.write(row, 0, score)
                # tptnlist = sorted_scores[val];
                tp1 = tptnlist[0]
                fp1 = tptnlist[1]
                fn1 = tptnlist[2]
                tn1 = tptnlist[3]
                j = 0
                for key in rumor_category:
                    if key == "R7" or key == "R5" or key == "R4":
                        continue
                    p_1 = tp1.get(key, 0) + fp1.get(key, 0)
                    precision = 0
                    if p_1 != 0:
                        precision = float(tp1.get(key, 0)) / (p_1)
                    recall = float(tp1.get(
                        key, 0)) / (tp1.get(key, 0) + fn1.get(key, 0))
                    sheet.write(row, j + 1, tp1.get(key, 0))
                    sheet.write(row, j + 2, fp1.get(key, 0))
                    sheet.write(row, j + 3, tn1.get(key, 0))
                    sheet.write(row, j + 4, fn1.get(key, 0))
                    sheet.write(row, j + 5, precision)
                    sheet.write(row, j + 6, recall)
                    if precision + recall == 0:
                        sheet.write(row, j + 7, 0)
                    else:
                        sheet.write(
                            row, j + 7,
                            float(2 * precision * recall /
                                  (precision + recall)))
                    accuracy = float(
                        (tp1.get(key, 0) + tn1.get(key, 0)) / float(
                            tp1.get(key, 0) + tn1.get(key, 0) +
                            fp1.get(key, 0) + fn1.get(key, 0)))
                    sheet.write(row, j + 8, accuracy)
                    j += 8
                row += 1

            save_path = os.getcwd() + "/Files/Jaccard/" + th + "/" + t
            workbook_eval.save(save_path +
                               "/Evaluation_Parameters".encode('utf-8') +
                               ".xls")

        print("--- %s Minutes ---" % str((time.time() - start_time) / 60))
                #     cc = excel.get(tweet)
                #     sheet.write(row,0,tweet.decode('ISO-8859-1'))#.decode('utf-8')
                #     sheet.write(row,1,cc)
                #     sheet.write(row,2,tweetLabel.get(tweet))
                #     row += 1
                # save_path = os.getcwd()+"/Files/Combined/"+t
                # workbook_new.save(save_path+"/out_"+str(val).encode('utf-8')+".xls")
                i += 1

            sorted_scores = sorted(scores.items(), key=operator.itemgetter(0))

            # cPickle.dump(word_count_storage, open("word_count_storage_Graph_"+str(t)+".p", "wb"))
            # cPickle.dump(scores, open("scores_Graph_"+t+".p", "wb"))

            # scores = cPickle.load(open("scores_Jacc"+t+".p", "rb"))
            ut.calculations(sorted_scores, rumor_category, t, th, "Combined")

            workbook_eval = xlwt.Workbook()
            sheet = workbook_eval.add_sheet("Evaluation")
            sheet.write(0, 0, "Threshold")
            j = 0
            for key in rumor_category:
                if key == "R7" or key == "R5" or key == "R4":
                    continue
                sheet.write(0, j + 1, key + "_True Positive")
                sheet.write(0, j + 2, key + "_False positive")
                sheet.write(0, j + 3, key + "_True Negative")
                sheet.write(0, j + 4, key + "_False Negative")
                sheet.write(0, j + 5, key + "_Precision")
                sheet.write(0, j + 6, key + "_Recall")
                sheet.write(0, j + 7, key + "_F1-Measure")