Lab 2 - Hyperlink Networks

Professor Brian Keegan
Department of Information Science, CU Boulder
This notebook is copyright and made available under the Apache License v2.0 license.

This is the second of five lab notebooks that will explore how to do some introductory data extraction and analysis from Wikipedia data. This lab will extend the methods in the prior lab about analyzing a single article's revision histories and use network science methods to analyze the networks of hyperlinks around a single article. You do not need to be fluent in either to complete the lab, but there are many options for extending the analyses we do here by using more advanced queries and scripting methods.

Acknowledgements
I'd like to thank the Wikimedia Foundation for the PAWS system and related Wikitech infrastructure that this workbook runs within. Yuvi Panda, Aaron Halfaker, Jonathan Morgan, and Dario Taraborelli have all provided crucial support and feedback.

Confirm that basic Python commands work

a = 3
b = 4
a**b

6012084
6012084

Import modules and setup environment

Load up all the libraries we'll need to connect to the database, retreive information for analysis, and visualize results.

# Makes the plots appear within the notebook
%matplotlib inline

# Two fundamental packages for doing data manipulation
import numpy as np                   # http://www.numpy.org/
import pandas as pd                  # http://pandas.pydata.org/

# Two related packages for plotting data
import matplotlib.pyplot as plt      # http://matplotlib.org/
import seaborn as sb                 # https://stanford.edu/~mwaskom/software/seaborn/

# Package for requesting data via the web and parsing resulting JSON
import requests
import json
from bs4 import BeautifulSoup

# Two packages for accessing the MySQL server
import pymysql                       # http://pymysql.readthedocs.io/en/latest/
import os                            # https://docs.python.org/3.4/library/os.html

# Packages for analyzing complex networks
import networkx as nx                # https://networkx.github.io/
import igraph as ig

# Setup the code environment to use plots with a white background and DataFrames show more columns and rows
sb.set_style('whitegrid')
pd.options.display.max_columns = 100
pd.options.display.max_rows = 110

Define the name of the article you want to use for the rest of the lab.

page_title = "2013 Egyptian coup d'état"
#dictionary list of all languages and their abbreviations
_langAbrev_dict=dict()

for d in _langlink_list:
    _lang=d['lang']
    _langname=d['langname']
    _langAbrev_dict[_lang]=_langname
_langAbrev_dict
{'af': 'Afrikaans',
 'als': 'Alemannisch',
 'am': 'Amharic',
 'an': 'Aragonese',
 'ang': 'Old English',
 'ar': 'Arabic',
 'arz': 'Egyptian Arabic',
 'as': 'Assamese',
 'ast': 'Asturian',
 'ay': 'Aymara',
 'az': 'Azerbaijani',
 'azb': 'تۆرکجه',
 'ba': 'Bashkir',
 'bat-smg': 'Samogitian',
 'bcl': 'Bikol Central',
 'be': 'Belarusian',
 'be-x-old': 'беларуская (тарашкевіца)\u200e',
 'bg': 'Bulgarian',
 'bm': 'Bambara',
 'bn': 'Bangla',
 'bpy': 'Bishnupriya',
 'br': 'Breton',
 'bs': 'Bosnian',
 'bxr': 'буряад',
 'ca': 'Catalan',
 'cbk-zam': 'Chavacano de Zamboanga',
 'cdo': 'Min Dong Chinese',
 'ce': 'Chechen',
 'ceb': 'Cebuano',
 'ckb': 'Central Kurdish',
 'co': 'Corsican',
 'cs': 'Czech',
 'cv': 'Chuvash',
 'cy': 'Welsh',
 'da': 'Danish',
 'de': 'German',
 'diq': 'Zazaki',
 'el': 'Greek',
 'eo': 'Esperanto',
 'es': 'Spanish',
 'et': 'Estonian',
 'eu': 'Basque',
 'ext': 'Extremaduran',
 'fa': 'Persian',
 'fi': 'Finnish',
 'fiu-vro': 'Võro',
 'fo': 'Faroese',
 'fr': 'French',
 'frp': 'Arpitan',
 'frr': 'Northern Frisian',
 'fy': 'Western Frisian',
 'ga': 'Irish',
 'gan': 'Gan Chinese',
 'gd': 'Scottish Gaelic',
 'gl': 'Galician',
 'gn': 'Guarani',
 'gom': 'Goan Konkani',
 'gu': 'Gujarati',
 'gv': 'Manx',
 'hak': 'Hakka Chinese',
 'haw': 'Hawaiian',
 'he': 'Hebrew',
 'hi': 'Hindi',
 'hif': 'Fiji Hindi',
 'hr': 'Croatian',
 'ht': 'Haitian Creole',
 'hu': 'Hungarian',
 'hy': 'Armenian',
 'ia': 'Interlingua',
 'id': 'Indonesian',
 'ie': 'Interlingue',
 'ig': 'Igbo',
 'ilo': 'Iloko',
 'io': 'Ido',
 'is': 'Icelandic',
 'it': 'Italian',
 'ja': 'Japanese',
 'jam': 'Jamaican Creole English',
 'jbo': 'Lojban',
 'jv': 'Javanese',
 'ka': 'Georgian',
 'kaa': 'Kara-Kalpak',
 'kab': 'Kabyle',
 'kk': 'Kazakh',
 'km': 'Khmer',
 'kn': 'Kannada',
 'ko': 'Korean',
 'ksh': 'Colognian',
 'ku': 'Kurdish',
 'kw': 'Cornish',
 'ky': 'Kyrgyz',
 'la': 'Latin',
 'lad': 'Ladino',
 'lb': 'Luxembourgish',
 'lez': 'Lezghian',
 'lg': 'Ganda',
 'li': 'Limburgish',
 'lij': 'Ligurian',
 'lmo': 'Lombard',
 'lrc': 'Northern Luri',
 'lt': 'Lithuanian',
 'lv': 'Latvian',
 'mai': 'Maithili',
 'map-bms': 'Basa Banyumasan',
 'mg': 'Malagasy',
 'mk': 'Macedonian',
 'ml': 'Malayalam',
 'mn': 'Mongolian',
 'mr': 'Marathi',
 'ms': 'Malay',
 'mwl': 'Mirandese',
 'my': 'Burmese',
 'mzn': 'Mazanderani',
 'na': 'Nauru',
 'nah': 'Nāhuatl',
 'nds': 'Low German',
 'nds-nl': 'Low Saxon',
 'ne': 'Nepali',
 'new': 'Newari',
 'nl': 'Dutch',
 'nn': 'Norwegian Nynorsk',
 'no': 'Norwegian',
 'nov': 'Novial',
 'nv': 'Navajo',
 'oc': 'Occitan',
 'olo': 'Livvi-Karelian',
 'om': 'Oromo',
 'or': 'Odia',
 'os': 'Ossetic',
 'pa': 'Punjabi',
 'pam': 'Pampanga',
 'pcd': 'Picard',
 'pl': 'Polish',
 'pms': 'Piedmontese',
 'pnb': 'Western Punjabi',
 'ps': 'Pashto',
 'pt': 'Portuguese',
 'qu': 'Quechua',
 'ro': 'Romanian',
 'roa-rup': 'Aromanian',
 'ru': 'Russian',
 'rue': 'Rusyn',
 'sa': 'Sanskrit',
 'sah': 'Sakha',
 'sc': 'Sardinian',
 'scn': 'Sicilian',
 'sco': 'Scots',
 'sd': 'Sindhi',
 'se': 'Northern Sami',
 'sh': 'Serbo-Croatian',
 'si': 'Sinhala',
 'simple': 'Simple English',
 'sk': 'Slovak',
 'sl': 'Slovenian',
 'so': 'Somali',
 'sq': 'Albanian',
 'sr': 'Serbian',
 'su': 'Sundanese',
 'sv': 'Swedish',
 'sw': 'Swahili',
 'szl': 'Silesian',
 'ta': 'Tamil',
 'te': 'Telugu',
 'th': 'Thai',
 'tk': 'Turkmen',
 'tl': 'Tagalog',
 'tpi': 'Tok Pisin',
 'tr': 'Turkish',
 'tt': 'Tatar',
 'tyv': 'Tuvinian',
 'ug': 'Uyghur',
 'uk': 'Ukrainian',
 'ur': 'Urdu',
 'uz': 'Uzbek',
 'vec': 'Venetian',
 'vep': 'Veps',
 'vi': 'Vietnamese',
 'vo': 'Volapük',
 'wa': 'Walloon',
 'war': 'Waray',
 'wo': 'Wolof',
 'wuu': 'Wu Chinese',
 'xmf': 'Mingrelian',
 'yi': 'Yiddish',
 'yo': 'Yoruba',
 'za': 'Zhuang',
 'zea': 'Zeelandic',
 'zh': 'Chinese',
 'zh-min-nan': 'Chinese (Min Nan)',
 'zh-yue': 'Cantonese'}
len(_langAbrev_dict)
190
#combine all the steps above into one function, every page in another language will be listed and written in that particular language

def link_getter(page_title):
    
    _S="https://en.wikipedia.org/w/api.php?action=query&format=json&prop=langlinks&titles={0}&llprop=autonym|langname&lllimit=500".format(page_title)
    
    req = requests.get(_S)

    json_string = json.loads(req.text)
    
    _pageID=list(json_string['query']['pages'].keys())[0]

    _langlink_list=json_string['query']['pages'][_pageID]['langlinks']
    
    _langlink_dict=dict()

    for d in _langlink_list:
        _lang=d['lang']
        _title=d['*']
        _langlink_dict[_lang]=_title
        
    _langlink_dict['en'] = page_title
    return _langlink_dict
#lang and title dict 

titles_and_lang_dict = {}

pages_and_langs = link_getter(page_title)

for lang,title in pages_and_langs.items():
    titles_and_lang_dict[lang] = title
    #titles_and_lang_dict['en'] = page_title
titles_and_lang_dict
{'af': 'Egiptiese staatsgreep van 2013',
 'ar': 'انقلاب 2013 في مصر',
 'arz': 'خريطة المستقبل (مصر)',
 'az': 'Misirdə hərbi çeviriliş (2013)',
 'bg': 'Държавен преврат в Египет (2013 г.)',
 'ca': "Cop d'Estat a Egipte l'any 2013",
 'ckb': 'کودەتای ٢٠١٣ی میسر',
 'de': 'Militärputsch in Ägypten 2013',
 'el': 'Αιγυπτιακό πραξικόπημα 2013',
 'en': "2013 Egyptian coup d'état",
 'es': 'Golpe de Estado en Egipto de 2013',
 'fa': 'کودتای ۲۰۱۳ مصر',
 'fi': 'Egyptin vallankaappaus 2013',
 'fr': "Coup d'État du 3 juillet 2013 en Égypte",
 'he': 'ההפיכה במצרים (2013)',
 'hi': 'मिस्र में सैन्य तख्तापलट २०१३',
 'id': 'Kudeta Mesir 2013',
 'it': 'Golpe egiziano del 2013',
 'ja': '2013年エジプトクーデター',
 'ko': '2013년 이집트 쿠데타',
 'nl': 'Protesten en staatsgreep in Egypte in 2013',
 'pl': 'Zamach stanu w Egipcie (2013)',
 'pt': 'Golpe de Estado no Egito em 2013',
 'ro': 'Lovitura de stat din Egipt din 2013',
 'ru': 'Военный переворот в Египте (2013)',
 'sr': 'Државни удар у Египту (2013)',
 'tg': 'Кудатои 2013 Миср',
 'tr': '2013 Mısır askerî darbesi',
 'uk': 'Військовий переворот в Єгипті 2013',
 'ur': '2013ء مصری فوجی تاخت',
 'vi': 'Đảo chính Ai Cập 2013',
 'zh': '2013年埃及政变'}
#returns list of pages in each lang it is published in 
len(link_getter(page_title))
32

Retrieve the content of the page via API

Write a function that takes an article title and returns the list of links in the body of the article. Note that the reason we don't use the "pagelinks" table in MySQL or the "links" parameter in the API is that this includes links within templates. Articles with templates link to each other forming over-dense clusters in the resulting networks. We only want the links appearing in the body of the text.

We pass a request to the API, which returns a JSON-formatted string containing the HTML of the page. We use BeautifulSoup to parse through the HTML tree and extract the non-template links and return them as a list.

def get_page_outlinks(page_title,lang='en',redirects=1):
    # Replace spaces with underscores
    page_title = page_title.replace(' ','_')
    
    bad_titles = ['Special:','Wikipedia:','Help:','Template:','Category:','International Standard','Portal:','s:','File:']
    
    # Get the response from the API for a query
    # After passing a page title, the API returns the HTML markup of the current article version within a JSON payload
    req = requests.get('https://{2}.wikipedia.org/w/api.php?action=parse&format=json&page={0}&redirects={1}&prop=text&disableeditsection=1&disabletoc=1'.format(page_title,redirects,lang))
    
    # Read the response into JSON to parse and extract the HTML
    json_string = json.loads(req.text)
    
    # Initialize an empty list to store the links
    outlinks_list = [] 
    
    if 'parse' in json_string.keys():
        page_html = json_string['parse']['text']['*']

        # Parse the HTML into Beautiful Soup
        soup = BeautifulSoup(page_html,'lxml')

        # Delete tags associated with templates
        for tag in soup.find_all('tr'):
            tag.replace_with('')

        # For each paragraph tag, extract the titles within the links
        for para in soup.find_all('p'):
            for link in para.find_all('a'):
                if link.has_attr('title'):
                    title = link['title']
                    # Ignore links that aren't interesting
                    if all(bad not in title for bad in bad_titles):
                        outlinks_list.append(title)

        # For each unordered list, extract the titles within the child links
        for unordered_list in soup.find_all('ul'):
            for item in unordered_list.find_all('li'):
                for link in item.find_all('a'):
                    if link.has_attr('title'):
                        title = link['title']
                        # Ignore links that aren't interesting
                        if all(bad not in title for bad in bad_titles):
                            outlinks_list.append(title)

    return outlinks_list
outlinks_per_lang = {}

language_titles = link_getter(page_title)

for lang,title in language_titles.items():
    #print("The language is",lang,"and the article title is", title)
    outlinks_per_lang[lang] = get_page_outlinks(title,lang)
outlinks_per_lang['de']
['Putsch',
 'Streitkräfte Ägyptens',
 'Oberster Rat der Streitkräfte',
 'Abd al-Fattah as-Sisi',
 'Ägypten',
 'Mohammed Mursi',
 'Ultimatum',
 'Islamismus',
 'Muslimbrüder',
 'Staatskrise in Ägypten 2013',
 'Vereinigte Staaten von Amerika',
 'Europäische Union',
 'Terrorismus',
 'Sinai-Halbinsel',
 'Gotteskrieger',
 'Menschenrechtsorganisation',
 'Husni Mubarak',
 'Putsch',
 'Koptische Kirche',
 'Patriarch',
 'Tawadros II.',
 'Imam',
 'Al-Azhar-Universität',
 'Ahmed Tayeb',
 'Tamarod',
 'Linksliberalismus',
 'Nationale Heilsfront',
 'Mohammed el-Baradei',
 'Salafisten',
 'Partei des Lichts',
 'Hasim al-Beblawi',
 'Staatskrise in Ägypten 2013',
 'Christentum',
 'Bischof',
 'Tawadros II.',
 'Sanktion',
 'Römisch-katholische Kirche',
 'Deutsche Bischofskonferenz',
 'Muslimbrüder',
 'Tiefer Staat',
 'Husni Mubarak',
 'Revolution in Ägypten 2011',
 'Restauration (Geschichte)',
 'Konterrevolution',
 'Parlament',
 'Verfassunggebende Versammlung',
 'Gremium',
 'Husni Mubarak',
 'Nachrichtendienst',
 'Streitkräfte Ägyptens',
 'Demonstration',
 'Protest',
 'Interessengruppe',
 'Unterschriftenaktion',
 'Tamarod',
 'Naguib Sawiris',
 'Infrastruktur',
 'Partei der Freien Ägypter',
 'Verfassungsgerichtsbarkeit',
 'Tahani al-Gebali',
 'Elektrizitätsversorgung',
 'Kraftstoff',
 'Erdgas',
 'Menschenrechte',
 'Folter',
 'Pressefreiheit',
 'Lebensmittelteuerung (Seite nicht vorhanden)',
 'Arbeitslosigkeit',
 'Tankstelle',
 'Stromausfall',
 'Boykott',
 'Kriminalität',
 'Nachrichtendienst',
 'Tawadros II.',
 'Ahmad Mohammad al-Tayyeb',
 'Mohammed el-Baradei',
 'Islam',
 'Al-Azhar-Universität',
 'Linksliberalismus',
 'Mohammed el-Baradei',
 'Salafismus',
 'Partei des Lichts',
 'Elite',
 'Übergangsregierung',
 'Technokratie',
 'Großunternehmen',
 'Gouvernement',
 'Gouverneur',
 'Abd al-Fattah as-Sisi',
 'Mohammed Hussein Tantawi',
 'Gremium',
 'Arbeitslosigkeit',
 'Inflation',
 'Revolution in Ägypten 2011',
 'Verfassung der Republik Ägypten',
 'Gouvernements in Ägypten',
 'Adel al-Chajat',
 'Gamaa Islamija',
 'Al-Azhar-Moschee',
 'Tamarod',
 'Mohammed Mursi',
 'Tahrir-Platz',
 'Al-Wasat-Partei',
 'Streitkräfte Ägyptens',
 'Barack Obama',
 'Mohamed Kamel Amr',
 'Middle East News Agency (Seite nicht vorhanden)',
 'Abd al-Fattah as-Sisi',
 'Hescham Kandil',
 'Abdel Meguid Mahmud',
 'Koalition (Politik)',
 'Universität Kairo',
 'Al-Dschamāʿa al-islāmiyya',
 'Assem Abdel-Maged (Seite nicht vorhanden)',
 'Anne W. Patterson',
 'Mitteleuropäische Sommerzeit',
 'Heliopolis',
 'Greenwich Mean Time',
 'Übergangsregierung',
 'Abd al-Fattah as-Sisi',
 'Vorgezogene Neuwahl',
 'Mahmoud Badr (Seite nicht vorhanden)',
 'Entführung',
 'Wiki Thawra (Seite nicht vorhanden)',
 'Washington Post',
 'Revolution',
 'Stiftung Wissenschaft und Politik',
 'Volker Perthes',
 'Die Zeit',
 'Kurier (Tageszeitung)',
 'Der Spiegel',
 'Putsch',
 'Politikwissenschaft',
 'NDR Info',
 'Putsch',
 'John Kerry',
 'Martin E. Dempsey',
 'Sedki Sobhi (Seite nicht vorhanden)',
 'Gunter Mulack',
 'Türkei',
 'Recep Tayyip Erdoğan',
 'Tunesien',
 'Ennahda',
 'The Daily Beast',
 'Philip J. Crowley',
 'Außenminister der Vereinigten Staaten',
 'Zentrum für Forschung zur Arabischen Welt (Seite nicht vorhanden)',
 'Deutsche Gesellschaft für Auswärtige Politik',
 'Europäische Union',
 'Krieg gegen den Terror',
 'Israelisch-ägyptischer Friedensvertrag',
 'Menschenrechte',
 'Dirk Emmerich (Seite nicht vorhanden)',
 'N-tv',
 'Tiefer Staat',
 'Judikative',
 'Exekutive',
 'Administrative',
 'Revolution in Ägypten 2011',
 'Wirtschaft',
 'Militär',
 'Staat im Staate',
 'Konterrevolution',
 'Elite',
 'Militärparade',
 'Akademischer Grad',
 'Militärakademie',
 'Vierte Gewalt',
 'The Guardian',
 'The Washington Post',
 'Al-Arabiya',
 'Al Jazeera',
 'Deutsche Welle',
 'BBC Arabic (Seite nicht vorhanden)',
 'Analphabetismus',
 'Kinderschänder',
 'Michael Thumann',
 'Bürgerrecht',
 'Arabic Network for Human Rights Information (Seite nicht vorhanden)',
 'Muhammad Badi’e',
 'Rābiʿa-al-ʿAdawiyya-Moschee',
 'Chairat al-Schater',
 'Saad al-Katatni',
 'Freiheits- und Gerechtigkeitspartei',
 'Rashad Bajumi (Seite nicht vorhanden)',
 'Human Rights Watch',
 'Adli Mansur',
 'Marsa Matruh',
 'Kafr asch-Schaich',
 'Alexandria',
 'Al-Minya',
 'Alexandria',
 'Luxor',
 'Damanhur',
 'Konterrevolution',
 'Flughafen al-Arisch',
 'Gouvernement as-Suwais',
 'Gouvernement Dschanub Sina',
 'Hosni Mubarak',
 'Kopten',
 'Kreuzzug',
 'Scharia',
 'Mohammed el-Baradei',
 'Partei des Lichts',
 'Ägyptische Sozialdemokratische Partei',
 'Siad Bahaa El-Din (Seite nicht vorhanden)',
 'Koptische Kirche',
 'Al-Arisch',
 'Verfassung der Republik Ägypten',
 'Voice of America',
 'Afrikanische Union',
 'Republikanische Partei',
 'John McCain',
 'Partei des Lichts',
 'Hasim al-Beblawi',
 'Weltbank',
 'Recep Tayyip Erdoğan',
 'Abdullah Gül',
 'Blutbad in Kairo und Gizeh vom 14. August 2013',
 'Cairo Institute for Human Rights Studies (Seite nicht vorhanden)',
 'Kosovo',
 'Libyen',
 'Syrien',
 'Libanon',
 'Ukraine',
 'Europäische Union',
 'Militärputsch in Ägypten 1952',
 'Gamal Abdel Nasser',
 'Tawadros II.',
 'Ahmad Mohammad al-Tayyeb',
 'Mohammed el-Baradei',
 'Verfassung der Republik Ägypten',
 'Oberstes Verfassungsgericht Ägyptens',
 'Adli Mansur',
 'Übergangsregierung',
 'Technokratie',
 'British Broadcasting Corporation',
 'Nationale Heilsfront',
 'Freiheits- und Gerechtigkeitspartei',
 'Joachim Schroedel',
 'Deutsche Bischofskonferenz',
 'The European',
 'Afrikanische Union',
 'Afrikanische Union',
 'Afrikanische Union',
 'Addis Abeba',
 'Nkosazana Dlamini-Zuma',
 'Revolution in Ägypten 2011',
 'Hosni Mubarak',
 'Mohammed Edrees (Seite nicht vorhanden)',
 'Dekolonisation Afrikas',
 'Deutschland',
 'Deutschland',
 'Guido Westerwelle',
 'Dänemark',
 'Dänemark',
 'Iran',
 'Iran',
 'Jordanien',
 'Jordanien',
 'Katar',
 'Katar',
 'Kuwait',
 'Kuwait',
 'Russland',
 'Russland',
 'Alexej Puchow (Seite nicht vorhanden)',
 'Saudi-Arabien',
 'Saudi-Arabien',
 'Abdullah ibn Abd al-Aziz',
 'Somalia',
 'Somalia',
 'Al-Shabaab (Somalia)',
 'Twitter',
 'Rosarote Brille',
 'Syrien',
 'Syrien',
 'Baschar al-Assad',
 'Türkei',
 'Türkei',
 'Ahmet Davutoğlu',
 'Recep Tayyip Erdoğan',
 'Israel',
 'Tunesien',
 'Tunesien',
 'Moncef Marzouki',
 'Kongress für die Republik (Tunesien)',
 'Vereinigte Arabische Emirate',
 'Vereinigte Arabische Emirate',
 'Chalifa bin Zayid Al Nahyan',
 'Vereinigtes Königreich',
 'Vereinigtes Königreich',
 'William Hague',
 'Vereinigte Staaten',
 'Vereinigte Staaten',
 'Vereinigte Staaten',
 'Tansania',
 'Barack Obama',
 'Tunesien',
 'Algerien',
 'L’Orient-Le Jour',
 'Libanon',
 'The Daily Star (Libanon)',
 'Baschar al-Assad',
 'Syrien',
 'Iran',
 'Bahrain',
 'Gulf News',
 'Vereinigte Arabische Emirate',
 'Israel',
 'Israel HaYom',
 'Jedi’ot Acharonot',
 'Haaretz',
 'Frankreich',
 'Paris',
 'Le Figaro',
 'Ouest-France',
 'The New York Times',
 'Handelsblatt',
 'Die Welt',
 'Süddeutsche Zeitung',
 'Frankfurter Allgemeine Zeitung',
 'Jen Psaki',
 'George Orwell',
 'Neusprech',
 'Federal Reserve Bank of New York',
 'Rüstungsindustrie',
 'General Dynamics F-16',
 'Mehrzweckkampfflugzeug',
 'Hughes AH-64',
 'Kampfhubschrauber',
 'M1 Abrams',
 'Kampfpanzer',
 'Fregatte',
 'Krieg in Afghanistan',
 'Krieg gegen den Terror',
 'Naher Osten',
 'Ostafrika',
 'Freiheiten der Luft',
 'Luftraum',
 'Sueskanal',
 'Ölvorkommen',
 'Naher Osten',
 'Brookings Institution',
 'Demokratiemessung',
 'Demokratiemessung',
 'Husni Mubarak',
 'Anwar as-Sadat',
 'Blutbad in Kairo und Gizeh 2013',
 'Staatskrise in Ägypten 2013/2014 (Kabinett Beblawi)',
 'Chile',
 'Argentinien',
 'Algerien',
 'Martin Gehlen',
 'James Franklin Jeffrey',
 'American Council on Germany',
 'Council on Foreign Relations',
 'George W. Bush']
