<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>Response Type</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>...</th>
      <th>interest_full_film</th>
      <th>geographic_place</th>
      <th>self_geographic_place</th>
      <th>self_geographic_place_other</th>
      <th>science_proximity</th>
      <th>ses_class</th>
      <th>self_working_class</th>
      <th>RESPONDENT_ID</th>
      <th>chapter</th>
      <th>FL_11 - Block Randomizer - Display Order</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2025-03-22 13:29:48</td>
      <td>2025-03-22 13:50:41</td>
      <td>0</td>
      <td>43</td>
      <td>1253</td>
      <td>0</td>
      <td>2025-03-29 13:50:42.779</td>
      <td>R_17TH94VMms3c97d</td>
      <td>1</td>
      <td>What stood out to me the most was how the spea...</td>
      <td>...</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>NaN</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>iP4ae4cb279d9237c7</td>
      <td>greenland</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2025-03-22 13:30:05</td>
      <td>2025-03-22 13:45:49</td>
      <td>0</td>
      <td>43</td>
      <td>944</td>
      <td>0</td>
      <td>2025-03-29 13:45:53.147</td>
      <td>R_74dbiuw6ul2JZ8l</td>
      <td>1</td>
      <td>What stood out to me was how the speaker conne...</td>
      <td>...</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>NaN</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>iP4ae4cb279d9237c7</td>
      <td>greenland</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2025-03-27 13:08:22</td>
      <td>2025-04-01 12:25:51</td>
      <td>0</td>
      <td>48</td>
      <td>429448</td>
      <td>0</td>
      <td>2025-04-08 12:25:51.601</td>
      <td>R_60ks9UK0khEVD2s</td>
      <td>1</td>
      <td>For 15 years he likes looking at things.</td>
      <td>...</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>NaN</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>iPc12c085e85fc727e</td>
      <td>seoul</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2025-03-27 14:34:13</td>
      <td>2025-03-27 14:41:41</td>
      <td>0</td>
      <td>48</td>
      <td>447</td>
      <td>0</td>
      <td>2025-04-03 14:41:45.051</td>
      <td>R_6m1RYLMbgLIL9tt</td>
      <td>1</td>
      <td>-99</td>
      <td>...</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>NaN</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>iP4dfe1f538c8f41e2</td>
      <td>maine</td>
      <td>NaN</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2025-03-27 14:40:09</td>
      <td>2025-03-27 15:01:41</td>
      <td>0</td>
      <td>48</td>
      <td>1291</td>
      <td>0</td>
      <td>2025-04-03 15:01:41.576</td>
      <td>R_7L2jD56NNlBjHxf</td>
      <td>1</td>
      <td>Interesting science coverage</td>
      <td>...</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>NaN</td>
      <td>-88</td>
      <td>-88</td>
      <td>-88</td>
      <td>iP301ca7081b5be1e0</td>
      <td>pantalica</td>
      <td>NaN</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 51 columns</p>
</div>

           Start Date            End Date  Response Type  Progress  \
0 2025-03-22 13:29:48 2025-03-22 13:50:41              0        43   
1 2025-03-22 13:30:05 2025-03-22 13:45:49              0        43   
2 2025-03-27 13:08:22 2025-04-01 12:25:51              0        48   
3 2025-03-27 14:34:13 2025-03-27 14:41:41              0        48   
4 2025-03-27 14:40:09 2025-03-27 15:01:41              0        48   

   Duration (in seconds)  Finished           Recorded Date        Response ID  \
0                   1253         0 2025-03-29 13:50:42.779  R_17TH94VMms3c97d   
1                    944         0 2025-03-29 13:45:53.147  R_74dbiuw6ul2JZ8l   
2                 429448         0 2025-04-08 12:25:51.601  R_60ks9UK0khEVD2s   
3                    447         0 2025-04-03 14:41:45.051  R_6m1RYLMbgLIL9tt   
4                   1291         0 2025-04-03 15:01:41.576  R_7L2jD56NNlBjHxf   

   consent                                          stood_out  ...  \
0        1  What stood out to me the most was how the spea...  ...   
1        1  What stood out to me was how the speaker conne...  ...   
2        1          For 15 years he likes looking at things.   ...   
3        1                                                -99  ...   
4        1                       Interesting science coverage  ...   

  interest_full_film  geographic_place self_geographic_place  \
0                -88               -88                   -88   
1                -88               -88                   -88   
2                -88               -88                   -88   
3                -88               -88                   -88   
4                -88               -88                   -88   

  self_geographic_place_other  science_proximity  ses_class  \
0                         NaN                -88        -88   
1                         NaN                -88        -88   
2                         NaN                -88        -88   
3                         NaN                -88        -88   
4                         NaN                -88        -88   

   self_working_class       RESPONDENT_ID    chapter  \
0                 -88  iP4ae4cb279d9237c7  greenland   
1                 -88  iP4ae4cb279d9237c7  greenland   
2                 -88  iPc12c085e85fc727e      seoul   
3                 -88  iP4dfe1f538c8f41e2      maine   
4                 -88  iP301ca7081b5be1e0  pantalica   

   FL_11 - Block Randomizer - Display Order  
0                                       NaN  
1                                       NaN  
2                                       NaN  
3                                       NaN  
4                                       NaN  

