library(foreign)
db <- read.spss(file=paste0(getwd(),
"/data/1186_Selects2019_CandidateSurvey_Data_v1.1.0.sav"),
use.value.labels = T,
to.data.frame = T)
sel <- db |>
dplyr::select(B12,T9a,E2a) |>
stats::na.omit() |>
dplyr::rename("budget"="B12", "party_list"="T9a", "age"="E2a") |>
plyr::mutate(budget=as.numeric(as.character(budget))) |>
plyr::mutate(party_list=as.factor(party_list))
sel$party_list <- gsub(" -.*","",sel$party_list)
sel$party_list <- as.factor(sel$party_list)
# filter candidates with maximally a budget of 100'000
sel <- sel[sel$budget<=100000,]
# recode the party affiliation into left-center-right
sel$lcr <- NA
sel$lcr <- ifelse(sel$party_list=="SP/PS" | sel$party_list=="GPS/PES", "left", as.character(sel$lcr))
sel$lcr <- ifelse(sel$party_list=="CVP/PDC" | sel$party_list=="GLP/PVL", "center", as.character(sel$lcr))
sel$lcr <- ifelse(sel$party_list=="FDP/PLR" | sel$party_list=="SVP/UDC", "right", as.character(sel$lcr))
sel$lcr <- as.factor(sel$lcr)
sel <- sel[!is.na(sel$lcr),] # remove the remaining categories