06-datasets-questions/explore_enron_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Starter code for exploring the Enron dataset (emails + finances)\n",
    "\n",
    "Loads up the dataset (pickled dict of dicts)\n",
    "\n",
    "The dataset has the form: `enron_data[\"LASTNAME FIRSTNAME MIDDLEINITIAL\"] = { features_dict }`\n",
    "\n",
    "`{features_dict}` is a dictionary of features associated with that person.\n",
    "\n",
    "You should explore `features_dict` as part of the mini-project, but here's an example to get you started:\n",
    "\n",
    "`enron_data[\"SKILLING JEFFREY K\"][\"bonus\"] = 5600000`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "\n",
    "with open('../17-final-project/final_project_dataset.pkl', 'rb') as f:\n",
    "    enron_data = pickle.load(f)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## ↓↓↓ Your Code Goes Here ↓↓↓"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Number of people: 146\n",
      "Number of features per person: 21\n",
      "How many POI are there?: 18\n",
      "What is the total value of the stock belonging to James Prentice?: 1095040\n",
      "How many email messages do we have from Wesley Colwell to persons of interest?: 11\n",
      "What’s the value of stock options exercised by Jeffrey K Skilling??: 19250000\n",
      "Of these three individuals (Lay, Skilling and Fastow), who took home the most money (largest value of “total_payments” feature)? \n",
      "How many folks in this dataset have a quantified salary? 95\n",
      "What about a known email address? 111\n",
      "How many people in the E+F dataset (as it currently exists) have “NaN” for their total payments? 21\n",
      "What percentage of people in the dataset as a whole is this? 0.14383561643835616\n",
      "How many POIs in the E+F dataset have “NaN” for their total payments? 0\n",
      "What percentage of POIs as a whole is this? 0.0\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'METTS MARK': {'salary': 365788,\n",
       "  'to_messages': 807,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1061827,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 600000,\n",
       "  'email_address': 'mark.metts@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 585062,\n",
       "  'expenses': 94299,\n",
       "  'from_poi_to_this_person': 38,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 29,\n",
       "  'other': 1740,\n",
       "  'from_this_person_to_poi': 1,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 702,\n",
       "  'restricted_stock': 585062,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BAXTER JOHN C': {'salary': 267102,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 1295738,\n",
       "  'total_payments': 5634343,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1200000,\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -1386055,\n",
       "  'total_stock_value': 10623258,\n",
       "  'expenses': 11200,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 6680544,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 2660303,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 1586055,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 3942714,\n",
       "  'director_fees': 'NaN'},\n",
       " 'ELLIOTT STEVEN': {'salary': 170941,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 211725,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 350000,\n",
       "  'email_address': 'steven.elliott@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -400729,\n",
       "  'total_stock_value': 6678735,\n",
       "  'expenses': 78552,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 4890344,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 12961,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 1788391,\n",
       "  'director_fees': 'NaN'},\n",
       " 'CORDES WILLIAM R': {'salary': 'NaN',\n",
       "  'to_messages': 764,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'bill.cordes@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1038185,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 10,\n",
       "  'exercised_stock_options': 651850,\n",
       "  'from_messages': 12,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 58,\n",
       "  'restricted_stock': 386335,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HANNON KEVIN P': {'salary': 243293,\n",
       "  'to_messages': 1045,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 288682,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1500000,\n",
       "  'email_address': 'kevin.hannon@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -3117011,\n",
       "  'total_stock_value': 6391065,\n",
       "  'expenses': 34039,\n",
       "  'from_poi_to_this_person': 32,\n",
       "  'exercised_stock_options': 5538001,\n",
       "  'from_messages': 32,\n",
       "  'other': 11350,\n",
       "  'from_this_person_to_poi': 21,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 1617011,\n",
       "  'shared_receipt_with_poi': 1035,\n",
       "  'restricted_stock': 853064,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MORDAUNT KRISTINA M': {'salary': 267093,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 628522,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 325000,\n",
       "  'email_address': 'kristina.mordaunt@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 208510,\n",
       "  'expenses': 35018,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 1411,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 208510,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MEYER ROCKFORD G': {'salary': 'NaN',\n",
       "  'to_messages': 232,\n",
       "  'deferral_payments': 1848227,\n",
       "  'total_payments': 1848227,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'rockford.meyer@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 955873,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 493489,\n",
       "  'from_messages': 28,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 22,\n",
       "  'restricted_stock': 462384,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MCMAHON JEFFREY': {'salary': 370448,\n",
       "  'to_messages': 2355,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 4099771,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 2600000,\n",
       "  'email_address': 'jeffrey.mcmahon@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1662855,\n",
       "  'expenses': 137108,\n",
       "  'from_poi_to_this_person': 58,\n",
       "  'exercised_stock_options': 1104054,\n",
       "  'from_messages': 48,\n",
       "  'other': 297353,\n",
       "  'from_this_person_to_poi': 26,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 694862,\n",
       "  'shared_receipt_with_poi': 2228,\n",
       "  'restricted_stock': 558801,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HAEDICKE MARK E': {'salary': 374125,\n",
       "  'to_messages': 4009,\n",
       "  'deferral_payments': 2157527,\n",
       "  'total_payments': 3859065,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1150000,\n",
       "  'email_address': 'mark.haedicke@enron.com',\n",
       "  'restricted_stock_deferred': -329825,\n",
       "  'deferred_income': -934484,\n",
       "  'total_stock_value': 803094,\n",
       "  'expenses': 76169,\n",
       "  'from_poi_to_this_person': 180,\n",
       "  'exercised_stock_options': 608750,\n",
       "  'from_messages': 1941,\n",
       "  'other': 52382,\n",
       "  'from_this_person_to_poi': 61,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 983346,\n",
       "  'shared_receipt_with_poi': 1847,\n",
       "  'restricted_stock': 524169,\n",
       "  'director_fees': 'NaN'},\n",
       " 'PIPER GREGORY F': {'salary': 197091,\n",
       "  'to_messages': 1238,\n",
       "  'deferral_payments': 1130036,\n",
       "  'total_payments': 1737629,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 400000,\n",
       "  'email_address': 'greg.piper@enron.com',\n",
       "  'restricted_stock_deferred': -409554,\n",
       "  'deferred_income': -33333,\n",
       "  'total_stock_value': 880290,\n",
       "  'expenses': 43057,\n",
       "  'from_poi_to_this_person': 61,\n",
       "  'exercised_stock_options': 880290,\n",
       "  'from_messages': 222,\n",
       "  'other': 778,\n",
       "  'from_this_person_to_poi': 48,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 742,\n",
       "  'restricted_stock': 409554,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HUMPHREY GENE E': {'salary': 130724,\n",
       "  'to_messages': 128,\n",
       "  'deferral_payments': 2964506,\n",
       "  'total_payments': 3100224,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'gene.humphrey@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2282768,\n",
       "  'expenses': 4994,\n",
       "  'from_poi_to_this_person': 10,\n",
       "  'exercised_stock_options': 2282768,\n",
       "  'from_messages': 17,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 17,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 119,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'NOLES JAMES L': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 774401,\n",
       "  'total_payments': 774401,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -94556,\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 368705,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 463261,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BLACHMAN JEREMY M': {'salary': 248546,\n",
       "  'to_messages': 2475,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2014835,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 850000,\n",
       "  'email_address': 'jeremy.blachman@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 954354,\n",
       "  'expenses': 84208,\n",
       "  'from_poi_to_this_person': 25,\n",
       "  'exercised_stock_options': 765313,\n",
       "  'from_messages': 14,\n",
       "  'other': 272,\n",
       "  'from_this_person_to_poi': 2,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 831809,\n",
       "  'shared_receipt_with_poi': 2326,\n",
       "  'restricted_stock': 189041,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SUNDE MARTIN': {'salary': 257486,\n",
       "  'to_messages': 2647,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1545059,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 700000,\n",
       "  'email_address': 'marty.sunde@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 698920,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 37,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 38,\n",
       "  'other': 111122,\n",
       "  'from_this_person_to_poi': 13,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 476451,\n",
       "  'shared_receipt_with_poi': 2565,\n",
       "  'restricted_stock': 698920,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GIBBS DANA R': {'salary': 'NaN',\n",
       "  'to_messages': 169,\n",
       "  'deferral_payments': 504610,\n",
       "  'total_payments': 966522,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'dana.gibbs@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2218275,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 2218275,\n",
       "  'from_messages': 12,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 461912,\n",
       "  'shared_receipt_with_poi': 23,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'LOWRY CHARLES P': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -153686,\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 372205,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 372205,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 153686,\n",
       "  'director_fees': 'NaN'},\n",
       " 'COLWELL WESLEY': {'salary': 288542,\n",
       "  'to_messages': 1758,\n",
       "  'deferral_payments': 27610,\n",
       "  'total_payments': 1490344,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1200000,\n",
       "  'email_address': 'wes.colwell@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -144062,\n",
       "  'total_stock_value': 698242,\n",
       "  'expenses': 16514,\n",
       "  'from_poi_to_this_person': 240,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 40,\n",
       "  'other': 101740,\n",
       "  'from_this_person_to_poi': 11,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 1132,\n",
       "  'restricted_stock': 698242,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MULLER MARK S': {'salary': 251654,\n",
       "  'to_messages': 136,\n",
       "  'deferral_payments': 842924,\n",
       "  'total_payments': 3202070,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1100000,\n",
       "  'email_address': 's..muller@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -719000,\n",
       "  'total_stock_value': 1416848,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 12,\n",
       "  'exercised_stock_options': 1056320,\n",
       "  'from_messages': 16,\n",
       "  'other': 947,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 1725545,\n",
       "  'shared_receipt_with_poi': 114,\n",
       "  'restricted_stock': 360528,\n",
       "  'director_fees': 'NaN'},\n",
       " 'JACKSON CHARLENE R': {'salary': 288558,\n",
       "  'to_messages': 258,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 551174,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 250000,\n",
       "  'email_address': 'charlene.jackson@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 725735,\n",
       "  'expenses': 10181,\n",
       "  'from_poi_to_this_person': 25,\n",
       "  'exercised_stock_options': 185063,\n",
       "  'from_messages': 56,\n",
       "  'other': 2435,\n",
       "  'from_this_person_to_poi': 19,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 117,\n",
       "  'restricted_stock': 540672,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WESTFAHL RICHARD K': {'salary': 63744,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 762135,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'dick.westfahl@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -10800,\n",
       "  'total_stock_value': 384930,\n",
       "  'expenses': 51870,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 401130,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 256191,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 384930,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WALTERS GARETH W': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 53625,\n",
       "  'total_payments': 87410,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1030329,\n",
       "  'expenses': 33785,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 1030329,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'WALLS JR ROBERT H': {'salary': 357091,\n",
       "  'to_messages': 671,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1798780,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 850000,\n",
       "  'email_address': 'rob.walls@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 5898997,\n",
       "  'expenses': 50936,\n",
       "  'from_poi_to_this_person': 17,\n",
       "  'exercised_stock_options': 4346544,\n",
       "  'from_messages': 146,\n",
       "  'other': 2,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 540751,\n",
       "  'shared_receipt_with_poi': 215,\n",
       "  'restricted_stock': 1552453,\n",
       "  'director_fees': 'NaN'},\n",
       " 'KITCHEN LOUISE': {'salary': 271442,\n",
       "  'to_messages': 8305,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 3471141,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 3100000,\n",
       "  'email_address': 'louise.kitchen@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 547143,\n",
       "  'expenses': 5774,\n",
       "  'from_poi_to_this_person': 251,\n",
       "  'exercised_stock_options': 81042,\n",
       "  'from_messages': 1728,\n",
       "  'other': 93925,\n",
       "  'from_this_person_to_poi': 194,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 3669,\n",
       "  'restricted_stock': 466101,\n",
       "  'director_fees': 'NaN'},\n",
       " 'CHAN RONNIE': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -32460,\n",
       "  'deferred_income': -98784,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 32460,\n",
       "  'director_fees': 98784},\n",
       " 'BELFER ROBERT': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': -102500,\n",
       "  'total_payments': 102500,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 44093,\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': -44093,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 3285,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 3285},\n",
       " 'SHANKMAN JEFFREY A': {'salary': 304110,\n",
       "  'to_messages': 3221,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 3038702,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 2000000,\n",
       "  'email_address': 'jeffrey.shankman@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2072035,\n",
       "  'expenses': 178979,\n",
       "  'from_poi_to_this_person': 94,\n",
       "  'exercised_stock_options': 1441898,\n",
       "  'from_messages': 2681,\n",
       "  'other': 1191,\n",
       "  'from_this_person_to_poi': 83,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 554422,\n",
       "  'shared_receipt_with_poi': 1730,\n",
       "  'restricted_stock': 630137,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WODRASKA JOHN': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 189583,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'john.wodraska@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 189583,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'BERGSIEKER RICHARD P': {'salary': 187922,\n",
       "  'to_messages': 383,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 618850,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 250000,\n",
       "  'email_address': 'rick.bergsieker@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -485813,\n",
       "  'total_stock_value': 659249,\n",
       "  'expenses': 59175,\n",
       "  'from_poi_to_this_person': 4,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 59,\n",
       "  'other': 427316,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 180250,\n",
       "  'shared_receipt_with_poi': 233,\n",
       "  'restricted_stock': 659249,\n",
       "  'director_fees': 'NaN'},\n",
       " 'URQUHART JOHN A': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 228656,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -36666,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 228656,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 36666},\n",
       " 'BIBI PHILIPPE A': {'salary': 213625,\n",
       "  'to_messages': 1607,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2047593,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1000000,\n",
       "  'email_address': 'philippe.bibi@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1843816,\n",
       "  'expenses': 38559,\n",
       "  'from_poi_to_this_person': 23,\n",
       "  'exercised_stock_options': 1465734,\n",
       "  'from_messages': 40,\n",
       "  'other': 425688,\n",
       "  'from_this_person_to_poi': 8,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 369721,\n",
       "  'shared_receipt_with_poi': 1336,\n",
       "  'restricted_stock': 378082,\n",
       "  'director_fees': 'NaN'},\n",
       " 'RIEKER PAULA H': {'salary': 249201,\n",
       "  'to_messages': 1328,\n",
       "  'deferral_payments': 214678,\n",
       "  'total_payments': 1099100,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 700000,\n",
       "  'email_address': 'paula.rieker@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -100000,\n",
       "  'total_stock_value': 1918887,\n",
       "  'expenses': 33271,\n",
       "  'from_poi_to_this_person': 35,\n",
       "  'exercised_stock_options': 1635238,\n",
       "  'from_messages': 82,\n",
       "  'other': 1950,\n",
       "  'from_this_person_to_poi': 48,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 1258,\n",
       "  'restricted_stock': 283649,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WHALEY DAVID A': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 98718,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 98718,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'BECK SALLY W': {'salary': 231330,\n",
       "  'to_messages': 7315,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 969068,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 700000,\n",
       "  'email_address': 'sally.beck@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 126027,\n",
       "  'expenses': 37172,\n",
       "  'from_poi_to_this_person': 144,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 4343,\n",
       "  'other': 566,\n",
       "  'from_this_person_to_poi': 386,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 2639,\n",
       "  'restricted_stock': 126027,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HAUG DAVID L': {'salary': 'NaN',\n",
       "  'to_messages': 573,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 475,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'david.haug@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2217299,\n",
       "  'expenses': 475,\n",
       "  'from_poi_to_this_person': 4,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 19,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 7,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 471,\n",
       "  'restricted_stock': 2217299,\n",
       "  'director_fees': 'NaN'},\n",
       " 'ECHOLS JOHN B': {'salary': 182245,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2692324,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 200000,\n",
       "  'email_address': 'john.echols@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1008941,\n",
       "  'expenses': 21530,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 601438,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 53775,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 2234774,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 407503,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MENDELSOHN JOHN': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 148,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -103750,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 148,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 103750},\n",
       " 'HICKERSON GARY J': {'salary': 211788,\n",
       "  'to_messages': 1320,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2081796,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1700000,\n",
       "  'email_address': 'gary.hickerson@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 441096,\n",
       "  'expenses': 98849,\n",
       "  'from_poi_to_this_person': 40,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 27,\n",
       "  'other': 1936,\n",
       "  'from_this_person_to_poi': 1,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 69223,\n",
       "  'shared_receipt_with_poi': 900,\n",
       "  'restricted_stock': 441096,\n",
       "  'director_fees': 'NaN'},\n",
       " 'CLINE KENNETH W': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -472568,\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 189518,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 662086,\n",
       "  'director_fees': 'NaN'},\n",
       " 'LEWIS RICHARD': {'salary': 'NaN',\n",
       "  'to_messages': 952,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'richard.lewis@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 850477,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 10,\n",
       "  'exercised_stock_options': 850477,\n",
       "  'from_messages': 26,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 739,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'HAYES ROBERT E': {'salary': 'NaN',\n",
       "  'to_messages': 504,\n",
       "  'deferral_payments': 7961,\n",
       "  'total_payments': 7961,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'robert.hayes@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 151418,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 16,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 12,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 50,\n",
       "  'restricted_stock': 151418,\n",
       "  'director_fees': 'NaN'},\n",
       " 'KOPPER MICHAEL J': {'salary': 224305,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2652612,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 800000,\n",
       "  'email_address': 'michael.kopper@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 985032,\n",
       "  'expenses': 118134,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 907502,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 602671,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 985032,\n",
       "  'director_fees': 'NaN'},\n",
       " 'LEFF DANIEL P': {'salary': 273746,\n",
       "  'to_messages': 2822,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2664228,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1000000,\n",
       "  'email_address': 'dan.leff@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 360528,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 67,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 63,\n",
       "  'other': 3083,\n",
       "  'from_this_person_to_poi': 14,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 1387399,\n",
       "  'shared_receipt_with_poi': 2672,\n",
       "  'restricted_stock': 360528,\n",
       "  'director_fees': 'NaN'},\n",
       " 'LAVORATO JOHN J': {'salary': 339288,\n",
       "  'to_messages': 7259,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 10425757,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 8000000,\n",
       "  'email_address': 'john.lavorato@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 5167144,\n",
       "  'expenses': 49537,\n",
       "  'from_poi_to_this_person': 528,\n",
       "  'exercised_stock_options': 4158995,\n",
       "  'from_messages': 2585,\n",
       "  'other': 1552,\n",
       "  'from_this_person_to_poi': 411,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 2035380,\n",
       "  'shared_receipt_with_poi': 3962,\n",
       "  'restricted_stock': 1008149,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BERBERIAN DAVID': {'salary': 216582,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 228474,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'david.berberian@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2493616,\n",
       "  'expenses': 11892,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 1624396,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 869220,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DETMERING TIMOTHY J': {'salary': 210500,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 875307,\n",
       "  'total_payments': 1204583,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 425000,\n",
       "  'email_address': 'timothy.detmering@enron.com',\n",
       "  'restricted_stock_deferred': -315068,\n",
       "  'deferred_income': -775241,\n",
       "  'total_stock_value': 2027865,\n",
       "  'expenses': 52255,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 2027865,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 1105,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 415657,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 315068,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WAKEHAM JOHN': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 213071,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 103773,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 109298},\n",
       " 'POWERS WILLIAM': {'salary': 'NaN',\n",
       "  'to_messages': 653,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'ken.powers@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -17500,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 26,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 12,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 17500},\n",
       " 'GOLD JOSEPH': {'salary': 272880,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2146973,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 750000,\n",
       "  'email_address': 'joe.gold@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 877611,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 436515,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 819288,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 304805,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 441096,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BANNANTINE JAMES M': {'salary': 477,\n",
       "  'to_messages': 566,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 916197,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'james.bannantine@enron.com',\n",
       "  'restricted_stock_deferred': -560222,\n",
       "  'deferred_income': -5104,\n",
       "  'total_stock_value': 5243487,\n",
       "  'expenses': 56301,\n",
       "  'from_poi_to_this_person': 39,\n",
       "  'exercised_stock_options': 4046157,\n",
       "  'from_messages': 29,\n",
       "  'other': 864523,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 465,\n",
       "  'restricted_stock': 1757552,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DUNCAN JOHN H': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 77492,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -25000,\n",
       "  'total_stock_value': 371750,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 371750,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 102492},\n",
       " 'SHAPIRO RICHARD S': {'salary': 269076,\n",
       "  'to_messages': 15149,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1057548,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 650000,\n",
       "  'email_address': 'richard.shapiro@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 987001,\n",
       "  'expenses': 137767,\n",
       "  'from_poi_to_this_person': 74,\n",
       "  'exercised_stock_options': 607837,\n",
       "  'from_messages': 1215,\n",
       "  'other': 705,\n",
       "  'from_this_person_to_poi': 65,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 4527,\n",
       "  'restricted_stock': 379164,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SHERRIFF JOHN R': {'salary': 428780,\n",
       "  'to_messages': 3187,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 4335388,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1500000,\n",
       "  'email_address': 'john.sherriff@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 3128982,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 28,\n",
       "  'exercised_stock_options': 1835558,\n",
       "  'from_messages': 92,\n",
       "  'other': 1852186,\n",
       "  'from_this_person_to_poi': 23,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 554422,\n",
       "  'shared_receipt_with_poi': 2103,\n",
       "  'restricted_stock': 1293424,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SHELBY REX': {'salary': 211844,\n",
       "  'to_messages': 225,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2003885,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 200000,\n",
       "  'email_address': 'rex.shelby@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -4167,\n",
       "  'total_stock_value': 2493616,\n",
       "  'expenses': 22884,\n",
       "  'from_poi_to_this_person': 13,\n",
       "  'exercised_stock_options': 1624396,\n",
       "  'from_messages': 39,\n",
       "  'other': 1573324,\n",
       "  'from_this_person_to_poi': 14,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 91,\n",
       "  'restricted_stock': 869220,\n",
       "  'director_fees': 'NaN'},\n",
       " 'LEMAISTRE CHARLES': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 87492,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -25000,\n",
       "  'total_stock_value': 412878,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 412878,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 112492},\n",
       " 'DEFFNER JOSEPH M': {'salary': 206121,\n",
       "  'to_messages': 714,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1208649,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 600000,\n",
       "  'email_address': 'joseph.deffner@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 159211,\n",
       "  'expenses': 41626,\n",
       "  'from_poi_to_this_person': 115,\n",
       "  'exercised_stock_options': 17378,\n",
       "  'from_messages': 74,\n",
       "  'other': 25553,\n",
       "  'from_this_person_to_poi': 4,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 335349,\n",
       "  'shared_receipt_with_poi': 552,\n",
       "  'restricted_stock': 141833,\n",
       "  'director_fees': 'NaN'},\n",
       " 'KISHKILL JOSEPH G': {'salary': 174246,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 704896,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'joe.kishkill@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -51042,\n",
       "  'total_stock_value': 1034346,\n",
       "  'expenses': 116335,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 465357,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 1034346,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WHALLEY LAWRENCE G': {'salary': 510364,\n",
       "  'to_messages': 6019,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 4677574,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 3000000,\n",
       "  'email_address': 'greg.whalley@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 6079137,\n",
       "  'expenses': 57838,\n",
       "  'from_poi_to_this_person': 186,\n",
       "  'exercised_stock_options': 3282960,\n",
       "  'from_messages': 556,\n",
       "  'other': 301026,\n",
       "  'from_this_person_to_poi': 24,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 808346,\n",
       "  'shared_receipt_with_poi': 3920,\n",
       "  'restricted_stock': 2796177,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MCCONNELL MICHAEL S': {'salary': 365038,\n",
       "  'to_messages': 3329,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2101364,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1100000,\n",
       "  'email_address': 'mike.mcconnell@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 3101279,\n",
       "  'expenses': 81364,\n",
       "  'from_poi_to_this_person': 92,\n",
       "  'exercised_stock_options': 1623010,\n",
       "  'from_messages': 2742,\n",
       "  'other': 540,\n",
       "  'from_this_person_to_poi': 194,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 554422,\n",
       "  'shared_receipt_with_poi': 2189,\n",
       "  'restricted_stock': 1478269,\n",
       "  'director_fees': 'NaN'},\n",
       " 'PIRO JIM': {'salary': 'NaN',\n",
       "  'to_messages': 58,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'jim.piro@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 47304,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 16,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 1,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 3,\n",
       "  'restricted_stock': 47304,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DELAINEY DAVID W': {'salary': 365163,\n",
       "  'to_messages': 3093,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 4747979,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 3000000,\n",
       "  'email_address': 'david.delainey@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 3614261,\n",
       "  'expenses': 86174,\n",
       "  'from_poi_to_this_person': 66,\n",
       "  'exercised_stock_options': 2291113,\n",
       "  'from_messages': 3069,\n",
       "  'other': 1661,\n",
       "  'from_this_person_to_poi': 609,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 1294981,\n",
       "  'shared_receipt_with_poi': 2097,\n",
       "  'restricted_stock': 1323148,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SULLIVAN-SHAKLOVITZ COLLEEN': {'salary': 162779,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 181993,\n",
       "  'total_payments': 999356,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 100000,\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1362375,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 1362375,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 162,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 554422,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'WROBEL BRUCE': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 139130,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 139130,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'LINDHOLM TOD A': {'salary': 236457,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 204075,\n",
       "  'total_payments': 875889,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 200000,\n",
       "  'email_address': 'tod.lindholm@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 3064208,\n",
       "  'expenses': 57727,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 2549361,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 2630,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 175000,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 514847,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MEYER JEROME J': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2151,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -38346,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 2151,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 38346},\n",
       " 'LAY KENNETH L': {'salary': 1072321,\n",
       "  'to_messages': 4273,\n",
       "  'deferral_payments': 202911,\n",
       "  'total_payments': 103559793,\n",
       "  'loan_advances': 81525000,\n",
       "  'bonus': 7000000,\n",
       "  'email_address': 'kenneth.lay@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -300000,\n",
       "  'total_stock_value': 49110078,\n",
       "  'expenses': 99832,\n",
       "  'from_poi_to_this_person': 123,\n",
       "  'exercised_stock_options': 34348384,\n",
       "  'from_messages': 36,\n",
       "  'other': 10359729,\n",
       "  'from_this_person_to_poi': 16,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 3600000,\n",
       "  'shared_receipt_with_poi': 2411,\n",
       "  'restricted_stock': 14761694,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BUTTS ROBERT H': {'salary': 261516,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1271582,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 750000,\n",
       "  'email_address': 'bob.butts@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -75000,\n",
       "  'total_stock_value': 417619,\n",
       "  'expenses': 9410,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 150656,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 175000,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 417619,\n",
       "  'director_fees': 'NaN'},\n",
       " 'OLSON CINDY K': {'salary': 329078,\n",
       "  'to_messages': 1184,\n",
       "  'deferral_payments': 77716,\n",
       "  'total_payments': 1321557,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 750000,\n",
       "  'email_address': 'cindy.olson@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2606763,\n",
       "  'expenses': 63791,\n",
       "  'from_poi_to_this_person': 20,\n",
       "  'exercised_stock_options': 1637034,\n",
       "  'from_messages': 52,\n",
       "  'other': 972,\n",
       "  'from_this_person_to_poi': 15,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 100000,\n",
       "  'shared_receipt_with_poi': 856,\n",
       "  'restricted_stock': 969729,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MCDONALD REBECCA': {'salary': 'NaN',\n",
       "  'to_messages': 894,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'rebecca.mcdonald@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1691366,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 54,\n",
       "  'exercised_stock_options': 757301,\n",
       "  'from_messages': 13,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 1,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 720,\n",
       "  'restricted_stock': 934065,\n",
       "  'director_fees': 'NaN'},\n",
       " 'CUMBERLAND MICHAEL S': {'salary': 184899,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 807956,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 325000,\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 207940,\n",
       "  'expenses': 22344,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 713,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 275000,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 207940,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GAHN ROBERT S': {'salary': 192008,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 73122,\n",
       "  'total_payments': 900585,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 509870,\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -1042,\n",
       "  'total_stock_value': 318607,\n",
       "  'expenses': 50080,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 83237,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 76547,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 235370,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BADUM JAMES P': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 178980,\n",
       "  'total_payments': 182466,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 257817,\n",
       "  'expenses': 3486,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 257817,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'HERMANN ROBERT J': {'salary': 262663,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1297461,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 700000,\n",
       "  'email_address': 'robert.hermann@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -280000,\n",
       "  'total_stock_value': 668132,\n",
       "  'expenses': 48357,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 187500,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 416441,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 150000,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 480632,\n",
       "  'director_fees': 'NaN'},\n",
       " 'FALLON JAMES B': {'salary': 304588,\n",
       "  'to_messages': 1755,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 3676340,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 2500000,\n",
       "  'email_address': 'jim.fallon@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2332399,\n",
       "  'expenses': 95924,\n",
       "  'from_poi_to_this_person': 42,\n",
       "  'exercised_stock_options': 940257,\n",
       "  'from_messages': 75,\n",
       "  'other': 401481,\n",
       "  'from_this_person_to_poi': 37,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 374347,\n",
       "  'shared_receipt_with_poi': 1604,\n",
       "  'restricted_stock': 1392142,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GATHMANN WILLIAM D': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -72419,\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1945360,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 1753766,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 264013,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HORTON STANLEY C': {'salary': 'NaN',\n",
       "  'to_messages': 2350,\n",
       "  'deferral_payments': 3131860,\n",
       "  'total_payments': 3131860,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'stanley.horton@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 7256648,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 44,\n",
       "  'exercised_stock_options': 5210569,\n",
       "  'from_messages': 1073,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 15,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 1074,\n",
       "  'restricted_stock': 2046079,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BOWEN JR RAYMOND M': {'salary': 278601,\n",
       "  'to_messages': 1858,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2669589,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1350000,\n",
       "  'email_address': 'raymond.bowen@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -833,\n",
       "  'total_stock_value': 252055,\n",
       "  'expenses': 65907,\n",
       "  'from_poi_to_this_person': 140,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 27,\n",
       "  'other': 1621,\n",
       "  'from_this_person_to_poi': 15,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 974293,\n",
       "  'shared_receipt_with_poi': 1593,\n",
       "  'restricted_stock': 252055,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GILLIS JOHN': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 85641,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 9803,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 75838,\n",
       "  'director_fees': 'NaN'},\n",
       " 'FITZGERALD JAY L': {'salary': 199157,\n",
       "  'to_messages': 936,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1414857,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 350000,\n",
       "  'email_address': 'jay.fitzgerald@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1621236,\n",
       "  'expenses': 23870,\n",
       "  'from_poi_to_this_person': 1,\n",
       "  'exercised_stock_options': 664461,\n",
       "  'from_messages': 16,\n",
       "  'other': 285414,\n",
       "  'from_this_person_to_poi': 8,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 556416,\n",
       "  'shared_receipt_with_poi': 723,\n",
       "  'restricted_stock': 956775,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MORAN MICHAEL P': {'salary': 'NaN',\n",
       "  'to_messages': 672,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'michael.moran@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 221141,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 59539,\n",
       "  'from_messages': 19,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 127,\n",
       "  'restricted_stock': 161602,\n",
       "  'director_fees': 'NaN'},\n",
       " 'REDMOND BRIAN L': {'salary': 96840,\n",
       "  'to_messages': 1671,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 111529,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'brian.redmond@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 7890324,\n",
       "  'expenses': 14689,\n",
       "  'from_poi_to_this_person': 204,\n",
       "  'exercised_stock_options': 7509039,\n",
       "  'from_messages': 221,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 49,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 1063,\n",
       "  'restricted_stock': 381285,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BAZELIDES PHILIP J': {'salary': 80818,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 684694,\n",
       "  'total_payments': 860136,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1599641,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 1599641,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 874,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 93750,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'BELDEN TIMOTHY N': {'salary': 213999,\n",
       "  'to_messages': 7991,\n",
       "  'deferral_payments': 2144013,\n",
       "  'total_payments': 5501630,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 5249999,\n",
       "  'email_address': 'tim.belden@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -2334434,\n",
       "  'total_stock_value': 1110705,\n",
       "  'expenses': 17355,\n",
       "  'from_poi_to_this_person': 228,\n",
       "  'exercised_stock_options': 953136,\n",
       "  'from_messages': 484,\n",
       "  'other': 210698,\n",
       "  'from_this_person_to_poi': 108,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 5521,\n",
       "  'restricted_stock': 157569,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DIMICHELE RICHARD G': {'salary': 262788,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2368151,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1000000,\n",
       "  'email_address': 'richard.dimichele@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 8317782,\n",
       "  'expenses': 35812,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 8191755,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 374689,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 694862,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 126027,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DURAN WILLIAM D': {'salary': 210692,\n",
       "  'to_messages': 904,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2093263,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 750000,\n",
       "  'email_address': 'w.duran@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1640910,\n",
       "  'expenses': 25785,\n",
       "  'from_poi_to_this_person': 106,\n",
       "  'exercised_stock_options': 1451869,\n",
       "  'from_messages': 12,\n",
       "  'other': 1568,\n",
       "  'from_this_person_to_poi': 3,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 1105218,\n",
       "  'shared_receipt_with_poi': 599,\n",
       "  'restricted_stock': 189041,\n",
       "  'director_fees': 'NaN'},\n",
       " 'THORN TERENCE H': {'salary': 222093,\n",
       "  'to_messages': 266,\n",
       "  'deferral_payments': 16586,\n",
       "  'total_payments': 911453,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'terence.thorn@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 4817796,\n",
       "  'expenses': 46145,\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 4452476,\n",
       "  'from_messages': 41,\n",
       "  'other': 426629,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 200000,\n",
       "  'shared_receipt_with_poi': 73,\n",
       "  'restricted_stock': 365320,\n",
       "  'director_fees': 'NaN'},\n",
       " 'FASTOW ANDREW S': {'salary': 440698,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 2424083,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1300000,\n",
       "  'email_address': 'andrew.fastow@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -1386055,\n",
       "  'total_stock_value': 1794412,\n",
       "  'expenses': 55921,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 277464,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 1736055,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 1794412,\n",
       "  'director_fees': 'NaN'},\n",
       " 'FOY JOE': {'salary': 'NaN',\n",
       "  'to_messages': 57,\n",
       "  'deferral_payments': 181755,\n",
       "  'total_payments': 181755,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'tracy.foy@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 343434,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 343434,\n",
       "  'from_messages': 13,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 2,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'CALGER CHRISTOPHER F': {'salary': 240189,\n",
       "  'to_messages': 2598,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1639297,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1250000,\n",
       "  'email_address': 'christopher.calger@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -262500,\n",
       "  'total_stock_value': 126027,\n",
       "  'expenses': 35818,\n",
       "  'from_poi_to_this_person': 199,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 144,\n",
       "  'other': 486,\n",
       "  'from_this_person_to_poi': 25,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 375304,\n",
       "  'shared_receipt_with_poi': 2188,\n",
       "  'restricted_stock': 126027,\n",
       "  'director_fees': 'NaN'},\n",
       " 'RICE KENNETH D': {'salary': 420636,\n",
       "  'to_messages': 905,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 505050,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1750000,\n",
       "  'email_address': 'ken.rice@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -3504386,\n",
       "  'total_stock_value': 22542539,\n",
       "  'expenses': 46950,\n",
       "  'from_poi_to_this_person': 42,\n",
       "  'exercised_stock_options': 19794175,\n",
       "  'from_messages': 18,\n",
       "  'other': 174839,\n",
       "  'from_this_person_to_poi': 4,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 1617011,\n",
       "  'shared_receipt_with_poi': 864,\n",
       "  'restricted_stock': 2748364,\n",
       "  'director_fees': 'NaN'},\n",
       " 'KAMINSKI WINCENTY J': {'salary': 275101,\n",
       "  'to_messages': 4607,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1086821,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 400000,\n",
       "  'email_address': 'vince.kaminski@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 976037,\n",
       "  'expenses': 83585,\n",
       "  'from_poi_to_this_person': 41,\n",
       "  'exercised_stock_options': 850010,\n",
       "  'from_messages': 14368,\n",
       "  'other': 4669,\n",
       "  'from_this_person_to_poi': 171,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 323466,\n",
       "  'shared_receipt_with_poi': 583,\n",
       "  'restricted_stock': 126027,\n",
       "  'director_fees': 'NaN'},\n",
       " 'LOCKHART EUGENE E': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'COX DAVID': {'salary': 314288,\n",
       "  'to_messages': 102,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1101393,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 800000,\n",
       "  'email_address': 'chip.cox@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -41250,\n",
       "  'total_stock_value': 495633,\n",
       "  'expenses': 27861,\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 117551,\n",
       "  'from_messages': 33,\n",
       "  'other': 494,\n",
       "  'from_this_person_to_poi': 4,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 71,\n",
       "  'restricted_stock': 378082,\n",
       "  'director_fees': 'NaN'},\n",
       " 'OVERDYKE JR JERE C': {'salary': 94941,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 249787,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'jere.overdyke@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 7307594,\n",
       "  'expenses': 18834,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 5266578,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 176,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 135836,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 2041016,\n",
       "  'director_fees': 'NaN'},\n",
       " 'PEREIRA PAULO V. FERRAZ': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 27942,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -101250,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 27942,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 101250},\n",
       " 'STABLER FRANK': {'salary': 239502,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1112087,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 500000,\n",
       "  'email_address': 'frank.stabler@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 511734,\n",
       "  'expenses': 16514,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 356071,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 511734,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SKILLING JEFFREY K': {'salary': 1111258,\n",
       "  'to_messages': 3627,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 8682716,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 5600000,\n",
       "  'email_address': 'jeff.skilling@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 26093672,\n",
       "  'expenses': 29336,\n",
       "  'from_poi_to_this_person': 88,\n",
       "  'exercised_stock_options': 19250000,\n",
       "  'from_messages': 108,\n",
       "  'other': 22122,\n",
       "  'from_this_person_to_poi': 30,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 1920000,\n",
       "  'shared_receipt_with_poi': 2042,\n",
       "  'restricted_stock': 6843672,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BLAKE JR. NORMAN P': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1279,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -113784,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 1279,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 113784},\n",
       " 'SHERRICK JEFFREY B': {'salary': 'NaN',\n",
       "  'to_messages': 613,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'jeffrey.sherrick@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1832468,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 39,\n",
       "  'exercised_stock_options': 1426469,\n",
       "  'from_messages': 25,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 18,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 583,\n",
       "  'restricted_stock': 405999,\n",
       "  'director_fees': 'NaN'},\n",
       " 'PRENTICE JAMES': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 564348,\n",
       "  'total_payments': 564348,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'james.prentice@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1095040,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 886231,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 208809,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GRAY RODNEY': {'salary': 6615,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 93585,\n",
       "  'total_payments': 1146658,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 680833,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 365625,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'THE TRAVEL AGENCY IN THE PARK': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 362096,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 362096,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'UMANOFF ADAM S': {'salary': 288589,\n",
       "  'to_messages': 111,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1130461,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 788750,\n",
       "  'email_address': 'adam.umanoff@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 53122,\n",
       "  'from_poi_to_this_person': 12,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 18,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 41,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'KEAN STEVEN J': {'salary': 404338,\n",
       "  'to_messages': 12754,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1747522,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1000000,\n",
       "  'email_address': 'steven.kean@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 6153642,\n",
       "  'expenses': 41953,\n",
       "  'from_poi_to_this_person': 140,\n",
       "  'exercised_stock_options': 2022048,\n",
       "  'from_messages': 6759,\n",
       "  'other': 1231,\n",
       "  'from_this_person_to_poi': 387,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 300000,\n",
       "  'shared_receipt_with_poi': 3639,\n",
       "  'restricted_stock': 4131594,\n",
       "  'director_fees': 'NaN'},\n",
       " 'TOTAL': {'salary': 26704229,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 32083396,\n",
       "  'total_payments': 309886585,\n",
       "  'loan_advances': 83925000,\n",
       "  'bonus': 97343619,\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -7576788,\n",
       "  'deferred_income': -27992891,\n",
       "  'total_stock_value': 434509511,\n",
       "  'expenses': 5235198,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 311764000,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 42667589,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 48521928,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 130322299,\n",
       "  'director_fees': 1398517},\n",
       " 'FOWLER PEGGY': {'salary': 'NaN',\n",
       "  'to_messages': 517,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'kulvinder.fowler@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1884748,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 1324578,\n",
       "  'from_messages': 36,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 10,\n",
       "  'restricted_stock': 560170,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WASAFF GEORGE': {'salary': 259996,\n",
       "  'to_messages': 400,\n",
       "  'deferral_payments': 831299,\n",
       "  'total_payments': 1034395,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 325000,\n",
       "  'email_address': 'george.wasaff@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -583325,\n",
       "  'total_stock_value': 2056427,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 22,\n",
       "  'exercised_stock_options': 1668260,\n",
       "  'from_messages': 30,\n",
       "  'other': 1425,\n",
       "  'from_this_person_to_poi': 7,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 200000,\n",
       "  'shared_receipt_with_poi': 337,\n",
       "  'restricted_stock': 388167,\n",
       "  'director_fees': 'NaN'},\n",
       " 'WHITE JR THOMAS E': {'salary': 317543,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1934359,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 450000,\n",
       "  'email_address': 'thomas.white@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 15144123,\n",
       "  'expenses': 81353,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 1297049,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 1085463,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 13847074,\n",
       "  'director_fees': 'NaN'},\n",
       " 'CHRISTODOULOU DIOMEDES': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'diomedes.christodoulou@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 6077885,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 5127155,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 950730,\n",
       "  'director_fees': 'NaN'},\n",
       " 'ALLEN PHILLIP K': {'salary': 201955,\n",
       "  'to_messages': 2902,\n",
       "  'deferral_payments': 2869717,\n",
       "  'total_payments': 4484442,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 4175000,\n",
       "  'email_address': 'phillip.allen@enron.com',\n",
       "  'restricted_stock_deferred': -126027,\n",
       "  'deferred_income': -3081055,\n",
       "  'total_stock_value': 1729541,\n",
       "  'expenses': 13868,\n",
       "  'from_poi_to_this_person': 47,\n",
       "  'exercised_stock_options': 1729541,\n",
       "  'from_messages': 2195,\n",
       "  'other': 152,\n",
       "  'from_this_person_to_poi': 65,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 304805,\n",
       "  'shared_receipt_with_poi': 1407,\n",
       "  'restricted_stock': 126027,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SHARP VICTORIA T': {'salary': 248146,\n",
       "  'to_messages': 3136,\n",
       "  'deferral_payments': 187469,\n",
       "  'total_payments': 1576511,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 600000,\n",
       "  'email_address': 'vicki.sharp@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 494136,\n",
       "  'expenses': 116337,\n",
       "  'from_poi_to_this_person': 24,\n",
       "  'exercised_stock_options': 281073,\n",
       "  'from_messages': 136,\n",
       "  'other': 2401,\n",
       "  'from_this_person_to_poi': 6,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 422158,\n",
       "  'shared_receipt_with_poi': 2477,\n",
       "  'restricted_stock': 213063,\n",
       "  'director_fees': 'NaN'},\n",
       " 'JAEDICKE ROBERT': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 83750,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -44093,\n",
       "  'deferred_income': -25000,\n",
       "  'total_stock_value': 431750,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 431750,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 44093,\n",
       "  'director_fees': 108750},\n",
       " 'WINOKUR JR. HERBERT S': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 84992,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -25000,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 1413,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 108579},\n",
       " 'BROWN MICHAEL': {'salary': 'NaN',\n",
       "  'to_messages': 1486,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 49288,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'michael.brown@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 49288,\n",
       "  'from_poi_to_this_person': 13,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 41,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 1,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 761,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'MCCLELLAN GEORGE': {'salary': 263413,\n",
       "  'to_messages': 1744,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1318763,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 900000,\n",
       "  'email_address': 'george.mcclellan@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -125000,\n",
       "  'total_stock_value': 947861,\n",
       "  'expenses': 228763,\n",
       "  'from_poi_to_this_person': 52,\n",
       "  'exercised_stock_options': 506765,\n",
       "  'from_messages': 49,\n",
       "  'other': 51587,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 1469,\n",
       "  'restricted_stock': 441096,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HUGHES JAMES A': {'salary': 'NaN',\n",
       "  'to_messages': 719,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'james.hughes@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1118394,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 35,\n",
       "  'exercised_stock_options': 754966,\n",
       "  'from_messages': 34,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 5,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 589,\n",
       "  'restricted_stock': 363428,\n",
       "  'director_fees': 'NaN'},\n",
       " 'REYNOLDS LAWRENCE': {'salary': 76399,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 51365,\n",
       "  'total_payments': 394475,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 100000,\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': -140264,\n",
       "  'deferred_income': -200000,\n",
       "  'total_stock_value': 4221891,\n",
       "  'expenses': 8409,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 4160672,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 202052,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 156250,\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 201483,\n",
       "  'director_fees': 'NaN'},\n",
       " 'PICKERING MARK R': {'salary': 655037,\n",
       "  'to_messages': 898,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1386690,\n",
       "  'loan_advances': 400000,\n",
       "  'bonus': 300000,\n",
       "  'email_address': 'mark.pickering@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 28798,\n",
       "  'expenses': 31653,\n",
       "  'from_poi_to_this_person': 7,\n",
       "  'exercised_stock_options': 28798,\n",
       "  'from_messages': 67,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 728,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'BHATNAGAR SANJAY': {'salary': 'NaN',\n",
       "  'to_messages': 523,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 15456290,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'sanjay.bhatnagar@enron.com',\n",
       "  'restricted_stock_deferred': 15456290,\n",
       "  'deferred_income': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 2604490,\n",
       "  'from_messages': 29,\n",
       "  'other': 137864,\n",
       "  'from_this_person_to_poi': 1,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 463,\n",
       "  'restricted_stock': -2604490,\n",
       "  'director_fees': 137864},\n",
       " 'CARTER REBECCA C': {'salary': 261809,\n",
       "  'to_messages': 312,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 477557,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 300000,\n",
       "  'email_address': 'rebecca.carter@enron.com',\n",
       "  'restricted_stock_deferred': -307301,\n",
       "  'deferred_income': -159792,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 29,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 15,\n",
       "  'other': 540,\n",
       "  'from_this_person_to_poi': 7,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 75000,\n",
       "  'shared_receipt_with_poi': 196,\n",
       "  'restricted_stock': 307301,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BUCHANAN HAROLD G': {'salary': 248017,\n",
       "  'to_messages': 1088,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1054637,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 500000,\n",
       "  'email_address': 'john.buchanan@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1014505,\n",
       "  'expenses': 600,\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 825464,\n",
       "  'from_messages': 125,\n",
       "  'other': 1215,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 304805,\n",
       "  'shared_receipt_with_poi': 23,\n",
       "  'restricted_stock': 189041,\n",
       "  'director_fees': 'NaN'},\n",
       " 'YEAP SOON': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 55097,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 192758,\n",
       "  'expenses': 55097,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 192758,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'MURRAY JULIA H': {'salary': 229284,\n",
       "  'to_messages': 2192,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 812194,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 400000,\n",
       "  'email_address': 'julia.murray@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 597461,\n",
       "  'expenses': 57580,\n",
       "  'from_poi_to_this_person': 11,\n",
       "  'exercised_stock_options': 400478,\n",
       "  'from_messages': 45,\n",
       "  'other': 330,\n",
       "  'from_this_person_to_poi': 2,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 125000,\n",
       "  'shared_receipt_with_poi': 395,\n",
       "  'restricted_stock': 196983,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GARLAND C KEVIN': {'salary': 231946,\n",
       "  'to_messages': 209,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1566469,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 850000,\n",
       "  'email_address': 'kevin.garland@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 896153,\n",
       "  'expenses': 48405,\n",
       "  'from_poi_to_this_person': 10,\n",
       "  'exercised_stock_options': 636246,\n",
       "  'from_messages': 44,\n",
       "  'other': 60814,\n",
       "  'from_this_person_to_poi': 27,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 375304,\n",
       "  'shared_receipt_with_poi': 178,\n",
       "  'restricted_stock': 259907,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DODSON KEITH': {'salary': 221003,\n",
       "  'to_messages': 176,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 319941,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 70000,\n",
       "  'email_address': 'keith.dodson@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 28164,\n",
       "  'from_poi_to_this_person': 10,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 14,\n",
       "  'other': 774,\n",
       "  'from_this_person_to_poi': 3,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 114,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'YEAGER F SCOTT': {'salary': 158403,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 360300,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'scott.yeager@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 11884758,\n",
       "  'expenses': 53947,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 8308552,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 147950,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 3576206,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HIRKO JOSEPH': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 10259,\n",
       "  'total_payments': 91093,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'joe.hirko@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 30766064,\n",
       "  'expenses': 77978,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 30766064,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 2856,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'DIETRICH JANET R': {'salary': 250100,\n",
       "  'to_messages': 2572,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1410464,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 600000,\n",
       "  'email_address': 'janet.dietrich@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1865087,\n",
       "  'expenses': 3475,\n",
       "  'from_poi_to_this_person': 305,\n",
       "  'exercised_stock_options': 1550019,\n",
       "  'from_messages': 63,\n",
       "  'other': 473,\n",
       "  'from_this_person_to_poi': 14,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 556416,\n",
       "  'shared_receipt_with_poi': 1902,\n",
       "  'restricted_stock': 315068,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DERRICK JR. JAMES V': {'salary': 492375,\n",
       "  'to_messages': 2181,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 550981,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 800000,\n",
       "  'email_address': 'james.derrick@enron.com',\n",
       "  'restricted_stock_deferred': -1787380,\n",
       "  'deferred_income': -1284000,\n",
       "  'total_stock_value': 8831913,\n",
       "  'expenses': 51124,\n",
       "  'from_poi_to_this_person': 64,\n",
       "  'exercised_stock_options': 8831913,\n",
       "  'from_messages': 909,\n",
       "  'other': 7482,\n",
       "  'from_this_person_to_poi': 20,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 484000,\n",
       "  'shared_receipt_with_poi': 1401,\n",
       "  'restricted_stock': 1787380,\n",
       "  'director_fees': 'NaN'},\n",
       " 'FREVERT MARK A': {'salary': 1060932,\n",
       "  'to_messages': 3275,\n",
       "  'deferral_payments': 6426990,\n",
       "  'total_payments': 17252530,\n",
       "  'loan_advances': 2000000,\n",
       "  'bonus': 2000000,\n",
       "  'email_address': 'mark.frevert@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -3367011,\n",
       "  'total_stock_value': 14622185,\n",
       "  'expenses': 86987,\n",
       "  'from_poi_to_this_person': 242,\n",
       "  'exercised_stock_options': 10433518,\n",
       "  'from_messages': 21,\n",
       "  'other': 7427621,\n",
       "  'from_this_person_to_poi': 6,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 1617011,\n",
       "  'shared_receipt_with_poi': 2979,\n",
       "  'restricted_stock': 4188667,\n",
       "  'director_fees': 'NaN'},\n",
       " 'PAI LOU L': {'salary': 261879,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 3123383,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1000000,\n",
       "  'email_address': 'lou.pai@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 23817930,\n",
       "  'expenses': 32047,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 15364167,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 1829457,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 8453763,\n",
       "  'director_fees': 'NaN'},\n",
       " 'HAYSLETT RODERICK J': {'salary': 'NaN',\n",
       "  'to_messages': 2649,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'rod.hayslett@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 346663,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 35,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 1061,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 38,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 571,\n",
       "  'restricted_stock': 346663,\n",
       "  'director_fees': 'NaN'},\n",
       " 'BAY FRANKLIN R': {'salary': 239671,\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 260455,\n",
       "  'total_payments': 827696,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 400000,\n",
       "  'email_address': 'frank.bay@enron.com',\n",
       "  'restricted_stock_deferred': -82782,\n",
       "  'deferred_income': -201641,\n",
       "  'total_stock_value': 63014,\n",
       "  'expenses': 129142,\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 69,\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 145796,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MCCARTY DANNY J': {'salary': 'NaN',\n",
       "  'to_messages': 1433,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'danny.mccarty@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 758931,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 25,\n",
       "  'exercised_stock_options': 664375,\n",
       "  'from_messages': 215,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 2,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 508,\n",
       "  'restricted_stock': 94556,\n",
       "  'director_fees': 'NaN'},\n",
       " 'FUGH JOHN L': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 50591,\n",
       "  'total_payments': 50591,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 176378,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 176378,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'SCRIMSHAW MATTHEW': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 'NaN',\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'matthew.scrimshaw@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 759557,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 759557,\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'KOENIG MARK E': {'salary': 309946,\n",
       "  'to_messages': 2374,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1587421,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 700000,\n",
       "  'email_address': 'mark.koenig@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 1920055,\n",
       "  'expenses': 127017,\n",
       "  'from_poi_to_this_person': 53,\n",
       "  'exercised_stock_options': 671737,\n",
       "  'from_messages': 61,\n",
       "  'other': 150458,\n",
       "  'from_this_person_to_poi': 15,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 300000,\n",
       "  'shared_receipt_with_poi': 2271,\n",
       "  'restricted_stock': 1248318,\n",
       "  'director_fees': 'NaN'},\n",
       " 'SAVAGE FRANK': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 3750,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -121284,\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 125034},\n",
       " 'IZZO LAWRENCE L': {'salary': 85274,\n",
       "  'to_messages': 496,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1979596,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'larry.izzo@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 5819980,\n",
       "  'expenses': 28093,\n",
       "  'from_poi_to_this_person': 28,\n",
       "  'exercised_stock_options': 2165172,\n",
       "  'from_messages': 19,\n",
       "  'other': 1553729,\n",
       "  'from_this_person_to_poi': 5,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 312500,\n",
       "  'shared_receipt_with_poi': 437,\n",
       "  'restricted_stock': 3654808,\n",
       "  'director_fees': 'NaN'},\n",
       " 'TILNEY ELIZABETH A': {'salary': 247338,\n",
       "  'to_messages': 460,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 399393,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 300000,\n",
       "  'email_address': 'elizabeth.tilney@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -575000,\n",
       "  'total_stock_value': 1168042,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 10,\n",
       "  'exercised_stock_options': 591250,\n",
       "  'from_messages': 19,\n",
       "  'other': 152055,\n",
       "  'from_this_person_to_poi': 11,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 275000,\n",
       "  'shared_receipt_with_poi': 379,\n",
       "  'restricted_stock': 576792,\n",
       "  'director_fees': 'NaN'},\n",
       " 'MARTIN AMANDA K': {'salary': 349487,\n",
       "  'to_messages': 1522,\n",
       "  'deferral_payments': 85430,\n",
       "  'total_payments': 8407016,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'a..martin@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 2070306,\n",
       "  'expenses': 8211,\n",
       "  'from_poi_to_this_person': 8,\n",
       "  'exercised_stock_options': 2070306,\n",
       "  'from_messages': 230,\n",
       "  'other': 2818454,\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 5145434,\n",
       "  'shared_receipt_with_poi': 477,\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 'NaN'},\n",
       " 'BUY RICHARD B': {'salary': 330546,\n",
       "  'to_messages': 3523,\n",
       "  'deferral_payments': 649584,\n",
       "  'total_payments': 2355702,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 900000,\n",
       "  'email_address': 'rick.buy@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -694862,\n",
       "  'total_stock_value': 3444470,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 156,\n",
       "  'exercised_stock_options': 2542813,\n",
       "  'from_messages': 1053,\n",
       "  'other': 400572,\n",
       "  'from_this_person_to_poi': 71,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 769862,\n",
       "  'shared_receipt_with_poi': 2333,\n",
       "  'restricted_stock': 901657,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GRAMM WENDY L': {'salary': 'NaN',\n",
       "  'to_messages': 'NaN',\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 119292,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 'NaN',\n",
       "  'email_address': 'NaN',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 'NaN',\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 'NaN',\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 'NaN',\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 'NaN',\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 'NaN',\n",
       "  'restricted_stock': 'NaN',\n",
       "  'director_fees': 119292},\n",
       " 'CAUSEY RICHARD A': {'salary': 415189,\n",
       "  'to_messages': 1892,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1868758,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 1000000,\n",
       "  'email_address': 'richard.causey@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -235000,\n",
       "  'total_stock_value': 2502063,\n",
       "  'expenses': 30674,\n",
       "  'from_poi_to_this_person': 58,\n",
       "  'exercised_stock_options': 'NaN',\n",
       "  'from_messages': 49,\n",
       "  'other': 307895,\n",
       "  'from_this_person_to_poi': 12,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 350000,\n",
       "  'shared_receipt_with_poi': 1585,\n",
       "  'restricted_stock': 2502063,\n",
       "  'director_fees': 'NaN'},\n",
       " 'TAYLOR MITCHELL S': {'salary': 265214,\n",
       "  'to_messages': 533,\n",
       "  'deferral_payments': 227449,\n",
       "  'total_payments': 1092663,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 600000,\n",
       "  'email_address': 'mitchell.taylor@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 3745048,\n",
       "  'expenses': 'NaN',\n",
       "  'from_poi_to_this_person': 0,\n",
       "  'exercised_stock_options': 3181250,\n",
       "  'from_messages': 29,\n",
       "  'other': 'NaN',\n",
       "  'from_this_person_to_poi': 0,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 300,\n",
       "  'restricted_stock': 563798,\n",
       "  'director_fees': 'NaN'},\n",
       " 'DONAHUE JR JEFFREY M': {'salary': 278601,\n",
       "  'to_messages': 865,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 875760,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 800000,\n",
       "  'email_address': 'jeff.donahue@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': -300000,\n",
       "  'total_stock_value': 1080988,\n",
       "  'expenses': 96268,\n",
       "  'from_poi_to_this_person': 188,\n",
       "  'exercised_stock_options': 765920,\n",
       "  'from_messages': 22,\n",
       "  'other': 891,\n",
       "  'from_this_person_to_poi': 11,\n",
       "  'poi': False,\n",
       "  'long_term_incentive': 'NaN',\n",
       "  'shared_receipt_with_poi': 772,\n",
       "  'restricted_stock': 315068,\n",
       "  'director_fees': 'NaN'},\n",
       " 'GLISAN JR BEN F': {'salary': 274975,\n",
       "  'to_messages': 873,\n",
       "  'deferral_payments': 'NaN',\n",
       "  'total_payments': 1272284,\n",
       "  'loan_advances': 'NaN',\n",
       "  'bonus': 600000,\n",
       "  'email_address': 'ben.glisan@enron.com',\n",
       "  'restricted_stock_deferred': 'NaN',\n",
       "  'deferred_income': 'NaN',\n",
       "  'total_stock_value': 778546,\n",
       "  'expenses': 125978,\n",
       "  'from_poi_to_this_person': 52,\n",
       "  'exercised_stock_options': 384728,\n",
       "  'from_messages': 16,\n",
       "  'other': 200308,\n",
       "  'from_this_person_to_poi': 6,\n",
       "  'poi': True,\n",
       "  'long_term_incentive': 71023,\n",
       "  'shared_receipt_with_poi': 874,\n",
       "  'restricted_stock': 393818,\n",
       "  'director_fees': 'NaN'}}"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "    print(\"Number of people: {}\".format(len(enron_data.keys())))\n",
    "    print(\"Number of features per person: {}\".format(len(enron_data['METTS MARK'])))\n",
    "\n",
    "    pois = [person_name for person_name in enron_data if enron_data[person_name][\"poi\"] == True]\n",
    "    print(\"How many POI are there?: {}\".format(len(pois)))\n",
    "\n",
    "    print(\"What is the total value of the stock belonging to James Prentice?: {}\".format(enron_data[\"PRENTICE JAMES\"][\"total_stock_value\"]))\n",
    "    print(\"How many email messages do we have from Wesley Colwell to persons of interest?: {}\".format(enron_data[\"COLWELL WESLEY\"][\"from_this_person_to_poi\"]))\n",
    "    print(\"What’s the value of stock options exercised by Jeffrey K Skilling??: {}\".format(enron_data[\"SKILLING JEFFREY K\"][\"exercised_stock_options\"]))\n",
    "\n",
    "    print(\"Of these three individuals (Lay, Skilling and Fastow), who took home the most money (largest value of “total_payments” feature)? {}\".format(\"\"))\n",
    "    enron_data[\"LAY KENNETH L\"][\"total_payments\"]      # 103,559,793\n",
    "    enron_data[\"SKILLING JEFFREY K\"][\"total_payments\"] # 8,682,716\n",
    "    enron_data[\"FASTOW ANDREW S\"][\"total_payments\"]    # 2,424,083\n",
    "\n",
    "    with_quantified_salary = [person_name for person_name in enron_data if enron_data[person_name][\"salary\"] != 'NaN']\n",
    "    with_known_email = [person_name for person_name in enron_data if enron_data[person_name][\"email_address\"] != 'NaN']\n",
    "    print(\"How many folks in this dataset have a quantified salary? {}\".format(len(with_quantified_salary)))\n",
    "    print(\"What about a known email address? {}\".format(len(with_known_email)))\n",
    "\n",
    "    with_nan_payments = [person_name for person_name in enron_data if enron_data[person_name][\"total_payments\"] == 'NaN']\n",
    "    print(\"How many people in the E+F dataset (as it currently exists) have “NaN” for their total payments? {}\".format(len(with_nan_payments)))\n",
    "    print(\"What percentage of people in the dataset as a whole is this? {}\".format(len(with_nan_payments)/len(enron_data)))\n",
    "\n",
    "    poi_with_nan_payments = [person_name for person_name in enron_data if enron_data[person_name][\"total_payments\"] == 'NaN' and enron_data[person_name][\"poi\"] == True]\n",
    "    print(\"How many POIs in the E+F dataset have “NaN” for their total payments? {}\".format(len(poi_with_nan_payments)))\n",
    "    print(\"What percentage of POIs as a whole is this? {}\".format(len(poi_with_nan_payments)/len(pois)))\n",
    "\n",
    "\n",
    "    enron_data"
   ]
  }
 ],
 "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.8.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}