import csv
with open("lab9_files/ex3_input.csv","r",encoding="utf-8") as f:
    d = csv.DictReader(f)
    dic = {}
    for i in d:
        nota=int(i["NOTA_EA"])
        specializare = i["Specializare"].lower()
        if specializare in dic.keys():
            dic[specializare][0] +=1
            if dic[specializare][1]<nota and dic[specializare][1]>0:
                dic[specializare][1]=nota
            if dic[specializare][2]>nota:
                dic[specializare][2]=nota

        else:
            dic[specializare] = [1,nota,nota]
    for i in d:
        nota=int(i["NOTA_EA"])

with open("out2.csv","w",encoding="utf-8") as g:
    csv = csv.writer(g)
    csv.writerow(["Specializare","Numar elevi","minim","maxim"])
    for i,j in dic.items():
        csv.writerow([i,j])