API tools faq
paste
Guest User

Untitled

a guest
Jun 9th, 2018
519
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.25 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 18,
  6. "metadata": {},
  7. "outputs": [],
  8. "source": [
  9. "at_users = pd.merge(attendace[[\"user_id\", \"course_id\"]], users, how='left', left_on='user_id', right_on='id')"
  10. ]
  11. },
  12. {
  13. "cell_type": "code",
  14. "execution_count": 19,
  15. "metadata": {},
  16. "outputs": [
  17. {
  18. "data": {
  19. "text/html": [
  20. "<div>\n",
  21. "<style scoped>\n",
  22. " .dataframe tbody tr th:only-of-type {\n",
  23. " vertical-align: middle;\n",
  24. " }\n",
  25. "\n",
  26. " .dataframe tbody tr th {\n",
  27. " vertical-align: top;\n",
  28. " }\n",
  29. "\n",
  30. " .dataframe thead th {\n",
  31. " text-align: right;\n",
  32. " }\n",
  33. "</style>\n",
  34. "<table border=\"1\" class=\"dataframe\">\n",
  35. " <thead>\n",
  36. " <tr style=\"text-align: right;\">\n",
  37. " <th></th>\n",
  38. " <th>user_id</th>\n",
  39. " <th>course_id</th>\n",
  40. " <th>id</th>\n",
  41. " <th>username</th>\n",
  42. " <th>first_name</th>\n",
  43. " <th>last_name</th>\n",
  44. " <th>birth_year</th>\n",
  45. " <th>points</th>\n",
  46. " <th>email</th>\n",
  47. " </tr>\n",
  48. " </thead>\n",
  49. " <tbody>\n",
  50. " <tr>\n",
  51. " <th>0</th>\n",
  52. " <td>1</td>\n",
  53. " <td>2</td>\n",
  54. " <td>1</td>\n",
  55. " <td>john</td>\n",
  56. " <td>John</td>\n",
  57. " <td>Smith</td>\n",
  58. " <td>1985</td>\n",
  59. " <td>5</td>\n",
  60. " <td>john@email.com</td>\n",
  61. " </tr>\n",
  62. " <tr>\n",
  63. " <th>1</th>\n",
  64. " <td>2</td>\n",
  65. " <td>1</td>\n",
  66. " <td>2</td>\n",
  67. " <td>jack</td>\n",
  68. " <td>Jack</td>\n",
  69. " <td>Wilson</td>\n",
  70. " <td>1994</td>\n",
  71. " <td>15</td>\n",
  72. " <td>wilson@sss.com</td>\n",
  73. " </tr>\n",
  74. " <tr>\n",
  75. " <th>2</th>\n",
  76. " <td>3</td>\n",
  77. " <td>4</td>\n",
  78. " <td>3</td>\n",
  79. " <td>clara</td>\n",
  80. " <td>Clara</td>\n",
  81. " <td>Setkin</td>\n",
  82. " <td>1988</td>\n",
  83. " <td>8</td>\n",
  84. " <td>clara@gmail.com</td>\n",
  85. " </tr>\n",
  86. " <tr>\n",
  87. " <th>3</th>\n",
  88. " <td>4</td>\n",
  89. " <td>4</td>\n",
  90. " <td>4</td>\n",
  91. " <td>ann</td>\n",
  92. " <td>Anna</td>\n",
  93. " <td>Johnson</td>\n",
  94. " <td>1964</td>\n",
  95. " <td>10</td>\n",
  96. " <td>NaN</td>\n",
  97. " </tr>\n",
  98. " <tr>\n",
  99. " <th>4</th>\n",
  100. " <td>5</td>\n",
  101. " <td>5</td>\n",
  102. " <td>5</td>\n",
  103. " <td>noah.eli</td>\n",
  104. " <td>Noah</td>\n",
  105. " <td>Eli</td>\n",
  106. " <td>1980</td>\n",
  107. " <td>2</td>\n",
  108. " <td>noah.eli@example.com</td>\n",
  109. " </tr>\n",
  110. " <tr>\n",
  111. " <th>5</th>\n",
  112. " <td>6</td>\n",
  113. " <td>7</td>\n",
  114. " <td>6</td>\n",
  115. " <td>liam.landon</td>\n",
  116. " <td>Liam</td>\n",
  117. " <td>Landon</td>\n",
  118. " <td>1995</td>\n",
  119. " <td>1</td>\n",
  120. " <td>liam.landon@example.com</td>\n",
  121. " </tr>\n",
  122. " <tr>\n",
  123. " <th>6</th>\n",
  124. " <td>7</td>\n",
  125. " <td>4</td>\n",
  126. " <td>7</td>\n",
  127. " <td>william.connor</td>\n",
  128. " <td>William</td>\n",
  129. " <td>Connor</td>\n",
  130. " <td>1996</td>\n",
  131. " <td>8</td>\n",
  132. " <td>william.connor@example.com</td>\n",
  133. " </tr>\n",
  134. " <tr>\n",
  135. " <th>7</th>\n",
  136. " <td>8</td>\n",
  137. " <td>3</td>\n",
  138. " <td>8</td>\n",
  139. " <td>mason.josiah</td>\n",
  140. " <td>Mason</td>\n",
  141. " <td>Josiah</td>\n",
  142. " <td>1990</td>\n",
  143. " <td>13</td>\n",
  144. " <td>mason.josiah@example.com</td>\n",
  145. " </tr>\n",
  146. " <tr>\n",
  147. " <th>8</th>\n",
  148. " <td>9</td>\n",
  149. " <td>3</td>\n",
  150. " <td>9</td>\n",
  151. " <td>james.jonathan</td>\n",
  152. " <td>James</td>\n",
  153. " <td>Jonathan</td>\n",
  154. " <td>1993</td>\n",
  155. " <td>9</td>\n",
  156. " <td>james.jonathan@example.com</td>\n",
  157. " </tr>\n",
  158. " <tr>\n",
  159. " <th>9</th>\n",
  160. " <td>10</td>\n",
  161. " <td>5</td>\n",
  162. " <td>10</td>\n",
  163. " <td>benjamin.cameron</td>\n",
  164. " <td>Benjamin</td>\n",
  165. " <td>Cameron</td>\n",
  166. " <td>1983</td>\n",
  167. " <td>11</td>\n",
  168. " <td>benjamin.cameron@example.com</td>\n",
  169. " </tr>\n",
  170. " <tr>\n",
  171. " <th>10</th>\n",
  172. " <td>11</td>\n",
  173. " <td>6</td>\n",
  174. " <td>11</td>\n",
  175. " <td>jacob.jeremiah</td>\n",
  176. " <td>Jacob</td>\n",
  177. " <td>Jeremiah</td>\n",
  178. " <td>1982</td>\n",
  179. " <td>3</td>\n",
  180. " <td>jacob.jeremiah@example.com</td>\n",
  181. " </tr>\n",
  182. " <tr>\n",
  183. " <th>11</th>\n",
  184. " <td>12</td>\n",
  185. " <td>6</td>\n",
  186. " <td>12</td>\n",
  187. " <td>michael.mateo</td>\n",
  188. " <td>Michael</td>\n",
  189. " <td>Mateo</td>\n",
  190. " <td>1984</td>\n",
  191. " <td>2</td>\n",
  192. " <td>michael.mateo@example.com</td>\n",
  193. " </tr>\n",
  194. " <tr>\n",
  195. " <th>12</th>\n",
  196. " <td>13</td>\n",
  197. " <td>1</td>\n",
  198. " <td>13</td>\n",
  199. " <td>elijah.adrian</td>\n",
  200. " <td>Elijah</td>\n",
  201. " <td>Adrian</td>\n",
  202. " <td>1994</td>\n",
  203. " <td>6</td>\n",
  204. " <td>elijah.adrian@example.com</td>\n",
  205. " </tr>\n",
  206. " <tr>\n",
  207. " <th>13</th>\n",
  208. " <td>14</td>\n",
  209. " <td>4</td>\n",
  210. " <td>14</td>\n",
  211. " <td>ethan.hudson</td>\n",
  212. " <td>Ethan</td>\n",
  213. " <td>Hudson</td>\n",
  214. " <td>1988</td>\n",
  215. " <td>8</td>\n",
  216. " <td>ethan.hudson@example.com</td>\n",
  217. " </tr>\n",
  218. " <tr>\n",
  219. " <th>14</th>\n",
  220. " <td>15</td>\n",
  221. " <td>3</td>\n",
  222. " <td>15</td>\n",
  223. " <td>alexander.robert</td>\n",
  224. " <td>Alexander</td>\n",
  225. " <td>Robert</td>\n",
  226. " <td>1982</td>\n",
  227. " <td>18</td>\n",
  228. " <td>alexander.robert@example.com</td>\n",
  229. " </tr>\n",
  230. " <tr>\n",
  231. " <th>15</th>\n",
  232. " <td>16</td>\n",
  233. " <td>6</td>\n",
  234. " <td>16</td>\n",
  235. " <td>oliver.nicholas</td>\n",
  236. " <td>Oliver</td>\n",
  237. " <td>Nicholas</td>\n",
  238. " <td>1994</td>\n",
  239. " <td>4</td>\n",
  240. " <td>oliver.nicholas@example.com</td>\n",
  241. " </tr>\n",
  242. " <tr>\n",
  243. " <th>16</th>\n",
  244. " <td>17</td>\n",
  245. " <td>4</td>\n",
  246. " <td>17</td>\n",
  247. " <td>daniel.brayden</td>\n",
  248. " <td>Daniel</td>\n",
  249. " <td>Brayden</td>\n",
  250. " <td>1983</td>\n",
  251. " <td>1</td>\n",
  252. " <td>daniel.brayden@example.com</td>\n",
  253. " </tr>\n",
  254. " <tr>\n",
  255. " <th>17</th>\n",
  256. " <td>18</td>\n",
  257. " <td>3</td>\n",
  258. " <td>18</td>\n",
  259. " <td>lucas.nolan</td>\n",
  260. " <td>Lucas</td>\n",
  261. " <td>Nolan</td>\n",
  262. " <td>1994</td>\n",
  263. " <td>12</td>\n",
  264. " <td>lucas.nolan@example.com</td>\n",
  265. " </tr>\n",
  266. " <tr>\n",
  267. " <th>18</th>\n",
  268. " <td>19</td>\n",
  269. " <td>3</td>\n",
  270. " <td>19</td>\n",
  271. " <td>matthew.easton</td>\n",
  272. " <td>Matthew</td>\n",
  273. " <td>Easton</td>\n",
  274. " <td>1989</td>\n",
  275. " <td>17</td>\n",
  276. " <td>matthew.easton@example.com</td>\n",
  277. " </tr>\n",
  278. " <tr>\n",
  279. " <th>19</th>\n",
  280. " <td>20</td>\n",
  281. " <td>4</td>\n",
  282. " <td>20</td>\n",
  283. " <td>aiden.jordan</td>\n",
  284. " <td>Aiden</td>\n",
  285. " <td>Jordan</td>\n",
  286. " <td>1997</td>\n",
  287. " <td>10</td>\n",
  288. " <td>aiden.jordan@example.com</td>\n",
  289. " </tr>\n",
  290. " <tr>\n",
  291. " <th>20</th>\n",
  292. " <td>21</td>\n",
  293. " <td>4</td>\n",
  294. " <td>21</td>\n",
  295. " <td>jackson.colton</td>\n",
  296. " <td>Jackson</td>\n",
  297. " <td>Colton</td>\n",
  298. " <td>1993</td>\n",
  299. " <td>13</td>\n",
  300. " <td>jackson.colton@example.com</td>\n",
  301. " </tr>\n",
  302. " <tr>\n",
  303. " <th>21</th>\n",
  304. " <td>22</td>\n",
  305. " <td>4</td>\n",
  306. " <td>22</td>\n",
  307. " <td>logan.evan</td>\n",
  308. " <td>Logan</td>\n",
  309. " <td>Evan</td>\n",
  310. " <td>1998</td>\n",
  311. " <td>12</td>\n",
  312. " <td>logan.evan@example.com</td>\n",
  313. " </tr>\n",
  314. " <tr>\n",
  315. " <th>22</th>\n",
  316. " <td>23</td>\n",
  317. " <td>4</td>\n",
  318. " <td>23</td>\n",
  319. " <td>david.angel</td>\n",
  320. " <td>David</td>\n",
  321. " <td>Angel</td>\n",
  322. " <td>1989</td>\n",
  323. " <td>5</td>\n",
  324. " <td>david.angel@example.com</td>\n",
  325. " </tr>\n",
  326. " <tr>\n",
  327. " <th>23</th>\n",
  328. " <td>24</td>\n",
  329. " <td>6</td>\n",
  330. " <td>24</td>\n",
  331. " <td>joseph.asher</td>\n",
  332. " <td>Joseph</td>\n",
  333. " <td>Asher</td>\n",
  334. " <td>1989</td>\n",
  335. " <td>19</td>\n",
  336. " <td>joseph.asher@example.com</td>\n",
  337. " </tr>\n",
  338. " <tr>\n",
  339. " <th>24</th>\n",
  340. " <td>25</td>\n",
  341. " <td>5</td>\n",
  342. " <td>25</td>\n",
  343. " <td>samuel.dominic</td>\n",
  344. " <td>Samuel</td>\n",
  345. " <td>Dominic</td>\n",
  346. " <td>1983</td>\n",
  347. " <td>3</td>\n",
  348. " <td>samuel.dominic@example.com</td>\n",
  349. " </tr>\n",
  350. " <tr>\n",
  351. " <th>25</th>\n",
  352. " <td>26</td>\n",
  353. " <td>6</td>\n",
  354. " <td>26</td>\n",
  355. " <td>henry.austin</td>\n",
  356. " <td>Henry</td>\n",
  357. " <td>Austin</td>\n",
  358. " <td>1987</td>\n",
  359. " <td>18</td>\n",
  360. " <td>henry.austin@example.com</td>\n",
  361. " </tr>\n",
  362. " <tr>\n",
  363. " <th>26</th>\n",
  364. " <td>27</td>\n",
  365. " <td>4</td>\n",
  366. " <td>27</td>\n",
  367. " <td>owen.leo</td>\n",
  368. " <td>Owen</td>\n",
  369. " <td>Leo</td>\n",
  370. " <td>1981</td>\n",
  371. " <td>17</td>\n",
  372. " <td>owen.leo@example.com</td>\n",
  373. " </tr>\n",
  374. " <tr>\n",
  375. " <th>27</th>\n",
  376. " <td>28</td>\n",
  377. " <td>6</td>\n",
  378. " <td>28</td>\n",
  379. " <td>sebastian.adam</td>\n",
  380. " <td>Sebastian</td>\n",
  381. " <td>Adam</td>\n",
  382. " <td>1980</td>\n",
  383. " <td>10</td>\n",
  384. " <td>sebastian.adam@example.com</td>\n",
  385. " </tr>\n",
  386. " <tr>\n",
  387. " <th>28</th>\n",
  388. " <td>29</td>\n",
  389. " <td>6</td>\n",
  390. " <td>29</td>\n",
  391. " <td>gabriel.jace</td>\n",
  392. " <td>Gabriel</td>\n",
  393. " <td>Jace</td>\n",
  394. " <td>1981</td>\n",
  395. " <td>8</td>\n",
  396. " <td>gabriel.jace@example.com</td>\n",
  397. " </tr>\n",
  398. " <tr>\n",
  399. " <th>29</th>\n",
  400. " <td>30</td>\n",
  401. " <td>2</td>\n",
  402. " <td>30</td>\n",
  403. " <td>carter.jose</td>\n",
  404. " <td>Carter</td>\n",
  405. " <td>Jose</td>\n",
  406. " <td>1992</td>\n",
  407. " <td>2</td>\n",
  408. " <td>carter.jose@example.com</td>\n",
  409. " </tr>\n",
  410. " <tr>\n",
  411. " <th>...</th>\n",
  412. " <td>...</td>\n",
  413. " <td>...</td>\n",
  414. " <td>...</td>\n",
  415. " <td>...</td>\n",
  416. " <td>...</td>\n",
  417. " <td>...</td>\n",
  418. " <td>...</td>\n",
  419. " <td>...</td>\n",
  420. " <td>...</td>\n",
  421. " </tr>\n",
  422. " <tr>\n",
  423. " <th>190</th>\n",
  424. " <td>26</td>\n",
  425. " <td>1</td>\n",
  426. " <td>26</td>\n",
  427. " <td>henry.austin</td>\n",
  428. " <td>Henry</td>\n",
  429. " <td>Austin</td>\n",
  430. " <td>1987</td>\n",
  431. " <td>18</td>\n",
  432. " <td>henry.austin@example.com</td>\n",
  433. " </tr>\n",
  434. " <tr>\n",
  435. " <th>191</th>\n",
  436. " <td>27</td>\n",
  437. " <td>5</td>\n",
  438. " <td>27</td>\n",
  439. " <td>owen.leo</td>\n",
  440. " <td>Owen</td>\n",
  441. " <td>Leo</td>\n",
  442. " <td>1981</td>\n",
  443. " <td>17</td>\n",
  444. " <td>owen.leo@example.com</td>\n",
  445. " </tr>\n",
  446. " <tr>\n",
  447. " <th>192</th>\n",
  448. " <td>28</td>\n",
  449. " <td>2</td>\n",
  450. " <td>28</td>\n",
  451. " <td>sebastian.adam</td>\n",
  452. " <td>Sebastian</td>\n",
  453. " <td>Adam</td>\n",
  454. " <td>1980</td>\n",
  455. " <td>10</td>\n",
  456. " <td>sebastian.adam@example.com</td>\n",
  457. " </tr>\n",
  458. " <tr>\n",
  459. " <th>193</th>\n",
  460. " <td>29</td>\n",
  461. " <td>1</td>\n",
  462. " <td>29</td>\n",
  463. " <td>gabriel.jace</td>\n",
  464. " <td>Gabriel</td>\n",
  465. " <td>Jace</td>\n",
  466. " <td>1981</td>\n",
  467. " <td>8</td>\n",
  468. " <td>gabriel.jace@example.com</td>\n",
  469. " </tr>\n",
  470. " <tr>\n",
  471. " <th>194</th>\n",
  472. " <td>30</td>\n",
  473. " <td>2</td>\n",
  474. " <td>30</td>\n",
  475. " <td>carter.jose</td>\n",
  476. " <td>Carter</td>\n",
  477. " <td>Jose</td>\n",
  478. " <td>1992</td>\n",
  479. " <td>2</td>\n",
  480. " <td>carter.jose@example.com</td>\n",
  481. " </tr>\n",
  482. " <tr>\n",
  483. " <th>195</th>\n",
  484. " <td>31</td>\n",
  485. " <td>1</td>\n",
  486. " <td>31</td>\n",
  487. " <td>jayden.ian</td>\n",
  488. " <td>Jayden</td>\n",
  489. " <td>Ian</td>\n",
  490. " <td>1998</td>\n",
  491. " <td>10</td>\n",
  492. " <td>jayden.ian@example.com</td>\n",
  493. " </tr>\n",
  494. " <tr>\n",
  495. " <th>196</th>\n",
  496. " <td>32</td>\n",
  497. " <td>4</td>\n",
  498. " <td>32</td>\n",
  499. " <td>john.cooper</td>\n",
  500. " <td>John</td>\n",
  501. " <td>Cooper</td>\n",
  502. " <td>1996</td>\n",
  503. " <td>5</td>\n",
  504. " <td>john.cooper@example.com</td>\n",
  505. " </tr>\n",
  506. " <tr>\n",
  507. " <th>197</th>\n",
  508. " <td>33</td>\n",
  509. " <td>5</td>\n",
  510. " <td>33</td>\n",
  511. " <td>luke.gavin</td>\n",
  512. " <td>Luke</td>\n",
  513. " <td>Gavin</td>\n",
  514. " <td>1980</td>\n",
  515. " <td>15</td>\n",
  516. " <td>luke.gavin@example.com</td>\n",
  517. " </tr>\n",
  518. " <tr>\n",
  519. " <th>198</th>\n",
  520. " <td>34</td>\n",
  521. " <td>3</td>\n",
  522. " <td>34</td>\n",
  523. " <td>anthony.carson</td>\n",
  524. " <td>Anthony</td>\n",
  525. " <td>Carson</td>\n",
  526. " <td>1989</td>\n",
  527. " <td>8</td>\n",
  528. " <td>anthony.carson@example.com</td>\n",
  529. " </tr>\n",
  530. " <tr>\n",
  531. " <th>199</th>\n",
  532. " <td>35</td>\n",
  533. " <td>6</td>\n",
  534. " <td>35</td>\n",
  535. " <td>isaac.jaxson</td>\n",
  536. " <td>Isaac</td>\n",
  537. " <td>Jaxson</td>\n",
  538. " <td>1997</td>\n",
  539. " <td>5</td>\n",
  540. " <td>isaac.jaxson@example.com</td>\n",
  541. " </tr>\n",
  542. " <tr>\n",
  543. " <th>200</th>\n",
  544. " <td>36</td>\n",
  545. " <td>4</td>\n",
  546. " <td>36</td>\n",
  547. " <td>dylan.theodore</td>\n",
  548. " <td>Dylan</td>\n",
  549. " <td>Theodore</td>\n",
  550. " <td>1991</td>\n",
  551. " <td>1</td>\n",
  552. " <td>dylan.theodore@example.com</td>\n",
  553. " </tr>\n",
  554. " <tr>\n",
  555. " <th>201</th>\n",
  556. " <td>37</td>\n",
  557. " <td>6</td>\n",
  558. " <td>37</td>\n",
  559. " <td>wyatt.jason</td>\n",
  560. " <td>Wyatt</td>\n",
  561. " <td>Jason</td>\n",
  562. " <td>2000</td>\n",
  563. " <td>3</td>\n",
  564. " <td>wyatt.jason@example.com</td>\n",
  565. " </tr>\n",
  566. " <tr>\n",
  567. " <th>202</th>\n",
  568. " <td>38</td>\n",
  569. " <td>6</td>\n",
  570. " <td>38</td>\n",
  571. " <td>andrew.ezra</td>\n",
  572. " <td>Andrew</td>\n",
  573. " <td>Ezra</td>\n",
  574. " <td>1980</td>\n",
  575. " <td>10</td>\n",
  576. " <td>andrew.ezra@example.com</td>\n",
  577. " </tr>\n",
  578. " <tr>\n",
  579. " <th>203</th>\n",
  580. " <td>39</td>\n",
  581. " <td>2</td>\n",
  582. " <td>39</td>\n",
  583. " <td>joshua.chase</td>\n",
  584. " <td>Joshua</td>\n",
  585. " <td>Chase</td>\n",
  586. " <td>1990</td>\n",
  587. " <td>17</td>\n",
  588. " <td>joshua.chase@example.com</td>\n",
  589. " </tr>\n",
  590. " <tr>\n",
  591. " <th>204</th>\n",
  592. " <td>40</td>\n",
  593. " <td>6</td>\n",
  594. " <td>40</td>\n",
  595. " <td>christopher.parker</td>\n",
  596. " <td>Christopher</td>\n",
  597. " <td>Parker</td>\n",
  598. " <td>1982</td>\n",
  599. " <td>4</td>\n",
  600. " <td>christopher.parker@example.com</td>\n",
  601. " </tr>\n",
  602. " <tr>\n",
  603. " <th>205</th>\n",
  604. " <td>41</td>\n",
  605. " <td>5</td>\n",
  606. " <td>41</td>\n",
  607. " <td>grayson.xavier</td>\n",
  608. " <td>Grayson</td>\n",
  609. " <td>Xavier</td>\n",
  610. " <td>1991</td>\n",
  611. " <td>3</td>\n",
  612. " <td>grayson.xavier@example.com</td>\n",
  613. " </tr>\n",
  614. " <tr>\n",
  615. " <th>206</th>\n",
  616. " <td>42</td>\n",
  617. " <td>7</td>\n",
  618. " <td>42</td>\n",
  619. " <td>jack.kevin</td>\n",
  620. " <td>Jack</td>\n",
  621. " <td>Kevin</td>\n",
  622. " <td>1996</td>\n",
  623. " <td>2</td>\n",
  624. " <td>jack.kevin@example.com</td>\n",
  625. " </tr>\n",
  626. " <tr>\n",
  627. " <th>207</th>\n",
  628. " <td>43</td>\n",
  629. " <td>2</td>\n",
  630. " <td>43</td>\n",
  631. " <td>julian.zachary</td>\n",
  632. " <td>Julian</td>\n",
  633. " <td>Zachary</td>\n",
  634. " <td>1995</td>\n",
  635. " <td>13</td>\n",
  636. " <td>julian.zachary@example.com</td>\n",
  637. " </tr>\n",
  638. " <tr>\n",
  639. " <th>208</th>\n",
  640. " <td>44</td>\n",
  641. " <td>1</td>\n",
  642. " <td>44</td>\n",
  643. " <td>ryan.tyler</td>\n",
  644. " <td>Ryan</td>\n",
  645. " <td>Tyler</td>\n",
  646. " <td>1996</td>\n",
  647. " <td>1</td>\n",
  648. " <td>ryan.tyler@example.com</td>\n",
  649. " </tr>\n",
  650. " <tr>\n",
  651. " <th>209</th>\n",
  652. " <td>45</td>\n",
  653. " <td>3</td>\n",
  654. " <td>45</td>\n",
  655. " <td>jaxon.ayden</td>\n",
  656. " <td>Jaxon</td>\n",
  657. " <td>Ayden</td>\n",
  658. " <td>1987</td>\n",
  659. " <td>11</td>\n",
  660. " <td>jaxon.ayden@example.com</td>\n",
  661. " </tr>\n",
  662. " <tr>\n",
  663. " <th>210</th>\n",
  664. " <td>46</td>\n",
  665. " <td>7</td>\n",
  666. " <td>46</td>\n",
  667. " <td>levi.elias</td>\n",
  668. " <td>Levi</td>\n",
  669. " <td>Elias</td>\n",
  670. " <td>1992</td>\n",
  671. " <td>11</td>\n",
  672. " <td>levi.elias@example.com</td>\n",
  673. " </tr>\n",
  674. " <tr>\n",
  675. " <th>211</th>\n",
  676. " <td>47</td>\n",
  677. " <td>7</td>\n",
  678. " <td>47</td>\n",
  679. " <td>nathan.bryson</td>\n",
  680. " <td>Nathan</td>\n",
  681. " <td>Bryson</td>\n",
  682. " <td>1995</td>\n",
  683. " <td>8</td>\n",
  684. " <td>nathan.bryson@example.com</td>\n",
  685. " </tr>\n",
  686. " <tr>\n",
  687. " <th>212</th>\n",
  688. " <td>48</td>\n",
  689. " <td>3</td>\n",
  690. " <td>48</td>\n",
  691. " <td>caleb.leonardo</td>\n",
  692. " <td>Caleb</td>\n",
  693. " <td>Leonardo</td>\n",
  694. " <td>1988</td>\n",
  695. " <td>9</td>\n",
  696. " <td>caleb.leonardo@example.com</td>\n",
  697. " </tr>\n",
  698. " <tr>\n",
  699. " <th>213</th>\n",
  700. " <td>49</td>\n",
  701. " <td>5</td>\n",
  702. " <td>49</td>\n",
  703. " <td>hunter.greyson</td>\n",
  704. " <td>Hunter</td>\n",
  705. " <td>Greyson</td>\n",
  706. " <td>1995</td>\n",
  707. " <td>20</td>\n",
  708. " <td>hunter.greyson@example.com</td>\n",
  709. " </tr>\n",
  710. " <tr>\n",
  711. " <th>214</th>\n",
  712. " <td>50</td>\n",
  713. " <td>7</td>\n",
  714. " <td>50</td>\n",
  715. " <td>christian.sawyer</td>\n",
  716. " <td>Christian</td>\n",
  717. " <td>Sawyer</td>\n",
  718. " <td>1993</td>\n",
  719. " <td>12</td>\n",
  720. " <td>christian.sawyer@example.com</td>\n",
  721. " </tr>\n",
  722. " <tr>\n",
  723. " <th>215</th>\n",
  724. " <td>51</td>\n",
  725. " <td>1</td>\n",
  726. " <td>51</td>\n",
  727. " <td>isaiah.roman</td>\n",
  728. " <td>Isaiah</td>\n",
  729. " <td>Roman</td>\n",
  730. " <td>1987</td>\n",
  731. " <td>13</td>\n",
  732. " <td>isaiah.roman@example.com</td>\n",
  733. " </tr>\n",
  734. " <tr>\n",
  735. " <th>216</th>\n",
  736. " <td>52</td>\n",
  737. " <td>6</td>\n",
  738. " <td>52</td>\n",
  739. " <td>thomas.brandon</td>\n",
  740. " <td>Thomas</td>\n",
  741. " <td>Brandon</td>\n",
  742. " <td>1988</td>\n",
  743. " <td>9</td>\n",
  744. " <td>thomas.brandon@example.com</td>\n",
  745. " </tr>\n",
  746. " <tr>\n",
  747. " <th>217</th>\n",
  748. " <td>53</td>\n",
  749. " <td>5</td>\n",
  750. " <td>53</td>\n",
  751. " <td>aaron.bentley</td>\n",
  752. " <td>Aaron</td>\n",
  753. " <td>Bentley</td>\n",
  754. " <td>1984</td>\n",
  755. " <td>4</td>\n",
  756. " <td>aaron.bentley@example.com</td>\n",
  757. " </tr>\n",
  758. " <tr>\n",
  759. " <th>218</th>\n",
  760. " <td>54</td>\n",
  761. " <td>6</td>\n",
  762. " <td>54</td>\n",
  763. " <td>lincoln.kayden</td>\n",
  764. " <td>Lincoln</td>\n",
  765. " <td>Kayden</td>\n",
  766. " <td>1997</td>\n",
  767. " <td>3</td>\n",
  768. " <td>lincoln.kayden@example.com</td>\n",
  769. " </tr>\n",
  770. " <tr>\n",
  771. " <th>219</th>\n",
  772. " <td>55</td>\n",
  773. " <td>6</td>\n",
  774. " <td>55</td>\n",
  775. " <td>charles.ryder</td>\n",
  776. " <td>Charles</td>\n",
  777. " <td>Ryder</td>\n",
  778. " <td>1984</td>\n",
  779. " <td>15</td>\n",
  780. " <td>charles.ryder@example.com</td>\n",
  781. " </tr>\n",
  782. " </tbody>\n",
  783. "</table>\n",
  784. "<p>220 rows × 9 columns</p>\n",
  785. "</div>"
  786. ],
  787. "text/plain": [
  788. " user_id course_id id username first_name last_name \\\n",
  789. "0 1 2 1 john John Smith \n",
  790. "1 2 1 2 jack Jack Wilson \n",
  791. "2 3 4 3 clara Clara Setkin \n",
  792. "3 4 4 4 ann Anna Johnson \n",
  793. "4 5 5 5 noah.eli Noah Eli \n",
  794. "5 6 7 6 liam.landon Liam Landon \n",
  795. "6 7 4 7 william.connor William Connor \n",
  796. "7 8 3 8 mason.josiah Mason Josiah \n",
  797. "8 9 3 9 james.jonathan James Jonathan \n",
  798. "9 10 5 10 benjamin.cameron Benjamin Cameron \n",
  799. "10 11 6 11 jacob.jeremiah Jacob Jeremiah \n",
  800. "11 12 6 12 michael.mateo Michael Mateo \n",
  801. "12 13 1 13 elijah.adrian Elijah Adrian \n",
  802. "13 14 4 14 ethan.hudson Ethan Hudson \n",
  803. "14 15 3 15 alexander.robert Alexander Robert \n",
  804. "15 16 6 16 oliver.nicholas Oliver Nicholas \n",
  805. "16 17 4 17 daniel.brayden Daniel Brayden \n",
  806. "17 18 3 18 lucas.nolan Lucas Nolan \n",
  807. "18 19 3 19 matthew.easton Matthew Easton \n",
  808. "19 20 4 20 aiden.jordan Aiden Jordan \n",
  809. "20 21 4 21 jackson.colton Jackson Colton \n",
  810. "21 22 4 22 logan.evan Logan Evan \n",
  811. "22 23 4 23 david.angel David Angel \n",
  812. "23 24 6 24 joseph.asher Joseph Asher \n",
  813. "24 25 5 25 samuel.dominic Samuel Dominic \n",
  814. "25 26 6 26 henry.austin Henry Austin \n",
  815. "26 27 4 27 owen.leo Owen Leo \n",
  816. "27 28 6 28 sebastian.adam Sebastian Adam \n",
  817. "28 29 6 29 gabriel.jace Gabriel Jace \n",
  818. "29 30 2 30 carter.jose Carter Jose \n",
  819. ".. ... ... .. ... ... ... \n",
  820. "190 26 1 26 henry.austin Henry Austin \n",
  821. "191 27 5 27 owen.leo Owen Leo \n",
  822. "192 28 2 28 sebastian.adam Sebastian Adam \n",
  823. "193 29 1 29 gabriel.jace Gabriel Jace \n",
  824. "194 30 2 30 carter.jose Carter Jose \n",
  825. "195 31 1 31 jayden.ian Jayden Ian \n",
  826. "196 32 4 32 john.cooper John Cooper \n",
  827. "197 33 5 33 luke.gavin Luke Gavin \n",
  828. "198 34 3 34 anthony.carson Anthony Carson \n",
  829. "199 35 6 35 isaac.jaxson Isaac Jaxson \n",
  830. "200 36 4 36 dylan.theodore Dylan Theodore \n",
  831. "201 37 6 37 wyatt.jason Wyatt Jason \n",
  832. "202 38 6 38 andrew.ezra Andrew Ezra \n",
  833. "203 39 2 39 joshua.chase Joshua Chase \n",
  834. "204 40 6 40 christopher.parker Christopher Parker \n",
  835. "205 41 5 41 grayson.xavier Grayson Xavier \n",
  836. "206 42 7 42 jack.kevin Jack Kevin \n",
  837. "207 43 2 43 julian.zachary Julian Zachary \n",
  838. "208 44 1 44 ryan.tyler Ryan Tyler \n",
  839. "209 45 3 45 jaxon.ayden Jaxon Ayden \n",
  840. "210 46 7 46 levi.elias Levi Elias \n",
  841. "211 47 7 47 nathan.bryson Nathan Bryson \n",
  842. "212 48 3 48 caleb.leonardo Caleb Leonardo \n",
  843. "213 49 5 49 hunter.greyson Hunter Greyson \n",
  844. "214 50 7 50 christian.sawyer Christian Sawyer \n",
  845. "215 51 1 51 isaiah.roman Isaiah Roman \n",
  846. "216 52 6 52 thomas.brandon Thomas Brandon \n",
  847. "217 53 5 53 aaron.bentley Aaron Bentley \n",
  848. "218 54 6 54 lincoln.kayden Lincoln Kayden \n",
  849. "219 55 6 55 charles.ryder Charles Ryder \n",
  850. "\n",
  851. " birth_year points email \n",
  852. "0 1985 5 john@email.com \n",
  853. "1 1994 15 wilson@sss.com \n",
  854. "2 1988 8 clara@gmail.com \n",
  855. "3 1964 10 NaN \n",
  856. "4 1980 2 noah.eli@example.com \n",
  857. "5 1995 1 liam.landon@example.com \n",
  858. "6 1996 8 william.connor@example.com \n",
  859. "7 1990 13 mason.josiah@example.com \n",
  860. "8 1993 9 james.jonathan@example.com \n",
  861. "9 1983 11 benjamin.cameron@example.com \n",
  862. "10 1982 3 jacob.jeremiah@example.com \n",
  863. "11 1984 2 michael.mateo@example.com \n",
  864. "12 1994 6 elijah.adrian@example.com \n",
  865. "13 1988 8 ethan.hudson@example.com \n",
  866. "14 1982 18 alexander.robert@example.com \n",
  867. "15 1994 4 oliver.nicholas@example.com \n",
  868. "16 1983 1 daniel.brayden@example.com \n",
  869. "17 1994 12 lucas.nolan@example.com \n",
  870. "18 1989 17 matthew.easton@example.com \n",
  871. "19 1997 10 aiden.jordan@example.com \n",
  872. "20 1993 13 jackson.colton@example.com \n",
  873. "21 1998 12 logan.evan@example.com \n",
  874. "22 1989 5 david.angel@example.com \n",
  875. "23 1989 19 joseph.asher@example.com \n",
  876. "24 1983 3 samuel.dominic@example.com \n",
  877. "25 1987 18 henry.austin@example.com \n",
  878. "26 1981 17 owen.leo@example.com \n",
  879. "27 1980 10 sebastian.adam@example.com \n",
  880. "28 1981 8 gabriel.jace@example.com \n",
  881. "29 1992 2 carter.jose@example.com \n",
  882. ".. ... ... ... \n",
  883. "190 1987 18 henry.austin@example.com \n",
  884. "191 1981 17 owen.leo@example.com \n",
  885. "192 1980 10 sebastian.adam@example.com \n",
  886. "193 1981 8 gabriel.jace@example.com \n",
  887. "194 1992 2 carter.jose@example.com \n",
  888. "195 1998 10 jayden.ian@example.com \n",
  889. "196 1996 5 john.cooper@example.com \n",
  890. "197 1980 15 luke.gavin@example.com \n",
  891. "198 1989 8 anthony.carson@example.com \n",
  892. "199 1997 5 isaac.jaxson@example.com \n",
  893. "200 1991 1 dylan.theodore@example.com \n",
  894. "201 2000 3 wyatt.jason@example.com \n",
  895. "202 1980 10 andrew.ezra@example.com \n",
  896. "203 1990 17 joshua.chase@example.com \n",
  897. "204 1982 4 christopher.parker@example.com \n",
  898. "205 1991 3 grayson.xavier@example.com \n",
  899. "206 1996 2 jack.kevin@example.com \n",
  900. "207 1995 13 julian.zachary@example.com \n",
  901. "208 1996 1 ryan.tyler@example.com \n",
  902. "209 1987 11 jaxon.ayden@example.com \n",
  903. "210 1992 11 levi.elias@example.com \n",
  904. "211 1995 8 nathan.bryson@example.com \n",
  905. "212 1988 9 caleb.leonardo@example.com \n",
  906. "213 1995 20 hunter.greyson@example.com \n",
  907. "214 1993 12 christian.sawyer@example.com \n",
  908. "215 1987 13 isaiah.roman@example.com \n",
  909. "216 1988 9 thomas.brandon@example.com \n",
  910. "217 1984 4 aaron.bentley@example.com \n",
  911. "218 1997 3 lincoln.kayden@example.com \n",
  912. "219 1984 15 charles.ryder@example.com \n",
  913. "\n",
  914. "[220 rows x 9 columns]"
  915. ]
  916. },
  917. "execution_count": 19,
  918. "metadata": {},
  919. "output_type": "execute_result"
  920. }
  921. ],
  922. "source": [
  923. "at_users"
  924. ]
  925. }
  926. ],
  927. "metadata": {
  928. "kernelspec": {
  929. "display_name": "Python 3",
  930. "language": "python",
  931. "name": "python3"
  932. },
  933. "language_info": {
  934. "codemirror_mode": {
  935. "name": "ipython",
  936. "version": 3
  937. },
  938. "file_extension": ".py",
  939. "mimetype": "text/x-python",
  940. "name": "python",
  941. "nbconvert_exporter": "python",
  942. "pygments_lexer": "ipython3",
  943. "version": "3.6.5"
  944. }
  945. },
  946. "nbformat": 4,
  947. "nbformat_minor": 2
  948. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!