import csv
import math
graph = Graph("http://*****:*****@localhost:7474/db/data/")
i=5
number=6
with open('../csv/eggs%s.csv'%number,'wb') as csvfile:
writer=csv.writer(csvfile, delimiter=',',quotechar='{')
writer.writerow(['Domain Class','CCS Score','DCS Score', 'Table','Overall Score'])
theTable=[]
domains={}
numberOfColumns=Neo4jDrive.findTotalNumberOfColumns()[0][0]
for record in graph.cypher.execute("MATCH (n) where n.hyp='yes' return n.name, n.ccs, n.DCS"):
domain=record[0]
ccs=record[1]
dcs=(Neo4jDrive.findNumberOfColumns(domain)[0][0]*1.0)/numberOfColumns
r=[]
table=Neo4jDrive.tableMembership(domain)
if ccs!=None and dcs!=None and ccs!=0 and dcs!=0:
csvs=math.sqrt((ccs*ccs)+(dcs*dcs))
entropy=-(ccs)/(ccs+dcs)*math.log(ccs/(ccs+dcs))-(dcs)/(ccs+dcs)*math.log(dcs/(ccs+dcs))
overall=csvs*entropy*table
else:
overall='-'
domains[domain]=overall
r.append(domain)
r.append(ccs)
r.append(dcs)
r.append(table)
r.append(overall)
theTable+=[r]
graph = Graph("http://*****:*****@localhost:7474/db/data/")
i = 5
number = 6
with open('../csv/eggs%s.csv' % number, 'wb') as csvfile:
writer = csv.writer(csvfile, delimiter=',', quotechar='{')
writer.writerow(
['Domain Class', 'CCS Score', 'DCS Score', 'Table', 'Overall Score'])
theTable = []
domains = {}
numberOfColumns = Neo4jDrive.findTotalNumberOfColumns()[0][0]
for record in graph.cypher.execute(
"MATCH (n) where n.hyp='yes' return n.name, n.ccs, n.DCS"):
domain = record[0]
ccs = record[1]
dcs = (Neo4jDrive.findNumberOfColumns(domain)[0][0] *
1.0) / numberOfColumns
r = []
table = Neo4jDrive.tableMembership(domain)
if ccs != None and dcs != None and ccs != 0 and dcs != 0:
csvs = math.sqrt((ccs * ccs) + (dcs * dcs))
entropy = -(ccs) / (ccs + dcs) * math.log(
ccs /
(ccs + dcs)) - (dcs) / (ccs + dcs) * math.log(dcs /
(ccs + dcs))
overall = csvs * entropy * table
else:
overall = '-'
domains[domain] = overall
r.append(domain)
r.append(ccs)
