Web Scraping adventure 1

Over a weekend I watched Arcane the league of legends Netflix animated series and have become mildly obsessed with reading the character pages and short story’s on the fan wiki league universe site. This along side seeing this “character diagram” bellow* on reddit. I thought it would be a good learning exercise to create a interactive diagram/map of all 140+ league characters. Runeterra map

Using excel/google slides

Early last year we quickly went over data sets for unity and hope this will be a good way to revisit those lesions. I found out you can import entire html tables from websites like the LOL wiki into google sheets with ‘=importhtml(“”,”table”,)’.

Using R

Sheets was a very quick and easy way of collecting the data I wanted but from what i understood at the time.

Following along with these tutorials by
Dataslice I eventually got my web scraper to collect and combine the datasets I wanted into a table. next step

At this point i would like to fine tune the xpath’s to clear up some of the data. for example in the row created for “Akshan” it recognises ” Gun ” as a background for the character.

Edit: the wiki has since changed this and “Gun” is no longer present on the page.

next steps will be to learn how to utilise datasets in game engine and recreate the map.

Leave a Reply

Your email address will not be published. Required fields are marked *