def get_outlink_translations(outlinks_per_lang):
    translation_dict = dict()
    for lang,links in outlinks_per_lang.items():
        _page_titles = list(set(links))

        translation_dict[lang] = {}

        for _page_title in _page_titles:
            _S="https://{1}.wikipedia.org/w/api.php?action=query&format=json&prop=langlinks&titles={0}&redirects=1&lllimit=500&formatversion=2".format(_page_title,lang)
            response = requests.get(_S).json()
            if 'pages' in response['query'].keys():
                langlink_dict = response['query']['pages'][0]
                translation_dict[lang][_page_title] = {}
                if 'langlinks' in langlink_dict.keys():
                    for _ll in langlink_dict['langlinks']:
                        _ll_title = _ll['title']
                        _ll_lang = _ll['lang']
                        translation_dict[lang][_page_title][_ll_lang] = _ll_title
            else:
                translation_dict[lang][_page_title] = {}
                
    return translation_dict
translation_dict = get_outlink_translations(outlinks_per_lang)
len([title for title,lang_dict in translation_dict['zh'].items() if 'en' in lang_dict.keys()])
78
len([title for title,lang_dict in translation_dict['zh'].items() if 'en' in lang_dict.keys()])
78
len(translation_dict['zh'])
91
list(translation_dict.items())[0]
('fa',
 {'اخوان\u200cالمسلمین': {'ar': 'الإخوان المسلمون',
   'arz': 'الاخوان المسلمين',
   'az': 'Müsəlman qardaşlar',
   'be': 'Браты-мусульмане',
   'be-x-old': 'Браты-мусульмане',
   'bg': 'Мюсюлманско братство',
   'bn': 'মুসলিম ব্রাদারহুড',
   'bs': 'Muslimansko bratstvo',
   'ca': 'Germans Musulmans',
   'ckb': 'کۆمەڵەی برایانی موسوڵمان',
   'cs': 'Muslimské bratrstvo',
   'cy': 'Y Frawdoliaeth Fwslimaidd',
   'da': 'Det muslimske broderskab',
   'de': 'Muslimbrüder',
   'el': 'Μουσουλμανική Αδελφότητα',
   'en': 'Muslim Brotherhood',
   'eo': 'Islama Frataro',
   'es': 'Hermanos Musulmanes',
   'et': 'Moslemi Vennaskond',
   'eu': 'Anaia Musulmanak',
   'fi': 'Muslimiveljeskunta',
   'fr': 'Frères musulmans',
   'gl': 'Irmandade Musulmá',
   'he': 'האחים המוסלמים',
   'hi': 'मुस्लिम ब्रदरहुड',
   'hr': 'Muslimansko bratstvo',
   'hu': 'Muszlim Testvériség',
   'id': 'Ikhwanul Muslimin',
   'it': 'Fratelli Musulmani',
   'ja': 'ムスリム同胞団',
   'ka': 'მუსლიმთა საძმო',
   'kk': 'Ихуан әл-Муслимин',
   'ko': '무슬림 형제단',
   'la': 'Fratres musulmani',
   'lt': 'Musulmonų Brolija',
   'lv': 'Musulmaņu brālība',
   'ml': 'മുസ്\u200cലിം ബ്രദർഹുഡ്',
   'ms': 'Ikhwanul Muslimun',
   'mzn': 'اخوان المسلمون',
   'nl': 'Moslimbroederschap',
   'nn': 'Det muslimske brorskapet',
   'no': 'Det muslimske brorskapet',
   'pa': 'ਮੁਸਲਿਮ ਬ੍ਰਦਰਹੁੱਡ',
   'pl': 'Bracia Muzułmańscy',
   'pnb': 'اخوان المسلمین',
   'ps': 'اخوان المسلمون',
   'pt': 'Irmandade Muçulmana',
   'ro': 'Frăția Musulmană',
   'ru': 'Братья-мусульмане',
   'scn': 'Frati mussurmani',
   'sh': 'Muslimansko bratstvo',
   'simple': 'Muslim Brotherhood',
   'sr': 'Муслиманско братство',
   'sv': 'Muslimska brödraskapet',
   'ta': 'முசுலிம் சகோதரத்துவம்',
   'te': 'ముస్లిం బ్రదర్\u200cహుడ్',
   'tg': 'Ихвонул муслимин',
   'tr': 'Müslüman Kardeşler',
   'uk': 'Брати мусульмани',
   'ur': 'اخوان المسلمین',
   'vi': 'Anh em Hồi giáo',
   'wa': 'Frés moslimîs',
   'wuu': '穆斯林兄弟会',
   'yi': 'מוסלעם ברידערשאפט',
   'zh': '穆斯林兄弟會',
   'zh-yue': '穆斯林兄弟會'},
  'ارتش مصر': {'af': 'Egiptiese Gewapende Magte',
   'ar': 'القوات المسلحة المصرية',
   'arz': 'الجيش المصرى',
   'az': 'Misir Silahlı Qüvvələri',
   'be': 'Узброеныя сілы Егіпта',
   'bg': 'Въоръжени сили на Египет',
   'bn': 'মিশরের সশস্ত্র বাহিনী',
   'ca': "Forces Armades d'Egipte",
   'ceb': 'Ehiptohanon nga armadong pwersa',
   'cs': 'Egyptské ozbrojené síly',
   'cy': 'Lluoedd Arfog yr Aifft',
   'da': 'Egyptiske væbnede styrker',
   'de': 'Streitkräfte Ägyptens',
   'el': 'Αιγυπτιακές Ένοπλες Δυνάμεις',
   'en': 'Egyptian Armed Forces',
   'eo': 'Egiptaj Armitaj Fortoj',
   'es': 'Fuerzas Armadas de Egipto',
   'et': 'Egiptuse relvajõud',
   'fi': 'Egyptin asevoimat',
   'fr': 'Forces armées égyptiennes',
   'hi': 'मिस्र के सशस्त्र बल',
   'hr': 'Egipatske oružane snage',
   'hu': 'Egyiptom hadereje',
   'hy': 'Եգիպտոսի զինված ուժեր',
   'id': 'Angkatan Bersenjata Mesir',
   'is': 'Egyptalandsher',
   'it': 'Forze armate egiziane',
   'ja': 'エジプト軍',
   'jv': 'Mesir pasukan bersenjata',
   'kk': 'Мысыр Қарулы күштері',
   'km': 'កងទ័ពអេហ្ស៊ីប',
   'ko': '이집트군',
   'ms': 'Angkatan Bersenjata Mesir',
   'ne': 'मिश्रको सशस्त्र बल',
   'no': 'Egypts forsvar',
   'pa': 'ਮਿਸਰ ਦੇ ਆਰਮਡ ਫੋਰਸਿਜ਼',
   'pt': 'Forças Armadas do Egito',
   'ro': 'Forțele armate ale Egiptului',
   'ru': 'Египетские вооружённые силы',
   'si': 'ඊජිප්තු සන්නද්ධ හමුදා',
   'simple': 'Egyptian Armed Forces',
   'sl': 'Oborožene sile Egipta',
   'so': 'Ciidamada Qalabka Sida ee Masaarida',
   'sq': 'Forcat e Armatosura Egjiptiane',
   'sv': 'Egyptiska väpnade styrkor',
   'sw': 'Jeshi la Misri',
   'tg': 'Қувваҳои Мусаллаҳи Миср',
   'th': 'กองทัพอียิปต์',
   'tr': 'Mısır Silahlı Kuvvetleri',
   'uk': 'Збройні сили Єгипту',
   'vi': 'Lực lượng vũ trang Ai Cập',
   'yi': 'עגיפטישע באוואפנטע קרעפטן',
   'yo': 'Egypt ologun',
   'zh': '埃及武裝力量',
   'zh-yue': '埃及軍事'},
  'اسکندریه': {'af': 'Alexandrië',
   'als': 'Alexandria',
   'am': 'እስክንድርያ',
   'an': 'Aleixandría',
   'ar': 'الإسكندرية',
   'arc': 'ܐܠܟܣܢܕܪܝܐ',
   'arz': 'اسكندريه',
   'az': 'İsgəndəriyyə',
   'azb': 'الکزاندریا ، (رومانی)',
   'ba': 'Искәндәриә',
   'be': 'Горад Александрыя',
   'be-x-old': 'Александрыя',
   'bg': 'Александрия',
   'bn': 'আলেকজান্দ্রিয়া',
   'bo': 'ཡ་ལི་ཧྲན་ད',
   'bpy': 'আলেক্সান্ড্রিয়া',
   'br': 'Aleksandria',
   'bs': 'Aleksandrija',
   'ca': 'Alexandria',
   'ce': 'Искандри',
   'ceb': 'Alexandria (kapital sa lalawigan sa Ehipto)',
   'ckb': 'ئەسکەندەریە',
   'cs': 'Alexandrie',
   'cy': 'Alexandria',
   'da': 'Alexandria',
   'de': 'Alexandria',
   'el': 'Αλεξάνδρεια',
   'en': 'Alexandria',
   'eo': 'Aleksandrio',
   'es': 'Alejandría',
   'et': 'Aleksandria',
   'eu': 'Alexandria',
   'ext': 'Alejandria',
   'fi': 'Aleksandria',
   'fr': 'Alexandrie',
   'frr': 'Alexandria',
   'fy': 'Aleksandrje',
   'ga': 'Cathair Alastair',
   'gl': 'Alexandría',
   'gu': 'એલેક્ઝાન્ડ્રિયા',
   'he': 'אלכסנדריה',
   'hi': 'सिकन्दरिया',
   'hr': 'Aleksandrija',
   'hu': 'Alexandria (Egyiptom)',
   'hy': 'Ալեքսանդրիա',
   'id': 'Iskandariyah',
   'ie': 'Alexandria',
   'is': 'Alexandría',
   'it': "Alessandria d'Egitto",
   'ja': 'アレクサンドリア',
   'jv': 'Alexandria',
   'ka': 'ალექსანდრია',
   'kab': 'Taskendrit',
   'kk': 'Александрия (Мысыр)',
   'kl': 'Alexandria',
   'kn': 'ಅಲೆಕ್ಸಾಂಡ್ರಿಯ',
   'ko': '알렉산드리아',
   'koi': 'Ӧльӧксандрия',
   'ku': 'Îskenderiye',
   'kv': 'Ӧльӧксандрия',
   'ky': 'Александрия',
   'la': 'Alexandria',
   'lad': 'Alejandria',
   'lt': 'Aleksandrija',
   'lv': 'Aleksandrija',
   'mhr': 'Александрий',
   'min': 'Alexandria',
   'mk': 'Александрија',
   'ml': 'അലക്സാണ്ട്രിയ',
   'mn': 'Александрия',
   'mr': 'अलेक्झांड्रिया',
   'ms': 'Iskandariah',
   'my': 'အလက်ဇန္ဒရီးယားမြို့',
   'na': 'Alexandria',
   'nah': 'Alexandria',
   'nap': "Alessandria 'e Naggitto",
   'nds': 'Alexandria',
   'nl': 'Alexandrië',
   'nn': 'Alexandria',
   'no': 'Alexandria',
   'oc': 'Alexàndria',
   'os': 'Александрия',
   'pa': 'ਸਿਕੰਦਰੀਆ',
   'pl': 'Aleksandria',
   'pnb': 'اسکندریہ',
   'pt': 'Alexandria',
   'qu': 'Iskandariya',
   'ro': 'Alexandria, Egipt',
   'ru': 'Александрия',
   'sc': "Lisàndria d'Egittu",
   'scn': "Alessandria d'Eggittu",
   'sco': 'Alexandria',
   'sh': 'Aleksandrija',
   'simple': 'Alexandria',
   'sk': 'Alexandria',
   'sl': 'Aleksandrija',
   'sn': 'Alexandria',
   'sq': 'Aleksandria',
   'sr': 'Александрија',
   'sv': 'Alexandria',
   'sw': 'Aleksandria',
   'szl': 'Aleksandryjo',
   'ta': 'அலெக்சாந்திரியா',
   'te': 'అలెగ్జాండ్రియా',
   'tg': 'Искандария',
   'th': 'อะเล็กซานเดรีย',
   'tl': 'Alexandria',
   'tr': 'İskenderiye',
   'tw': 'Alexandria',
   'uk': 'Александрія',
   'ur': 'اسکندریہ',
   'uz': 'Aleksandriya',
   'vec': "Ałesandria d'Egito",
   'vep': 'Aleksandrii',
   'vi': 'Alexandria',
   'war': 'Alexandria',
   'wo': 'Alegsàndiri',
   'wuu': '亚历山大港',
   'xmf': 'ალექსანდრია',
   'yi': 'אלעקסאנדריע',
   'zh': '亚历山大港',
   'zh-min-nan': 'Alexandria',
   'zh-yue': '亞歷山大港'},
  'انقلاب ۲۰۱۱ مصر': {'ar': 'ثورة 25 يناير',
   'arz': 'ثورة 25 يناير',
   'az': 'Misir inqilabı (2011)',
   'azb': 'میصر اینقیلابی',
   'be': 'Рэвалюцыя ў Егіпце, 2011',
   'be-x-old': 'Эгіпецкая рэвалюцыя 2011 году',
   'bg': 'Египетска революция (2011)',
   'bs': 'Protesti u Egiptu (2011)',
   'ca': 'Revolució egípcia de 2011',
   'cs': 'Egyptská revoluce 2011',
   'cy': "Chwyldro'r Aifft, 2011",
   'da': 'Egyptiske revolution 2011',
   'de': 'Revolution in Ägypten 2011',
   'el': 'Αιγυπτιακή επανάσταση του 2011',
   'en': 'Egyptian revolution of 2011',
   'eo': 'Egipta revolucio de 2011',
   'es': 'Revolución egipcia de 2011',
   'eu': '2011ko Egiptoko Iraultza',
   'fi': 'Egyptin vallankumous 2011',
   'fr': 'Révolution égyptienne de 2011',
   'he': 'המהפכה במצרים (2011)',
   'hr': 'Egipatska revolucija 2011.',
   'hu': 'Nílusi forradalom',
   'hy': 'Եգիպտական հեղափոխություն (2011)',
   'id': 'Revolusi Mesir 2011',
   'io': 'Revoluciono Egiptiana 2011',
   'is': 'Egypska byltingin 2011',
   'it': 'Rivoluzione egiziana del 2011',
   'ja': 'エジプト革命 (2011年)',
   'jv': 'Demonstrasi Mesir 2011',
   'ko': '2011년 이집트 혁명',
   'la': 'Manifestationes Aegyptiae anni 2011',
   'lt': '2011 m. Egipto revoliucija',
   'lv': '2011. gada Ēģiptes revolūcija',
   'ml': '2011-ലെ ഈജിപ്ഷ്യൻ പ്രക്ഷോഭം',
   'ms': 'Revolusi Mesir 2011',
   'my': '၂၀၁၁ အီဂျစ် လူထုဆန္ဒပြပွဲ',
   'nl': 'Egyptische Revolutie (2011)',
   'nn': 'Den egyptiske revolusjonen i 2011',
   'no': 'Den egyptiske revolusjonen i 2011',
   'pl': 'Rewolucja w Egipcie (2011)',
   'pt': 'Revolução Egípcia de 2011',
   'ro': 'Revoluția egipteană din 2011',
   'ru': 'Революция в Египте (2011)',
   'sco': '2011 Egyptian revolution',
   'sh': 'Protesti u Egiptu (2011)',
   'simple': '2011 Egyptian revolution',
   'so': 'Kacdoonka masar',
   'sr': 'Протести у Египту (2011)',
   'sv': 'Egyptiska revolutionen 2011',
   'ta': '2011 எகிப்தியப் புரட்சி',
   'th': 'การปฏิวัติอียิปต์ พ.ศ. 2554',
   'tr': '2011 Mısır Devrimi',
   'uk': 'Революція в Єгипті (2011)',
   'vi': 'Cách mạng Ai Cập 2011',
   'wa': 'Revintreye edjipsyinne',
   'zh': '2011年埃及革命',
   'zh-yue': '2011年埃及示威'},
  'باراک اوباما': {'ab': 'Барақ Обама',
   'ace': 'Barack Obama',
   'af': 'Barack Obama',
   'als': 'Barack Obama',
   'am': 'ባራክ ኦባማ',
   'an': 'Barack Obama',
   'ang': 'Barack Obama',
   'ar': 'باراك أوباما',
   'arc': 'ܒܪܐܩ ܐܘܒܐܡܐ',
   'arz': 'باراك اوباما',
   'as': "বাৰাক অ'বামা",
   'ast': 'Barack Obama',
   'av': 'Обама, Барак',
   'ay': 'Barack Obama',
   'az': 'Barak Obama',
   'azb': 'باراک اوباما',
   'ba': 'Барак Обама',
   'bar': 'Barack Obama',
   'bat-smg': 'Baraks Obama',
   'bcl': 'Barack Obama',
   'be': 'Барак Абама',
   'be-x-old': 'Барак Абама',
   'bg': 'Барак Обама',
   'bh': 'बराक ओबामा',
   'bi': 'Barak Obama',
   'bjn': 'Barack Obama',
   'bm': 'Barack Obama',
   'bn': 'বারাক ওবামা',
   'bo': 'བ་རག་ཨོ་པྰ་མ།',
   'br': 'Barack Obama',
   'bs': 'Barack Obama',
   'ca': 'Barack Obama',
   'cbk-zam': 'Barack Obama',
   'cdo': 'Barack Obama',
   'ce': 'Барак Обама',
   'ceb': 'Barack Obama',
   'chr': 'ᏆᎳᎩ ᎣᏆᎹ',
   'chy': "Netse Ôhmo'ôhtávaestse",
   'ckb': 'باراک ئۆباما',
   'co': 'Barack Obama',
   'crh': 'Barak Obama',
   'cs': 'Barack Obama',
   'cv': 'Барак Обама',
   'cy': 'Barack Obama',
   'da': 'Barack Obama',
   'de': 'Barack Obama',
   'diq': 'Barack Obama',
   'dsb': 'Barack Obama',
   'dv': 'ބަރަކް އޮބާމާ',
   'el': 'Μπαράκ Ομπάμα',
   'eml': 'Barack Obama',
   'en': 'Barack Obama',
   'eo': 'Barack Obama',
   'es': 'Barack Obama',
   'et': 'Barack Obama',
   'eu': 'Barack Obama',
   'ext': 'Barack Obama',
   'fi': 'Barack Obama',
   'fo': 'Barack Obama',
   'fr': 'Barack Obama',
   'frp': 'Barack Obama',
   'frr': 'Barack Obama',
   'fur': 'Barack Obama',
   'fy': 'Barack Obama',
   'ga': 'Barack Obama',
   'gan': '奧巴馬',
   'gd': 'Barack Obama',
   'gl': 'Barack Obama',
   'gn': 'Barack Obama',
   'gom': 'Barack Obama',
   'got': '𐌱𐌰𐍂𐌰𐌺 𐍉𐌱𐌰𐌼𐌰',
   'gv': 'Barack Obama',
   'ha': 'Barack Obama',
   'hak': 'Barack Obama',
   'haw': 'Barack Obama',
   'he': 'ברק אובמה',
   'hi': 'बराक ओबामा',
   'hif': 'Barack Obama',
   'hr': 'Barack Obama',
   'hsb': 'Barack Obama',
   'ht': 'Barack Obama',
   'hu': 'Barack Obama',
   'hy': 'Բարաք Օբամա',
   'ia': 'Barack Obama',
   'id': 'Barack Obama',
   'ie': 'Barack Obama',
   'ig': 'Barack Obama',
   'ilo': 'Barack Obama',
   'io': 'Barack Obama',
   'is': 'Barack Obama',
   'it': 'Barack Obama',
   'iu': 'ᐸᕌᒃ ᐅᐹᒪ',
   'ja': 'バラク・オバマ',
   'jbo': 'byRAK.obamas',
   'jv': 'Barack Obama',
   'ka': 'ბარაკ ობამა',
   'kaa': 'Barak Obama',
   'kab': 'Barack Obama',
   'kk': 'Барак Обама',
   'kl': 'Barack Obama',
   'km': 'បារ៉ាក់ អូបាម៉ា',
   'kn': 'ಬರಾಕ್ ಒಬಾಮ',
   'ko': '버락 오바마',
   'ks': 'بَراک اؤبامہ',
   'ksh': 'Barack Obama',
   'ku': 'Barack Obama',
   'kw': 'Barack Obama',
   'ky': 'Барак Обама',
   'la': 'Baracus Obama',
   'lad': 'Barack Obama',
   'lb': 'Barack Obama',
   'li': 'Barack Obama',
   'lij': 'Barack Obama',
   'lmo': 'Barack Obama',
   'ln': 'Barack Obama',
   'lo': 'ບາຣັກ ໂອບາມາ',
   'lt': 'Barack Obama',
   'ltg': 'Baraks Obama',
   'lv': 'Baraks Obama',
   'mai': 'बाराक ओबामा',
   'map-bms': 'Barack Obama',
   'mg': 'Barack Obama',
   'mhr': 'Обама, Барак',
   'mi': 'Barack Obama',
   'mk': 'Барак Обама',
   'ml': 'ബറാക്ക് ഒബാമ',
   'mn': 'Барак Обама',
   'mr': 'बराक ओबामा',
   'ms': 'Barack Obama',
   'mt': 'Barack Obama',
   'my': 'ဘာရက် အိုဘားမား',
   'myv': 'Обамань Барак',
   'mzn': 'باراک اوباما',
   'na': 'Barack Obama',
   'nah': 'Barack Obama',
   'nap': 'Barack Obama',
   'nds': 'Barack Obama',
   'nds-nl': 'Barack Obama',
   'ne': 'बाराक ओबामा',
   'new': 'बाराक ओबामा',
   'nl': 'Barack Obama',
   'nn': 'Barack Obama',
   'no': 'Barack Obama',
   'nrm': 'Barack Obama',
   'nso': 'Barack Obama',
   'nv': 'Hastiin alą́ąjįʼ dahsidáhígíí Barack Obama',
   'ny': 'Barack Obama',
   'oc': 'Barack Obama',
   'or': 'ବାରାକ ଓବାମା',
   'os': 'Обама, Барак',
   'pa': 'ਬਰਾਕ ਓਬਾਮਾ',
   'pag': 'Barack Obama',
   'pam': 'Barack Obama',
   'pap': 'Barack Obama',
   'pdc': 'Barack Obama',
   'pih': 'Barack Obama',
   'pl': 'Barack Obama',
   'pms': 'Barack Obama',
   'pnb': 'بارک اوبامہ',
   'ps': 'باراک حسين اوباما',
   'pt': 'Barack Obama',
   'qu': 'Barack Obama',
   'rm': 'Barack Obama',
   'ro': 'Barack Obama',
   'roa-tara': 'Barack Obama',
   'ru': 'Обама, Барак',
   'rue': 'Барак Обама',
   'rw': 'Barack Obama',
   'sa': 'बराक् ओबामा',
   'sah': 'Барак Обама',
   'sc': 'Barack Obama',
   'scn': 'Barack Obama',
   'sco': 'Barack Obama',
   'sd': 'بارڪ اوباما',
   'se': 'Barack Obama',
   'sh': 'Barack Obama',
   'si': 'බරාක් ඔබාමා',
   'simple': 'Barack Obama',
   'sk': 'Barack Obama',
   'sl': 'Barack Obama',
   'so': 'Baraak Obama',
   'sq': 'Barack Obama',
   'sr': 'Барак Обама',
   'srn': 'Barack Obama',
   'su': 'Barack Obama',
   'sv': 'Barack Obama',
   'sw': 'Barack Obama',
   'szl': 'Barack Obama',
   'ta': 'பராக் ஒபாமா',
   'te': 'బరాక్ ఒబామా',
   'tet': 'Barack Obama',
   'tg': 'Барак Обама',
   'th': 'บารัก โอบามา',
   'tk': 'Barak Obama',
   'tl': 'Barack Obama',
   'tpi': 'Barack Obama',
   'tr': 'Barack Obama',
   'tt': 'Барак Обама',
   'ty': 'Barack Obama',
   'ug': 'باراك ئوباما',
   'uk': 'Барак Обама',
   'ur': 'بارک اوباما',
   'uz': 'Barack Obama',
   'vec': 'Barack Obama',
   'vep': 'Obama Barak',
   'vi': 'Barack Obama',
   'vls': 'Barack Obama',
   'vo': 'Barack Obama',
   'wa': 'Barack Obama',
   'war': 'Barack Obama',
   'wuu': '巴拉克·奥巴马',
   'xmf': 'ბარაკ ობამა',
   'yi': 'באראק אבאמא',
   'yo': 'Barack Obama',
   'zea': 'Barack Obama',
   'zh': '贝拉克·奥巴马',
   'zh-min-nan': 'Barack Obama',
   'zh-yue': '奧巴馬',
   'zu': 'Barack Obama'},
  'بشار اسد': {'an': 'Baixar al-Assad',
   'ar': 'بشار الأسد',
   'arc': 'ܒܫܐܪ ܐܠܐܣܕ',
   'arz': 'بشار الاسد',
   'az': 'Bəşər Əsəd',
   'azb': 'بشار اسد',
   'bcl': 'Bashar al-Assad,',
   'be': 'Башар Асад',
   'bg': 'Башар Асад',
   'bn': 'বাশার আল-আসাদ',
   'br': 'Bashar al-Assad',
   'bs': 'Bašar el Asad',
   'ca': 'Baixar al-Àssad',
   'ce': 'Асад, Башар',
   'ckb': 'بەشار ئەسەد',
   'cs': 'Bašár al-Asad',
   'cy': 'Bashar al-Assad',
   'da': 'Bashar al-Assad',
   'de': 'Baschar al-Assad',
   'diq': 'Beşer Esad',
   'el': 'Μπασάρ αλ Άσαντ',
   'en': 'Bashar al-Assad',
   'eo': 'Baŝar al-Asad',
   'es': 'Bashar al-Ásad',
   'et': 'Bashshār al-Asad',
   'eu': 'Baxar al-Assad',
   'fi': 'Bašar al-Assad',
   'fr': 'Bachar el-Assad',
   'fy': 'Bashar al-Assad',
   'ga': 'Bashar al-Assad',
   'gl': 'Bashar al-Assad',
   'he': 'בשאר אל-אסד',
   'hi': 'बशर अल - असद',
   'hr': 'Bašar al-Asad',
   'hu': 'Bassár el-Aszad',
   'hy': 'Բաշշար ալ-Ասադ',
   'id': 'Bashar al-Assad',
   'ie': 'Bashar al-Assad',
   'io': 'Bashar al-Assad',
   'is': 'Bashar al-Assad',
   'it': 'Bashar al-Assad',
   'ja': 'バッシャール・アル=アサド',
   'ka': 'ბაშარ ალ-ასადი',
   'kk': 'Башар әл-Асад',
   'ko': '바샤르 알아사드',
   'ku': 'Beşar Esed',
   'la': 'Baššār al-Asad',
   'lt': 'Bašaras al-Asadas',
   'lv': 'Bašārs al Asads',
   'ml': 'ബഷാർ അൽ അസദ്',
   'mr': 'बशर अल-अस्साद',
   'ms': 'Basyar al-Assad',
   'nl': 'Bashar al-Assad',
   'nn': 'Bashar al-Assad',
   'no': 'Bashar al-Assad',
   'oc': 'Bashar al-Assad',
   'pa': 'ਬਸ਼ਰ ਅਲ-ਅਸਦ',
   'pam': 'Bashar al-Assad',
   'pap': 'Bashar al-Assad',
   'pl': 'Baszszar al-Asad',
   'pnb': 'بشار الاسد',
   'pt': 'Bashar al-Assad',
   'ro': 'Bashar al-Assad',
   'ru': 'Асад, Башар',
   'sah': 'Башар Асад',
   'scn': 'Bashar al-Assad',
   'sco': 'Bashar al-Assad',
   'sh': 'Bašar al-Asad',
   'simple': 'Bashar al-Assad',
   'sk': 'Baššár al-Asad',
   'sl': 'Bašar al Asad',
   'sq': 'Beshar el-Asad',
   'sr': 'Башар ел Асад',
   'sv': 'Bashar al-Assad',
   'ta': 'பசார் அல்-அசத்',
   'th': 'บัชชาร อัลอะซัด',
   'tr': 'Beşşar Esad',
   'tt': 'Bäşär Äsäd',
   'uk': 'Башар аль-Асад',
   'ur': 'بشار الاسد',
   'uz': 'Bashar al-Assad',
   'vep': 'Asad Bašar',
   'vi': 'Bashar al-Assad',
   'wuu': '巴入·阿萨德',
   'yi': 'באשער על אסאד',
   'yo': 'Bashar al-Assad',
   'zh': '巴沙尔·阿萨德',
   'zh-min-nan': 'Bashar al-Assad',
   'zh-yue': '巴沙爾'},
  'جان مک\u200cکین': {'an': 'John McCain',
   'ar': 'جون ماكين',
   'arz': 'جون ماكين',
   'az': 'Con Makkeyn',
   'bcl': 'John McCain',
   'be': 'Джон Сідні Мак-Кейн',
   'be-x-old': 'Джон Макейн',
   'bg': 'Джон Маккейн',
   'bi': 'John McCain',
   'bn': 'জন ম্যাককেইন',
   'bpy': 'জন ম্যাককেইন',
   'br': 'John McCain',
   'ca': 'John McCain',
   'ceb': 'John McCain',
   'cs': 'John McCain',
   'cy': 'John McCain',
   'da': 'John McCain',
   'de': 'John McCain',
   'el': 'Τζον Μακέιν',
   'en': 'John McCain',
   'eo': 'John McCain',
   'es': 'John McCain',
   'et': 'John McCain',
   'eu': 'John McCain',
   'fi': 'John McCain',
   'fo': 'John McCain',
   'fr': 'John McCain',
   'fy': 'John McCain',
   'ga': 'John McCain',
   'gd': 'John McCain',
   'gl': 'John McCain',
   'he': "ג'ון מקיין",
   'hr': 'John McCain',
   'hsb': 'John McCain',
   'hu': 'John McCain',
   'id': 'John McCain',
   'ilo': 'John McCain',
   'io': 'John McCain',
   'is': 'John McCain',
   'it': 'John McCain',
   'ja': 'ジョン・マケイン',
   'jv': 'John McCain',
   'ka': 'ჯონ მაკ-კეინი',
   'ko': '존 매케인',
   'ksh': 'John McCain',
   'la': 'Ioannes McCain',
   'lmo': 'John McCain',
   'lt': 'John McCain',
   'lv': 'Džons Makeins',
   'mk': 'Џон Мекејн',
   'ml': 'ജോൺ മക്കെയ്ൻ',
   'mn': 'Жон МакКэйн',
   'mr': 'जॉन मॅककेन',
   'ms': 'John McCain',
   'my': 'ဂျွန်မက်ကိန်း',
   'nds': 'John McCain',
   'nl': 'John McCain',
   'nn': 'John McCain',
   'no': 'John McCain',
   'nov': 'John McCain',
   'oc': 'John Mc Cain',
   'pdc': 'John McCain',
   'pl': 'John McCain',
   'pt': 'John McCain',
   'ro': 'John McCain',
   'ru': 'Маккейн, Джон',
   'scn': 'John McCain',
   'sco': 'John McCain',
   'sh': 'John McCain',
   'si': 'ජෝන් මැකේන්',
   'simple': 'John McCain',
   'sk': 'John McCain',
   'sl': 'John McCain',
   'sq': 'John McCain',
   'sr': 'Џон Мекејн',
   'sv': 'John McCain',
   'sw': 'John McCain',
   'ta': 'ஜான் மெக்கெய்ன்',
   'th': 'จอห์น แมคเคน',
   'tl': 'John McCain',
   'tr': 'John McCain',
   'uk': 'Джон Маккейн',
   'ur': 'جان مکین',
   'uz': 'John McCain',
   'vec': 'John McCain',
   'vep': 'Makkein Džon',
   'vi': 'John McCain',
   'wuu': '强·马凯恩',
   'yi': 'דזשאן מעקעין',
   'yo': 'John Mccain',
   'zh': '約翰·麥凱恩',
   'zh-min-nan': 'John McCain',
   'zh-yue': '麥堅'},
  'جهان عرب': {'ar': 'الوطن العربي',
   'arc': 'ܥܠܡܐ ܥܪܒܝܐ',
   'be': 'Арабскі свет',
   'bg': 'Арабски свят',
   'bn': 'আরব বিশ্ব',
   'ca': 'Països àrabs',
   'ckb': 'جیھانی عەرەب',
   'cs': 'Arabský svět',
   'cu': 'Аравьскꙑ странꙑ',
   'cy': 'Y Byd Arabaidd',
   'da': 'Arabiske verden',
   'de': 'Arabische Welt',
   'en': 'Arab world',
   'eo': 'Araba mondo',
   'es': 'Mundo árabe',
   'et': 'Araabia maad',
   'eu': 'Arabiar mundua',
   'fi': 'Arabimaailma',
   'fr': 'Monde arabe',
   'gag': 'Arab devletläri',
   'gl': 'Mundo árabe',
   'he': 'ארצות ערב',
   'hr': 'Arapski svijet',
   'hu': 'Arab államok',
   'hy': 'Արաբական աշխարհ',
   'id': 'Dunia Arab',
   'it': 'Mondo arabo',
   'ja': 'アラブ世界',
   'jv': 'Nagara-nagara Arab',
   'ka': 'არაბული სამყარო',
   'kg': 'Bansi ya balabu',
   'ko': '아랍권',
   'la': 'Orbis Arabicus',
   'lt': 'Arabų šalys',
   'lv': 'Arābu pasaule',
   'ml': 'അറബ് ലോകം',
   'mr': 'अरब राष्ट्रे',
   'ms': 'Dunia Arab',
   'nl': 'Arabische wereld',
   'nn': 'Den arabiske verda',
   'no': 'Den arabiske verden',
   'nv': 'Ásáí dinéʼiʼ bikéyah',
   'oc': 'Païses Arabis',
   'pa': 'ਅਰਬ ਜਗਤ',
   'pl': 'Kraje arabskie',
   'pt': 'Mundo árabe',
   'ro': 'Lumea arabă',
   'ru': 'Арабский мир',
   'sco': 'Arab warld',
   'sh': 'Arapski svijet',
   'si': 'අරාබි ලොව',
   'simple': 'Arab world',
   'sl': 'Arabski svet',
   'sq': 'Bota arabe',
   'sr': 'Арапски свет',
   'su': 'Dunya Arab',
   'sv': 'Arabvärlden',
   'th': 'โลกอาหรับ',
   'tr': 'Arap devletleri',
   'ug': 'ئەرەب ئەللىرى',
   'uk': 'Арабський світ',
   'ur': 'عرب ممالک',
   'vi': 'Thế giới Ả Rập',
   'wa': 'Monde arabe',
   'yi': 'אראבישע לענדער',
   'zh': '阿拉伯世界',
   'zh-yue': '阿剌伯'},
  'حازم الببلاوی': {'ar': 'حازم الببلاوي',
   'arz': 'حازم الببلاوى',
   'de': 'Hasim al-Beblawi',
   'el': 'Χάζεμ ελ Μπεμπλάουι',
   'en': 'Hazem El Beblawi',
   'es': 'Hazem el Beblaui',
   'fr': 'Hazem el-Beblawi',
   'he': 'חאזם אל-בבלאווי',
   'hi': 'हज़ेम बबलावी',
   'hu': 'Házem el-Beblávi',
   'it': 'Hazem al-Beblawi',
   'ja': 'ハーゼム・エル=ベブラーウィー',
   'la': 'Ḥāzim al-Bablāwi',
   'nl': 'Hazem al-Beblawi',
   'no': 'Hazem Al Beblawi',
   'pl': 'Hazim al-Biblawi',
   'pt': 'Hazem el-Beblaui',
   'ro': 'Hazem Al Beblawi',
   'ru': 'Аль-Баблауи, Хазем',
   'sco': 'Hazem Al Beblawi',
   'simple': 'Hazem Al Beblawi',
   'sr': 'Хазем ел Беблави',
   'sv': 'Hazem El-Beblawi',
   'tr': 'Hazım el-Beblavi',
   'uk': 'Хазем аль-Баблауї',
   'vi': 'Hazem Al Beblawi',
   'zh': '哈贊姆·貝伯拉威'},
  'حازم ببلاوی': {'ar': 'حازم الببلاوي',
   'arz': 'حازم الببلاوى',
   'de': 'Hasim al-Beblawi',
   'el': 'Χάζεμ ελ Μπεμπλάουι',
   'en': 'Hazem El Beblawi',
   'es': 'Hazem el Beblaui',
   'fr': 'Hazem el-Beblawi',
   'he': 'חאזם אל-בבלאווי',
   'hi': 'हज़ेम बबलावी',
   'hu': 'Házem el-Beblávi',
   'it': 'Hazem al-Beblawi',
   'ja': 'ハーゼム・エル=ベブラーウィー',
   'la': 'Ḥāzim al-Bablāwi',
   'nl': 'Hazem al-Beblawi',
   'no': 'Hazem Al Beblawi',
   'pl': 'Hazim al-Biblawi',
   'pt': 'Hazem el-Beblaui',
   'ro': 'Hazem Al Beblawi',
   'ru': 'Аль-Баблауи, Хазем',
   'sco': 'Hazem Al Beblawi',
   'simple': 'Hazem Al Beblawi',
   'sr': 'Хазем ел Беблави',
   'sv': 'Hazem El-Beblawi',
   'tr': 'Hazım el-Beblavi',
   'uk': 'Хазем аль-Баблауї',
   'vi': 'Hazem Al Beblawi',
   'zh': '哈贊姆·貝伯拉威'},
  'حبس ابد': {'ar': 'سجن مؤبد',
   'bg': 'Доживотен затвор',
   'ca': 'Presó perpètua',
   'cs': 'Doživotí',
   'da': 'Livsvarigt fængsel',
   'de': 'Lebenslange Freiheitsstrafe',
   'el': 'Ισόβια κάθειρξη',
   'en': 'Life imprisonment',
   'eo': 'Ĝismorta puno',
   'es': 'Cadena perpetua',
   'et': 'Eluaegne vangistus',
   'fi': 'Elinkautinen vankeus',
   'fr': 'Emprisonnement à perpétuité',
   'he': 'מאסר עולם',
   'hi': 'आजीवन कारावास',
   'hu': 'Életfogytiglan',
   'hy': 'Ցմահ բանտարկություն',
   'id': 'Penjara seumur hidup',
   'it': 'Ergastolo',
   'ja': '終身刑',
   'ko': '종신형',
   'lt': 'Įkalinimas iki gyvos galvos',
   'lv': 'Mūža ieslodzījums',
   'ml': 'ജീവപര്യന്തം തടവ്',
   'ms': 'Penjara seumur hidup',
   'nl': 'Levenslange gevangenisstraf',
   'no': 'Livsvarig fengsel',
   'pl': 'Kara dożywotniego pozbawienia wolności',
   'pt': 'Prisão perpétua',
   'ru': 'Пожизненное лишение свободы',
   'sh': 'Doživotni zatvor',
   'simple': 'Life imprisonment',
   'sk': 'Doživotný trest odňatia slobody',
   'sr': 'Доживотна робија',
   'sv': 'Livstids fängelse',
   'sw': 'Kifungo cha maisha',
   'ta': 'ஆயுள் தண்டனை',
   'te': 'యావజ్జీవ కారాగారశిక్ష',
   'tr': 'Müebbet hapis',
   'uk': 'Довічне позбавлення волі',
   'vi': 'Chung thân',
   'zh': '無期徒刑',
   'zh-yue': '終身監禁'},
  'رده:اعتراضات در جهان عرب (۲۰۱۰–۲۰۱۱)': {'ar': 'تصنيف:الربيع العربي',
   'az': 'Kateqoriya:Ərəb ölkələrində etiraz dalğası (2010-2011)',
   'be': 'Катэгорыя:Арабская вясна',
   'bg': 'Категория:Арабски протести (2010 – 2011)',
   'ca': 'Categoria:Primavera Àrab',
   'ckb': 'پۆل:بەھاری عەرەبی',
   'cs': 'Kategorie:Arabské jaro',
   'cy': "Categori:Protestiadau'r Dwyrain Canol a Gogledd Affrica, 2010–2011",
   'da': 'Kategori:Protesterne i den arabiske verden 2010-2011',
   'de': 'Kategorie:Arabischer Frühling',
   'diq': 'Kategori:Wesarê Erebi',
   'el': 'Κατηγορία:Αραβική Άνοιξη',
   'en': 'Category:Arab Spring',
   'eo': 'Kategorio:Protestoj en la araba mondo en 2010 kaj 2011',
   'es': 'Categoría:Protestas en el mundo árabe de 2010-2011',
   'eu': 'Kategoria:Arabiar Udaberria',
   'fi': 'Luokka:Arabikevät',
   'fr': 'Catégorie:Printemps arabe',
   'he': 'קטגוריה:האביב הערבי',
   'hu': 'Kategória:2010–2011-es tüntetések az arab világban',
   'id': 'Kategori:Kebangkitan dunia Arab',
   'it': 'Categoria:Proteste nel mondo arabo del 2010-2011',
   'ja': 'Category:アラブの春',
   'ko': '분류:아랍의 봄',
   'ku': 'Kategorî:Bihara erebî',
   'mk': 'Категорија:Арапска пролет',
   'ms': 'Kategori:Bantahan dunia Arab 2010–2011',
   'nl': 'Categorie:Arabische Lente',
   'nn': 'Kategori:Den arabiske våren',
   'no': 'Kategori:Den arabiske våren',
   'pl': 'Kategoria:Arabska wiosna',
   'pt': 'Categoria:Primavera Árabe',
   'ro': 'Categorie:Protestele din lumea arabă din 2010-2011',
   'ru': 'Категория:Арабская весна',
   'sr': 'Категорија:Арапско пролеће',
   'sv': 'Kategori:Arabiska våren',
   'th': 'หมวดหมู่:อาหรับสปริง',
   'tr': 'Kategori:Arap Baharı',
   'uk': 'Категорія:Арабська весна',
   'ur': 'زمرہ:عرب بہار',
   'vi': 'Thể loại:Mùa xuân Ả Rập',
   'zh': 'Category:阿拉伯之春',
   'zh-min-nan': 'Lūi-pia̍t:A-la-pek chi Chhun'},
  'زره پوش': {'ar': 'ناقلة جنود مدرعة',
   'be': 'Бронетранспарцёр',
   'be-x-old': 'Бронетранспартэр',
   'bg': 'Бронетранспортьор',
   'bn': 'আর্মার্ড পার্সোনেল ক্যারিয়ার',
   'ca': 'Transport blindat de personal',
   'cs': 'Obrněný transportér',
   'da': 'Pansret mandskabsvogn',
   'de': 'Mannschaftstransportwagen (Militär)',
   'el': 'Τεθωρακισμένο όχημα μεταφοράς προσωπικού',
   'en': 'Armoured personnel carrier',
   'eo': 'Kirasita transportilo',
   'es': 'Transporte blindado de personal',
   'et': 'Soomustransportöör',
   'fi': 'Panssaroitu miehistönkuljetusvaunu',
   'fr': 'Véhicule de transport de troupes',
   'he': 'נגמ"ש',
   'hr': 'Oklopni transporter',
   'hy': 'Զրահափոխադրիչ',
   'id': 'Pengangkut personel lapis baja',
   'it': 'Veicolo trasporto truppe',
   'ja': '装甲兵員輸送車',
   'ka': 'ჯავშანტრანსპორტიორი',
   'kk': 'Бронетранспортер',
   'ko': '병력수송장갑차',
   'la': 'Vehiculum operariorum armatum',
   'lt': 'Šarvuotasis transporteris',
   'mn': 'Ангилал:Хуягт тээвэрлэгчүүд',
   'ms': 'Pengangkut anggota berperisai',
   'nl': 'Pantserinfanterievoertuig',
   'no': 'Pansret personellkjøretøy',
   'pl': 'Transporter opancerzony',
   'pt': 'Veículo blindado de transporte de pessoal',
   'ro': 'Transportor blindat pentru trupe',
   'ru': 'Бронетранспортёр',
   'sh': 'Oklopni transporter',
   'sk': 'Obrnený transportér',
   'sl': 'Oklepni transporter',
   'sr': 'Оклопни транспортер',
   'sv': 'Pansarskyttefordon',
   'tr': 'Zırhlı personel taşıyıcı',
   'uk': 'Бронетранспортер',
   'uz': 'Bronetransportyor',
   'vi': 'Xe bọc thép chở quân',
   'yi': 'געפאנצערטער סאלדאטן טראנספארט',
   'zh': '装甲输送车'},
  'سعود الفیصل': {'ar': 'سعود الفيصل بن عبد العزيز آل سعود',
   'de': 'Saud ibn Faisal',
   'en': 'Saud bin Faisal bin Abdulaziz Al Saud',
   'fr': 'Saoud ben Fayçal ben Abdelaziz Al Saoud',
   'id': 'Saud bin Faisal bin Abdul Aziz Al Saud',
   'it': "Sa'ud bin Faysal bin Abd al-Aziz Al Sa'ud",
   'ja': 'サウード・アル=ファイサル',
   'la': 'Saʿūd ibn Fayṣal ibn ʿAbd al-ʿAzīz',
   'lb': 'Saud ibn Faisal',
   'pl': 'Su’ud ibn Fajsal ibn Abd al-Aziz Al Su’ud',
   'ps': 'سعود الفیصل',
   'ru': 'Сауд ибн Фейсал ибн Абдул-Азиз Аль Сауд',
   'simple': 'Saud bin Faisal',
   'tr': 'Suud bin Faysal bin Abdülaziz El Suud',
   'ur': 'سعود الفیصل'},
  'سوئز': {},
  'سوئز (شهر)': {'af': 'Suez',
   'ar': 'السويس',
   'arz': 'السويس',
   'be': 'Горад Суэц',
   'bg': 'Суец',
   'bs': 'Suez',
   'ca': 'Suez',
   'ce': 'Сувайс',
   'ceb': 'Suez (kapital sa lalawigan sa Ehipto)',
   'cs': 'Suez',
   'csb': 'Suez',
   'da': 'Suez',
   'de': 'Sues',
   'el': 'Σουέζ',
   'en': 'Suez',
   'eo': 'Suezo',
   'es': 'Suez',
   'et': 'Suess',
   'eu': 'Suez',
   'fi': 'Suez',
   'fr': 'Suez (ville)',
   'fy': 'Suez',
   'ga': 'Suais',
   'he': 'סואץ (עיר)',
   'hr': 'Suez',
   'hu': 'Szuez',
   'hy': 'Սուեզ',
   'id': 'Suez',
   'ilo': 'Suez',
   'is': 'Súes',
   'it': 'Suez',
   'ja': 'スエズ',
   'jv': 'Suèz',
   'ka': 'სუეცი',
   'kl': 'Suez',
   'ko': '수에즈',
   'la': 'Suesia',
   'lt': 'Suecas',
   'lv': 'Sueca',
   'mr': 'सुएझ',
   'ms': 'Suez',
   'nl': 'Suez',
   'nn': 'Suez',
   'no': 'Suez',
   'oc': 'Suèz (vila)',
   'pl': 'Suez',
   'pt': 'Suez',
   'ro': 'Suez',
   'ru': 'Суэц',
   'sco': 'Suez',
   'sh': 'Suec',
   'simple': 'Suez',
   'sk': 'Suez (mesto)',
   'sq': 'Suezi',
   'sr': 'Суец',
   'sv': 'Suez',
   'sw': 'Suez',
   'tr': 'Süveyş',
   'uk': 'Суец',
   'ur': 'سوئیز',
   'war': 'Suez',
   'zh': '苏伊士',
   'zh-yue': '蘇伊士'},
  'عبدالفتاح السیسی': {'ar': 'عبد الفتاح السيسي',
   'arz': 'عبد الفتاح السيسى',
   'az': 'Əbdül Fəttah əs-Sisi',
   'bg': 'Абдел Фатах Сиси',
   'ca': 'Abdelfatah Al-Sisi',
   'ckb': 'عەبدولفەتاح ئەلسیسی',
   'cs': 'Abd al-Fattáh as-Sísí',
   'da': 'Abdel Fatah al-Sisi',
   'de': 'Abd al-Fattah as-Sisi',
   'el': 'Αμπντέλ Φατάχ αλ Σίσι',
   'en': 'Abdel Fattah el-Sisi',
   'es': 'Abdelfatah Al-Sisi',
   'et': '‘Abd al-Fattāḩ Khalīl as-Sīsī',
   'fi': 'Abdel Fattah al-Sisi',
   'fr': 'Abdel Fattah al-Sissi',
   'ga': 'Abdel Fattah el-Sisi',
   'gl': 'Abdul Fatah al-Sisi',
   'he': 'עבד אל-פתאח א-סיסי',
   'hr': 'Abdel Fatah al-Sisi',
   'hy': 'Աբդել Ֆաթթահ Ալ-Սիսի',
   'id': 'Abdul Fattah as-Sisi',
   'it': 'Abd al-Fattah al-Sisi',
   'ja': 'アブドルファッターフ・アッ=シーシー',
   'ka': 'აბდულ-ფათაჰ ალ-სისი',
   'ko': '압둘팟타흐 시시',
   'la': 'Abd al-Fattāḥ al-Sīsī',
   'lb': 'Abdel Fattah al-Sissi',
   'ml': 'അബ്ദൾ ഫത്ത അൽസിസി',
   'mr': 'अब्देल फताह एल-सिसी',
   'ms': 'Abdel Fattah al-Sisi',
   'mzn': 'عبدالفتاح السیسی',
   'nl': 'Abdul Fatah al-Sisi',
   'no': 'Abdel Fattah al-Sisi',
   'oc': 'Abd al-Fattah al-Sissi',
   'pa': 'ਅਬਦਲ ਫਾਤਹ ਅਲ-ਸੀਸੀ',
   'pl': 'Abd al-Fattah as-Sisi',
   'pt': 'Abdul Fatah Khalil Al-Sisi',
   'ro': 'Abdel Fattah el-Sisi',
   'ru': 'Ас-Сиси, Абдул-Фаттах Халил',
   'sco': 'Abdel Fattah el-Sisi',
   'sh': 'Abdel Fatah al-Sisi',
   'simple': 'Abdel Fattah el-Sisi',
   'sr': 'Абдел Фатах ел Сиси',
   'sv': 'Abd al-Fattah al-Sisi',
   'ta': 'அப்துல் பத்தா அல்-சிசி',
   'tg': 'Абду Фатаҳ Халил Ал-Сийсӣ',
   'tl': 'Abdel Fattah el-Sisi',
   'tr': 'Abdülfettah el-Sisi',
   'uk': 'Абдель Фаттах Ас-Сісі',
   'ur': 'عبدالفتاح السیسی',
   'uz': 'Abdulfattoh as-Sisiy',
   'vi': 'Abdel Fattah el-Sisi',
   'zh': '阿卜杜勒-法塔赫·塞西'},
  'عبدالله بن عبدالعزیز': {'af': 'Abdoellah van Saoedi-Arabië',
   'ar': 'عبد الله بن عبد العزيز آل سعود',
   'arz': 'عبد الله بن عبد العزيز ال سعود',
   'az': 'Abdullah bin Əbdüləziz əs-Səud',
   'azb': 'عبدالله بن عبدالعزیز',
   'ba': 'Ғабдулла ибн Ғәбдел Ғәзиз әс-Сәғүд',
   'bat-smg': 'Abdula ibn Abdilazėzos Al Saudos',
   'be': 'Абдала ібн Абдэль Азіз ас-Сауд',
   'be-x-old': 'Абдала ібн Абдэль Азыз ас-Сауд',
   'bg': 'Абдула бин Абдул Азис',
   'bn': 'আবদুল্লাহ বিন আবদুল আজিজ',
   'bs': 'Abdullah bin Abdulaziz al-Saud',
   'ca': "Abdul·lah de l'Aràbia Saudita",
   'ce': 'ӀабдуллахӀ бин Ӏабдул-Ӏазиз Аль СаӀуд',
   'ckb': 'عەبدوڵڵا کوڕی عەبدولعەزیز',
   'cs': 'Abd Alláh bin Abd al-Azíz',
   'cy': 'Abdullah, brenin Sawdi Arabia',
   'da': 'Abdullah af Saudi-Arabien',
   'de': 'Abdullah ibn Abd al-Aziz',
   'el': 'Αμπντουλάχ της Σαουδικής Αραβίας',
   'en': 'Abdullah of Saudi Arabia',
   'eo': 'Abdulah bin Abdul-Aziz Al Saud',
   'es': 'Abdalá bin Abdulaziz',
   'et': '‘Abd Allāh ibn ‘Abd al-‘Azīz Āl Sa‘ūd',
   'eu': 'Abdullah Saudi Arabiakoa',
   'fi': 'Abdullah',
   'fr': 'Abdallah ben Abdelaziz Al Saoud',
   'gl': 'Abdalá I',
   'he': 'עבדאללה, מלך ערב הסעודית',
   'hi': 'शाह अब्दुल्ला',
   'hr': 'Abdullah bin Abdulaziz al-Saud',
   'hu': 'Abdullah szaúdi király',
   'hy': 'Աբդուլլահ իբն Աբդուլ-Ազիզ ալ-Սաուդ',
   'id': 'Abdullah dari Arab Saudi',
   'is': 'Abdullah bin Abdul Aziz al-Saud',
   'it': "Abd Allah dell'Arabia Saudita",
   'ja': 'アブドゥッラー・ビン・アブドゥルアズィーズ',
   'jv': 'Abdullah saking Arab Saudi',
   'ka': 'აბდულა (საუდის არაბეთი)',
   'kk': 'Абдулла ибн Абд әл-Ғазиз әл Сауд',
   'ko': '압둘라 빈 압둘아지즈 알사우드',
   'la': 'ʿAbd Allāh ibn ʿAbd al-ʿAzīz',
   'lb': 'Abdullah ibn Abd al-Aziz',
   'lv': 'Abdulla Saūds',
   'min': 'Abdullah dari Arab Saudi',
   'ml': 'അബ്ദുല്ല രാജാവ്',
   'mr': 'अब्दुल्ला, सौदी अरेबिया',
   'ms': 'Abdullah ibn Abdul Aziz Al-Saud',
   'mzn': 'عبدالله بن عبدالعزیز',
   'nl': 'Abdoellah bin Abdoel Aziz al-Saoed',
   'nn': 'Abdullah av Saudi-Arabia',
   'no': 'Abdullah av Saudi-Arabia',
   'oc': 'Abdallah bin ʿAbd al-ʿAzīz ʾĀl Saʿūd',
   'pa': 'ਅਬਦੁੱਲਾ, ਸਾਊਦੀ ਅਰਬ',
   'pl': 'Abd Allah ibn Abd al-Aziz Al Su’ud',
   'pms': "Abdullah dl'Arabia Saodita",
   'pnb': 'عبداللہ بن عبدالعزیز',
   'ps': 'عبدالله بن عبدالعزیز آل سعود',
   'pt': 'Abdullah da Arábia Saudita',
   'qu': 'Abdullah bin Abdul-Aziz',
   'ro': 'Abdullah bin Abdulaziz al-Saud',
   'ru': 'Абдалла ибн Абдул-Азиз Аль Сауд',
   'scn': 'Abdullah bin Abdulaziz al-Saud',
   'sco': 'Abdullah o Saudi Arabie',
   'sd': 'عبدالله بن عبدالعزيز',
   'sh': 'Abdulah od Saudijske Arabije',
   'si': 'අබ්දුල්ලා රජ, සවුදි අරාබිය',
   'simple': 'Abdullah of Saudi Arabia',
   'sk': 'Abd Alláh ibn Abd al-Azíz',
   'sr': 'Абдулах од Саудијске Арабије',
   'su': 'Abdullah ti Saudi Arabia',
   'sv': 'Abdullah bin Abdul Aziz',
   'ta': 'சவூதி அரேபியாவின் அப்துல்லா',
   'th': 'สมเด็จพระราชาธิบดีอับดุลลอห์ บิน อับดัลอะซิซ อาล สะอูด',
   'tl': 'Abdullah ng Saudi Arabia',
   'tr': 'Abdullah bin Abdülaziz el-Suud',
   'uk': 'Абдалла ібн Абдель Азіз Аль Сауд',
   'ur': 'عبداللہ بن عبدالعزیز آل سعود',
   'uz': 'Abdulloh ibn Abdulaziz as-Saud',
   'vi': 'Abdullah bin Abdulaziz al-Saud',
   'yi': 'אבדאללא, קעניג פון סאודי',
   'yo': 'Abdullah ilẹ̀ Sáúdí Arábíà',
   'zh': '阿卜杜拉·本·阿卜杜勒-阿齐兹·阿勒沙特',
   'zh-classical': '阿卜杜拉·本·阿卜杜勒-阿齊茲·沙特',
   'zh-min-nan': 'Abdullah bin Abdulaziz',
   'zh-yue': '阿卜杜拉·賓·阿卜杜-阿兹兹·阿爾-沙地'},
  'عدلی منصور': {'ar': 'عدلي منصور',
   'arz': 'عدلى منصور',
   'az': 'Ədli Mənsur',
   'be': 'Адлі Мансур',
   'ca': 'Adly Mansur',
   'ckb': 'عەدلی مەنسوور',
   'da': 'Adly Mansour',
   'de': 'Adli Mansur',
   'el': 'Αντλί Μανσούρ',
   'en': 'Adly Mansour',
   'es': 'Adli Mansur',
   'fi': 'Adli Mansur',
   'fr': 'Adli Mansour',
   'he': 'עדלי מנסור',
   'hr': 'Adli Mansur',
   'hu': 'Adli Manszúr',
   'id': 'Adli Mansur',
   'it': 'Adli Mansur',
   'ja': 'アドリー・マンスール',
   'ka': 'ადლი მანსური',
   'ko': '아들리 만수르',
   'la': 'Adlī Manṣūr',
   'nl': 'Adly Mansour',
   'no': 'ʿAdlī Manṣūr',
   'oc': 'Adli Mansor',
   'pl': 'Adli Mansur',
   'pt': 'Adly Mansur',
   'ro': 'Adli Mansour',
   'ru': 'Мансур, Адли',
   'sco': 'Adly Mansour',
   'simple': 'Adly Mansour',
   'sr': 'Адли Мансур',
   'sv': 'Adli Mansour',
   'tr': 'Adli Mansur',
   'tt': 'Гадли Мансур',
   'uk': 'Адлі Мансур',
   'vi': 'Adly Mansour',
   'zh': '阿德利·曼苏尔'},
  'عریش': {'ar': 'العريش',
   'arz': 'العريش',
   'bg': 'Ариш',
   'ca': 'Al-Arix',
   'ceb': 'Arish',
   'cs': 'Aríš',
   'da': 'Al-Arish',
   'de': 'Al-Arisch',
   'el': 'Αρίς',
   'en': 'Arish',
   'eo': 'El Ariŝ',
   'es': 'El Arish',
   'et': 'Al-‘Arīsh',
   'fr': 'El-Arich',
   'he': 'אל עריש',
   'hi': 'अरीश',
   'hu': 'El-Arís',
   'id': 'El Arish',
   'it': 'Al-Arish',
   'ja': 'アリーシュ',
   'jv': "Al 'Arish",
   'ka': 'ელ-არიში',
   'kk': 'Эль-Ариш',
   'ko': '아리시',
   'lt': 'Arišas',
   'ms': 'Arish',
   'nl': 'El Arish',
   'no': 'Al-Arish',
   'pl': 'Al-Arisz',
   'pt': 'Alarixe',
   'ru': 'Эль-Ариш',
   'sco': 'Arish',
   'sq': 'Arishi',
   'sr': 'Ариш (град)',
   'sv': 'Al-Arish',
   'tr': 'El-Ariş',
   'uk': 'Ель-Аріш',
   'ur': 'عریش',
   'war': 'Arish',
   'yi': 'על אריש',
   'zh': '阿里什'},
  'قاهره': {'ace': 'Al-Qahirah',
   'ady': 'Каир',
   'af': 'Kaïro',
   'ak': 'Cairo',
   'als': 'Kairo',
   'am': 'ካይሮ',
   'an': 'O Caire',
   'ar': 'القاهرة',
   'arz': 'القاهره',
   'ast': 'El Cairo',
   'av': 'Каир',
   'az': 'Qahirə',
   'azb': 'قاهیره',
   'ba': 'Ҡаһирә',
   'bat-smg': 'Kairs',
   'bcl': 'Cairo',
   'be': 'Горад Каір',
   'be-x-old': 'Каір',
   'bg': 'Кайро',
   'bh': 'काहिरा',
   'bn': 'কায়রো',
   'bo': 'ཁ་ཡི་རོ',
   'br': 'Kaero',
   'bs': 'Kairo',
   'bxr': 'Каир',
   'ca': 'El Caire',
   'cdo': 'Cairo',
   'ce': 'КъахӀира',
   'ceb': 'Cairo',
   'ckb': 'قاھیرە',
   'crh': 'Qaire',
   'cs': 'Káhira',
   'csb': 'Kairo',
   'cv': 'Каир',
   'cy': 'Cairo',
   'da': 'Kairo',
   'de': 'Kairo',
   'diq': 'Qahira',
   'dsb': 'Kairo',
   'el': 'Κάιρο',
   'en': 'Cairo',
   'eo': 'Kairo',
   'es': 'El Cairo',
   'et': 'Kairo',
   'eu': 'Kairo',
   'ext': 'El Cairu',
   'fi': 'Kairo',
   'fiu-vro': 'Kairo',
   'fo': 'Keiro',
   'fr': 'Le Caire',
   'frp': 'Lo Cayiro',
   'frr': 'Kairo',
   'fy': 'Kairo',
   'ga': 'Caireo',
   'gd': 'Cairo',
   'gl': 'O Cairo',
   'gv': 'Cairo',
   'hak': 'Cairo',
   'he': 'קהיר',
   'hi': 'काहिरा',
   'hif': 'Cairo',
   'hr': 'Kairo',
   'hsb': 'Kairo',
   'ht': 'Li Kè',
   'hu': 'Kairó',
   'hy': 'Կահիրե',
   'id': 'Kairo',
   'ie': 'Cairo',
   'ilo': 'Cairo',
   'io': 'Kairo',
   'is': 'Kaíró',
   'it': 'Il Cairo',
   'ja': 'カイロ',
   'jv': 'Kairo',
   'ka': 'კაირო',
   'kaa': 'Al-Qahira',
   'kab': 'Taqahirt',
   'ki': 'Cairo',
   'kk': 'Каир',
   'kl': 'Cairo',
   'kn': 'ಕೈರೋ',
   'ko': '카이로',
   'ku': 'Qahîre',
   'kv': 'Каир',
   'kw': 'Cairo',
   'ky': 'Каир',
   'la': 'Cairus',
   'lad': 'El Kairo',
   'lb': 'Kairo',
   'lbe': 'Кьагьира',
   'lez': 'Каир',
   'li': 'Caïro',
   'lij': 'O Cairo',
   'lmo': 'El Cairo',
   'ln': 'Kairo',
   'lrc': 'قاهره',
   'lt': 'Kairas',
   'lv': 'Kaira',
   'mdf': 'Каир',
   'mg': 'Kairo',
   'mhr': 'Каир',
   'min': 'Kairo',
   'mk': 'Каиро',
   'ml': 'കെയ്റോ',
   'mn': 'Каир',
   'mr': 'कैरो',
   'mrj': 'Каир',
   'ms': 'Kaherah',
   'mwl': 'Cairo',
   'my': 'ကိုင်ရိုမြို့',
   'mzn': 'قاهره',
   'na': 'Cairo',
   'nah': 'In Cairo',
   'nap': "'O Cairo",
   'new': 'कायरो',
   'nl': 'Caïro (stad)',
   'nn': 'Kairo',
   'no': 'Kairo',
   'ny': 'Cairo',
   'oc': 'Lo Caire',
   'olo': 'Kairo',
   'os': 'Каир',
   'pa': 'ਕਾਹਿਰਾ',
   'pap': 'Kairo',
   'pl': 'Kair',
   'pms': 'Ël Càiro',
   'pnb': 'قاہرہ',
   'pnt': 'Κάιρον',
   'ps': 'قاهره',
   'pt': 'Cairo',
   'qu': 'Qahira',
   'rm': 'Cairo',
   'ro': 'Cairo',
   'roa-tara': "'U Cairo",
   'ru': 'Каир',
   'rue': 'Кагіра',
   'sah': 'Каир',
   'sc': 'Cairo',
   'scn': 'Cairu',
   'sco': 'Cairo',
   'se': 'Kairo',
   'sh': 'Kairo',
   'simple': 'Cairo',
   'sk': 'Káhira',
   'sl': 'Kairo',
   'sn': 'Cairo',
   'so': 'Qaahiro',
   'sq': 'Kajro',
   'sr': 'Каиро',
   'su': 'Kairo',
   'sv': 'Kairo',
   'sw': 'Kairo',
   'szl': 'Kajir',
   'ta': 'கெய்ரோ',
   'te': 'కైరో',
   'tg': 'Қоҳира',
   'th': 'ไคโร',
   'tk': 'Kair',
   'tl': 'Cairo',
   'tpi': 'Kairo',
   'tr': 'Kahire',
   'tt': 'Каһирә',
   'tw': 'Kairo',
   'udm': 'Каир',
   'ug': 'كايرو',
   'uk': 'Каїр',
   'ur': 'قاہرہ',
   'uz': 'Qohira',
   'vec': 'El Cairo',
   'vep': 'Kair',
   'vi': 'Cairo',
   'vls': 'Caïro',
   'vo': 'Kahirä',
   'wa': 'El Caire',
   'war': 'Cairo',
   'wo': 'Xayra',
   'wuu': '开罗',
   'xal': 'Каир балһсн',
   'xmf': 'კაირო',
   'yi': 'קיירא',
   'yo': 'Káírò',
   'zea': 'Caïro (stad)',
   'zh': '开罗',
   'zh-min-nan': 'Cairo',
   'zh-yue': '開羅'},
  'لیندزی گراهام (صفحه وجود ندارد)': {},
  'مجلس سنای آمریکا': {'ar': 'مجلس الشيوخ الأمريكي',
   'be': 'Сенат ЗША',
   'bg': 'Сенат на САЩ',
   'br': 'Sened ar Stadoù-Unanet',
   'bs': 'Senat Sjedinjenih Američkih Država',
   'ca': 'Senat dels Estats Units',
   'cs': 'Senát Spojených států amerických',
   'cy': 'Senedd yr Unol Daleithiau',
   'da': 'Senatet (USA)',
   'de': 'Senat der Vereinigten Staaten',
   'el': 'Γερουσία (ΗΠΑ)',
   'en': 'United States Senate',
   'eo': 'Usona Senato',
   'es': 'Senado de los Estados Unidos',
   'et': 'Ameerika Ühendriikide Senat',
   'eu': 'Ameriketako Estatu Batuetako Senatua',
   'fi': 'Yhdysvaltain senaatti',
   'fo': 'Senatið í USA',
   'fr': 'Sénat des États-Unis',
   'fy': 'Amerikaanske Senaat',
   'ga': 'Seanad Stáit Aontaithe Mheiriceá',
   'gl': 'Senado dos Estados Unidos de América',
   'hak': 'Mî-koet Chhâm-ngi-yèn',
   'he': 'הסנאט של ארצות הברית',
   'hi': 'अमेरिकी सीनेट',
   'hr': 'Senat Sjedinjenih Američkih Država',
   'hu': 'Az Amerikai Egyesült Államok szenátusa',
   'id': 'Senat Amerika Serikat',
   'io': 'Usana Senato',
   'is': 'Öldungadeild Bandaríkjaþings',
   'it': "Senato (Stati Uniti d'America)",
   'ja': 'アメリカ合衆国上院',
   'jv': 'Senat Amérika Sarékat',
   'ka': 'აშშ-ის სენატი',
   'ko': '미국 상원',
   'ku': 'Senatoya Dewletên Yekbûyî yên Amerîkayê',
   'kw': 'Senedh Statys Unys',
   'la': 'Senatus Civitatum Foederatarum Americae',
   'lmo': 'Senad di Stat Unii',
   'lt': 'Jungtinių Valstijų Senatas',
   'lv': 'ASV Senāts',
   'mk': 'Сенат на Соединетите Американски Држави',
   'mn': 'Америкийн Нэгдсэн Улсын Сенат',
   'mr': 'अमेरिकेची सेनेट',
   'ms': 'Senat Amerika Syarikat',
   'nds': 'Senat (USA)',
   'nl': 'Senaat (Verenigde Staten)',
   'nn': 'Senatet i USA',
   'no': 'USAs senat',
   'oc': "Senat dels Estats Units d'America",
   'pl': 'Senat Stanów Zjednoczonych',
   'pt': 'Senado dos Estados Unidos',
   'ro': 'Senatul Statelor Unite ale Americii',
   'ru': 'Сенат США',
   'sco': 'Unitit States Senate',
   'sh': 'Senat SAD',
   'simple': 'United States Senate',
   'sk': 'Senát Spojených štátov',
   'sl': 'Senat Združenih držav Amerike',
   'sr': 'Сенат Сједињених Америчких Држава',
   'sv': 'USA:s senat',
   'sw': 'Senati (Marekani)',
   'ta': 'மேலவை (ஐக்கிய அமெரிக்கா)',
   'th': 'วุฒิสภาสหรัฐ',
   'tl': 'Senado ng Estados Unidos',
   'tr': 'Amerika Birleşik Devletleri Senatosu',
   'tt': 'AQŞ Senatı',
   'uk': 'Сенат США',
   'ur': 'ریاستہائے متحدہ سینٹ',
   'vi': 'Thượng viện Hoa Kỳ',
   'xmf': 'ააშ-იშ სენატი',
   'yi': 'סענאט',
   'zh': '美国参议院',
   'zh-yue': '美國參議院'},
  'محمد البرادعی': {'ar': 'محمد البرادعي',
   'arz': 'محمد البرادعى',
   'az': 'Məhəmməd Əl-Baradei',
   'be': 'Махамед аль-Барадэі',
   'be-x-old': 'Махамад аль-Барадэі',
   'bg': 'Мохамед ел-Барадей',
   'bo': 'ཨེལ་བྷ་ར་སྒྲེ།',
   'ca': 'Mohamed al-Baradei',
   'cs': 'Muhammad Baradej',
   'da': 'Mohammed el-Baradei',
   'de': 'Mohammed el-Baradei',
   'el': 'Μοχάμεντ Ελ Μπαραντέι',
   'en': 'Mohamed ElBaradei',
   'eo': 'Mohamed ElBaradei',
   'es': 'Mohamed el-Baradei',
   'et': 'Muḩammad al-Barāda‘ī',
   'eu': 'Mohamed ElBaradei',
   'fi': 'Mohamed ElBaradei',
   'fr': 'Mohamed el-Baradei',
   'ga': 'Mohamed ElBaradei',
   'he': 'מוחמד אל-בראדעי',
   'hi': 'मोहम्मद अलबारदेई',
   'hr': 'Mohamed ElBaradei',
   'hu': 'Mohammed el-Barádei',
   'id': 'Mohamed ElBaradei',
   'is': 'Mohamed ElBaradei',
   'it': "Muhammad al-Barade'i",
   'ja': 'モハメド・エルバラダイ',
   'ka': 'მოჰამედ ალ-ბარადეი',
   'ko': '무함마드 엘바라데이',
   'ku': 'Mohamed El-Baradei',
   'la': "Mahometus al-Barāda'ī",
   'lb': 'Mohamed ElBaradei',
   'lv': 'Mohameds El Barādeī',
   'ml': 'മുഹമ്മദ്\u200c എൽബറാദി',
   'mzn': 'محمد البرادعی',
   'nds': 'Mohammed el-Baradei',
   'nl': 'Mohammed el-Baradei',
   'nn': 'Mohamed ElBaradei',
   'no': 'Mohamed ElBaradei',
   'pl': 'Muhammad el-Baradei',
   'pnb': 'محمد البارا',
   'pt': 'Mohamed ElBaradei',
   'qu': 'Mohamed ElBaradei',
   'ro': 'Mohamed El Baradei',
   'ru': 'Эль-Барадеи, Мохаммед',
   'sco': 'Mohamed ElBaradei',
   'sh': 'Mohamed ElBaradei',
   'simple': 'Mohamed ElBaradei',
   'sl': 'Mohamed El-Baradej',
   'sv': 'Mohamed ElBaradei',
   'ta': 'முகம்மது அல்-பராதிய்',
   'th': 'มุฮัมมัด อัลบะรอดะอี',
   'tr': 'Muhammed el-Baradey',
   'uk': 'Мухаммед аль-Барадаї',
   'ur': 'محمد البرادعی',
   'uz': 'Muhammad Al-Baradei',
   'vi': 'Mohamed ElBaradei',
   'yo': 'Mohamed ElBaradei',
   'zh': '穆罕默德·巴拉迪'},
  'محمد مرسی': {'ar': 'محمد مرسي',
   'arz': 'محمد مرسى',
   'av': 'МухІаммад Мурси',
   'az': 'Məhəmməd Morsi',
   'bar': 'Mohammed Mursi',
   'be': 'Мухамед Мурсі',
   'bg': 'Мохамад Морси',
   'bjn': 'Muhammad Mursi',
   'bn': 'মুহাম্মাদ মুরসি',
   'br': 'Mohamed Morsi',
   'bs': 'Muhammed Mursi',
   'ca': 'Mohamed Mursi',
   'ckb': 'محەممەد مورسی',
   'cs': 'Muhammad Mursí',
   'cy': 'Mohamed Morsi',
   'da': 'Mohamed Mursi',
   'de': 'Mohammed Mursi',
   'diq': 'Mihemmed Mursî',
   'el': 'Μοχάμεντ Μόρσι',
   'en': 'Mohamed Morsi',
   'eo': 'Mohamed Mursi',
   'es': 'Mohamed Morsi',
   'et': 'Muḩammad Mursī',
   'eu': 'Mohamed Morsi',
   'fi': 'Mohammed Mursi',
   'fr': 'Mohamed Morsi',
   'ga': 'Mohamed Morsi',
   'gd': 'Mohamed Morsi',
   'he': 'מוחמד מורסי',
   'hi': 'मुहम्मद मुर्सी',
   'hr': 'Mohamed Mursi',
   'hu': 'Muhammad Morszi',
   'id': 'Muhammad Mursi',
   'it': 'Mohamed Morsi',
   'ja': 'ムハンマド・ムルシー',
   'ka': 'მუჰამედ მურსი',
   'kk': 'Мұхаммед Мурси',
   'ko': '무함마드 무르시',
   'la': 'Mahometus Mursī',
   'lb': 'Mohammed Mursi',
   'lv': 'Mohameds Morsī',
   'mg': 'Mohamed Morsi',
   'min': 'Muhammad Mursi',
   'ml': 'മുഹമ്മദ് മുർസി',
   'mr': 'मोहमद मोर्सी',
   'ms': 'Mohammed Mursi',
   'mzn': 'محمد مرسی',
   'nl': 'Mohamed Morsi',
   'no': 'Mohammed Mursi',
   'oc': 'Mohamed Morsi',
   'pa': 'ਮੁਹੰਮਦ ਮੁਰਸੀ',
   'pam': 'Mohamed Morsi',
   'pl': 'Muhammad Mursi',
   'pnb': 'محمد مرسی',
   'pt': 'Mohamed Morsi',
   'qu': 'Mohamed Morsi',
   'ro': 'Mohamed Morsi',
   'ru': 'Мурси, Мухаммед',
   'sa': 'मोहम्मदमुर्शी',
   'scn': 'Mohamed Morsi',
   'sco': 'Mohamed Morsi',
   'sh': 'Muhamed Morsi',
   'simple': 'Mohamed Morsi',
   'so': 'Maxamed Morsi',
   'sr': 'Мухамед Мурси',
   'sv': 'Muhammad Mursi',
   'ta': 'முகம்மது முர்சி',
   'tg': 'Муҳаммад Мурсӣ',
   'th': 'มุฮัมมัด มุรซี',
   'tl': 'Mohamed Morsi',
   'tr': 'Muhammed Mursi',
   'ug': 'مۇھەممەد مۇرسى',
   'uk': 'Мухаммед Мурсі',
   'ur': 'محمد مرسی',
   'vi': 'Mohamed Morsi',
   'yo': 'Mohamed Morsi',
   'zh': '穆罕默德·穆尔西',
   'zh-yue': '莫西'},
  'میدان التحریر': {'ar': 'ميدان التحرير',
   'arz': 'ميدان التحرير',
   'az': 'Təhrir meydanı',
   'bg': 'Тахрир',
   'bn': 'তাহরির স্কয়ার',
   'ca': 'Plaça Tahrir',
   'ckb': 'گۆڕەپانی تەحریر',
   'cs': 'Náměstí Osvobození',
   'da': 'Tahrir-pladsen',
   'de': 'Tahrir-Platz',
   'el': 'Πλατεία Ταχρίρ',
   'en': 'Tahrir Square',
   'eo': 'Tahrir',
   'es': 'Plaza de la Liberación',
   'et': 'Taḩrīri väljak',
   'eu': 'Tahrir plaza',
   'fi': 'Tahririn aukio',
   'fr': 'Place Tahrir',
   'ga': 'Cearnóg Tahrir',
   'gv': 'Kerrin Tahrir',
   'he': 'כיכר א-תחריר',
   'hi': 'तहरीर चौक',
   'hu': 'Tahrír tér',
   'hy': 'Թահրիր հրապարակ',
   'id': 'Alun-alun Tahrir',
   'it': 'Piazza Tahrir',
   'ja': 'タハリール広場',
   'ko': '타흐리르 광장',
   'lt': 'Tahriro aikštė',
   'ml': 'തഹ്\u200cരീർ ചത്വരം',
   'nl': 'Tahrirplein',
   'no': 'Tahrirplassen',
   'pa': 'ਤਹਿਰੀਰ ਚੌਕ',
   'pl': 'Majdan at-Tahrir',
   'pnb': 'تحریر چوک',
   'pt': 'Praça Tahrir',
   'ro': 'Piața Tahrir',
   'ru': 'Площадь Тахрир',
   'sco': 'Tahrir Square',
   'sr': 'Трг Тахрир',
   'sv': 'Befrielsetorget',
   'ta': 'தஹ்ரீர் சதுக்கம்',
   'th': 'จัตุรัสทาห์รีร์',
   'tr': 'Tahrir Meydanı',
   'uk': 'Мідан Тахрір',
   'ur': 'تحریر چوک',
   'vi': 'Quảng trường Tahrir',
   'zh': '解放广场'},
  'میدان تحریر': {'ar': 'ميدان التحرير',
   'arz': 'ميدان التحرير',
   'az': 'Təhrir meydanı',
   'bg': 'Тахрир',
   'bn': 'তাহরির স্কয়ার',
   'ca': 'Plaça Tahrir',
   'ckb': 'گۆڕەپانی تەحریر',
   'cs': 'Náměstí Osvobození',
   'da': 'Tahrir-pladsen',
   'de': 'Tahrir-Platz',
   'el': 'Πλατεία Ταχρίρ',
   'en': 'Tahrir Square',
   'eo': 'Tahrir',
   'es': 'Plaza de la Liberación',
   'et': 'Taḩrīri väljak',
   'eu': 'Tahrir plaza',
   'fi': 'Tahririn aukio',
   'fr': 'Place Tahrir',
   'ga': 'Cearnóg Tahrir',
   'gv': 'Kerrin Tahrir',
   'he': 'כיכר א-תחריר',
   'hi': 'तहरीर चौक',
   'hu': 'Tahrír tér',
   'hy': 'Թահրիր հրապարակ',
   'id': 'Alun-alun Tahrir',
   'it': 'Piazza Tahrir',
   'ja': 'タハリール広場',
   'ko': '타흐리르 광장',
   'lt': 'Tahriro aikštė',
   'ml': 'തഹ്\u200cരീർ ചത്വരം',
   'nl': 'Tahrirplein',
   'no': 'Tahrirplassen',
   'pa': 'ਤਹਿਰੀਰ ਚੌਕ',
   'pl': 'Majdan at-Tahrir',
   'pnb': 'تحریر چوک',
   'pt': 'Praça Tahrir',
   'ro': 'Piața Tahrir',
   'ru': 'Площадь Тахрир',
   'sco': 'Tahrir Square',
   'sr': 'Трг Тахрир',
   'sv': 'Befrielsetorget',
   'ta': 'தஹ்ரீர் சதுக்கம்',
   'th': 'จัตุรัสทาห์รีร์',
   'tr': 'Tahrir Meydanı',
   'uk': 'Мідан Тахрір',
   'ur': 'تحریر چوک',
   'vi': 'Quảng trường Tahrir',
   'zh': '解放广场'},
  'نوری مالکی': {'ar': 'نوري المالكي',
   'az': 'Nuri əl-Maliki',
   'bcl': 'Nuri al-Maliki',
   'bn': 'নুরি আল-মালিকি',
   'br': 'Nouri al-Maliki',
   'ca': 'Nuri Al Maliki',
   'ckb': 'نووری مالیکی',
   'cs': 'Núrí Málikí',
   'cy': 'Nouri al-Maliki',
   'da': 'Nuri al-Maliki',
   'de': 'Nuri al-Maliki',
   'el': 'Νουρί αλ Μαλίκι',
   'en': 'Nouri al-Maliki',
   'eo': 'Nuri al-Maliki',
   'es': 'Nuri al-Maliki',
   'et': 'Nūrī al-Mālikī',
   'fi': 'Nuri al-Maliki',
   'fr': 'Nouri al-Maliki',
   'he': 'נורי אל-מאלכי',
   'hu': 'Núri el-Máliki',
   'id': 'Nouri al-Maliki',
   'it': 'Nuri al-Maliki',
   'ja': 'ヌーリー・マーリキー',
   'ka': 'ნური ალ-მალიქი',
   'ko': '누리 알말리키',
   'ku': 'Nûrî Malikî',
   'la': 'Nūrī al-Mālikī',
   'ms': 'Nouri al-Maliki',
   'mzn': 'نوری المالکی',
   'nl': 'Nouri al-Maliki',
   'no': 'Nouri al-Maliki',
   'pa': 'ਨੂਰੀ ਅਲ-ਮਲੀਕੀ',
   'pl': 'Nuri al-Maliki',
   'pt': 'Nouri al-Maliki',
   'ru': 'Аль-Малики, Нури',
   'sco': 'Nouri al-Maliki',
   'sh': 'Nuri al-Maliki',
   'simple': 'Nouri al-Maliki',
   'so': 'Nuur Al-Maliki',
   'sr': 'Нури ел Малики',
   'sv': 'Nuri al-Maliki',
   'tr': 'Nuri el-Maliki',
   'uk': 'Нурі аль-Малікі',
   'ur': 'نوری المالکی',
   'vi': 'Nouri al-Maliki',
   'yo': 'Nouri al-Maliki',
   'zh': '努里·马利基'},
  'پرچم ایالات متحده آمریکا': {'af': 'Vlag van die Verenigde State',
   'am': 'የአሜሪካ ሰንደቅ ዓላማ',
   'ar': 'علم الولايات المتحدة',
   'ast': "Bandera de los Estaos Xuníos d'América",
   'az': 'ABŞ bayrağı',
   'be': 'Сцяг ЗША',
   'be-x-old': 'Сьцяг Злучаных Штатаў Амэрыкі',
   'bg': 'Национално знаме на Съединените американски щати',
   'bpy': 'তিলপারাষ্ট্রর ফিরালহান',
   'br': 'Banniel ar Stadoù-Unanet',
   'bs': 'Zastava Sjedinjenih Američkih Država',
   'ca': 'Bandera dels Estats Units',
   'cs': 'Vlajka Spojených států amerických',
   'cy': 'Baner yr Unol Daleithiau',
   'da': "USA's flag",
   'de': 'Flagge der Vereinigten Staaten',
   'el': 'Σημαία των Ηνωμένων Πολιτειών',
   'en': 'Flag of the United States',
   'eo': 'Flago de Usono',
   'es': 'Bandera de los Estados Unidos',
   'et': 'Ameerika Ühendriikide lipp',
   'eu': 'Ameriketako Estatu Batuetako bandera',
   'fi': 'Yhdysvaltain lippu',
   'fo': 'Flagg Sambandsríkið Amerika',
   'fr': 'Drapeau des États-Unis',
   'fy': 'Flagge fan de Feriene Steaten',
   'gl': 'Bandeira dos Estados Unidos de América',
   'he': 'דגל ארצות הברית',
   'hi': 'संयुक्त राज्य का ध्वज',
   'hr': 'Zastava Sjedinjenih Američkih Država',
   'hu': 'Az Amerikai Egyesült Államok zászlaja',
   'hy': 'Ամերիկայի Միացյալ Նահանգների դրոշ',
   'id': 'Bendera Amerika Serikat',
   'ilo': 'Wagayway ti Estados Unidos',
   'is': 'Fáni Bandaríkjanna',
   'it': "Bandiera degli Stati Uniti d'America",
   'ja': 'アメリカ合衆国の国旗',
   'ka': 'აშშ-ის დროშა',
   'kk': 'Америка Құрама Штаттарының туы',
   'ko': '미국의 국기',
   'la': 'Vexillum Civitatum Foederatarum Americae',
   'lbe': 'Американал байрам',
   'lt': 'JAV vėliava',
   'lv': 'Amerikas Savienoto Valstu karogs',
   'mk': 'Знаме на Соединетите Американски Држави',
   'mr': 'अमेरिकेचा ध्वज',
   'ms': 'Bendera Amerika Syarikat',
   'my': 'အမေရိကန်ပြည်ထောင်စု၏ အလံတော်',
   'myv': 'Американь коцтось',
   'nl': 'Vlag van de Verenigde Staten',
   'nn': 'Det amerikanske flagget',
   'no': 'USAs flagg',
   'pl': 'Flaga Stanów Zjednoczonych',
   'pnb': 'امریکی چنڈا',
   'pt': 'Bandeira dos Estados Unidos',
   'ro': 'Drapelul Statelor Unite ale Americii',
   'ru': 'Флаг Соединённых Штатов Америки',
   'sco': 'Banner o the Unitit States',
   'sh': 'Zastava Sjedinjenih Američkih Država',
   'simple': 'Flag of the United States',
   'sk': 'Vlajka Spojených štátov',
   'sl': 'Zastava Združenih držav Amerike',
   'sq': 'Flamuri i Shteteve të Bashkuara',
   'sr': 'Застава Сједињених Америчких Држава',
   'sv': 'USA:s flagga',
   'th': 'ธงชาติสหรัฐอเมริกา',
   'tr': 'Amerika Birleşik Devletleri bayrağı',
   'uk': 'Прапор США',
   'vep': 'AÜV:oiden flag',
   'vi': 'Quốc kỳ Hoa Kỳ',
   'yo': 'Àsìá ilẹ̀ àwọn Ìpínlẹ̀ Aṣọ̀kan Amẹ́ríkà',
   'zh': '美国国旗',
   'zh-min-nan': 'Bí-kok kok-kî',
   'zh-yue': '花旗'},
  'پرچم ایران': {'af': 'Vlag van Iran',
   'am': 'የኢራን ሰንደቅ ዓላማ',
   'ar': 'علم إيران',
   'az': 'İran bayrağı',
   'be': 'Сцяг Ірана',
   'be-x-old': 'Сьцяг Ірану',
   'bg': 'Национално знаме на Иран',
   'bn': 'ইরানের জাতীয় পতাকা',
   'bpy': 'ইরানর ফিরালহান',
   'bs': 'Zastava Irana',
   'ca': "Bandera de l'Iran",
   'cs': 'Íránská vlajka',
   'da': 'Irans flag',
   'de': 'Flagge des Iran',
   'el': 'Σημαία του Ιράν',
   'en': 'Flag of Iran',
   'eo': 'Flago de Irano',
   'es': 'Bandera de Irán',
   'et': 'Iraani lipp',
   'eu': 'Irango bandera',
   'fi': 'Iranin lippu',
   'fr': "Drapeau de l'Iran",
   'gl': 'Bandeira de Irán',
   'gu': 'ઈરાનનો રાષ્ટ્રધ્વજ',
   'he': 'דגל איראן',
   'hi': 'ईरान का ध्वज',
   'hr': 'Zastava Irana',
   'hu': 'Irán zászlaja',
   'hy': 'Իրանի դրոշ',
   'id': 'Bendera Iran',
   'is': 'Fáni Írans',
   'it': "Bandiera dell'Iran",
   'ja': 'イランの国旗',
   'ka': 'ირანის დროშა',
   'ko': '이란의 국기',
   'lt': 'Irano vėliava',
   'mk': 'Знаме на Иран',
   'mr': 'इराणचा ध्वज',
   'ms': 'Bendera Iran',
   'mzn': 'ایران پرچم',
   'nl': 'Vlag van Iran',
   'no': 'Irans flagg',
   'pl': 'Flaga Iranu',
   'pt': 'Bandeira do Irão',
   'ru': 'Флаг Ирана',
   'sco': 'Banner o Iran',
   'sh': 'Zastava Irana',
   'simple': 'Flag of Iran',
   'sk': 'Vlajka Iránu',
   'sr': 'Застава Ирана',
   'sv': 'Irans flagga',
   'th': 'ธงชาติอิหร่าน',
   'tr': 'İran bayrağı',
   'uk': 'Прапор Ірану',
   'ur': 'پرچم ایران',
   'uz': 'Eron bayrogʻi',
   'vi': 'Quốc kỳ Iran',
   'yo': 'Àsìá ilẹ̀ Ìránì',
   'zh': '伊朗国旗'},
  'کاترین اشتون': {'ar': 'كاترين أشتون',
   'ast': 'Catherine Ashton',
   'az': 'Ketrin Eşton',
   'be': 'Кэтрын Маргарэт Эштан',
   'bg': 'Катрин Аштън',
   'br': 'Catherine Ashton',
   'ca': 'Catherine Ashton',
   'ckb': 'کاترین ئەشتۆن',
   'cs': 'Catherine Ashtonová',
   'da': 'Catherine Ashton',
   'de': 'Catherine Ashton',
   'el': 'Κάθριν Άστον',
   'en': 'Catherine Ashton',
   'eo': 'Catherine Ashton',
   'es': 'Catherine Ashton',
   'et': 'Catherine Ashton',
   'eu': 'Catherine Ashton',
   'fi': 'Catherine Ashton',
   'fr': 'Catherine Ashton',
   'gl': 'Catherine Ashton',
   'he': 'קתרין אשטון',
   'hr': 'Catherine Ashton',
   'hu': 'Catherine Ashton',
   'hy': 'Քեթրին Էշթոն',
   'it': 'Catherine Ashton',
   'ja': 'キャサリン・アシュトン',
   'ko': '캐서린 애슈턴',
   'lb': 'Catherine Ashton',
   'li': 'Catherine Ashton',
   'lt': 'Catherine Ashton',
   'nds': 'Catherine Ashton',
   'nl': 'Catherine Ashton',
   'no': 'Catherine Ashton',
   'oc': 'Catherine Ashton',
   'pl': 'Catherine Ashton',
   'pt': 'Catherine Ashton',
   'ro': 'Catherine Ashton',
   'ru': 'Эштон, Кэтрин',
   'sco': 'Catherine Ashton',
   'simple': 'Catherine Ashton',
   'sk': 'Catherine Ashtonová',
   'sr': 'Кетрин Ештон',
   'sv': 'Catherine Ashton',
   'tg': 'Кэтрин Эштон',
   'tr': 'Catherine Ashton',
   'uk': 'Кетрін Ештон',
   'zh': '艾嘉蓮'},
  'کلیسا': {'ang': 'Cirice',
   'ar': 'الكنيسة المسيحية',
   'ast': 'Ilesia',
   'bg': 'Църква (институция)',
   'ca': 'Església (institució)',
   'ckb': 'کڵێسا',
   'cs': 'Církev',
   'cv': 'Чиркӳ',
   'da': 'Kirken',
   'de': 'Kirche (Organisation)',
   'el': 'Εκκλησία',
   'eml': 'Ceṡa',
   'en': 'Christian Church',
   'eo': 'Eklezio',
   'es': 'Iglesia',
   'fi': 'Kirkko',
   'fr': 'Église (institution)',
   'gd': 'Eaglais',
   'gl': 'Igrexa',
   'hak': 'Kî-tuk Kau-fi',
   'hi': 'गिरजाघर',
   'hr': 'Kršćanska crkva',
   'hu': 'Egyház',
   'hy': 'Եկեղեցի',
   'ia': 'Ecclesia',
   'id': 'Gereja',
   'io': 'Kirko',
   'is': 'Kirkja',
   'it': 'Chiesa (comunità)',
   'ja': '教会',
   'jam': 'Kristian Choch',
   'jv': 'Gréja',
   'ko': '교회',
   'la': 'Ecclesia',
   'lv': 'Kristīgā baznīca',
   'mg': 'Fiangonana',
   'min': 'Gereja',
   'mrj': 'Костёл',
   'mwl': 'Eigreija',
   'nds': 'Kark (Organisation)',
   'nl': 'Kerk (instituut)',
   'nn': 'Kyrkja',
   'os': 'Еклези',
   'pl': 'Kościół (organizacja)',
   'pms': 'Cesa',
   'pt': 'Igreja',
   'qu': 'Kristiyanu inlisya',
   'ro': 'Biserică (instituție)',
   'ru': 'Христианская церковь',
   'sc': 'Creja',
   'scn': 'Crèsia',
   'sco': 'Christian Kirk',
   'sh': 'Hrišćanska crkva',
   'si': 'ක්\u200dරිස්තියානි ආගමික සභා',
   'simple': 'Christian Church',
   'sk': 'Cirkev',
   'sl': 'Cerkev (organizacija)',
   'sr': 'Црква',
   'sv': 'Kyrkan',
   'sw': 'Kanisa',
   'ta': 'திருச்சபை',
   'th': 'คริสตจักร',
   'tl': 'Simbahan',
   'tr': 'Kilise (örgüt)',
   'tt': 'Xristian Çirkäwe',
   'uk': 'Християнська Церква',
   'zh': '教会',
   'zh-min-nan': 'Kàu-hōe',
   'zu': 'Isonto'}})
