Relation Election 6

Allocate seats on a fictional national level

read "ef2019.csv"
select partei !== "Übrige"
project partei, fiktive_waehlende sum
relation number
set i = 0
while i < 60
set i = i+ 1
insert i
end while
write "numberlist.csv"
join cross
extend quotient = fiktive_waehlende_sum/number
order quotient 9
limit 1 200
print 10
project partei, number count
order number_count 9
write "seats2019national.csv"
print