示例#1
0
def getSessDurPosCorrelation(thresholdP, pearson, pearson_p, corr_Cat,
                             focType):
    import db_queries, utility
    res = utility.convertDictToList(
        db_queries.getSessDurPosCorrelation(thresholdP, pearson, pearson_p,
                                            corr_Cat, focType))
    return res
示例#2
0
def getHighFocSessCountMedCorr(thresholdP, pearson1, pearson2, pearson_p,
                               corr_Cat, focType):
    import db_queries, utility
    res = utility.convertDictToList(
        db_queries.getSessCountMedCorrelation(thresholdP, pearson1, pearson2,
                                              pearson_p, corr_Cat, focType))
    return res
def getSessCharOverall(
        fieldNameP, 
        thresholdP, 
        focType
    ):  
        import db_queries, utility
        res =  utility.convertDictToList( db_queries.getSessCharOverall( fieldNameP, thresholdP, focType))                                      
        return res                                                                          
示例#4
0
def getUniqueProjDetails(thresholdParam):
    #############
    print "Unique project details .... for project interleaving correlation"
    query40 = db_queries.query40(thresholdParam)
    #print "Query 40:  details corr >= 0.50 ", len(query40)
    query41 = db_queries.query41(thresholdParam)
    #print "Query 41:  details corr >= 0.0 and corr <=0.499 ", len(query41)
    query42 = db_queries.query42(thresholdParam)
    #print "Query 42:  details corr < 0.0 ", len(query42)

    list_query40 = utility.convertDictToList(query40)
    list_query41 = utility.convertDictToList(query41)
    list_query42 = utility.convertDictToList(query42)
    ###
    print "Getting box-plots done for U-N-I-Q-U-E P-R-O-J-E-C-T  counts in Project Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query40, list_query41, list_query42,
                              "Unique_Project_Counts_In_Project_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for U-N-I-Q-U-E P-R-O-J-E-C-T  counts in Project Interleaving Correlation ... "
    t_40_41, p_40_41 = utility.doTTest(list_query40, list_query41)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_40_41, p_40_41)
    t_40_42, p_40_42 = utility.doTTest(list_query40, list_query42)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_40_42, p_40_42)
    t_41_42, p_41_42 = utility.doTTest(list_query41, list_query42)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_41_42, p_41_42)
    #print "Query-40", list_query40
    #print "Query-41", list_query41
    #print "Query-42", list_query42
    print "---------------------"
    # A12 - test
    print "doing A12 for U-N-I-Q-U-E P-R-O-J-E-C-T  counts in Project Interleaving Correlation ... "
    a12_40_41 = utility.performA12(list_query40, list_query41)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_40_41)
    a12_40_42 = utility.performA12(list_query40, list_query42)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_40_42)
    a12_41_42 = utility.performA12(list_query41, list_query42)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_41_42)
    print "---------------------"
def getHighFocSessCountPosCorr(
        thresholdP, 
        pearson, 
        pearson_p, 
        corr_Cat, 
        focType
    ):  
        import db_queries, utility
        res =  utility.convertDictToList( db_queries.getSessCountPosCorrelation(  thresholdP, pearson, pearson_p, corr_Cat, focType))                                      
        return res                                              
示例#6
0
def getUniqueNamespaceDetails(thresholdParam):
    #############
    print "Unique namespace details .... for namespace interleaving correlation"
    query43 = db_queries.query43(thresholdParam)
    #print "Query 43:  details corr >= 0.50 ", len(query43)
    query44 = db_queries.query44(thresholdParam)
    #print "Query 44:  details corr >= 0.0 and corr <=0.499 ", len(query44)
    query45 = db_queries.query45(thresholdParam)
    #print "Query 45:  details corr < 0.0 ", len(query45)
    list_query43 = utility.convertDictToList(query43)
    list_query44 = utility.convertDictToList(query44)
    list_query45 = utility.convertDictToList(query45)
    print "Getting box-plots done for U-N-I-Q-U-E N-A-M-E-S-P-A-C-E  counts in Namespace Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query43, list_query44, list_query45,
                              "Unique_NSpace_Counts_In_NSpace_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for  U-N-I-Q-U-E N-A-M-E-S-P-A-C-E  counts in Namespace Interleaving Correlation ... "
    t_43_44, p_43_44 = utility.doTTest(list_query43, list_query44)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_43_44, p_43_44)
    t_43_45, p_43_45 = utility.doTTest(list_query43, list_query45)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_43_45, p_43_45)
    t_44_45, p_44_45 = utility.doTTest(list_query44, list_query45)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_44_45, p_44_45)
    #print "Query-43", list_query43
    #print "Query-44", list_query44
    #print "Query-45", list_query45
    print "---------------------"
    # A12 - test
    print "doing A12 for  U-N-I-Q-U-E N-A-M-E-S-P-A-C-E  counts in Namespace Interleaving Correlation ... "
    a12_43_44 = utility.performA12(list_query43, list_query44)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_43_44)
    a12_43_45 = utility.performA12(list_query43, list_query45)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_43_45)
    a12_44_45 = utility.performA12(list_query44, list_query45)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_44_45)
    print "---------------------"