len_transoutlink_dict_counterEn = {}

for lang,titles_dict in translation_dict.items():
    len_transoutlink_dict_counterEn[lang]=0         #starting at fa at a count of 0 
    for art_title,lang_dict in titles_dict.items(): #go into links on fa 
        if 'en' in lang_dict.keys():               #check for en version in links 
            len_transoutlink_dict_counterEn[lang] +=1   #if one is found add to counter 
            
    
   # for trans_lang,trans_title in lang_dict.items():
    #tp_dict = translation_dict[langlinks_lang][titles]
    
    #if 'en' in titles.keys():
        #en_transoutlink_dict_en[lang]['en'] = len(titles)
         
            
            #for o in s_tuff['en']:
            #len_transoutlink_dict_en[lang]['en'] = len(titles)
       # else:
            #len_transoutlink_dict_en[langlinks_lang][lang] = {}
    
   # if 'en' in langlinks_lang.keys():
      #  len_transoutlink_dict_en[langlinks_lang] = len(titles)
        
        
        #b = dict( (key, value) for (key, value) in a.items() if key == "hello" )
len_transoutlink_dict_en
{'af': 2,
 'ar': 94,
 'arz': 26,
 'az': 0,
 'bg': 17,
 'ca': 21,
 'ckb': 9,
 'de': 233,
 'el': 6,
 'en': 0,
 'es': 65,
 'fa': 30,
 'fi': 10,
 'fr': 74,
 'he': 45,
 'hi': 3,
 'id': 8,
 'it': 50,
 'ja': 221,
 'ko': 9,
 'nl': 22,
 'pl': 17,
 'pt': 23,
 'ro': 19,
 'ru': 33,
 'sr': 24,
 'tg': 4,
 'tr': 27,
 'uk': 32,
 'ur': 2,
 'vi': 34,
 'zh': 78}
