Data_split.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d0430ccc",
   "metadata": {
    "code_folding": [
     0
    ]
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/evida-monika/anaconda3/envs/mhunters/lib/python3.10/site-packages/outdated/utils.py:14: OutdatedPackageWarning: The package pingouin is out of date. Your version is 0.5.2, the latest is 0.5.3.\n",
      "Set the environment variable OUTDATED_IGNORE=1 to disable these warnings.\n",
      "  return warn(\n"
     ]
    }
   ],
   "source": [
    "# libraries\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import bz2\n",
    "pd.set_option('display.max_columns', None)\n",
    "import statistics\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import math\n",
    "import pingouin as pg\n",
    "import statsmodels.api as sm\n",
    "import matplotlib as mpl\n",
    "from scipy import stats\n",
    "from distfit import distfit\n",
    "import scikit_posthocs as sp\n",
    "import datetime as dt\n",
    "\n",
    "pd.options.display.float_format = '{:.2f}'.format\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "\n",
    "plt.rcParams[\"image.cmap\"] = \"Pastel2\"\n",
    "\n",
    "\n",
    "# planting seed\n",
    "\n",
    "import random\n",
    "\n",
    "random.seed(10)\n",
    "\n",
    "# importing data\n",
    "\n",
    "df = pd.read_csv(\"/home/evida-monika/mhunters/final_data_5.csv.bz2\", compression=\"bz2\", sep=\",\")\n",
    "\n",
    "# this is cleaned dataset\n",
    "# we need to delete another user - ID = 235, because it has 274 sessions in 4 weeks - impossible.\n",
    "\n",
    "df = df[df['id_users'] != 235]\n",
    "\n",
    "# changing types of data\n",
    "\n",
    "cols = ['name_en_exercises','discarded_session_execution', 'code_name_sessions', \n",
    "        'name_en_sessions', 'active_user_programs', 'completed_user_programs',\n",
    "        'pro_programs', 'available_programs', 'name_en_programs', \n",
    "        'gender', \n",
    "        'activity_level', 'goal', 'body_type', 'newsletter_subscription', 'notifications_setting',\n",
    "        'language', 'scientific_data_usage', 'BMI_category', 'name_en_implements', 'cluster']\n",
    "\n",
    "for col in cols:\n",
    "    df[col] = df[col].astype('category')\n",
    "    \n",
    "col_date = ['updated_at_ex_ex', 'created_at_exercises', 'updated_at_exercises',\n",
    "            'updated_at_session_execution', 'created_at_user_programs', 'updated_at_user_programs',\n",
    "            'created_at_programs', 'updated_at_programs', 'created_at_users', 'updated_at_users',\n",
    "            'date_of_birth']\n",
    "\n",
    "for col in col_date:\n",
    "    df[col] = pd.to_datetime(df[col])#.dt.strftime(\"%Y-%m-%d %H:%M:%S\")\n",
    "\n",
    "cat_names = {\n",
    "    'gender': {1: 'male', 0: 'female'},\n",
    "    'activity_level': {0: 'very active', 1: 'active', 2: 'sedentary'},\n",
    "    'goal': {0: 'lose', 1: 'gain', 2: 'antiaging'},\n",
    "    'body_type': {0: 'thin', 1: 'mid', 2: 'strong'}\n",
    "}\n",
    "\n",
    "df = df.replace(cat_names)\n",
    "\n",
    "\n",
    "# Correlation plots and table definition\n",
    "\n",
    "def corr_heatmap_p(df):\n",
    "    rho, p = stats.spearmanr(df)\n",
    "    \n",
    "    rho = pd.DataFrame(rho).set_index(pd.Index(df.columns))\n",
    "    rho.columns = df.columns\n",
    "    \n",
    "    p = pd.DataFrame(p).set_index(pd.Index(df.columns))\n",
    "    p.columns = df.columns\n",
    "    \n",
    "    plt.figure(figsize=(12,7))\n",
    "    heatmap = sns.heatmap(rho, vmin=-1, \n",
    "                      vmax=1, annot=True)\n",
    "    plt.title(\"Spearman Correlation\")\n",
    "    \n",
    "    \n",
    "    s = set_title = np.vectorize(lambda ax,rho2: ax.title.set_text(\n",
    "                                        '$\\\\rho$ = ' + \n",
    "                                        \"{:.2f}\".format(rho2)) if ax!=None else None\n",
    "                            )      \n",
    "\n",
    "    rho2 = df.corr(method=\"spearman\")\n",
    "    g = sns.PairGrid(df,corner=True)\n",
    "    g.map_diag(plt.hist,color=\"yellow\")\n",
    "    g.map_lower(sns.scatterplot,color=\"magenta\")\n",
    "    set_title(g.axes,rho2)\n",
    "    plt.subplots_adjust(hspace = 0.6)\n",
    "    plt.show()\n",
    "    \n",
    "    for col in rho.columns:\n",
    "        rho[col] = np.where((p[col] <= 0.05) & (p[col] > 0.01) & (col != rho.index),\n",
    "                                          rho[col].round(2).astype('str') + '*', \n",
    "                                          np.where((p[col] <= 0.01) & (p[col] > 0.001) & (col != rho.index),\n",
    "                                          rho[col].round(2).astype('str') + '**', \n",
    "                                          np.where((p[col] <= 0.001) & (col != rho.index),\n",
    "                                          rho[col].round(2).astype('str') + '***', \n",
    "                                          rho[col])))\n",
    "        \n",
    "    \n",
    "\n",
    "    return(rho)\n",
    "\n",
    "# dataset only for users\n",
    "\n",
    "df_users_only_once = df.drop_duplicates(subset=['id_users'], keep='first')\n",
    "\n",
    "# here dropping all of the columns that are not relevant for users\n",
    "\n",
    "df_users_only = df_users_only_once.loc[:, ['id_users', 'created_at_users', 'updated_at_users', 'gender',\n",
    "       'date_of_birth', 'height', 'weight', 'activity_level', 'goal',\n",
    "       'body_type', 'body_fat', 'newsletter_subscription',\n",
    "       'notifications_setting', 'training_days_setting', 'language', 'points',\n",
    "       'scientific_data_usage', 'best_weekly_streak_users', 'BMI', 'BMI_category', 'total_sessions_users2',\n",
    "                                          'total_time_users2', 'total_reps_users2', 'reps_per_session_users2',\n",
    "                                          'total_calories_users2', 'kcal_per_session_users2', 'exercises_per_user', \n",
    "                                        'exercises_without_rest_per_user', 'cluster']]\n",
    "\n",
    "# dataset for only one of id_session_execution\n",
    "\n",
    "df_session_exe_only_once = df.drop_duplicates(subset=['id_session_execution'], keep='first')\n",
    "\n",
    "# here dropping all of the columns that are not relevant for session_execution\n",
    "\n",
    "df_session_exe = df_session_exe_only_once.loc[:, ['id_session_execution', \n",
    "                                                  'difficulty_feedback_session_execution',\n",
    "       'enjoyment_feedback_session_execution',\n",
    "       'reps_executed_session_execution', 'updated_at_session_execution',\n",
    "       'discarded_session_execution', 'id_sessions', 'order_sessions',\n",
    "       'time_duration_sessions', 'code_name_sessions', 'name_en_sessions',\n",
    "       'id_user_programs', 'created_at_user_programs',\n",
    "       'updated_at_user_programs', 'active_user_programs',\n",
    "       'current_session_id_user_programs', 'completed_user_programs',\n",
    "       'id_programs', 'created_at_programs', 'updated_at_programs',\n",
    "       'pro_programs', 'available_programs', 'strength_programs',\n",
    "       'endurance_programs', 'technique_programs', 'flexibility_programs',\n",
    "       'intensity_programs', 'name_en_programs', 'description_en_programs',\n",
    "       'id_users', 'created_at_users', 'updated_at_users', 'gender',\n",
    "       'date_of_birth', 'height', 'weight', 'activity_level', 'goal',\n",
    "       'body_type', 'body_fat', 'newsletter_subscription',\n",
    "       'notifications_setting', 'training_days_setting', 'language', 'points',\n",
    "       'scientific_data_usage', 'best_weekly_streak_users', 'BMI', 'BMI_category', 'total_sessions_users2',\n",
    "       'total_time_session_execution', 'total_reps_session_execution',\n",
    "       'total_time_users2', 'total_reps_users2', 'reps_per_session_users2',\n",
    "       'total_time_session_execution_min', 'reps_per_min_session_execution',\n",
    "       'exercise_execution_time_min', 'calories_session_execution',\n",
    "       'total_calories_users2', 'kcal_per_session_users2',\n",
    "                                          'YYYY/WW', 'number_exercises_in_session',\n",
    "                                    'number_exercises_without_rest_in_session']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "33c01950",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_session_exe_dropped_columns = df_session_exe.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9335c791",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_session_exe_dropped_columns.drop(['points', 'best_weekly_streak_users', \n",
    "                                     'total_sessions_users2', 'total_time_users2',\n",
    "                                     'total_reps_users2', 'reps_per_session_users2',\n",
    "                                     'exercise_execution_time_min', \n",
    "                                     'total_calories_users2', 'kcal_per_session_users2'],\n",
    "                                   axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "e2a61a0a",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_session_execution</th>\n",
       "      <th>difficulty_feedback_session_execution</th>\n",
       "      <th>enjoyment_feedback_session_execution</th>\n",
       "      <th>reps_executed_session_execution</th>\n",
       "      <th>updated_at_session_execution</th>\n",
       "      <th>discarded_session_execution</th>\n",
       "      <th>id_sessions</th>\n",
       "      <th>order_sessions</th>\n",
       "      <th>time_duration_sessions</th>\n",
       "      <th>code_name_sessions</th>\n",
       "      <th>name_en_sessions</th>\n",
       "      <th>id_user_programs</th>\n",
       "      <th>created_at_user_programs</th>\n",
       "      <th>updated_at_user_programs</th>\n",
       "      <th>active_user_programs</th>\n",
       "      <th>current_session_id_user_programs</th>\n",
       "      <th>completed_user_programs</th>\n",
       "      <th>id_programs</th>\n",
       "      <th>created_at_programs</th>\n",
       "      <th>updated_at_programs</th>\n",
       "      <th>pro_programs</th>\n",
       "      <th>available_programs</th>\n",
       "      <th>strength_programs</th>\n",
       "      <th>endurance_programs</th>\n",
       "      <th>technique_programs</th>\n",
       "      <th>flexibility_programs</th>\n",
       "      <th>intensity_programs</th>\n",
       "      <th>name_en_programs</th>\n",
       "      <th>description_en_programs</th>\n",
       "      <th>id_users</th>\n",
       "      <th>created_at_users</th>\n",
       "      <th>updated_at_users</th>\n",
       "      <th>gender</th>\n",
       "      <th>date_of_birth</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>activity_level</th>\n",
       "      <th>goal</th>\n",
       "      <th>body_type</th>\n",
       "      <th>body_fat</th>\n",
       "      <th>newsletter_subscription</th>\n",
       "      <th>notifications_setting</th>\n",
       "      <th>training_days_setting</th>\n",
       "      <th>language</th>\n",
       "      <th>scientific_data_usage</th>\n",
       "      <th>BMI</th>\n",
       "      <th>BMI_category</th>\n",
       "      <th>total_time_session_execution</th>\n",
       "      <th>total_reps_session_execution</th>\n",
       "      <th>total_time_session_execution_min</th>\n",
       "      <th>reps_per_min_session_execution</th>\n",
       "      <th>calories_session_execution</th>\n",
       "      <th>YYYY/WW</th>\n",
       "      <th>number_exercises_in_session</th>\n",
       "      <th>number_exercises_without_rest_in_session</th>\n",
       "      <th>month_session_execution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6132.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>368.00</td>\n",
       "      <td>2021-11-01 12:05:40.078024</td>\n",
       "      <td>False</td>\n",
       "      <td>710.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1105.00</td>\n",
       "      <td>PM1.2_V2</td>\n",
       "      <td>Session 2</td>\n",
       "      <td>7181.00</td>\n",
       "      <td>2021-10-25 11:04:40.657070</td>\n",
       "      <td>2021-11-28 11:26:22.131395</td>\n",
       "      <td>False</td>\n",
       "      <td>713.00</td>\n",
       "      <td>True</td>\n",
       "      <td>10.00</td>\n",
       "      <td>2020-11-23 13:41:46.587265</td>\n",
       "      <td>2021-09-29 14:53:34.897432</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>Get motivated!</td>\n",
       "      <td>The ultimate beginner’s program designed to he...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>988.00</td>\n",
       "      <td>368.00</td>\n",
       "      <td>16.47</td>\n",
       "      <td>22.35</td>\n",
       "      <td>50.95</td>\n",
       "      <td>2021/44</td>\n",
       "      <td>55</td>\n",
       "      <td>32</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>7495.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>2021-11-06 13:52:37.632519</td>\n",
       "      <td>False</td>\n",
       "      <td>711.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>386.00</td>\n",
       "      <td>PM1.3_V2</td>\n",
       "      <td>Session 3</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>635.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>10.58</td>\n",
       "      <td>14.17</td>\n",
       "      <td>38.32</td>\n",
       "      <td>2021/44</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>9800.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>286.00</td>\n",
       "      <td>2021-11-14 13:44:04.327400</td>\n",
       "      <td>False</td>\n",
       "      <td>320.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>962.00</td>\n",
       "      <td>MuHu7.1</td>\n",
       "      <td>Session 6</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>1322.00</td>\n",
       "      <td>286.00</td>\n",
       "      <td>22.03</td>\n",
       "      <td>12.98</td>\n",
       "      <td>72.86</td>\n",
       "      <td>2021/45</td>\n",
       "      <td>57</td>\n",
       "      <td>34</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>8444.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>72.00</td>\n",
       "      <td>2021-11-09 18:47:45.480112</td>\n",
       "      <td>False</td>\n",
       "      <td>713.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>662.00</td>\n",
       "      <td>PM1.5_V2</td>\n",
       "      <td>Session 5</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>685.00</td>\n",
       "      <td>80.00</td>\n",
       "      <td>11.42</td>\n",
       "      <td>7.01</td>\n",
       "      <td>37.74</td>\n",
       "      <td>2021/45</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>8075.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>2021-11-08 19:29:14.727155</td>\n",
       "      <td>False</td>\n",
       "      <td>634.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1140.00</td>\n",
       "      <td>Descanso Activo 1</td>\n",
       "      <td>Regenerative</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>1269.00</td>\n",
       "      <td>155.00</td>\n",
       "      <td>21.15</td>\n",
       "      <td>7.33</td>\n",
       "      <td>50.15</td>\n",
       "      <td>2021/45</td>\n",
       "      <td>48</td>\n",
       "      <td>25</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id_session_execution  difficulty_feedback_session_execution  \\\n",
       "0                 6132.00                                   4.00   \n",
       "55                7495.00                                   5.00   \n",
       "70                9800.00                                   8.00   \n",
       "127               8444.00                                   7.00   \n",
       "144               8075.00                                   6.00   \n",
       "\n",
       "     enjoyment_feedback_session_execution  reps_executed_session_execution  \\\n",
       "0                                    3.00                           368.00   \n",
       "55                                   3.00                           150.00   \n",
       "70                                   4.00                           286.00   \n",
       "127                                  4.00                            72.00   \n",
       "144                                  4.00                           150.00   \n",
       "\n",
       "    updated_at_session_execution discarded_session_execution  id_sessions  \\\n",
       "0     2021-11-01 12:05:40.078024                       False       710.00   \n",
       "55    2021-11-06 13:52:37.632519                       False       711.00   \n",
       "70    2021-11-14 13:44:04.327400                       False       320.00   \n",
       "127   2021-11-09 18:47:45.480112                       False       713.00   \n",
       "144   2021-11-08 19:29:14.727155                       False       634.00   \n",
       "\n",
       "     order_sessions  time_duration_sessions code_name_sessions  \\\n",
       "0              2.00                 1105.00           PM1.2_V2   \n",
       "55             3.00                  386.00           PM1.3_V2   \n",
       "70             7.00                  962.00            MuHu7.1   \n",
       "127            5.00                  662.00           PM1.5_V2   \n",
       "144            1.00                 1140.00  Descanso Activo 1   \n",
       "\n",
       "    name_en_sessions  id_user_programs   created_at_user_programs  \\\n",
       "0          Session 2           7181.00 2021-10-25 11:04:40.657070   \n",
       "55         Session 3          35844.00 2021-11-03 10:24:44.496283   \n",
       "70         Session 6          35844.00 2021-11-03 10:24:44.496283   \n",
       "127        Session 5          35844.00 2021-11-03 10:24:44.496283   \n",
       "144     Regenerative          35844.00 2021-11-03 10:24:44.496283   \n",
       "\n",
       "      updated_at_user_programs active_user_programs  \\\n",
       "0   2021-11-28 11:26:22.131395                False   \n",
       "55  2022-07-11 12:39:18.024392                 True   \n",
       "70  2022-07-11 12:39:18.024392                 True   \n",
       "127 2022-07-11 12:39:18.024392                 True   \n",
       "144 2022-07-11 12:39:18.024392                 True   \n",
       "\n",
       "     current_session_id_user_programs completed_user_programs  id_programs  \\\n",
       "0                              713.00                    True        10.00   \n",
       "55                             315.00                   False        34.00   \n",
       "70                             315.00                   False        34.00   \n",
       "127                            315.00                   False        34.00   \n",
       "144                            315.00                   False        34.00   \n",
       "\n",
       "           created_at_programs        updated_at_programs pro_programs  \\\n",
       "0   2020-11-23 13:41:46.587265 2021-09-29 14:53:34.897432        False   \n",
       "55  2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "70  2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "127 2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "144 2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "\n",
       "    available_programs  strength_programs  endurance_programs  \\\n",
       "0                 True               1.00                3.00   \n",
       "55                True               5.00                4.00   \n",
       "70                True               5.00                4.00   \n",
       "127               True               5.00                4.00   \n",
       "144               True               5.00                4.00   \n",
       "\n",
       "     technique_programs  flexibility_programs  intensity_programs  \\\n",
       "0                  1.00                  2.00                2.00   \n",
       "55                 3.00                  3.00                5.00   \n",
       "70                 3.00                  3.00                5.00   \n",
       "127                3.00                  3.00                5.00   \n",
       "144                3.00                  3.00                5.00   \n",
       "\n",
       "                name_en_programs  \\\n",
       "0                 Get motivated!   \n",
       "55   Muscle Hunters Initiation 1   \n",
       "70   Muscle Hunters Initiation 1   \n",
       "127  Muscle Hunters Initiation 1   \n",
       "144  Muscle Hunters Initiation 1   \n",
       "\n",
       "                               description_en_programs  id_users  \\\n",
       "0    The ultimate beginner’s program designed to he...   2273.00   \n",
       "55   Muscle Hunters is a program created for you to...   2273.00   \n",
       "70   Muscle Hunters is a program created for you to...   2273.00   \n",
       "127  Muscle Hunters is a program created for you to...   2273.00   \n",
       "144  Muscle Hunters is a program created for you to...   2273.00   \n",
       "\n",
       "              created_at_users           updated_at_users  gender  \\\n",
       "0   2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "55  2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "70  2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "127 2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "144 2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "\n",
       "    date_of_birth  height  weight activity_level  goal body_type  body_fat  \\\n",
       "0      1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "55     1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "70     1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "127    1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "144    1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "\n",
       "    newsletter_subscription notifications_setting  training_days_setting  \\\n",
       "0                     False                  True                   3.00   \n",
       "55                    False                  True                   3.00   \n",
       "70                    False                  True                   3.00   \n",
       "127                   False                  True                   3.00   \n",
       "144                   False                  True                   3.00   \n",
       "\n",
       "    language scientific_data_usage   BMI BMI_category  \\\n",
       "0         es                  True 24.84       Normal   \n",
       "55        es                  True 24.84       Normal   \n",
       "70        es                  True 24.84       Normal   \n",
       "127       es                  True 24.84       Normal   \n",
       "144       es                  True 24.84       Normal   \n",
       "\n",
       "     total_time_session_execution  total_reps_session_execution  \\\n",
       "0                          988.00                        368.00   \n",
       "55                         635.00                        150.00   \n",
       "70                        1322.00                        286.00   \n",
       "127                        685.00                         80.00   \n",
       "144                       1269.00                        155.00   \n",
       "\n",
       "     total_time_session_execution_min  reps_per_min_session_execution  \\\n",
       "0                               16.47                           22.35   \n",
       "55                              10.58                           14.17   \n",
       "70                              22.03                           12.98   \n",
       "127                             11.42                            7.01   \n",
       "144                             21.15                            7.33   \n",
       "\n",
       "     calories_session_execution  YYYY/WW  number_exercises_in_session  \\\n",
       "0                         50.95  2021/44                           55   \n",
       "55                        38.32  2021/44                           15   \n",
       "70                        72.86  2021/45                           57   \n",
       "127                       37.74  2021/45                           17   \n",
       "144                       50.15  2021/45                           48   \n",
       "\n",
       "     number_exercises_without_rest_in_session  month_session_execution  \n",
       "0                                          32                       11  \n",
       "55                                         15                       11  \n",
       "70                                         34                       11  \n",
       "127                                        17                       11  \n",
       "144                                        25                       11  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_session_exe_dropped_columns.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "de0d5035",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_session_exe_dropped_columns['month_session_execution'] = pd.DatetimeIndex(df_session_exe_dropped_columns['updated_at_session_execution']).month\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "ce56ecaa",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_11_2021 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 11]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "3c8b2a2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_12_2021 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 12]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "5eb3fc3d",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_01_2022 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "95255b8d",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_02_2022 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "872ceeeb",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_03_2022 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "6fbc39bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_04_2022 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "8d2e4a63",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_05_2022 = df_session_exe_dropped_columns[df_session_exe_dropped_columns['month_session_execution'] == 5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "418960d4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_session_execution</th>\n",
       "      <th>difficulty_feedback_session_execution</th>\n",
       "      <th>enjoyment_feedback_session_execution</th>\n",
       "      <th>reps_executed_session_execution</th>\n",
       "      <th>updated_at_session_execution</th>\n",
       "      <th>discarded_session_execution</th>\n",
       "      <th>id_sessions</th>\n",
       "      <th>order_sessions</th>\n",
       "      <th>time_duration_sessions</th>\n",
       "      <th>code_name_sessions</th>\n",
       "      <th>name_en_sessions</th>\n",
       "      <th>id_user_programs</th>\n",
       "      <th>created_at_user_programs</th>\n",
       "      <th>updated_at_user_programs</th>\n",
       "      <th>active_user_programs</th>\n",
       "      <th>current_session_id_user_programs</th>\n",
       "      <th>completed_user_programs</th>\n",
       "      <th>id_programs</th>\n",
       "      <th>created_at_programs</th>\n",
       "      <th>updated_at_programs</th>\n",
       "      <th>pro_programs</th>\n",
       "      <th>available_programs</th>\n",
       "      <th>strength_programs</th>\n",
       "      <th>endurance_programs</th>\n",
       "      <th>technique_programs</th>\n",
       "      <th>flexibility_programs</th>\n",
       "      <th>intensity_programs</th>\n",
       "      <th>name_en_programs</th>\n",
       "      <th>description_en_programs</th>\n",
       "      <th>id_users</th>\n",
       "      <th>created_at_users</th>\n",
       "      <th>updated_at_users</th>\n",
       "      <th>gender</th>\n",
       "      <th>date_of_birth</th>\n",
       "      <th>height</th>\n",
       "      <th>weight</th>\n",
       "      <th>activity_level</th>\n",
       "      <th>goal</th>\n",
       "      <th>body_type</th>\n",
       "      <th>body_fat</th>\n",
       "      <th>newsletter_subscription</th>\n",
       "      <th>notifications_setting</th>\n",
       "      <th>training_days_setting</th>\n",
       "      <th>language</th>\n",
       "      <th>scientific_data_usage</th>\n",
       "      <th>BMI</th>\n",
       "      <th>BMI_category</th>\n",
       "      <th>total_time_session_execution</th>\n",
       "      <th>total_reps_session_execution</th>\n",
       "      <th>total_time_session_execution_min</th>\n",
       "      <th>reps_per_min_session_execution</th>\n",
       "      <th>calories_session_execution</th>\n",
       "      <th>YYYY/WW</th>\n",
       "      <th>number_exercises_in_session</th>\n",
       "      <th>number_exercises_without_rest_in_session</th>\n",
       "      <th>month_session_execution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6132.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>368.00</td>\n",
       "      <td>2021-11-01 12:05:40.078024</td>\n",
       "      <td>False</td>\n",
       "      <td>710.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>1105.00</td>\n",
       "      <td>PM1.2_V2</td>\n",
       "      <td>Session 2</td>\n",
       "      <td>7181.00</td>\n",
       "      <td>2021-10-25 11:04:40.657070</td>\n",
       "      <td>2021-11-28 11:26:22.131395</td>\n",
       "      <td>False</td>\n",
       "      <td>713.00</td>\n",
       "      <td>True</td>\n",
       "      <td>10.00</td>\n",
       "      <td>2020-11-23 13:41:46.587265</td>\n",
       "      <td>2021-09-29 14:53:34.897432</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>2.00</td>\n",
       "      <td>Get motivated!</td>\n",
       "      <td>The ultimate beginner’s program designed to he...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>988.00</td>\n",
       "      <td>368.00</td>\n",
       "      <td>16.47</td>\n",
       "      <td>22.35</td>\n",
       "      <td>50.95</td>\n",
       "      <td>2021/44</td>\n",
       "      <td>55</td>\n",
       "      <td>32</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>7495.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>2021-11-06 13:52:37.632519</td>\n",
       "      <td>False</td>\n",
       "      <td>711.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>386.00</td>\n",
       "      <td>PM1.3_V2</td>\n",
       "      <td>Session 3</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>635.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>10.58</td>\n",
       "      <td>14.17</td>\n",
       "      <td>38.32</td>\n",
       "      <td>2021/44</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>9800.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>286.00</td>\n",
       "      <td>2021-11-14 13:44:04.327400</td>\n",
       "      <td>False</td>\n",
       "      <td>320.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>962.00</td>\n",
       "      <td>MuHu7.1</td>\n",
       "      <td>Session 6</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>1322.00</td>\n",
       "      <td>286.00</td>\n",
       "      <td>22.03</td>\n",
       "      <td>12.98</td>\n",
       "      <td>72.86</td>\n",
       "      <td>2021/45</td>\n",
       "      <td>57</td>\n",
       "      <td>34</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>8444.00</td>\n",
       "      <td>7.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>72.00</td>\n",
       "      <td>2021-11-09 18:47:45.480112</td>\n",
       "      <td>False</td>\n",
       "      <td>713.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>662.00</td>\n",
       "      <td>PM1.5_V2</td>\n",
       "      <td>Session 5</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>685.00</td>\n",
       "      <td>80.00</td>\n",
       "      <td>11.42</td>\n",
       "      <td>7.01</td>\n",
       "      <td>37.74</td>\n",
       "      <td>2021/45</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>8075.00</td>\n",
       "      <td>6.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>2021-11-08 19:29:14.727155</td>\n",
       "      <td>False</td>\n",
       "      <td>634.00</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1140.00</td>\n",
       "      <td>Descanso Activo 1</td>\n",
       "      <td>Regenerative</td>\n",
       "      <td>35844.00</td>\n",
       "      <td>2021-11-03 10:24:44.496283</td>\n",
       "      <td>2022-07-11 12:39:18.024392</td>\n",
       "      <td>True</td>\n",
       "      <td>315.00</td>\n",
       "      <td>False</td>\n",
       "      <td>34.00</td>\n",
       "      <td>2020-11-23 14:15:43.775009</td>\n",
       "      <td>2021-09-29 14:54:09.125824</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>5.00</td>\n",
       "      <td>4.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>3.00</td>\n",
       "      <td>5.00</td>\n",
       "      <td>Muscle Hunters Initiation 1</td>\n",
       "      <td>Muscle Hunters is a program created for you to...</td>\n",
       "      <td>2273.00</td>\n",
       "      <td>2021-10-25 11:04:40.560589</td>\n",
       "      <td>2022-09-07 12:39:46.135605</td>\n",
       "      <td>female</td>\n",
       "      <td>1981-12-31</td>\n",
       "      <td>163.00</td>\n",
       "      <td>66.00</td>\n",
       "      <td>active</td>\n",
       "      <td>lose</td>\n",
       "      <td>mid</td>\n",
       "      <td>15.00</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>3.00</td>\n",
       "      <td>es</td>\n",
       "      <td>True</td>\n",
       "      <td>24.84</td>\n",
       "      <td>Normal</td>\n",
       "      <td>1269.00</td>\n",
       "      <td>155.00</td>\n",
       "      <td>21.15</td>\n",
       "      <td>7.33</td>\n",
       "      <td>50.15</td>\n",
       "      <td>2021/45</td>\n",
       "      <td>48</td>\n",
       "      <td>25</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id_session_execution  difficulty_feedback_session_execution  \\\n",
       "0                 6132.00                                   4.00   \n",
       "55                7495.00                                   5.00   \n",
       "70                9800.00                                   8.00   \n",
       "127               8444.00                                   7.00   \n",
       "144               8075.00                                   6.00   \n",
       "\n",
       "     enjoyment_feedback_session_execution  reps_executed_session_execution  \\\n",
       "0                                    3.00                           368.00   \n",
       "55                                   3.00                           150.00   \n",
       "70                                   4.00                           286.00   \n",
       "127                                  4.00                            72.00   \n",
       "144                                  4.00                           150.00   \n",
       "\n",
       "    updated_at_session_execution discarded_session_execution  id_sessions  \\\n",
       "0     2021-11-01 12:05:40.078024                       False       710.00   \n",
       "55    2021-11-06 13:52:37.632519                       False       711.00   \n",
       "70    2021-11-14 13:44:04.327400                       False       320.00   \n",
       "127   2021-11-09 18:47:45.480112                       False       713.00   \n",
       "144   2021-11-08 19:29:14.727155                       False       634.00   \n",
       "\n",
       "     order_sessions  time_duration_sessions code_name_sessions  \\\n",
       "0              2.00                 1105.00           PM1.2_V2   \n",
       "55             3.00                  386.00           PM1.3_V2   \n",
       "70             7.00                  962.00            MuHu7.1   \n",
       "127            5.00                  662.00           PM1.5_V2   \n",
       "144            1.00                 1140.00  Descanso Activo 1   \n",
       "\n",
       "    name_en_sessions  id_user_programs   created_at_user_programs  \\\n",
       "0          Session 2           7181.00 2021-10-25 11:04:40.657070   \n",
       "55         Session 3          35844.00 2021-11-03 10:24:44.496283   \n",
       "70         Session 6          35844.00 2021-11-03 10:24:44.496283   \n",
       "127        Session 5          35844.00 2021-11-03 10:24:44.496283   \n",
       "144     Regenerative          35844.00 2021-11-03 10:24:44.496283   \n",
       "\n",
       "      updated_at_user_programs active_user_programs  \\\n",
       "0   2021-11-28 11:26:22.131395                False   \n",
       "55  2022-07-11 12:39:18.024392                 True   \n",
       "70  2022-07-11 12:39:18.024392                 True   \n",
       "127 2022-07-11 12:39:18.024392                 True   \n",
       "144 2022-07-11 12:39:18.024392                 True   \n",
       "\n",
       "     current_session_id_user_programs completed_user_programs  id_programs  \\\n",
       "0                              713.00                    True        10.00   \n",
       "55                             315.00                   False        34.00   \n",
       "70                             315.00                   False        34.00   \n",
       "127                            315.00                   False        34.00   \n",
       "144                            315.00                   False        34.00   \n",
       "\n",
       "           created_at_programs        updated_at_programs pro_programs  \\\n",
       "0   2020-11-23 13:41:46.587265 2021-09-29 14:53:34.897432        False   \n",
       "55  2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "70  2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "127 2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "144 2020-11-23 14:15:43.775009 2021-09-29 14:54:09.125824         True   \n",
       "\n",
       "    available_programs  strength_programs  endurance_programs  \\\n",
       "0                 True               1.00                3.00   \n",
       "55                True               5.00                4.00   \n",
       "70                True               5.00                4.00   \n",
       "127               True               5.00                4.00   \n",
       "144               True               5.00                4.00   \n",
       "\n",
       "     technique_programs  flexibility_programs  intensity_programs  \\\n",
       "0                  1.00                  2.00                2.00   \n",
       "55                 3.00                  3.00                5.00   \n",
       "70                 3.00                  3.00                5.00   \n",
       "127                3.00                  3.00                5.00   \n",
       "144                3.00                  3.00                5.00   \n",
       "\n",
       "                name_en_programs  \\\n",
       "0                 Get motivated!   \n",
       "55   Muscle Hunters Initiation 1   \n",
       "70   Muscle Hunters Initiation 1   \n",
       "127  Muscle Hunters Initiation 1   \n",
       "144  Muscle Hunters Initiation 1   \n",
       "\n",
       "                               description_en_programs  id_users  \\\n",
       "0    The ultimate beginner’s program designed to he...   2273.00   \n",
       "55   Muscle Hunters is a program created for you to...   2273.00   \n",
       "70   Muscle Hunters is a program created for you to...   2273.00   \n",
       "127  Muscle Hunters is a program created for you to...   2273.00   \n",
       "144  Muscle Hunters is a program created for you to...   2273.00   \n",
       "\n",
       "              created_at_users           updated_at_users  gender  \\\n",
       "0   2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "55  2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "70  2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "127 2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "144 2021-10-25 11:04:40.560589 2022-09-07 12:39:46.135605  female   \n",
       "\n",
       "    date_of_birth  height  weight activity_level  goal body_type  body_fat  \\\n",
       "0      1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "55     1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "70     1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "127    1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "144    1981-12-31  163.00   66.00         active  lose       mid     15.00   \n",
       "\n",
       "    newsletter_subscription notifications_setting  training_days_setting  \\\n",
       "0                     False                  True                   3.00   \n",
       "55                    False                  True                   3.00   \n",
       "70                    False                  True                   3.00   \n",
       "127                   False                  True                   3.00   \n",
       "144                   False                  True                   3.00   \n",
       "\n",
       "    language scientific_data_usage   BMI BMI_category  \\\n",
       "0         es                  True 24.84       Normal   \n",
       "55        es                  True 24.84       Normal   \n",
       "70        es                  True 24.84       Normal   \n",
       "127       es                  True 24.84       Normal   \n",
       "144       es                  True 24.84       Normal   \n",
       "\n",
       "     total_time_session_execution  total_reps_session_execution  \\\n",
       "0                          988.00                        368.00   \n",
       "55                         635.00                        150.00   \n",
       "70                        1322.00                        286.00   \n",
       "127                        685.00                         80.00   \n",
       "144                       1269.00                        155.00   \n",
       "\n",
       "     total_time_session_execution_min  reps_per_min_session_execution  \\\n",
       "0                               16.47                           22.35   \n",
       "55                              10.58                           14.17   \n",
       "70                              22.03                           12.98   \n",
       "127                             11.42                            7.01   \n",
       "144                             21.15                            7.33   \n",
       "\n",
       "     calories_session_execution  YYYY/WW  number_exercises_in_session  \\\n",
       "0                         50.95  2021/44                           55   \n",
       "55                        38.32  2021/44                           15   \n",
       "70                        72.86  2021/45                           57   \n",
       "127                       37.74  2021/45                           17   \n",
       "144                       50.15  2021/45                           48   \n",
       "\n",
       "     number_exercises_without_rest_in_session  month_session_execution  \n",
       "0                                          32                       11  \n",
       "55                                         15                       11  \n",
       "70                                         34                       11  \n",
       "127                                        17                       11  \n",
       "144                                        25                       11  "
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sessions_executed_11_2021.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "f05b59a6",
   "metadata": {},
   "outputs": [],
   "source": [
    "trial = pd.DataFrame({'total_time_users': sessions_executed_11_2021.groupby(['id_users'])['total_time_session_execution'].sum()})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "53409aed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>total_time_users</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id_users</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>172.00</th>\n",
       "      <td>5681.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219.00</th>\n",
       "      <td>1338.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514.00</th>\n",
       "      <td>4572.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>549.00</th>\n",
       "      <td>576.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>590.00</th>\n",
       "      <td>2189.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12022.00</th>\n",
       "      <td>384.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12027.00</th>\n",
       "      <td>1230.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12036.00</th>\n",
       "      <td>749.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12037.00</th>\n",
       "      <td>279.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12038.00</th>\n",
       "      <td>522.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1239 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          total_time_users\n",
       "id_users                  \n",
       "172.00             5681.00\n",
       "219.00             1338.00\n",
       "514.00             4572.00\n",
       "549.00              576.00\n",
       "590.00             2189.00\n",
       "...                    ...\n",
       "12022.00            384.00\n",
       "12027.00           1230.00\n",
       "12036.00            749.00\n",
       "12037.00            279.00\n",
       "12038.00            522.00\n",
       "\n",
       "[1239 rows x 1 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trial"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "f0fc6b08",
   "metadata": {},
   "outputs": [],
   "source": [
    "sessions_executed_11_2021 = sessions_executed_11_2021.merge(trial, how = 'left', left_on = 'id_users', right_on = 'id_users')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "6ff1bb6b",
   "metadata": {},
   "outputs": [],
   "source": [
    "def change_tables(df):\n",
    "    total_time_users = pd.DataFrame({'total_time_users': df.groupby(['id_users'])['total_time_session_execution'].sum()})\n",
    "    df = df.merge(total_time_users, how = 'left', left_on = 'id_users', right_on = 'id_users')\n",
    "    \n",
    "    total_reps_users = pd.DataFrame({'total_reps_users': df.groupby(['id_users'])['total_reps_session_execution'].sum()})\n",
    "    df = df.merge(total_reps_users, how = 'left', left_on = 'id_users', right_on = 'id_users')\n",
    "    \n",
    "    df['total_time_min'] = df['total_time_users']/60\n",
    "    \n",
    "    total_calories_users = pd.DataFrame({'total_calories_users': df.groupby(['id_users'])['calories_session_execution'].sum()})\n",
    "    df = df.merge(total_calories_users, how = 'left', left_on = 'id_users', right_on = 'id_users')\n",
    "    \n",
    "    total_sessions_users = pd.DataFrame({'total_sessions_users': df.groupby(['id_users'])['id_session_execution'].nunique()})\n",
    "    df = df.merge(total_sessions_users, how = 'left', left_on = 'id_users', right_on = 'id_users')\n",
    "\n",
    "    df['reps_per_session_users'] = df['total_reps_users']/df['total_sessions_users']\n",
    "    df['calories_per_session_users'] = df['total_calories_users']/df['total_sessions_users']\n",
    "    \n",
    "    total_exercises_users = pd.DataFrame({'total_exercises_users': df.groupby(['id_users'])['number_exercises_in_session'].sum()})\n",
    "    df = df.merge(total_exercises_users, how = 'left', left_on = 'id_users', right_on = 'id_users')\n",
    "    \n",
    "    total_exercises_without_rest_users = pd.DataFrame({'total_exercises_without_rest_users': df.groupby(['id_users'])['number_exercises_without_rest_in_session'].sum()})\n",
    "    df = df.merge(total_exercises_without_rest_users, how = 'left', left_on = 'id_users', right_on = 'id_users')\n",
    "\n",
    "    return df\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "d7e7f0e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_11_2021 = change_tables(sessions_executed_11_2021)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "2a7521e3",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_11_2021.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_11_2021.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "c03b22bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_12_2021 = change_tables(sessions_executed_12_2021)\n",
    "df_sessions_executed_1_2022 = change_tables(sessions_executed_01_2022)\n",
    "df_sessions_executed_2_2022 = change_tables(sessions_executed_02_2022)\n",
    "df_sessions_executed_3_2022 = change_tables(sessions_executed_03_2022)\n",
    "df_sessions_executed_4_2022 = change_tables(sessions_executed_04_2022)\n",
    "df_sessions_executed_5_2022 = change_tables(sessions_executed_05_2022)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "1d24ef15",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_12_2021.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_12_2021.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "0a20b8b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_1_2022.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_01_2022.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "990ae0ca",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_2_2022.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_02_2022.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "95e1af60",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_3_2022.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_03_2022.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "243b733f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_4_2022.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_04_2022.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "d886c3bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sessions_executed_5_2022.to_csv(r'/home/evida-monika/mhunters/df_sessions_executed_05_2022.csv'+ '.bz2', header=True, index=False,compression='bz2')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b4fd6583",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.9"
  },
  "nbTranslate": {
   "displayLangs": [
    "*"
   ],
   "hotkey": "alt-t",
   "langInMainMenu": true,
   "sourceLang": "en",
   "targetLang": "fr",
   "useGoogleTranslate": true
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": true,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {
    "height": "calc(100% - 180px)",
    "left": "10px",
    "top": "150px",
    "width": "345.717px"
   },
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}