Original Blog Entry: Week 3 picks did not change from week 2..

hypersoniq — Fri, 15 Nov 2024 17:10:24 GMT

The first week picks for the pick 5 ended up being slightly different in week 2, the pick 3 was added in week 2. Since I am moving forward with the pick 3, it is interesting that the combo choice has not changed for either day or night...

I simplified the sorting process by adding a composite column, which simply adds the straight and box hits of the combos together. It was a simple adjustment that needed a variable to add the other 2 (straight + box hits) and creating a column header and writing the new column to the csv file.

I am still seeing some inconsistent counts in the pick 5 output, which makes it an ideal time to remake the code to count properly as the switch to the pick 3 only is underway.

I also noticed some inconsistencies when looking at the number of draws in the csv files vs. The spreadsheets. The history files were initially entered by hand so events such as the infamous 666 evening draw and their short lived double draw results could be kept out.

I may have to resort to running the entire history file creation again, only this time with the year to year copy data from the URL instead of manual typing... that will be an ongoing project... I have gotten better at cleaning data, but it is still a monumental task, as pick 3 evening data goes all the way back to 1977 and the website only gives out a year at a time.

I almost wish I did not see the anomalies, but data consistency is important.... [ More ]