def testSpreadsheetDataCompare4c(self): sp=SpreadsheetData(data=[[i*0.5,math.sin(i)] for i in range(10)],names=['t','val']) sp2=SpreadsheetData(data=[[i*0.5,math.sin(i)+0.5] for i in range(10)],names=['t','val']) diff1=sp.compare(sp2,"val") diff2=sp2.compare(sp,"val") self.assertAlmostEqual(diff1["max"],diff2["max"]) self.assertAlmostEqual(diff1["average"],diff2["average"]) self.assertAlmostEqual(diff1["wAverage"],diff2["wAverage"]) self.assertAlmostEqual(diff1["average"],diff1["wAverage"])
def testSpreadsheetDataCompare4f(self): sp=SpreadsheetData(data=[[i*0.5,i*0.5] for i in range(10)],names=['t','val']) sp2=SpreadsheetData(data=[[i*0.5-0.25,i*0.5-0.25] for i in range(10)],names=['t','val']) diff3=sp.compare(sp2,"val",common=True) diff4=sp2.compare(sp,"val",common=True) self.assertAlmostEqual(diff3["max"],diff4["max"]) self.assertAlmostEqual(diff3["average"],diff4["average"]) self.assertAlmostEqual(diff3["wAverage"],diff4["wAverage"]) self.assertAlmostEqual(diff3["average"],diff3["wAverage"]) self.assertAlmostEqual(diff4["average"],diff4["wAverage"])
def testSpreadsheetDataCompare4b(self): sp = SpreadsheetData(data=[[i * 0.5, 1 + i * i] for i in range(10)], names=['t', 'val']) sp2 = SpreadsheetData(data=[[i * 0.5, 2 + i * i] for i in range(10)], names=['t', 'val']) diff1 = sp.compare(sp2, "val") diff2 = sp2.compare(sp, "val") self.assertAlmostEqual(diff1["max"], diff2["max"]) self.assertAlmostEqual(diff1["average"], diff2["average"]) self.assertAlmostEqual(diff1["wAverage"], diff2["wAverage"]) self.assertAlmostEqual(diff1["average"], diff1["wAverage"])
def testSpreadsheetDataCompare3(self): sp = SpreadsheetData(data=data6, names=names3) sp2 = SpreadsheetData(data=data7, names=names4) diff1 = sp.compare(sp2, "val") self.assertAlmostEqual(diff1["max"], 0) self.assertAlmostEqual(diff1["average"], 0) self.assertAlmostEqual(diff1["wAverage"], 0) diff2 = sp2.compare(sp, "val") self.assertAlmostEqual(diff2["max"], 0.5) self.assertAlmostEqual(diff2["average"], 0.09090909) self.assertAlmostEqual(diff2["wAverage"], 0.05)
def testSpreadsheetDataCompare2(self): sp = SpreadsheetData(data=data3, names=names3) sp2 = SpreadsheetData(data=data5, names=names4) diff1 = sp.compare(sp2, "val") self.assertAlmostEqual(diff1["max"], 0.25) self.assertAlmostEqual(diff1["average"], 0.25) self.assertAlmostEqual(diff1["wAverage"], 0.25) diff2 = sp2.compare(sp, "val") self.assertAlmostEqual(diff2["max"], 9.25) self.assertAlmostEqual(diff2["average"], 1.0681818181) self.assertAlmostEqual(diff2["wAverage"], 0.7)
def testSpreadsheetDataCompare3(self): sp=SpreadsheetData(data=data6,names=names3) sp2=SpreadsheetData(data=data7,names=names4) diff1=sp.compare(sp2,"val") self.assertAlmostEqual(diff1["max"],0) self.assertAlmostEqual(diff1["average"],0) self.assertAlmostEqual(diff1["wAverage"],0) diff2=sp2.compare(sp,"val") self.assertAlmostEqual(diff2["max"],0.5) self.assertAlmostEqual(diff2["average"],0.09090909) self.assertAlmostEqual(diff2["wAverage"],0.05)
def testSpreadsheetDataCompare2(self): sp=SpreadsheetData(data=data3,names=names3) sp2=SpreadsheetData(data=data5,names=names4) diff1=sp.compare(sp2,"val") self.assertAlmostEqual(diff1["max"],0.25) self.assertAlmostEqual(diff1["average"],0.25) self.assertAlmostEqual(diff1["wAverage"],0.25) diff2=sp2.compare(sp,"val") self.assertAlmostEqual(diff2["max"],9.25) self.assertAlmostEqual(diff2["average"],1.0681818181) self.assertAlmostEqual(diff2["wAverage"],0.7)
def testSpreadsheetDataCompare4f(self): sp = SpreadsheetData(data=[[i * 0.5, i * 0.5] for i in range(10)], names=['t', 'val']) sp2 = SpreadsheetData(data=[[i * 0.5 - 0.25, i * 0.5 - 0.25] for i in range(10)], names=['t', 'val']) diff3 = sp.compare(sp2, "val", common=True) diff4 = sp2.compare(sp, "val", common=True) self.assertAlmostEqual(diff3["max"], diff4["max"]) self.assertAlmostEqual(diff3["average"], diff4["average"]) self.assertAlmostEqual(diff3["wAverage"], diff4["wAverage"]) self.assertAlmostEqual(diff3["average"], diff3["wAverage"]) self.assertAlmostEqual(diff4["average"], diff4["wAverage"])
def testSpreadsheetDataCompare1(self): sp = SpreadsheetData(data=data3, names=names3) sp2 = SpreadsheetData(data=data4, names=names4) diff1 = sp.compare(sp2, "val") self.assertAlmostEqual(diff1["max"], 1) self.assertAlmostEqual(diff1["average"], 1) self.assertAlmostEqual(diff1["wAverage"], 1) diff2 = sp2.compare(sp, "val") self.assertEqual(diff1["max"], diff2["max"]) self.assertEqual(diff1["average"], diff2["average"]) self.assertEqual(diff1["wAverage"], diff2["wAverage"]) diff3 = sp.compare(sp, "val") self.assertAlmostEqual(diff3["max"], 0) self.assertAlmostEqual(diff3["average"], 0) self.assertAlmostEqual(diff3["wAverage"], 0)
def testSpreadsheetDataCompare1(self): sp=SpreadsheetData(data=data3,names=names3) sp2=SpreadsheetData(data=data4,names=names4) diff1=sp.compare(sp2,"val") self.assertAlmostEqual(diff1["max"],1) self.assertAlmostEqual(diff1["average"],1) self.assertAlmostEqual(diff1["wAverage"],1) diff2=sp2.compare(sp,"val") self.assertEqual(diff1["max"],diff2["max"]) self.assertEqual(diff1["average"],diff2["average"]) self.assertEqual(diff1["wAverage"],diff2["wAverage"]) diff3=sp.compare(sp,"val") self.assertAlmostEqual(diff3["max"],0) self.assertAlmostEqual(diff3["average"],0) self.assertAlmostEqual(diff3["wAverage"],0)
def testSpreadsheetDataCompare5(self): sp = SpreadsheetData(data=[[i * 0.5, 1] for i in range(10)], names=['t', 'val']) diff = sp.compare(sp, "val") self.assertAlmostEqual(diff["max"], 0) self.assertAlmostEqual(diff["average"], 0) self.assertAlmostEqual(diff["wAverage"], 0)
def testSpreadsheetDataCompare6(self): sp=SpreadsheetData(data=[[i*0.5,1] for i in range(10)],names=['t','val']) sp2=SpreadsheetData(data=[[i*0.5+10,2] for i in range(10)],names=['t','val']) diff1=sp.compare(sp2,"val") diff2=sp2.compare(sp,"val") self.assertAlmostEqual(diff1["max"],1) self.assertAlmostEqual(diff1["average"],1) self.assertAlmostEqual(diff1["wAverage"],1) self.assertAlmostEqual(diff2["max"],1) self.assertAlmostEqual(diff2["average"],1) self.assertAlmostEqual(diff2["wAverage"],1) diff1=sp.compare(sp2,"val",common=True) diff2=sp2.compare(sp,"val",common=True) self.assertEqual(diff1["max"],None) self.assertEqual(diff1["average"],None) self.assertEqual(diff1["wAverage"],None) self.assertEqual(diff2["max"],None) self.assertEqual(diff2["average"],None) self.assertEqual(diff2["wAverage"],None)
def testSpreadsheetDataCompare6(self): sp = SpreadsheetData(data=[[i * 0.5, 1] for i in range(10)], names=['t', 'val']) sp2 = SpreadsheetData(data=[[i * 0.5 + 10, 2] for i in range(10)], names=['t', 'val']) diff1 = sp.compare(sp2, "val") diff2 = sp2.compare(sp, "val") self.assertAlmostEqual(diff1["max"], 1) self.assertAlmostEqual(diff1["average"], 1) self.assertAlmostEqual(diff1["wAverage"], 1) self.assertAlmostEqual(diff2["max"], 1) self.assertAlmostEqual(diff2["average"], 1) self.assertAlmostEqual(diff2["wAverage"], 1) diff1 = sp.compare(sp2, "val", common=True) diff2 = sp2.compare(sp, "val", common=True) self.assertEqual(diff1["max"], None) self.assertEqual(diff1["average"], None) self.assertEqual(diff1["wAverage"], None) self.assertEqual(diff2["max"], None) self.assertEqual(diff2["average"], None) self.assertEqual(diff2["wAverage"], None)
def testSpreadsheetDataCompare4d(self): sp = SpreadsheetData(data=[[i * 0.5, math.sin(i)] for i in range(10)], names=['t', 'val']) sp2 = SpreadsheetData(data=[[i * 0.5 - 0.5, math.sin(i - 1) + 0.5] for i in range(11)], names=['t', 'val']) diff1 = sp.compare(sp2, "val") diff2 = sp2.compare(sp, "val") self.assertAlmostEqual(diff1["max"], diff2["max"]) # self.assertAlmostEqual(diff1["average"],diff2["average"]) # self.assertAlmostEqual(diff1["wAverage"],diff2["wAverage"]) self.assertAlmostEqual(diff1["average"], diff1["wAverage"]) # self.assertAlmostEqual(diff2["average"],diff2["wAverage"]) diff3 = sp.compare(sp2, "val", common=True) diff4 = sp2.compare(sp, "val", common=True) self.assertAlmostEqual(diff3["max"], diff4["max"]) self.assertAlmostEqual(diff3["average"], diff4["average"]) self.assertAlmostEqual(diff3["wAverage"], diff4["wAverage"]) self.assertAlmostEqual(diff3["average"], diff3["wAverage"]) self.assertAlmostEqual(diff4["average"], diff4["wAverage"])
def testSpreadsheetDataCompare5(self): sp=SpreadsheetData(data=[[i*0.5,1] for i in range(10)],names=['t','val']) diff=sp.compare(sp,"val") self.assertAlmostEqual(diff["max"],0) self.assertAlmostEqual(diff["average"],0) self.assertAlmostEqual(diff["wAverage"],0)