Importing of different Modules

import json
import mwapi
import pandas as pd
import seaborn as sns
import matplotlib as plt
session = mwapi.Session(host='https://en.wikipedia.org',
                        user_agent='Miriiyala Pujitha Jaji')


parameters = {'action':'query',
              'format':'json',
              'list':'cxpublishedtranslations',
              'from':'en',
              'to':'hi',
              'limit':500,
              'offset':200}
res = session.get(parameters)
res['result']['translations'][:5]
[{'translationId': '104628',
  'sourceTitle': 'Jain monasticism',
  'targetTitle': 'जैन मुनि',
  'sourceLanguage': 'en',
  'sourceRevisionId': '697821792',
  'targetRevisionId': '2995713',
  'targetLanguage': 'hi',
  'sourceURL': '//en.wikipedia.org/wiki/Jain monasticism',
  'targetURL': '//hi.wikipedia.org/wiki/जैन मुनि',
  'publishedDate': '20160110184902',
  'stats': {'any': 0.19009086688333,
   'human': 0.061219075412881,
   'mt': 0.12887179147045,
   'mtSectionsCount': 8}},
 {'translationId': '105194',
  'sourceTitle': 'Wikipedia:WikiProject Medicine/Translation task force/RTT/Simple measles vaccine',
  'targetTitle': 'खसरे का टीका(वैक्सीन)',
  'sourceLanguage': 'en',
  'sourceRevisionId': '653739996',
  'targetRevisionId': '2996646',
  'targetLanguage': 'hi',
  'sourceURL': '//en.wikipedia.org/wiki/Wikipedia:WikiProject Medicine/Translation task force/RTT/Simple measles vaccine',
  'targetURL': '//hi.wikipedia.org/wiki/खसरे का टीका(वैक्सीन)',
  'publishedDate': '20160112155454',
  'stats': {'any': 1.0132774283718,
   'human': 0.77917540181691,
   'mt': 0.23410202655486,
   'mtSectionsCount': 1}},
 {'translationId': '105305',
  'sourceTitle': 'List of earthquakes in 2016',
  'targetTitle': '2016 आए में भूकम्पों की सूची',
  'sourceLanguage': 'en',
  'sourceRevisionId': '699475804',
  'targetRevisionId': '2996667',
  'targetLanguage': 'hi',
  'sourceURL': '//en.wikipedia.org/wiki/List of earthquakes in 2016',
  'targetURL': '//hi.wikipedia.org/wiki/2016 आए में भूकम्पों की सूची',
  'publishedDate': '20160112165117',
  'stats': {'any': 0.98091603053435,
   'human': 0.36641221374046,
   'mt': 0.61450381679389,
   'mtSectionsCount': 4}},
 {'translationId': '105719',
  'sourceTitle': 'Nimr al-Nimr',
  'targetTitle': 'निम्र अल-निम्र',
  'sourceLanguage': 'en',
  'sourceRevisionId': '699462541',
  'targetRevisionId': '2997383',
  'targetLanguage': 'hi',
  'sourceURL': '//en.wikipedia.org/wiki/Nimr al-Nimr',
  'targetURL': '//hi.wikipedia.org/wiki/निम्र अल-निम्र',
  'publishedDate': '20160113191205',
  'stats': {'any': 0.34254974984012,
   'human': 0.035398562991385,
   'mt': 0.30715118684874,
   'mtSectionsCount': 1}},
 {'translationId': '106456',
  'sourceTitle': 'J. F. R. Jacob',
  'targetTitle': 'जे॰एफ॰आर॰ जैकब',
  'sourceLanguage': 'en',
  'sourceRevisionId': '699970333',
  'targetRevisionId': '2999440',
  'targetLanguage': 'hi',
  'sourceURL': '//en.wikipedia.org/wiki/J. F. R. Jacob',
  'targetURL': '//hi.wikipedia.org/wiki/जे॰एफ॰आर॰ जैकब',
  'publishedDate': '20160115180314',
  'stats': {'any': 0.15827460303982,
   'human': 0.02241657467946,
   'mt': 0.13585802836036,
   'mtSectionsCount': 1}}]
df = pd.DataFrame(res['result']['translations'])
Data.head(10)
publishedDate sourceLanguage sourceRevisionId sourceTitle sourceURL stats targetLanguage targetRevisionId targetTitle targetURL translationId
0 20160110184902 en 697821792 Jain monasticism //en.wikipedia.org/wiki/Jain monasticism {'any': 0.19009086688333, 'human': 0.061219075... hi 2995713 जैन मुनि //hi.wikipedia.org/wiki/जैन मुनि 104628
1 20160112155454 en 653739996 Wikipedia:WikiProject Medicine/Translation tas... //en.wikipedia.org/wiki/Wikipedia:WikiProject ... {'any': 1.0132774283718, 'human': 0.7791754018... hi 2996646 खसरे का टीका(वैक्सीन) //hi.wikipedia.org/wiki/खसरे का टीका(वैक्सीन) 105194
2 20160112165117 en 699475804 List of earthquakes in 2016 //en.wikipedia.org/wiki/List of earthquakes in... {'any': 0.98091603053435, 'human': 0.366412213... hi 2996667 2016 आए में भूकम्पों की सूची //hi.wikipedia.org/wiki/2016 आए में भूकम्पों क... 105305
3 20160113191205 en 699462541 Nimr al-Nimr //en.wikipedia.org/wiki/Nimr al-Nimr {'any': 0.34254974984012, 'human': 0.035398562... hi 2997383 निम्र अल-निम्र //hi.wikipedia.org/wiki/निम्र अल-निम्र 105719
4 20160115180314 en 699970333 J. F. R. Jacob //en.wikipedia.org/wiki/J. F. R. Jacob {'any': 0.15827460303982, 'human': 0.022416574... hi 2999440 जे॰एफ॰आर॰ जैकब //hi.wikipedia.org/wiki/जे॰एफ॰आर॰ जैकब 106456
5 20160117000107 en 699007501 Toplessness //en.wikipedia.org/wiki/Toplessness {'any': 0.26409060042496, 'human': 0.052112768... hi 3000442 धड़ निरावरण //hi.wikipedia.org/wiki/धड़ निरावरण 106992
6 20160117035201 en 648100317 Tripurantaka Temple //en.wikipedia.org/wiki/Tripurantaka Temple {'any': 0.3125, 'human': 0.21912955465587, 'mt... hi 3000482 त्रिपुरान्तकेश्वर मन्दिर //hi.wikipedia.org/wiki/त्रिपुरान्तकेश्वर मन्दिर 107061
7 20160117053801 en 700083932 Bandha (Jainism) //en.wikipedia.org/wiki/Bandha (Jainism) {'any': 0.77460901563937, 'human': 0.374425022... hi 3000535 कर्म बन्ध //hi.wikipedia.org/wiki/कर्म बन्ध 107075
8 20160117062624 en 642055132 Samvara //en.wikipedia.org/wiki/Samvara {'any': 0.54980392156863, 'human': 0.273333333... hi 3000562 संवर //hi.wikipedia.org/wiki/संवर 107084
9 20160117091641 en 683049890 Ajiva //en.wikipedia.org/wiki/Ajiva {'any': 0.25737100737101, 'human': 0.136773136... hi 3000672 अजीव //hi.wikipedia.org/wiki/अजीव 107150
df.describe
<bound method NDFrame.describe of       publishedDate sourceLanguage sourceRevisionId  \
0    20160110184902             en        697821792   
1    20160112155454             en        653739996   
2    20160112165117             en        699475804   
3    20160113191205             en        699462541   
4    20160115180314             en        699970333   
5    20160117000107             en        699007501   
6    20160117035201             en        648100317   
7    20160117053801             en        700083932   
8    20160117062624             en        642055132   
9    20160117091641             en        683049890   
10   20160302105005             en        651727167   
11   20160118162934             en        700452418   
12   20160119052347             en        698692197   
13   20160119203556             en        700563075   
14   20160119210752             en        700653458   
15   20160119211557             en        700433361   
16   20160119212800             en        700553927   
17   20160123051543             en        701210750   
18   20160124144847             en        700007048   
19   20160125122522             en        691840925   
20   20160129075720             en        686405762   
21   20160129092957             en        701542586   
22   20160130120948             en        701769199   
23   20160201105208             en        702481836   
24   20160203171556             en        703056218   
25   20160203182344             en        699824456   
26   20160206133411             en        700382513   
27   20160303181122             en        667034917   
28   20160422143001             en        709838647   
29   20160217110756             en        703790551   
..              ...            ...              ...   
470  20170228033254             en        764800901   
471  20170228080329             en        740795240   
472  20170301013845             en        766738836   
473  20170301231845             en        745785994   
474  20170302094529             en        751788693   
475  20170303074157             en        755920184   
476  20170304095351             en        768068815   
477  20170327182057             en        767369616   
478  20170305020625             en        766539991   
479  20170915114113             en        766496971   
480  20170305074816             en        767919066   
481  20170306045612             en        763565815   
482  20170306152056             en        718853071   
483  20170307031902             en        766399276   
484  20170308091721             en        755906403   
485  20170308093129             en        767609558   
486  20170309060458             en        747340317   
487  20170309072901             en        769102307   
488  20170309092154             en        761814255   
489  20170309092947             en        764076001   
490  20170309114501             en        765962475   
491  20170310110148             en        767320504   
492  20170310090825             en        758566270   
493  20170310105802             en        769532007   
494  20170310100413             en        748600451   
495  20170311134650             en        762351636   
496  20170311191205             en        753576350   
497  20170311171821             en        767197890   
498  20170312023934             en        759015048   
499  20170312052134             en        769885873   

                                           sourceTitle  \
