GTU - DataWrangling.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Link for DataSet -> https://www.kaggle.com/janpreets/peeking-into-endangered-languages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Countries</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>Number of speakers</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1022</td>\n",
       "      <td>South Italian</td>\n",
       "      <td>italien du sud</td>\n",
       "      <td>napolitano-calabrés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>nap</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Neapolitan; Neapolitan-Calabrese; неаполитанск...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.9798</td>\n",
       "      <td>15.2490</td>\n",
       "      <td>Campania, Lucania (Basilicata), Abruzzi (Abruz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1023</td>\n",
       "      <td>Sicilian</td>\n",
       "      <td>sicilien</td>\n",
       "      <td>siciliano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>scn</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.4399</td>\n",
       "      <td>14.5019</td>\n",
       "      <td>Sicily (Sicilia), southern and central Calabri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>383</td>\n",
       "      <td>Low Saxon</td>\n",
       "      <td>bas-saxon</td>\n",
       "      <td>bajo sajón</td>\n",
       "      <td>Germany, Denmark, Netherlands, Poland, Russian...</td>\n",
       "      <td>DEU, DNK, NLD, POL, RUS</td>\n",
       "      <td>act, drt, frs, gos, nds, sdz, stl, twd, vel, wep</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Low German, Niedersächsisch, Nedersaksisch, Ni...</td>\n",
       "      <td>Neddersassisch</td>\n",
       "      <td>4800000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.4029</td>\n",
       "      <td>10.3601</td>\n",
       "      <td>northern Germany, the north-eastern part of th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335</td>\n",
       "      <td>Belarusian</td>\n",
       "      <td>biélorusse</td>\n",
       "      <td>bielorruso</td>\n",
       "      <td>Belarus, Latvia, Lithuania, Poland, Russian Fe...</td>\n",
       "      <td>BRB, LVA, LTU, POL, RUS, UKR</td>\n",
       "      <td>bel</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4000000.0</td>\n",
       "      <td>Hienadź Cychun: Weißrussisch. — Lexikon der Sp...</td>\n",
       "      <td>53.9560</td>\n",
       "      <td>27.5756</td>\n",
       "      <td>Belarus except the Polesian-speaking south-wes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>382</td>\n",
       "      <td>Lombard</td>\n",
       "      <td>lombard</td>\n",
       "      <td>lombardo</td>\n",
       "      <td>Italy, Switzerland</td>\n",
       "      <td>ITA, CHE</td>\n",
       "      <td>lmo</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.7215</td>\n",
       "      <td>9.3273</td>\n",
       "      <td>the region of Lombardy (except the southernmos...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2717</th>\n",
       "      <td>1972</td>\n",
       "      <td>Yonaguni</td>\n",
       "      <td>yonaguni</td>\n",
       "      <td>yonaguni</td>\n",
       "      <td>Japan</td>\n",
       "      <td>JPN</td>\n",
       "      <td>yoi</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yukio Uemura: The Ryukyuan language. Endangere...</td>\n",
       "      <td>24.4580</td>\n",
       "      <td>122.9802</td>\n",
       "      <td>Yonaguni Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718</th>\n",
       "      <td>2018</td>\n",
       "      <td>Yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>ycn</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.2633</td>\n",
       "      <td>-70.6640</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2719</th>\n",
       "      <td>2015</td>\n",
       "      <td>Yurutí (Colombia)</td>\n",
       "      <td>yurutí (Colombie)</td>\n",
       "      <td>yurutí (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>yui</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.1370</td>\n",
       "      <td>-70.2136</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2720</th>\n",
       "      <td>2716</td>\n",
       "      <td>Zangskari</td>\n",
       "      <td>zangskari</td>\n",
       "      <td>zangskari</td>\n",
       "      <td>India, Pakistan</td>\n",
       "      <td>IND, PAK</td>\n",
       "      <td>zau</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Zangs-dkar, Z’angkar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.0833</td>\n",
       "      <td>76.8500</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2721</th>\n",
       "      <td>2177</td>\n",
       "      <td>Zidgali</td>\n",
       "      <td>zidgali</td>\n",
       "      <td>zidgali</td>\n",
       "      <td>Oman</td>\n",
       "      <td>OMN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>Zidjali, Zadjali</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No authoritative source found yet; information...</td>\n",
       "      <td>23.4027</td>\n",
       "      <td>58.0957</td>\n",
       "      <td>Capital area of Muscat</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2722 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID    Name in English     Name in French      Name in Spanish  \\\n",
       "0     1022      South Italian     italien du sud  napolitano-calabrés   \n",
       "1     1023           Sicilian           sicilien            siciliano   \n",
       "2      383          Low Saxon          bas-saxon           bajo sajón   \n",
       "3      335         Belarusian         biélorusse           bielorruso   \n",
       "4      382            Lombard            lombard             lombardo   \n",
       "...    ...                ...                ...                  ...   \n",
       "2717  1972           Yonaguni           yonaguni             yonaguni   \n",
       "2718  2018             Yucuna             yucuna               yucuna   \n",
       "2719  2015  Yurutí (Colombia)  yurutí (Colombie)    yurutí (Colombia)   \n",
       "2720  2716          Zangskari          zangskari            zangskari   \n",
       "2721  2177            Zidgali            zidgali              zidgali   \n",
       "\n",
       "                                              Countries  \\\n",
       "0                                                 Italy   \n",
       "1                                                 Italy   \n",
       "2     Germany, Denmark, Netherlands, Poland, Russian...   \n",
       "3     Belarus, Latvia, Lithuania, Poland, Russian Fe...   \n",
       "4                                    Italy, Switzerland   \n",
       "...                                                 ...   \n",
       "2717                                              Japan   \n",
       "2718                                           Colombia   \n",
       "2719                                           Colombia   \n",
       "2720                                    India, Pakistan   \n",
       "2721                                               Oman   \n",
       "\n",
       "             Country codes alpha 3  \\\n",
       "0                              ITA   \n",
       "1                              ITA   \n",
       "2          DEU, DNK, NLD, POL, RUS   \n",
       "3     BRB, LVA, LTU, POL, RUS, UKR   \n",
       "4                         ITA, CHE   \n",
       "...                            ...   \n",
       "2717                           JPN   \n",
       "2718                           COL   \n",
       "2719                           COL   \n",
       "2720                      IND, PAK   \n",
       "2721                           OMN   \n",
       "\n",
       "                                        ISO639-3 codes Degree of endangerment  \\\n",
       "0                                                  nap             Vulnerable   \n",
       "1                                                  scn             Vulnerable   \n",
       "2     act, drt, frs, gos, nds, sdz, stl, twd, vel, wep             Vulnerable   \n",
       "3                                                  bel             Vulnerable   \n",
       "4                                                  lmo  Definitely endangered   \n",
       "...                                                ...                    ...   \n",
       "2717                                               yoi    Severely endangered   \n",
       "2718                                               ycn  Definitely endangered   \n",
       "2719                                               yui  Definitely endangered   \n",
       "2720                                               zau  Definitely endangered   \n",
       "2721                                               NaN  Critically endangered   \n",
       "\n",
       "                                        Alternate names Name in the language  \\\n",
       "0     Neapolitan; Neapolitan-Calabrese; неаполитанск...                  NaN   \n",
       "1                                                   NaN                  NaN   \n",
       "2     Low German, Niedersächsisch, Nedersaksisch, Ni...       Neddersassisch   \n",
       "3                                                   NaN                  NaN   \n",
       "4                                                   NaN                  NaN   \n",
       "...                                                 ...                  ...   \n",
       "2717                                                NaN                  NaN   \n",
       "2718                                                NaN                  NaN   \n",
       "2719                                                NaN                  NaN   \n",
       "2720                               Zangs-dkar, Z’angkar                  NaN   \n",
       "2721                                   Zidjali, Zadjali                  NaN   \n",
       "\n",
       "      Number of speakers                                            Sources  \\\n",
       "0              7500000.0                                                NaN   \n",
       "1              5000000.0                                                NaN   \n",
       "2              4800000.0                                                NaN   \n",
       "3              4000000.0  Hienadź Cychun: Weißrussisch. — Lexikon der Sp...   \n",
       "4              3500000.0                                                NaN   \n",
       "...                  ...                                                ...   \n",
       "2717                 NaN  Yukio Uemura: The Ryukyuan language. Endangere...   \n",
       "2718                 NaN                                                NaN   \n",
       "2719                 NaN                                                NaN   \n",
       "2720                 NaN                                                NaN   \n",
       "2721                 NaN  No authoritative source found yet; information...   \n",
       "\n",
       "      Latitude  Longitude                        Description of the location  \n",
       "0      40.9798    15.2490  Campania, Lucania (Basilicata), Abruzzi (Abruz...  \n",
       "1      37.4399    14.5019  Sicily (Sicilia), southern and central Calabri...  \n",
       "2      53.4029    10.3601  northern Germany, the north-eastern part of th...  \n",
       "3      53.9560    27.5756  Belarus except the Polesian-speaking south-wes...  \n",
       "4      45.7215     9.3273  the region of Lombardy (except the southernmos...  \n",
       "...        ...        ...                                                ...  \n",
       "2717   24.4580   122.9802                                    Yonaguni Island  \n",
       "2718   -1.2633   -70.6640                                                NaN  \n",
       "2719    1.1370   -70.2136                                                NaN  \n",
       "2720   34.0833    76.8500                                                NaN  \n",
       "2721   23.4027    58.0957                             Capital area of Muscat  \n",
       "\n",
       "[2722 rows x 15 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv(\"Language_data.csv\")\n",
    "data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## select rows which have Countries column value == Italy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Countries</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>Number of speakers</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1022</td>\n",
       "      <td>South Italian</td>\n",
       "      <td>italien du sud</td>\n",
       "      <td>napolitano-calabrés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>nap</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Neapolitan; Neapolitan-Calabrese; неаполитанск...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.9798</td>\n",
       "      <td>15.2490</td>\n",
       "      <td>Campania, Lucania (Basilicata), Abruzzi (Abruz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1023</td>\n",
       "      <td>Sicilian</td>\n",
       "      <td>sicilien</td>\n",
       "      <td>siciliano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>scn</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.4399</td>\n",
       "      <td>14.5019</td>\n",
       "      <td>Sicily (Sicilia), southern and central Calabri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>399</td>\n",
       "      <td>Piedmontese</td>\n",
       "      <td>piémontais</td>\n",
       "      <td>piamontés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>pms</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.2013</td>\n",
       "      <td>7.8662</td>\n",
       "      <td>Piedmont Region except the Novara Province, th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>337</td>\n",
       "      <td>Campidanese</td>\n",
       "      <td>campidanien</td>\n",
       "      <td>sardo campidanés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>sro</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Campidanese Sardinian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>900000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.2991</td>\n",
       "      <td>8.9868</td>\n",
       "      <td>southern Sardinia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>353</td>\n",
       "      <td>Friulian</td>\n",
       "      <td>frioulan</td>\n",
       "      <td>friulano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>fur</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.1037</td>\n",
       "      <td>13.1396</td>\n",
       "      <td>the Autonomous Region Friuli-Venezia Giulia ex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>381</td>\n",
       "      <td>Logudorese</td>\n",
       "      <td>logoudorien</td>\n",
       "      <td>sardo logudorés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>src</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Logudorese Sardinian; Logudorese-Nuorese</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.1116</td>\n",
       "      <td>9.1845</td>\n",
       "      <td>central Sardinia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>408</td>\n",
       "      <td>Sassarese</td>\n",
       "      <td>sassarien</td>\n",
       "      <td>sasarés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>sdc</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Sassarese Sardinian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.6139</td>\n",
       "      <td>8.6132</td>\n",
       "      <td>northwestern Sardinia; an outlying dialect of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>356</td>\n",
       "      <td>Gallurese</td>\n",
       "      <td>gallurien</td>\n",
       "      <td>sardo galurés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>sdn</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Gallurese Sardinian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.8802</td>\n",
       "      <td>9.4482</td>\n",
       "      <td>northeastern Sardinia; an outlying dialect of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>1347</td>\n",
       "      <td>Arbëresh</td>\n",
       "      <td>arbërerisht</td>\n",
       "      <td>arberés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>aae</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Arbëreshë Albanian</td>\n",
       "      <td>arbrisht</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>Walter Breu: Italoalbanisch. — Lexikon der Spr...</td>\n",
       "      <td>40.9321</td>\n",
       "      <td>14.8645</td>\n",
       "      <td>(i) Adriatic zone: Montecilfone, Campomarino, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>1330</td>\n",
       "      <td>Gallo-Sicilian</td>\n",
       "      <td>gallo-sicilien</td>\n",
       "      <td>galo-siciliano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>lmo</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.0167</td>\n",
       "      <td>14.5994</td>\n",
       "      <td>Nicosia, Sperlinga, Piazza Armerina, Valguarne...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>565</td>\n",
       "      <td>Ladin</td>\n",
       "      <td>ladin</td>\n",
       "      <td>ladino</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>lld</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.5531</td>\n",
       "      <td>11.8597</td>\n",
       "      <td>several towns and villages in the Dolomites, i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>1614</td>\n",
       "      <td>Griko (Salento)</td>\n",
       "      <td>griko (Salento)</td>\n",
       "      <td>griko salentino</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>ell</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.1578</td>\n",
       "      <td>18.2208</td>\n",
       "      <td>the Salento peninsula in Lecce Province in sou...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>1343</td>\n",
       "      <td>Algherese Catalan</td>\n",
       "      <td>catalan alguerais</td>\n",
       "      <td>alguerés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>cat</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>Enquesta d’usos lingüístics a l’Alguer 2004 av...</td>\n",
       "      <td>40.5638</td>\n",
       "      <td>8.3276</td>\n",
       "      <td>the town of Alghero in northwestern Sardinia; ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>1349</td>\n",
       "      <td>Molise Croatian</td>\n",
       "      <td>croate de Molise</td>\n",
       "      <td>croata molise</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>bos, hrv, srp</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>Walter Breu: Moliseslawisch. — Lexikon der Spr...</td>\n",
       "      <td>41.8787</td>\n",
       "      <td>14.7065</td>\n",
       "      <td>the villages of Montemitro (Mundimitar), San F...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>964</th>\n",
       "      <td>1339</td>\n",
       "      <td>Griko (Calabria)</td>\n",
       "      <td>griko (Calabre)</td>\n",
       "      <td>griko calabrés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>ell</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.9961</td>\n",
       "      <td>15.9329</td>\n",
       "      <td>a few villages near Reggio di Calabria in sout...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1198</th>\n",
       "      <td>1511</td>\n",
       "      <td>Mòcheno</td>\n",
       "      <td>mocheno</td>\n",
       "      <td>mócheno</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>mhn</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>Anthony R. Rowley: „Mocheno e Cimbro“: Von Dia...</td>\n",
       "      <td>46.1194</td>\n",
       "      <td>11.3258</td>\n",
       "      <td>Palù (Palai), Fierozzo (Florutz) and Frassilon...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1205</th>\n",
       "      <td>1348</td>\n",
       "      <td>Resian</td>\n",
       "      <td>résien</td>\n",
       "      <td>resiano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>slv</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Resian Slovene (en), resiano (it), Rezijanski ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.3734</td>\n",
       "      <td>13.3058</td>\n",
       "      <td>Resia in the northeastern part of Udine Provin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1315</th>\n",
       "      <td>351</td>\n",
       "      <td>Faetar</td>\n",
       "      <td>faetar</td>\n",
       "      <td>faetar</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>frp</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600.0</td>\n",
       "      <td>Naomi Nagy: Writing a sociolinguistics grammar...</td>\n",
       "      <td>41.3265</td>\n",
       "      <td>15.1721</td>\n",
       "      <td>Faeto and Celle San Vito in Foggia Province in...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1455</th>\n",
       "      <td>1345</td>\n",
       "      <td>Cimbrian</td>\n",
       "      <td>cimbre</td>\n",
       "      <td>cimbriano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>cim</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Cimbro</td>\n",
       "      <td>NaN</td>\n",
       "      <td>400.0</td>\n",
       "      <td>Anthony R. Rowley: „Mocheno e Cimbro“: Von Dia...</td>\n",
       "      <td>45.8670</td>\n",
       "      <td>11.4268</td>\n",
       "      <td>vigorously spoken in Luserna (Lusern) in Trent...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1506</th>\n",
       "      <td>357</td>\n",
       "      <td>Gardiol</td>\n",
       "      <td>gardiol</td>\n",
       "      <td>gardiol</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>340.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.4658</td>\n",
       "      <td>15.9933</td>\n",
       "      <td>Guardia Piedmontese in Calabria; an outlying d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1663</th>\n",
       "      <td>1344</td>\n",
       "      <td>Töitschu</td>\n",
       "      <td>töitschu</td>\n",
       "      <td>töitschu</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>gsw, swg, wae</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.6913</td>\n",
       "      <td>7.8682</td>\n",
       "      <td>the village of Issime (Eischeme) in the upper ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID    Name in English     Name in French      Name in Spanish  \\\n",
       "0     1022      South Italian     italien du sud  napolitano-calabrés   \n",
       "1     1023           Sicilian           sicilien            siciliano   \n",
       "13     399        Piedmontese         piémontais            piamontés   \n",
       "36     337        Campidanese        campidanien     sardo campidanés   \n",
       "53     353           Friulian           frioulan             friulano   \n",
       "80     381         Logudorese        logoudorien      sardo logudorés   \n",
       "157    408          Sassarese          sassarien              sasarés   \n",
       "170    356          Gallurese          gallurien        sardo galurés   \n",
       "197   1347           Arbëresh        arbërerisht              arberés   \n",
       "212   1330     Gallo-Sicilian     gallo-sicilien       galo-siciliano   \n",
       "320    565              Ladin              ladin               ladino   \n",
       "391   1614    Griko (Salento)    griko (Salento)      griko salentino   \n",
       "510   1343  Algherese Catalan  catalan alguerais             alguerés   \n",
       "729   1349    Molise Croatian   croate de Molise        croata molise   \n",
       "964   1339   Griko (Calabria)    griko (Calabre)       griko calabrés   \n",
       "1198  1511            Mòcheno            mocheno              mócheno   \n",
       "1205  1348             Resian             résien              resiano   \n",
       "1315   351             Faetar             faetar               faetar   \n",
       "1455  1345           Cimbrian             cimbre            cimbriano   \n",
       "1506   357            Gardiol            gardiol              gardiol   \n",
       "1663  1344           Töitschu           töitschu             töitschu   \n",
       "\n",
       "     Countries Country codes alpha 3 ISO639-3 codes Degree of endangerment  \\\n",
       "0        Italy                   ITA            nap             Vulnerable   \n",
       "1        Italy                   ITA            scn             Vulnerable   \n",
       "13       Italy                   ITA            pms  Definitely endangered   \n",
       "36       Italy                   ITA            sro  Definitely endangered   \n",
       "53       Italy                   ITA            fur  Definitely endangered   \n",
       "80       Italy                   ITA            src  Definitely endangered   \n",
       "157      Italy                   ITA            sdc  Definitely endangered   \n",
       "170      Italy                   ITA            sdn  Definitely endangered   \n",
       "197      Italy                   ITA            aae  Definitely endangered   \n",
       "212      Italy                   ITA            lmo  Definitely endangered   \n",
       "320      Italy                   ITA            lld  Definitely endangered   \n",
       "391      Italy                   ITA            ell    Severely endangered   \n",
       "510      Italy                   ITA            cat  Definitely endangered   \n",
       "729      Italy                   ITA  bos, hrv, srp    Severely endangered   \n",
       "964      Italy                   ITA            ell    Severely endangered   \n",
       "1198     Italy                   ITA            mhn  Definitely endangered   \n",
       "1205     Italy                   ITA            slv  Definitely endangered   \n",
       "1315     Italy                   ITA            frp  Definitely endangered   \n",
       "1455     Italy                   ITA            cim  Definitely endangered   \n",
       "1506     Italy                   ITA            NaN    Severely endangered   \n",
       "1663     Italy                   ITA  gsw, swg, wae    Severely endangered   \n",
       "\n",
       "                                        Alternate names Name in the language  \\\n",
       "0     Neapolitan; Neapolitan-Calabrese; неаполитанск...                  NaN   \n",
       "1                                                   NaN                  NaN   \n",
       "13                                                  NaN                  NaN   \n",
       "36                                Campidanese Sardinian                  NaN   \n",
       "53                                                  NaN                  NaN   \n",
       "80             Logudorese Sardinian; Logudorese-Nuorese                  NaN   \n",
       "157                                 Sassarese Sardinian                  NaN   \n",
       "170                                 Gallurese Sardinian                  NaN   \n",
       "197                                  Arbëreshë Albanian             arbrisht   \n",
       "212                                                 NaN                  NaN   \n",
       "320                                                 NaN                  NaN   \n",
       "391                                                 NaN                  NaN   \n",
       "510                                                 NaN                  NaN   \n",
       "729                                                 NaN                  NaN   \n",
       "964                                                 NaN                  NaN   \n",
       "1198                                                NaN                  NaN   \n",
       "1205  Resian Slovene (en), resiano (it), Rezijanski ...                  NaN   \n",
       "1315                                                NaN                  NaN   \n",
       "1455                                             Cimbro                  NaN   \n",
       "1506                                                NaN                  NaN   \n",
       "1663                                                NaN                  NaN   \n",
       "\n",
       "      Number of speakers                                            Sources  \\\n",
       "0              7500000.0                                                NaN   \n",
       "1              5000000.0                                                NaN   \n",
       "13             2000000.0                                                NaN   \n",
       "36              900000.0                                                NaN   \n",
       "53              600000.0                                                NaN   \n",
       "80              400000.0                                                NaN   \n",
       "157             120000.0                                                NaN   \n",
       "170             100000.0                                                NaN   \n",
       "197              80000.0  Walter Breu: Italoalbanisch. — Lexikon der Spr...   \n",
       "212              65000.0                                                NaN   \n",
       "320              30000.0                                                NaN   \n",
       "391              20000.0                                                NaN   \n",
       "510              10000.0  Enquesta d’usos lingüístics a l’Alguer 2004 av...   \n",
       "729               5000.0  Walter Breu: Moliseslawisch. — Lexikon der Spr...   \n",
       "964               2000.0                                                NaN   \n",
       "1198              1000.0  Anthony R. Rowley: „Mocheno e Cimbro“: Von Dia...   \n",
       "1205              1000.0                                                NaN   \n",
       "1315               600.0  Naomi Nagy: Writing a sociolinguistics grammar...   \n",
       "1455               400.0  Anthony R. Rowley: „Mocheno e Cimbro“: Von Dia...   \n",
       "1506               340.0                                                NaN   \n",
       "1663               200.0                                                NaN   \n",
       "\n",
       "      Latitude  Longitude                        Description of the location  \n",
       "0      40.9798    15.2490  Campania, Lucania (Basilicata), Abruzzi (Abruz...  \n",
       "1      37.4399    14.5019  Sicily (Sicilia), southern and central Calabri...  \n",
       "13     45.2013     7.8662  Piedmont Region except the Novara Province, th...  \n",
       "36     39.2991     8.9868                                  southern Sardinia  \n",
       "53     46.1037    13.1396  the Autonomous Region Friuli-Venezia Giulia ex...  \n",
       "80     40.1116     9.1845                                   central Sardinia  \n",
       "157    40.6139     8.6132  northwestern Sardinia; an outlying dialect of ...  \n",
       "170    40.8802     9.4482  northeastern Sardinia; an outlying dialect of ...  \n",
       "197    40.9321    14.8645  (i) Adriatic zone: Montecilfone, Campomarino, ...  \n",
       "212    38.0167    14.5994  Nicosia, Sperlinga, Piazza Armerina, Valguarne...  \n",
       "320    46.5531    11.8597  several towns and villages in the Dolomites, i...  \n",
       "391    40.1578    18.2208  the Salento peninsula in Lecce Province in sou...  \n",
       "510    40.5638     8.3276  the town of Alghero in northwestern Sardinia; ...  \n",
       "729    41.8787    14.7065  the villages of Montemitro (Mundimitar), San F...  \n",
       "964    37.9961    15.9329  a few villages near Reggio di Calabria in sout...  \n",
       "1198   46.1194    11.3258  Palù (Palai), Fierozzo (Florutz) and Frassilon...  \n",
       "1205   46.3734    13.3058  Resia in the northeastern part of Udine Provin...  \n",
       "1315   41.3265    15.1721  Faeto and Celle San Vito in Foggia Province in...  \n",
       "1455   45.8670    11.4268  vigorously spoken in Luserna (Lusern) in Trent...  \n",
       "1506   39.4658    15.9933  Guardia Piedmontese in Calabria; an outlying d...  \n",
       "1663   45.6913     7.8682  the village of Issime (Eischeme) in the upper ...  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.Countries == 'Italy']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## multiple value from particular column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Countries</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>Number of speakers</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1022</td>\n",
       "      <td>South Italian</td>\n",
       "      <td>italien du sud</td>\n",
       "      <td>napolitano-calabrés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>nap</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Neapolitan; Neapolitan-Calabrese; неаполитанск...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.9798</td>\n",
       "      <td>15.2490</td>\n",
       "      <td>Campania, Lucania (Basilicata), Abruzzi (Abruz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1023</td>\n",
       "      <td>Sicilian</td>\n",
       "      <td>sicilien</td>\n",
       "      <td>siciliano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>scn</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.4399</td>\n",
       "      <td>14.5019</td>\n",
       "      <td>Sicily (Sicilia), southern and central Calabri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>399</td>\n",
       "      <td>Piedmontese</td>\n",
       "      <td>piémontais</td>\n",
       "      <td>piamontés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>pms</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.2013</td>\n",
       "      <td>7.8662</td>\n",
       "      <td>Piedmont Region except the Novara Province, th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>337</td>\n",
       "      <td>Campidanese</td>\n",
       "      <td>campidanien</td>\n",
       "      <td>sardo campidanés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>sro</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Campidanese Sardinian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>900000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.2991</td>\n",
       "      <td>8.9868</td>\n",
       "      <td>southern Sardinia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>353</td>\n",
       "      <td>Friulian</td>\n",
       "      <td>frioulan</td>\n",
       "      <td>friulano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>fur</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>600000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.1037</td>\n",
       "      <td>13.1396</td>\n",
       "      <td>the Autonomous Region Friuli-Venezia Giulia ex...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2701</th>\n",
       "      <td>2009</td>\n",
       "      <td>Tucano (Colombia)</td>\n",
       "      <td>tucano (Colombie)</td>\n",
       "      <td>tucano (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>tuo</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Tukáno</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.6921</td>\n",
       "      <td>-69.8291</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2704</th>\n",
       "      <td>2013</td>\n",
       "      <td>Tuyuca (Colombia)</td>\n",
       "      <td>tuyuca (Colombie)</td>\n",
       "      <td>tuyuca (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>tue</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Tuyúka</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.3515</td>\n",
       "      <td>-70.2026</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2710</th>\n",
       "      <td>2014</td>\n",
       "      <td>Wanano / Kotiria (Colombia)</td>\n",
       "      <td>wanano / kotirya (Colombie)</td>\n",
       "      <td>guanano / kótedia (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>gvc</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Guanano, Kotiria is autodenomination in Brazil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0106</td>\n",
       "      <td>-69.6423</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718</th>\n",
       "      <td>2018</td>\n",
       "      <td>Yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>ycn</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.2633</td>\n",
       "      <td>-70.6640</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2719</th>\n",
       "      <td>2015</td>\n",
       "      <td>Yurutí (Colombia)</td>\n",
       "      <td>yurutí (Colombie)</td>\n",
       "      <td>yurutí (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>yui</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.1370</td>\n",
       "      <td>-70.2136</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>78 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID              Name in English               Name in French  \\\n",
       "0     1022                South Italian               italien du sud   \n",
       "1     1023                     Sicilian                     sicilien   \n",
       "13     399                  Piedmontese                   piémontais   \n",
       "36     337                  Campidanese                  campidanien   \n",
       "53     353                     Friulian                     frioulan   \n",
       "...    ...                          ...                          ...   \n",
       "2701  2009            Tucano (Colombia)            tucano (Colombie)   \n",
       "2704  2013            Tuyuca (Colombia)            tuyuca (Colombie)   \n",
       "2710  2014  Wanano / Kotiria (Colombia)  wanano / kotirya (Colombie)   \n",
       "2718  2018                       Yucuna                       yucuna   \n",
       "2719  2015            Yurutí (Colombia)            yurutí (Colombie)   \n",
       "\n",
       "                   Name in Spanish Countries Country codes alpha 3  \\\n",
       "0              napolitano-calabrés     Italy                   ITA   \n",
       "1                        siciliano     Italy                   ITA   \n",
       "13                       piamontés     Italy                   ITA   \n",
       "36                sardo campidanés     Italy                   ITA   \n",
       "53                        friulano     Italy                   ITA   \n",
       "...                            ...       ...                   ...   \n",
       "2701             tucano (Colombia)  Colombia                   COL   \n",
       "2704             tuyuca (Colombia)  Colombia                   COL   \n",
       "2710  guanano / kótedia (Colombia)  Colombia                   COL   \n",
       "2718                        yucuna  Colombia                   COL   \n",
       "2719             yurutí (Colombia)  Colombia                   COL   \n",
       "\n",
       "     ISO639-3 codes Degree of endangerment  \\\n",
       "0               nap             Vulnerable   \n",
       "1               scn             Vulnerable   \n",
       "13              pms  Definitely endangered   \n",
       "36              sro  Definitely endangered   \n",
       "53              fur  Definitely endangered   \n",
       "...             ...                    ...   \n",
       "2701            tuo             Vulnerable   \n",
       "2704            tue  Definitely endangered   \n",
       "2710            gvc  Definitely endangered   \n",
       "2718            ycn  Definitely endangered   \n",
       "2719            yui  Definitely endangered   \n",
       "\n",
       "                                        Alternate names Name in the language  \\\n",
       "0     Neapolitan; Neapolitan-Calabrese; неаполитанск...                  NaN   \n",
       "1                                                   NaN                  NaN   \n",
       "13                                                  NaN                  NaN   \n",
       "36                                Campidanese Sardinian                  NaN   \n",
       "53                                                  NaN                  NaN   \n",
       "...                                                 ...                  ...   \n",
       "2701                                             Tukáno                  NaN   \n",
       "2704                                             Tuyúka                  NaN   \n",
       "2710     Guanano, Kotiria is autodenomination in Brazil                  NaN   \n",
       "2718                                                NaN                  NaN   \n",
       "2719                                                NaN                  NaN   \n",
       "\n",
       "      Number of speakers Sources  Latitude  Longitude  \\\n",
       "0              7500000.0     NaN   40.9798    15.2490   \n",
       "1              5000000.0     NaN   37.4399    14.5019   \n",
       "13             2000000.0     NaN   45.2013     7.8662   \n",
       "36              900000.0     NaN   39.2991     8.9868   \n",
       "53              600000.0     NaN   46.1037    13.1396   \n",
       "...                  ...     ...       ...        ...   \n",
       "2701                 NaN     NaN    0.6921   -69.8291   \n",
       "2704                 NaN     NaN    0.3515   -70.2026   \n",
       "2710                 NaN     NaN    1.0106   -69.6423   \n",
       "2718                 NaN     NaN   -1.2633   -70.6640   \n",
       "2719                 NaN     NaN    1.1370   -70.2136   \n",
       "\n",
       "                            Description of the location  \n",
       "0     Campania, Lucania (Basilicata), Abruzzi (Abruz...  \n",
       "1     Sicily (Sicilia), southern and central Calabri...  \n",
       "13    Piedmont Region except the Novara Province, th...  \n",
       "36                                    southern Sardinia  \n",
       "53    the Autonomous Region Friuli-Venezia Giulia ex...  \n",
       "...                                                 ...  \n",
       "2701                                                NaN  \n",
       "2704                                                NaN  \n",
       "2710                                                NaN  \n",
       "2718                                                NaN  \n",
       "2719                                                NaN  \n",
       "\n",
       "[78 rows x 15 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.loc[data['Countries'].isin(['Italy','Colombia'])]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## in table we want to do combine selection of two column name \n",
    "## like: to display the countries where there are less than 100 speaker."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Countries</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>no_of_speaker</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1022</td>\n",
       "      <td>South Italian</td>\n",
       "      <td>italien du sud</td>\n",
       "      <td>napolitano-calabrés</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>nap</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Neapolitan; Neapolitan-Calabrese; неаполитанск...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.9798</td>\n",
       "      <td>15.2490</td>\n",
       "      <td>Campania, Lucania (Basilicata), Abruzzi (Abruz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1023</td>\n",
       "      <td>Sicilian</td>\n",
       "      <td>sicilien</td>\n",
       "      <td>siciliano</td>\n",
       "      <td>Italy</td>\n",
       "      <td>ITA</td>\n",
       "      <td>scn</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.4399</td>\n",
       "      <td>14.5019</td>\n",
       "      <td>Sicily (Sicilia), southern and central Calabri...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>383</td>\n",
       "      <td>Low Saxon</td>\n",
       "      <td>bas-saxon</td>\n",
       "      <td>bajo sajón</td>\n",
       "      <td>Germany, Denmark, Netherlands, Poland, Russian...</td>\n",
       "      <td>DEU, DNK, NLD, POL, RUS</td>\n",
       "      <td>act, drt, frs, gos, nds, sdz, stl, twd, vel, wep</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>Low German, Niedersächsisch, Nedersaksisch, Ni...</td>\n",
       "      <td>Neddersassisch</td>\n",
       "      <td>4800000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.4029</td>\n",
       "      <td>10.3601</td>\n",
       "      <td>northern Germany, the north-eastern part of th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>335</td>\n",
       "      <td>Belarusian</td>\n",
       "      <td>biélorusse</td>\n",
       "      <td>bielorruso</td>\n",
       "      <td>Belarus, Latvia, Lithuania, Poland, Russian Fe...</td>\n",
       "      <td>BRB, LVA, LTU, POL, RUS, UKR</td>\n",
       "      <td>bel</td>\n",
       "      <td>Vulnerable</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4000000.0</td>\n",
       "      <td>Hienadź Cychun: Weißrussisch. — Lexikon der Sp...</td>\n",
       "      <td>53.9560</td>\n",
       "      <td>27.5756</td>\n",
       "      <td>Belarus except the Polesian-speaking south-wes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>382</td>\n",
       "      <td>Lombard</td>\n",
       "      <td>lombard</td>\n",
       "      <td>lombardo</td>\n",
       "      <td>Italy, Switzerland</td>\n",
       "      <td>ITA, CHE</td>\n",
       "      <td>lmo</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3500000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.7215</td>\n",
       "      <td>9.3273</td>\n",
       "      <td>the region of Lombardy (except the southernmos...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2717</th>\n",
       "      <td>1972</td>\n",
       "      <td>Yonaguni</td>\n",
       "      <td>yonaguni</td>\n",
       "      <td>yonaguni</td>\n",
       "      <td>Japan</td>\n",
       "      <td>JPN</td>\n",
       "      <td>yoi</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yukio Uemura: The Ryukyuan language. Endangere...</td>\n",
       "      <td>24.4580</td>\n",
       "      <td>122.9802</td>\n",
       "      <td>Yonaguni Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718</th>\n",
       "      <td>2018</td>\n",
       "      <td>Yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>ycn</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.2633</td>\n",
       "      <td>-70.6640</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2719</th>\n",
       "      <td>2015</td>\n",
       "      <td>Yurutí (Colombia)</td>\n",
       "      <td>yurutí (Colombie)</td>\n",
       "      <td>yurutí (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>yui</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.1370</td>\n",
       "      <td>-70.2136</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2720</th>\n",
       "      <td>2716</td>\n",
       "      <td>Zangskari</td>\n",
       "      <td>zangskari</td>\n",
       "      <td>zangskari</td>\n",
       "      <td>India, Pakistan</td>\n",
       "      <td>IND, PAK</td>\n",
       "      <td>zau</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Zangs-dkar, Z’angkar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.0833</td>\n",
       "      <td>76.8500</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2721</th>\n",
       "      <td>2177</td>\n",
       "      <td>Zidgali</td>\n",
       "      <td>zidgali</td>\n",
       "      <td>zidgali</td>\n",
       "      <td>Oman</td>\n",
       "      <td>OMN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>Zidjali, Zadjali</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No authoritative source found yet; information...</td>\n",
       "      <td>23.4027</td>\n",
       "      <td>58.0957</td>\n",
       "      <td>Capital area of Muscat</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2722 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID    Name in English     Name in French      Name in Spanish  \\\n",
       "0     1022      South Italian     italien du sud  napolitano-calabrés   \n",
       "1     1023           Sicilian           sicilien            siciliano   \n",
       "2      383          Low Saxon          bas-saxon           bajo sajón   \n",
       "3      335         Belarusian         biélorusse           bielorruso   \n",
       "4      382            Lombard            lombard             lombardo   \n",
       "...    ...                ...                ...                  ...   \n",
       "2717  1972           Yonaguni           yonaguni             yonaguni   \n",
       "2718  2018             Yucuna             yucuna               yucuna   \n",
       "2719  2015  Yurutí (Colombia)  yurutí (Colombie)    yurutí (Colombia)   \n",
       "2720  2716          Zangskari          zangskari            zangskari   \n",
       "2721  2177            Zidgali            zidgali              zidgali   \n",
       "\n",
       "                                              Countries  \\\n",
       "0                                                 Italy   \n",
       "1                                                 Italy   \n",
       "2     Germany, Denmark, Netherlands, Poland, Russian...   \n",
       "3     Belarus, Latvia, Lithuania, Poland, Russian Fe...   \n",
       "4                                    Italy, Switzerland   \n",
       "...                                                 ...   \n",
       "2717                                              Japan   \n",
       "2718                                           Colombia   \n",
       "2719                                           Colombia   \n",
       "2720                                    India, Pakistan   \n",
       "2721                                               Oman   \n",
       "\n",
       "             Country codes alpha 3  \\\n",
       "0                              ITA   \n",
       "1                              ITA   \n",
       "2          DEU, DNK, NLD, POL, RUS   \n",
       "3     BRB, LVA, LTU, POL, RUS, UKR   \n",
       "4                         ITA, CHE   \n",
       "...                            ...   \n",
       "2717                           JPN   \n",
       "2718                           COL   \n",
       "2719                           COL   \n",
       "2720                      IND, PAK   \n",
       "2721                           OMN   \n",
       "\n",
       "                                        ISO639-3 codes Degree of endangerment  \\\n",
       "0                                                  nap             Vulnerable   \n",
       "1                                                  scn             Vulnerable   \n",
       "2     act, drt, frs, gos, nds, sdz, stl, twd, vel, wep             Vulnerable   \n",
       "3                                                  bel             Vulnerable   \n",
       "4                                                  lmo  Definitely endangered   \n",
       "...                                                ...                    ...   \n",
       "2717                                               yoi    Severely endangered   \n",
       "2718                                               ycn  Definitely endangered   \n",
       "2719                                               yui  Definitely endangered   \n",
       "2720                                               zau  Definitely endangered   \n",
       "2721                                               NaN  Critically endangered   \n",
       "\n",
       "                                        Alternate names Name in the language  \\\n",
       "0     Neapolitan; Neapolitan-Calabrese; неаполитанск...                  NaN   \n",
       "1                                                   NaN                  NaN   \n",
       "2     Low German, Niedersächsisch, Nedersaksisch, Ni...       Neddersassisch   \n",
       "3                                                   NaN                  NaN   \n",
       "4                                                   NaN                  NaN   \n",
       "...                                                 ...                  ...   \n",
       "2717                                                NaN                  NaN   \n",
       "2718                                                NaN                  NaN   \n",
       "2719                                                NaN                  NaN   \n",
       "2720                               Zangs-dkar, Z’angkar                  NaN   \n",
       "2721                                   Zidjali, Zadjali                  NaN   \n",
       "\n",
       "      no_of_speaker                                            Sources  \\\n",
       "0         7500000.0                                                NaN   \n",
       "1         5000000.0                                                NaN   \n",
       "2         4800000.0                                                NaN   \n",
       "3         4000000.0  Hienadź Cychun: Weißrussisch. — Lexikon der Sp...   \n",
       "4         3500000.0                                                NaN   \n",
       "...             ...                                                ...   \n",
       "2717            NaN  Yukio Uemura: The Ryukyuan language. Endangere...   \n",
       "2718            NaN                                                NaN   \n",
       "2719            NaN                                                NaN   \n",
       "2720            NaN                                                NaN   \n",
       "2721            NaN  No authoritative source found yet; information...   \n",
       "\n",
       "      Latitude  Longitude                        Description of the location  \n",
       "0      40.9798    15.2490  Campania, Lucania (Basilicata), Abruzzi (Abruz...  \n",
       "1      37.4399    14.5019  Sicily (Sicilia), southern and central Calabri...  \n",
       "2      53.4029    10.3601  northern Germany, the north-eastern part of th...  \n",
       "3      53.9560    27.5756  Belarus except the Polesian-speaking south-wes...  \n",
       "4      45.7215     9.3273  the region of Lombardy (except the southernmos...  \n",
       "...        ...        ...                                                ...  \n",
       "2717   24.4580   122.9802                                    Yonaguni Island  \n",
       "2718   -1.2633   -70.6640                                                NaN  \n",
       "2719    1.1370   -70.2136                                                NaN  \n",
       "2720   34.0833    76.8500                                                NaN  \n",
       "2721   23.4027    58.0957                             Capital area of Muscat  \n",
       "\n",
       "[2722 rows x 15 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.rename(columns={'Number of speakers' : 'no_of_speaker'}, inplace=True)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Countries</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>no_of_speaker</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1912</th>\n",
       "      <td>2455</td>\n",
       "      <td>Onge</td>\n",
       "      <td>onge</td>\n",
       "      <td>önge</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>oon</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>Ong</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.6390</td>\n",
       "      <td>92.4938</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1922</th>\n",
       "      <td>1363</td>\n",
       "      <td>Sentilese</td>\n",
       "      <td>sentinelese</td>\n",
       "      <td>sentinel</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>std</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.5446</td>\n",
       "      <td>92.2576</td>\n",
       "      <td>Andaman Islands, North Sentinel Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1957</th>\n",
       "      <td>1364</td>\n",
       "      <td>Jarawa</td>\n",
       "      <td>jarawa</td>\n",
       "      <td>jarawa</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>ang</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.6028</td>\n",
       "      <td>92.7520</td>\n",
       "      <td>South Andaman Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2172</th>\n",
       "      <td>2722</td>\n",
       "      <td>Great andamanese</td>\n",
       "      <td>grand andamanais</td>\n",
       "      <td>andamanés</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>akj</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>Aka-Jeru; Jeru</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Prof. Anvita Abbi, Bidisha Som, and Aloka Das ...</td>\n",
       "      <td>12.2326</td>\n",
       "      <td>92.9031</td>\n",
       "      <td>Middle and North Adaman</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2284</th>\n",
       "      <td>429</td>\n",
       "      <td>Ahom</td>\n",
       "      <td>ahom</td>\n",
       "      <td>ahom</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>aho</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.5393</td>\n",
       "      <td>92.5378</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2291</th>\n",
       "      <td>513</td>\n",
       "      <td>Andro</td>\n",
       "      <td>andro</td>\n",
       "      <td>andro</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>Phayeng</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.8415</td>\n",
       "      <td>94.0539</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2323</th>\n",
       "      <td>519</td>\n",
       "      <td>Chairel</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>Chakpa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.9760</td>\n",
       "      <td>94.2407</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2477</th>\n",
       "      <td>443</td>\n",
       "      <td>Rangkas</td>\n",
       "      <td>rangkas</td>\n",
       "      <td>rangkas</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>rgk</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>van Driem 2007</td>\n",
       "      <td>30.0358</td>\n",
       "      <td>80.1342</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2481</th>\n",
       "      <td>558</td>\n",
       "      <td>Sengmai</td>\n",
       "      <td>sengmai</td>\n",
       "      <td>sengmai</td>\n",
       "      <td>India</td>\n",
       "      <td>IND</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>Sekmai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.6445</td>\n",
       "      <td>94.0567</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID   Name in English    Name in French Name in Spanish Countries  \\\n",
       "1912  2455              Onge              onge            önge     India   \n",
       "1922  1363         Sentilese       sentinelese        sentinel     India   \n",
       "1957  1364            Jarawa            jarawa          jarawa     India   \n",
       "2172  2722  Great andamanese  grand andamanais       andamanés     India   \n",
       "2284   429              Ahom              ahom            ahom     India   \n",
       "2291   513             Andro             andro           andro     India   \n",
       "2323   519           Chairel               NaN             NaN     India   \n",
       "2477   443           Rangkas           rangkas         rangkas     India   \n",
       "2481   558           Sengmai           sengmai         sengmai     India   \n",
       "\n",
       "     Country codes alpha 3 ISO639-3 codes Degree of endangerment  \\\n",
       "1912                   IND            oon  Critically endangered   \n",
       "1922                   IND            std  Critically endangered   \n",
       "1957                   IND            ang  Critically endangered   \n",
       "2172                   IND            akj  Critically endangered   \n",
       "2284                   IND            aho                Extinct   \n",
       "2291                   IND            NaN                Extinct   \n",
       "2323                   IND            NaN                Extinct   \n",
       "2477                   IND            rgk                Extinct   \n",
       "2481                   IND            NaN                Extinct   \n",
       "\n",
       "     Alternate names Name in the language  no_of_speaker  \\\n",
       "1912             Ong                  NaN           50.0   \n",
       "1922             NaN                  NaN           50.0   \n",
       "1957             NaN                  NaN           31.0   \n",
       "2172  Aka-Jeru; Jeru                  NaN            5.0   \n",
       "2284             NaN                  NaN            0.0   \n",
       "2291         Phayeng                  NaN            0.0   \n",
       "2323          Chakpa                  NaN            0.0   \n",
       "2477             NaN                  NaN            0.0   \n",
       "2481          Sekmai                  NaN            0.0   \n",
       "\n",
       "                                                Sources  Latitude  Longitude  \\\n",
       "1912                                                NaN   10.6390    92.4938   \n",
       "1922                                                NaN   11.5446    92.2576   \n",
       "1957                                                NaN   12.6028    92.7520   \n",
       "2172  Prof. Anvita Abbi, Bidisha Som, and Aloka Das ...   12.2326    92.9031   \n",
       "2284                                                NaN   26.5393    92.5378   \n",
       "2291                                                NaN   24.8415    94.0539   \n",
       "2323                                                NaN   24.9760    94.2407   \n",
       "2477                                     van Driem 2007   30.0358    80.1342   \n",
       "2481                                                NaN   24.6445    94.0567   \n",
       "\n",
       "                 Description of the location  \n",
       "1912                                     NaN  \n",
       "1922  Andaman Islands, North Sentinel Island  \n",
       "1957                    South Andaman Island  \n",
       "2172                 Middle and North Adaman  \n",
       "2284                                     NaN  \n",
       "2291                                     NaN  \n",
       "2323                                     NaN  \n",
       "2477                                     NaN  \n",
       "2481                                     NaN  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[(data.Countries == 'India') & (data.no_of_speaker < 100)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##  GroupBy-- sort no_of_speaker"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Countries</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>no_of_speaker</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2538</th>\n",
       "      <td>130</td>\n",
       "      <td>ǁXegwi</td>\n",
       "      <td>ǁxegwi</td>\n",
       "      <td>ǁxegwi</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>ZAF</td>\n",
       "      <td>xeg</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Anthony Traill, 2002' The Khoesan languages', ...</td>\n",
       "      <td>-25.3500</td>\n",
       "      <td>30.9900</td>\n",
       "      <td>Lake Chrissie, Eastern Transvaal.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2374</th>\n",
       "      <td>477</td>\n",
       "      <td>Kamas</td>\n",
       "      <td>kamasse</td>\n",
       "      <td>kamas</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>RUS</td>\n",
       "      <td>xas, zkb</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>Koibal (dialect); a suffixed variant such as “...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Péter Simoncsics: Kamassian. — The Uralic lang...</td>\n",
       "      <td>57.9964</td>\n",
       "      <td>92.8784</td>\n",
       "      <td>formerly spoken in the eastern part of the Min...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2373</th>\n",
       "      <td>696</td>\n",
       "      <td>Judeo-Berber (Morocco)</td>\n",
       "      <td>judéo-berbère (Maroc)</td>\n",
       "      <td>judeo-bereber (Marruecos)</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>MAR</td>\n",
       "      <td>jbe</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>Judeo-Tamazight, Tamazight des juifs marocains</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Haim Zafrani, Paulette-Galland Pernet, Daniel ...</td>\n",
       "      <td>30.8220</td>\n",
       "      <td>-6.8005</td>\n",
       "      <td>Several areas in the Higher and the Middle Atl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2372</th>\n",
       "      <td>1925</td>\n",
       "      <td>Jorá</td>\n",
       "      <td>jorá</td>\n",
       "      <td>jorá</td>\n",
       "      <td>Bolivia (Plurinational State of)</td>\n",
       "      <td>BOL</td>\n",
       "      <td>jor</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-14.0246</td>\n",
       "      <td>-63.3581</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2371</th>\n",
       "      <td>857</td>\n",
       "      <td>Island Chumash</td>\n",
       "      <td>chumash</td>\n",
       "      <td>chumasho</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>USA</td>\n",
       "      <td>crz</td>\n",
       "      <td>Extinct</td>\n",
       "      <td>Cruzeño</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Victor Golla, Ives Goddard, Lyle Campbell, Mar...</td>\n",
       "      <td>34.3821</td>\n",
       "      <td>-119.4574</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2717</th>\n",
       "      <td>1972</td>\n",
       "      <td>Yonaguni</td>\n",
       "      <td>yonaguni</td>\n",
       "      <td>yonaguni</td>\n",
       "      <td>Japan</td>\n",
       "      <td>JPN</td>\n",
       "      <td>yoi</td>\n",
       "      <td>Severely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yukio Uemura: The Ryukyuan language. Endangere...</td>\n",
       "      <td>24.4580</td>\n",
       "      <td>122.9802</td>\n",
       "      <td>Yonaguni Island</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2718</th>\n",
       "      <td>2018</td>\n",
       "      <td>Yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>yucuna</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>ycn</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1.2633</td>\n",
       "      <td>-70.6640</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2719</th>\n",
       "      <td>2015</td>\n",
       "      <td>Yurutí (Colombia)</td>\n",
       "      <td>yurutí (Colombie)</td>\n",
       "      <td>yurutí (Colombia)</td>\n",
       "      <td>Colombia</td>\n",
       "      <td>COL</td>\n",
       "      <td>yui</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.1370</td>\n",
       "      <td>-70.2136</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2720</th>\n",
       "      <td>2716</td>\n",
       "      <td>Zangskari</td>\n",
       "      <td>zangskari</td>\n",
       "      <td>zangskari</td>\n",
       "      <td>India, Pakistan</td>\n",
       "      <td>IND, PAK</td>\n",
       "      <td>zau</td>\n",
       "      <td>Definitely endangered</td>\n",
       "      <td>Zangs-dkar, Z’angkar</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.0833</td>\n",
       "      <td>76.8500</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2721</th>\n",
       "      <td>2177</td>\n",
       "      <td>Zidgali</td>\n",
       "      <td>zidgali</td>\n",
       "      <td>zidgali</td>\n",
       "      <td>Oman</td>\n",
       "      <td>OMN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Critically endangered</td>\n",
       "      <td>Zidjali, Zadjali</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No authoritative source found yet; information...</td>\n",
       "      <td>23.4027</td>\n",
       "      <td>58.0957</td>\n",
       "      <td>Capital area of Muscat</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2722 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ID         Name in English         Name in French  \\\n",
       "2538   130                  ǁXegwi                 ǁxegwi   \n",
       "2374   477                   Kamas                kamasse   \n",
       "2373   696  Judeo-Berber (Morocco)  judéo-berbère (Maroc)   \n",
       "2372  1925                    Jorá                   jorá   \n",
       "2371   857          Island Chumash                chumash   \n",
       "...    ...                     ...                    ...   \n",
       "2717  1972                Yonaguni               yonaguni   \n",
       "2718  2018                  Yucuna                 yucuna   \n",
       "2719  2015       Yurutí (Colombia)      yurutí (Colombie)   \n",
       "2720  2716               Zangskari              zangskari   \n",
       "2721  2177                 Zidgali                zidgali   \n",
       "\n",
       "                Name in Spanish                         Countries  \\\n",
       "2538                     ǁxegwi                      South Africa   \n",
       "2374                      kamas                Russian Federation   \n",
       "2373  judeo-bereber (Marruecos)                           Morocco   \n",
       "2372                       jorá  Bolivia (Plurinational State of)   \n",
       "2371                   chumasho          United States of America   \n",
       "...                         ...                               ...   \n",
       "2717                   yonaguni                             Japan   \n",
       "2718                     yucuna                          Colombia   \n",
       "2719          yurutí (Colombia)                          Colombia   \n",
       "2720                  zangskari                   India, Pakistan   \n",
       "2721                    zidgali                              Oman   \n",
       "\n",
       "     Country codes alpha 3 ISO639-3 codes Degree of endangerment  \\\n",
       "2538                   ZAF            xeg                Extinct   \n",
       "2374                   RUS       xas, zkb                Extinct   \n",
       "2373                   MAR            jbe                Extinct   \n",
       "2372                   BOL            jor  Critically endangered   \n",
       "2371                   USA            crz                Extinct   \n",
       "...                    ...            ...                    ...   \n",
       "2717                   JPN            yoi    Severely endangered   \n",
       "2718                   COL            ycn  Definitely endangered   \n",
       "2719                   COL            yui  Definitely endangered   \n",
       "2720              IND, PAK            zau  Definitely endangered   \n",
       "2721                   OMN            NaN  Critically endangered   \n",
       "\n",
       "                                        Alternate names Name in the language  \\\n",
       "2538                                                NaN                  NaN   \n",
       "2374  Koibal (dialect); a suffixed variant such as “...                  NaN   \n",
       "2373     Judeo-Tamazight, Tamazight des juifs marocains                  NaN   \n",
       "2372                                                NaN                  NaN   \n",
       "2371                                            Cruzeño                  NaN   \n",
       "...                                                 ...                  ...   \n",
       "2717                                                NaN                  NaN   \n",
       "2718                                                NaN                  NaN   \n",
       "2719                                                NaN                  NaN   \n",
       "2720                               Zangs-dkar, Z’angkar                  NaN   \n",
       "2721                                   Zidjali, Zadjali                  NaN   \n",
       "\n",
       "      no_of_speaker                                            Sources  \\\n",
       "2538            0.0  Anthony Traill, 2002' The Khoesan languages', ...   \n",
       "2374            0.0  Péter Simoncsics: Kamassian. — The Uralic lang...   \n",
       "2373            0.0  Haim Zafrani, Paulette-Galland Pernet, Daniel ...   \n",
       "2372            0.0                                                NaN   \n",
       "2371            0.0  Victor Golla, Ives Goddard, Lyle Campbell, Mar...   \n",
       "...             ...                                                ...   \n",
       "2717            NaN  Yukio Uemura: The Ryukyuan language. Endangere...   \n",
       "2718            NaN                                                NaN   \n",
       "2719            NaN                                                NaN   \n",
       "2720            NaN                                                NaN   \n",
       "2721            NaN  No authoritative source found yet; information...   \n",
       "\n",
       "      Latitude  Longitude                        Description of the location  \n",
       "2538  -25.3500    30.9900                 Lake Chrissie, Eastern Transvaal.   \n",
       "2374   57.9964    92.8784  formerly spoken in the eastern part of the Min...  \n",
       "2373   30.8220    -6.8005  Several areas in the Higher and the Middle Atl...  \n",
       "2372  -14.0246   -63.3581                                                NaN  \n",
       "2371   34.3821  -119.4574                                                NaN  \n",
       "...        ...        ...                                                ...  \n",
       "2717   24.4580   122.9802                                    Yonaguni Island  \n",
       "2718   -1.2633   -70.6640                                                NaN  \n",
       "2719    1.1370   -70.2136                                                NaN  \n",
       "2720   34.0833    76.8500                                                NaN  \n",
       "2721   23.4027    58.0957                             Capital area of Muscat  \n",
       "\n",
       "[2722 rows x 15 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sort_values('no_of_speaker',ascending=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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></th>\n",
       "      <th>ID</th>\n",
       "      <th>Name in English</th>\n",
       "      <th>Name in French</th>\n",
       "      <th>Name in Spanish</th>\n",
       "      <th>Country codes alpha 3</th>\n",
       "      <th>ISO639-3 codes</th>\n",
       "      <th>Degree of endangerment</th>\n",
       "      <th>Alternate names</th>\n",
       "      <th>Name in the language</th>\n",
       "      <th>Sources</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Description of the location</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Countries</th>\n",
       "      <th>no_of_speaker</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Afghanistan</th>\n",
       "      <th>100.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200.0</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000.0</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000.0</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6000.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Viet Nam</th>\n",
       "      <th>47000.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50000.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <th>1000.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Yemen</th>\n",
       "      <th>50000.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75000.0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1771 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              ID  Name in English  Name in French  \\\n",
       "Countries      no_of_speaker                                        \n",
       "Afghanistan    100.0           1                1               1   \n",
       "               200.0           2                2               2   \n",
       "               1000.0          2                2               2   \n",
       "               2000.0          5                5               5   \n",
       "               6000.0          1                1               1   \n",
       "...                           ..              ...             ...   \n",
       "Viet Nam       47000.0         1                1               1   \n",
       "               50000.0         1                1               1   \n",
       "Western Sahara 1000.0          1                1               1   \n",
       "Yemen          50000.0         1                1               1   \n",
       "               75000.0         1                1               1   \n",
       "\n",
       "                              Name in Spanish  Country codes alpha 3  \\\n",
       "Countries      no_of_speaker                                           \n",
       "Afghanistan    100.0                        1                      1   \n",
       "               200.0                        2                      2   \n",
       "               1000.0                       2                      2   \n",
       "               2000.0                       5                      5   \n",
       "               6000.0                       1                      1   \n",
       "...                                       ...                    ...   \n",
       "Viet Nam       47000.0                      1                      1   \n",
       "               50000.0                      1                      1   \n",
       "Western Sahara 1000.0                       1                      1   \n",
       "Yemen          50000.0                      1                      1   \n",
       "               75000.0                      1                      1   \n",
       "\n",
       "                              ISO639-3 codes  Degree of endangerment  \\\n",
       "Countries      no_of_speaker                                           \n",
       "Afghanistan    100.0                       1                       1   \n",
       "               200.0                       2                       2   \n",
       "               1000.0                      2                       2   \n",
       "               2000.0                      5                       5   \n",
       "               6000.0                      1                       1   \n",
       "...                                      ...                     ...   \n",
       "Viet Nam       47000.0                     1                       1   \n",
       "               50000.0                     1                       1   \n",
       "Western Sahara 1000.0                      1                       1   \n",
       "Yemen          50000.0                     1                       1   \n",
       "               75000.0                     0                       1   \n",
       "\n",
       "                              Alternate names  Name in the language  Sources  \\\n",
       "Countries      no_of_speaker                                                   \n",
       "Afghanistan    100.0                        1                     0        1   \n",
       "               200.0                        2                     0        2   \n",
       "               1000.0                       2                     0        2   \n",
       "               2000.0                       4                     0        5   \n",
       "               6000.0                       0                     0        1   \n",
       "...                                       ...                   ...      ...   \n",
       "Viet Nam       47000.0                      1                     0        0   \n",
       "               50000.0                      0                     0        0   \n",
       "Western Sahara 1000.0                       1                     0        1   \n",
       "Yemen          50000.0                      1                     0        1   \n",
       "               75000.0                      1                     0        1   \n",
       "\n",
       "                              Latitude  Longitude  Description of the location  \n",
       "Countries      no_of_speaker                                                    \n",
       "Afghanistan    100.0                 1          1                            1  \n",
       "               200.0                 2          2                            2  \n",
       "               1000.0                2          2                            2  \n",
       "               2000.0                5          5                            5  \n",
       "               6000.0                1          1                            1  \n",
       "...                                ...        ...                          ...  \n",
       "Viet Nam       47000.0               1          1                            0  \n",
       "               50000.0               1          1                            0  \n",
       "Western Sahara 1000.0                1          1                            1  \n",
       "Yemen          50000.0               1          1                            1  \n",
       "               75000.0               1          1                            1  \n",
       "\n",
       "[1771 rows x 13 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby([\"Countries\",\"no_of_speaker\"]).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}