Work-With-JSON-SQL.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "276c6f75-782b-4a5e-8b23-e8aa6eba8bc8",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Waris Hayyat\\AppData\\Local\\Temp\\ipykernel_9380\\573954172.py:2: DeprecationWarning: \n",
      "Pyarrow will become a required dependency of pandas in the next major release of pandas (pandas 3.0),\n",
      "(to allow more performant data types, such as the Arrow string type, and better interoperability with other libraries)\n",
      "but was not found to be installed on your system.\n",
      "If this would cause problems for you,\n",
      "please provide us feedback at https://github.com/pandas-dev/pandas/issues/54466\n",
      "        \n",
      "  import pandas as pd\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e4586f60-2356-42e5-986d-3cac83b27c4b",
   "metadata": {},
   "source": [
    "                                    Working with Json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "575891ea-4d29-4034-b695-73132a0e2189",
   "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>type</th>\n",
       "      <th>features</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'AC', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'AL', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'AP', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'AM', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'BA', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'CE', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'DF', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'ES', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'GO', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'MA', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'MT', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'MS', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'MG', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'PA', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'PB', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'PR', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'PE', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'PI', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'RJ', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'RN', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'RS', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'RO', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'RR', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'SC', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'SP', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'SE', 'properties': ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>FeatureCollection</td>\n",
       "      <td>{'type': 'Feature', 'id': 'TO', 'properties': ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 type                                           features\n",
       "0   FeatureCollection  {'type': 'Feature', 'id': 'AC', 'properties': ...\n",
       "1   FeatureCollection  {'type': 'Feature', 'id': 'AL', 'properties': ...\n",
       "2   FeatureCollection  {'type': 'Feature', 'id': 'AP', 'properties': ...\n",
       "3   FeatureCollection  {'type': 'Feature', 'id': 'AM', 'properties': ...\n",
       "4   FeatureCollection  {'type': 'Feature', 'id': 'BA', 'properties': ...\n",
       "5   FeatureCollection  {'type': 'Feature', 'id': 'CE', 'properties': ...\n",
       "6   FeatureCollection  {'type': 'Feature', 'id': 'DF', 'properties': ...\n",
       "7   FeatureCollection  {'type': 'Feature', 'id': 'ES', 'properties': ...\n",
       "8   FeatureCollection  {'type': 'Feature', 'id': 'GO', 'properties': ...\n",
       "9   FeatureCollection  {'type': 'Feature', 'id': 'MA', 'properties': ...\n",
       "10  FeatureCollection  {'type': 'Feature', 'id': 'MT', 'properties': ...\n",
       "11  FeatureCollection  {'type': 'Feature', 'id': 'MS', 'properties': ...\n",
       "12  FeatureCollection  {'type': 'Feature', 'id': 'MG', 'properties': ...\n",
       "13  FeatureCollection  {'type': 'Feature', 'id': 'PA', 'properties': ...\n",
       "14  FeatureCollection  {'type': 'Feature', 'id': 'PB', 'properties': ...\n",
       "15  FeatureCollection  {'type': 'Feature', 'id': 'PR', 'properties': ...\n",
       "16  FeatureCollection  {'type': 'Feature', 'id': 'PE', 'properties': ...\n",
       "17  FeatureCollection  {'type': 'Feature', 'id': 'PI', 'properties': ...\n",
       "18  FeatureCollection  {'type': 'Feature', 'id': 'RJ', 'properties': ...\n",
       "19  FeatureCollection  {'type': 'Feature', 'id': 'RN', 'properties': ...\n",
       "20  FeatureCollection  {'type': 'Feature', 'id': 'RS', 'properties': ...\n",
       "21  FeatureCollection  {'type': 'Feature', 'id': 'RO', 'properties': ...\n",
       "22  FeatureCollection  {'type': 'Feature', 'id': 'RR', 'properties': ...\n",
       "23  FeatureCollection  {'type': 'Feature', 'id': 'SC', 'properties': ...\n",
       "24  FeatureCollection  {'type': 'Feature', 'id': 'SP', 'properties': ...\n",
       "25  FeatureCollection  {'type': 'Feature', 'id': 'SE', 'properties': ...\n",
       "26  FeatureCollection  {'type': 'Feature', 'id': 'TO', 'properties': ..."
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#how to import json file into datafrmae\n",
    "data=pd.read_json(\"brazil_geo.json\")\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "77d3b43d-d9e9-4966-a989-428a252d04e9",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Now working with sql first we make database on xamp then import a library on the notebook."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "5695c308-314b-44e9-815a-66fddb4dcad2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Collecting mysql.connector\n",
      "  Downloading mysql-connector-2.2.9.tar.gz (11.9 MB)\n",
      "     ---------------------------------------- 0.0/11.9 MB ? eta -:--:--\n",
      "     ---------------------------------------- 0.0/11.9 MB ? eta -:--:--\n",
      "     ---------------------------------------- 0.0/11.9 MB ? eta -:--:--\n",
      "     ---------------------------------------- 0.0/11.9 MB ? eta -:--:--\n",
      "     --------------------------------------- 0.0/11.9 MB 146.3 kB/s eta 0:01:21\n",
      "     --------------------------------------- 0.0/11.9 MB 164.3 kB/s eta 0:01:12\n",
      "     --------------------------------------- 0.1/11.9 MB 245.8 kB/s eta 0:00:48\n",
      "     --------------------------------------- 0.1/11.9 MB 345.9 kB/s eta 0:00:34\n",
      "      -------------------------------------- 0.2/11.9 MB 418.0 kB/s eta 0:00:28\n",
      "      -------------------------------------- 0.2/11.9 MB 573.4 kB/s eta 0:00:21\n",
      "      -------------------------------------- 0.3/11.9 MB 632.4 kB/s eta 0:00:19\n",
      "     - ------------------------------------- 0.4/11.9 MB 719.3 kB/s eta 0:00:16\n",
      "     - ------------------------------------- 0.4/11.9 MB 755.6 kB/s eta 0:00:16\n",
      "     -- ------------------------------------- 0.7/11.9 MB 1.2 MB/s eta 0:00:10\n",
      "     -- ------------------------------------- 0.8/11.9 MB 1.3 MB/s eta 0:00:09\n",
      "     ---- ----------------------------------- 1.2/11.9 MB 1.8 MB/s eta 0:00:06\n",
      "     ---- ----------------------------------- 1.5/11.9 MB 2.0 MB/s eta 0:00:06\n",
      "     ---- ----------------------------------- 1.5/11.9 MB 2.0 MB/s eta 0:00:06\n",
      "     ---- ----------------------------------- 1.5/11.9 MB 2.0 MB/s eta 0:00:06\n",
      "     ---- ----------------------------------- 1.5/11.9 MB 2.0 MB/s eta 0:00:06\n",
      "     ---- ----------------------------------- 1.5/11.9 MB 2.0 MB/s eta 0:00:06\n",
      "     ----- ---------------------------------- 1.6/11.9 MB 1.7 MB/s eta 0:00:07\n",
      "     ------ --------------------------------- 2.0/11.9 MB 2.0 MB/s eta 0:00:05\n",
      "     ------- -------------------------------- 2.1/11.9 MB 2.1 MB/s eta 0:00:05\n",
      "     ------- -------------------------------- 2.1/11.9 MB 2.1 MB/s eta 0:00:05\n",
      "     ------- -------------------------------- 2.1/11.9 MB 2.1 MB/s eta 0:00:05\n",
      "     ------- -------------------------------- 2.2/11.9 MB 1.9 MB/s eta 0:00:06\n",
      "     ------- -------------------------------- 2.2/11.9 MB 1.9 MB/s eta 0:00:06\n",
      "     ------- -------------------------------- 2.4/11.9 MB 1.9 MB/s eta 0:00:06\n",
      "     ---------- ----------------------------- 3.2/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     ---------- ----------------------------- 3.2/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     ----------- ---------------------------- 3.3/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     ----------- ---------------------------- 3.3/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     ----------- ---------------------------- 3.4/11.9 MB 2.3 MB/s eta 0:00:04\n",
      "     ----------- ---------------------------- 3.5/11.9 MB 2.3 MB/s eta 0:00:04\n",
      "     ------------ --------------------------- 3.6/11.9 MB 2.3 MB/s eta 0:00:04\n",
      "     ------------ --------------------------- 3.8/11.9 MB 2.3 MB/s eta 0:00:04\n",
      "     ------------- -------------------------- 4.1/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     -------------- ------------------------- 4.2/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     -------------- ------------------------- 4.3/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     -------------- ------------------------- 4.3/11.9 MB 2.4 MB/s eta 0:00:04\n",
      "     -------------- ------------------------- 4.3/11.9 MB 2.3 MB/s eta 0:00:04\n",
      "     --------------- ------------------------ 4.6/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ---------------- ----------------------- 4.8/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ---------------- ----------------------- 4.8/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ---------------- ----------------------- 4.8/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ----------------- ---------------------- 5.2/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ----------------- ---------------------- 5.2/11.9 MB 2.5 MB/s eta 0:00:03\n",
      "     ----------------- ---------------------- 5.2/11.9 MB 2.5 MB/s eta 0:00:03\n",
      "     ------------------ --------------------- 5.4/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ------------------ --------------------- 5.5/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ------------------ --------------------- 5.5/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ------------------- -------------------- 5.6/11.9 MB 2.4 MB/s eta 0:00:03\n",
      "     ------------------- -------------------- 5.7/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     ------------------- -------------------- 5.8/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     ------------------- -------------------- 5.9/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     ------------------- -------------------- 5.9/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     -------------------- ------------------- 6.0/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     -------------------- ------------------- 6.1/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     -------------------- ------------------- 6.1/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     -------------------- ------------------- 6.2/11.9 MB 2.3 MB/s eta 0:00:03\n",
      "     --------------------- ------------------ 6.3/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     --------------------- ------------------ 6.4/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     --------------------- ------------------ 6.5/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     --------------------- ------------------ 6.5/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ---------------------- ----------------- 6.6/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ---------------------- ----------------- 6.7/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ---------------------- ----------------- 6.8/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ----------------------- ---------------- 6.8/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ----------------------- ---------------- 6.9/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ----------------------- ---------------- 7.0/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ----------------------- ---------------- 7.1/11.9 MB 2.2 MB/s eta 0:00:03\n",
      "     ----------------------- ---------------- 7.1/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------ --------------- 7.2/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------ --------------- 7.2/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------ --------------- 7.3/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------ --------------- 7.4/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------ --------------- 7.4/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------- -------------- 7.5/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     ------------------------- -------------- 7.6/11.9 MB 2.1 MB/s eta 0:00:03\n",
      "     -------------------------- ------------- 7.7/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     -------------------------- ------------- 7.8/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     -------------------------- ------------- 8.0/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     -------------------------- ------------- 8.0/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     --------------------------- ------------ 8.1/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     --------------------------- ------------ 8.2/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     --------------------------- ------------ 8.2/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     --------------------------- ------------ 8.3/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     ---------------------------- ----------- 8.4/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     ---------------------------- ----------- 8.4/11.9 MB 2.1 MB/s eta 0:00:02\n",
      "     ---------------------------- ----------- 8.5/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ---------------------------- ----------- 8.6/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ----------------------------- ---------- 8.7/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ----------------------------- ---------- 8.7/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ----------------------------- ---------- 8.8/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ------------------------------ --------- 9.0/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ------------------------------ --------- 9.0/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ------------------------------ --------- 9.1/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ------------------------------- -------- 9.2/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ------------------------------- -------- 9.3/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     ------------------------------- -------- 9.4/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     -------------------------------- ------- 9.5/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     -------------------------------- ------- 9.6/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     -------------------------------- ------- 9.7/11.9 MB 2.0 MB/s eta 0:00:02\n",
      "     --------------------------------- ------ 9.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     --------------------------------- ------ 9.9/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     --------------------------------- ------ 10.0/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     --------------------------------- ------ 10.0/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     --------------------------------- ------ 10.0/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------- ----- 10.1/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------- ----- 10.3/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------- ----- 10.3/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ----------------------------------- ---- 10.4/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ----------------------------------- ---- 10.5/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ----------------------------------- ---- 10.6/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ------------------------------------ --- 10.7/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ------------------------------------ --- 10.8/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ------------------------------------ --- 10.9/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ------------------------------------- -- 11.0/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ------------------------------------- -- 11.0/11.9 MB 2.1 MB/s eta 0:00:01\n",
      "     ------------------------------------- -- 11.1/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ------------------------------------- -- 11.2/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     -------------------------------------- - 11.4/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     -------------------------------------- - 11.4/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     -------------------------------------- - 11.5/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.6/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------  11.8/11.9 MB 2.0 MB/s eta 0:00:01\n",
      "     ---------------------------------------- 11.9/11.9 MB 1.9 MB/s eta 0:00:00\n",
      "  Installing build dependencies: started\n",
      "  Installing build dependencies: finished with status 'done'\n",
      "  Getting requirements to build wheel: started\n",
      "  Getting requirements to build wheel: finished with status 'done'\n",
      "  Installing backend dependencies: started\n",
      "  Installing backend dependencies: finished with status 'done'\n",
      "  Preparing metadata (pyproject.toml): started\n",
      "  Preparing metadata (pyproject.toml): finished with status 'done'\n",
      "Building wheels for collected packages: mysql.connector\n",
      "  Building wheel for mysql.connector (pyproject.toml): started\n",
      "  Building wheel for mysql.connector (pyproject.toml): finished with status 'done'\n",
      "  Created wheel for mysql.connector: filename=mysql_connector-2.2.9-cp312-cp312-win_amd64.whl size=247958 sha256=e931dd9abe7242300b989c63ff63f4d1e8887df41315a5f265ea02926681e7c8\n",
      "  Stored in directory: c:\\users\\waris hayyat\\appdata\\local\\pip\\cache\\wheels\\03\\17\\fa\\d7604c72dd3dd6d3eb3d249abf36cc532c9a9b4354b8f1bc4f\n",
      "Successfully built mysql.connector\n",
      "Installing collected packages: mysql.connector\n",
      "Successfully installed mysql.connector-2.2.9\n"
     ]
    }
   ],
   "source": [
    "!pip install mysql.connector"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "81ea1247-d1f4-4496-9c2a-3d84ae09757d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import mysql.connector"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "dcfd2fee-43e8-428b-85c7-d09234433e46",
   "metadata": {},
   "outputs": [],
   "source": [
    "connection=mysql.connector.Connect(host=\"localhost\",user=\"root\",password=\"\",database=\"world\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "id": "f6e380de-81ad-4b87-a260-d0b25c01daba",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Waris Hayyat\\AppData\\Local\\Temp\\ipykernel_9380\\3110173952.py:1: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.\n",
      "  City=pd.read_sql_query(\"SELECT * FROM CITY where name like 'india' \",connection)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Name</th>\n",
       "      <th>CountryCode</th>\n",
       "      <th>District</th>\n",
       "      <th>Population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [ID, Name, CountryCode, District, Population]\n",
       "Index: []"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "City=pd.read_sql_query(\"SELECT * FROM CITY WHERE  \",connection)\n",
    "City"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "18fb16c6-0301-4c03-87da-964a48258c99",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Waris Hayyat\\AppData\\Local\\Temp\\ipykernel_9380\\3128894736.py:1: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.\n",
      "  Country=pd.read_sql_query(\"SELECT * FROM COUNTRY\",connection)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Code</th>\n",
       "      <th>Name</th>\n",
       "      <th>Continent</th>\n",
       "      <th>Region</th>\n",
       "      <th>SurfaceArea</th>\n",
       "      <th>IndepYear</th>\n",
       "      <th>Population</th>\n",
       "      <th>LifeExpectancy</th>\n",
       "      <th>GNP</th>\n",
       "      <th>GNPOld</th>\n",
       "      <th>LocalName</th>\n",
       "      <th>GovernmentForm</th>\n",
       "      <th>HeadOfState</th>\n",
       "      <th>Capital</th>\n",
       "      <th>Code2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ABW</td>\n",
       "      <td>Aruba</td>\n",
       "      <td>North America</td>\n",
       "      <td>Caribbean</td>\n",
       "      <td>193.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103000</td>\n",
       "      <td>78.4</td>\n",
       "      <td>828.0</td>\n",
       "      <td>793.0</td>\n",
       "      <td>Aruba</td>\n",
       "      <td>Nonmetropolitan Territory of The Netherlands</td>\n",
       "      <td>Beatrix</td>\n",
       "      <td>129.0</td>\n",
       "      <td>AW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AFG</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Southern and Central Asia</td>\n",
       "      <td>652090.0</td>\n",
       "      <td>1919.0</td>\n",
       "      <td>22720000</td>\n",
       "      <td>45.9</td>\n",
       "      <td>5976.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Afganistan/Afqanestan</td>\n",
       "      <td>Islamic Emirate</td>\n",
       "      <td>Mohammad Omar</td>\n",
       "      <td>1.0</td>\n",
       "      <td>AF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AGO</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Central Africa</td>\n",
       "      <td>1246700.0</td>\n",
       "      <td>1975.0</td>\n",
       "      <td>12878000</td>\n",
       "      <td>38.3</td>\n",
       "      <td>6648.0</td>\n",
       "      <td>7984.0</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Republic</td>\n",
       "      <td>José Eduardo dos Santos</td>\n",
       "      <td>56.0</td>\n",
       "      <td>AO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AIA</td>\n",
       "      <td>Anguilla</td>\n",
       "      <td>North America</td>\n",
       "      <td>Caribbean</td>\n",
       "      <td>96.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8000</td>\n",
       "      <td>76.1</td>\n",
       "      <td>63.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anguilla</td>\n",
       "      <td>Dependent Territory of the UK</td>\n",
       "      <td>Elisabeth II</td>\n",
       "      <td>62.0</td>\n",
       "      <td>AI</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ALB</td>\n",
       "      <td>Albania</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Southern Europe</td>\n",
       "      <td>28748.0</td>\n",
       "      <td>1912.0</td>\n",
       "      <td>3401200</td>\n",
       "      <td>71.6</td>\n",
       "      <td>3205.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>Shqipëria</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Rexhep Mejdani</td>\n",
       "      <td>34.0</td>\n",
       "      <td>AL</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>234</th>\n",
       "      <td>YEM</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>527968.0</td>\n",
       "      <td>1918.0</td>\n",
       "      <td>18112000</td>\n",
       "      <td>59.8</td>\n",
       "      <td>6041.0</td>\n",
       "      <td>5729.0</td>\n",
       "      <td>Al-Yaman</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Ali Abdallah Salih</td>\n",
       "      <td>1780.0</td>\n",
       "      <td>YE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>YUG</td>\n",
       "      <td>Yugoslavia</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Southern Europe</td>\n",
       "      <td>102173.0</td>\n",
       "      <td>1918.0</td>\n",
       "      <td>10640000</td>\n",
       "      <td>72.4</td>\n",
       "      <td>17000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Jugoslavija</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vojislav Koštunica</td>\n",
       "      <td>1792.0</td>\n",
       "      <td>YU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>ZAF</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Southern Africa</td>\n",
       "      <td>1221037.0</td>\n",
       "      <td>1910.0</td>\n",
       "      <td>40377000</td>\n",
       "      <td>51.1</td>\n",
       "      <td>116729.0</td>\n",
       "      <td>129092.0</td>\n",
       "      <td>South Africa</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Thabo Mbeki</td>\n",
       "      <td>716.0</td>\n",
       "      <td>ZA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>ZMB</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>752618.0</td>\n",
       "      <td>1964.0</td>\n",
       "      <td>9169000</td>\n",
       "      <td>37.2</td>\n",
       "      <td>3377.0</td>\n",
       "      <td>3922.0</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Frederick Chiluba</td>\n",
       "      <td>3162.0</td>\n",
       "      <td>ZM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>390757.0</td>\n",
       "      <td>1980.0</td>\n",
       "      <td>11669000</td>\n",
       "      <td>37.8</td>\n",
       "      <td>5951.0</td>\n",
       "      <td>8670.0</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Robert G. Mugabe</td>\n",
       "      <td>4068.0</td>\n",
       "      <td>ZW</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>239 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Code          Name      Continent                     Region  SurfaceArea  \\\n",
       "0    ABW         Aruba  North America                  Caribbean        193.0   \n",
       "1    AFG   Afghanistan           Asia  Southern and Central Asia     652090.0   \n",
       "2    AGO        Angola         Africa             Central Africa    1246700.0   \n",
       "3    AIA      Anguilla  North America                  Caribbean         96.0   \n",
       "4    ALB       Albania         Europe            Southern Europe      28748.0   \n",
       "..   ...           ...            ...                        ...          ...   \n",
       "234  YEM         Yemen           Asia                Middle East     527968.0   \n",
       "235  YUG    Yugoslavia         Europe            Southern Europe     102173.0   \n",
       "236  ZAF  South Africa         Africa            Southern Africa    1221037.0   \n",
       "237  ZMB        Zambia         Africa             Eastern Africa     752618.0   \n",
       "238  ZWE      Zimbabwe         Africa             Eastern Africa     390757.0   \n",
       "\n",
       "     IndepYear  Population  LifeExpectancy       GNP    GNPOld  \\\n",
       "0          NaN      103000            78.4     828.0     793.0   \n",
       "1       1919.0    22720000            45.9    5976.0       NaN   \n",
       "2       1975.0    12878000            38.3    6648.0    7984.0   \n",
       "3          NaN        8000            76.1      63.2       NaN   \n",
       "4       1912.0     3401200            71.6    3205.0    2500.0   \n",
       "..         ...         ...             ...       ...       ...   \n",
       "234     1918.0    18112000            59.8    6041.0    5729.0   \n",
       "235     1918.0    10640000            72.4   17000.0       NaN   \n",
       "236     1910.0    40377000            51.1  116729.0  129092.0   \n",
       "237     1964.0     9169000            37.2    3377.0    3922.0   \n",
       "238     1980.0    11669000            37.8    5951.0    8670.0   \n",
       "\n",
       "                 LocalName                                GovernmentForm  \\\n",
       "0                    Aruba  Nonmetropolitan Territory of The Netherlands   \n",
       "1    Afganistan/Afqanestan                               Islamic Emirate   \n",
       "2                   Angola                                      Republic   \n",
       "3                 Anguilla                 Dependent Territory of the UK   \n",
       "4                Shqipëria                                      Republic   \n",
       "..                     ...                                           ...   \n",
       "234               Al-Yaman                                      Republic   \n",
       "235            Jugoslavija                              Federal Republic   \n",
       "236           South Africa                                      Republic   \n",
       "237                 Zambia                                      Republic   \n",
       "238               Zimbabwe                                      Republic   \n",
       "\n",
       "                 HeadOfState  Capital Code2  \n",
       "0                    Beatrix    129.0    AW  \n",
       "1              Mohammad Omar      1.0    AF  \n",
       "2    José Eduardo dos Santos     56.0    AO  \n",
       "3               Elisabeth II     62.0    AI  \n",
       "4             Rexhep Mejdani     34.0    AL  \n",
       "..                       ...      ...   ...  \n",
       "234       Ali Abdallah Salih   1780.0    YE  \n",
       "235       Vojislav Koštunica   1792.0    YU  \n",
       "236              Thabo Mbeki    716.0    ZA  \n",
       "237        Frederick Chiluba   3162.0    ZM  \n",
       "238         Robert G. Mugabe   4068.0    ZW  \n",
       "\n",
       "[239 rows x 15 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Country=pd.read_sql_query(\"SELECT * FROM COUNTRY\",connection)\n",
    "Country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "226e4645-2953-4bc5-a606-9b030fd4784f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Waris Hayyat\\AppData\\Local\\Temp\\ipykernel_9380\\1623803578.py:1: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.\n",
      "  language=pd.read_sql_query(\"SELECT * FROM COUNTRYLANGUAGE\",connection)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CountryCode</th>\n",
       "      <th>Language</th>\n",
       "      <th>IsOfficial</th>\n",
       "      <th>Percentage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ABW</td>\n",
       "      <td>Dutch</td>\n",
       "      <td>T</td>\n",
       "      <td>5.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ABW</td>\n",
       "      <td>English</td>\n",
       "      <td>F</td>\n",
       "      <td>9.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABW</td>\n",
       "      <td>Papiamento</td>\n",
       "      <td>F</td>\n",
       "      <td>76.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ABW</td>\n",
       "      <td>Spanish</td>\n",
       "      <td>F</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AFG</td>\n",
       "      <td>Balochi</td>\n",
       "      <td>F</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>ZMB</td>\n",
       "      <td>Tongan</td>\n",
       "      <td>F</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>English</td>\n",
       "      <td>T</td>\n",
       "      <td>2.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Ndebele</td>\n",
       "      <td>F</td>\n",
       "      <td>16.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Nyanja</td>\n",
       "      <td>F</td>\n",
       "      <td>2.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>ZWE</td>\n",
       "      <td>Shona</td>\n",
       "      <td>F</td>\n",
       "      <td>72.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>984 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CountryCode    Language IsOfficial  Percentage\n",
       "0           ABW       Dutch          T         5.3\n",
       "1           ABW     English          F         9.5\n",
       "2           ABW  Papiamento          F        76.7\n",
       "3           ABW     Spanish          F         7.4\n",
       "4           AFG     Balochi          F         0.9\n",
       "..          ...         ...        ...         ...\n",
       "979         ZMB      Tongan          F        11.0\n",
       "980         ZWE     English          T         2.2\n",
       "981         ZWE     Ndebele          F        16.2\n",
       "982         ZWE      Nyanja          F         2.2\n",
       "983         ZWE       Shona          F        72.1\n",
       "\n",
       "[984 rows x 4 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "language=pd.read_sql_query(\"SELECT * FROM COUNTRYLANGUAGE\",connection)\n",
    "language"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "40cd3189-dd73-45f7-ae3a-3e1a10d42cc6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(        ID            Name CountryCode       District  Population\n",
       " 0        1           Kabul         AFG          Kabol     1780000\n",
       " 1        2        Qandahar         AFG       Qandahar      237500\n",
       " 2        3           Herat         AFG          Herat      186800\n",
       " 3        4  Mazar-e-Sharif         AFG          Balkh      127800\n",
       " 4        5       Amsterdam         NLD  Noord-Holland      731200\n",
       " ...    ...             ...         ...            ...         ...\n",
       " 4074  4075      Khan Yunis         PSE     Khan Yunis      123175\n",
       " 4075  4076          Hebron         PSE         Hebron      119401\n",
       " 4076  4077        Jabaliya         PSE     North Gaza      113901\n",
       " 4077  4078          Nablus         PSE         Nablus      100231\n",
       " 4078  4079           Rafah         PSE          Rafah       92020\n",
       " \n",
       " [4079 rows x 5 columns],\n",
       "     Code          Name      Continent                     Region  SurfaceArea  \\\n",
       " 0    ABW         Aruba  North America                  Caribbean        193.0   \n",
       " 1    AFG   Afghanistan           Asia  Southern and Central Asia     652090.0   \n",
       " 2    AGO        Angola         Africa             Central Africa    1246700.0   \n",
       " 3    AIA      Anguilla  North America                  Caribbean         96.0   \n",
       " 4    ALB       Albania         Europe            Southern Europe      28748.0   \n",
       " ..   ...           ...            ...                        ...          ...   \n",
       " 234  YEM         Yemen           Asia                Middle East     527968.0   \n",
       " 235  YUG    Yugoslavia         Europe            Southern Europe     102173.0   \n",
       " 236  ZAF  South Africa         Africa            Southern Africa    1221037.0   \n",
       " 237  ZMB        Zambia         Africa             Eastern Africa     752618.0   \n",
       " 238  ZWE      Zimbabwe         Africa             Eastern Africa     390757.0   \n",
       " \n",
       "      IndepYear  Population  LifeExpectancy       GNP    GNPOld  \\\n",
       " 0          NaN      103000            78.4     828.0     793.0   \n",
       " 1       1919.0    22720000            45.9    5976.0       NaN   \n",
       " 2       1975.0    12878000            38.3    6648.0    7984.0   \n",
       " 3          NaN        8000            76.1      63.2       NaN   \n",
       " 4       1912.0     3401200            71.6    3205.0    2500.0   \n",
       " ..         ...         ...             ...       ...       ...   \n",
       " 234     1918.0    18112000            59.8    6041.0    5729.0   \n",
       " 235     1918.0    10640000            72.4   17000.0       NaN   \n",
       " 236     1910.0    40377000            51.1  116729.0  129092.0   \n",
       " 237     1964.0     9169000            37.2    3377.0    3922.0   \n",
       " 238     1980.0    11669000            37.8    5951.0    8670.0   \n",
       " \n",
       "                  LocalName                                GovernmentForm  \\\n",
       " 0                    Aruba  Nonmetropolitan Territory of The Netherlands   \n",
       " 1    Afganistan/Afqanestan                               Islamic Emirate   \n",
       " 2                   Angola                                      Republic   \n",
       " 3                 Anguilla                 Dependent Territory of the UK   \n",
       " 4                Shqipëria                                      Republic   \n",
       " ..                     ...                                           ...   \n",
       " 234               Al-Yaman                                      Republic   \n",
       " 235            Jugoslavija                              Federal Republic   \n",
       " 236           South Africa                                      Republic   \n",
       " 237                 Zambia                                      Republic   \n",
       " 238               Zimbabwe                                      Republic   \n",
       " \n",
       "                  HeadOfState  Capital Code2  \n",
       " 0                    Beatrix    129.0    AW  \n",
       " 1              Mohammad Omar      1.0    AF  \n",
       " 2    José Eduardo dos Santos     56.0    AO  \n",
       " 3               Elisabeth II     62.0    AI  \n",
       " 4             Rexhep Mejdani     34.0    AL  \n",
       " ..                       ...      ...   ...  \n",
       " 234       Ali Abdallah Salih   1780.0    YE  \n",
       " 235       Vojislav Koštunica   1792.0    YU  \n",
       " 236              Thabo Mbeki    716.0    ZA  \n",
       " 237        Frederick Chiluba   3162.0    ZM  \n",
       " 238         Robert G. Mugabe   4068.0    ZW  \n",
       " \n",
       " [239 rows x 15 columns])"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "City,Country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "35ab08b9-8f5e-4db2-88c7-755a10185d31",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "19\n"
     ]
    }
   ],
   "source": [
    "var = pd.merge(City, Country, on='Name')\n",
    "print(var.columns.value_counts().sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "818defe4-b75a-422a-8525-01940e371e63",
   "metadata": {},
   "outputs": [],
   "source": [
    "var2=pd.merge(var,language, on=\"CountryCode\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "f8a508c8-0f86-4c1a-9118-c1da0f93c445",
   "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</th>\n",
       "      <th>CountryCode</th>\n",
       "      <th>District</th>\n",
       "      <th>Population_x</th>\n",
       "      <th>Code</th>\n",
       "      <th>Continent</th>\n",
       "      <th>Region</th>\n",
       "      <th>SurfaceArea</th>\n",
       "      <th>IndepYear</th>\n",
       "      <th>...</th>\n",
       "      <th>GNP</th>\n",
       "      <th>GNPOld</th>\n",
       "      <th>LocalName</th>\n",
       "      <th>GovernmentForm</th>\n",
       "      <th>HeadOfState</th>\n",
       "      <th>Capital</th>\n",
       "      <th>Code2</th>\n",
       "      <th>Language</th>\n",
       "      <th>IsOfficial</th>\n",
       "      <th>Percentage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>585</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>DJI</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>383000</td>\n",
       "      <td>DJI</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>23200.0</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>...</td>\n",
       "      <td>382.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>Djibouti/Jibuti</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Ismail Omar Guelleh</td>\n",
       "      <td>585.0</td>\n",
       "      <td>DJ</td>\n",
       "      <td>Afar</td>\n",
       "      <td>F</td>\n",
       "      <td>34.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>585</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>DJI</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>383000</td>\n",
       "      <td>DJI</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>23200.0</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>...</td>\n",
       "      <td>382.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>Djibouti/Jibuti</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Ismail Omar Guelleh</td>\n",
       "      <td>585.0</td>\n",
       "      <td>DJ</td>\n",
       "      <td>Arabic</td>\n",
       "      <td>T</td>\n",
       "      <td>10.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>585</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>DJI</td>\n",
       "      <td>Djibouti</td>\n",
       "      <td>383000</td>\n",
       "      <td>DJI</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Eastern Africa</td>\n",
       "      <td>23200.0</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>...</td>\n",
       "      <td>382.0</td>\n",
       "      <td>373.0</td>\n",
       "      <td>Djibouti/Jibuti</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Ismail Omar Guelleh</td>\n",
       "      <td>585.0</td>\n",
       "      <td>DJ</td>\n",
       "      <td>Somali</td>\n",
       "      <td>F</td>\n",
       "      <td>43.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Bicol</td>\n",
       "      <td>F</td>\n",
       "      <td>5.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Cebuano</td>\n",
       "      <td>F</td>\n",
       "      <td>23.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Hiligaynon</td>\n",
       "      <td>F</td>\n",
       "      <td>9.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Ilocano</td>\n",
       "      <td>F</td>\n",
       "      <td>9.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Maguindanao</td>\n",
       "      <td>F</td>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Maranao</td>\n",
       "      <td>F</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Pampango</td>\n",
       "      <td>F</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Pangasinan</td>\n",
       "      <td>F</td>\n",
       "      <td>1.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Pilipino</td>\n",
       "      <td>T</td>\n",
       "      <td>29.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>864</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>PHL</td>\n",
       "      <td>Central Luzon</td>\n",
       "      <td>109481</td>\n",
       "      <td>MEX</td>\n",
       "      <td>North America</td>\n",
       "      <td>Central America</td>\n",
       "      <td>1958201.0</td>\n",
       "      <td>1810.0</td>\n",
       "      <td>...</td>\n",
       "      <td>414972.0</td>\n",
       "      <td>401461.0</td>\n",
       "      <td>México</td>\n",
       "      <td>Federal Republic</td>\n",
       "      <td>Vicente Fox Quesada</td>\n",
       "      <td>2515.0</td>\n",
       "      <td>MX</td>\n",
       "      <td>Waray-waray</td>\n",
       "      <td>F</td>\n",
       "      <td>3.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>915</td>\n",
       "      <td>Gibraltar</td>\n",
       "      <td>GIB</td>\n",
       "      <td>–</td>\n",
       "      <td>27025</td>\n",
       "      <td>GIB</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Southern Europe</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gibraltar</td>\n",
       "      <td>Dependent Territory of the UK</td>\n",
       "      <td>Elisabeth II</td>\n",
       "      <td>915.0</td>\n",
       "      <td>GI</td>\n",
       "      <td>Arabic</td>\n",
       "      <td>F</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>915</td>\n",
       "      <td>Gibraltar</td>\n",
       "      <td>GIB</td>\n",
       "      <td>–</td>\n",
       "      <td>27025</td>\n",
       "      <td>GIB</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Southern Europe</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>258.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gibraltar</td>\n",
       "      <td>Dependent Territory of the UK</td>\n",
       "      <td>Elisabeth II</td>\n",
       "      <td>915.0</td>\n",
       "      <td>GI</td>\n",
       "      <td>English</td>\n",
       "      <td>T</td>\n",
       "      <td>88.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2272</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>COL</td>\n",
       "      <td>Quindío</td>\n",
       "      <td>288977</td>\n",
       "      <td>ARM</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>29800.0</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1813.0</td>\n",
       "      <td>1627.0</td>\n",
       "      <td>Hajastan</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Robert Kotšarjan</td>\n",
       "      <td>126.0</td>\n",
       "      <td>AM</td>\n",
       "      <td>Arawakan</td>\n",
       "      <td>F</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2272</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>COL</td>\n",
       "      <td>Quindío</td>\n",
       "      <td>288977</td>\n",
       "      <td>ARM</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>29800.0</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1813.0</td>\n",
       "      <td>1627.0</td>\n",
       "      <td>Hajastan</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Robert Kotšarjan</td>\n",
       "      <td>126.0</td>\n",
       "      <td>AM</td>\n",
       "      <td>Caribbean</td>\n",
       "      <td>F</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2272</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>COL</td>\n",
       "      <td>Quindío</td>\n",
       "      <td>288977</td>\n",
       "      <td>ARM</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>29800.0</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1813.0</td>\n",
       "      <td>1627.0</td>\n",
       "      <td>Hajastan</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Robert Kotšarjan</td>\n",
       "      <td>126.0</td>\n",
       "      <td>AM</td>\n",
       "      <td>Chibcha</td>\n",
       "      <td>F</td>\n",
       "      <td>0.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2272</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>COL</td>\n",
       "      <td>Quindío</td>\n",
       "      <td>288977</td>\n",
       "      <td>ARM</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>29800.0</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1813.0</td>\n",
       "      <td>1627.0</td>\n",
       "      <td>Hajastan</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Robert Kotšarjan</td>\n",
       "      <td>126.0</td>\n",
       "      <td>AM</td>\n",
       "      <td>Creole English</td>\n",
       "      <td>F</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2272</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>COL</td>\n",
       "      <td>Quindío</td>\n",
       "      <td>288977</td>\n",
       "      <td>ARM</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>29800.0</td>\n",
       "      <td>1991.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1813.0</td>\n",
       "      <td>1627.0</td>\n",
       "      <td>Hajastan</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Robert Kotšarjan</td>\n",
       "      <td>126.0</td>\n",
       "      <td>AM</td>\n",
       "      <td>Spanish</td>\n",
       "      <td>T</td>\n",
       "      <td>99.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2429</td>\n",
       "      <td>Kuwait</td>\n",
       "      <td>KWT</td>\n",
       "      <td>al-Asima</td>\n",
       "      <td>28859</td>\n",
       "      <td>KWT</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>17818.0</td>\n",
       "      <td>1961.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27037.0</td>\n",
       "      <td>30373.0</td>\n",
       "      <td>Al-Kuwayt</td>\n",
       "      <td>Constitutional Monarchy (Emirate)</td>\n",
       "      <td>Jabir al-Ahmad al-Jabir al-Sabah</td>\n",
       "      <td>2429.0</td>\n",
       "      <td>KW</td>\n",
       "      <td>Arabic</td>\n",
       "      <td>T</td>\n",
       "      <td>78.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2429</td>\n",
       "      <td>Kuwait</td>\n",
       "      <td>KWT</td>\n",
       "      <td>al-Asima</td>\n",
       "      <td>28859</td>\n",
       "      <td>KWT</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Middle East</td>\n",
       "      <td>17818.0</td>\n",
       "      <td>1961.0</td>\n",
       "      <td>...</td>\n",
       "      <td>27037.0</td>\n",
       "      <td>30373.0</td>\n",
       "      <td>Al-Kuwayt</td>\n",
       "      <td>Constitutional Monarchy (Emirate)</td>\n",
       "      <td>Jabir al-Ahmad al-Jabir al-Sabah</td>\n",
       "      <td>2429.0</td>\n",
       "      <td>KW</td>\n",
       "      <td>English</td>\n",
       "      <td>F</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2454</td>\n",
       "      <td>Macao</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Macau</td>\n",
       "      <td>437500</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Eastern Asia</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5749.0</td>\n",
       "      <td>5940.0</td>\n",
       "      <td>Macau/Aomen</td>\n",
       "      <td>Special Administrative Region of China</td>\n",
       "      <td>Jiang Zemin</td>\n",
       "      <td>2454.0</td>\n",
       "      <td>MO</td>\n",
       "      <td>Canton Chinese</td>\n",
       "      <td>F</td>\n",
       "      <td>85.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2454</td>\n",
       "      <td>Macao</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Macau</td>\n",
       "      <td>437500</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Eastern Asia</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5749.0</td>\n",
       "      <td>5940.0</td>\n",
       "      <td>Macau/Aomen</td>\n",
       "      <td>Special Administrative Region of China</td>\n",
       "      <td>Jiang Zemin</td>\n",
       "      <td>2454.0</td>\n",
       "      <td>MO</td>\n",
       "      <td>English</td>\n",
       "      <td>F</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2454</td>\n",
       "      <td>Macao</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Macau</td>\n",
       "      <td>437500</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Eastern Asia</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5749.0</td>\n",
       "      <td>5940.0</td>\n",
       "      <td>Macau/Aomen</td>\n",
       "      <td>Special Administrative Region of China</td>\n",
       "      <td>Jiang Zemin</td>\n",
       "      <td>2454.0</td>\n",
       "      <td>MO</td>\n",
       "      <td>Mandarin Chinese</td>\n",
       "      <td>F</td>\n",
       "      <td>1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2454</td>\n",
       "      <td>Macao</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Macau</td>\n",
       "      <td>437500</td>\n",
       "      <td>MAC</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Eastern Asia</td>\n",
       "      <td>18.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5749.0</td>\n",
       "      <td>5940.0</td>\n",
       "      <td>Macau/Aomen</td>\n",
       "      <td>Special Administrative Region of China</td>\n",
       "      <td>Jiang Zemin</td>\n",
       "      <td>2454.0</td>\n",
       "      <td>MO</td>\n",
       "      <td>Portuguese</td>\n",
       "      <td>T</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3171</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>SMR</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>2294</td>\n",
       "      <td>SMR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Southern Europe</td>\n",
       "      <td>61.0</td>\n",
       "      <td>885.0</td>\n",
       "      <td>...</td>\n",
       "      <td>510.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>Republic</td>\n",
       "      <td>None</td>\n",
       "      <td>3171.0</td>\n",
       "      <td>SM</td>\n",
       "      <td>Italian</td>\n",
       "      <td>T</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3208</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>SGP</td>\n",
       "      <td>–</td>\n",
       "      <td>4017733</td>\n",
       "      <td>SGP</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>618.0</td>\n",
       "      <td>1965.0</td>\n",
       "      <td>...</td>\n",
       "      <td>86503.0</td>\n",
       "      <td>96318.0</td>\n",
       "      <td>Singapore/Singapura/Xinjiapo/Singapur</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Sellapan Rama Nathan</td>\n",
       "      <td>3208.0</td>\n",
       "      <td>SG</td>\n",
       "      <td>Chinese</td>\n",
       "      <td>T</td>\n",
       "      <td>77.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3208</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>SGP</td>\n",
       "      <td>–</td>\n",
       "      <td>4017733</td>\n",
       "      <td>SGP</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>618.0</td>\n",
       "      <td>1965.0</td>\n",
       "      <td>...</td>\n",
       "      <td>86503.0</td>\n",
       "      <td>96318.0</td>\n",
       "      <td>Singapore/Singapura/Xinjiapo/Singapur</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Sellapan Rama Nathan</td>\n",
       "      <td>3208.0</td>\n",
       "      <td>SG</td>\n",
       "      <td>Malay</td>\n",
       "      <td>T</td>\n",
       "      <td>14.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3208</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>SGP</td>\n",
       "      <td>–</td>\n",
       "      <td>4017733</td>\n",
       "      <td>SGP</td>\n",
       "      <td>Asia</td>\n",
       "      <td>Southeast Asia</td>\n",
       "      <td>618.0</td>\n",
       "      <td>1965.0</td>\n",
       "      <td>...</td>\n",
       "      <td>86503.0</td>\n",
       "      <td>96318.0</td>\n",
       "      <td>Singapore/Singapura/Xinjiapo/Singapur</td>\n",
       "      <td>Republic</td>\n",
       "      <td>Sellapan Rama Nathan</td>\n",
       "      <td>3208.0</td>\n",
       "      <td>SG</td>\n",
       "      <td>Tamil</td>\n",
       "      <td>T</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID        Name CountryCode       District  Population_x Code  \\\n",
       "0    585    Djibouti         DJI       Djibouti        383000  DJI   \n",
       "1    585    Djibouti         DJI       Djibouti        383000  DJI   \n",
       "2    585    Djibouti         DJI       Djibouti        383000  DJI   \n",
       "3    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "4    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "5    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "6    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "7    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "8    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "9    864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "10   864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "11   864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "12   864      Mexico         PHL  Central Luzon        109481  MEX   \n",
       "13   915   Gibraltar         GIB              –         27025  GIB   \n",
       "14   915   Gibraltar         GIB              –         27025  GIB   \n",
       "15  2272     Armenia         COL        Quindío        288977  ARM   \n",
       "16  2272     Armenia         COL        Quindío        288977  ARM   \n",
       "17  2272     Armenia         COL        Quindío        288977  ARM   \n",
       "18  2272     Armenia         COL        Quindío        288977  ARM   \n",
       "19  2272     Armenia         COL        Quindío        288977  ARM   \n",
       "20  2429      Kuwait         KWT       al-Asima         28859  KWT   \n",
       "21  2429      Kuwait         KWT       al-Asima         28859  KWT   \n",
       "22  2454       Macao         MAC          Macau        437500  MAC   \n",
       "23  2454       Macao         MAC          Macau        437500  MAC   \n",
       "24  2454       Macao         MAC          Macau        437500  MAC   \n",
       "25  2454       Macao         MAC          Macau        437500  MAC   \n",
       "26  3171  San Marino         SMR     San Marino          2294  SMR   \n",
       "27  3208   Singapore         SGP              –       4017733  SGP   \n",
       "28  3208   Singapore         SGP              –       4017733  SGP   \n",
       "29  3208   Singapore         SGP              –       4017733  SGP   \n",
       "\n",
       "        Continent           Region  SurfaceArea  IndepYear  ...       GNP  \\\n",
       "0          Africa   Eastern Africa      23200.0     1977.0  ...     382.0   \n",
       "1          Africa   Eastern Africa      23200.0     1977.0  ...     382.0   \n",
       "2          Africa   Eastern Africa      23200.0     1977.0  ...     382.0   \n",
       "3   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "4   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "5   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "6   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "7   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "8   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "9   North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "10  North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "11  North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "12  North America  Central America    1958201.0     1810.0  ...  414972.0   \n",
       "13         Europe  Southern Europe          6.0        NaN  ...     258.0   \n",
       "14         Europe  Southern Europe          6.0        NaN  ...     258.0   \n",
       "15           Asia      Middle East      29800.0     1991.0  ...    1813.0   \n",
       "16           Asia      Middle East      29800.0     1991.0  ...    1813.0   \n",
       "17           Asia      Middle East      29800.0     1991.0  ...    1813.0   \n",
       "18           Asia      Middle East      29800.0     1991.0  ...    1813.0   \n",
       "19           Asia      Middle East      29800.0     1991.0  ...    1813.0   \n",
       "20           Asia      Middle East      17818.0     1961.0  ...   27037.0   \n",
       "21           Asia      Middle East      17818.0     1961.0  ...   27037.0   \n",
       "22           Asia     Eastern Asia         18.0        NaN  ...    5749.0   \n",
       "23           Asia     Eastern Asia         18.0        NaN  ...    5749.0   \n",
       "24           Asia     Eastern Asia         18.0        NaN  ...    5749.0   \n",
       "25           Asia     Eastern Asia         18.0        NaN  ...    5749.0   \n",
       "26         Europe  Southern Europe         61.0      885.0  ...     510.0   \n",
       "27           Asia   Southeast Asia        618.0     1965.0  ...   86503.0   \n",
       "28           Asia   Southeast Asia        618.0     1965.0  ...   86503.0   \n",
       "29           Asia   Southeast Asia        618.0     1965.0  ...   86503.0   \n",
       "\n",
       "      GNPOld                              LocalName  \\\n",
       "0      373.0                        Djibouti/Jibuti   \n",
       "1      373.0                        Djibouti/Jibuti   \n",
       "2      373.0                        Djibouti/Jibuti   \n",
       "3   401461.0                                 México   \n",
       "4   401461.0                                 México   \n",
       "5   401461.0                                 México   \n",
       "6   401461.0                                 México   \n",
       "7   401461.0                                 México   \n",
       "8   401461.0                                 México   \n",
       "9   401461.0                                 México   \n",
       "10  401461.0                                 México   \n",
       "11  401461.0                                 México   \n",
       "12  401461.0                                 México   \n",
       "13       NaN                              Gibraltar   \n",
       "14       NaN                              Gibraltar   \n",
       "15    1627.0                               Hajastan   \n",
       "16    1627.0                               Hajastan   \n",
       "17    1627.0                               Hajastan   \n",
       "18    1627.0                               Hajastan   \n",
       "19    1627.0                               Hajastan   \n",
       "20   30373.0                              Al-Kuwayt   \n",
       "21   30373.0                              Al-Kuwayt   \n",
       "22    5940.0                            Macau/Aomen   \n",
       "23    5940.0                            Macau/Aomen   \n",
       "24    5940.0                            Macau/Aomen   \n",
       "25    5940.0                            Macau/Aomen   \n",
       "26       NaN                             San Marino   \n",
       "27   96318.0  Singapore/Singapura/Xinjiapo/Singapur   \n",
       "28   96318.0  Singapore/Singapura/Xinjiapo/Singapur   \n",
       "29   96318.0  Singapore/Singapura/Xinjiapo/Singapur   \n",
       "\n",
       "                            GovernmentForm                       HeadOfState  \\\n",
       "0                                 Republic               Ismail Omar Guelleh   \n",
       "1                                 Republic               Ismail Omar Guelleh   \n",
       "2                                 Republic               Ismail Omar Guelleh   \n",
       "3                         Federal Republic               Vicente Fox Quesada   \n",
       "4                         Federal Republic               Vicente Fox Quesada   \n",
       "5                         Federal Republic               Vicente Fox Quesada   \n",
       "6                         Federal Republic               Vicente Fox Quesada   \n",
       "7                         Federal Republic               Vicente Fox Quesada   \n",
       "8                         Federal Republic               Vicente Fox Quesada   \n",
       "9                         Federal Republic               Vicente Fox Quesada   \n",
       "10                        Federal Republic               Vicente Fox Quesada   \n",
       "11                        Federal Republic               Vicente Fox Quesada   \n",
       "12                        Federal Republic               Vicente Fox Quesada   \n",
       "13           Dependent Territory of the UK                      Elisabeth II   \n",
       "14           Dependent Territory of the UK                      Elisabeth II   \n",
       "15                                Republic                  Robert Kotšarjan   \n",
       "16                                Republic                  Robert Kotšarjan   \n",
       "17                                Republic                  Robert Kotšarjan   \n",
       "18                                Republic                  Robert Kotšarjan   \n",
       "19                                Republic                  Robert Kotšarjan   \n",
       "20       Constitutional Monarchy (Emirate)  Jabir al-Ahmad al-Jabir al-Sabah   \n",
       "21       Constitutional Monarchy (Emirate)  Jabir al-Ahmad al-Jabir al-Sabah   \n",
       "22  Special Administrative Region of China                       Jiang Zemin   \n",
       "23  Special Administrative Region of China                       Jiang Zemin   \n",
       "24  Special Administrative Region of China                       Jiang Zemin   \n",
       "25  Special Administrative Region of China                       Jiang Zemin   \n",
       "26                                Republic                              None   \n",
       "27                                Republic              Sellapan Rama Nathan   \n",
       "28                                Republic              Sellapan Rama Nathan   \n",
       "29                                Republic              Sellapan Rama Nathan   \n",
       "\n",
       "   Capital Code2          Language IsOfficial Percentage  \n",
       "0    585.0    DJ              Afar          F       34.8  \n",
       "1    585.0    DJ            Arabic          T       10.6  \n",
       "2    585.0    DJ            Somali          F       43.9  \n",
       "3   2515.0    MX             Bicol          F        5.7  \n",
       "4   2515.0    MX           Cebuano          F       23.3  \n",
       "5   2515.0    MX        Hiligaynon          F        9.1  \n",
       "6   2515.0    MX           Ilocano          F        9.3  \n",
       "7   2515.0    MX       Maguindanao          F        1.4  \n",
       "8   2515.0    MX           Maranao          F        1.3  \n",
       "9   2515.0    MX          Pampango          F        3.0  \n",
       "10  2515.0    MX        Pangasinan          F        1.8  \n",
       "11  2515.0    MX          Pilipino          T       29.3  \n",
       "12  2515.0    MX       Waray-waray          F        3.8  \n",
       "13   915.0    GI            Arabic          F        7.4  \n",
       "14   915.0    GI           English          T       88.9  \n",
       "15   126.0    AM          Arawakan          F        0.1  \n",
       "16   126.0    AM         Caribbean          F        0.1  \n",
       "17   126.0    AM           Chibcha          F        0.4  \n",
       "18   126.0    AM    Creole English          F        0.1  \n",
       "19   126.0    AM           Spanish          T       99.0  \n",
       "20  2429.0    KW            Arabic          T       78.1  \n",
       "21  2429.0    KW           English          F        0.0  \n",
       "22  2454.0    MO    Canton Chinese          F       85.6  \n",
       "23  2454.0    MO           English          F        0.5  \n",
       "24  2454.0    MO  Mandarin Chinese          F        1.2  \n",
       "25  2454.0    MO        Portuguese          T        2.3  \n",
       "26  3171.0    SM           Italian          T      100.0  \n",
       "27  3208.0    SG           Chinese          T       77.1  \n",
       "28  3208.0    SG             Malay          T       14.1  \n",
       "29  3208.0    SG             Tamil          T        7.4  \n",
       "\n",
       "[30 rows x 22 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "var2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "62c11bfe-1ace-4efe-a7ae-92d7ccdb7b64",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.0"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}