Multiple-choice quiz | Pivoting data

Is the statement below TRUE or FALSE?

Wide format data is usually better for making plots with ggplot2 in R.

Answer TRUE or FALSE

For presenting time series data in a table, a long format is usually better, since it is easy to spot trends in this format.

Consider the following subset of the relig_income dataset from tidyr, which shows, in a wide format, the number of respondents who have an income range in column name:

relig_income_subset <- tidyr::relig_income %>% select(1:4) %>% head()
relig_income_subset

## # A tibble: 6 × 4
##   religion           `<$10k` `$10-20k` `$20-30k`
##   <chr>                <dbl>     <dbl>     <dbl>
## 1 Agnostic                27        34        60
## 2 Atheist                 12        27        37
## 3 Buddhist                27        21        30
## 4 Catholic               418       617       732
## 5 Don’t know/refused      15        14        15
## 6 Evangelical Prot       575       869      1064

Which of the following code chunks will successfully pivot the wide data into a long format?

Consider the following mock dataset showing the number of cases of an unnamed diseases in three countries over time:

mock_long_data <- bind_cols(expand_grid(country = c("Chad", "Iran", "Peru"), 
                                   year = 2000:2003), 
                       num_of_cases = sample(1:20, 12))
mock_long_data

## # A tibble: 12 × 3
##    country  year num_of_cases
##    <chr>   <int>        <int>
##  1 Chad     2000            9
##  2 Chad     2001            8
##  3 Chad     2002           15
##  4 Chad     2003           10
##  5 Iran     2000            2
##  6 Iran     2001           13
##  7 Iran     2002           14
##  8 Iran     2003            5
##  9 Peru     2000           11
## 10 Peru     2001           12
## 11 Peru     2002            3
## 12 Peru     2003           19

Which of the following code chunks will successfully pivot the long data into an appropriate wide format?