Tidying data
Let's continue our work from the previous exercise. Now that we've got the population we want, let's reformat our data to get it in shape for plotting. The graph only looks at flier's opinions about whether different behaviors are rude, so we'll first want to select only those columns. Then we can reshape our data to prepare us for the next lesson where we'll get some summary data from different questions.
This exercise is part of the course
Categorical Data in the Tidyverse
Exercise instructions
- Select columns where "rude" is in the column name.
- Change the dataset from "wide" to "long", with the variable names in a column called "response_var" and the values in a column called "value."
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
gathered_data <- flying_etiquette %>%
mutate(across(where(is.character), as.factor)) %>%
filter(`How often do you travel by plane?` != "Never") %>%
# Select columns containing "rude"
___ %>%
# Change format from wide to long
___