STICKMAN VENTURES

Custom Software Development and Engineering

Helping Players Track Stats with LoL-csv

Riot Game’s LoL API is a powerful tool for the community. It allows us to create and share applications that enrich the community culture by leveraging data and processes that would be useless without it.

We believe that we can fill a useful niche in the community by helping players more easily keep track of their stats. lol-csv is a web-app we built that runs on the Google Cloud Platform and uses certification from Let’s Encrypt. It allows for players to enter a summoner name and return data for their last ten qualifying ranked matches in a csv file format. This is intended to be a tool any player can use to track their stats over time in order to improve or understand their play. The idea arose after witnessing a friend of ours record their end game stats manually in a spreadsheet after each match. We thought we could make the process easier for him and others like him by leveraging the LoL API.

Lol-csv is a testament to the gaming culture we love that surrounds League of Legends and Riot Games. As thanks for the many hours of joy and entertainment League of Legends and the LoL community has brought us, we hope that lol-csv will help members of the community enrich their gaming experience. Within the spirit of aiding the community, we’ve open-sourced our code-base for the project. Visit our Github Repo here.

Detailed Use Information:

The csv returned will contain information on your last 10 ranked games, regardless of rank queue type.

For subsequent visits and uses of the service, we recommend pasting the data from each new csv file into a master spreadsheet containing data from past uses. From the master spreadsheet, consolidate and process relevant data with function calls into a new sheet to streamline your analysis. For example, a player only interested in their KDA is recommended to find the columns that refer to the Kills, Deaths, and Assists in the downloaded sheet. Set columns in a second sheet equal to the values of the original KDA columns and work on data transformations in the second sheet to ensure consistent formatting as your master spreadsheet grows.

Relevant Projects:

We first began experimenting with data from the LoL API with a Python and SQLAlchemy tech stack. If interested, check out the blog post here or the project repo here.

Ready to start?

Get in touch. We're ready to listen.