Skip to content

Instantly share code, notes, and snippets.

@adilek

adilek/pandas-sql_5.ipynb

Last active June 6, 2018 14:41
Show Gist options
  • Save adilek/079d9b43f6e1ac686f91bf82d8056aad to your computer and use it in GitHub Desktop.
Save adilek/079d9b43f6e1ac686f91bf82d8056aad to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
pandas-sql_5.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 9,
"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>first_name</th>\n",
" <th>last_name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>John</td>\n",
" <td>Smith</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Jack</td>\n",
" <td>Wilson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Clara</td>\n",
" <td>Setkin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Anna</td>\n",
" <td>Johnson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Noah</td>\n",
" <td>Eli</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Liam</td>\n",
" <td>Landon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>William</td>\n",
" <td>Connor</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Mason</td>\n",
" <td>Josiah</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>James</td>\n",
" <td>Jonathan</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Benjamin</td>\n",
" <td>Cameron</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Jacob</td>\n",
" <td>Jeremiah</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Michael</td>\n",
" <td>Mateo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Elijah</td>\n",
" <td>Adrian</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Ethan</td>\n",
" <td>Hudson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Alexander</td>\n",
" <td>Robert</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Oliver</td>\n",
" <td>Nicholas</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Daniel</td>\n",
" <td>Brayden</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Lucas</td>\n",
" <td>Nolan</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Matthew</td>\n",
" <td>Easton</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Aiden</td>\n",
" <td>Jordan</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Jackson</td>\n",
" <td>Colton</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Logan</td>\n",
" <td>Evan</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>David</td>\n",
" <td>Angel</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Joseph</td>\n",
" <td>Asher</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Samuel</td>\n",
" <td>Dominic</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Henry</td>\n",
" <td>Austin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Owen</td>\n",
" <td>Leo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Sebastian</td>\n",
" <td>Adam</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Gabriel</td>\n",
" <td>Jace</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Carter</td>\n",
" <td>Jose</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>Jayden</td>\n",
" <td>Ian</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>John</td>\n",
" <td>Cooper</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>Luke</td>\n",
" <td>Gavin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>Anthony</td>\n",
" <td>Carson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>Isaac</td>\n",
" <td>Jaxson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>Dylan</td>\n",
" <td>Theodore</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>Wyatt</td>\n",
" <td>Jason</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>Andrew</td>\n",
" <td>Ezra</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>Joshua</td>\n",
" <td>Chase</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>Christopher</td>\n",
" <td>Parker</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>Grayson</td>\n",
" <td>Xavier</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>Jack</td>\n",
" <td>Kevin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Julian</td>\n",
" <td>Zachary</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>Ryan</td>\n",
" <td>Tyler</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>Jaxon</td>\n",
" <td>Ayden</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>Levi</td>\n",
" <td>Elias</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>Nathan</td>\n",
" <td>Bryson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>Caleb</td>\n",
" <td>Leonardo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>Hunter</td>\n",
" <td>Greyson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>Christian</td>\n",
" <td>Sawyer</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50</th>\n",
" <td>Isaiah</td>\n",
" <td>Roman</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>Thomas</td>\n",
" <td>Brandon</td>\n",
" </tr>\n",
" <tr>\n",
" <th>52</th>\n",
" <td>Aaron</td>\n",
" <td>Bentley</td>\n",
" </tr>\n",
" <tr>\n",
" <th>53</th>\n",
" <td>Lincoln</td>\n",
" <td>Kayden</td>\n",
" </tr>\n",
" <tr>\n",
" <th>54</th>\n",
" <td>Charles</td>\n",
" <td>Ryder</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" first_name last_name\n",
"0 John Smith\n",
"1 Jack Wilson\n",
"2 Clara Setkin\n",
"3 Anna Johnson\n",
"4 Noah Eli\n",
"5 Liam Landon\n",
"6 William Connor\n",
"7 Mason Josiah\n",
"8 James Jonathan\n",
"9 Benjamin Cameron\n",
"10 Jacob Jeremiah\n",
"11 Michael Mateo\n",
"12 Elijah Adrian\n",
"13 Ethan Hudson\n",
"14 Alexander Robert\n",
"15 Oliver Nicholas\n",
"16 Daniel Brayden\n",
"17 Lucas Nolan\n",
"18 Matthew Easton\n",
"19 Aiden Jordan\n",
"20 Jackson Colton\n",
"21 Logan Evan\n",
"22 David Angel\n",
"23 Joseph Asher\n",
"24 Samuel Dominic\n",
"25 Henry Austin\n",
"26 Owen Leo\n",
"27 Sebastian Adam\n",
"28 Gabriel Jace\n",
"29 Carter Jose\n",
"30 Jayden Ian\n",
"31 John Cooper\n",
"32 Luke Gavin\n",
"33 Anthony Carson\n",
"34 Isaac Jaxson\n",
"35 Dylan Theodore\n",
"36 Wyatt Jason\n",
"37 Andrew Ezra\n",
"38 Joshua Chase\n",
"39 Christopher Parker\n",
"40 Grayson Xavier\n",
"41 Jack Kevin\n",
"42 Julian Zachary\n",
"43 Ryan Tyler\n",
"44 Jaxon Ayden\n",
"45 Levi Elias\n",
"46 Nathan Bryson\n",
"47 Caleb Leonardo\n",
"48 Hunter Greyson\n",
"49 Christian Sawyer\n",
"50 Isaiah Roman\n",
"51 Thomas Brandon\n",
"52 Aaron Bentley\n",
"53 Lincoln Kayden\n",
"54 Charles Ryder"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"users[[\"first_name\", \"last_name\"]]"
]
}
],
"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