initialize_vertex.py 581 Bytes
Edit Raw Blame History



1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22


import csv, re, sqlite3

con = sqlite3.connect("database2.db")
cur = con.cursor()
fX = open("xvertex_init", "w+")
fY = open("yvertex_init", "w+")

toWriteX = ''
toWriteY = ''

for i in range(0, 1373):

	cur.execute("SELECT sum(x)/count(x) FROM vertex where ug like "+str(i))
	result = cur.fetchall()
	toWriteX = str(result[0]).replace(')','').replace('(','')	
	
	cur.execute("SELECT sum(y)/count(y) FROM vertex where ug like "+str(i))
	result = cur.fetchall()
	toWriteY = str(result[0]).replace(')','').replace('(','')
	
	fX.write(toWriteX[:-1]+"\n")
	fY.write(toWriteY[:-1]+"\n")