Challenge Results
A dataset detailing the challenges played including reward and immunity challenges.
immunity
and rewards
datasets.
challenge_results
This nested data frame contains the following columns:
season_name
The season name
season
The season number
episode
Episode number
day
The day of the tribal council
episode_title
Episode title
challenge_name
The name of the challenge. Challenges can go by different names but where possible recurring challenges are kept consistent. While there are tweaks to the challenges where the main components of the challenge consistent they share the same name
challenge_type
The challenge type e.g. immunity, reward, etc
outcome_type
Whether the challenge is individual or tribal. Some individual reward challenges may involve multiple castawats as the winner gets to choose who they bring along
challenge_id
Primary key to the challenge_description
data set which contains features of the challenge
winning_tribe
Name of the winner tribe. NA
during the merge
outcome_status
Identifies the winner of individual reward challenges and those chosen to participate i.e. they didn't win but were chosen by the winner to join them on the reward.
winner
The list of winners. Either the list of people in the tribe which won, list of people that participated on the reward or the individual winner
winner_id
The ID of the winners of the challenge. Consistent with castaway_id
A nested tidy data frame of immunity and reward challenge results. The
winners and winning tribe of the challenge are found by expanding the winner
column. For individual immunity challenges the winning tribe is simply NA
.
Typically in the merge if a single person win a reward they are allowed to bring others along with them. The first castaway in the expanded list is likely to be the winner and the subsequent players those they brought along with them. Although, not always. Occasionally in the merge the castaways are split into two teams for the purpose of the reward, in which case all castaways win the reward rather than a single person.
The day
field on this data set represents the day of the tribal council rather
than the day of the challenge. This is to more easily associate the reward challenge
with the immunity challenge and result of the tribal council. It also helps for
joining tables.
library(dplyr) library(tidyr) challenge_results %>% filter(season == 40) %>% unnest(winners)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.