[5 rows x 51 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>Response Type</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>...</th>
      <th>interest_full_film</th>
      <th>geographic_place</th>
      <th>self_geographic_place</th>
      <th>self_geographic_place_other</th>
      <th>science_proximity</th>
      <th>ses_class</th>
      <th>self_working_class</th>
      <th>RESPONDENT_ID</th>
      <th>chapter</th>
      <th>FL_11 - Block Randomizer - Display Order</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>63</th>
      <td>2025-03-22 09:37:15</td>
      <td>2025-03-22 10:06:03</td>
      <td>0</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>...</td>
      <td>4</td>
      <td>2</td>
      <td>2</td>
      <td>-99</td>
      <td>5</td>
      <td>3</td>
      <td>3</td>
      <td>iPa8503af03bb284a8</td>
      <td>atacama</td>
      <td>Trust|Valuealignment</td>
    </tr>
    <tr>
      <th>64</th>
      <td>2025-03-22 09:37:17</td>
      <td>2025-03-22 09:58:44</td>
      <td>0</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>...</td>
      <td>3</td>
      <td>2</td>
      <td>1</td>
      <td>-99</td>
      <td>6</td>
      <td>3</td>
      <td>1</td>
      <td>iPb4802d8779fc7ac9</td>
      <td>greenland</td>
      <td>Trust|Valuealignment</td>
    </tr>
    <tr>
      <th>65</th>
      <td>2025-03-22 09:37:37</td>
      <td>2025-03-22 09:57:50</td>
      <td>0</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>...</td>
      <td>5</td>
      <td>2</td>
      <td>2</td>
      <td>-99</td>
      <td>10</td>
      <td>3</td>
      <td>1</td>
      <td>iPe86aa9eb73b9c47b</td>
      <td>seoul</td>
      <td>Valuealignment|Trust</td>
    </tr>
    <tr>
      <th>66</th>
      <td>2025-03-22 09:37:47</td>
      <td>2025-03-22 10:01:50</td>
      <td>0</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>...</td>
      <td>2</td>
      <td>1</td>
      <td>4</td>
      <td>-99</td>
      <td>10</td>
      <td>2</td>
      <td>1</td>
      <td>iP303583bbd989478e</td>
      <td>greenland</td>
      <td>Valuealignment|Trust</td>
    </tr>
    <tr>
      <th>67</th>
      <td>2025-03-22 09:37:48</td>
      <td>2025-03-22 09:53:02</td>
      <td>0</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>...</td>
      <td>5</td>
      <td>4</td>
      <td>1</td>
      <td>-99</td>
      <td>9</td>
      <td>2</td>
      <td>2</td>
      <td>iP2a6138fe72ec5982</td>
      <td>maine</td>
      <td>Trust|Valuealignment</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 51 columns</p>
</div>

            Start Date            End Date  Response Type  Progress  \
63 2025-03-22 09:37:15 2025-03-22 10:06:03              0       100   
64 2025-03-22 09:37:17 2025-03-22 09:58:44              0       100   
65 2025-03-22 09:37:37 2025-03-22 09:57:50              0       100   
66 2025-03-22 09:37:47 2025-03-22 10:01:50              0       100   
67 2025-03-22 09:37:48 2025-03-22 09:53:02              0       100   

    Duration (in seconds)  Finished           Recorded Date  \
63                   1727         1 2025-03-22 10:06:03.466   
64                   1286         1 2025-03-22 09:58:44.783   
65                   1213         1 2025-03-22 09:57:55.730   
66                   1443         1 2025-03-22 10:01:50.785   
67                    914         1 2025-03-22 09:53:03.277   

          Response ID  consent  \
63  R_59vk9us5U8IP3gf        1   
64  R_6JggRfb6ow9nZfc        1   
65  R_5tMxxNsXZ6QDuLj        1   
66  R_5lKeFwUGE7lDwGh        1   
67  R_6uPZbRrXC8qBe2Z        1   

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

    geographic_place self_geographic_place self_geographic_place_other  \
63                 2                     2                         -99   
64                 2                     1                         -99   
65                 2                     2                         -99   
66                 1                     4                         -99   
67                 4                     1                         -99   

    science_proximity  ses_class  self_working_class       RESPONDENT_ID  \
63                  5          3                   3  iPa8503af03bb284a8   
64                  6          3                   1  iPb4802d8779fc7ac9   
65                 10          3                   1  iPe86aa9eb73b9c47b   
66                 10          2                   1  iP303583bbd989478e   
67                  9          2                   2  iP2a6138fe72ec5982   

      chapter  FL_11 - Block Randomizer - Display Order  
63    atacama                      Trust|Valuealignment  
64  greenland                      Trust|Valuealignment  
65      seoul                      Valuealignment|Trust  
66  greenland                      Valuealignment|Trust  
67      maine                      Trust|Valuealignment  

[5 rows x 51 columns]

6. Save only the finished responses as their own dataset

Load the dataset

How many rows have `Finished` =1

Subsest the rows where `Finished` =1 and put them in a new dataset called qualtrics_finished_clean

Save the qualtrics_finished_clean dataframe as a new excel file that has the same name.

Load the dataset

How many rows have Finished =1

Subsest the rows where Finished =1 and put them in a new dataset called qualtrics_finished_clean

Save the qualtrics_finished_clean dataframe as a new excel file that has the same name.

How many rows have `Finished` =1

Subsest the rows where `Finished` =1 and put them in a new dataset called qualtrics_finished_clean