play.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 122,
   "id": "a9ede83e-06ad-4ba5-98f7-327769262933",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pathlib import Path\n",
    "from udhr_align import read_tsvs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "a6297c6d-764c-4f9b-9f00-f9d0b46a5294",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "romanized/  segments-histogram.pdf  tsvs/  xmls/\n"
     ]
    }
   ],
   "source": [
    "ls data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "id": "0ec81961-1f5e-44bd-8f3b-9b02271864e0",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "2021-11-12 08:34:37,794 - udhr_align - INFO - Found 486 files in data/tsvs\n",
      "2021-11-12 08:34:38,153 - udhr_align - INFO - Creating a table of Langs x Segs = 486x135\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Lang</th>\n",
       "      <th>00-00</th>\n",
       "      <th>00-01</th>\n",
       "      <th>00-02</th>\n",
       "      <th>00-03</th>\n",
       "      <th>00-04</th>\n",
       "      <th>00-05</th>\n",
       "      <th>00-06</th>\n",
       "      <th>00-07</th>\n",
       "      <th>00-08</th>\n",
       "      <th>...</th>\n",
       "      <th>28-01</th>\n",
       "      <th>28-02</th>\n",
       "      <th>28-03</th>\n",
       "      <th>29-00</th>\n",
       "      <th>29-01</th>\n",
       "      <th>29-02</th>\n",
       "      <th>29-03</th>\n",
       "      <th>30-00</th>\n",
       "      <th>30-01</th>\n",
       "      <th>30-02</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>007</td>\n",
       "      <td>Declaraçón Universal di Dirêtu di Hómé</td>\n",
       "      <td>Punda dignidade di tudo nguê di mundu e dirêtu...</td>\n",
       "      <td>Punda fata di conheximentu e displêzu di dirêt...</td>\n",
       "      <td>Punda ploteçón di dirêtu di hómé baseado ni ua...</td>\n",
       "      <td>Punda ê sá importante lumadu conselhá disenvol...</td>\n",
       "      <td>Punda ni Cata, tudu pôvô di Naçón Unida plocla...</td>\n",
       "      <td>Punda tudu Estado memblu xiná complomissu cuma...</td>\n",
       "      <td>Punda ua mêma conceçón di nen dirêtu cu liberd...</td>\n",
       "      <td>Assembleia Geral</td>\n",
       "      <td>...</td>\n",
       "      <td>Tudu nguê tê dirêtu di fé pa zisti, ni plano s...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Artigo 29º</td>\n",
       "      <td>Qualqué ngué tê obligaçón ni glupu dê, e xi ê ...</td>\n",
       "      <td>Óla qualqué nguê ca gozá dirêtu cu liberdade, ...</td>\n",
       "      <td>Tudu dirêtu cu liberdade sé na ca pô zisti con...</td>\n",
       "      <td>Artigo 30º</td>\n",
       "      <td>Tudu cuá cu sá ni Declaraçón sé na ca pô plimi...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>008</td>\n",
       "      <td>DECLARAÇON UNIVERSAL DI DIRITU DI OMIS</td>\n",
       "      <td>Suma qui qui ricunhicidu dignidadi di tudu mem...</td>\n",
       "      <td>Suma falta di cunsi, cu disprezu di diritu di ...</td>\n",
       "      <td>Omi padidu pa viki, pa quila I dibidi tadjadu ...</td>\n",
       "      <td>Suma na mundu tudu djintis díbidi mama, I purc...</td>\n",
       "      <td>Suma qui carta qui Naçon Unida scribi pa si po...</td>\n",
       "      <td>Suma stadus qui pui na son djurmenti pui mon p...</td>\n",
       "      <td>Só ora qui tudu djintis intindi diritu ê barba...</td>\n",
       "      <td>ASSEMBLEIA GERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Na ê Declaração, tudu pecadur tem diritu di fa...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>ARTIGO 29º.</td>\n",
       "      <td>Cada pecadur tem quê qui díbidi fassi na si co...</td>\n",
       "      <td>Na tudu diritu que faladu na ê declaçon, ora q...</td>\n",
       "      <td>Nin un dia ês diritus cu liberdadis ca pudi fa...</td>\n",
       "      <td>ARTIGO 30º.</td>\n",
       "      <td>Ninguin ca pudi ncunha na nin un palabra di ê ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>009</td>\n",
       "      <td>?</td>\n",
       "      <td>O kutetulula kuila, o kuijia o ujitu mu ukunji...</td>\n",
       "      <td>O kutetulula kuila o mutu mu ku kamba o kuijia...</td>\n",
       "      <td>O kutetulula uixi, kia tokala bu kale o dikuat...</td>\n",
       "      <td>O kutetulula kuila, kia tokala o dikuatenenu d...</td>\n",
       "      <td>O kutetulula kuila, o mukanda ua kifuxi kia ng...</td>\n",
       "      <td>O kutetulula kuila o Jinguvulu ja Jimbandu ia ...</td>\n",
       "      <td>Mu kutetulula kuila o mu dixiganeku dimoxi dia...</td>\n",
       "      <td>O KIONGE KIA KISANGELA</td>\n",
       "      <td>...</td>\n",
       "      <td>Mutu uoso uoso uala ni ubinganu ua kuxinganeka...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MAKUINHI AIADI NI DIVUA</td>\n",
       "      <td>Mutu uoso uoso ua tokala kubanga ni ujitu imba...</td>\n",
       "      <td>Mu kikalakalu kia ubinganu uoso, ni mu kutana ...</td>\n",
       "      <td>Kanaku kima, maka, mba imbamba itenesu ku tobe...</td>\n",
       "      <td>MAKUINHI ATATU</td>\n",
       "      <td>Kanaku utundilu ua kamukua uambote, ukexilu mb...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010</td>\n",
       "      <td>Deklarasaun kona ba Ema tomak nia Direitu, iha...</td>\n",
       "      <td>- atu bele moris ho liberdade, ho justisa, ho ...</td>\n",
       "      <td>- tan lakohi simu, tan heuuai ema nia direitu ...</td>\n",
       "      <td>- atu tahan ema tomak nia direitu tuir ukun ho...</td>\n",
       "      <td>- atu buka hametin damen iha nasaun tomak.</td>\n",
       "      <td>- iha Surat Deklarasaun ne’e, Nasaun tomak fo ...</td>\n",
       "      <td>- Nasaun tomak iha O.N.U. tau lia ba malu atu ...</td>\n",
       "      <td>- atu ema tomak halo tuir lia hirak ne’e be fo...</td>\n",
       "      <td>Asembleia Boot</td>\n",
       "      <td>...</td>\n",
       "      <td>Naran ema ida iha direitu, iha fatin ne’e be n...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Artigu 29</td>\n",
       "      <td>Naran ema ida sei halo buat ruma ba nia rain, ...</td>\n",
       "      <td>Atu moris ho direitu, atu bele hetan liberdade...</td>\n",
       "      <td>Hotu-hotu sei tuir lolós direitu ho liberdade ...</td>\n",
       "      <td>Artigu 30</td>\n",
       "      <td>Naran Nasaun ida, klibur ruma e naran ema ida,...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>011</td>\n",
       "      <td>Ohuminyo Yoluali Yoku Tata Ovimuenyo Viomanu</td>\n",
       "      <td>Unu womanu loku sumbila omuenyo wapata omanu v...</td>\n",
       "      <td>Ekambo liu kulihiso kuenda oku pembula ovihand...</td>\n",
       "      <td>Okutata omuenyo womanu oco cavelapo , kuenje c...</td>\n",
       "      <td>Ca sesamela okuti pokati kolofeka viosi pa kal...</td>\n",
       "      <td>Ekolelõ liomanu vosi va tiamela ko Hongele Yol...</td>\n",
       "      <td>Olofeka viosi vi tiamelã ko Hongele Yolofeka (...</td>\n",
       "      <td>Kovisila evi vioku tata omuenyo womanu oko ku ...</td>\n",
       "      <td>Onjango Yinene</td>\n",
       "      <td>...</td>\n",
       "      <td>Omunu wosi okuete omoko yoku kisika okuti ovih...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>ONDAKA YA 29</td>\n",
       "      <td>Omunu wosi okuete ovikele lovocisoko a atiamel...</td>\n",
       "      <td>Ko kusuisapo ovihandeleko evi loku vitelisa ok...</td>\n",
       "      <td>Ovihandeleko evi vilingiwa lika oku kolisa ong...</td>\n",
       "      <td>ONDAKA YA 30</td>\n",
       "      <td>Lacimue ocihandeleko casonehiwa vu Vangi mulo ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>zdj</td>\n",
       "      <td>ANZIMIYO LA KILEMWENGU UHSU ZE HAKI ZAKI BINADAMU</td>\n",
       "      <td>1- Ha mwakinisho ukaya ho ukubali ye sheo shah...</td>\n",
       "      <td>2- Ha mwakinisho ukaya wo upuzi no uwoneya ze ...</td>\n",
       "      <td>3- Ha mwakinisho ukaya zo muhimu ho uhifadhwi ...</td>\n",
       "      <td>4- Ha mwakinisho ukaya zo muhimu ho utriya dji...</td>\n",
       "      <td>5- Ha mwakinisho ukaya harimwa le katiba mshin...</td>\n",
       "      <td>6- Ha mwakinisho ukaya ze daula wanashama zidj...</td>\n",
       "      <td>7- Ha mwakinisho ukaya mwelewano sawa wapwadzi...</td>\n",
       "      <td>8- Le Barazaka Kuu lahe Djumuyian ya madola ng...</td>\n",
       "      <td>...</td>\n",
       "      <td>Haina mwanadamu ngena haki pvakaye myenshi har...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Faslu ya yishiri na shenda</td>\n",
       "      <td>Ye mwanadamu ngena wadjau ze wadjibu zahahe ho...</td>\n",
       "      <td>Ze haki ne ze nafasi za haina mdru nkazitsina ...</td>\n",
       "      <td>Ze haki ne ze nafasi yizo nkazina udjuwa, hain...</td>\n",
       "      <td>Faslu ya mengo miraru</td>\n",
       "      <td>Kapvatsi faslu yahe le Katiba linu lidjo udjuw...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>zgh</td>\n",
       "      <td>ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ</td>\n",
       "      <td>ⵍⵍⵉⵖ ⵜⴳⴰ ⵜⵓⴽⵣⴰ ⵏ ⵓⵍⵍⴰⵍⵓ ⵏ ⴽⴰⵢⴳⴰⵜ ⵢⴰⵏ ⵖ ⵜⴰⵡⵊⴰ ⵜ...</td>\n",
       "      <td>ⵜⴳ ⵜⴰⵎⵜⵜⴰⵡⵜ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ ⴰⴷ ⵉⵜⵜⴰⵡⵉⵏ ⵜⵓⴳⵜⵜ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴳ ⵏ ⵉⵣⵔⴼⴰⵏⵏ ⵏ ⵓⵎⴷⴰⵏ ⵢⴰⵏ ⵓⴼⴳⴳⴰⴳ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⵍⵍⴰ ⴳ ⵜⵏⵜⵜⴰⵎⵜ ⵉⴷ ⵉⴳⴷⵓⴷⵏ ⵏ ⵜⵎⵜⵜⴰ ⵉⵎⵓⵏⵏ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵎⵙⵓⵛⴽⴰⵏ ⵉⵡⴰⵏⴽⵏ ⵉⴳⵎⴰⵎⵏ, ⵙ ⵜⵡⵙⵉⵏ ⵏ ⵜⵎⴰⴷⴷⴰ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴽ ⵙ ⵉⵣⵔⴼⴰⵏ ⴷ ⵜⴷⵔⴼⵉⵜ ⴰⵙⴽⴽⵉⵏ ⴰⴽⵙⵡ...</td>\n",
       "      <td>ⵉⵙⵙⴰⴼⵖ ⴷ ⵓⴳⵔⴰⵡ ⴰⵎⴰⵜⴰⵢ ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ...</td>\n",
       "      <td>ⴰⵍⵖⵓ ⴰⴷ, ⴰⴷ ⴷⵓⵙⵏ, ⵙ ⵓⵙⵙⵍⵎⴷ ⴷ ⵓⵙⴳⵎⵉ, ⵙⴱⵓⵖⵍⵓⵏ ⴷ ...</td>\n",
       "      <td>...</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⴰⴷ ⵉⵙⴼⴰⵢⴷ ⵖ ⵓⵖⴰⵡⴰⵙ ⴰⵏⴰⵎⵓ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 29</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⴰⵔ ⵉⵜⵜⴰⵡⵙ ⵖ ⵜⵡⵉⵣⵉ ⵏ ⵡⴰⵎⵓⵏ ⵙ ⵓⵢⵏⵏⴰ ⵎⵓ ⵉⵥ...</td>\n",
       "      <td>ⴰⵔ ⵏⵏ ⵉⵜⵜⴷⵓⵍ ⵓⴼⴳⴰⵏ ⵙ ⵉⵙⴽⵔⴰⴼ ⵍⵍⵉ ⵉⵍⵍⴰⵏ ⴳ ⵓⵙⵍⴳⵏ ...</td>\n",
       "      <td>ⵖⵉⴽⵏⵏⴰ ⴽⴰ ⴳⴰⵏⵜ ⵜⵖⴰⵡⵙⵉⵡⵉⵏ ⵓⵔ ⴷ ⵉⵇⵇⴰⵏ ⴰⴷ ⵎⵎⵙⴽⴰⵔⵏ...</td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 30</td>\n",
       "      <td>ⵓⵔ ⵉⵍⵍⵉ ⵖ ⵓⵍⵖⵓ ⴰⴷ ⴽⵔⴰ ⵏ ⵓⴹⵕⵉⵚ ⴰⴼⴰⴷ ⴰⴷ ⵉⵙⵎⴷⵢⴰ ⴽ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>zro</td>\n",
       "      <td>?</td>\n",
       "      <td>Panichanu tamasa taykua kayapi kupanimajicha i...</td>\n",
       "      <td>Panichanu ikicha tamanu rikuanu kupanimajicha ...</td>\n",
       "      <td>Panicha cha nuka nishima niata akuinaja aramuj...</td>\n",
       "      <td>Panicha aramujun kiniana kupanicha majicha iki...</td>\n",
       "      <td>Kiraitia kiniana amimaja</td>\n",
       "      <td>Akatsajuka anicha ahi</td>\n",
       "      <td>Akatsuju kiraitia rikuanu kayapuina ta nuka ti...</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>Kawiriya kayapi ichanu ikicha rikuanu ta nuka ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Akatsuju 29</td>\n",
       "      <td>Kawiriaja ichanu ikicha utatinuka charanishija...</td>\n",
       "      <td>Ta nuka cha meiri ku rikuanu ta nuka tawijuka ...</td>\n",
       "      <td>Ku ikicha nuka rikuanu ta nukaka puchakirinu t...</td>\n",
       "      <td>Akatsuju30</td>\n",
       "      <td>Taikua tamasa ikicha kayapi atijianuka ikicha ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>ztu</td>\n",
       "      <td>Declarasyoony x:te:e'n Deree'ch x:te:e' Ra'ta'...</td>\n",
       "      <td>Zi'cy na:a dignidaa deree'ch nah x:te:e' ra'ta...</td>\n",
       "      <td>Zi'cy na:a gahll quei'ty runybe:e' ra deree'ch...</td>\n",
       "      <td>Zi'cy na:a na:a pahr chu' le'i nih guuny prote...</td>\n",
       "      <td>Zi'cy na:a na:a pahr ga'c ra nasyoony amiiegw,</td>\n",
       "      <td>Zi'cy na:a ra bu:unny x:te:e'n Naciones Unidas...</td>\n",
       "      <td>Zi'cy na:a ra mye'mmr x:te:e'n Naciones Unidas...</td>\n",
       "      <td>Zi'cy na:a na:a pahr ga'cbe:e' bu:unny ra dere...</td>\n",
       "      <td>Nah chiru'</td>\n",
       "      <td>...</td>\n",
       "      <td>Ra'ta' bu:unny ra:a'p deree'ch chu' gax:lyuh l...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Ga:ally Ahbga:a:a' (29)</td>\n",
       "      <td>Ra'ta' bu:unny na:a pahr yde:e:i'dy ze:i'ny la...</td>\n",
       "      <td>Ra le'i na:a pahr chu'ihzy pahr ga'pdo:o ra de...</td>\n",
       "      <td>Ra'ta' bu:unny na:a pahr chu' zi'cy nih canni:...</td>\n",
       "      <td>Ga:ally Ahbtsë:ë' (30)</td>\n",
       "      <td>Nye:e'cy te'ihby nasyoony nye:e'cy te'ihby bu:...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>zul</td>\n",
       "      <td>UMBHALO OGCWELE WOGUNYAZO LWAMALUNGELO OLUNTU ...</td>\n",
       "      <td>Ngokunjalo ukwamukelwa ngokuzuzwa kwesithunzi ...</td>\n",
       "      <td>Ngokunjalo ukunganakwa nokwedelelwa kwamalunge...</td>\n",
       "      <td>Ngokunjalo kudingekile, uma umuntu engenakupho...</td>\n",
       "      <td>Ngokunjalo kudingekile ukuba kwenyuswe ukuthut...</td>\n",
       "      <td>Ngokunjalo abantu beNhlangano yeZizwe bayinqin...</td>\n",
       "      <td>Ngokunjalo aMalunga eMibuso azibophezele mathu...</td>\n",
       "      <td>Ngokunjalo ukuqondwa kahle ngokufanayo kwalama...</td>\n",
       "      <td>MANJE, NGAKHOKE</td>\n",
       "      <td>...</td>\n",
       "      <td>Wonke umuntu emphakathini nasemhlabeni kumele ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Isigaba 29</td>\n",
       "      <td>Wonke umuntu uneqhaza emphakathini okuwukuphel...</td>\n",
       "      <td>Ekusebenziseni amalungelo nenkululeko yakhe, u...</td>\n",
       "      <td>Lamalungelo nenkululeko akunakusetshenziswa ng...</td>\n",
       "      <td>Isigaba 30</td>\n",
       "      <td>Akukho lutho okukuloluGunyazo okuyohunyushwa n...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>486 rows × 136 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Lang                                              00-00  \\\n",
       "0    007             Declaraçón Universal di Dirêtu di Hómé   \n",
       "1    008             DECLARAÇON UNIVERSAL DI DIRITU DI OMIS   \n",
       "2    009                                                  ?   \n",
       "3    010  Deklarasaun kona ba Ema tomak nia Direitu, iha...   \n",
       "4    011       Ohuminyo Yoluali Yoku Tata Ovimuenyo Viomanu   \n",
       "..   ...                                                ...   \n",
       "481  zdj  ANZIMIYO LA KILEMWENGU UHSU ZE HAKI ZAKI BINADAMU   \n",
       "482  zgh                      ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ   \n",
       "483  zro                                                  ?   \n",
       "484  ztu  Declarasyoony x:te:e'n Deree'ch x:te:e' Ra'ta'...   \n",
       "485  zul  UMBHALO OGCWELE WOGUNYAZO LWAMALUNGELO OLUNTU ...   \n",
       "\n",
       "                                                 00-01  \\\n",
       "0    Punda dignidade di tudo nguê di mundu e dirêtu...   \n",
       "1    Suma qui qui ricunhicidu dignidadi di tudu mem...   \n",
       "2    O kutetulula kuila, o kuijia o ujitu mu ukunji...   \n",
       "3    - atu bele moris ho liberdade, ho justisa, ho ...   \n",
       "4    Unu womanu loku sumbila omuenyo wapata omanu v...   \n",
       "..                                                 ...   \n",
       "481  1- Ha mwakinisho ukaya ho ukubali ye sheo shah...   \n",
       "482  ⵍⵍⵉⵖ ⵜⴳⴰ ⵜⵓⴽⵣⴰ ⵏ ⵓⵍⵍⴰⵍⵓ ⵏ ⴽⴰⵢⴳⴰⵜ ⵢⴰⵏ ⵖ ⵜⴰⵡⵊⴰ ⵜ...   \n",
       "483  Panichanu tamasa taykua kayapi kupanimajicha i...   \n",
       "484  Zi'cy na:a dignidaa deree'ch nah x:te:e' ra'ta...   \n",
       "485  Ngokunjalo ukwamukelwa ngokuzuzwa kwesithunzi ...   \n",
       "\n",
       "                                                 00-02  \\\n",
       "0    Punda fata di conheximentu e displêzu di dirêt...   \n",
       "1    Suma falta di cunsi, cu disprezu di diritu di ...   \n",
       "2    O kutetulula kuila o mutu mu ku kamba o kuijia...   \n",
       "3    - tan lakohi simu, tan heuuai ema nia direitu ...   \n",
       "4    Ekambo liu kulihiso kuenda oku pembula ovihand...   \n",
       "..                                                 ...   \n",
       "481  2- Ha mwakinisho ukaya wo upuzi no uwoneya ze ...   \n",
       "482  ⵜⴳ ⵜⴰⵎⵜⵜⴰⵡⵜ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ ⴰⴷ ⵉⵜⵜⴰⵡⵉⵏ ⵜⵓⴳⵜⵜ ...   \n",
       "483  Panichanu ikicha tamanu rikuanu kupanimajicha ...   \n",
       "484  Zi'cy na:a gahll quei'ty runybe:e' ra deree'ch...   \n",
       "485  Ngokunjalo ukunganakwa nokwedelelwa kwamalunge...   \n",
       "\n",
       "                                                 00-03  \\\n",
       "0    Punda ploteçón di dirêtu di hómé baseado ni ua...   \n",
       "1    Omi padidu pa viki, pa quila I dibidi tadjadu ...   \n",
       "2    O kutetulula uixi, kia tokala bu kale o dikuat...   \n",
       "3    - atu tahan ema tomak nia direitu tuir ukun ho...   \n",
       "4    Okutata omuenyo womanu oco cavelapo , kuenje c...   \n",
       "..                                                 ...   \n",
       "481  3- Ha mwakinisho ukaya zo muhimu ho uhifadhwi ...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴳ ⵏ ⵉⵣⵔⴼⴰⵏⵏ ⵏ ⵓⵎⴷⴰⵏ ⵢⴰⵏ ⵓⴼⴳⴳⴰⴳ ...   \n",
       "483  Panicha cha nuka nishima niata akuinaja aramuj...   \n",
       "484  Zi'cy na:a na:a pahr chu' le'i nih guuny prote...   \n",
       "485  Ngokunjalo kudingekile, uma umuntu engenakupho...   \n",
       "\n",
       "                                                 00-04  \\\n",
       "0    Punda ê sá importante lumadu conselhá disenvol...   \n",
       "1    Suma na mundu tudu djintis díbidi mama, I purc...   \n",
       "2    O kutetulula kuila, kia tokala o dikuatenenu d...   \n",
       "3           - atu buka hametin damen iha nasaun tomak.   \n",
       "4    Ca sesamela okuti pokati kolofeka viosi pa kal...   \n",
       "..                                                 ...   \n",
       "481  4- Ha mwakinisho ukaya zo muhimu ho utriya dji...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⵍⵍⴰ ⴳ ⵜⵏⵜⵜⴰⵎⵜ ⵉⴷ ⵉⴳⴷⵓⴷⵏ ⵏ ⵜⵎⵜⵜⴰ ⵉⵎⵓⵏⵏ ...   \n",
       "483  Panicha aramujun kiniana kupanicha majicha iki...   \n",
       "484     Zi'cy na:a na:a pahr ga'c ra nasyoony amiiegw,   \n",
       "485  Ngokunjalo kudingekile ukuba kwenyuswe ukuthut...   \n",
       "\n",
       "                                                 00-05  \\\n",
       "0    Punda ni Cata, tudu pôvô di Naçón Unida plocla...   \n",
       "1    Suma qui carta qui Naçon Unida scribi pa si po...   \n",
       "2    O kutetulula kuila, o mukanda ua kifuxi kia ng...   \n",
       "3    - iha Surat Deklarasaun ne’e, Nasaun tomak fo ...   \n",
       "4    Ekolelõ liomanu vosi va tiamela ko Hongele Yol...   \n",
       "..                                                 ...   \n",
       "481  5- Ha mwakinisho ukaya harimwa le katiba mshin...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵎⵙⵓⵛⴽⴰⵏ ⵉⵡⴰⵏⴽⵏ ⵉⴳⵎⴰⵎⵏ, ⵙ ⵜⵡⵙⵉⵏ ⵏ ⵜⵎⴰⴷⴷⴰ...   \n",
       "483                           Kiraitia kiniana amimaja   \n",
       "484  Zi'cy na:a ra bu:unny x:te:e'n Naciones Unidas...   \n",
       "485  Ngokunjalo abantu beNhlangano yeZizwe bayinqin...   \n",
       "\n",
       "                                                 00-06  \\\n",
       "0    Punda tudu Estado memblu xiná complomissu cuma...   \n",
       "1    Suma stadus qui pui na son djurmenti pui mon p...   \n",
       "2    O kutetulula kuila o Jinguvulu ja Jimbandu ia ...   \n",
       "3    - Nasaun tomak iha O.N.U. tau lia ba malu atu ...   \n",
       "4    Olofeka viosi vi tiamelã ko Hongele Yolofeka (...   \n",
       "..                                                 ...   \n",
       "481  6- Ha mwakinisho ukaya ze daula wanashama zidj...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴽ ⵙ ⵉⵣⵔⴼⴰⵏ ⴷ ⵜⴷⵔⴼⵉⵜ ⴰⵙⴽⴽⵉⵏ ⴰⴽⵙⵡ...   \n",
       "483                              Akatsajuka anicha ahi   \n",
       "484  Zi'cy na:a ra mye'mmr x:te:e'n Naciones Unidas...   \n",
       "485  Ngokunjalo aMalunga eMibuso azibophezele mathu...   \n",
       "\n",
       "                                                 00-07  \\\n",
       "0    Punda ua mêma conceçón di nen dirêtu cu liberd...   \n",
       "1    Só ora qui tudu djintis intindi diritu ê barba...   \n",
       "2    Mu kutetulula kuila o mu dixiganeku dimoxi dia...   \n",
       "3    - atu ema tomak halo tuir lia hirak ne’e be fo...   \n",
       "4    Kovisila evi vioku tata omuenyo womanu oko ku ...   \n",
       "..                                                 ...   \n",
       "481  7- Ha mwakinisho ukaya mwelewano sawa wapwadzi...   \n",
       "482  ⵉⵙⵙⴰⴼⵖ ⴷ ⵓⴳⵔⴰⵡ ⴰⵎⴰⵜⴰⵢ ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ...   \n",
       "483  Akatsuju kiraitia rikuanu kayapuina ta nuka ti...   \n",
       "484  Zi'cy na:a na:a pahr ga'cbe:e' bu:unny ra dere...   \n",
       "485  Ngokunjalo ukuqondwa kahle ngokufanayo kwalama...   \n",
       "\n",
       "                                                 00-08  ...  \\\n",
       "0                                     Assembleia Geral  ...   \n",
       "1                                     ASSEMBLEIA GERAL  ...   \n",
       "2                               O KIONGE KIA KISANGELA  ...   \n",
       "3                                       Asembleia Boot  ...   \n",
       "4                                       Onjango Yinene  ...   \n",
       "..                                                 ...  ...   \n",
       "481  8- Le Barazaka Kuu lahe Djumuyian ya madola ng...  ...   \n",
       "482  ⴰⵍⵖⵓ ⴰⴷ, ⴰⴷ ⴷⵓⵙⵏ, ⵙ ⵓⵙⵙⵍⵎⴷ ⴷ ⵓⵙⴳⵎⵉ, ⵙⴱⵓⵖⵍⵓⵏ ⴷ ...  ...   \n",
       "483                                                     ...   \n",
       "484                                         Nah chiru'  ...   \n",
       "485                                    MANJE, NGAKHOKE  ...   \n",
       "\n",
       "                                                 28-01 28-02 28-03  \\\n",
       "0    Tudu nguê tê dirêtu di fé pa zisti, ni plano s...               \n",
       "1    Na ê Declaração, tudu pecadur tem diritu di fa...               \n",
       "2    Mutu uoso uoso uala ni ubinganu ua kuxinganeka...               \n",
       "3    Naran ema ida iha direitu, iha fatin ne’e be n...               \n",
       "4    Omunu wosi okuete omoko yoku kisika okuti ovih...               \n",
       "..                                                 ...   ...   ...   \n",
       "481  Haina mwanadamu ngena haki pvakaye myenshi har...               \n",
       "482  ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⴰⴷ ⵉⵙⴼⴰⵢⴷ ⵖ ⵓⵖⴰⵡⴰⵙ ⴰⵏⴰⵎⵓ...               \n",
       "483  Kawiriya kayapi ichanu ikicha rikuanu ta nuka ...               \n",
       "484  Ra'ta' bu:unny ra:a'p deree'ch chu' gax:lyuh l...               \n",
       "485  Wonke umuntu emphakathini nasemhlabeni kumele ...               \n",
       "\n",
       "                          29-00  \\\n",
       "0                    Artigo 29º   \n",
       "1                   ARTIGO 29º.   \n",
       "2       MAKUINHI AIADI NI DIVUA   \n",
       "3                     Artigu 29   \n",
       "4                  ONDAKA YA 29   \n",
       "..                          ...   \n",
       "481  Faslu ya yishiri na shenda   \n",
       "482                  ⴰⵎⴰⴳⵔⴰⴷ 29   \n",
       "483                 Akatsuju 29   \n",
       "484     Ga:ally Ahbga:a:a' (29)   \n",
       "485                  Isigaba 29   \n",
       "\n",
       "                                                 29-01  \\\n",
       "0    Qualqué ngué tê obligaçón ni glupu dê, e xi ê ...   \n",
       "1    Cada pecadur tem quê qui díbidi fassi na si co...   \n",
       "2    Mutu uoso uoso ua tokala kubanga ni ujitu imba...   \n",
       "3    Naran ema ida sei halo buat ruma ba nia rain, ...   \n",
       "4    Omunu wosi okuete ovikele lovocisoko a atiamel...   \n",
       "..                                                 ...   \n",
       "481  Ye mwanadamu ngena wadjau ze wadjibu zahahe ho...   \n",
       "482  ⴽⵓ ⵢⴰⵏ ⴰⵔ ⵉⵜⵜⴰⵡⵙ ⵖ ⵜⵡⵉⵣⵉ ⵏ ⵡⴰⵎⵓⵏ ⵙ ⵓⵢⵏⵏⴰ ⵎⵓ ⵉⵥ...   \n",
       "483  Kawiriaja ichanu ikicha utatinuka charanishija...   \n",
       "484  Ra'ta' bu:unny na:a pahr yde:e:i'dy ze:i'ny la...   \n",
       "485  Wonke umuntu uneqhaza emphakathini okuwukuphel...   \n",
       "\n",
       "                                                 29-02  \\\n",
       "0    Óla qualqué nguê ca gozá dirêtu cu liberdade, ...   \n",
       "1    Na tudu diritu que faladu na ê declaçon, ora q...   \n",
       "2    Mu kikalakalu kia ubinganu uoso, ni mu kutana ...   \n",
       "3    Atu moris ho direitu, atu bele hetan liberdade...   \n",
       "4    Ko kusuisapo ovihandeleko evi loku vitelisa ok...   \n",
       "..                                                 ...   \n",
       "481  Ze haki ne ze nafasi za haina mdru nkazitsina ...   \n",
       "482  ⴰⵔ ⵏⵏ ⵉⵜⵜⴷⵓⵍ ⵓⴼⴳⴰⵏ ⵙ ⵉⵙⴽⵔⴰⴼ ⵍⵍⵉ ⵉⵍⵍⴰⵏ ⴳ ⵓⵙⵍⴳⵏ ...   \n",
       "483  Ta nuka cha meiri ku rikuanu ta nuka tawijuka ...   \n",
       "484  Ra le'i na:a pahr chu'ihzy pahr ga'pdo:o ra de...   \n",
       "485  Ekusebenziseni amalungelo nenkululeko yakhe, u...   \n",
       "\n",
       "                                                 29-03  \\\n",
       "0    Tudu dirêtu cu liberdade sé na ca pô zisti con...   \n",
       "1    Nin un dia ês diritus cu liberdadis ca pudi fa...   \n",
       "2    Kanaku kima, maka, mba imbamba itenesu ku tobe...   \n",
       "3    Hotu-hotu sei tuir lolós direitu ho liberdade ...   \n",
       "4    Ovihandeleko evi vilingiwa lika oku kolisa ong...   \n",
       "..                                                 ...   \n",
       "481  Ze haki ne ze nafasi yizo nkazina udjuwa, hain...   \n",
       "482  ⵖⵉⴽⵏⵏⴰ ⴽⴰ ⴳⴰⵏⵜ ⵜⵖⴰⵡⵙⵉⵡⵉⵏ ⵓⵔ ⴷ ⵉⵇⵇⴰⵏ ⴰⴷ ⵎⵎⵙⴽⴰⵔⵏ...   \n",
       "483  Ku ikicha nuka rikuanu ta nukaka puchakirinu t...   \n",
       "484  Ra'ta' bu:unny na:a pahr chu' zi'cy nih canni:...   \n",
       "485  Lamalungelo nenkululeko akunakusetshenziswa ng...   \n",
       "\n",
       "                      30-00  \\\n",
       "0                Artigo 30º   \n",
       "1               ARTIGO 30º.   \n",
       "2            MAKUINHI ATATU   \n",
       "3                 Artigu 30   \n",
       "4              ONDAKA YA 30   \n",
       "..                      ...   \n",
       "481   Faslu ya mengo miraru   \n",
       "482              ⴰⵎⴰⴳⵔⴰⴷ 30   \n",
       "483              Akatsuju30   \n",
       "484  Ga:ally Ahbtsë:ë' (30)   \n",
       "485              Isigaba 30   \n",
       "\n",
       "                                                 30-01 30-02  \n",
       "0    Tudu cuá cu sá ni Declaraçón sé na ca pô plimi...        \n",
       "1    Ninguin ca pudi ncunha na nin un palabra di ê ...        \n",
       "2    Kanaku utundilu ua kamukua uambote, ukexilu mb...        \n",
       "3    Naran Nasaun ida, klibur ruma e naran ema ida,...        \n",
       "4    Lacimue ocihandeleko casonehiwa vu Vangi mulo ...        \n",
       "..                                                 ...   ...  \n",
       "481  Kapvatsi faslu yahe le Katiba linu lidjo udjuw...        \n",
       "482  ⵓⵔ ⵉⵍⵍⵉ ⵖ ⵓⵍⵖⵓ ⴰⴷ ⴽⵔⴰ ⵏ ⵓⴹⵕⵉⵚ ⴰⴼⴰⴷ ⴰⴷ ⵉⵙⵎⴷⵢⴰ ⴽ...        \n",
       "483  Taikua tamasa ikicha kayapi atijianuka ikicha ...        \n",
       "484  Nye:e'cy te'ihby nasyoony nye:e'cy te'ihby bu:...        \n",
       "485  Akukho lutho okukuloluGunyazo okuyohunyushwa n...        \n",
       "\n",
       "[486 rows x 136 columns]"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = align_tsvs(Path('data/tsvs'))\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "id": "2aa51956-f3bc-4b6d-a417-67dba79a7852",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Lang</th>\n",
       "      <th>00-00</th>\n",
       "      <th>00-01</th>\n",
       "      <th>00-02</th>\n",
       "      <th>00-03</th>\n",
       "      <th>00-04</th>\n",
       "      <th>00-05</th>\n",
       "      <th>00-06</th>\n",
       "      <th>00-07</th>\n",
       "      <th>00-08</th>\n",
       "      <th>...</th>\n",
       "      <th>28-01</th>\n",
       "      <th>28-02</th>\n",
       "      <th>28-03</th>\n",
       "      <th>29-00</th>\n",
       "      <th>29-01</th>\n",
       "      <th>29-02</th>\n",
       "      <th>29-03</th>\n",
       "      <th>30-00</th>\n",
       "      <th>30-01</th>\n",
       "      <th>30-02</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>007</td>\n",
       "      <td>Declaraçón Universal di Dirêtu di Hómé</td>\n",
       "      <td>Punda dignidade di tudo nguê di mundu e dirêtu...</td>\n",
       "      <td>Punda fata di conheximentu e displêzu di dirêt...</td>\n",
       "      <td>Punda ploteçón di dirêtu di hómé baseado ni ua...</td>\n",
       "      <td>Punda ê sá importante lumadu conselhá disenvol...</td>\n",
       "      <td>Punda ni Cata, tudu pôvô di Naçón Unida plocla...</td>\n",
       "      <td>Punda tudu Estado memblu xiná complomissu cuma...</td>\n",
       "      <td>Punda ua mêma conceçón di nen dirêtu cu liberd...</td>\n",
       "      <td>Assembleia Geral</td>\n",
       "      <td>...</td>\n",
       "      <td>Tudu nguê tê dirêtu di fé pa zisti, ni plano s...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Artigo 29º</td>\n",
       "      <td>Qualqué ngué tê obligaçón ni glupu dê, e xi ê ...</td>\n",
       "      <td>Óla qualqué nguê ca gozá dirêtu cu liberdade, ...</td>\n",
       "      <td>Tudu dirêtu cu liberdade sé na ca pô zisti con...</td>\n",
       "      <td>Artigo 30º</td>\n",
       "      <td>Tudu cuá cu sá ni Declaraçón sé na ca pô plimi...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>008</td>\n",
       "      <td>DECLARAÇON UNIVERSAL DI DIRITU DI OMIS</td>\n",
       "      <td>Suma qui qui ricunhicidu dignidadi di tudu mem...</td>\n",
       "      <td>Suma falta di cunsi, cu disprezu di diritu di ...</td>\n",
       "      <td>Omi padidu pa viki, pa quila I dibidi tadjadu ...</td>\n",
       "      <td>Suma na mundu tudu djintis díbidi mama, I purc...</td>\n",
       "      <td>Suma qui carta qui Naçon Unida scribi pa si po...</td>\n",
       "      <td>Suma stadus qui pui na son djurmenti pui mon p...</td>\n",
       "      <td>Só ora qui tudu djintis intindi diritu ê barba...</td>\n",
       "      <td>ASSEMBLEIA GERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Na ê Declaração, tudu pecadur tem diritu di fa...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>ARTIGO 29º.</td>\n",
       "      <td>Cada pecadur tem quê qui díbidi fassi na si co...</td>\n",
       "      <td>Na tudu diritu que faladu na ê declaçon, ora q...</td>\n",
       "      <td>Nin un dia ês diritus cu liberdadis ca pudi fa...</td>\n",
       "      <td>ARTIGO 30º.</td>\n",
       "      <td>Ninguin ca pudi ncunha na nin un palabra di ê ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>009</td>\n",
       "      <td></td>\n",
       "      <td>O kutetulula kuila, o kuijia o ujitu mu ukunji...</td>\n",
       "      <td>O kutetulula kuila o mutu mu ku kamba o kuijia...</td>\n",
       "      <td>O kutetulula uixi, kia tokala bu kale o dikuat...</td>\n",
       "      <td>O kutetulula kuila, kia tokala o dikuatenenu d...</td>\n",
       "      <td>O kutetulula kuila, o mukanda ua kifuxi kia ng...</td>\n",
       "      <td>O kutetulula kuila o Jinguvulu ja Jimbandu ia ...</td>\n",
       "      <td>Mu kutetulula kuila o mu dixiganeku dimoxi dia...</td>\n",
       "      <td>O KIONGE KIA KISANGELA</td>\n",
       "      <td>...</td>\n",
       "      <td>Mutu uoso uoso uala ni ubinganu ua kuxinganeka...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>MAKUINHI AIADI NI DIVUA</td>\n",
       "      <td>Mutu uoso uoso ua tokala kubanga ni ujitu imba...</td>\n",
       "      <td>Mu kikalakalu kia ubinganu uoso, ni mu kutana ...</td>\n",
       "      <td>Kanaku kima, maka, mba imbamba itenesu ku tobe...</td>\n",
       "      <td>MAKUINHI ATATU</td>\n",
       "      <td>Kanaku utundilu ua kamukua uambote, ukexilu mb...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010</td>\n",
       "      <td>Deklarasaun kona ba Ema tomak nia Direitu, iha...</td>\n",
       "      <td>- atu bele moris ho liberdade, ho justisa, ho ...</td>\n",
       "      <td>- tan lakohi simu, tan heuuai ema nia direitu ...</td>\n",
       "      <td>- atu tahan ema tomak nia direitu tuir ukun ho...</td>\n",
       "      <td>- atu buka hametin damen iha nasaun tomak.</td>\n",
       "      <td>- iha Surat Deklarasaun ne’e, Nasaun tomak fo ...</td>\n",
       "      <td>- Nasaun tomak iha O.N.U. tau lia ba malu atu ...</td>\n",
       "      <td>- atu ema tomak halo tuir lia hirak ne’e be fo...</td>\n",
       "      <td>Asembleia Boot</td>\n",
       "      <td>...</td>\n",
       "      <td>Naran ema ida iha direitu, iha fatin ne’e be n...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Artigu 29</td>\n",
       "      <td>Naran ema ida sei halo buat ruma ba nia rain, ...</td>\n",
       "      <td>Atu moris ho direitu, atu bele hetan liberdade...</td>\n",
       "      <td>Hotu-hotu sei tuir lolós direitu ho liberdade ...</td>\n",
       "      <td>Artigu 30</td>\n",
       "      <td>Naran Nasaun ida, klibur ruma e naran ema ida,...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>011</td>\n",
       "      <td>Ohuminyo Yoluali Yoku Tata Ovimuenyo Viomanu</td>\n",
       "      <td>Unu womanu loku sumbila omuenyo wapata omanu v...</td>\n",
       "      <td>Ekambo liu kulihiso kuenda oku pembula ovihand...</td>\n",
       "      <td>Okutata omuenyo womanu oco cavelapo , kuenje c...</td>\n",
       "      <td>Ca sesamela okuti pokati kolofeka viosi pa kal...</td>\n",
       "      <td>Ekolelõ liomanu vosi va tiamela ko Hongele Yol...</td>\n",
       "      <td>Olofeka viosi vi tiamelã ko Hongele Yolofeka (...</td>\n",
       "      <td>Kovisila evi vioku tata omuenyo womanu oko ku ...</td>\n",
       "      <td>Onjango Yinene</td>\n",
       "      <td>...</td>\n",
       "      <td>Omunu wosi okuete omoko yoku kisika okuti ovih...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>ONDAKA YA 29</td>\n",
       "      <td>Omunu wosi okuete ovikele lovocisoko a atiamel...</td>\n",
       "      <td>Ko kusuisapo ovihandeleko evi loku vitelisa ok...</td>\n",
       "      <td>Ovihandeleko evi vilingiwa lika oku kolisa ong...</td>\n",
       "      <td>ONDAKA YA 30</td>\n",
       "      <td>Lacimue ocihandeleko casonehiwa vu Vangi mulo ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>zdj</td>\n",
       "      <td>ANZIMIYO LA KILEMWENGU UHSU ZE HAKI ZAKI BINADAMU</td>\n",
       "      <td>1- Ha mwakinisho ukaya ho ukubali ye sheo shah...</td>\n",
       "      <td>2- Ha mwakinisho ukaya wo upuzi no uwoneya ze ...</td>\n",
       "      <td>3- Ha mwakinisho ukaya zo muhimu ho uhifadhwi ...</td>\n",
       "      <td>4- Ha mwakinisho ukaya zo muhimu ho utriya dji...</td>\n",
       "      <td>5- Ha mwakinisho ukaya harimwa le katiba mshin...</td>\n",
       "      <td>6- Ha mwakinisho ukaya ze daula wanashama zidj...</td>\n",
       "      <td>7- Ha mwakinisho ukaya mwelewano sawa wapwadzi...</td>\n",
       "      <td>8- Le Barazaka Kuu lahe Djumuyian ya madola ng...</td>\n",
       "      <td>...</td>\n",
       "      <td>Haina mwanadamu ngena haki pvakaye myenshi har...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Faslu ya yishiri na shenda</td>\n",
       "      <td>Ye mwanadamu ngena wadjau ze wadjibu zahahe ho...</td>\n",
       "      <td>Ze haki ne ze nafasi za haina mdru nkazitsina ...</td>\n",
       "      <td>Ze haki ne ze nafasi yizo nkazina udjuwa, hain...</td>\n",
       "      <td>Faslu ya mengo miraru</td>\n",
       "      <td>Kapvatsi faslu yahe le Katiba linu lidjo udjuw...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>zgh</td>\n",
       "      <td>ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ</td>\n",
       "      <td>ⵍⵍⵉⵖ ⵜⴳⴰ ⵜⵓⴽⵣⴰ ⵏ ⵓⵍⵍⴰⵍⵓ ⵏ ⴽⴰⵢⴳⴰⵜ ⵢⴰⵏ ⵖ ⵜⴰⵡⵊⴰ ⵜ...</td>\n",
       "      <td>ⵜⴳ ⵜⴰⵎⵜⵜⴰⵡⵜ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ ⴰⴷ ⵉⵜⵜⴰⵡⵉⵏ ⵜⵓⴳⵜⵜ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴳ ⵏ ⵉⵣⵔⴼⴰⵏⵏ ⵏ ⵓⵎⴷⴰⵏ ⵢⴰⵏ ⵓⴼⴳⴳⴰⴳ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⵍⵍⴰ ⴳ ⵜⵏⵜⵜⴰⵎⵜ ⵉⴷ ⵉⴳⴷⵓⴷⵏ ⵏ ⵜⵎⵜⵜⴰ ⵉⵎⵓⵏⵏ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵎⵙⵓⵛⴽⴰⵏ ⵉⵡⴰⵏⴽⵏ ⵉⴳⵎⴰⵎⵏ, ⵙ ⵜⵡⵙⵉⵏ ⵏ ⵜⵎⴰⴷⴷⴰ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴽ ⵙ ⵉⵣⵔⴼⴰⵏ ⴷ ⵜⴷⵔⴼⵉⵜ ⴰⵙⴽⴽⵉⵏ ⴰⴽⵙⵡ...</td>\n",
       "      <td>ⵉⵙⵙⴰⴼⵖ ⴷ ⵓⴳⵔⴰⵡ ⴰⵎⴰⵜⴰⵢ ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ...</td>\n",
       "      <td>ⴰⵍⵖⵓ ⴰⴷ, ⴰⴷ ⴷⵓⵙⵏ, ⵙ ⵓⵙⵙⵍⵎⴷ ⴷ ⵓⵙⴳⵎⵉ, ⵙⴱⵓⵖⵍⵓⵏ ⴷ ...</td>\n",
       "      <td>...</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⴰⴷ ⵉⵙⴼⴰⵢⴷ ⵖ ⵓⵖⴰⵡⴰⵙ ⴰⵏⴰⵎⵓ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 29</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⴰⵔ ⵉⵜⵜⴰⵡⵙ ⵖ ⵜⵡⵉⵣⵉ ⵏ ⵡⴰⵎⵓⵏ ⵙ ⵓⵢⵏⵏⴰ ⵎⵓ ⵉⵥ...</td>\n",
       "      <td>ⴰⵔ ⵏⵏ ⵉⵜⵜⴷⵓⵍ ⵓⴼⴳⴰⵏ ⵙ ⵉⵙⴽⵔⴰⴼ ⵍⵍⵉ ⵉⵍⵍⴰⵏ ⴳ ⵓⵙⵍⴳⵏ ...</td>\n",
       "      <td>ⵖⵉⴽⵏⵏⴰ ⴽⴰ ⴳⴰⵏⵜ ⵜⵖⴰⵡⵙⵉⵡⵉⵏ ⵓⵔ ⴷ ⵉⵇⵇⴰⵏ ⴰⴷ ⵎⵎⵙⴽⴰⵔⵏ...</td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 30</td>\n",
       "      <td>ⵓⵔ ⵉⵍⵍⵉ ⵖ ⵓⵍⵖⵓ ⴰⴷ ⴽⵔⴰ ⵏ ⵓⴹⵕⵉⵚ ⴰⴼⴰⴷ ⴰⴷ ⵉⵙⵎⴷⵢⴰ ⴽ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>zro</td>\n",
       "      <td></td>\n",
       "      <td>Panichanu tamasa taykua kayapi kupanimajicha i...</td>\n",
       "      <td>Panichanu ikicha tamanu rikuanu kupanimajicha ...</td>\n",
       "      <td>Panicha cha nuka nishima niata akuinaja aramuj...</td>\n",
       "      <td>Panicha aramujun kiniana kupanicha majicha iki...</td>\n",
       "      <td>Kiraitia kiniana amimaja</td>\n",
       "      <td>Akatsajuka anicha ahi</td>\n",
       "      <td>Akatsuju kiraitia rikuanu kayapuina ta nuka ti...</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>Kawiriya kayapi ichanu ikicha rikuanu ta nuka ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Akatsuju 29</td>\n",
       "      <td>Kawiriaja ichanu ikicha utatinuka charanishija...</td>\n",
       "      <td>Ta nuka cha meiri ku rikuanu ta nuka tawijuka ...</td>\n",
       "      <td>Ku ikicha nuka rikuanu ta nukaka puchakirinu t...</td>\n",
       "      <td>Akatsuju30</td>\n",
       "      <td>Taikua tamasa ikicha kayapi atijianuka ikicha ...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>ztu</td>\n",
       "      <td>Declarasyoony x:te:e'n Deree'ch x:te:e' Ra'ta'...</td>\n",
       "      <td>Zi'cy na:a dignidaa deree'ch nah x:te:e' ra'ta...</td>\n",
       "      <td>Zi'cy na:a gahll quei'ty runybe:e' ra deree'ch...</td>\n",
       "      <td>Zi'cy na:a na:a pahr chu' le'i nih guuny prote...</td>\n",
       "      <td>Zi'cy na:a na:a pahr ga'c ra nasyoony amiiegw,</td>\n",
       "      <td>Zi'cy na:a ra bu:unny x:te:e'n Naciones Unidas...</td>\n",
       "      <td>Zi'cy na:a ra mye'mmr x:te:e'n Naciones Unidas...</td>\n",
       "      <td>Zi'cy na:a na:a pahr ga'cbe:e' bu:unny ra dere...</td>\n",
       "      <td>Nah chiru'</td>\n",
       "      <td>...</td>\n",
       "      <td>Ra'ta' bu:unny ra:a'p deree'ch chu' gax:lyuh l...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Ga:ally Ahbga:a:a' (29)</td>\n",
       "      <td>Ra'ta' bu:unny na:a pahr yde:e:i'dy ze:i'ny la...</td>\n",
       "      <td>Ra le'i na:a pahr chu'ihzy pahr ga'pdo:o ra de...</td>\n",
       "      <td>Ra'ta' bu:unny na:a pahr chu' zi'cy nih canni:...</td>\n",
       "      <td>Ga:ally Ahbtsë:ë' (30)</td>\n",
       "      <td>Nye:e'cy te'ihby nasyoony nye:e'cy te'ihby bu:...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>zul</td>\n",
       "      <td>UMBHALO OGCWELE WOGUNYAZO LWAMALUNGELO OLUNTU ...</td>\n",
       "      <td>Ngokunjalo ukwamukelwa ngokuzuzwa kwesithunzi ...</td>\n",
       "      <td>Ngokunjalo ukunganakwa nokwedelelwa kwamalunge...</td>\n",
       "      <td>Ngokunjalo kudingekile, uma umuntu engenakupho...</td>\n",
       "      <td>Ngokunjalo kudingekile ukuba kwenyuswe ukuthut...</td>\n",
       "      <td>Ngokunjalo abantu beNhlangano yeZizwe bayinqin...</td>\n",
       "      <td>Ngokunjalo aMalunga eMibuso azibophezele mathu...</td>\n",
       "      <td>Ngokunjalo ukuqondwa kahle ngokufanayo kwalama...</td>\n",
       "      <td>MANJE, NGAKHOKE</td>\n",
       "      <td>...</td>\n",
       "      <td>Wonke umuntu emphakathini nasemhlabeni kumele ...</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>Isigaba 29</td>\n",
       "      <td>Wonke umuntu uneqhaza emphakathini okuwukuphel...</td>\n",
       "      <td>Ekusebenziseni amalungelo nenkululeko yakhe, u...</td>\n",
       "      <td>Lamalungelo nenkululeko akunakusetshenziswa ng...</td>\n",
       "      <td>Isigaba 30</td>\n",
       "      <td>Akukho lutho okukuloluGunyazo okuyohunyushwa n...</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>486 rows × 136 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Lang                                              00-00  \\\n",
       "0    007             Declaraçón Universal di Dirêtu di Hómé   \n",
       "1    008             DECLARAÇON UNIVERSAL DI DIRITU DI OMIS   \n",
       "2    009                                                      \n",
       "3    010  Deklarasaun kona ba Ema tomak nia Direitu, iha...   \n",
       "4    011       Ohuminyo Yoluali Yoku Tata Ovimuenyo Viomanu   \n",
       "..   ...                                                ...   \n",
       "481  zdj  ANZIMIYO LA KILEMWENGU UHSU ZE HAKI ZAKI BINADAMU   \n",
       "482  zgh                      ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ   \n",
       "483  zro                                                      \n",
       "484  ztu  Declarasyoony x:te:e'n Deree'ch x:te:e' Ra'ta'...   \n",
       "485  zul  UMBHALO OGCWELE WOGUNYAZO LWAMALUNGELO OLUNTU ...   \n",
       "\n",
       "                                                 00-01  \\\n",
       "0    Punda dignidade di tudo nguê di mundu e dirêtu...   \n",
       "1    Suma qui qui ricunhicidu dignidadi di tudu mem...   \n",
       "2    O kutetulula kuila, o kuijia o ujitu mu ukunji...   \n",
       "3    - atu bele moris ho liberdade, ho justisa, ho ...   \n",
       "4    Unu womanu loku sumbila omuenyo wapata omanu v...   \n",
       "..                                                 ...   \n",
       "481  1- Ha mwakinisho ukaya ho ukubali ye sheo shah...   \n",
       "482  ⵍⵍⵉⵖ ⵜⴳⴰ ⵜⵓⴽⵣⴰ ⵏ ⵓⵍⵍⴰⵍⵓ ⵏ ⴽⴰⵢⴳⴰⵜ ⵢⴰⵏ ⵖ ⵜⴰⵡⵊⴰ ⵜ...   \n",
       "483  Panichanu tamasa taykua kayapi kupanimajicha i...   \n",
       "484  Zi'cy na:a dignidaa deree'ch nah x:te:e' ra'ta...   \n",
       "485  Ngokunjalo ukwamukelwa ngokuzuzwa kwesithunzi ...   \n",
       "\n",
       "                                                 00-02  \\\n",
       "0    Punda fata di conheximentu e displêzu di dirêt...   \n",
       "1    Suma falta di cunsi, cu disprezu di diritu di ...   \n",
       "2    O kutetulula kuila o mutu mu ku kamba o kuijia...   \n",
       "3    - tan lakohi simu, tan heuuai ema nia direitu ...   \n",
       "4    Ekambo liu kulihiso kuenda oku pembula ovihand...   \n",
       "..                                                 ...   \n",
       "481  2- Ha mwakinisho ukaya wo upuzi no uwoneya ze ...   \n",
       "482  ⵜⴳ ⵜⴰⵎⵜⵜⴰⵡⵜ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ ⴰⴷ ⵉⵜⵜⴰⵡⵉⵏ ⵜⵓⴳⵜⵜ ...   \n",
       "483  Panichanu ikicha tamanu rikuanu kupanimajicha ...   \n",
       "484  Zi'cy na:a gahll quei'ty runybe:e' ra deree'ch...   \n",
       "485  Ngokunjalo ukunganakwa nokwedelelwa kwamalunge...   \n",
       "\n",
       "                                                 00-03  \\\n",
       "0    Punda ploteçón di dirêtu di hómé baseado ni ua...   \n",
       "1    Omi padidu pa viki, pa quila I dibidi tadjadu ...   \n",
       "2    O kutetulula uixi, kia tokala bu kale o dikuat...   \n",
       "3    - atu tahan ema tomak nia direitu tuir ukun ho...   \n",
       "4    Okutata omuenyo womanu oco cavelapo , kuenje c...   \n",
       "..                                                 ...   \n",
       "481  3- Ha mwakinisho ukaya zo muhimu ho uhifadhwi ...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴳ ⵏ ⵉⵣⵔⴼⴰⵏⵏ ⵏ ⵓⵎⴷⴰⵏ ⵢⴰⵏ ⵓⴼⴳⴳⴰⴳ ...   \n",
       "483  Panicha cha nuka nishima niata akuinaja aramuj...   \n",
       "484  Zi'cy na:a na:a pahr chu' le'i nih guuny prote...   \n",
       "485  Ngokunjalo kudingekile, uma umuntu engenakupho...   \n",
       "\n",
       "                                                 00-04  \\\n",
       "0    Punda ê sá importante lumadu conselhá disenvol...   \n",
       "1    Suma na mundu tudu djintis díbidi mama, I purc...   \n",
       "2    O kutetulula kuila, kia tokala o dikuatenenu d...   \n",
       "3           - atu buka hametin damen iha nasaun tomak.   \n",
       "4    Ca sesamela okuti pokati kolofeka viosi pa kal...   \n",
       "..                                                 ...   \n",
       "481  4- Ha mwakinisho ukaya zo muhimu ho utriya dji...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⵍⵍⴰ ⴳ ⵜⵏⵜⵜⴰⵎⵜ ⵉⴷ ⵉⴳⴷⵓⴷⵏ ⵏ ⵜⵎⵜⵜⴰ ⵉⵎⵓⵏⵏ ...   \n",
       "483  Panicha aramujun kiniana kupanicha majicha iki...   \n",
       "484     Zi'cy na:a na:a pahr ga'c ra nasyoony amiiegw,   \n",
       "485  Ngokunjalo kudingekile ukuba kwenyuswe ukuthut...   \n",
       "\n",
       "                                                 00-05  \\\n",
       "0    Punda ni Cata, tudu pôvô di Naçón Unida plocla...   \n",
       "1    Suma qui carta qui Naçon Unida scribi pa si po...   \n",
       "2    O kutetulula kuila, o mukanda ua kifuxi kia ng...   \n",
       "3    - iha Surat Deklarasaun ne’e, Nasaun tomak fo ...   \n",
       "4    Ekolelõ liomanu vosi va tiamela ko Hongele Yol...   \n",
       "..                                                 ...   \n",
       "481  5- Ha mwakinisho ukaya harimwa le katiba mshin...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵎⵙⵓⵛⴽⴰⵏ ⵉⵡⴰⵏⴽⵏ ⵉⴳⵎⴰⵎⵏ, ⵙ ⵜⵡⵙⵉⵏ ⵏ ⵜⵎⴰⴷⴷⴰ...   \n",
       "483                           Kiraitia kiniana amimaja   \n",
       "484  Zi'cy na:a ra bu:unny x:te:e'n Naciones Unidas...   \n",
       "485  Ngokunjalo abantu beNhlangano yeZizwe bayinqin...   \n",
       "\n",
       "                                                 00-06  \\\n",
       "0    Punda tudu Estado memblu xiná complomissu cuma...   \n",
       "1    Suma stadus qui pui na son djurmenti pui mon p...   \n",
       "2    O kutetulula kuila o Jinguvulu ja Jimbandu ia ...   \n",
       "3    - Nasaun tomak iha O.N.U. tau lia ba malu atu ...   \n",
       "4    Olofeka viosi vi tiamelã ko Hongele Yolofeka (...   \n",
       "..                                                 ...   \n",
       "481  6- Ha mwakinisho ukaya ze daula wanashama zidj...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴽ ⵙ ⵉⵣⵔⴼⴰⵏ ⴷ ⵜⴷⵔⴼⵉⵜ ⴰⵙⴽⴽⵉⵏ ⴰⴽⵙⵡ...   \n",
       "483                              Akatsajuka anicha ahi   \n",
       "484  Zi'cy na:a ra mye'mmr x:te:e'n Naciones Unidas...   \n",
       "485  Ngokunjalo aMalunga eMibuso azibophezele mathu...   \n",
       "\n",
       "                                                 00-07  \\\n",
       "0    Punda ua mêma conceçón di nen dirêtu cu liberd...   \n",
       "1    Só ora qui tudu djintis intindi diritu ê barba...   \n",
       "2    Mu kutetulula kuila o mu dixiganeku dimoxi dia...   \n",
       "3    - atu ema tomak halo tuir lia hirak ne’e be fo...   \n",
       "4    Kovisila evi vioku tata omuenyo womanu oko ku ...   \n",
       "..                                                 ...   \n",
       "481  7- Ha mwakinisho ukaya mwelewano sawa wapwadzi...   \n",
       "482  ⵉⵙⵙⴰⴼⵖ ⴷ ⵓⴳⵔⴰⵡ ⴰⵎⴰⵜⴰⵢ ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ...   \n",
       "483  Akatsuju kiraitia rikuanu kayapuina ta nuka ti...   \n",
       "484  Zi'cy na:a na:a pahr ga'cbe:e' bu:unny ra dere...   \n",
       "485  Ngokunjalo ukuqondwa kahle ngokufanayo kwalama...   \n",
       "\n",
       "                                                 00-08  ...  \\\n",
       "0                                     Assembleia Geral  ...   \n",
       "1                                     ASSEMBLEIA GERAL  ...   \n",
       "2                               O KIONGE KIA KISANGELA  ...   \n",
       "3                                       Asembleia Boot  ...   \n",
       "4                                       Onjango Yinene  ...   \n",
       "..                                                 ...  ...   \n",
       "481  8- Le Barazaka Kuu lahe Djumuyian ya madola ng...  ...   \n",
       "482  ⴰⵍⵖⵓ ⴰⴷ, ⴰⴷ ⴷⵓⵙⵏ, ⵙ ⵓⵙⵙⵍⵎⴷ ⴷ ⵓⵙⴳⵎⵉ, ⵙⴱⵓⵖⵍⵓⵏ ⴷ ...  ...   \n",
       "483                                                     ...   \n",
       "484                                         Nah chiru'  ...   \n",
       "485                                    MANJE, NGAKHOKE  ...   \n",
       "\n",
       "                                                 28-01 28-02 28-03  \\\n",
       "0    Tudu nguê tê dirêtu di fé pa zisti, ni plano s...               \n",
       "1    Na ê Declaração, tudu pecadur tem diritu di fa...               \n",
       "2    Mutu uoso uoso uala ni ubinganu ua kuxinganeka...               \n",
       "3    Naran ema ida iha direitu, iha fatin ne’e be n...               \n",
       "4    Omunu wosi okuete omoko yoku kisika okuti ovih...               \n",
       "..                                                 ...   ...   ...   \n",
       "481  Haina mwanadamu ngena haki pvakaye myenshi har...               \n",
       "482  ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⴰⴷ ⵉⵙⴼⴰⵢⴷ ⵖ ⵓⵖⴰⵡⴰⵙ ⴰⵏⴰⵎⵓ...               \n",
       "483  Kawiriya kayapi ichanu ikicha rikuanu ta nuka ...               \n",
       "484  Ra'ta' bu:unny ra:a'p deree'ch chu' gax:lyuh l...               \n",
       "485  Wonke umuntu emphakathini nasemhlabeni kumele ...               \n",
       "\n",
       "                          29-00  \\\n",
       "0                    Artigo 29º   \n",
       "1                   ARTIGO 29º.   \n",
       "2       MAKUINHI AIADI NI DIVUA   \n",
       "3                     Artigu 29   \n",
       "4                  ONDAKA YA 29   \n",
       "..                          ...   \n",
       "481  Faslu ya yishiri na shenda   \n",
       "482                  ⴰⵎⴰⴳⵔⴰⴷ 29   \n",
       "483                 Akatsuju 29   \n",
       "484     Ga:ally Ahbga:a:a' (29)   \n",
       "485                  Isigaba 29   \n",
       "\n",
       "                                                 29-01  \\\n",
       "0    Qualqué ngué tê obligaçón ni glupu dê, e xi ê ...   \n",
       "1    Cada pecadur tem quê qui díbidi fassi na si co...   \n",
       "2    Mutu uoso uoso ua tokala kubanga ni ujitu imba...   \n",
       "3    Naran ema ida sei halo buat ruma ba nia rain, ...   \n",
       "4    Omunu wosi okuete ovikele lovocisoko a atiamel...   \n",
       "..                                                 ...   \n",
       "481  Ye mwanadamu ngena wadjau ze wadjibu zahahe ho...   \n",
       "482  ⴽⵓ ⵢⴰⵏ ⴰⵔ ⵉⵜⵜⴰⵡⵙ ⵖ ⵜⵡⵉⵣⵉ ⵏ ⵡⴰⵎⵓⵏ ⵙ ⵓⵢⵏⵏⴰ ⵎⵓ ⵉⵥ...   \n",
       "483  Kawiriaja ichanu ikicha utatinuka charanishija...   \n",
       "484  Ra'ta' bu:unny na:a pahr yde:e:i'dy ze:i'ny la...   \n",
       "485  Wonke umuntu uneqhaza emphakathini okuwukuphel...   \n",
       "\n",
       "                                                 29-02  \\\n",
       "0    Óla qualqué nguê ca gozá dirêtu cu liberdade, ...   \n",
       "1    Na tudu diritu que faladu na ê declaçon, ora q...   \n",
       "2    Mu kikalakalu kia ubinganu uoso, ni mu kutana ...   \n",
       "3    Atu moris ho direitu, atu bele hetan liberdade...   \n",
       "4    Ko kusuisapo ovihandeleko evi loku vitelisa ok...   \n",
       "..                                                 ...   \n",
       "481  Ze haki ne ze nafasi za haina mdru nkazitsina ...   \n",
       "482  ⴰⵔ ⵏⵏ ⵉⵜⵜⴷⵓⵍ ⵓⴼⴳⴰⵏ ⵙ ⵉⵙⴽⵔⴰⴼ ⵍⵍⵉ ⵉⵍⵍⴰⵏ ⴳ ⵓⵙⵍⴳⵏ ...   \n",
       "483  Ta nuka cha meiri ku rikuanu ta nuka tawijuka ...   \n",
       "484  Ra le'i na:a pahr chu'ihzy pahr ga'pdo:o ra de...   \n",
       "485  Ekusebenziseni amalungelo nenkululeko yakhe, u...   \n",
       "\n",
       "                                                 29-03  \\\n",
       "0    Tudu dirêtu cu liberdade sé na ca pô zisti con...   \n",
       "1    Nin un dia ês diritus cu liberdadis ca pudi fa...   \n",
       "2    Kanaku kima, maka, mba imbamba itenesu ku tobe...   \n",
       "3    Hotu-hotu sei tuir lolós direitu ho liberdade ...   \n",
       "4    Ovihandeleko evi vilingiwa lika oku kolisa ong...   \n",
       "..                                                 ...   \n",
       "481  Ze haki ne ze nafasi yizo nkazina udjuwa, hain...   \n",
       "482  ⵖⵉⴽⵏⵏⴰ ⴽⴰ ⴳⴰⵏⵜ ⵜⵖⴰⵡⵙⵉⵡⵉⵏ ⵓⵔ ⴷ ⵉⵇⵇⴰⵏ ⴰⴷ ⵎⵎⵙⴽⴰⵔⵏ...   \n",
       "483  Ku ikicha nuka rikuanu ta nukaka puchakirinu t...   \n",
       "484  Ra'ta' bu:unny na:a pahr chu' zi'cy nih canni:...   \n",
       "485  Lamalungelo nenkululeko akunakusetshenziswa ng...   \n",
       "\n",
       "                      30-00  \\\n",
       "0                Artigo 30º   \n",
       "1               ARTIGO 30º.   \n",
       "2            MAKUINHI ATATU   \n",
       "3                 Artigu 30   \n",
       "4              ONDAKA YA 30   \n",
       "..                      ...   \n",
       "481   Faslu ya mengo miraru   \n",
       "482              ⴰⵎⴰⴳⵔⴰⴷ 30   \n",
       "483              Akatsuju30   \n",
       "484  Ga:ally Ahbtsë:ë' (30)   \n",
       "485              Isigaba 30   \n",
       "\n",
       "                                                 30-01 30-02  \n",
       "0    Tudu cuá cu sá ni Declaraçón sé na ca pô plimi...        \n",
       "1    Ninguin ca pudi ncunha na nin un palabra di ê ...        \n",
       "2    Kanaku utundilu ua kamukua uambote, ukexilu mb...        \n",
       "3    Naran Nasaun ida, klibur ruma e naran ema ida,...        \n",
       "4    Lacimue ocihandeleko casonehiwa vu Vangi mulo ...        \n",
       "..                                                 ...   ...  \n",
       "481  Kapvatsi faslu yahe le Katiba linu lidjo udjuw...        \n",
       "482  ⵓⵔ ⵉⵍⵍⵉ ⵖ ⵓⵍⵖⵓ ⴰⴷ ⴽⵔⴰ ⵏ ⵓⴹⵕⵉⵚ ⴰⴼⴰⴷ ⴰⴷ ⵉⵙⵎⴷⵢⴰ ⴽ...        \n",
       "483  Taikua tamasa ikicha kayapi atijianuka ikicha ...        \n",
       "484  Nye:e'cy te'ihby nasyoony nye:e'cy te'ihby bu:...        \n",
       "485  Akukho lutho okukuloluGunyazo okuyohunyushwa n...        \n",
       "\n",
       "[486 rows x 136 columns]"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "missing_vals = {'', None, '?', '[missing]', '[?]', '[Missing?]'}\n",
    "df = df.applymap(lambda x: '' if (x or x.strip()) in missing_vals else x)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "id": "92c22245-0140-4046-9211-835c76dbefa8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "remove columns ['00-12', '00-13', '00-14', '00-15', '00-16', '00-17', '00-18', '00-19', '01-02', '02-03', '02-04', '03-02', '05-02', '05-03', '06-02', '07-02', '08-02', '08-03', '09-02', '09-03', '10-02', '10-03', '10-04', '11-03', '12-02', '12-03', '12-04', '12-05', '16-04', '17-03', '18-02', '18-03', '19-02', '20-03', '22-02', '22-03', '24-02', '25-03', '26-04', '27-03', '28-02', '28-03', '30-02']\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "sparse_cols = []\n",
    "for col_name, n_found in df.applymap(lambda x: bool(x or x.strip())).sum(axis=0).items():\n",
    "    if n_found <= 50:\n",
    "        sparse_cols.append(col_name)\n",
    "\n",
    "print('remove columns', sparse_cols)\n",
    "len(sparse_cols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "id": "3c241606-3cfb-4b63-b21a-026e92822d2a",
   "metadata": {},
   "outputs": [],
   "source": [
    "skip_cells = []\n",
    "for col in sparse_cols:\n",
    "    for lang, val in zip(df['Lang'], df[col]):\n",
    "        if val:\n",
    "            skip_cells.append((lang, col, val))\n",
    "\n",
    "with open('skipped-recs.tsv', 'w') as out:\n",
    "    for lang, col, val in sorted(skip_cells):\n",
    "        out.write(f'{lang}\\t{col}\\t{val}\\n')    \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "686e92d0-f27a-457e-abf7-635e97cb92bd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Lang</th>\n",
       "      <th>00-00</th>\n",
       "      <th>00-01</th>\n",
       "      <th>00-02</th>\n",
       "      <th>00-03</th>\n",
       "      <th>00-04</th>\n",
       "      <th>00-05</th>\n",
       "      <th>00-06</th>\n",
       "      <th>00-07</th>\n",
       "      <th>00-08</th>\n",
       "      <th>...</th>\n",
       "      <th>27-01</th>\n",
       "      <th>27-02</th>\n",
       "      <th>28-00</th>\n",
       "      <th>28-01</th>\n",
       "      <th>29-00</th>\n",
       "      <th>29-01</th>\n",
       "      <th>29-02</th>\n",
       "      <th>29-03</th>\n",
       "      <th>30-00</th>\n",
       "      <th>30-01</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>007</td>\n",
       "      <td>Declaraçón Universal di Dirêtu di Hómé</td>\n",
       "      <td>Punda dignidade di tudo nguê di mundu e dirêtu...</td>\n",
       "      <td>Punda fata di conheximentu e displêzu di dirêt...</td>\n",
       "      <td>Punda ploteçón di dirêtu di hómé baseado ni ua...</td>\n",
       "      <td>Punda ê sá importante lumadu conselhá disenvol...</td>\n",
       "      <td>Punda ni Cata, tudu pôvô di Naçón Unida plocla...</td>\n",
       "      <td>Punda tudu Estado memblu xiná complomissu cuma...</td>\n",
       "      <td>Punda ua mêma conceçón di nen dirêtu cu liberd...</td>\n",
       "      <td>Assembleia Geral</td>\n",
       "      <td>...</td>\n",
       "      <td>Tudu nguê tê dirêtu di participá ni cultura di...</td>\n",
       "      <td>Tudu nguê tê dirêtu di proteçón di interesse m...</td>\n",
       "      <td>Artigo 28º</td>\n",
       "      <td>Tudu nguê tê dirêtu di fé pa zisti, ni plano s...</td>\n",
       "      <td>Artigo 29º</td>\n",
       "      <td>Qualqué ngué tê obligaçón ni glupu dê, e xi ê ...</td>\n",
       "      <td>Óla qualqué nguê ca gozá dirêtu cu liberdade, ...</td>\n",
       "      <td>Tudu dirêtu cu liberdade sé na ca pô zisti con...</td>\n",
       "      <td>Artigo 30º</td>\n",
       "      <td>Tudu cuá cu sá ni Declaraçón sé na ca pô plimi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>008</td>\n",
       "      <td>DECLARAÇON UNIVERSAL DI DIRITU DI OMIS</td>\n",
       "      <td>Suma qui qui ricunhicidu dignidadi di tudu mem...</td>\n",
       "      <td>Suma falta di cunsi, cu disprezu di diritu di ...</td>\n",
       "      <td>Omi padidu pa viki, pa quila I dibidi tadjadu ...</td>\n",
       "      <td>Suma na mundu tudu djintis díbidi mama, I purc...</td>\n",
       "      <td>Suma qui carta qui Naçon Unida scribi pa si po...</td>\n",
       "      <td>Suma stadus qui pui na son djurmenti pui mon p...</td>\n",
       "      <td>Só ora qui tudu djintis intindi diritu ê barba...</td>\n",
       "      <td>ASSEMBLEIA GERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Tudu pecadur tem diritu di mati cermónia di si...</td>\n",
       "      <td>Tudu tem diritu di guardadu cussa qui dissel I...</td>\n",
       "      <td>ARTIGO 28º.</td>\n",
       "      <td>Na ê Declaração, tudu pecadur tem diritu di fa...</td>\n",
       "      <td>ARTIGO 29º.</td>\n",
       "      <td>Cada pecadur tem quê qui díbidi fassi na si co...</td>\n",
       "      <td>Na tudu diritu que faladu na ê declaçon, ora q...</td>\n",
       "      <td>Nin un dia ês diritus cu liberdadis ca pudi fa...</td>\n",
       "      <td>ARTIGO 30º.</td>\n",
       "      <td>Ninguin ca pudi ncunha na nin un palabra di ê ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>009</td>\n",
       "      <td></td>\n",
       "      <td>O kutetulula kuila, o kuijia o ujitu mu ukunji...</td>\n",
       "      <td>O kutetulula kuila o mutu mu ku kamba o kuijia...</td>\n",
       "      <td>O kutetulula uixi, kia tokala bu kale o dikuat...</td>\n",
       "      <td>O kutetulula kuila, kia tokala o dikuatenenu d...</td>\n",
       "      <td>O kutetulula kuila, o mukanda ua kifuxi kia ng...</td>\n",
       "      <td>O kutetulula kuila o Jinguvulu ja Jimbandu ia ...</td>\n",
       "      <td>Mu kutetulula kuila o mu dixiganeku dimoxi dia...</td>\n",
       "      <td>O KIONGE KIA KISANGELA</td>\n",
       "      <td>...</td>\n",
       "      <td>Mutu uoso uoso uala ni ubinganu ua tokala ni b...</td>\n",
       "      <td>Mutu uoso uala uê ni ubinganu ua dikuatekesu m...</td>\n",
       "      <td>MAKUINHI IAIDI NI DINAKE</td>\n",
       "      <td>Mutu uoso uoso uala ni ubinganu ua kuxinganeka...</td>\n",
       "      <td>MAKUINHI AIADI NI DIVUA</td>\n",
       "      <td>Mutu uoso uoso ua tokala kubanga ni ujitu imba...</td>\n",
       "      <td>Mu kikalakalu kia ubinganu uoso, ni mu kutana ...</td>\n",
       "      <td>Kanaku kima, maka, mba imbamba itenesu ku tobe...</td>\n",
       "      <td>MAKUINHI ATATU</td>\n",
       "      <td>Kanaku utundilu ua kamukua uambote, ukexilu mb...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>010</td>\n",
       "      <td>Deklarasaun kona ba Ema tomak nia Direitu, iha...</td>\n",
       "      <td>- atu bele moris ho liberdade, ho justisa, ho ...</td>\n",
       "      <td>- tan lakohi simu, tan heuuai ema nia direitu ...</td>\n",
       "      <td>- atu tahan ema tomak nia direitu tuir ukun ho...</td>\n",
       "      <td>- atu buka hametin damen iha nasaun tomak.</td>\n",
       "      <td>- iha Surat Deklarasaun ne’e, Nasaun tomak fo ...</td>\n",
       "      <td>- Nasaun tomak iha O.N.U. tau lia ba malu atu ...</td>\n",
       "      <td>- atu ema tomak halo tuir lia hirak ne’e be fo...</td>\n",
       "      <td>Asembleia Boot</td>\n",
       "      <td>...</td>\n",
       "      <td>Naran ema ida iha direitu atu tama, tuir nia h...</td>\n",
       "      <td>Naran ema ida iha direitu atu hetan tulun kona...</td>\n",
       "      <td>Artigu 28</td>\n",
       "      <td>Naran ema ida iha direitu, iha fatin ne’e be n...</td>\n",
       "      <td>Artigu 29</td>\n",
       "      <td>Naran ema ida sei halo buat ruma ba nia rain, ...</td>\n",
       "      <td>Atu moris ho direitu, atu bele hetan liberdade...</td>\n",
       "      <td>Hotu-hotu sei tuir lolós direitu ho liberdade ...</td>\n",
       "      <td>Artigu 30</td>\n",
       "      <td>Naran Nasaun ida, klibur ruma e naran ema ida,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>011</td>\n",
       "      <td>Ohuminyo Yoluali Yoku Tata Ovimuenyo Viomanu</td>\n",
       "      <td>Unu womanu loku sumbila omuenyo wapata omanu v...</td>\n",
       "      <td>Ekambo liu kulihiso kuenda oku pembula ovihand...</td>\n",
       "      <td>Okutata omuenyo womanu oco cavelapo , kuenje c...</td>\n",
       "      <td>Ca sesamela okuti pokati kolofeka viosi pa kal...</td>\n",
       "      <td>Ekolelõ liomanu vosi va tiamela ko Hongele Yol...</td>\n",
       "      <td>Olofeka viosi vi tiamelã ko Hongele Yolofeka (...</td>\n",
       "      <td>Kovisila evi vioku tata omuenyo womanu oko ku ...</td>\n",
       "      <td>Onjango Yinene</td>\n",
       "      <td>...</td>\n",
       "      <td>Omunu wosi okuete omoko kuatisa kelongiso liov...</td>\n",
       "      <td>Omunu wosi okuete omoko yokuvetatela umesele w...</td>\n",
       "      <td>ONDAKA YA 28</td>\n",
       "      <td>Omunu wosi okuete omoko yoku kisika okuti ovih...</td>\n",
       "      <td>ONDAKA YA 29</td>\n",
       "      <td>Omunu wosi okuete ovikele lovocisoko a atiamel...</td>\n",
       "      <td>Ko kusuisapo ovihandeleko evi loku vitelisa ok...</td>\n",
       "      <td>Ovihandeleko evi vilingiwa lika oku kolisa ong...</td>\n",
       "      <td>ONDAKA YA 30</td>\n",
       "      <td>Lacimue ocihandeleko casonehiwa vu Vangi mulo ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>zdj</td>\n",
       "      <td>ANZIMIYO LA KILEMWENGU UHSU ZE HAKI ZAKI BINADAMU</td>\n",
       "      <td>1- Ha mwakinisho ukaya ho ukubali ye sheo shah...</td>\n",
       "      <td>2- Ha mwakinisho ukaya wo upuzi no uwoneya ze ...</td>\n",
       "      <td>3- Ha mwakinisho ukaya zo muhimu ho uhifadhwi ...</td>\n",
       "      <td>4- Ha mwakinisho ukaya zo muhimu ho utriya dji...</td>\n",
       "      <td>5- Ha mwakinisho ukaya harimwa le katiba mshin...</td>\n",
       "      <td>6- Ha mwakinisho ukaya ze daula wanashama zidj...</td>\n",
       "      <td>7- Ha mwakinisho ukaya mwelewano sawa wapwadzi...</td>\n",
       "      <td>8- Le Barazaka Kuu lahe Djumuyian ya madola ng...</td>\n",
       "      <td>...</td>\n",
       "      <td>Haina mdru ngena haki ya ndjiye harumwa ye mae...</td>\n",
       "      <td>Haina mdru ngena haki yahondrane na hifadhwi y...</td>\n",
       "      <td>Faslu ya yishrini na nane</td>\n",
       "      <td>Haina mwanadamu ngena haki pvakaye myenshi har...</td>\n",
       "      <td>Faslu ya yishiri na shenda</td>\n",
       "      <td>Ye mwanadamu ngena wadjau ze wadjibu zahahe ho...</td>\n",
       "      <td>Ze haki ne ze nafasi za haina mdru nkazitsina ...</td>\n",
       "      <td>Ze haki ne ze nafasi yizo nkazina udjuwa, hain...</td>\n",
       "      <td>Faslu ya mengo miraru</td>\n",
       "      <td>Kapvatsi faslu yahe le Katiba linu lidjo udjuw...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>zgh</td>\n",
       "      <td>ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ</td>\n",
       "      <td>ⵍⵍⵉⵖ ⵜⴳⴰ ⵜⵓⴽⵣⴰ ⵏ ⵓⵍⵍⴰⵍⵓ ⵏ ⴽⴰⵢⴳⴰⵜ ⵢⴰⵏ ⵖ ⵜⴰⵡⵊⴰ ⵜ...</td>\n",
       "      <td>ⵜⴳ ⵜⴰⵎⵜⵜⴰⵡⵜ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ ⴰⴷ ⵉⵜⵜⴰⵡⵉⵏ ⵜⵓⴳⵜⵜ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴳ ⵏ ⵉⵣⵔⴼⴰⵏⵏ ⵏ ⵓⵎⴷⴰⵏ ⵢⴰⵏ ⵓⴼⴳⴳⴰⴳ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⵍⵍⴰ ⴳ ⵜⵏⵜⵜⴰⵎⵜ ⵉⴷ ⵉⴳⴷⵓⴷⵏ ⵏ ⵜⵎⵜⵜⴰ ⵉⵎⵓⵏⵏ ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵎⵙⵓⵛⴽⴰⵏ ⵉⵡⴰⵏⴽⵏ ⵉⴳⵎⴰⵎⵏ, ⵙ ⵜⵡⵙⵉⵏ ⵏ ⵜⵎⴰⴷⴷⴰ...</td>\n",
       "      <td>ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴽ ⵙ ⵉⵣⵔⴼⴰⵏ ⴷ ⵜⴷⵔⴼⵉⵜ ⴰⵙⴽⴽⵉⵏ ⴰⴽⵙⵡ...</td>\n",
       "      <td>ⵉⵙⵙⴰⴼⵖ ⴷ ⵓⴳⵔⴰⵡ ⴰⵎⴰⵜⴰⵢ ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ...</td>\n",
       "      <td>ⴰⵍⵖⵓ ⴰⴷ, ⴰⴷ ⴷⵓⵙⵏ, ⵙ ⵓⵙⵙⵍⵎⴷ ⴷ ⵓⵙⴳⵎⵉ, ⵙⴱⵓⵖⵍⵓⵏ ⴷ ...</td>\n",
       "      <td>...</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼⴰⴷ ⵢⴰⵡⵙ ⵖ ⵜⵓⴷⵔⵜ ⵏ ⵡⴰⵎⵓⵏ ⵏ...</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⵜⴳⴰ ⵜⴷⵔⴼⵉⵜ ⵏ ⵓⵙⵏⵓⵍⴼⵓ ⴷ ⵜ...</td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 28</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⴰⴷ ⵉⵙⴼⴰⵢⴷ ⵖ ⵓⵖⴰⵡⴰⵙ ⴰⵏⴰⵎⵓ...</td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 29</td>\n",
       "      <td>ⴽⵓ ⵢⴰⵏ ⴰⵔ ⵉⵜⵜⴰⵡⵙ ⵖ ⵜⵡⵉⵣⵉ ⵏ ⵡⴰⵎⵓⵏ ⵙ ⵓⵢⵏⵏⴰ ⵎⵓ ⵉⵥ...</td>\n",
       "      <td>ⴰⵔ ⵏⵏ ⵉⵜⵜⴷⵓⵍ ⵓⴼⴳⴰⵏ ⵙ ⵉⵙⴽⵔⴰⴼ ⵍⵍⵉ ⵉⵍⵍⴰⵏ ⴳ ⵓⵙⵍⴳⵏ ...</td>\n",
       "      <td>ⵖⵉⴽⵏⵏⴰ ⴽⴰ ⴳⴰⵏⵜ ⵜⵖⴰⵡⵙⵉⵡⵉⵏ ⵓⵔ ⴷ ⵉⵇⵇⴰⵏ ⴰⴷ ⵎⵎⵙⴽⴰⵔⵏ...</td>\n",
       "      <td>ⴰⵎⴰⴳⵔⴰⴷ 30</td>\n",
       "      <td>ⵓⵔ ⵉⵍⵍⵉ ⵖ ⵓⵍⵖⵓ ⴰⴷ ⴽⵔⴰ ⵏ ⵓⴹⵕⵉⵚ ⴰⴼⴰⴷ ⴰⴷ ⵉⵙⵎⴷⵢⴰ ⴽ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>zro</td>\n",
       "      <td></td>\n",
       "      <td>Panichanu tamasa taykua kayapi kupanimajicha i...</td>\n",
       "      <td>Panichanu ikicha tamanu rikuanu kupanimajicha ...</td>\n",
       "      <td>Panicha cha nuka nishima niata akuinaja aramuj...</td>\n",
       "      <td>Panicha aramujun kiniana kupanicha majicha iki...</td>\n",
       "      <td>Kiraitia kiniana amimaja</td>\n",
       "      <td>Akatsajuka anicha ahi</td>\n",
       "      <td>Akatsuju kiraitia rikuanu kayapuina ta nuka ti...</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>Kawiriaja kayapi ichanu ikicha iriaja ta pucha...</td>\n",
       "      <td>Kawiriaja kayapi ichanu ikicha rikuanu ta nuka...</td>\n",
       "      <td>Akatsuju 28</td>\n",
       "      <td>Kawiriya kayapi ichanu ikicha rikuanu ta nuka ...</td>\n",
       "      <td>Akatsuju 29</td>\n",
       "      <td>Kawiriaja ichanu ikicha utatinuka charanishija...</td>\n",
       "      <td>Ta nuka cha meiri ku rikuanu ta nuka tawijuka ...</td>\n",
       "      <td>Ku ikicha nuka rikuanu ta nukaka puchakirinu t...</td>\n",
       "      <td>Akatsuju30</td>\n",
       "      <td>Taikua tamasa ikicha kayapi atijianuka ikicha ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>ztu</td>\n",
       "      <td>Declarasyoony x:te:e'n Deree'ch x:te:e' Ra'ta'...</td>\n",
       "      <td>Zi'cy na:a dignidaa deree'ch nah x:te:e' ra'ta...</td>\n",
       "      <td>Zi'cy na:a gahll quei'ty runybe:e' ra deree'ch...</td>\n",
       "      <td>Zi'cy na:a na:a pahr chu' le'i nih guuny prote...</td>\n",
       "      <td>Zi'cy na:a na:a pahr ga'c ra nasyoony amiiegw,</td>\n",
       "      <td>Zi'cy na:a ra bu:unny x:te:e'n Naciones Unidas...</td>\n",
       "      <td>Zi'cy na:a ra mye'mmr x:te:e'n Naciones Unidas...</td>\n",
       "      <td>Zi'cy na:a na:a pahr ga'cbe:e' bu:unny ra dere...</td>\n",
       "      <td>Nah chiru'</td>\n",
       "      <td>...</td>\n",
       "      <td>Ra'ta' bu:unny ra:a'p deree'ch pahr guuny part...</td>\n",
       "      <td>Ra'ta' bu:unny ra:a'p deree'ch gunybe:e'rëng b...</td>\n",
       "      <td>Ga:ally Ahbx:o:on (28)</td>\n",
       "      <td>Ra'ta' bu:unny ra:a'p deree'ch chu' gax:lyuh l...</td>\n",
       "      <td>Ga:ally Ahbga:a:a' (29)</td>\n",
       "      <td>Ra'ta' bu:unny na:a pahr yde:e:i'dy ze:i'ny la...</td>\n",
       "      <td>Ra le'i na:a pahr chu'ihzy pahr ga'pdo:o ra de...</td>\n",
       "      <td>Ra'ta' bu:unny na:a pahr chu' zi'cy nih canni:...</td>\n",
       "      <td>Ga:ally Ahbtsë:ë' (30)</td>\n",
       "      <td>Nye:e'cy te'ihby nasyoony nye:e'cy te'ihby bu:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>zul</td>\n",
       "      <td>UMBHALO OGCWELE WOGUNYAZO LWAMALUNGELO OLUNTU ...</td>\n",
       "      <td>Ngokunjalo ukwamukelwa ngokuzuzwa kwesithunzi ...</td>\n",
       "      <td>Ngokunjalo ukunganakwa nokwedelelwa kwamalunge...</td>\n",
       "      <td>Ngokunjalo kudingekile, uma umuntu engenakupho...</td>\n",
       "      <td>Ngokunjalo kudingekile ukuba kwenyuswe ukuthut...</td>\n",
       "      <td>Ngokunjalo abantu beNhlangano yeZizwe bayinqin...</td>\n",
       "      <td>Ngokunjalo aMalunga eMibuso azibophezele mathu...</td>\n",
       "      <td>Ngokunjalo ukuqondwa kahle ngokufanayo kwalama...</td>\n",
       "      <td>MANJE, NGAKHOKE</td>\n",
       "      <td>...</td>\n",
       "      <td>Wonke umuntu unelungelo elikhululekile lokuzim...</td>\n",
       "      <td>Wonke umuntu unelungelo lokuvikeleka kwezifiso...</td>\n",
       "      <td>Isigaba 28</td>\n",
       "      <td>Wonke umuntu emphakathini nasemhlabeni kumele ...</td>\n",
       "      <td>Isigaba 29</td>\n",
       "      <td>Wonke umuntu uneqhaza emphakathini okuwukuphel...</td>\n",
       "      <td>Ekusebenziseni amalungelo nenkululeko yakhe, u...</td>\n",
       "      <td>Lamalungelo nenkululeko akunakusetshenziswa ng...</td>\n",
       "      <td>Isigaba 30</td>\n",
       "      <td>Akukho lutho okukuloluGunyazo okuyohunyushwa n...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>486 rows × 93 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Lang                                              00-00  \\\n",
       "0    007             Declaraçón Universal di Dirêtu di Hómé   \n",
       "1    008             DECLARAÇON UNIVERSAL DI DIRITU DI OMIS   \n",
       "2    009                                                      \n",
       "3    010  Deklarasaun kona ba Ema tomak nia Direitu, iha...   \n",
       "4    011       Ohuminyo Yoluali Yoku Tata Ovimuenyo Viomanu   \n",
       "..   ...                                                ...   \n",
       "481  zdj  ANZIMIYO LA KILEMWENGU UHSU ZE HAKI ZAKI BINADAMU   \n",
       "482  zgh                      ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ   \n",
       "483  zro                                                      \n",
       "484  ztu  Declarasyoony x:te:e'n Deree'ch x:te:e' Ra'ta'...   \n",
       "485  zul  UMBHALO OGCWELE WOGUNYAZO LWAMALUNGELO OLUNTU ...   \n",
       "\n",
       "                                                 00-01  \\\n",
       "0    Punda dignidade di tudo nguê di mundu e dirêtu...   \n",
       "1    Suma qui qui ricunhicidu dignidadi di tudu mem...   \n",
       "2    O kutetulula kuila, o kuijia o ujitu mu ukunji...   \n",
       "3    - atu bele moris ho liberdade, ho justisa, ho ...   \n",
       "4    Unu womanu loku sumbila omuenyo wapata omanu v...   \n",
       "..                                                 ...   \n",
       "481  1- Ha mwakinisho ukaya ho ukubali ye sheo shah...   \n",
       "482  ⵍⵍⵉⵖ ⵜⴳⴰ ⵜⵓⴽⵣⴰ ⵏ ⵓⵍⵍⴰⵍⵓ ⵏ ⴽⴰⵢⴳⴰⵜ ⵢⴰⵏ ⵖ ⵜⴰⵡⵊⴰ ⵜ...   \n",
       "483  Panichanu tamasa taykua kayapi kupanimajicha i...   \n",
       "484  Zi'cy na:a dignidaa deree'ch nah x:te:e' ra'ta...   \n",
       "485  Ngokunjalo ukwamukelwa ngokuzuzwa kwesithunzi ...   \n",
       "\n",
       "                                                 00-02  \\\n",
       "0    Punda fata di conheximentu e displêzu di dirêt...   \n",
       "1    Suma falta di cunsi, cu disprezu di diritu di ...   \n",
       "2    O kutetulula kuila o mutu mu ku kamba o kuijia...   \n",
       "3    - tan lakohi simu, tan heuuai ema nia direitu ...   \n",
       "4    Ekambo liu kulihiso kuenda oku pembula ovihand...   \n",
       "..                                                 ...   \n",
       "481  2- Ha mwakinisho ukaya wo upuzi no uwoneya ze ...   \n",
       "482  ⵜⴳ ⵜⴰⵎⵜⵜⴰⵡⵜ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ⵓⴼⴳⴰⵏ ⴰⴷ ⵉⵜⵜⴰⵡⵉⵏ ⵜⵓⴳⵜⵜ ...   \n",
       "483  Panichanu ikicha tamanu rikuanu kupanimajicha ...   \n",
       "484  Zi'cy na:a gahll quei'ty runybe:e' ra deree'ch...   \n",
       "485  Ngokunjalo ukunganakwa nokwedelelwa kwamalunge...   \n",
       "\n",
       "                                                 00-03  \\\n",
       "0    Punda ploteçón di dirêtu di hómé baseado ni ua...   \n",
       "1    Omi padidu pa viki, pa quila I dibidi tadjadu ...   \n",
       "2    O kutetulula uixi, kia tokala bu kale o dikuat...   \n",
       "3    - atu tahan ema tomak nia direitu tuir ukun ho...   \n",
       "4    Okutata omuenyo womanu oco cavelapo , kuenje c...   \n",
       "..                                                 ...   \n",
       "481  3- Ha mwakinisho ukaya zo muhimu ho uhifadhwi ...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴳ ⵏ ⵉⵣⵔⴼⴰⵏⵏ ⵏ ⵓⵎⴷⴰⵏ ⵢⴰⵏ ⵓⴼⴳⴳⴰⴳ ...   \n",
       "483  Panicha cha nuka nishima niata akuinaja aramuj...   \n",
       "484  Zi'cy na:a na:a pahr chu' le'i nih guuny prote...   \n",
       "485  Ngokunjalo kudingekile, uma umuntu engenakupho...   \n",
       "\n",
       "                                                 00-04  \\\n",
       "0    Punda ê sá importante lumadu conselhá disenvol...   \n",
       "1    Suma na mundu tudu djintis díbidi mama, I purc...   \n",
       "2    O kutetulula kuila, kia tokala o dikuatenenu d...   \n",
       "3           - atu buka hametin damen iha nasaun tomak.   \n",
       "4    Ca sesamela okuti pokati kolofeka viosi pa kal...   \n",
       "..                                                 ...   \n",
       "481  4- Ha mwakinisho ukaya zo muhimu ho utriya dji...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⵍⵍⴰ ⴳ ⵜⵏⵜⵜⴰⵎⵜ ⵉⴷ ⵉⴳⴷⵓⴷⵏ ⵏ ⵜⵎⵜⵜⴰ ⵉⵎⵓⵏⵏ ...   \n",
       "483  Panicha aramujun kiniana kupanicha majicha iki...   \n",
       "484     Zi'cy na:a na:a pahr ga'c ra nasyoony amiiegw,   \n",
       "485  Ngokunjalo kudingekile ukuba kwenyuswe ukuthut...   \n",
       "\n",
       "                                                 00-05  \\\n",
       "0    Punda ni Cata, tudu pôvô di Naçón Unida plocla...   \n",
       "1    Suma qui carta qui Naçon Unida scribi pa si po...   \n",
       "2    O kutetulula kuila, o mukanda ua kifuxi kia ng...   \n",
       "3    - iha Surat Deklarasaun ne’e, Nasaun tomak fo ...   \n",
       "4    Ekolelõ liomanu vosi va tiamela ko Hongele Yol...   \n",
       "..                                                 ...   \n",
       "481  5- Ha mwakinisho ukaya harimwa le katiba mshin...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵎⵙⵓⵛⴽⴰⵏ ⵉⵡⴰⵏⴽⵏ ⵉⴳⵎⴰⵎⵏ, ⵙ ⵜⵡⵙⵉⵏ ⵏ ⵜⵎⴰⴷⴷⴰ...   \n",
       "483                           Kiraitia kiniana amimaja   \n",
       "484  Zi'cy na:a ra bu:unny x:te:e'n Naciones Unidas...   \n",
       "485  Ngokunjalo abantu beNhlangano yeZizwe bayinqin...   \n",
       "\n",
       "                                                 00-06  \\\n",
       "0    Punda tudu Estado memblu xiná complomissu cuma...   \n",
       "1    Suma stadus qui pui na son djurmenti pui mon p...   \n",
       "2    O kutetulula kuila o Jinguvulu ja Jimbandu ia ...   \n",
       "3    - Nasaun tomak iha O.N.U. tau lia ba malu atu ...   \n",
       "4    Olofeka viosi vi tiamelã ko Hongele Yolofeka (...   \n",
       "..                                                 ...   \n",
       "481  6- Ha mwakinisho ukaya ze daula wanashama zidj...   \n",
       "482  ⴷ ⵍⵍⵉⵖ ⵉⴳⴰ ⵓⴼⵔⴰⴽ ⵙ ⵉⵣⵔⴼⴰⵏ ⴷ ⵜⴷⵔⴼⵉⵜ ⴰⵙⴽⴽⵉⵏ ⴰⴽⵙⵡ...   \n",
       "483                              Akatsajuka anicha ahi   \n",
       "484  Zi'cy na:a ra mye'mmr x:te:e'n Naciones Unidas...   \n",
       "485  Ngokunjalo aMalunga eMibuso azibophezele mathu...   \n",
       "\n",
       "                                                 00-07  \\\n",
       "0    Punda ua mêma conceçón di nen dirêtu cu liberd...   \n",
       "1    Só ora qui tudu djintis intindi diritu ê barba...   \n",
       "2    Mu kutetulula kuila o mu dixiganeku dimoxi dia...   \n",
       "3    - atu ema tomak halo tuir lia hirak ne’e be fo...   \n",
       "4    Kovisila evi vioku tata omuenyo womanu oko ku ...   \n",
       "..                                                 ...   \n",
       "481  7- Ha mwakinisho ukaya mwelewano sawa wapwadzi...   \n",
       "482  ⵉⵙⵙⴰⴼⵖ ⴷ ⵓⴳⵔⴰⵡ ⴰⵎⴰⵜⴰⵢ ⴰⵍⵖⵓ ⴰⵎⴰⴹⵍⴰⵏ ⵏ ⵉⵣⵔⴼⴰⵏ ⵏ ...   \n",
       "483  Akatsuju kiraitia rikuanu kayapuina ta nuka ti...   \n",
       "484  Zi'cy na:a na:a pahr ga'cbe:e' bu:unny ra dere...   \n",
       "485  Ngokunjalo ukuqondwa kahle ngokufanayo kwalama...   \n",
       "\n",
       "                                                 00-08  ...  \\\n",
       "0                                     Assembleia Geral  ...   \n",
       "1                                     ASSEMBLEIA GERAL  ...   \n",
       "2                               O KIONGE KIA KISANGELA  ...   \n",
       "3                                       Asembleia Boot  ...   \n",
       "4                                       Onjango Yinene  ...   \n",
       "..                                                 ...  ...   \n",
       "481  8- Le Barazaka Kuu lahe Djumuyian ya madola ng...  ...   \n",
       "482  ⴰⵍⵖⵓ ⴰⴷ, ⴰⴷ ⴷⵓⵙⵏ, ⵙ ⵓⵙⵙⵍⵎⴷ ⴷ ⵓⵙⴳⵎⵉ, ⵙⴱⵓⵖⵍⵓⵏ ⴷ ...  ...   \n",
       "483                                                     ...   \n",
       "484                                         Nah chiru'  ...   \n",
       "485                                    MANJE, NGAKHOKE  ...   \n",
       "\n",
       "                                                 27-01  \\\n",
       "0    Tudu nguê tê dirêtu di participá ni cultura di...   \n",
       "1    Tudu pecadur tem diritu di mati cermónia di si...   \n",
       "2    Mutu uoso uoso uala ni ubinganu ua tokala ni b...   \n",
       "3    Naran ema ida iha direitu atu tama, tuir nia h...   \n",
       "4    Omunu wosi okuete omoko kuatisa kelongiso liov...   \n",
       "..                                                 ...   \n",
       "481  Haina mdru ngena haki ya ndjiye harumwa ye mae...   \n",
       "482  ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼⴰⴷ ⵢⴰⵡⵙ ⵖ ⵜⵓⴷⵔⵜ ⵏ ⵡⴰⵎⵓⵏ ⵏ...   \n",
       "483  Kawiriaja kayapi ichanu ikicha iriaja ta pucha...   \n",
       "484  Ra'ta' bu:unny ra:a'p deree'ch pahr guuny part...   \n",
       "485  Wonke umuntu unelungelo elikhululekile lokuzim...   \n",
       "\n",
       "                                                 27-02  \\\n",
       "0    Tudu nguê tê dirêtu di proteçón di interesse m...   \n",
       "1    Tudu tem diritu di guardadu cussa qui dissel I...   \n",
       "2    Mutu uoso uala uê ni ubinganu ua dikuatekesu m...   \n",
       "3    Naran ema ida iha direitu atu hetan tulun kona...   \n",
       "4    Omunu wosi okuete omoko yokuvetatela umesele w...   \n",
       "..                                                 ...   \n",
       "481  Haina mdru ngena haki yahondrane na hifadhwi y...   \n",
       "482  ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⵜⴳⴰ ⵜⴷⵔⴼⵉⵜ ⵏ ⵓⵙⵏⵓⵍⴼⵓ ⴷ ⵜ...   \n",
       "483  Kawiriaja kayapi ichanu ikicha rikuanu ta nuka...   \n",
       "484  Ra'ta' bu:unny ra:a'p deree'ch gunybe:e'rëng b...   \n",
       "485  Wonke umuntu unelungelo lokuvikeleka kwezifiso...   \n",
       "\n",
       "                         28-00  \\\n",
       "0                   Artigo 28º   \n",
       "1                  ARTIGO 28º.   \n",
       "2     MAKUINHI IAIDI NI DINAKE   \n",
       "3                    Artigu 28   \n",
       "4                 ONDAKA YA 28   \n",
       "..                         ...   \n",
       "481  Faslu ya yishrini na nane   \n",
       "482                 ⴰⵎⴰⴳⵔⴰⴷ 28   \n",
       "483                Akatsuju 28   \n",
       "484     Ga:ally Ahbx:o:on (28)   \n",
       "485                 Isigaba 28   \n",
       "\n",
       "                                                 28-01  \\\n",
       "0    Tudu nguê tê dirêtu di fé pa zisti, ni plano s...   \n",
       "1    Na ê Declaração, tudu pecadur tem diritu di fa...   \n",
       "2    Mutu uoso uoso uala ni ubinganu ua kuxinganeka...   \n",
       "3    Naran ema ida iha direitu, iha fatin ne’e be n...   \n",
       "4    Omunu wosi okuete omoko yoku kisika okuti ovih...   \n",
       "..                                                 ...   \n",
       "481  Haina mwanadamu ngena haki pvakaye myenshi har...   \n",
       "482  ⴽⵓ ⵢⴰⵏ ⵉⵍⵍⴰ ⴷⴰⵔⵙ ⵓⵣⵔⴼ ⴰⴷ ⵉⵙⴼⴰⵢⴷ ⵖ ⵓⵖⴰⵡⴰⵙ ⴰⵏⴰⵎⵓ...   \n",
       "483  Kawiriya kayapi ichanu ikicha rikuanu ta nuka ...   \n",
       "484  Ra'ta' bu:unny ra:a'p deree'ch chu' gax:lyuh l...   \n",
       "485  Wonke umuntu emphakathini nasemhlabeni kumele ...   \n",
       "\n",
       "                          29-00  \\\n",
       "0                    Artigo 29º   \n",
       "1                   ARTIGO 29º.   \n",
       "2       MAKUINHI AIADI NI DIVUA   \n",
       "3                     Artigu 29   \n",
       "4                  ONDAKA YA 29   \n",
       "..                          ...   \n",
       "481  Faslu ya yishiri na shenda   \n",
       "482                  ⴰⵎⴰⴳⵔⴰⴷ 29   \n",
       "483                 Akatsuju 29   \n",
       "484     Ga:ally Ahbga:a:a' (29)   \n",
       "485                  Isigaba 29   \n",
       "\n",
       "                                                 29-01  \\\n",
       "0    Qualqué ngué tê obligaçón ni glupu dê, e xi ê ...   \n",
       "1    Cada pecadur tem quê qui díbidi fassi na si co...   \n",
       "2    Mutu uoso uoso ua tokala kubanga ni ujitu imba...   \n",
       "3    Naran ema ida sei halo buat ruma ba nia rain, ...   \n",
       "4    Omunu wosi okuete ovikele lovocisoko a atiamel...   \n",
       "..                                                 ...   \n",
       "481  Ye mwanadamu ngena wadjau ze wadjibu zahahe ho...   \n",
       "482  ⴽⵓ ⵢⴰⵏ ⴰⵔ ⵉⵜⵜⴰⵡⵙ ⵖ ⵜⵡⵉⵣⵉ ⵏ ⵡⴰⵎⵓⵏ ⵙ ⵓⵢⵏⵏⴰ ⵎⵓ ⵉⵥ...   \n",
       "483  Kawiriaja ichanu ikicha utatinuka charanishija...   \n",
       "484  Ra'ta' bu:unny na:a pahr yde:e:i'dy ze:i'ny la...   \n",
       "485  Wonke umuntu uneqhaza emphakathini okuwukuphel...   \n",
       "\n",
       "                                                 29-02  \\\n",
       "0    Óla qualqué nguê ca gozá dirêtu cu liberdade, ...   \n",
       "1    Na tudu diritu que faladu na ê declaçon, ora q...   \n",
       "2    Mu kikalakalu kia ubinganu uoso, ni mu kutana ...   \n",
       "3    Atu moris ho direitu, atu bele hetan liberdade...   \n",
       "4    Ko kusuisapo ovihandeleko evi loku vitelisa ok...   \n",
       "..                                                 ...   \n",
       "481  Ze haki ne ze nafasi za haina mdru nkazitsina ...   \n",
       "482  ⴰⵔ ⵏⵏ ⵉⵜⵜⴷⵓⵍ ⵓⴼⴳⴰⵏ ⵙ ⵉⵙⴽⵔⴰⴼ ⵍⵍⵉ ⵉⵍⵍⴰⵏ ⴳ ⵓⵙⵍⴳⵏ ...   \n",
       "483  Ta nuka cha meiri ku rikuanu ta nuka tawijuka ...   \n",
       "484  Ra le'i na:a pahr chu'ihzy pahr ga'pdo:o ra de...   \n",
       "485  Ekusebenziseni amalungelo nenkululeko yakhe, u...   \n",
       "\n",
       "                                                 29-03  \\\n",
       "0    Tudu dirêtu cu liberdade sé na ca pô zisti con...   \n",
       "1    Nin un dia ês diritus cu liberdadis ca pudi fa...   \n",
       "2    Kanaku kima, maka, mba imbamba itenesu ku tobe...   \n",
       "3    Hotu-hotu sei tuir lolós direitu ho liberdade ...   \n",
       "4    Ovihandeleko evi vilingiwa lika oku kolisa ong...   \n",
       "..                                                 ...   \n",
       "481  Ze haki ne ze nafasi yizo nkazina udjuwa, hain...   \n",
       "482  ⵖⵉⴽⵏⵏⴰ ⴽⴰ ⴳⴰⵏⵜ ⵜⵖⴰⵡⵙⵉⵡⵉⵏ ⵓⵔ ⴷ ⵉⵇⵇⴰⵏ ⴰⴷ ⵎⵎⵙⴽⴰⵔⵏ...   \n",
       "483  Ku ikicha nuka rikuanu ta nukaka puchakirinu t...   \n",
       "484  Ra'ta' bu:unny na:a pahr chu' zi'cy nih canni:...   \n",
       "485  Lamalungelo nenkululeko akunakusetshenziswa ng...   \n",
       "\n",
       "                      30-00                                              30-01  \n",
       "0                Artigo 30º  Tudu cuá cu sá ni Declaraçón sé na ca pô plimi...  \n",
       "1               ARTIGO 30º.  Ninguin ca pudi ncunha na nin un palabra di ê ...  \n",
       "2            MAKUINHI ATATU  Kanaku utundilu ua kamukua uambote, ukexilu mb...  \n",
       "3                 Artigu 30  Naran Nasaun ida, klibur ruma e naran ema ida,...  \n",
       "4              ONDAKA YA 30  Lacimue ocihandeleko casonehiwa vu Vangi mulo ...  \n",
       "..                      ...                                                ...  \n",
       "481   Faslu ya mengo miraru  Kapvatsi faslu yahe le Katiba linu lidjo udjuw...  \n",
       "482              ⴰⵎⴰⴳⵔⴰⴷ 30  ⵓⵔ ⵉⵍⵍⵉ ⵖ ⵓⵍⵖⵓ ⴰⴷ ⴽⵔⴰ ⵏ ⵓⴹⵕⵉⵚ ⴰⴼⴰⴷ ⴰⴷ ⵉⵙⵎⴷⵢⴰ ⴽ...  \n",
       "483              Akatsuju30  Taikua tamasa ikicha kayapi atijianuka ikicha ...  \n",
       "484  Ga:ally Ahbtsë:ë' (30)  Nye:e'cy te'ihby nasyoony nye:e'cy te'ihby bu:...  \n",
       "485              Isigaba 30  Akukho lutho okukuloluGunyazo okuyohunyushwa n...  \n",
       "\n",
       "[486 rows x 93 columns]"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_min = df.drop(columns=sparse_cols)\n",
    "df_min"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "id": "d3daf314-19f3-4219-a2f4-92ec0b1f4609",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[224, 412, 423, 446]"
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drop_rows = [idx for idx, n_found in df_min.applymap(lambda x: bool(x or x.strip())).sum(axis=1).items() if n_found <= 10]\n",
    "drop_rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "efe23579-e23e-4a3a-8d48-4a8e44449ebd",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_min = df_min.drop(index=drop_rows)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "bca5fc28-7a3f-43ee-b67a-f10a459813ef",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_min.to_csv('UDHR-align.v2.tsv', sep='\\t', index=False)\n",
    "df_min.T.to_csv('UDHR-align.v2T.tsv', sep='\\t', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "7fc52ee2-9df8-47fd-bfce-26c26acd85b3",
   "metadata": {},
   "outputs": [],
   "source": [
    "writer = pd.ExcelWriter('UDHR-align.v2.xlsx')\n",
    "\n",
    "df_min.to_excel(writer, sheet_name='Sheet1', index=False)\n",
    "df_min.T.to_excel(writer, sheet_name='Sheet2', index=True)\n",
    "\n",
    "writer.save()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1bac51c4-5f50-4695-8e80-a851547f221c",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}