def createTeams():
list = dataExtraction.readStockDataFromFile("E0")
for row in list:
if teamMap.has_key(row[2]) != true:
t = Team(row[2])
teamMap[row[2]] = t
if teamMap.has_key(row[3]) != true:
t = Team(row[3])
teamMap[row[3]] = t
#aggregate values to home team
teamMap[row[2]].aggGoalDiff(row[4]-row[5])
won = 0
if (row[6] == 'H')
won = 1
lost = 0
if (row[6] == 'A')
lost = 1
teamMap[row[2]].aggWonGames(won)
teamMap[row[2]].aggWonLostDiff(lost)
teamMap[row[2]].aggShots(row[11])
teamMap[row[2]].aggShotsOnGoal(row[13])
teamMap[row[2]].aggShotsWoodwork(0)#N/A
teamMap[row[2]].aggCorners(row[17])
teamMap[row[2]].aggFouls(row[15])
teamMap[row[2]].aggOffsides(0)#N/A
teamMap[row[2]].aggYellowCards(row[19])
teamMap[row[2]].aggRedCards(row[21])
teamMap[row[2]].setOdds()#function for average odds
#aggregate values to away team
teamMap[row[3]].aggGoalDiff(-1*(row[4]-row[5]))
teamMap[row[3]].aggWonGames(lost)
teamMap[row[3]].aggWonLostDiff(won)
teamMap[row[3]].aggShots(row[12])
teamMap[row[3]].aggShotsOnGoal(row[14])
teamMap[row[3]].aggShotsWoodwork(0)#N/A
teamMap[row[3]].aggCorners(row[18])
teamMap[row[3]].aggFouls(row[16])
teamMap[row[3]].aggOffsides(0)#N/A
teamMap[row[3]].aggYellowCards(row[20])
teamMap[row[3]].aggRedCards(row[22])
teamMap[row[3]].setOdds()#function for average odds
import os
import sys
sys.path.append(
os.path.abspath(os.path.join(os.path.dirname(__file__), '..', 'src')))
import dataExtraction
dataExtraction.pull_historical_data("E0.csv")
dataExtraction.readDataFromExcel("E0")
list = dataExtraction.readStockDataFromFile("E0")
print list[1]
import os
import sys
sys.path.append(os.path.abspath(os.path.join(os.path.dirname( __file__ ), '..', 'src')))
import dataExtraction
dataExtraction.pull_historical_data("E0.csv")
dataExtraction.readDataFromExcel("E0")
list = dataExtraction.readStockDataFromFile("E0")
print list[1]
