-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtamrin13.py
128 lines (101 loc) · 4.37 KB
/
tamrin13.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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
import csv
from csv import writer
# For the average
from statistics import mean
def calculate_averages(input_file_name, output_file_name):
with open("E:\\Python project\\tamrin13\\%s.csv" %(input_file_name), "r") as f:
reader=csv.reader(f)
with open("E:\\Python project\\tamrin13\\%s.csv" %(output_file_name),"w",newline="") as x:
writer=csv.writer(x)
for row in reader:
n=row[0].strip()
grades=list()
for i in row[1:]:
grades.append(int(i.strip()))
l=[n,mean(grades)]
writer.writerow(l)
#calculate_averages("tamrin 13","a")
def calculate_sorted_averages(input_file_name, output_file_name):
with open("E:\\Python project\\tamrin13\\%s.csv" %(input_file_name), "r") as f:
reader=csv.reader(f)
with open("E:\\Python project\\tamrin13\\%s.csv" %(output_file_name),"w",newline="") as x:
writer=csv.writer(x)
d=dict()
for row in reader:
name=row[0]
v=float(row[1])
d[name]=v
a=sorted(d.values())
b=d.keys()
l=list()
for i in a:
for ii in b:
if d[ii]==i:
l.append(ii)
l.append(i)
for i in range(int(len(l)/2)): #len/2 baraye ine ke range az tedad ozve list bishtar nashe err bede
ll=list()
n=2*i
m=2*i+1
ll.append(l[n])
ll.append(l[m])
writer.writerow(ll)
calculate_sorted_averages("a","b")
def calculate_three_best(input_file_name, output_file_name):
with open("E:\\Python project\\tamrin13\\%s.csv" %(input_file_name), "r") as f:
reader=csv.reader(f)
with open("E:\\Python project\\tamrin13\\%s.csv" %(output_file_name),"w",newline="") as x:
writer=csv.writer(x)
d=dict()
for row in reader:
name=row[0]
m=float(row[1])
d[name]=m
a=sorted(d.values())
b=d.keys()
aa=list()
aa=[a[-1],a[-2],a[-3]] #soarted 3 best
l=list()
for i in aa:
for ii in b:
if d[ii]==i:
l.append(ii)
l.append(i)
for i in range(int(len(l)/2)):
ll=list()
n=2*i
m=2*i+1
ll.append(l[n])
ll.append(l[m])
writer.writerow(ll)
#calculate_three_best("b","c")
def calculate_three_worst(input_file_name, output_file_name):
with open("E:\\Python project\\tamrin13\\%s.csv" %(input_file_name), "r") as f:
reader=csv.reader(f)
with open("E:\\Python project\\tamrin13\\%s.csv" %(output_file_name),"w",newline="") as x:
writer=csv.writer(x)
d=dict()
for row in reader:
name=row[0]
m=float(row[1])
d[name]=m
a=sorted(d.values())
aa=list()
aa+=[a[0],a[1],a[2]]
for i in range(len(aa)):
ll=[]
ll.append(aa[i])
writer.writerow(ll)
#calculate_three_worst("b","d")
def calculate_average_of_averages(input_file_name, output_file_name):
with open("E:\\Python project\\tamrin13\\%s.csv" %(input_file_name), "r") as f:
reader=csv.reader(f)
with open("E:\\Python project\\tamrin13\\%s.csv" %(output_file_name),"w",newline="") as x:
writer=csv.writer(x)
l=[]
for row in reader:
m=float(row[1])
l+=[m]
ll=[mean(l)]
writer.writerow(ll)
#calculate_average_of_averages("b","e")