示例#7
0
def getUniqueFileDetails(thresholdParam):
    #############
    print "Unique file details .... for file interleaving correlation"
    query37 = db_queries.query37(thresholdParam)
    #print "Query 37: file details corr >= 0.50 ", len(query37)
    query38 = db_queries.query38(thresholdParam)
    #print "Query 38: file details corr >= 0.0 and corr <=0.499 ", len(query38)
    query39 = db_queries.query39(thresholdParam)
    #print "Query 39: file details corr < 0.0 ", len(query39)
    list_query37 = utility.convertDictToList(query37)
    list_query38 = utility.convertDictToList(query38)
    list_query39 = utility.convertDictToList(query39)
    print "Getting box-plots done for U-N-I-Q-U-E F-I-L-E  counts in File Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query37, list_query38, list_query39,
                              "Unique_File_Counts_In_File_Corr")
    #print "Query-37", list_query37
    #print "Query-38", list_query38
    #print "Query-39", list_query39
    print "---------------------"
    # t - test
    print "doing T-Tests for U-N-I-Q-U-E F-I-L-E interleaving values in FILE Interleaving  Correlation ... "
    t_37_38, p_37_38 = utility.doTTest(list_query37, list_query38)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_37_38, p_37_38)
    t_37_39, p_37_39 = utility.doTTest(list_query37, list_query39)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_37_39, p_37_39)
    t_38_39, p_38_39 = utility.doTTest(list_query38, list_query39)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_38_39, p_38_39)
    print "---------------------"
    # A12 - test
    print "doing A12 for U-N-I-Q-U-E F-I-L-E interleaving values in FILE Interleaving Correlation ... "
    a12_37_38 = utility.performA12(list_query37, list_query38)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_37_38)
    a12_37_39 = utility.performA12(list_query37, list_query39)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_37_39)
    a12_38_39 = utility.performA12(list_query38, list_query39)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_38_39)
    print "---------------------"
def getSessDurMedCorrelation(
        thresholdP, 
        pearson1, 
        pearson2,
        pearson_p, 
        corr_Cat, 
        focType
    ):  
        import db_queries, utility
        res = utility.convertDictToList( db_queries.getSessDurMedCorrelation(  thresholdP, pearson1, pearson2, pearson_p, corr_Cat, focType))                                      
        return res                                              
def getGeneralFileExtResult(cntList, tableP): 
  import db_queries , utility , plotter 
  dict_FileExt={}
  for cntType in cntList:
    cnt_res =  utility.convertDictToList( db_queries.performFileExtQuery(cntType, tableP))
    dict_FileExt[cntType] = cnt_res                                                       
  #print "Final result = ", dict_FileExt
  print "Plotting ..."  
  plotter.compareFileExtViaBarPlots(dict_FileExt, "avg_general_file_ext", cntList)
  plotter.compareFileExtViaBoxPlots(dict_FileExt, "general_file_ext", cntList)  
  plotter.plotSharpVSOthers(dict_FileExt, "CSharp_And_Others")
  return dict_FileExt   
示例#10
0
def getUniqueProjDetails(thresholdParam):    
    #############
    print "Unique project details .... for project interleaving correlation"
    query40 = db_queries.query40(thresholdParam)
    #print "Query 40:  details corr >= 0.50 ", len(query40)
    query41 = db_queries.query41(thresholdParam)
    #print "Query 41:  details corr >= 0.0 and corr <=0.499 ", len(query41)
    query42 = db_queries.query42(thresholdParam)
    #print "Query 42:  details corr < 0.0 ", len(query42)
    
    list_query40=utility.convertDictToList(query40)
    list_query41=utility.convertDictToList(query41)
    list_query42=utility.convertDictToList(query42)    
    ###
    print "Getting box-plots done for U-N-I-Q-U-E P-R-O-J-E-C-T  counts in Project Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query40, list_query41, list_query42, "Unique_Project_Counts_In_Project_Corr")                                    
    print "---------------------"                
    # t - test 
    print "doing T-Tests for U-N-I-Q-U-E P-R-O-J-E-C-T  counts in Project Interleaving Correlation ... " 
    t_40_41, p_40_41 =  utility.doTTest(list_query40, list_query41)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_40_41, p_40_41)    
    t_40_42, p_40_42 =  utility.doTTest(list_query40, list_query42)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_40_42, p_40_42)        
    t_41_42, p_41_42 =  utility.doTTest(list_query41, list_query42)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_41_42, p_41_42)                                                     
    #print "Query-40", list_query40
    #print "Query-41", list_query41
    #print "Query-42", list_query42
    print "---------------------"                
    # A12 - test 
    print "doing A12 for U-N-I-Q-U-E P-R-O-J-E-C-T  counts in Project Interleaving Correlation ... " 
    a12_40_41 =  utility.performA12(list_query40, list_query41)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_40_41)    
    a12_40_42 =  utility.performA12(list_query40, list_query42)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_40_42)        
    a12_41_42 =  utility.performA12(list_query41, list_query42)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_41_42)           
    print "---------------------"                                                                  