len_transoutlink_dict_enList = {}

for lang,titles_dict in translation_dict.items():
    len_transoutlink_dict_enList[lang]=[]         #starting at fa at a count of 0 
    for art_title,lang_dict in titles_dict.items(): #go into links on fa 
        if 'en' in lang_dict.keys():  
            _title = lang_dict['en']        #check for en version in links 
            len_transoutlink_dict_enList[lang].append(_title)   #add to list  en version 
len(len_transoutlink_dict_enList['zh'])
78
len_transoutlink_dict = {}

#links_and_langs = get_outlink_translations(outlinks_per_lang)



for langlinks_lang,titles in translation_dict.items():
    len_transoutlink_dict[langlinks_lang] = len(titles)
   

    #if 'en' in lang_dict.keys():
       # len_transoutlink_en_dict[lang_dict]= len(titles)
    
    
    # links_and_langs.items():
    #len_transoutlink_en_dict[lang] = len([titles for titles in translation_dict if 'en' in lang_dict.keys()])
    
    
    #if 'en' in lang_dict.keys
    #titles_and_lang_dict[lang] = len(titles)



#print(key, len([item for item in value if item]))


#titles_and_lang_dict = {}

#pages_and_langs = link_getter(page_title)

#for lang,title in pages_and_langs.items():
    #titles_and_lang_dict[lang] = title
