Source code for various requests at https://www.reddit.com/r/WorldofTanksConsole/comments/6mp76o/kamakazis_datamining_adventure_part_2_lets/

battlesbytank.sql

select sum(battles), stats.tank_id, short_name, tier, is_premium from stats, tanks where tanks.tank_id=stats.tank_id group by stats.tank_id;

graph xbox players.ipynb

List of plots and data.rst

Data

Data used for this session can be downloaded from: https://drive.google.com/open?id=0B1qZrP_GY8KXeHh4WjZCSmdIQkE

Plots

A combined listing of graphs that can be had at Plot.ly

• Playerbase growth
• Account Lifespan
• Tank ownership
• Battles vs account age (large!)
• Battles per tank
• Estimated revenue by (in)active players

revenue.ipynb