0                                     Jain monasticism   
1    Wikipedia:WikiProject Medicine/Translation tas...   
2                          List of earthquakes in 2016   
3                                         Nimr al-Nimr   
4                                       J. F. R. Jacob   
5                                          Toplessness   
6                                  Tripurantaka Temple   
7                                     Bandha (Jainism)   
8                                              Samvara   
9                                                Ajiva   
10   Wikipedia:WikiProject Medicine/Translation tas...   
11                                             Nirjara   
12                                        Bajna, India   
13                                         V. Rama Rao   
14                                          Glenn Frey   
15                                  Lars Roar Langslet   
16                                      Armando Loaiza   
17                                      Jasprit Bumrah   
18                                   Stereolithography   
19                                  Gangapur, Varanasi   
20                                   Inkjet solar cell   
21                                        Ahinsa Sthal   
22                                          Avesh Khan   
23                                     Tablighi Jamaat   
24                                          Abu Hanifa   
25                              Ford Model A (1927–31)   
26                                            Tirumala   
27                                       The Asian Age   
28                         Capital punishment in India   
29                                         Jai Gurudev   
..                                                 ...   
470                               Deenanath Mangeshkar   
471                                 Jitendra Abhisheki   
472                                     Malini Awasthi   
473                                       Rasoolan Bai   
474                                       Basanti Devi   
475                                       Shonali Bose   
476                                             Sappho   
477                                    Cri-Zelda Brits   
478                                      Meera Kosambi   
479                           Wikipedia:Creating a bot   
480                                European Parliament   
481                                       Nithya Menen   
482                                             Khumbu   
483                                      Ishita Katyal   
484                                      Sakuntla Devi   
485                                          Apoptosis   
486                                      N. Valarmathi   
487                                        Laura Bates   
488                                   Avani Chaturvedi   
489                                         Aditi Pant   
490                                     Mie Prefecture   
491                                         Rubina Ali   
492                                      Fatima Sheikh   
493                     Kanchan Chaudhary Bhattacharya   
494                                       Manju Bansal   
495                                  Navjot Kaur Sidhu   
496                         Priyambada Mohanty Hejmadi   
497                                     Pushpalata Das   
498                                    Geeta Mukherjee   
499                                  Chandrai (Barmer)   

                                             sourceURL  \
0             //en.wikipedia.org/wiki/Jain monasticism   
1    //en.wikipedia.org/wiki/Wikipedia:WikiProject ...   
2    //en.wikipedia.org/wiki/List of earthquakes in...   
3                 //en.wikipedia.org/wiki/Nimr al-Nimr   
4               //en.wikipedia.org/wiki/J. F. R. Jacob   
5                  //en.wikipedia.org/wiki/Toplessness   
6          //en.wikipedia.org/wiki/Tripurantaka Temple   
7             //en.wikipedia.org/wiki/Bandha (Jainism)   
8                      //en.wikipedia.org/wiki/Samvara   
9                        //en.wikipedia.org/wiki/Ajiva   
10   //en.wikipedia.org/wiki/Wikipedia:WikiProject ...   
11                     //en.wikipedia.org/wiki/Nirjara   
12                //en.wikipedia.org/wiki/Bajna, India   
13                 //en.wikipedia.org/wiki/V. Rama Rao   
14                  //en.wikipedia.org/wiki/Glenn Frey   
15          //en.wikipedia.org/wiki/Lars Roar Langslet   
16              //en.wikipedia.org/wiki/Armando Loaiza   
17              //en.wikipedia.org/wiki/Jasprit Bumrah   
18           //en.wikipedia.org/wiki/Stereolithography   
19          //en.wikipedia.org/wiki/Gangapur, Varanasi   
20           //en.wikipedia.org/wiki/Inkjet solar cell   
21                //en.wikipedia.org/wiki/Ahinsa Sthal   
22                  //en.wikipedia.org/wiki/Avesh Khan   
23             //en.wikipedia.org/wiki/Tablighi Jamaat   
24                  //en.wikipedia.org/wiki/Abu Hanifa   
25      //en.wikipedia.org/wiki/Ford Model A (1927–31)   
26                    //en.wikipedia.org/wiki/Tirumala   
27               //en.wikipedia.org/wiki/The Asian Age   
28   //en.wikipedia.org/wiki/Capital punishment in ...   
29                 //en.wikipedia.org/wiki/Jai Gurudev   
..                                                 ...   
470       //en.wikipedia.org/wiki/Deenanath Mangeshkar   
471         //en.wikipedia.org/wiki/Jitendra Abhisheki   
472             //en.wikipedia.org/wiki/Malini Awasthi   
473               //en.wikipedia.org/wiki/Rasoolan Bai   
474               //en.wikipedia.org/wiki/Basanti Devi   
475               //en.wikipedia.org/wiki/Shonali Bose   
476                     //en.wikipedia.org/wiki/Sappho   
477            //en.wikipedia.org/wiki/Cri-Zelda Brits   
478              //en.wikipedia.org/wiki/Meera Kosambi   
479   //en.wikipedia.org/wiki/Wikipedia:Creating a bot   
480        //en.wikipedia.org/wiki/European Parliament   
481               //en.wikipedia.org/wiki/Nithya Menen   
482                     //en.wikipedia.org/wiki/Khumbu   
483              //en.wikipedia.org/wiki/Ishita Katyal   
484              //en.wikipedia.org/wiki/Sakuntla Devi   
485                  //en.wikipedia.org/wiki/Apoptosis   
486              //en.wikipedia.org/wiki/N. Valarmathi   
487                //en.wikipedia.org/wiki/Laura Bates   
488           //en.wikipedia.org/wiki/Avani Chaturvedi   
489                 //en.wikipedia.org/wiki/Aditi Pant   
490             //en.wikipedia.org/wiki/Mie Prefecture   
491                 //en.wikipedia.org/wiki/Rubina Ali   
492              //en.wikipedia.org/wiki/Fatima Sheikh   
493  //en.wikipedia.org/wiki/Kanchan Chaudhary Bhat...   
494               //en.wikipedia.org/wiki/Manju Bansal   
495          //en.wikipedia.org/wiki/Navjot Kaur Sidhu   
496  //en.wikipedia.org/wiki/Priyambada Mohanty Hej...   
497             //en.wikipedia.org/wiki/Pushpalata Das   
498            //en.wikipedia.org/wiki/Geeta Mukherjee   
499          //en.wikipedia.org/wiki/Chandrai (Barmer)   

                                                 stats targetLanguage  \
