API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 27th, 2016
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.27 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 1,
  6. "metadata": {
  7. "collapsed": false
  8. },
  9. "outputs": [
  10. {
  11. "name": "stderr",
  12. "output_type": "stream",
  13. "text": [
  14. "Loading required package: DBI\n"
  15. ]
  16. }
  17. ],
  18. "source": [
  19. "library(RMySQL)"
  20. ]
  21. },
  22. {
  23. "cell_type": "code",
  24. "execution_count": 7,
  25. "metadata": {
  26. "collapsed": true
  27. },
  28. "outputs": [],
  29. "source": [
  30. "mydb = dbConnect(MySQL(), user='cscw', password='cscw', dbname='datasets_p', host='paws-db')"
  31. ]
  32. },
  33. {
  34. "cell_type": "code",
  35. "execution_count": 8,
  36. "metadata": {
  37. "collapsed": false
  38. },
  39. "outputs": [
  40. {
  41. "data": {
  42. "text/plain": [
  43. "<MySQLResult:(32,1,0)> "
  44. ]
  45. },
  46. "execution_count": 8,
  47. "metadata": {},
  48. "output_type": "execute_result"
  49. }
  50. ],
  51. "source": [
  52. "dbSendQuery(mydb, 'use datasets_p');\n",
  53. "rs = dbSendQuery(mydb, \"select * from enwiki_sessions_20150801 where user_text = 'Jtmorgan' and start between '20120301000000' and '20120331000000';\")\n",
  54. "data = fetch(rs, n=-1)"
  55. ]
  56. },
  57. {
  58. "cell_type": "code",
  59. "execution_count": 9,
  60. "metadata": {
  61. "collapsed": false
  62. },
  63. "outputs": [
  64. {
  65. "data": {
  66. "text/html": [
  67. "<table>\n",
  68. "<thead><tr><th></th><th scope=col>user_text</th><th scope=col>start</th><th scope=col>end</th><th scope=col>index</th><th scope=col>events</th></tr></thead>\n",
  69. "<tbody>\n",
  70. "\t<tr><th scope=row>1</th><td>Jtmorgan</td><td>20120301041016</td><td>20120301041016</td><td>156</td><td>1</td></tr>\n",
  71. "\t<tr><th scope=row>2</th><td>Jtmorgan</td><td>20120301081615</td><td>20120301083626</td><td>157</td><td>4</td></tr>\n",
  72. "\t<tr><th scope=row>3</th><td>Jtmorgan</td><td>20120301175912</td><td>20120301180030</td><td>158</td><td>2</td></tr>\n",
  73. "\t<tr><th scope=row>4</th><td>Jtmorgan</td><td>20120301194116</td><td>20120301201637</td><td>159</td><td>4</td></tr>\n",
  74. "\t<tr><th scope=row>5</th><td>Jtmorgan</td><td>20120301215613</td><td>20120301215613</td><td>160</td><td>1</td></tr>\n",
  75. "\t<tr><th scope=row>6</th><td>Jtmorgan</td><td>20120302040935</td><td>20120302040935</td><td>161</td><td>1</td></tr>\n",
  76. "\t<tr><th scope=row>7</th><td>Jtmorgan</td><td>20120302085945</td><td>20120302085945</td><td>162</td><td>1</td></tr>\n",
  77. "\t<tr><th scope=row>8</th><td>Jtmorgan</td><td>20120303041020</td><td>20120303041020</td><td>163</td><td>1</td></tr>\n",
  78. "\t<tr><th scope=row>9</th><td>Jtmorgan</td><td>20120304040932</td><td>20120304040932</td><td>164</td><td>1</td></tr>\n",
  79. "\t<tr><th scope=row>10</th><td>Jtmorgan</td><td>20120305015842</td><td>20120305040958</td><td>165</td><td>20</td></tr>\n",
  80. "\t<tr><th scope=row>11</th><td>Jtmorgan</td><td>20120305052708</td><td>20120305053100</td><td>166</td><td>2</td></tr>\n",
  81. "\t<tr><th scope=row>12</th><td>Jtmorgan</td><td>20120305075321</td><td>20120305080202</td><td>167</td><td>3</td></tr>\n",
  82. "\t<tr><th scope=row>13</th><td>Jtmorgan</td><td>20120305201300</td><td>20120305201300</td><td>168</td><td>1</td></tr>\n",
  83. "\t<tr><th scope=row>14</th><td>Jtmorgan</td><td>20120306040945</td><td>20120306040945</td><td>169</td><td>1</td></tr>\n",
  84. "\t<tr><th scope=row>15</th><td>Jtmorgan</td><td>20120306230310</td><td>20120307041001</td><td>170</td><td>89</td></tr>\n",
  85. "\t<tr><th scope=row>16</th><td>Jtmorgan</td><td>20120308001837</td><td>20120308012028</td><td>171</td><td>10</td></tr>\n",
  86. "\t<tr><th scope=row>17</th><td>Jtmorgan</td><td>20120308040929</td><td>20120308040929</td><td>172</td><td>1</td></tr>\n",
  87. "\t<tr><th scope=row>18</th><td>Jtmorgan</td><td>20120308190231</td><td>20120308190830</td><td>173</td><td>2</td></tr>\n",
  88. "\t<tr><th scope=row>19</th><td>Jtmorgan</td><td>20120308201157</td><td>20120308205938</td><td>174</td><td>16</td></tr>\n",
  89. "\t<tr><th scope=row>20</th><td>Jtmorgan</td><td>20120308220751</td><td>20120309041137</td><td>175</td><td>66</td></tr>\n",
  90. "\t<tr><th scope=row>21</th><td>Jtmorgan</td><td>20120309151732</td><td>20120309152149</td><td>176</td><td>2</td></tr>\n",
  91. "\t<tr><th scope=row>22</th><td>Jtmorgan</td><td>20120310040933</td><td>20120310040933</td><td>177</td><td>1</td></tr>\n",
  92. "\t<tr><th scope=row>23</th><td>Jtmorgan</td><td>20120311032545</td><td>20120311042526</td><td>178</td><td>13</td></tr>\n",
  93. "\t<tr><th scope=row>24</th><td>Jtmorgan</td><td>20120312040956</td><td>20120312040956</td><td>179</td><td>1</td></tr>\n",
  94. "\t<tr><th scope=row>25</th><td>Jtmorgan</td><td>20120312054523</td><td>20120312054523</td><td>180</td><td>1</td></tr>\n",
  95. "\t<tr><th scope=row>26</th><td>Jtmorgan</td><td>20120313014341</td><td>20120313014341</td><td>181</td><td>1</td></tr>\n",
  96. "\t<tr><th scope=row>27</th><td>Jtmorgan</td><td>20120313041141</td><td>20120313041141</td><td>182</td><td>1</td></tr>\n",
  97. "\t<tr><th scope=row>28</th><td>Jtmorgan</td><td>20120313154156</td><td>20120313171618</td><td>183</td><td>13</td></tr>\n",
  98. "\t<tr><th scope=row>29</th><td>Jtmorgan</td><td>20120313194706</td><td>20120313204823</td><td>184</td><td>18</td></tr>\n",
  99. "\t<tr><th scope=row>30</th><td>Jtmorgan</td><td>20120314041034</td><td>20120314041034</td><td>185</td><td>1</td></tr>\n",
  100. "\t<tr><th scope=row>31</th><td>Jtmorgan</td><td>20120314163608</td><td>20120314164633</td><td>186</td><td>3</td></tr>\n",
  101. "\t<tr><th scope=row>32</th><td>Jtmorgan</td><td>20120314175911</td><td>20120314193514</td><td>187</td><td>4</td></tr>\n",
  102. "\t<tr><th scope=row>33</th><td>Jtmorgan</td><td>20120314205228</td><td>20120314210936</td><td>188</td><td>4</td></tr>\n",
  103. "\t<tr><th scope=row>34</th><td>Jtmorgan</td><td>20120315032301</td><td>20120315041105</td><td>189</td><td>2</td></tr>\n",
  104. "\t<tr><th scope=row>35</th><td>Jtmorgan</td><td>20120316041016</td><td>20120316041016</td><td>190</td><td>1</td></tr>\n",
  105. "\t<tr><th scope=row>36</th><td>Jtmorgan</td><td>20120316184049</td><td>20120316184049</td><td>191</td><td>1</td></tr>\n",
  106. "\t<tr><th scope=row>37</th><td>Jtmorgan</td><td>20120317041011</td><td>20120317041011</td><td>192</td><td>1</td></tr>\n",
  107. "\t<tr><th scope=row>38</th><td>Jtmorgan</td><td>20120317171637</td><td>20120317171637</td><td>193</td><td>1</td></tr>\n",
  108. "\t<tr><th scope=row>39</th><td>Jtmorgan</td><td>20120318030958</td><td>20120318055150</td><td>194</td><td>21</td></tr>\n",
  109. "\t<tr><th scope=row>40</th><td>Jtmorgan</td><td>20120319022737</td><td>20120319030223</td><td>195</td><td>5</td></tr>\n",
  110. "\t<tr><th scope=row>41</th><td>Jtmorgan</td><td>20120319041019</td><td>20120319041019</td><td>196</td><td>1</td></tr>\n",
  111. "\t<tr><th scope=row>42</th><td>Jtmorgan</td><td>20120319202429</td><td>20120319202429</td><td>197</td><td>1</td></tr>\n",
  112. "\t<tr><th scope=row>43</th><td>Jtmorgan</td><td>20120320033941</td><td>20120320041447</td><td>198</td><td>3</td></tr>\n",
  113. "\t<tr><th scope=row>44</th><td>Jtmorgan</td><td>20120320161701</td><td>20120320161701</td><td>199</td><td>1</td></tr>\n",
  114. "\t<tr><th scope=row>45</th><td>Jtmorgan</td><td>20120320191903</td><td>20120320191903</td><td>200</td><td>1</td></tr>\n",
  115. "\t<tr><th scope=row>46</th><td>Jtmorgan</td><td>20120320212053</td><td>20120320225940</td><td>201</td><td>16</td></tr>\n",
  116. "\t<tr><th scope=row>47</th><td>Jtmorgan</td><td>20120321215811</td><td>20120321220523</td><td>202</td><td>3</td></tr>\n",
  117. "\t<tr><th scope=row>48</th><td>Jtmorgan</td><td>20120322182619</td><td>20120322182619</td><td>203</td><td>1</td></tr>\n",
  118. "\t<tr><th scope=row>49</th><td>Jtmorgan</td><td>20120322220229</td><td>20120322220229</td><td>204</td><td>1</td></tr>\n",
  119. "\t<tr><th scope=row>50</th><td>Jtmorgan</td><td>20120323003110</td><td>20120323003333</td><td>205</td><td>2</td></tr>\n",
  120. "\t<tr><th scope=row>51</th><td>Jtmorgan</td><td>20120323015327</td><td>20120323171118</td><td>206</td><td>40</td></tr>\n",
  121. "\t<tr><th scope=row>52</th><td>Jtmorgan</td><td>20120323225541</td><td>20120407154328</td><td>207</td><td>839</td></tr>\n",
  122. "</tbody>\n",
  123. "</table>\n"
  124. ],
  125. "text/latex": [
  126. "\\begin{tabular}{r|lllll}\n",
  127. " & user_text & start & end & index & events\\\\\n",
  128. "\\hline\n",
  129. "\t1 & Jtmorgan & 20120301041016 & 20120301041016 & 156 & 1\\\\\n",
  130. "\t2 & Jtmorgan & 20120301081615 & 20120301083626 & 157 & 4\\\\\n",
  131. "\t3 & Jtmorgan & 20120301175912 & 20120301180030 & 158 & 2\\\\\n",
  132. "\t4 & Jtmorgan & 20120301194116 & 20120301201637 & 159 & 4\\\\\n",
  133. "\t5 & Jtmorgan & 20120301215613 & 20120301215613 & 160 & 1\\\\\n",
  134. "\t6 & Jtmorgan & 20120302040935 & 20120302040935 & 161 & 1\\\\\n",
  135. "\t7 & Jtmorgan & 20120302085945 & 20120302085945 & 162 & 1\\\\\n",
  136. "\t8 & Jtmorgan & 20120303041020 & 20120303041020 & 163 & 1\\\\\n",
  137. "\t9 & Jtmorgan & 20120304040932 & 20120304040932 & 164 & 1\\\\\n",
  138. "\t10 & Jtmorgan & 20120305015842 & 20120305040958 & 165 & 20\\\\\n",
  139. "\t11 & Jtmorgan & 20120305052708 & 20120305053100 & 166 & 2\\\\\n",
  140. "\t12 & Jtmorgan & 20120305075321 & 20120305080202 & 167 & 3\\\\\n",
  141. "\t13 & Jtmorgan & 20120305201300 & 20120305201300 & 168 & 1\\\\\n",
  142. "\t14 & Jtmorgan & 20120306040945 & 20120306040945 & 169 & 1\\\\\n",
  143. "\t15 & Jtmorgan & 20120306230310 & 20120307041001 & 170 & 89\\\\\n",
  144. "\t16 & Jtmorgan & 20120308001837 & 20120308012028 & 171 & 10\\\\\n",
  145. "\t17 & Jtmorgan & 20120308040929 & 20120308040929 & 172 & 1\\\\\n",
  146. "\t18 & Jtmorgan & 20120308190231 & 20120308190830 & 173 & 2\\\\\n",
  147. "\t19 & Jtmorgan & 20120308201157 & 20120308205938 & 174 & 16\\\\\n",
  148. "\t20 & Jtmorgan & 20120308220751 & 20120309041137 & 175 & 66\\\\\n",
  149. "\t21 & Jtmorgan & 20120309151732 & 20120309152149 & 176 & 2\\\\\n",
  150. "\t22 & Jtmorgan & 20120310040933 & 20120310040933 & 177 & 1\\\\\n",
  151. "\t23 & Jtmorgan & 20120311032545 & 20120311042526 & 178 & 13\\\\\n",
  152. "\t24 & Jtmorgan & 20120312040956 & 20120312040956 & 179 & 1\\\\\n",
  153. "\t25 & Jtmorgan & 20120312054523 & 20120312054523 & 180 & 1\\\\\n",
  154. "\t26 & Jtmorgan & 20120313014341 & 20120313014341 & 181 & 1\\\\\n",
  155. "\t27 & Jtmorgan & 20120313041141 & 20120313041141 & 182 & 1\\\\\n",
  156. "\t28 & Jtmorgan & 20120313154156 & 20120313171618 & 183 & 13\\\\\n",
  157. "\t29 & Jtmorgan & 20120313194706 & 20120313204823 & 184 & 18\\\\\n",
  158. "\t30 & Jtmorgan & 20120314041034 & 20120314041034 & 185 & 1\\\\\n",
  159. "\t31 & Jtmorgan & 20120314163608 & 20120314164633 & 186 & 3\\\\\n",
  160. "\t32 & Jtmorgan & 20120314175911 & 20120314193514 & 187 & 4\\\\\n",
  161. "\t33 & Jtmorgan & 20120314205228 & 20120314210936 & 188 & 4\\\\\n",
  162. "\t34 & Jtmorgan & 20120315032301 & 20120315041105 & 189 & 2\\\\\n",
  163. "\t35 & Jtmorgan & 20120316041016 & 20120316041016 & 190 & 1\\\\\n",
  164. "\t36 & Jtmorgan & 20120316184049 & 20120316184049 & 191 & 1\\\\\n",
  165. "\t37 & Jtmorgan & 20120317041011 & 20120317041011 & 192 & 1\\\\\n",
  166. "\t38 & Jtmorgan & 20120317171637 & 20120317171637 & 193 & 1\\\\\n",
  167. "\t39 & Jtmorgan & 20120318030958 & 20120318055150 & 194 & 21\\\\\n",
  168. "\t40 & Jtmorgan & 20120319022737 & 20120319030223 & 195 & 5\\\\\n",
  169. "\t41 & Jtmorgan & 20120319041019 & 20120319041019 & 196 & 1\\\\\n",
  170. "\t42 & Jtmorgan & 20120319202429 & 20120319202429 & 197 & 1\\\\\n",
  171. "\t43 & Jtmorgan & 20120320033941 & 20120320041447 & 198 & 3\\\\\n",
  172. "\t44 & Jtmorgan & 20120320161701 & 20120320161701 & 199 & 1\\\\\n",
  173. "\t45 & Jtmorgan & 20120320191903 & 20120320191903 & 200 & 1\\\\\n",
  174. "\t46 & Jtmorgan & 20120320212053 & 20120320225940 & 201 & 16\\\\\n",
  175. "\t47 & Jtmorgan & 20120321215811 & 20120321220523 & 202 & 3\\\\\n",
  176. "\t48 & Jtmorgan & 20120322182619 & 20120322182619 & 203 & 1\\\\\n",
  177. "\t49 & Jtmorgan & 20120322220229 & 20120322220229 & 204 & 1\\\\\n",
  178. "\t50 & Jtmorgan & 20120323003110 & 20120323003333 & 205 & 2\\\\\n",
  179. "\t51 & Jtmorgan & 20120323015327 & 20120323171118 & 206 & 40\\\\\n",
  180. "\t52 & Jtmorgan & 20120323225541 & 20120407154328 & 207 & 839\\\\\n",
  181. "\\end{tabular}\n"
  182. ],
  183. "text/plain": [
  184. " user_text start end index events\n",
  185. "1 Jtmorgan 20120301041016 20120301041016 156 1\n",
  186. "2 Jtmorgan 20120301081615 20120301083626 157 4\n",
  187. "3 Jtmorgan 20120301175912 20120301180030 158 2\n",
  188. "4 Jtmorgan 20120301194116 20120301201637 159 4\n",
  189. "5 Jtmorgan 20120301215613 20120301215613 160 1\n",
  190. "6 Jtmorgan 20120302040935 20120302040935 161 1\n",
  191. "7 Jtmorgan 20120302085945 20120302085945 162 1\n",
  192. "8 Jtmorgan 20120303041020 20120303041020 163 1\n",
  193. "9 Jtmorgan 20120304040932 20120304040932 164 1\n",
  194. "10 Jtmorgan 20120305015842 20120305040958 165 20\n",
  195. "11 Jtmorgan 20120305052708 20120305053100 166 2\n",
  196. "12 Jtmorgan 20120305075321 20120305080202 167 3\n",
  197. "13 Jtmorgan 20120305201300 20120305201300 168 1\n",
  198. "14 Jtmorgan 20120306040945 20120306040945 169 1\n",
  199. "15 Jtmorgan 20120306230310 20120307041001 170 89\n",
  200. "16 Jtmorgan 20120308001837 20120308012028 171 10\n",
  201. "17 Jtmorgan 20120308040929 20120308040929 172 1\n",
  202. "18 Jtmorgan 20120308190231 20120308190830 173 2\n",
  203. "19 Jtmorgan 20120308201157 20120308205938 174 16\n",
  204. "20 Jtmorgan 20120308220751 20120309041137 175 66\n",
  205. "21 Jtmorgan 20120309151732 20120309152149 176 2\n",
  206. "22 Jtmorgan 20120310040933 20120310040933 177 1\n",
  207. "23 Jtmorgan 20120311032545 20120311042526 178 13\n",
  208. "24 Jtmorgan 20120312040956 20120312040956 179 1\n",
  209. "25 Jtmorgan 20120312054523 20120312054523 180 1\n",
  210. "26 Jtmorgan 20120313014341 20120313014341 181 1\n",
  211. "27 Jtmorgan 20120313041141 20120313041141 182 1\n",
  212. "28 Jtmorgan 20120313154156 20120313171618 183 13\n",
  213. "29 Jtmorgan 20120313194706 20120313204823 184 18\n",
  214. "30 Jtmorgan 20120314041034 20120314041034 185 1\n",
  215. "31 Jtmorgan 20120314163608 20120314164633 186 3\n",
  216. "32 Jtmorgan 20120314175911 20120314193514 187 4\n",
  217. "33 Jtmorgan 20120314205228 20120314210936 188 4\n",
  218. "34 Jtmorgan 20120315032301 20120315041105 189 2\n",
  219. "35 Jtmorgan 20120316041016 20120316041016 190 1\n",
  220. "36 Jtmorgan 20120316184049 20120316184049 191 1\n",
  221. "37 Jtmorgan 20120317041011 20120317041011 192 1\n",
  222. "38 Jtmorgan 20120317171637 20120317171637 193 1\n",
  223. "39 Jtmorgan 20120318030958 20120318055150 194 21\n",
  224. "40 Jtmorgan 20120319022737 20120319030223 195 5\n",
  225. "41 Jtmorgan 20120319041019 20120319041019 196 1\n",
  226. "42 Jtmorgan 20120319202429 20120319202429 197 1\n",
  227. "43 Jtmorgan 20120320033941 20120320041447 198 3\n",
  228. "44 Jtmorgan 20120320161701 20120320161701 199 1\n",
  229. "45 Jtmorgan 20120320191903 20120320191903 200 1\n",
  230. "46 Jtmorgan 20120320212053 20120320225940 201 16\n",
  231. "47 Jtmorgan 20120321215811 20120321220523 202 3\n",
  232. "48 Jtmorgan 20120322182619 20120322182619 203 1\n",
  233. "49 Jtmorgan 20120322220229 20120322220229 204 1\n",
  234. "50 Jtmorgan 20120323003110 20120323003333 205 2\n",
  235. "51 Jtmorgan 20120323015327 20120323171118 206 40\n",
  236. "52 Jtmorgan 20120323225541 20120407154328 207 839"
  237. ]
  238. },
  239. "execution_count": 9,
  240. "metadata": {},
  241. "output_type": "execute_result"
  242. }
  243. ],
  244. "source": [
  245. "data"
  246. ]
  247. },
  248. {
  249. "cell_type": "code",
  250. "execution_count": null,
  251. "metadata": {
  252. "collapsed": true
  253. },
  254. "outputs": [],
  255. "source": []
  256. }
  257. ],
  258. "metadata": {
  259. "kernelspec": {
  260. "display_name": "R",
  261. "language": "R",
  262. "name": "ir"
  263. },
  264. "language_info": {
  265. "codemirror_mode": "r",
  266. "file_extension": ".r",
  267. "mimetype": "text/x-r-source",
  268. "name": "R",
  269. "pygments_lexer": "r",
  270. "version": "3.1.1"
  271. }
  272. },
  273. "nbformat": 4,
  274. "nbformat_minor": 0
  275. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!