get_afltables_stats returns full finals names for 2017 and 2018 seasons

[insightlane]

afltables_data_new <- get_afltables_stats(start_date = "1897-05-07", end_date = Sys.Date())

afltables_data_new %>%

• filter(Season == 2016 & Round == "GF")

A tibble: 44 x 59

Groups: Season, Round, Home.team, Away.team [1]

Season Round Date Local.start.time Venue Attendance Home.team HQ1G HQ1B HQ2G HQ2B HQ3G HQ3B HQ4G HQ4B

1 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 2 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 3 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 4 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 5 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 6 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 7 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 8 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 9 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 10 2016 GF 2016-10-01 1430 M.C.G. 99981 Western Bulld~ 2 0 7 1 9 7 13 11 # ... with 34 more rows, and 44 more variables: Home.score , Away.team , AQ1G , AQ1B , AQ2G , # AQ2B , AQ3G , AQ3B , AQ4G , AQ4B , Away.score , First.name , Surname , ID , # Jumper.No. , Playing.for , Kicks , Marks , Handballs , Goals , Behinds , # Hit.Outs , Tackles , Rebounds , Inside.50s , Clearances , Clangers , Frees.For , # Frees.Against , Brownlow.Votes , Contested.Possessions , Uncontested.Possessions , # Contested.Marks , Marks.Inside.50 , One.Percenters , Bounces , Goal.Assists , # Time.on.Ground.. , Substitute , Umpire.1 , Umpire.2 , Umpire.3 , Umpire.4 , group_id afltables_data_new %>% + filter(Season == 2017 & Round == "Grand Final") # A tibble: 44 x 59 # Groups: Season, Round, Home.team, Away.team [1] Season Round Date Local.start.time Venue Attendance Home.team HQ1G HQ1B HQ2G HQ2B HQ3G HQ3B HQ4G HQ4B 1 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 2 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 3 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 4 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 5 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 6 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 7 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 8 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 9 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 10 2017 Grand Fi~ 2017-09-30 1430 "M.C.G~ 100021 Richmond 2 3 6 4 11 8 16 12 # ... with 34 more rows, and 44 more variables: Home.score , Away.team , AQ1G , AQ1B , AQ2G , # AQ2B , AQ3G , AQ3B , AQ4G , AQ4B , Away.score , First.name , Surname , ID , # Jumper.No. , Playing.for , Kicks , Marks , Handballs , Goals , Behinds , # Hit.Outs , Tackles , Rebounds , Inside.50s , Clearances , Clangers , Frees.For , # Frees.Against , Brownlow.Votes , Contested.Possessions , Uncontested.Possessions , # Contested.Marks , Marks.Inside.50 , One.Percenters , Bounces , Goal.Assists , # Time.on.Ground.. , Substitute , Umpire.1 , Umpire.2 , Umpire.3 , Umpire.4 , group_id

[jimmyday12]

Thanks mate, there are some strange parsing problems with afltables and finals. Thought I had sorted them all but will take a look!

[insightlane]

This one is more around the round names (e.g. 2016 uses "GF" and 2017 uses "Grand Final") etc.