(           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],
            Word                                      Similar Words
 0     alienated                    ['disconnected', 'unrelatable']
 1       annoyed                                       ['annoying']
 2  apprehensive                                   ['apprehensive']
 3     approving  ['approve', 'pleasant', 'pleased', 'excellent'...
 4       ashamed                                          ['shame'])

<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_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>
      <th>stood_out_emotion_matches</th>
      <th>stood_out_emotion_categories</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>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>
      <td>[commitment, appreciation, moral, passion]</td>
      <td>[passionate, respectful, appreciative]</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>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>
      <td>[inspire, interest, interested]</td>
      <td>[interested, inspired]</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></td>
      <td>-99</td>
      <td>...</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>
      <td>[]</td>
      <td>[]</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>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>
      <td>[]</td>
      <td>[]</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>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>
      <td>[observing]</td>
      <td>[observant]</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 91 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                                                      
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_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   

                    stood_out_emotion_matches  \
0  [commitment, appreciation, moral, passion]   
1             [inspire, interest, interested]   
2                                          []   
3                                          []   
4                                 [observing]   

             stood_out_emotion_categories  
0  [passionate, respectful, appreciative]  
1                  [interested, inspired]  
2                                      []  
3                                      []  
4                             [observant]  

[5 rows x 91 columns]

19. Recategorizing the emotional language using the round 6 groupings.

Can you show me a preview of the updated dataframe?

Can you visualize the distribution of emotion categories?

Start Date	stood_out	stood_out_emotion_matches	stood_out_emotion_categories
2025-03-22 09:37:15	What stood out to me the most about the clip was...	[commitment, appreciation, moral, passion]	[passionate, respectful, appreciative]
2025-03-22 09:37:17	I was more inspired and interested in the topic...	[inspire, interest, interested]	[interested, inspired]
2025-03-22 09:37:37	...	[]	[]
2025-03-22 09:37:47	...	[]	[]
2025-03-22 09:37:48	Observing the reactions was quite enlightening...	[observing]	[observant]