(         Response ID                          stood_out_emotion_matches  \
 0  R_59vk9us5U8IP3gf  ['commitment', 'passion', 'moral', 'appreciati...   
 1  R_6JggRfb6ow9nZfc                          ['inspire', 'interested']   
 2  R_5lKeFwUGE7lDwGh                                                 []   
 3  R_6uPZbRrXC8qBe2Z                                      ['observing']   
 4  R_6fVs5ZIyI0kQR6T                                                 []   
 
                    stood_out_emotion_categories  emotion_edited  emotion_locus  
 0  ['passionate', 'respectful', 'appreciative']             0.0            3.0  
 1                                     [annoyed]             1.0            1.0  
 2                                            []             0.0            0.0  
 3                                 ['observant']             0.0            1.0  
 4                                    [confused]             1.0            1.0  ,
            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])

<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>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>
      <th>stood_out_emotion_matches</th>
      <th>stood_out_emotion_categories</th>
      <th>emotion_edited</th>
      <th>emotion_locus</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>1</td>
      <td>1.0</td>
      <td>1993</td>
      <td>99</td>
      <td>8093.0</td>
      <td>5.666667</td>
      <td>['commitment', 'passion', 'moral', 'appreciati...</td>
      <td>['passionate', 'respectful', 'appreciative']</td>
      <td>0.0</td>
      <td>3.0</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>1.0</td>
      <td>1986</td>
      <td>99</td>
      <td>7035.0</td>
      <td>4.777778</td>
      <td>['inspire', 'interested']</td>
      <td>[annoyed]</td>
      <td>1.0</td>
      <td>1.0</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>1</td>
      <td>1.0</td>
      <td>1996</td>
      <td>22019;22018</td>
      <td>62203.0</td>
      <td>4.333333</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>NaN</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>1</td>
      <td>1.0</td>
      <td>1998</td>
      <td>12021</td>
      <td>76031.0</td>
      <td>1.777778</td>
      <td>[]</td>
      <td>[]</td>
      <td>0.0</td>
      <td>0.0</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>1</td>
      <td>1.0</td>
      <td>1974</td>
      <td>99</td>
      <td>53206.0</td>
      <td>6.888889</td>
      <td>['observing']</td>
      <td>['observant']</td>
      <td>0.0</td>
      <td>1.0</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 93 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  ...  vehicle_types  \
0  My reaction to the main characters which was t...  ...              1   
1  I liked the characters. Likeable for the most ...  ...            NaN   
2                                                -99  ...              1   
3  The main character seemed like a sweet soul. I...  ...              1   
4  Jacques is very smart, observate and totally r...  ...              1   

  voter_registration_usa   yob  yob_and_gender_of_children      zip  \
0                    1.0  1993                          99   8093.0   
1                    1.0  1986                          99   7035.0   
2                    1.0  1996                 22019;22018  62203.0   
3                    1.0  1998                       12021  76031.0   
4                    1.0  1974                          99  53206.0   

   character_identification  \
0                  5.666667   
1                  4.777778   
2                  4.333333   
3                  1.777778   
4                  6.888889   

                           stood_out_emotion_matches  \
0  ['commitment', 'passion', 'moral', 'appreciati...   
1                          ['inspire', 'interested']   
2                                                NaN   
3                                                 []   
4                                      ['observing']   

                   stood_out_emotion_categories  emotion_edited  emotion_locus  
0  ['passionate', 'respectful', 'appreciative']             0.0            3.0  
1                                     [annoyed]             1.0            1.0  
2                                           NaN             NaN            NaN  
3                                            []             0.0            0.0  
4                                 ['observant']             0.0            1.0  

[5 rows x 93 columns]

20. Merge the manually-coded emotion variables into the clean chapter study dataset

Load these files and make sure the stood_out column in chapter_study_clean_xlsx is readable as string data.

`chapter_study_emotions_manual.csv`

`chapter_study_clean.xlsx`

Use the Response_ID columns to merge the chapter_study_emotions_manual file into the dataset.

save the new dataset as an excel file