LBGT+_1.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# features congruent and incongruent to increasing LGBT+ wellbeing"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## references"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- [ILGA](https://ilga.org/maps-sexual-orientation-laws)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import shijian\n",
    "import seaborn as sns\n",
    "\n",
    "%matplotlib inline\n",
    "pd.set_option(\"display.max_columns\", 100)\n",
    "sns.set(context = \"paper\", font = \"monospace\")\n",
    "shijian.setup_Jupyter()"
   ]
  },
  {
   "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>Continent</th>\n",
       "      <th>Continent.1</th>\n",
       "      <th>Country</th>\n",
       "      <th>Legal</th>\n",
       "      <th>Age of consent</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Illegal</th>\n",
       "      <th>Unnamed: 7</th>\n",
       "      <th>Penalising text</th>\n",
       "      <th>Unnamed: 9</th>\n",
       "      <th>Unnamed: 10</th>\n",
       "      <th>Unnamed: 11</th>\n",
       "      <th>Unnamed: 12</th>\n",
       "      <th>Promotion/Morality</th>\n",
       "      <th>Unnamed: 14</th>\n",
       "      <th>Ma.x Sentences (M)onths and (Y)ears</th>\n",
       "      <th>Unnamed: 16</th>\n",
       "      <th>Unnamed: 17</th>\n",
       "      <th>Unnamed: 18</th>\n",
       "      <th>Unnamed: 19</th>\n",
       "      <th>Arrests, prosecutions, etc</th>\n",
       "      <th>Unnamed: 21</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>NRHI - SO-inclusive?</th>\n",
       "      <th>Unnamed: 24</th>\n",
       "      <th>Unnamed: 25</th>\n",
       "      <th>Unnamed: 26</th>\n",
       "      <th>Discrimination protection</th>\n",
       "      <th>Unnamed: 28</th>\n",
       "      <th>Unnamed: 29</th>\n",
       "      <th>Unnamed: 30</th>\n",
       "      <th>Unnamed: 31</th>\n",
       "      <th>Relationship recognition</th>\n",
       "      <th>Unnamed: 33</th>\n",
       "      <th>Unnamed: 34</th>\n",
       "      <th>Unnamed: 35</th>\n",
       "      <th>Unnamed: 36</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>All genders</td>\n",
       "      <td>Equal</td>\n",
       "      <td>Unequal</td>\n",
       "      <td>Male</td>\n",
       "      <td>Female</td>\n",
       "      <td>Sexual act</td>\n",
       "      <td>Sodomy</td>\n",
       "      <td>Against nature</td>\n",
       "      <td>Buggery</td>\n",
       "      <td>Indecency/other</td>\n",
       "      <td>Penal code</td>\n",
       "      <td>Sharia codes</td>\n",
       "      <td>1 M - 2 Y</td>\n",
       "      <td>3 Y - 7 Y</td>\n",
       "      <td>8 Y - 14 Y</td>\n",
       "      <td>15-Y - Life</td>\n",
       "      <td>Death</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Unclear</td>\n",
       "      <td>None</td>\n",
       "      <td>Employ-ment</td>\n",
       "      <td>Const-itution</td>\n",
       "      <td>Other</td>\n",
       "      <td>Hate Crime</td>\n",
       "      <td>Incite-menrt</td>\n",
       "      <td>Marriage</td>\n",
       "      <td>Civil recognition</td>\n",
       "      <td>Minimal CP</td>\n",
       "      <td>Joint adoption</td>\n",
       "      <td>2nd parent adoption</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angola</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>Benin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Benin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Botswana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Continent Continent.1   Country        Legal Age of consent Unnamed: 5  \\\n",
       "0       NaN         NaN       NaN  All genders          Equal    Unequal   \n",
       "1       NaN         NaN   Algeria          NaN            NaN        NaN   \n",
       "2        AF         NaN    Angola          NaN            NaN        NaN   \n",
       "3        AF         NaN     Benin        Benin            NaN      Benin   \n",
       "4        AF         NaN  Botswana          NaN            NaN        NaN   \n",
       "\n",
       "    Illegal Unnamed: 7 Penalising text Unnamed: 9     Unnamed: 10 Unnamed: 11  \\\n",
       "0      Male     Female      Sexual act     Sodomy  Against nature     Buggery   \n",
       "1   Algeria    Algeria         Algeria        NaN             NaN         NaN   \n",
       "2    Angola     Angola             NaN        NaN          Angola         NaN   \n",
       "3       NaN        NaN             NaN        NaN             NaN         NaN   \n",
       "4  Botswana   Botswana             NaN        NaN        Botswana         NaN   \n",
       "\n",
       "       Unnamed: 12 Promotion/Morality   Unnamed: 14  \\\n",
       "0  Indecency/other         Penal code  Sharia codes   \n",
       "1              NaN                NaN       Algeria   \n",
       "2              NaN                NaN           NaN   \n",
       "3              NaN                NaN           NaN   \n",
       "4              NaN                NaN           NaN   \n",
       "\n",
       "  Ma.x Sentences (M)onths and (Y)ears Unnamed: 16 Unnamed: 17  Unnamed: 18  \\\n",
       "0                           1 M - 2 Y   3 Y - 7 Y  8 Y - 14 Y  15-Y - Life   \n",
       "1                                 NaN     Algeria         NaN          NaN   \n",
       "2                                 NaN      Angola         NaN          NaN   \n",
       "3                                 NaN         NaN         NaN          NaN   \n",
       "4                                 NaN    Botswana         NaN          NaN   \n",
       "\n",
       "  Unnamed: 19 Arrests, prosecutions, etc Unnamed: 21 Unnamed: 22  \\\n",
       "0       Death                       Yes          No      Unknown   \n",
       "1         NaN                        NaN     Algeria         NaN   \n",
       "2         NaN                        NaN      Angola         NaN   \n",
       "3         NaN                        NaN         NaN         NaN   \n",
       "4         NaN                        NaN    Botswana         NaN   \n",
       "\n",
       "  NRHI - SO-inclusive?  Unnamed: 24 Unnamed: 25 Unnamed: 26  \\\n",
       "0                   Yes         No      Unclear        None   \n",
       "1                   NaN     Algeria         NaN         NaN   \n",
       "2                Angola         NaN         NaN         NaN   \n",
       "3                   NaN       Benin         NaN         NaN   \n",
       "4              Botswana         NaN         NaN         NaN   \n",
       "\n",
       "  Discrimination protection    Unnamed: 28 Unnamed: 29 Unnamed: 30  \\\n",
       "0               Employ-ment  Const-itution       Other  Hate Crime   \n",
       "1                       NaN            NaN         NaN         NaN   \n",
       "2                    Angola            NaN         NaN         NaN   \n",
       "3                       NaN            NaN         NaN         NaN   \n",
       "4                  Botswana            NaN         NaN         NaN   \n",
       "\n",
       "    Unnamed: 31 Relationship recognition        Unnamed: 33 Unnamed: 34  \\\n",
       "0  Incite-menrt                 Marriage  Civil recognition  Minimal CP   \n",
       "1           NaN                      NaN                NaN         NaN   \n",
       "2           NaN                      NaN                NaN         NaN   \n",
       "3           NaN                      NaN                NaN         NaN   \n",
       "4           NaN                      NaN                NaN         NaN   \n",
       "\n",
       "      Unnamed: 35          Unnamed: 36  \n",
       "0  Joint adoption  2nd parent adoption  \n",
       "1             NaN                  NaN  \n",
       "2             NaN                  NaN  \n",
       "3             NaN                  NaN  \n",
       "4             NaN                  NaN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ILGA_2016_06 = pd.read_excel(\"ILGA_legal_dataset_June_2016_for_public.xlsx\")\n",
    "ILGA_2016_06.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Unnamed: 0</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Unnamed: 2</th>\n",
       "      <th>Unnamed: 3</th>\n",
       "      <th>Unnamed: 4</th>\n",
       "      <th>Unnamed: 5</th>\n",
       "      <th>Unnamed: 6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>Values</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Row Labels</td>\n",
       "      <td>Count of Protection</td>\n",
       "      <td>Count of Protection2</td>\n",
       "      <td>Count of Protection3</td>\n",
       "      <td>Count of Protection4</td>\n",
       "      <td>Count of Protection5</td>\n",
       "      <td>Count of Protection6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Albania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Unnamed: 0           Unnamed: 1            Unnamed: 2  \\\n",
       "0          NaN               Values                   NaN   \n",
       "1   Row Labels  Count of Protection  Count of Protection2   \n",
       "2  Afghanistan                  NaN                   NaN   \n",
       "3     Albania                   NaN                     1   \n",
       "4      Algeria                  NaN                   NaN   \n",
       "\n",
       "             Unnamed: 3            Unnamed: 4            Unnamed: 5  \\\n",
       "0                   NaN                   NaN                   NaN   \n",
       "1  Count of Protection3  Count of Protection4  Count of Protection5   \n",
       "2                   NaN                   NaN                   NaN   \n",
       "3                     1                     1                     1   \n",
       "4                   NaN                   NaN                   NaN   \n",
       "\n",
       "             Unnamed: 6  \n",
       "0                   NaN  \n",
       "1  Count of Protection6  \n",
       "2                   NaN  \n",
       "3                   NaN  \n",
       "4                   NaN  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ILGA_2017_05 = pd.read_excel(\"ILGA_sexual_orientation_legal_dataset_May_2017.xlsx\")\n",
    "ILGA_2017_05.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}