As usual, this morning kicked off with a blog post from Andy instructing us to scrape Marathon data from this website: https://results.tcslondonmarathon.com/2022/?page=2&event=MAS&pid=search&search[name]=DA
We were also instructed to filter the data to the first 2 letters of our surnames and collect data from 2014 - 2023. Here is my workflow attempting to do this.
I couldn't get some years to show in this method. It must be that the regex for those years is slightly different to the more recent years but I had time to worry about so I pressed on anyway.
I put together this sketch:
and put together this in Tableau:
I definitely struggled with trying to tell a story with the data today but overall I'm happy with the interactivity and data.