-
Notifications
You must be signed in to change notification settings - Fork 0
/
StatsGenerator.py
81 lines (72 loc) · 2.67 KB
/
StatsGenerator.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
import pandas
def vendorCounts(data):
counts = {}
for manufacturer in data["Manufacturer"]:
manufacturerList= str(manufacturer).split(sep="/")
manufacturerList = map(str.strip, manufacturerList)
for item in manufacturerList:
if item in counts:
counts[item] += 1
else:
counts[item] = 1
outputFile = open('vendorCounts.csv', 'a')
outputFile.write("name,count")
for (key, value) in sorted(counts.items(),key=lambda item: (item[1], item[0]), reverse=True):
outputFile.write("\n"+str(key)+","+str(value))
def countryCounts(data):
print("***Finding Country Counts***")
counts = {}
for country in data["Country"]:
if country in counts:
counts[country] += 1
else:
counts[country] = 1
outputFile = open('countryCounts.csv', 'a')
outputFile.write("name,count")
for (key, value) in sorted(counts.items(),key=lambda item: (item[1], item[0]), reverse=True):
outputFile.write("\n"+str(key)+","+str(value))
def regionCounts(data):
print("***Finding Region Counts***")
counts = {}
for region in data["Region"]:
if region in counts:
counts[region] += 1
else:
counts[region] = 1
outputFile = open('regionCounts.csv', 'a')
outputFile.write("name,count")
for (key, value) in sorted(counts.items(),key=lambda item: (item[1], item[0]), reverse=True):
outputFile.write("\n"+str(key)+","+str(value))
def segmentCounts(data):
print("***Finding Segment Counts***")
counts = {}
for segment in data["Segment"]:
if segment in counts:
counts[segment] += 1
else:
counts[segment] = 1
outputFile = open('segmentCounts.csv', 'a')
outputFile.write("name,count")
for (key, value) in sorted(counts.items(),key=lambda item: (item[1], item[0]), reverse=True):
outputFile.write("\n"+str(key)+","+str(value))
def OSCounts(data):
print("***Finding OS Counts***")
counts = {}
for OS in data["OS"]:
if OS in counts:
counts[OS] += 1
else:
counts[OS] = 1
outputFile = open('OSCounts.csv', 'a')
outputFile.write("name,count")
for (key, value) in sorted(counts.items(),key=lambda item: (item[1], item[0]), reverse=True):
outputFile.write("\n"+str(key)+","+str(value))
def main():
data = pandas.read_csv("top500.csv", encoding="ISO-8859-1")
vendorCounts(data)
countryCounts(data)
regionCounts(data)
segmentCounts(data)
OSCounts(data)
print("Done.")
main()