<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>sexual_orientation</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>
    </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.0</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>
    </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>1.0</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>
    </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.0</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>
    </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.0</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>
    </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.0</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>
    </tr>
  </tbody>
</table>
<p>5 rows × 88 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  ...  sexual_orientation  \
0  My reaction to the main characters which was t...  ...                 1.0   
1  I liked the characters. Likeable for the most ...  ...                 1.0   
2                                                -99  ...                 1.0   
3  The main character seemed like a sweet soul. I...  ...                 1.0   
4  Jacques is very smart, observate and totally r...  ...                 1.0   

  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  
0  1993                          99   8093.0  
1  1986                          99   7035.0  
2  1996                 22019;22018  62203.0  
3  1998                       12021  76031.0  
4  1974                          99  53206.0  

[5 rows x 88 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>involved_experiences</th>
      <th>knew_feelings</th>
      <th>knew_experiences</th>
      <th>easily_identify</th>
      <th>understand_perspective</th>
      <th>found_interesting</th>
      <th>found_memorable</th>
      <th>reminded_of_myself</th>
      <th>reminded_of_someone</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>4</td>
      <td>6</td>
      <td>5</td>
      <td>6</td>
      <td>7</td>
      <td>6</td>
      <td>6</td>
      <td>5</td>
      <td>6</td>
    </tr>
    <tr>
      <th>1</th>
      <td>5</td>
      <td>4</td>
      <td>4</td>
      <td>4</td>
      <td>6</td>
      <td>5</td>
      <td>5</td>
      <td>5</td>
      <td>5</td>
    </tr>
    <tr>
      <th>2</th>
      <td>4</td>
      <td>5</td>
      <td>5</td>
      <td>1</td>
      <td>6</td>
      <td>7</td>
      <td>7</td>
      <td>2</td>
      <td>2</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2</td>
      <td>1</td>
      <td>1</td>
      <td>1</td>
      <td>3</td>
      <td>4</td>
      <td>2</td>
      <td>1</td>
      <td>1</td>
    </tr>
    <tr>
      <th>4</th>
      <td>7</td>
      <td>7</td>
      <td>7</td>
      <td>7</td>
      <td>7</td>
      <td>7</td>
      <td>6</td>
      <td>7</td>
      <td>7</td>
    </tr>
  </tbody>
</table>
</div>

   involved_experiences  knew_feelings knew_experiences  easily_identify  \
0                     4              6                5                6   
1                     5              4                4                4   
2                     4              5                5                1   
3                     2              1                1                1   
4                     7              7                7                7   

   understand_perspective  found_interesting  found_memorable  \
0                       7                  6                6   
1                       6                  5                5   
2                       6                  7                7   
3                       3                  4                2   
4                       7                  7                6   

   reminded_of_myself  reminded_of_someone  
0                   5                    6  
1                   5                    5  
2                   2                    2  
3                   1                    1  
4                   7                    7  

<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>Missing Value Share (%)</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>involved_experiences</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>knew_feelings</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>knew_experiences</th>
      <td>0.083126</td>
    </tr>
    <tr>
      <th>easily_identify</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>understand_perspective</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>found_interesting</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>found_memorable</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>reminded_of_myself</th>
      <td>0.000000</td>
    </tr>
    <tr>
      <th>reminded_of_someone</th>
      <td>0.000000</td>
    </tr>
  </tbody>
</table>
</div>

                        Missing Value Share (%)
involved_experiences                   0.000000
knew_feelings                          0.000000
knew_experiences                       0.083126
easily_identify                        0.000000
understand_perspective                 0.000000
found_interesting                      0.000000
found_memorable                        0.000000
reminded_of_myself                     0.000000
reminded_of_someone                    0.000000

<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>character_identification</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>5.666667</td>
    </tr>
    <tr>
      <th>1</th>
      <td>4.777778</td>
    </tr>
    <tr>
      <th>2</th>
      <td>4.333333</td>
    </tr>
    <tr>
      <th>3</th>
      <td>1.777778</td>
    </tr>
    <tr>
      <th>4</th>
      <td>6.888889</td>
    </tr>
  </tbody>
</table>
</div>

  character_identification
0                 5.666667
1                 4.777778
2                 4.333333
3                 1.777778
4                 6.888889

9. Index the character identification variables.

load the dataset

Set values of -88 and -99 to missing for the columns `involved_experiences` `knew_feelings` `knew_experiences` `easily_identify` `understand_perspective` `found_interesting` `found_memorable` `reminded_of_myself` `reminded_of_someone`

Create a table to show me the share of missing values for `involved_experiences` `knew_feelings` `knew_experiences` `easily_identify` `understand_perspective` `found_interesting` `found_memorable` `reminded_of_myself` `reminded_of_someone`

Run a reliability analysis and report a cronbach's alpha for `involved_experiences` `knew_feelings` `knew_experiences` `easily_identify` `understand_perspective` `found_interesting` `found_memorable` `reminded_of_myself` `reminded_of_someone`

Index the following variables into a new variable called character_identification: `involved_experiences` `knew_feelings` `knew_experiences` `easily_identify` `understand_perspective` `found_interesting` `found_memorable` `reminded_of_myself` `reminded_of_someone`

Can you visualize the distribution of the new variable `character_identification`?

save the new dataset as an excel file called chapter_study_1

Column Name	Missing Value Share (%)
involved_experiences	0.00
knew_feelings	0.00
knew_experiences	0.08
easily_identify	0.00
understand_perspective	0.00
found_interesting	0.00
found_memorable	0.00
reminded_of_myself	0.00
reminded_of_someone	0.00

load the dataset

Set values of -88 and -99 to missing for the columns involved_experiences knew_feelings knew_experiences easily_identify understand_perspective found_interesting found_memorable reminded_of_myself reminded_of_someone

Create a table to show me the share of missing values for involved_experiences knew_feelings knew_experiences easily_identify understand_perspective found_interesting found_memorable reminded_of_myself reminded_of_someone

Run a reliability analysis and report a cronbach's alpha for involved_experiences knew_feelings knew_experiences easily_identify understand_perspective found_interesting found_memorable reminded_of_myself reminded_of_someone