Hello everybody
I need a code for number analysis. I imagine this can be done in Python and I think it would be rather easy task for somebody familiar with coding :)
I will try to explain my best of what I would need the code to do.
1) I have an excel file, that contains list of numbers. Each row contains different amount of numbers ranging from 1-75. On average one row contains of minimum 42 to maximum 54 different digits, each in separate cell and no number is present twice in one row. The minimum amount of digits will never be less than 38, but might happen that maximum amount of digits will go over 54. For example one row can be: 1,2,4,5,7,9,10,12,13,14,15,16,17,19,20,21,24,25,27,28,29,30,31,33,34,36,37,38,41,42,43,44,45,46,48,50,51,52,53,56,57,58,59,60,61,63,64,65,69,70,71,72,74,75
There are currently listed nearly 400 rows of such numbers, but as I input more rows it is going to grow to about 1300 rows and will slowly increase over time after then.
2) What I need the code to do is to calculate from the excel file how many times certain combinations of digits have appeared in every row with special terms.
Term1: the numbers 1-75 are divided into 5 groups of 15 digits: 1st 1-15 ; 2nd 16-30 ; 3rd 31-45 ; 4th 46-60 ; 5th 61-75
Term2: The certain combination must always contain 5 digits from each of the 5 groups (so 25 digits in total) and no repeating numbers, order of numbers is not important, so one of the many certain combinations would be five first numbers of each group: "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 understand if my calculations are correct that there will be about 2.4*e17 of those combinations, which is huge number, would a regular home computer be able to calculate these within reasonable time?)
So to say, the code must calculate how many times these 25 digits have appeared together in all the rows in the excel file.
3) Since there are so very many possible combinations of 25 digits from 1-75 numbers, then it is not needed that the code lists me all combinations and gives a value how many times that combination has appeared.
What I need the code to do is create a file, where for example top 10 valued combinations of 25 digits are listed, preferably in excel file, each different combination is on separate row and at the end of the combination is the value, how many times it has appeared, and the combinations are in decreasing order regarding the value of appearance.
If top 10 values lists way too many rows, then I could simply reduce it to lets say top 5 values etc.
Is this doable? Would someone be willing to do this code? I imagine this being a rather simple task for someone who is at home with coding :)
Thank you for attention and I am hoping someone is willing to help
I need a code for number analysis. I imagine this can be done in Python and I think it would be rather easy task for somebody familiar with coding :)
I will try to explain my best of what I would need the code to do.
1) I have an excel file, that contains list of numbers. Each row contains different amount of numbers ranging from 1-75. On average one row contains of minimum 42 to maximum 54 different digits, each in separate cell and no number is present twice in one row. The minimum amount of digits will never be less than 38, but might happen that maximum amount of digits will go over 54. For example one row can be: 1,2,4,5,7,9,10,12,13,14,15,16,17,19,20,21,24,25,27,28,29,30,31,33,34,36,37,38,41,42,43,44,45,46,48,50,51,52,53,56,57,58,59,60,61,63,64,65,69,70,71,72,74,75
There are currently listed nearly 400 rows of such numbers, but as I input more rows it is going to grow to about 1300 rows and will slowly increase over time after then.
2) What I need the code to do is to calculate from the excel file how many times certain combinations of digits have appeared in every row with special terms.
Term1: the numbers 1-75 are divided into 5 groups of 15 digits: 1st 1-15 ; 2nd 16-30 ; 3rd 31-45 ; 4th 46-60 ; 5th 61-75
Term2: The certain combination must always contain 5 digits from each of the 5 groups (so 25 digits in total) and no repeating numbers, order of numbers is not important, so one of the many certain combinations would be five first numbers of each group: "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 understand if my calculations are correct that there will be about 2.4*e17 of those combinations, which is huge number, would a regular home computer be able to calculate these within reasonable time?)
So to say, the code must calculate how many times these 25 digits have appeared together in all the rows in the excel file.
3) Since there are so very many possible combinations of 25 digits from 1-75 numbers, then it is not needed that the code lists me all combinations and gives a value how many times that combination has appeared.
What I need the code to do is create a file, where for example top 10 valued combinations of 25 digits are listed, preferably in excel file, each different combination is on separate row and at the end of the combination is the value, how many times it has appeared, and the combinations are in decreasing order regarding the value of appearance.
If top 10 values lists way too many rows, then I could simply reduce it to lets say top 5 values etc.
Is this doable? Would someone be willing to do this code? I imagine this being a rather simple task for someone who is at home with coding :)
Thank you for attention and I am hoping someone is willing to help
