API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
871
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 88.12 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. "deletable": true,
  9. "editable": true
  10. },
  11. "outputs": [
  12. {
  13. "data": {
  14. "text/html": [
  15. "<div>\n",
  16. "<table border=\"1\" class=\"dataframe\">\n",
  17. " <thead>\n",
  18. " <tr style=\"text-align: right;\">\n",
  19. " <th></th>\n",
  20. " <th>assigned_to</th>\n",
  21. " <th>assigned_to_detail</th>\n",
  22. " <th>component</th>\n",
  23. " <th>id</th>\n",
  24. " <th>priority</th>\n",
  25. " <th>product</th>\n",
  26. " </tr>\n",
  27. " </thead>\n",
  28. " <tbody>\n",
  29. " <tr>\n",
  30. " <th>0</th>\n",
  31. " <td>sshih@mozilla.com</td>\n",
  32. " <td>{u'id': 559389, u'email': u'sshih@mozilla.com'...</td>\n",
  33. " <td>DOM: Events</td>\n",
  34. " <td>386743</td>\n",
  35. " <td>--</td>\n",
  36. " <td>Core</td>\n",
  37. " </tr>\n",
  38. " <tr>\n",
  39. " <th>1</th>\n",
  40. " <td>sshih@mozilla.com</td>\n",
  41. " <td>{u'id': 559389, u'email': u'sshih@mozilla.com'...</td>\n",
  42. " <td>DOM: Workers</td>\n",
  43. " <td>482388</td>\n",
  44. " <td>--</td>\n",
  45. " <td>Core</td>\n",
  46. " </tr>\n",
  47. " <tr>\n",
  48. " <th>2</th>\n",
  49. " <td>echen@mozilla.com</td>\n",
  50. " <td>{u'id': 455480, u'email': u'echen@mozilla.com'...</td>\n",
  51. " <td>DOM: Core & HTML</td>\n",
  52. " <td>599975</td>\n",
  53. " <td>--</td>\n",
  54. " <td>Core</td>\n",
  55. " </tr>\n",
  56. " <tr>\n",
  57. " <th>3</th>\n",
  58. " <td>sshih@mozilla.com</td>\n",
  59. " <td>{u'id': 559389, u'email': u'sshih@mozilla.com'...</td>\n",
  60. " <td>Event Handling</td>\n",
  61. " <td>606885</td>\n",
  62. " <td>--</td>\n",
  63. " <td>Core</td>\n",
  64. " </tr>\n",
  65. " <tr>\n",
  66. " <th>4</th>\n",
  67. " <td>jdai@mozilla.com</td>\n",
  68. " <td>{u'id': 525840, u'email': u'jdai@mozilla.com',...</td>\n",
  69. " <td>Document Navigation</td>\n",
  70. " <td>682294</td>\n",
  71. " <td>--</td>\n",
  72. " <td>Core</td>\n",
  73. " </tr>\n",
  74. " <tr>\n",
  75. " <th>5</th>\n",
  76. " <td>htsai@mozilla.com</td>\n",
  77. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  78. " <td>DOM: Device Interfaces</td>\n",
  79. " <td>714968</td>\n",
  80. " <td>--</td>\n",
  81. " <td>Core</td>\n",
  82. " </tr>\n",
  83. " <tr>\n",
  84. " <th>6</th>\n",
  85. " <td>sawang@mozilla.com</td>\n",
  86. " <td>{u'id': 531029, u'email': u'sawang@mozilla.com...</td>\n",
  87. " <td>RIL</td>\n",
  88. " <td>733331</td>\n",
  89. " <td>--</td>\n",
  90. " <td>Firefox OS</td>\n",
  91. " </tr>\n",
  92. " <tr>\n",
  93. " <th>7</th>\n",
  94. " <td>htsai@mozilla.com</td>\n",
  95. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  96. " <td>DOM: Device Interfaces</td>\n",
  97. " <td>735165</td>\n",
  98. " <td>--</td>\n",
  99. " <td>Core</td>\n",
  100. " </tr>\n",
  101. " <tr>\n",
  102. " <th>8</th>\n",
  103. " <td>htsai@mozilla.com</td>\n",
  104. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  105. " <td>DOM: Device Interfaces</td>\n",
  106. " <td>735170</td>\n",
  107. " <td>--</td>\n",
  108. " <td>Core</td>\n",
  109. " </tr>\n",
  110. " <tr>\n",
  111. " <th>9</th>\n",
  112. " <td>htsai@mozilla.com</td>\n",
  113. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  114. " <td>DOM: Device Interfaces</td>\n",
  115. " <td>736258</td>\n",
  116. " <td>--</td>\n",
  117. " <td>Core</td>\n",
  118. " </tr>\n",
  119. " <tr>\n",
  120. " <th>10</th>\n",
  121. " <td>htsai@mozilla.com</td>\n",
  122. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  123. " <td>DOM</td>\n",
  124. " <td>737793</td>\n",
  125. " <td>--</td>\n",
  126. " <td>Core</td>\n",
  127. " </tr>\n",
  128. " <tr>\n",
  129. " <th>11</th>\n",
  130. " <td>htsai@mozilla.com</td>\n",
  131. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  132. " <td>DOM: Device Interfaces</td>\n",
  133. " <td>743008</td>\n",
  134. " <td>--</td>\n",
  135. " <td>Core</td>\n",
  136. " </tr>\n",
  137. " <tr>\n",
  138. " <th>12</th>\n",
  139. " <td>htsai@mozilla.com</td>\n",
  140. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  141. " <td>DOM</td>\n",
  142. " <td>746496</td>\n",
  143. " <td>--</td>\n",
  144. " <td>Core</td>\n",
  145. " </tr>\n",
  146. " <tr>\n",
  147. " <th>13</th>\n",
  148. " <td>htsai@mozilla.com</td>\n",
  149. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  150. " <td>DOM: Device Interfaces</td>\n",
  151. " <td>749794</td>\n",
  152. " <td>--</td>\n",
  153. " <td>Core</td>\n",
  154. " </tr>\n",
  155. " <tr>\n",
  156. " <th>14</th>\n",
  157. " <td>htsai@mozilla.com</td>\n",
  158. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  159. " <td>DOM: Device Interfaces</td>\n",
  160. " <td>757587</td>\n",
  161. " <td>--</td>\n",
  162. " <td>Core</td>\n",
  163. " </tr>\n",
  164. " <tr>\n",
  165. " <th>15</th>\n",
  166. " <td>htsai@mozilla.com</td>\n",
  167. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  168. " <td>DOM: Device Interfaces</td>\n",
  169. " <td>759521</td>\n",
  170. " <td>--</td>\n",
  171. " <td>Core</td>\n",
  172. " </tr>\n",
  173. " <tr>\n",
  174. " <th>16</th>\n",
  175. " <td>htsai@mozilla.com</td>\n",
  176. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  177. " <td>DOM: Device Interfaces</td>\n",
  178. " <td>761533</td>\n",
  179. " <td>--</td>\n",
  180. " <td>Core</td>\n",
  181. " </tr>\n",
  182. " <tr>\n",
  183. " <th>17</th>\n",
  184. " <td>jjong@mozilla.com</td>\n",
  185. " <td>{u'id': 475045, u'email': u'jjong@mozilla.com'...</td>\n",
  186. " <td>DOM: Device Interfaces</td>\n",
  187. " <td>761732</td>\n",
  188. " <td>--</td>\n",
  189. " <td>Core</td>\n",
  190. " </tr>\n",
  191. " <tr>\n",
  192. " <th>18</th>\n",
  193. " <td>bechen@mozilla.com</td>\n",
  194. " <td>{u'id': 453463, u'email': u'bechen@mozilla.com...</td>\n",
  195. " <td>Audio/Video</td>\n",
  196. " <td>762774</td>\n",
  197. " <td>--</td>\n",
  198. " <td>Core</td>\n",
  199. " </tr>\n",
  200. " <tr>\n",
  201. " <th>19</th>\n",
  202. " <td>htsai@mozilla.com</td>\n",
  203. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  204. " <td>DOM: Device Interfaces</td>\n",
  205. " <td>764690</td>\n",
  206. " <td>--</td>\n",
  207. " <td>Core</td>\n",
  208. " </tr>\n",
  209. " <tr>\n",
  210. " <th>20</th>\n",
  211. " <td>htsai@mozilla.com</td>\n",
  212. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  213. " <td>DOM: Device Interfaces</td>\n",
  214. " <td>765231</td>\n",
  215. " <td>--</td>\n",
  216. " <td>Core</td>\n",
  217. " </tr>\n",
  218. " <tr>\n",
  219. " <th>21</th>\n",
  220. " <td>htsai@mozilla.com</td>\n",
  221. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  222. " <td>DOM: Device Interfaces</td>\n",
  223. " <td>765684</td>\n",
  224. " <td>--</td>\n",
  225. " <td>Core</td>\n",
  226. " </tr>\n",
  227. " <tr>\n",
  228. " <th>22</th>\n",
  229. " <td>htsai@mozilla.com</td>\n",
  230. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  231. " <td>DOM: Device Interfaces</td>\n",
  232. " <td>766273</td>\n",
  233. " <td>--</td>\n",
  234. " <td>Core</td>\n",
  235. " </tr>\n",
  236. " <tr>\n",
  237. " <th>23</th>\n",
  238. " <td>htsai@mozilla.com</td>\n",
  239. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  240. " <td>DOM: Device Interfaces</td>\n",
  241. " <td>766822</td>\n",
  242. " <td>--</td>\n",
  243. " <td>Core</td>\n",
  244. " </tr>\n",
  245. " <tr>\n",
  246. " <th>24</th>\n",
  247. " <td>btseng@mozilla.com</td>\n",
  248. " <td>{u'id': 483302, u'email': u'btseng@mozilla.com...</td>\n",
  249. " <td>RIL</td>\n",
  250. " <td>768441</td>\n",
  251. " <td>--</td>\n",
  252. " <td>Firefox OS</td>\n",
  253. " </tr>\n",
  254. " <tr>\n",
  255. " <th>25</th>\n",
  256. " <td>htsai@mozilla.com</td>\n",
  257. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  258. " <td>DOM: Device Interfaces</td>\n",
  259. " <td>768608</td>\n",
  260. " <td>--</td>\n",
  261. " <td>Core</td>\n",
  262. " </tr>\n",
  263. " <tr>\n",
  264. " <th>26</th>\n",
  265. " <td>echuang@mozilla.com</td>\n",
  266. " <td>{u'id': 516138, u'email': u'echuang@mozilla.co...</td>\n",
  267. " <td>Networking: File</td>\n",
  268. " <td>772528</td>\n",
  269. " <td>--</td>\n",
  270. " <td>Core</td>\n",
  271. " </tr>\n",
  272. " <tr>\n",
  273. " <th>27</th>\n",
  274. " <td>htsai@mozilla.com</td>\n",
  275. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  276. " <td>DOM: Device Interfaces</td>\n",
  277. " <td>772765</td>\n",
  278. " <td>--</td>\n",
  279. " <td>Core</td>\n",
  280. " </tr>\n",
  281. " <tr>\n",
  282. " <th>28</th>\n",
  283. " <td>htsai@mozilla.com</td>\n",
  284. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  285. " <td>DOM: Device Interfaces</td>\n",
  286. " <td>775375</td>\n",
  287. " <td>--</td>\n",
  288. " <td>Core</td>\n",
  289. " </tr>\n",
  290. " <tr>\n",
  291. " <th>29</th>\n",
  292. " <td>htsai@mozilla.com</td>\n",
  293. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  294. " <td>DOM: Device Interfaces</td>\n",
  295. " <td>777202</td>\n",
  296. " <td>--</td>\n",
  297. " <td>Core</td>\n",
  298. " </tr>\n",
  299. " <tr>\n",
  300. " <th>...</th>\n",
  301. " <td>...</td>\n",
  302. " <td>...</td>\n",
  303. " <td>...</td>\n",
  304. " <td>...</td>\n",
  305. " <td>...</td>\n",
  306. " <td>...</td>\n",
  307. " </tr>\n",
  308. " <tr>\n",
  309. " <th>74</th>\n",
  310. " <td>cnevinchen@gmail.com</td>\n",
  311. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  312. " <td>Metrics</td>\n",
  313. " <td>1351556</td>\n",
  314. " <td>P1</td>\n",
  315. " <td>Firefox for Android</td>\n",
  316. " </tr>\n",
  317. " <tr>\n",
  318. " <th>75</th>\n",
  319. " <td>cnevinchen@gmail.com</td>\n",
  320. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  321. " <td>General</td>\n",
  322. " <td>1351585</td>\n",
  323. " <td>P1</td>\n",
  324. " <td>Firefox for Android</td>\n",
  325. " </tr>\n",
  326. " <tr>\n",
  327. " <th>76</th>\n",
  328. " <td>walkingice0204@gmail.com</td>\n",
  329. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  330. " <td>General</td>\n",
  331. " <td>1351605</td>\n",
  332. " <td>P1</td>\n",
  333. " <td>Firefox for Android</td>\n",
  334. " </tr>\n",
  335. " <tr>\n",
  336. " <th>77</th>\n",
  337. " <td>cnevinchen@gmail.com</td>\n",
  338. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  339. " <td>Web Apps</td>\n",
  340. " <td>1352004</td>\n",
  341. " <td>P1</td>\n",
  342. " <td>Firefox for Android</td>\n",
  343. " </tr>\n",
  344. " <tr>\n",
  345. " <th>78</th>\n",
  346. " <td>walkingice0204@gmail.com</td>\n",
  347. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  348. " <td>General</td>\n",
  349. " <td>1352104</td>\n",
  350. " <td>--</td>\n",
  351. " <td>Firefox for Android</td>\n",
  352. " </tr>\n",
  353. " <tr>\n",
  354. " <th>79</th>\n",
  355. " <td>walkingice0204@gmail.com</td>\n",
  356. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  357. " <td>General</td>\n",
  358. " <td>1352131</td>\n",
  359. " <td>--</td>\n",
  360. " <td>Firefox for Android</td>\n",
  361. " </tr>\n",
  362. " <tr>\n",
  363. " <th>80</th>\n",
  364. " <td>walkingice0204@gmail.com</td>\n",
  365. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  366. " <td>General</td>\n",
  367. " <td>1352993</td>\n",
  368. " <td>P1</td>\n",
  369. " <td>Firefox for Android</td>\n",
  370. " </tr>\n",
  371. " <tr>\n",
  372. " <th>81</th>\n",
  373. " <td>walkingice0204@gmail.com</td>\n",
  374. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  375. " <td>General</td>\n",
  376. " <td>1352999</td>\n",
  377. " <td>P2</td>\n",
  378. " <td>Firefox for Android</td>\n",
  379. " </tr>\n",
  380. " <tr>\n",
  381. " <th>82</th>\n",
  382. " <td>max@mxli.us</td>\n",
  383. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  384. " <td>Awesomescreen</td>\n",
  385. " <td>1353001</td>\n",
  386. " <td>--</td>\n",
  387. " <td>Firefox for Android</td>\n",
  388. " </tr>\n",
  389. " <tr>\n",
  390. " <th>83</th>\n",
  391. " <td>walkingice0204@gmail.com</td>\n",
  392. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  393. " <td>General</td>\n",
  394. " <td>1353019</td>\n",
  395. " <td>P2</td>\n",
  396. " <td>Firefox for Android</td>\n",
  397. " </tr>\n",
  398. " <tr>\n",
  399. " <th>84</th>\n",
  400. " <td>max@mxli.us</td>\n",
  401. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  402. " <td>Awesomescreen</td>\n",
  403. " <td>1354973</td>\n",
  404. " <td>--</td>\n",
  405. " <td>Firefox for Android</td>\n",
  406. " </tr>\n",
  407. " <tr>\n",
  408. " <th>85</th>\n",
  409. " <td>cnevinchen@gmail.com</td>\n",
  410. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  411. " <td>Web Apps</td>\n",
  412. " <td>1355852</td>\n",
  413. " <td>P1</td>\n",
  414. " <td>Firefox for Android</td>\n",
  415. " </tr>\n",
  416. " <tr>\n",
  417. " <th>86</th>\n",
  418. " <td>cnevinchen@gmail.com</td>\n",
  419. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  420. " <td>General</td>\n",
  421. " <td>1356517</td>\n",
  422. " <td>P1</td>\n",
  423. " <td>Firefox for Android</td>\n",
  424. " </tr>\n",
  425. " <tr>\n",
  426. " <th>87</th>\n",
  427. " <td>max@mxli.us</td>\n",
  428. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  429. " <td>General</td>\n",
  430. " <td>1357356</td>\n",
  431. " <td>--</td>\n",
  432. " <td>Firefox for Android</td>\n",
  433. " </tr>\n",
  434. " <tr>\n",
  435. " <th>88</th>\n",
  436. " <td>walkingice0204@gmail.com</td>\n",
  437. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  438. " <td>General</td>\n",
  439. " <td>1357780</td>\n",
  440. " <td>P1</td>\n",
  441. " <td>Firefox for Android</td>\n",
  442. " </tr>\n",
  443. " <tr>\n",
  444. " <th>89</th>\n",
  445. " <td>walkingice0204@gmail.com</td>\n",
  446. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  447. " <td>General</td>\n",
  448. " <td>1357781</td>\n",
  449. " <td>P1</td>\n",
  450. " <td>Firefox for Android</td>\n",
  451. " </tr>\n",
  452. " <tr>\n",
  453. " <th>90</th>\n",
  454. " <td>max@mxli.us</td>\n",
  455. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  456. " <td>Theme and Visual Design</td>\n",
  457. " <td>1358089</td>\n",
  458. " <td>--</td>\n",
  459. " <td>Firefox for Android</td>\n",
  460. " </tr>\n",
  461. " <tr>\n",
  462. " <th>91</th>\n",
  463. " <td>cnevinchen@gmail.com</td>\n",
  464. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  465. " <td>General</td>\n",
  466. " <td>1358117</td>\n",
  467. " <td>P1</td>\n",
  468. " <td>Firefox for Android</td>\n",
  469. " </tr>\n",
  470. " <tr>\n",
  471. " <th>92</th>\n",
  472. " <td>cnevinchen@gmail.com</td>\n",
  473. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  474. " <td>Reading List</td>\n",
  475. " <td>1358946</td>\n",
  476. " <td>P1</td>\n",
  477. " <td>Firefox for Android</td>\n",
  478. " </tr>\n",
  479. " <tr>\n",
  480. " <th>93</th>\n",
  481. " <td>topwu.tw@gmail.com</td>\n",
  482. " <td>{u'id': 585545, u'email': u'topwu.tw@gmail.com...</td>\n",
  483. " <td>Awesomescreen</td>\n",
  484. " <td>1359006</td>\n",
  485. " <td>P1</td>\n",
  486. " <td>Firefox for Android</td>\n",
  487. " </tr>\n",
  488. " <tr>\n",
  489. " <th>94</th>\n",
  490. " <td>walkingice0204@gmail.com</td>\n",
  491. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  492. " <td>General</td>\n",
  493. " <td>1359098</td>\n",
  494. " <td>P1</td>\n",
  495. " <td>Firefox for Android</td>\n",
  496. " </tr>\n",
  497. " <tr>\n",
  498. " <th>95</th>\n",
  499. " <td>cnevinchen@gmail.com</td>\n",
  500. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  501. " <td>General</td>\n",
  502. " <td>1361664</td>\n",
  503. " <td>P1</td>\n",
  504. " <td>Firefox for Android</td>\n",
  505. " </tr>\n",
  506. " <tr>\n",
  507. " <th>96</th>\n",
  508. " <td>osimpleo@gmail.com</td>\n",
  509. " <td>{u'id': 594758, u'email': u'osimpleo@gmail.com...</td>\n",
  510. " <td>Build Config & IDE Support</td>\n",
  511. " <td>1365878</td>\n",
  512. " <td>--</td>\n",
  513. " <td>Firefox for Android</td>\n",
  514. " </tr>\n",
  515. " <tr>\n",
  516. " <th>97</th>\n",
  517. " <td>cnevinchen@gmail.com</td>\n",
  518. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  519. " <td>General</td>\n",
  520. " <td>1366575</td>\n",
  521. " <td>--</td>\n",
  522. " <td>Firefox for Android</td>\n",
  523. " </tr>\n",
  524. " <tr>\n",
  525. " <th>98</th>\n",
  526. " <td>walkingice0204@gmail.com</td>\n",
  527. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  528. " <td>General</td>\n",
  529. " <td>1366648</td>\n",
  530. " <td>P1</td>\n",
  531. " <td>Firefox for Android</td>\n",
  532. " </tr>\n",
  533. " <tr>\n",
  534. " <th>99</th>\n",
  535. " <td>osimpleo@gmail.com</td>\n",
  536. " <td>{u'id': 594758, u'email': u'osimpleo@gmail.com...</td>\n",
  537. " <td>Build Config & IDE Support</td>\n",
  538. " <td>1367768</td>\n",
  539. " <td>--</td>\n",
  540. " <td>Firefox for Android</td>\n",
  541. " </tr>\n",
  542. " <tr>\n",
  543. " <th>100</th>\n",
  544. " <td>max@mxli.us</td>\n",
  545. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  546. " <td>Locale switching and selection</td>\n",
  547. " <td>1369281</td>\n",
  548. " <td>P1</td>\n",
  549. " <td>Firefox for Android</td>\n",
  550. " </tr>\n",
  551. " <tr>\n",
  552. " <th>101</th>\n",
  553. " <td>walkingice0204@gmail.com</td>\n",
  554. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  555. " <td>General</td>\n",
  556. " <td>1369681</td>\n",
  557. " <td>--</td>\n",
  558. " <td>Firefox for Android</td>\n",
  559. " </tr>\n",
  560. " <tr>\n",
  561. " <th>102</th>\n",
  562. " <td>cnevinchen@gmail.com</td>\n",
  563. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  564. " <td>Metrics</td>\n",
  565. " <td>1369685</td>\n",
  566. " <td>--</td>\n",
  567. " <td>Firefox for Android</td>\n",
  568. " </tr>\n",
  569. " <tr>\n",
  570. " <th>103</th>\n",
  571. " <td>walkingice0204@gmail.com</td>\n",
  572. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  573. " <td>General</td>\n",
  574. " <td>1371561</td>\n",
  575. " <td>--</td>\n",
  576. " <td>Firefox for Android</td>\n",
  577. " </tr>\n",
  578. " </tbody>\n",
  579. "</table>\n",
  580. "<p>8352 rows × 6 columns</p>\n",
  581. "</div>"
  582. ],
  583. "text/plain": [
  584. " assigned_to \\\n",
  585. "0 sshih@mozilla.com \n",
  586. "1 sshih@mozilla.com \n",
  587. "2 echen@mozilla.com \n",
  588. "3 sshih@mozilla.com \n",
  589. "4 jdai@mozilla.com \n",
  590. "5 htsai@mozilla.com \n",
  591. "6 sawang@mozilla.com \n",
  592. "7 htsai@mozilla.com \n",
  593. "8 htsai@mozilla.com \n",
  594. "9 htsai@mozilla.com \n",
  595. "10 htsai@mozilla.com \n",
  596. "11 htsai@mozilla.com \n",
  597. "12 htsai@mozilla.com \n",
  598. "13 htsai@mozilla.com \n",
  599. "14 htsai@mozilla.com \n",
  600. "15 htsai@mozilla.com \n",
  601. "16 htsai@mozilla.com \n",
  602. "17 jjong@mozilla.com \n",
  603. "18 bechen@mozilla.com \n",
  604. "19 htsai@mozilla.com \n",
  605. "20 htsai@mozilla.com \n",
  606. "21 htsai@mozilla.com \n",
  607. "22 htsai@mozilla.com \n",
  608. "23 htsai@mozilla.com \n",
  609. "24 btseng@mozilla.com \n",
  610. "25 htsai@mozilla.com \n",
  611. "26 echuang@mozilla.com \n",
  612. "27 htsai@mozilla.com \n",
  613. "28 htsai@mozilla.com \n",
  614. "29 htsai@mozilla.com \n",
  615. ".. ... \n",
  616. "74 cnevinchen@gmail.com \n",
  617. "75 cnevinchen@gmail.com \n",
  618. "76 walkingice0204@gmail.com \n",
  619. "77 cnevinchen@gmail.com \n",
  620. "78 walkingice0204@gmail.com \n",
  621. "79 walkingice0204@gmail.com \n",
  622. "80 walkingice0204@gmail.com \n",
  623. "81 walkingice0204@gmail.com \n",
  624. "82 max@mxli.us \n",
  625. "83 walkingice0204@gmail.com \n",
  626. "84 max@mxli.us \n",
  627. "85 cnevinchen@gmail.com \n",
  628. "86 cnevinchen@gmail.com \n",
  629. "87 max@mxli.us \n",
  630. "88 walkingice0204@gmail.com \n",
  631. "89 walkingice0204@gmail.com \n",
  632. "90 max@mxli.us \n",
  633. "91 cnevinchen@gmail.com \n",
  634. "92 cnevinchen@gmail.com \n",
  635. "93 topwu.tw@gmail.com \n",
  636. "94 walkingice0204@gmail.com \n",
  637. "95 cnevinchen@gmail.com \n",
  638. "96 osimpleo@gmail.com \n",
  639. "97 cnevinchen@gmail.com \n",
  640. "98 walkingice0204@gmail.com \n",
  641. "99 osimpleo@gmail.com \n",
  642. "100 max@mxli.us \n",
  643. "101 walkingice0204@gmail.com \n",
  644. "102 cnevinchen@gmail.com \n",
  645. "103 walkingice0204@gmail.com \n",
  646. "\n",
  647. " assigned_to_detail \\\n",
  648. "0 {u'id': 559389, u'email': u'sshih@mozilla.com'... \n",
  649. "1 {u'id': 559389, u'email': u'sshih@mozilla.com'... \n",
  650. "2 {u'id': 455480, u'email': u'echen@mozilla.com'... \n",
  651. "3 {u'id': 559389, u'email': u'sshih@mozilla.com'... \n",
  652. "4 {u'id': 525840, u'email': u'jdai@mozilla.com',... \n",
  653. "5 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  654. "6 {u'id': 531029, u'email': u'sawang@mozilla.com... \n",
  655. "7 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  656. "8 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  657. "9 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  658. "10 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  659. "11 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  660. "12 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  661. "13 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  662. "14 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  663. "15 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  664. "16 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  665. "17 {u'id': 475045, u'email': u'jjong@mozilla.com'... \n",
  666. "18 {u'id': 453463, u'email': u'bechen@mozilla.com... \n",
  667. "19 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  668. "20 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  669. "21 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  670. "22 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  671. "23 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  672. "24 {u'id': 483302, u'email': u'btseng@mozilla.com... \n",
  673. "25 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  674. "26 {u'id': 516138, u'email': u'echuang@mozilla.co... \n",
  675. "27 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  676. "28 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  677. "29 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  678. ".. ... \n",
  679. "74 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  680. "75 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  681. "76 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  682. "77 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  683. "78 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  684. "79 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  685. "80 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  686. "81 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  687. "82 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  688. "83 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  689. "84 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  690. "85 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  691. "86 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  692. "87 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  693. "88 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  694. "89 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  695. "90 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  696. "91 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  697. "92 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  698. "93 {u'id': 585545, u'email': u'topwu.tw@gmail.com... \n",
  699. "94 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  700. "95 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  701. "96 {u'id': 594758, u'email': u'osimpleo@gmail.com... \n",
  702. "97 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  703. "98 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  704. "99 {u'id': 594758, u'email': u'osimpleo@gmail.com... \n",
  705. "100 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  706. "101 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  707. "102 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  708. "103 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  709. "\n",
  710. " component id priority product \n",
  711. "0 DOM: Events 386743 -- Core \n",
  712. "1 DOM: Workers 482388 -- Core \n",
  713. "2 DOM: Core & HTML 599975 -- Core \n",
  714. "3 Event Handling 606885 -- Core \n",
  715. "4 Document Navigation 682294 -- Core \n",
  716. "5 DOM: Device Interfaces 714968 -- Core \n",
  717. "6 RIL 733331 -- Firefox OS \n",
  718. "7 DOM: Device Interfaces 735165 -- Core \n",
  719. "8 DOM: Device Interfaces 735170 -- Core \n",
  720. "9 DOM: Device Interfaces 736258 -- Core \n",
  721. "10 DOM 737793 -- Core \n",
  722. "11 DOM: Device Interfaces 743008 -- Core \n",
  723. "12 DOM 746496 -- Core \n",
  724. "13 DOM: Device Interfaces 749794 -- Core \n",
  725. "14 DOM: Device Interfaces 757587 -- Core \n",
  726. "15 DOM: Device Interfaces 759521 -- Core \n",
  727. "16 DOM: Device Interfaces 761533 -- Core \n",
  728. "17 DOM: Device Interfaces 761732 -- Core \n",
  729. "18 Audio/Video 762774 -- Core \n",
  730. "19 DOM: Device Interfaces 764690 -- Core \n",
  731. "20 DOM: Device Interfaces 765231 -- Core \n",
  732. "21 DOM: Device Interfaces 765684 -- Core \n",
  733. "22 DOM: Device Interfaces 766273 -- Core \n",
  734. "23 DOM: Device Interfaces 766822 -- Core \n",
  735. "24 RIL 768441 -- Firefox OS \n",
  736. "25 DOM: Device Interfaces 768608 -- Core \n",
  737. "26 Networking: File 772528 -- Core \n",
  738. "27 DOM: Device Interfaces 772765 -- Core \n",
  739. "28 DOM: Device Interfaces 775375 -- Core \n",
  740. "29 DOM: Device Interfaces 777202 -- Core \n",
  741. ".. ... ... ... ... \n",
  742. "74 Metrics 1351556 P1 Firefox for Android \n",
  743. "75 General 1351585 P1 Firefox for Android \n",
  744. "76 General 1351605 P1 Firefox for Android \n",
  745. "77 Web Apps 1352004 P1 Firefox for Android \n",
  746. "78 General 1352104 -- Firefox for Android \n",
  747. "79 General 1352131 -- Firefox for Android \n",
  748. "80 General 1352993 P1 Firefox for Android \n",
  749. "81 General 1352999 P2 Firefox for Android \n",
  750. "82 Awesomescreen 1353001 -- Firefox for Android \n",
  751. "83 General 1353019 P2 Firefox for Android \n",
  752. "84 Awesomescreen 1354973 -- Firefox for Android \n",
  753. "85 Web Apps 1355852 P1 Firefox for Android \n",
  754. "86 General 1356517 P1 Firefox for Android \n",
  755. "87 General 1357356 -- Firefox for Android \n",
  756. "88 General 1357780 P1 Firefox for Android \n",
  757. "89 General 1357781 P1 Firefox for Android \n",
  758. "90 Theme and Visual Design 1358089 -- Firefox for Android \n",
  759. "91 General 1358117 P1 Firefox for Android \n",
  760. "92 Reading List 1358946 P1 Firefox for Android \n",
  761. "93 Awesomescreen 1359006 P1 Firefox for Android \n",
  762. "94 General 1359098 P1 Firefox for Android \n",
  763. "95 General 1361664 P1 Firefox for Android \n",
  764. "96 Build Config & IDE Support 1365878 -- Firefox for Android \n",
  765. "97 General 1366575 -- Firefox for Android \n",
  766. "98 General 1366648 P1 Firefox for Android \n",
  767. "99 Build Config & IDE Support 1367768 -- Firefox for Android \n",
  768. "100 Locale switching and selection 1369281 P1 Firefox for Android \n",
  769. "101 General 1369681 -- Firefox for Android \n",
  770. "102 Metrics 1369685 -- Firefox for Android \n",
  771. "103 General 1371561 -- Firefox for Android \n",
  772. "\n",
  773. "[8352 rows x 6 columns]"
  774. ]
  775. },
  776. "execution_count": 1,
  777. "metadata": {},
  778. "output_type": "execute_result"
  779. }
  780. ],
  781. "source": [
  782. "import pandas as pd\n",
  783. "import numpy as np\n",
  784. "import json \n",
  785. "from pprint import pprint\n",
  786. "import matplotlib.pyplot as plt\n",
  787. "\n",
  788. "firefox = ['../data/TPE-DOM.json', '../data/TPE-Security.json', '../data/TPE-Network.json',\n",
  789. " '../data/TPE-Layout.json', '../data/TPE-Graphic.json', '../data/TPE-Media.json',\n",
  790. " '../data/TPE-Perf.json', '../data/TPE-Frontend.json', '../data/TPE-Fennec.json']\n",
  791. "\n",
  792. "df = pd.DataFrame()\n",
  793. "for target in firefox:\n",
  794. " with open(target) as data_file:\n",
  795. " data = json.load(data_file)\n",
  796. " dtemp = pd.DataFrame(data)\n",
  797. " dtemp = pd.DataFrame([dtemp['bugs'][n] for n in range(0, len(dtemp.index))])\n",
  798. " df = pd.concat([df, dtemp])\n",
  799. " \n",
  800. "df.drop_duplicates(subset=['id'], inplace=True)\n",
  801. "df"
  802. ]
  803. },
  804. {
  805. "cell_type": "code",
  806. "execution_count": 2,
  807. "metadata": {
  808. "collapsed": false,
  809. "deletable": true,
  810. "editable": true
  811. },
  812. "outputs": [
  813. {
  814. "data": {
  815. "text/html": [
  816. "<div>\n",
  817. "<table border=\"1\" class=\"dataframe\">\n",
  818. " <thead>\n",
  819. " <tr style=\"text-align: right;\">\n",
  820. " <th></th>\n",
  821. " <th>assigned_to</th>\n",
  822. " <th>assigned_to_detail</th>\n",
  823. " <th>component</th>\n",
  824. " <th>id</th>\n",
  825. " <th>priority</th>\n",
  826. " <th>product</th>\n",
  827. " </tr>\n",
  828. " </thead>\n",
  829. " <tbody>\n",
  830. " <tr>\n",
  831. " <th>0</th>\n",
  832. " <td>sshih@mozilla.com</td>\n",
  833. " <td>{u'id': 559389, u'email': u'sshih@mozilla.com'...</td>\n",
  834. " <td>DOM: Events</td>\n",
  835. " <td>386743</td>\n",
  836. " <td>--</td>\n",
  837. " <td>Core</td>\n",
  838. " </tr>\n",
  839. " <tr>\n",
  840. " <th>1</th>\n",
  841. " <td>sshih@mozilla.com</td>\n",
  842. " <td>{u'id': 559389, u'email': u'sshih@mozilla.com'...</td>\n",
  843. " <td>DOM: Workers</td>\n",
  844. " <td>482388</td>\n",
  845. " <td>--</td>\n",
  846. " <td>Core</td>\n",
  847. " </tr>\n",
  848. " <tr>\n",
  849. " <th>2</th>\n",
  850. " <td>echen@mozilla.com</td>\n",
  851. " <td>{u'id': 455480, u'email': u'echen@mozilla.com'...</td>\n",
  852. " <td>DOM: Core & HTML</td>\n",
  853. " <td>599975</td>\n",
  854. " <td>--</td>\n",
  855. " <td>Core</td>\n",
  856. " </tr>\n",
  857. " <tr>\n",
  858. " <th>3</th>\n",
  859. " <td>sshih@mozilla.com</td>\n",
  860. " <td>{u'id': 559389, u'email': u'sshih@mozilla.com'...</td>\n",
  861. " <td>Event Handling</td>\n",
  862. " <td>606885</td>\n",
  863. " <td>--</td>\n",
  864. " <td>Core</td>\n",
  865. " </tr>\n",
  866. " <tr>\n",
  867. " <th>4</th>\n",
  868. " <td>jdai@mozilla.com</td>\n",
  869. " <td>{u'id': 525840, u'email': u'jdai@mozilla.com',...</td>\n",
  870. " <td>Document Navigation</td>\n",
  871. " <td>682294</td>\n",
  872. " <td>--</td>\n",
  873. " <td>Core</td>\n",
  874. " </tr>\n",
  875. " <tr>\n",
  876. " <th>5</th>\n",
  877. " <td>htsai@mozilla.com</td>\n",
  878. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  879. " <td>DOM: Device Interfaces</td>\n",
  880. " <td>714968</td>\n",
  881. " <td>--</td>\n",
  882. " <td>Core</td>\n",
  883. " </tr>\n",
  884. " <tr>\n",
  885. " <th>7</th>\n",
  886. " <td>htsai@mozilla.com</td>\n",
  887. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  888. " <td>DOM: Device Interfaces</td>\n",
  889. " <td>735165</td>\n",
  890. " <td>--</td>\n",
  891. " <td>Core</td>\n",
  892. " </tr>\n",
  893. " <tr>\n",
  894. " <th>8</th>\n",
  895. " <td>htsai@mozilla.com</td>\n",
  896. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  897. " <td>DOM: Device Interfaces</td>\n",
  898. " <td>735170</td>\n",
  899. " <td>--</td>\n",
  900. " <td>Core</td>\n",
  901. " </tr>\n",
  902. " <tr>\n",
  903. " <th>9</th>\n",
  904. " <td>htsai@mozilla.com</td>\n",
  905. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  906. " <td>DOM: Device Interfaces</td>\n",
  907. " <td>736258</td>\n",
  908. " <td>--</td>\n",
  909. " <td>Core</td>\n",
  910. " </tr>\n",
  911. " <tr>\n",
  912. " <th>10</th>\n",
  913. " <td>htsai@mozilla.com</td>\n",
  914. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  915. " <td>DOM</td>\n",
  916. " <td>737793</td>\n",
  917. " <td>--</td>\n",
  918. " <td>Core</td>\n",
  919. " </tr>\n",
  920. " <tr>\n",
  921. " <th>11</th>\n",
  922. " <td>htsai@mozilla.com</td>\n",
  923. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  924. " <td>DOM: Device Interfaces</td>\n",
  925. " <td>743008</td>\n",
  926. " <td>--</td>\n",
  927. " <td>Core</td>\n",
  928. " </tr>\n",
  929. " <tr>\n",
  930. " <th>12</th>\n",
  931. " <td>htsai@mozilla.com</td>\n",
  932. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  933. " <td>DOM</td>\n",
  934. " <td>746496</td>\n",
  935. " <td>--</td>\n",
  936. " <td>Core</td>\n",
  937. " </tr>\n",
  938. " <tr>\n",
  939. " <th>13</th>\n",
  940. " <td>htsai@mozilla.com</td>\n",
  941. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  942. " <td>DOM: Device Interfaces</td>\n",
  943. " <td>749794</td>\n",
  944. " <td>--</td>\n",
  945. " <td>Core</td>\n",
  946. " </tr>\n",
  947. " <tr>\n",
  948. " <th>14</th>\n",
  949. " <td>htsai@mozilla.com</td>\n",
  950. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  951. " <td>DOM: Device Interfaces</td>\n",
  952. " <td>757587</td>\n",
  953. " <td>--</td>\n",
  954. " <td>Core</td>\n",
  955. " </tr>\n",
  956. " <tr>\n",
  957. " <th>15</th>\n",
  958. " <td>htsai@mozilla.com</td>\n",
  959. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  960. " <td>DOM: Device Interfaces</td>\n",
  961. " <td>759521</td>\n",
  962. " <td>--</td>\n",
  963. " <td>Core</td>\n",
  964. " </tr>\n",
  965. " <tr>\n",
  966. " <th>16</th>\n",
  967. " <td>htsai@mozilla.com</td>\n",
  968. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  969. " <td>DOM: Device Interfaces</td>\n",
  970. " <td>761533</td>\n",
  971. " <td>--</td>\n",
  972. " <td>Core</td>\n",
  973. " </tr>\n",
  974. " <tr>\n",
  975. " <th>17</th>\n",
  976. " <td>jjong@mozilla.com</td>\n",
  977. " <td>{u'id': 475045, u'email': u'jjong@mozilla.com'...</td>\n",
  978. " <td>DOM: Device Interfaces</td>\n",
  979. " <td>761732</td>\n",
  980. " <td>--</td>\n",
  981. " <td>Core</td>\n",
  982. " </tr>\n",
  983. " <tr>\n",
  984. " <th>18</th>\n",
  985. " <td>bechen@mozilla.com</td>\n",
  986. " <td>{u'id': 453463, u'email': u'bechen@mozilla.com...</td>\n",
  987. " <td>Audio/Video</td>\n",
  988. " <td>762774</td>\n",
  989. " <td>--</td>\n",
  990. " <td>Core</td>\n",
  991. " </tr>\n",
  992. " <tr>\n",
  993. " <th>19</th>\n",
  994. " <td>htsai@mozilla.com</td>\n",
  995. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  996. " <td>DOM: Device Interfaces</td>\n",
  997. " <td>764690</td>\n",
  998. " <td>--</td>\n",
  999. " <td>Core</td>\n",
  1000. " </tr>\n",
  1001. " <tr>\n",
  1002. " <th>20</th>\n",
  1003. " <td>htsai@mozilla.com</td>\n",
  1004. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1005. " <td>DOM: Device Interfaces</td>\n",
  1006. " <td>765231</td>\n",
  1007. " <td>--</td>\n",
  1008. " <td>Core</td>\n",
  1009. " </tr>\n",
  1010. " <tr>\n",
  1011. " <th>21</th>\n",
  1012. " <td>htsai@mozilla.com</td>\n",
  1013. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1014. " <td>DOM: Device Interfaces</td>\n",
  1015. " <td>765684</td>\n",
  1016. " <td>--</td>\n",
  1017. " <td>Core</td>\n",
  1018. " </tr>\n",
  1019. " <tr>\n",
  1020. " <th>22</th>\n",
  1021. " <td>htsai@mozilla.com</td>\n",
  1022. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1023. " <td>DOM: Device Interfaces</td>\n",
  1024. " <td>766273</td>\n",
  1025. " <td>--</td>\n",
  1026. " <td>Core</td>\n",
  1027. " </tr>\n",
  1028. " <tr>\n",
  1029. " <th>23</th>\n",
  1030. " <td>htsai@mozilla.com</td>\n",
  1031. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1032. " <td>DOM: Device Interfaces</td>\n",
  1033. " <td>766822</td>\n",
  1034. " <td>--</td>\n",
  1035. " <td>Core</td>\n",
  1036. " </tr>\n",
  1037. " <tr>\n",
  1038. " <th>25</th>\n",
  1039. " <td>htsai@mozilla.com</td>\n",
  1040. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1041. " <td>DOM: Device Interfaces</td>\n",
  1042. " <td>768608</td>\n",
  1043. " <td>--</td>\n",
  1044. " <td>Core</td>\n",
  1045. " </tr>\n",
  1046. " <tr>\n",
  1047. " <th>26</th>\n",
  1048. " <td>echuang@mozilla.com</td>\n",
  1049. " <td>{u'id': 516138, u'email': u'echuang@mozilla.co...</td>\n",
  1050. " <td>Networking: File</td>\n",
  1051. " <td>772528</td>\n",
  1052. " <td>--</td>\n",
  1053. " <td>Core</td>\n",
  1054. " </tr>\n",
  1055. " <tr>\n",
  1056. " <th>27</th>\n",
  1057. " <td>htsai@mozilla.com</td>\n",
  1058. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1059. " <td>DOM: Device Interfaces</td>\n",
  1060. " <td>772765</td>\n",
  1061. " <td>--</td>\n",
  1062. " <td>Core</td>\n",
  1063. " </tr>\n",
  1064. " <tr>\n",
  1065. " <th>28</th>\n",
  1066. " <td>htsai@mozilla.com</td>\n",
  1067. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1068. " <td>DOM: Device Interfaces</td>\n",
  1069. " <td>775375</td>\n",
  1070. " <td>--</td>\n",
  1071. " <td>Core</td>\n",
  1072. " </tr>\n",
  1073. " <tr>\n",
  1074. " <th>29</th>\n",
  1075. " <td>htsai@mozilla.com</td>\n",
  1076. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1077. " <td>DOM: Device Interfaces</td>\n",
  1078. " <td>777202</td>\n",
  1079. " <td>--</td>\n",
  1080. " <td>Core</td>\n",
  1081. " </tr>\n",
  1082. " <tr>\n",
  1083. " <th>30</th>\n",
  1084. " <td>htsai@mozilla.com</td>\n",
  1085. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1086. " <td>DOM: Device Interfaces</td>\n",
  1087. " <td>777899</td>\n",
  1088. " <td>--</td>\n",
  1089. " <td>Core</td>\n",
  1090. " </tr>\n",
  1091. " <tr>\n",
  1092. " <th>31</th>\n",
  1093. " <td>htsai@mozilla.com</td>\n",
  1094. " <td>{u'id': 434964, u'email': u'htsai@mozilla.com'...</td>\n",
  1095. " <td>DOM: Device Interfaces</td>\n",
  1096. " <td>779217</td>\n",
  1097. " <td>--</td>\n",
  1098. " <td>Core</td>\n",
  1099. " </tr>\n",
  1100. " <tr>\n",
  1101. " <th>...</th>\n",
  1102. " <td>...</td>\n",
  1103. " <td>...</td>\n",
  1104. " <td>...</td>\n",
  1105. " <td>...</td>\n",
  1106. " <td>...</td>\n",
  1107. " <td>...</td>\n",
  1108. " </tr>\n",
  1109. " <tr>\n",
  1110. " <th>74</th>\n",
  1111. " <td>cnevinchen@gmail.com</td>\n",
  1112. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1113. " <td>Metrics</td>\n",
  1114. " <td>1351556</td>\n",
  1115. " <td>P1</td>\n",
  1116. " <td>Firefox for Android</td>\n",
  1117. " </tr>\n",
  1118. " <tr>\n",
  1119. " <th>75</th>\n",
  1120. " <td>cnevinchen@gmail.com</td>\n",
  1121. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1122. " <td>General</td>\n",
  1123. " <td>1351585</td>\n",
  1124. " <td>P1</td>\n",
  1125. " <td>Firefox for Android</td>\n",
  1126. " </tr>\n",
  1127. " <tr>\n",
  1128. " <th>76</th>\n",
  1129. " <td>walkingice0204@gmail.com</td>\n",
  1130. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1131. " <td>General</td>\n",
  1132. " <td>1351605</td>\n",
  1133. " <td>P1</td>\n",
  1134. " <td>Firefox for Android</td>\n",
  1135. " </tr>\n",
  1136. " <tr>\n",
  1137. " <th>77</th>\n",
  1138. " <td>cnevinchen@gmail.com</td>\n",
  1139. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1140. " <td>Web Apps</td>\n",
  1141. " <td>1352004</td>\n",
  1142. " <td>P1</td>\n",
  1143. " <td>Firefox for Android</td>\n",
  1144. " </tr>\n",
  1145. " <tr>\n",
  1146. " <th>78</th>\n",
  1147. " <td>walkingice0204@gmail.com</td>\n",
  1148. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1149. " <td>General</td>\n",
  1150. " <td>1352104</td>\n",
  1151. " <td>--</td>\n",
  1152. " <td>Firefox for Android</td>\n",
  1153. " </tr>\n",
  1154. " <tr>\n",
  1155. " <th>79</th>\n",
  1156. " <td>walkingice0204@gmail.com</td>\n",
  1157. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1158. " <td>General</td>\n",
  1159. " <td>1352131</td>\n",
  1160. " <td>--</td>\n",
  1161. " <td>Firefox for Android</td>\n",
  1162. " </tr>\n",
  1163. " <tr>\n",
  1164. " <th>80</th>\n",
  1165. " <td>walkingice0204@gmail.com</td>\n",
  1166. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1167. " <td>General</td>\n",
  1168. " <td>1352993</td>\n",
  1169. " <td>P1</td>\n",
  1170. " <td>Firefox for Android</td>\n",
  1171. " </tr>\n",
  1172. " <tr>\n",
  1173. " <th>81</th>\n",
  1174. " <td>walkingice0204@gmail.com</td>\n",
  1175. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1176. " <td>General</td>\n",
  1177. " <td>1352999</td>\n",
  1178. " <td>P2</td>\n",
  1179. " <td>Firefox for Android</td>\n",
  1180. " </tr>\n",
  1181. " <tr>\n",
  1182. " <th>82</th>\n",
  1183. " <td>max@mxli.us</td>\n",
  1184. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  1185. " <td>Awesomescreen</td>\n",
  1186. " <td>1353001</td>\n",
  1187. " <td>--</td>\n",
  1188. " <td>Firefox for Android</td>\n",
  1189. " </tr>\n",
  1190. " <tr>\n",
  1191. " <th>83</th>\n",
  1192. " <td>walkingice0204@gmail.com</td>\n",
  1193. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1194. " <td>General</td>\n",
  1195. " <td>1353019</td>\n",
  1196. " <td>P2</td>\n",
  1197. " <td>Firefox for Android</td>\n",
  1198. " </tr>\n",
  1199. " <tr>\n",
  1200. " <th>84</th>\n",
  1201. " <td>max@mxli.us</td>\n",
  1202. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  1203. " <td>Awesomescreen</td>\n",
  1204. " <td>1354973</td>\n",
  1205. " <td>--</td>\n",
  1206. " <td>Firefox for Android</td>\n",
  1207. " </tr>\n",
  1208. " <tr>\n",
  1209. " <th>85</th>\n",
  1210. " <td>cnevinchen@gmail.com</td>\n",
  1211. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1212. " <td>Web Apps</td>\n",
  1213. " <td>1355852</td>\n",
  1214. " <td>P1</td>\n",
  1215. " <td>Firefox for Android</td>\n",
  1216. " </tr>\n",
  1217. " <tr>\n",
  1218. " <th>86</th>\n",
  1219. " <td>cnevinchen@gmail.com</td>\n",
  1220. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1221. " <td>General</td>\n",
  1222. " <td>1356517</td>\n",
  1223. " <td>P1</td>\n",
  1224. " <td>Firefox for Android</td>\n",
  1225. " </tr>\n",
  1226. " <tr>\n",
  1227. " <th>87</th>\n",
  1228. " <td>max@mxli.us</td>\n",
  1229. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  1230. " <td>General</td>\n",
  1231. " <td>1357356</td>\n",
  1232. " <td>--</td>\n",
  1233. " <td>Firefox for Android</td>\n",
  1234. " </tr>\n",
  1235. " <tr>\n",
  1236. " <th>88</th>\n",
  1237. " <td>walkingice0204@gmail.com</td>\n",
  1238. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1239. " <td>General</td>\n",
  1240. " <td>1357780</td>\n",
  1241. " <td>P1</td>\n",
  1242. " <td>Firefox for Android</td>\n",
  1243. " </tr>\n",
  1244. " <tr>\n",
  1245. " <th>89</th>\n",
  1246. " <td>walkingice0204@gmail.com</td>\n",
  1247. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1248. " <td>General</td>\n",
  1249. " <td>1357781</td>\n",
  1250. " <td>P1</td>\n",
  1251. " <td>Firefox for Android</td>\n",
  1252. " </tr>\n",
  1253. " <tr>\n",
  1254. " <th>90</th>\n",
  1255. " <td>max@mxli.us</td>\n",
  1256. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  1257. " <td>Theme and Visual Design</td>\n",
  1258. " <td>1358089</td>\n",
  1259. " <td>--</td>\n",
  1260. " <td>Firefox for Android</td>\n",
  1261. " </tr>\n",
  1262. " <tr>\n",
  1263. " <th>91</th>\n",
  1264. " <td>cnevinchen@gmail.com</td>\n",
  1265. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1266. " <td>General</td>\n",
  1267. " <td>1358117</td>\n",
  1268. " <td>P1</td>\n",
  1269. " <td>Firefox for Android</td>\n",
  1270. " </tr>\n",
  1271. " <tr>\n",
  1272. " <th>92</th>\n",
  1273. " <td>cnevinchen@gmail.com</td>\n",
  1274. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1275. " <td>Reading List</td>\n",
  1276. " <td>1358946</td>\n",
  1277. " <td>P1</td>\n",
  1278. " <td>Firefox for Android</td>\n",
  1279. " </tr>\n",
  1280. " <tr>\n",
  1281. " <th>93</th>\n",
  1282. " <td>topwu.tw@gmail.com</td>\n",
  1283. " <td>{u'id': 585545, u'email': u'topwu.tw@gmail.com...</td>\n",
  1284. " <td>Awesomescreen</td>\n",
  1285. " <td>1359006</td>\n",
  1286. " <td>P1</td>\n",
  1287. " <td>Firefox for Android</td>\n",
  1288. " </tr>\n",
  1289. " <tr>\n",
  1290. " <th>94</th>\n",
  1291. " <td>walkingice0204@gmail.com</td>\n",
  1292. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1293. " <td>General</td>\n",
  1294. " <td>1359098</td>\n",
  1295. " <td>P1</td>\n",
  1296. " <td>Firefox for Android</td>\n",
  1297. " </tr>\n",
  1298. " <tr>\n",
  1299. " <th>95</th>\n",
  1300. " <td>cnevinchen@gmail.com</td>\n",
  1301. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1302. " <td>General</td>\n",
  1303. " <td>1361664</td>\n",
  1304. " <td>P1</td>\n",
  1305. " <td>Firefox for Android</td>\n",
  1306. " </tr>\n",
  1307. " <tr>\n",
  1308. " <th>96</th>\n",
  1309. " <td>osimpleo@gmail.com</td>\n",
  1310. " <td>{u'id': 594758, u'email': u'osimpleo@gmail.com...</td>\n",
  1311. " <td>Build Config & IDE Support</td>\n",
  1312. " <td>1365878</td>\n",
  1313. " <td>--</td>\n",
  1314. " <td>Firefox for Android</td>\n",
  1315. " </tr>\n",
  1316. " <tr>\n",
  1317. " <th>97</th>\n",
  1318. " <td>cnevinchen@gmail.com</td>\n",
  1319. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1320. " <td>General</td>\n",
  1321. " <td>1366575</td>\n",
  1322. " <td>--</td>\n",
  1323. " <td>Firefox for Android</td>\n",
  1324. " </tr>\n",
  1325. " <tr>\n",
  1326. " <th>98</th>\n",
  1327. " <td>walkingice0204@gmail.com</td>\n",
  1328. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1329. " <td>General</td>\n",
  1330. " <td>1366648</td>\n",
  1331. " <td>P1</td>\n",
  1332. " <td>Firefox for Android</td>\n",
  1333. " </tr>\n",
  1334. " <tr>\n",
  1335. " <th>99</th>\n",
  1336. " <td>osimpleo@gmail.com</td>\n",
  1337. " <td>{u'id': 594758, u'email': u'osimpleo@gmail.com...</td>\n",
  1338. " <td>Build Config & IDE Support</td>\n",
  1339. " <td>1367768</td>\n",
  1340. " <td>--</td>\n",
  1341. " <td>Firefox for Android</td>\n",
  1342. " </tr>\n",
  1343. " <tr>\n",
  1344. " <th>100</th>\n",
  1345. " <td>max@mxli.us</td>\n",
  1346. " <td>{u'id': 578584, u'email': u'max@mxli.us', u'na...</td>\n",
  1347. " <td>Locale switching and selection</td>\n",
  1348. " <td>1369281</td>\n",
  1349. " <td>P1</td>\n",
  1350. " <td>Firefox for Android</td>\n",
  1351. " </tr>\n",
  1352. " <tr>\n",
  1353. " <th>101</th>\n",
  1354. " <td>walkingice0204@gmail.com</td>\n",
  1355. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1356. " <td>General</td>\n",
  1357. " <td>1369681</td>\n",
  1358. " <td>--</td>\n",
  1359. " <td>Firefox for Android</td>\n",
  1360. " </tr>\n",
  1361. " <tr>\n",
  1362. " <th>102</th>\n",
  1363. " <td>cnevinchen@gmail.com</td>\n",
  1364. " <td>{u'id': 582291, u'email': u'cnevinchen@gmail.c...</td>\n",
  1365. " <td>Metrics</td>\n",
  1366. " <td>1369685</td>\n",
  1367. " <td>--</td>\n",
  1368. " <td>Firefox for Android</td>\n",
  1369. " </tr>\n",
  1370. " <tr>\n",
  1371. " <th>103</th>\n",
  1372. " <td>walkingice0204@gmail.com</td>\n",
  1373. " <td>{u'id': 465405, u'email': u'walkingice0204@gma...</td>\n",
  1374. " <td>General</td>\n",
  1375. " <td>1371561</td>\n",
  1376. " <td>--</td>\n",
  1377. " <td>Firefox for Android</td>\n",
  1378. " </tr>\n",
  1379. " </tbody>\n",
  1380. "</table>\n",
  1381. "<p>5106 rows × 6 columns</p>\n",
  1382. "</div>"
  1383. ],
  1384. "text/plain": [
  1385. " assigned_to \\\n",
  1386. "0 sshih@mozilla.com \n",
  1387. "1 sshih@mozilla.com \n",
  1388. "2 echen@mozilla.com \n",
  1389. "3 sshih@mozilla.com \n",
  1390. "4 jdai@mozilla.com \n",
  1391. "5 htsai@mozilla.com \n",
  1392. "7 htsai@mozilla.com \n",
  1393. "8 htsai@mozilla.com \n",
  1394. "9 htsai@mozilla.com \n",
  1395. "10 htsai@mozilla.com \n",
  1396. "11 htsai@mozilla.com \n",
  1397. "12 htsai@mozilla.com \n",
  1398. "13 htsai@mozilla.com \n",
  1399. "14 htsai@mozilla.com \n",
  1400. "15 htsai@mozilla.com \n",
  1401. "16 htsai@mozilla.com \n",
  1402. "17 jjong@mozilla.com \n",
  1403. "18 bechen@mozilla.com \n",
  1404. "19 htsai@mozilla.com \n",
  1405. "20 htsai@mozilla.com \n",
  1406. "21 htsai@mozilla.com \n",
  1407. "22 htsai@mozilla.com \n",
  1408. "23 htsai@mozilla.com \n",
  1409. "25 htsai@mozilla.com \n",
  1410. "26 echuang@mozilla.com \n",
  1411. "27 htsai@mozilla.com \n",
  1412. "28 htsai@mozilla.com \n",
  1413. "29 htsai@mozilla.com \n",
  1414. "30 htsai@mozilla.com \n",
  1415. "31 htsai@mozilla.com \n",
  1416. ".. ... \n",
  1417. "74 cnevinchen@gmail.com \n",
  1418. "75 cnevinchen@gmail.com \n",
  1419. "76 walkingice0204@gmail.com \n",
  1420. "77 cnevinchen@gmail.com \n",
  1421. "78 walkingice0204@gmail.com \n",
  1422. "79 walkingice0204@gmail.com \n",
  1423. "80 walkingice0204@gmail.com \n",
  1424. "81 walkingice0204@gmail.com \n",
  1425. "82 max@mxli.us \n",
  1426. "83 walkingice0204@gmail.com \n",
  1427. "84 max@mxli.us \n",
  1428. "85 cnevinchen@gmail.com \n",
  1429. "86 cnevinchen@gmail.com \n",
  1430. "87 max@mxli.us \n",
  1431. "88 walkingice0204@gmail.com \n",
  1432. "89 walkingice0204@gmail.com \n",
  1433. "90 max@mxli.us \n",
  1434. "91 cnevinchen@gmail.com \n",
  1435. "92 cnevinchen@gmail.com \n",
  1436. "93 topwu.tw@gmail.com \n",
  1437. "94 walkingice0204@gmail.com \n",
  1438. "95 cnevinchen@gmail.com \n",
  1439. "96 osimpleo@gmail.com \n",
  1440. "97 cnevinchen@gmail.com \n",
  1441. "98 walkingice0204@gmail.com \n",
  1442. "99 osimpleo@gmail.com \n",
  1443. "100 max@mxli.us \n",
  1444. "101 walkingice0204@gmail.com \n",
  1445. "102 cnevinchen@gmail.com \n",
  1446. "103 walkingice0204@gmail.com \n",
  1447. "\n",
  1448. " assigned_to_detail \\\n",
  1449. "0 {u'id': 559389, u'email': u'sshih@mozilla.com'... \n",
  1450. "1 {u'id': 559389, u'email': u'sshih@mozilla.com'... \n",
  1451. "2 {u'id': 455480, u'email': u'echen@mozilla.com'... \n",
  1452. "3 {u'id': 559389, u'email': u'sshih@mozilla.com'... \n",
  1453. "4 {u'id': 525840, u'email': u'jdai@mozilla.com',... \n",
  1454. "5 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1455. "7 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1456. "8 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1457. "9 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1458. "10 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1459. "11 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1460. "12 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1461. "13 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1462. "14 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1463. "15 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1464. "16 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1465. "17 {u'id': 475045, u'email': u'jjong@mozilla.com'... \n",
  1466. "18 {u'id': 453463, u'email': u'bechen@mozilla.com... \n",
  1467. "19 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1468. "20 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1469. "21 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1470. "22 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1471. "23 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1472. "25 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1473. "26 {u'id': 516138, u'email': u'echuang@mozilla.co... \n",
  1474. "27 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1475. "28 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1476. "29 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1477. "30 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1478. "31 {u'id': 434964, u'email': u'htsai@mozilla.com'... \n",
  1479. ".. ... \n",
  1480. "74 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1481. "75 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1482. "76 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1483. "77 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1484. "78 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1485. "79 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1486. "80 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1487. "81 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1488. "82 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  1489. "83 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1490. "84 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  1491. "85 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1492. "86 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1493. "87 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  1494. "88 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1495. "89 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1496. "90 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  1497. "91 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1498. "92 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1499. "93 {u'id': 585545, u'email': u'topwu.tw@gmail.com... \n",
  1500. "94 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1501. "95 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1502. "96 {u'id': 594758, u'email': u'osimpleo@gmail.com... \n",
  1503. "97 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1504. "98 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1505. "99 {u'id': 594758, u'email': u'osimpleo@gmail.com... \n",
  1506. "100 {u'id': 578584, u'email': u'max@mxli.us', u'na... \n",
  1507. "101 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1508. "102 {u'id': 582291, u'email': u'cnevinchen@gmail.c... \n",
  1509. "103 {u'id': 465405, u'email': u'walkingice0204@gma... \n",
  1510. "\n",
  1511. " component id priority product \n",
  1512. "0 DOM: Events 386743 -- Core \n",
  1513. "1 DOM: Workers 482388 -- Core \n",
  1514. "2 DOM: Core & HTML 599975 -- Core \n",
  1515. "3 Event Handling 606885 -- Core \n",
  1516. "4 Document Navigation 682294 -- Core \n",
  1517. "5 DOM: Device Interfaces 714968 -- Core \n",
  1518. "7 DOM: Device Interfaces 735165 -- Core \n",
  1519. "8 DOM: Device Interfaces 735170 -- Core \n",
  1520. "9 DOM: Device Interfaces 736258 -- Core \n",
  1521. "10 DOM 737793 -- Core \n",
  1522. "11 DOM: Device Interfaces 743008 -- Core \n",
  1523. "12 DOM 746496 -- Core \n",
  1524. "13 DOM: Device Interfaces 749794 -- Core \n",
  1525. "14 DOM: Device Interfaces 757587 -- Core \n",
  1526. "15 DOM: Device Interfaces 759521 -- Core \n",
  1527. "16 DOM: Device Interfaces 761533 -- Core \n",
  1528. "17 DOM: Device Interfaces 761732 -- Core \n",
  1529. "18 Audio/Video 762774 -- Core \n",
  1530. "19 DOM: Device Interfaces 764690 -- Core \n",
  1531. "20 DOM: Device Interfaces 765231 -- Core \n",
  1532. "21 DOM: Device Interfaces 765684 -- Core \n",
  1533. "22 DOM: Device Interfaces 766273 -- Core \n",
  1534. "23 DOM: Device Interfaces 766822 -- Core \n",
  1535. "25 DOM: Device Interfaces 768608 -- Core \n",
  1536. "26 Networking: File 772528 -- Core \n",
  1537. "27 DOM: Device Interfaces 772765 -- Core \n",
  1538. "28 DOM: Device Interfaces 775375 -- Core \n",
  1539. "29 DOM: Device Interfaces 777202 -- Core \n",
  1540. "30 DOM: Device Interfaces 777899 -- Core \n",
  1541. "31 DOM: Device Interfaces 779217 -- Core \n",
  1542. ".. ... ... ... ... \n",
  1543. "74 Metrics 1351556 P1 Firefox for Android \n",
  1544. "75 General 1351585 P1 Firefox for Android \n",
  1545. "76 General 1351605 P1 Firefox for Android \n",
  1546. "77 Web Apps 1352004 P1 Firefox for Android \n",
  1547. "78 General 1352104 -- Firefox for Android \n",
  1548. "79 General 1352131 -- Firefox for Android \n",
  1549. "80 General 1352993 P1 Firefox for Android \n",
  1550. "81 General 1352999 P2 Firefox for Android \n",
  1551. "82 Awesomescreen 1353001 -- Firefox for Android \n",
  1552. "83 General 1353019 P2 Firefox for Android \n",
  1553. "84 Awesomescreen 1354973 -- Firefox for Android \n",
  1554. "85 Web Apps 1355852 P1 Firefox for Android \n",
  1555. "86 General 1356517 P1 Firefox for Android \n",
  1556. "87 General 1357356 -- Firefox for Android \n",
  1557. "88 General 1357780 P1 Firefox for Android \n",
  1558. "89 General 1357781 P1 Firefox for Android \n",
  1559. "90 Theme and Visual Design 1358089 -- Firefox for Android \n",
  1560. "91 General 1358117 P1 Firefox for Android \n",
  1561. "92 Reading List 1358946 P1 Firefox for Android \n",
  1562. "93 Awesomescreen 1359006 P1 Firefox for Android \n",
  1563. "94 General 1359098 P1 Firefox for Android \n",
  1564. "95 General 1361664 P1 Firefox for Android \n",
  1565. "96 Build Config & IDE Support 1365878 -- Firefox for Android \n",
  1566. "97 General 1366575 -- Firefox for Android \n",
  1567. "98 General 1366648 P1 Firefox for Android \n",
  1568. "99 Build Config & IDE Support 1367768 -- Firefox for Android \n",
  1569. "100 Locale switching and selection 1369281 P1 Firefox for Android \n",
  1570. "101 General 1369681 -- Firefox for Android \n",
  1571. "102 Metrics 1369685 -- Firefox for Android \n",
  1572. "103 General 1371561 -- Firefox for Android \n",
  1573. "\n",
  1574. "[5106 rows x 6 columns]"
  1575. ]
  1576. },
  1577. "execution_count": 2,
  1578. "metadata": {},
  1579. "output_type": "execute_result"
  1580. }
  1581. ],
  1582. "source": [
  1583. "df = df[df['product'] != 'Firefox OS']\n",
  1584. "df = df[df['product'] != 'SeaMonkey']\n",
  1585. "df = df[df['product'] != 'Connected Devices']\n",
  1586. "df"
  1587. ]
  1588. },
  1589. {
  1590. "cell_type": "code",
  1591. "execution_count": 3,
  1592. "metadata": {
  1593. "collapsed": false,
  1594. "deletable": true,
  1595. "editable": true
  1596. },
  1597. "outputs": [
  1598. {
  1599. "data": {
  1600. "text/plain": [
  1601. "jwwang@mozilla.com 767\n",
  1602. "tlin@mozilla.com 231\n",
  1603. "cku@mozilla.com 186\n",
  1604. "allstars.chh@mozilla.com 149\n",
  1605. "ethlin@mozilla.com 136\n",
  1606. "mtseng@mozilla.com 128\n",
  1607. "ayang@mozilla.com 128\n",
  1608. "bechen@mozilla.com 124\n",
  1609. "alwu@mozilla.com 121\n",
  1610. "kchen@mozilla.com 117\n",
  1611. "echen@mozilla.com 107\n",
  1612. "rchien@mozilla.com 107\n",
  1613. "timdream@gmail.com 105\n",
  1614. "boris.chiou@gmail.com 102\n",
  1615. "hshih@mozilla.com 102\n",
  1616. "hchang@mozilla.com 100\n",
  1617. "kaku@mozilla.com 97\n",
  1618. "evan@tseng.io 90\n",
  1619. "dlee@mozilla.com 89\n",
  1620. "sshih@mozilla.com 83\n",
  1621. "jeremychen@mozilla.com 82\n",
  1622. "dmu@mozilla.com 81\n",
  1623. "gasolin@mozilla.com 81\n",
  1624. "jacheng@mozilla.com 80\n",
  1625. "jjong@mozilla.com 75\n",
  1626. "jolin@mozilla.com 67\n",
  1627. "cyu@mozilla.com 66\n",
  1628. "howareyou322@gmail.com 66\n",
  1629. "tnguyen@mozilla.com 63\n",
  1630. "ralin@mozilla.com 62\n",
  1631. " ... \n",
  1632. "shuang@mozilla.com 33\n",
  1633. "scwwu@mozilla.com 33\n",
  1634. "swu@mozilla.com 30\n",
  1635. "cleu@mozilla.com 28\n",
  1636. "kechen@mozilla.com 26\n",
  1637. "max@mxli.us 26\n",
  1638. "walkingice0204@gmail.com 26\n",
  1639. "wpan@mozilla.com 24\n",
  1640. "aschen@mozilla.com 23\n",
  1641. "paulkchen@netscape.net 20\n",
  1642. "lchang@mozilla.com 20\n",
  1643. "sawang@mozilla.com 19\n",
  1644. "ttung@mozilla.com 18\n",
  1645. "btian@mozilla.com 17\n",
  1646. "ettseng@mozilla.com 17\n",
  1647. "ywu@mozilla.com 16\n",
  1648. "brsun@mozilla.com 16\n",
  1649. "alchen@mozilla.com 15\n",
  1650. "bhsu@mozilla.com 13\n",
  1651. "cfu@redhat.com 13\n",
  1652. "echuang@mozilla.com 13\n",
  1653. "amchung@mozilla.com 12\n",
  1654. "topwu.tw@gmail.com 11\n",
  1655. "fatseng@mozilla.com 11\n",
  1656. "lochang@mozilla.com 11\n",
  1657. "ehung@mozilla.com 5\n",
  1658. "etsai@mozilla.com 4\n",
  1659. "wiwang@mozilla.com 3\n",
  1660. "cfu@mozilla.com 2\n",
  1661. "osimpleo@gmail.com 2\n",
  1662. "Name: assigned_to, dtype: int64"
  1663. ]
  1664. },
  1665. "execution_count": 3,
  1666. "metadata": {},
  1667. "output_type": "execute_result"
  1668. }
  1669. ],
  1670. "source": [
  1671. "df['assigned_to'].value_counts()"
  1672. ]
  1673. },
  1674. {
  1675. "cell_type": "code",
  1676. "execution_count": 4,
  1677. "metadata": {
  1678. "collapsed": false,
  1679. "deletable": true,
  1680. "editable": true
  1681. },
  1682. "outputs": [
  1683. {
  1684. "data": {
  1685. "text/plain": [
  1686. "Core 3903\n",
  1687. "Firefox 364\n",
  1688. "Toolkit 347\n",
  1689. "Firefox for Android 246\n",
  1690. "Testing 105\n",
  1691. "Release Engineering 38\n",
  1692. "Mozilla Localizations 25\n",
  1693. "Taskcluster 24\n",
  1694. "JSS 13\n",
  1695. "Core Graveyard 9\n",
  1696. "www.mozilla.org 5\n",
  1697. "NSS 5\n",
  1698. "MozReview 3\n",
  1699. "Tree Management 2\n",
  1700. "Socorro 2\n",
  1701. "Developer Documentation 2\n",
  1702. "Web Compatibility 2\n",
  1703. "NSPR 1\n",
  1704. "mozilla.org 1\n",
  1705. "Infrastructure & Operations 1\n",
  1706. "Developer Services 1\n",
  1707. "Thunderbird 1\n",
  1708. "Firefox Graveyard 1\n",
  1709. "Firefox for iOS 1\n",
  1710. "Tracking 1\n",
  1711. "Add-on SDK 1\n",
  1712. "bugzilla.mozilla.org 1\n",
  1713. "Marketplace 1\n",
  1714. "Name: product, dtype: int64"
  1715. ]
  1716. },
  1717. "execution_count": 4,
  1718. "metadata": {},
  1719. "output_type": "execute_result"
  1720. }
  1721. ],
  1722. "source": [
  1723. "df['product'].value_counts()"
  1724. ]
  1725. },
  1726. {
  1727. "cell_type": "code",
  1728. "execution_count": 61,
  1729. "metadata": {
  1730. "collapsed": false,
  1731. "deletable": true,
  1732. "editable": true
  1733. },
  1734. "outputs": [
  1735. {
  1736. "data": {
  1737. "text/html": [
  1738. "<div>\n",
  1739. "<table border=\"1\" class=\"dataframe\">\n",
  1740. " <thead>\n",
  1741. " <tr style=\"text-align: right;\">\n",
  1742. " <th></th>\n",
  1743. " <th>assigned_to</th>\n",
  1744. " <th>assigned_to_detail</th>\n",
  1745. " <th>component</th>\n",
  1746. " <th>id</th>\n",
  1747. " <th>priority</th>\n",
  1748. " <th>product</th>\n",
  1749. " </tr>\n",
  1750. " </thead>\n",
  1751. " <tbody>\n",
  1752. " <tr>\n",
  1753. " <th>0</th>\n",
  1754. " <td>timdream@gmail.com</td>\n",
  1755. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1756. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1757. " <td>445093</td>\n",
  1758. " <td>--</td>\n",
  1759. " <td>Mozilla Localizations</td>\n",
  1760. " </tr>\n",
  1761. " <tr>\n",
  1762. " <th>2</th>\n",
  1763. " <td>timdream@gmail.com</td>\n",
  1764. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1765. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1766. " <td>464512</td>\n",
  1767. " <td>--</td>\n",
  1768. " <td>Mozilla Localizations</td>\n",
  1769. " </tr>\n",
  1770. " <tr>\n",
  1771. " <th>3</th>\n",
  1772. " <td>timdream@gmail.com</td>\n",
  1773. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1774. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1775. " <td>470899</td>\n",
  1776. " <td>--</td>\n",
  1777. " <td>Mozilla Localizations</td>\n",
  1778. " </tr>\n",
  1779. " <tr>\n",
  1780. " <th>4</th>\n",
  1781. " <td>timdream@gmail.com</td>\n",
  1782. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1783. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1784. " <td>471502</td>\n",
  1785. " <td>--</td>\n",
  1786. " <td>Mozilla Localizations</td>\n",
  1787. " </tr>\n",
  1788. " <tr>\n",
  1789. " <th>5</th>\n",
  1790. " <td>timdream@gmail.com</td>\n",
  1791. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1792. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1793. " <td>473949</td>\n",
  1794. " <td>--</td>\n",
  1795. " <td>Mozilla Localizations</td>\n",
  1796. " </tr>\n",
  1797. " <tr>\n",
  1798. " <th>6</th>\n",
  1799. " <td>timdream@gmail.com</td>\n",
  1800. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1801. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1802. " <td>493110</td>\n",
  1803. " <td>--</td>\n",
  1804. " <td>Mozilla Localizations</td>\n",
  1805. " </tr>\n",
  1806. " <tr>\n",
  1807. " <th>7</th>\n",
  1808. " <td>timdream@gmail.com</td>\n",
  1809. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1810. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1811. " <td>493697</td>\n",
  1812. " <td>--</td>\n",
  1813. " <td>Mozilla Localizations</td>\n",
  1814. " </tr>\n",
  1815. " <tr>\n",
  1816. " <th>8</th>\n",
  1817. " <td>timdream@gmail.com</td>\n",
  1818. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1819. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1820. " <td>493717</td>\n",
  1821. " <td>--</td>\n",
  1822. " <td>Mozilla Localizations</td>\n",
  1823. " </tr>\n",
  1824. " <tr>\n",
  1825. " <th>9</th>\n",
  1826. " <td>timdream@gmail.com</td>\n",
  1827. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1828. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1829. " <td>497311</td>\n",
  1830. " <td>--</td>\n",
  1831. " <td>Mozilla Localizations</td>\n",
  1832. " </tr>\n",
  1833. " <tr>\n",
  1834. " <th>10</th>\n",
  1835. " <td>timdream@gmail.com</td>\n",
  1836. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1837. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1838. " <td>497321</td>\n",
  1839. " <td>--</td>\n",
  1840. " <td>Mozilla Localizations</td>\n",
  1841. " </tr>\n",
  1842. " <tr>\n",
  1843. " <th>11</th>\n",
  1844. " <td>timdream@gmail.com</td>\n",
  1845. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1846. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1847. " <td>497324</td>\n",
  1848. " <td>--</td>\n",
  1849. " <td>Mozilla Localizations</td>\n",
  1850. " </tr>\n",
  1851. " <tr>\n",
  1852. " <th>12</th>\n",
  1853. " <td>timdream@gmail.com</td>\n",
  1854. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1855. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1856. " <td>522012</td>\n",
  1857. " <td>--</td>\n",
  1858. " <td>Mozilla Localizations</td>\n",
  1859. " </tr>\n",
  1860. " <tr>\n",
  1861. " <th>16</th>\n",
  1862. " <td>timdream@gmail.com</td>\n",
  1863. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1864. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1865. " <td>531657</td>\n",
  1866. " <td>--</td>\n",
  1867. " <td>Mozilla Localizations</td>\n",
  1868. " </tr>\n",
  1869. " <tr>\n",
  1870. " <th>17</th>\n",
  1871. " <td>timdream@gmail.com</td>\n",
  1872. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1873. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1874. " <td>533146</td>\n",
  1875. " <td>--</td>\n",
  1876. " <td>Mozilla Localizations</td>\n",
  1877. " </tr>\n",
  1878. " <tr>\n",
  1879. " <th>18</th>\n",
  1880. " <td>timdream@gmail.com</td>\n",
  1881. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1882. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1883. " <td>536506</td>\n",
  1884. " <td>--</td>\n",
  1885. " <td>Mozilla Localizations</td>\n",
  1886. " </tr>\n",
  1887. " <tr>\n",
  1888. " <th>19</th>\n",
  1889. " <td>timdream@gmail.com</td>\n",
  1890. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1891. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1892. " <td>537637</td>\n",
  1893. " <td>--</td>\n",
  1894. " <td>Mozilla Localizations</td>\n",
  1895. " </tr>\n",
  1896. " <tr>\n",
  1897. " <th>21</th>\n",
  1898. " <td>timdream@gmail.com</td>\n",
  1899. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1900. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1901. " <td>554076</td>\n",
  1902. " <td>--</td>\n",
  1903. " <td>Mozilla Localizations</td>\n",
  1904. " </tr>\n",
  1905. " <tr>\n",
  1906. " <th>24</th>\n",
  1907. " <td>timdream@gmail.com</td>\n",
  1908. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1909. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1910. " <td>585079</td>\n",
  1911. " <td>--</td>\n",
  1912. " <td>Mozilla Localizations</td>\n",
  1913. " </tr>\n",
  1914. " <tr>\n",
  1915. " <th>25</th>\n",
  1916. " <td>timdream@gmail.com</td>\n",
  1917. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1918. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1919. " <td>585274</td>\n",
  1920. " <td>--</td>\n",
  1921. " <td>Mozilla Localizations</td>\n",
  1922. " </tr>\n",
  1923. " <tr>\n",
  1924. " <th>26</th>\n",
  1925. " <td>timdream@gmail.com</td>\n",
  1926. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1927. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1928. " <td>585907</td>\n",
  1929. " <td>--</td>\n",
  1930. " <td>Mozilla Localizations</td>\n",
  1931. " </tr>\n",
  1932. " <tr>\n",
  1933. " <th>27</th>\n",
  1934. " <td>timdream@gmail.com</td>\n",
  1935. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1936. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1937. " <td>587019</td>\n",
  1938. " <td>--</td>\n",
  1939. " <td>Mozilla Localizations</td>\n",
  1940. " </tr>\n",
  1941. " <tr>\n",
  1942. " <th>28</th>\n",
  1943. " <td>timdream@gmail.com</td>\n",
  1944. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1945. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1946. " <td>596474</td>\n",
  1947. " <td>--</td>\n",
  1948. " <td>Mozilla Localizations</td>\n",
  1949. " </tr>\n",
  1950. " <tr>\n",
  1951. " <th>30</th>\n",
  1952. " <td>timdream@gmail.com</td>\n",
  1953. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1954. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1955. " <td>604023</td>\n",
  1956. " <td>--</td>\n",
  1957. " <td>Mozilla Localizations</td>\n",
  1958. " </tr>\n",
  1959. " <tr>\n",
  1960. " <th>31</th>\n",
  1961. " <td>timdream@gmail.com</td>\n",
  1962. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1963. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1964. " <td>615187</td>\n",
  1965. " <td>--</td>\n",
  1966. " <td>Mozilla Localizations</td>\n",
  1967. " </tr>\n",
  1968. " <tr>\n",
  1969. " <th>33</th>\n",
  1970. " <td>timdream@gmail.com</td>\n",
  1971. " <td>{u'id': 185001, u'email': u'timdream@gmail.com...</td>\n",
  1972. " <td>zh-TW / Chinese (Traditional)</td>\n",
  1973. " <td>675960</td>\n",
  1974. " <td>--</td>\n",
  1975. " <td>Mozilla Localizations</td>\n",
  1976. " </tr>\n",
  1977. " </tbody>\n",
  1978. "</table>\n",
  1979. "</div>"
  1980. ],
  1981. "text/plain": [
  1982. " assigned_to assigned_to_detail \\\n",
  1983. "0 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1984. "2 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1985. "3 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1986. "4 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1987. "5 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1988. "6 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1989. "7 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1990. "8 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1991. "9 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1992. "10 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1993. "11 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1994. "12 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1995. "16 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1996. "17 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1997. "18 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1998. "19 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  1999. "21 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2000. "24 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2001. "25 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2002. "26 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2003. "27 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2004. "28 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2005. "30 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2006. "31 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2007. "33 timdream@gmail.com {u'id': 185001, u'email': u'timdream@gmail.com... \n",
  2008. "\n",
  2009. " component id priority product \n",
  2010. "0 zh-TW / Chinese (Traditional) 445093 -- Mozilla Localizations \n",
  2011. "2 zh-TW / Chinese (Traditional) 464512 -- Mozilla Localizations \n",
  2012. "3 zh-TW / Chinese (Traditional) 470899 -- Mozilla Localizations \n",
  2013. "4 zh-TW / Chinese (Traditional) 471502 -- Mozilla Localizations \n",
  2014. "5 zh-TW / Chinese (Traditional) 473949 -- Mozilla Localizations \n",
  2015. "6 zh-TW / Chinese (Traditional) 493110 -- Mozilla Localizations \n",
  2016. "7 zh-TW / Chinese (Traditional) 493697 -- Mozilla Localizations \n",
  2017. "8 zh-TW / Chinese (Traditional) 493717 -- Mozilla Localizations \n",
  2018. "9 zh-TW / Chinese (Traditional) 497311 -- Mozilla Localizations \n",
  2019. "10 zh-TW / Chinese (Traditional) 497321 -- Mozilla Localizations \n",
  2020. "11 zh-TW / Chinese (Traditional) 497324 -- Mozilla Localizations \n",
  2021. "12 zh-TW / Chinese (Traditional) 522012 -- Mozilla Localizations \n",
  2022. "16 zh-TW / Chinese (Traditional) 531657 -- Mozilla Localizations \n",
  2023. "17 zh-TW / Chinese (Traditional) 533146 -- Mozilla Localizations \n",
  2024. "18 zh-TW / Chinese (Traditional) 536506 -- Mozilla Localizations \n",
  2025. "19 zh-TW / Chinese (Traditional) 537637 -- Mozilla Localizations \n",
  2026. "21 zh-TW / Chinese (Traditional) 554076 -- Mozilla Localizations \n",
  2027. "24 zh-TW / Chinese (Traditional) 585079 -- Mozilla Localizations \n",
  2028. "25 zh-TW / Chinese (Traditional) 585274 -- Mozilla Localizations \n",
  2029. "26 zh-TW / Chinese (Traditional) 585907 -- Mozilla Localizations \n",
  2030. "27 zh-TW / Chinese (Traditional) 587019 -- Mozilla Localizations \n",
  2031. "28 zh-TW / Chinese (Traditional) 596474 -- Mozilla Localizations \n",
  2032. "30 zh-TW / Chinese (Traditional) 604023 -- Mozilla Localizations \n",
  2033. "31 zh-TW / Chinese (Traditional) 615187 -- Mozilla Localizations \n",
  2034. "33 zh-TW / Chinese (Traditional) 675960 -- Mozilla Localizations "
  2035. ]
  2036. },
  2037. "execution_count": 61,
  2038. "metadata": {},
  2039. "output_type": "execute_result"
  2040. }
  2041. ],
  2042. "source": [
  2043. "df[df['product'].str.contains('Mozilla Localizations') == True]"
  2044. ]
  2045. },
  2046. {
  2047. "cell_type": "code",
  2048. "execution_count": null,
  2049. "metadata": {
  2050. "collapsed": true,
  2051. "deletable": true,
  2052. "editable": true
  2053. },
  2054. "outputs": [],
  2055. "source": []
  2056. }
  2057. ],
  2058. "metadata": {
  2059. "kernelspec": {
  2060. "display_name": "Python 2",
  2061. "language": "python",
  2062. "name": "python2"
  2063. },
  2064. "language_info": {
  2065. "codemirror_mode": {
  2066. "name": "ipython",
  2067. "version": 2
  2068. },
  2069. "file_extension": ".py",
  2070. "mimetype": "text/x-python",
  2071. "name": "python",
  2072. "nbconvert_exporter": "python",
  2073. "pygments_lexer": "ipython2",
  2074. "version": "2.7.13"
  2075. }
  2076. },
  2077. "nbformat": 4,
  2078. "nbformat_minor": 2
  2079. }
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!