Hearthstone Deck Database |> Table Contest

Hearthstone Deck Database

Authors: Michael Bane
twitter, linkedin

Abstract: We harvest unique "deck-codes" from youtube gameplay videos daily of the popular online trading card game "Hearthstone". We extract and then visualise the decks for users, allowing them to search videos and decks according to the cards being played in them.

Full Description: We are first using "tuber" to access the the YouTube API, extracting video descriptions for videos produced by popular players of the trading card game "Hearthstone". We then extract "deck-codes" from these video descriptions, which are used by Hearthstone to import and share decks between users. We then use Hearthstone specific python libraries, via reticulate, to extract human readable deck composition data (cards within the decks) from the codes, and add them to a SQLite database with RSQLite.

We have then built a catalogue of videos, with metadata attached as well as the codes for importing into the Hearthstone game, links to videos and other online deck building tools. Using DT's HMTL capabilities, we have been able to introduce deck visualisations within the tables, which help users identify the cards within a deck quickly.

The true value of this is that user can filter video content by the decks and cards that are being played within them. It also helps users to find decks to play, and provides a long-term history of the Hearthstone meta and the popularity of different cards and decks. We are also able to provide other visualisations including card synergies and popularities over time.


Table Type: interactive-Shiny
Submission Type: Single Table Example
Table: Wild Deck DB
Code: GitHub - michaelBane/hsDecklistScraper
Cloud project:
Languages: Built with R: true. Built with Python: true.
Industries: Gaming.
Other packages: DT, reticulate, tuber, RSQLite, shiny

3 Likes

I just saw your forum post about the Hearthstone Deck Database and it
sounds like a really cool and useful tool for players of the game. It's
really interesting to think about how you're using data from YouTube
videos to create a database of decks and cards that users can search and
filter through.

It's a great way for players to find new decks and see how the meta has evolved over time.
I'm a big fan of strategy games, and I love the challenge of building and optimizing decks. It's always fun to see what kind of combinations and synergies you can come up with, and it's interesting to see how different cards and strategies perform against each other.
If you're looking for some ways to pass the time and exercise your brain, you might want to try jigsaw puzzles. Many websites and apps offer jigsaw puzzles online, so you can play from the comfort of your own home.