len_transoutlink_dict
{'af': 4,
 'ar': 110,
 'arz': 28,
 'az': 0,
 'bg': 24,
 'ca': 21,
 'ckb': 11,
 'de': 267,
 'el': 9,
 'en': 262,
 'es': 69,
 'fa': 32,
 'fi': 14,
 'fr': 87,
 'he': 48,
 'hi': 3,
 'id': 8,
 'it': 57,
 'ja': 235,
 'ko': 9,
 'nl': 22,
 'pl': 17,
 'pt': 26,
 'ro': 29,
 'ru': 33,
 'sr': 28,
 'tg': 7,
 'tr': 39,
 'uk': 34,
 'ur': 2,
 'vi': 45,
 'zh': 91}
len(len_transoutlink_dict)
32
s_d2 = pd.Series(titles_and_lang_dict)

s_d1 = pd.Series(_langAbrev_dict)

s_d3 = pd.Series(len_transoutlink_dict)

s_d4 = pd.Series(len_transoutlink_dict_counterEn)
df_mix = pd.DataFrame({'lang' : s_d1,
                       'title' : s_d2, 
                       'total links' : s_d3,
                       'english links': s_d4})

df_mix = df_mix[['lang', 'title', 'total links', 'english links']]
df_mix
lang title total links english links
af Afrikaans Egiptiese staatsgreep van 2013 4.0 2.0
als Alemannisch NaN NaN NaN
am Amharic NaN NaN NaN
an Aragonese NaN NaN NaN
ang Old English NaN NaN NaN
ar Arabic انقلاب 2013 في مصر 110.0 94.0
arz Egyptian Arabic خريطة المستقبل (مصر) 28.0 26.0
as Assamese NaN NaN NaN
ast Asturian NaN NaN NaN
ay Aymara NaN NaN NaN
az Azerbaijani Misirdə hərbi çeviriliş (2013) 0.0 0.0
azb تۆرکجه NaN NaN NaN
ba Bashkir NaN NaN NaN
bat-smg Samogitian NaN NaN NaN
bcl Bikol Central NaN NaN NaN
be Belarusian NaN NaN NaN
be-x-old беларуская (тарашкевіца)‎ NaN NaN NaN
bg Bulgarian Държавен преврат в Египет (2013 г.) 24.0 17.0
bm Bambara NaN NaN NaN
bn Bangla NaN NaN NaN
bpy Bishnupriya NaN NaN NaN
br Breton NaN NaN NaN
bs Bosnian NaN NaN NaN
bxr буряад NaN NaN NaN
ca Catalan Cop d'Estat a Egipte l'any 2013 21.0 21.0
cbk-zam Chavacano de Zamboanga NaN NaN NaN
cdo Min Dong Chinese NaN NaN NaN
ce Chechen NaN NaN NaN
ceb Cebuano NaN NaN NaN
ckb Central Kurdish کودەتای ٢٠١٣ی میسر 11.0 9.0
co Corsican NaN NaN NaN
cs Czech NaN NaN NaN
cv Chuvash NaN NaN NaN
cy Welsh NaN NaN NaN
da Danish NaN NaN NaN
de German Militärputsch in Ägypten 2013 267.0 233.0
diq Zazaki NaN NaN NaN
el Greek Αιγυπτιακό πραξικόπημα 2013 9.0 6.0
en NaN 2013 Egyptian coup d'état 262.0 0.0
eo Esperanto NaN NaN NaN
es Spanish Golpe de Estado en Egipto de 2013 69.0 65.0
et Estonian NaN NaN NaN
eu Basque NaN NaN NaN
ext Extremaduran NaN NaN NaN
fa Persian کودتای ۲۰۱۳ مصر 32.0 30.0
fi Finnish Egyptin vallankaappaus 2013 14.0 10.0
fiu-vro Võro NaN NaN NaN
fo Faroese NaN NaN NaN
fr French Coup d'État du 3 juillet 2013 en Égypte 87.0 74.0
frp Arpitan NaN NaN NaN
frr Northern Frisian NaN NaN NaN
fy Western Frisian NaN NaN NaN
ga Irish NaN NaN NaN
gan Gan Chinese NaN NaN NaN
gd Scottish Gaelic NaN NaN NaN
... ... ... ... ...
pt Portuguese Golpe de Estado no Egito em 2013 26.0 23.0
qu Quechua NaN NaN NaN
ro Romanian Lovitura de stat din Egipt din 2013 29.0 19.0
roa-rup Aromanian NaN NaN NaN
ru Russian Военный переворот в Египте (2013) 33.0 33.0
rue Rusyn NaN NaN NaN
sa Sanskrit NaN NaN NaN
sah Sakha NaN NaN NaN
sc Sardinian NaN NaN NaN
scn Sicilian NaN NaN NaN
sco Scots NaN NaN NaN
sd Sindhi NaN NaN NaN
se Northern Sami NaN NaN NaN
sh Serbo-Croatian NaN NaN NaN
si Sinhala NaN NaN NaN
simple Simple English NaN NaN NaN
sk Slovak NaN NaN NaN
sl Slovenian NaN NaN NaN
so Somali NaN NaN NaN
sq Albanian NaN NaN NaN
sr Serbian Државни удар у Египту (2013) 28.0 24.0
su Sundanese NaN NaN NaN
sv Swedish NaN NaN NaN
sw Swahili NaN NaN NaN
szl Silesian NaN NaN NaN
ta Tamil NaN NaN NaN
te Telugu NaN NaN NaN
tg NaN Кудатои 2013 Миср 7.0 4.0
th Thai NaN NaN NaN
tk Turkmen NaN NaN NaN
tl Tagalog NaN NaN NaN
tpi Tok Pisin NaN NaN NaN
tr Turkish 2013 Mısır askerî darbesi 39.0 27.0
tt Tatar NaN NaN NaN
tyv Tuvinian NaN NaN NaN
ug Uyghur NaN NaN NaN
uk Ukrainian Військовий переворот в Єгипті 2013 34.0 32.0
ur Urdu 2013ء مصری فوجی تاخت 2.0 2.0
uz Uzbek NaN NaN NaN
vec Venetian NaN NaN NaN
vep Veps NaN NaN NaN
vi Vietnamese Đảo chính Ai Cập 2013 45.0 34.0
vo Volapük NaN NaN NaN
wa Walloon NaN NaN NaN
war Waray NaN NaN NaN
wo Wolof NaN NaN NaN
wuu Wu Chinese NaN NaN NaN
xmf Mingrelian NaN NaN NaN
yi Yiddish NaN NaN NaN
yo Yoruba NaN NaN NaN
za Zhuang NaN NaN NaN
zea Zeelandic NaN NaN NaN
zh Chinese 2013年埃及政变 91.0 78.0
zh-min-nan Chinese (Min Nan) NaN NaN NaN
zh-yue Cantonese NaN NaN NaN

