Let me make an example with the latest lichess database (12 million games, 26GB unzipped):
https://database.lichess.org/
and let's say that I want to make a D3.js graph:
https://github.com/d3/d3/wiki/Gallery
which needs a csv file:
Code: Select all
elo_range, n_players, avg_n_games
1300, 34, 5
1350, 58, 30
1400, 23, 9
....
-calculate the average elo for each player and assign the player to an elo_range
-count the number of players for each elo_range
-calculate the average number of games played for each elo_range (total number of games of the players in the group divided by the number of players).
Which tools are able to extract the data?