I want to have a numbers analysis program

[dainer]

Hello World!

I would like to have a program of sorts, that would analyse rows of numbers for me bringing out the top patterns.
As you might understand it is for lottery, yaay :D but it is a local lottery that is not world-wide format.

Let me explain what it is and what I need, maybe my needs are very simple and one can guide me to get the results needed.

Lottery itself consists of balls from 1-75.
The ticket you can create yourself, ie. pick numbers.
Conditions are:
Ticket field 5x5 = total 25 numbers
Colums and numbers -> 1st = 1-15 ; 2nd = 16-30 ; 3rd = 31-45 ; 4th = 46-60 ; 5th = 61-75

First 33 numbers will be drawn. After that 5 numbers and lastly as much numbers as needed for atleast one person to have filled all 25 fields on ticket. (on average it is about 13-15 numbers)

What I have is list of all the draws (currently 1300+ ). I have the numbers as full increasing lists and have them also separately to the 3 drawing sections (as in 3 rows left to right, 1 empty row, again 3 rows left to right, etc.)

What I need to have analysis on is:
- what numbers come together most often during the first 33 balls, condition is that only 2 numbers from each column are chosen. For example how many times together has been 1-2-16-17-31-32-46-47-61-62. I need like top 5 to top 10 to be listed for me with the occurence count.
- what numbers come together most often during the total balls drawn. This time condition is that 5 numbers from each column are chosen. For example how many times together has been 1-2-3-4-5+16-17-18-19-20+31-32-33-34-35+46-47-48-49-50+61-62-63-64-65. I need like top 5 to top 10 to be listed for me with the occurence count.

These would be the most needed factors to analyse.
Now what would I need to achieve it? What is the easiest programming language to use?
I think in excel these calculations would hang the MSExcel program.
Would somebody have enough time and knowledge to guide me through in creating a program for such calculations, in future I would like to add some different analysis.
I am quite far from programming, but I consider myself a quick learner and I want to learn to create.

If I finish this and the analysis program turns out helpful, I will post more about the lottery and how the program helped. :)

As for now, hopefully there is somebody willing to guide me through this :)

[dev7060]

The approach needs to be written in a programming language by following the rules of its grammar. Writing the algo/approach/pseudocode beforehand would prove useful in the actual implementation. The data to be analyzed can be supplied or read from files. For a person 'far from programming', the process of writing an implementable code from the solution in mind may require learning the basic principles and concepts of programming to come up with.

[dainer]

Thank you for replying.

Can you forward me to what programming language would me most suitable for the task, so I would not start at the worng or longest end?

[dreamtext]

It seems you have already written the algorithm.
Which is usually a written understanding of how you would solve the problem.
All you need to do is convert it to code.

Python is a good programming language for this task.

Here's a basic tutorial on how to use Python for math/number related tasks.

https://docs.python.org/3/tutorial/introduction.html

Here's a basic on data structures in python:

https://docs.python.org/3/tutorial/datastructures.html

Here's the basics on flow control and logic.

https://docs.python.org/3/tutorial/controlflow.html

Python has a library called numpy. Use this library to create data structures to work with numbers.
You can load it in your code by calling:

import numpy as np

If you are using windows:

https://docs.python.org/3/faq/windows.html

https://docs.microsoft.com/en-us/windows/python/beginners

If you are using Mac:

https://docs.python.org/3/using/mac.html

Other references:

https://en.wikibooks.org/wiki/Python_Programming/Basic_Math

[dainer]

Thank you Dreamtext for the information.
I will look into this and hopefully I'll manage to complete it.

If I run into questions I cannot solve on my own, which I think I will run into, then do you have good knowledge on Python... can I ask you directly?

[dev7060]

Can you forward me to what programming language would me most suitable for the task, so I would not start at the worng or longest end?

Considering the description of the program, I don't think the choice of language would play a significant role here that could make it label "wrong start"; other than being able to provide the ease for a beginner to grasp the concepts and in your case, come up with the desired solution. People have different subjective opinions on the choice of the first language, and there appears no definite path.

[mirandapalmer]

I think should be better to hire experienced team for this.

[AntonySilva]

I think I can't cope with it alone

[bakertaylor28]

- what numbers come together most often during the first 33 balls, condition is that only 2 numbers from each column are chosen. For example how many times together has been 1-2-16-17-31-32-46-47-61-62. I need like top 5 to top 10 to be listed for me with the occurrence count.

This would not really be anything that could be analyzed with an algorithm, because of the fact that it relies heavily on the law of probability, where you'd have to control for p-value to demonstrate a pattern that is statistically significant. If the balls are drawn at random, and there's no real-world physical factor that influences the draw, then we know that there are 2^25 (or 33,554,432) possible draws in the first 33 balls, and that is all we can know. In order to form an algorithm to analyze anything, we must know what outside factors influence the draw. Until we have that information, there's nothing to analyze that is statistically significant, considering the fact that the p-value will be too high at random to be statistically significant for any usable purpose.

[RoseCampbell]

Thx you all for you answers, a lot of new things i must to learn for yourself! :D