$csvfile="adatb_zh.csv"

$data=import-csv -delimiter ";" $csvfile -header "neptun","csoport","gyakvez","terem","gy1","gy2","gy3","gy4","gy5","gy6","pont","jegy"
$data=$data[1..($data.length-1)]

$jegyek="njm",1,2,3,4,5

write-host "összesen:"

foreach($jegy in $jegyek)
{
    write-host ("jegy: "+$jegy+", darab: "+@($data|where-object {$_.jegy -eq $jegy}).length+", legalább "+$jegy+": "+($data|where-object {$jegy -eq "njm" -or ($_.jegy -ge $jegy -and $_.jegy -ne "njm")}).length)
}

$gyakok="k1","k2","k3","k4","k5","k6","kh","c1","c2","c3","c4","c5","c6","c7","ch","vk"

foreach($gyak in $gyakok)
{
    write-host

    $gyakdata=$data|where-object {$_.csoport -eq $gyak}

    write-host ("gyak: "+$gyak+", gyakvez: "+$gyakdata[0].gyakvez+":")

    foreach($jegy in $jegyek)
    {
        write-host ("    jegy: "+$jegy+", darab: "+@($gyakdata|where-object {$_.jegy -eq $jegy}).length)
    }
}