Groupme+EDA_raw.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Import Groupme JSON into Normalized Pandas DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import scipy.stats as st\n",
    "import numpy as np\n",
    "import json\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "%matplotlib notebook\n",
    "%matplotlib inline\n",
    "plt.style.use\n",
    "plt.rcParams['figure.figsize'] = (15, 10)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# normalize the json into a df. \n",
    "with open('message.json') as data:\n",
    "    dump = json.load(data)\n",
    "    df = json_normalize(dump)\n",
    "    \n",
    "# send df to csv for Mike. \n",
    "df.to_csv('groupme_raw.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>attachments</th>\n",
       "      <th>avatar_url</th>\n",
       "      <th>created_at</th>\n",
       "      <th>event.data.added_users</th>\n",
       "      <th>event.data.adder_user.id</th>\n",
       "      <th>event.data.adder_user.nickname</th>\n",
       "      <th>event.data.avatar_url</th>\n",
       "      <th>event.data.conversation.id</th>\n",
       "      <th>event.data.name</th>\n",
       "      <th>event.data.options</th>\n",
       "      <th>...</th>\n",
       "      <th>favorited_by</th>\n",
       "      <th>group_id</th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>sender_id</th>\n",
       "      <th>sender_type</th>\n",
       "      <th>source_guid</th>\n",
       "      <th>system</th>\n",
       "      <th>text</th>\n",
       "      <th>user_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/972x1296.jpeg.e5d92f11ad...</td>\n",
       "      <td>1532891142</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>[15598303, 21309246]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153289114263245359</td>\n",
       "      <td>Taylor Combs</td>\n",
       "      <td>20656068</td>\n",
       "      <td>user</td>\n",
       "      <td>android-40213835-b73b-488f-9b9b-af9d624d750b</td>\n",
       "      <td>False</td>\n",
       "      <td>idk if anyone else here has a hammock but I'm ...</td>\n",
       "      <td>20656068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/676x676.jpeg.1a95ae8658a...</td>\n",
       "      <td>1532889926</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288992655626166</td>\n",
       "      <td>Simbi Akanni</td>\n",
       "      <td>6601670</td>\n",
       "      <td>user</td>\n",
       "      <td>DDE8ABC0-191D-4803-84E2-F00D7D2B2A89</td>\n",
       "      <td>False</td>\n",
       "      <td>Quick MoGo Trip to jolly pumpkin anyone?</td>\n",
       "      <td>6601670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.a1a31c8e2b8...</td>\n",
       "      <td>1532889236</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>[11747595, 12671871, 13102679, 15598303, 20602...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288923674335151</td>\n",
       "      <td>Jacqueline Trager</td>\n",
       "      <td>5929297</td>\n",
       "      <td>user</td>\n",
       "      <td>cbeee56453623ccddcc852d3eea8d5e7</td>\n",
       "      <td>False</td>\n",
       "      <td>Hi friends, my challenge group and I were talk...</td>\n",
       "      <td>5929297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[{'loci': [[0, 13]], 'type': 'mentions', 'user...</td>\n",
       "      <td>https://i.groupme.com/200x215.jpeg.c7c78374a95...</td>\n",
       "      <td>1532889048</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288904888931045</td>\n",
       "      <td>Akhil Aniff</td>\n",
       "      <td>21685515</td>\n",
       "      <td>user</td>\n",
       "      <td>FB1736EF-175B-44D4-A8F0-3AE26D945C4E</td>\n",
       "      <td>False</td>\n",
       "      <td>@Julia Kelley</td>\n",
       "      <td>21685515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/200x215.jpeg.c7c78374a95...</td>\n",
       "      <td>1532889044</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288904496343131</td>\n",
       "      <td>Akhil Aniff</td>\n",
       "      <td>21685515</td>\n",
       "      <td>user</td>\n",
       "      <td>9ECFFBB4-37A6-408C-B82F-3BF02283F760</td>\n",
       "      <td>False</td>\n",
       "      <td>Is there any juice left?</td>\n",
       "      <td>21685515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[{'loci': [[2, 13]], 'type': 'mentions', 'user...</td>\n",
       "      <td>https://i.groupme.com/1024x1024.jpeg.58333b264...</td>\n",
       "      <td>1532888464</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>[25267735]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288846477758488</td>\n",
       "      <td>British James</td>\n",
       "      <td>13288142</td>\n",
       "      <td>user</td>\n",
       "      <td>B524A6A9-40CD-4E78-96D9-B5849A881F88</td>\n",
       "      <td>False</td>\n",
       "      <td>^ @Julia Kelley</td>\n",
       "      <td>13288142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/1017x784.jpeg.001b9ea0f7...</td>\n",
       "      <td>1532888223</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288822304036875</td>\n",
       "      <td>Lydia Dick</td>\n",
       "      <td>20615984</td>\n",
       "      <td>user</td>\n",
       "      <td>8BBB6740-C016-43B2-B640-403E459B3142</td>\n",
       "      <td>False</td>\n",
       "      <td>Reminder to dm me if you’re interested in a ve...</td>\n",
       "      <td>20615984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.3a44fe250dd...</td>\n",
       "      <td>1532888188</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288818856768392</td>\n",
       "      <td>Rachel Krasnick</td>\n",
       "      <td>2221108</td>\n",
       "      <td>user</td>\n",
       "      <td>AD0501C0-B548-44D8-81F4-E5DCD886DFB4</td>\n",
       "      <td>False</td>\n",
       "      <td>^^ yes and if I can bring anything pls lmk!!</td>\n",
       "      <td>2221108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/640x640.jpeg.51ceabef6de...</td>\n",
       "      <td>1532888149</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>[10370140, 10456773, 11747595, 12671871, 13353...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288814954720902</td>\n",
       "      <td>Vaughn Hunt</td>\n",
       "      <td>14422702</td>\n",
       "      <td>user</td>\n",
       "      <td>6C9F7A61-4C88-450A-AFD8-EF1180A5F579</td>\n",
       "      <td>False</td>\n",
       "      <td>Yo, to all the peeps cooking tonight, post the...</td>\n",
       "      <td>14422702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/1080x1920.png.b9b097c4a2...</td>\n",
       "      <td>1532888089</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>[20602202]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288808911706771</td>\n",
       "      <td>Martin Valkov</td>\n",
       "      <td>21542974</td>\n",
       "      <td>user</td>\n",
       "      <td>android-274bc17f-469f-47b1-8b56-60310e25bddc</td>\n",
       "      <td>False</td>\n",
       "      <td>Anyone wanna kick a ball around?</td>\n",
       "      <td>21542974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[{'loci': [[0, 14]], 'type': 'mentions', 'user...</td>\n",
       "      <td>https://i.groupme.com/1024x899.jpeg.722870f97c...</td>\n",
       "      <td>1532885997</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>[15598303, 20906892, 21466701, 58147098]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288599758928392</td>\n",
       "      <td>Molly Oretsky</td>\n",
       "      <td>9670428</td>\n",
       "      <td>user</td>\n",
       "      <td>6EF20434-B800-412F-9CA0-5E2A5DA04AA6</td>\n",
       "      <td>False</td>\n",
       "      <td>@Lydia Zaleski And I are gonna walk around dow...</td>\n",
       "      <td>9670428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/1022x1024.jpeg.f0ed13087...</td>\n",
       "      <td>1532885331</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>[21309246, 3878626, 46686457]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288533167955359</td>\n",
       "      <td>Will Miller</td>\n",
       "      <td>19535672</td>\n",
       "      <td>user</td>\n",
       "      <td>B953E9F7-D9F9-4F9D-B0DA-B7CD92CA9A6C</td>\n",
       "      <td>False</td>\n",
       "      <td>Sign up with Bird and use code OXRQYP to get a...</td>\n",
       "      <td>19535672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/2624x1476.jpeg.0589bc93f...</td>\n",
       "      <td>1532884864</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>[13288142]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288486406481456</td>\n",
       "      <td>Sean Lynch</td>\n",
       "      <td>10456773</td>\n",
       "      <td>user</td>\n",
       "      <td>android-79f00fd9-6e1d-42d3-bdf3-f742bb97ec59</td>\n",
       "      <td>False</td>\n",
       "      <td>Anyone at Eastern Market rn?</td>\n",
       "      <td>10456773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[{'loci': [[0, 12]], 'type': 'mentions', 'user...</td>\n",
       "      <td>https://i.groupme.com/748x580.jpeg.d5f4bddfb72...</td>\n",
       "      <td>1532884510</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>[20615984]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288451044292597</td>\n",
       "      <td>Harrison Lioce</td>\n",
       "      <td>6444591</td>\n",
       "      <td>user</td>\n",
       "      <td>A8E5281F-C9D2-4768-AB70-F4BD390951D0</td>\n",
       "      <td>False</td>\n",
       "      <td>@Dan Bardach And I are going to grab food (not...</td>\n",
       "      <td>6444591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.5a48db6c1fe...</td>\n",
       "      <td>1532884151</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>[10364985, 17446781, 46686457]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288415175561045</td>\n",
       "      <td>Apurva Kasam</td>\n",
       "      <td>18172472</td>\n",
       "      <td>user</td>\n",
       "      <td>0362CD85-304C-414D-BFC4-50719622E403</td>\n",
       "      <td>False</td>\n",
       "      <td>Our role based group leader (PJ) told us yeste...</td>\n",
       "      <td>18172472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/638x638.jpeg.6e105d64370...</td>\n",
       "      <td>1532884119</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288411976383833</td>\n",
       "      <td>William Martin</td>\n",
       "      <td>23239728</td>\n",
       "      <td>user</td>\n",
       "      <td>android-98f879c3-d6a1-4b1e-90e0-a6142b77ac89</td>\n",
       "      <td>False</td>\n",
       "      <td>Who discovered #buttcon?</td>\n",
       "      <td>23239728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1532883452</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://i.groupme.com/720x722.jpeg.9914c07b539...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[18172472, 20656068, 20877694]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288345206776900</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>686cf870757e0136705e22000ab9dacd</td>\n",
       "      <td>True</td>\n",
       "      <td>Michele changed the group's avatar</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[{'type': 'image', 'url': 'https://i.groupme.c...</td>\n",
       "      <td>https://i.groupme.com/640x640.jpeg.6417f9cdb68...</td>\n",
       "      <td>1532883431</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>[14950174, 18885373, 21685515, 33123627, 9195374]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288343184583231</td>\n",
       "      <td>Micky Wolf</td>\n",
       "      <td>14950174</td>\n",
       "      <td>user</td>\n",
       "      <td>7CF5F129-DF99-437C-A769-713ECA6FCCAC</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14950174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[{'type': 'image', 'url': 'https://i.groupme.c...</td>\n",
       "      <td>https://i.groupme.com/1024x1024.jpeg.6a664ccc8...</td>\n",
       "      <td>1532883357</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>[14950174, 17446781, 18172472, 19891783, 20985...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288335790920014</td>\n",
       "      <td>Julia Kelley</td>\n",
       "      <td>21121405</td>\n",
       "      <td>user</td>\n",
       "      <td>4686012E-3931-4421-8AD8-2FDDC73C6107</td>\n",
       "      <td>False</td>\n",
       "      <td>Free juice in the 3rd floor lounge!\\n 🍓🍈🍊🥤</td>\n",
       "      <td>21121405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[{'loci': [[0, 13], [14, 8]], 'type': 'mention...</td>\n",
       "      <td>https://i.groupme.com/972x1296.jpeg.e5d92f11ad...</td>\n",
       "      <td>1532883236</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>[20858917, 21309246]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288323664878045</td>\n",
       "      <td>Taylor Combs</td>\n",
       "      <td>20656068</td>\n",
       "      <td>user</td>\n",
       "      <td>android-7d6c2637-56de-4357-89a2-9eec8c7c8006</td>\n",
       "      <td>False</td>\n",
       "      <td>@Grayson Wise @Michele how did we ever survive...</td>\n",
       "      <td>20656068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/748x556.jpeg.f4a799e9156...</td>\n",
       "      <td>1532883021</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>[11179662, 11747595, 16632019, 17446781, 18794...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288302140333131</td>\n",
       "      <td>Grant Steinhauer</td>\n",
       "      <td>20843407</td>\n",
       "      <td>user</td>\n",
       "      <td>3261056e9cab508bfa93150b67513a8f</td>\n",
       "      <td>False</td>\n",
       "      <td>That was sent in confidence!</td>\n",
       "      <td>20843407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>[{'type': 'image', 'url': 'https://i.groupme.c...</td>\n",
       "      <td>https://i.groupme.com/4d9241f034970131420b2200...</td>\n",
       "      <td>1532882410</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>[10234636, 10370140, 10370473, 11179662, 11747...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288241048491045</td>\n",
       "      <td>Emma Montgomery</td>\n",
       "      <td>13353835</td>\n",
       "      <td>user</td>\n",
       "      <td>58D04394-101C-45B7-829B-7990718997DA</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13353835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.ddc142d719f...</td>\n",
       "      <td>1532882290</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288229055103231</td>\n",
       "      <td>Nick Rafferty</td>\n",
       "      <td>20757944</td>\n",
       "      <td>user</td>\n",
       "      <td>620774E7-9551-4D46-B833-BD18758C082B</td>\n",
       "      <td>False</td>\n",
       "      <td>Does anyone have a large pot???</td>\n",
       "      <td>20757944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>[{'loci': [[77, 13], [111, 10], [123, 14]], 't...</td>\n",
       "      <td>https://i.groupme.com/3264x2448.jpeg.c71719e2d...</td>\n",
       "      <td>1532881885</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>[15000743, 16180042, 17655019, 2055911, 207071...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288188503993744</td>\n",
       "      <td>K Rumburg</td>\n",
       "      <td>9195374</td>\n",
       "      <td>user</td>\n",
       "      <td>223A3B31-F0B1-44F3-9B55-1C72A8D54B80</td>\n",
       "      <td>False</td>\n",
       "      <td>Growth mindset gurus! Personal finance worksho...</td>\n",
       "      <td>9195374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/1024x1024.jpeg.6a664ccc8...</td>\n",
       "      <td>1532881633</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288163363748392</td>\n",
       "      <td>Julia Kelley</td>\n",
       "      <td>21121405</td>\n",
       "      <td>user</td>\n",
       "      <td>4738132D-CD2E-4AA0-8FE2-803B992AFE5F</td>\n",
       "      <td>False</td>\n",
       "      <td>Heading back from brunch...will text when I’m ...</td>\n",
       "      <td>21121405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>[{'type': 'image', 'url': 'https://i.groupme.c...</td>\n",
       "      <td>https://i.groupme.com/1022x1024.jpeg.f0ed13087...</td>\n",
       "      <td>1532881192</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>[10234636, 11179662, 13132655, 13713979, 18885...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288119252770014</td>\n",
       "      <td>Will Miller</td>\n",
       "      <td>19535672</td>\n",
       "      <td>user</td>\n",
       "      <td>88490E22-5666-4CC4-B79A-D1AAFB9A3A49</td>\n",
       "      <td>False</td>\n",
       "      <td>Lets fly</td>\n",
       "      <td>19535672</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.32c1104a6ac...</td>\n",
       "      <td>1532881009</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>[21068718, 23191339]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288100936060194</td>\n",
       "      <td>Eliana Drescher</td>\n",
       "      <td>10053824</td>\n",
       "      <td>user</td>\n",
       "      <td>5FCF1A3B-816B-44D8-8434-D7872B2A66C5</td>\n",
       "      <td>False</td>\n",
       "      <td>If any low -pexers/hangry fellows wanna join m...</td>\n",
       "      <td>10053824</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1532880823</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://i.groupme.com/848x965.jpeg.2bf1bfd689c...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[17446781, 20758467]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288082315013231</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>4977fc3075780136728722000ab9650c</td>\n",
       "      <td>True</td>\n",
       "      <td>Cooper Temple changed the group's avatar</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>[{'type': 'image', 'url': 'https://i.groupme.c...</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.f683cfd990d...</td>\n",
       "      <td>1532880524</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>[11886065, 12723262, 14861500, 16093955, 18885...</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153288052459709988</td>\n",
       "      <td>Eric Zhang</td>\n",
       "      <td>33306533</td>\n",
       "      <td>user</td>\n",
       "      <td>7e27807d9b67019b706ba72be8a494bd</td>\n",
       "      <td>False</td>\n",
       "      <td>This is what I think of whenever you guys go #...</td>\n",
       "      <td>33306533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/750x750.jpeg.26f259e87eb...</td>\n",
       "      <td>1532879878</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>[14870085, 18885373, 20858917, 21309246]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153287987832388488</td>\n",
       "      <td>Nico Krachenfels</td>\n",
       "      <td>19848740</td>\n",
       "      <td>user</td>\n",
       "      <td>25A6F229-CE65-4B76-B79D-6D62B6168905</td>\n",
       "      <td>False</td>\n",
       "      <td>Let’s fly baby</td>\n",
       "      <td>19848740</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>4353</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/748x750.jpeg.af895ab1075...</td>\n",
       "      <td>1530314775</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>[20806675]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153031477573714304</td>\n",
       "      <td>Abrar Tanveer</td>\n",
       "      <td>14870085</td>\n",
       "      <td>user</td>\n",
       "      <td>C0CE3A69-B2C0-41F3-AF3D-02F043065B50</td>\n",
       "      <td>False</td>\n",
       "      <td>Can we see the place?</td>\n",
       "      <td>14870085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4354</th>\n",
       "      <td>[]</td>\n",
       "      <td>https://i.groupme.com/1024x1024.jpeg.6fdca83f3...</td>\n",
       "      <td>1530314570</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153031457070296625</td>\n",
       "      <td>Marc Bielas</td>\n",
       "      <td>11747595</td>\n",
       "      <td>user</td>\n",
       "      <td>3FC99ABB-5F33-431E-A5F2-58691321764C</td>\n",
       "      <td>False</td>\n",
       "      <td>I booked the place and we’ll have a grill - if...</td>\n",
       "      <td>11747595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4355</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530312966</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153031296613631533</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>876acf105e1d0136727522000ab9650c</td>\n",
       "      <td>True</td>\n",
       "      <td>Marc Bielas has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4356</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530312942</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153031294220806821</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>7927a3e05e1d0136f87122000b78906f</td>\n",
       "      <td>True</td>\n",
       "      <td>Micky Wolf has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4357</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530311867</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153031186748069846</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>f89143005e1a013638cb22000b99a321</td>\n",
       "      <td>True</td>\n",
       "      <td>Ashwin Puri has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4358</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530308628</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030862844056058</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>6df2f5605e1301368ac922000b6a8482</td>\n",
       "      <td>True</td>\n",
       "      <td>Lily Wilson has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4359</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530308434</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030843435962722</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>fa4491905e12013626e022000aa74b07</td>\n",
       "      <td>True</td>\n",
       "      <td>Shea Fallick has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4360</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530307112</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030711292475238</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>e6a199505e0f0136cfc722000a45211c</td>\n",
       "      <td>True</td>\n",
       "      <td>Gaby Nair has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4361</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530306044</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030604476435827</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>69f542705e0d0136d66e22000bd8a0b6</td>\n",
       "      <td>True</td>\n",
       "      <td>Daniel Miller has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4362</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530305210</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030521092451039</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>78f368a05e0b0136534722000bc1838d</td>\n",
       "      <td>True</td>\n",
       "      <td>Exia Burns has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4363</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530305079</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030507956535844</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>2aa794d05e0b0136978822000a71d1ae</td>\n",
       "      <td>True</td>\n",
       "      <td>Henry Joyce has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4364</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530304534</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030453472076294</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>e5e6e4405e09013659c422000b9ec5ef</td>\n",
       "      <td>True</td>\n",
       "      <td>Hayden Cohen has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4365</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530304413</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030441394366055</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>9de9c4005e0901368a8722000b6d8861</td>\n",
       "      <td>True</td>\n",
       "      <td>Daisy Claire Homolka has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4366</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530303505</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030350557726055</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>807c0de05e0701368a8722000b6d8861</td>\n",
       "      <td>True</td>\n",
       "      <td>Samuel Gardner has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4367</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530302013</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030201335891998</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>070d9e705e040136b6d922000b698c65</td>\n",
       "      <td>True</td>\n",
       "      <td>Betsy Yang has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4368</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530301607</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030160724987511</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>14fe48405e030136607322000b2304c6</td>\n",
       "      <td>True</td>\n",
       "      <td>Luke Wasynczuk has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4369</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530301468</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030146842902096</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>c23fe8205e02013605d622000b51975d</td>\n",
       "      <td>True</td>\n",
       "      <td>Lindsay Buckel has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4370</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530300507</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030050779264304</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>85aa6f905e000136a80622000b3109a3</td>\n",
       "      <td>True</td>\n",
       "      <td>Serena Thomas has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4371</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530300487</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153030048783263487</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>79c4c5405e00013641c022000a71bcf2</td>\n",
       "      <td>True</td>\n",
       "      <td>Apurva Kasam has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4372</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530299790</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029979011336055</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>d9e544105dfe01368a8722000b6d8861</td>\n",
       "      <td>True</td>\n",
       "      <td>Monica Nimmagadda has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4373</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530299611</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029961158894304</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>6f7c98d05dfe0136a80622000b3109a3</td>\n",
       "      <td>True</td>\n",
       "      <td>Rosalie Reuss has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4374</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530299324</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029932417265893</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>c42c58f05dfd0136eaa522000bf8e41a</td>\n",
       "      <td>True</td>\n",
       "      <td>Cooper Temple has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4375</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530298281</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029828197925238</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>56fa42d05dfb0136cfc722000a45211c</td>\n",
       "      <td>True</td>\n",
       "      <td>Gabby Kirlew has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4376</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530297580</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029758058425837</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>b4e9e1905df90136e7bc22000b8809e1</td>\n",
       "      <td>True</td>\n",
       "      <td>Elianna Goldstein has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4377</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530297019</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029701944170281</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>667254405df8013606b422000ae1953d</td>\n",
       "      <td>True</td>\n",
       "      <td>Jason Chato has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4378</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530296946</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029694638526294</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>3ae6ca505df8013659c422000b9ec5ef</td>\n",
       "      <td>True</td>\n",
       "      <td>Jackson Steger has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4379</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530296852</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029685202521653</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>02a897405df8013642d422000b0b86e7</td>\n",
       "      <td>True</td>\n",
       "      <td>Reagan Cline has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4380</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530296784</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029678419545995</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>da3a94b05df70136600e22000ba9801a</td>\n",
       "      <td>True</td>\n",
       "      <td>Lydia Zaleski has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4381</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530296754</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>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029675451539846</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>c889c3305df7013638cb22000b99a321</td>\n",
       "      <td>True</td>\n",
       "      <td>Robbie Dornbush has joined the group</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4382</th>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1530296680</td>\n",
       "      <td>[{'id': 19891783, 'nickname': 'Noah Quinn'}, {...</td>\n",
       "      <td>14870085.0</td>\n",
       "      <td>Abrar Tanveer</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>41772366</td>\n",
       "      <td>153029668034140281</td>\n",
       "      <td>GroupMe</td>\n",
       "      <td>system</td>\n",
       "      <td>system</td>\n",
       "      <td>9c53ba005df7013606b422000ae1953d</td>\n",
       "      <td>True</td>\n",
       "      <td>Abrar Tanveer added Noah Quinn, Amir Patel, mi...</td>\n",
       "      <td>system</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4383 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            attachments  \\\n",
       "0                                                    []   \n",
       "1                                                    []   \n",
       "2                                                    []   \n",
       "3     [{'loci': [[0, 13]], 'type': 'mentions', 'user...   \n",
       "4                                                    []   \n",
       "5     [{'loci': [[2, 13]], 'type': 'mentions', 'user...   \n",
       "6                                                    []   \n",
       "7                                                    []   \n",
       "8                                                    []   \n",
       "9                                                    []   \n",
       "10    [{'loci': [[0, 14]], 'type': 'mentions', 'user...   \n",
       "11                                                   []   \n",
       "12                                                   []   \n",
       "13    [{'loci': [[0, 12]], 'type': 'mentions', 'user...   \n",
       "14                                                   []   \n",
       "15                                                   []   \n",
       "16                                                   []   \n",
       "17    [{'type': 'image', 'url': 'https://i.groupme.c...   \n",
       "18    [{'type': 'image', 'url': 'https://i.groupme.c...   \n",
       "19    [{'loci': [[0, 13], [14, 8]], 'type': 'mention...   \n",
       "20                                                   []   \n",
       "21    [{'type': 'image', 'url': 'https://i.groupme.c...   \n",
       "22                                                   []   \n",
       "23    [{'loci': [[77, 13], [111, 10], [123, 14]], 't...   \n",
       "24                                                   []   \n",
       "25    [{'type': 'image', 'url': 'https://i.groupme.c...   \n",
       "26                                                   []   \n",
       "27                                                   []   \n",
       "28    [{'type': 'image', 'url': 'https://i.groupme.c...   \n",
       "29                                                   []   \n",
       "...                                                 ...   \n",
       "4353                                                 []   \n",
       "4354                                                 []   \n",
       "4355                                                 []   \n",
       "4356                                                 []   \n",
       "4357                                                 []   \n",
       "4358                                                 []   \n",
       "4359                                                 []   \n",
       "4360                                                 []   \n",
       "4361                                                 []   \n",
       "4362                                                 []   \n",
       "4363                                                 []   \n",
       "4364                                                 []   \n",
       "4365                                                 []   \n",
       "4366                                                 []   \n",
       "4367                                                 []   \n",
       "4368                                                 []   \n",
       "4369                                                 []   \n",
       "4370                                                 []   \n",
       "4371                                                 []   \n",
       "4372                                                 []   \n",
       "4373                                                 []   \n",
       "4374                                                 []   \n",
       "4375                                                 []   \n",
       "4376                                                 []   \n",
       "4377                                                 []   \n",
       "4378                                                 []   \n",
       "4379                                                 []   \n",
       "4380                                                 []   \n",
       "4381                                                 []   \n",
       "4382                                                 []   \n",
       "\n",
       "                                             avatar_url  created_at  \\\n",
       "0     https://i.groupme.com/972x1296.jpeg.e5d92f11ad...  1532891142   \n",
       "1     https://i.groupme.com/676x676.jpeg.1a95ae8658a...  1532889926   \n",
       "2     https://i.groupme.com/750x750.jpeg.a1a31c8e2b8...  1532889236   \n",
       "3     https://i.groupme.com/200x215.jpeg.c7c78374a95...  1532889048   \n",
       "4     https://i.groupme.com/200x215.jpeg.c7c78374a95...  1532889044   \n",
       "5     https://i.groupme.com/1024x1024.jpeg.58333b264...  1532888464   \n",
       "6     https://i.groupme.com/1017x784.jpeg.001b9ea0f7...  1532888223   \n",
       "7     https://i.groupme.com/750x750.jpeg.3a44fe250dd...  1532888188   \n",
       "8     https://i.groupme.com/640x640.jpeg.51ceabef6de...  1532888149   \n",
       "9     https://i.groupme.com/1080x1920.png.b9b097c4a2...  1532888089   \n",
       "10    https://i.groupme.com/1024x899.jpeg.722870f97c...  1532885997   \n",
       "11    https://i.groupme.com/1022x1024.jpeg.f0ed13087...  1532885331   \n",
       "12    https://i.groupme.com/2624x1476.jpeg.0589bc93f...  1532884864   \n",
       "13    https://i.groupme.com/748x580.jpeg.d5f4bddfb72...  1532884510   \n",
       "14    https://i.groupme.com/750x750.jpeg.5a48db6c1fe...  1532884151   \n",
       "15    https://i.groupme.com/638x638.jpeg.6e105d64370...  1532884119   \n",
       "16                                                  NaN  1532883452   \n",
       "17    https://i.groupme.com/640x640.jpeg.6417f9cdb68...  1532883431   \n",
       "18    https://i.groupme.com/1024x1024.jpeg.6a664ccc8...  1532883357   \n",
       "19    https://i.groupme.com/972x1296.jpeg.e5d92f11ad...  1532883236   \n",
       "20    https://i.groupme.com/748x556.jpeg.f4a799e9156...  1532883021   \n",
       "21    https://i.groupme.com/4d9241f034970131420b2200...  1532882410   \n",
       "22    https://i.groupme.com/750x750.jpeg.ddc142d719f...  1532882290   \n",
       "23    https://i.groupme.com/3264x2448.jpeg.c71719e2d...  1532881885   \n",
       "24    https://i.groupme.com/1024x1024.jpeg.6a664ccc8...  1532881633   \n",
       "25    https://i.groupme.com/1022x1024.jpeg.f0ed13087...  1532881192   \n",
       "26    https://i.groupme.com/750x750.jpeg.32c1104a6ac...  1532881009   \n",
       "27                                                  NaN  1532880823   \n",
       "28    https://i.groupme.com/750x750.jpeg.f683cfd990d...  1532880524   \n",
       "29    https://i.groupme.com/750x750.jpeg.26f259e87eb...  1532879878   \n",
       "...                                                 ...         ...   \n",
       "4353  https://i.groupme.com/748x750.jpeg.af895ab1075...  1530314775   \n",
       "4354  https://i.groupme.com/1024x1024.jpeg.6fdca83f3...  1530314570   \n",
       "4355                                                NaN  1530312966   \n",
       "4356                                                NaN  1530312942   \n",
       "4357                                                NaN  1530311867   \n",
       "4358                                                NaN  1530308628   \n",
       "4359                                                NaN  1530308434   \n",
       "4360                                                NaN  1530307112   \n",
       "4361                                                NaN  1530306044   \n",
       "4362                                                NaN  1530305210   \n",
       "4363                                                NaN  1530305079   \n",
       "4364                                                NaN  1530304534   \n",
       "4365                                                NaN  1530304413   \n",
       "4366                                                NaN  1530303505   \n",
       "4367                                                NaN  1530302013   \n",
       "4368                                                NaN  1530301607   \n",
       "4369                                                NaN  1530301468   \n",
       "4370                                                NaN  1530300507   \n",
       "4371                                                NaN  1530300487   \n",
       "4372                                                NaN  1530299790   \n",
       "4373                                                NaN  1530299611   \n",
       "4374                                                NaN  1530299324   \n",
       "4375                                                NaN  1530298281   \n",
       "4376                                                NaN  1530297580   \n",
       "4377                                                NaN  1530297019   \n",
       "4378                                                NaN  1530296946   \n",
       "4379                                                NaN  1530296852   \n",
       "4380                                                NaN  1530296784   \n",
       "4381                                                NaN  1530296754   \n",
       "4382                                                NaN  1530296680   \n",
       "\n",
       "                                 event.data.added_users  \\\n",
       "0                                                   NaN   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "5                                                   NaN   \n",
       "6                                                   NaN   \n",
       "7                                                   NaN   \n",
       "8                                                   NaN   \n",
       "9                                                   NaN   \n",
       "10                                                  NaN   \n",
       "11                                                  NaN   \n",
       "12                                                  NaN   \n",
       "13                                                  NaN   \n",
       "14                                                  NaN   \n",
       "15                                                  NaN   \n",
       "16                                                  NaN   \n",
       "17                                                  NaN   \n",
       "18                                                  NaN   \n",
       "19                                                  NaN   \n",
       "20                                                  NaN   \n",
       "21                                                  NaN   \n",
       "22                                                  NaN   \n",
       "23                                                  NaN   \n",
       "24                                                  NaN   \n",
       "25                                                  NaN   \n",
       "26                                                  NaN   \n",
       "27                                                  NaN   \n",
       "28                                                  NaN   \n",
       "29                                                  NaN   \n",
       "...                                                 ...   \n",
       "4353                                                NaN   \n",
       "4354                                                NaN   \n",
       "4355                                                NaN   \n",
       "4356                                                NaN   \n",
       "4357                                                NaN   \n",
       "4358                                                NaN   \n",
       "4359                                                NaN   \n",
       "4360                                                NaN   \n",
       "4361                                                NaN   \n",
       "4362                                                NaN   \n",
       "4363                                                NaN   \n",
       "4364                                                NaN   \n",
       "4365                                                NaN   \n",
       "4366                                                NaN   \n",
       "4367                                                NaN   \n",
       "4368                                                NaN   \n",
       "4369                                                NaN   \n",
       "4370                                                NaN   \n",
       "4371                                                NaN   \n",
       "4372                                                NaN   \n",
       "4373                                                NaN   \n",
       "4374                                                NaN   \n",
       "4375                                                NaN   \n",
       "4376                                                NaN   \n",
       "4377                                                NaN   \n",
       "4378                                                NaN   \n",
       "4379                                                NaN   \n",
       "4380                                                NaN   \n",
       "4381                                                NaN   \n",
       "4382  [{'id': 19891783, 'nickname': 'Noah Quinn'}, {...   \n",
       "\n",
       "      event.data.adder_user.id event.data.adder_user.nickname  \\\n",
       "0                          NaN                            NaN   \n",
       "1                          NaN                            NaN   \n",
       "2                          NaN                            NaN   \n",
       "3                          NaN                            NaN   \n",
       "4                          NaN                            NaN   \n",
       "5                          NaN                            NaN   \n",
       "6                          NaN                            NaN   \n",
       "7                          NaN                            NaN   \n",
       "8                          NaN                            NaN   \n",
       "9                          NaN                            NaN   \n",
       "10                         NaN                            NaN   \n",
       "11                         NaN                            NaN   \n",
       "12                         NaN                            NaN   \n",
       "13                         NaN                            NaN   \n",
       "14                         NaN                            NaN   \n",
       "15                         NaN                            NaN   \n",
       "16                         NaN                            NaN   \n",
       "17                         NaN                            NaN   \n",
       "18                         NaN                            NaN   \n",
       "19                         NaN                            NaN   \n",
       "20                         NaN                            NaN   \n",
       "21                         NaN                            NaN   \n",
       "22                         NaN                            NaN   \n",
       "23                         NaN                            NaN   \n",
       "24                         NaN                            NaN   \n",
       "25                         NaN                            NaN   \n",
       "26                         NaN                            NaN   \n",
       "27                         NaN                            NaN   \n",
       "28                         NaN                            NaN   \n",
       "29                         NaN                            NaN   \n",
       "...                        ...                            ...   \n",
       "4353                       NaN                            NaN   \n",
       "4354                       NaN                            NaN   \n",
       "4355                       NaN                            NaN   \n",
       "4356                       NaN                            NaN   \n",
       "4357                       NaN                            NaN   \n",
       "4358                       NaN                            NaN   \n",
       "4359                       NaN                            NaN   \n",
       "4360                       NaN                            NaN   \n",
       "4361                       NaN                            NaN   \n",
       "4362                       NaN                            NaN   \n",
       "4363                       NaN                            NaN   \n",
       "4364                       NaN                            NaN   \n",
       "4365                       NaN                            NaN   \n",
       "4366                       NaN                            NaN   \n",
       "4367                       NaN                            NaN   \n",
       "4368                       NaN                            NaN   \n",
       "4369                       NaN                            NaN   \n",
       "4370                       NaN                            NaN   \n",
       "4371                       NaN                            NaN   \n",
       "4372                       NaN                            NaN   \n",
       "4373                       NaN                            NaN   \n",
       "4374                       NaN                            NaN   \n",
       "4375                       NaN                            NaN   \n",
       "4376                       NaN                            NaN   \n",
       "4377                       NaN                            NaN   \n",
       "4378                       NaN                            NaN   \n",
       "4379                       NaN                            NaN   \n",
       "4380                       NaN                            NaN   \n",
       "4381                       NaN                            NaN   \n",
       "4382                14870085.0                  Abrar Tanveer   \n",
       "\n",
       "                                  event.data.avatar_url  \\\n",
       "0                                                   NaN   \n",
       "1                                                   NaN   \n",
       "2                                                   NaN   \n",
       "3                                                   NaN   \n",
       "4                                                   NaN   \n",
       "5                                                   NaN   \n",
       "6                                                   NaN   \n",
       "7                                                   NaN   \n",
       "8                                                   NaN   \n",
       "9                                                   NaN   \n",
       "10                                                  NaN   \n",
       "11                                                  NaN   \n",
       "12                                                  NaN   \n",
       "13                                                  NaN   \n",
       "14                                                  NaN   \n",
       "15                                                  NaN   \n",
       "16    https://i.groupme.com/720x722.jpeg.9914c07b539...   \n",
       "17                                                  NaN   \n",
       "18                                                  NaN   \n",
       "19                                                  NaN   \n",
       "20                                                  NaN   \n",
       "21                                                  NaN   \n",
       "22                                                  NaN   \n",
       "23                                                  NaN   \n",
       "24                                                  NaN   \n",
       "25                                                  NaN   \n",
       "26                                                  NaN   \n",
       "27    https://i.groupme.com/848x965.jpeg.2bf1bfd689c...   \n",
       "28                                                  NaN   \n",
       "29                                                  NaN   \n",
       "...                                                 ...   \n",
       "4353                                                NaN   \n",
       "4354                                                NaN   \n",
       "4355                                                NaN   \n",
       "4356                                                NaN   \n",
       "4357                                                NaN   \n",
       "4358                                                NaN   \n",
       "4359                                                NaN   \n",
       "4360                                                NaN   \n",
       "4361                                                NaN   \n",
       "4362                                                NaN   \n",
       "4363                                                NaN   \n",
       "4364                                                NaN   \n",
       "4365                                                NaN   \n",
       "4366                                                NaN   \n",
       "4367                                                NaN   \n",
       "4368                                                NaN   \n",
       "4369                                                NaN   \n",
       "4370                                                NaN   \n",
       "4371                                                NaN   \n",
       "4372                                                NaN   \n",
       "4373                                                NaN   \n",
       "4374                                                NaN   \n",
       "4375                                                NaN   \n",
       "4376                                                NaN   \n",
       "4377                                                NaN   \n",
       "4378                                                NaN   \n",
       "4379                                                NaN   \n",
       "4380                                                NaN   \n",
       "4381                                                NaN   \n",
       "4382                                                NaN   \n",
       "\n",
       "     event.data.conversation.id event.data.name event.data.options    ...     \\\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",
       "5                           NaN             NaN                NaN    ...      \n",
       "6                           NaN             NaN                NaN    ...      \n",
       "7                           NaN             NaN                NaN    ...      \n",
       "8                           NaN             NaN                NaN    ...      \n",
       "9                           NaN             NaN                NaN    ...      \n",
       "10                          NaN             NaN                NaN    ...      \n",
       "11                          NaN             NaN                NaN    ...      \n",
       "12                          NaN             NaN                NaN    ...      \n",
       "13                          NaN             NaN                NaN    ...      \n",
       "14                          NaN             NaN                NaN    ...      \n",
       "15                          NaN             NaN                NaN    ...      \n",
       "16                          NaN             NaN                NaN    ...      \n",
       "17                          NaN             NaN                NaN    ...      \n",
       "18                          NaN             NaN                NaN    ...      \n",
       "19                          NaN             NaN                NaN    ...      \n",
       "20                          NaN             NaN                NaN    ...      \n",
       "21                          NaN             NaN                NaN    ...      \n",
       "22                          NaN             NaN                NaN    ...      \n",
       "23                          NaN             NaN                NaN    ...      \n",
       "24                          NaN             NaN                NaN    ...      \n",
       "25                          NaN             NaN                NaN    ...      \n",
       "26                          NaN             NaN                NaN    ...      \n",
       "27                          NaN             NaN                NaN    ...      \n",
       "28                          NaN             NaN                NaN    ...      \n",
       "29                          NaN             NaN                NaN    ...      \n",
       "...                         ...             ...                ...    ...      \n",
       "4353                        NaN             NaN                NaN    ...      \n",
       "4354                        NaN             NaN                NaN    ...      \n",
       "4355                        NaN             NaN                NaN    ...      \n",
       "4356                        NaN             NaN                NaN    ...      \n",
       "4357                        NaN             NaN                NaN    ...      \n",
       "4358                        NaN             NaN                NaN    ...      \n",
       "4359                        NaN             NaN                NaN    ...      \n",
       "4360                        NaN             NaN                NaN    ...      \n",
       "4361                        NaN             NaN                NaN    ...      \n",
       "4362                        NaN             NaN                NaN    ...      \n",
       "4363                        NaN             NaN                NaN    ...      \n",
       "4364                        NaN             NaN                NaN    ...      \n",
       "4365                        NaN             NaN                NaN    ...      \n",
       "4366                        NaN             NaN                NaN    ...      \n",
       "4367                        NaN             NaN                NaN    ...      \n",
       "4368                        NaN             NaN                NaN    ...      \n",
       "4369                        NaN             NaN                NaN    ...      \n",
       "4370                        NaN             NaN                NaN    ...      \n",
       "4371                        NaN             NaN                NaN    ...      \n",
       "4372                        NaN             NaN                NaN    ...      \n",
       "4373                        NaN             NaN                NaN    ...      \n",
       "4374                        NaN             NaN                NaN    ...      \n",
       "4375                        NaN             NaN                NaN    ...      \n",
       "4376                        NaN             NaN                NaN    ...      \n",
       "4377                        NaN             NaN                NaN    ...      \n",
       "4378                        NaN             NaN                NaN    ...      \n",
       "4379                        NaN             NaN                NaN    ...      \n",
       "4380                        NaN             NaN                NaN    ...      \n",
       "4381                        NaN             NaN                NaN    ...      \n",
       "4382                        NaN             NaN                NaN    ...      \n",
       "\n",
       "                                           favorited_by  group_id  \\\n",
       "0                                  [15598303, 21309246]  41772366   \n",
       "1                                                    []  41772366   \n",
       "2     [11747595, 12671871, 13102679, 15598303, 20602...  41772366   \n",
       "3                                                    []  41772366   \n",
       "4                                                    []  41772366   \n",
       "5                                            [25267735]  41772366   \n",
       "6                                                    []  41772366   \n",
       "7                                                    []  41772366   \n",
       "8     [10370140, 10456773, 11747595, 12671871, 13353...  41772366   \n",
       "9                                            [20602202]  41772366   \n",
       "10             [15598303, 20906892, 21466701, 58147098]  41772366   \n",
       "11                        [21309246, 3878626, 46686457]  41772366   \n",
       "12                                           [13288142]  41772366   \n",
       "13                                           [20615984]  41772366   \n",
       "14                       [10364985, 17446781, 46686457]  41772366   \n",
       "15                                                   []  41772366   \n",
       "16                       [18172472, 20656068, 20877694]  41772366   \n",
       "17    [14950174, 18885373, 21685515, 33123627, 9195374]  41772366   \n",
       "18    [14950174, 17446781, 18172472, 19891783, 20985...  41772366   \n",
       "19                                 [20858917, 21309246]  41772366   \n",
       "20    [11179662, 11747595, 16632019, 17446781, 18794...  41772366   \n",
       "21    [10234636, 10370140, 10370473, 11179662, 11747...  41772366   \n",
       "22                                                   []  41772366   \n",
       "23    [15000743, 16180042, 17655019, 2055911, 207071...  41772366   \n",
       "24                                                   []  41772366   \n",
       "25    [10234636, 11179662, 13132655, 13713979, 18885...  41772366   \n",
       "26                                 [21068718, 23191339]  41772366   \n",
       "27                                 [17446781, 20758467]  41772366   \n",
       "28    [11886065, 12723262, 14861500, 16093955, 18885...  41772366   \n",
       "29             [14870085, 18885373, 20858917, 21309246]  41772366   \n",
       "...                                                 ...       ...   \n",
       "4353                                         [20806675]  41772366   \n",
       "4354                                                 []  41772366   \n",
       "4355                                                 []  41772366   \n",
       "4356                                                 []  41772366   \n",
       "4357                                                 []  41772366   \n",
       "4358                                                 []  41772366   \n",
       "4359                                                 []  41772366   \n",
       "4360                                                 []  41772366   \n",
       "4361                                                 []  41772366   \n",
       "4362                                                 []  41772366   \n",
       "4363                                                 []  41772366   \n",
       "4364                                                 []  41772366   \n",
       "4365                                                 []  41772366   \n",
       "4366                                                 []  41772366   \n",
       "4367                                                 []  41772366   \n",
       "4368                                                 []  41772366   \n",
       "4369                                                 []  41772366   \n",
       "4370                                                 []  41772366   \n",
       "4371                                                 []  41772366   \n",
       "4372                                                 []  41772366   \n",
       "4373                                                 []  41772366   \n",
       "4374                                                 []  41772366   \n",
       "4375                                                 []  41772366   \n",
       "4376                                                 []  41772366   \n",
       "4377                                                 []  41772366   \n",
       "4378                                                 []  41772366   \n",
       "4379                                                 []  41772366   \n",
       "4380                                                 []  41772366   \n",
       "4381                                                 []  41772366   \n",
       "4382                                                 []  41772366   \n",
       "\n",
       "                      id               name sender_id  sender_type  \\\n",
       "0     153289114263245359       Taylor Combs  20656068         user   \n",
       "1     153288992655626166       Simbi Akanni   6601670         user   \n",
       "2     153288923674335151  Jacqueline Trager   5929297         user   \n",
       "3     153288904888931045        Akhil Aniff  21685515         user   \n",
       "4     153288904496343131        Akhil Aniff  21685515         user   \n",
       "5     153288846477758488      British James  13288142         user   \n",
       "6     153288822304036875         Lydia Dick  20615984         user   \n",
       "7     153288818856768392    Rachel Krasnick   2221108         user   \n",
       "8     153288814954720902        Vaughn Hunt  14422702         user   \n",
       "9     153288808911706771      Martin Valkov  21542974         user   \n",
       "10    153288599758928392      Molly Oretsky   9670428         user   \n",
       "11    153288533167955359        Will Miller  19535672         user   \n",
       "12    153288486406481456         Sean Lynch  10456773         user   \n",
       "13    153288451044292597     Harrison Lioce   6444591         user   \n",
       "14    153288415175561045       Apurva Kasam  18172472         user   \n",
       "15    153288411976383833     William Martin  23239728         user   \n",
       "16    153288345206776900            GroupMe    system       system   \n",
       "17    153288343184583231         Micky Wolf  14950174         user   \n",
       "18    153288335790920014       Julia Kelley  21121405         user   \n",
       "19    153288323664878045       Taylor Combs  20656068         user   \n",
       "20    153288302140333131   Grant Steinhauer  20843407         user   \n",
       "21    153288241048491045    Emma Montgomery  13353835         user   \n",
       "22    153288229055103231      Nick Rafferty  20757944         user   \n",
       "23    153288188503993744          K Rumburg   9195374         user   \n",
       "24    153288163363748392       Julia Kelley  21121405         user   \n",
       "25    153288119252770014        Will Miller  19535672         user   \n",
       "26    153288100936060194    Eliana Drescher  10053824         user   \n",
       "27    153288082315013231            GroupMe    system       system   \n",
       "28    153288052459709988         Eric Zhang  33306533         user   \n",
       "29    153287987832388488   Nico Krachenfels  19848740         user   \n",
       "...                  ...                ...       ...          ...   \n",
       "4353  153031477573714304      Abrar Tanveer  14870085         user   \n",
       "4354  153031457070296625        Marc Bielas  11747595         user   \n",
       "4355  153031296613631533            GroupMe    system       system   \n",
       "4356  153031294220806821            GroupMe    system       system   \n",
       "4357  153031186748069846            GroupMe    system       system   \n",
       "4358  153030862844056058            GroupMe    system       system   \n",
       "4359  153030843435962722            GroupMe    system       system   \n",
       "4360  153030711292475238            GroupMe    system       system   \n",
       "4361  153030604476435827            GroupMe    system       system   \n",
       "4362  153030521092451039            GroupMe    system       system   \n",
       "4363  153030507956535844            GroupMe    system       system   \n",
       "4364  153030453472076294            GroupMe    system       system   \n",
       "4365  153030441394366055            GroupMe    system       system   \n",
       "4366  153030350557726055            GroupMe    system       system   \n",
       "4367  153030201335891998            GroupMe    system       system   \n",
       "4368  153030160724987511            GroupMe    system       system   \n",
       "4369  153030146842902096            GroupMe    system       system   \n",
       "4370  153030050779264304            GroupMe    system       system   \n",
       "4371  153030048783263487            GroupMe    system       system   \n",
       "4372  153029979011336055            GroupMe    system       system   \n",
       "4373  153029961158894304            GroupMe    system       system   \n",
       "4374  153029932417265893            GroupMe    system       system   \n",
       "4375  153029828197925238            GroupMe    system       system   \n",
       "4376  153029758058425837            GroupMe    system       system   \n",
       "4377  153029701944170281            GroupMe    system       system   \n",
       "4378  153029694638526294            GroupMe    system       system   \n",
       "4379  153029685202521653            GroupMe    system       system   \n",
       "4380  153029678419545995            GroupMe    system       system   \n",
       "4381  153029675451539846            GroupMe    system       system   \n",
       "4382  153029668034140281            GroupMe    system       system   \n",
       "\n",
       "                                       source_guid system  \\\n",
       "0     android-40213835-b73b-488f-9b9b-af9d624d750b  False   \n",
       "1             DDE8ABC0-191D-4803-84E2-F00D7D2B2A89  False   \n",
       "2                 cbeee56453623ccddcc852d3eea8d5e7  False   \n",
       "3             FB1736EF-175B-44D4-A8F0-3AE26D945C4E  False   \n",
       "4             9ECFFBB4-37A6-408C-B82F-3BF02283F760  False   \n",
       "5             B524A6A9-40CD-4E78-96D9-B5849A881F88  False   \n",
       "6             8BBB6740-C016-43B2-B640-403E459B3142  False   \n",
       "7             AD0501C0-B548-44D8-81F4-E5DCD886DFB4  False   \n",
       "8             6C9F7A61-4C88-450A-AFD8-EF1180A5F579  False   \n",
       "9     android-274bc17f-469f-47b1-8b56-60310e25bddc  False   \n",
       "10            6EF20434-B800-412F-9CA0-5E2A5DA04AA6  False   \n",
       "11            B953E9F7-D9F9-4F9D-B0DA-B7CD92CA9A6C  False   \n",
       "12    android-79f00fd9-6e1d-42d3-bdf3-f742bb97ec59  False   \n",
       "13            A8E5281F-C9D2-4768-AB70-F4BD390951D0  False   \n",
       "14            0362CD85-304C-414D-BFC4-50719622E403  False   \n",
       "15    android-98f879c3-d6a1-4b1e-90e0-a6142b77ac89  False   \n",
       "16                686cf870757e0136705e22000ab9dacd   True   \n",
       "17            7CF5F129-DF99-437C-A769-713ECA6FCCAC  False   \n",
       "18            4686012E-3931-4421-8AD8-2FDDC73C6107  False   \n",
       "19    android-7d6c2637-56de-4357-89a2-9eec8c7c8006  False   \n",
       "20                3261056e9cab508bfa93150b67513a8f  False   \n",
       "21            58D04394-101C-45B7-829B-7990718997DA  False   \n",
       "22            620774E7-9551-4D46-B833-BD18758C082B  False   \n",
       "23            223A3B31-F0B1-44F3-9B55-1C72A8D54B80  False   \n",
       "24            4738132D-CD2E-4AA0-8FE2-803B992AFE5F  False   \n",
       "25            88490E22-5666-4CC4-B79A-D1AAFB9A3A49  False   \n",
       "26            5FCF1A3B-816B-44D8-8434-D7872B2A66C5  False   \n",
       "27                4977fc3075780136728722000ab9650c   True   \n",
       "28                7e27807d9b67019b706ba72be8a494bd  False   \n",
       "29            25A6F229-CE65-4B76-B79D-6D62B6168905  False   \n",
       "...                                            ...    ...   \n",
       "4353          C0CE3A69-B2C0-41F3-AF3D-02F043065B50  False   \n",
       "4354          3FC99ABB-5F33-431E-A5F2-58691321764C  False   \n",
       "4355              876acf105e1d0136727522000ab9650c   True   \n",
       "4356              7927a3e05e1d0136f87122000b78906f   True   \n",
       "4357              f89143005e1a013638cb22000b99a321   True   \n",
       "4358              6df2f5605e1301368ac922000b6a8482   True   \n",
       "4359              fa4491905e12013626e022000aa74b07   True   \n",
       "4360              e6a199505e0f0136cfc722000a45211c   True   \n",
       "4361              69f542705e0d0136d66e22000bd8a0b6   True   \n",
       "4362              78f368a05e0b0136534722000bc1838d   True   \n",
       "4363              2aa794d05e0b0136978822000a71d1ae   True   \n",
       "4364              e5e6e4405e09013659c422000b9ec5ef   True   \n",
       "4365              9de9c4005e0901368a8722000b6d8861   True   \n",
       "4366              807c0de05e0701368a8722000b6d8861   True   \n",
       "4367              070d9e705e040136b6d922000b698c65   True   \n",
       "4368              14fe48405e030136607322000b2304c6   True   \n",
       "4369              c23fe8205e02013605d622000b51975d   True   \n",
       "4370              85aa6f905e000136a80622000b3109a3   True   \n",
       "4371              79c4c5405e00013641c022000a71bcf2   True   \n",
       "4372              d9e544105dfe01368a8722000b6d8861   True   \n",
       "4373              6f7c98d05dfe0136a80622000b3109a3   True   \n",
       "4374              c42c58f05dfd0136eaa522000bf8e41a   True   \n",
       "4375              56fa42d05dfb0136cfc722000a45211c   True   \n",
       "4376              b4e9e1905df90136e7bc22000b8809e1   True   \n",
       "4377              667254405df8013606b422000ae1953d   True   \n",
       "4378              3ae6ca505df8013659c422000b9ec5ef   True   \n",
       "4379              02a897405df8013642d422000b0b86e7   True   \n",
       "4380              da3a94b05df70136600e22000ba9801a   True   \n",
       "4381              c889c3305df7013638cb22000b99a321   True   \n",
       "4382              9c53ba005df7013606b422000ae1953d   True   \n",
       "\n",
       "                                                   text   user_id  \n",
       "0     idk if anyone else here has a hammock but I'm ...  20656068  \n",
       "1              Quick MoGo Trip to jolly pumpkin anyone?   6601670  \n",
       "2     Hi friends, my challenge group and I were talk...   5929297  \n",
       "3                                        @Julia Kelley   21685515  \n",
       "4                              Is there any juice left?  21685515  \n",
       "5                                      ^ @Julia Kelley   13288142  \n",
       "6     Reminder to dm me if you’re interested in a ve...  20615984  \n",
       "7          ^^ yes and if I can bring anything pls lmk!!   2221108  \n",
       "8     Yo, to all the peeps cooking tonight, post the...  14422702  \n",
       "9                      Anyone wanna kick a ball around?  21542974  \n",
       "10    @Lydia Zaleski And I are gonna walk around dow...   9670428  \n",
       "11    Sign up with Bird and use code OXRQYP to get a...  19535672  \n",
       "12                        Anyone at Eastern Market rn?   10456773  \n",
       "13    @Dan Bardach And I are going to grab food (not...   6444591  \n",
       "14    Our role based group leader (PJ) told us yeste...  18172472  \n",
       "15                             Who discovered #buttcon?  23239728  \n",
       "16                   Michele changed the group's avatar    system  \n",
       "17                                                  NaN  14950174  \n",
       "18           Free juice in the 3rd floor lounge!\\n 🍓🍈🍊🥤  21121405  \n",
       "19    @Grayson Wise @Michele how did we ever survive...  20656068  \n",
       "20                         That was sent in confidence!  20843407  \n",
       "21                                                  NaN  13353835  \n",
       "22                      Does anyone have a large pot???  20757944  \n",
       "23    Growth mindset gurus! Personal finance worksho...   9195374  \n",
       "24    Heading back from brunch...will text when I’m ...  21121405  \n",
       "25                                             Lets fly  19535672  \n",
       "26    If any low -pexers/hangry fellows wanna join m...  10053824  \n",
       "27             Cooper Temple changed the group's avatar    system  \n",
       "28    This is what I think of whenever you guys go #...  33306533  \n",
       "29                                       Let’s fly baby  19848740  \n",
       "...                                                 ...       ...  \n",
       "4353                             Can we see the place?   14870085  \n",
       "4354  I booked the place and we’ll have a grill - if...  11747595  \n",
       "4355                   Marc Bielas has joined the group    system  \n",
       "4356                    Micky Wolf has joined the group    system  \n",
       "4357                   Ashwin Puri has joined the group    system  \n",
       "4358                   Lily Wilson has joined the group    system  \n",
       "4359                  Shea Fallick has joined the group    system  \n",
       "4360                     Gaby Nair has joined the group    system  \n",
       "4361                 Daniel Miller has joined the group    system  \n",
       "4362                    Exia Burns has joined the group    system  \n",
       "4363                   Henry Joyce has joined the group    system  \n",
       "4364                  Hayden Cohen has joined the group    system  \n",
       "4365          Daisy Claire Homolka has joined the group    system  \n",
       "4366                Samuel Gardner has joined the group    system  \n",
       "4367                    Betsy Yang has joined the group    system  \n",
       "4368                Luke Wasynczuk has joined the group    system  \n",
       "4369                Lindsay Buckel has joined the group    system  \n",
       "4370                 Serena Thomas has joined the group    system  \n",
       "4371                  Apurva Kasam has joined the group    system  \n",
       "4372             Monica Nimmagadda has joined the group    system  \n",
       "4373                 Rosalie Reuss has joined the group    system  \n",
       "4374                 Cooper Temple has joined the group    system  \n",
       "4375                  Gabby Kirlew has joined the group    system  \n",
       "4376             Elianna Goldstein has joined the group    system  \n",
       "4377                   Jason Chato has joined the group    system  \n",
       "4378                Jackson Steger has joined the group    system  \n",
       "4379                  Reagan Cline has joined the group    system  \n",
       "4380                 Lydia Zaleski has joined the group    system  \n",
       "4381               Robbie Dornbush has joined the group    system  \n",
       "4382  Abrar Tanveer added Noah Quinn, Amir Patel, mi...    system  \n",
       "\n",
       "[4383 rows x 31 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "\"labels ['event.data.event.id'] not contained in axis\"",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-4-7573109905a7>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     11\u001b[0m \u001b[0mdf2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf2\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'event.data.avatar_url'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     12\u001b[0m \u001b[0mdf2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf2\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'event.data.conversation.id'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 13\u001b[0;31m \u001b[0mdf2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf2\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'event.data.event.id'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     14\u001b[0m \u001b[0mdf2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf2\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'event.data.event.name'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     15\u001b[0m \u001b[0mdf2\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdf2\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'event.data.user.id'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36mdrop\u001b[0;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[1;32m   3692\u001b[0m                                            \u001b[0mindex\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3693\u001b[0m                                            \u001b[0mlevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0minplace\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0minplace\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3694\u001b[0;31m                                            errors=errors)\n\u001b[0m\u001b[1;32m   3695\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3696\u001b[0m     @rewrite_axis_style_signature('mapper', [('copy', True),\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36mdrop\u001b[0;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[1;32m   3106\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlabels\u001b[0m \u001b[0;32min\u001b[0m \u001b[0maxes\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3107\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mlabels\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3108\u001b[0;31m                 \u001b[0mobj\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mobj\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_drop_axis\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3109\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3110\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0minplace\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m_drop_axis\u001b[0;34m(self, labels, axis, level, errors)\u001b[0m\n\u001b[1;32m   3138\u001b[0m                 \u001b[0mnew_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3139\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3140\u001b[0;31m                 \u001b[0mnew_axis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0maxis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlabels\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merrors\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0merrors\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3141\u001b[0m             \u001b[0mdropped\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreindex\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m**\u001b[0m\u001b[0;34m{\u001b[0m\u001b[0maxis_name\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mnew_axis\u001b[0m\u001b[0;34m}\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3142\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mdrop\u001b[0;34m(self, labels, errors)\u001b[0m\n\u001b[1;32m   4385\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0merrors\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0;34m'ignore'\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4386\u001b[0m                 raise KeyError(\n\u001b[0;32m-> 4387\u001b[0;31m                     'labels %s not contained in axis' % labels[mask])\n\u001b[0m\u001b[1;32m   4388\u001b[0m             \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mindexer\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m~\u001b[0m\u001b[0mmask\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4389\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdelete\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: \"labels ['event.data.event.id'] not contained in axis\""
     ]
    }
   ],
   "source": [
    "# == CLEAN DATAFRAME ==  \n",
    "#######################\n",
    "\n",
    "# Cut out system generated messages like \"so and so joined the channel\"\n",
    "df2 = df[df.user_id != 'system']\n",
    "\n",
    "# Cut event data columns, almost all of which were NaNs. \n",
    "\n",
    "df2 = df2.drop('event.data.adder_user.id', axis=1)\n",
    "df2 = df2.drop('event.data.adder_user.nickname', axis=1)\n",
    "df2 = df2.drop('event.data.avatar_url', axis=1)\n",
    "df2 = df2.drop('event.data.conversation.id', axis=1)\n",
    "df2 = df2.drop('event.data.event.id', axis=1)\n",
    "df2 = df2.drop('event.data.event.name', axis=1)\n",
    "df2 = df2.drop('event.data.user.id', axis=1)\n",
    "df2 = df2.drop('event.data.user.nickname', axis=1)\n",
    "df2 = df2.drop('event.type', axis=1)\n",
    "df2 = df2.drop('event.data.url', axis=1)\n",
    "df2 = df2.drop('event.data.added_users', axis=1)\n",
    "df2 = df2.drop('event.data.options', axis=1)\n",
    "df2 = df2.drop('event.data.poll.expiration', axis=1)\n",
    "df2 = df2.drop('event.data.poll.id', axis=1)\n",
    "df2 = df2.drop('event.data.poll.subject', axis=1)\n",
    "df2 = df2.drop('user_id', axis=1)\n",
    "\n",
    "# Cut other uninteresting columns. \n",
    "df2 = df2.drop('system', axis=1)\n",
    "df2 = df2.drop('sender_type', axis=1)\n",
    "df2 = df2.drop('group_id', axis=1) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_csv('groupme_cleaned.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}