192 rows × 4 columns

df_mix[['lang', 'title', 'total links', 'english links']]
lang title total links english links
af Afrikaans Egiptiese staatsgreep van 2013 4.0 2.0
als Alemannisch NaN NaN NaN
am Amharic NaN NaN NaN
an Aragonese NaN NaN NaN
ang Old English NaN NaN NaN
ar Arabic انقلاب 2013 في مصر 110.0 94.0
arz Egyptian Arabic خريطة المستقبل (مصر) 28.0 26.0
as Assamese NaN NaN NaN
ast Asturian NaN NaN NaN
ay Aymara NaN NaN NaN
az Azerbaijani Misirdə hərbi çeviriliş (2013) 0.0 0.0
azb تۆرکجه NaN NaN NaN
ba Bashkir NaN NaN NaN
bat-smg Samogitian NaN NaN NaN
bcl Bikol Central NaN NaN NaN
be Belarusian NaN NaN NaN
be-x-old беларуская (тарашкевіца)‎ NaN NaN NaN
bg Bulgarian Държавен преврат в Египет (2013 г.) 24.0 17.0
bm Bambara NaN NaN NaN
bn Bangla NaN NaN NaN
bpy Bishnupriya NaN NaN NaN
br Breton NaN NaN NaN
bs Bosnian NaN NaN NaN
bxr буряад NaN NaN NaN
ca Catalan Cop d'Estat a Egipte l'any 2013 21.0 21.0
cbk-zam Chavacano de Zamboanga NaN NaN NaN
cdo Min Dong Chinese NaN NaN NaN
ce Chechen NaN NaN NaN
ceb Cebuano NaN NaN NaN
ckb Central Kurdish کودەتای ٢٠١٣ی میسر 11.0 9.0
co Corsican NaN NaN NaN
cs Czech NaN NaN NaN
cv Chuvash NaN NaN NaN
cy Welsh NaN NaN NaN
da Danish NaN NaN NaN
de German Militärputsch in Ägypten 2013 267.0 233.0
diq Zazaki NaN NaN NaN
el Greek Αιγυπτιακό πραξικόπημα 2013 9.0 6.0
en NaN 2013 Egyptian coup d'état 262.0 0.0
eo Esperanto NaN NaN NaN
es Spanish Golpe de Estado en Egipto de 2013 69.0 65.0
et Estonian NaN NaN NaN
eu Basque NaN NaN NaN
ext Extremaduran NaN NaN NaN
fa Persian کودتای ۲۰۱۳ مصر 32.0 30.0
fi Finnish Egyptin vallankaappaus 2013 14.0 10.0
fiu-vro Võro NaN NaN NaN
fo Faroese NaN NaN NaN
fr French Coup d'État du 3 juillet 2013 en Égypte 87.0 74.0
frp Arpitan NaN NaN NaN
frr Northern Frisian NaN NaN NaN
fy Western Frisian NaN NaN NaN
ga Irish NaN NaN NaN
gan Gan Chinese NaN NaN NaN
gd Scottish Gaelic NaN NaN NaN
... ... ... ... ...
pt Portuguese Golpe de Estado no Egito em 2013 26.0 23.0
qu Quechua NaN NaN NaN
ro Romanian Lovitura de stat din Egipt din 2013 29.0 19.0
roa-rup Aromanian NaN NaN NaN
ru Russian Военный переворот в Египте (2013) 33.0 33.0
rue Rusyn NaN NaN NaN
sa Sanskrit NaN NaN NaN
sah Sakha NaN NaN NaN
sc Sardinian NaN NaN NaN
scn Sicilian NaN NaN NaN
sco Scots NaN NaN NaN
sd Sindhi NaN NaN NaN
se Northern Sami NaN NaN NaN
sh Serbo-Croatian NaN NaN NaN
si Sinhala NaN NaN NaN
simple Simple English NaN NaN NaN
sk Slovak NaN NaN NaN
sl Slovenian NaN NaN NaN
so Somali NaN NaN NaN
sq Albanian NaN NaN NaN
sr Serbian Државни удар у Египту (2013) 28.0 24.0
su Sundanese NaN NaN NaN
sv Swedish NaN NaN NaN
sw Swahili NaN NaN NaN
szl Silesian NaN NaN NaN
ta Tamil NaN NaN NaN
te Telugu NaN NaN NaN
tg NaN Кудатои 2013 Миср 7.0 4.0
th Thai NaN NaN NaN
tk Turkmen NaN NaN NaN
tl Tagalog NaN NaN NaN
tpi Tok Pisin NaN NaN NaN
tr Turkish 2013 Mısır askerî darbesi 39.0 27.0
tt Tatar NaN NaN NaN
tyv Tuvinian NaN NaN NaN
ug Uyghur NaN NaN NaN
uk Ukrainian Військовий переворот в Єгипті 2013 34.0 32.0
ur Urdu 2013ء مصری فوجی تاخت 2.0 2.0
uz Uzbek NaN NaN NaN
vec Venetian NaN NaN NaN
vep Veps NaN NaN NaN
vi Vietnamese Đảo chính Ai Cập 2013 45.0 34.0
vo Volapük NaN NaN NaN
wa Walloon NaN NaN NaN
war Waray NaN NaN NaN
wo Wolof NaN NaN NaN
wuu Wu Chinese NaN NaN NaN
xmf Mingrelian NaN NaN NaN
yi Yiddish NaN NaN NaN
yo Yoruba NaN NaN NaN
za Zhuang NaN NaN NaN
zea Zeelandic NaN NaN NaN
zh Chinese 2013年埃及政变 91.0 78.0
zh-min-nan Chinese (Min Nan) NaN NaN NaN
zh-yue Cantonese NaN NaN NaN

