A dataset summarising challenge_results
challenge_summary
This data frame contains the following columns
category
The category of the challenge e.g. tribal, individual, individual immunity, duel, etc. This makes it easy
to split out the difference types of challenges and avoid complications such as 'Team / Individual' challenges where there is a
dependent outcome structure. Join to challenge_results
using challenge_id
, version_season
and castaway_id
version_season
Version season key
challenge_id
Primary key to the challenge_description
data set which contains features of the challenge
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 castaways as the winner gets to choose who they bring along
tribe
Current tribe the castaway is on
castaway
Name of castaway. Generally this is the name they were most commonly referred to or nickname e.g. no one called Coach, Benjamin. He was simply Coach
castaway_id
ID of the castaway (primary key). Consistent across seasons and name changes e.g. Amber Brkich / Amber Mariano. The first two letters reference the country of the version played e.g. US, AU (TBA).
n_entities
Number of entities competing for the win e.g. the number of tribes, teams, or people.
n_winners
Number of winners (or winning entities) e.g. if there are two tribes there is only one winning tribe, if there are three tribes like the new era there are two winning tribes and one that goes to tribal council.
n_in_team
The number of people in the tribe or team
won
If the castaway won
library(dplyr)
library(tidyr)
challenge_summary %>%
filter(version_season == 46)
Run the code above in your browser using DataLab