The TOTO $8Million draw snowballed 3x to coming this Monday 18 Oct 9pm, with a $8 million prize for the jackpot. Being a true-blue Singaporean, I have bought some numbers too. We all know that this is a game of chance, luck and rather low probability of winning, but wouldn’t it be interesting to see some real data?
There are two parts of this project. The first is to get the data. 3 years of Group 1 jackpot data are available in Singapore Pool’s website. The extraction was automated using Python, and dumped into a sqlite database. Google Maps API was also used to geocode Singapore Pool branch’s addresses so as to place markers in a map.
With the more time-consuming coding over, all the data were finally visualised using Tableau. And the resulting dashboard above is created
The eventual dashboard resulting from this project:
https://public.tableau.com/app/profile/manhunt2k/viz/Toto102018-21-FINAL/TOTO
If you win due to my data science toto table, appreciate give me some few % winnings ,kamsia (: have a great weekend
Do subscribe mailing list to keep posted on updates,recommendations etc
Extraction & Analysis of TOTO Results
Extraction & Analysis of TOTO Results A mini-project to analyse 3 years of TOTO Group 1 data.
totocreate.py: create an sqlite database for storing toto data
totoscrape.py: scrape toto results from Singapore Pool’s website
toto_all_locations.py: scrape all branches & authorised sellers from Singapore Pool’s website
totogeocode.py: geocode addresses into latitude and longitude using Google Maps API
With the more time-consuming coding over, all the data were finally visualised using Tableau. And the resulting dashboard above is created in tableau.
And so there it is. A fun mini-project to play around with and I also picked up a few tricks to improve my coding skills.
If you win due to my data science toto table, appreciate give me some few % winnings ,kamsia (: have a great weekend
Do subscribe mailing list to keep posted on updates,recommendations etc
For those into the geek part, you can subscribe mailing list to state your interest so as to share my scripts.