192 rows × 4 columns

df_mix['percent en linkbacks'] = df_mix['english links']/df_mix['total links']

df_mix
lang title total links english links percent en linkbacks
af Afrikaans Egiptiese staatsgreep van 2013 4.0 2.0 0.500000
als Alemannisch NaN NaN NaN NaN
am Amharic NaN NaN NaN NaN
an Aragonese NaN NaN NaN NaN
ang Old English NaN NaN NaN NaN
ar Arabic انقلاب 2013 في مصر 110.0 94.0 0.854545
arz Egyptian Arabic خريطة المستقبل (مصر) 28.0 26.0 0.928571
as Assamese NaN NaN NaN NaN
ast Asturian NaN NaN NaN NaN
ay Aymara NaN NaN NaN NaN
az Azerbaijani Misirdə hərbi çeviriliş (2013) 0.0 0.0 NaN
azb تۆرکجه NaN NaN NaN NaN
ba Bashkir NaN NaN NaN NaN
bat-smg Samogitian NaN NaN NaN NaN
bcl Bikol Central NaN NaN NaN NaN
be Belarusian NaN NaN NaN NaN
be-x-old беларуская (тарашкевіца)‎ NaN NaN NaN NaN
bg Bulgarian Държавен преврат в Египет (2013 г.) 24.0 17.0 0.708333
bm Bambara NaN NaN NaN NaN
bn Bangla NaN NaN NaN NaN
bpy Bishnupriya NaN NaN NaN NaN
br Breton NaN NaN NaN NaN
bs Bosnian NaN NaN NaN NaN
bxr буряад NaN NaN NaN NaN
ca Catalan Cop d'Estat a Egipte l'any 2013 21.0 21.0 1.000000
cbk-zam Chavacano de Zamboanga NaN NaN NaN NaN
cdo Min Dong Chinese NaN NaN NaN NaN
ce Chechen NaN NaN NaN NaN
ceb Cebuano NaN NaN NaN NaN
ckb Central Kurdish کودەتای ٢٠١٣ی میسر 11.0 9.0 0.818182
co Corsican NaN NaN NaN NaN
cs Czech NaN NaN NaN NaN
cv Chuvash NaN NaN NaN NaN
cy Welsh NaN NaN NaN NaN
da Danish NaN NaN NaN NaN
de German Militärputsch in Ägypten 2013 267.0 233.0 0.872659
diq Zazaki NaN NaN NaN NaN
el Greek Αιγυπτιακό πραξικόπημα 2013 9.0 6.0 0.666667
en NaN 2013 Egyptian coup d'état 262.0 0.0 0.000000
eo Esperanto NaN NaN NaN NaN
es Spanish Golpe de Estado en Egipto de 2013 69.0 65.0 0.942029
et Estonian NaN NaN NaN NaN
eu Basque NaN NaN NaN NaN
ext Extremaduran NaN NaN NaN NaN
fa Persian کودتای ۲۰۱۳ مصر 32.0 30.0 0.937500
fi Finnish Egyptin vallankaappaus 2013 14.0 10.0 0.714286
fiu-vro Võro NaN NaN NaN NaN
fo Faroese NaN NaN NaN NaN
fr French Coup d'État du 3 juillet 2013 en Égypte 87.0 74.0 0.850575
frp Arpitan NaN NaN NaN NaN
frr Northern Frisian NaN NaN NaN NaN
fy Western Frisian NaN NaN NaN NaN
ga Irish NaN NaN NaN NaN
gan Gan Chinese NaN NaN NaN NaN
gd Scottish Gaelic NaN NaN NaN NaN
... ... ... ... ... ...
pt Portuguese Golpe de Estado no Egito em 2013 26.0 23.0 0.884615
qu Quechua NaN NaN NaN NaN
ro Romanian Lovitura de stat din Egipt din 2013 29.0 19.0 0.655172
roa-rup Aromanian NaN NaN NaN NaN
ru Russian Военный переворот в Египте (2013) 33.0 33.0 1.000000
rue Rusyn NaN NaN NaN NaN
sa Sanskrit NaN NaN NaN NaN
sah Sakha NaN NaN NaN NaN
sc Sardinian NaN NaN NaN NaN
scn Sicilian NaN NaN NaN NaN
sco Scots NaN NaN NaN NaN
sd Sindhi NaN NaN NaN NaN
se Northern Sami NaN NaN NaN NaN
sh Serbo-Croatian NaN NaN NaN NaN
si Sinhala NaN NaN NaN NaN
simple Simple English NaN NaN NaN NaN
sk Slovak NaN NaN NaN NaN
sl Slovenian NaN NaN NaN NaN
so Somali NaN NaN NaN NaN
sq Albanian NaN NaN NaN NaN
sr Serbian Државни удар у Египту (2013) 28.0 24.0 0.857143
su Sundanese NaN NaN NaN NaN
sv Swedish NaN NaN NaN NaN
sw Swahili NaN NaN NaN NaN
szl Silesian NaN NaN NaN NaN
ta Tamil NaN NaN NaN NaN
te Telugu NaN NaN NaN NaN
tg NaN Кудатои 2013 Миср 7.0 4.0 0.571429
th Thai NaN NaN NaN NaN
tk Turkmen NaN NaN NaN NaN
tl Tagalog NaN NaN NaN NaN
tpi Tok Pisin NaN NaN NaN NaN
tr Turkish 2013 Mısır askerî darbesi 39.0 27.0 0.692308
tt Tatar NaN NaN NaN NaN
tyv Tuvinian NaN NaN NaN NaN
ug Uyghur NaN NaN NaN NaN
uk Ukrainian Військовий переворот в Єгипті 2013 34.0 32.0 0.941176
ur Urdu 2013ء مصری فوجی تاخت 2.0 2.0 1.000000
uz Uzbek NaN NaN NaN NaN
vec Venetian NaN NaN NaN NaN
vep Veps NaN NaN NaN NaN
vi Vietnamese Đảo chính Ai Cập 2013 45.0 34.0 0.755556
vo Volapük NaN NaN NaN NaN
wa Walloon NaN NaN NaN NaN
war Waray NaN NaN NaN NaN
wo Wolof NaN NaN NaN NaN
wuu Wu Chinese NaN NaN NaN NaN
xmf Mingrelian NaN NaN NaN NaN
yi Yiddish NaN NaN NaN NaN
yo Yoruba NaN NaN NaN NaN
za Zhuang NaN NaN NaN NaN
zea Zeelandic NaN NaN NaN NaN
zh Chinese 2013年埃及政变 91.0 78.0 0.857143
zh-min-nan Chinese (Min Nan) NaN NaN NaN NaN
zh-yue Cantonese NaN NaN NaN NaN

192 rows × 5 columns

df2 = pd.DataFrame(s_d2)
df2
0
af Egiptiese staatsgreep van 2013
ar انقلاب 2013 في مصر
arz خريطة المستقبل (مصر)
az Misirdə hərbi çeviriliş (2013)
bg Държавен преврат в Египет (2013 г.)
ca Cop d'Estat a Egipte l'any 2013
ckb کودەتای ٢٠١٣ی میسر
de Militärputsch in Ägypten 2013
el Αιγυπτιακό πραξικόπημα 2013
en 2013 Egyptian coup d'état
es Golpe de Estado en Egipto de 2013
fa کودتای ۲۰۱۳ مصر
fi Egyptin vallankaappaus 2013
fr Coup d'État du 3 juillet 2013 en Égypte
he ההפיכה במצרים (2013)
hi मिस्र में सैन्य तख्तापलट २०१३
id Kudeta Mesir 2013
it Golpe egiziano del 2013
ja 2013年エジプトクーデター
ko 2013년 이집트 쿠데타
nl Protesten en staatsgreep in Egypte in 2013
pl Zamach stanu w Egipcie (2013)
pt Golpe de Estado no Egito em 2013
ro Lovitura de stat din Egipt din 2013
ru Военный переворот в Египте (2013)
sr Државни удар у Египту (2013)
tg Кудатои 2013 Миср
tr 2013 Mısır askerî darbesi
uk Військовий переворот в Єгипті 2013
ur 2013ء مصری فوجی تاخت
vi Đảo chính Ai Cập 2013
zh 2013年埃及政变
df1 = pd.DataFrame(s_d1)
df1
0
af Afrikaans
als Alemannisch
am Amharic
an Aragonese
ang Old English
ar Arabic
arz Egyptian Arabic
as Assamese
ast Asturian
ay Aymara
az Azerbaijani
azb تۆرکجه
ba Bashkir
bat-smg Samogitian
bcl Bikol Central
be Belarusian
be-x-old беларуская (тарашкевіца)‎
bg Bulgarian
bm Bambara
bn Bangla
bpy Bishnupriya
br Breton
bs Bosnian
bxr буряад
ca Catalan
cbk-zam Chavacano de Zamboanga
cdo Min Dong Chinese
ce Chechen
ceb Cebuano
ckb Central Kurdish
co Corsican
cs Czech
cv Chuvash
cy Welsh
da Danish
de German
diq Zazaki
el Greek
eo Esperanto
es Spanish
et Estonian
eu Basque
ext Extremaduran
fa Persian
fi Finnish
fiu-vro Võro
fo Faroese
fr French
frp Arpitan
frr Northern Frisian
fy Western Frisian
ga Irish
gan Gan Chinese
gd Scottish Gaelic
gl Galician
... ...
ps Pashto
pt Portuguese
qu Quechua
ro Romanian
roa-rup Aromanian
ru Russian
rue Rusyn
sa Sanskrit
sah Sakha
sc Sardinian
scn Sicilian
sco Scots
sd Sindhi
se Northern Sami
sh Serbo-Croatian
si Sinhala
simple Simple English
sk Slovak
sl Slovenian
so Somali
sq Albanian
sr Serbian
su Sundanese
sv Swedish
sw Swahili
szl Silesian
ta Tamil
te Telugu
th Thai
tk Turkmen
tl Tagalog
tpi Tok Pisin
tr Turkish
tt Tatar
tyv Tuvinian
ug Uyghur
uk Ukrainian
ur Urdu
uz Uzbek
vec Venetian
vep Veps
vi Vietnamese
vo Volapük
wa Walloon
war Waray
wo Wolof
wuu Wu Chinese
xmf Mingrelian
yi Yiddish
yo Yoruba
za Zhuang
zea Zeelandic
zh Chinese
zh-min-nan Chinese (Min Nan)
zh-yue Cantonese

190 rows × 1 columns

