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:
email,word,powerpoint,sap,rdpi,inet,firefox,pcp,xltt,backup,antivirus,shareme
190,17941,17941,179101,233,233,190,3741,23321,310,156,233
741,179,109,12,122,2335,48,47,109,12,122,2335
1907,106,109,156,37,16,156741,122,13341,17941,233,400
831,17941,16,310,36,18,0,17941,16,23302,310,18
1907,106,109,1,2332,36,233,106,310,1,2332,106
831,12,2331,2339,190,156,156,12,2331,2339,190,156
133,179,16,13341,33,2333,133,47,16,13341,33,2333
831,133,2336,233,2330,12,8,133,2336,233,2330,12
710,310,2330,1,156,190741,17910,310,2330,1,156,1904
741,109,179,2337,2336,109,106,109,179,2337,2336,109
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.