Visas and Qual.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import country_converter as coco"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "visa = pd.read_csv(\"data/visa.csv\", index_col = 0)\n",
    "def converter(x):\n",
    "    if(x == \"YUGOSLAVIA\" or x == \"SERBIA AND MONTENEGRO\"):\n",
    "        return \"SERBIA\"\n",
    "    else:\n",
    "        return x\n",
    "visa[\"citizenship\"] = visa[\"citizenship\"].apply(converter)\n",
    "c = coco.convert(names = visa[\"citizenship\"].value_counts().index.tolist(), to = 'ISO2')\n",
    "c = [i.lower() for i in c]\n",
    "d = [list(x) + [] for x in zip(c[::-1], range(1, len(c) + 1))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{name: 'Advanced Mfg', y: typeData[country]['Advanced Mfg']},\n",
      "{name: 'Aerospace', y: typeData[country]['Aerospace']},\n",
      "{name: 'Agribusiness', y: typeData[country]['Agribusiness']},\n",
      "{name: 'Automotive', y: typeData[country]['Automotive']},\n",
      "{name: 'Biotechnology', y: typeData[country]['Biotechnology']},\n",
      "{name: 'Construction', y: typeData[country]['Construction']},\n",
      "{name: 'Educational Services', y: typeData[country]['Educational Services']},\n",
      "{name: 'Energy', y: typeData[country]['Energy']},\n",
      "{name: 'Finance', y: typeData[country]['Finance']},\n",
      "{name: 'Geospatial', y: typeData[country]['Geospatial']},\n",
      "{name: 'Health Care', y: typeData[country]['Health Care']},\n",
      "{name: 'Homeland Security', y: typeData[country]['Homeland Security']},\n",
      "{name: 'Hospitality', y: typeData[country]['Hospitality']},\n",
      "{name: 'IT', y: typeData[country]['IT']},\n",
      "{name: 'Other Economic Sector', y: typeData[country]['Other Economic Sector']},\n",
      "{name: 'Retail', y: typeData[country]['Retail']},\n",
      "{name: 'Transportation', y: typeData[country]['Transportation']},\n"
     ]
    }
   ],
   "source": [
    "ind_data = pd.pivot_table(visa, values = 'application type', index=['citizenship'],\n",
    "                    columns=['category'], aggfunc= 'count').fillna(0)\n",
    "ind_data.index = pd.Series(coco.convert(names = ind_data.index.tolist(), to = 'ISO2')).str.lower()\n",
    "for i in ind_data.columns:\n",
    "    print(\"{name: '\" +  i + \"', y: typeData[country]['\" +  i + \"']},\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>index</th>\n",
       "      <th>N</th>\n",
       "      <th>Y</th>\n",
       "      <th>percent</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>af</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>43.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>al</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>dz</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ar</td>\n",
       "      <td>22.0</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.752809</td>\n",
       "      <td>122.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>am</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>au</td>\n",
       "      <td>28.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>0.813333</td>\n",
       "      <td>139.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>at</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.937500</td>\n",
       "      <td>89.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>az</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>57.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>bs</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>bh</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>bd</td>\n",
       "      <td>22.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.816667</td>\n",
       "      <td>133.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>bb</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.909091</td>\n",
       "      <td>78.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>by</td>\n",
       "      <td>9.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>105.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>be</td>\n",
       "      <td>2.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.931034</td>\n",
       "      <td>97.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>bz</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>bj</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>bm</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>bt</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>bo</td>\n",
       "      <td>4.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>92.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ba</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>41.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>bw</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>br</td>\n",
       "      <td>36.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0.840708</td>\n",
       "      <td>144.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>bg</td>\n",
       "      <td>8.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>0.875000</td>\n",
       "      <td>117.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>bf</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>mm</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>87.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>bi</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>26.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>kh</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>49.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>cm</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.928571</td>\n",
       "      <td>85.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>ca</td>\n",
       "      <td>229.0</td>\n",
       "      <td>1404.0</td>\n",
       "      <td>0.859767</td>\n",
       "      <td>157.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>ky</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>kn</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>lc</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>53.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>vc</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>sd</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>sr</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>se</td>\n",
       "      <td>2.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0.959184</td>\n",
       "      <td>107.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>ch</td>\n",
       "      <td>6.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.823529</td>\n",
       "      <td>99.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>sy</td>\n",
       "      <td>5.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>0.912281</td>\n",
       "      <td>111.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>tw</td>\n",
       "      <td>72.0</td>\n",
       "      <td>401.0</td>\n",
       "      <td>0.847780</td>\n",
       "      <td>152.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>tj</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>tz</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>61.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>th</td>\n",
       "      <td>23.0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>0.774510</td>\n",
       "      <td>129.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>tg</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>tt</td>\n",
       "      <td>7.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.851064</td>\n",
       "      <td>106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>tn</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>58.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>tr</td>\n",
       "      <td>33.0</td>\n",
       "      <td>240.0</td>\n",
       "      <td>0.879121</td>\n",
       "      <td>148.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>tm</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>ug</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>56.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>ua</td>\n",
       "      <td>21.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>0.812500</td>\n",
       "      <td>131.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>ae</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>gb</td>\n",
       "      <td>92.0</td>\n",
       "      <td>444.0</td>\n",
       "      <td>0.828358</td>\n",
       "      <td>153.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>us</td>\n",
       "      <td>21.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>0.730769</td>\n",
       "      <td>119.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>uy</td>\n",
       "      <td>0.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>84.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>uz</td>\n",
       "      <td>2.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>73.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>vu</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>ve</td>\n",
       "      <td>43.0</td>\n",
       "      <td>219.0</td>\n",
       "      <td>0.835878</td>\n",
       "      <td>147.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>vn</td>\n",
       "      <td>9.0</td>\n",
       "      <td>55.0</td>\n",
       "      <td>0.859375</td>\n",
       "      <td>115.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>ye</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>zm</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>44.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>zw</td>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.941176</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>159 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    index      N       Y   percent  value\n",
       "0      af    1.0     3.0  0.750000   43.0\n",
       "1      al    2.0    10.0  0.833333   82.0\n",
       "2      dz    2.0     1.0  0.333333   38.0\n",
       "3      ar   22.0    67.0  0.752809  122.0\n",
       "4      am    0.0     9.0  1.000000   69.0\n",
       "5      au   28.0   122.0  0.813333  139.0\n",
       "6      at    1.0    15.0  0.937500   89.0\n",
       "7      az    0.0     7.0  1.000000   57.0\n",
       "8      bs    2.0     8.0  0.800000   72.0\n",
       "9      bh    0.0     1.0  1.000000   10.0\n",
       "10     bd   22.0    98.0  0.816667  133.0\n",
       "11     bb    1.0    10.0  0.909091   78.0\n",
       "12     by    9.0    36.0  0.800000  105.0\n",
       "13     be    2.0    27.0  0.931034   97.0\n",
       "14     bz    0.0     2.0  1.000000   32.0\n",
       "15     bj    0.0     1.0  1.000000    3.0\n",
       "16     bm    1.0     1.0  0.500000   21.0\n",
       "17     bt    0.0     1.0  1.000000    1.0\n",
       "18     bo    4.0    16.0  0.800000   92.0\n",
       "19     ba    0.0     3.0  1.000000   41.0\n",
       "20     bw    1.0     2.0  0.666667   33.0\n",
       "21     br   36.0   190.0  0.840708  144.0\n",
       "22     bg    8.0    56.0  0.875000  117.0\n",
       "23     bf    1.0     0.0  0.000000    2.0\n",
       "24     mm    0.0    14.0  1.000000   87.0\n",
       "25     bi    1.0     1.0  0.500000   26.0\n",
       "26     kh    2.0     2.0  0.500000   49.0\n",
       "27     cm    1.0    13.0  0.928571   85.0\n",
       "28     ca  229.0  1404.0  0.859767  157.0\n",
       "29     ky    0.0     2.0  1.000000   30.0\n",
       "..    ...    ...     ...       ...    ...\n",
       "129    kn    1.0     1.0  0.500000   31.0\n",
       "130    lc    1.0     5.0  0.833333   53.0\n",
       "131    vc    0.0     3.0  1.000000   34.0\n",
       "132    sd    0.0     1.0  1.000000   14.0\n",
       "133    sr    2.0     1.0  0.333333   37.0\n",
       "134    se    2.0    47.0  0.959184  107.0\n",
       "135    ch    6.0    28.0  0.823529   99.0\n",
       "136    sy    5.0    52.0  0.912281  111.0\n",
       "137    tw   72.0   401.0  0.847780  152.0\n",
       "138    tj    2.0     2.0  0.500000   45.0\n",
       "139    tz    2.0     6.0  0.750000   61.0\n",
       "140    th   23.0    79.0  0.774510  129.0\n",
       "141    tg    0.0     1.0  1.000000   12.0\n",
       "142    tt    7.0    40.0  0.851064  106.0\n",
       "143    tn    0.0     7.0  1.000000   58.0\n",
       "144    tr   33.0   240.0  0.879121  148.0\n",
       "145    tm    0.0     3.0  1.000000   39.0\n",
       "146    ug    2.0     5.0  0.714286   56.0\n",
       "147    ua   21.0    91.0  0.812500  131.0\n",
       "148    ae    0.0     1.0  1.000000   16.0\n",
       "149    gb   92.0   444.0  0.828358  153.0\n",
       "150    us   21.0    57.0  0.730769  119.0\n",
       "151    uy    0.0    14.0  1.000000   84.0\n",
       "152    uz    2.0     8.0  0.800000   73.0\n",
       "153    vu    0.0     1.0  1.000000   17.0\n",
       "154    ve   43.0   219.0  0.835878  147.0\n",
       "155    vn    9.0    55.0  0.859375  115.0\n",
       "156    ye    0.0     3.0  1.000000   42.0\n",
       "157    zm    1.0     3.0  0.750000   44.0\n",
       "158    zw    1.0    16.0  0.941176   90.0\n",
       "\n",
       "[159 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "countries = pd.read_csv(\"data/visa_decision.csv\", index_col = 0)\n",
    "countries[\"value\"] = pd.Series()\n",
    "for i in d:\n",
    "    countries.loc[i[0]][\"value\"] = i[1]\n",
    "countries = countries.reset_index()\n",
    "#countries.to_json(\"data/visa_decision.json\", orient = \"index\", date_format = \"epoch\", double_precision = 10, force_ascii = True, date_unit = \"ms\", default_handler = None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>category</th>\n",
       "      <th>citizenship</th>\n",
       "      <th>application type</th>\n",
       "      <th>visa class</th>\n",
       "      <th>decision</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Automotive</td>\n",
       "      <td>ECUADOR</td>\n",
       "      <td>MAILEDIN</td>\n",
       "      <td>EWI</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>PHILIPPINES</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>L-1</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IT</td>\n",
       "      <td>COLOMBIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Transportation</td>\n",
       "      <td>SOUTH KOREA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>E-2</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>IT</td>\n",
       "      <td>GERMANY</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Energy</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Geospatial</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Health Care</td>\n",
       "      <td>UKRAINE</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>L-1</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Construction</td>\n",
       "      <td>EL SALVADOR</td>\n",
       "      <td>MAILEDIN</td>\n",
       "      <td>EWI</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Construction</td>\n",
       "      <td>EL SALVADOR</td>\n",
       "      <td>MAILEDIN</td>\n",
       "      <td>TPS</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Hospitality</td>\n",
       "      <td>UNITED STATES OF AMERICA</td>\n",
       "      <td>MAILEDIN</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Construction</td>\n",
       "      <td>POLAND</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>B-2</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Finance</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>L-1</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>FRANCE</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Aerospace</td>\n",
       "      <td>CHINA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>Y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38561</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38562</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38563</th>\n",
       "      <td>Educational Services</td>\n",
       "      <td>JORDAN</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38564</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>ITALY</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>E-1</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38565</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38566</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38567</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38568</th>\n",
       "      <td>Other Economic Sector</td>\n",
       "      <td>SOUTH KOREA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>B-2</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38569</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38570</th>\n",
       "      <td>IT</td>\n",
       "      <td>ISRAEL</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>E-1</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38571</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38572</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38573</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>ISRAEL</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>L-1</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38574</th>\n",
       "      <td>Other Economic Sector</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38575</th>\n",
       "      <td>Other Economic Sector</td>\n",
       "      <td>PHILIPPINES</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38576</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38577</th>\n",
       "      <td>Other Economic Sector</td>\n",
       "      <td>SOUTH KOREA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>F-1</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38578</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38579</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38580</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38581</th>\n",
       "      <td>Educational Services</td>\n",
       "      <td>DENMARK</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38582</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38583</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>SOUTH KOREA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38584</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38585</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38586</th>\n",
       "      <td>Automotive</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38587</th>\n",
       "      <td>Other Economic Sector</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38588</th>\n",
       "      <td>Advanced Mfg</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38589</th>\n",
       "      <td>IT</td>\n",
       "      <td>INDIA</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>H-1B</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38590</th>\n",
       "      <td>Transportation</td>\n",
       "      <td>UNITED KINGDOM</td>\n",
       "      <td>ONLINE</td>\n",
       "      <td>B-2</td>\n",
       "      <td>N</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38591 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    category               citizenship application type  \\\n",
       "0                 Automotive                   ECUADOR         MAILEDIN   \n",
       "1               Advanced Mfg                     INDIA           ONLINE   \n",
       "2               Advanced Mfg               PHILIPPINES           ONLINE   \n",
       "3               Advanced Mfg                     INDIA           ONLINE   \n",
       "4               Advanced Mfg                     INDIA           ONLINE   \n",
       "5               Advanced Mfg                     INDIA           ONLINE   \n",
       "6               Advanced Mfg                     INDIA           ONLINE   \n",
       "7                         IT                  COLOMBIA           ONLINE   \n",
       "8                         IT                     INDIA           ONLINE   \n",
       "9             Transportation               SOUTH KOREA           ONLINE   \n",
       "10                        IT                     INDIA           ONLINE   \n",
       "11                        IT                   GERMANY           ONLINE   \n",
       "12              Advanced Mfg            UNITED KINGDOM           ONLINE   \n",
       "13                    Energy                     INDIA           ONLINE   \n",
       "14                Geospatial                     INDIA           ONLINE   \n",
       "15               Health Care                   UKRAINE           ONLINE   \n",
       "16                        IT                     INDIA           ONLINE   \n",
       "17                        IT                     INDIA           ONLINE   \n",
       "18                        IT                     INDIA           ONLINE   \n",
       "19              Construction               EL SALVADOR         MAILEDIN   \n",
       "20              Construction               EL SALVADOR         MAILEDIN   \n",
       "21               Hospitality  UNITED STATES OF AMERICA         MAILEDIN   \n",
       "22                        IT                     INDIA           ONLINE   \n",
       "23              Construction                    POLAND           ONLINE   \n",
       "24                   Finance                     INDIA           ONLINE   \n",
       "25                        IT                     INDIA           ONLINE   \n",
       "26                        IT                     INDIA           ONLINE   \n",
       "27              Advanced Mfg                     INDIA           ONLINE   \n",
       "28              Advanced Mfg                    FRANCE           ONLINE   \n",
       "29                 Aerospace                     CHINA           ONLINE   \n",
       "...                      ...                       ...              ...   \n",
       "38561           Advanced Mfg                     INDIA           ONLINE   \n",
       "38562                     IT                     INDIA           ONLINE   \n",
       "38563   Educational Services                    JORDAN           ONLINE   \n",
       "38564           Advanced Mfg                     ITALY           ONLINE   \n",
       "38565                     IT                     INDIA           ONLINE   \n",
       "38566                     IT                     INDIA           ONLINE   \n",
       "38567                     IT                     INDIA           ONLINE   \n",
       "38568  Other Economic Sector               SOUTH KOREA           ONLINE   \n",
       "38569                     IT                     INDIA           ONLINE   \n",
       "38570                     IT                    ISRAEL           ONLINE   \n",
       "38571           Advanced Mfg            UNITED KINGDOM           ONLINE   \n",
       "38572                     IT                     INDIA           ONLINE   \n",
       "38573           Advanced Mfg                    ISRAEL           ONLINE   \n",
       "38574  Other Economic Sector                     INDIA           ONLINE   \n",
       "38575  Other Economic Sector               PHILIPPINES           ONLINE   \n",
       "38576                     IT                     INDIA           ONLINE   \n",
       "38577  Other Economic Sector               SOUTH KOREA           ONLINE   \n",
       "38578           Advanced Mfg            UNITED KINGDOM           ONLINE   \n",
       "38579                     IT                     INDIA           ONLINE   \n",
       "38580                     IT                     INDIA           ONLINE   \n",
       "38581   Educational Services                   DENMARK           ONLINE   \n",
       "38582                     IT                     INDIA           ONLINE   \n",
       "38583           Advanced Mfg               SOUTH KOREA           ONLINE   \n",
       "38584                     IT                     INDIA           ONLINE   \n",
       "38585                     IT                     INDIA           ONLINE   \n",
       "38586             Automotive                     INDIA           ONLINE   \n",
       "38587  Other Economic Sector                     INDIA           ONLINE   \n",
       "38588           Advanced Mfg                     INDIA           ONLINE   \n",
       "38589                     IT                     INDIA           ONLINE   \n",
       "38590         Transportation            UNITED KINGDOM           ONLINE   \n",
       "\n",
       "      visa class decision  \n",
       "0            EWI        Y  \n",
       "1           H-1B        Y  \n",
       "2            L-1        Y  \n",
       "3           H-1B        Y  \n",
       "4           H-1B        Y  \n",
       "5           H-1B        Y  \n",
       "6           H-1B        Y  \n",
       "7           H-1B        Y  \n",
       "8           H-1B        Y  \n",
       "9            E-2        Y  \n",
       "10          H-1B        Y  \n",
       "11          H-1B        Y  \n",
       "12          H-1B        Y  \n",
       "13          H-1B        Y  \n",
       "14          H-1B        Y  \n",
       "15          H-1B        Y  \n",
       "16           L-1        Y  \n",
       "17          H-1B        Y  \n",
       "18          H-1B        Y  \n",
       "19           EWI        Y  \n",
       "20           TPS        Y  \n",
       "21          H-1B        Y  \n",
       "22          H-1B        Y  \n",
       "23           B-2        Y  \n",
       "24           L-1        Y  \n",
       "25          H-1B        Y  \n",
       "26          H-1B        Y  \n",
       "27          H-1B        Y  \n",
       "28          H-1B        Y  \n",
       "29          H-1B        Y  \n",
       "...          ...      ...  \n",
       "38561       H-1B        N  \n",
       "38562       H-1B        N  \n",
       "38563       H-1B        N  \n",
       "38564        E-1        N  \n",
       "38565       H-1B        N  \n",
       "38566       H-1B        N  \n",
       "38567       H-1B        N  \n",
       "38568        B-2        N  \n",
       "38569       H-1B        N  \n",
       "38570        E-1        N  \n",
       "38571       H-1B        N  \n",
       "38572       H-1B        N  \n",
       "38573        L-1        N  \n",
       "38574       H-1B        N  \n",
       "38575       H-1B        N  \n",
       "38576       H-1B        N  \n",
       "38577        F-1        N  \n",
       "38578       H-1B        N  \n",
       "38579       H-1B        N  \n",
       "38580       H-1B        N  \n",
       "38581       H-1B        N  \n",
       "38582       H-1B        N  \n",
       "38583       H-1B        N  \n",
       "38584       H-1B        N  \n",
       "38585       H-1B        N  \n",
       "38586       H-1B        N  \n",
       "38587       H-1B        N  \n",
       "38588       H-1B        N  \n",
       "38589       H-1B        N  \n",
       "38590        B-2        N  \n",
       "\n",
       "[38591 rows x 5 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "visa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}