0    {'any': 0.19009086688333, 'human': 0.061219075...             hi   
1    {'any': 1.0132774283718, 'human': 0.7791754018...             hi   
2    {'any': 0.98091603053435, 'human': 0.366412213...             hi   
3    {'any': 0.34254974984012, 'human': 0.035398562...             hi   
4    {'any': 0.15827460303982, 'human': 0.022416574...             hi   
5    {'any': 0.26409060042496, 'human': 0.052112768...             hi   
6    {'any': 0.3125, 'human': 0.21912955465587, 'mt...             hi   
7    {'any': 0.77460901563937, 'human': 0.374425022...             hi   
8    {'any': 0.54980392156863, 'human': 0.273333333...             hi   
9    {'any': 0.25737100737101, 'human': 0.136773136...             hi   
10   {'any': 0.99924442765395, 'human': 0.787306384...             hi   
11   {'any': 0.25880955523294, 'human': 0.136201662...             hi   
12   {'any': 0.95201827875095, 'human': 0.731911652...             hi   
13   {'any': 0.39990859232176, 'human': 0.351919561...             hi   
14   {'any': 0.28379880505766, 'human': 0.052660830...             hi   
15   {'any': 0.61561264822134, 'human': 0.347826086...             hi   
16   {'any': 0.60969387755102, 'human': 0.354591836...             hi   
17   {'any': 0.83720930232558, 'human': 0.565891472...             hi   
18   {'any': 1.0277041676704, 'human': 0.8240183088...             hi   
19   {'any': 0.97165991902834, 'human': 0.701754385...             hi   
20   {'any': 0.99670588235294, 'human': 0.644549019...             hi   
21   {'any': 0.69593147751606, 'human': 0.357601713...             hi   
22   {'any': 0.74418604651163, 'human': 0.368217054...             hi   
23   {'any': 0.2015784126084, 'human': 0.0196828997...             hi   
24   {'any': 0.63818683366883, 'human': 0.193170804...             hi   
25   {'any': 0.20954881369117, 'human': 0.084208479...             hi   
26   {'any': 0.22934472934473, 'human': 0.053520553...             hi   
27   {'any': 0.79222720478326, 'human': 0.733931240...             hi   
28   {'any': 0.45599399019453, 'human': 0.197690969...             hi   
29   {'any': 0.11626934337097, 'human': 0.116269343...             hi   
..                                                 ...            ...   
470  {'any': 0.88469046291132, 'human': 0.062465142...             hi   
471  {'any': 0.93331175137585, 'human': 0, 'mt': 0....             hi   
472  {'any': 0.69070996978852, 'human': 0.650679758...             hi   
473  {'any': 0.19989121566494, 'human': 0.161272776...             hi   
474  {'any': 0.12515114873035, 'human': 0.061870213...             hi   
475  {'any': 0.3352559480894, 'human': 0.3280461427...             hi   
476  {'any': 0.070471770166265, 'human': 0.07020739...             hi   
477  {'any': 0.68596627332489, 'human': 0.252500918...             hi   
478  {'any': 0.46585627457991, 'human': 0.463711119...             hi   
479  {'any': 0.99393810486015, 'human': 0.008401573...             hi   
480  {'any': 0.23406124657796, 'human': 0.233984847...             hi   
481  {'any': 0.67012474541752, 'human': 0.481224541...             hi   
482  {'any': 0.68388106416275, 'human': 0.574856546...             hi   
483  {'any': 1.3586515028432, 'human': 1.3131600324...             hi   
484  {'any': 0.53442399454669, 'human': 0.521245171...             hi   
485  {'any': 0.0075956090651558, 'human': 0.0075956...             hi   
486  {'any': 0.75953079178886, 'human': 0.744281524...             hi   
487  {'any': 0.57786805958599, 'human': 0.500483652...             hi   
488  {'any': 1.3592067988669, 'human': 1.3354107648...             hi   
489  {'any': 0.79337370858568, 'human': 0.780548628...             hi   
490  {'any': 0.37199493884437, 'human': 0.161197806...             hi   
491  {'any': 0.61617572371762, 'human': 0.614398171...             hi   
492  {'any': 1.3326848249027, 'human': 1.3210116731...             hi   
493  {'any': 1.0810064436944, 'human': 1.0699601104...             hi   
494  {'any': 0.9622641509434, 'human': 0.9486616937...             hi   
495  {'any': 1.3700092850511, 'human': 1.3672237697...             hi   
496  {'any': 0.52702702702703, 'human': 0.517872711...             hi   
497  {'any': 0.69502238609429, 'human': 0.693047142...             hi   
498  {'any': 0.56326825741142, 'human': 0.506326825...             hi   
499  {'any': 0.0048426150121065, 'human': 0, 'mt': ...             hi   

    targetRevisionId                                        targetTitle  \
0            2995713                                           जैन मुनि   
1            2996646                              खसरे का टीका(वैक्सीन)   
2            2996667                       2016 आए में भूकम्पों की सूची   
3            2997383                                     निम्र अल-निम्र   
4            2999440                                     जे॰एफ॰आर॰ जैकब   
5            3000442                                        धड़ निरावरण   
6            3000482                           त्रिपुरान्तकेश्वर मन्दिर   
7            3000535                                          कर्म बन्ध   
8            3000562                                               संवर   
9            3000672                                               अजीव   
10           3022867  विकिपीडिया:WikiProject Medicine/Translation ta...   
11           3001522                                            निर्जरा   
12           3001696                                        बाजना, भारत   
13           3002240                                       वी॰ रामा राव   
14           3002246                                         ग्लेन फ्रे   
15           3002248                                लार्स रोर लंग्स्लेट   
16           3002250                                     अरमांडो लोयज़ा   
17           3003675                                     जसप्रीत बुमराह   
18           3004162                                 स्टीरियोलिथोग्राफी   
19           3004600                                   गंगापुर, वाराणसी   
20           3006739                                     इंकजेट सौर सेल   
21           3006772                                        अहिंसा स्थल   
22           3007235                                           अवेश खान   
23           3008148                                      तबलीग़ी जमाअत   
24           3009533                                         अबू हनीफ़ा   
25           3009599                             फोर्ड मॉडल ए (१९२७–३१)   
26           3010861                                            तिरुमला   
27           3023592                                         द एशियन एज   
28           3056460                               भारत में मौत की सज़ा   
29           3016303                                         जय गुरुदेव   
..               ...                                                ...   
470          3402027                                    दीनानाथ मंगेशकर   
471          3402248                                   जीतेंद्र अभिषेकी   
472          3402741                                      मालिनी अवस्थी   
473          3405440                                          रसूलन बाई   
474          3407447                                         बसंती देवी   
475          3409398                                         शोनाली बोस   
476          3410200                                              साफ़ो   
477          3436944                                क्रि-जेल्डा ब्रिट्स   
478          3410663                                      मीरा कोसाम्बी   
479          3410751                  विकिपीडिया:बॉट बनाने की प्रक्रिया   
480          3410842                                       यूरोपीय संसद   
481          3411607                                        नित्या मेनन   
482          3414054                                             खुम्बु   
483          3414461                                        इशिता काताल   
484          3415301                                       शकुंतला देवी   
485          3415307                                         एपोप्टोसिस   
486          3415810                                         ऐन. वलरमठी   
487          3415862                                          लौरा बेटस   
488          3415961                                     अवनि चतुर्वेदी   
489          3415966                                          अदिति पंत   
490          3416083                                     मिऐ प्रीफेक्चर   
491          3416645                                         रुबीना अली   
492          3416528                                       फ़ातिमा शेख़   
493          3416642                             कंचन चौधरी भट्टाचार्या   
494          3416598                                          मंजू बंसल   
495          3417332                                   नवजोत कौर सिद्धु   
496          3417517                           प्रियंवदा मोहंती हेजमादी   
497          3417454                                       पुष्पलता दास   
498          3417638                                       गीता मुखर्जी   
499          3417744                                 चान्दराई (बाड़मेर)   

                                             targetURL translationId  
0                     //hi.wikipedia.org/wiki/जैन मुनि        104628  
1        //hi.wikipedia.org/wiki/खसरे का टीका(वैक्सीन)        105194  
2    //hi.wikipedia.org/wiki/2016 आए में भूकम्पों क...        105305  
3               //hi.wikipedia.org/wiki/निम्र अल-निम्र        105719  
4               //hi.wikipedia.org/wiki/जे॰एफ॰आर॰ जैकब        106456  
5                  //hi.wikipedia.org/wiki/धड़ निरावरण        106992  
6     //hi.wikipedia.org/wiki/त्रिपुरान्तकेश्वर मन्दिर        107061  
7                    //hi.wikipedia.org/wiki/कर्म बन्ध        107075  
8                         //hi.wikipedia.org/wiki/संवर        107084  
9                         //hi.wikipedia.org/wiki/अजीव        107150  
10   //hi.wikipedia.org/wiki/विकिपीडिया:WikiProject...        107233  
11                     //hi.wikipedia.org/wiki/निर्जरा        107678  
12                 //hi.wikipedia.org/wiki/बाजना, भारत        107864  
13                //hi.wikipedia.org/wiki/वी॰ रामा राव        108160  
14                  //hi.wikipedia.org/wiki/ग्लेन फ्रे        108171  
15         //hi.wikipedia.org/wiki/लार्स रोर लंग्स्लेट        108176  
16              //hi.wikipedia.org/wiki/अरमांडो लोयज़ा        108180  
17              //hi.wikipedia.org/wiki/जसप्रीत बुमराह        109364  
18          //hi.wikipedia.org/wiki/स्टीरियोलिथोग्राफी        109849  
19            //hi.wikipedia.org/wiki/गंगापुर, वाराणसी        110222  
20              //hi.wikipedia.org/wiki/इंकजेट सौर सेल        111002  
21                 //hi.wikipedia.org/wiki/अहिंसा स्थल        111446  
22                    //hi.wikipedia.org/wiki/अवेश खान        111872  
23               //hi.wikipedia.org/wiki/तबलीग़ी जमाअत        112781  
24                  //hi.wikipedia.org/wiki/अबू हनीफ़ा        113629  
25      //hi.wikipedia.org/wiki/फोर्ड मॉडल ए (१९२७–३१)        113654  
26                     //hi.wikipedia.org/wiki/तिरुमला        114651  
27                  //hi.wikipedia.org/wiki/द एशियन एज        114917  
28        //hi.wikipedia.org/wiki/भारत में मौत की सज़ा        118018  
29                  //hi.wikipedia.org/wiki/जय गुरुदेव        118170  
..                                                 ...           ...  
470            //hi.wikipedia.org/wiki/दीनानाथ मंगेशकर        282721  
471           //hi.wikipedia.org/wiki/जीतेंद्र अभिषेकी        282777  
472              //hi.wikipedia.org/wiki/मालिनी अवस्थी        283155  
473                  //hi.wikipedia.org/wiki/रसूलन बाई        283525  
474                 //hi.wikipedia.org/wiki/बसंती देवी        283765  
475                 //hi.wikipedia.org/wiki/शोनाली बोस        284177  
476                      //hi.wikipedia.org/wiki/साफ़ो        284615  
477        //hi.wikipedia.org/wiki/क्रि-जेल्डा ब्रिट्स        284666  
478              //hi.wikipedia.org/wiki/मीरा कोसाम्बी        285138  
479  //hi.wikipedia.org/wiki/विकिपीडिया:बॉट बनाने क...        285196  
480               //hi.wikipedia.org/wiki/यूरोपीय संसद        285246  
481                //hi.wikipedia.org/wiki/नित्या मेनन        285687  
482                     //hi.wikipedia.org/wiki/खुम्बु        285786  
483                //hi.wikipedia.org/wiki/इशिता काताल        286166  
484               //hi.wikipedia.org/wiki/शकुंतला देवी        286698  
485                 //hi.wikipedia.org/wiki/एपोप्टोसिस        286720  
486                 //hi.wikipedia.org/wiki/ऐन. वलरमठी        287181  
487                  //hi.wikipedia.org/wiki/लौरा बेटस        287186  
488             //hi.wikipedia.org/wiki/अवनि चतुर्वेदी        287205  
489                  //hi.wikipedia.org/wiki/अदिति पंत        287215  
490             //hi.wikipedia.org/wiki/मिऐ प्रीफेक्चर        287250  
491                 //hi.wikipedia.org/wiki/रुबीना अली        287589  
492               //hi.wikipedia.org/wiki/फ़ातिमा शेख़        287664  
493     //hi.wikipedia.org/wiki/कंचन चौधरी भट्टाचार्या        287671  
494                  //hi.wikipedia.org/wiki/मंजू बंसल        287675  
495           //hi.wikipedia.org/wiki/नवजोत कौर सिद्धु        288277  
496   //hi.wikipedia.org/wiki/प्रियंवदा मोहंती हेजमादी        288315  
497               //hi.wikipedia.org/wiki/पुष्पलता दास        288360  
498               //hi.wikipedia.org/wiki/गीता मुखर्जी        288583  
499         //hi.wikipedia.org/wiki/चान्दराई (बाड़मेर)        288639  

[500 rows x 11 columns]>
Data.describe
<bound method NDFrame.describe of       publishedDate sourceLanguage sourceRevisionId  \
0    20160110184902             en        697821792   
1    20160112155454             en        653739996   
2    20160112165117             en        699475804   
3    20160113191205             en        699462541   
4    20160115180314             en        699970333   
5    20160117000107             en        699007501   
6    20160117035201             en        648100317   
7    20160117053801             en        700083932   
8    20160117062624             en        642055132   
9    20160117091641             en        683049890   
10   20160302105005             en        651727167   
11   20160118162934             en        700452418   
12   20160119052347             en        698692197   
13   20160119203556             en        700563075   
14   20160119210752             en        700653458   
15   20160119211557             en        700433361   
16   20160119212800             en        700553927   
17   20160123051543             en        701210750   
18   20160124144847             en        700007048   
19   20160125122522             en        691840925   
20   20160129075720             en        686405762   
21   20160129092957             en        701542586   
22   20160130120948             en        701769199   
23   20160201105208             en        702481836   
24   20160203171556             en        703056218   
25   20160203182344             en        699824456   
26   20160206133411             en        700382513   
27   20160303181122             en        667034917   
28   20160422143001             en        709838647   
29   20160217110756             en        703790551   
..              ...            ...              ...   
470  20170228033254             en        764800901   
471  20170228080329             en        740795240   
472  20170301013845             en        766738836   
473  20170301231845             en        745785994   
474  20170302094529             en        751788693   
475  20170303074157             en        755920184   
476  20170304095351             en        768068815   
477  20170327182057             en        767369616   
478  20170305020625             en        766539991   
479  20170915114113             en        766496971   
480  20170305074816             en        767919066   
481  20170306045612             en        763565815   
482  20170306152056             en        718853071   
483  20170307031902             en        766399276   
484  20170308091721             en        755906403   
485  20170308093129             en        767609558   
486  20170309060458             en        747340317   
487  20170309072901             en        769102307   
488  20170309092154             en        761814255   
489  20170309092947             en        764076001   
490  20170309114501             en        765962475   
491  20170310110148             en        767320504   
492  20170310090825             en        758566270   
493  20170310105802             en        769532007   
494  20170310100413             en        748600451   
495  20170311134650             en        762351636   
496  20170311191205             en        753576350   
497  20170311171821             en        767197890   
498  20170312023934             en        759015048   
499  20170312052134             en        769885873   

                                           sourceTitle  \
0                                     Jain monasticism   
1    Wikipedia:WikiProject Medicine/Translation tas...   
2                          List of earthquakes in 2016   
3                                         Nimr al-Nimr   
4                                       J. F. R. Jacob   
5                                          Toplessness   
6                                  Tripurantaka Temple   
7                                     Bandha (Jainism)   
8                                              Samvara   
9                                                Ajiva   
10   Wikipedia:WikiProject Medicine/Translation tas...   
11                                             Nirjara   
12                                        Bajna, India   
13                                         V. Rama Rao   
14                                          Glenn Frey   
15                                  Lars Roar Langslet   
16                                      Armando Loaiza   
17                                      Jasprit Bumrah   
18                                   Stereolithography   
19                                  Gangapur, Varanasi   
20                                   Inkjet solar cell   
21                                        Ahinsa Sthal   
22                                          Avesh Khan   
23                                     Tablighi Jamaat   
24                                          Abu Hanifa   
25                              Ford Model A (1927–31)   
26                                            Tirumala   
27                                       The Asian Age   
28                         Capital punishment in India   
29                                         Jai Gurudev   
..                                                 ...   
470                               Deenanath Mangeshkar   
471                                 Jitendra Abhisheki   
472                                     Malini Awasthi   
473                                       Rasoolan Bai   
474                                       Basanti Devi   
475                                       Shonali Bose   
476                                             Sappho   
477                                    Cri-Zelda Brits   
478                                      Meera Kosambi   
479                           Wikipedia:Creating a bot   
480                                European Parliament   
481                                       Nithya Menen   
482                                             Khumbu   
483                                      Ishita Katyal   
484                                      Sakuntla Devi   
485                                          Apoptosis   
486                                      N. Valarmathi   
487                                        Laura Bates   
488                                   Avani Chaturvedi   
489                                         Aditi Pant   
490                                     Mie Prefecture   
491                                         Rubina Ali   
492                                      Fatima Sheikh   
493                     Kanchan Chaudhary Bhattacharya   
494                                       Manju Bansal   
495                                  Navjot Kaur Sidhu   
496                         Priyambada Mohanty Hejmadi   
497                                     Pushpalata Das   
498                                    Geeta Mukherjee   
499                                  Chandrai (Barmer)   

                                             sourceURL  \
0             //en.wikipedia.org/wiki/Jain monasticism   
1    //en.wikipedia.org/wiki/Wikipedia:WikiProject ...   
2    //en.wikipedia.org/wiki/List of earthquakes in...   
3                 //en.wikipedia.org/wiki/Nimr al-Nimr   
4               //en.wikipedia.org/wiki/J. F. R. Jacob   
5                  //en.wikipedia.org/wiki/Toplessness   
6          //en.wikipedia.org/wiki/Tripurantaka Temple   
7             //en.wikipedia.org/wiki/Bandha (Jainism)   
8                      //en.wikipedia.org/wiki/Samvara   
9                        //en.wikipedia.org/wiki/Ajiva   
10   //en.wikipedia.org/wiki/Wikipedia:WikiProject ...   
11                     //en.wikipedia.org/wiki/Nirjara   
12                //en.wikipedia.org/wiki/Bajna, India   
13                 //en.wikipedia.org/wiki/V. Rama Rao   
14                  //en.wikipedia.org/wiki/Glenn Frey   
15          //en.wikipedia.org/wiki/Lars Roar Langslet   
16              //en.wikipedia.org/wiki/Armando Loaiza   
17              //en.wikipedia.org/wiki/Jasprit Bumrah   
18           //en.wikipedia.org/wiki/Stereolithography   
19          //en.wikipedia.org/wiki/Gangapur, Varanasi   
20           //en.wikipedia.org/wiki/Inkjet solar cell   
21                //en.wikipedia.org/wiki/Ahinsa Sthal   
22                  //en.wikipedia.org/wiki/Avesh Khan   
23             //en.wikipedia.org/wiki/Tablighi Jamaat   
24                  //en.wikipedia.org/wiki/Abu Hanifa   
25      //en.wikipedia.org/wiki/Ford Model A (1927–31)   
26                    //en.wikipedia.org/wiki/Tirumala   
27               //en.wikipedia.org/wiki/The Asian Age   
28   //en.wikipedia.org/wiki/Capital punishment in ...   
29                 //en.wikipedia.org/wiki/Jai Gurudev   
..                                                 ...   
470       //en.wikipedia.org/wiki/Deenanath Mangeshkar   
471         //en.wikipedia.org/wiki/Jitendra Abhisheki   
472             //en.wikipedia.org/wiki/Malini Awasthi   
473               //en.wikipedia.org/wiki/Rasoolan Bai   
474               //en.wikipedia.org/wiki/Basanti Devi   
475               //en.wikipedia.org/wiki/Shonali Bose   
476                     //en.wikipedia.org/wiki/Sappho   
477            //en.wikipedia.org/wiki/Cri-Zelda Brits   
478              //en.wikipedia.org/wiki/Meera Kosambi   
479   //en.wikipedia.org/wiki/Wikipedia:Creating a bot   
480        //en.wikipedia.org/wiki/European Parliament   
481               //en.wikipedia.org/wiki/Nithya Menen   
482                     //en.wikipedia.org/wiki/Khumbu   
483              //en.wikipedia.org/wiki/Ishita Katyal   
484              //en.wikipedia.org/wiki/Sakuntla Devi   
485                  //en.wikipedia.org/wiki/Apoptosis   
486              //en.wikipedia.org/wiki/N. Valarmathi   
487                //en.wikipedia.org/wiki/Laura Bates   
488           //en.wikipedia.org/wiki/Avani Chaturvedi   
489                 //en.wikipedia.org/wiki/Aditi Pant   
490             //en.wikipedia.org/wiki/Mie Prefecture   
491                 //en.wikipedia.org/wiki/Rubina Ali   
492              //en.wikipedia.org/wiki/Fatima Sheikh   
493  //en.wikipedia.org/wiki/Kanchan Chaudhary Bhat...   
494               //en.wikipedia.org/wiki/Manju Bansal   
495          //en.wikipedia.org/wiki/Navjot Kaur Sidhu   
496  //en.wikipedia.org/wiki/Priyambada Mohanty Hej...   
497             //en.wikipedia.org/wiki/Pushpalata Das   
498            //en.wikipedia.org/wiki/Geeta Mukherjee   
499          //en.wikipedia.org/wiki/Chandrai (Barmer)   

                                                 stats targetLanguage  \
0    {'any': 0.19009086688333, 'human': 0.061219075...             hi   
1    {'any': 1.0132774283718, 'human': 0.7791754018...             hi   
2    {'any': 0.98091603053435, 'human': 0.366412213...             hi   
3    {'any': 0.34254974984012, 'human': 0.035398562...             hi   
4    {'any': 0.15827460303982, 'human': 0.022416574...             hi   
5    {'any': 0.26409060042496, 'human': 0.052112768...             hi   
6    {'any': 0.3125, 'human': 0.21912955465587, 'mt...             hi   
7    {'any': 0.77460901563937, 'human': 0.374425022...             hi   
8    {'any': 0.54980392156863, 'human': 0.273333333...             hi   
9    {'any': 0.25737100737101, 'human': 0.136773136...             hi   
10   {'any': 0.99924442765395, 'human': 0.787306384...             hi   
11   {'any': 0.25880955523294, 'human': 0.136201662...             hi   
12   {'any': 0.95201827875095, 'human': 0.731911652...             hi   
13   {'any': 0.39990859232176, 'human': 0.351919561...             hi   
14   {'any': 0.28379880505766, 'human': 0.052660830...             hi   
15   {'any': 0.61561264822134, 'human': 0.347826086...             hi   
16   {'any': 0.60969387755102, 'human': 0.354591836...             hi   
17   {'any': 0.83720930232558, 'human': 0.565891472...             hi   
18   {'any': 1.0277041676704, 'human': 0.8240183088...             hi   
19   {'any': 0.97165991902834, 'human': 0.701754385...             hi   
20   {'any': 0.99670588235294, 'human': 0.644549019...             hi   
21   {'any': 0.69593147751606, 'human': 0.357601713...             hi   
22   {'any': 0.74418604651163, 'human': 0.368217054...             hi   
23   {'any': 0.2015784126084, 'human': 0.0196828997...             hi   
24   {'any': 0.63818683366883, 'human': 0.193170804...             hi   
25   {'any': 0.20954881369117, 'human': 0.084208479...             hi   
26   {'any': 0.22934472934473, 'human': 0.053520553...             hi   
27   {'any': 0.79222720478326, 'human': 0.733931240...             hi   
28   {'any': 0.45599399019453, 'human': 0.197690969...             hi   
29   {'any': 0.11626934337097, 'human': 0.116269343...             hi   
..                                                 ...            ...   
470  {'any': 0.88469046291132, 'human': 0.062465142...             hi   
471  {'any': 0.93331175137585, 'human': 0, 'mt': 0....             hi   
472  {'any': 0.69070996978852, 'human': 0.650679758...             hi   
473  {'any': 0.19989121566494, 'human': 0.161272776...             hi   
474  {'any': 0.12515114873035, 'human': 0.061870213...             hi   
475  {'any': 0.3352559480894, 'human': 0.3280461427...             hi   
476  {'any': 0.070471770166265, 'human': 0.07020739...             hi   
477  {'any': 0.68596627332489, 'human': 0.252500918...             hi   
478  {'any': 0.46585627457991, 'human': 0.463711119...             hi   
479  {'any': 0.99393810486015, 'human': 0.008401573...             hi   
480  {'any': 0.23406124657796, 'human': 0.233984847...             hi   
481  {'any': 0.67012474541752, 'human': 0.481224541...             hi   
482  {'any': 0.68388106416275, 'human': 0.574856546...             hi   
483  {'any': 1.3586515028432, 'human': 1.3131600324...             hi   
484  {'any': 0.53442399454669, 'human': 0.521245171...             hi   
485  {'any': 0.0075956090651558, 'human': 0.0075956...             hi   
486  {'any': 0.75953079178886, 'human': 0.744281524...             hi   
487  {'any': 0.57786805958599, 'human': 0.500483652...             hi   
488  {'any': 1.3592067988669, 'human': 1.3354107648...             hi   
489  {'any': 0.79337370858568, 'human': 0.780548628...             hi   
490  {'any': 0.37199493884437, 'human': 0.161197806...             hi   
491  {'any': 0.61617572371762, 'human': 0.614398171...             hi   
492  {'any': 1.3326848249027, 'human': 1.3210116731...             hi   
493  {'any': 1.0810064436944, 'human': 1.0699601104...             hi   
494  {'any': 0.9622641509434, 'human': 0.9486616937...             hi   
495  {'any': 1.3700092850511, 'human': 1.3672237697...             hi   
496  {'any': 0.52702702702703, 'human': 0.517872711...             hi   
497  {'any': 0.69502238609429, 'human': 0.693047142...             hi   
498  {'any': 0.56326825741142, 'human': 0.506326825...             hi   
499  {'any': 0.0048426150121065, 'human': 0, 'mt': ...             hi   

    targetRevisionId                                        targetTitle  \
0            2995713                                           जैन मुनि   
1            2996646                              खसरे का टीका(वैक्सीन)   
2            2996667                       2016 आए में भूकम्पों की सूची   
3            2997383                                     निम्र अल-निम्र   
4            2999440                                     जे॰एफ॰आर॰ जैकब   
5            3000442                                        धड़ निरावरण   
6            3000482                           त्रिपुरान्तकेश्वर मन्दिर   
7            3000535                                          कर्म बन्ध   
8            3000562                                               संवर   
9            3000672                                               अजीव   
10           3022867  विकिपीडिया:WikiProject Medicine/Translation ta...   
11           3001522                                            निर्जरा   
12           3001696                                        बाजना, भारत   
13           3002240                                       वी॰ रामा राव   
14           3002246                                         ग्लेन फ्रे   
15           3002248                                लार्स रोर लंग्स्लेट   
16           3002250                                     अरमांडो लोयज़ा   
17           3003675                                     जसप्रीत बुमराह   
18           3004162                                 स्टीरियोलिथोग्राफी   
19           3004600                                   गंगापुर, वाराणसी   
20           3006739                                     इंकजेट सौर सेल   
21           3006772                                        अहिंसा स्थल   
22           3007235                                           अवेश खान   
23           3008148                                      तबलीग़ी जमाअत   
24           3009533                                         अबू हनीफ़ा   
25           3009599                             फोर्ड मॉडल ए (१९२७–३१)   
26           3010861                                            तिरुमला   
27           3023592                                         द एशियन एज   
28           3056460                               भारत में मौत की सज़ा   
29           3016303                                         जय गुरुदेव   
..               ...                                                ...   
470          3402027                                    दीनानाथ मंगेशकर   
471          3402248                                   जीतेंद्र अभिषेकी   
472          3402741                                      मालिनी अवस्थी   
473          3405440                                          रसूलन बाई   
474          3407447                                         बसंती देवी   
475          3409398                                         शोनाली बोस   
476          3410200                                              साफ़ो   
477          3436944                                क्रि-जेल्डा ब्रिट्स   
478          3410663                                      मीरा कोसाम्बी   
479          3410751                  विकिपीडिया:बॉट बनाने की प्रक्रिया   
480          3410842                                       यूरोपीय संसद   
481          3411607                                        नित्या मेनन   
482          3414054                                             खुम्बु   
483          3414461                                        इशिता काताल   
484          3415301                                       शकुंतला देवी   
485          3415307                                         एपोप्टोसिस   
486          3415810                                         ऐन. वलरमठी   
487          3415862                                          लौरा बेटस   
488          3415961                                     अवनि चतुर्वेदी   
489          3415966                                          अदिति पंत   
490          3416083                                     मिऐ प्रीफेक्चर   
491          3416645                                         रुबीना अली   
492          3416528                                       फ़ातिमा शेख़   
493          3416642                             कंचन चौधरी भट्टाचार्या   
494          3416598                                          मंजू बंसल   
495          3417332                                   नवजोत कौर सिद्धु   
496          3417517                           प्रियंवदा मोहंती हेजमादी   
497          3417454                                       पुष्पलता दास   
498          3417638                                       गीता मुखर्जी   
499          3417744                                 चान्दराई (बाड़मेर)   

                                             targetURL translationId  
0                     //hi.wikipedia.org/wiki/जैन मुनि        104628  
1        //hi.wikipedia.org/wiki/खसरे का टीका(वैक्सीन)        105194  
2    //hi.wikipedia.org/wiki/2016 आए में भूकम्पों क...        105305  
3               //hi.wikipedia.org/wiki/निम्र अल-निम्र        105719  
4               //hi.wikipedia.org/wiki/जे॰एफ॰आर॰ जैकब        106456  
5                  //hi.wikipedia.org/wiki/धड़ निरावरण        106992  
6     //hi.wikipedia.org/wiki/त्रिपुरान्तकेश्वर मन्दिर        107061  
7                    //hi.wikipedia.org/wiki/कर्म बन्ध        107075  
8                         //hi.wikipedia.org/wiki/संवर        107084  
9                         //hi.wikipedia.org/wiki/अजीव        107150  
10   //hi.wikipedia.org/wiki/विकिपीडिया:WikiProject...        107233  
11                     //hi.wikipedia.org/wiki/निर्जरा        107678  
12                 //hi.wikipedia.org/wiki/बाजना, भारत        107864  
13                //hi.wikipedia.org/wiki/वी॰ रामा राव        108160  
14                  //hi.wikipedia.org/wiki/ग्लेन फ्रे        108171  
15         //hi.wikipedia.org/wiki/लार्स रोर लंग्स्लेट        108176  
16              //hi.wikipedia.org/wiki/अरमांडो लोयज़ा        108180  
17              //hi.wikipedia.org/wiki/जसप्रीत बुमराह        109364  
18          //hi.wikipedia.org/wiki/स्टीरियोलिथोग्राफी        109849  
19            //hi.wikipedia.org/wiki/गंगापुर, वाराणसी        110222  
20              //hi.wikipedia.org/wiki/इंकजेट सौर सेल        111002  
21                 //hi.wikipedia.org/wiki/अहिंसा स्थल        111446  
22                    //hi.wikipedia.org/wiki/अवेश खान        111872  
23               //hi.wikipedia.org/wiki/तबलीग़ी जमाअत        112781  
24                  //hi.wikipedia.org/wiki/अबू हनीफ़ा        113629  
25      //hi.wikipedia.org/wiki/फोर्ड मॉडल ए (१९२७–३१)        113654  
26                     //hi.wikipedia.org/wiki/तिरुमला        114651  
27                  //hi.wikipedia.org/wiki/द एशियन एज        114917  
28        //hi.wikipedia.org/wiki/भारत में मौत की सज़ा        118018  
29                  //hi.wikipedia.org/wiki/जय गुरुदेव        118170  
..                                                 ...           ...  
470            //hi.wikipedia.org/wiki/दीनानाथ मंगेशकर        282721  
471           //hi.wikipedia.org/wiki/जीतेंद्र अभिषेकी        282777  
472              //hi.wikipedia.org/wiki/मालिनी अवस्थी        283155  
473                  //hi.wikipedia.org/wiki/रसूलन बाई        283525  
474                 //hi.wikipedia.org/wiki/बसंती देवी        283765  
475                 //hi.wikipedia.org/wiki/शोनाली बोस        284177  
476                      //hi.wikipedia.org/wiki/साफ़ो        284615  
477        //hi.wikipedia.org/wiki/क्रि-जेल्डा ब्रिट्स        284666  
478              //hi.wikipedia.org/wiki/मीरा कोसाम्बी        285138  
479  //hi.wikipedia.org/wiki/विकिपीडिया:बॉट बनाने क...        285196  
480               //hi.wikipedia.org/wiki/यूरोपीय संसद        285246  
481                //hi.wikipedia.org/wiki/नित्या मेनन        285687  
482                     //hi.wikipedia.org/wiki/खुम्बु        285786  
483                //hi.wikipedia.org/wiki/इशिता काताल        286166  
484               //hi.wikipedia.org/wiki/शकुंतला देवी        286698  
485                 //hi.wikipedia.org/wiki/एपोप्टोसिस        286720  
486                 //hi.wikipedia.org/wiki/ऐन. वलरमठी        287181  
487                  //hi.wikipedia.org/wiki/लौरा बेटस        287186  
488             //hi.wikipedia.org/wiki/अवनि चतुर्वेदी        287205  
489                  //hi.wikipedia.org/wiki/अदिति पंत        287215  
490             //hi.wikipedia.org/wiki/मिऐ प्रीफेक्चर        287250  
491                 //hi.wikipedia.org/wiki/रुबीना अली        287589  
492               //hi.wikipedia.org/wiki/फ़ातिमा शेख़        287664  
493     //hi.wikipedia.org/wiki/कंचन चौधरी भट्टाचार्या        287671  
494                  //hi.wikipedia.org/wiki/मंजू बंसल        287675  
495           //hi.wikipedia.org/wiki/नवजोत कौर सिद्धु        288277  
496   //hi.wikipedia.org/wiki/प्रियंवदा मोहंती हेजमादी        288315  
497               //hi.wikipedia.org/wiki/पुष्पलता दास        288360  
498               //hi.wikipedia.org/wiki/गीता मुखर्जी        288583  
499         //hi.wikipedia.org/wiki/चान्दराई (बाड़मेर)        288639  

[500 rows x 11 columns]>
Data.columns
Index(['publishedDate', 'sourceLanguage', 'sourceRevisionId', 'sourceTitle',
       'sourceURL', 'stats', 'targetLanguage', 'targetRevisionId',
       'targetTitle', 'targetURL', 'translationId'],
      dtype='object')
Data.index
RangeIndex(start=0, stop=500, step=1)
Data.shape
(500, 11)
Data.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 500 entries, 0 to 499
Data columns (total 11 columns):
publishedDate       500 non-null object
sourceLanguage      500 non-null object
sourceRevisionId    500 non-null object
sourceTitle         500 non-null object
sourceURL           500 non-null object
stats               500 non-null object
targetLanguage      500 non-null object
targetRevisionId    500 non-null object
targetTitle         500 non-null object
targetURL           500 non-null object
translationId       500 non-null object
dtypes: object(11)
memory usage: 43.0+ KB
Data['sourceURL'].nunique()
500

There are 11 Columns

print(Data['publishedDate'].describe())
count                500
unique               499
top       20170226064641
freq                   2
Name: publishedDate, dtype: object
print(Data['sourceLanguage'].describe())
count     500
unique      1
top        en
freq      500
Name: sourceLanguage, dtype: object
print(Data['sourceRevisionId'].describe())
count           500
unique          500
top       739103720
freq              1
Name: sourceRevisionId, dtype: object
print(Data['sourceTitle'].describe())
count                        500
unique                       500
top       Spider-Man: Homecoming
freq                           1
Name: sourceTitle, dtype: object
print(Data['translationId'].describe())
count        500
unique       500
top       269493
freq           1
Name: translationId, dtype: object
print(Data['targetTitle'].describe())
count            500
unique           500
top       प्रणामसागर
freq               1
Name: targetTitle, dtype: object
print(Data['targetLanguage'].describe())
print(Data['sourceLanguage'].describe())
count     500
unique      1
top        hi
freq      500
Name: targetLanguage, dtype: object
count     500
unique      1
top        en
freq      500
Name: sourceLanguage, dtype: object
Data[Data['sourceTitle'] == 'Gradient boosting']
publishedDate sourceLanguage sourceRevisionId sourceTitle sourceURL stats targetLanguage targetRevisionId targetTitle targetURL translationId
gboost_source_title = Data.loc[10, 'sourceTitle']
gboost_target_title = Data.loc[10, 'targetTitle']
gboost_tid = Data.loc[8,'translationId']
gboost_source_revid = Data.loc[10, 'sourceRevisionId']
print(gboost_source_title)
print(gboost_target_title)
print(gboost_tid)
print(gboost_source_revid)
Wikipedia:WikiProject Medicine/Translation task force/RTT/Simple mumps vaccine
विकिपीडिया:WikiProject Medicine/Translation task force/RTT/Simple mumps vaccine
107084
651727167
gboost_stats = Data.loc[10, 'stats']
json_str = ""
with gzip.open('cx-corpora._2_.text.json.gz', 'rt') as fin:
    for line in fin:
        json_str += line.strip()
# remove repetitive commas
json_str = re.sub(',{2,}', ',', json_str)
parallel_corpus = json.loads(json_str)
# if this still throws an error, it's probably a trailing comma
# find where that comma is and instead do something like:
# parallel_corpus = json.loads(json_str[:<comma-idx>] + json_str[<comma-idx>+1:])
# id: a string composed of <translationID>/<sectionID>
# <translationID> is in the data accessed from the first API
# each section in the article that was translated gets its own <sectionID>
# mt indicates whether machine translation was used in the interface
print("Descriptive statistics:")
print("{0} translated sections.".format(len(parallel_corpus)))
print("{0} translated articles.".format(len(set(sec['id'].split('/')[0] for sec in parallel_corpus))))
mt_counts = {}
for sec in parallel_corpus:
    if sec['mt']:
        service = sec['mt']['engine']
        mt_counts[service] = mt_counts.get(service, 0) + 1
    else:
        mt_counts['no-mt'] = mt_counts.get('no-mt', 0) + 1
print("Machine translation services used: {0}".format(mt_counts))
print("\nExample:\n", parallel_corpus[0])
Descriptive statistics:
183464 translated sections.
19022 translated articles.
Machine translation services used: {'no-mt': 141130, 'Apertium': 3638, 'Yandex': 38652, 'scratch': 43, 'source-mt': 1}

Example:
 {'id': '180587/mwAQ', 'sourceLanguage': 'af', 'targetLanguage': 'haw', 'source': {'content': "Minas Gerais é o Meu País\xa0(Minas Gerais, Is my land in afrikaans) is'n separatisme beweging veg vir die onafhanklikheid van Minas Gerais te skei van die res van Brasilië."}, 'mt': None, 'target': {'content': 'Minas Gerais é o Meu País\xa0(nan Minas Gerais se peyi mwen nan hawai`i) is`n mouvman separatism goumen pou separe endepandans la nan Minas Gerais de rès la nan Brezil.\xa0'}}
from mwviews.api import PageviewsClient

p = PageviewsClient(user_agent="Miriiyala Pujitha Jaji Outreachy Aspirant")

p.article_views('en.wikipedia', ['Selfie', 'Cat', 'Dog'])
p.project_views(['ro.wikipedia', 'de.wikipedia', 'commons.wikimedia'])
p.top_articles('en.wikipedia', limit=10)
p.article_views('en.wikipedia', ['Selfie', 'Cat'])
defaultdict(dict,
            {datetime.datetime(2019, 3, 1, 0, 0): {'Selfie': 724, 'Cat': 6810},
             datetime.datetime(2019, 3, 2, 0, 0): {'Selfie': 704, 'Cat': 6809},
             datetime.datetime(2019, 3, 3, 0, 0): {'Selfie': 661, 'Cat': 6894},
             datetime.datetime(2019, 3, 4, 0, 0): {'Selfie': 1324,
              'Cat': 7278},
             datetime.datetime(2019, 3, 5, 0, 0): {'Selfie': 811, 'Cat': 7421},
             datetime.datetime(2019, 3, 6, 0, 0): {'Selfie': 748, 'Cat': 7587},
             datetime.datetime(2019, 3, 7, 0, 0): {'Selfie': 886, 'Cat': 7409},
             datetime.datetime(2019, 3, 8, 0, 0): {'Selfie': 722, 'Cat': 6741},
             datetime.datetime(2019, 3, 9, 0, 0): {'Selfie': 1056,
              'Cat': 6132},
             datetime.datetime(2019, 3, 10, 0, 0): {'Selfie': 842,
              'Cat': 6850},
             datetime.datetime(2019, 3, 11, 0, 0): {'Selfie': 928,
              'Cat': 7513},
             datetime.datetime(2019, 3, 12, 0, 0): {'Selfie': 935,
              'Cat': 7260},
             datetime.datetime(2019, 3, 13, 0, 0): {'Selfie': 879,
              'Cat': 7177},
             datetime.datetime(2019, 3, 14, 0, 0): {'Selfie': 872,
              'Cat': 7194},
             datetime.datetime(2019, 3, 15, 0, 0): {'Selfie': 753,
              'Cat': 6335},
             datetime.datetime(2019, 3, 16, 0, 0): {'Selfie': 966,
              'Cat': 5903},
             datetime.datetime(2019, 3, 17, 0, 0): {'Selfie': 996,
              'Cat': 7465},
             datetime.datetime(2019, 3, 18, 0, 0): {'Selfie': 811,
              'Cat': 7013},
             datetime.datetime(2019, 3, 19, 0, 0): {'Selfie': 877,
              'Cat': 7193},
             datetime.datetime(2019, 3, 20, 0, 0): {'Selfie': 772,
              'Cat': 7186},
             datetime.datetime(2019, 3, 21, 0, 0): {'Selfie': 1333,
              'Cat': 6955},
             datetime.datetime(2019, 3, 22, 0, 0): {'Selfie': 774,
              'Cat': 6289},
             datetime.datetime(2019, 3, 23, 0, 0): {'Selfie': 708,
              'Cat': 5786},
             datetime.datetime(2019, 3, 24, 0, 0): {'Selfie': 691,
              'Cat': 6160},
             datetime.datetime(2019, 3, 25, 0, 0): {'Selfie': 900,
              'Cat': 7251},
             datetime.datetime(2019, 3, 26, 0, 0): {'Selfie': 1064,
              'Cat': 6986},
             datetime.datetime(2019, 3, 27, 0, 0): {'Selfie': 885,
              'Cat': 7292},
             datetime.datetime(2019, 3, 28, 0, 0): {'Selfie': 830,
              'Cat': 7214},
             datetime.datetime(2019, 3, 29, 0, 0): {'Selfie': 792,
              'Cat': 6356},
             datetime.datetime(2019, 3, 30, 0, 0): {'Selfie': 795,
              'Cat': 5948},
             datetime.datetime(2019, 3, 31, 0, 0): {'Selfie': None,
              'Cat': None}})
#!pip install git+https://github.com/mediawiki-utilities/python-mwviews.git
#plt.figure(figsize=(25558,54878787))
#sns.distplot(Data['translationId']);
 
revision_parameters = {
    "action": "query",
    "prop": "revisions",
    "titles": gboost_source_title,
    "rvprop": "timestamp|user|comment",
    "rvlimit": 100,
    "rvstartid": gboost_source_revid,
    "rvslots": "main",
    "formatversion": "2",
    "format": "json",
    "rvdir": "newer"
}
gboost_revisions = session.get(revision_parameters)
gboost_revisions
{'batchcomplete': True,
 'query': {'pages': [{'pageid': 45693078,
    'ns': 4,
    'title': 'Wikipedia:WikiProject Medicine/Translation task force/RTT/Simple mumps vaccine',
    'revisions': [{'user': 'Doc James',
      'timestamp': '2015-03-17T02:40:09Z',
      'comment': "[[WP:AES|←]]Created page with '{{Drugbox | Verifiedfields = changed | verifiedrevid = 447562958 | image =    <!--Vacine data--> | type = vaccine | target = [[Mumps]] | vaccine_type = attenuate...'"},
     {'user': 'Medtrans th 02',
      'timestamp': '2016-04-12T16:46:24Z',
      'comment': 'Thai transltion of mumps vaccine'},
     {'user': 'Medtrans th 02',
      'timestamp': '2016-04-12T16:49:11Z',
      'comment': ''},
     {'user': 'Medtrans th 02',
      'timestamp': '2016-04-12T16:49:48Z',
      'comment': ''},
     {'user': 'Medtrans th 02',
      'timestamp': '2016-04-12T16:54:11Z',
      'comment': ''},
     {'user': 'Lucas559',
      'timestamp': '2016-04-12T18:00:23Z',
      'comment': 'Reverted [[WP:AGF|good faith]] edits by [[Special:Contributions/Medtrans th 02|Medtrans th 02]] ([[User talk:Medtrans th 02|talk]]): Should be saved to th.wiki instead of this project page. ([[WP:TW|TW]])'},
     {'user': 'Dcirovic',
      'timestamp': '2016-06-07T03:39:21Z',
      'comment': '/* top */refs using [[Project:AWB|AWB]]'},
     {'user': 'Doc James',
      'timestamp': '2016-06-07T15:36:12Z',
      'comment': 'Reverted edits by [[Special:Contribs/Dcirovic|Dcirovic]] ([[User talk:Dcirovic|talk]]) to last version by Lucas559'}]}]}}
 
sessionParallel = mwapi.Session(host='https://en.wikipedia.org',
                        user_agent='Miriiyala Pujitha Jaji')


parameters = {'action':'query',
              'format':'json',
              'list':'contenttranslationcorpora',
              'translationid': gboost_tid,
                              'striphtml':True}
               
              
 

 
parallel_corpus_res = session.get(parallelParameters)
---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-165-58daa51535c2> in <module>()
----> 1 parallel_corpus_res = session.get(parallelParameters)

NameError: name 'parallelParameters' is not defined
parallel_corpus_res
{'batchcomplete': '', 'query': {'contenttranslationcorpora': {'sections': []}}}
 
publishedDate sourceLanguage sourceRevisionId sourceTitle sourceURL stats targetLanguage targetRevisionId targetTitle targetURL translationId
0 20160110184902 en 697821792 Jain monasticism //en.wikipedia.org/wiki/Jain monasticism {'any': 0.19009086688333, 'human': 0.061219075... hi 2995713 जैन मुनि //hi.wikipedia.org/wiki/जैन मुनि 104628
1 20160112155454 en 653739996 Wikipedia:WikiProject Medicine/Translation tas... //en.wikipedia.org/wiki/Wikipedia:WikiProject ... {'any': 1.0132774283718, 'human': 0.7791754018... hi 2996646 खसरे का टीका(वैक्सीन) //hi.wikipedia.org/wiki/खसरे का टीका(वैक्सीन) 105194
2 20160112165117 en 699475804 List of earthquakes in 2016 //en.wikipedia.org/wiki/List of earthquakes in... {'any': 0.98091603053435, 'human': 0.366412213... hi 2996667 2016 आए में भूकम्पों की सूची //hi.wikipedia.org/wiki/2016 आए में भूकम्पों क... 105305
3 20160113191205 en 699462541 Nimr al-Nimr //en.wikipedia.org/wiki/Nimr al-Nimr {'any': 0.34254974984012, 'human': 0.035398562... hi 2997383 निम्र अल-निम्र //hi.wikipedia.org/wiki/निम्र अल-निम्र 105719
4 20160115180314 en 699970333 J. F. R. Jacob //en.wikipedia.org/wiki/J. F. R. Jacob {'any': 0.15827460303982, 'human': 0.022416574... hi 2999440 जे॰एफ॰आर॰ जैकब //hi.wikipedia.org/wiki/जे॰एफ॰आर॰ जैकब 106456
5 20160117000107 en 699007501 Toplessness //en.wikipedia.org/wiki/Toplessness {'any': 0.26409060042496, 'human': 0.052112768... hi 3000442 धड़ निरावरण //hi.wikipedia.org/wiki/धड़ निरावरण 106992
6 20160117035201 en 648100317 Tripurantaka Temple //en.wikipedia.org/wiki/Tripurantaka Temple {'any': 0.3125, 'human': 0.21912955465587, 'mt... hi 3000482 त्रिपुरान्तकेश्वर मन्दिर //hi.wikipedia.org/wiki/त्रिपुरान्तकेश्वर मन्दिर 107061
7 20160117053801 en 700083932 Bandha (Jainism) //en.wikipedia.org/wiki/Bandha (Jainism) {'any': 0.77460901563937, 'human': 0.374425022... hi 3000535 कर्म बन्ध //hi.wikipedia.org/wiki/कर्म बन्ध 107075
8 20160117062624 en 642055132 Samvara //en.wikipedia.org/wiki/Samvara {'any': 0.54980392156863, 'human': 0.273333333... hi 3000562 संवर //hi.wikipedia.org/wiki/संवर 107084
9 20160117091641 en 683049890 Ajiva //en.wikipedia.org/wiki/Ajiva {'any': 0.25737100737101, 'human': 0.136773136... hi 3000672 अजीव //hi.wikipedia.org/wiki/अजीव 107150