data.info()

data.describe(include=[np.number])

data.describe(include=object)

data.game_results()

data.results_by_team("Winner", "Wins")

data.results_by_team("Loser", "Losses")

data.team_goals("Home_Team_Score", "Home Team")

data.team_goals("Away_Team_Score", "Away Team")

team_blue = 'Universidad de Chile' team_white = 'Colo Colo' data_classic = data.query("(Home_Team == @team_blue & Away_Team == @team_white) | (Home_Team == @team_white & Away_Team == @team_blue)") data_classic.head()

data_classic.classic_results()

data_classic.classic_wins_awayORhome(result='Home_Team')

data_classic.classic_wins_awayORhome(result="Away_Team")

team_blue = 'Universidad de Chile' team_white = 'Universidad Catolica' data_U_classic = data.query("(Home_Team == @team_blue & Away_Team == @team_white) | (Home_Team == @team_white & Away_Team == @team_blue)") data_U_classic.head()

data_U_classic.classic_results()

data_U_classic.classic_wins_awayORhome(result='Home_Team')

data_U_classic.classic_wins_awayORhome(result='Away_Team')