Behind me, there's a tiny christmas tree
and some tinsel!
as well at the roundel, which means that i'm recording this at
christmas time, at the end of 2020
and we're here to talk about the world cup
of Tube Lines
lines on a tube map, at the end of 2020
the last four years
we're gonna analuse all the data, and once and for all come up with
the ultimate ranking
of what ... is your faourite Tube Line?
so here's how it works, for the last fours years
i first did it in 2017, on Twitter
follow me! at Geofftech
ive run the world cup of Tube Lines
or to give it it's proper name
the world cup of lines on the TfL Map
'cause there are eleven tube lines
but then if you add on like, the DLR
all the other modes
and the Cable Car, and TfL Rail
there's sixteen modes in all
Thameslink, featured this year
we'll get to that in a second
i first ran it in 2017
and what it is, if you're not a twitter user
there's an option on twitter where you can just run a poll
four options, and in 2017
just for fun, i didn't think it would become an annual event
i did the world cup of Tube Lines
and that year
i didn't seed
any of the lines, i just put sixteen into a hat and pulled them out at random
and the Jubilee, beat the Victoria
i ber your pardon! the Victoria beat the Jubilee
and won, in 2017
people loved it, people got really involved and engaged
people said can you do it again
so i did, in 2018 i re-ran
world cup of tube lines again it was a jubilee versus victoria final
the Jubilee actually won this time
so one to the Victoria, one to the Jubilee
and i started to think "that's interesting, those two always get to the final"
can we actually separate them?
i ran it again
in 2019
jubilee got to the third / fourth place playoffs
interestingly, the Victoria
played the DLR in the final, and the Victoria won
so the Victoria line has now won twice
and the Jublee once, and then ...
we had, this year
the world cup of lines on the TfL Map in 2020
a slight anomalie, because Thameslink was back on the map
i knew it was coming back in October / November when i did this
i introduced that
instead of the Waterloo and City line
which is currently closed, and Thameslink actually got all the way through
to the final
we'll discuss this in a minute, and won!
it was a Thameslink versus DLR final, so the DLR was in the final
and the Jubilee and Victoria were up there again
in third and fourth place
for the third and fourth place playoff
but this year more than ever, loads more people voted than ever
loads got engaged on twitter
i was great, and i realised that i now had
four years worth
of data in a spreadsheet, and i thought surely i can do something with this?
and i opened up Excel
and i looked at all the data, and then i thought
i'm much better at making videos
about transport, then i am ...
... at crunching Excel data
fortunately, i know a man
who eats
excel spreadsheets for breakfast
i got in touch with him and my friend Matt Parker
standupmaths, and i said "can you have a look at my data?"
he said sure
send it over
thanks Geoff
hello eveyone, it's me Matt Parker
your friendly neighbourhood mathmetician
and i've taken Geoff's spreadsheet
i've tidied it up a little
and you can see it here, that's what's on my screen
at the moment, i've ... put in
RGB columns
then you, i took the RGB
colours that Geoff had used when formatting the spreadsheet
and i've actually rigged up my christma tree
so the LEDs on this tree
go the colours
in the order they are on the spreadsheet. at the moment
they're just alphabetical
by the names of the lines
we can do a lot better
so, when i was thinking. what is the ultimate
way ... to rank these
one idea i had was
what if i calcuatled the average
percentage, of votes
that each line got
across all of the ruonds it was in
and each line they're in different numbers of rounds
depending on how successful they are
but i figure, well ...
they're pretty much playing a random selection of the other lines
so it should be reasonably fair
if i just calculate their average percentages
and that's what you can see
in the extra column here
now if we select all of that data
and we're going to sort that range
and oh yes
my data does have a header row
average percentage
we to go, errr
descending, so the best is at the top
sort, and ... there we go!
so the trees updated, so you've got jubilee
little but of grey right at the top
you've then got the Thameslink, which
probably back, you know i can just the numbers of rows that read let's just do
the top five
so we'll have jubilee thameslink
DLR victoria
piccadilly, all ...
wildly different colours
as you can - that was a lot of work
that's not paying off
anyway, that's not a bad way to rank it
and i was pretty happy with that
and Jubilee wins
which kind of makes sense, i did dabble with ...
you may have seen there was another thing called Vote Splits
and if we, sort
by vote split
what i was doing there
was just having a think
of i've got it up the wrong way, don't think so
sort range
ok that's the right way up now, so
this is the top
five, according to
vote split, which is where i just calculated
if, on average
each line got more, or less
than its ... share
of votes, in that round
so if all the votes
were even distributed
each line would rank one
and you can see here, Piccadilly is rankign one point two three
which puts it, at the very top
followed by Thameslink, the Jubilee
Victoria, Bakerloo right at the bottom
and this is weird one
i don't know if this one is fair, because ...
it kind of depends on
how popular the rounds were
and, i feel like this one might be swayed by if
a line was against another very popular line
so basically, the Piccadilly a little surprise winner there
and that's because
the Piccadilly lost
it didn't lose by much
and when it won, it won by a lot
so even though, it's not normally at the top
there's an argument
that the piccadilly was actually the ultimate winner, but the trouble with all these things
i'll go back to average percent
is ... you can argue it
however you want
there's no one definetely, mathematically
certain way to get the ultimate ranking
you just decide ... is is somewhat
of combing these different scores
fair, or not? and that ...
... kind of depends
on what your definition of fair is, so
so i think this is probably the best one
in which case
Jubilee is the ultimate winner
across all of them, i'm prepared to say that
the one thing we can say with no uncertainty
is that consistently
the cable car ... is the worst
there you go
you know what?
let's give cablecar
it's time in the sun, i'm going to delete
every other row, apart from
there it is
the cable car!
that took longer to update than i expected!
back to you Geoff
that's Matt, what's really interesting about that i find
he looked at it in two different ways, is that
i alway had a sense that the Piccadilly was
popular, it does well in high scoring rounds
but doesn't win, so it's very interesting to see that
the Piccadilly is popular, it makes me sort of want to
seed the Piccadilly
against ...
lines which i know it will easily beat
if i do this again next year
and we all know - i'm gonna do this again next year
in 2021 right? because i feel like the Piccadilly
deserves to do better
it's always funn by the way, i never ever stipulate
on what basis you should vote for
a tube, so people always come back to me
and they go "is is the stations? is is the architecture?"
"is it the punctuality?" you know
you can choose, whatever you like
to be your thing about why you voted for that line
people then do
Piccadilly gets a lot of votes because, a lot of Charles Holden stations on there
people vote the Jubilee line because they like the noise of the engines
that is a valid reason for voting
for the jubilee
but i live that people vote for it for different reasons
so we got Matt's data there, i'll be using the
other one, where the Piccadilly doesn't come top
when we do our summary in a minute
but i need to mention some people on twitter
i don't know their real name
but i did get a tweet from someone called "hellgunneR"
on twitter, whilst this was all going on, saying
are you going to analyse, any of this data?
yes i am!
in this video!
they're obviously a bit of a football fan because they talked about coefficients
and the football UEFA method that they use
all i know is that they sent me this spreadsheet
where they'd done some sums
and some maths on it, and they'd come up wth
their own rankings
on what they thought would be
the ultimate 16 ranking list, i'm gonna get to my own rankings in a minute
whilst we're here
i do want to talk about a twist that happened this year
and why we talk about the numbers behind the polls
you only see the percetages, but twitter
boooo! changed
about 18 months ago from old twitter, to new twitter
took us an age to Grrrr! get our head round new twitter
but the good thing about new twitter
is that there's an API, an application programming interface
behind it, if you're clever ... coder
which i'm not! then you can dig in
sort behind the scenes, and into the numbers
and this weird thing happened this year
there was somebody .... on twitter
called FlaiFlai thank you - who first tweeted me
and pointed out that you could dig into twitter
and get the actual numbres if you ever needed to see the numbers
then this amazing thing happened
there's somebody on twitter, his real name is Kishan
i shall throw up his twitter name now
there's another chap called David
i did not know these people, they just started chatting to me
saying, would you like, maybe some sort of
analyst, behind this
and i gather that they all got chatting to each other
one of them did some coding, and the other one went "ooh i like what you did there"
and before i knew it, these guys were collaberating
and they basically built up this amazing website
which gave real-time information
so you could see, whilst the poll was taking place
like the graph, the graph was updating
i think hourly, it was amazing the work they did behind it
they improved it
based on feedback, and now i gather
they're best friends, so ... when i'm doing all this analysis
i'm excluding Thameslink, we do need to give a nod to Thameslink
because i knew Thameslink was going to be on the map this year, and Thameslink actually won!
the reason why ... the GTR social media team
who i talk to, and i'm friendly with
and i did no more than just say
"this is happening"
and then they got on, and i genuinely
genuienly had no idea
my phone dinged, and somebody said
"have you seen this?" and i was like ... "what?"
and basically, GTR had started to put up signs
on passenger information screens at stations saying
"please vote for Thameslink"
"in Geoff's world cup of Tube lines"
there was one ... i think TfL got wind of this
ooorr, maybe somebody at the DLR
that knows me or maybe follows my channel, i have a clip
of somebody going
world cup! and it sort of flashed up on the DLR
vote! vote! not Thameslink
but by then, it was too late
so that is what happened
in ths year's 2020 worldcup
so for my OWN summing up
what i then basically did, was just to look
at all fours years, and i sort of noted
that the Victoria has won twice
the Jubilee has won once
but it's got to the third/fourth playoff twice
the DLR has been in the finals twice but never won
the Northern has been to the third/fourth playoff twice and so on
piccadilly quarter final twice, and
when there there things like circle h&c bakerloo tfl rail
have only ever got to the quarter final once
i just ranked them by who had the best percentages
in their losing match, so!
in summary, we've got
what Matt did, thank you matt
with his spreadsheet
we've got when hellegunnR did
with his UEFA based football coefficient spreadsheet
and then we've got my rankings
those three rankings
are on screen now
now what i've done they're slightly different
you can see they're almost the same
i was hoping they might all be perfect
but to make them perfect i've simply scored them 1 to 16
against all of those
added them up
and divded them by three
for their average rankings
and you can see, and i' m looking at it on my screen now
that the victoria and jubilee are tied
so they are tied for first placew
with an average ranking of 1.6
and then there's no other tied scores
all the way down, so that is it, that is the ultimate
ranking of what your favourite tube line is
so your favourite tube line ... IS!
the victoria and jubilee
in joint first, DLR thirds
northern fourth, Overground fifth
Piccadilly sixth, District seventh
Metropolitan Line eight
Central line, Bakerloo
tenth, Circle eleventh
W & C twelfth
then TfLrail and then trams
then H&C and then yes
the cablecar is your least favourite line, slash
mode, on the tube map
that is it!
that is the results
the analysis
of four years, of world cups
thank you everybody, Matt Parker! are you still there?
oh! hey, yes
no, still here
Geoff, absolulte pleasure to be part of your video
thanks for getting me involved
and if anyone wants to see
how i wired, and programmed
and indeed calculated
this tree
it's the most recent video, on my standupmaths channel
thanks Matt, do go and subcribe to his channel
links below in the description
stand up maths, if your a nerd you like numbers crunching and maths
hmmm! tasty breakfast
then please go and follow his channel
do you eat them dry? or with milk
i'm gonna go and get on the phone to my
christmas tree supplier
and see where i can get some tube coloured lights from
that's it! thanks :)