import psycopg2
import sys
import csv
from itertools import count
path = r'C:UserssammyDownloadsE0.csv'
with open(path, "r") as csvfile:
    readCSV = csv.reader(csvfile, delimiter=",")
    firstline = 1
    con = None
    con = psycopg2.connect("host='localhost' dbname='football' user='postgres' password='XXX'")
    cur = con.cursor()
    cur.execute("DROP TABLE Referees")
    cur.execute("CREATE TABLE Referees (RefereeID VARCHAR, RefereeName VARCHAR)")

    try:
        for row in readCSV:
            if firstline:
                firstline=0
                continue
            RefereeID = row[10]
            RefereeName = row[10]
            data = (RefereeID, RefereeName)
            query = "INSERT INTO Referees (RefereeID, RefereeName) VALUES (%s, %s);"
            print (RefereeID)
            print (RefereeName)
            cursor = con.cursor()
            cursor.execute(query, data)
    except psycopg2.DatabaseError as e:
        if con:
            con.rollback()
            print ("Error %s % e", e)
            sys.exit(1)
    finally:
        if con:
            con.commit()
            con.close()

print(" ".join(row))
out=open("new_data.csv", "w")
output = csv.writer(out)

for row in data:
    output.writerow(row)

out.close()

path = r'C:UserssammyDownloadsE0.csv'
with open(path, "r") as csvfile:
    readCSV = csv.reader(csvfile, delimiter=",")

    refereename= []

    class Teams:
         for row in readCSV:
            referee= row[10]
            refereename.append(referee)

        for x in refereename:
            if x not in uniquerefereename:
                uniquerefereename.append(x)

 print (refereename)
print (uniquerefereename)

 refereesorted= sorted(uniquerefereename)

 print (refereesorted)