示例#11
0
def getUniqueNamespaceDetails(thresholdParam):    
    #############
    print "Unique namespace details .... for namespace interleaving correlation"
    query43 = db_queries.query43(thresholdParam)
    #print "Query 43:  details corr >= 0.50 ", len(query43)
    query44 = db_queries.query44(thresholdParam)
    #print "Query 44:  details corr >= 0.0 and corr <=0.499 ", len(query44)
    query45 = db_queries.query45(thresholdParam)
    #print "Query 45:  details corr < 0.0 ", len(query45)
    list_query43=utility.convertDictToList(query43)
    list_query44=utility.convertDictToList(query44)
    list_query45=utility.convertDictToList(query45)    
    print "Getting box-plots done for U-N-I-Q-U-E N-A-M-E-S-P-A-C-E  counts in Namespace Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query43, list_query44, list_query45, "Unique_NSpace_Counts_In_NSpace_Corr")                                        
    print "---------------------"                
    # t - test 
    print "doing T-Tests for  U-N-I-Q-U-E N-A-M-E-S-P-A-C-E  counts in Namespace Interleaving Correlation ... " 
    t_43_44, p_43_44 =  utility.doTTest(list_query43, list_query44)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_43_44, p_43_44)    
    t_43_45, p_43_45 =  utility.doTTest(list_query43, list_query45)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_43_45, p_43_45)        
    t_44_45, p_44_45 =  utility.doTTest(list_query44, list_query45)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_44_45, p_44_45)                                                     
    #print "Query-43", list_query43
    #print "Query-44", list_query44
    #print "Query-45", list_query45    
    print "---------------------"                
    # A12 - test 
    print "doing A12 for  U-N-I-Q-U-E N-A-M-E-S-P-A-C-E  counts in Namespace Interleaving Correlation ... " 
    a12_43_44 =  utility.performA12(list_query43, list_query44)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_43_44)    
    a12_43_45 =  utility.performA12(list_query43, list_query45)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_43_45)        
    a12_44_45 =  utility.performA12(list_query44, list_query45)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_44_45)           
    print "---------------------"                                                              
示例#12
0
def getUniqueFileDetails(thresholdParam):
    #############
    print "Unique file details .... for file interleaving correlation"
    query37 = db_queries.query37(thresholdParam)
    #print "Query 37: file details corr >= 0.50 ", len(query37)
    query38 = db_queries.query38(thresholdParam)
    #print "Query 38: file details corr >= 0.0 and corr <=0.499 ", len(query38)
    query39 = db_queries.query39(thresholdParam)
    #print "Query 39: file details corr < 0.0 ", len(query39)
    list_query37=utility.convertDictToList(query37)
    list_query38=utility.convertDictToList(query38)
    list_query39=utility.convertDictToList(query39)  
    print "Getting box-plots done for U-N-I-Q-U-E F-I-L-E  counts in File Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query37, list_query38, list_query39, "Unique_File_Counts_In_File_Corr")                                
    #print "Query-37", list_query37
    #print "Query-38", list_query38
    #print "Query-39", list_query39  
    print "---------------------"                
    # t - test 
    print "doing T-Tests for U-N-I-Q-U-E F-I-L-E interleaving values in FILE Interleaving  Correlation ... " 
    t_37_38, p_37_38 =  utility.doTTest(list_query37, list_query38)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_37_38, p_37_38)    
    t_37_39, p_37_39 =  utility.doTTest(list_query37, list_query39)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_37_39, p_37_39)        
    t_38_39, p_38_39 =  utility.doTTest(list_query38, list_query39)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_38_39, p_38_39)  
    print "---------------------"                
    # A12 - test 
    print "doing A12 for U-N-I-Q-U-E F-I-L-E interleaving values in FILE Interleaving Correlation ... " 
    a12_37_38 =  utility.performA12(list_query37, list_query38)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_37_38)    
    a12_37_39 =  utility.performA12(list_query37, list_query39)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_37_39)        
    a12_38_39 =  utility.performA12(list_query38, list_query39)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_38_39)           
    print "---------------------"                                                                                                                 
示例#13
0
def getGeneralFileExtResult(cntList, tableP):
    import db_queries, utility, plotter
    dict_FileExt = {}
    for cntType in cntList:
        cnt_res = utility.convertDictToList(
            db_queries.performFileExtQuery(cntType, tableP))
        dict_FileExt[cntType] = cnt_res
    #print "Final result = ", dict_FileExt
    print "Plotting ..."
    plotter.compareFileExtViaBarPlots(dict_FileExt, "avg_general_file_ext",
                                      cntList)
    plotter.compareFileExtViaBoxPlots(dict_FileExt, "general_file_ext",
                                      cntList)
    plotter.plotSharpVSOthers(dict_FileExt, "CSharp_And_Others")
    return dict_FileExt
示例#14
0
def getSessCharOverall(fieldNameP, thresholdP, focType):
    import db_queries, utility
    res = utility.convertDictToList(
        db_queries.getSessCharOverall(fieldNameP, thresholdP, focType))
    return res
