We are looking for a script developed that can count the number of times a particular number appears in each column. The script need to load the data from a large csv file like:
Result should show for each column, what are the top 3 most recurring number(s). For example, in the sample above, for column 1 (email), the results should be:
Top number(s): 831 (3 times)
2nd number(s): 741,1907 (2 times)
3nd number(s): 190,710,133 (1 time)
Please PMB if you have any questions.
Let's say I start populating the column with numbers one by one. Let's say the first number is 14, I want the script to start looking for three numbers 13,14,15 (+1, = ,-1) in that column.As soon as I enter one of those (3) target numbers before the desired sequence of numbers (i.e.60) is met, I need some sort of warning. I also want to know as soon as I have 60 numbers that exclude those 3. Every time the script finds of on "undesired" numbers before the goal of 60 numbers is reached, it should move to the next consecutive number in the column.
Please note that the first portion of the project was mistakenly copied into the field. I do not need the top numbers thing. Only the part about a sequence of 60 numbers.