Skip to content

Instantly share code, notes, and snippets.

@adilek

adilek/pandas-sql_18.ipynb

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