{article:ll_dict['en'] for article,ll_dict in translation_dict.items() if 'en' in ll_dict.keys()}
{}
german_outlinks
['Putsch',
 'Streitkräfte Ägyptens',
 'Oberster Rat der Streitkräfte',
 'Abd al-Fattah as-Sisi',
 'Ägypten',
 'Mohammed Mursi',
 'Ultimatum',
 'Islamismus',
 'Muslimbrüder',
 'Staatskrise in Ägypten 2013',
 'Vereinigte Staaten von Amerika',
 'Europäische Union',
 'Terrorismus',
 'Sinai-Halbinsel',
 'Gotteskrieger',
 'Menschenrechtsorganisation',
 'Husni Mubarak',
 'Putsch',
 'Koptische Kirche',
 'Patriarch',
 'Tawadros II.',
 'Imam',
 'Al-Azhar-Universität',
 'Ahmed Tayeb',
 'Tamarod',
 'Linksliberalismus',
 'Nationale Heilsfront',
 'Mohammed el-Baradei',
 'Salafisten',
 'Partei des Lichts',
 'Hasim al-Beblawi',
 'Staatskrise in Ägypten 2013',
 'Christentum',
 'Bischof',
 'Tawadros II.',
 'Sanktion',
 'Römisch-katholische Kirche',
 'Deutsche Bischofskonferenz',
 'Muslimbrüder',
 'Tiefer Staat',
 'Husni Mubarak',
 'Revolution in Ägypten 2011',
 'Restauration (Geschichte)',
 'Konterrevolution',
 'Parlament',
 'Verfassunggebende Versammlung',
 'Gremium',
 'Husni Mubarak',
 'Nachrichtendienst',
 'Streitkräfte Ägyptens',
 'Demonstration',
 'Protest',
 'Interessengruppe',
 'Unterschriftenaktion',
 'Tamarod',
 'Naguib Sawiris',
 'Infrastruktur',
 'Partei der Freien Ägypter',
 'Verfassungsgerichtsbarkeit',
 'Tahani al-Gebali',
 'Elektrizitätsversorgung',
 'Kraftstoff',
 'Erdgas',
 'Menschenrechte',
 'Folter',
 'Pressefreiheit',
 'Lebensmittelteuerung (Seite nicht vorhanden)',
 'Arbeitslosigkeit',
 'Tankstelle',
 'Stromausfall',
 'Boykott',
 'Kriminalität',
 'Nachrichtendienst',
 'Tawadros II.',
 'Ahmad Mohammad al-Tayyeb',
 'Mohammed el-Baradei',
 'Islam',
 'Al-Azhar-Universität',
 'Linksliberalismus',
 'Mohammed el-Baradei',
 'Salafismus',
 'Partei des Lichts',
 'Elite',
 'Übergangsregierung',
 'Technokratie',
 'Großunternehmen',
 'Gouvernement',
 'Gouverneur',
 'Abd al-Fattah as-Sisi',
 'Mohammed Hussein Tantawi',
 'Gremium',
 'Arbeitslosigkeit',
 'Inflation',
 'Revolution in Ägypten 2011',
 'Verfassung der Republik Ägypten',
 'Gouvernements in Ägypten',
 'Adel al-Chajat',
 'Gamaa Islamija',
 'Al-Azhar-Moschee',
 'Tamarod',
 'Mohammed Mursi',
 'Tahrir-Platz',
 'Al-Wasat-Partei',
 'Streitkräfte Ägyptens',
 'Barack Obama',
 'Mohamed Kamel Amr',
 'Middle East News Agency (Seite nicht vorhanden)',
 'Abd al-Fattah as-Sisi',
 'Hescham Kandil',
 'Abdel Meguid Mahmud',
 'Koalition (Politik)',
 'Universität Kairo',
 'Al-Dschamāʿa al-islāmiyya',
 'Assem Abdel-Maged (Seite nicht vorhanden)',
 'Anne W. Patterson',
 'Mitteleuropäische Sommerzeit',
 'Heliopolis',
 'Greenwich Mean Time',
 'Übergangsregierung',
 'Abd al-Fattah as-Sisi',
 'Vorgezogene Neuwahl',
 'Mahmoud Badr (Seite nicht vorhanden)',
 'Entführung',
 'Wiki Thawra (Seite nicht vorhanden)',
 'Washington Post',
 'Revolution',
 'Stiftung Wissenschaft und Politik',
 'Volker Perthes',
 'Die Zeit',
 'Kurier (Tageszeitung)',
 'Der Spiegel',
 'Putsch',
 'Politikwissenschaft',
 'NDR Info',
 'Putsch',
 'John Kerry',
 'Martin E. Dempsey',
 'Sedki Sobhi (Seite nicht vorhanden)',
 'Gunter Mulack',
 'Türkei',
 'Recep Tayyip Erdoğan',
 'Tunesien',
 'Ennahda',
 'The Daily Beast',
 'Philip J. Crowley',
 'Außenminister der Vereinigten Staaten',
 'Zentrum für Forschung zur Arabischen Welt (Seite nicht vorhanden)',
 'Deutsche Gesellschaft für Auswärtige Politik',
 'Europäische Union',
 'Krieg gegen den Terror',
 'Israelisch-ägyptischer Friedensvertrag',
 'Menschenrechte',
 'Dirk Emmerich (Seite nicht vorhanden)',
 'N-tv',
 'Tiefer Staat',
 'Judikative',
 'Exekutive',
 'Administrative',
 'Revolution in Ägypten 2011',
 'Wirtschaft',
 'Militär',
 'Staat im Staate',
 'Konterrevolution',
 'Elite',
 'Militärparade',
 'Akademischer Grad',
 'Militärakademie',
 'Vierte Gewalt',
 'The Guardian',
 'The Washington Post',
 'Al-Arabiya',
 'Al Jazeera',
 'Deutsche Welle',
 'BBC Arabic (Seite nicht vorhanden)',
 'Analphabetismus',
 'Kinderschänder',
 'Michael Thumann',
 'Bürgerrecht',
 'Arabic Network for Human Rights Information (Seite nicht vorhanden)',
 'Muhammad Badi’e',
 'Rābiʿa-al-ʿAdawiyya-Moschee',
 'Chairat al-Schater',
 'Saad al-Katatni',
 'Freiheits- und Gerechtigkeitspartei',
 'Rashad Bajumi (Seite nicht vorhanden)',
 'Human Rights Watch',
 'Adli Mansur',
 'Marsa Matruh',
 'Kafr asch-Schaich',
 'Alexandria',
 'Al-Minya',
 'Alexandria',
 'Luxor',
 'Damanhur',
 'Konterrevolution',
 'Flughafen al-Arisch',
 'Gouvernement as-Suwais',
 'Gouvernement Dschanub Sina',
 'Hosni Mubarak',
 'Kopten',
 'Kreuzzug',
 'Scharia',
 'Mohammed el-Baradei',
 'Partei des Lichts',
 'Ägyptische Sozialdemokratische Partei',
 'Siad Bahaa El-Din (Seite nicht vorhanden)',
 'Koptische Kirche',
 'Al-Arisch',
 'Verfassung der Republik Ägypten',
 'Voice of America',
 'Afrikanische Union',
 'Republikanische Partei',
 'John McCain',
 'Partei des Lichts',
 'Hasim al-Beblawi',
 'Weltbank',
 'Recep Tayyip Erdoğan',
 'Abdullah Gül',
 'Blutbad in Kairo und Gizeh vom 14. August 2013',
 'Cairo Institute for Human Rights Studies (Seite nicht vorhanden)',
 'Kosovo',
 'Libyen',
 'Syrien',
 'Libanon',
 'Ukraine',
 'Europäische Union',
 'Militärputsch in Ägypten 1952',
 'Gamal Abdel Nasser',
 'Tawadros II.',
 'Ahmad Mohammad al-Tayyeb',
 'Mohammed el-Baradei',
 'Verfassung der Republik Ägypten',
 'Oberstes Verfassungsgericht Ägyptens',
 'Adli Mansur',
 'Übergangsregierung',
 'Technokratie',
 'British Broadcasting Corporation',
 'Nationale Heilsfront',
 'Freiheits- und Gerechtigkeitspartei',
 'Joachim Schroedel',
 'Deutsche Bischofskonferenz',
 'The European',
 'Afrikanische Union',
 'Afrikanische Union',
 'Afrikanische Union',
 'Addis Abeba',
 'Nkosazana Dlamini-Zuma',
 'Revolution in Ägypten 2011',
 'Hosni Mubarak',
 'Mohammed Edrees (Seite nicht vorhanden)',
 'Dekolonisation Afrikas',
 'Deutschland',
 'Deutschland',
 'Guido Westerwelle',
 'Dänemark',
 'Dänemark',
 'Iran',
 'Iran',
 'Jordanien',
 'Jordanien',
 'Katar',
 'Katar',
 'Kuwait',
 'Kuwait',
 'Russland',
 'Russland',
 'Alexej Puchow (Seite nicht vorhanden)',
 'Saudi-Arabien',
 'Saudi-Arabien',
 'Abdullah ibn Abd al-Aziz',
 'Somalia',
 'Somalia',
 'Al-Shabaab (Somalia)',
 'Twitter',
 'Rosarote Brille',
 'Syrien',
 'Syrien',
 'Baschar al-Assad',
 'Türkei',
 'Türkei',
 'Ahmet Davutoğlu',
 'Recep Tayyip Erdoğan',
 'Israel',
 'Tunesien',
 'Tunesien',
 'Moncef Marzouki',
 'Kongress für die Republik (Tunesien)',
 'Vereinigte Arabische Emirate',
 'Vereinigte Arabische Emirate',
 'Chalifa bin Zayid Al Nahyan',
 'Vereinigtes Königreich',
 'Vereinigtes Königreich',
 'William Hague',
 'Vereinigte Staaten',
 'Vereinigte Staaten',
 'Vereinigte Staaten',
 'Tansania',
 'Barack Obama',
 'Tunesien',
 'Algerien',
 'L’Orient-Le Jour',
 'Libanon',
 'The Daily Star (Libanon)',
 'Baschar al-Assad',
 'Syrien',
 'Iran',
 'Bahrain',
 'Gulf News',
 'Vereinigte Arabische Emirate',
 'Israel',
 'Israel HaYom',
 'Jedi’ot Acharonot',
 'Haaretz',
 'Frankreich',
 'Paris',
 'Le Figaro',
 'Ouest-France',
 'The New York Times',
 'Handelsblatt',
 'Die Welt',
 'Süddeutsche Zeitung',
 'Frankfurter Allgemeine Zeitung',
 'Jen Psaki',
 'George Orwell',
 'Neusprech',
 'Federal Reserve Bank of New York',
 'Rüstungsindustrie',
 'General Dynamics F-16',
 'Mehrzweckkampfflugzeug',
 'Hughes AH-64',
 'Kampfhubschrauber',
 'M1 Abrams',
 'Kampfpanzer',
 'Fregatte',
 'Krieg in Afghanistan',
 'Krieg gegen den Terror',
 'Naher Osten',
 'Ostafrika',
 'Freiheiten der Luft',
 'Luftraum',
 'Sueskanal',
 'Ölvorkommen',
 'Naher Osten',
 'Brookings Institution',
 'Demokratiemessung',
 'Demokratiemessung',
 'Husni Mubarak',
 'Anwar as-Sadat',
 'Blutbad in Kairo und Gizeh 2013',
 'Staatskrise in Ägypten 2013/2014 (Kabinett Beblawi)',
 'Chile',
 'Argentinien',
 'Algerien',
 'Martin Gehlen',
 'James Franklin Jeffrey',
 'American Council on Germany',
 'Council on Foreign Relations',
 'George W. Bush']

Run an example article, shows the first all outlinks for all articles in each language .

#pull all out links for each specific language page 
_langlink_AllList_dict=dict()

for lang,title in link_getter(page_title).items():
    LangLinksAll=get_page_outlinks(page_title=title,lang=lang)
   
    _langlink_AllList_dict[lang]=LangLinksAll
    
    
_langlink_AllList_dict
page_outlinks = get_page_outlinks(page_title)
page_outlinks
 

You could write a recursive function like recursively_get_hyperlink_network that would crawl the hyperlink network out to an arbitrary distance, but this is becomes exhorbitantly expensive at any depth greater than 1.

Here's an example function, but is not executable to prevent you from harming yourself. :)

def recursively_get_hyperlink_network(seed_page,depth): neighbors = {} if depth < 0: return neighbors neighbors[seed_page] = get_page_outlinks(seed_page) for neighbor in neighbors[seed_page]: neighbors[neighbor] = get_hyperlink_network(neighbor,depth-1) return neighbors

Instead, define a simple function to get the 1.5-step ego hyperlink network. The "ego" is the seed page you start from, the "alters" are the neighbors that the ego links out to. We also get the alters of the alters (2nd order alters), but only include these 2nd order connections if they link to 1st order alters. In other words, the 1.5-step ego hyperlink network are all the pages linked from the seed page and the connections among this set of articles.

def get_hyperlink_alters(seed_page):
    # Initialize an empty dictionary to act as an adjacency "list"
    neighbors = {}
    
    # Get all the alters for the seed page and store them in the adjacency dictionary
    neighbors[seed_page] = get_page_outlinks(seed_page,1)
    
    # For each of the alters, get their alters and store in the adjacency dictionary
    for neighbor in list(set(neighbors[seed_page])): # Don't recrawl duplicates
        neighbors[neighbor] = get_page_outlinks(neighbor,0)
    
    # Initialize an empty graph that we will add nodes and edges into
    g = nx.DiGraph()
    
    # For each entry in the adjacency dictionary, check if the alter's alters are also the seed page's alters
    # If they are and the edge is already in the graph, increment the edge weight by one
    # If they are but the edge is not already in the graph, add the edge with a weight of one
    for article,neighbor_list in neighbors.items():
        for neighbor in neighbor_list:
            if neighbor in neighbors[seed_page] + [seed_page]:
                if g.has_edge(article,neighbor):
                    g[article][neighbor]['weight'] += 1
                else:
                    g.add_edge(article,neighbor,weight=1)
    
    # Return the weighted graph
    return g

Run this on an example article and save the resulting graph object to disk.

This step could take more than a minute depending on the number of links and size of the neighboring pages.

# Create the hyperlink network
hyperlink_g = get_hyperlink_alters(page_title)

# Save the graph to disk to visualize in Gephi
nx.write_graphml(hyperlink_g,'hyperlink_{0}.graphml'.format(page_title.replace(' ','_')))
hg_nodes = hyperlink_g.number_of_nodes()
hg_edges = hyperlink_g.number_of_edges()

print("There are {0} nodes and {1} edges in the hyperlink network.".format(hg_nodes,hg_edges))
hg_density = nx.density(hyperlink_g)
print('{0:.2%} of the possible edges actually exist.'.format(hg_density))
def reciprocity(g):
    reciprocated_edges = []
    
    for (i,j) in g.edges():
        if hyperlink_g.has_edge(j,i):
            reciprocated_edges.append((i,j))
    
    return len(reciprocated_edges)/float(g.number_of_edges())

hg_reciprocity = reciprocity(hyperlink_g)

print('{0:.2%} of the edges in the hyperlink network are reciprocated.'.format(hg_reciprocity))

Play the Wikipedia Game!

Using only the hyperlinks on the article, try to get from the first article to the second article.

page1,page2 = np.random.choice(list(hyperlink_g.nodes()),2)
print("Try to navigate from \"{0}\" to \"{1}\" using only hyperlinks.\n".format(page1,page2))
print("Start at: https://en.wikipedia.org/wiki/{0}".format(page1.replace(' ','_')))

No cheating!

After you've played the game a few times, see what an optimal shortest path is. You may get an error indicating there is no shortest path, in which case, try a new pair of nodes.

nx.shortest_path(hyperlink_g,page1,page2)

The shortest path length is the path connecting two nodes in the fewest steps. This is related to the "small world" effect where everyone in the world is just a few handshakes from each other. It's rare to find complex networks where the longest shortest path is above 5. Nodes that are this far from each other are likely about very unrelated topics.

If there are no paths greater than 5, lower the path_length_threshold from 5 to 4.

The long_path_lengths dictionary below is populated by computing all the shortest path lengths between nodes in the network and only keeping those paths that are longer than 5 steps from each other. In a directed graph like our hyperlink network, it's important to follow the direction of the arrows: if page A links to page B but page B doesn't link to page A, then we can't make a shortest path from B to A, we have to find another path.

path_length_threshold = 4
long_path_lengths = {}

for k,d in nx.all_pairs_shortest_path_length(hyperlink_g).items():
    long_paths = [v for v,l in d.items() if l > path_length_threshold]
    if len(long_paths) > 0:
        long_path_lengths[k] = long_paths
        
long_path_lengths.keys()

The shortest path between the articles can be identified using the shortest_path function and supplying the graph and the names of two nodes.

# Randomly choose two articles in the list of long shortest paths
page1,page2 = np.random.choice(list(long_path_lengths.keys()),2)
print("The two pages randomly selected are: \"{0}\" and \"{1}\"".format(page1,page2))

# Display the path between these articles
nx.shortest_path(hyperlink_g,page1,page2)

Test out different combinations of articles from the long_path_lengths to find the articles that are farthest apart by entering different article names for page1 and page2.

page1 = 'National Association for Business Economics'
page2 = 'NATO'
nx.shortest_path(hyperlink_g,page1,page2)
hg_in_degree_d = {node:int(centrality*(len(hyperlink_g) - 1)) for node,centrality in nx.in_degree_centrality(hyperlink_g).items()}
hg_out_degree_d = {node:int(centrality*(len(hyperlink_g) - 1)) for node,centrality in nx.out_degree_centrality(hyperlink_g).items()}

Look at the nodes with the highest in-degree: other pages in the network point to this page.

degree_df = pd.DataFrame({'In':hg_in_degree_d,'Out':hg_out_degree_d})
degree_df['In'].sort_values(ascending=False).head(10)

Look at the nodes with the highest-out-degree: these pages point to many other pages.

degree_df['Out'].sort_values(ascending=False).head(10)

Look at the nodes that have no links out.

degree_df.query('Out == 0')['Out']

Look at nodes that have a single link in. These are also known as (in-) pendants. If there are none, it should appear as an empty series.

degree_df.query('In == 1')['In']

Look at the nodes with a single link out. These are also known as (out-)pendants. If there are none, it should appear as an empty series.

degree_df.query('Out == 1')['Out']

Given a page, what are the neighbors that link in to it? Assign a specific article title to the page1 variable by replacing the np.random.choice(degree_df.index)

page1 = np.random.choice(degree_df.index)

in_connections = hyperlink_g.predecessors(page1)
print("The links into node \"{0}\" are:\n{1}".format(page1,in_connections))
out_connections = hyperlink_g.successors(page1)
print("The links out from node \"{0}\" are:\n{1}".format(page1,out_connections))
in_degree_dist_df = degree_df['In'].value_counts().reset_index()
out_degree_dist_df = degree_df['Out'].value_counts().reset_index()

f,ax = plt.subplots(1,1)
in_degree_dist_df.plot.scatter(x='index',y='In',ax=ax,c='blue',label='In')
out_degree_dist_df.plot.scatter(x='index',y='Out',ax=ax,c='red',label='Out')
ax.set_xscale('symlog')
ax.set_yscale('symlog')
ax.set_xlim((0,1e3))
ax.set_ylim((0,1e3))

ax.set_xlabel('Connections')
ax.set_ylabel('Count')

Calculate communities within the network

Define a function to compute node community memberships for multiple community detection algorithms within igraph. The output is a dictionary of dictionaries where the top-level key is the name of the algorithm and returns a second-level dictionary keyed by the the page name with values being the community membership value. Documentation and details about these algorithms can be found under the igraph graph-class documentation.

def comparative_community_detector(igraph):
    memberships = {}
    
    # Directed memberships
    memberships['betweenness'] = igraph.community_edge_betweenness().as_clustering().membership
    memberships['infomap'] = igraph.community_infomap().membership
    memberships['spinglass'] = igraph.community_spinglass().membership
    memberships['walktrap'] = igraph.community_walktrap().as_clustering().membership
    
    # Undirected memberships
    undirected = igraph.as_undirected()
    memberships['fastgreedy'] = undirected.community_fastgreedy().as_clustering().membership
    memberships['leading_eigenvector'] = undirected.community_leading_eigenvector().membership
    memberships['multilevel'] = undirected.community_multilevel().membership
    
    labelled_memberships = {}
    for label,membership in memberships.items():
        labelled_memberships[label] = dict(zip(igraph.vs['id'],membership))
        
    return labelled_memberships

Not included in the comparative_community_detector function are two additional community detection algorithms that are too intensive or are not working properly. They're documented below if you ever care to explore in the future.

# Uses up a ton of memory and crashes kernel immediately ig_hg_optimal_modularity = hyperlink_g.community_optimal_modularity().membership ig_hg_optimal_modularity_labels = dict(zip(ig_hg.vs['id'],ig_hg_optimal_modularity)) pd.Series(ig_hg_optimal_modularity_labels).value_counts().head(10) # Lumps everyone into a single community ig_hg_label_propagation = hyperlink_g.community_label_propagation(initial=range(ig_hg_d.vcount()),fixed=[False]*ig_hg_d.vcount()).membership ig_hg_label_propagation_labels = dict(zip(ig_hg_d.vs['id'],ig_hg_label_propagation)) pd.Series(ig_hg_label_propagation_labels).value_counts().head(10)

Here we need to shift from using the networkx library to using the igraph library. The former is built purely in Python which makes it easier-to-use but somewhat slower while the latter is a "wrapper" that lets us write in Python but does the calculations in much-faster C code behind-the-scenes.

# Load the hyperlink network data from disk into a networkx graph object
nx_hg = nx.read_graphml('hyperlink_{0}.graphml'.format(page_title.replace(' ','_')))

# Load the hyperlink network data from disk into a igraph graph object
ig_hg = ig.read('hyperlink_{0}.graphml'.format(page_title.replace(' ','_')))
ig.summary(ig_hg) # Get statistics about the 

Run the function on the igraph version of the hyperlink network.

This may take a minute or more since these are intensive calculations

# Run the community detection labelling on the igraph graph object
comparative_community_labels = comparative_community_detector(ig_hg)

# Convert the node labels into a dict-of-dicts keyed by page name and inner-dict containing community labels
comparative_community_labels_transposed = pd.DataFrame(comparative_community_labels).to_dict('index')

# Update each node in the networkx graph object to reflect the community membership labels
for _node in nx_hg.nodes():
    try:
        nx_hg.node[_node]['label'] = _node
        for (label,membership) in comparative_community_labels_transposed[_node].items():
            nx_hg.node[_node][label] = int(membership)
    except KeyError: # Concerning that some labels aren't present, but skip them for now
        print("Error in assigning \"{0}\" to a community.".format(_node))
        pass

# Write the labeled graph back to disk to visualize in Gephi
nx.write_graphml(nx_hg,'hyperlink_communities_{0}.graphml'.format(page_title.replace(' ','_')))
SCRAPS


def translation_getter(page_title, lang='de', target_lang):
    
    _T="https://en.wikipedia.org/w/api.php?action=query&format=json&prop=langlinks&titles={0}&llprop=autonym|langname&lllimit=500".format(page_title)
    
    req = requests.get(_T)

    json_string = json.loads(req.text)
    
    _pageID=list(json_string['query']['pages'].keys())[0]

    _translation_list=json_string['query']['pages'][_pageID]['langlinks']
    
    _translation_dict=dict()

    for translate in german_outlinks:
        translate_lang=translate['en']
        translate_title=translate['*']
        _translation_dict[translate_lang]=translate_title
        
    
    return _translation_dict



translation_getter(page_title)

translate_links_en_dict=dict()

for lang,title in german_outlinks(page_title,lang).items():
    translate_links_en=german_outlinks(page_title=title,lang='en')
    
    translate_links_en_dict['en']=translate_links_en
    
    
    
#check language links for translation in other pages
#def outlink_translater(page_title,lang,page_outlinks):
    
translated_links_dict = dict()
    
    for lang,title,outlinks in _langlink_AllList_dict.items():
        translatedLinks=lan
titles_and_lang_dict = {}

#importantInfo = link_getter(page_title)

#for _langlink_dict in 


important_info = link_getter(page_title)

for lang,title in important_info.items():
    titles_and_lang_dict[lang]=title

    
    #for _lang,_title,_langname in link_getter(page_title,_lang,_langname).items():
    #titles_and_lang_dict[lang]=_title,_langname
    
    #titles_and_lang_dict['en'] = page_title
    
    
    #_lang=o['lang']
    #_title=o['*']
    #_langname=o['langname']
    #titles_and_lang_dict[lang]=_title,_langname,
    #importantInfo = _langlink_list(lang,title,langname)
    #importantInfo = link_getter(title,lang)
    #titles_and_lang_dict[lang] = importantInfo
    
    #importantInfo(lang,title,langname)




#important_info.items():
    #important_info[lang] = 

    
    #outlinks_per_lang = {}

#language_titles = link_getter(page_title)

#for lang,title in language_titles.items():
                #print("The language is",lang,"and the article title is", title)
    #outlinks_per_lang[lang] = get_page_outlinks(title,lang)
    
#_langlink_AllList_dict=dict()

#for lang,title in link_getter(page_title).items():
    #LangLinksAll=get_page_outlinks(page_title=title,lang=lang)
   
    #_langlink_AllList_dict[lang]=LangLinksAll