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% |