English Français Deutsch

Relation Election 4

Compare the results of the Green Party 2019 with 2015.
program results (year, party)
read "ef" .year. ".csv"
dup
project kanton, fiktive_waehlende sum
swap
select partei == party
join natural
extend share = fiktive_waehlende / fiktive_waehlende_sum
project kanton, share
end program
run results (2019 , "GPS")
rename share share2019
run results (2015 , "GPS")
rename share share2015
join natural
extend delta = share2019 - share2015
format delta "%0.2p" , share2019 "%0.2p" , share2015 "%0.2p"
order delta 9
print

kanton share2019 share2015 delta
Genève 24.61% 11.47% 13.14%
Zug 19.23% 7.16% 12.07%
Neuchâtel 20.81% 9.31% 11.50%
Ticino 12.11% 3.53% 8.59%
Vaud 19.68% 11.25% 8.43%
Jura 15.62% 7.27% 8.35%
Zürich 14.08% 6.89% 7.19%
Fribourg / Freiburg 12.46% 5.29% 7.18%
Basel-Stadt 17.70% 11.18% 6.51%
Solothurn 11.42% 5.56% 5.86%
Valais / Wallis 10.59% 4.89% 5.70%
Thurgau 10.60% 5.44% 5.16%
Luzern 12.23% 7.07% 5.16%
Bern / Berne 13.59% 8.51% 5.08%
St. Gallen 10.54% 5.75% 4.79%
Aargau 9.78% 5.47% 4.31%
Basel-Landschaft 18.00% 14.19% 3.80%
Schaffhausen 6.83% 3.42% 3.41%
Schwyz 2.61% 1.41% 1.20%
Uri 0.00% 26.28% -26.28%