Skip to content

Instantly share code, notes, and snippets.

@adilek

adilek/pandas-sql_15.ipynb

Created June 6, 2018 15:07
Show Gist options
  • Save adilek/798fb92f8415187c39aa155d06364c84 to your computer and use it in GitHub Desktop.
Save adilek/798fb92f8415187c39aa155d06364c84 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
pandas-sql_15.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 22,
"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",
" <th>birth_year</th>\n",
" <th>points</th>\n",
" <th>course_name</th>\n",
" <th>instructor</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>John</td>\n",
" <td>Smith</td>\n",
" <td>1985</td>\n",
" <td>5</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Carter</td>\n",
" <td>Jose</td>\n",
" <td>1992</td>\n",
" <td>2</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Isaac</td>\n",
" <td>Jaxson</td>\n",
" <td>1997</td>\n",
" <td>5</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Dylan</td>\n",
" <td>Theodore</td>\n",
" <td>1991</td>\n",
" <td>1</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>Christopher</td>\n",
" <td>Parker</td>\n",
" <td>1982</td>\n",
" <td>4</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Ryan</td>\n",
" <td>Tyler</td>\n",
" <td>1996</td>\n",
" <td>1</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Jaxon</td>\n",
" <td>Ayden</td>\n",
" <td>1987</td>\n",
" <td>11</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Anna</td>\n",
" <td>Johnson</td>\n",
" <td>1964</td>\n",
" <td>10</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>Noah</td>\n",
" <td>Eli</td>\n",
" <td>1980</td>\n",
" <td>2</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>David</td>\n",
" <td>Angel</td>\n",
" <td>1989</td>\n",
" <td>5</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>Joseph</td>\n",
" <td>Asher</td>\n",
" <td>1989</td>\n",
" <td>19</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>John</td>\n",
" <td>Cooper</td>\n",
" <td>1996</td>\n",
" <td>5</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Luke</td>\n",
" <td>Gavin</td>\n",
" <td>1980</td>\n",
" <td>15</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Joshua</td>\n",
" <td>Chase</td>\n",
" <td>1990</td>\n",
" <td>17</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>Christopher</td>\n",
" <td>Parker</td>\n",
" <td>1982</td>\n",
" <td>4</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>Levi</td>\n",
" <td>Elias</td>\n",
" <td>1992</td>\n",
" <td>11</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>John</td>\n",
" <td>Smith</td>\n",
" <td>1985</td>\n",
" <td>5</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>Jack</td>\n",
" <td>Wilson</td>\n",
" <td>1994</td>\n",
" <td>15</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>Samuel</td>\n",
" <td>Dominic</td>\n",
" <td>1983</td>\n",
" <td>3</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Owen</td>\n",
" <td>Leo</td>\n",
" <td>1981</td>\n",
" <td>17</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Gabriel</td>\n",
" <td>Jace</td>\n",
" <td>1981</td>\n",
" <td>8</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Jayden</td>\n",
" <td>Ian</td>\n",
" <td>1998</td>\n",
" <td>10</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Dylan</td>\n",
" <td>Theodore</td>\n",
" <td>1991</td>\n",
" <td>1</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Christopher</td>\n",
" <td>Parker</td>\n",
" <td>1982</td>\n",
" <td>4</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>Elijah</td>\n",
" <td>Adrian</td>\n",
" <td>1994</td>\n",
" <td>6</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Jackson</td>\n",
" <td>Colton</td>\n",
" <td>1993</td>\n",
" <td>13</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>Joseph</td>\n",
" <td>Asher</td>\n",
" <td>1989</td>\n",
" <td>19</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Sebastian</td>\n",
" <td>Adam</td>\n",
" <td>1980</td>\n",
" <td>10</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>Carter</td>\n",
" <td>Jose</td>\n",
" <td>1992</td>\n",
" <td>2</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>Joshua</td>\n",
" <td>Chase</td>\n",
" <td>1990</td>\n",
" <td>17</td>\n",
" <td>Data Science applications</td>\n",
" <td>Michael Jackson</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",
" </tr>\n",
" <tr>\n",
" <th>176</th>\n",
" <td>Thomas</td>\n",
" <td>Brandon</td>\n",
" <td>1988</td>\n",
" <td>9</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>177</th>\n",
" <td>John</td>\n",
" <td>Smith</td>\n",
" <td>1985</td>\n",
" <td>5</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>178</th>\n",
" <td>William</td>\n",
" <td>Connor</td>\n",
" <td>1996</td>\n",
" <td>8</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>179</th>\n",
" <td>James</td>\n",
" <td>Jonathan</td>\n",
" <td>1993</td>\n",
" <td>9</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>180</th>\n",
" <td>Lucas</td>\n",
" <td>Nolan</td>\n",
" <td>1994</td>\n",
" <td>12</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>181</th>\n",
" <td>Gabriel</td>\n",
" <td>Jace</td>\n",
" <td>1981</td>\n",
" <td>8</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>182</th>\n",
" <td>Jaxon</td>\n",
" <td>Ayden</td>\n",
" <td>1987</td>\n",
" <td>11</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>183</th>\n",
" <td>Christian</td>\n",
" <td>Sawyer</td>\n",
" <td>1993</td>\n",
" <td>12</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>184</th>\n",
" <td>Isaiah</td>\n",
" <td>Roman</td>\n",
" <td>1987</td>\n",
" <td>13</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>185</th>\n",
" <td>Anna</td>\n",
" <td>Johnson</td>\n",
" <td>1964</td>\n",
" <td>10</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>Ethan</td>\n",
" <td>Hudson</td>\n",
" <td>1988</td>\n",
" <td>8</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>187</th>\n",
" <td>Oliver</td>\n",
" <td>Nicholas</td>\n",
" <td>1994</td>\n",
" <td>4</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>188</th>\n",
" <td>Carter</td>\n",
" <td>Jose</td>\n",
" <td>1992</td>\n",
" <td>2</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>189</th>\n",
" <td>Andrew</td>\n",
" <td>Ezra</td>\n",
" <td>1980</td>\n",
" <td>10</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>190</th>\n",
" <td>Jack</td>\n",
" <td>Kevin</td>\n",
" <td>1996</td>\n",
" <td>2</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>191</th>\n",
" <td>Caleb</td>\n",
" <td>Leonardo</td>\n",
" <td>1988</td>\n",
" <td>9</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>192</th>\n",
" <td>Hunter</td>\n",
" <td>Greyson</td>\n",
" <td>1995</td>\n",
" <td>20</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>193</th>\n",
" <td>Clara</td>\n",
" <td>Setkin</td>\n",
" <td>1988</td>\n",
" <td>8</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>194</th>\n",
" <td>Noah</td>\n",
" <td>Eli</td>\n",
" <td>1980</td>\n",
" <td>2</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>195</th>\n",
" <td>Benjamin</td>\n",
" <td>Cameron</td>\n",
" <td>1983</td>\n",
" <td>11</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>196</th>\n",
" <td>Michael</td>\n",
" <td>Mateo</td>\n",
" <td>1984</td>\n",
" <td>2</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>197</th>\n",
" <td>Aiden</td>\n",
" <td>Jordan</td>\n",
" <td>1997</td>\n",
" <td>10</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>198</th>\n",
" <td>Samuel</td>\n",
" <td>Dominic</td>\n",
" <td>1983</td>\n",
" <td>3</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>199</th>\n",
" <td>Isaac</td>\n",
" <td>Jaxson</td>\n",
" <td>1997</td>\n",
" <td>5</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>200</th>\n",
" <td>Wyatt</td>\n",
" <td>Jason</td>\n",
" <td>2000</td>\n",
" <td>3</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>201</th>\n",
" <td>Andrew</td>\n",
" <td>Ezra</td>\n",
" <td>1980</td>\n",
" <td>10</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>202</th>\n",
" <td>Christopher</td>\n",
" <td>Parker</td>\n",
" <td>1982</td>\n",
" <td>4</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>203</th>\n",
" <td>Thomas</td>\n",
" <td>Brandon</td>\n",
" <td>1988</td>\n",
" <td>9</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>204</th>\n",
" <td>Lincoln</td>\n",
" <td>Kayden</td>\n",
" <td>1997</td>\n",
" <td>3</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" <tr>\n",
" <th>205</th>\n",
" <td>Charles</td>\n",
" <td>Ryder</td>\n",
" <td>1984</td>\n",
" <td>15</td>\n",
" <td>Intro to Deep Learning</td>\n",
" <td>Emma Watson</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>206 rows × 6 columns</p>\n",
"</div>"
],
"text/plain": [
" first_name last_name birth_year points course_name \\\n",
"0 John Smith 1985 5 Data Science applications \n",
"1 Carter Jose 1992 2 Data Science applications \n",
"2 Isaac Jaxson 1997 5 Data Science applications \n",
"3 Dylan Theodore 1991 1 Data Science applications \n",
"4 Christopher Parker 1982 4 Data Science applications \n",
"5 Ryan Tyler 1996 1 Data Science applications \n",
"6 Jaxon Ayden 1987 11 Data Science applications \n",
"7 Anna Johnson 1964 10 Data Science applications \n",
"8 Noah Eli 1980 2 Data Science applications \n",
"9 David Angel 1989 5 Data Science applications \n",
"10 Joseph Asher 1989 19 Data Science applications \n",
"11 John Cooper 1996 5 Data Science applications \n",
"12 Luke Gavin 1980 15 Data Science applications \n",
"13 Joshua Chase 1990 17 Data Science applications \n",
"14 Christopher Parker 1982 4 Data Science applications \n",
"15 Levi Elias 1992 11 Data Science applications \n",
"16 John Smith 1985 5 Data Science applications \n",
"17 Jack Wilson 1994 15 Data Science applications \n",
"18 Samuel Dominic 1983 3 Data Science applications \n",
"19 Owen Leo 1981 17 Data Science applications \n",
"20 Gabriel Jace 1981 8 Data Science applications \n",
"21 Jayden Ian 1998 10 Data Science applications \n",
"22 Dylan Theodore 1991 1 Data Science applications \n",
"23 Christopher Parker 1982 4 Data Science applications \n",
"24 Elijah Adrian 1994 6 Data Science applications \n",
"25 Jackson Colton 1993 13 Data Science applications \n",
"26 Joseph Asher 1989 19 Data Science applications \n",
"27 Sebastian Adam 1980 10 Data Science applications \n",
"28 Carter Jose 1992 2 Data Science applications \n",
"29 Joshua Chase 1990 17 Data Science applications \n",
".. ... ... ... ... ... \n",
"176 Thomas Brandon 1988 9 Intro to Deep Learning \n",
"177 John Smith 1985 5 Intro to Deep Learning \n",
"178 William Connor 1996 8 Intro to Deep Learning \n",
"179 James Jonathan 1993 9 Intro to Deep Learning \n",
"180 Lucas Nolan 1994 12 Intro to Deep Learning \n",
"181 Gabriel Jace 1981 8 Intro to Deep Learning \n",
"182 Jaxon Ayden 1987 11 Intro to Deep Learning \n",
"183 Christian Sawyer 1993 12 Intro to Deep Learning \n",
"184 Isaiah Roman 1987 13 Intro to Deep Learning \n",
"185 Anna Johnson 1964 10 Intro to Deep Learning \n",
"186 Ethan Hudson 1988 8 Intro to Deep Learning \n",
"187 Oliver Nicholas 1994 4 Intro to Deep Learning \n",
"188 Carter Jose 1992 2 Intro to Deep Learning \n",
"189 Andrew Ezra 1980 10 Intro to Deep Learning \n",
"190 Jack Kevin 1996 2 Intro to Deep Learning \n",
"191 Caleb Leonardo 1988 9 Intro to Deep Learning \n",
"192 Hunter Greyson 1995 20 Intro to Deep Learning \n",
"193 Clara Setkin 1988 8 Intro to Deep Learning \n",
"194 Noah Eli 1980 2 Intro to Deep Learning \n",
"195 Benjamin Cameron 1983 11 Intro to Deep Learning \n",
"196 Michael Mateo 1984 2 Intro to Deep Learning \n",
"197 Aiden Jordan 1997 10 Intro to Deep Learning \n",
"198 Samuel Dominic 1983 3 Intro to Deep Learning \n",
"199 Isaac Jaxson 1997 5 Intro to Deep Learning \n",
"200 Wyatt Jason 2000 3 Intro to Deep Learning \n",
"201 Andrew Ezra 1980 10 Intro to Deep Learning \n",
"202 Christopher Parker 1982 4 Intro to Deep Learning \n",
"203 Thomas Brandon 1988 9 Intro to Deep Learning \n",
"204 Lincoln Kayden 1997 3 Intro to Deep Learning \n",
"205 Charles Ryder 1984 15 Intro to Deep Learning \n",
"\n",
" instructor \n",
"0 Michael Jackson \n",
"1 Michael Jackson \n",
"2 Michael Jackson \n",
"3 Michael Jackson \n",
"4 Michael Jackson \n",
"5 Michael Jackson \n",
"6 Michael Jackson \n",
"7 Michael Jackson \n",
"8 Michael Jackson \n",
"9 Michael Jackson \n",
"10 Michael Jackson \n",
"11 Michael Jackson \n",
"12 Michael Jackson \n",
"13 Michael Jackson \n",
"14 Michael Jackson \n",
"15 Michael Jackson \n",
"16 Michael Jackson \n",
"17 Michael Jackson \n",
"18 Michael Jackson \n",
"19 Michael Jackson \n",
"20 Michael Jackson \n",
"21 Michael Jackson \n",
"22 Michael Jackson \n",
"23 Michael Jackson \n",
"24 Michael Jackson \n",
"25 Michael Jackson \n",
"26 Michael Jackson \n",
"27 Michael Jackson \n",
"28 Michael Jackson \n",
"29 Michael Jackson \n",
".. ... \n",
"176 Emma Watson \n",
"177 Emma Watson \n",
"178 Emma Watson \n",
"179 Emma Watson \n",
"180 Emma Watson \n",
"181 Emma Watson \n",
"182 Emma Watson \n",
"183 Emma Watson \n",
"184 Emma Watson \n",
"185 Emma Watson \n",
"186 Emma Watson \n",
"187 Emma Watson \n",
"188 Emma Watson \n",
"189 Emma Watson \n",
"190 Emma Watson \n",
"191 Emma Watson \n",
"192 Emma Watson \n",
"193 Emma Watson \n",
"194 Emma Watson \n",
"195 Emma Watson \n",
"196 Emma Watson \n",
"197 Emma Watson \n",
"198 Emma Watson \n",
"199 Emma Watson \n",
"200 Emma Watson \n",
"201 Emma Watson \n",
"202 Emma Watson \n",
"203 Emma Watson \n",
"204 Emma Watson \n",
"205 Emma Watson \n",
"\n",
"[206 rows x 6 columns]"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"course_user[[\"first_name\", \"last_name\", \"birth_year\", \"points\", \"course_name\", \"instructor\"]]"
]
}
],
"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