Brasil_Layla_Homework_1
2024-01-16
R Markdown
This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.
When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:
summary(cars)## speed dist
## Min. : 4.0 Min. : 2.00
## 1st Qu.:12.0 1st Qu.: 26.00
## Median :15.0 Median : 36.00
## Mean :15.4 Mean : 42.98
## 3rd Qu.:19.0 3rd Qu.: 56.00
## Max. :25.0 Max. :120.00Including Plots
You can also embed plots, for example:
Note that the echo = FALSE parameter was added to the
code chunk to prevent printing of the R code that generated the
plot.
packages <- c("tidyverse", "fst", "modelsummary")
new_packages <- packages[!(packages %in% installed.packages()[,"Package"])]
if(length(new_packages)) install.packages(new_packages)
lapply(packages, library, character.only = TRUE)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.4.4 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.0
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors## [[1]]
## [1] "lubridate" "forcats" "stringr" "dplyr" "purrr" "readr"
## [7] "tidyr" "tibble" "ggplot2" "tidyverse" "stats" "graphics"
## [13] "grDevices" "utils" "datasets" "methods" "base"
##
## [[2]]
## [1] "fst" "lubridate" "forcats" "stringr" "dplyr" "purrr"
## [7] "readr" "tidyr" "tibble" "ggplot2" "tidyverse" "stats"
## [13] "graphics" "grDevices" "utils" "datasets" "methods" "base"
##
## [[3]]
## [1] "modelsummary" "fst" "lubridate" "forcats" "stringr"
## [6] "dplyr" "purrr" "readr" "tidyr" "tibble"
## [11] "ggplot2" "tidyverse" "stats" "graphics" "grDevices"
## [16] "utils" "datasets" "methods" "base"ess <- read_fst("All-ESS-Data.fst")———————————-Homework———————————-
Task 1
Provide code and answer.
Prompt and question: calculate the average for the variable ‘happy’ for the country of Norway. On average, based on the ESS data, who reports higher levels of happiness: Norway or Belgium?
Note: we already did it for Belgium. You just need to compare to Norway’s average, making sure to provide the code for both.
unique(ess$cntry)## [1] "AT" "BE" "CH" "CZ" "DE" "DK" "ES" "FI" "FR" "GB" "GR" "HU" "IE" "IL" "IT"
## [16] "LU" "NL" "NO" "PL" "PT" "SE" "SI" "EE" "IS" "SK" "TR" "UA" "BG" "CY" "RU"
## [31] "HR" "LV" "RO" "LT" "AL" "XK" "ME" "RS" "MK"belgium_happy <- ess %>%
filter(cntry == "BE") %>%
select(happy)belgium_happy$y <- belgium_happy$happy
table(belgium_happy$y)##
## 0 1 2 3 4 5 6 7 8 9 10 77 88 99
## 50 27 104 194 234 830 999 3503 6521 3402 1565 3 16 3belgium_happy$y[belgium_happy$y %in% 77:99] <- NA
table(belgium_happy$y)##
## 0 1 2 3 4 5 6 7 8 9 10
## 50 27 104 194 234 830 999 3503 6521 3402 1565mean_y <- mean(belgium_happy$y, na.rm = TRUE)
cat("Mean of 'y' is:", mean_y, "\n") ## Mean of 'y' is: 7.737334Norway
norway_happy <- ess %>%
filter(cntry == "NO") %>%
select(happy)norway_happy$y <- norway_happy$happy
table(norway_happy$y)##
## 0 1 2 3 4 5 6 7 8 9 10 77 88
## 15 29 59 163 238 730 817 2617 5235 3796 2344 12 10norway_happy$y[norway_happy$y %in% 77:99] <- NA
table(norway_happy$y)##
## 0 1 2 3 4 5 6 7 8 9 10
## 15 29 59 163 238 730 817 2617 5235 3796 2344mean_x <- mean(norway_happy$y, na.rm = TRUE)
cat("Mean of 'x' is:", mean_x, "\n") ## Mean of 'x' is: 7.975005Answer: Norway reports a higher average level of happiness (7.98) compared to Belgium (7.74)
Task 2
Provide code and answer.
Prompt and question: what is the most common category selected, for Irish respondents, for frequency of binge drinking? The variable of interest is: alcbnge.
More info here: https://ess-search.nsd.no/en/variable/0c65116e-7481-4ca6-b1d9-f237db99a694.
Hint: need to convert numeric value entries to categories as specified in the variable information link. We did similar steps for Estonia and the climate change attitude variable.
ireland_bingedrinking <- ess %>%
filter(cntry == "IE") %>%
select(alcbnge)
ireland_bingedrinking$y <- ireland_bingedrinking$alcbnge
table(ireland_bingedrinking$y)##
## 1 2 3 4 5 6 7 8
## 65 650 346 417 239 641 26 6ireland_bingedrinking$y[ireland_bingedrinking$y %in% 6:8] <- NAdf <- ireland_bingedrinking %>%
mutate(
y_category = case_when(
y == 1 ~ "Daily or almost daily",
y == 2 ~ "Weekly",
y == 3 ~ "Monthly",
y == 4 ~ "Less than monthly",
y == 5 ~ "Never",
TRUE ~ NA_character_
),
y_category = fct_relevel(factor(y_category),
"Daily or almost daily",
"Weekly",
"Monthly",
"Less than monthly",
"Never")
)
table(df$y_category)##
## Daily or almost daily Weekly Monthly
## 65 650 346
## Less than monthly Never
## 417 239get_mode <- function(v) {
tbl <- table(v)
mode_vals <- as.character(names(tbl)[tbl == max(tbl)])
return(mode_vals)
}
mode_values <- get_mode(df$y_category)
cat("Mode of y category:", paste(mode_values, collapse = ", "), "\n")## Mode of y category: Weeklycat("\n", "For Irish respondents, for frequency of binge drinking, the most common category selected is", paste(mode_values, collapse = ", "), "\n")##
## For Irish respondents, for frequency of binge drinking, the most common category selected is WeeklyTask 3
Provide code and answer.
Prompt and question: when you use the summary() function for the variable plnftr (about planning for future or taking every each day as it comes from 0-10) for both the countries of Portugal and Serbia, what do you notice? What stands out as different when you compare the two countries (note: look up the variable information on the ESS website to help with interpretation)? Explain while referring to the output generated.
port_plan <- ess %>%
filter(cntry == "PT") %>%
select(plnftr)
port_plan$y <- port_plan$plnftr
table(port_plan$y)##
## 0 1 2 3 4 5 6 7 8 9 10 88
## 114 184 313 356 264 481 262 382 345 166 370 40port_plan$y[port_plan$y %in% 88] <- NA
table(port_plan$y)##
## 0 1 2 3 4 5 6 7 8 9 10
## 114 184 313 356 264 481 262 382 345 166 370summary(port_plan)## plnftr y
## Min. : 0.000 Min. : 0.000
## 1st Qu.: 3.000 1st Qu.: 3.000
## Median : 5.000 Median : 5.000
## Mean : 6.426 Mean : 5.418
## 3rd Qu.: 8.000 3rd Qu.: 8.000
## Max. :88.000 Max. :10.000
## NA's :14604 NA's :14644serb_plan <- ess %>%
filter(cntry == "RS") %>%
select(plnftr)
serb_plan$y <- serb_plan$plnftr
table(serb_plan$y)##
## 0 1 2 3 4 5 6 7 8 9 10 77 88
## 587 133 152 138 95 246 70 87 103 47 364 4 17serb_plan$y[serb_plan$y %in% 77:88] <- NA
table(serb_plan$y)##
## 0 1 2 3 4 5 6 7 8 9 10
## 587 133 152 138 95 246 70 87 103 47 364summary(serb_plan)## plnftr y
## Min. : 0.000 Min. : 0.000
## 1st Qu.: 0.000 1st Qu.: 0.000
## Median : 4.000 Median : 4.000
## Mean : 4.983 Mean : 4.143
## 3rd Qu.: 8.000 3rd Qu.: 8.000
## Max. :88.000 Max. :10.000
## NA's :1505 NA's :1526Answer: One big thing that stands out to me is that Serbia’s 1st Quartile is 0. This means that 25% of all voters voted for taking each day as it comes, compared to portugual which has a value of 3 at the 1st quartile. Overall (and indicated by the mean) Portugal leans toward planning more for the future, and Serbia leans a little bit more towards taking each day as it comes.
Task 4
Provide code and answer.
Prompt and question: using the variables stfdem and gndr, answer the following: on average, who is more dissastified with democracy in Italy, men or women? Explain while referring to the output generated.
Info on variable here: https://ess.sikt.no/en/variable/query/stfdem/page/1
italy_data <- ess %>%
filter(cntry == "IT")italy_data <- italy_data %>%
mutate(
gndr = case_when(
gndr == 1 ~ "Male",
gndr == 2 ~ "Female",
TRUE ~ as.character(gndr)
),
) table(italy_data$gndr)##
## 9 Female Male
## 13 5329 4836italy_data$gndr[italy_data$gndr %in% 9] <- NAitaly_data <- italy_data %>% filter(!is.na(gndr))means_by_gender <- italy_data %>%
group_by(gndr) %>%
summarize(stfdem = mean(stfdem, na.rm = TRUE))
print(means_by_gender)## # A tibble: 2 × 2
## gndr stfdem
## <chr> <dbl>
## 1 Female 8.43
## 2 Male 7.43Answer: since 10 is labeled as extremely satisfied, and 0 is labeled as extremely dissatisfied, males are more dissatisfied with democracy in Italy than women. Males have a mean democracy satisfaction of 7.43 which is lower than females with a mean of 8.43.
Task 5
Provide code and answer.
Prompt: Interpret the boxplot graph of stfedu and stfhlth that we generated already: according to ESS data, would we say that the median French person is more satisfied with the education system or health services? Explain.
Change the boxplot graph: provide the code to change some of the key labels: (1) Change the title to: Boxplot of satisfaction with the state of education vs. health services; (2) Remove the x-axis label; (3) Change the y-axis label to: Satisfaction (0-10).
Hint: copy the boxplot code above and just replace or cut what is asked.
france_data <- read.fst("france_data.fst")france_data %>%
mutate(stfedu = ifelse(stfedu %in% c(77, 88, 99), NA, stfedu),
stfhlth = ifelse(stfhlth %in% c(77, 88, 99), NA, stfhlth)) %>%
select(stfedu, stfhlth) %>%
gather(variable, value, c(stfedu, stfhlth)) %>%
ggplot(aes(x = variable, y = value)) +
geom_boxplot() +
labs(y = "Y-axis", x = "X-axis", title = "Boxplot of stfedu vs. stfhlth") +
theme_minimal()## Warning: Removed 364 rows containing non-finite values (`stat_boxplot()`).
Answer: The median french person is more satisfied with the health
services. The thick and dark line in the middle of the boxes represent
the median of each variable in this boxplot. Since the median line for
education is close to 5, and the median line for health services is
closer to 7, the median for health services is higher. Therefore, The
median for a french persons satisfaction is higher for health
services.
altering of graph code
france_data %>%
mutate(stfedu = ifelse(stfedu %in% c(77, 88, 99), NA, stfedu),
stfhlth = ifelse(stfhlth %in% c(77, 88, 99), NA, stfhlth)) %>%
select(stfedu, stfhlth) %>%
gather(variable, value, c(stfedu, stfhlth)) %>%
ggplot(aes(x = variable, y = value)) +
geom_boxplot() +
labs(y = "Satisfaction (0-10)", x = "",　title = "Boxplot of satisfaction with the state of education vs. health services") +
theme_minimal()## Warning: Removed 364 rows containing non-finite values (`stat_boxplot()`).