contributor_list.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0abfb6c6-63d3-485b-abc8-995a92154285",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e8387bc8-67d1-4a7b-b942-6fdf539ffd6e",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "indivs_commits = pd.concat([pd.read_csv(\"data/merged_data/committers_info_pr.csv\", index_col = 0),\n",
    "                            pd.read_csv(\"data/merged_data/committers_info_push.csv\", index_col = 0)])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "60410944-8abf-4f6c-ad15-9d4650652384",
   "metadata": {},
   "outputs": [],
   "source": [
    "event_types = np.unique([ele[:-16] for ele in os.listdir('data/github_clean/github_data_pre_18')])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c4b9d287-2814-4e06-a618-e184b3598a59",
   "metadata": {},
   "outputs": [],
   "source": [
    "def readFile(prefix):\n",
    "    file_group1 = [file for file in os.listdir('data/github_clean/github_data_pre_18') if prefix in file]\n",
    "    all_files1 = pd.concat([pd.read_csv(f'data/github_clean/github_data_pre_18/{f}', index_col = 0) for f in file_group1])\n",
    "    file_group2 = [file for file in os.listdir('data/github_clean/filtered_github_data_large') if prefix in file]\n",
    "    all_files2 = pd.concat([pd.read_csv(f'data/github_clean/github_data_pre_18/{f}', index_col = 0) for f in file_group2])\n",
    "    all_files = pd.concat([all_files1, all_files2])\n",
    "\n",
    "    all_files_grouped = all_files.groupby(['actor_id', 'actor_login', 'repo_id', 'repo_name', 'org_id','org_login']).agg({'created_at':[min, max, 'count']})\n",
    "    setcols = ['actor_id', 'actor_login', 'repo_id', 'repo_name', 'org_id','org_login']\n",
    "    setcols.extend([f'earliest_{prefix}', f'latest_{prefix}', f'count_{prefix}'])\n",
    "    all_files_grouped.reset_index(inplace = True)\n",
    "    all_files_grouped.columns = setcols\n",
    "    return all_files_grouped"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "bdee23d9-9b16-4c4e-8682-11ac4840d478",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "deleteEvent\n",
      "issueCommentEvent\n",
      "issuesEvent\n",
      "prEvent\n",
      "prEventCommits\n",
      "prReviewCommentEvent\n",
      "prReviewEvent\n",
      "pushEvent\n",
      "releaseEvent\n"
     ]
    }
   ],
   "source": [
    "df_merged = readFile(event_types[0])\n",
    "for event in event_types[1:]:\n",
    "    if event not in ['forkEvent', 'watchEvent']:\n",
    "        print(event)\n",
    "        df_fixed = readFile(event)\n",
    "        df_merged = pd.merge(df_merged, df_fixed, how = 'outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "06fb9eb3-2209-48cc-b982-0ead260771f1",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df_actors = df_merged[['actor_id', 'actor_login']].drop_duplicates()\n",
    "df_actors['type'] = 'general contributor'\n",
    "df_actors.reset_index(inplace = True, drop = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "bdd4d327-19ff-4559-adc3-8bc3dc442d43",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df_fork = readFile('forkEvent')\n",
    "df_merged_fork = pd.merge(df_merged, df_fork, how = 'outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "5719511d-b432-4dc5-9e65-fbce70fca07c",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df_actors_fork = df_merged_fork[['actor_id', 'actor_login']].drop_duplicates()\n",
    "df_actors_fork = pd.merge(df_actors_fork, df_actors, how = 'left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "2cf43754-dd5d-4c5e-b7e5-97fd89525e2a",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "logins = indivs_commits[['actor_login']].dropna().drop_duplicates()\n",
    "logins = logins[~logins['actor_login'].isin(df_actors_fork['actor_login'].tolist())]\n",
    "logins['type'] = 'general contributor'\n",
    "logins['actor_id'] = np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "5f863b09-f936-47aa-a234-013ced48f88e",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df_actors_fork = pd.concat([df_actors_fork, logins])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "42a42ab6-7eda-4c3f-b304-f4b130d72a45",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_actors_fork['type'] = df_actors_fork['type'].apply(lambda x: 'forker' if pd.isnull(x) else x)\n",
    "#df_actors_fork.to_csv('data/inputs/all_contributors.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "97875a4c-68fc-420c-be24-ea9eeffe72a7",
   "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>actor_id</th>\n",
       "      <th>actor_login</th>\n",
       "      <th>repo_id</th>\n",
       "      <th>repo_name</th>\n",
       "      <th>org_id</th>\n",
       "      <th>org_login</th>\n",
       "      <th>earliest_createEvent</th>\n",
       "      <th>latest_createEvent</th>\n",
       "      <th>count_createEvent</th>\n",
       "      <th>earliest_deleteEvent</th>\n",
       "      <th>...</th>\n",
       "      <th>count_prReviewEvent</th>\n",
       "      <th>earliest_pushEvent</th>\n",
       "      <th>latest_pushEvent</th>\n",
       "      <th>count_pushEvent</th>\n",
       "      <th>earliest_releaseEvent</th>\n",
       "      <th>latest_releaseEvent</th>\n",
       "      <th>count_releaseEvent</th>\n",
       "      <th>earliest_forkEvent</th>\n",
       "      <th>latest_forkEvent</th>\n",
       "      <th>count_forkEvent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>124</td>\n",
       "      <td>brosner</td>\n",
       "      <td>39740335</td>\n",
       "      <td>kelproject/pykube</td>\n",
       "      <td>17834534.0</td>\n",
       "      <td>kelproject</td>\n",
       "      <td>2016-05-21 16:11:14+00:00</td>\n",
       "      <td>2017-03-06 18:28:02+00:00</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2016-06-09 17:51:08+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-05-03 19:13:00+00:00</td>\n",
       "      <td>2017-07-01 21:01:07+00:00</td>\n",
       "      <td>103.0</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>175</td>\n",
       "      <td>tommorris</td>\n",
       "      <td>34864460</td>\n",
       "      <td>Nexmo/nexmo-python</td>\n",
       "      <td>551057.0</td>\n",
       "      <td>Nexmo</td>\n",
       "      <td>2017-05-03 17:42:11+00:00</td>\n",
       "      <td>2017-06-06 10:33:03+00:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2017-05-26 21:46:43+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2017-05-18 13:22:19+00:00</td>\n",
       "      <td>2017-05-25 16:16:58+00:00</td>\n",
       "      <td>3.0</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>260</td>\n",
       "      <td>maddox</td>\n",
       "      <td>124170980</td>\n",
       "      <td>fancybits/pychannels</td>\n",
       "      <td>16461035.0</td>\n",
       "      <td>fancybits</td>\n",
       "      <td>2018-03-07 03:04:43+00:00</td>\n",
       "      <td>2018-03-07 03:11:41+00:00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018-03-07 03:07:19+00:00</td>\n",
       "      <td>2018-03-07 05:25:11+00:00</td>\n",
       "      <td>6.0</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>3</th>\n",
       "      <td>598</td>\n",
       "      <td>jmhodges</td>\n",
       "      <td>26516210</td>\n",
       "      <td>letsencrypt/letsencrypt</td>\n",
       "      <td>9289019.0</td>\n",
       "      <td>letsencrypt</td>\n",
       "      <td>2015-07-22 23:59:26+00:00</td>\n",
       "      <td>2015-11-13 20:39:40+00:00</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2015-11-09 22:30:16+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-29 22:08:25+00:00</td>\n",
       "      <td>2015-07-29 22:27:19+00:00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-29 21:53:06+00:00</td>\n",
       "      <td>2015-08-25 19:22:11+00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>658</td>\n",
       "      <td>stephencelis</td>\n",
       "      <td>527040</td>\n",
       "      <td>recurly/recurly-client-python</td>\n",
       "      <td>144605.0</td>\n",
       "      <td>recurly</td>\n",
       "      <td>2011-10-28 21:55:09+00:00</td>\n",
       "      <td>2011-10-28 21:55:09+00:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2011-10-31 22:27:12+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2011-10-31 22:26:57+00:00</td>\n",
       "      <td>2011-12-03 00:30:45+00:00</td>\n",
       "      <td>5.0</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>310228</th>\n",
       "      <td>42841451</td>\n",
       "      <td>nenadnikolicai</td>\n",
       "      <td>102973646</td>\n",
       "      <td>fastai/fastai</td>\n",
       "      <td>20547620.0</td>\n",
       "      <td>fastai</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>2018-08-30 14:37:26+00:00</td>\n",
       "      <td>2018-08-30 14:37:26+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310229</th>\n",
       "      <td>42848579</td>\n",
       "      <td>Dzyn641</td>\n",
       "      <td>3470471</td>\n",
       "      <td>FortAwesome/Font-Awesome</td>\n",
       "      <td>1505683.0</td>\n",
       "      <td>FortAwesome</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>2018-08-31 02:30:50+00:00</td>\n",
       "      <td>2018-08-31 02:30:50+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310230</th>\n",
       "      <td>42848941</td>\n",
       "      <td>ManuBonachela</td>\n",
       "      <td>142422739</td>\n",
       "      <td>google/dopamine</td>\n",
       "      <td>1342004.0</td>\n",
       "      <td>google</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>2018-08-30 20:00:06+00:00</td>\n",
       "      <td>2018-08-30 20:00:06+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310231</th>\n",
       "      <td>42872341</td>\n",
       "      <td>BinaryBlockChain</td>\n",
       "      <td>96364578</td>\n",
       "      <td>ethereum/eth-tester</td>\n",
       "      <td>6250754.0</td>\n",
       "      <td>ethereum</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>2018-08-31 15:44:23+00:00</td>\n",
       "      <td>2018-08-31 15:44:23+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310232</th>\n",
       "      <td>42876096</td>\n",
       "      <td>ezkia</td>\n",
       "      <td>3470471</td>\n",
       "      <td>FortAwesome/Font-Awesome</td>\n",
       "      <td>1505683.0</td>\n",
       "      <td>FortAwesome</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>2018-08-31 18:31:20+00:00</td>\n",
       "      <td>2018-08-31 18:31:20+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>310233 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        actor_id       actor_login    repo_id                      repo_name  \\\n",
       "0            124           brosner   39740335              kelproject/pykube   \n",
       "1            175         tommorris   34864460             Nexmo/nexmo-python   \n",
       "2            260            maddox  124170980           fancybits/pychannels   \n",
       "3            598          jmhodges   26516210        letsencrypt/letsencrypt   \n",
       "4            658      stephencelis     527040  recurly/recurly-client-python   \n",
       "...          ...               ...        ...                            ...   \n",
       "310228  42841451    nenadnikolicai  102973646                  fastai/fastai   \n",
       "310229  42848579           Dzyn641    3470471       FortAwesome/Font-Awesome   \n",
       "310230  42848941     ManuBonachela  142422739                google/dopamine   \n",
       "310231  42872341  BinaryBlockChain   96364578            ethereum/eth-tester   \n",
       "310232  42876096             ezkia    3470471       FortAwesome/Font-Awesome   \n",
       "\n",
       "            org_id    org_login       earliest_createEvent  \\\n",
       "0       17834534.0   kelproject  2016-05-21 16:11:14+00:00   \n",
       "1         551057.0        Nexmo  2017-05-03 17:42:11+00:00   \n",
       "2       16461035.0    fancybits  2018-03-07 03:04:43+00:00   \n",
       "3        9289019.0  letsencrypt  2015-07-22 23:59:26+00:00   \n",
       "4         144605.0      recurly  2011-10-28 21:55:09+00:00   \n",
       "...            ...          ...                        ...   \n",
       "310228  20547620.0       fastai                        NaN   \n",
       "310229   1505683.0  FortAwesome                        NaN   \n",
       "310230   1342004.0       google                        NaN   \n",
       "310231   6250754.0     ethereum                        NaN   \n",
       "310232   1505683.0  FortAwesome                        NaN   \n",
       "\n",
       "               latest_createEvent  count_createEvent  \\\n",
       "0       2017-03-06 18:28:02+00:00               14.0   \n",
       "1       2017-06-06 10:33:03+00:00                4.0   \n",
       "2       2018-03-07 03:11:41+00:00                3.0   \n",
       "3       2015-11-13 20:39:40+00:00                9.0   \n",
       "4       2011-10-28 21:55:09+00:00                1.0   \n",
       "...                           ...                ...   \n",
       "310228                        NaN                NaN   \n",
       "310229                        NaN                NaN   \n",
       "310230                        NaN                NaN   \n",
       "310231                        NaN                NaN   \n",
       "310232                        NaN                NaN   \n",
       "\n",
       "             earliest_deleteEvent  ... count_prReviewEvent  \\\n",
       "0       2016-06-09 17:51:08+00:00  ...                 NaN   \n",
       "1       2017-05-26 21:46:43+00:00  ...                 NaN   \n",
       "2                             NaN  ...                 NaN   \n",
       "3       2015-11-09 22:30:16+00:00  ...                 NaN   \n",
       "4       2011-10-31 22:27:12+00:00  ...                 NaN   \n",
       "...                           ...  ...                 ...   \n",
       "310228                        NaN  ...                 NaN   \n",
       "310229                        NaN  ...                 NaN   \n",
       "310230                        NaN  ...                 NaN   \n",
       "310231                        NaN  ...                 NaN   \n",
       "310232                        NaN  ...                 NaN   \n",
       "\n",
       "               earliest_pushEvent           latest_pushEvent count_pushEvent  \\\n",
       "0       2016-05-03 19:13:00+00:00  2017-07-01 21:01:07+00:00           103.0   \n",
       "1       2017-05-18 13:22:19+00:00  2017-05-25 16:16:58+00:00             3.0   \n",
       "2       2018-03-07 03:07:19+00:00  2018-03-07 05:25:11+00:00             6.0   \n",
       "3       2015-07-29 22:08:25+00:00  2015-07-29 22:27:19+00:00             2.0   \n",
       "4       2011-10-31 22:26:57+00:00  2011-12-03 00:30:45+00:00             5.0   \n",
       "...                           ...                        ...             ...   \n",
       "310228                        NaN                        NaN             NaN   \n",
       "310229                        NaN                        NaN             NaN   \n",
       "310230                        NaN                        NaN             NaN   \n",
       "310231                        NaN                        NaN             NaN   \n",
       "310232                        NaN                        NaN             NaN   \n",
       "\n",
       "        earliest_releaseEvent latest_releaseEvent count_releaseEvent  \\\n",
       "0                         NaN                 NaN                NaN   \n",
       "1                         NaN                 NaN                NaN   \n",
       "2                         NaN                 NaN                NaN   \n",
       "3                         NaN                 NaN                NaN   \n",
       "4                         NaN                 NaN                NaN   \n",
       "...                       ...                 ...                ...   \n",
       "310228                    NaN                 NaN                NaN   \n",
       "310229                    NaN                 NaN                NaN   \n",
       "310230                    NaN                 NaN                NaN   \n",
       "310231                    NaN                 NaN                NaN   \n",
       "310232                    NaN                 NaN                NaN   \n",
       "\n",
       "               earliest_forkEvent           latest_forkEvent count_forkEvent  \n",
       "0                             NaN                        NaN             NaN  \n",
       "1                             NaN                        NaN             NaN  \n",
       "2                             NaN                        NaN             NaN  \n",
       "3       2015-07-29 21:53:06+00:00  2015-08-25 19:22:11+00:00             2.0  \n",
       "4                             NaN                        NaN             NaN  \n",
       "...                           ...                        ...             ...  \n",
       "310228  2018-08-30 14:37:26+00:00  2018-08-30 14:37:26+00:00             1.0  \n",
       "310229  2018-08-31 02:30:50+00:00  2018-08-31 02:30:50+00:00             1.0  \n",
       "310230  2018-08-30 20:00:06+00:00  2018-08-30 20:00:06+00:00             1.0  \n",
       "310231  2018-08-31 15:44:23+00:00  2018-08-31 15:44:23+00:00             1.0  \n",
       "310232  2018-08-31 18:31:20+00:00  2018-08-31 18:31:20+00:00             1.0  \n",
       "\n",
       "[310233 rows x 39 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged_fork"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "782e401b-a98f-4c9a-bfe4-c6aa518ea47a",
   "metadata": {
    "scrolled": true
   },
   "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>actor_id</th>\n",
       "      <th>actor_login</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>124.0</td>\n",
       "      <td>brosner</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>175.0</td>\n",
       "      <td>tommorris</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>260.0</td>\n",
       "      <td>maddox</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>598.0</td>\n",
       "      <td>jmhodges</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>658.0</td>\n",
       "      <td>stephencelis</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111327</th>\n",
       "      <td>NaN</td>\n",
       "      <td>aveuiller</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111345</th>\n",
       "      <td>NaN</td>\n",
       "      <td>caithagoras0</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111422</th>\n",
       "      <td>NaN</td>\n",
       "      <td>pastamaker[bot]</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111431</th>\n",
       "      <td>NaN</td>\n",
       "      <td>houssemkouki</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111577</th>\n",
       "      <td>NaN</td>\n",
       "      <td>acotter</td>\n",
       "      <td>general contributor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>295845 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        actor_id      actor_login                 type\n",
       "0          124.0          brosner  general contributor\n",
       "1          175.0        tommorris  general contributor\n",
       "2          260.0           maddox  general contributor\n",
       "3          598.0         jmhodges  general contributor\n",
       "4          658.0     stephencelis  general contributor\n",
       "...          ...              ...                  ...\n",
       "111327       NaN        aveuiller  general contributor\n",
       "111345       NaN     caithagoras0  general contributor\n",
       "111422       NaN  pastamaker[bot]  general contributor\n",
       "111431       NaN     houssemkouki  general contributor\n",
       "111577       NaN          acotter  general contributor\n",
       "\n",
       "[295845 rows x 3 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_actors_fork"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "2ac996e5-0a69-4dea-9eb0-ecead5eef274",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_watch = readFile('watchEvent')\n",
    "df_merged_watch = pd.merge(df_merged_fork, df_watch, how = 'outer')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "1a252a0a-7038-4b51-bd0d-1657da343d02",
   "metadata": {
    "scrolled": true
   },
   "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>actor_id</th>\n",
       "      <th>actor_login</th>\n",
       "      <th>repo_id</th>\n",
       "      <th>repo_name</th>\n",
       "      <th>org_id</th>\n",
       "      <th>org_login</th>\n",
       "      <th>earliest_createEvent</th>\n",
       "      <th>latest_createEvent</th>\n",
       "      <th>count_createEvent</th>\n",
       "      <th>earliest_deleteEvent</th>\n",
       "      <th>...</th>\n",
       "      <th>count_pushEvent</th>\n",
       "      <th>earliest_releaseEvent</th>\n",
       "      <th>latest_releaseEvent</th>\n",
       "      <th>count_releaseEvent</th>\n",
       "      <th>earliest_forkEvent</th>\n",
       "      <th>latest_forkEvent</th>\n",
       "      <th>count_forkEvent</th>\n",
       "      <th>earliest_watchEvent</th>\n",
       "      <th>latest_watchEvent</th>\n",
       "      <th>count_watchEvent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>124.0</td>\n",
       "      <td>brosner</td>\n",
       "      <td>39740335</td>\n",
       "      <td>kelproject/pykube</td>\n",
       "      <td>17834534.0</td>\n",
       "      <td>kelproject</td>\n",
       "      <td>2016-05-21 16:11:14+00:00</td>\n",
       "      <td>2017-03-06 18:28:02+00:00</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2016-06-09 17:51:08+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>103.0</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>175.0</td>\n",
       "      <td>tommorris</td>\n",
       "      <td>34864460</td>\n",
       "      <td>Nexmo/nexmo-python</td>\n",
       "      <td>551057.0</td>\n",
       "      <td>Nexmo</td>\n",
       "      <td>2017-05-03 17:42:11+00:00</td>\n",
       "      <td>2017-06-06 10:33:03+00:00</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2017-05-26 21:46:43+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</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>2017-04-12 14:50:43+00:00</td>\n",
       "      <td>2017-04-12 14:50:43+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>260.0</td>\n",
       "      <td>maddox</td>\n",
       "      <td>124170980</td>\n",
       "      <td>fancybits/pychannels</td>\n",
       "      <td>16461035.0</td>\n",
       "      <td>fancybits</td>\n",
       "      <td>2018-03-07 03:04:43+00:00</td>\n",
       "      <td>2018-03-07 03:11:41+00:00</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</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>2018-03-29 07:25:17+00:00</td>\n",
       "      <td>2018-03-29 07:25:17+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>598.0</td>\n",
       "      <td>jmhodges</td>\n",
       "      <td>26516210</td>\n",
       "      <td>letsencrypt/letsencrypt</td>\n",
       "      <td>9289019.0</td>\n",
       "      <td>letsencrypt</td>\n",
       "      <td>2015-07-22 23:59:26+00:00</td>\n",
       "      <td>2015-11-13 20:39:40+00:00</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2015-11-09 22:30:16+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-29 21:53:06+00:00</td>\n",
       "      <td>2015-08-25 19:22:11+00:00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>658.0</td>\n",
       "      <td>stephencelis</td>\n",
       "      <td>527040</td>\n",
       "      <td>recurly/recurly-client-python</td>\n",
       "      <td>144605.0</td>\n",
       "      <td>recurly</td>\n",
       "      <td>2011-10-28 21:55:09+00:00</td>\n",
       "      <td>2011-10-28 21:55:09+00:00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2011-10-31 22:27:12+00:00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</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>933987</th>\n",
       "      <td>42854098.0</td>\n",
       "      <td>nilbibi</td>\n",
       "      <td>142422739</td>\n",
       "      <td>google/dopamine</td>\n",
       "      <td>1342004.0</td>\n",
       "      <td>google</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>2018-08-31 01:31:57+00:00</td>\n",
       "      <td>2018-08-31 01:31:57+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933988</th>\n",
       "      <td>42861855.0</td>\n",
       "      <td>mbulek</td>\n",
       "      <td>142422739</td>\n",
       "      <td>google/dopamine</td>\n",
       "      <td>1342004.0</td>\n",
       "      <td>google</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>2018-08-31 08:16:10+00:00</td>\n",
       "      <td>2018-08-31 08:16:10+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933989</th>\n",
       "      <td>42869196.0</td>\n",
       "      <td>ADugeniuc</td>\n",
       "      <td>73328905</td>\n",
       "      <td>pytorch/vision</td>\n",
       "      <td>21003710.0</td>\n",
       "      <td>pytorch</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>2018-08-31 13:33:14+00:00</td>\n",
       "      <td>2018-08-31 13:33:14+00:00</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933990</th>\n",
       "      <td>42875880.0</td>\n",
       "      <td>baznunes</td>\n",
       "      <td>142422739</td>\n",
       "      <td>google/dopamine</td>\n",
       "      <td>1342004.0</td>\n",
       "      <td>google</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>2018-08-31 18:38:49+00:00</td>\n",
       "      <td>2018-08-31 18:38:49+00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>933991</th>\n",
       "      <td>42879943.0</td>\n",
       "      <td>asalib3</td>\n",
       "      <td>142422739</td>\n",
       "      <td>google/dopamine</td>\n",
       "      <td>1342004.0</td>\n",
       "      <td>google</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>2018-08-31 22:54:09+00:00</td>\n",
       "      <td>2018-08-31 22:54:09+00:00</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>933992 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          actor_id   actor_login    repo_id                      repo_name  \\\n",
       "0            124.0       brosner   39740335              kelproject/pykube   \n",
       "1            175.0     tommorris   34864460             Nexmo/nexmo-python   \n",
       "2            260.0        maddox  124170980           fancybits/pychannels   \n",
       "3            598.0      jmhodges   26516210        letsencrypt/letsencrypt   \n",
       "4            658.0  stephencelis     527040  recurly/recurly-client-python   \n",
       "...            ...           ...        ...                            ...   \n",
       "933987  42854098.0       nilbibi  142422739                google/dopamine   \n",
       "933988  42861855.0        mbulek  142422739                google/dopamine   \n",
       "933989  42869196.0     ADugeniuc   73328905                 pytorch/vision   \n",
       "933990  42875880.0      baznunes  142422739                google/dopamine   \n",
       "933991  42879943.0       asalib3  142422739                google/dopamine   \n",
       "\n",
       "            org_id    org_login       earliest_createEvent  \\\n",
       "0       17834534.0   kelproject  2016-05-21 16:11:14+00:00   \n",
       "1         551057.0        Nexmo  2017-05-03 17:42:11+00:00   \n",
       "2       16461035.0    fancybits  2018-03-07 03:04:43+00:00   \n",
       "3        9289019.0  letsencrypt  2015-07-22 23:59:26+00:00   \n",
       "4         144605.0      recurly  2011-10-28 21:55:09+00:00   \n",
       "...            ...          ...                        ...   \n",
       "933987   1342004.0       google                        NaN   \n",
       "933988   1342004.0       google                        NaN   \n",
       "933989  21003710.0      pytorch                        NaN   \n",
       "933990   1342004.0       google                        NaN   \n",
       "933991   1342004.0       google                        NaN   \n",
       "\n",
       "               latest_createEvent  count_createEvent  \\\n",
       "0       2017-03-06 18:28:02+00:00               14.0   \n",
       "1       2017-06-06 10:33:03+00:00                4.0   \n",
       "2       2018-03-07 03:11:41+00:00                3.0   \n",
       "3       2015-11-13 20:39:40+00:00                9.0   \n",
       "4       2011-10-28 21:55:09+00:00                1.0   \n",
       "...                           ...                ...   \n",
       "933987                        NaN                NaN   \n",
       "933988                        NaN                NaN   \n",
       "933989                        NaN                NaN   \n",
       "933990                        NaN                NaN   \n",
       "933991                        NaN                NaN   \n",
       "\n",
       "             earliest_deleteEvent  ... count_pushEvent  earliest_releaseEvent  \\\n",
       "0       2016-06-09 17:51:08+00:00  ...           103.0                    NaN   \n",
       "1       2017-05-26 21:46:43+00:00  ...             3.0                    NaN   \n",
       "2                             NaN  ...             6.0                    NaN   \n",
       "3       2015-11-09 22:30:16+00:00  ...             2.0                    NaN   \n",
       "4       2011-10-31 22:27:12+00:00  ...             5.0                    NaN   \n",
       "...                           ...  ...             ...                    ...   \n",
       "933987                        NaN  ...             NaN                    NaN   \n",
       "933988                        NaN  ...             NaN                    NaN   \n",
       "933989                        NaN  ...             NaN                    NaN   \n",
       "933990                        NaN  ...             NaN                    NaN   \n",
       "933991                        NaN  ...             NaN                    NaN   \n",
       "\n",
       "       latest_releaseEvent count_releaseEvent         earliest_forkEvent  \\\n",
       "0                      NaN                NaN                        NaN   \n",
       "1                      NaN                NaN                        NaN   \n",
       "2                      NaN                NaN                        NaN   \n",
       "3                      NaN                NaN  2015-07-29 21:53:06+00:00   \n",
       "4                      NaN                NaN                        NaN   \n",
       "...                    ...                ...                        ...   \n",
       "933987                 NaN                NaN                        NaN   \n",
       "933988                 NaN                NaN                        NaN   \n",
       "933989                 NaN                NaN                        NaN   \n",
       "933990                 NaN                NaN                        NaN   \n",
       "933991                 NaN                NaN                        NaN   \n",
       "\n",
       "                 latest_forkEvent count_forkEvent        earliest_watchEvent  \\\n",
       "0                             NaN             NaN                        NaN   \n",
       "1                             NaN             NaN  2017-04-12 14:50:43+00:00   \n",
       "2                             NaN             NaN  2018-03-29 07:25:17+00:00   \n",
       "3       2015-08-25 19:22:11+00:00             2.0                        NaN   \n",
       "4                             NaN             NaN                        NaN   \n",
       "...                           ...             ...                        ...   \n",
       "933987                        NaN             NaN  2018-08-31 01:31:57+00:00   \n",
       "933988                        NaN             NaN  2018-08-31 08:16:10+00:00   \n",
       "933989                        NaN             NaN  2018-08-31 13:33:14+00:00   \n",
       "933990                        NaN             NaN  2018-08-31 18:38:49+00:00   \n",
       "933991                        NaN             NaN  2018-08-31 22:54:09+00:00   \n",
       "\n",
       "                latest_watchEvent count_watchEvent  \n",
       "0                             NaN              NaN  \n",
       "1       2017-04-12 14:50:43+00:00              1.0  \n",
       "2       2018-03-29 07:25:17+00:00              1.0  \n",
       "3                             NaN              NaN  \n",
       "4                             NaN              NaN  \n",
       "...                           ...              ...  \n",
       "933987  2018-08-31 01:31:57+00:00              1.0  \n",
       "933988  2018-08-31 08:16:10+00:00              1.0  \n",
       "933989  2018-08-31 13:33:14+00:00              1.0  \n",
       "933990  2018-08-31 18:38:49+00:00              2.0  \n",
       "933991  2018-08-31 22:54:09+00:00              2.0  \n",
       "\n",
       "[933992 rows x 42 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged_watch"
   ]
  }
 ],
 "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}