示例#15
0
def getDetails(thresholdParam):
    #############
    print "Focus details .... for namespace interleaving correlation"
    query13 = db_queries.query13(thresholdParam)
    #print "Query 13: focus details corr >= 0.50 ", len(query13)

    query14 = db_queries.query14(thresholdParam)
    #print "Query 14: focus details corr >= 0.0 and corr <=0.499 ", len(query14)
    query15 = db_queries.query15(thresholdParam)
    #print "Query 15: focus details corr < 0.0 ", len(query15)
    #############
    print "Focus details .... for state interleaving correlation"
    query16 = db_queries.query16(thresholdParam)
    #print "Query 16: focus details corr >= 0.50 ", len(query16)
    query17 = db_queries.query17(thresholdParam)
    #print "Query 17: focus details corr >= 0.0 and corr <=0.499 ", len(query17)
    query18 = db_queries.query18(thresholdParam)
    #print "Query 18: focus details corr < 0.0 ", len(query18)
    #############
    print "Focus details .... for project interleaving correlation"
    query19 = db_queries.query19(thresholdParam)
    #print "Query 19: focus details corr >= 0.50 ", len(query19)
    query20 = db_queries.query20(thresholdParam)
    #print "Query 20: focus details corr >= 0.0 and corr <=0.499 ", len(query20)
    query21 = db_queries.query21(thresholdParam)
    #print "Query 21: focus details corr < 0.0 ", len(query21)
    #############
    print "File Interleaving details .... for file interleaving correlation"
    query22 = db_queries.query22(thresholdParam)
    #print "Query 22: focus details corr >= 0.50 ", len(query22)
    query23 = db_queries.query23(thresholdParam)
    #print "Query 23: focus details corr >= 0.0 and corr <=0.499 ", len(query23)
    query24 = db_queries.query24(thresholdParam)
    #print "Query 24: focus details corr < 0.0 ", len(query24)
    #############
    print "Focus details .... for file interleaving correlation"
    query25 = db_queries.query25(thresholdParam)
    #print "Query 25:  details corr >= 0.50 ", len(query25)
    query26 = db_queries.query26(thresholdParam)
    #print "Query 26:  details corr >= 0.0 and corr <=0.499 ", len(query26)
    query27 = db_queries.query27(thresholdParam)
    #print "Query 27:  details corr < 0.0 ", len(query27)
    #############
    print "Project interleaving details .... for project interleaving correlation"
    query28 = db_queries.query28(thresholdParam)
    #print "Query 28:  details corr >= 0.50 ", len(query28)
    query29 = db_queries.query29(thresholdParam)
    #print "Query 29:  details corr >= 0.0 and corr <=0.499 ", len(query29)
    query30 = db_queries.query30(thresholdParam)
    #print "Query 30:  details corr < 0.0 ", len(query30)
    #############
    print "State details .... for state interleaving correlation"
    query31 = db_queries.query31(thresholdParam)
    #print "Query 31:  details corr >= 0.50 ", len(query31)
    query32 = db_queries.query32(thresholdParam)
    #print "Query 32:  details corr >= 0.0 and corr <=0.499 ", len(query32)
    query33 = db_queries.query33(thresholdParam)
    #print "Query 33:  details corr < 0.0 ", len(query33)
    #############
    print "Namespace interleaving details .... for namespace interleaving correlation"
    query34 = db_queries.query34(thresholdParam)
    #print "Query 34:  details corr >= 0.50 ", len(query34)
    query35 = db_queries.query35(thresholdParam)
    #print "Query 35:  details corr >= 0.0 and corr <=0.499 ", len(query35)
    query36 = db_queries.query36(thresholdParam)
    #print "Query 36:  details corr < 0.0 ", len(query36)
    ################ CONVERSION OF DICTS TO LISTS ###########
    list_query13 = utility.convertDictToList(query13)
    list_query14 = utility.convertDictToList(query14)
    list_query15 = utility.convertDictToList(query15)
    print "---------------------"
    print "Getting box-plots done for F-O-C-U-S values in Namespace Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query13, list_query14, list_query15,
                              "Focus_Values_In_Namespace_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for F-O-C-U-S values in Namespace Interleaving Correlation ... "
    t_13_14, p_13_14 = utility.doTTest(list_query13, list_query14)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_13_14, p_13_14)
    t_13_15, p_13_15 = utility.doTTest(list_query13, list_query15)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_13_15, p_13_15)
    t_14_15, p_14_15 = utility.doTTest(list_query14, list_query15)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_14_15, p_14_15)
    print "---------------------"
    # A12 - test
    print "doing A12 for F-O-C-U-S values in Namespace Interleaving  Correlation ... "
    a12_13_14 = utility.performA12(list_query13, list_query14)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_13_14)
    a12_13_15 = utility.performA12(list_query13, list_query15)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_13_15)
    a12_14_15 = utility.performA12(list_query14, list_query15)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_14_15)
    print "---------------------"
    list_query16 = utility.convertDictToList(query16)
    list_query17 = utility.convertDictToList(query17)
    list_query18 = utility.convertDictToList(query18)
    print "---------------------"
    print "Getting box-plots done for F-O-C-U-S values in State Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query16, list_query17, list_query18,
                              "Focus_Values_In_State_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for F-O-C-U-S values in State Interleaving Correlation ... "
    t_16_17, p_16_17 = utility.doTTest(list_query16, list_query17)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_16_17, p_16_17)
    t_16_18, p_16_18 = utility.doTTest(list_query16, list_query18)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_16_18, p_16_18)
    t_17_18, p_17_18 = utility.doTTest(list_query17, list_query18)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_17_18, p_17_18)
    print "---------------------"
    # A12 - test
    print "doing A12 for F-O-C-U-S values in State Interleaving  Correlation ... "
    a12_16_17 = utility.performA12(list_query16, list_query17)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_16_17)
    a12_16_18 = utility.performA12(list_query16, list_query18)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_16_18)
    a12_17_18 = utility.performA12(list_query17, list_query18)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_17_18)
    print "---------------------"
    list_query19 = utility.convertDictToList(query19)
    list_query20 = utility.convertDictToList(query20)
    list_query21 = utility.convertDictToList(query21)
    print "---------------------"
    print "Getting box-plots done for F-O-C-U-S values in Project Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query19, list_query20, list_query21,
                              "Focus_Values_In_Project_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for F-O-C-U-S values in Project Interleaving Correlation ... "
    t_19_20, p_19_20 = utility.doTTest(list_query19, list_query20)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_19_20, p_19_20)
    t_19_21, p_19_21 = utility.doTTest(list_query19, list_query21)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_19_21, p_19_21)
    t_20_21, p_20_21 = utility.doTTest(list_query20, list_query21)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_20_21, p_20_21)
    print "---------------------"
    # A12 - test
    print "doing A12 for F-O-C-U-S values in Project Interleaving  Correlation ... "
    a12_19_20 = utility.performA12(list_query19, list_query20)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_19_20)
    a12_19_21 = utility.performA12(list_query19, list_query21)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_19_21)
    a12_20_21 = utility.performA12(list_query20, list_query21)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_20_21)
    print "---------------------"
    list_query22 = utility.convertDictToList(query22)
    list_query23 = utility.convertDictToList(query23)
    list_query24 = utility.convertDictToList(query24)
    print "---------------------"
    print "Getting box-plots done for F-O-C-U-S  values in File Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query22, list_query23, list_query24,
                              "Focus_Values_In_File_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for F-O-C-U-S values in File Interleaving Correlation ... "
    t_22_23, p_22_23 = utility.doTTest(list_query22, list_query23)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_22_23, p_22_23)
    t_22_24, p_22_24 = utility.doTTest(list_query22, list_query24)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_22_24, p_22_24)
    t_23_24, p_23_24 = utility.doTTest(list_query23, list_query24)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_23_24, p_23_24)
    print "---------------------"
    # A12 - test
    print "doing A12 for F-O-C-U-S values in File Interleaving  Correlation ... "
    a12_22_23 = utility.performA12(list_query22, list_query23)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_22_23)
    a12_22_24 = utility.performA12(list_query22, list_query24)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_22_24)
    a12_23_24 = utility.performA12(list_query23, list_query24)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_23_24)
    print "---------------------"
    list_query25 = utility.convertDictToList(query25)
    list_query26 = utility.convertDictToList(query26)
    list_query27 = utility.convertDictToList(query27)
    print "---------------------"
    print "Getting box-plots done for F-I-L-E interleaving values in File Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query25, list_query26, list_query27,
                              "File_Values_In_File_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for F-I-L-E interleaving values in File Interleaving Correlation ... "
    t_25_26, p_25_26 = utility.doTTest(list_query25, list_query26)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_25_26, p_25_26)
    t_25_27, p_25_27 = utility.doTTest(list_query25, list_query27)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_25_27, p_25_27)
    t_26_27, p_26_27 = utility.doTTest(list_query26, list_query27)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_26_27, p_26_27)
    list_query28 = utility.convertDictToList(query28)
    list_query29 = utility.convertDictToList(query29)
    list_query30 = utility.convertDictToList(query30)
    print "---------------------"
    # A12 - test
    print "doing A12 for F-I-L-E interleaving values in File Interleaving Correlation ... "
    a12_25_26 = utility.performA12(list_query25, list_query26)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_25_26)
    a12_25_27 = utility.performA12(list_query25, list_query27)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_25_27)
    a12_26_27 = utility.performA12(list_query26, list_query27)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_26_27)
    print "---------------------"
    print "---------------------"
    print "Getting box-plots done for P-R-O-J-E-C-T interleaving values in Project Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query28, list_query29, list_query30,
                              "Project_Values_In_Project_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for P-R-O-J-E-C-T  interleaving values in Project Interleaving Correlation ... "
    t_28_29, p_28_29 = utility.doTTest(list_query28, list_query29)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_28_29, p_28_29)
    t_28_30, p_28_30 = utility.doTTest(list_query28, list_query30)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_28_30, p_28_30)
    t_29_30, p_29_30 = utility.doTTest(list_query29, list_query30)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_29_30, p_29_30)
    list_query31 = utility.convertDictToList(query31)
    list_query32 = utility.convertDictToList(query32)
    list_query33 = utility.convertDictToList(query33)
    print "---------------------"
    # A12 - test
    print "doing A12 for P-R-O-J-E-C-T  interleaving values in Project Interleaving Correlation ... "
    a12_28_29 = utility.performA12(list_query28, list_query29)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_28_29)
    a12_28_30 = utility.performA12(list_query28, list_query30)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_28_30)
    a12_29_30 = utility.performA12(list_query29, list_query30)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_29_30)
    print "---------------------"
    print "---------------------"
    print "Getting box-plots done for S-T-A-T-E interleaving values in STATE Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query31, list_query32, list_query33,
                              "State_Values_In_State_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for S-T-A-T-E interleaving values in STATE Interleaving  Correlation ... "
    t_31_32, p_31_32 = utility.doTTest(list_query31, list_query32)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_31_32, p_31_32)
    t_31_33, p_31_33 = utility.doTTest(list_query31, list_query33)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_31_33, p_31_33)
    t_32_33, p_32_33 = utility.doTTest(list_query32, list_query33)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_32_33, p_32_33)
    print "---------------------"
    # A12 - test
    print "doing A12 for S-T-A-T-E interleaving values in STATE Interleaving Correlation ... "
    a12_31_32 = utility.performA12(list_query31, list_query32)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_31_32)
    a12_31_33 = utility.performA12(list_query31, list_query33)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_31_33)
    a12_32_33 = utility.performA12(list_query32, list_query33)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_32_33)
    print "---------------------"

    list_query34 = utility.convertDictToList(query34)
    list_query35 = utility.convertDictToList(query35)
    list_query36 = utility.convertDictToList(query36)
    print "---------------------"
    print "Getting box-plots done for N-A-M-E-S-P-A-C-E interleaving values in NAMESPACE Interleaving Correlation ... "
    plotter.compareViaBoxPlot(list_query34, list_query35, list_query36,
                              "Namespace_Values_In_Namespace_Corr")
    print "---------------------"
    # t - test
    print "doing T-Tests for N-A-M-E-S-P-A-C-E interleaving values in NAMESPACE Interleaving  Correlation ... "
    t_34_35, p_34_35 = utility.doTTest(list_query34, list_query35)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(
        t_34_35, p_34_35)
    t_34_36, p_34_36 = utility.doTTest(list_query34, list_query36)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_34_36, p_34_36)
    t_35_36, p_35_36 = utility.doTTest(list_query35, list_query36)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(
        t_35_36, p_35_36)

    print "---------------------"
    # A12 - test
    print "doing A12 for N-A-M-E-S-P-A-C-E interleaving values in NAMESPACE Interleaving Correlation ... "
    a12_34_35 = utility.performA12(list_query34, list_query35)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(
        a12_34_35)
    a12_34_36 = utility.performA12(list_query34, list_query36)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_34_36)
    a12_35_36 = utility.performA12(list_query35, list_query36)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(
        a12_35_36)
    print "---------------------"
