Skip to content

Instantly share code, notes, and snippets.

@adilek
Created June 6, 2018 14:32
Show Gist options
  • Select an option

  • Save adilek/e6009fb243c77924050a0ff6f453c701 to your computer and use it in GitHub Desktop.

Select an option

Save adilek/e6009fb243c77924050a0ff6f453c701 to your computer and use it in GitHub Desktop.
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>username</th>\n",
" <th>first_name</th>\n",
" <th>last_name</th>\n",
" <th>birth_year</th>\n",
" <th>points</th>\n",
" <th>email</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>1</td>\n",
" <td>john</td>\n",
" <td>John</td>\n",
" <td>Smith</td>\n",
" <td>1985</td>\n",
" <td>5</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>2</td>\n",
" <td>jack</td>\n",
" <td>Jack</td>\n",
" <td>Wilson</td>\n",
" <td>1994</td>\n",
" <td>15</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3</td>\n",
" <td>clara</td>\n",
" <td>Clara</td>\n",
" <td>Setkin</td>\n",
" <td>1988</td>\n",
" <td>8</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>4</td>\n",
" <td>ann</td>\n",
" <td>Anna</td>\n",
" <td>Johnson</td>\n",
" <td>1964</td>\n",
" <td>10</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5</td>\n",
" <td>noah.eli</td>\n",
" <td>Noah</td>\n",
" <td>Eli</td>\n",
" <td>1980</td>\n",
" <td>2</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>6</td>\n",
" <td>liam.landon</td>\n",
" <td>Liam</td>\n",
" <td>Landon</td>\n",
" <td>1995</td>\n",
" <td>1</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>7</td>\n",
" <td>william.connor</td>\n",
" <td>William</td>\n",
" <td>Connor</td>\n",
" <td>1996</td>\n",
" <td>8</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>8</td>\n",
" <td>mason.josiah</td>\n",
" <td>Mason</td>\n",
" <td>Josiah</td>\n",
" <td>1990</td>\n",
" <td>13</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>9</td>\n",
" <td>james.jonathan</td>\n",
" <td>James</td>\n",
" <td>Jonathan</td>\n",
" <td>1993</td>\n",
" <td>9</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>10</td>\n",
" <td>benjamin.cameron</td>\n",
" <td>Benjamin</td>\n",
" <td>Cameron</td>\n",
" <td>1983</td>\n",
" <td>11</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>11</td>\n",
" <td>jacob.jeremiah</td>\n",
" <td>Jacob</td>\n",
" <td>Jeremiah</td>\n",
" <td>1982</td>\n",
" <td>3</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>12</td>\n",
" <td>michael.mateo</td>\n",
" <td>Michael</td>\n",
" <td>Mateo</td>\n",
" <td>1984</td>\n",
" <td>2</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>13</td>\n",
" <td>elijah.adrian</td>\n",
" <td>Elijah</td>\n",
" <td>Adrian</td>\n",
" <td>1994</td>\n",
" <td>6</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>14</td>\n",
" <td>ethan.hudson</td>\n",
" <td>Ethan</td>\n",
" <td>Hudson</td>\n",
" <td>1988</td>\n",
" <td>8</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>15</td>\n",
" <td>alexander.robert</td>\n",
" <td>Alexander</td>\n",
" <td>Robert</td>\n",
" <td>1982</td>\n",
" <td>18</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>16</td>\n",
" <td>oliver.nicholas</td>\n",
" <td>Oliver</td>\n",
" <td>Nicholas</td>\n",
" <td>1994</td>\n",
" <td>4</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>17</td>\n",
" <td>daniel.brayden</td>\n",
" <td>Daniel</td>\n",
" <td>Brayden</td>\n",
" <td>1983</td>\n",
" <td>1</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>18</td>\n",
" <td>lucas.nolan</td>\n",
" <td>Lucas</td>\n",
" <td>Nolan</td>\n",
" <td>1994</td>\n",
" <td>12</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>19</td>\n",
" <td>matthew.easton</td>\n",
" <td>Matthew</td>\n",
" <td>Easton</td>\n",
" <td>1989</td>\n",
" <td>17</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>20</td>\n",
" <td>aiden.jordan</td>\n",
" <td>Aiden</td>\n",
" <td>Jordan</td>\n",
" <td>1997</td>\n",
" <td>10</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>21</td>\n",
" <td>jackson.colton</td>\n",
" <td>Jackson</td>\n",
" <td>Colton</td>\n",
" <td>1993</td>\n",
" <td>13</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>22</td>\n",
" <td>logan.evan</td>\n",
" <td>Logan</td>\n",
" <td>Evan</td>\n",
" <td>1998</td>\n",
" <td>12</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>23</td>\n",
" <td>david.angel</td>\n",
" <td>David</td>\n",
" <td>Angel</td>\n",
" <td>1989</td>\n",
" <td>5</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>24</td>\n",
" <td>joseph.asher</td>\n",
" <td>Joseph</td>\n",
" <td>Asher</td>\n",
" <td>1989</td>\n",
" <td>19</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>25</td>\n",
" <td>samuel.dominic</td>\n",
" <td>Samuel</td>\n",
" <td>Dominic</td>\n",
" <td>1983</td>\n",
" <td>3</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>26</td>\n",
" <td>henry.austin</td>\n",
" <td>Henry</td>\n",
" <td>Austin</td>\n",
" <td>1987</td>\n",
" <td>18</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>27</td>\n",
" <td>owen.leo</td>\n",
" <td>Owen</td>\n",
" <td>Leo</td>\n",
" <td>1981</td>\n",
" <td>17</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>28</td>\n",
" <td>sebastian.adam</td>\n",
" <td>Sebastian</td>\n",
" <td>Adam</td>\n",
" <td>1980</td>\n",
" <td>10</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>29</td>\n",
" <td>gabriel.jace</td>\n",
" <td>Gabriel</td>\n",
" <td>Jace</td>\n",
" <td>1981</td>\n",
" <td>8</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>30</td>\n",
" <td>carter.jose</td>\n",
" <td>Carter</td>\n",
" <td>Jose</td>\n",
" <td>1992</td>\n",
" <td>2</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>31</td>\n",
" <td>jayden.ian</td>\n",
" <td>Jayden</td>\n",
" <td>Ian</td>\n",
" <td>1998</td>\n",
" <td>10</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>32</td>\n",
" <td>john.cooper</td>\n",
" <td>John</td>\n",
" <td>Cooper</td>\n",
" <td>1996</td>\n",
" <td>5</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>33</td>\n",
" <td>luke.gavin</td>\n",
" <td>Luke</td>\n",
" <td>Gavin</td>\n",
" <td>1980</td>\n",
" <td>15</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>34</td>\n",
" <td>anthony.carson</td>\n",
" <td>Anthony</td>\n",
" <td>Carson</td>\n",
" <td>1989</td>\n",
" <td>8</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>35</td>\n",
" <td>isaac.jaxson</td>\n",
" <td>Isaac</td>\n",
" <td>Jaxson</td>\n",
" <td>1997</td>\n",
" <td>5</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>36</td>\n",
" <td>dylan.theodore</td>\n",
" <td>Dylan</td>\n",
" <td>Theodore</td>\n",
" <td>1991</td>\n",
" <td>1</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>37</td>\n",
" <td>wyatt.jason</td>\n",
" <td>Wyatt</td>\n",
" <td>Jason</td>\n",
" <td>2000</td>\n",
" <td>3</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>38</td>\n",
" <td>andrew.ezra</td>\n",
" <td>Andrew</td>\n",
" <td>Ezra</td>\n",
" <td>1980</td>\n",
" <td>10</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>39</td>\n",
" <td>joshua.chase</td>\n",
" <td>Joshua</td>\n",
" <td>Chase</td>\n",
" <td>1990</td>\n",
" <td>17</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>40</td>\n",
" <td>christopher.parker</td>\n",
" <td>Christopher</td>\n",
" <td>Parker</td>\n",
" <td>1982</td>\n",
" <td>4</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>41</td>\n",
" <td>grayson.xavier</td>\n",
" <td>Grayson</td>\n",
" <td>Xavier</td>\n",
" <td>1991</td>\n",
" <td>3</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>42</td>\n",
" <td>jack.kevin</td>\n",
" <td>Jack</td>\n",
" <td>Kevin</td>\n",
" <td>1996</td>\n",
" <td>2</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>43</td>\n",
" <td>julian.zachary</td>\n",
" <td>Julian</td>\n",
" <td>Zachary</td>\n",
" <td>1995</td>\n",
" <td>13</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>44</td>\n",
" <td>ryan.tyler</td>\n",
" <td>Ryan</td>\n",
" <td>Tyler</td>\n",
" <td>1996</td>\n",
" <td>1</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>45</td>\n",
" <td>jaxon.ayden</td>\n",
" <td>Jaxon</td>\n",
" <td>Ayden</td>\n",
" <td>1987</td>\n",
" <td>11</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>46</td>\n",
" <td>levi.elias</td>\n",
" <td>Levi</td>\n",
" <td>Elias</td>\n",
" <td>1992</td>\n",
" <td>11</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>47</td>\n",
" <td>nathan.bryson</td>\n",
" <td>Nathan</td>\n",
" <td>Bryson</td>\n",
" <td>1995</td>\n",
" <td>8</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>48</td>\n",
" <td>caleb.leonardo</td>\n",
" <td>Caleb</td>\n",
" <td>Leonardo</td>\n",
" <td>1988</td>\n",
" <td>9</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>49</td>\n",
" <td>hunter.greyson</td>\n",
" <td>Hunter</td>\n",
" <td>Greyson</td>\n",
" <td>1995</td>\n",
" <td>20</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>50</td>\n",
" <td>christian.sawyer</td>\n",
" <td>Christian</td>\n",
" <td>Sawyer</td>\n",
" <td>1993</td>\n",
" <td>12</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>51</td>\n",
" <td>isaiah.roman</td>\n",
" <td>Isaiah</td>\n",
" <td>Roman</td>\n",
" <td>1987</td>\n",
" <td>13</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>52</td>\n",
" <td>thomas.brandon</td>\n",
" <td>Thomas</td>\n",
" <td>Brandon</td>\n",
" <td>1988</td>\n",
" <td>9</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>53</td>\n",
" <td>aaron.bentley</td>\n",
" <td>Aaron</td>\n",
" <td>Bentley</td>\n",
" <td>1984</td>\n",
" <td>4</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>54</td>\n",
" <td>lincoln.kayden</td>\n",
" <td>Lincoln</td>\n",
" <td>Kayden</td>\n",
" <td>1997</td>\n",
" <td>3</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>55</td>\n",
" <td>charles.ryder</td>\n",
" <td>Charles</td>\n",
" <td>Ryder</td>\n",
" <td>1984</td>\n",
" <td>15</td>\n",
" <td>[email protected]</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" id username first_name last_name birth_year points \\\n",
"0 1 john John Smith 1985 5 \n",
"1 2 jack Jack Wilson 1994 15 \n",
"2 3 clara Clara Setkin 1988 8 \n",
"3 4 ann Anna Johnson 1964 10 \n",
"4 5 noah.eli Noah Eli 1980 2 \n",
"5 6 liam.landon Liam Landon 1995 1 \n",
"6 7 william.connor William Connor 1996 8 \n",
"7 8 mason.josiah Mason Josiah 1990 13 \n",
"8 9 james.jonathan James Jonathan 1993 9 \n",
"9 10 benjamin.cameron Benjamin Cameron 1983 11 \n",
"10 11 jacob.jeremiah Jacob Jeremiah 1982 3 \n",
"11 12 michael.mateo Michael Mateo 1984 2 \n",
"12 13 elijah.adrian Elijah Adrian 1994 6 \n",
"13 14 ethan.hudson Ethan Hudson 1988 8 \n",
"14 15 alexander.robert Alexander Robert 1982 18 \n",
"15 16 oliver.nicholas Oliver Nicholas 1994 4 \n",
"16 17 daniel.brayden Daniel Brayden 1983 1 \n",
"17 18 lucas.nolan Lucas Nolan 1994 12 \n",
"18 19 matthew.easton Matthew Easton 1989 17 \n",
"19 20 aiden.jordan Aiden Jordan 1997 10 \n",
"20 21 jackson.colton Jackson Colton 1993 13 \n",
"21 22 logan.evan Logan Evan 1998 12 \n",
"22 23 david.angel David Angel 1989 5 \n",
"23 24 joseph.asher Joseph Asher 1989 19 \n",
"24 25 samuel.dominic Samuel Dominic 1983 3 \n",
"25 26 henry.austin Henry Austin 1987 18 \n",
"26 27 owen.leo Owen Leo 1981 17 \n",
"27 28 sebastian.adam Sebastian Adam 1980 10 \n",
"28 29 gabriel.jace Gabriel Jace 1981 8 \n",
"29 30 carter.jose Carter Jose 1992 2 \n",
"30 31 jayden.ian Jayden Ian 1998 10 \n",
"31 32 john.cooper John Cooper 1996 5 \n",
"32 33 luke.gavin Luke Gavin 1980 15 \n",
"33 34 anthony.carson Anthony Carson 1989 8 \n",
"34 35 isaac.jaxson Isaac Jaxson 1997 5 \n",
"35 36 dylan.theodore Dylan Theodore 1991 1 \n",
"36 37 wyatt.jason Wyatt Jason 2000 3 \n",
"37 38 andrew.ezra Andrew Ezra 1980 10 \n",
"38 39 joshua.chase Joshua Chase 1990 17 \n",
"39 40 christopher.parker Christopher Parker 1982 4 \n",
"40 41 grayson.xavier Grayson Xavier 1991 3 \n",
"41 42 jack.kevin Jack Kevin 1996 2 \n",
"42 43 julian.zachary Julian Zachary 1995 13 \n",
"43 44 ryan.tyler Ryan Tyler 1996 1 \n",
"44 45 jaxon.ayden Jaxon Ayden 1987 11 \n",
"45 46 levi.elias Levi Elias 1992 11 \n",
"46 47 nathan.bryson Nathan Bryson 1995 8 \n",
"47 48 caleb.leonardo Caleb Leonardo 1988 9 \n",
"48 49 hunter.greyson Hunter Greyson 1995 20 \n",
"49 50 christian.sawyer Christian Sawyer 1993 12 \n",
"50 51 isaiah.roman Isaiah Roman 1987 13 \n",
"51 52 thomas.brandon Thomas Brandon 1988 9 \n",
"52 53 aaron.bentley Aaron Bentley 1984 4 \n",
"53 54 lincoln.kayden Lincoln Kayden 1997 3 \n",
"54 55 charles.ryder Charles Ryder 1984 15 \n",
"\n",
" email \n",
"0 [email protected] \n",
"1 [email protected] \n",
"2 [email protected] \n",
"3 NaN \n",
"4 [email protected] \n",
"5 [email protected] \n",
"6 [email protected] \n",
"7 [email protected] \n",
"8 [email protected] \n",
"9 [email protected] \n",
"10 [email protected] \n",
"11 [email protected] \n",
"12 [email protected] \n",
"13 [email protected] \n",
"14 [email protected] \n",
"15 [email protected] \n",
"16 [email protected] \n",
"17 [email protected] \n",
"18 [email protected] \n",
"19 [email protected] \n",
"20 [email protected] \n",
"21 [email protected] \n",
"22 [email protected] \n",
"23 [email protected] \n",
"24 [email protected] \n",
"25 [email protected] \n",
"26 [email protected] \n",
"27 [email protected] \n",
"28 [email protected] \n",
"29 [email protected] \n",
"30 [email protected] \n",
"31 [email protected] \n",
"32 [email protected] \n",
"33 [email protected] \n",
"34 [email protected] \n",
"35 [email protected] \n",
"36 [email protected] \n",
"37 [email protected] \n",
"38 [email protected] \n",
"39 [email protected] \n",
"40 [email protected] \n",
"41 [email protected] \n",
"42 [email protected] \n",
"43 [email protected] \n",
"44 [email protected] \n",
"45 [email protected] \n",
"46 [email protected] \n",
"47 [email protected] \n",
"48 [email protected] \n",
"49 [email protected] \n",
"50 [email protected] \n",
"51 [email protected] \n",
"52 [email protected] \n",
"53 [email protected] \n",
"54 [email protected] "
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"users"
]
}
],
"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
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment