In [1]:
import student as s
import stats as stats
import matplotlib.pyplot as plt
In [2]:
students = s.import_safe_file("assets/sv.xlsx")
unique_students = s.import_safe_file("assets/sv-unique.xlsx")
In [7]:
semesters_per_student = {}
for student in students:
if student.data['SCIPER'] in semesters_per_student.keys():
semesters_per_student[student.data['SCIPER']] += 1
else:
semesters_per_student[student.data['SCIPER']] = 1
semesters = [0] * 20
for i in range(20):
for k in semesters_per_student.keys():
if semesters_per_student[k] == i:
semesters[i] += 1
semesters
ind = list(range(20))
width = 0.6
plt.bar(ind,semesters,width)
plt.title("number of semesters stayed at EPFL per SV student")
plt.xlabel("number of semesters stayed")
plt.ylabel("number of students")
plt.show()
In [14]:
labels = []
for i in range(20):
labels.append(str(i))
cs = stats.cs
plt.pie(semesters,labels=labels,colors=cs)
plt.axis('square')
plt.show()
In [ ]: