Scholar Stats
This is a simple python script for saving the historical data of your scholars.
Features
Overview of:
- Daily SLP
- Daily $
- Daily Average SLP
- Total SLP
- Total $
- Manager Share SLP
- Manager Share $
- Scholar Share SLP
- Scholar Share $
- SLP Price
- Daily overview of SLP on scholars accounts
- Specific overview of every scholar For more see the screenshots below.
Dependencies
The required packages to run this code can be found in the requirements.txt
file. To run this file, execute the following code block:
$ pip install -r requirements.txt
Alternatively, you can install the required packages manually like this:
$ pip install <package>
Setup
Start by cloning the repository.
Next, get your authentication.json file, by following the steps below carefully. Or follow the instructions from this (starts from 1:58) video
If you prefer written instructions follow the instructions below:
- Enable API access for the new project instructions.
- Creating the
authentication.json file
instructions.
After follow the instructions above, last things you need to do is this:
- Save your
authentication.json
file in the same folder as you saved the files for this script. - Open
authentication.json
and copy the email behind"client_email":
- Open Google Drive and go to the folder that you want the bot to make the spreadsheets in, right click on that folder and press share
- Share the folder with the client email out of
authentication.json
Then after that is done, go to the folder where this repository is stored and execute the following code block:
python src/setup.py
This will setup the Spreadsheet and worksheet for you in Google Drive. After doing that you will need to fill in the information of your scholars. If you are not sure what you should fill in here, check the examples below.
If you filled out the information you are done and at last you need to execute this code:
python src/main.py
Note
The same method as described here is also used for setting up our Discord bot. So if you would like to have a Discord bot to manage your scholars, be sure to check out that repository.
Examples
This is how your "Scholars" worksheet should look like if you want the basic functioning:
After running this the code this is how your spreadsheet should look like: