{ "cells": [ { "cell_type": "code", "id": "initial_id", "metadata": { "collapsed": true, "ExecuteTime": { "end_time": "2026-03-28T18:06:02.184586Z", "start_time": "2026-03-28T18:05:58.061588Z" } }, "source": [ "# -------------------------\n", "# 1. LOAD DATA\n", "# -------------------------\n", "\n", "import pandas as pd\n", "\n", "# Part 2 (experiment data)\n", "no = pd.read_excel(\"No_Music.xlsx\")\n", "mozart = pd.read_excel(\"Mozart.xlsx\")\n", "person = pd.read_excel(\"Personalized.xlsx\")\n", "\n", "# Combine Part 2 files\n", "df = pd.concat([no, mozart, person], ignore_index=True)\n", "\n", "\n", "# Part 1 (pre-survey data)\n", "survey = pd.read_excel(\"PreSurvey.xlsx\")" ], "outputs": [], "execution_count": 33 }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-28T18:06:03.919777Z", "start_time": "2026-03-28T18:06:03.894595Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 2. DEFINE COLUMN GROUPS\n", "# -------------------------\n", "\n", "# Investment rounds\n", "inv_cols = [\n", " 'thesis_exp_main_task.1.player.investment',\n", " 'thesis_exp_main_task.2.player.investment',\n", " 'thesis_exp_main_task.3.player.investment',\n", " 'thesis_exp_main_task.4.player.investment',\n", " 'thesis_exp_main_task.5.player.investment',\n", " 'thesis_exp_main_task.6.player.investment'\n", "]\n", "\n", "# Investment time spent\n", "inv_time_cols = [\n", " 'thesis_exp_main_task.1.player.time_spent',\n", " 'thesis_exp_main_task.2.player.time_spent',\n", " 'thesis_exp_main_task.3.player.time_spent',\n", " 'thesis_exp_main_task.4.player.time_spent',\n", " 'thesis_exp_main_task.5.player.time_spent',\n", " 'thesis_exp_main_task.6.player.time_spent'\n", "]\n", "\n", "# Math correctness\n", "math_cols = [\n", " 'thesis_exp_main_task.7.player.correct',\n", " 'thesis_exp_main_task.8.player.correct',\n", " 'thesis_exp_main_task.9.player.correct',\n", " 'thesis_exp_main_task.10.player.correct',\n", " 'thesis_exp_main_task.11.player.correct',\n", " 'thesis_exp_main_task.12.player.correct'\n", "]\n", "\n", "\n", "# Math time spent\n", "math_time_cols = [\n", " 'thesis_exp_main_task.7.player.time_spent',\n", " 'thesis_exp_main_task.8.player.time_spent',\n", " 'thesis_exp_main_task.9.player.time_spent',\n", " 'thesis_exp_main_task.10.player.time_spent',\n", " 'thesis_exp_main_task.11.player.time_spent',\n", " 'thesis_exp_main_task.12.player.time_spent'\n", "]\n" ], "id": "ad677a430aa29ce7", "outputs": [], "execution_count": 34 }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-28T18:06:07.413737Z", "start_time": "2026-03-28T18:06:07.382473Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 3. CREATE CLEAN VARIABLES\n", "# -------------------------\n", "\n", "# Code (Merge key)\n", "df['exp_code'] = df['participant.exp_code']\n", "\n", "# Treatment\n", "df['treatment'] = df['participant.treatment']\n", "\n", "# Riskiness\n", "df['riskiness'] = df[inv_cols].mean(axis=1)\n", "\n", "# Investment speed\n", "df['inv_speed'] = df[inv_time_cols].mean(axis=1)\n", "\n", "# Math accuracy\n", "df['math_accuracy'] = df[math_cols].mean(axis=1)\n", "\n", "# Math speed\n", "df['math_speed'] = df[math_time_cols].mean(axis=1)" ], "id": "d2ff332758fa50aa", "outputs": [], "execution_count": 35 }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-28T18:06:11.181730Z", "start_time": "2026-03-28T18:06:11.082514Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 4. MERGE WITH PRE-SURVEY DATA\n", "# -------------------------\n", "\n", "# Merge Part 2 (df) with Part 1 (survey) using exp_code\n", "df = df.merge(survey, on='participant.exp_code', how='left')\n", "df" ], "id": "613ccc3cf2eb37f1", "outputs": [ { "data": { "text/plain": [ " participant._current_app_name_x participant._current_page_name_x \\\n", "0 thesis_exp_post_survey EmotionSurvey \n", "1 thesis_exp_post_survey EmotionSurvey \n", "2 thesis_exp_post_survey EmotionSurvey \n", "3 thesis_exp_post_survey EmotionSurvey \n", "4 thesis_exp_post_survey EmotionSurvey \n", "5 thesis_exp_post_survey EmotionSurvey \n", "6 thesis_exp_post_survey EmotionSurvey \n", "7 thesis_exp_post_survey EmotionSurvey \n", "8 thesis_exp_post_survey EmotionSurvey \n", "9 thesis_exp_post_survey EmotionSurvey \n", "10 thesis_exp_post_survey EmotionSurvey \n", "11 thesis_exp_post_survey EmotionSurvey \n", "12 thesis_exp_post_survey EmotionSurvey \n", "13 thesis_exp_post_survey EmotionSurvey \n", "14 thesis_exp_post_survey EmotionSurvey \n", "15 thesis_exp_post_survey EmotionSurvey \n", "16 thesis_exp_post_survey EmotionSurvey \n", "17 thesis_exp_post_survey EmotionSurvey \n", "18 thesis_exp_post_survey EmotionSurvey \n", "19 thesis_exp_post_survey EmotionSurvey \n", "20 thesis_exp_post_survey EmotionSurvey \n", "21 thesis_exp_post_survey EmotionSurvey \n", "22 thesis_exp_post_survey EmotionSurvey \n", "23 thesis_exp_post_survey EmotionSurvey \n", "24 thesis_exp_post_survey EmotionSurvey \n", "25 thesis_exp_post_survey EmotionSurvey \n", "26 thesis_exp_post_survey EmotionSurvey \n", "27 thesis_exp_post_survey EmotionSurvey \n", "28 thesis_exp_post_survey EmotionSurvey \n", "29 thesis_exp_post_survey EmotionSurvey \n", "30 thesis_exp_post_survey EmotionSurvey \n", "31 thesis_exp_post_survey EmotionSurvey \n", "32 thesis_exp_post_survey EmotionSurvey \n", "33 thesis_exp_post_survey EmotionSurvey \n", "34 thesis_exp_post_survey EmotionSurvey \n", "35 thesis_exp_post_survey EmotionSurvey \n", "36 thesis_exp_post_survey EmotionSurvey \n", "37 thesis_exp_post_survey EmotionSurvey \n", "38 thesis_exp_post_survey EmotionSurvey \n", "39 thesis_exp_post_survey EmotionSurvey \n", "40 thesis_exp_post_survey EmotionSurvey \n", "41 thesis_exp_post_survey EmotionSurvey \n", "42 thesis_exp_post_survey EmotionSurvey \n", "43 thesis_exp_post_survey EmotionSurvey \n", "44 thesis_exp_post_survey EmotionSurvey \n", "45 thesis_exp_post_survey EmotionSurvey \n", "46 thesis_exp_post_survey EmotionSurvey \n", "47 thesis_exp_post_survey EmotionSurvey \n", "48 thesis_exp_post_survey EmotionSurvey \n", "49 thesis_exp_post_survey EmotionSurvey \n", "50 thesis_exp_post_survey EmotionSurvey \n", "51 thesis_exp_post_survey EmotionSurvey \n", "52 thesis_exp_post_survey EmotionSurvey \n", "53 thesis_exp_post_survey EmotionSurvey \n", "54 thesis_exp_post_survey EmotionSurvey \n", "55 thesis_exp_post_survey EmotionSurvey \n", "56 thesis_exp_post_survey EmotionSurvey \n", "57 thesis_exp_post_survey EmotionSurvey \n", "\n", " participant.time_started_utc_x participant.payoff_x participant.exp_code \\\n", "0 2026-03-04 12:38:37.346 547 A02 \n", "1 2026-03-09 08:41:51.997 522 A07 \n", "2 2026-03-10 13:42:59.282 538 A09 \n", "3 2026-03-12 12:17:38.009 562 A01 \n", "4 2026-03-19 08:35:50.922 520 A11 \n", "5 2026-03-23 08:35:13.597 528 A15 \n", "6 2026-03-23 09:03:47.621 544 A99 \n", "7 2026-03-23 09:26:47.158 526 A19 \n", "8 2026-03-23 09:43:53.118 517 A13 \n", "9 2026-03-23 10:14:55.976 545 A18 \n", "10 2026-03-24 12:10:55.349 508 A16 \n", "11 2026-03-24 12:47:19.916 517 A21 \n", "12 2026-03-24 13:18:58.172 538 A24 \n", "13 2026-03-25 08:19:48.238 525 A23 \n", "14 2026-03-26 13:40:53.778 538 A27 \n", "15 2026-03-27 08:19:23.988 526 A30 \n", "16 2026-03-27 08:23:47.242 538 A08 \n", "17 2026-03-27 10:12:58.353 538 A28 \n", "18 2026-03-27 10:16:18.928 524 A20 \n", "19 2026-02-25 09:40:41.766 532 B05 \n", "20 2026-03-06 11:54:12.995 543 B08 \n", "21 2026-03-06 12:40:11.351 556 B06 \n", "22 2026-03-09 10:14:52.758 538 B07 \n", "23 2026-03-10 12:38:47.546 542 B03 \n", "24 2026-03-17 10:13:37.499 528 B09 \n", "25 2026-03-19 08:33:56.404 557 B11 \n", "26 2026-03-23 08:39:08.004 537 B14 \n", "27 2026-03-23 08:43:33.175 541 B16 \n", "28 2026-03-23 09:43:28.941 515 B12 \n", "29 2026-03-23 10:15:46.662 524 B18 \n", "30 2026-03-24 12:12:48.348 540 B17 \n", "31 2026-03-25 08:18:57.157 521 B13 \n", "32 2026-03-25 08:20:41.220 547 B20 \n", "33 2026-03-25 08:21:29.215 522 B24 \n", "34 2026-03-25 09:46:50.459 518 B22 \n", "35 2026-03-26 11:57:39.388 535 B90 \n", "36 2026-03-27 08:18:11.078 547 B26 \n", "37 2026-03-27 08:20:57.182 528 B25 \n", "38 2026-03-27 09:28:11.985 530 B30 \n", "39 2026-03-27 10:17:04.096 532 B15 \n", "40 2026-03-03 08:34:53.751 536 C04 \n", "41 2026-03-09 10:13:39.171 526 C08 \n", "42 2026-03-10 12:37:50.630 528 C07 \n", "43 2026-03-18 13:08:53.330 510 C09 \n", "44 2026-03-20 12:12:40.642 521 C10 \n", "45 2026-03-23 08:37:27.930 527 C14 \n", "46 2026-03-23 08:40:26.859 506 C17 \n", "47 2026-03-23 08:41:54.332 529 C13 \n", "48 2026-03-23 10:14:00.205 540 C05 \n", "49 2026-03-23 10:14:22.611 523 C15 \n", "50 2026-03-24 12:11:54.887 562 C11 \n", "51 2026-03-25 08:16:57.507 520 C16 \n", "52 2026-03-25 08:17:46.638 527 C12 \n", "53 2026-03-25 09:48:30.739 567 C22 \n", "54 2026-03-26 11:56:43.922 557 C28 \n", "55 2026-03-27 08:22:10.563 515 C29 \n", "56 2026-03-27 08:22:52.502 528 C18 \n", "57 2026-03-27 09:27:28.047 516 C30 \n", "\n", " participant.treatment_x thesis_exp_pre_survey.1.player.confirm_code_x \\\n", "0 no_music 1 \n", "1 no_music 1 \n", "2 no_music 1 \n", "3 no_music 1 \n", "4 no_music 1 \n", "5 no_music 1 \n", "6 no_music 1 \n", "7 no_music 1 \n", "8 no_music 1 \n", "9 no_music 1 \n", "10 no_music 1 \n", "11 no_music 1 \n", "12 no_music 1 \n", "13 no_music 1 \n", "14 no_music 1 \n", "15 no_music 1 \n", "16 no_music 1 \n", "17 no_music 1 \n", "18 no_music 1 \n", "19 slow_music 1 \n", "20 slow_music 1 \n", "21 slow_music 1 \n", "22 slow_music 1 \n", "23 slow_music 1 \n", "24 slow_music 1 \n", "25 slow_music 1 \n", "26 slow_music 1 \n", "27 slow_music 1 \n", "28 slow_music 1 \n", "29 slow_music 1 \n", "30 slow_music 1 \n", "31 slow_music 1 \n", "32 slow_music 1 \n", "33 slow_music 1 \n", "34 slow_music 1 \n", "35 slow_music 1 \n", "36 slow_music 1 \n", "37 slow_music 1 \n", "38 slow_music 1 \n", "39 slow_music 1 \n", "40 personalized_music 1 \n", "41 personalized_music 1 \n", "42 personalized_music 1 \n", "43 personalized_music 1 \n", "44 personalized_music 1 \n", "45 personalized_music 1 \n", "46 personalized_music 1 \n", "47 personalized_music 1 \n", "48 personalized_music 1 \n", "49 personalized_music 1 \n", "50 personalized_music 1 \n", "51 personalized_music 1 \n", "52 personalized_music 1 \n", "53 personalized_music 1 \n", "54 personalized_music 1 \n", "55 personalized_music 1 \n", "56 personalized_music 1 \n", "57 personalized_music 1 \n", "\n", " thesis_exp_pre_survey.1.player.audio_filename_x \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 mozart.mp3 \n", "20 mozart.mp3 \n", "21 mozart.mp3 \n", "22 mozart.mp3 \n", "23 mozart.mp3 \n", "24 mozart.mp3 \n", "25 mozart.mp3 \n", "26 mozart.mp3 \n", "27 mozart.mp3 \n", "28 mozart.mp3 \n", "29 mozart.mp3 \n", "30 mozart.mp3 \n", "31 mozart.mp3 \n", "32 mozart.mp3 \n", "33 mozart.mp3 \n", "34 mozart.mp3 \n", "35 mozart.mp3 \n", "36 mozart.mp3 \n", "37 mozart.mp3 \n", "38 mozart.mp3 \n", "39 mozart.mp3 \n", "40 C04.mp3 \n", "41 C08.mp3 \n", "42 C07.mp3 \n", "43 C09.mp3 \n", "44 C10.mp3 \n", "45 C14.mp3 \n", "46 C17.mp3 \n", "47 C13.mp3 \n", "48 C05.mp3 \n", "49 C15.mp3 \n", "50 C11.mp3 \n", "51 C16.mp3 \n", "52 C12.mp3 \n", "53 C22.mp3 \n", "54 C28.mp3 \n", "55 C29.mp3 \n", "56 C18.mp3 \n", "57 C30.mp3 \n", "\n", " thesis_exp_pre_survey.1.player.audio_file_exists_x \\\n", "0 0 \n", "1 0 \n", "2 0 \n", "3 0 \n", "4 0 \n", "5 0 \n", "6 0 \n", "7 0 \n", "8 0 \n", "9 0 \n", "10 0 \n", "11 0 \n", "12 0 \n", "13 0 \n", "14 0 \n", "15 0 \n", "16 0 \n", "17 0 \n", "18 0 \n", "19 1 \n", "20 1 \n", "21 1 \n", "22 1 \n", "23 1 \n", "24 1 \n", "25 1 \n", "26 1 \n", "27 1 \n", "28 1 \n", "29 1 \n", "30 1 \n", "31 1 \n", "32 1 \n", "33 1 \n", "34 1 \n", "35 1 \n", "36 1 \n", "37 1 \n", "38 1 \n", "39 1 \n", "40 1 \n", "41 1 \n", "42 1 \n", "43 1 \n", "44 1 \n", "45 1 \n", "46 1 \n", "47 1 \n", "48 1 \n", "49 1 \n", "50 1 \n", "51 1 \n", "52 1 \n", "53 1 \n", "54 1 \n", "55 1 \n", "56 1 \n", "57 1 \n", "\n", " thesis_exp_pre_survey.1.player.confirm_ready_x ... \\\n", "0 1 ... \n", "1 1 ... \n", "2 1 ... \n", "3 1 ... \n", "4 1 ... \n", "5 1 ... \n", "6 1 ... \n", "7 1 ... \n", "8 1 ... \n", "9 1 ... \n", "10 1 ... \n", "11 1 ... \n", "12 1 ... \n", "13 1 ... \n", "14 1 ... \n", "15 1 ... \n", "16 1 ... \n", "17 1 ... \n", "18 1 ... \n", "19 1 ... \n", "20 1 ... \n", "21 1 ... \n", "22 1 ... \n", "23 1 ... \n", "24 1 ... \n", "25 1 ... \n", "26 1 ... \n", "27 1 ... \n", "28 1 ... \n", "29 1 ... \n", "30 1 ... \n", "31 1 ... \n", "32 1 ... \n", "33 1 ... \n", "34 1 ... \n", "35 1 ... \n", "36 1 ... \n", "37 1 ... \n", "38 1 ... \n", "39 1 ... \n", "40 1 ... \n", "41 1 ... \n", "42 1 ... \n", "43 1 ... \n", "44 1 ... \n", "45 1 ... \n", "46 1 ... \n", "47 1 ... \n", "48 1 ... \n", "49 1 ... \n", "50 1 ... \n", "51 1 ... \n", "52 1 ... \n", "53 1 ... \n", "54 1 ... \n", "55 1 ... \n", "56 1 ... \n", "57 1 ... \n", "\n", " thesis_exp_pre_survey.1.player.confirm_code_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.treatment \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.audio_filename_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.audio_file_exists_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.confirm_ready_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.emo_calmness_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.emo_energy_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.player.emo_mood_y \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.group.id_in_subsession \\\n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", " thesis_exp_pre_survey.1.subsession.round_number \n", "0 NaN \n", "1 NaN \n", "2 NaN \n", "3 NaN \n", "4 NaN \n", "5 NaN \n", "6 NaN \n", "7 NaN \n", "8 NaN \n", "9 NaN \n", "10 NaN \n", "11 NaN \n", "12 NaN \n", "13 NaN \n", "14 NaN \n", "15 NaN \n", "16 NaN \n", "17 NaN \n", "18 NaN \n", "19 NaN \n", "20 NaN \n", "21 NaN \n", "22 NaN \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 NaN \n", "27 NaN \n", "28 NaN \n", "29 NaN \n", "30 NaN \n", "31 NaN \n", "32 NaN \n", "33 NaN \n", "34 NaN \n", "35 NaN \n", "36 NaN \n", "37 NaN \n", "38 NaN \n", "39 NaN \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 NaN \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 NaN \n", "48 NaN \n", "49 NaN \n", "50 NaN \n", "51 NaN \n", "52 NaN \n", "53 NaN \n", "54 NaN \n", "55 NaN \n", "56 NaN \n", "57 NaN \n", "\n", "[58 rows x 388 columns]" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
participant._current_app_name_xparticipant._current_page_name_xparticipant.time_started_utc_xparticipant.payoff_xparticipant.exp_codeparticipant.treatment_xthesis_exp_pre_survey.1.player.confirm_code_xthesis_exp_pre_survey.1.player.audio_filename_xthesis_exp_pre_survey.1.player.audio_file_exists_xthesis_exp_pre_survey.1.player.confirm_ready_x...thesis_exp_pre_survey.1.player.confirm_code_ythesis_exp_pre_survey.1.player.treatmentthesis_exp_pre_survey.1.player.audio_filename_ythesis_exp_pre_survey.1.player.audio_file_exists_ythesis_exp_pre_survey.1.player.confirm_ready_ythesis_exp_pre_survey.1.player.emo_calmness_ythesis_exp_pre_survey.1.player.emo_energy_ythesis_exp_pre_survey.1.player.emo_mood_ythesis_exp_pre_survey.1.group.id_in_subsessionthesis_exp_pre_survey.1.subsession.round_number
0thesis_exp_post_surveyEmotionSurvey2026-03-04 12:38:37.346547A02no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1thesis_exp_post_surveyEmotionSurvey2026-03-09 08:41:51.997522A07no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2thesis_exp_post_surveyEmotionSurvey2026-03-10 13:42:59.282538A09no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3thesis_exp_post_surveyEmotionSurvey2026-03-12 12:17:38.009562A01no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
4thesis_exp_post_surveyEmotionSurvey2026-03-19 08:35:50.922520A11no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
5thesis_exp_post_surveyEmotionSurvey2026-03-23 08:35:13.597528A15no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
6thesis_exp_post_surveyEmotionSurvey2026-03-23 09:03:47.621544A99no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
7thesis_exp_post_surveyEmotionSurvey2026-03-23 09:26:47.158526A19no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
8thesis_exp_post_surveyEmotionSurvey2026-03-23 09:43:53.118517A13no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
9thesis_exp_post_surveyEmotionSurvey2026-03-23 10:14:55.976545A18no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
10thesis_exp_post_surveyEmotionSurvey2026-03-24 12:10:55.349508A16no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
11thesis_exp_post_surveyEmotionSurvey2026-03-24 12:47:19.916517A21no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
12thesis_exp_post_surveyEmotionSurvey2026-03-24 13:18:58.172538A24no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
13thesis_exp_post_surveyEmotionSurvey2026-03-25 08:19:48.238525A23no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
14thesis_exp_post_surveyEmotionSurvey2026-03-26 13:40:53.778538A27no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
15thesis_exp_post_surveyEmotionSurvey2026-03-27 08:19:23.988526A30no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
16thesis_exp_post_surveyEmotionSurvey2026-03-27 08:23:47.242538A08no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
17thesis_exp_post_surveyEmotionSurvey2026-03-27 10:12:58.353538A28no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
18thesis_exp_post_surveyEmotionSurvey2026-03-27 10:16:18.928524A20no_music1NaN01...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
19thesis_exp_post_surveyEmotionSurvey2026-02-25 09:40:41.766532B05slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
20thesis_exp_post_surveyEmotionSurvey2026-03-06 11:54:12.995543B08slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
21thesis_exp_post_surveyEmotionSurvey2026-03-06 12:40:11.351556B06slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
22thesis_exp_post_surveyEmotionSurvey2026-03-09 10:14:52.758538B07slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
23thesis_exp_post_surveyEmotionSurvey2026-03-10 12:38:47.546542B03slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
24thesis_exp_post_surveyEmotionSurvey2026-03-17 10:13:37.499528B09slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
25thesis_exp_post_surveyEmotionSurvey2026-03-19 08:33:56.404557B11slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
26thesis_exp_post_surveyEmotionSurvey2026-03-23 08:39:08.004537B14slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
27thesis_exp_post_surveyEmotionSurvey2026-03-23 08:43:33.175541B16slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
28thesis_exp_post_surveyEmotionSurvey2026-03-23 09:43:28.941515B12slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
29thesis_exp_post_surveyEmotionSurvey2026-03-23 10:15:46.662524B18slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
30thesis_exp_post_surveyEmotionSurvey2026-03-24 12:12:48.348540B17slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
31thesis_exp_post_surveyEmotionSurvey2026-03-25 08:18:57.157521B13slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
32thesis_exp_post_surveyEmotionSurvey2026-03-25 08:20:41.220547B20slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
33thesis_exp_post_surveyEmotionSurvey2026-03-25 08:21:29.215522B24slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
34thesis_exp_post_surveyEmotionSurvey2026-03-25 09:46:50.459518B22slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
35thesis_exp_post_surveyEmotionSurvey2026-03-26 11:57:39.388535B90slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
36thesis_exp_post_surveyEmotionSurvey2026-03-27 08:18:11.078547B26slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
37thesis_exp_post_surveyEmotionSurvey2026-03-27 08:20:57.182528B25slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
38thesis_exp_post_surveyEmotionSurvey2026-03-27 09:28:11.985530B30slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
39thesis_exp_post_surveyEmotionSurvey2026-03-27 10:17:04.096532B15slow_music1mozart.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
40thesis_exp_post_surveyEmotionSurvey2026-03-03 08:34:53.751536C04personalized_music1C04.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
41thesis_exp_post_surveyEmotionSurvey2026-03-09 10:13:39.171526C08personalized_music1C08.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
42thesis_exp_post_surveyEmotionSurvey2026-03-10 12:37:50.630528C07personalized_music1C07.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
43thesis_exp_post_surveyEmotionSurvey2026-03-18 13:08:53.330510C09personalized_music1C09.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
44thesis_exp_post_surveyEmotionSurvey2026-03-20 12:12:40.642521C10personalized_music1C10.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
45thesis_exp_post_surveyEmotionSurvey2026-03-23 08:37:27.930527C14personalized_music1C14.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
46thesis_exp_post_surveyEmotionSurvey2026-03-23 08:40:26.859506C17personalized_music1C17.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
47thesis_exp_post_surveyEmotionSurvey2026-03-23 08:41:54.332529C13personalized_music1C13.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
48thesis_exp_post_surveyEmotionSurvey2026-03-23 10:14:00.205540C05personalized_music1C05.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
49thesis_exp_post_surveyEmotionSurvey2026-03-23 10:14:22.611523C15personalized_music1C15.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
50thesis_exp_post_surveyEmotionSurvey2026-03-24 12:11:54.887562C11personalized_music1C11.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
51thesis_exp_post_surveyEmotionSurvey2026-03-25 08:16:57.507520C16personalized_music1C16.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
52thesis_exp_post_surveyEmotionSurvey2026-03-25 08:17:46.638527C12personalized_music1C12.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
53thesis_exp_post_surveyEmotionSurvey2026-03-25 09:48:30.739567C22personalized_music1C22.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
54thesis_exp_post_surveyEmotionSurvey2026-03-26 11:56:43.922557C28personalized_music1C28.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
55thesis_exp_post_surveyEmotionSurvey2026-03-27 08:22:10.563515C29personalized_music1C29.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
56thesis_exp_post_surveyEmotionSurvey2026-03-27 08:22:52.502528C18personalized_music1C18.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
57thesis_exp_post_surveyEmotionSurvey2026-03-27 09:27:28.047516C30personalized_music1C30.mp311...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
\n", "

58 rows × 388 columns

\n", "
" ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 36 }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-28T18:14:27.333079Z", "start_time": "2026-03-28T18:14:27.193059Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 5. CREATE CLEAN DATASET (WITH CONTROLS + EMOTIONS)\n", "# -------------------------\n", "\n", "clean = df[[\n", " 'participant.exp_code',\n", " 'participant.treatment_x',\n", " 'riskiness',\n", " 'inv_speed',\n", " 'math_accuracy',\n", " 'math_speed',\n", "\n", " # controls\n", " 'thesis_pre_survey.1.player.q1_age',\n", " 'thesis_pre_survey.1.player.q2_gender',\n", " 'thesis_pre_survey.1.player.q9_arithmetic_comfort',\n", " 'thesis_pre_survey.1.player.q10_investing_experience',\n", " 'thesis_pre_survey.1.player.q11_overdrawn_frequency',\n", " 'thesis_pre_survey.1.player.q12_gambling_experience',\n", " 'thesis_pre_survey.1.player.q13_music_frequency',\n", " 'thesis_pre_survey.1.player.q17_tempo',\n", "\n", " # emotions: pre\n", " 'thesis_exp_pre_survey.1.player.emo_calmness_x',\n", " 'thesis_exp_pre_survey.1.player.emo_energy_x',\n", " 'thesis_exp_pre_survey.1.player.emo_mood_x',\n", "\n", " # emotions: post\n", " 'thesis_exp_post_survey.1.player.feeling_now_x',\n", " 'thesis_exp_post_survey.1.player.energy_now_x',\n", " 'thesis_exp_post_survey.1.player.mood_now_x'\n", "]].copy()\n", "\n", "clean" ], "id": "347446ce3f59070f", "outputs": [ { "data": { "text/plain": [ " participant.exp_code participant.treatment_x riskiness inv_speed \\\n", "0 A02 no_music 67.500000 11.504333 \n", "1 A07 no_music 43.333333 23.725333 \n", "2 A09 no_music 45.000000 14.467333 \n", "3 A01 no_music 61.666667 24.376000 \n", "4 A11 no_music 41.000000 12.977000 \n", "5 A15 no_music 38.333333 37.709667 \n", "6 A99 no_music 83.333333 17.309500 \n", "7 A19 no_music 76.666667 25.334500 \n", "8 A13 no_music 41.666667 28.305500 \n", "9 A18 no_music 65.000000 13.566667 \n", "10 A16 no_music 54.166667 33.414167 \n", "11 A21 no_music 71.000000 40.584500 \n", "12 A24 no_music 51.666667 13.015500 \n", "13 A23 no_music 18.333333 12.243333 \n", "14 A27 no_music 41.666667 22.272667 \n", "15 A30 no_music 55.000000 19.391167 \n", "16 A08 no_music 60.000000 27.303333 \n", "17 A28 no_music 35.833333 19.236833 \n", "18 A20 no_music 25.833333 18.755333 \n", "19 B05 slow_music 86.666667 18.570167 \n", "20 B08 slow_music 56.666667 33.657000 \n", "21 B06 slow_music 66.666667 73.627167 \n", "22 B07 slow_music 48.333333 35.175333 \n", "23 B03 slow_music 47.500000 14.178000 \n", "24 B09 slow_music 46.666667 59.726333 \n", "25 B11 slow_music 64.166667 27.919333 \n", "26 B14 slow_music 27.166667 49.301333 \n", "27 B16 slow_music 26.666667 18.295333 \n", "28 B12 slow_music 40.833333 25.160833 \n", "29 B18 slow_music 41.666667 18.178833 \n", "30 B17 slow_music 46.666667 36.739000 \n", "31 B13 slow_music 38.333333 17.651333 \n", "32 B20 slow_music 26.166667 18.912167 \n", "33 B24 slow_music 40.000000 49.353000 \n", "34 B22 slow_music 41.666667 14.481333 \n", "35 B90 slow_music 68.333333 16.971000 \n", "36 B26 slow_music 48.333333 22.774833 \n", "37 B25 slow_music 24.166667 14.865500 \n", "38 B30 slow_music 43.333333 5.648333 \n", "39 B15 slow_music 31.333333 24.614500 \n", "40 C04 personalized_music 47.500000 16.016500 \n", "41 C08 personalized_music 7.500000 35.598833 \n", "42 C07 personalized_music 62.500000 27.897500 \n", "43 C09 personalized_music 70.000000 27.068500 \n", "44 C10 personalized_music 41.833333 17.197667 \n", "45 C14 personalized_music 27.333333 37.195167 \n", "46 C17 personalized_music 100.000000 28.860667 \n", "47 C13 personalized_music 25.000000 17.875333 \n", "48 C05 personalized_music 45.000000 11.487667 \n", "49 C15 personalized_music 68.333333 14.810500 \n", "50 C11 personalized_music 63.333333 51.721333 \n", "51 C16 personalized_music 39.166667 24.744333 \n", "52 C12 personalized_music 18.333333 39.558833 \n", "53 C22 personalized_music 63.333333 52.548500 \n", "54 C28 personalized_music 40.000000 29.097667 \n", "55 C29 personalized_music 43.000000 15.551667 \n", "56 C18 personalized_music 44.166667 12.277000 \n", "57 C30 personalized_music 64.166667 16.884500 \n", "\n", " math_accuracy math_speed thesis_pre_survey.1.player.q1_age \\\n", "0 1.000000 20.744833 25.0 \n", "1 1.000000 32.232000 22.0 \n", "2 0.833333 9.919333 29.0 \n", "3 0.666667 18.568500 29.0 \n", "4 0.666667 11.993167 24.0 \n", "5 0.166667 36.234833 28.0 \n", "6 0.833333 5.699333 25.0 \n", "7 1.000000 13.534833 30.0 \n", "8 1.000000 8.087667 22.0 \n", "9 1.000000 6.383000 21.0 \n", "10 0.333333 13.302667 29.0 \n", "11 0.500000 20.803833 23.0 \n", "12 1.000000 28.195500 28.0 \n", "13 1.000000 28.091667 26.0 \n", "14 1.000000 5.984667 27.0 \n", "15 1.000000 22.653500 22.0 \n", "16 0.500000 26.957500 23.0 \n", "17 0.833333 11.395000 20.0 \n", "18 0.500000 9.032167 24.0 \n", "19 0.833333 9.883333 24.0 \n", "20 0.833333 8.629167 22.0 \n", "21 1.000000 27.850500 31.0 \n", "22 1.000000 23.639333 32.0 \n", "23 0.500000 43.443833 26.0 \n", "24 1.000000 18.683500 26.0 \n", "25 1.000000 18.598833 25.0 \n", "26 1.000000 6.790667 24.0 \n", "27 0.833333 15.432500 25.0 \n", "28 1.000000 7.696167 23.0 \n", "29 0.500000 13.698000 28.0 \n", "30 0.833333 6.089833 25.0 \n", "31 0.666667 9.427833 19.0 \n", "32 1.000000 19.124167 20.0 \n", "33 0.833333 12.073833 23.0 \n", "34 0.833333 16.045667 32.0 \n", "35 0.833333 16.310167 25.0 \n", "36 0.833333 16.682167 19.0 \n", "37 1.000000 10.372333 26.0 \n", "38 0.833333 22.526000 21.0 \n", "39 0.833333 12.926000 24.0 \n", "40 0.833333 13.512333 24.0 \n", "41 0.500000 37.960833 26.0 \n", "42 1.000000 9.911833 24.0 \n", "43 1.000000 12.151333 24.0 \n", "44 1.000000 12.798333 26.0 \n", "45 0.833333 16.168167 25.0 \n", "46 1.000000 9.197167 19.0 \n", "47 1.000000 16.082833 27.0 \n", "48 0.833333 12.876333 19.0 \n", "49 0.833333 11.526333 27.0 \n", "50 0.666667 17.463833 25.0 \n", "51 0.833333 14.171333 23.0 \n", "52 1.000000 9.738333 25.0 \n", "53 0.833333 27.445833 24.0 \n", "54 0.500000 10.033000 19.0 \n", "55 0.833333 10.237667 24.0 \n", "56 0.666667 7.383500 28.0 \n", "57 1.000000 10.407667 26.0 \n", "\n", " thesis_pre_survey.1.player.q2_gender \\\n", "0 Female \n", "1 Female \n", "2 Male \n", "3 Female \n", "4 Male \n", "5 Female \n", "6 Male \n", "7 Male \n", "8 Male \n", "9 Male \n", "10 Female \n", "11 Male \n", "12 Female \n", "13 Female \n", "14 Female \n", "15 Female \n", "16 Female \n", "17 Male \n", "18 Female \n", "19 Female \n", "20 Male \n", "21 Male \n", "22 Female \n", "23 Female \n", "24 Female \n", "25 Male \n", "26 Male \n", "27 Female \n", "28 Male \n", "29 Female \n", "30 Non-binary \n", "31 Non-binary \n", "32 Female \n", "33 Male \n", "34 Female \n", "35 Male \n", "36 Female \n", "37 Female \n", "38 Male \n", "39 Male \n", "40 Female \n", "41 Male \n", "42 Female \n", "43 Male \n", "44 Female \n", "45 Male \n", "46 Male \n", "47 Female \n", "48 Male \n", "49 Female \n", "50 Female \n", "51 Male \n", "52 Male \n", "53 Female \n", "54 Female \n", "55 Male \n", "56 Female \n", "57 Female \n", "\n", " thesis_pre_survey.1.player.q9_arithmetic_comfort \\\n", "0 3.0 \n", "1 2.0 \n", "2 3.0 \n", "3 3.0 \n", "4 3.0 \n", "5 3.0 \n", "6 4.0 \n", "7 3.0 \n", "8 4.0 \n", "9 3.0 \n", "10 4.0 \n", "11 3.0 \n", "12 1.0 \n", "13 3.0 \n", "14 3.0 \n", "15 3.0 \n", "16 4.0 \n", "17 3.0 \n", "18 3.0 \n", "19 4.0 \n", "20 4.0 \n", "21 4.0 \n", "22 2.0 \n", "23 2.0 \n", "24 3.0 \n", "25 4.0 \n", "26 4.0 \n", "27 1.0 \n", "28 4.0 \n", "29 2.0 \n", "30 4.0 \n", "31 3.0 \n", "32 3.0 \n", "33 4.0 \n", "34 4.0 \n", "35 3.0 \n", "36 3.0 \n", "37 4.0 \n", "38 2.0 \n", "39 4.0 \n", "40 3.0 \n", "41 3.0 \n", "42 3.0 \n", "43 2.0 \n", "44 2.0 \n", "45 3.0 \n", "46 4.0 \n", "47 4.0 \n", "48 3.0 \n", "49 3.0 \n", "50 2.0 \n", "51 3.0 \n", "52 4.0 \n", "53 3.0 \n", "54 3.0 \n", "55 3.0 \n", "56 3.0 \n", "57 2.0 \n", "\n", " thesis_pre_survey.1.player.q10_investing_experience \\\n", "0 1.0 \n", "1 2.0 \n", "2 2.0 \n", "3 1.0 \n", "4 3.0 \n", "5 1.0 \n", "6 4.0 \n", "7 4.0 \n", "8 2.0 \n", "9 1.0 \n", "10 2.0 \n", "11 1.0 \n", "12 2.0 \n", "13 2.0 \n", "14 2.0 \n", "15 1.0 \n", "16 1.0 \n", "17 2.0 \n", "18 2.0 \n", "19 2.0 \n", "20 2.0 \n", "21 4.0 \n", "22 1.0 \n", "23 1.0 \n", "24 2.0 \n", "25 3.0 \n", "26 3.0 \n", "27 1.0 \n", "28 2.0 \n", "29 2.0 \n", "30 1.0 \n", "31 1.0 \n", "32 2.0 \n", "33 1.0 \n", "34 2.0 \n", "35 2.0 \n", "36 1.0 \n", "37 2.0 \n", "38 2.0 \n", "39 2.0 \n", "40 1.0 \n", "41 2.0 \n", "42 1.0 \n", "43 1.0 \n", "44 1.0 \n", "45 4.0 \n", "46 3.0 \n", "47 2.0 \n", "48 3.0 \n", "49 1.0 \n", "50 1.0 \n", "51 2.0 \n", "52 4.0 \n", "53 2.0 \n", "54 2.0 \n", "55 1.0 \n", "56 2.0 \n", "57 3.0 \n", "\n", " thesis_pre_survey.1.player.q11_overdrawn_frequency \\\n", "0 2.0 \n", "1 1.0 \n", "2 2.0 \n", "3 2.0 \n", "4 1.0 \n", "5 1.0 \n", "6 1.0 \n", "7 2.0 \n", "8 2.0 \n", "9 1.0 \n", "10 1.0 \n", "11 1.0 \n", "12 3.0 \n", "13 1.0 \n", "14 2.0 \n", "15 1.0 \n", "16 1.0 \n", "17 1.0 \n", "18 1.0 \n", "19 1.0 \n", "20 1.0 \n", "21 2.0 \n", "22 2.0 \n", "23 3.0 \n", "24 1.0 \n", "25 2.0 \n", "26 1.0 \n", "27 2.0 \n", "28 2.0 \n", "29 2.0 \n", "30 1.0 \n", "31 1.0 \n", "32 2.0 \n", "33 2.0 \n", "34 1.0 \n", "35 1.0 \n", "36 1.0 \n", "37 1.0 \n", "38 1.0 \n", "39 1.0 \n", "40 1.0 \n", "41 1.0 \n", "42 1.0 \n", "43 3.0 \n", "44 1.0 \n", "45 1.0 \n", "46 1.0 \n", "47 2.0 \n", "48 1.0 \n", "49 1.0 \n", "50 2.0 \n", "51 2.0 \n", "52 1.0 \n", "53 2.0 \n", "54 1.0 \n", "55 1.0 \n", "56 2.0 \n", "57 2.0 \n", "\n", " thesis_pre_survey.1.player.q12_gambling_experience \\\n", "0 1.0 \n", "1 1.0 \n", "2 1.0 \n", "3 1.0 \n", "4 2.0 \n", "5 1.0 \n", "6 1.0 \n", "7 3.0 \n", "8 1.0 \n", "9 1.0 \n", "10 2.0 \n", "11 1.0 \n", "12 1.0 \n", "13 1.0 \n", "14 2.0 \n", "15 1.0 \n", "16 2.0 \n", "17 1.0 \n", "18 1.0 \n", "19 1.0 \n", "20 1.0 \n", "21 2.0 \n", "22 1.0 \n", "23 1.0 \n", "24 1.0 \n", "25 2.0 \n", "26 1.0 \n", "27 1.0 \n", "28 1.0 \n", "29 2.0 \n", "30 2.0 \n", "31 1.0 \n", "32 3.0 \n", "33 1.0 \n", "34 1.0 \n", "35 1.0 \n", "36 1.0 \n", "37 1.0 \n", "38 2.0 \n", "39 1.0 \n", "40 1.0 \n", "41 2.0 \n", "42 1.0 \n", "43 1.0 \n", "44 1.0 \n", "45 1.0 \n", "46 1.0 \n", "47 3.0 \n", "48 2.0 \n", "49 1.0 \n", "50 1.0 \n", "51 1.0 \n", "52 1.0 \n", "53 2.0 \n", "54 1.0 \n", "55 2.0 \n", "56 1.0 \n", "57 2.0 \n", "\n", " thesis_pre_survey.1.player.q13_music_frequency \\\n", "0 3.0 \n", "1 2.0 \n", "2 2.0 \n", "3 2.0 \n", "4 3.0 \n", "5 2.0 \n", "6 2.0 \n", "7 3.0 \n", "8 3.0 \n", "9 5.0 \n", "10 3.0 \n", "11 2.0 \n", "12 5.0 \n", "13 3.0 \n", "14 2.0 \n", "15 3.0 \n", "16 3.0 \n", "17 1.0 \n", "18 4.0 \n", "19 1.0 \n", "20 1.0 \n", "21 1.0 \n", "22 3.0 \n", "23 3.0 \n", "24 2.0 \n", "25 3.0 \n", "26 4.0 \n", "27 2.0 \n", "28 5.0 \n", "29 2.0 \n", "30 3.0 \n", "31 2.0 \n", "32 4.0 \n", "33 3.0 \n", "34 4.0 \n", "35 5.0 \n", "36 3.0 \n", "37 1.0 \n", "38 2.0 \n", "39 3.0 \n", "40 4.0 \n", "41 2.0 \n", "42 3.0 \n", "43 3.0 \n", "44 2.0 \n", "45 5.0 \n", "46 2.0 \n", "47 3.0 \n", "48 4.0 \n", "49 3.0 \n", "50 2.0 \n", "51 4.0 \n", "52 4.0 \n", "53 4.0 \n", "54 3.0 \n", "55 4.0 \n", "56 4.0 \n", "57 4.0 \n", "\n", " thesis_pre_survey.1.player.q17_tempo \\\n", "0 Medium \n", "1 Slow \n", "2 Slow \n", "3 Medium \n", "4 Slow \n", "5 Medium \n", "6 Slow \n", "7 Slow \n", "8 Medium \n", "9 Slow \n", "10 Medium \n", "11 Slow \n", "12 Slow \n", "13 Medium \n", "14 Medium \n", "15 Slow \n", "16 Medium \n", "17 Slow \n", "18 Slow \n", "19 Medium \n", "20 Slow \n", "21 Slow \n", "22 Medium \n", "23 Slow \n", "24 Medium \n", "25 Medium \n", "26 Medium \n", "27 Slow \n", "28 Medium \n", "29 Slow \n", "30 Medium \n", "31 Slow \n", "32 Medium \n", "33 Slow \n", "34 Fast \n", "35 Fast \n", "36 Slow \n", "37 Medium \n", "38 Medium \n", "39 Medium \n", "40 Slow \n", "41 Slow \n", "42 Slow \n", "43 Slow \n", "44 Medium \n", "45 Medium \n", "46 Slow \n", "47 Slow \n", "48 Medium \n", "49 Slow \n", "50 Slow \n", "51 Medium \n", "52 Medium \n", "53 Medium \n", "54 Slow \n", "55 Slow \n", "56 Medium \n", "57 Medium \n", "\n", " thesis_exp_pre_survey.1.player.emo_calmness_x \\\n", "0 2 \n", "1 2 \n", "2 4 \n", "3 2 \n", "4 2 \n", "5 4 \n", "6 3 \n", "7 3 \n", "8 1 \n", "9 2 \n", "10 3 \n", "11 1 \n", "12 2 \n", "13 2 \n", "14 3 \n", "15 4 \n", "16 1 \n", "17 4 \n", "18 4 \n", "19 1 \n", "20 1 \n", "21 5 \n", "22 4 \n", "23 4 \n", "24 3 \n", "25 3 \n", "26 3 \n", "27 2 \n", "28 3 \n", "29 4 \n", "30 1 \n", "31 1 \n", "32 4 \n", "33 4 \n", "34 4 \n", "35 1 \n", "36 2 \n", "37 2 \n", "38 3 \n", "39 3 \n", "40 3 \n", "41 4 \n", "42 2 \n", "43 1 \n", "44 2 \n", "45 3 \n", "46 2 \n", "47 2 \n", "48 2 \n", "49 4 \n", "50 2 \n", "51 4 \n", "52 1 \n", "53 4 \n", "54 4 \n", "55 2 \n", "56 2 \n", "57 4 \n", "\n", " thesis_exp_pre_survey.1.player.emo_energy_x \\\n", "0 2 \n", "1 3 \n", "2 3 \n", "3 3 \n", "4 3 \n", "5 3 \n", "6 3 \n", "7 3 \n", "8 4 \n", "9 4 \n", "10 2 \n", "11 2 \n", "12 3 \n", "13 2 \n", "14 4 \n", "15 2 \n", "16 5 \n", "17 2 \n", "18 3 \n", "19 4 \n", "20 3 \n", "21 4 \n", "22 4 \n", "23 4 \n", "24 3 \n", "25 3 \n", "26 2 \n", "27 4 \n", "28 4 \n", "29 5 \n", "30 3 \n", "31 2 \n", "32 2 \n", "33 5 \n", "34 2 \n", "35 3 \n", "36 4 \n", "37 2 \n", "38 3 \n", "39 4 \n", "40 5 \n", "41 3 \n", "42 2 \n", "43 3 \n", "44 3 \n", "45 4 \n", "46 3 \n", "47 4 \n", "48 3 \n", "49 2 \n", "50 4 \n", "51 5 \n", "52 4 \n", "53 2 \n", "54 3 \n", "55 3 \n", "56 5 \n", "57 2 \n", "\n", " thesis_exp_pre_survey.1.player.emo_mood_x \\\n", "0 5 \n", "1 3 \n", "2 4 \n", "3 4 \n", "4 4 \n", "5 5 \n", "6 4 \n", "7 4 \n", "8 4 \n", "9 4 \n", "10 2 \n", "11 5 \n", "12 3 \n", "13 3 \n", "14 4 \n", "15 2 \n", "16 5 \n", "17 2 \n", "18 2 \n", "19 5 \n", "20 4 \n", "21 5 \n", "22 4 \n", "23 4 \n", "24 3 \n", "25 4 \n", "26 3 \n", "27 5 \n", "28 5 \n", "29 4 \n", "30 4 \n", "31 4 \n", "32 3 \n", "33 5 \n", "34 3 \n", "35 4 \n", "36 3 \n", "37 3 \n", "38 4 \n", "39 3 \n", "40 4 \n", "41 3 \n", "42 5 \n", "43 5 \n", "44 4 \n", "45 5 \n", "46 4 \n", "47 5 \n", "48 4 \n", "49 4 \n", "50 4 \n", "51 3 \n", "52 5 \n", "53 3 \n", "54 3 \n", "55 4 \n", "56 5 \n", "57 2 \n", "\n", " thesis_exp_post_survey.1.player.feeling_now_x \\\n", "0 4 \n", "1 3 \n", "2 3 \n", "3 2 \n", "4 3 \n", "5 3 \n", "6 4 \n", "7 1 \n", "8 2 \n", "9 3 \n", "10 4 \n", "11 4 \n", "12 4 \n", "13 4 \n", "14 4 \n", "15 4 \n", "16 4 \n", "17 4 \n", "18 4 \n", "19 3 \n", "20 2 \n", "21 1 \n", "22 4 \n", "23 4 \n", "24 4 \n", "25 2 \n", "26 4 \n", "27 4 \n", "28 2 \n", "29 2 \n", "30 1 \n", "31 4 \n", "32 3 \n", "33 5 \n", "34 4 \n", "35 2 \n", "36 2 \n", "37 3 \n", "38 4 \n", "39 2 \n", "40 4 \n", "41 3 \n", "42 3 \n", "43 1 \n", "44 2 \n", "45 2 \n", "46 4 \n", "47 3 \n", "48 3 \n", "49 4 \n", "50 3 \n", "51 2 \n", "52 3 \n", "53 3 \n", "54 4 \n", "55 3 \n", "56 3 \n", "57 4 \n", "\n", " thesis_exp_post_survey.1.player.energy_now_x \\\n", "0 3 \n", "1 4 \n", "2 4 \n", "3 4 \n", "4 4 \n", "5 3 \n", "6 4 \n", "7 4 \n", "8 5 \n", "9 5 \n", "10 4 \n", "11 3 \n", "12 5 \n", "13 4 \n", "14 4 \n", "15 4 \n", "16 5 \n", "17 3 \n", "18 4 \n", "19 4 \n", "20 3 \n", "21 5 \n", "22 5 \n", "23 2 \n", "24 4 \n", "25 2 \n", "26 4 \n", "27 3 \n", "28 4 \n", "29 4 \n", "30 3 \n", "31 1 \n", "32 2 \n", "33 5 \n", "34 2 \n", "35 3 \n", "36 5 \n", "37 4 \n", "38 3 \n", "39 4 \n", "40 5 \n", "41 2 \n", "42 4 \n", "43 3 \n", "44 3 \n", "45 4 \n", "46 2 \n", "47 4 \n", "48 4 \n", "49 4 \n", "50 4 \n", "51 5 \n", "52 5 \n", "53 4 \n", "54 4 \n", "55 3 \n", "56 5 \n", "57 4 \n", "\n", " thesis_exp_post_survey.1.player.mood_now_x \n", "0 4 \n", "1 3 \n", "2 3 \n", "3 4 \n", "4 3 \n", "5 5 \n", "6 4 \n", "7 4 \n", "8 5 \n", "9 4 \n", "10 2 \n", "11 3 \n", "12 4 \n", "13 3 \n", "14 4 \n", "15 4 \n", "16 5 \n", "17 3 \n", "18 2 \n", "19 5 \n", "20 4 \n", "21 5 \n", "22 4 \n", "23 3 \n", "24 2 \n", "25 4 \n", "26 4 \n", "27 4 \n", "28 5 \n", "29 5 \n", "30 4 \n", "31 3 \n", "32 3 \n", "33 5 \n", "34 3 \n", "35 4 \n", "36 4 \n", "37 3 \n", "38 4 \n", "39 4 \n", "40 2 \n", "41 3 \n", "42 5 \n", "43 5 \n", "44 4 \n", "45 5 \n", "46 3 \n", "47 5 \n", "48 5 \n", "49 4 \n", "50 4 \n", "51 5 \n", "52 4 \n", "53 3 \n", "54 4 \n", "55 5 \n", "56 4 \n", "57 3 " ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
participant.exp_codeparticipant.treatment_xriskinessinv_speedmath_accuracymath_speedthesis_pre_survey.1.player.q1_agethesis_pre_survey.1.player.q2_genderthesis_pre_survey.1.player.q9_arithmetic_comfortthesis_pre_survey.1.player.q10_investing_experiencethesis_pre_survey.1.player.q11_overdrawn_frequencythesis_pre_survey.1.player.q12_gambling_experiencethesis_pre_survey.1.player.q13_music_frequencythesis_pre_survey.1.player.q17_tempothesis_exp_pre_survey.1.player.emo_calmness_xthesis_exp_pre_survey.1.player.emo_energy_xthesis_exp_pre_survey.1.player.emo_mood_xthesis_exp_post_survey.1.player.feeling_now_xthesis_exp_post_survey.1.player.energy_now_xthesis_exp_post_survey.1.player.mood_now_x
0A02no_music67.50000011.5043331.00000020.74483325.0Female3.01.02.01.03.0Medium225434
1A07no_music43.33333323.7253331.00000032.23200022.0Female2.02.01.01.02.0Slow233343
2A09no_music45.00000014.4673330.8333339.91933329.0Male3.02.02.01.02.0Slow434343
3A01no_music61.66666724.3760000.66666718.56850029.0Female3.01.02.01.02.0Medium234244
4A11no_music41.00000012.9770000.66666711.99316724.0Male3.03.01.02.03.0Slow234343
5A15no_music38.33333337.7096670.16666736.23483328.0Female3.01.01.01.02.0Medium435335
6A99no_music83.33333317.3095000.8333335.69933325.0Male4.04.01.01.02.0Slow334444
7A19no_music76.66666725.3345001.00000013.53483330.0Male3.04.02.03.03.0Slow334144
8A13no_music41.66666728.3055001.0000008.08766722.0Male4.02.02.01.03.0Medium144255
9A18no_music65.00000013.5666671.0000006.38300021.0Male3.01.01.01.05.0Slow244354
10A16no_music54.16666733.4141670.33333313.30266729.0Female4.02.01.02.03.0Medium322442
11A21no_music71.00000040.5845000.50000020.80383323.0Male3.01.01.01.02.0Slow125433
12A24no_music51.66666713.0155001.00000028.19550028.0Female1.02.03.01.05.0Slow233454
13A23no_music18.33333312.2433331.00000028.09166726.0Female3.02.01.01.03.0Medium223443
14A27no_music41.66666722.2726671.0000005.98466727.0Female3.02.02.02.02.0Medium344444
15A30no_music55.00000019.3911671.00000022.65350022.0Female3.01.01.01.03.0Slow422444
16A08no_music60.00000027.3033330.50000026.95750023.0Female4.01.01.02.03.0Medium155455
17A28no_music35.83333319.2368330.83333311.39500020.0Male3.02.01.01.01.0Slow422433
18A20no_music25.83333318.7553330.5000009.03216724.0Female3.02.01.01.04.0Slow432442
19B05slow_music86.66666718.5701670.8333339.88333324.0Female4.02.01.01.01.0Medium145345
20B08slow_music56.66666733.6570000.8333338.62916722.0Male4.02.01.01.01.0Slow134234
21B06slow_music66.66666773.6271671.00000027.85050031.0Male4.04.02.02.01.0Slow545155
22B07slow_music48.33333335.1753331.00000023.63933332.0Female2.01.02.01.03.0Medium444454
23B03slow_music47.50000014.1780000.50000043.44383326.0Female2.01.03.01.03.0Slow444423
24B09slow_music46.66666759.7263331.00000018.68350026.0Female3.02.01.01.02.0Medium333442
25B11slow_music64.16666727.9193331.00000018.59883325.0Male4.03.02.02.03.0Medium334224
26B14slow_music27.16666749.3013331.0000006.79066724.0Male4.03.01.01.04.0Medium323444
27B16slow_music26.66666718.2953330.83333315.43250025.0Female1.01.02.01.02.0Slow245434
28B12slow_music40.83333325.1608331.0000007.69616723.0Male4.02.02.01.05.0Medium345245
29B18slow_music41.66666718.1788330.50000013.69800028.0Female2.02.02.02.02.0Slow454245
30B17slow_music46.66666736.7390000.8333336.08983325.0Non-binary4.01.01.02.03.0Medium134134
31B13slow_music38.33333317.6513330.6666679.42783319.0Non-binary3.01.01.01.02.0Slow124413
32B20slow_music26.16666718.9121671.00000019.12416720.0Female3.02.02.03.04.0Medium423323
33B24slow_music40.00000049.3530000.83333312.07383323.0Male4.01.02.01.03.0Slow455555
34B22slow_music41.66666714.4813330.83333316.04566732.0Female4.02.01.01.04.0Fast423423
35B90slow_music68.33333316.9710000.83333316.31016725.0Male3.02.01.01.05.0Fast134234
36B26slow_music48.33333322.7748330.83333316.68216719.0Female3.01.01.01.03.0Slow243254
37B25slow_music24.16666714.8655001.00000010.37233326.0Female4.02.01.01.01.0Medium223343
38B30slow_music43.3333335.6483330.83333322.52600021.0Male2.02.01.02.02.0Medium334434
39B15slow_music31.33333324.6145000.83333312.92600024.0Male4.02.01.01.03.0Medium343244
40C04personalized_music47.50000016.0165000.83333313.51233324.0Female3.01.01.01.04.0Slow354452
41C08personalized_music7.50000035.5988330.50000037.96083326.0Male3.02.01.02.02.0Slow433323
42C07personalized_music62.50000027.8975001.0000009.91183324.0Female3.01.01.01.03.0Slow225345
43C09personalized_music70.00000027.0685001.00000012.15133324.0Male2.01.03.01.03.0Slow135135
44C10personalized_music41.83333317.1976671.00000012.79833326.0Female2.01.01.01.02.0Medium234234
45C14personalized_music27.33333337.1951670.83333316.16816725.0Male3.04.01.01.05.0Medium345245
46C17personalized_music100.00000028.8606671.0000009.19716719.0Male4.03.01.01.02.0Slow234423
47C13personalized_music25.00000017.8753331.00000016.08283327.0Female4.02.02.03.03.0Slow245345
48C05personalized_music45.00000011.4876670.83333312.87633319.0Male3.03.01.02.04.0Medium234345
49C15personalized_music68.33333314.8105000.83333311.52633327.0Female3.01.01.01.03.0Slow424444
50C11personalized_music63.33333351.7213330.66666717.46383325.0Female2.01.02.01.02.0Slow244344
51C16personalized_music39.16666724.7443330.83333314.17133323.0Male3.02.02.01.04.0Medium453255
52C12personalized_music18.33333339.5588331.0000009.73833325.0Male4.04.01.01.04.0Medium145354
53C22personalized_music63.33333352.5485000.83333327.44583324.0Female3.02.02.02.04.0Medium423343
54C28personalized_music40.00000029.0976670.50000010.03300019.0Female3.02.01.01.03.0Slow433444
55C29personalized_music43.00000015.5516670.83333310.23766724.0Male3.01.01.02.04.0Slow234335
56C18personalized_music44.16666712.2770000.6666677.38350028.0Female3.02.02.01.04.0Medium255354
57C30personalized_music64.16666716.8845001.00000010.40766726.0Female2.03.02.02.04.0Medium422443
\n", "
" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 38 }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-28T18:17:10.011061Z", "start_time": "2026-03-28T18:17:09.904414Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 5.1 CREATE DUMMIES + CHANGE VARIABLES\n", "# -------------------------\n", "\n", "# Treatment dummies\n", "clean['slow_music_dummy'] = (clean['participant.treatment_x'] == 'slow_music').astype(int)\n", "clean['personalized_dummy'] = (clean['participant.treatment_x'] == 'personalized_music').astype(int)\n", "\n", "# Gender dummy (Female = 1, all others = 0)\n", "clean['female'] = (clean['thesis_pre_survey.1.player.q2_gender'] == 'Female').astype(int)\n", "\n", "# Tempo dummies (reference = Slow)\n", "clean['tempo_medium'] = (clean['thesis_pre_survey.1.player.q17_tempo'] == 'Medium').astype(int)\n", "clean['tempo_fast'] = (clean['thesis_pre_survey.1.player.q17_tempo'] == 'Fast').astype(int)\n", "\n", "# Emotion change variables (post - pre)\n", "clean['delta_calmness'] = clean['thesis_exp_post_survey.1.player.feeling_now_x'] - clean['thesis_exp_pre_survey.1.player.emo_calmness_x']\n", "clean['delta_energy'] = clean['thesis_exp_post_survey.1.player.energy_now_x'] - clean['thesis_exp_pre_survey.1.player.emo_energy_x']\n", "clean['delta_mood'] = clean['thesis_exp_post_survey.1.player.mood_now_x'] - clean['thesis_exp_pre_survey.1.player.emo_mood_x']\n", "\n", "clean" ], "id": "cf2b4352932f5f1b", "outputs": [ { "data": { "text/plain": [ " participant.exp_code participant.treatment_x riskiness inv_speed \\\n", "0 A02 no_music 67.500000 11.504333 \n", "1 A07 no_music 43.333333 23.725333 \n", "2 A09 no_music 45.000000 14.467333 \n", "3 A01 no_music 61.666667 24.376000 \n", "4 A11 no_music 41.000000 12.977000 \n", "5 A15 no_music 38.333333 37.709667 \n", "6 A99 no_music 83.333333 17.309500 \n", "7 A19 no_music 76.666667 25.334500 \n", "8 A13 no_music 41.666667 28.305500 \n", "9 A18 no_music 65.000000 13.566667 \n", "10 A16 no_music 54.166667 33.414167 \n", "11 A21 no_music 71.000000 40.584500 \n", "12 A24 no_music 51.666667 13.015500 \n", "13 A23 no_music 18.333333 12.243333 \n", "14 A27 no_music 41.666667 22.272667 \n", "15 A30 no_music 55.000000 19.391167 \n", "16 A08 no_music 60.000000 27.303333 \n", "17 A28 no_music 35.833333 19.236833 \n", "18 A20 no_music 25.833333 18.755333 \n", "19 B05 slow_music 86.666667 18.570167 \n", "20 B08 slow_music 56.666667 33.657000 \n", "21 B06 slow_music 66.666667 73.627167 \n", "22 B07 slow_music 48.333333 35.175333 \n", "23 B03 slow_music 47.500000 14.178000 \n", "24 B09 slow_music 46.666667 59.726333 \n", "25 B11 slow_music 64.166667 27.919333 \n", "26 B14 slow_music 27.166667 49.301333 \n", "27 B16 slow_music 26.666667 18.295333 \n", "28 B12 slow_music 40.833333 25.160833 \n", "29 B18 slow_music 41.666667 18.178833 \n", "30 B17 slow_music 46.666667 36.739000 \n", "31 B13 slow_music 38.333333 17.651333 \n", "32 B20 slow_music 26.166667 18.912167 \n", "33 B24 slow_music 40.000000 49.353000 \n", "34 B22 slow_music 41.666667 14.481333 \n", "35 B90 slow_music 68.333333 16.971000 \n", "36 B26 slow_music 48.333333 22.774833 \n", "37 B25 slow_music 24.166667 14.865500 \n", "38 B30 slow_music 43.333333 5.648333 \n", "39 B15 slow_music 31.333333 24.614500 \n", "40 C04 personalized_music 47.500000 16.016500 \n", "41 C08 personalized_music 7.500000 35.598833 \n", "42 C07 personalized_music 62.500000 27.897500 \n", "43 C09 personalized_music 70.000000 27.068500 \n", "44 C10 personalized_music 41.833333 17.197667 \n", "45 C14 personalized_music 27.333333 37.195167 \n", "46 C17 personalized_music 100.000000 28.860667 \n", "47 C13 personalized_music 25.000000 17.875333 \n", "48 C05 personalized_music 45.000000 11.487667 \n", "49 C15 personalized_music 68.333333 14.810500 \n", "50 C11 personalized_music 63.333333 51.721333 \n", "51 C16 personalized_music 39.166667 24.744333 \n", "52 C12 personalized_music 18.333333 39.558833 \n", "53 C22 personalized_music 63.333333 52.548500 \n", "54 C28 personalized_music 40.000000 29.097667 \n", "55 C29 personalized_music 43.000000 15.551667 \n", "56 C18 personalized_music 44.166667 12.277000 \n", "57 C30 personalized_music 64.166667 16.884500 \n", "\n", " math_accuracy math_speed thesis_pre_survey.1.player.q1_age \\\n", "0 1.000000 20.744833 25.0 \n", "1 1.000000 32.232000 22.0 \n", "2 0.833333 9.919333 29.0 \n", "3 0.666667 18.568500 29.0 \n", "4 0.666667 11.993167 24.0 \n", "5 0.166667 36.234833 28.0 \n", "6 0.833333 5.699333 25.0 \n", "7 1.000000 13.534833 30.0 \n", "8 1.000000 8.087667 22.0 \n", "9 1.000000 6.383000 21.0 \n", "10 0.333333 13.302667 29.0 \n", "11 0.500000 20.803833 23.0 \n", "12 1.000000 28.195500 28.0 \n", "13 1.000000 28.091667 26.0 \n", "14 1.000000 5.984667 27.0 \n", "15 1.000000 22.653500 22.0 \n", "16 0.500000 26.957500 23.0 \n", "17 0.833333 11.395000 20.0 \n", "18 0.500000 9.032167 24.0 \n", "19 0.833333 9.883333 24.0 \n", "20 0.833333 8.629167 22.0 \n", "21 1.000000 27.850500 31.0 \n", "22 1.000000 23.639333 32.0 \n", "23 0.500000 43.443833 26.0 \n", "24 1.000000 18.683500 26.0 \n", "25 1.000000 18.598833 25.0 \n", "26 1.000000 6.790667 24.0 \n", "27 0.833333 15.432500 25.0 \n", "28 1.000000 7.696167 23.0 \n", "29 0.500000 13.698000 28.0 \n", "30 0.833333 6.089833 25.0 \n", "31 0.666667 9.427833 19.0 \n", "32 1.000000 19.124167 20.0 \n", "33 0.833333 12.073833 23.0 \n", "34 0.833333 16.045667 32.0 \n", "35 0.833333 16.310167 25.0 \n", "36 0.833333 16.682167 19.0 \n", "37 1.000000 10.372333 26.0 \n", "38 0.833333 22.526000 21.0 \n", "39 0.833333 12.926000 24.0 \n", "40 0.833333 13.512333 24.0 \n", "41 0.500000 37.960833 26.0 \n", "42 1.000000 9.911833 24.0 \n", "43 1.000000 12.151333 24.0 \n", "44 1.000000 12.798333 26.0 \n", "45 0.833333 16.168167 25.0 \n", "46 1.000000 9.197167 19.0 \n", "47 1.000000 16.082833 27.0 \n", "48 0.833333 12.876333 19.0 \n", "49 0.833333 11.526333 27.0 \n", "50 0.666667 17.463833 25.0 \n", "51 0.833333 14.171333 23.0 \n", "52 1.000000 9.738333 25.0 \n", "53 0.833333 27.445833 24.0 \n", "54 0.500000 10.033000 19.0 \n", "55 0.833333 10.237667 24.0 \n", "56 0.666667 7.383500 28.0 \n", "57 1.000000 10.407667 26.0 \n", "\n", " thesis_pre_survey.1.player.q2_gender \\\n", "0 Female \n", "1 Female \n", "2 Male \n", "3 Female \n", "4 Male \n", "5 Female \n", "6 Male \n", "7 Male \n", "8 Male \n", "9 Male \n", "10 Female \n", "11 Male \n", "12 Female \n", "13 Female \n", "14 Female \n", "15 Female \n", "16 Female \n", "17 Male \n", "18 Female \n", "19 Female \n", "20 Male \n", "21 Male \n", "22 Female \n", "23 Female \n", "24 Female \n", "25 Male \n", "26 Male \n", "27 Female \n", "28 Male \n", "29 Female \n", "30 Non-binary \n", "31 Non-binary \n", "32 Female \n", "33 Male \n", "34 Female \n", "35 Male \n", "36 Female \n", "37 Female \n", "38 Male \n", "39 Male \n", "40 Female \n", "41 Male \n", "42 Female \n", "43 Male \n", "44 Female \n", "45 Male \n", "46 Male \n", "47 Female \n", "48 Male \n", "49 Female \n", "50 Female \n", "51 Male \n", "52 Male \n", "53 Female \n", "54 Female \n", "55 Male \n", "56 Female \n", "57 Female \n", "\n", " thesis_pre_survey.1.player.q9_arithmetic_comfort \\\n", "0 3.0 \n", "1 2.0 \n", "2 3.0 \n", "3 3.0 \n", "4 3.0 \n", "5 3.0 \n", "6 4.0 \n", "7 3.0 \n", "8 4.0 \n", "9 3.0 \n", "10 4.0 \n", "11 3.0 \n", "12 1.0 \n", "13 3.0 \n", "14 3.0 \n", "15 3.0 \n", "16 4.0 \n", "17 3.0 \n", "18 3.0 \n", "19 4.0 \n", "20 4.0 \n", "21 4.0 \n", "22 2.0 \n", "23 2.0 \n", "24 3.0 \n", "25 4.0 \n", "26 4.0 \n", "27 1.0 \n", "28 4.0 \n", "29 2.0 \n", "30 4.0 \n", "31 3.0 \n", "32 3.0 \n", "33 4.0 \n", "34 4.0 \n", "35 3.0 \n", "36 3.0 \n", "37 4.0 \n", "38 2.0 \n", "39 4.0 \n", "40 3.0 \n", "41 3.0 \n", "42 3.0 \n", "43 2.0 \n", "44 2.0 \n", "45 3.0 \n", "46 4.0 \n", "47 4.0 \n", "48 3.0 \n", "49 3.0 \n", "50 2.0 \n", "51 3.0 \n", "52 4.0 \n", "53 3.0 \n", "54 3.0 \n", "55 3.0 \n", "56 3.0 \n", "57 2.0 \n", "\n", " thesis_pre_survey.1.player.q10_investing_experience ... \\\n", "0 1.0 ... \n", "1 2.0 ... \n", "2 2.0 ... \n", "3 1.0 ... \n", "4 3.0 ... \n", "5 1.0 ... \n", "6 4.0 ... \n", "7 4.0 ... \n", "8 2.0 ... \n", "9 1.0 ... \n", "10 2.0 ... \n", "11 1.0 ... \n", "12 2.0 ... \n", "13 2.0 ... \n", "14 2.0 ... \n", "15 1.0 ... \n", "16 1.0 ... \n", "17 2.0 ... \n", "18 2.0 ... \n", "19 2.0 ... \n", "20 2.0 ... \n", "21 4.0 ... \n", "22 1.0 ... \n", "23 1.0 ... \n", "24 2.0 ... \n", "25 3.0 ... \n", "26 3.0 ... \n", "27 1.0 ... \n", "28 2.0 ... \n", "29 2.0 ... \n", "30 1.0 ... \n", "31 1.0 ... \n", "32 2.0 ... \n", "33 1.0 ... \n", "34 2.0 ... \n", "35 2.0 ... \n", "36 1.0 ... \n", "37 2.0 ... \n", "38 2.0 ... \n", "39 2.0 ... \n", "40 1.0 ... \n", "41 2.0 ... \n", "42 1.0 ... \n", "43 1.0 ... \n", "44 1.0 ... \n", "45 4.0 ... \n", "46 3.0 ... \n", "47 2.0 ... \n", "48 3.0 ... \n", "49 1.0 ... \n", "50 1.0 ... \n", "51 2.0 ... \n", "52 4.0 ... \n", "53 2.0 ... \n", "54 2.0 ... \n", "55 1.0 ... \n", "56 2.0 ... \n", "57 3.0 ... \n", "\n", " thesis_exp_post_survey.1.player.energy_now_x \\\n", "0 3 \n", "1 4 \n", "2 4 \n", "3 4 \n", "4 4 \n", "5 3 \n", "6 4 \n", "7 4 \n", "8 5 \n", "9 5 \n", "10 4 \n", "11 3 \n", "12 5 \n", "13 4 \n", "14 4 \n", "15 4 \n", "16 5 \n", "17 3 \n", "18 4 \n", "19 4 \n", "20 3 \n", "21 5 \n", "22 5 \n", "23 2 \n", "24 4 \n", "25 2 \n", "26 4 \n", "27 3 \n", "28 4 \n", "29 4 \n", "30 3 \n", "31 1 \n", "32 2 \n", "33 5 \n", "34 2 \n", "35 3 \n", "36 5 \n", "37 4 \n", "38 3 \n", "39 4 \n", "40 5 \n", "41 2 \n", "42 4 \n", "43 3 \n", "44 3 \n", "45 4 \n", "46 2 \n", "47 4 \n", "48 4 \n", "49 4 \n", "50 4 \n", "51 5 \n", "52 5 \n", "53 4 \n", "54 4 \n", "55 3 \n", "56 5 \n", "57 4 \n", "\n", " thesis_exp_post_survey.1.player.mood_now_x slow_music_dummy \\\n", "0 4 0 \n", "1 3 0 \n", "2 3 0 \n", "3 4 0 \n", "4 3 0 \n", "5 5 0 \n", "6 4 0 \n", "7 4 0 \n", "8 5 0 \n", "9 4 0 \n", "10 2 0 \n", "11 3 0 \n", "12 4 0 \n", "13 3 0 \n", "14 4 0 \n", "15 4 0 \n", "16 5 0 \n", "17 3 0 \n", "18 2 0 \n", "19 5 1 \n", "20 4 1 \n", "21 5 1 \n", "22 4 1 \n", "23 3 1 \n", "24 2 1 \n", "25 4 1 \n", "26 4 1 \n", "27 4 1 \n", "28 5 1 \n", "29 5 1 \n", "30 4 1 \n", "31 3 1 \n", "32 3 1 \n", "33 5 1 \n", "34 3 1 \n", "35 4 1 \n", "36 4 1 \n", "37 3 1 \n", "38 4 1 \n", "39 4 1 \n", "40 2 0 \n", "41 3 0 \n", "42 5 0 \n", "43 5 0 \n", "44 4 0 \n", "45 5 0 \n", "46 3 0 \n", "47 5 0 \n", "48 5 0 \n", "49 4 0 \n", "50 4 0 \n", "51 5 0 \n", "52 4 0 \n", "53 3 0 \n", "54 4 0 \n", "55 5 0 \n", "56 4 0 \n", "57 3 0 \n", "\n", " personalized_dummy female tempo_medium tempo_fast delta_calmness \\\n", "0 0 1 1 0 2 \n", "1 0 1 0 0 1 \n", "2 0 0 0 0 -1 \n", "3 0 1 1 0 0 \n", "4 0 0 0 0 1 \n", "5 0 1 1 0 -1 \n", "6 0 0 0 0 1 \n", "7 0 0 0 0 -2 \n", "8 0 0 1 0 1 \n", "9 0 0 0 0 1 \n", "10 0 1 1 0 1 \n", "11 0 0 0 0 3 \n", "12 0 1 0 0 2 \n", "13 0 1 1 0 2 \n", "14 0 1 1 0 1 \n", "15 0 1 0 0 0 \n", "16 0 1 1 0 3 \n", "17 0 0 0 0 0 \n", "18 0 1 0 0 0 \n", "19 0 1 1 0 2 \n", "20 0 0 0 0 1 \n", "21 0 0 0 0 -4 \n", "22 0 1 1 0 0 \n", "23 0 1 0 0 0 \n", "24 0 1 1 0 1 \n", "25 0 0 1 0 -1 \n", "26 0 0 1 0 1 \n", "27 0 1 0 0 2 \n", "28 0 0 1 0 -1 \n", "29 0 1 0 0 -2 \n", "30 0 0 1 0 0 \n", "31 0 0 0 0 3 \n", "32 0 1 1 0 -1 \n", "33 0 0 0 0 1 \n", "34 0 1 0 1 0 \n", "35 0 0 0 1 1 \n", "36 0 1 0 0 0 \n", "37 0 1 1 0 1 \n", "38 0 0 1 0 1 \n", "39 0 0 1 0 -1 \n", "40 1 1 0 0 1 \n", "41 1 0 0 0 -1 \n", "42 1 1 0 0 1 \n", "43 1 0 0 0 0 \n", "44 1 1 1 0 0 \n", "45 1 0 1 0 -1 \n", "46 1 0 0 0 2 \n", "47 1 1 0 0 1 \n", "48 1 0 1 0 1 \n", "49 1 1 0 0 0 \n", "50 1 1 0 0 1 \n", "51 1 0 1 0 -2 \n", "52 1 0 1 0 2 \n", "53 1 1 1 0 -1 \n", "54 1 1 0 0 0 \n", "55 1 0 0 0 1 \n", "56 1 1 1 0 1 \n", "57 1 1 1 0 0 \n", "\n", " delta_energy delta_mood \n", "0 1 -1 \n", "1 1 0 \n", "2 1 -1 \n", "3 1 0 \n", "4 1 -1 \n", "5 0 0 \n", "6 1 0 \n", "7 1 0 \n", "8 1 1 \n", "9 1 0 \n", "10 2 0 \n", "11 1 -2 \n", "12 2 1 \n", "13 2 0 \n", "14 0 0 \n", "15 2 2 \n", "16 0 0 \n", "17 1 1 \n", "18 1 0 \n", "19 0 0 \n", "20 0 0 \n", "21 1 0 \n", "22 1 0 \n", "23 -2 -1 \n", "24 1 -1 \n", "25 -1 0 \n", "26 2 1 \n", "27 -1 -1 \n", "28 0 0 \n", "29 -1 1 \n", "30 0 0 \n", "31 -1 -1 \n", "32 0 0 \n", "33 0 0 \n", "34 0 0 \n", "35 0 0 \n", "36 1 1 \n", "37 2 0 \n", "38 0 0 \n", "39 0 1 \n", "40 0 -2 \n", "41 -1 0 \n", "42 2 0 \n", "43 0 0 \n", "44 0 0 \n", "45 0 0 \n", "46 -1 -1 \n", "47 0 0 \n", "48 1 1 \n", "49 2 0 \n", "50 0 0 \n", "51 0 2 \n", "52 1 -1 \n", "53 2 0 \n", "54 1 1 \n", "55 0 1 \n", "56 0 -1 \n", "57 2 1 \n", "\n", "[58 rows x 28 columns]" ], "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
participant.exp_codeparticipant.treatment_xriskinessinv_speedmath_accuracymath_speedthesis_pre_survey.1.player.q1_agethesis_pre_survey.1.player.q2_genderthesis_pre_survey.1.player.q9_arithmetic_comfortthesis_pre_survey.1.player.q10_investing_experience...thesis_exp_post_survey.1.player.energy_now_xthesis_exp_post_survey.1.player.mood_now_xslow_music_dummypersonalized_dummyfemaletempo_mediumtempo_fastdelta_calmnessdelta_energydelta_mood
0A02no_music67.50000011.5043331.00000020.74483325.0Female3.01.0...340011021-1
1A07no_music43.33333323.7253331.00000032.23200022.0Female2.02.0...4300100110
2A09no_music45.00000014.4673330.8333339.91933329.0Male3.02.0...4300000-11-1
3A01no_music61.66666724.3760000.66666718.56850029.0Female3.01.0...4400110010
4A11no_music41.00000012.9770000.66666711.99316724.0Male3.03.0...430000011-1
5A15no_music38.33333337.7096670.16666736.23483328.0Female3.01.0...3500110-100
6A99no_music83.33333317.3095000.8333335.69933325.0Male4.04.0...4400000110
7A19no_music76.66666725.3345001.00000013.53483330.0Male3.04.0...4400000-210
8A13no_music41.66666728.3055001.0000008.08766722.0Male4.02.0...5500010111
9A18no_music65.00000013.5666671.0000006.38300021.0Male3.01.0...5400000110
10A16no_music54.16666733.4141670.33333313.30266729.0Female4.02.0...4200110120
11A21no_music71.00000040.5845000.50000020.80383323.0Male3.01.0...330000031-2
12A24no_music51.66666713.0155001.00000028.19550028.0Female1.02.0...5400100221
13A23no_music18.33333312.2433331.00000028.09166726.0Female3.02.0...4300110220
14A27no_music41.66666722.2726671.0000005.98466727.0Female3.02.0...4400110100
15A30no_music55.00000019.3911671.00000022.65350022.0Female3.01.0...4400100022
16A08no_music60.00000027.3033330.50000026.95750023.0Female4.01.0...5500110300
17A28no_music35.83333319.2368330.83333311.39500020.0Male3.02.0...3300000011
18A20no_music25.83333318.7553330.5000009.03216724.0Female3.02.0...4200100010
19B05slow_music86.66666718.5701670.8333339.88333324.0Female4.02.0...4510110200
20B08slow_music56.66666733.6570000.8333338.62916722.0Male4.02.0...3410000100
21B06slow_music66.66666773.6271671.00000027.85050031.0Male4.04.0...5510000-410
22B07slow_music48.33333335.1753331.00000023.63933332.0Female2.01.0...5410110010
23B03slow_music47.50000014.1780000.50000043.44383326.0Female2.01.0...23101000-2-1
24B09slow_music46.66666759.7263331.00000018.68350026.0Female3.02.0...421011011-1
25B11slow_music64.16666727.9193331.00000018.59883325.0Male4.03.0...2410010-1-10
26B14slow_music27.16666749.3013331.0000006.79066724.0Male4.03.0...4410010121
27B16slow_music26.66666718.2953330.83333315.43250025.0Female1.01.0...34101002-1-1
28B12slow_music40.83333325.1608331.0000007.69616723.0Male4.02.0...4510010-100
29B18slow_music41.66666718.1788330.50000013.69800028.0Female2.02.0...4510100-2-11
30B17slow_music46.66666736.7390000.8333336.08983325.0Non-binary4.01.0...3410010000
31B13slow_music38.33333317.6513330.6666679.42783319.0Non-binary3.01.0...13100003-1-1
32B20slow_music26.16666718.9121671.00000019.12416720.0Female3.02.0...2310110-100
33B24slow_music40.00000049.3530000.83333312.07383323.0Male4.01.0...5510000100
34B22slow_music41.66666714.4813330.83333316.04566732.0Female4.02.0...2310101000
35B90slow_music68.33333316.9710000.83333316.31016725.0Male3.02.0...3410001100
36B26slow_music48.33333322.7748330.83333316.68216719.0Female3.01.0...5410100011
37B25slow_music24.16666714.8655001.00000010.37233326.0Female4.02.0...4310110120
38B30slow_music43.3333335.6483330.83333322.52600021.0Male2.02.0...3410010100
39B15slow_music31.33333324.6145000.83333312.92600024.0Male4.02.0...4410010-101
40C04personalized_music47.50000016.0165000.83333313.51233324.0Female3.01.0...520110010-2
41C08personalized_music7.50000035.5988330.50000037.96083326.0Male3.02.0...2301000-1-10
42C07personalized_music62.50000027.8975001.0000009.91183324.0Female3.01.0...4501100120
43C09personalized_music70.00000027.0685001.00000012.15133324.0Male2.01.0...3501000000
44C10personalized_music41.83333317.1976671.00000012.79833326.0Female2.01.0...3401110000
45C14personalized_music27.33333337.1951670.83333316.16816725.0Male3.04.0...4501010-100
46C17personalized_music100.00000028.8606671.0000009.19716719.0Male4.03.0...23010002-1-1
47C13personalized_music25.00000017.8753331.00000016.08283327.0Female4.02.0...4501100100
48C05personalized_music45.00000011.4876670.83333312.87633319.0Male3.03.0...4501010111
49C15personalized_music68.33333314.8105000.83333311.52633327.0Female3.01.0...4401100020
50C11personalized_music63.33333351.7213330.66666717.46383325.0Female2.01.0...4401100100
51C16personalized_music39.16666724.7443330.83333314.17133323.0Male3.02.0...5501010-202
52C12personalized_music18.33333339.5588331.0000009.73833325.0Male4.04.0...540101021-1
53C22personalized_music63.33333352.5485000.83333327.44583324.0Female3.02.0...4301110-120
54C28personalized_music40.00000029.0976670.50000010.03300019.0Female3.02.0...4401100011
55C29personalized_music43.00000015.5516670.83333310.23766724.0Male3.01.0...3501000101
56C18personalized_music44.16666712.2770000.6666677.38350028.0Female3.02.0...540111010-1
57C30personalized_music64.16666716.8845001.00000010.40766726.0Female2.03.0...4301110021
\n", "

58 rows × 28 columns

\n", "
" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "execution_count": 40 }, { "metadata": {}, "cell_type": "code", "source": [ "# Notes for current state:\n", "# 1. MusicHabit and Gender have to be added making the potential future regression model:\n", "# Riskiness_i = beta0 + beta1*SlowMusic_i + beta2*PersonalizedMusic_i\n", "# + beta3*MusicHabit_i + beta4*Gender_i + error_i\n" ], "id": "e93835be7a19729d", "outputs": [], "execution_count": null }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-28T18:18:42.652123Z", "start_time": "2026-03-28T18:18:42.548191Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 6. DESCRIPTIVE STATISTICS\n", "# -------------------------\n", "\n", "# 6.1 Means by treatment\n", "desc_mean_treatment = clean.groupby('participant.treatment_x')[[\n", " 'riskiness', 'inv_speed', 'math_accuracy', 'math_speed'\n", "]].mean()\n", "\n", "print(\"=== Means by Treatment ===\")\n", "print(desc_mean_treatment)\n", "\n", "\n", "# 6.2 Standard deviations by treatment\n", "desc_std_treatment = clean.groupby('participant.treatment_x')[[\n", " 'riskiness', 'inv_speed', 'math_accuracy', 'math_speed'\n", "]].std()\n", "\n", "print(\"\\n=== Standard Deviations by Treatment ===\")\n", "print(desc_std_treatment)\n", "\n", "\n", "# 6.3 Observations per treatment group\n", "desc_count_treatment = clean.groupby('participant.treatment_x').size()\n", "\n", "print(\"\\n=== Observations per Group ===\")\n", "print(desc_count_treatment)\n", "\n", "\n", "# 6.4 Means by gender\n", "desc_mean_gender = clean.groupby('female')[[\n", " 'riskiness', 'inv_speed', 'math_accuracy', 'math_speed'\n", "]].mean()\n", "\n", "print(\"\\n=== Means by Gender (female=1, non-female=0) ===\")\n", "print(desc_mean_gender)\n", "\n", "\n", "# 6.5 Emotion levels before and after by treatment\n", "desc_emotions = clean.groupby('participant.treatment_x')[[\n", " 'thesis_exp_pre_survey.1.player.emo_calmness_x',\n", " 'thesis_exp_post_survey.1.player.feeling_now_x',\n", " 'thesis_exp_pre_survey.1.player.emo_energy_x',\n", " 'thesis_exp_post_survey.1.player.energy_now_x',\n", " 'thesis_exp_pre_survey.1.player.emo_mood_x',\n", " 'thesis_exp_post_survey.1.player.mood_now_x'\n", "]].mean()\n", "\n", "print(\"\\n=== Emotion Means Before vs After by Treatment ===\")\n", "print(desc_emotions)\n", "\n", "\n", "# 6.6 Emotion change by treatment\n", "desc_delta = clean.groupby('participant.treatment_x')[[\n", " 'delta_calmness', 'delta_energy', 'delta_mood'\n", "]].mean()\n", "\n", "print(\"\\n=== Emotion Change (Post - Pre) by Treatment ===\")\n", "print(desc_delta)\n", "\n", "\n", "# 6.7 Emotion change by gender\n", "desc_delta_gender = clean.groupby('female')[[\n", " 'delta_calmness', 'delta_energy', 'delta_mood'\n", "]].mean()\n", "\n", "print(\"\\n=== Emotion Change (Post - Pre) by Gender (female=1, non-female=0) ===\")\n", "print(desc_delta_gender)" ], "id": "be95c20914a7d05e", "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "=== Means by Treatment ===\n", " riskiness inv_speed math_accuracy math_speed\n", "participant.treatment_x \n", "no_music 51.421053 21.868035 0.780702 17.358632\n", "personalized_music 48.361111 26.466231 0.842593 14.392593\n", "slow_music 45.777778 28.371460 0.857143 15.996373\n", "\n", "=== Standard Deviations by Treatment ===\n", " riskiness inv_speed math_accuracy math_speed\n", "participant.treatment_x \n", "no_music 17.078736 8.667144 0.266740 9.565440\n", "personalized_music 22.024589 12.712804 0.166394 7.397148\n", "slow_music 15.837046 17.086078 0.151710 8.567072\n", "\n", "=== Observations per Group ===\n", "participant.treatment_x\n", "no_music 19\n", "personalized_music 18\n", "slow_music 21\n", "dtype: int64\n", "\n", "=== Means by Gender (female=1, non-female=0) ===\n", " riskiness inv_speed math_accuracy math_speed\n", "female \n", "0 49.382716 27.870012 0.858025 13.305049\n", "1 47.596774 23.715973 0.801075 18.244134\n", "\n", "=== Emotion Means Before vs After by Treatment ===\n", " thesis_exp_pre_survey.1.player.emo_calmness_x \\\n", "participant.treatment_x \n", "no_music 2.578947 \n", "personalized_music 2.666667 \n", "slow_music 2.761905 \n", "\n", " thesis_exp_post_survey.1.player.feeling_now_x \\\n", "participant.treatment_x \n", "no_music 3.368421 \n", "personalized_music 3.000000 \n", "slow_music 2.952381 \n", "\n", " thesis_exp_pre_survey.1.player.emo_energy_x \\\n", "participant.treatment_x \n", "no_music 2.947368 \n", "personalized_music 3.333333 \n", "slow_music 3.333333 \n", "\n", " thesis_exp_post_survey.1.player.energy_now_x \\\n", "participant.treatment_x \n", "no_music 4.000000 \n", "personalized_music 3.833333 \n", "slow_music 3.428571 \n", "\n", " thesis_exp_pre_survey.1.player.emo_mood_x \\\n", "participant.treatment_x \n", "no_music 3.631579 \n", "personalized_music 4.000000 \n", "slow_music 3.904762 \n", "\n", " thesis_exp_post_survey.1.player.mood_now_x \n", "participant.treatment_x \n", "no_music 3.631579 \n", "personalized_music 4.055556 \n", "slow_music 3.904762 \n", "\n", "=== Emotion Change (Post - Pre) by Treatment ===\n", " delta_calmness delta_energy delta_mood\n", "participant.treatment_x \n", "no_music 0.789474 1.052632 0.000000\n", "personalized_music 0.333333 0.500000 0.055556\n", "slow_music 0.190476 0.095238 0.000000\n", "\n", "=== Emotion Change (Post - Pre) by Gender (female=1, non-female=0) ===\n", " delta_calmness delta_energy delta_mood\n", "female \n", "0 0.259259 0.333333 0.037037\n", "1 0.580645 0.709677 0.000000\n" ] } ], "execution_count": 41 }, { "metadata": { "ExecuteTime": { "end_time": "2026-03-29T20:00:08.216236Z", "start_time": "2026-03-29T20:00:07.481684Z" } }, "cell_type": "code", "source": [ "# -------------------------\n", "# 6.8 ANOVA TESTS\n", "# -------------------------\n", "\n", "from scipy.stats import f_oneway\n", "\n", "# Helper function\n", "def run_anova(var):\n", " groups = [\n", " clean[clean['participant.treatment_x'] == 'no_music'][var],\n", " clean[clean['participant.treatment_x'] == 'slow_music'][var],\n", " clean[clean['participant.treatment_x'] == 'personalized_music'][var]\n", " ]\n", "\n", " f_stat, p_value = f_oneway(*groups)\n", " print(f\"{var}: F = {f_stat:.3f}, p = {p_value:.4f}\")\n", "\n", "\n", "print(\"\\n=== ANOVA: Treatment Effects ===\")\n", "\n", "# Main outcomes\n", "run_anova('riskiness')\n", "run_anova('inv_speed')\n", "run_anova('math_accuracy')\n", "run_anova('math_speed')\n", "\n", "print(\"\\n=== ANOVA: Emotion Changes ===\")\n", "\n", "# Emotion changes\n", "run_anova('delta_calmness')\n", "run_anova('delta_energy')\n", "run_anova('delta_mood')" ], "id": "4b6fed7aafb73040", "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "\n", "=== ANOVA: Treatment Effects ===\n", "riskiness: F = 0.472, p = 0.6262\n", "inv_speed: F = 1.216, p = 0.3044\n", "math_accuracy: F = 0.798, p = 0.4555\n", "math_speed: F = 0.553, p = 0.5782\n", "\n", "=== ANOVA: Emotion Changes ===\n", "delta_calmness: F = 1.070, p = 0.3501\n", "delta_energy: F = 5.832, p = 0.0050\n", "delta_mood: F = 0.029, p = 0.9719\n" ] } ], "execution_count": 42 }, { "metadata": {}, "cell_type": "code", "source": [ "# -------------------------\n", "# 7. REGRESSIONS (WITH CONTROLS)\n", "# -------------------------\n", "\n", "import statsmodels.api as sm\n", "\n", "X = clean[[\n", " 'slow_music_dummy',\n", " 'personalized_dummy',\n", " 'thesis_pre_survey.1.player.q1_age',\n", " 'female',\n", " 'thesis_pre_survey.1.player.q9_arithmetic_comfort',\n", " 'thesis_pre_survey.1.player.q10_investing_experience',\n", " 'thesis_pre_survey.1.player.q11_overdrawn_frequency',\n", " 'thesis_pre_survey.1.player.q12_gambling_experience',\n", " 'thesis_pre_survey.1.player.q13_music_frequency',\n", " 'tempo_medium',\n", " 'tempo_fast'\n", "]]\n", "\n", "X = sm.add_constant(X)\n", "\n", "# --- Riskiness ---\n", "y = clean['riskiness']\n", "model_risk = sm.OLS(y, X).fit()\n", "print(\"=== Riskiness ===\")\n", "print(model_risk.summary())\n", "\n", "# --- Investment Speed ---\n", "y = clean['inv_speed']\n", "model_inv = sm.OLS(y, X).fit()\n", "print(\"\\n=== Investment Speed ===\")\n", "print(model_inv.summary())\n", "\n", "# --- Math Accuracy ---\n", "y = clean['math_accuracy']\n", "model_acc = sm.OLS(y, X).fit()\n", "print(\"\\n=== Math Accuracy ===\")\n", "print(model_acc.summary())\n", "\n", "# --- Math Speed ---\n", "y = clean['math_speed']\n", "model_speed = sm.OLS(y, X).fit()\n", "print(\"\\n=== Math Speed ===\")\n", "print(model_speed.summary())" ], "id": "7f84863649f2df8f", "outputs": [], "execution_count": null } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.6" } }, "nbformat": 4, "nbformat_minor": 5 }