Collecting and analyzing Bitcoin Dice game data
In this section, we will look at the data from a dice games portal, read in the data from the API, and use pandas
to convert it into a tabular format. We will also export the data and find the things that need cleaning up. We'll clean up, manipulate, and reshape the data, making it ready for analysis, and finally, we will draw a simple plot from the clean data.
Getting data from the Games Web API
The user can explore the dice games data fromMegaDice.com, which is available from the website's API link at https://www.megadice.com.
We will use the pandas read_JSON
method to read individual winner history data from the MegaDice API link. We create a pandas DataFrame
, called leaders
, from this data and call in the head ()
method to see what this data looks like.
The code in the following screenshots shows the creation of thepandas
DataFrame
, leaders
:

The data we have imported has 703 columns, most of which are individual dates. We will delete the last...