Jfjelstul Worldcup Data-csv Appearances.csv

| File | Join column(s) | Purpose | |------|----------------|---------| | matches.csv | match_id | Match date, stadium, score, stage (group, final, etc.) | | players.csv | player_id | Player birth date, height, FIFA player URL | | teams.csv | team_id | Confederation (UEFA, CONMEBOL, etc.) | | goals.csv | match_id + player_id | Detailed goal times, types (penalty, own goal, etc.) | | cards.csv | match_id + player_id | Minute of each card |

matches = pd.read_csv("https://raw.githubusercontent.com/jfjelstul/worldcup/master/data-csv/matches.csv") red_cards = appearances[appearances["red_cards"] > 0] merged = red_cards.merge(matches[["match_id", "stage_name"]], on="match_id") print(merged["stage_name"].value_counts()) jfjelstul worldcup data-csv appearances.csv

Fjelstul, J. (2023). The World Cup Database. GitHub. https://github.com/jfjelstul/worldcup | File | Join column(s) | Purpose |

: Using player appearance history and past match outcomes to forecast future World Cup results. GitHub

# Filter only starters (not substitutes) starters = appearances[appearances["substitute"] == False]