Architecture

Jfjelstul Worldcup Data-csv Appearances.csv -

Jfjelstul Worldcup Data-csv Appearances.csv -

1. Overview The appearances.csv file records every single player appearance in a FIFA World Cup match (men’s tournament). Each row corresponds to one player in one match , including detailed performance statistics (goals, cards, substitutions, etc.).

# Filter only starters (not substitutes) starters = appearances[appearances["substitute"] == False] starters["total_cards"] = starters["yellow_cards"] + starters["red_cards"] cards_by_player = starters.groupby(["player_id", "position_name"])["total_cards"].sum().reset_index() Merge player names players = pd.read_csv("players.csv") disciplinary = cards_by_player.merge(players[["player_id", "family_name", "given_name"]], on="player_id") Pick top card-takers per position disciplinary.sort_values(["position_name", "total_cards"], ascending=False).groupby("position_name").head(2) 8. Citation & Acknowledgments If you use this data in research or a publication: Fjelstul, J. (2023). The World Cup Database. GitHub. https://github.com/jfjelstul/worldcup BibTeX: jfjelstul worldcup data-csv appearances.csv

@miscfjelstul2023worldcup, author = Joshua C. Fjelstul, title = The World Cup Database, year = 2023, publisher = GitHub, url = https://github.com/jfjelstul/worldcup # Filter only starters (not substitutes) starters =

jfjelstul worldcup data-csv appearances.csv
About me
ArchEyes editorial team is a collective of architects, journalists, and critics passionate about architecture that shapes cultures and generations. With expertise spanning design, engineering, and education, they have taught at institutions such as the Technical University of Madrid, École Nationale d'Architecture de Tétouan, and Tecnológico de Monterrey.

3 comments

  • jfjelstul worldcup data-csv appearances.csv
  • jfjelstul worldcup data-csv appearances.csv

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.