Question

Q10: Which contestants have never received a tribal council vote (i.e. a vote to be voted out of the game as shown in the vote_id column in the vote_history DataFrame)? Note that there are various reasons for a contestant to not receive a tribal vote: they quit, made it to the end, medical emergency, etc. Select their rows from the castaway_details DataFrame and save this as Q10 in ascending order by castaway_id. This should return a DataFrame and the index and missing values should be left as is.

Answer 1

To find the contestants who have never received a tribal council vote, we can filter the castaway_details DataFrame based on the missing values in the vote_id column. We'll create a new DataFrame called Q10 with these rows, and sort it in ascending order by castaway_id. Here's the code to achieve this:

```python
# Filter rows where vote_id is null
Q10 = castaway_details[castaway_details['vote_id'].isnull()]

# Sort by castaway_id in ascending order
Q10 = Q10.sort_values('castaway_id')

# Display the Q10 DataFrame
Q10
```

Note: The code assumes that the castaway_details DataFrame is already loaded and available in the environment.