<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Start Date</th>
      <th>End Date</th>
      <th>Progress</th>
      <th>Duration (in seconds)</th>
      <th>Finished</th>
      <th>Recorded Date</th>
      <th>Response ID</th>
      <th>consent</th>
      <th>stood_out</th>
      <th>character_impressions</th>
      <th>...</th>
      <th>social_media_accounts</th>
      <th>social_media_used</th>
      <th>social_political_ideology</th>
      <th>state</th>
      <th>vehicle_types</th>
      <th>voter_registration_usa</th>
      <th>yob</th>
      <th>yob_and_gender_of_children</th>
      <th>zip</th>
      <th>character_identification</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2025-03-22 09:37:15</td>
      <td>2025-03-22 10:06:03</td>
      <td>100</td>
      <td>1727</td>
      <td>1</td>
      <td>2025-03-22 10:06:03.466</td>
      <td>R_59vk9us5U8IP3gf</td>
      <td>1</td>
      <td>What stood out to me the most about the clip w...</td>
      <td>My reaction to the main characters which was t...</td>
      <td>...</td>
      <td>NaN</td>
      <td>13;18;3;10;5;4;9;2;8;11;1;19</td>
      <td>2.0</td>
      <td>NJ</td>
      <td>1</td>
      <td>1.0</td>
      <td>1993</td>
      <td>99</td>
      <td>8093.0</td>
      <td>5.666667</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2025-03-22 09:37:17</td>
      <td>2025-03-22 09:58:44</td>
      <td>100</td>
      <td>1286</td>
      <td>1</td>
      <td>2025-03-22 09:58:44.783</td>
      <td>R_6JggRfb6ow9nZfc</td>
      <td>1</td>
      <td>I was more interested in the Inuet culture and...</td>
      <td>I liked the characters. Likeable for the most ...</td>
      <td>...</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>5.0</td>
      <td>NJ</td>
      <td>NaN</td>
      <td>1.0</td>
      <td>1986</td>
      <td>99</td>
      <td>7035.0</td>
      <td>4.777778</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2025-03-22 09:37:37</td>
      <td>2025-03-22 09:57:50</td>
      <td>100</td>
      <td>1213</td>
      <td>1</td>
      <td>2025-03-22 09:57:55.730</td>
      <td>R_5tMxxNsXZ6QDuLj</td>
      <td>1</td>
      <td>-99</td>
      <td>-99</td>
      <td>...</td>
      <td>NaN</td>
      <td>4;10;19;11</td>
      <td>4.0</td>
      <td>IL</td>
      <td>1</td>
      <td>1.0</td>
      <td>1996</td>
      <td>22019;22018</td>
      <td>62203.0</td>
      <td>4.333333</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2025-03-22 09:37:47</td>
      <td>2025-03-22 10:01:50</td>
      <td>100</td>
      <td>1443</td>
      <td>1</td>
      <td>2025-03-22 10:01:50.785</td>
      <td>R_5lKeFwUGE7lDwGh</td>
      <td>1</td>
      <td>The red frame that was used to isolate differe...</td>
      <td>The main character seemed like a sweet soul. I...</td>
      <td>...</td>
      <td>NaN</td>
      <td>10;13;16;3;18;2;9;8;4;11;19</td>
      <td>3.0</td>
      <td>TX</td>
      <td>1</td>
      <td>1.0</td>
      <td>1998</td>
      <td>12021</td>
      <td>76031.0</td>
      <td>1.777778</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2025-03-22 09:37:48</td>
      <td>2025-03-22 09:53:02</td>
      <td>100</td>
      <td>914</td>
      <td>1</td>
      <td>2025-03-22 09:53:03.277</td>
      <td>R_6uPZbRrXC8qBe2Z</td>
      <td>1</td>
      <td>What stood out to me the most is that we are n...</td>
      <td>Jacques is very smart, observate and totally r...</td>
      <td>...</td>
      <td>11;2;3;4;13;19;9;10</td>
      <td>4;19;18;5;2;12;3;9;13;11;10</td>
      <td>4.0</td>
      <td>WI</td>
      <td>1</td>
      <td>1.0</td>
      <td>1974</td>
      <td>99</td>
      <td>53206.0</td>
      <td>6.888889</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 89 columns</p>
</div>

           Start Date            End Date  Progress  Duration (in seconds)  \
0 2025-03-22 09:37:15 2025-03-22 10:06:03       100                   1727   
1 2025-03-22 09:37:17 2025-03-22 09:58:44       100                   1286   
2 2025-03-22 09:37:37 2025-03-22 09:57:50       100                   1213   
3 2025-03-22 09:37:47 2025-03-22 10:01:50       100                   1443   
4 2025-03-22 09:37:48 2025-03-22 09:53:02       100                    914   

   Finished           Recorded Date        Response ID  consent  \
0         1 2025-03-22 10:06:03.466  R_59vk9us5U8IP3gf        1   
1         1 2025-03-22 09:58:44.783  R_6JggRfb6ow9nZfc        1   
2         1 2025-03-22 09:57:55.730  R_5tMxxNsXZ6QDuLj        1   
3         1 2025-03-22 10:01:50.785  R_5lKeFwUGE7lDwGh        1   
4         1 2025-03-22 09:53:03.277  R_6uPZbRrXC8qBe2Z        1   

                                           stood_out  \
0  What stood out to me the most about the clip w...   
1  I was more interested in the Inuet culture and...   
2                                                -99   
3  The red frame that was used to isolate differe...   
4  What stood out to me the most is that we are n...   

                               character_impressions  ...  \
0  My reaction to the main characters which was t...  ...   
1  I liked the characters. Likeable for the most ...  ...   
2                                                -99  ...   
3  The main character seemed like a sweet soul. I...  ...   
4  Jacques is very smart, observate and totally r...  ...   

   social_media_accounts             social_media_used  \
0                    NaN  13;18;3;10;5;4;9;2;8;11;1;19   
1                    NaN                           NaN   
2                    NaN                    4;10;19;11   
3                    NaN   10;13;16;3;18;2;9;8;4;11;19   
4    11;2;3;4;13;19;9;10   4;19;18;5;2;12;3;9;13;11;10   

  social_political_ideology  state  vehicle_types  voter_registration_usa  \
0                       2.0     NJ              1                     1.0   
1                       5.0     NJ            NaN                     1.0   
2                       4.0     IL              1                     1.0   
3                       3.0     TX              1                     1.0   
4                       4.0     WI              1                     1.0   

    yob  yob_and_gender_of_children      zip  character_identification  
0  1993                          99   8093.0                  5.666667  
1  1986                          99   7035.0                  4.777778  
2  1996                 22019;22018  62203.0                  4.333333  
3  1998                       12021  76031.0                  1.777778  
4  1974                          99  53206.0                  6.888889  

[5 rows x 89 columns]

11. Recode and label certain variables.

Load the dataset.

save the dataset as a new excel file called chatper_study_2.