Dataset: AFL Fantasy Points - 2022 Season

About this Dataset

AFL Fantasy Points - 2022 Season

Context

I wanted to study player stats for Australian Rules Football (AFL), using Machine Learning to identify who the key players are, predict performance and results. My aim is to create the Ultimate Tipping predictor or maybe a Fantasy League tool. I couldn't find a dataset anywhere so I created my own GCD project and am sharing the database for anybody to explore.

Content

Every key stat from Kicks to Clangers to Bounces. Every player, game by game.

Tables

Playerdata

@kaggle.iampunitkmryh_afl_fantasy_points_2022_season.playerdata

323.33 KB
811 rows
150 columns


CREATE TABLE playerdata (
  "unnamed_0" BIGINT,
  "playerid" VARCHAR,
  "gamesplayed" DOUBLE,
  "playerdetails_givenname" VARCHAR,
  "playerdetails_surname" VARCHAR,
  "playerdetails_age" BIGINT,
  "playerdetails_heightcm" BIGINT,
  "playerdetails_weightkg" BIGINT,
  "playerdetails_jumpernumber" BIGINT,
  "playerdetails_kickingfoot" VARCHAR,
  "playerdetails_stateoforigin" VARCHAR,
  "playerdetails_draftyear" BIGINT,
  "playerdetails_debutyear" DOUBLE,
  "playerdetails_recruitedfrom" VARCHAR,
  "playerdetails_draftposition" DOUBLE,
  "playerdetails_drafttype" VARCHAR,
  "playerdetails_position" VARCHAR,
  "playerdetails_bio" VARCHAR,
  "playerdetails_aflawards" VARCHAR,
  "playerdetails_photourl" VARCHAR,
  "playerdetails_dateofbirth" TIMESTAMP,
  "team_teamid" VARCHAR,
  "team_teamabbr" VARCHAR,
  "team_teamname" VARCHAR,
  "team_teamnickname" VARCHAR,
  "totals_matchesplayed" DOUBLE,
  "totals_timeongroundpercentage" DOUBLE,
  "totals_behinds" DOUBLE,
  "totals_bounces" DOUBLE,
  "totals_centrebounceattendances" DOUBLE,
  "totals_centreclearances" DOUBLE,
  "totals_clangers" DOUBLE,
  "totals_contestdeflosses" DOUBLE,
  "totals_contestdeflosspercentage" DOUBLE,
  "totals_contestdefoneonones" DOUBLE,
  "totals_contestedmarks" DOUBLE,
  "totals_contestedpossessionrate" DOUBLE,
  "totals_contestedpossessions" DOUBLE,
  "totals_contestoffoneonones" DOUBLE,
  "totals_contestoffwins" DOUBLE,
  "totals_contestoffwinspercentage" DOUBLE,
  "totals_defhalfpressureacts" DOUBLE,
  "totals_disposalefficiency" DOUBLE,
  "totals_disposals" DOUBLE,
  "totals_dreamteampoints" DOUBLE,
  "totals_effectivedisposals" DOUBLE,
  "totals_effectivekicks" DOUBLE,
  "totals_f50groundballgets" DOUBLE,
  "totals_freesagainst" DOUBLE,
  "totals_freesfor" DOUBLE,
  "totals_goalaccuracy" DOUBLE,
  "totals_goalassists" DOUBLE,
  "totals_goals" DOUBLE,
  "totals_groundballgets" DOUBLE,
  "totals_handballs" DOUBLE,
  "totals_hitouts" DOUBLE,
  "totals_hitoutstoadvantage" DOUBLE,
  "totals_hitouttoadvantagerate" DOUBLE,
  "totals_hitoutwinpercentage" DOUBLE,
  "totals_inside50s" DOUBLE,
  "totals_interceptmarks" DOUBLE,
  "totals_intercepts" DOUBLE,
  "totals_kickefficiency" DOUBLE,
  "totals_kickins" DOUBLE,
  "totals_kickinsplayon" DOUBLE,
  "totals_kicks" DOUBLE,
  "totals_kicktohandballratio" DOUBLE,
  "totals_marks" DOUBLE,
  "totals_marksinside50" DOUBLE,
  "totals_marksonlead" DOUBLE,
  "totals_metresgained" DOUBLE,
  "totals_onepercenters" DOUBLE,
  "totals_pressureacts" DOUBLE,
  "totals_ranking" DOUBLE,
  "totals_ratingpoints" DOUBLE,
  "totals_rebound50s" DOUBLE,
  "totals_ruckcontests" DOUBLE,
  "totals_scoreinvolvements" DOUBLE,
  "totals_scorelaunches" DOUBLE,
  "totals_shotsatgoal" DOUBLE,
  "totals_spoils" DOUBLE,
  "totals_stoppageclearances" DOUBLE,
  "totals_tackles" DOUBLE,
  "totals_tacklesinside50" DOUBLE,
  "totals_totalclearances" DOUBLE,
  "totals_totalpossessions" DOUBLE,
  "totals_turnovers" DOUBLE,
  "totals_uncontestedpossessions" DOUBLE,
  "averages_matchesplayed" DOUBLE,
  "averages_timeongroundpercentage" DOUBLE,
  "averages_behinds" DOUBLE,
  "averages_bounces" DOUBLE,
  "averages_centrebounceattendances" DOUBLE,
  "averages_centreclearances" DOUBLE,
  "averages_clangers" DOUBLE,
  "averages_contestdeflosses" DOUBLE,
  "averages_contestdeflosspercentage" DOUBLE,
  "averages_contestdefoneonones" DOUBLE,
  "averages_contestedmarks" DOUBLE,
  "averages_contestedpossessionrate" DOUBLE
);