{ "metadata": { "signature": "sha256:028dc5e5e0ad07086953ec28d7dde90d1cbc4af91026f4da53393013fef815b8" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Topic Modeling on Turkish News\n", "by [Talha Oz](http://www.mli.gmu.edu/toz/wordpress/)\n", "\n", "Details on the project is available on [GitHub](https://github.com/oztalha/News-Commentary-Tweets-of-Elites)" ] }, { "cell_type": "code", "collapsed": false, "input": [ "cd 'C:\\Users\\Talha\\Documents\\WinPython\\projelerim\\news\\News-Commentary-Tweets-of-Elites'" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "C:\\Users\\Talha\\Documents\\WinPython\\projelerim\\news\\News-Commentary-Tweets-of-Elites\n" ] } ], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "from gensim import corpora, models\n", "from nltk.corpus import stopwords\n", "import nltk\n", "import snowballstemmer\n", "import re\n", "from operator import itemgetter" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "df = pd.read_csv('data/TR-news.csv',usecols=['dt','title','newstxt'],parse_dates=[0])\n", "df = df[df['newstxt'].str.contains(\"Amerika|ABD|Obama\")]\n", "documents = df.newstxt.tolist()\n", "df.sort(['dt']).to_csv('data/amerika-news.csv',encoding='utf-8',index=False,columns=['dt','title'])\n", "df.sort(['dt'])" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | dt | \n", "title | \n", "newstxt | \n", "
---|---|---|---|
1916 | \n", "2013-01-14 | \n", "1979 \u0130ran\u2019\u0131na \u00f6d\u00fcl ya\u011fd\u0131 \u2013 nediyor.com | \n", "\\nOscar\u2019dan sonra sinema d\u00fcnyas\u0131n\u0131n en prestij... | \n", "
1917 | \n", "2013-01-14 | \n", "Sa\u011fl\u0131k Bakanl\u0131\u011f\u0131\u2019ndan Refiye a\u00e7\u0131klamas\u0131 \u2013 nedi... | \n", "\\nMilyonda bir g\u00f6r\u00fclen \u201cGardner sendromu\u201d hast... | \n", "
1852 | \n", "2013-01-16 | \n", "\u00dcnl\u00fc ressam Do\u011fan\u00e7ay hayat\u0131n\u0131 kaybetti \u2013 nediy... | \n", "\\n\u00dcnl\u00fc ressam Burhan Do\u011fan\u00e7ay bu sabah tedavi ... | \n", "
1851 | \n", "2013-01-16 | \n", "Mehmet Ali Birand hastaneye kald\u0131r\u0131ld\u0131 \u2013 nediy... | \n", "\\nKanal D Haber Grup Ba\u015fkan\u0131 ve anchorman\u2019\u0131 de... | \n", "
1812 | \n", "2013-01-17 | \n", "Gazetecili\u011fin ikonu Birand\u2019\u0131 kaybettik \u2013 nediy... | \n", "\\nKanal D Haber Grup Ba\u015fkan\u0131 Mehmet Ali Birand... | \n", "
1825 | \n", "2013-01-17 | \n", "\u00d6l\u00fcm haberine Umur Birand\u2019tan yalanlama \u2013 nedi... | \n", "\\nKanal D Haber Grup Ba\u015fkan\u0131 Mehmet Ali Birand... | \n", "
1795 | \n", "2013-01-18 | \n", "Birand\u2019\u0131n \u00f6l\u00fcm\u00fcnde ihmal \u015f\u00fcphesi \u2013 nediyor.com | \n", "\\nDuayen gazeteci Mehmet Ali Birand\u2019\u0131n Sal\u0131 g\u00fc... | \n", "
1796 | \n", "2013-01-18 | \n", "Armstrong sonunda dopingi itiraf etti \u2013 nediyo... | \n", "\\nAmerika\u2019n\u0131n g\u00fcndemi Lance Armstrong. \u00dcnl\u00fc bi... | \n", "
1788 | \n", "2013-01-19 | \n", "Birand son yolculu\u011funa u\u011furland\u0131 \u2013 nediyor.com | \n", "\\nPer\u015fembe g\u00fcn\u00fc vefat eden duayen gazeteci Meh... | \n", "
1761 | \n", "2013-01-21 | \n", "Patriotlar T\u00fcrkiye\u2019de \u2013 nediyor.com | \n", "\\nT\u00fcrkiye\u2019nin Suriye s\u0131n\u0131r\u0131na konu\u015fland\u0131rmak \u00fc... | \n", "
70 | \n", "2013-01-22 | \n", "Hatay\u2019da NATO askerine \u00e7uval ge\u00e7irme giri\u015fimi ... | \n", "\\nHatay\u2019\u0131n \u0130skenderun il\u00e7esinde T\u00fcrkiye Gen\u00e7li... | \n", "
1744 | \n", "2013-01-22 | \n", "Obama ikinci kez yemin etti \u2013 nediyor.com | \n", "\\nABD Ba\u015fkan\u0131 Barack Obama, ikinci ba\u015fkanl\u0131k d... | \n", "
1647 | \n", "2013-01-25 | \n", "Samatya\u2019daki sald\u0131r\u0131lar\u0131n faili ayn\u0131 ki\u015fi \u2013 ne... | \n", "\\n\u0130stanbul\u2019da ge\u00e7ti\u011fimiz Aral\u0131k ay\u0131ndan bu yan... | \n", "
1551 | \n", "2013-01-29 | \n", "\u201c\u015eangay Be\u015flisi\u201d a\u00e7\u0131l\u0131m\u0131na ABD\u2019den g\u00fcl\u00fcmseme \u2013... | \n", "\\nBa\u015fbakan Erdo\u011fan\u2019\u0131n AB\u2019ye alternatif olarak ... | \n", "
56 | \n", "2013-01-30 | \n", "\u0130srail u\u00e7aklar\u0131 Suriye\u2019yi vurdu \u2013 nediyor.com | \n", "\\nSuriye, \u0130srail\u2019e ait sava\u015f u\u00e7aklar\u0131n\u0131n d\u00fcn b... | \n", "
1492 | \n", "2013-02-01 | \n", "Birand\u2019\u0131n 33\u2032\u00fcnc\u00fc g\u00fcn\u00fc \u2013 nediyor.com | \n", "\\nCan D\u00fcndar ve B\u00fclent \u00c7apl\u0131\u2019n\u0131n 17 Ocak\u2019ta ya... | \n", "
1479 | \n", "2013-02-01 | \n", "ABD B\u00fcy\u00fckel\u00e7ili\u011fi\u2019ne intihar sald\u0131r\u0131s\u0131 \u2013 nediy... | \n", "\\nABD\u2019nin Ankara B\u00fcy\u00fckel\u00e7ili\u011fi\u2019nde saat 13:00 ... | \n", "
1476 | \n", "2013-02-01 | \n", "Sald\u0131r\u0131da talihsiz randevu \u2013 nediyor.com | \n", "\\n ABD\u2019nin Ankara B\u00fcy\u00fckel\u00e7ili\u011fi\u2019nde ger\u00e7ekle\u015fe... | \n", "
52 | \n", "2013-02-01 | \n", "Ba\u015fbakan: \u201cTSK bir ter\u00f6r \u00f6rg\u00fct\u00fc de\u011fildir\u201d \u2013 ne... | \n", "\\nBa\u015fbakan Erdo\u011fan, silahl\u0131 ter\u00f6r \u00f6rg\u00fct\u00fc lider... | \n", "
1464 | \n", "2013-02-02 | \n", "Radikal\u2019e \u201cKorsakoff\u201d tepkisi \u2013 nediyor.com | \n", "\\nD\u00fcn Ankara\u2019da ABD Ba\u015fkonsoloslu\u011fu\u2019na d\u00fczenle... | \n", "
1436 | \n", "2013-02-04 | \n", "Sarai\u2019nin soru\u015fturmas\u0131na FBI da dahil oldu \u2013 n... | \n", "\\n \u0130stanbul\u2019da kaybolduktan bir s\u00fcre sonra Cum... | \n", "
49 | \n", "2013-02-05 | \n", "Didem Tuncay\u2019dan \u00fczen haber \u2013 nediyor.com | \n", "\\nABD\u2019nin Ankara B\u00fcy\u00fckel\u00e7ili\u011fi giri\u015findeki pat... | \n", "
1419 | \n", "2013-02-05 | \n", "Tarantino\u2019nun \u201cZincirsiz\u201di beklenen ilgiyi g\u00f6r... | \n", "\\n\u201cEn \u0130yi Film\u201d dahil 5 dalda Oscar (Sinema Sa... | \n", "
1417 | \n", "2013-02-05 | \n", "Erdo\u011fan \u201c\u015eangay Be\u015flisi\u201dni savundu \u2013 nediyor.com | \n", "\\nBa\u015fbakan Erdo\u011fan ile Rusya Devlet Ba\u015fkan\u0131 Pu... | \n", "
45 | \n", "2013-02-06 | \n", "Ergin Saygun\u2019un k\u0131z\u0131n\u0131n \u00e7\u0131\u011fl\u0131\u011f\u0131 \u2013 nediyor.com | \n", "\\nBalyoz davas\u0131nda 18 y\u0131l hapis cezas\u0131 verilen... | \n", "
1388 | \n", "2013-02-06 | \n", "Ahmedinejad\u2019a da ayakkab\u0131 \u2013 nediyor.com | \n", "\\n\u0130ran Cumhurba\u015fkan\u0131 Ahmedinejad, Kahire\u2019de Su... | \n", "
1365 | \n", "2013-02-07 | \n", "FBI Sarai Sierra\u2019dan \u015f\u00fcphelendi \u2013 nediyor.com | \n", "\\nSarai Sierra\u2019n\u0131n \u00f6l\u00fcm\u00fcn\u00fc soru\u015fturan Amerikan... | \n", "
1364 | \n", "2013-02-07 | \n", "T\u00fcrkiye uyard\u0131; Obama y\u00f6netimi sahip \u00e7\u0131kt\u0131 \u2013 n... | \n", "\\nABD B\u00fcy\u00fckel\u00e7isi Francis Ricciardone, T\u00fcrk ya... | \n", "
1333 | \n", "2013-02-08 | \n", "DHKP-C g\u00f6z\u00fcn\u00fc \u00e7\u0131kartt\u0131; \u00f6z\u00fcr diledi \u2013 nediyor.com | \n", "\\nDHKP-C, ABD\u2019nin Ankara B\u00fcy\u00fckel\u00e7ili\u011fi\u2019ne y\u00f6ne... | \n", "
1335 | \n", "2013-02-08 | \n", "Saygun tahliyesinde Ar\u0131n\u00e7 tesad\u00fcf\u00fc \u2013 nediyor.com | \n", "\\nBa\u015fbakan Yard\u0131mc\u0131s\u0131 B\u00fclent Ar\u0131n\u00e7, d\u00fcn ak\u015fam ... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
9944 | \n", "2014-11-29 | \n", "Kobani\u2019deki \u00e7at\u0131\u015fmalar s\u0131n\u0131ra 25 metrede | \n", "\\nSuriye\u2019de\u00a0Halep\u2019e ba\u011fl\u0131 Kobani\u2019de (Ayn el Ar... | \n", "
9069 | \n", "2014-12-04 | \n", "ABD B\u00fcy\u00fckel\u00e7ili\u011fi\u2019nden Gaziantep\u2019te sald\u0131r\u0131 uy... | \n", "\\nABD Ankara B\u00fcy\u00fckel\u00e7ili\u011fi, radikal gruplar\u0131n ... | \n", "
8857 | \n", "2014-12-04 | \n", "\u201cAK Saray\u201d i\u00e7in a\u00e7\u0131lan davada Atat\u00fcrk\u2019\u00fcn vasiy... | \n", "\\nAralar\u0131nda Mimarlar Odas\u0131\u2019n\u0131n da bulundu\u011fu m... | \n", "
8960 | \n", "2014-12-04 | \n", "\u015ei\u015fli Belediyesi\u2019nde \u0130n\u00f6n\u00fc-Sar\u0131g\u00fcl gerilimi | \n", "\\n\u015ei\u015fli Belediye Ba\u015fkan\u0131 Hayri \u0130n\u00f6n\u00fc, Ba\u015fkan Y... | \n", "
9068 | \n", "2014-12-04 | \n", "ABD askerlerinin ba\u015f\u0131na \u00e7uval ge\u00e7irenlere 10 y... | \n", "\\n\u0130stanbul Emin\u00f6n\u00fc semtinde iki ABD askerinin ... | \n", "
8656 | \n", "2014-12-05 | \n", "T\u00fcrkiye\u2019nin ilk K\u00fclt\u00fcr Bakan\u0131 Halman vefat etti | \n", "\\nT\u00fcrkiye\u2019nin ilk K\u00fclt\u00fcr Bakan\u0131 ve Bilkent \u00dcni... | \n", "
8747 | \n", "2014-12-05 | \n", "Tatl\u0131ses: \u201cSaray milletin; bunu g\u00f6remediniz\u201d | \n", "\\nCumhurba\u015fkanl\u0131\u011f\u0131 Saray\u0131 ile ilgili tart\u0131\u015fmal... | \n", "
8579 | \n", "2014-12-06 | \n", "Cumhurba\u015fkan\u0131: \u201cPolis kendisini savunmayacak m\u0131?\u201d | \n", "\\nCumhurba\u015fkan\u0131 Erdo\u011fan, ABD\u2019de son d\u00f6nemde ta... | \n", "
8486 | \n", "2014-12-07 | \n", "Russell Crowe: \u201cAvustralya\u2019y\u0131 M\u00fcsl\u00fcmanlar ke\u015ff... | \n", "\\nHollywood\u2019un \u00fcnl\u00fc akt\u00f6rlerinden Russell Crow... | \n", "
7182 | \n", "2014-12-12 | \n", "Dolar iki ay\u0131n zirvesinde; 2.30 TL\u2019yi ge\u00e7ti | \n", "\\nDolar, iki ay\u0131n ard\u0131ndan yeniden 2.30 TL sev... | \n", "
7069 | \n", "2014-12-13 | \n", "\u201cABD\u2019li Ba\u015fkonsolos, T\u00fcrk genciyle evleniyor\u201d ... | \n", "\\nABD\u2019nin \u0130stanbul Ba\u015fkonsolosu Charles F. Hun... | \n", "
6862 | \n", "2014-12-14 | \n", "CHP\u2019li Haluk Ko\u00e7\u2019tan yeni \u201ctorpil\u201d listesi | \n", "\\nHaberListe\\n\\nCHP Genel Ba\u015fkan Yard\u0131mc\u0131s\u0131 ve... | \n", "
6570 | \n", "2014-12-15 | \n", "Dolarda tarihi rekor; 2.40 TL\u2019ye dayand\u0131 | \n", "\\n16-17 Aral\u0131k\u2019ta ger\u00e7ekle\u015fecek Amerikan Merke... | \n", "
6203 | \n", "2014-12-16 | \n", "\u201cDigit\u00fcrk Katar \u015feyhine sat\u0131ld\u0131\u201d iddias\u0131 | \n", "\\nY\u00fczde 53\u2032\u00fc ABD\u2019li Providence fonuna, y\u00fczde 4... | \n", "
6095 | \n", "2014-12-17 | \n", "Erdo\u011fan\u2019dan G\u00fclen\u2019e: \u201cElini kolunu ba\u011flayan yo... | \n", "\\nHaberA\u00e7\u0131klamadan sat\u0131rba\u015flar\u0131\\nKonya-\u0130stanbu... | \n", "
5908 | \n", "2014-12-18 | \n", "Nazl\u0131 \u0130n\u00f6n\u00fc su\u00e7lad\u0131; Sar\u0131g\u00fcl yalanlad\u0131 | \n", "\\n\u0130stanbul\u2019da CHP\u2019li \u015ei\u015fli Belediyesi\u2019nde ya\u015fa... | \n", "
5408 | \n", "2014-12-19 | \n", "Fuat Avni ile G\u00fclerce yeniden kar\u015f\u0131 kar\u015f\u0131ya | \n", "\\nHaberFuat Avni'nin payla\u015f\u0131mlar\u0131G\u00fclerce'nin y... | \n", "
5411 | \n", "2014-12-19 | \n", "Fethullah G\u00fclen hakk\u0131nda yakalama talebi | \n", "\\n14 Aral\u0131k soru\u015fturmas\u0131 kapsam\u0131nda\u00a0Fethullah ... | \n", "
5122 | \n", "2014-12-22 | \n", "Bula\u00e7 Dilipak\u2019\u0131 do\u011frulad\u0131: \u201cAK Parti bir Ameri... | \n", "\\nHaber\u0130ddia ve Dilipak'\u0131n yan\u0131t\u0131\\n\\nZaman gaz... | \n", "
4715 | \n", "2014-12-23 | \n", "Rekt\u00f6r: \u201cTayt ya da mini etekle \u00fcniversiteye g... | \n", "\\n\u0130stanbul Ayd\u0131n \u00dcniversitesi Rekt\u00f6r\u00fc Prof. Dr... | \n", "
4010 | \n", "2014-12-26 | \n", "Davuto\u011flu: \u201c\u2018D\u00f6nemin ba\u015fbakan\u0131\u2019 dedikleri ki\u015fi\u2026\u201d | \n", "\\nBa\u015fbakan Ahmet Davuto\u011flu, ATV ve A Haber kan... | \n", "
3818 | \n", "2014-12-27 | \n", "B\u00fclent Ar\u0131n\u00e7: \u201cArkadan vurulduk\u201d | \n", "\\nH\u00fck\u00fcmet S\u00f6zc\u00fcs\u00fc ve Ba\u015fbakan Yard\u0131mc\u0131s\u0131 B\u00fclen... | \n", "
3521 | \n", "2014-12-29 | \n", "T\u00fcrk ekonomisi iki basamak geriledi | \n", "\\nUluslararas\u0131 ara\u015ft\u0131rma \u015firketi \u0130ngiliz Ekono... | \n", "
3624 | \n", "2014-12-29 | \n", "G\u00fclen\u2019in pasaportunun iptaline Dan\u0131\u015ftay vizesi | \n", "\\nHaber\u015eimdi ne olacak?\\n\\nDan\u0131\u015ftay 10\u2032uncu Da... | \n", "
3062 | \n", "2014-12-31 | \n", "T\u00fcrkiye\u2019de 2014 b\u00f6yle ge\u00e7ti | \n", "\\nHaberAy ay 2014'\u00fcn g\u00f6r\u00fcn\u00fcm\u00fc\\n\\nT\u00fcrkiye harek... | \n", "
2488 | \n", "2015-01-02 | \n", "MEB\u2019den yeni \u201cde\u011ferler e\u011fitimi\u201d | \n", "\\nHaberKitap\u00e7\u0131ktan b\u00f6l\u00fcmler\\nMilli E\u011fitim Baka... | \n", "
2486 | \n", "2015-01-03 | \n", "Dumanl\u0131\u2019dan ABD bas\u0131n\u0131nda a\u011f\u0131r Erdo\u011fan ele\u015ftirisi | \n", "\\nZaman gazetesi Genel Yay\u0131n Y\u00f6netmeni\u00a0Ekrem D... | \n", "
2273 | \n", "2015-01-04 | \n", "Tatl\u0131ses milletvekili adayl\u0131\u011f\u0131n\u0131 duyurdu | \n", "\\n\u00dcnl\u00fc t\u00fcrk\u00fcc\u00fc \u0130brahim Tatl\u0131ses, 2015 se\u00e7imler... | \n", "
1094 | \n", "2015-01-07 | \n", "\u00d6DP lideri Ta\u015f: \u201cT\u00fcrkiye\u2019de \u2018devrimci ilahiyat... | \n", "\\nH\u00fcrriyet gazetesinde Ahmet Hakan\u2019\u0131n bu hafta... | \n", "
176 | \n", "2015-01-08 | \n", "Kadri G\u00fcrsel: \u201cFransa\u2019n\u0131n Mad\u0131mak\u2019\u0131\u201d | \n", "\\nMilliyet gazetesi yazar\u0131 Kadri G\u00fcrsel,\u00a0Frans... | \n", "
585 rows \u00d7 3 columns
\n", "