Relation Election 3
What is the voter share of the Green Party in each canton?
read "ef2019.csv"
dup
project kanton, fiktive_waehlende sum
swap
select partei == "GPS"
join natural
extend share = fiktive_waehlende / fiktive_waehlende_sum
project kanton, share
order share 9
format share "%0.1p"
print
| kanton | share |
|---|---|
| Genève | 24.6% |
| Neuchâtel | 20.8% |
| Vaud | 19.7% |
| Zug | 19.2% |
| Basel-Landschaft | 18.0% |
| Basel-Stadt | 17.7% |
| Jura | 15.6% |
| Zürich | 14.1% |
| Bern / Berne | 13.6% |
| Fribourg / Freiburg | 12.5% |
| Luzern | 12.2% |
| Ticino | 12.1% |
| Solothurn | 11.4% |
| Thurgau | 10.6% |
| Valais / Wallis | 10.6% |
| St. Gallen | 10.5% |
| Aargau | 9.8% |
| Schaffhausen | 6.8% |
| Graubünden / Grigioni / Grischun | 5.5% |
| Glarus | 2.7% |
| Schwyz | 2.6% |
| Uri | 0.0% |