there is misalignment between what varible definition defines what is on dataset columns and actual values on data set columns ie
In variable definition :
Team --- > Name of home team
but the validity of this statment is not always true in some cases like :
train_df[(train_df['Season'] == 1) & (train_df['Game_ID'] == 'ID_KAG4KAE9')]['Team'].unique()
can i get some explanation .......?
another interesting add_on :
train_df[(train_df['Season'] == 1) & (train_df['Game_ID'] == 'ID_KAG4KAE9')]['Opposition_Team'].unique()
how can "oppostion team " and "Team" returns the same unique lists?.......
Let's assume that we have three teams in a league named A, B and C.
First match A vs B
Second match B vs C
Third match C vs A
Each team has played two matches. The list of teams before vs (team) is the same as the list of teams after vs (opposition). This is my understanding of the setup hence the same unique list.
I could be wrong and I am very much open to further discussion on this.