demogs = readRDS('verasightDemogs.rds')
sentiment_study1 = merge(read.csv('dataCenterSentiment_01.csv'), readRDS('verasightDemogs.rds'), by='vsid') %>%
filter(dataCenterSentiment != "") %>%
mutate(dataCenterSentiment = factor(dataCenterSentiment, labels=c('Strongly oppose', 'Somewhat oppose', 'Have no opinion', 'Somewhat favor', 'Strongly favor')),
dataCenterDensity = factor(dataCenterDensity, labels=c('None','1-2','More than 2', "I'm not sure"))) %>%
mutate(dataCenterDensity_collapsed = factor(ifelse(dataCenterDensity == "I'm not sure", 1, dataCenterDensity), labels=c('None','1-2', 'More than 2')),
priceForSupport_withoutStrongOpposerZeroes = ifelse(dataCenterSentiment == "Strongly oppose" & priceForSupport <1, NA, priceForSupport)) %>%
mutate(priceForSupport_withSupporters = ifelse(dataCenterSentiment == "Somewhat favor" | dataCenterSentiment =="Strongly favor", 0, priceForSupport),
priceForSupport_withSupporters = ifelse(dataCenterSentiment == "Strongly oppose" & priceForSupport <1, NA, priceForSupport_withSupporters),
priceForSupport_binned = factor(ifelse(priceForSupport_withoutStrongOpposerZeroes <1, "$0",
ifelse(priceForSupport_withoutStrongOpposerZeroes > 0 & priceForSupport_withoutStrongOpposerZeroes < 1001, "$1K or less",
ifelse(priceForSupport_withoutStrongOpposerZeroes >1000 & priceForSupport_withoutStrongOpposerZeroes <10001, "More than $1K",
ifelse(priceForSupport_withoutStrongOpposerZeroes >10000 & priceForSupport_withoutStrongOpposerZeroes <50001, "More than $10K",
ifelse(priceForSupport_withoutStrongOpposerZeroes >50000 & priceForSupport_withoutStrongOpposerZeroes <100001, "More than $50K",
ifelse(priceForSupport_withoutStrongOpposerZeroes >100000 & priceForSupport_withoutStrongOpposerZeroes <1000001, 'More than $100K',
ifelse(priceForSupport_withoutStrongOpposerZeroes >1000000 & priceForSupport_withoutStrongOpposerZeroes <1000000001, 'More than $1M', "More than $1B"))))))), levels=c(NA, '$0','$1K or less','More than $1K', 'More than $10K','More than $50K','More than $100K','More than $1M','More than $1B')),
reasonsTally = rowSums(pick("support_qualityOfLife", "support_localEconomy", "support_AIdev", "support_environment", "support_naturalResources") > 1, na.rm = TRUE)) %>%
mutate(reasonsTally_fct = factor(ifelse(reasonsTally <2, "1 or less", reasonsTally)))