ModelConcatModel.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "30b1d69d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import operator as op\n",
    "import warnings\n",
    "warnings.filterwarnings(action = 'ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "de912258",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"DataLast.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0d12f339",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.drop(\"Unnamed: 0\", axis = 1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "9a6659c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"User_ID\"] = df[\"User_ID\"].astype(\"string\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d13593a7",
   "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>User_ID</th>\n",
       "      <th>Participant_Type</th>\n",
       "      <th>Successful_Submission_Count</th>\n",
       "      <th>Comp_participation_day</th>\n",
       "      <th>FeatureA</th>\n",
       "      <th>FeatureB</th>\n",
       "      <th>FeatureC</th>\n",
       "      <th>FeatureD</th>\n",
       "      <th>FeatureE</th>\n",
       "      <th>SecretCode</th>\n",
       "      <th>...</th>\n",
       "      <th>Updated_Profile</th>\n",
       "      <th>blog_ID</th>\n",
       "      <th>Viewed_Discussion</th>\n",
       "      <th>Updated_Submission</th>\n",
       "      <th>badge_HYIO</th>\n",
       "      <th>count_UA</th>\n",
       "      <th>Day_duration</th>\n",
       "      <th>FeatureX</th>\n",
       "      <th>FeatureY</th>\n",
       "      <th>User_sign-in_day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_000H9XOP_Month_5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_003YJHQA_Month_4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_004UKSJV_Month_1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_004UKSJV_Month_12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_008D2J6C_Month_1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17357</th>\n",
       "      <td>ID_ZZMHNLNT_Month_4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17358</th>\n",
       "      <td>ID_ZZQK0LU6_Month_3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17359</th>\n",
       "      <td>ID_ZZUNZJ2U_Month_2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17360</th>\n",
       "      <td>ID_ZZVM2KO7_Month_4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17361</th>\n",
       "      <td>ID_ZZVUJ45W_Month_3</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17362 rows × 45 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    User_ID  Participant_Type  Successful_Submission_Count  \\\n",
       "0       ID_000H9XOP_Month_5               0.0                          0.0   \n",
       "1       ID_003YJHQA_Month_4               0.0                          0.0   \n",
       "2       ID_004UKSJV_Month_1               0.0                          0.0   \n",
       "3      ID_004UKSJV_Month_12               0.0                          0.0   \n",
       "4       ID_008D2J6C_Month_1               0.0                          0.0   \n",
       "...                     ...               ...                          ...   \n",
       "17357   ID_ZZMHNLNT_Month_4               0.0                          0.0   \n",
       "17358   ID_ZZQK0LU6_Month_3               1.0                          0.0   \n",
       "17359   ID_ZZUNZJ2U_Month_2               0.0                          0.0   \n",
       "17360   ID_ZZVM2KO7_Month_4               0.0                          0.0   \n",
       "17361   ID_ZZVUJ45W_Month_3               1.0                          0.0   \n",
       "\n",
       "       Comp_participation_day  FeatureA  FeatureB  FeatureC  FeatureD  \\\n",
       "0                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "1                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "2                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "3                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "4                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "...                       ...       ...       ...       ...       ...   \n",
       "17357                     0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "17358                    29.0       1.5       0.0      13.5       0.0   \n",
       "17359                     0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "17360                     0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "17361                     5.0       1.0       7.0       4.0       1.0   \n",
       "\n",
       "       FeatureE  SecretCode  ...  Updated_Profile  blog_ID  Viewed_Discussion  \\\n",
       "0          -1.0        -1.0  ...              0.0      0.0                0.0   \n",
       "1          -1.0        -1.0  ...              2.0      0.0                0.0   \n",
       "2          -1.0        -1.0  ...              0.0      0.0                0.0   \n",
       "3          -1.0        -1.0  ...              4.0      0.0                0.0   \n",
       "4          -1.0        -1.0  ...              2.0      0.0                0.0   \n",
       "...         ...         ...  ...              ...      ...                ...   \n",
       "17357      -1.0        -1.0  ...              0.0      0.0                0.0   \n",
       "17358       2.0         1.0  ...              0.0      0.0                0.0   \n",
       "17359      -1.0        -1.0  ...              0.0      0.0                0.0   \n",
       "17360      -1.0        -1.0  ...              0.0      0.0                0.0   \n",
       "17361       1.0         0.0  ...              0.0      0.0                0.0   \n",
       "\n",
       "       Updated_Submission  badge_HYIO  count_UA  Day_duration  FeatureX  \\\n",
       "0                     0.0         0.0       6.0           5.0       0.0   \n",
       "1                     0.0         0.0      11.0           1.0       0.0   \n",
       "2                     0.0         0.0       1.0           1.0      -1.0   \n",
       "3                     0.0         0.0      11.0           2.0       0.0   \n",
       "4                     0.0         0.0      10.0           9.0       0.0   \n",
       "...                   ...         ...       ...           ...       ...   \n",
       "17357                 0.0         0.0       8.0           1.0       0.0   \n",
       "17358                 0.0         0.0     134.0           2.0       0.0   \n",
       "17359                 0.0         0.0      12.0           1.0       0.0   \n",
       "17360                 0.0         0.0       0.0           0.0       0.0   \n",
       "17361                 0.0         0.0      52.0           1.0       0.0   \n",
       "\n",
       "       FeatureY  User_sign-in_day  \n",
       "0           1.0              22.0  \n",
       "1           1.0              12.0  \n",
       "2          -1.0               0.0  \n",
       "3           0.0              28.0  \n",
       "4           0.0               7.0  \n",
       "...         ...               ...  \n",
       "17357       0.0               1.0  \n",
       "17358       3.0              29.0  \n",
       "17359       0.0              30.0  \n",
       "17360       0.0              22.0  \n",
       "17361       0.0               5.0  \n",
       "\n",
       "[17362 rows x 45 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8b003d8e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 17362 entries, 0 to 17361\n",
      "Data columns (total 45 columns):\n",
      " #   Column                           Non-Null Count  Dtype  \n",
      "---  ------                           --------------  -----  \n",
      " 0   User_ID                          17362 non-null  string \n",
      " 1   Participant_Type                 17362 non-null  float64\n",
      " 2   Successful_Submission_Count      17362 non-null  float64\n",
      " 3   Comp_participation_day           17362 non-null  float64\n",
      " 4   FeatureA                         17362 non-null  float64\n",
      " 5   FeatureB                         17362 non-null  float64\n",
      " 6   FeatureC                         17362 non-null  float64\n",
      " 7   FeatureD                         17362 non-null  float64\n",
      " 8   FeatureE                         17362 non-null  float64\n",
      " 9   SecretCode                       17362 non-null  float64\n",
      " 10  FeatureF                         17362 non-null  float64\n",
      " 11  FeatureG                         17362 non-null  float64\n",
      " 12  FeatureH                         17362 non-null  float64\n",
      " 13  FeatureI                         17362 non-null  float64\n",
      " 14  Country_ID                       17362 non-null  float64\n",
      " 15  competition_ended_month          17362 non-null  float64\n",
      " 16  competition_started_month        17362 non-null  float64\n",
      " 17  Day_last_active                  17362 non-null  float64\n",
      " 18  Downloaded_Competition_Datafile  17362 non-null  float64\n",
      " 19  Viewed_All_Discussions           17362 non-null  float64\n",
      " 20  Confirmed_Email                  17362 non-null  float64\n",
      " 21  Joined_Competition               17362 non-null  float64\n",
      " 22  Signed_Up                        17362 non-null  float64\n",
      " 23  Viewed_All_Competitions          17362 non-null  float64\n",
      " 24  Viewed_All_Learning_Pages        17362 non-null  float64\n",
      " 25  badge_OCZE                       17362 non-null  float64\n",
      " 26  create_alias                     17362 non-null  float64\n",
      " 27  identify                         17362 non-null  float64\n",
      " 28  comp_ID                          17362 non-null  float64\n",
      " 29  Signed_In                        17362 non-null  float64\n",
      " 30  job_ID                           17362 non-null  float64\n",
      " 31  Updated_Discussion               17362 non-null  float64\n",
      " 32  Viewed_All_Jobs                  17362 non-null  float64\n",
      " 33  Created_Submission               17362 non-null  float64\n",
      " 34  Signed_Out                       17362 non-null  float64\n",
      " 35  Updated_Profile                  17362 non-null  float64\n",
      " 36  blog_ID                          17362 non-null  float64\n",
      " 37  Viewed_Discussion                17362 non-null  float64\n",
      " 38  Updated_Submission               17362 non-null  float64\n",
      " 39  badge_HYIO                       17362 non-null  float64\n",
      " 40  count_UA                         17362 non-null  float64\n",
      " 41  Day_duration                     17362 non-null  float64\n",
      " 42  FeatureX                         17362 non-null  float64\n",
      " 43  FeatureY                         17362 non-null  float64\n",
      " 44  User_sign-in_day                 17362 non-null  float64\n",
      "dtypes: float64(44), string(1)\n",
      "memory usage: 6.0 MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "746d0ed6",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5d8af1d3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         5\n",
       "1         4\n",
       "2         1\n",
       "3        12\n",
       "4         1\n",
       "         ..\n",
       "17357     4\n",
       "17358     3\n",
       "17359     2\n",
       "17360     4\n",
       "17361     3\n",
       "Name: User_ID, Length: 17362, dtype: string"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp[\"User_ID\"].str[18:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "3291f2e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp[\"Month\"] = temp[\"User_ID\"].str[18:]\n",
    "temp[\"Month\"] = pd.to_numeric(temp[\"Month\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "6cf3917b",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp[\"User_ID\"] = temp[\"User_ID\"].str[0:11]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5243de3c",
   "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>User_ID</th>\n",
       "      <th>Participant_Type</th>\n",
       "      <th>Successful_Submission_Count</th>\n",
       "      <th>Comp_participation_day</th>\n",
       "      <th>FeatureA</th>\n",
       "      <th>FeatureB</th>\n",
       "      <th>FeatureC</th>\n",
       "      <th>FeatureD</th>\n",
       "      <th>FeatureE</th>\n",
       "      <th>SecretCode</th>\n",
       "      <th>...</th>\n",
       "      <th>blog_ID</th>\n",
       "      <th>Viewed_Discussion</th>\n",
       "      <th>Updated_Submission</th>\n",
       "      <th>badge_HYIO</th>\n",
       "      <th>count_UA</th>\n",
       "      <th>Day_duration</th>\n",
       "      <th>FeatureX</th>\n",
       "      <th>FeatureY</th>\n",
       "      <th>User_sign-in_day</th>\n",
       "      <th>Month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_000H9XOP</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_003YJHQA</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_004UKSJV</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_004UKSJV</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_008D2J6C</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17357</th>\n",
       "      <td>ID_ZZMHNLNT</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17358</th>\n",
       "      <td>ID_ZZQK0LU6</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17359</th>\n",
       "      <td>ID_ZZUNZJ2U</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17360</th>\n",
       "      <td>ID_ZZVM2KO7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17361</th>\n",
       "      <td>ID_ZZVUJ45W</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17362 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           User_ID  Participant_Type  Successful_Submission_Count  \\\n",
       "0      ID_000H9XOP               0.0                          0.0   \n",
       "1      ID_003YJHQA               0.0                          0.0   \n",
       "2      ID_004UKSJV               0.0                          0.0   \n",
       "3      ID_004UKSJV               0.0                          0.0   \n",
       "4      ID_008D2J6C               0.0                          0.0   \n",
       "...            ...               ...                          ...   \n",
       "17357  ID_ZZMHNLNT               0.0                          0.0   \n",
       "17358  ID_ZZQK0LU6               1.0                          0.0   \n",
       "17359  ID_ZZUNZJ2U               0.0                          0.0   \n",
       "17360  ID_ZZVM2KO7               0.0                          0.0   \n",
       "17361  ID_ZZVUJ45W               1.0                          0.0   \n",
       "\n",
       "       Comp_participation_day  FeatureA  FeatureB  FeatureC  FeatureD  \\\n",
       "0                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "1                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "2                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "3                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "4                         0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "...                       ...       ...       ...       ...       ...   \n",
       "17357                     0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "17358                    29.0       1.5       0.0      13.5       0.0   \n",
       "17359                     0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "17360                     0.0      -1.0      -1.0      -1.0      -1.0   \n",
       "17361                     5.0       1.0       7.0       4.0       1.0   \n",
       "\n",
       "       FeatureE  SecretCode  ...  blog_ID  Viewed_Discussion  \\\n",
       "0          -1.0        -1.0  ...      0.0                0.0   \n",
       "1          -1.0        -1.0  ...      0.0                0.0   \n",
       "2          -1.0        -1.0  ...      0.0                0.0   \n",
       "3          -1.0        -1.0  ...      0.0                0.0   \n",
       "4          -1.0        -1.0  ...      0.0                0.0   \n",
       "...         ...         ...  ...      ...                ...   \n",
       "17357      -1.0        -1.0  ...      0.0                0.0   \n",
       "17358       2.0         1.0  ...      0.0                0.0   \n",
       "17359      -1.0        -1.0  ...      0.0                0.0   \n",
       "17360      -1.0        -1.0  ...      0.0                0.0   \n",
       "17361       1.0         0.0  ...      0.0                0.0   \n",
       "\n",
       "       Updated_Submission  badge_HYIO  count_UA  Day_duration  FeatureX  \\\n",
       "0                     0.0         0.0       6.0           5.0       0.0   \n",
       "1                     0.0         0.0      11.0           1.0       0.0   \n",
       "2                     0.0         0.0       1.0           1.0      -1.0   \n",
       "3                     0.0         0.0      11.0           2.0       0.0   \n",
       "4                     0.0         0.0      10.0           9.0       0.0   \n",
       "...                   ...         ...       ...           ...       ...   \n",
       "17357                 0.0         0.0       8.0           1.0       0.0   \n",
       "17358                 0.0         0.0     134.0           2.0       0.0   \n",
       "17359                 0.0         0.0      12.0           1.0       0.0   \n",
       "17360                 0.0         0.0       0.0           0.0       0.0   \n",
       "17361                 0.0         0.0      52.0           1.0       0.0   \n",
       "\n",
       "       FeatureY  User_sign-in_day  Month  \n",
       "0           1.0              22.0      5  \n",
       "1           1.0              12.0      4  \n",
       "2          -1.0               0.0      1  \n",
       "3           0.0              28.0     12  \n",
       "4           0.0               7.0      1  \n",
       "...         ...               ...    ...  \n",
       "17357       0.0               1.0      4  \n",
       "17358       3.0              29.0      3  \n",
       "17359       0.0              30.0      2  \n",
       "17360       0.0              22.0      4  \n",
       "17361       0.0               5.0      3  \n",
       "\n",
       "[17362 rows x 46 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "491bf1b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "months = np.array([1, 2, 3, 4, 5, 11, 12])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7cca5bc9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_month1 = temp[temp[\"Month\"]==1]\n",
    "df_month2 = temp[temp[\"Month\"]==2]\n",
    "df_month3 = temp[temp[\"Month\"]==3]\n",
    "df_month4 = temp[temp[\"Month\"]==4]\n",
    "df_month5 = temp[temp[\"Month\"]==5]\n",
    "df_month11 = temp[temp[\"Month\"]==11]\n",
    "df_month12 = temp[temp[\"Month\"]==12]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3ff632b6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 3771 entries, 2 to 17354\n",
      "Data columns (total 46 columns):\n",
      " #   Column                           Non-Null Count  Dtype  \n",
      "---  ------                           --------------  -----  \n",
      " 0   User_ID                          3771 non-null   string \n",
      " 1   Participant_Type                 3771 non-null   float64\n",
      " 2   Successful_Submission_Count      3771 non-null   float64\n",
      " 3   Comp_participation_day           3771 non-null   float64\n",
      " 4   FeatureA                         3771 non-null   float64\n",
      " 5   FeatureB                         3771 non-null   float64\n",
      " 6   FeatureC                         3771 non-null   float64\n",
      " 7   FeatureD                         3771 non-null   float64\n",
      " 8   FeatureE                         3771 non-null   float64\n",
      " 9   SecretCode                       3771 non-null   float64\n",
      " 10  FeatureF                         3771 non-null   float64\n",
      " 11  FeatureG                         3771 non-null   float64\n",
      " 12  FeatureH                         3771 non-null   float64\n",
      " 13  FeatureI                         3771 non-null   float64\n",
      " 14  Country_ID                       3771 non-null   float64\n",
      " 15  competition_ended_month          3771 non-null   float64\n",
      " 16  competition_started_month        3771 non-null   float64\n",
      " 17  Day_last_active                  3771 non-null   float64\n",
      " 18  Downloaded_Competition_Datafile  3771 non-null   float64\n",
      " 19  Viewed_All_Discussions           3771 non-null   float64\n",
      " 20  Confirmed_Email                  3771 non-null   float64\n",
      " 21  Joined_Competition               3771 non-null   float64\n",
      " 22  Signed_Up                        3771 non-null   float64\n",
      " 23  Viewed_All_Competitions          3771 non-null   float64\n",
      " 24  Viewed_All_Learning_Pages        3771 non-null   float64\n",
      " 25  badge_OCZE                       3771 non-null   float64\n",
      " 26  create_alias                     3771 non-null   float64\n",
      " 27  identify                         3771 non-null   float64\n",
      " 28  comp_ID                          3771 non-null   float64\n",
      " 29  Signed_In                        3771 non-null   float64\n",
      " 30  job_ID                           3771 non-null   float64\n",
      " 31  Updated_Discussion               3771 non-null   float64\n",
      " 32  Viewed_All_Jobs                  3771 non-null   float64\n",
      " 33  Created_Submission               3771 non-null   float64\n",
      " 34  Signed_Out                       3771 non-null   float64\n",
      " 35  Updated_Profile                  3771 non-null   float64\n",
      " 36  blog_ID                          3771 non-null   float64\n",
      " 37  Viewed_Discussion                3771 non-null   float64\n",
      " 38  Updated_Submission               3771 non-null   float64\n",
      " 39  badge_HYIO                       3771 non-null   float64\n",
      " 40  count_UA                         3771 non-null   float64\n",
      " 41  Day_duration                     3771 non-null   float64\n",
      " 42  FeatureX                         3771 non-null   float64\n",
      " 43  FeatureY                         3771 non-null   float64\n",
      " 44  User_sign-in_day                 3771 non-null   float64\n",
      " 45  Month                            3771 non-null   int64  \n",
      "dtypes: float64(44), int64(1), string(1)\n",
      "memory usage: 1.4 MB\n"
     ]
    }
   ],
   "source": [
    "df_month1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "15903f76",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_month1.drop(\"Month\", inplace=True, axis=1)\n",
    "df_month2.drop(\"Month\", inplace=True, axis=1)\n",
    "df_month3.drop(\"Month\", inplace=True, axis=1)\n",
    "df_month4.drop(\"Month\", inplace=True, axis=1)\n",
    "df_month5.drop(\"Month\", inplace=True, axis=1)\n",
    "df_month11.drop(\"Month\", inplace=True, axis=1)\n",
    "df_month12.drop(\"Month\", inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "7b8d770b",
   "metadata": {},
   "outputs": [],
   "source": [
    "names1 = df_month1.columns\n",
    "names1 = names1.astype(\"string\")\n",
    "names1 = names1 + \"1\"\n",
    "df_month1.columns = names1\n",
    "\n",
    "names2 = df_month2.columns\n",
    "names2 = names2.astype(\"string\")\n",
    "names2 = names2 + \"2\"\n",
    "df_month2.columns = names2\n",
    "\n",
    "names3 = df_month3.columns\n",
    "names3 = names3.astype(\"string\")\n",
    "names3 = names3 + \"3\"\n",
    "df_month3.columns = names3\n",
    "\n",
    "names4 = df_month4.columns\n",
    "names4 = names4.astype(\"string\")\n",
    "names4 = names4 + \"4\"\n",
    "df_month4.columns = names4\n",
    "\n",
    "names5 = df_month5.columns\n",
    "names5 = names5.astype(\"string\")\n",
    "names5 = names5 + \"5\"\n",
    "df_month5.columns = names5\n",
    "\n",
    "names11 = df_month11.columns\n",
    "names11 = names11.astype(\"string\")\n",
    "names11 = names11 + \"11\"\n",
    "df_month11.columns = names11\n",
    "\n",
    "names12 = df_month12.columns\n",
    "names12 = names12.astype(\"string\")\n",
    "names12 = names12 + \"12\"\n",
    "df_month12.columns = names12"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "0488297c",
   "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>User_ID12</th>\n",
       "      <th>Participant_Type12</th>\n",
       "      <th>Successful_Submission_Count12</th>\n",
       "      <th>Comp_participation_day12</th>\n",
       "      <th>FeatureA12</th>\n",
       "      <th>FeatureB12</th>\n",
       "      <th>FeatureC12</th>\n",
       "      <th>FeatureD12</th>\n",
       "      <th>FeatureE12</th>\n",
       "      <th>SecretCode12</th>\n",
       "      <th>...</th>\n",
       "      <th>Updated_Profile12</th>\n",
       "      <th>blog_ID12</th>\n",
       "      <th>Viewed_Discussion12</th>\n",
       "      <th>Updated_Submission12</th>\n",
       "      <th>badge_HYIO12</th>\n",
       "      <th>count_UA12</th>\n",
       "      <th>Day_duration12</th>\n",
       "      <th>FeatureX12</th>\n",
       "      <th>FeatureY12</th>\n",
       "      <th>User_sign-in_day12</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_004UKSJV</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ID_00RKDLAX</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>ID_00XHYSFF</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ID_015M2NE1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ID_0190Y8K7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17303</th>\n",
       "      <td>ID_ZV8F7M7F</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17322</th>\n",
       "      <td>ID_ZWPDZMDT</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17323</th>\n",
       "      <td>ID_ZWQZQHGR</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17349</th>\n",
       "      <td>ID_ZZ852GLE</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17355</th>\n",
       "      <td>ID_ZZJKFBR5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2233 rows × 45 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         User_ID12  Participant_Type12  Successful_Submission_Count12  \\\n",
       "3      ID_004UKSJV                 0.0                            0.0   \n",
       "7      ID_00RKDLAX                 0.0                            0.0   \n",
       "9      ID_00XHYSFF                 0.0                            0.0   \n",
       "13     ID_015M2NE1                 1.0                            0.0   \n",
       "15     ID_0190Y8K7                 0.0                            0.0   \n",
       "...            ...                 ...                            ...   \n",
       "17303  ID_ZV8F7M7F                 0.0                            0.0   \n",
       "17322  ID_ZWPDZMDT                 1.0                            0.0   \n",
       "17323  ID_ZWQZQHGR                 0.0                            0.0   \n",
       "17349  ID_ZZ852GLE                 1.0                            0.0   \n",
       "17355  ID_ZZJKFBR5                 1.0                            0.0   \n",
       "\n",
       "       Comp_participation_day12  FeatureA12  FeatureB12  FeatureC12  \\\n",
       "3                           0.0        -1.0        -1.0        -1.0   \n",
       "7                           0.0        -1.0        -1.0        -1.0   \n",
       "9                           0.0        -1.0        -1.0        -1.0   \n",
       "13                         27.0         1.0         9.0         2.0   \n",
       "15                          0.0        -1.0        -1.0        -1.0   \n",
       "...                         ...         ...         ...         ...   \n",
       "17303                       0.0        -1.0        -1.0        -1.0   \n",
       "17322                       2.0         2.5         0.0         6.0   \n",
       "17323                       0.0        -1.0        -1.0        -1.0   \n",
       "17349                       6.0         1.0         1.0        13.0   \n",
       "17355                       8.0         1.0         1.0        13.0   \n",
       "\n",
       "       FeatureD12  FeatureE12  SecretCode12  ...  Updated_Profile12  \\\n",
       "3            -1.0        -1.0          -1.0  ...                4.0   \n",
       "7            -1.0        -1.0          -1.0  ...                2.0   \n",
       "9            -1.0        -1.0          -1.0  ...                1.0   \n",
       "13            1.0         1.0           0.0  ...                0.0   \n",
       "15           -1.0        -1.0          -1.0  ...                3.0   \n",
       "...           ...         ...           ...  ...                ...   \n",
       "17303        -1.0        -1.0          -1.0  ...                0.0   \n",
       "17322         1.0         2.0           0.0  ...                0.0   \n",
       "17323        -1.0        -1.0          -1.0  ...                0.0   \n",
       "17349         1.0         2.0           0.0  ...                0.0   \n",
       "17355         1.0         2.0           0.0  ...                0.0   \n",
       "\n",
       "       blog_ID12  Viewed_Discussion12  Updated_Submission12  badge_HYIO12  \\\n",
       "3            0.0                  0.0                   0.0           0.0   \n",
       "7            0.0                  0.0                   0.0           0.0   \n",
       "9            0.0                  0.0                   0.0           0.0   \n",
       "13           0.0                  0.0                   0.0           0.0   \n",
       "15           0.0                  0.0                   0.0           0.0   \n",
       "...          ...                  ...                   ...           ...   \n",
       "17303        0.0                  0.0                   0.0           0.0   \n",
       "17322        0.0                  0.0                   0.0           0.0   \n",
       "17323        0.0                  0.0                   0.0           0.0   \n",
       "17349        0.0                  0.0                   0.0           0.0   \n",
       "17355        0.0                  0.0                   0.0           0.0   \n",
       "\n",
       "       count_UA12  Day_duration12  FeatureX12  FeatureY12  User_sign-in_day12  \n",
       "3            11.0             2.0         0.0         0.0                28.0  \n",
       "7             9.0             1.0         0.0         1.0                23.0  \n",
       "9             7.0             1.0         0.0         0.0                24.0  \n",
       "13           39.0             1.0         0.0         1.0                27.0  \n",
       "15           10.0             1.0         0.0         0.0                13.0  \n",
       "...           ...             ...         ...         ...                 ...  \n",
       "17303         7.0             2.0         0.0         0.0                30.0  \n",
       "17322        10.0             1.0         0.0         0.0                 2.0  \n",
       "17323         0.0             0.0         0.0         0.0                 9.0  \n",
       "17349        57.0             5.0         0.0         0.0                 6.0  \n",
       "17355        43.0             4.0         0.0         1.0                 8.0  \n",
       "\n",
       "[2233 rows x 45 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_month12"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "18fca28a",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_month1 = df_month1.rename(columns={\"User_ID1\":\"User_ID\"})\n",
    "df_month2 = df_month2.rename(columns={\"User_ID2\":\"User_ID\"})\n",
    "df_month3 = df_month3.rename(columns={\"User_ID3\":\"User_ID\"})\n",
    "df_month4 = df_month4.rename(columns={\"User_ID4\":\"User_ID\"})\n",
    "df_month5 = df_month5.rename(columns={\"User_ID5\":\"User_ID\"})\n",
    "df_month11 = df_month11.rename(columns={\"User_ID11\":\"User_ID\"})\n",
    "df_month12 = df_month12.rename(columns={\"User_ID12\":\"User_ID\"})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "9127c17d",
   "metadata": {},
   "outputs": [],
   "source": [
    "result1 = pd.merge(df_month1, df_month2, how=\"outer\", on=\"User_ID\", )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "b6a12616",
   "metadata": {},
   "outputs": [],
   "source": [
    "result1 = result1.drop_duplicates(subset=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1c04c486",
   "metadata": {},
   "outputs": [],
   "source": [
    "result2 = pd.merge(result1, df_month3, how=\"outer\", on=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "a1a3fded",
   "metadata": {},
   "outputs": [],
   "source": [
    "result2 = result2.drop_duplicates(subset=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "e06c84ac",
   "metadata": {},
   "outputs": [],
   "source": [
    "result3 = pd.merge(result2, df_month4, how=\"outer\", on=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "fa4b35e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "result3 = result3.drop_duplicates(subset=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "21fffaed",
   "metadata": {},
   "outputs": [],
   "source": [
    "result4 = pd.merge(result3, df_month5, how=\"outer\", on=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "4415faa4",
   "metadata": {},
   "outputs": [],
   "source": [
    "result4 = result4.drop_duplicates(subset=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "0eddeed1",
   "metadata": {},
   "outputs": [],
   "source": [
    "result5 = pd.merge(result4, df_month11, how=\"outer\", on=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "398dfd7c",
   "metadata": {},
   "outputs": [],
   "source": [
    "result5 = result5.drop_duplicates(subset=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "80f52319",
   "metadata": {},
   "outputs": [],
   "source": [
    "result = pd.merge(result5, df_month12, how=\"outer\", on=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "d3d485d6",
   "metadata": {},
   "outputs": [],
   "source": [
    "result = result.drop_duplicates(subset=\"User_ID\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "69fb4aac",
   "metadata": {},
   "outputs": [],
   "source": [
    "result = result.sort_values(\"User_ID\").reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "aa0c7184",
   "metadata": {},
   "outputs": [],
   "source": [
    "result.drop(\"index\", inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "1d881ad9",
   "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>User_ID</th>\n",
       "      <th>Participant_Type1</th>\n",
       "      <th>Successful_Submission_Count1</th>\n",
       "      <th>Comp_participation_day1</th>\n",
       "      <th>FeatureA1</th>\n",
       "      <th>FeatureB1</th>\n",
       "      <th>FeatureC1</th>\n",
       "      <th>FeatureD1</th>\n",
       "      <th>FeatureE1</th>\n",
       "      <th>SecretCode1</th>\n",
       "      <th>...</th>\n",
       "      <th>Updated_Profile12</th>\n",
       "      <th>blog_ID12</th>\n",
       "      <th>Viewed_Discussion12</th>\n",
       "      <th>Updated_Submission12</th>\n",
       "      <th>badge_HYIO12</th>\n",
       "      <th>count_UA12</th>\n",
       "      <th>Day_duration12</th>\n",
       "      <th>FeatureX12</th>\n",
       "      <th>FeatureY12</th>\n",
       "      <th>User_sign-in_day12</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_000H9XOP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_003YJHQA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_004UKSJV</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_008D2J6C</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_00ETFE7J</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12408</th>\n",
       "      <td>ID_ZZMHNLNT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12409</th>\n",
       "      <td>ID_ZZQK0LU6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12410</th>\n",
       "      <td>ID_ZZUNZJ2U</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12411</th>\n",
       "      <td>ID_ZZVM2KO7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12412</th>\n",
       "      <td>ID_ZZVUJ45W</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12413 rows × 309 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           User_ID  Participant_Type1  Successful_Submission_Count1  \\\n",
       "0      ID_000H9XOP                NaN                           NaN   \n",
       "1      ID_003YJHQA                NaN                           NaN   \n",
       "2      ID_004UKSJV                0.0                           0.0   \n",
       "3      ID_008D2J6C                0.0                           0.0   \n",
       "4      ID_00ETFE7J                0.0                           0.0   \n",
       "...            ...                ...                           ...   \n",
       "12408  ID_ZZMHNLNT                NaN                           NaN   \n",
       "12409  ID_ZZQK0LU6                NaN                           NaN   \n",
       "12410  ID_ZZUNZJ2U                NaN                           NaN   \n",
       "12411  ID_ZZVM2KO7                NaN                           NaN   \n",
       "12412  ID_ZZVUJ45W                NaN                           NaN   \n",
       "\n",
       "       Comp_participation_day1  FeatureA1  FeatureB1  FeatureC1  FeatureD1  \\\n",
       "0                          NaN        NaN        NaN        NaN        NaN   \n",
       "1                          NaN        NaN        NaN        NaN        NaN   \n",
       "2                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "3                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "4                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "...                        ...        ...        ...        ...        ...   \n",
       "12408                      NaN        NaN        NaN        NaN        NaN   \n",
       "12409                      NaN        NaN        NaN        NaN        NaN   \n",
       "12410                      NaN        NaN        NaN        NaN        NaN   \n",
       "12411                      NaN        NaN        NaN        NaN        NaN   \n",
       "12412                      NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       FeatureE1  SecretCode1  ...  Updated_Profile12  blog_ID12  \\\n",
       "0            NaN          NaN  ...                NaN        NaN   \n",
       "1            NaN          NaN  ...                NaN        NaN   \n",
       "2           -1.0         -1.0  ...                4.0        0.0   \n",
       "3           -1.0         -1.0  ...                NaN        NaN   \n",
       "4           -1.0         -1.0  ...                NaN        NaN   \n",
       "...          ...          ...  ...                ...        ...   \n",
       "12408        NaN          NaN  ...                NaN        NaN   \n",
       "12409        NaN          NaN  ...                NaN        NaN   \n",
       "12410        NaN          NaN  ...                NaN        NaN   \n",
       "12411        NaN          NaN  ...                NaN        NaN   \n",
       "12412        NaN          NaN  ...                NaN        NaN   \n",
       "\n",
       "       Viewed_Discussion12  Updated_Submission12  badge_HYIO12  count_UA12  \\\n",
       "0                      NaN                   NaN           NaN         NaN   \n",
       "1                      NaN                   NaN           NaN         NaN   \n",
       "2                      0.0                   0.0           0.0        11.0   \n",
       "3                      NaN                   NaN           NaN         NaN   \n",
       "4                      NaN                   NaN           NaN         NaN   \n",
       "...                    ...                   ...           ...         ...   \n",
       "12408                  NaN                   NaN           NaN         NaN   \n",
       "12409                  NaN                   NaN           NaN         NaN   \n",
       "12410                  NaN                   NaN           NaN         NaN   \n",
       "12411                  NaN                   NaN           NaN         NaN   \n",
       "12412                  NaN                   NaN           NaN         NaN   \n",
       "\n",
       "       Day_duration12  FeatureX12  FeatureY12  User_sign-in_day12  \n",
       "0                 NaN         NaN         NaN                 NaN  \n",
       "1                 NaN         NaN         NaN                 NaN  \n",
       "2                 2.0         0.0         0.0                28.0  \n",
       "3                 NaN         NaN         NaN                 NaN  \n",
       "4                 NaN         NaN         NaN                 NaN  \n",
       "...               ...         ...         ...                 ...  \n",
       "12408             NaN         NaN         NaN                 NaN  \n",
       "12409             NaN         NaN         NaN                 NaN  \n",
       "12410             NaN         NaN         NaN                 NaN  \n",
       "12411             NaN         NaN         NaN                 NaN  \n",
       "12412             NaN         NaN         NaN                 NaN  \n",
       "\n",
       "[12413 rows x 309 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "ac79bdf7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<StringArray>\n",
       "['ID_000H9XOP', 'ID_003YJHQA', 'ID_004UKSJV', 'ID_008D2J6C', 'ID_00ETFE7J',\n",
       " 'ID_00RKDLAX', 'ID_00SL0NNP', 'ID_00XHYSFF', 'ID_011YM9VH', 'ID_015M2NE1',\n",
       " ...\n",
       " 'ID_ZZ852GLE', 'ID_ZZCQMX2B', 'ID_ZZFZI3DK', 'ID_ZZHDXC1Q', 'ID_ZZJKFBR5',\n",
       " 'ID_ZZMHNLNT', 'ID_ZZQK0LU6', 'ID_ZZUNZJ2U', 'ID_ZZVM2KO7', 'ID_ZZVUJ45W']\n",
       "Length: 12413, dtype: string"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result[\"User_ID\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "8e2339dd",
   "metadata": {},
   "outputs": [],
   "source": [
    "result.count_UA1.fillna(0, inplace=True)\n",
    "result.count_UA2.fillna(0, inplace=True)\n",
    "result.count_UA3.fillna(0, inplace=True)\n",
    "result.count_UA4.fillna(0, inplace=True)\n",
    "result.count_UA5.fillna(0, inplace=True)\n",
    "result.count_UA11.fillna(0, inplace=True)\n",
    "result.count_UA12.fillna(0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "1abb1d09",
   "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>User_ID</th>\n",
       "      <th>Participant_Type1</th>\n",
       "      <th>Successful_Submission_Count1</th>\n",
       "      <th>Comp_participation_day1</th>\n",
       "      <th>FeatureA1</th>\n",
       "      <th>FeatureB1</th>\n",
       "      <th>FeatureC1</th>\n",
       "      <th>FeatureD1</th>\n",
       "      <th>FeatureE1</th>\n",
       "      <th>SecretCode1</th>\n",
       "      <th>...</th>\n",
       "      <th>Updated_Profile12</th>\n",
       "      <th>blog_ID12</th>\n",
       "      <th>Viewed_Discussion12</th>\n",
       "      <th>Updated_Submission12</th>\n",
       "      <th>badge_HYIO12</th>\n",
       "      <th>count_UA12</th>\n",
       "      <th>Day_duration12</th>\n",
       "      <th>FeatureX12</th>\n",
       "      <th>FeatureY12</th>\n",
       "      <th>User_sign-in_day12</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_000H9XOP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_003YJHQA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_004UKSJV</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_008D2J6C</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_00ETFE7J</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12408</th>\n",
       "      <td>ID_ZZMHNLNT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12409</th>\n",
       "      <td>ID_ZZQK0LU6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12410</th>\n",
       "      <td>ID_ZZUNZJ2U</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12411</th>\n",
       "      <td>ID_ZZVM2KO7</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12412</th>\n",
       "      <td>ID_ZZVUJ45W</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12413 rows × 309 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           User_ID  Participant_Type1  Successful_Submission_Count1  \\\n",
       "0      ID_000H9XOP                NaN                           NaN   \n",
       "1      ID_003YJHQA                NaN                           NaN   \n",
       "2      ID_004UKSJV                0.0                           0.0   \n",
       "3      ID_008D2J6C                0.0                           0.0   \n",
       "4      ID_00ETFE7J                0.0                           0.0   \n",
       "...            ...                ...                           ...   \n",
       "12408  ID_ZZMHNLNT                NaN                           NaN   \n",
       "12409  ID_ZZQK0LU6                NaN                           NaN   \n",
       "12410  ID_ZZUNZJ2U                NaN                           NaN   \n",
       "12411  ID_ZZVM2KO7                NaN                           NaN   \n",
       "12412  ID_ZZVUJ45W                NaN                           NaN   \n",
       "\n",
       "       Comp_participation_day1  FeatureA1  FeatureB1  FeatureC1  FeatureD1  \\\n",
       "0                          NaN        NaN        NaN        NaN        NaN   \n",
       "1                          NaN        NaN        NaN        NaN        NaN   \n",
       "2                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "3                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "4                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "...                        ...        ...        ...        ...        ...   \n",
       "12408                      NaN        NaN        NaN        NaN        NaN   \n",
       "12409                      NaN        NaN        NaN        NaN        NaN   \n",
       "12410                      NaN        NaN        NaN        NaN        NaN   \n",
       "12411                      NaN        NaN        NaN        NaN        NaN   \n",
       "12412                      NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "       FeatureE1  SecretCode1  ...  Updated_Profile12  blog_ID12  \\\n",
       "0            NaN          NaN  ...                NaN        NaN   \n",
       "1            NaN          NaN  ...                NaN        NaN   \n",
       "2           -1.0         -1.0  ...                4.0        0.0   \n",
       "3           -1.0         -1.0  ...                NaN        NaN   \n",
       "4           -1.0         -1.0  ...                NaN        NaN   \n",
       "...          ...          ...  ...                ...        ...   \n",
       "12408        NaN          NaN  ...                NaN        NaN   \n",
       "12409        NaN          NaN  ...                NaN        NaN   \n",
       "12410        NaN          NaN  ...                NaN        NaN   \n",
       "12411        NaN          NaN  ...                NaN        NaN   \n",
       "12412        NaN          NaN  ...                NaN        NaN   \n",
       "\n",
       "       Viewed_Discussion12  Updated_Submission12  badge_HYIO12  count_UA12  \\\n",
       "0                      NaN                   NaN           NaN         0.0   \n",
       "1                      NaN                   NaN           NaN         0.0   \n",
       "2                      0.0                   0.0           0.0        11.0   \n",
       "3                      NaN                   NaN           NaN         0.0   \n",
       "4                      NaN                   NaN           NaN         0.0   \n",
       "...                    ...                   ...           ...         ...   \n",
       "12408                  NaN                   NaN           NaN         0.0   \n",
       "12409                  NaN                   NaN           NaN         0.0   \n",
       "12410                  NaN                   NaN           NaN         0.0   \n",
       "12411                  NaN                   NaN           NaN         0.0   \n",
       "12412                  NaN                   NaN           NaN         0.0   \n",
       "\n",
       "       Day_duration12  FeatureX12  FeatureY12  User_sign-in_day12  \n",
       "0                 NaN         NaN         NaN                 NaN  \n",
       "1                 NaN         NaN         NaN                 NaN  \n",
       "2                 2.0         0.0         0.0                28.0  \n",
       "3                 NaN         NaN         NaN                 NaN  \n",
       "4                 NaN         NaN         NaN                 NaN  \n",
       "...               ...         ...         ...                 ...  \n",
       "12408             NaN         NaN         NaN                 NaN  \n",
       "12409             NaN         NaN         NaN                 NaN  \n",
       "12410             NaN         NaN         NaN                 NaN  \n",
       "12411             NaN         NaN         NaN                 NaN  \n",
       "12412             NaN         NaN         NaN                 NaN  \n",
       "\n",
       "[12413 rows x 309 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "ba2d1cd6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Participant_Type1',\n",
       " 'Successful_Submission_Count1',\n",
       " 'Comp_participation_day1',\n",
       " 'FeatureA1',\n",
       " 'FeatureB1',\n",
       " 'FeatureC1',\n",
       " 'FeatureD1',\n",
       " 'FeatureE1',\n",
       " 'SecretCode1',\n",
       " 'FeatureF1',\n",
       " 'FeatureG1',\n",
       " 'FeatureH1',\n",
       " 'FeatureI1',\n",
       " 'Country_ID1',\n",
       " 'competition_ended_month1',\n",
       " 'competition_started_month1',\n",
       " 'Day_last_active1',\n",
       " 'Downloaded_Competition_Datafile1',\n",
       " 'Viewed_All_Discussions1',\n",
       " 'Confirmed_Email1',\n",
       " 'Joined_Competition1',\n",
       " 'Signed_Up1',\n",
       " 'Viewed_All_Competitions1',\n",
       " 'Viewed_All_Learning_Pages1',\n",
       " 'badge_OCZE1',\n",
       " 'create_alias1',\n",
       " 'identify1',\n",
       " 'comp_ID1',\n",
       " 'Signed_In1',\n",
       " 'job_ID1',\n",
       " 'Updated_Discussion1',\n",
       " 'Viewed_All_Jobs1',\n",
       " 'Created_Submission1',\n",
       " 'Signed_Out1',\n",
       " 'Updated_Profile1',\n",
       " 'blog_ID1',\n",
       " 'Viewed_Discussion1',\n",
       " 'Updated_Submission1',\n",
       " 'badge_HYIO1',\n",
       " 'Day_duration1',\n",
       " 'FeatureX1',\n",
       " 'FeatureY1',\n",
       " 'User_sign-in_day1',\n",
       " 'Participant_Type2',\n",
       " 'Successful_Submission_Count2',\n",
       " 'Comp_participation_day2',\n",
       " 'FeatureA2',\n",
       " 'FeatureB2',\n",
       " 'FeatureC2',\n",
       " 'FeatureD2',\n",
       " 'FeatureE2',\n",
       " 'SecretCode2',\n",
       " 'FeatureF2',\n",
       " 'FeatureG2',\n",
       " 'FeatureH2',\n",
       " 'FeatureI2',\n",
       " 'Country_ID2',\n",
       " 'competition_ended_month2',\n",
       " 'competition_started_month2',\n",
       " 'Day_last_active2',\n",
       " 'Downloaded_Competition_Datafile2',\n",
       " 'Viewed_All_Discussions2',\n",
       " 'Confirmed_Email2',\n",
       " 'Joined_Competition2',\n",
       " 'Signed_Up2',\n",
       " 'Viewed_All_Competitions2',\n",
       " 'Viewed_All_Learning_Pages2',\n",
       " 'badge_OCZE2',\n",
       " 'create_alias2',\n",
       " 'identify2',\n",
       " 'comp_ID2',\n",
       " 'Signed_In2',\n",
       " 'job_ID2',\n",
       " 'Updated_Discussion2',\n",
       " 'Viewed_All_Jobs2',\n",
       " 'Created_Submission2',\n",
       " 'Signed_Out2',\n",
       " 'Updated_Profile2',\n",
       " 'blog_ID2',\n",
       " 'Viewed_Discussion2',\n",
       " 'Updated_Submission2',\n",
       " 'badge_HYIO2',\n",
       " 'Day_duration2',\n",
       " 'FeatureX2',\n",
       " 'FeatureY2',\n",
       " 'User_sign-in_day2',\n",
       " 'Participant_Type3',\n",
       " 'Successful_Submission_Count3',\n",
       " 'Comp_participation_day3',\n",
       " 'FeatureA3',\n",
       " 'FeatureB3',\n",
       " 'FeatureC3',\n",
       " 'FeatureD3',\n",
       " 'FeatureE3',\n",
       " 'SecretCode3',\n",
       " 'FeatureF3',\n",
       " 'FeatureG3',\n",
       " 'FeatureH3',\n",
       " 'FeatureI3',\n",
       " 'Country_ID3',\n",
       " 'competition_ended_month3',\n",
       " 'competition_started_month3',\n",
       " 'Day_last_active3',\n",
       " 'Downloaded_Competition_Datafile3',\n",
       " 'Viewed_All_Discussions3',\n",
       " 'Confirmed_Email3',\n",
       " 'Joined_Competition3',\n",
       " 'Signed_Up3',\n",
       " 'Viewed_All_Competitions3',\n",
       " 'Viewed_All_Learning_Pages3',\n",
       " 'badge_OCZE3',\n",
       " 'create_alias3',\n",
       " 'identify3',\n",
       " 'comp_ID3',\n",
       " 'Signed_In3',\n",
       " 'job_ID3',\n",
       " 'Updated_Discussion3',\n",
       " 'Viewed_All_Jobs3',\n",
       " 'Created_Submission3',\n",
       " 'Signed_Out3',\n",
       " 'Updated_Profile3',\n",
       " 'blog_ID3',\n",
       " 'Viewed_Discussion3',\n",
       " 'Updated_Submission3',\n",
       " 'badge_HYIO3',\n",
       " 'Day_duration3',\n",
       " 'FeatureX3',\n",
       " 'FeatureY3',\n",
       " 'User_sign-in_day3',\n",
       " 'Participant_Type4',\n",
       " 'Successful_Submission_Count4',\n",
       " 'Comp_participation_day4',\n",
       " 'FeatureA4',\n",
       " 'FeatureB4',\n",
       " 'FeatureC4',\n",
       " 'FeatureD4',\n",
       " 'FeatureE4',\n",
       " 'SecretCode4',\n",
       " 'FeatureF4',\n",
       " 'FeatureG4',\n",
       " 'FeatureH4',\n",
       " 'FeatureI4',\n",
       " 'Country_ID4',\n",
       " 'competition_ended_month4',\n",
       " 'competition_started_month4',\n",
       " 'Day_last_active4',\n",
       " 'Downloaded_Competition_Datafile4',\n",
       " 'Viewed_All_Discussions4',\n",
       " 'Confirmed_Email4',\n",
       " 'Joined_Competition4',\n",
       " 'Signed_Up4',\n",
       " 'Viewed_All_Competitions4',\n",
       " 'Viewed_All_Learning_Pages4',\n",
       " 'badge_OCZE4',\n",
       " 'create_alias4',\n",
       " 'identify4',\n",
       " 'comp_ID4',\n",
       " 'Signed_In4',\n",
       " 'job_ID4',\n",
       " 'Updated_Discussion4',\n",
       " 'Viewed_All_Jobs4',\n",
       " 'Created_Submission4',\n",
       " 'Signed_Out4',\n",
       " 'Updated_Profile4',\n",
       " 'blog_ID4',\n",
       " 'Viewed_Discussion4',\n",
       " 'Updated_Submission4',\n",
       " 'badge_HYIO4',\n",
       " 'Day_duration4',\n",
       " 'FeatureX4',\n",
       " 'FeatureY4',\n",
       " 'User_sign-in_day4',\n",
       " 'Participant_Type5',\n",
       " 'Successful_Submission_Count5',\n",
       " 'Comp_participation_day5',\n",
       " 'FeatureA5',\n",
       " 'FeatureB5',\n",
       " 'FeatureC5',\n",
       " 'FeatureD5',\n",
       " 'FeatureE5',\n",
       " 'SecretCode5',\n",
       " 'FeatureF5',\n",
       " 'FeatureG5',\n",
       " 'FeatureH5',\n",
       " 'FeatureI5',\n",
       " 'Country_ID5',\n",
       " 'competition_ended_month5',\n",
       " 'competition_started_month5',\n",
       " 'Day_last_active5',\n",
       " 'Downloaded_Competition_Datafile5',\n",
       " 'Viewed_All_Discussions5',\n",
       " 'Confirmed_Email5',\n",
       " 'Joined_Competition5',\n",
       " 'Signed_Up5',\n",
       " 'Viewed_All_Competitions5',\n",
       " 'Viewed_All_Learning_Pages5',\n",
       " 'badge_OCZE5',\n",
       " 'create_alias5',\n",
       " 'identify5',\n",
       " 'comp_ID5',\n",
       " 'Signed_In5',\n",
       " 'job_ID5',\n",
       " 'Updated_Discussion5',\n",
       " 'Viewed_All_Jobs5',\n",
       " 'Created_Submission5',\n",
       " 'Signed_Out5',\n",
       " 'Updated_Profile5',\n",
       " 'blog_ID5',\n",
       " 'Viewed_Discussion5',\n",
       " 'Updated_Submission5',\n",
       " 'badge_HYIO5',\n",
       " 'Day_duration5',\n",
       " 'FeatureX5',\n",
       " 'FeatureY5',\n",
       " 'User_sign-in_day5',\n",
       " 'Participant_Type11',\n",
       " 'Successful_Submission_Count11',\n",
       " 'Comp_participation_day11',\n",
       " 'FeatureA11',\n",
       " 'FeatureB11',\n",
       " 'FeatureC11',\n",
       " 'FeatureD11',\n",
       " 'FeatureE11',\n",
       " 'SecretCode11',\n",
       " 'FeatureF11',\n",
       " 'FeatureG11',\n",
       " 'FeatureH11',\n",
       " 'FeatureI11',\n",
       " 'Country_ID11',\n",
       " 'competition_ended_month11',\n",
       " 'competition_started_month11',\n",
       " 'Day_last_active11',\n",
       " 'Downloaded_Competition_Datafile11',\n",
       " 'Viewed_All_Discussions11',\n",
       " 'Confirmed_Email11',\n",
       " 'Joined_Competition11',\n",
       " 'Signed_Up11',\n",
       " 'Viewed_All_Competitions11',\n",
       " 'Viewed_All_Learning_Pages11',\n",
       " 'badge_OCZE11',\n",
       " 'create_alias11',\n",
       " 'identify11',\n",
       " 'comp_ID11',\n",
       " 'Signed_In11',\n",
       " 'job_ID11',\n",
       " 'Updated_Discussion11',\n",
       " 'Viewed_All_Jobs11',\n",
       " 'Created_Submission11',\n",
       " 'Signed_Out11',\n",
       " 'Updated_Profile11',\n",
       " 'blog_ID11',\n",
       " 'Viewed_Discussion11',\n",
       " 'Updated_Submission11',\n",
       " 'badge_HYIO11',\n",
       " 'Day_duration11',\n",
       " 'FeatureX11',\n",
       " 'FeatureY11',\n",
       " 'User_sign-in_day11',\n",
       " 'Participant_Type12',\n",
       " 'Successful_Submission_Count12',\n",
       " 'Comp_participation_day12',\n",
       " 'FeatureA12',\n",
       " 'FeatureB12',\n",
       " 'FeatureC12',\n",
       " 'FeatureD12',\n",
       " 'FeatureE12',\n",
       " 'SecretCode12',\n",
       " 'FeatureF12',\n",
       " 'FeatureG12',\n",
       " 'FeatureH12',\n",
       " 'FeatureI12',\n",
       " 'Country_ID12',\n",
       " 'competition_ended_month12',\n",
       " 'competition_started_month12',\n",
       " 'Day_last_active12',\n",
       " 'Downloaded_Competition_Datafile12',\n",
       " 'Viewed_All_Discussions12',\n",
       " 'Confirmed_Email12',\n",
       " 'Joined_Competition12',\n",
       " 'Signed_Up12',\n",
       " 'Viewed_All_Competitions12',\n",
       " 'Viewed_All_Learning_Pages12',\n",
       " 'badge_OCZE12',\n",
       " 'create_alias12',\n",
       " 'identify12',\n",
       " 'comp_ID12',\n",
       " 'Signed_In12',\n",
       " 'job_ID12',\n",
       " 'Updated_Discussion12',\n",
       " 'Viewed_All_Jobs12',\n",
       " 'Created_Submission12',\n",
       " 'Signed_Out12',\n",
       " 'Updated_Profile12',\n",
       " 'blog_ID12',\n",
       " 'Viewed_Discussion12',\n",
       " 'Updated_Submission12',\n",
       " 'badge_HYIO12',\n",
       " 'Day_duration12',\n",
       " 'FeatureX12',\n",
       " 'FeatureY12',\n",
       " 'User_sign-in_day12']"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result.columns[result.isna().any()].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "29a868de",
   "metadata": {},
   "outputs": [],
   "source": [
    "result.fillna(-1, inplace=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3a9c07bb",
   "metadata": {},
   "source": [
    "## Train and Test Split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "2a6efc35",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sample = pd.read_csv(\"SampleSubmission.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "7fbcbe07",
   "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>User_ID_Next_month_Activity</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_4TOXNBGB_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_CHFTIP26_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_FU5GMWLQ_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_254TVBQP_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_4ENO2VFE_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1335</th>\n",
       "      <td>ID_PI8N2KJX_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>ID_L9AHTUD7_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337</th>\n",
       "      <td>ID_BB7GLV87_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1338</th>\n",
       "      <td>ID_WB6O1NFS_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1339</th>\n",
       "      <td>ID_99LD9C1B_Month_5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1340 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     User_ID_Next_month_Activity  Active\n",
       "0            ID_4TOXNBGB_Month_5       0\n",
       "1            ID_CHFTIP26_Month_5       0\n",
       "2            ID_FU5GMWLQ_Month_5       0\n",
       "3            ID_254TVBQP_Month_5       0\n",
       "4            ID_4ENO2VFE_Month_5       0\n",
       "...                          ...     ...\n",
       "1335         ID_PI8N2KJX_Month_5       0\n",
       "1336         ID_L9AHTUD7_Month_5       0\n",
       "1337         ID_BB7GLV87_Month_5       0\n",
       "1338         ID_WB6O1NFS_Month_5       0\n",
       "1339         ID_99LD9C1B_Month_5       0\n",
       "\n",
       "[1340 rows x 2 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "24334a8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sample[\"User_ID_Next_month_Activity\"] = df_sample.User_ID_Next_month_Activity.str.replace('_Month_5', '')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "d7e0e832",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1340"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df_sample[\"User_ID_Next_month_Activity\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "e65645ba",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sample.rename(columns={'User_ID_Next_month_Activity': 'User_ID'},  inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "1c870ec4",
   "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>User_ID</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_4TOXNBGB</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_CHFTIP26</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_FU5GMWLQ</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_254TVBQP</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_4ENO2VFE</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1335</th>\n",
       "      <td>ID_PI8N2KJX</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>ID_L9AHTUD7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337</th>\n",
       "      <td>ID_BB7GLV87</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1338</th>\n",
       "      <td>ID_WB6O1NFS</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1339</th>\n",
       "      <td>ID_99LD9C1B</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1340 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          User_ID  Active\n",
       "0     ID_4TOXNBGB       0\n",
       "1     ID_CHFTIP26       0\n",
       "2     ID_FU5GMWLQ       0\n",
       "3     ID_254TVBQP       0\n",
       "4     ID_4ENO2VFE       0\n",
       "...           ...     ...\n",
       "1335  ID_PI8N2KJX       0\n",
       "1336  ID_L9AHTUD7       0\n",
       "1337  ID_BB7GLV87       0\n",
       "1338  ID_WB6O1NFS       0\n",
       "1339  ID_99LD9C1B       0\n",
       "\n",
       "[1340 rows x 2 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "6f6b24a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_sample[\"User_ID\"] = df_sample[\"User_ID\"].astype(\"string\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "b7ecd096",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'ID_4TOXNBGB'"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sample.loc[0, \"User_ID\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "bc2111aa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       ID_4TOXNBGB\n",
       "1       ID_CHFTIP26\n",
       "2       ID_FU5GMWLQ\n",
       "3       ID_254TVBQP\n",
       "4       ID_4ENO2VFE\n",
       "           ...     \n",
       "1335    ID_PI8N2KJX\n",
       "1336    ID_L9AHTUD7\n",
       "1337    ID_BB7GLV87\n",
       "1338    ID_WB6O1NFS\n",
       "1339    ID_99LD9C1B\n",
       "Name: User_ID, Length: 1340, dtype: string"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sample[\"User_ID\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "c82fd50c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_test = pd.merge(df_sample, result, on='User_ID',  how='inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "ef80bf7d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_test.drop(\"Active\", inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "0da95982",
   "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>User_ID</th>\n",
       "      <th>Participant_Type1</th>\n",
       "      <th>Successful_Submission_Count1</th>\n",
       "      <th>Comp_participation_day1</th>\n",
       "      <th>FeatureA1</th>\n",
       "      <th>FeatureB1</th>\n",
       "      <th>FeatureC1</th>\n",
       "      <th>FeatureD1</th>\n",
       "      <th>FeatureE1</th>\n",
       "      <th>SecretCode1</th>\n",
       "      <th>...</th>\n",
       "      <th>Updated_Profile12</th>\n",
       "      <th>blog_ID12</th>\n",
       "      <th>Viewed_Discussion12</th>\n",
       "      <th>Updated_Submission12</th>\n",
       "      <th>badge_HYIO12</th>\n",
       "      <th>count_UA12</th>\n",
       "      <th>Day_duration12</th>\n",
       "      <th>FeatureX12</th>\n",
       "      <th>FeatureY12</th>\n",
       "      <th>User_sign-in_day12</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_4TOXNBGB</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_CHFTIP26</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_FU5GMWLQ</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_254TVBQP</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_4ENO2VFE</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1335</th>\n",
       "      <td>ID_PI8N2KJX</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1336</th>\n",
       "      <td>ID_L9AHTUD7</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1337</th>\n",
       "      <td>ID_BB7GLV87</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1338</th>\n",
       "      <td>ID_WB6O1NFS</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1339</th>\n",
       "      <td>ID_99LD9C1B</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1340 rows × 309 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          User_ID  Participant_Type1  Successful_Submission_Count1  \\\n",
       "0     ID_4TOXNBGB               -1.0                          -1.0   \n",
       "1     ID_CHFTIP26               -1.0                          -1.0   \n",
       "2     ID_FU5GMWLQ               -1.0                          -1.0   \n",
       "3     ID_254TVBQP               -1.0                          -1.0   \n",
       "4     ID_4ENO2VFE               -1.0                          -1.0   \n",
       "...           ...                ...                           ...   \n",
       "1335  ID_PI8N2KJX               -1.0                          -1.0   \n",
       "1336  ID_L9AHTUD7               -1.0                          -1.0   \n",
       "1337  ID_BB7GLV87               -1.0                          -1.0   \n",
       "1338  ID_WB6O1NFS               -1.0                          -1.0   \n",
       "1339  ID_99LD9C1B               -1.0                          -1.0   \n",
       "\n",
       "      Comp_participation_day1  FeatureA1  FeatureB1  FeatureC1  FeatureD1  \\\n",
       "0                        -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1                        -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "2                        -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "3                        -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "4                        -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "...                       ...        ...        ...        ...        ...   \n",
       "1335                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1336                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1337                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1338                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1339                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "\n",
       "      FeatureE1  SecretCode1  ...  Updated_Profile12  blog_ID12  \\\n",
       "0          -1.0         -1.0  ...               -1.0       -1.0   \n",
       "1          -1.0         -1.0  ...               -1.0       -1.0   \n",
       "2          -1.0         -1.0  ...               -1.0       -1.0   \n",
       "3          -1.0         -1.0  ...               -1.0       -1.0   \n",
       "4          -1.0         -1.0  ...               -1.0       -1.0   \n",
       "...         ...          ...  ...                ...        ...   \n",
       "1335       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "1336       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "1337       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "1338       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "1339       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "\n",
       "      Viewed_Discussion12  Updated_Submission12  badge_HYIO12  count_UA12  \\\n",
       "0                    -1.0                  -1.0          -1.0         0.0   \n",
       "1                    -1.0                  -1.0          -1.0         0.0   \n",
       "2                    -1.0                  -1.0          -1.0         0.0   \n",
       "3                    -1.0                  -1.0          -1.0         0.0   \n",
       "4                    -1.0                  -1.0          -1.0         0.0   \n",
       "...                   ...                   ...           ...         ...   \n",
       "1335                 -1.0                  -1.0          -1.0         0.0   \n",
       "1336                 -1.0                  -1.0          -1.0         0.0   \n",
       "1337                 -1.0                  -1.0          -1.0         0.0   \n",
       "1338                 -1.0                  -1.0          -1.0         0.0   \n",
       "1339                 -1.0                  -1.0          -1.0         0.0   \n",
       "\n",
       "      Day_duration12  FeatureX12  FeatureY12  User_sign-in_day12  \n",
       "0               -1.0        -1.0        -1.0                -1.0  \n",
       "1               -1.0        -1.0        -1.0                -1.0  \n",
       "2               -1.0        -1.0        -1.0                -1.0  \n",
       "3               -1.0        -1.0        -1.0                -1.0  \n",
       "4               -1.0        -1.0        -1.0                -1.0  \n",
       "...              ...         ...         ...                 ...  \n",
       "1335            -1.0        -1.0        -1.0                -1.0  \n",
       "1336            -1.0        -1.0        -1.0                -1.0  \n",
       "1337            -1.0        -1.0        -1.0                -1.0  \n",
       "1338            -1.0        -1.0        -1.0                -1.0  \n",
       "1339            -1.0        -1.0        -1.0                -1.0  \n",
       "\n",
       "[1340 rows x 309 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "d73b8619",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_train = result[~result.User_ID.isin(df_test.User_ID)].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "5fbf4797",
   "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>User_ID</th>\n",
       "      <th>Participant_Type1</th>\n",
       "      <th>Successful_Submission_Count1</th>\n",
       "      <th>Comp_participation_day1</th>\n",
       "      <th>FeatureA1</th>\n",
       "      <th>FeatureB1</th>\n",
       "      <th>FeatureC1</th>\n",
       "      <th>FeatureD1</th>\n",
       "      <th>FeatureE1</th>\n",
       "      <th>SecretCode1</th>\n",
       "      <th>...</th>\n",
       "      <th>Updated_Profile12</th>\n",
       "      <th>blog_ID12</th>\n",
       "      <th>Viewed_Discussion12</th>\n",
       "      <th>Updated_Submission12</th>\n",
       "      <th>badge_HYIO12</th>\n",
       "      <th>count_UA12</th>\n",
       "      <th>Day_duration12</th>\n",
       "      <th>FeatureX12</th>\n",
       "      <th>FeatureY12</th>\n",
       "      <th>User_sign-in_day12</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_000H9XOP</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_004UKSJV</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_008D2J6C</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_00ETFE7J</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_00RKDLAX</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11068</th>\n",
       "      <td>ID_ZZHDXC1Q</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11069</th>\n",
       "      <td>ID_ZZJKFBR5</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11070</th>\n",
       "      <td>ID_ZZQK0LU6</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11071</th>\n",
       "      <td>ID_ZZUNZJ2U</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11072</th>\n",
       "      <td>ID_ZZVUJ45W</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11073 rows × 309 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           User_ID  Participant_Type1  Successful_Submission_Count1  \\\n",
       "0      ID_000H9XOP               -1.0                          -1.0   \n",
       "1      ID_004UKSJV                0.0                           0.0   \n",
       "2      ID_008D2J6C                0.0                           0.0   \n",
       "3      ID_00ETFE7J                0.0                           0.0   \n",
       "4      ID_00RKDLAX                0.0                           0.0   \n",
       "...            ...                ...                           ...   \n",
       "11068  ID_ZZHDXC1Q               -1.0                          -1.0   \n",
       "11069  ID_ZZJKFBR5                0.0                           0.0   \n",
       "11070  ID_ZZQK0LU6               -1.0                          -1.0   \n",
       "11071  ID_ZZUNZJ2U               -1.0                          -1.0   \n",
       "11072  ID_ZZVUJ45W               -1.0                          -1.0   \n",
       "\n",
       "       Comp_participation_day1  FeatureA1  FeatureB1  FeatureC1  FeatureD1  \\\n",
       "0                         -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "2                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "3                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "4                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "...                        ...        ...        ...        ...        ...   \n",
       "11068                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11069                      0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11070                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11071                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11072                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "\n",
       "       FeatureE1  SecretCode1  ...  Updated_Profile12  blog_ID12  \\\n",
       "0           -1.0         -1.0  ...               -1.0       -1.0   \n",
       "1           -1.0         -1.0  ...                4.0        0.0   \n",
       "2           -1.0         -1.0  ...               -1.0       -1.0   \n",
       "3           -1.0         -1.0  ...               -1.0       -1.0   \n",
       "4           -1.0         -1.0  ...                2.0        0.0   \n",
       "...          ...          ...  ...                ...        ...   \n",
       "11068       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "11069       -1.0         -1.0  ...                0.0        0.0   \n",
       "11070       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "11071       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "11072       -1.0         -1.0  ...               -1.0       -1.0   \n",
       "\n",
       "       Viewed_Discussion12  Updated_Submission12  badge_HYIO12  count_UA12  \\\n",
       "0                     -1.0                  -1.0          -1.0         0.0   \n",
       "1                      0.0                   0.0           0.0        11.0   \n",
       "2                     -1.0                  -1.0          -1.0         0.0   \n",
       "3                     -1.0                  -1.0          -1.0         0.0   \n",
       "4                      0.0                   0.0           0.0         9.0   \n",
       "...                    ...                   ...           ...         ...   \n",
       "11068                 -1.0                  -1.0          -1.0         0.0   \n",
       "11069                  0.0                   0.0           0.0        43.0   \n",
       "11070                 -1.0                  -1.0          -1.0         0.0   \n",
       "11071                 -1.0                  -1.0          -1.0         0.0   \n",
       "11072                 -1.0                  -1.0          -1.0         0.0   \n",
       "\n",
       "       Day_duration12  FeatureX12  FeatureY12  User_sign-in_day12  \n",
       "0                -1.0        -1.0        -1.0                -1.0  \n",
       "1                 2.0         0.0         0.0                28.0  \n",
       "2                -1.0        -1.0        -1.0                -1.0  \n",
       "3                -1.0        -1.0        -1.0                -1.0  \n",
       "4                 1.0         0.0         1.0                23.0  \n",
       "...               ...         ...         ...                 ...  \n",
       "11068            -1.0        -1.0        -1.0                -1.0  \n",
       "11069             4.0         0.0         1.0                 8.0  \n",
       "11070            -1.0        -1.0        -1.0                -1.0  \n",
       "11071            -1.0        -1.0        -1.0                -1.0  \n",
       "11072            -1.0        -1.0        -1.0                -1.0  \n",
       "\n",
       "[11073 rows x 309 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "be958ed6",
   "metadata": {},
   "source": [
    "## Criteria"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "189a64f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_crit = pd.read_csv(\"CriteriaData.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "5f5bdeee",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_crit.drop(\"Unnamed: 0\", axis = 1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "472d3c00",
   "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>User_ID</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ID_ZZVUJ45W</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ID_ZZUNZJ2U</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ID_ZZQK0LU6</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ID_ZZHDXC1Q</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ID_ZYVA36JR</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5231</th>\n",
       "      <td>ID_01BEG5HQ</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5232</th>\n",
       "      <td>ID_011YM9VH</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5233</th>\n",
       "      <td>ID_00SL0NNP</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5234</th>\n",
       "      <td>ID_00ETFE7J</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5235</th>\n",
       "      <td>ID_008D2J6C</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5236 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          User_ID  Active\n",
       "0     ID_ZZVUJ45W     0.0\n",
       "1     ID_ZZUNZJ2U     0.0\n",
       "2     ID_ZZQK0LU6     0.0\n",
       "3     ID_ZZHDXC1Q     0.0\n",
       "4     ID_ZYVA36JR     1.0\n",
       "...           ...     ...\n",
       "5231  ID_01BEG5HQ     1.0\n",
       "5232  ID_011YM9VH     1.0\n",
       "5233  ID_00SL0NNP     0.0\n",
       "5234  ID_00ETFE7J     0.0\n",
       "5235  ID_008D2J6C     0.0\n",
       "\n",
       "[5236 rows x 2 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_crit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "9a79889f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_train = pd.merge(df_train, df_crit, on='User_ID',  how='left').fillna(0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "0e40ce6f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_train.drop(\"User_ID\", inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "651aac20",
   "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>Participant_Type1</th>\n",
       "      <th>Successful_Submission_Count1</th>\n",
       "      <th>Comp_participation_day1</th>\n",
       "      <th>FeatureA1</th>\n",
       "      <th>FeatureB1</th>\n",
       "      <th>FeatureC1</th>\n",
       "      <th>FeatureD1</th>\n",
       "      <th>FeatureE1</th>\n",
       "      <th>SecretCode1</th>\n",
       "      <th>FeatureF1</th>\n",
       "      <th>...</th>\n",
       "      <th>blog_ID12</th>\n",
       "      <th>Viewed_Discussion12</th>\n",
       "      <th>Updated_Submission12</th>\n",
       "      <th>badge_HYIO12</th>\n",
       "      <th>count_UA12</th>\n",
       "      <th>Day_duration12</th>\n",
       "      <th>FeatureX12</th>\n",
       "      <th>FeatureY12</th>\n",
       "      <th>User_sign-in_day12</th>\n",
       "      <th>Active</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11068</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11069</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11070</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11071</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11072</th>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11073 rows × 309 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Participant_Type1  Successful_Submission_Count1  \\\n",
       "0                   -1.0                          -1.0   \n",
       "1                    0.0                           0.0   \n",
       "2                    0.0                           0.0   \n",
       "3                    0.0                           0.0   \n",
       "4                    0.0                           0.0   \n",
       "...                  ...                           ...   \n",
       "11068               -1.0                          -1.0   \n",
       "11069                0.0                           0.0   \n",
       "11070               -1.0                          -1.0   \n",
       "11071               -1.0                          -1.0   \n",
       "11072               -1.0                          -1.0   \n",
       "\n",
       "       Comp_participation_day1  FeatureA1  FeatureB1  FeatureC1  FeatureD1  \\\n",
       "0                         -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "1                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "2                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "3                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "4                          0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "...                        ...        ...        ...        ...        ...   \n",
       "11068                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11069                      0.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11070                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11071                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "11072                     -1.0       -1.0       -1.0       -1.0       -1.0   \n",
       "\n",
       "       FeatureE1  SecretCode1  FeatureF1  ...  blog_ID12  Viewed_Discussion12  \\\n",
       "0           -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "1           -1.0         -1.0       -1.0  ...        0.0                  0.0   \n",
       "2           -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "3           -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "4           -1.0         -1.0       -1.0  ...        0.0                  0.0   \n",
       "...          ...          ...        ...  ...        ...                  ...   \n",
       "11068       -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "11069       -1.0         -1.0       -1.0  ...        0.0                  0.0   \n",
       "11070       -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "11071       -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "11072       -1.0         -1.0       -1.0  ...       -1.0                 -1.0   \n",
       "\n",
       "       Updated_Submission12  badge_HYIO12  count_UA12  Day_duration12  \\\n",
       "0                      -1.0          -1.0         0.0            -1.0   \n",
       "1                       0.0           0.0        11.0             2.0   \n",
       "2                      -1.0          -1.0         0.0            -1.0   \n",
       "3                      -1.0          -1.0         0.0            -1.0   \n",
       "4                       0.0           0.0         9.0             1.0   \n",
       "...                     ...           ...         ...             ...   \n",
       "11068                  -1.0          -1.0         0.0            -1.0   \n",
       "11069                   0.0           0.0        43.0             4.0   \n",
       "11070                  -1.0          -1.0         0.0            -1.0   \n",
       "11071                  -1.0          -1.0         0.0            -1.0   \n",
       "11072                  -1.0          -1.0         0.0            -1.0   \n",
       "\n",
       "       FeatureX12  FeatureY12  User_sign-in_day12  Active  \n",
       "0            -1.0        -1.0                -1.0     0.0  \n",
       "1             0.0         0.0                28.0     0.0  \n",
       "2            -1.0        -1.0                -1.0     0.0  \n",
       "3            -1.0        -1.0                -1.0     0.0  \n",
       "4             0.0         1.0                23.0     0.0  \n",
       "...           ...         ...                 ...     ...  \n",
       "11068        -1.0        -1.0                -1.0     0.0  \n",
       "11069         0.0         1.0                 8.0     0.0  \n",
       "11070        -1.0        -1.0                -1.0     0.0  \n",
       "11071        -1.0        -1.0                -1.0     0.0  \n",
       "11072        -1.0        -1.0                -1.0     0.0  \n",
       "\n",
       "[11073 rows x 309 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f7c2162d",
   "metadata": {},
   "source": [
    "## Model Building"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "32618f2d",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import accuracy_score\n",
    "from sklearn.metrics import f1_score\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "import operator as op"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "de7735e4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_temp = df_train.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "a9f5aef7",
   "metadata": {},
   "outputs": [],
   "source": [
    "y = df_temp[\"Active\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "7948241f",
   "metadata": {},
   "outputs": [],
   "source": [
    "my_cols = set(df_temp.columns)\n",
    "my_cols.remove('Active')\n",
    "X = df_temp[my_cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "781c2be2",
   "metadata": {},
   "outputs": [],
   "source": [
    "for column in X:\n",
    "    X[column] = X[column] / X[column].abs().max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "cb608100",
   "metadata": {},
   "outputs": [],
   "source": [
    "train_X, test_X, train_y, test_y = train_test_split(X, y, test_size=0.2, random_state=12, shuffle=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "72d396d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "clf = LogisticRegression(random_state=0).fit(train_X, train_y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "8bc3741c",
   "metadata": {},
   "outputs": [],
   "source": [
    "y_p = clf.predict(test_X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "ce5e81df",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "187"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "op.countOf(y_p, 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "4fea319c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.9959367945823928"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "accuracy_score(test_y, y_p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "c5bcaa00",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.9760000000000001"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f1_score(test_y, y_p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "56692c5f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_test.drop(\"User_ID\", inplace=True, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "76dbc835",
   "metadata": {},
   "outputs": [],
   "source": [
    "for column in df_test:\n",
    "    df_test[column] = df_test[column] / df_test[column].abs().max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "b5285ed1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_test.fillna(0, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "be72de9b",
   "metadata": {},
   "outputs": [],
   "source": [
    "y_predict = clf.predict(df_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "422d24ac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "op.countOf(y_predict, 1)"
   ]
  }
 ],
 "metadata": {
  "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}