API tools faq
paste
Guest User

Untitled

a guest
Jun 9th, 2018
251
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.20 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "markdown",
  5. "metadata": {},
  6. "source": [
  7. "## ```SELECT * FROM users LIMIT 0,10```"
  8. ]
  9. },
  10. {
  11. "cell_type": "code",
  12. "execution_count": 7,
  13. "metadata": {},
  14. "outputs": [
  15. {
  16. "data": {
  17. "text/html": [
  18. "<div>\n",
  19. "<style scoped>\n",
  20. " .dataframe tbody tr th:only-of-type {\n",
  21. " vertical-align: middle;\n",
  22. " }\n",
  23. "\n",
  24. " .dataframe tbody tr th {\n",
  25. " vertical-align: top;\n",
  26. " }\n",
  27. "\n",
  28. " .dataframe thead th {\n",
  29. " text-align: right;\n",
  30. " }\n",
  31. "</style>\n",
  32. "<table border=\"1\" class=\"dataframe\">\n",
  33. " <thead>\n",
  34. " <tr style=\"text-align: right;\">\n",
  35. " <th></th>\n",
  36. " <th>id</th>\n",
  37. " <th>username</th>\n",
  38. " <th>first_name</th>\n",
  39. " <th>last_name</th>\n",
  40. " <th>birth_year</th>\n",
  41. " <th>points</th>\n",
  42. " <th>email</th>\n",
  43. " </tr>\n",
  44. " </thead>\n",
  45. " <tbody>\n",
  46. " <tr>\n",
  47. " <th>0</th>\n",
  48. " <td>1</td>\n",
  49. " <td>john</td>\n",
  50. " <td>John</td>\n",
  51. " <td>Smith</td>\n",
  52. " <td>1985</td>\n",
  53. " <td>5</td>\n",
  54. " <td>john@email.com</td>\n",
  55. " </tr>\n",
  56. " <tr>\n",
  57. " <th>1</th>\n",
  58. " <td>2</td>\n",
  59. " <td>jack</td>\n",
  60. " <td>Jack</td>\n",
  61. " <td>Wilson</td>\n",
  62. " <td>1994</td>\n",
  63. " <td>15</td>\n",
  64. " <td>wilson@sss.com</td>\n",
  65. " </tr>\n",
  66. " <tr>\n",
  67. " <th>2</th>\n",
  68. " <td>3</td>\n",
  69. " <td>clara</td>\n",
  70. " <td>Clara</td>\n",
  71. " <td>Setkin</td>\n",
  72. " <td>1988</td>\n",
  73. " <td>8</td>\n",
  74. " <td>clara@gmail.com</td>\n",
  75. " </tr>\n",
  76. " <tr>\n",
  77. " <th>3</th>\n",
  78. " <td>4</td>\n",
  79. " <td>ann</td>\n",
  80. " <td>Anna</td>\n",
  81. " <td>Johnson</td>\n",
  82. " <td>1964</td>\n",
  83. " <td>10</td>\n",
  84. " <td>NaN</td>\n",
  85. " </tr>\n",
  86. " <tr>\n",
  87. " <th>4</th>\n",
  88. " <td>5</td>\n",
  89. " <td>noah.eli</td>\n",
  90. " <td>Noah</td>\n",
  91. " <td>Eli</td>\n",
  92. " <td>1980</td>\n",
  93. " <td>2</td>\n",
  94. " <td>noah.eli@example.com</td>\n",
  95. " </tr>\n",
  96. " <tr>\n",
  97. " <th>5</th>\n",
  98. " <td>6</td>\n",
  99. " <td>liam.landon</td>\n",
  100. " <td>Liam</td>\n",
  101. " <td>Landon</td>\n",
  102. " <td>1995</td>\n",
  103. " <td>1</td>\n",
  104. " <td>liam.landon@example.com</td>\n",
  105. " </tr>\n",
  106. " <tr>\n",
  107. " <th>6</th>\n",
  108. " <td>7</td>\n",
  109. " <td>william.connor</td>\n",
  110. " <td>William</td>\n",
  111. " <td>Connor</td>\n",
  112. " <td>1996</td>\n",
  113. " <td>8</td>\n",
  114. " <td>william.connor@example.com</td>\n",
  115. " </tr>\n",
  116. " <tr>\n",
  117. " <th>7</th>\n",
  118. " <td>8</td>\n",
  119. " <td>mason.josiah</td>\n",
  120. " <td>Mason</td>\n",
  121. " <td>Josiah</td>\n",
  122. " <td>1990</td>\n",
  123. " <td>13</td>\n",
  124. " <td>mason.josiah@example.com</td>\n",
  125. " </tr>\n",
  126. " <tr>\n",
  127. " <th>8</th>\n",
  128. " <td>9</td>\n",
  129. " <td>james.jonathan</td>\n",
  130. " <td>James</td>\n",
  131. " <td>Jonathan</td>\n",
  132. " <td>1993</td>\n",
  133. " <td>9</td>\n",
  134. " <td>james.jonathan@example.com</td>\n",
  135. " </tr>\n",
  136. " <tr>\n",
  137. " <th>9</th>\n",
  138. " <td>10</td>\n",
  139. " <td>benjamin.cameron</td>\n",
  140. " <td>Benjamin</td>\n",
  141. " <td>Cameron</td>\n",
  142. " <td>1983</td>\n",
  143. " <td>11</td>\n",
  144. " <td>benjamin.cameron@example.com</td>\n",
  145. " </tr>\n",
  146. " </tbody>\n",
  147. "</table>\n",
  148. "</div>"
  149. ],
  150. "text/plain": [
  151. " id username first_name last_name birth_year points \\\n",
  152. "0 1 john John Smith 1985 5 \n",
  153. "1 2 jack Jack Wilson 1994 15 \n",
  154. "2 3 clara Clara Setkin 1988 8 \n",
  155. "3 4 ann Anna Johnson 1964 10 \n",
  156. "4 5 noah.eli Noah Eli 1980 2 \n",
  157. "5 6 liam.landon Liam Landon 1995 1 \n",
  158. "6 7 william.connor William Connor 1996 8 \n",
  159. "7 8 mason.josiah Mason Josiah 1990 13 \n",
  160. "8 9 james.jonathan James Jonathan 1993 9 \n",
  161. "9 10 benjamin.cameron Benjamin Cameron 1983 11 \n",
  162. "\n",
  163. " email \n",
  164. "0 john@email.com \n",
  165. "1 wilson@sss.com \n",
  166. "2 clara@gmail.com \n",
  167. "3 NaN \n",
  168. "4 noah.eli@example.com \n",
  169. "5 liam.landon@example.com \n",
  170. "6 william.connor@example.com \n",
  171. "7 mason.josiah@example.com \n",
  172. "8 james.jonathan@example.com \n",
  173. "9 benjamin.cameron@example.com "
  174. ]
  175. },
  176. "execution_count": 7,
  177. "metadata": {},
  178. "output_type": "execute_result"
  179. }
  180. ],
  181. "source": [
  182. "users[0:10]"
  183. ]
  184. }
  185. ],
  186. "metadata": {
  187. "kernelspec": {
  188. "display_name": "Python 3",
  189. "language": "python",
  190. "name": "python3"
  191. },
  192. "language_info": {
  193. "codemirror_mode": {
  194. "name": "ipython",
  195. "version": 3
  196. },
  197. "file_extension": ".py",
  198. "mimetype": "text/x-python",
  199. "name": "python",
  200. "nbconvert_exporter": "python",
  201. "pygments_lexer": "ipython3",
  202. "version": "3.6.5"
  203. }
  204. },
  205. "nbformat": 4,
  206. "nbformat_minor": 2
  207. }
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!