示例#16
0
def getAllCorrelationCategories():  
        import db_queries, utility
        res = []
        res = utility.convertDictToList(db_queries.getAllCorrelationCategories())
        return res 
示例#17
0
def getDetails(thresholdParam):
    #############
    print "Focus details .... for namespace interleaving correlation"
    query13 = db_queries.query13(thresholdParam)
    #print "Query 13: focus details corr >= 0.50 ", len(query13)
    
    query14 = db_queries.query14(thresholdParam)
    #print "Query 14: focus details corr >= 0.0 and corr <=0.499 ", len(query14)
    query15 = db_queries.query15(thresholdParam)
    #print "Query 15: focus details corr < 0.0 ", len(query15)
    #############
    print "Focus details .... for state interleaving correlation"
    query16 = db_queries.query16(thresholdParam)
    #print "Query 16: focus details corr >= 0.50 ", len(query16)
    query17 = db_queries.query17(thresholdParam)
    #print "Query 17: focus details corr >= 0.0 and corr <=0.499 ", len(query17)
    query18 = db_queries.query18(thresholdParam)
    #print "Query 18: focus details corr < 0.0 ", len(query18)
    #############
    print "Focus details .... for project interleaving correlation"
    query19 = db_queries.query19(thresholdParam)
    #print "Query 19: focus details corr >= 0.50 ", len(query19)
    query20 = db_queries.query20(thresholdParam)
    #print "Query 20: focus details corr >= 0.0 and corr <=0.499 ", len(query20)
    query21 = db_queries.query21(thresholdParam)
    #print "Query 21: focus details corr < 0.0 ", len(query21)
    #############
    print "File Interleaving details .... for file interleaving correlation"
    query22 = db_queries.query22(thresholdParam)
    #print "Query 22: focus details corr >= 0.50 ", len(query22)
    query23 = db_queries.query23(thresholdParam)
    #print "Query 23: focus details corr >= 0.0 and corr <=0.499 ", len(query23)
    query24 = db_queries.query24(thresholdParam)
    #print "Query 24: focus details corr < 0.0 ", len(query24)
    #############
    print "Focus details .... for file interleaving correlation"
    query25 = db_queries.query25(thresholdParam)
    #print "Query 25:  details corr >= 0.50 ", len(query25)
    query26 = db_queries.query26(thresholdParam)
    #print "Query 26:  details corr >= 0.0 and corr <=0.499 ", len(query26)
    query27 = db_queries.query27(thresholdParam)
    #print "Query 27:  details corr < 0.0 ", len(query27)
    #############
    print "Project interleaving details .... for project interleaving correlation"
    query28 = db_queries.query28(thresholdParam)
    #print "Query 28:  details corr >= 0.50 ", len(query28)
    query29 = db_queries.query29(thresholdParam)
    #print "Query 29:  details corr >= 0.0 and corr <=0.499 ", len(query29)
    query30 = db_queries.query30(thresholdParam)
    #print "Query 30:  details corr < 0.0 ", len(query30)
    #############
    print "State details .... for state interleaving correlation"
    query31 = db_queries.query31(thresholdParam)
    #print "Query 31:  details corr >= 0.50 ", len(query31)
    query32 = db_queries.query32(thresholdParam)
    #print "Query 32:  details corr >= 0.0 and corr <=0.499 ", len(query32)
    query33 = db_queries.query33(thresholdParam)
    #print "Query 33:  details corr < 0.0 ", len(query33)
    #############
    print "Namespace interleaving details .... for namespace interleaving correlation"
    query34 = db_queries.query34(thresholdParam)
    #print "Query 34:  details corr >= 0.50 ", len(query34)
    query35 = db_queries.query35(thresholdParam)
    #print "Query 35:  details corr >= 0.0 and corr <=0.499 ", len(query35)
    query36 = db_queries.query36(thresholdParam)
    #print "Query 36:  details corr < 0.0 ", len(query36)   
    ################ CONVERSION OF DICTS TO LISTS ###########
    list_query13=utility.convertDictToList(query13)
    list_query14=utility.convertDictToList(query14)
    list_query15=utility.convertDictToList(query15) 
    print "---------------------"    
    print "Getting box-plots done for F-O-C-U-S values in Namespace Interleaving Correlation ... " 
    plotter.compareViaBoxPlot(list_query13, list_query14, list_query15, "Focus_Values_In_Namespace_Corr")
    print "---------------------"
    # t - test 
    print "doing T-Tests for F-O-C-U-S values in Namespace Interleaving Correlation ... " 
    t_13_14, p_13_14 =  utility.doTTest(list_query13, list_query14)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_13_14, p_13_14)    
    t_13_15, p_13_15 =  utility.doTTest(list_query13, list_query15)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_13_15, p_13_15)        
    t_14_15, p_14_15 =  utility.doTTest(list_query14, list_query15)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_14_15, p_14_15)    
    print "---------------------"                
    # A12 - test 
    print "doing A12 for F-O-C-U-S values in Namespace Interleaving  Correlation ... " 
    a12_13_14 =  utility.performA12(list_query13, list_query14)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_13_14)    
    a12_13_15 =  utility.performA12(list_query13, list_query15)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_13_15)        
    a12_14_15 =  utility.performA12(list_query14, list_query15)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_14_15)           
    print "---------------------"                
    list_query16=utility.convertDictToList(query16)
    list_query17=utility.convertDictToList(query17)
    list_query18=utility.convertDictToList(query18)
    print "---------------------"    
    print "Getting box-plots done for F-O-C-U-S values in State Interleaving Correlation ... "     
    plotter.compareViaBoxPlot(list_query16, list_query17, list_query18, "Focus_Values_In_State_Corr")
    print "---------------------"
    # t - test 
    print "doing T-Tests for F-O-C-U-S values in State Interleaving Correlation ... " 
    t_16_17, p_16_17 =  utility.doTTest(list_query16, list_query17)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_16_17, p_16_17)    
    t_16_18, p_16_18 =  utility.doTTest(list_query16, list_query18)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_16_18, p_16_18)        
    t_17_18, p_17_18 =  utility.doTTest(list_query17, list_query18)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_17_18, p_17_18)                
    print "---------------------"                
    # A12 - test 
    print "doing A12 for F-O-C-U-S values in State Interleaving  Correlation ... " 
    a12_16_17 =  utility.performA12(list_query16, list_query17)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_16_17)    
    a12_16_18 =  utility.performA12(list_query16, list_query18)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_16_18)        
    a12_17_18 =  utility.performA12(list_query17, list_query18)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_17_18)           
    print "---------------------"                                                                                                                                                                    
    list_query19=utility.convertDictToList(query19)
    list_query20=utility.convertDictToList(query20)
    list_query21=utility.convertDictToList(query21)
    print "---------------------"    
    print "Getting box-plots done for F-O-C-U-S values in Project Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query19, list_query20, list_query21, "Focus_Values_In_Project_Corr") 
    print "---------------------"    
    # t - test 
    print "doing T-Tests for F-O-C-U-S values in Project Interleaving Correlation ... " 
    t_19_20, p_19_20 =  utility.doTTest(list_query19, list_query20)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_19_20, p_19_20)    
    t_19_21, p_19_21 =  utility.doTTest(list_query19, list_query21)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_19_21, p_19_21)        
    t_20_21, p_20_21 =  utility.doTTest(list_query20, list_query21)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_20_21, p_20_21)        
    print "---------------------"                
    # A12 - test 
    print "doing A12 for F-O-C-U-S values in Project Interleaving  Correlation ... " 
    a12_19_20 =  utility.performA12(list_query19, list_query20)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_19_20)    
    a12_19_21 =  utility.performA12(list_query19, list_query21)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_19_21)        
    a12_20_21 =  utility.performA12(list_query20, list_query21)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_20_21)           
    print "---------------------"                                                                                                                                                                
    list_query22=utility.convertDictToList(query22)
    list_query23=utility.convertDictToList(query23)
    list_query24=utility.convertDictToList(query24)
    print "---------------------"    
    print "Getting box-plots done for F-O-C-U-S  values in File Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query22, list_query23, list_query24, "Focus_Values_In_File_Corr")    
    print "---------------------"    
    # t - test 
    print "doing T-Tests for F-O-C-U-S values in File Interleaving Correlation ... " 
    t_22_23, p_22_23 =  utility.doTTest(list_query22, list_query23)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_22_23, p_22_23)    
    t_22_24, p_22_24 =  utility.doTTest(list_query22, list_query24)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_22_24, p_22_24)        
    t_23_24, p_23_24 =  utility.doTTest(list_query23, list_query24)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_23_24, p_23_24) 
    print "---------------------"                
    # A12 - test 
    print "doing A12 for F-O-C-U-S values in File Interleaving  Correlation ... " 
    a12_22_23 =  utility.performA12(list_query22, list_query23)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_22_23)    
    a12_22_24 =  utility.performA12(list_query22, list_query24)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_22_24)        
    a12_23_24 =  utility.performA12(list_query23, list_query24)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_23_24)           
    print "---------------------"                                                                                                                                                    
    list_query25=utility.convertDictToList(query25)
    list_query26=utility.convertDictToList(query26)
    list_query27=utility.convertDictToList(query27)
    print "---------------------"    
    print "Getting box-plots done for F-I-L-E interleaving values in File Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query25, list_query26, list_query27, "File_Values_In_File_Corr")    
    print "---------------------"            
    # t - test 
    print "doing T-Tests for F-I-L-E interleaving values in File Interleaving Correlation ... " 
    t_25_26, p_25_26 =  utility.doTTest(list_query25, list_query26)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_25_26, p_25_26)    
    t_25_27, p_25_27 =  utility.doTTest(list_query25, list_query27)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_25_27, p_25_27)        
    t_26_27, p_26_27 =  utility.doTTest(list_query26, list_query27)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_26_27, p_26_27)                        
    list_query28=utility.convertDictToList(query28)
    list_query29=utility.convertDictToList(query29)
    list_query30=utility.convertDictToList(query30)
    print "---------------------"                
    # A12 - test 
    print "doing A12 for F-I-L-E interleaving values in File Interleaving Correlation ... " 
    a12_25_26 =  utility.performA12(list_query25, list_query26)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_25_26)    
    a12_25_27 =  utility.performA12(list_query25, list_query27)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_25_27)        
    a12_26_27 =  utility.performA12(list_query26, list_query27)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_26_27)           
    print "---------------------"                                                                                                                         
    print "---------------------"    
    print "Getting box-plots done for P-R-O-J-E-C-T interleaving values in Project Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query28, list_query29, list_query30, "Project_Values_In_Project_Corr")     
    print "---------------------"      
    # t - test 
    print "doing T-Tests for P-R-O-J-E-C-T  interleaving values in Project Interleaving Correlation ... " 
    t_28_29, p_28_29 =  utility.doTTest(list_query28, list_query29)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_28_29, p_28_29)    
    t_28_30, p_28_30 =  utility.doTTest(list_query28, list_query30)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_28_30, p_28_30)        
    t_29_30, p_29_30 =  utility.doTTest(list_query29, list_query30)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_29_30, p_29_30)                                 
    list_query31=utility.convertDictToList(query31)
    list_query32=utility.convertDictToList(query32)
    list_query33=utility.convertDictToList(query33)
    print "---------------------"                
    # A12 - test 
    print "doing A12 for P-R-O-J-E-C-T  interleaving values in Project Interleaving Correlation ... " 
    a12_28_29 =  utility.performA12(list_query28, list_query29)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_28_29)    
    a12_28_30 =  utility.performA12(list_query28, list_query30)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_28_30)        
    a12_29_30 =  utility.performA12(list_query29, list_query30)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_29_30)           
    print "---------------------"                                                                                                                     
    print "---------------------"    
    print "Getting box-plots done for S-T-A-T-E interleaving values in STATE Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query31, list_query32, list_query33, "State_Values_In_State_Corr")   
    print "---------------------"                     
    # t - test 
    print "doing T-Tests for S-T-A-T-E interleaving values in STATE Interleaving  Correlation ... " 
    t_31_32, p_31_32 =  utility.doTTest(list_query31, list_query32)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_31_32, p_31_32)    
    t_31_33, p_31_33 =  utility.doTTest(list_query31, list_query33)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_31_33, p_31_33)        
    t_32_33, p_32_33 =  utility.doTTest(list_query32, list_query33)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_32_33, p_32_33)  
    print "---------------------"                
    # A12 - test 
    print "doing A12 for S-T-A-T-E interleaving values in STATE Interleaving Correlation ... " 
    a12_31_32 =  utility.performA12(list_query31, list_query32)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_31_32)    
    a12_31_33 =  utility.performA12(list_query31, list_query33)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_31_33)        
    a12_32_33 =  utility.performA12(list_query32, list_query33)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_32_33)           
    print "---------------------"                                                                                                                 
                                   
    list_query34=utility.convertDictToList(query34)
    list_query35=utility.convertDictToList(query35)
    list_query36=utility.convertDictToList(query36) 
    print "---------------------"    
    print "Getting box-plots done for N-A-M-E-S-P-A-C-E interleaving values in NAMESPACE Interleaving Correlation ... "         
    plotter.compareViaBoxPlot(list_query34, list_query35, list_query36, "Namespace_Values_In_Namespace_Corr")    
    print "---------------------"                
    # t - test 
    print "doing T-Tests for N-A-M-E-S-P-A-C-E interleaving values in NAMESPACE Interleaving  Correlation ... " 
    t_34_35, p_34_35 =  utility.doTTest(list_query34, list_query35)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> t: {}, p:{}".format(t_34_35, p_34_35)    
    t_34_36, p_34_36 =  utility.doTTest(list_query34, list_query36)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_34_36, p_34_36)        
    t_35_36, p_35_36 =  utility.doTTest(list_query35, list_query36)
    print " 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> t: {}, p:{}".format(t_35_36, p_35_36)   




    print "---------------------"                
    # A12 - test 
    print "doing A12 for N-A-M-E-S-P-A-C-E interleaving values in NAMESPACE Interleaving Correlation ... " 
    a12_34_35 =  utility.performA12(list_query34, list_query35)
    print "Corr >= 0.50 vs 0.0 <= Corr <= 0.499 =====> a12: {}".format(a12_34_35)    
    a12_34_36 =  utility.performA12(list_query34, list_query36)
    print "Corr >= 0.50 vs  Corr < 0.0 =====> a12: {}".format(a12_34_36)        
    a12_35_36 =  utility.performA12(list_query35, list_query36)
    print "Corr 0.499 >= Corr >= 0.0 vs  Corr < 0.0 =====> a12: {}".format(a12_35_36)           
    print "---------------------"                                                                                                                 
示例#18
0
def getAllCorrelationCategories():
    import db_queries, utility
    res = []
    res = utility.convertDictToList(db_queries.getAllCorrelationCategories())
    return res