Created
May 27, 2014 18:48
-
-
Save herrfz/b5b16991028b07123a65 to your computer and use it in GitHub Desktop.
toying around with graph api
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "metadata": { | |
| "name": "", | |
| "signature": "sha256:05422648a49f22daa0f624f940cf7c2a837c449095c78bce172b4a5073a0084c" | |
| }, | |
| "nbformat": 3, | |
| "nbformat_minor": 0, | |
| "worksheets": [ | |
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "import json\n", | |
| "import requests\n", | |
| "import hashlib\n", | |
| "import pandas as pd" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [], | |
| "prompt_number": 1 | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "ACCESS_TOKEN = ''" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [], | |
| "prompt_number": 2 | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "base_url = 'https://graph.facebook.com/me/'\n", | |
| "fields = 'home'\n", | |
| "url = '{}?fields={}&access_token={}'.format(base_url, fields, ACCESS_TOKEN)\n", | |
| "\n", | |
| "posts = []\n", | |
| "\n", | |
| "i = 0\n", | |
| "while True:\n", | |
| " try:\n", | |
| " content = requests.get(url).json()\n", | |
| " \n", | |
| " if i == 0:\n", | |
| " contents = content['home']['data']\n", | |
| " url = content['home']['paging']['next']\n", | |
| " else:\n", | |
| " contents = content['data']\n", | |
| " url = content['paging']['next']\n", | |
| " \n", | |
| " for post in contents:\n", | |
| " m = hashlib.md5()\n", | |
| " try:\n", | |
| " m.update(post['from']['name'])\n", | |
| " name = m.hexdigest()\n", | |
| " status = post['message']\n", | |
| " posts.append((name, status))\n", | |
| " except:\n", | |
| " continue\n", | |
| " \n", | |
| " i += 1\n", | |
| "\n", | |
| " except:\n", | |
| " break\n", | |
| "\n", | |
| "len(posts)" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "metadata": {}, | |
| "output_type": "pyout", | |
| "prompt_number": 16, | |
| "text": [ | |
| "319" | |
| ] | |
| } | |
| ], | |
| "prompt_number": 16 | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "df = pd.DataFrame(posts, columns=['name', 'status'])\n", | |
| "df" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "html": [ | |
| "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>name</th>\n", | |
| " <th>status</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0 </th>\n", | |
| " <td> b7614105b4075a560dc960622205ca4d</td>\n", | |
| " <td> Di \"pijet\" Khalid memang lebih enak dibanding ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1 </th>\n", | |
| " <td> 380ece00e3a5c3b9c876cbeb0c8a38bb</td>\n", | |
| " <td> Schleicher mit Lichthupe verdr\u00e4ngen? Ja oder N...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2 </th>\n", | |
| " <td> d279eb03080cdc91c708349912867b15</td>\n", | |
| " <td> \u201cBasically, Kenny... You are Keanu Reeves.\u201d\\n\\...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3 </th>\n", | |
| " <td> b0db045e045cd721e85fbe6fbdf76045</td>\n", | |
| " <td> Jangan terkecoh, kata Prijanto</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4 </th>\n", | |
| " <td> c11deae89867c2b1c520861af3bac590</td>\n", | |
| " <td> The LP Underground will be hosting the 10th In...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5 </th>\n", | |
| " <td> c0e67c407905103dbce3984c756f3f21</td>\n", | |
| " <td> The countdown starts to August, and fans of cl...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6 </th>\n", | |
| " <td> 380ece00e3a5c3b9c876cbeb0c8a38bb</td>\n", | |
| " <td> Was war das h\u00f6chste Riesenrad, in dem Ihr bish...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7 </th>\n", | |
| " <td> f440ed5adec363da81e0d00ae69ec12f</td>\n", | |
| " <td> Why did CoreOS, the company behind the new con...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8 </th>\n", | |
| " <td> 583e9780f7fdb235c7fcdd97aa164ef3</td>\n", | |
| " <td> \"I loved your mother more than you could ever ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9 </th>\n", | |
| " <td> 2576e9bd83cf0da4704edde3dbe2caf7</td>\n", | |
| " <td> If you\u2019re seeing the out of data message. Not ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td> a20e4567288b076388e1694fd0dffac7</td>\n", | |
| " <td> \u0645\u062b\u0642\u0641\u0648 \u0627\u0644\u0645\u0645\u0627\u0646\u0639\u0629 \u0627\u0644\u0644\u0628\u0646\u0627\u0646\u064a\u064a\u0648\u0646 / \u0627\u0644\u0633\u0648\u0631\u064a\u0648\u0646 \u064a\u0639\u0644\u0646\u0648\u0627 ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td> db93d4f9cf8915a78a11abccd45860d0</td>\n", | |
| " <td> Nah ini Presidenku! :D</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td> 380ece00e3a5c3b9c876cbeb0c8a38bb</td>\n", | |
| " <td> Hier die L\u00f6sung. Habt Ihr alle drei entdeckt? ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td> 76ced828d6e5b6ddeebf7ec9b17e774f</td>\n", | |
| " <td> Bapak saya sederhana, bukan siapa2.\\nUstadz bu...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td> c655f28174d531bdf1330241740ac883</td>\n", | |
| " <td> Our visit to LTA Singapore (ITS centre)</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td> a20e4567288b076388e1694fd0dffac7</td>\n", | |
| " <td> Sandy Ch Roy Dib\\n\\n\u0623\u063a\u0646\u064a\u0629 \u0642\u062f\u064a\u0645\u0629 \u062a\u0644\u064a\u0642 \u0628\u0628\u062d\u0651\u0629 \"\u0628\u062d...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td> a20e4567288b076388e1694fd0dffac7</td>\n", | |
| " <td> \u0634\u0631\u0627\u064a\u064a\u0646 \u0632\u0631\u0642\u0627\u0621 \u0639\u0644\u0649 \u0635\u062f\u063a \u0646\u0627\u062f\u0644\u0629\\n\\n\\n\u00ab\u0645\u0642\u0647\u0649 \u062c\u0645\u064a\u0644\u060c \u064a\u0646...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td> ea807b1a897b39d775af4daacb1e5ca6</td>\n", | |
| " <td> yes, it's only because mom n dad didn't allow ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td> d279eb03080cdc91c708349912867b15</td>\n", | |
| " <td> BUTTERS: Get it up there good and deep.\\n\\nAW...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td> fa6c90713e78aaa6eba105642245b12e</td>\n", | |
| " <td> ..follow the moskwa, down to gorky park... lis...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td> 5d0578c900cdee248dfe2e1eb86b43da</td>\n", | |
| " <td> Frei...endlich, Geschafft !!</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td> 380ece00e3a5c3b9c876cbeb0c8a38bb</td>\n", | |
| " <td> Na? Wie viele Personen verstecken sich auf dem...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td> d86126d9423b22509fe68ac3334acbbb</td>\n", | |
| " <td> Barangkali banyak dari tersangka dan trpidana ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td> add5f7533b6e30df950675a23df6a0f2</td>\n", | |
| " <td> Caravan seru juga</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td> 230b730a0aba339ea2c3e592b265ce27</td>\n", | |
| " <td> Saking frustrasinya dengan jalannya demokrasi ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td> dd9126c379c7c10e66d84050f6b7f2f9</td>\n", | |
| " <td> Although I am not local, this is an excellent ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td> 2b4456ccd20bef89685f61fe65f439f4</td>\n", | |
| " <td> C'est time. Thank you for everything Germany! :*</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td> 380ece00e3a5c3b9c876cbeb0c8a38bb</td>\n", | |
| " <td> Wow! Schon 50.000 haben unseren YouTube-Channe...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td> fa6c90713e78aaa6eba105642245b12e</td>\n", | |
| " <td> Science of stupid.... never fail to make me la...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td> 427edf8a80785725bfd3aecfe174d2a8</td>\n", | |
| " <td> Pie susu ala emak... gegara lihat anak2 doyan ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>30</th>\n", | |
| " <td> 0a6d9b596b89c3fb62df767a7438f54a</td>\n", | |
| " <td> RT Keren Tanpa Rokok (@KerenTanpaRokok) HARI ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>31</th>\n", | |
| " <td> fa6c90713e78aaa6eba105642245b12e</td>\n", | |
| " <td> Orang miskin gak boleh SAKIT, susah SEKOLAH, s...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>32</th>\n", | |
| " <td> fa6c90713e78aaa6eba105642245b12e</td>\n", | |
| " <td> uuu baby baby...it's a wild world... i'll alwa...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>33</th>\n", | |
| " <td> 2b4456ccd20bef89685f61fe65f439f4</td>\n", | |
| " <td> Hampir semua warga indonesia sibuk \"berantem\" ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>34</th>\n", | |
| " <td> a20e4567288b076388e1694fd0dffac7</td>\n", | |
| " <td> \u0639\u0627\u062c\u0644: \u0645\u0635\u0631\u064a \u064a\u0637\u0644\u0628 \u0627\u0644\u0632\u0648\u0627\u062c \u0645\u0646 \u0645\u0635\u0631\u064a\u0629 \u0642\u062f\u0627\u0645\u064a \u0628\u0627\u0644\u0645\u0637\u0639\u0645 ...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>35</th>\n", | |
| " <td> 380ece00e3a5c3b9c876cbeb0c8a38bb</td>\n", | |
| " <td> W\u00e4r das nicht was f\u00fcr den Vatertag?</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>36</th>\n", | |
| " <td> fa6c90713e78aaa6eba105642245b12e</td>\n", | |
| " <td> gilak !!</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>37</th>\n", | |
| " <td> 97323467cc956e3423c8f05952956df9</td>\n", | |
| " <td> hahaha. lucu</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>38</th>\n", | |
| " <td> db93d4f9cf8915a78a11abccd45860d0</td>\n", | |
| " <td> Menarik nggak nih pak Achmad Rizal?</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>39</th>\n", | |
| " <td> a4b0366d0529ef864b696dc1e5f18625</td>\n", | |
| " <td> Kira2 orang masih berani korupsi gak kalo:\\nA....</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>40</th>\n", | |
| " <td> 97323467cc956e3423c8f05952956df9</td>\n", | |
| " <td> PKS di pemerintahan ? siap2 menkominfo dan men...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>41</th>\n", | |
| " <td> 248f1bcbef24a3bd3f46f492de33a82e</td>\n", | |
| " <td> agar indonesia bebas rokok, naikkan pajak roko...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>42</th>\n", | |
| " <td> db93d4f9cf8915a78a11abccd45860d0</td>\n", | |
| " <td> Selamat kepada civitas akademika UNPAD...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>43</th>\n", | |
| " <td> c64e5d2e56cb139765ae10c40facab19</td>\n", | |
| " <td> Indonesia's presidential election is coming so...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>44</th>\n", | |
| " <td> 12f1b6ae95589e2f97ac2cb3f8dca23b</td>\n", | |
| " <td> Jogjakarta we love u so much....JOGJA ISTIMEWA</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>45</th>\n", | |
| " <td> 5dc5e1873f1b38202c1bb867f2e07a86</td>\n", | |
| " <td> Papandayan Sunrise</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>46</th>\n", | |
| " <td> d86126d9423b22509fe68ac3334acbbb</td>\n", | |
| " <td> Reuni kecil sobat SMP 3 Semarang.. 17 Tahun ga...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>47</th>\n", | |
| " <td> a4b0366d0529ef864b696dc1e5f18625</td>\n", | |
| " <td> What do you know.. even our own shits might cu...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>48</th>\n", | |
| " <td> db93d4f9cf8915a78a11abccd45860d0</td>\n", | |
| " <td> Ikutan boss Dimas Fajar Soedibyo hasilnya begi...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>49</th>\n", | |
| " <td> fa6c90713e78aaa6eba105642245b12e</td>\n", | |
| " <td> ediaannn\\n</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>50</th>\n", | |
| " <td> 2b4456ccd20bef89685f61fe65f439f4</td>\n", | |
| " <td> slamat ulang tahun Bro!</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>51</th>\n", | |
| " <td> 00d772a2021cb625c5a7c0e12223e949</td>\n", | |
| " <td> Kalau mentri, gubernur, walikota, pejabat ting...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>52</th>\n", | |
| " <td> b0db045e045cd721e85fbe6fbdf76045</td>\n", | |
| " <td> Cuma sekedar mengingatkan kembali janji njenen...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>53</th>\n", | |
| " <td> 1ddae1e0989a8a62ab92a4bbf9353c33</td>\n", | |
| " <td> Gw baru duduk ngopi sepenanakan nasi, tau2 kes...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>54</th>\n", | |
| " <td> 248f1bcbef24a3bd3f46f492de33a82e</td>\n", | |
| " <td> setali tiga uang ya....:)</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>55</th>\n", | |
| " <td> 7300cbaf83c963dcd6c54aea15ae24cf</td>\n", | |
| " <td> Kalau saya umat apa pak?</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>56</th>\n", | |
| " <td> 248f1bcbef24a3bd3f46f492de33a82e</td>\n", | |
| " <td> katanya .... katanya....1000 x</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>57</th>\n", | |
| " <td> b2f6b5085e972cd052b04d14a96403a7</td>\n", | |
| " <td> Selamat Merayakan Peringatan ISRA MI RAJ\\n\\nRa...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>58</th>\n", | |
| " <td> 248f1bcbef24a3bd3f46f492de33a82e</td>\n", | |
| " <td> mana boneka mana yg bukan.</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>59</th>\n", | |
| " <td> 248f1bcbef24a3bd3f46f492de33a82e</td>\n", | |
| " <td> cuma kata kata dan gambar aja, kedua kubu suda...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th></th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>319 rows \u00d7 2 columns</p>\n", | |
| "</div>" | |
| ], | |
| "metadata": {}, | |
| "output_type": "pyout", | |
| "prompt_number": 17, | |
| "text": [ | |
| " name \\\n", | |
| "0 b7614105b4075a560dc960622205ca4d \n", | |
| "1 380ece00e3a5c3b9c876cbeb0c8a38bb \n", | |
| "2 d279eb03080cdc91c708349912867b15 \n", | |
| "3 b0db045e045cd721e85fbe6fbdf76045 \n", | |
| "4 c11deae89867c2b1c520861af3bac590 \n", | |
| "5 c0e67c407905103dbce3984c756f3f21 \n", | |
| "6 380ece00e3a5c3b9c876cbeb0c8a38bb \n", | |
| "7 f440ed5adec363da81e0d00ae69ec12f \n", | |
| "8 583e9780f7fdb235c7fcdd97aa164ef3 \n", | |
| "9 2576e9bd83cf0da4704edde3dbe2caf7 \n", | |
| "10 a20e4567288b076388e1694fd0dffac7 \n", | |
| "11 db93d4f9cf8915a78a11abccd45860d0 \n", | |
| "12 380ece00e3a5c3b9c876cbeb0c8a38bb \n", | |
| "13 76ced828d6e5b6ddeebf7ec9b17e774f \n", | |
| "14 c655f28174d531bdf1330241740ac883 \n", | |
| "15 a20e4567288b076388e1694fd0dffac7 \n", | |
| "16 a20e4567288b076388e1694fd0dffac7 \n", | |
| "17 ea807b1a897b39d775af4daacb1e5ca6 \n", | |
| "18 d279eb03080cdc91c708349912867b15 \n", | |
| "19 fa6c90713e78aaa6eba105642245b12e \n", | |
| "20 5d0578c900cdee248dfe2e1eb86b43da \n", | |
| "21 380ece00e3a5c3b9c876cbeb0c8a38bb \n", | |
| "22 d86126d9423b22509fe68ac3334acbbb \n", | |
| "23 add5f7533b6e30df950675a23df6a0f2 \n", | |
| "24 230b730a0aba339ea2c3e592b265ce27 \n", | |
| "25 dd9126c379c7c10e66d84050f6b7f2f9 \n", | |
| "26 2b4456ccd20bef89685f61fe65f439f4 \n", | |
| "27 380ece00e3a5c3b9c876cbeb0c8a38bb \n", | |
| "28 fa6c90713e78aaa6eba105642245b12e \n", | |
| "29 427edf8a80785725bfd3aecfe174d2a8 \n", | |
| "30 0a6d9b596b89c3fb62df767a7438f54a \n", | |
| "31 fa6c90713e78aaa6eba105642245b12e \n", | |
| "32 fa6c90713e78aaa6eba105642245b12e \n", | |
| "33 2b4456ccd20bef89685f61fe65f439f4 \n", | |
| "34 a20e4567288b076388e1694fd0dffac7 \n", | |
| "35 380ece00e3a5c3b9c876cbeb0c8a38bb \n", | |
| "36 fa6c90713e78aaa6eba105642245b12e \n", | |
| "37 97323467cc956e3423c8f05952956df9 \n", | |
| "38 db93d4f9cf8915a78a11abccd45860d0 \n", | |
| "39 a4b0366d0529ef864b696dc1e5f18625 \n", | |
| "40 97323467cc956e3423c8f05952956df9 \n", | |
| "41 248f1bcbef24a3bd3f46f492de33a82e \n", | |
| "42 db93d4f9cf8915a78a11abccd45860d0 \n", | |
| "43 c64e5d2e56cb139765ae10c40facab19 \n", | |
| "44 12f1b6ae95589e2f97ac2cb3f8dca23b \n", | |
| "45 5dc5e1873f1b38202c1bb867f2e07a86 \n", | |
| "46 d86126d9423b22509fe68ac3334acbbb \n", | |
| "47 a4b0366d0529ef864b696dc1e5f18625 \n", | |
| "48 db93d4f9cf8915a78a11abccd45860d0 \n", | |
| "49 fa6c90713e78aaa6eba105642245b12e \n", | |
| "50 2b4456ccd20bef89685f61fe65f439f4 \n", | |
| "51 00d772a2021cb625c5a7c0e12223e949 \n", | |
| "52 b0db045e045cd721e85fbe6fbdf76045 \n", | |
| "53 1ddae1e0989a8a62ab92a4bbf9353c33 \n", | |
| "54 248f1bcbef24a3bd3f46f492de33a82e \n", | |
| "55 7300cbaf83c963dcd6c54aea15ae24cf \n", | |
| "56 248f1bcbef24a3bd3f46f492de33a82e \n", | |
| "57 b2f6b5085e972cd052b04d14a96403a7 \n", | |
| "58 248f1bcbef24a3bd3f46f492de33a82e \n", | |
| "59 248f1bcbef24a3bd3f46f492de33a82e \n", | |
| " ... \n", | |
| "\n", | |
| " status \n", | |
| "0 Di \"pijet\" Khalid memang lebih enak dibanding ... \n", | |
| "1 Schleicher mit Lichthupe verdr\u00e4ngen? Ja oder N... \n", | |
| "2 \u201cBasically, Kenny... You are Keanu Reeves.\u201d\\n\\... \n", | |
| "3 Jangan terkecoh, kata Prijanto \n", | |
| "4 The LP Underground will be hosting the 10th In... \n", | |
| "5 The countdown starts to August, and fans of cl... \n", | |
| "6 Was war das h\u00f6chste Riesenrad, in dem Ihr bish... \n", | |
| "7 Why did CoreOS, the company behind the new con... \n", | |
| "8 \"I loved your mother more than you could ever ... \n", | |
| "9 If you\u2019re seeing the out of data message. Not ... \n", | |
| "10 \u0645\u062b\u0642\u0641\u0648 \u0627\u0644\u0645\u0645\u0627\u0646\u0639\u0629 \u0627\u0644\u0644\u0628\u0646\u0627\u0646\u064a\u064a\u0648\u0646 / \u0627\u0644\u0633\u0648\u0631\u064a\u0648\u0646 \u064a\u0639\u0644\u0646\u0648\u0627 ... \n", | |
| "11 Nah ini Presidenku! :D \n", | |
| "12 Hier die L\u00f6sung. Habt Ihr alle drei entdeckt? ... \n", | |
| "13 Bapak saya sederhana, bukan siapa2.\\nUstadz bu... \n", | |
| "14 Our visit to LTA Singapore (ITS centre) \n", | |
| "15 Sandy Ch Roy Dib\\n\\n\u0623\u063a\u0646\u064a\u0629 \u0642\u062f\u064a\u0645\u0629 \u062a\u0644\u064a\u0642 \u0628\u0628\u062d\u0651\u0629 \"\u0628\u062d... \n", | |
| "16 \u0634\u0631\u0627\u064a\u064a\u0646 \u0632\u0631\u0642\u0627\u0621 \u0639\u0644\u0649 \u0635\u062f\u063a \u0646\u0627\u062f\u0644\u0629\\n\\n\\n\u00ab\u0645\u0642\u0647\u0649 \u062c\u0645\u064a\u0644\u060c \u064a\u0646... \n", | |
| "17 yes, it's only because mom n dad didn't allow ... \n", | |
| "18 BUTTERS: Get it up there good and deep.\\n\\nAW... \n", | |
| "19 ..follow the moskwa, down to gorky park... lis... \n", | |
| "20 Frei...endlich, Geschafft !! \n", | |
| "21 Na? Wie viele Personen verstecken sich auf dem... \n", | |
| "22 Barangkali banyak dari tersangka dan trpidana ... \n", | |
| "23 Caravan seru juga \n", | |
| "24 Saking frustrasinya dengan jalannya demokrasi ... \n", | |
| "25 Although I am not local, this is an excellent ... \n", | |
| "26 C'est time. Thank you for everything Germany! :* \n", | |
| "27 Wow! Schon 50.000 haben unseren YouTube-Channe... \n", | |
| "28 Science of stupid.... never fail to make me la... \n", | |
| "29 Pie susu ala emak... gegara lihat anak2 doyan ... \n", | |
| "30 RT Keren Tanpa Rokok (@KerenTanpaRokok) HARI ... \n", | |
| "31 Orang miskin gak boleh SAKIT, susah SEKOLAH, s... \n", | |
| "32 uuu baby baby...it's a wild world... i'll alwa... \n", | |
| "33 Hampir semua warga indonesia sibuk \"berantem\" ... \n", | |
| "34 \u0639\u0627\u062c\u0644: \u0645\u0635\u0631\u064a \u064a\u0637\u0644\u0628 \u0627\u0644\u0632\u0648\u0627\u062c \u0645\u0646 \u0645\u0635\u0631\u064a\u0629 \u0642\u062f\u0627\u0645\u064a \u0628\u0627\u0644\u0645\u0637\u0639\u0645 ... \n", | |
| "35 W\u00e4r das nicht was f\u00fcr den Vatertag? \n", | |
| "36 gilak !! \n", | |
| "37 hahaha. lucu \n", | |
| "38 Menarik nggak nih pak Achmad Rizal? \n", | |
| "39 Kira2 orang masih berani korupsi gak kalo:\\nA.... \n", | |
| "40 PKS di pemerintahan ? siap2 menkominfo dan men... \n", | |
| "41 agar indonesia bebas rokok, naikkan pajak roko... \n", | |
| "42 Selamat kepada civitas akademika UNPAD... \n", | |
| "43 Indonesia's presidential election is coming so... \n", | |
| "44 Jogjakarta we love u so much....JOGJA ISTIMEWA \n", | |
| "45 Papandayan Sunrise \n", | |
| "46 Reuni kecil sobat SMP 3 Semarang.. 17 Tahun ga... \n", | |
| "47 What do you know.. even our own shits might cu... \n", | |
| "48 Ikutan boss Dimas Fajar Soedibyo hasilnya begi... \n", | |
| "49 ediaannn\\n \n", | |
| "50 slamat ulang tahun Bro! \n", | |
| "51 Kalau mentri, gubernur, walikota, pejabat ting... \n", | |
| "52 Cuma sekedar mengingatkan kembali janji njenen... \n", | |
| "53 Gw baru duduk ngopi sepenanakan nasi, tau2 kes... \n", | |
| "54 setali tiga uang ya....:) \n", | |
| "55 Kalau saya umat apa pak? \n", | |
| "56 katanya .... katanya....1000 x \n", | |
| "57 Selamat Merayakan Peringatan ISRA MI RAJ\\n\\nRa... \n", | |
| "58 mana boneka mana yg bukan. \n", | |
| "59 cuma kata kata dan gambar aja, kedua kubu suda... \n", | |
| " ... \n", | |
| "\n", | |
| "[319 rows x 2 columns]" | |
| ] | |
| } | |
| ], | |
| "prompt_number": 17 | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [ | |
| "df.groupby('name')['status'].count().order(ascending=False)" | |
| ], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "metadata": {}, | |
| "output_type": "pyout", | |
| "prompt_number": 18, | |
| "text": [ | |
| "name\n", | |
| "a20e4567288b076388e1694fd0dffac7 26\n", | |
| "248f1bcbef24a3bd3f46f492de33a82e 26\n", | |
| "380ece00e3a5c3b9c876cbeb0c8a38bb 22\n", | |
| "db93d4f9cf8915a78a11abccd45860d0 16\n", | |
| "d279eb03080cdc91c708349912867b15 15\n", | |
| "fa6c90713e78aaa6eba105642245b12e 14\n", | |
| "b0db045e045cd721e85fbe6fbdf76045 14\n", | |
| "7300cbaf83c963dcd6c54aea15ae24cf 13\n", | |
| "f440ed5adec363da81e0d00ae69ec12f 8\n", | |
| "583e9780f7fdb235c7fcdd97aa164ef3 7\n", | |
| "2b4456ccd20bef89685f61fe65f439f4 7\n", | |
| "0a6d9b596b89c3fb62df767a7438f54a 7\n", | |
| "dd9126c379c7c10e66d84050f6b7f2f9 6\n", | |
| "bb28f52f24482ee421aa70bd15a9e7ad 6\n", | |
| "ae350205d736a523b2a2c82716638480 6\n", | |
| "...\n", | |
| "782b6d6ed0533f41706bf4e9cf5cf716 1\n", | |
| "6f9d1d3fc930343f36867f49f2cf6b91 1\n", | |
| "682f1bb355ffcbca09cf838dc80b6556 1\n", | |
| "5d0578c900cdee248dfe2e1eb86b43da 1\n", | |
| "59869b09e4c75d8d7fde161b3f1a76e8 1\n", | |
| "4a5225c05fb206ab3a8f1a5f0e0a4ab2 1\n", | |
| "463f96e158218e567cfe7c2cc4eb47b2 1\n", | |
| "381a4bf5037cd6b928c0bf69edb8453c 1\n", | |
| "301424685023605d75e271659a489e30 1\n", | |
| "29f7bf373afa5499bf26b5e84967f53d 1\n", | |
| "1eff7e86f5f1a4b454e692ad1dd32553 1\n", | |
| "1ddae1e0989a8a62ab92a4bbf9353c33 1\n", | |
| "1dcc74266ae18e0be1564f075d532c73 1\n", | |
| "1cd96110507c55859d19666f6f9644b6 1\n", | |
| "1c0b92959b8b87f409f9a6e21ab512cf 1\n", | |
| "Length: 82, dtype: int64" | |
| ] | |
| } | |
| ], | |
| "prompt_number": 18 | |
| }, | |
| { | |
| "cell_type": "code", | |
| "collapsed": false, | |
| "input": [], | |
| "language": "python", | |
| "metadata": {}, | |
| "outputs": [] | |
| } | |
| ], | |
| "metadata": {} | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment