we must always redistribute knowledge — Nandy
A few things before I start this guide- I’ll keep this guide short as this one’s intended for those who have a good amount of experience in both Tableau and data prepping. There might be parts you may get stuck in, but for every doubt, there is usually always a Google search to provide a solution and me, who’s always ready to help you out on Twitter.
When I came up with this template, I tired to get it as similar to the folks at StatsPerform and most of the formulas were taken…
Convex hulls are very easy to do in R, the following graphic can be produced in just 5 lines of code. This guide tells you how to make the very same graphic by integrating R with Tableau.
x = df[c('endX','endY')]ch <- chull(x)
coords <- x[c(ch, ch), ]plot(x, pch=19, col = 'blue')
polygon(coords, col = rgb(0,0,1,alpha = 0.1))
Do read the CRAN docs , here if you wish to understand the package in more detail.
‘The gaffer has entrusted him with more freedom today’ , ‘he has been given the creative license, let’s see what he does’. Freedom in football is common parlance. It’s usually associated with creative midfielders who move into channels to receive passes. Still despite being such an easily understandable concept, there isn’t exactly a way to definitively say that ‘player X’ has more freedom than ‘Player Y’.
I propose a new Metric, called FR (Freedom Rating) that puts a mathematical number behind how free a player’s role truly is.
Ok maybe the guys over at statsbomb already have something like this…
Do you want x and y coordinate data for one team’s shots in any particular season. Well, you can do that in just 5 lines of R code. Commence copy-paste
Step 1: Install this library from Ewen and load it up
#install the library from github
Step 2 : Extract team data by mentioning your desired team within the quotations. Also mention the season you want. 2019 corresponds to 2019/20, 2018 to 2018/19 and so on. I chose Real Madrid and 2019.
rm = get_team_players_stats("Real Madrid",2019) #enter team name within quotations and season required
Step 3: Create a…
I recommend reading TabGuide #1 to get you up-to grips with some of the techniques mentioned here. This is a much longer piece and will have more parts to it. Thanks for dropping by :)
To make a pass-map in Tableau, all you need your data to have are four values- X and Y coordinates for the start location of the pass and the end location of the pass. Most importantly, you need a unique identifier like event ID. Ideally, you’d also need the player who made the pass and the player who received the pass and maybe the length…
To get started, all your data needs to have are X and Y coordinates for the shot locations. Anything apart from that like xG and shot outcome is great as well.
If you already have data from another provider, that’s great. Here’s a 5 line code on R from ewenme that can help you scrape shot location data since the 2014 season from understat. All you need to do is find the number for your particular player and then run the code attached below.
#install the library from github
remotes::install_github('ewenme/understatr')library(understatr)data1 = get_player_shots(499) #insert playerID heresetwd("~/Downloads") #set your…
This season was another roller-coaster with Champions League football being secured only on the last match of the season. Having said that, the only way forward from this point is up, and no matter what happens in the 2019–20 summer mercato, this season will have high expectations, to the levels of which haven’t been seen at the San Siro for many years. I would also like to take this opportunity to thank you for all the support that has been shown on the series, and this will be the final part of the series. …
From being one goal away from the Champions League knockouts to an early exit from the Europa League; from Mauro Icardi gifting the team Rolex watches to the Curva disowning him, from #SpallettiIn to #SpallettiOut, this season has been a roller-coaster ride to the say the least.
Inter still have to ensure top-four qualification and with the last six games including matches against AS Roma, Napoli and Juventus, things could get tricky. Another hot topic among the fans is the alleged 9 million euro deal to be offered to Antonio Conte. …
Xavi’s greatness, Well documented
Amongst few, He’s resented
Amongst Many, He’s respected
His departure Could have been extended
The board’s antics Could have been prevented
His lack of a successor left the fans disoriented
He was one of the greatest despite not being multi-talented
Rather than be the jack of all trades, he was the master of a field which he reinvented.
We all know that Xavi was not the most physically gifted, or the most versatile dribbler. What made him stand out was his passing ability. But that would be a misconception. …
Roberto Firmino’s role in Liverpool’s offence is well-documented, he’s been heralded as the ‘Modern Day False 9’ and rightfully so. Arguably, the most complex role in football is the False 9. It is easy to claim that it’s all about dropping deep and playing more as a midfielder, but in reality, it is a lot more complex. It involves timing, understanding of the game, versatility and traditional striker roles like hold-up. There are very few players who have mastered the False 9 role such as Francesco Totti, Karim Benzema and Lionel Messi, in particular, who redefined it.
In Italy, managers…