Which contestant(s) played a perfect game? A perfect game is considered when the contestant:
didn't receive any tribal council votes all season (this is different than Q10 since some players played multiple times. They got voted out in one season so they would not show in Q10 but they came back for another season and didn't receive any tribal council votes)
won the game
got unanimous jury votes (see question 12)
Save this DataFrame as Q19 with the following columns: season_name, season, castaway_id, full_name, tribal_council_votes, jury_votes. The DataFrame should be sorted by season and the index should be 0 to n-1.
We are missing some data in order to answer this question as we need information about tribal council votes and jury votes for each contestant in each season. Please provide data for these columns and instructions on how to access it.
To filter the contestants who played a perfect game, you can follow these steps:
Step 1: Import the necessary libraries and load the data.
```python
import pandas as pd
# Load the data into a DataFrame
data = pd.read_csv('survivor_data.csv')
```
Step 2: Create a new DataFrame 'Q19' with the required columns.
```python
Q19 = data[['season_name', 'season', 'castaway_id', 'full_name', 'tribal_council_votes', 'jury_votes']]
```
Step 3: Apply the filters to find the perfect game players.
```python
Q19 = Q19[(Q19['tribal_council_votes'] == 0) & (Q19['jury_votes'] == 'unanimous')]
```
Step 4: Sort the DataFrame by season and reset the index.
```python
Q19.sort_values(by='season', inplace=True)
Q19.reset_index(drop=True, inplace=True)
```
The resulting DataFrame 'Q19' will contain the information of contestants who played a perfect game, sorted by season, and with the index starting from 0 to n-1.