1. Context
In late 2001, Enron, an American energy company, filed for bankruptcy after one of the largest financial scandals in corporate history. After the company's collapse, over 600,000 emails generated by 158 Enron employees - now known as the Enron Corpus - were acquired by the Federal Energy Regulatory Commission during its investigation. The data was then uploaded online, and since then, a number of people and organizations have graciously prepared, cleaned and organized the dataset that is available to the public today (a few years later, financial data of top Enron executives were released following their trial).
2. Project
The aim of this project is to apply machine learning techniques to build a predictive model that identifies Enron employees that may have committed fraud based on their financial and email data.
The objective is to get a precision and recall score of at least 0.42
import sys
import pickle
sys.path.append("../tools/")
from feature_format import featureFormat, targetFeatureSplit
from tester import dump_classifier_and_data
import pandas as pd
import sys
import pickle
import csv
import matplotlib.pyplot as plt
sys.path.append("../tools/")
from feature_format import featureFormat, targetFeatureSplit
#from poi_data import *
from sklearn.feature_selection import SelectKBest
from sklearn.pipeline import Pipeline
from sklearn.preprocessing import StandardScaler
from sklearn.model_selection import StratifiedShuffleSplit
from numpy import mean
from sklearn.model_selection import train_test_split
from sklearn.model_selection import cross_validate
from sklearn.metrics import accuracy_score, precision_score, recall_score
target_label = 'poi'
email_features_list = [
'from_messages',
'from_poi_to_this_person',
'from_this_person_to_poi',
'shared_receipt_with_poi',
'to_messages',
]
financial_features_list = [
'bonus',
'deferral_payments',
'deferred_income',
'director_fees',
'exercised_stock_options',
'expenses',
'loan_advances',
'long_term_incentive',
'other',
'restricted_stock',
'restricted_stock_deferred',
'salary',
'total_payments',
'total_stock_value',
]
features_list = [target_label] + financial_features_list + email_features_list
print(features_list)
['poi', 'bonus', 'deferral_payments', 'deferred_income', 'director_fees', 'exercised_stock_options', 'expenses', 'loan_advances', 'long_term_incentive', 'other', 'restricted_stock', 'restricted_stock_deferred', 'salary', 'total_payments', 'total_stock_value', 'from_messages', 'from_poi_to_this_person', 'from_this_person_to_poi', 'shared_receipt_with_poi', 'to_messages']
### Load the dictionary containing the dataset
with open("final_project_dataset.pkl", "rb") as data_file:
data_dict = pickle.load(data_file)
### 1.1.0 Explore csv file
def make_csv(data_dict):
""" generates a csv file from a data set"""
fieldnames = ['name'] + data_dict.itervalues().next().keys()
with open('data.csv', 'w') as csvfile:
writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
writer.writeheader()
for record in data_dict:
person = data_dict[record]
person['name'] = record
assert set(person.keys()) == set(fieldnames)
writer.writerow(person)
# Data dictionary complete
data_dict
{'METTS MARK': {'salary': 365788,
'to_messages': 807,
'deferral_payments': 'NaN',
'total_payments': 1061827,
'loan_advances': 'NaN',
'bonus': 600000,
'email_address': 'mark.metts@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 585062,
'expenses': 94299,
'from_poi_to_this_person': 38,
'exercised_stock_options': 'NaN',
'from_messages': 29,
'other': 1740,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 702,
'restricted_stock': 585062,
'director_fees': 'NaN'},
'BAXTER JOHN C': {'salary': 267102,
'to_messages': 'NaN',
'deferral_payments': 1295738,
'total_payments': 5634343,
'loan_advances': 'NaN',
'bonus': 1200000,
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -1386055,
'total_stock_value': 10623258,
'expenses': 11200,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 6680544,
'from_messages': 'NaN',
'other': 2660303,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 1586055,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 3942714,
'director_fees': 'NaN'},
'ELLIOTT STEVEN': {'salary': 170941,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 211725,
'loan_advances': 'NaN',
'bonus': 350000,
'email_address': 'steven.elliott@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -400729,
'total_stock_value': 6678735,
'expenses': 78552,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 4890344,
'from_messages': 'NaN',
'other': 12961,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 1788391,
'director_fees': 'NaN'},
'CORDES WILLIAM R': {'salary': 'NaN',
'to_messages': 764,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'bill.cordes@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1038185,
'expenses': 'NaN',
'from_poi_to_this_person': 10,
'exercised_stock_options': 651850,
'from_messages': 12,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 58,
'restricted_stock': 386335,
'director_fees': 'NaN'},
'HANNON KEVIN P': {'salary': 243293,
'to_messages': 1045,
'deferral_payments': 'NaN',
'total_payments': 288682,
'loan_advances': 'NaN',
'bonus': 1500000,
'email_address': 'kevin.hannon@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -3117011,
'total_stock_value': 6391065,
'expenses': 34039,
'from_poi_to_this_person': 32,
'exercised_stock_options': 5538001,
'from_messages': 32,
'other': 11350,
'from_this_person_to_poi': 21,
'poi': True,
'long_term_incentive': 1617011,
'shared_receipt_with_poi': 1035,
'restricted_stock': 853064,
'director_fees': 'NaN'},
'MORDAUNT KRISTINA M': {'salary': 267093,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 628522,
'loan_advances': 'NaN',
'bonus': 325000,
'email_address': 'kristina.mordaunt@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 208510,
'expenses': 35018,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 1411,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 208510,
'director_fees': 'NaN'},
'MEYER ROCKFORD G': {'salary': 'NaN',
'to_messages': 232,
'deferral_payments': 1848227,
'total_payments': 1848227,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'rockford.meyer@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 955873,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 493489,
'from_messages': 28,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 22,
'restricted_stock': 462384,
'director_fees': 'NaN'},
'MCMAHON JEFFREY': {'salary': 370448,
'to_messages': 2355,
'deferral_payments': 'NaN',
'total_payments': 4099771,
'loan_advances': 'NaN',
'bonus': 2600000,
'email_address': 'jeffrey.mcmahon@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1662855,
'expenses': 137108,
'from_poi_to_this_person': 58,
'exercised_stock_options': 1104054,
'from_messages': 48,
'other': 297353,
'from_this_person_to_poi': 26,
'poi': False,
'long_term_incentive': 694862,
'shared_receipt_with_poi': 2228,
'restricted_stock': 558801,
'director_fees': 'NaN'},
'HAEDICKE MARK E': {'salary': 374125,
'to_messages': 4009,
'deferral_payments': 2157527,
'total_payments': 3859065,
'loan_advances': 'NaN',
'bonus': 1150000,
'email_address': 'mark.haedicke@enron.com',
'restricted_stock_deferred': -329825,
'deferred_income': -934484,
'total_stock_value': 803094,
'expenses': 76169,
'from_poi_to_this_person': 180,
'exercised_stock_options': 608750,
'from_messages': 1941,
'other': 52382,
'from_this_person_to_poi': 61,
'poi': False,
'long_term_incentive': 983346,
'shared_receipt_with_poi': 1847,
'restricted_stock': 524169,
'director_fees': 'NaN'},
'PIPER GREGORY F': {'salary': 197091,
'to_messages': 1238,
'deferral_payments': 1130036,
'total_payments': 1737629,
'loan_advances': 'NaN',
'bonus': 400000,
'email_address': 'greg.piper@enron.com',
'restricted_stock_deferred': -409554,
'deferred_income': -33333,
'total_stock_value': 880290,
'expenses': 43057,
'from_poi_to_this_person': 61,
'exercised_stock_options': 880290,
'from_messages': 222,
'other': 778,
'from_this_person_to_poi': 48,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 742,
'restricted_stock': 409554,
'director_fees': 'NaN'},
'HUMPHREY GENE E': {'salary': 130724,
'to_messages': 128,
'deferral_payments': 2964506,
'total_payments': 3100224,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'gene.humphrey@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2282768,
'expenses': 4994,
'from_poi_to_this_person': 10,
'exercised_stock_options': 2282768,
'from_messages': 17,
'other': 'NaN',
'from_this_person_to_poi': 17,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 119,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'NOLES JAMES L': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 774401,
'total_payments': 774401,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': -94556,
'deferred_income': 'NaN',
'total_stock_value': 368705,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 463261,
'director_fees': 'NaN'},
'BLACHMAN JEREMY M': {'salary': 248546,
'to_messages': 2475,
'deferral_payments': 'NaN',
'total_payments': 2014835,
'loan_advances': 'NaN',
'bonus': 850000,
'email_address': 'jeremy.blachman@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 954354,
'expenses': 84208,
'from_poi_to_this_person': 25,
'exercised_stock_options': 765313,
'from_messages': 14,
'other': 272,
'from_this_person_to_poi': 2,
'poi': False,
'long_term_incentive': 831809,
'shared_receipt_with_poi': 2326,
'restricted_stock': 189041,
'director_fees': 'NaN'},
'SUNDE MARTIN': {'salary': 257486,
'to_messages': 2647,
'deferral_payments': 'NaN',
'total_payments': 1545059,
'loan_advances': 'NaN',
'bonus': 700000,
'email_address': 'marty.sunde@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 698920,
'expenses': 'NaN',
'from_poi_to_this_person': 37,
'exercised_stock_options': 'NaN',
'from_messages': 38,
'other': 111122,
'from_this_person_to_poi': 13,
'poi': False,
'long_term_incentive': 476451,
'shared_receipt_with_poi': 2565,
'restricted_stock': 698920,
'director_fees': 'NaN'},
'GIBBS DANA R': {'salary': 'NaN',
'to_messages': 169,
'deferral_payments': 504610,
'total_payments': 966522,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'dana.gibbs@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2218275,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 2218275,
'from_messages': 12,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 461912,
'shared_receipt_with_poi': 23,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'LOWRY CHARLES P': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': -153686,
'deferred_income': 'NaN',
'total_stock_value': 372205,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 372205,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 153686,
'director_fees': 'NaN'},
'COLWELL WESLEY': {'salary': 288542,
'to_messages': 1758,
'deferral_payments': 27610,
'total_payments': 1490344,
'loan_advances': 'NaN',
'bonus': 1200000,
'email_address': 'wes.colwell@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -144062,
'total_stock_value': 698242,
'expenses': 16514,
'from_poi_to_this_person': 240,
'exercised_stock_options': 'NaN',
'from_messages': 40,
'other': 101740,
'from_this_person_to_poi': 11,
'poi': True,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 1132,
'restricted_stock': 698242,
'director_fees': 'NaN'},
'MULLER MARK S': {'salary': 251654,
'to_messages': 136,
'deferral_payments': 842924,
'total_payments': 3202070,
'loan_advances': 'NaN',
'bonus': 1100000,
'email_address': 's..muller@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -719000,
'total_stock_value': 1416848,
'expenses': 'NaN',
'from_poi_to_this_person': 12,
'exercised_stock_options': 1056320,
'from_messages': 16,
'other': 947,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 1725545,
'shared_receipt_with_poi': 114,
'restricted_stock': 360528,
'director_fees': 'NaN'},
'JACKSON CHARLENE R': {'salary': 288558,
'to_messages': 258,
'deferral_payments': 'NaN',
'total_payments': 551174,
'loan_advances': 'NaN',
'bonus': 250000,
'email_address': 'charlene.jackson@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 725735,
'expenses': 10181,
'from_poi_to_this_person': 25,
'exercised_stock_options': 185063,
'from_messages': 56,
'other': 2435,
'from_this_person_to_poi': 19,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 117,
'restricted_stock': 540672,
'director_fees': 'NaN'},
'WESTFAHL RICHARD K': {'salary': 63744,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 762135,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'dick.westfahl@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -10800,
'total_stock_value': 384930,
'expenses': 51870,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 401130,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 256191,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 384930,
'director_fees': 'NaN'},
'WALTERS GARETH W': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 53625,
'total_payments': 87410,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1030329,
'expenses': 33785,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 1030329,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'WALLS JR ROBERT H': {'salary': 357091,
'to_messages': 671,
'deferral_payments': 'NaN',
'total_payments': 1798780,
'loan_advances': 'NaN',
'bonus': 850000,
'email_address': 'rob.walls@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 5898997,
'expenses': 50936,
'from_poi_to_this_person': 17,
'exercised_stock_options': 4346544,
'from_messages': 146,
'other': 2,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 540751,
'shared_receipt_with_poi': 215,
'restricted_stock': 1552453,
'director_fees': 'NaN'},
'KITCHEN LOUISE': {'salary': 271442,
'to_messages': 8305,
'deferral_payments': 'NaN',
'total_payments': 3471141,
'loan_advances': 'NaN',
'bonus': 3100000,
'email_address': 'louise.kitchen@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 547143,
'expenses': 5774,
'from_poi_to_this_person': 251,
'exercised_stock_options': 81042,
'from_messages': 1728,
'other': 93925,
'from_this_person_to_poi': 194,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 3669,
'restricted_stock': 466101,
'director_fees': 'NaN'},
'CHAN RONNIE': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': -32460,
'deferred_income': -98784,
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 32460,
'director_fees': 98784},
'BELFER ROBERT': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': -102500,
'total_payments': 102500,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 44093,
'deferred_income': 'NaN',
'total_stock_value': -44093,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 3285,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 3285},
'SHANKMAN JEFFREY A': {'salary': 304110,
'to_messages': 3221,
'deferral_payments': 'NaN',
'total_payments': 3038702,
'loan_advances': 'NaN',
'bonus': 2000000,
'email_address': 'jeffrey.shankman@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2072035,
'expenses': 178979,
'from_poi_to_this_person': 94,
'exercised_stock_options': 1441898,
'from_messages': 2681,
'other': 1191,
'from_this_person_to_poi': 83,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 1730,
'restricted_stock': 630137,
'director_fees': 'NaN'},
'WODRASKA JOHN': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 189583,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'john.wodraska@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 189583,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'BERGSIEKER RICHARD P': {'salary': 187922,
'to_messages': 383,
'deferral_payments': 'NaN',
'total_payments': 618850,
'loan_advances': 'NaN',
'bonus': 250000,
'email_address': 'rick.bergsieker@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -485813,
'total_stock_value': 659249,
'expenses': 59175,
'from_poi_to_this_person': 4,
'exercised_stock_options': 'NaN',
'from_messages': 59,
'other': 427316,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 180250,
'shared_receipt_with_poi': 233,
'restricted_stock': 659249,
'director_fees': 'NaN'},
'URQUHART JOHN A': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 228656,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -36666,
'total_stock_value': 'NaN',
'expenses': 228656,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 36666},
'BIBI PHILIPPE A': {'salary': 213625,
'to_messages': 1607,
'deferral_payments': 'NaN',
'total_payments': 2047593,
'loan_advances': 'NaN',
'bonus': 1000000,
'email_address': 'philippe.bibi@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1843816,
'expenses': 38559,
'from_poi_to_this_person': 23,
'exercised_stock_options': 1465734,
'from_messages': 40,
'other': 425688,
'from_this_person_to_poi': 8,
'poi': False,
'long_term_incentive': 369721,
'shared_receipt_with_poi': 1336,
'restricted_stock': 378082,
'director_fees': 'NaN'},
'RIEKER PAULA H': {'salary': 249201,
'to_messages': 1328,
'deferral_payments': 214678,
'total_payments': 1099100,
'loan_advances': 'NaN',
'bonus': 700000,
'email_address': 'paula.rieker@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -100000,
'total_stock_value': 1918887,
'expenses': 33271,
'from_poi_to_this_person': 35,
'exercised_stock_options': 1635238,
'from_messages': 82,
'other': 1950,
'from_this_person_to_poi': 48,
'poi': True,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 1258,
'restricted_stock': 283649,
'director_fees': 'NaN'},
'WHALEY DAVID A': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 98718,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 98718,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'BECK SALLY W': {'salary': 231330,
'to_messages': 7315,
'deferral_payments': 'NaN',
'total_payments': 969068,
'loan_advances': 'NaN',
'bonus': 700000,
'email_address': 'sally.beck@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 126027,
'expenses': 37172,
'from_poi_to_this_person': 144,
'exercised_stock_options': 'NaN',
'from_messages': 4343,
'other': 566,
'from_this_person_to_poi': 386,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 2639,
'restricted_stock': 126027,
'director_fees': 'NaN'},
'HAUG DAVID L': {'salary': 'NaN',
'to_messages': 573,
'deferral_payments': 'NaN',
'total_payments': 475,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'david.haug@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2217299,
'expenses': 475,
'from_poi_to_this_person': 4,
'exercised_stock_options': 'NaN',
'from_messages': 19,
'other': 'NaN',
'from_this_person_to_poi': 7,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 471,
'restricted_stock': 2217299,
'director_fees': 'NaN'},
'ECHOLS JOHN B': {'salary': 182245,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 2692324,
'loan_advances': 'NaN',
'bonus': 200000,
'email_address': 'john.echols@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1008941,
'expenses': 21530,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 601438,
'from_messages': 'NaN',
'other': 53775,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 2234774,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 407503,
'director_fees': 'NaN'},
'MENDELSOHN JOHN': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 148,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -103750,
'total_stock_value': 'NaN',
'expenses': 148,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 103750},
'HICKERSON GARY J': {'salary': 211788,
'to_messages': 1320,
'deferral_payments': 'NaN',
'total_payments': 2081796,
'loan_advances': 'NaN',
'bonus': 1700000,
'email_address': 'gary.hickerson@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 441096,
'expenses': 98849,
'from_poi_to_this_person': 40,
'exercised_stock_options': 'NaN',
'from_messages': 27,
'other': 1936,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 69223,
'shared_receipt_with_poi': 900,
'restricted_stock': 441096,
'director_fees': 'NaN'},
'CLINE KENNETH W': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': -472568,
'deferred_income': 'NaN',
'total_stock_value': 189518,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 662086,
'director_fees': 'NaN'},
'LEWIS RICHARD': {'salary': 'NaN',
'to_messages': 952,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'richard.lewis@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 850477,
'expenses': 'NaN',
'from_poi_to_this_person': 10,
'exercised_stock_options': 850477,
'from_messages': 26,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 739,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'HAYES ROBERT E': {'salary': 'NaN',
'to_messages': 504,
'deferral_payments': 7961,
'total_payments': 7961,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'robert.hayes@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 151418,
'expenses': 'NaN',
'from_poi_to_this_person': 16,
'exercised_stock_options': 'NaN',
'from_messages': 12,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 50,
'restricted_stock': 151418,
'director_fees': 'NaN'},
'KOPPER MICHAEL J': {'salary': 224305,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 2652612,
'loan_advances': 'NaN',
'bonus': 800000,
'email_address': 'michael.kopper@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 985032,
'expenses': 118134,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 907502,
'from_this_person_to_poi': 'NaN',
'poi': True,
'long_term_incentive': 602671,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 985032,
'director_fees': 'NaN'},
'LEFF DANIEL P': {'salary': 273746,
'to_messages': 2822,
'deferral_payments': 'NaN',
'total_payments': 2664228,
'loan_advances': 'NaN',
'bonus': 1000000,
'email_address': 'dan.leff@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 360528,
'expenses': 'NaN',
'from_poi_to_this_person': 67,
'exercised_stock_options': 'NaN',
'from_messages': 63,
'other': 3083,
'from_this_person_to_poi': 14,
'poi': False,
'long_term_incentive': 1387399,
'shared_receipt_with_poi': 2672,
'restricted_stock': 360528,
'director_fees': 'NaN'},
'LAVORATO JOHN J': {'salary': 339288,
'to_messages': 7259,
'deferral_payments': 'NaN',
'total_payments': 10425757,
'loan_advances': 'NaN',
'bonus': 8000000,
'email_address': 'john.lavorato@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 5167144,
'expenses': 49537,
'from_poi_to_this_person': 528,
'exercised_stock_options': 4158995,
'from_messages': 2585,
'other': 1552,
'from_this_person_to_poi': 411,
'poi': False,
'long_term_incentive': 2035380,
'shared_receipt_with_poi': 3962,
'restricted_stock': 1008149,
'director_fees': 'NaN'},
'BERBERIAN DAVID': {'salary': 216582,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 228474,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'david.berberian@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2493616,
'expenses': 11892,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 1624396,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 869220,
'director_fees': 'NaN'},
'DETMERING TIMOTHY J': {'salary': 210500,
'to_messages': 'NaN',
'deferral_payments': 875307,
'total_payments': 1204583,
'loan_advances': 'NaN',
'bonus': 425000,
'email_address': 'timothy.detmering@enron.com',
'restricted_stock_deferred': -315068,
'deferred_income': -775241,
'total_stock_value': 2027865,
'expenses': 52255,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 2027865,
'from_messages': 'NaN',
'other': 1105,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 415657,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 315068,
'director_fees': 'NaN'},
'WAKEHAM JOHN': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 213071,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 103773,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 109298},
'POWERS WILLIAM': {'salary': 'NaN',
'to_messages': 653,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'ken.powers@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -17500,
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 'NaN',
'from_messages': 26,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 12,
'restricted_stock': 'NaN',
'director_fees': 17500},
'GOLD JOSEPH': {'salary': 272880,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 2146973,
'loan_advances': 'NaN',
'bonus': 750000,
'email_address': 'joe.gold@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 877611,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 436515,
'from_messages': 'NaN',
'other': 819288,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 304805,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 441096,
'director_fees': 'NaN'},
'BANNANTINE JAMES M': {'salary': 477,
'to_messages': 566,
'deferral_payments': 'NaN',
'total_payments': 916197,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'james.bannantine@enron.com',
'restricted_stock_deferred': -560222,
'deferred_income': -5104,
'total_stock_value': 5243487,
'expenses': 56301,
'from_poi_to_this_person': 39,
'exercised_stock_options': 4046157,
'from_messages': 29,
'other': 864523,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 465,
'restricted_stock': 1757552,
'director_fees': 'NaN'},
'DUNCAN JOHN H': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 77492,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -25000,
'total_stock_value': 371750,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 371750,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 102492},
'SHAPIRO RICHARD S': {'salary': 269076,
'to_messages': 15149,
'deferral_payments': 'NaN',
'total_payments': 1057548,
'loan_advances': 'NaN',
'bonus': 650000,
'email_address': 'richard.shapiro@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 987001,
'expenses': 137767,
'from_poi_to_this_person': 74,
'exercised_stock_options': 607837,
'from_messages': 1215,
'other': 705,
'from_this_person_to_poi': 65,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 4527,
'restricted_stock': 379164,
'director_fees': 'NaN'},
'SHERRIFF JOHN R': {'salary': 428780,
'to_messages': 3187,
'deferral_payments': 'NaN',
'total_payments': 4335388,
'loan_advances': 'NaN',
'bonus': 1500000,
'email_address': 'john.sherriff@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 3128982,
'expenses': 'NaN',
'from_poi_to_this_person': 28,
'exercised_stock_options': 1835558,
'from_messages': 92,
'other': 1852186,
'from_this_person_to_poi': 23,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 2103,
'restricted_stock': 1293424,
'director_fees': 'NaN'},
'SHELBY REX': {'salary': 211844,
'to_messages': 225,
'deferral_payments': 'NaN',
'total_payments': 2003885,
'loan_advances': 'NaN',
'bonus': 200000,
'email_address': 'rex.shelby@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -4167,
'total_stock_value': 2493616,
'expenses': 22884,
'from_poi_to_this_person': 13,
'exercised_stock_options': 1624396,
'from_messages': 39,
'other': 1573324,
'from_this_person_to_poi': 14,
'poi': True,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 91,
'restricted_stock': 869220,
'director_fees': 'NaN'},
'LEMAISTRE CHARLES': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 87492,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -25000,
'total_stock_value': 412878,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 412878,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 112492},
'DEFFNER JOSEPH M': {'salary': 206121,
'to_messages': 714,
'deferral_payments': 'NaN',
'total_payments': 1208649,
'loan_advances': 'NaN',
'bonus': 600000,
'email_address': 'joseph.deffner@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 159211,
'expenses': 41626,
'from_poi_to_this_person': 115,
'exercised_stock_options': 17378,
'from_messages': 74,
'other': 25553,
'from_this_person_to_poi': 4,
'poi': False,
'long_term_incentive': 335349,
'shared_receipt_with_poi': 552,
'restricted_stock': 141833,
'director_fees': 'NaN'},
'KISHKILL JOSEPH G': {'salary': 174246,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 704896,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'joe.kishkill@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -51042,
'total_stock_value': 1034346,
'expenses': 116335,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 465357,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 1034346,
'director_fees': 'NaN'},
'WHALLEY LAWRENCE G': {'salary': 510364,
'to_messages': 6019,
'deferral_payments': 'NaN',
'total_payments': 4677574,
'loan_advances': 'NaN',
'bonus': 3000000,
'email_address': 'greg.whalley@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 6079137,
'expenses': 57838,
'from_poi_to_this_person': 186,
'exercised_stock_options': 3282960,
'from_messages': 556,
'other': 301026,
'from_this_person_to_poi': 24,
'poi': False,
'long_term_incentive': 808346,
'shared_receipt_with_poi': 3920,
'restricted_stock': 2796177,
'director_fees': 'NaN'},
'MCCONNELL MICHAEL S': {'salary': 365038,
'to_messages': 3329,
'deferral_payments': 'NaN',
'total_payments': 2101364,
'loan_advances': 'NaN',
'bonus': 1100000,
'email_address': 'mike.mcconnell@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 3101279,
'expenses': 81364,
'from_poi_to_this_person': 92,
'exercised_stock_options': 1623010,
'from_messages': 2742,
'other': 540,
'from_this_person_to_poi': 194,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 2189,
'restricted_stock': 1478269,
'director_fees': 'NaN'},
'PIRO JIM': {'salary': 'NaN',
'to_messages': 58,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'jim.piro@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 47304,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 'NaN',
'from_messages': 16,
'other': 'NaN',
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 3,
'restricted_stock': 47304,
'director_fees': 'NaN'},
'DELAINEY DAVID W': {'salary': 365163,
'to_messages': 3093,
'deferral_payments': 'NaN',
'total_payments': 4747979,
'loan_advances': 'NaN',
'bonus': 3000000,
'email_address': 'david.delainey@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 3614261,
'expenses': 86174,
'from_poi_to_this_person': 66,
'exercised_stock_options': 2291113,
'from_messages': 3069,
'other': 1661,
'from_this_person_to_poi': 609,
'poi': True,
'long_term_incentive': 1294981,
'shared_receipt_with_poi': 2097,
'restricted_stock': 1323148,
'director_fees': 'NaN'},
'SULLIVAN-SHAKLOVITZ COLLEEN': {'salary': 162779,
'to_messages': 'NaN',
'deferral_payments': 181993,
'total_payments': 999356,
'loan_advances': 'NaN',
'bonus': 100000,
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1362375,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 1362375,
'from_messages': 'NaN',
'other': 162,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'WROBEL BRUCE': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 139130,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 139130,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'LINDHOLM TOD A': {'salary': 236457,
'to_messages': 'NaN',
'deferral_payments': 204075,
'total_payments': 875889,
'loan_advances': 'NaN',
'bonus': 200000,
'email_address': 'tod.lindholm@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 3064208,
'expenses': 57727,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 2549361,
'from_messages': 'NaN',
'other': 2630,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 175000,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 514847,
'director_fees': 'NaN'},
'MEYER JEROME J': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 2151,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -38346,
'total_stock_value': 'NaN',
'expenses': 2151,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 38346},
'LAY KENNETH L': {'salary': 1072321,
'to_messages': 4273,
'deferral_payments': 202911,
'total_payments': 103559793,
'loan_advances': 81525000,
'bonus': 7000000,
'email_address': 'kenneth.lay@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -300000,
'total_stock_value': 49110078,
'expenses': 99832,
'from_poi_to_this_person': 123,
'exercised_stock_options': 34348384,
'from_messages': 36,
'other': 10359729,
'from_this_person_to_poi': 16,
'poi': True,
'long_term_incentive': 3600000,
'shared_receipt_with_poi': 2411,
'restricted_stock': 14761694,
'director_fees': 'NaN'},
'BUTTS ROBERT H': {'salary': 261516,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 1271582,
'loan_advances': 'NaN',
'bonus': 750000,
'email_address': 'bob.butts@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -75000,
'total_stock_value': 417619,
'expenses': 9410,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 150656,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 175000,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 417619,
'director_fees': 'NaN'},
'OLSON CINDY K': {'salary': 329078,
'to_messages': 1184,
'deferral_payments': 77716,
'total_payments': 1321557,
'loan_advances': 'NaN',
'bonus': 750000,
'email_address': 'cindy.olson@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2606763,
'expenses': 63791,
'from_poi_to_this_person': 20,
'exercised_stock_options': 1637034,
'from_messages': 52,
'other': 972,
'from_this_person_to_poi': 15,
'poi': False,
'long_term_incentive': 100000,
'shared_receipt_with_poi': 856,
'restricted_stock': 969729,
'director_fees': 'NaN'},
'MCDONALD REBECCA': {'salary': 'NaN',
'to_messages': 894,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'rebecca.mcdonald@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1691366,
'expenses': 'NaN',
'from_poi_to_this_person': 54,
'exercised_stock_options': 757301,
'from_messages': 13,
'other': 'NaN',
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 720,
'restricted_stock': 934065,
'director_fees': 'NaN'},
'CUMBERLAND MICHAEL S': {'salary': 184899,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 807956,
'loan_advances': 'NaN',
'bonus': 325000,
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 207940,
'expenses': 22344,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 713,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 275000,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 207940,
'director_fees': 'NaN'},
'GAHN ROBERT S': {'salary': 192008,
'to_messages': 'NaN',
'deferral_payments': 73122,
'total_payments': 900585,
'loan_advances': 'NaN',
'bonus': 509870,
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -1042,
'total_stock_value': 318607,
'expenses': 50080,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 83237,
'from_messages': 'NaN',
'other': 76547,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 235370,
'director_fees': 'NaN'},
'BADUM JAMES P': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 178980,
'total_payments': 182466,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 257817,
'expenses': 3486,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 257817,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'HERMANN ROBERT J': {'salary': 262663,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 1297461,
'loan_advances': 'NaN',
'bonus': 700000,
'email_address': 'robert.hermann@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -280000,
'total_stock_value': 668132,
'expenses': 48357,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 187500,
'from_messages': 'NaN',
'other': 416441,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 150000,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 480632,
'director_fees': 'NaN'},
'FALLON JAMES B': {'salary': 304588,
'to_messages': 1755,
'deferral_payments': 'NaN',
'total_payments': 3676340,
'loan_advances': 'NaN',
'bonus': 2500000,
'email_address': 'jim.fallon@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2332399,
'expenses': 95924,
'from_poi_to_this_person': 42,
'exercised_stock_options': 940257,
'from_messages': 75,
'other': 401481,
'from_this_person_to_poi': 37,
'poi': False,
'long_term_incentive': 374347,
'shared_receipt_with_poi': 1604,
'restricted_stock': 1392142,
'director_fees': 'NaN'},
'GATHMANN WILLIAM D': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': -72419,
'deferred_income': 'NaN',
'total_stock_value': 1945360,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 1753766,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 264013,
'director_fees': 'NaN'},
'HORTON STANLEY C': {'salary': 'NaN',
'to_messages': 2350,
'deferral_payments': 3131860,
'total_payments': 3131860,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'stanley.horton@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 7256648,
'expenses': 'NaN',
'from_poi_to_this_person': 44,
'exercised_stock_options': 5210569,
'from_messages': 1073,
'other': 'NaN',
'from_this_person_to_poi': 15,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 1074,
'restricted_stock': 2046079,
'director_fees': 'NaN'},
'BOWEN JR RAYMOND M': {'salary': 278601,
'to_messages': 1858,
'deferral_payments': 'NaN',
'total_payments': 2669589,
'loan_advances': 'NaN',
'bonus': 1350000,
'email_address': 'raymond.bowen@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -833,
'total_stock_value': 252055,
'expenses': 65907,
'from_poi_to_this_person': 140,
'exercised_stock_options': 'NaN',
'from_messages': 27,
'other': 1621,
'from_this_person_to_poi': 15,
'poi': True,
'long_term_incentive': 974293,
'shared_receipt_with_poi': 1593,
'restricted_stock': 252055,
'director_fees': 'NaN'},
'GILLIS JOHN': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 85641,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 9803,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 75838,
'director_fees': 'NaN'},
'FITZGERALD JAY L': {'salary': 199157,
'to_messages': 936,
'deferral_payments': 'NaN',
'total_payments': 1414857,
'loan_advances': 'NaN',
'bonus': 350000,
'email_address': 'jay.fitzgerald@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1621236,
'expenses': 23870,
'from_poi_to_this_person': 1,
'exercised_stock_options': 664461,
'from_messages': 16,
'other': 285414,
'from_this_person_to_poi': 8,
'poi': False,
'long_term_incentive': 556416,
'shared_receipt_with_poi': 723,
'restricted_stock': 956775,
'director_fees': 'NaN'},
'MORAN MICHAEL P': {'salary': 'NaN',
'to_messages': 672,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'michael.moran@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 221141,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 59539,
'from_messages': 19,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 127,
'restricted_stock': 161602,
'director_fees': 'NaN'},
'REDMOND BRIAN L': {'salary': 96840,
'to_messages': 1671,
'deferral_payments': 'NaN',
'total_payments': 111529,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'brian.redmond@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 7890324,
'expenses': 14689,
'from_poi_to_this_person': 204,
'exercised_stock_options': 7509039,
'from_messages': 221,
'other': 'NaN',
'from_this_person_to_poi': 49,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 1063,
'restricted_stock': 381285,
'director_fees': 'NaN'},
'BAZELIDES PHILIP J': {'salary': 80818,
'to_messages': 'NaN',
'deferral_payments': 684694,
'total_payments': 860136,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1599641,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 1599641,
'from_messages': 'NaN',
'other': 874,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 93750,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'BELDEN TIMOTHY N': {'salary': 213999,
'to_messages': 7991,
'deferral_payments': 2144013,
'total_payments': 5501630,
'loan_advances': 'NaN',
'bonus': 5249999,
'email_address': 'tim.belden@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -2334434,
'total_stock_value': 1110705,
'expenses': 17355,
'from_poi_to_this_person': 228,
'exercised_stock_options': 953136,
'from_messages': 484,
'other': 210698,
'from_this_person_to_poi': 108,
'poi': True,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 5521,
'restricted_stock': 157569,
'director_fees': 'NaN'},
'DIMICHELE RICHARD G': {'salary': 262788,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 2368151,
'loan_advances': 'NaN',
'bonus': 1000000,
'email_address': 'richard.dimichele@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 8317782,
'expenses': 35812,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 8191755,
'from_messages': 'NaN',
'other': 374689,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 694862,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 126027,
'director_fees': 'NaN'},
'DURAN WILLIAM D': {'salary': 210692,
'to_messages': 904,
'deferral_payments': 'NaN',
'total_payments': 2093263,
'loan_advances': 'NaN',
'bonus': 750000,
'email_address': 'w.duran@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1640910,
'expenses': 25785,
'from_poi_to_this_person': 106,
'exercised_stock_options': 1451869,
'from_messages': 12,
'other': 1568,
'from_this_person_to_poi': 3,
'poi': False,
'long_term_incentive': 1105218,
'shared_receipt_with_poi': 599,
'restricted_stock': 189041,
'director_fees': 'NaN'},
'THORN TERENCE H': {'salary': 222093,
'to_messages': 266,
'deferral_payments': 16586,
'total_payments': 911453,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'terence.thorn@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 4817796,
'expenses': 46145,
'from_poi_to_this_person': 0,
'exercised_stock_options': 4452476,
'from_messages': 41,
'other': 426629,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 200000,
'shared_receipt_with_poi': 73,
'restricted_stock': 365320,
'director_fees': 'NaN'},
'FASTOW ANDREW S': {'salary': 440698,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 2424083,
'loan_advances': 'NaN',
'bonus': 1300000,
'email_address': 'andrew.fastow@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -1386055,
'total_stock_value': 1794412,
'expenses': 55921,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 277464,
'from_this_person_to_poi': 'NaN',
'poi': True,
'long_term_incentive': 1736055,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 1794412,
'director_fees': 'NaN'},
'FOY JOE': {'salary': 'NaN',
'to_messages': 57,
'deferral_payments': 181755,
'total_payments': 181755,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'tracy.foy@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 343434,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 343434,
'from_messages': 13,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 2,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'CALGER CHRISTOPHER F': {'salary': 240189,
'to_messages': 2598,
'deferral_payments': 'NaN',
'total_payments': 1639297,
'loan_advances': 'NaN',
'bonus': 1250000,
'email_address': 'christopher.calger@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -262500,
'total_stock_value': 126027,
'expenses': 35818,
'from_poi_to_this_person': 199,
'exercised_stock_options': 'NaN',
'from_messages': 144,
'other': 486,
'from_this_person_to_poi': 25,
'poi': True,
'long_term_incentive': 375304,
'shared_receipt_with_poi': 2188,
'restricted_stock': 126027,
'director_fees': 'NaN'},
'RICE KENNETH D': {'salary': 420636,
'to_messages': 905,
'deferral_payments': 'NaN',
'total_payments': 505050,
'loan_advances': 'NaN',
'bonus': 1750000,
'email_address': 'ken.rice@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -3504386,
'total_stock_value': 22542539,
'expenses': 46950,
'from_poi_to_this_person': 42,
'exercised_stock_options': 19794175,
'from_messages': 18,
'other': 174839,
'from_this_person_to_poi': 4,
'poi': True,
'long_term_incentive': 1617011,
'shared_receipt_with_poi': 864,
'restricted_stock': 2748364,
'director_fees': 'NaN'},
'KAMINSKI WINCENTY J': {'salary': 275101,
'to_messages': 4607,
'deferral_payments': 'NaN',
'total_payments': 1086821,
'loan_advances': 'NaN',
'bonus': 400000,
'email_address': 'vince.kaminski@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 976037,
'expenses': 83585,
'from_poi_to_this_person': 41,
'exercised_stock_options': 850010,
'from_messages': 14368,
'other': 4669,
'from_this_person_to_poi': 171,
'poi': False,
'long_term_incentive': 323466,
'shared_receipt_with_poi': 583,
'restricted_stock': 126027,
'director_fees': 'NaN'},
'LOCKHART EUGENE E': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'COX DAVID': {'salary': 314288,
'to_messages': 102,
'deferral_payments': 'NaN',
'total_payments': 1101393,
'loan_advances': 'NaN',
'bonus': 800000,
'email_address': 'chip.cox@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -41250,
'total_stock_value': 495633,
'expenses': 27861,
'from_poi_to_this_person': 0,
'exercised_stock_options': 117551,
'from_messages': 33,
'other': 494,
'from_this_person_to_poi': 4,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 71,
'restricted_stock': 378082,
'director_fees': 'NaN'},
'OVERDYKE JR JERE C': {'salary': 94941,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 249787,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'jere.overdyke@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 7307594,
'expenses': 18834,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 5266578,
'from_messages': 'NaN',
'other': 176,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 135836,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 2041016,
'director_fees': 'NaN'},
'PEREIRA PAULO V. FERRAZ': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 27942,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -101250,
'total_stock_value': 'NaN',
'expenses': 27942,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 101250},
'STABLER FRANK': {'salary': 239502,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 1112087,
'loan_advances': 'NaN',
'bonus': 500000,
'email_address': 'frank.stabler@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 511734,
'expenses': 16514,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 356071,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 511734,
'director_fees': 'NaN'},
'SKILLING JEFFREY K': {'salary': 1111258,
'to_messages': 3627,
'deferral_payments': 'NaN',
'total_payments': 8682716,
'loan_advances': 'NaN',
'bonus': 5600000,
'email_address': 'jeff.skilling@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 26093672,
'expenses': 29336,
'from_poi_to_this_person': 88,
'exercised_stock_options': 19250000,
'from_messages': 108,
'other': 22122,
'from_this_person_to_poi': 30,
'poi': True,
'long_term_incentive': 1920000,
'shared_receipt_with_poi': 2042,
'restricted_stock': 6843672,
'director_fees': 'NaN'},
'BLAKE JR. NORMAN P': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 1279,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -113784,
'total_stock_value': 'NaN',
'expenses': 1279,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 113784},
'SHERRICK JEFFREY B': {'salary': 'NaN',
'to_messages': 613,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'jeffrey.sherrick@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1832468,
'expenses': 'NaN',
'from_poi_to_this_person': 39,
'exercised_stock_options': 1426469,
'from_messages': 25,
'other': 'NaN',
'from_this_person_to_poi': 18,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 583,
'restricted_stock': 405999,
'director_fees': 'NaN'},
'PRENTICE JAMES': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 564348,
'total_payments': 564348,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'james.prentice@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1095040,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 886231,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 208809,
'director_fees': 'NaN'},
'GRAY RODNEY': {'salary': 6615,
'to_messages': 'NaN',
'deferral_payments': 93585,
'total_payments': 1146658,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 680833,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 365625,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'THE TRAVEL AGENCY IN THE PARK': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 362096,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 362096,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'UMANOFF ADAM S': {'salary': 288589,
'to_messages': 111,
'deferral_payments': 'NaN',
'total_payments': 1130461,
'loan_advances': 'NaN',
'bonus': 788750,
'email_address': 'adam.umanoff@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 53122,
'from_poi_to_this_person': 12,
'exercised_stock_options': 'NaN',
'from_messages': 18,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 41,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'KEAN STEVEN J': {'salary': 404338,
'to_messages': 12754,
'deferral_payments': 'NaN',
'total_payments': 1747522,
'loan_advances': 'NaN',
'bonus': 1000000,
'email_address': 'steven.kean@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 6153642,
'expenses': 41953,
'from_poi_to_this_person': 140,
'exercised_stock_options': 2022048,
'from_messages': 6759,
'other': 1231,
'from_this_person_to_poi': 387,
'poi': False,
'long_term_incentive': 300000,
'shared_receipt_with_poi': 3639,
'restricted_stock': 4131594,
'director_fees': 'NaN'},
'TOTAL': {'salary': 26704229,
'to_messages': 'NaN',
'deferral_payments': 32083396,
'total_payments': 309886585,
'loan_advances': 83925000,
'bonus': 97343619,
'email_address': 'NaN',
'restricted_stock_deferred': -7576788,
'deferred_income': -27992891,
'total_stock_value': 434509511,
'expenses': 5235198,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 311764000,
'from_messages': 'NaN',
'other': 42667589,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 48521928,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 130322299,
'director_fees': 1398517},
'FOWLER PEGGY': {'salary': 'NaN',
'to_messages': 517,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'kulvinder.fowler@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1884748,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 1324578,
'from_messages': 36,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 10,
'restricted_stock': 560170,
'director_fees': 'NaN'},
'WASAFF GEORGE': {'salary': 259996,
'to_messages': 400,
'deferral_payments': 831299,
'total_payments': 1034395,
'loan_advances': 'NaN',
'bonus': 325000,
'email_address': 'george.wasaff@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -583325,
'total_stock_value': 2056427,
'expenses': 'NaN',
'from_poi_to_this_person': 22,
'exercised_stock_options': 1668260,
'from_messages': 30,
'other': 1425,
'from_this_person_to_poi': 7,
'poi': False,
'long_term_incentive': 200000,
'shared_receipt_with_poi': 337,
'restricted_stock': 388167,
'director_fees': 'NaN'},
'WHITE JR THOMAS E': {'salary': 317543,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 1934359,
'loan_advances': 'NaN',
'bonus': 450000,
'email_address': 'thomas.white@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 15144123,
'expenses': 81353,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 1297049,
'from_messages': 'NaN',
'other': 1085463,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 13847074,
'director_fees': 'NaN'},
'CHRISTODOULOU DIOMEDES': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'diomedes.christodoulou@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 6077885,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 5127155,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 950730,
'director_fees': 'NaN'},
'ALLEN PHILLIP K': {'salary': 201955,
'to_messages': 2902,
'deferral_payments': 2869717,
'total_payments': 4484442,
'loan_advances': 'NaN',
'bonus': 4175000,
'email_address': 'phillip.allen@enron.com',
'restricted_stock_deferred': -126027,
'deferred_income': -3081055,
'total_stock_value': 1729541,
'expenses': 13868,
'from_poi_to_this_person': 47,
'exercised_stock_options': 1729541,
'from_messages': 2195,
'other': 152,
'from_this_person_to_poi': 65,
'poi': False,
'long_term_incentive': 304805,
'shared_receipt_with_poi': 1407,
'restricted_stock': 126027,
'director_fees': 'NaN'},
'SHARP VICTORIA T': {'salary': 248146,
'to_messages': 3136,
'deferral_payments': 187469,
'total_payments': 1576511,
'loan_advances': 'NaN',
'bonus': 600000,
'email_address': 'vicki.sharp@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 494136,
'expenses': 116337,
'from_poi_to_this_person': 24,
'exercised_stock_options': 281073,
'from_messages': 136,
'other': 2401,
'from_this_person_to_poi': 6,
'poi': False,
'long_term_incentive': 422158,
'shared_receipt_with_poi': 2477,
'restricted_stock': 213063,
'director_fees': 'NaN'},
'JAEDICKE ROBERT': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 83750,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': -44093,
'deferred_income': -25000,
'total_stock_value': 431750,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 431750,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 44093,
'director_fees': 108750},
'WINOKUR JR. HERBERT S': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 84992,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -25000,
'total_stock_value': 'NaN',
'expenses': 1413,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 108579},
'BROWN MICHAEL': {'salary': 'NaN',
'to_messages': 1486,
'deferral_payments': 'NaN',
'total_payments': 49288,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'michael.brown@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 49288,
'from_poi_to_this_person': 13,
'exercised_stock_options': 'NaN',
'from_messages': 41,
'other': 'NaN',
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 761,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'MCCLELLAN GEORGE': {'salary': 263413,
'to_messages': 1744,
'deferral_payments': 'NaN',
'total_payments': 1318763,
'loan_advances': 'NaN',
'bonus': 900000,
'email_address': 'george.mcclellan@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -125000,
'total_stock_value': 947861,
'expenses': 228763,
'from_poi_to_this_person': 52,
'exercised_stock_options': 506765,
'from_messages': 49,
'other': 51587,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 1469,
'restricted_stock': 441096,
'director_fees': 'NaN'},
'HUGHES JAMES A': {'salary': 'NaN',
'to_messages': 719,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'james.hughes@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1118394,
'expenses': 'NaN',
'from_poi_to_this_person': 35,
'exercised_stock_options': 754966,
'from_messages': 34,
'other': 'NaN',
'from_this_person_to_poi': 5,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 589,
'restricted_stock': 363428,
'director_fees': 'NaN'},
'REYNOLDS LAWRENCE': {'salary': 76399,
'to_messages': 'NaN',
'deferral_payments': 51365,
'total_payments': 394475,
'loan_advances': 'NaN',
'bonus': 100000,
'email_address': 'NaN',
'restricted_stock_deferred': -140264,
'deferred_income': -200000,
'total_stock_value': 4221891,
'expenses': 8409,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 4160672,
'from_messages': 'NaN',
'other': 202052,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 156250,
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 201483,
'director_fees': 'NaN'},
'PICKERING MARK R': {'salary': 655037,
'to_messages': 898,
'deferral_payments': 'NaN',
'total_payments': 1386690,
'loan_advances': 400000,
'bonus': 300000,
'email_address': 'mark.pickering@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 28798,
'expenses': 31653,
'from_poi_to_this_person': 7,
'exercised_stock_options': 28798,
'from_messages': 67,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 728,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'BHATNAGAR SANJAY': {'salary': 'NaN',
'to_messages': 523,
'total_stock_value': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 15456290,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'sanjay.bhatnagar@enron.com',
'restricted_stock_deferred': 15456290,
'deferred_income': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 2604490,
'from_messages': 29,
'other': 137864,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 463,
'restricted_stock': -2604490,
'director_fees': 137864},
'CARTER REBECCA C': {'salary': 261809,
'to_messages': 312,
'deferral_payments': 'NaN',
'total_payments': 477557,
'loan_advances': 'NaN',
'bonus': 300000,
'email_address': 'rebecca.carter@enron.com',
'restricted_stock_deferred': -307301,
'deferred_income': -159792,
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 29,
'exercised_stock_options': 'NaN',
'from_messages': 15,
'other': 540,
'from_this_person_to_poi': 7,
'poi': False,
'long_term_incentive': 75000,
'shared_receipt_with_poi': 196,
'restricted_stock': 307301,
'director_fees': 'NaN'},
'BUCHANAN HAROLD G': {'salary': 248017,
'to_messages': 1088,
'deferral_payments': 'NaN',
'total_payments': 1054637,
'loan_advances': 'NaN',
'bonus': 500000,
'email_address': 'john.buchanan@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1014505,
'expenses': 600,
'from_poi_to_this_person': 0,
'exercised_stock_options': 825464,
'from_messages': 125,
'other': 1215,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 304805,
'shared_receipt_with_poi': 23,
'restricted_stock': 189041,
'director_fees': 'NaN'},
'YEAP SOON': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 55097,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 192758,
'expenses': 55097,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 192758,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'MURRAY JULIA H': {'salary': 229284,
'to_messages': 2192,
'deferral_payments': 'NaN',
'total_payments': 812194,
'loan_advances': 'NaN',
'bonus': 400000,
'email_address': 'julia.murray@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 597461,
'expenses': 57580,
'from_poi_to_this_person': 11,
'exercised_stock_options': 400478,
'from_messages': 45,
'other': 330,
'from_this_person_to_poi': 2,
'poi': False,
'long_term_incentive': 125000,
'shared_receipt_with_poi': 395,
'restricted_stock': 196983,
'director_fees': 'NaN'},
'GARLAND C KEVIN': {'salary': 231946,
'to_messages': 209,
'deferral_payments': 'NaN',
'total_payments': 1566469,
'loan_advances': 'NaN',
'bonus': 850000,
'email_address': 'kevin.garland@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 896153,
'expenses': 48405,
'from_poi_to_this_person': 10,
'exercised_stock_options': 636246,
'from_messages': 44,
'other': 60814,
'from_this_person_to_poi': 27,
'poi': False,
'long_term_incentive': 375304,
'shared_receipt_with_poi': 178,
'restricted_stock': 259907,
'director_fees': 'NaN'},
'DODSON KEITH': {'salary': 221003,
'to_messages': 176,
'deferral_payments': 'NaN',
'total_payments': 319941,
'loan_advances': 'NaN',
'bonus': 70000,
'email_address': 'keith.dodson@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 28164,
'from_poi_to_this_person': 10,
'exercised_stock_options': 'NaN',
'from_messages': 14,
'other': 774,
'from_this_person_to_poi': 3,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 114,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'YEAGER F SCOTT': {'salary': 158403,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 360300,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'scott.yeager@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 11884758,
'expenses': 53947,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 8308552,
'from_messages': 'NaN',
'other': 147950,
'from_this_person_to_poi': 'NaN',
'poi': True,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 3576206,
'director_fees': 'NaN'},
'HIRKO JOSEPH': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 10259,
'total_payments': 91093,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'joe.hirko@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 30766064,
'expenses': 77978,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 30766064,
'from_messages': 'NaN',
'other': 2856,
'from_this_person_to_poi': 'NaN',
'poi': True,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'DIETRICH JANET R': {'salary': 250100,
'to_messages': 2572,
'deferral_payments': 'NaN',
'total_payments': 1410464,
'loan_advances': 'NaN',
'bonus': 600000,
'email_address': 'janet.dietrich@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1865087,
'expenses': 3475,
'from_poi_to_this_person': 305,
'exercised_stock_options': 1550019,
'from_messages': 63,
'other': 473,
'from_this_person_to_poi': 14,
'poi': False,
'long_term_incentive': 556416,
'shared_receipt_with_poi': 1902,
'restricted_stock': 315068,
'director_fees': 'NaN'},
'DERRICK JR. JAMES V': {'salary': 492375,
'to_messages': 2181,
'deferral_payments': 'NaN',
'total_payments': 550981,
'loan_advances': 'NaN',
'bonus': 800000,
'email_address': 'james.derrick@enron.com',
'restricted_stock_deferred': -1787380,
'deferred_income': -1284000,
'total_stock_value': 8831913,
'expenses': 51124,
'from_poi_to_this_person': 64,
'exercised_stock_options': 8831913,
'from_messages': 909,
'other': 7482,
'from_this_person_to_poi': 20,
'poi': False,
'long_term_incentive': 484000,
'shared_receipt_with_poi': 1401,
'restricted_stock': 1787380,
'director_fees': 'NaN'},
'FREVERT MARK A': {'salary': 1060932,
'to_messages': 3275,
'deferral_payments': 6426990,
'total_payments': 17252530,
'loan_advances': 2000000,
'bonus': 2000000,
'email_address': 'mark.frevert@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -3367011,
'total_stock_value': 14622185,
'expenses': 86987,
'from_poi_to_this_person': 242,
'exercised_stock_options': 10433518,
'from_messages': 21,
'other': 7427621,
'from_this_person_to_poi': 6,
'poi': False,
'long_term_incentive': 1617011,
'shared_receipt_with_poi': 2979,
'restricted_stock': 4188667,
'director_fees': 'NaN'},
'PAI LOU L': {'salary': 261879,
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 3123383,
'loan_advances': 'NaN',
'bonus': 1000000,
'email_address': 'lou.pai@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 23817930,
'expenses': 32047,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 15364167,
'from_messages': 'NaN',
'other': 1829457,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 8453763,
'director_fees': 'NaN'},
'HAYSLETT RODERICK J': {'salary': 'NaN',
'to_messages': 2649,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'rod.hayslett@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 346663,
'expenses': 'NaN',
'from_poi_to_this_person': 35,
'exercised_stock_options': 'NaN',
'from_messages': 1061,
'other': 'NaN',
'from_this_person_to_poi': 38,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 571,
'restricted_stock': 346663,
'director_fees': 'NaN'},
'BAY FRANKLIN R': {'salary': 239671,
'to_messages': 'NaN',
'deferral_payments': 260455,
'total_payments': 827696,
'loan_advances': 'NaN',
'bonus': 400000,
'email_address': 'frank.bay@enron.com',
'restricted_stock_deferred': -82782,
'deferred_income': -201641,
'total_stock_value': 63014,
'expenses': 129142,
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 69,
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 145796,
'director_fees': 'NaN'},
'MCCARTY DANNY J': {'salary': 'NaN',
'to_messages': 1433,
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'danny.mccarty@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 758931,
'expenses': 'NaN',
'from_poi_to_this_person': 25,
'exercised_stock_options': 664375,
'from_messages': 215,
'other': 'NaN',
'from_this_person_to_poi': 2,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 508,
'restricted_stock': 94556,
'director_fees': 'NaN'},
'FUGH JOHN L': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 50591,
'total_payments': 50591,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 176378,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 176378,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'SCRIMSHAW MATTHEW': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 'NaN',
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'matthew.scrimshaw@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 759557,
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 759557,
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'KOENIG MARK E': {'salary': 309946,
'to_messages': 2374,
'deferral_payments': 'NaN',
'total_payments': 1587421,
'loan_advances': 'NaN',
'bonus': 700000,
'email_address': 'mark.koenig@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 1920055,
'expenses': 127017,
'from_poi_to_this_person': 53,
'exercised_stock_options': 671737,
'from_messages': 61,
'other': 150458,
'from_this_person_to_poi': 15,
'poi': True,
'long_term_incentive': 300000,
'shared_receipt_with_poi': 2271,
'restricted_stock': 1248318,
'director_fees': 'NaN'},
'SAVAGE FRANK': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 3750,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': -121284,
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 125034},
'IZZO LAWRENCE L': {'salary': 85274,
'to_messages': 496,
'deferral_payments': 'NaN',
'total_payments': 1979596,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'larry.izzo@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 5819980,
'expenses': 28093,
'from_poi_to_this_person': 28,
'exercised_stock_options': 2165172,
'from_messages': 19,
'other': 1553729,
'from_this_person_to_poi': 5,
'poi': False,
'long_term_incentive': 312500,
'shared_receipt_with_poi': 437,
'restricted_stock': 3654808,
'director_fees': 'NaN'},
'TILNEY ELIZABETH A': {'salary': 247338,
'to_messages': 460,
'deferral_payments': 'NaN',
'total_payments': 399393,
'loan_advances': 'NaN',
'bonus': 300000,
'email_address': 'elizabeth.tilney@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -575000,
'total_stock_value': 1168042,
'expenses': 'NaN',
'from_poi_to_this_person': 10,
'exercised_stock_options': 591250,
'from_messages': 19,
'other': 152055,
'from_this_person_to_poi': 11,
'poi': False,
'long_term_incentive': 275000,
'shared_receipt_with_poi': 379,
'restricted_stock': 576792,
'director_fees': 'NaN'},
'MARTIN AMANDA K': {'salary': 349487,
'to_messages': 1522,
'deferral_payments': 85430,
'total_payments': 8407016,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'a..martin@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 2070306,
'expenses': 8211,
'from_poi_to_this_person': 8,
'exercised_stock_options': 2070306,
'from_messages': 230,
'other': 2818454,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 5145434,
'shared_receipt_with_poi': 477,
'restricted_stock': 'NaN',
'director_fees': 'NaN'},
'BUY RICHARD B': {'salary': 330546,
'to_messages': 3523,
'deferral_payments': 649584,
'total_payments': 2355702,
'loan_advances': 'NaN',
'bonus': 900000,
'email_address': 'rick.buy@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -694862,
'total_stock_value': 3444470,
'expenses': 'NaN',
'from_poi_to_this_person': 156,
'exercised_stock_options': 2542813,
'from_messages': 1053,
'other': 400572,
'from_this_person_to_poi': 71,
'poi': False,
'long_term_incentive': 769862,
'shared_receipt_with_poi': 2333,
'restricted_stock': 901657,
'director_fees': 'NaN'},
'GRAMM WENDY L': {'salary': 'NaN',
'to_messages': 'NaN',
'deferral_payments': 'NaN',
'total_payments': 119292,
'loan_advances': 'NaN',
'bonus': 'NaN',
'email_address': 'NaN',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 'NaN',
'expenses': 'NaN',
'from_poi_to_this_person': 'NaN',
'exercised_stock_options': 'NaN',
'from_messages': 'NaN',
'other': 'NaN',
'from_this_person_to_poi': 'NaN',
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 'NaN',
'restricted_stock': 'NaN',
'director_fees': 119292},
'CAUSEY RICHARD A': {'salary': 415189,
'to_messages': 1892,
'deferral_payments': 'NaN',
'total_payments': 1868758,
'loan_advances': 'NaN',
'bonus': 1000000,
'email_address': 'richard.causey@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -235000,
'total_stock_value': 2502063,
'expenses': 30674,
'from_poi_to_this_person': 58,
'exercised_stock_options': 'NaN',
'from_messages': 49,
'other': 307895,
'from_this_person_to_poi': 12,
'poi': True,
'long_term_incentive': 350000,
'shared_receipt_with_poi': 1585,
'restricted_stock': 2502063,
'director_fees': 'NaN'},
'TAYLOR MITCHELL S': {'salary': 265214,
'to_messages': 533,
'deferral_payments': 227449,
'total_payments': 1092663,
'loan_advances': 'NaN',
'bonus': 600000,
'email_address': 'mitchell.taylor@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 3745048,
'expenses': 'NaN',
'from_poi_to_this_person': 0,
'exercised_stock_options': 3181250,
'from_messages': 29,
'other': 'NaN',
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 300,
'restricted_stock': 563798,
'director_fees': 'NaN'},
'DONAHUE JR JEFFREY M': {'salary': 278601,
'to_messages': 865,
'deferral_payments': 'NaN',
'total_payments': 875760,
'loan_advances': 'NaN',
'bonus': 800000,
'email_address': 'jeff.donahue@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': -300000,
'total_stock_value': 1080988,
'expenses': 96268,
'from_poi_to_this_person': 188,
'exercised_stock_options': 765920,
'from_messages': 22,
'other': 891,
'from_this_person_to_poi': 11,
'poi': False,
'long_term_incentive': 'NaN',
'shared_receipt_with_poi': 772,
'restricted_stock': 315068,
'director_fees': 'NaN'},
'GLISAN JR BEN F': {'salary': 274975,
'to_messages': 873,
'deferral_payments': 'NaN',
'total_payments': 1272284,
'loan_advances': 'NaN',
'bonus': 600000,
'email_address': 'ben.glisan@enron.com',
'restricted_stock_deferred': 'NaN',
'deferred_income': 'NaN',
'total_stock_value': 778546,
'expenses': 125978,
'from_poi_to_this_person': 52,
'exercised_stock_options': 384728,
'from_messages': 16,
'other': 200308,
'from_this_person_to_poi': 6,
'poi': True,
'long_term_incentive': 71023,
'shared_receipt_with_poi': 874,
'restricted_stock': 393818,
'director_fees': 'NaN'}}
### 1.1.1 Dataset Exploration
print('# Exploratory Data Analysis #')
data_dict.keys()
print('Total number of data points: %d' % len(data_dict.keys()))
num_poi = 0
for name in data_dict.keys():
if data_dict[name]['poi'] == True:
num_poi += 1
num_not_poi = (len(data_dict.keys()) - num_poi)
print('Number of Persons of Interest: %d' % num_poi)
print('Number of people without Person of Interest label: %d' % num_not_poi)
# Exploratory Data Analysis # Total number of data points: 146 Number of Persons of Interest: 18 Number of people without Person of Interest label: 128
###1.1.2 Feature Exploration
all_features = data_dict['METTS MARK'].keys()
print('Each person has %d features available' % len(all_features))
### Evaluate dataset for completeness
missing_values = {}
for feature in all_features:
missing_values[feature] = 0
for person in data_dict.keys():
records = 0
for feature in all_features:
if data_dict[person][feature] == 'NaN':
missing_values[feature] += 1
else:
records += 1
Each person has 21 features available
### Print results of completeness analysis
print('Number of Missing Values for Each Feature:')
for feature in all_features:
print("%s: %d" % (feature, missing_values[feature]))
Number of Missing Values for Each Feature: salary: 51 to_messages: 60 deferral_payments: 107 total_payments: 21 loan_advances: 142 bonus: 64 email_address: 35 restricted_stock_deferred: 128 deferred_income: 97 total_stock_value: 20 expenses: 51 from_poi_to_this_person: 60 exercised_stock_options: 44 from_messages: 60 other: 53 from_this_person_to_poi: 60 poi: 0 long_term_incentive: 80 shared_receipt_with_poi: 60 restricted_stock: 36 director_fees: 129
**The missing data for financial features (payment, fees and stock) represent 0 and not unknown quantities, as it is shown in [Enron's public data](https://github.com/louisedietrich/Enron-Financial-Dataset).
We will thus in a first place replace all the missing values by 0.**
**For the features concerning emails (to_messages, from_messages, from_poi_to_this_person, from_this_person_to_poi, shared_receipt_with_poi.), missing values are unknown information. We don't want to drop all those values as we already are working on a rather small dataset and need data to build our models. We will replace the missing information by its average values, depending on the person's profile (i.e. average values for the POI or not POI for each feature).**
# Convert 'NaN' string to zero
for person in data_dict.keys():
for feature in all_features:
if data_dict[person][feature] == 'NaN':
data_dict[person][feature] = 0
# Data dictionary complete to check if the NaN values are removed
data_dict
{'METTS MARK': {'salary': 365788,
'to_messages': 807,
'deferral_payments': 0,
'total_payments': 1061827,
'loan_advances': 0,
'bonus': 600000,
'email_address': 'mark.metts@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 585062,
'expenses': 94299,
'from_poi_to_this_person': 38,
'exercised_stock_options': 0,
'from_messages': 29,
'other': 1740,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 702,
'restricted_stock': 585062,
'director_fees': 0},
'BAXTER JOHN C': {'salary': 267102,
'to_messages': 0,
'deferral_payments': 1295738,
'total_payments': 5634343,
'loan_advances': 0,
'bonus': 1200000,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -1386055,
'total_stock_value': 10623258,
'expenses': 11200,
'from_poi_to_this_person': 0,
'exercised_stock_options': 6680544,
'from_messages': 0,
'other': 2660303,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 1586055,
'shared_receipt_with_poi': 0,
'restricted_stock': 3942714,
'director_fees': 0},
'ELLIOTT STEVEN': {'salary': 170941,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 211725,
'loan_advances': 0,
'bonus': 350000,
'email_address': 'steven.elliott@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -400729,
'total_stock_value': 6678735,
'expenses': 78552,
'from_poi_to_this_person': 0,
'exercised_stock_options': 4890344,
'from_messages': 0,
'other': 12961,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 1788391,
'director_fees': 0},
'CORDES WILLIAM R': {'salary': 0,
'to_messages': 764,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'bill.cordes@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1038185,
'expenses': 0,
'from_poi_to_this_person': 10,
'exercised_stock_options': 651850,
'from_messages': 12,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 58,
'restricted_stock': 386335,
'director_fees': 0},
'HANNON KEVIN P': {'salary': 243293,
'to_messages': 1045,
'deferral_payments': 0,
'total_payments': 288682,
'loan_advances': 0,
'bonus': 1500000,
'email_address': 'kevin.hannon@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -3117011,
'total_stock_value': 6391065,
'expenses': 34039,
'from_poi_to_this_person': 32,
'exercised_stock_options': 5538001,
'from_messages': 32,
'other': 11350,
'from_this_person_to_poi': 21,
'poi': True,
'long_term_incentive': 1617011,
'shared_receipt_with_poi': 1035,
'restricted_stock': 853064,
'director_fees': 0},
'MORDAUNT KRISTINA M': {'salary': 267093,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 628522,
'loan_advances': 0,
'bonus': 325000,
'email_address': 'kristina.mordaunt@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 208510,
'expenses': 35018,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 1411,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 208510,
'director_fees': 0},
'MEYER ROCKFORD G': {'salary': 0,
'to_messages': 232,
'deferral_payments': 1848227,
'total_payments': 1848227,
'loan_advances': 0,
'bonus': 0,
'email_address': 'rockford.meyer@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 955873,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 493489,
'from_messages': 28,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 22,
'restricted_stock': 462384,
'director_fees': 0},
'MCMAHON JEFFREY': {'salary': 370448,
'to_messages': 2355,
'deferral_payments': 0,
'total_payments': 4099771,
'loan_advances': 0,
'bonus': 2600000,
'email_address': 'jeffrey.mcmahon@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1662855,
'expenses': 137108,
'from_poi_to_this_person': 58,
'exercised_stock_options': 1104054,
'from_messages': 48,
'other': 297353,
'from_this_person_to_poi': 26,
'poi': False,
'long_term_incentive': 694862,
'shared_receipt_with_poi': 2228,
'restricted_stock': 558801,
'director_fees': 0},
'HAEDICKE MARK E': {'salary': 374125,
'to_messages': 4009,
'deferral_payments': 2157527,
'total_payments': 3859065,
'loan_advances': 0,
'bonus': 1150000,
'email_address': 'mark.haedicke@enron.com',
'restricted_stock_deferred': -329825,
'deferred_income': -934484,
'total_stock_value': 803094,
'expenses': 76169,
'from_poi_to_this_person': 180,
'exercised_stock_options': 608750,
'from_messages': 1941,
'other': 52382,
'from_this_person_to_poi': 61,
'poi': False,
'long_term_incentive': 983346,
'shared_receipt_with_poi': 1847,
'restricted_stock': 524169,
'director_fees': 0},
'PIPER GREGORY F': {'salary': 197091,
'to_messages': 1238,
'deferral_payments': 1130036,
'total_payments': 1737629,
'loan_advances': 0,
'bonus': 400000,
'email_address': 'greg.piper@enron.com',
'restricted_stock_deferred': -409554,
'deferred_income': -33333,
'total_stock_value': 880290,
'expenses': 43057,
'from_poi_to_this_person': 61,
'exercised_stock_options': 880290,
'from_messages': 222,
'other': 778,
'from_this_person_to_poi': 48,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 742,
'restricted_stock': 409554,
'director_fees': 0},
'HUMPHREY GENE E': {'salary': 130724,
'to_messages': 128,
'deferral_payments': 2964506,
'total_payments': 3100224,
'loan_advances': 0,
'bonus': 0,
'email_address': 'gene.humphrey@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2282768,
'expenses': 4994,
'from_poi_to_this_person': 10,
'exercised_stock_options': 2282768,
'from_messages': 17,
'other': 0,
'from_this_person_to_poi': 17,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 119,
'restricted_stock': 0,
'director_fees': 0},
'NOLES JAMES L': {'salary': 0,
'to_messages': 0,
'deferral_payments': 774401,
'total_payments': 774401,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': -94556,
'deferred_income': 0,
'total_stock_value': 368705,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 463261,
'director_fees': 0},
'BLACHMAN JEREMY M': {'salary': 248546,
'to_messages': 2475,
'deferral_payments': 0,
'total_payments': 2014835,
'loan_advances': 0,
'bonus': 850000,
'email_address': 'jeremy.blachman@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 954354,
'expenses': 84208,
'from_poi_to_this_person': 25,
'exercised_stock_options': 765313,
'from_messages': 14,
'other': 272,
'from_this_person_to_poi': 2,
'poi': False,
'long_term_incentive': 831809,
'shared_receipt_with_poi': 2326,
'restricted_stock': 189041,
'director_fees': 0},
'SUNDE MARTIN': {'salary': 257486,
'to_messages': 2647,
'deferral_payments': 0,
'total_payments': 1545059,
'loan_advances': 0,
'bonus': 700000,
'email_address': 'marty.sunde@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 698920,
'expenses': 0,
'from_poi_to_this_person': 37,
'exercised_stock_options': 0,
'from_messages': 38,
'other': 111122,
'from_this_person_to_poi': 13,
'poi': False,
'long_term_incentive': 476451,
'shared_receipt_with_poi': 2565,
'restricted_stock': 698920,
'director_fees': 0},
'GIBBS DANA R': {'salary': 0,
'to_messages': 169,
'deferral_payments': 504610,
'total_payments': 966522,
'loan_advances': 0,
'bonus': 0,
'email_address': 'dana.gibbs@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2218275,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 2218275,
'from_messages': 12,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 461912,
'shared_receipt_with_poi': 23,
'restricted_stock': 0,
'director_fees': 0},
'LOWRY CHARLES P': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': -153686,
'deferred_income': 0,
'total_stock_value': 372205,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 372205,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 153686,
'director_fees': 0},
'COLWELL WESLEY': {'salary': 288542,
'to_messages': 1758,
'deferral_payments': 27610,
'total_payments': 1490344,
'loan_advances': 0,
'bonus': 1200000,
'email_address': 'wes.colwell@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -144062,
'total_stock_value': 698242,
'expenses': 16514,
'from_poi_to_this_person': 240,
'exercised_stock_options': 0,
'from_messages': 40,
'other': 101740,
'from_this_person_to_poi': 11,
'poi': True,
'long_term_incentive': 0,
'shared_receipt_with_poi': 1132,
'restricted_stock': 698242,
'director_fees': 0},
'MULLER MARK S': {'salary': 251654,
'to_messages': 136,
'deferral_payments': 842924,
'total_payments': 3202070,
'loan_advances': 0,
'bonus': 1100000,
'email_address': 's..muller@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -719000,
'total_stock_value': 1416848,
'expenses': 0,
'from_poi_to_this_person': 12,
'exercised_stock_options': 1056320,
'from_messages': 16,
'other': 947,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 1725545,
'shared_receipt_with_poi': 114,
'restricted_stock': 360528,
'director_fees': 0},
'JACKSON CHARLENE R': {'salary': 288558,
'to_messages': 258,
'deferral_payments': 0,
'total_payments': 551174,
'loan_advances': 0,
'bonus': 250000,
'email_address': 'charlene.jackson@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 725735,
'expenses': 10181,
'from_poi_to_this_person': 25,
'exercised_stock_options': 185063,
'from_messages': 56,
'other': 2435,
'from_this_person_to_poi': 19,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 117,
'restricted_stock': 540672,
'director_fees': 0},
'WESTFAHL RICHARD K': {'salary': 63744,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 762135,
'loan_advances': 0,
'bonus': 0,
'email_address': 'dick.westfahl@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -10800,
'total_stock_value': 384930,
'expenses': 51870,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 401130,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 256191,
'shared_receipt_with_poi': 0,
'restricted_stock': 384930,
'director_fees': 0},
'WALTERS GARETH W': {'salary': 0,
'to_messages': 0,
'deferral_payments': 53625,
'total_payments': 87410,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1030329,
'expenses': 33785,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1030329,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'WALLS JR ROBERT H': {'salary': 357091,
'to_messages': 671,
'deferral_payments': 0,
'total_payments': 1798780,
'loan_advances': 0,
'bonus': 850000,
'email_address': 'rob.walls@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 5898997,
'expenses': 50936,
'from_poi_to_this_person': 17,
'exercised_stock_options': 4346544,
'from_messages': 146,
'other': 2,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 540751,
'shared_receipt_with_poi': 215,
'restricted_stock': 1552453,
'director_fees': 0},
'KITCHEN LOUISE': {'salary': 271442,
'to_messages': 8305,
'deferral_payments': 0,
'total_payments': 3471141,
'loan_advances': 0,
'bonus': 3100000,
'email_address': 'louise.kitchen@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 547143,
'expenses': 5774,
'from_poi_to_this_person': 251,
'exercised_stock_options': 81042,
'from_messages': 1728,
'other': 93925,
'from_this_person_to_poi': 194,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 3669,
'restricted_stock': 466101,
'director_fees': 0},
'CHAN RONNIE': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': -32460,
'deferred_income': -98784,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 32460,
'director_fees': 98784},
'BELFER ROBERT': {'salary': 0,
'to_messages': 0,
'deferral_payments': -102500,
'total_payments': 102500,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 44093,
'deferred_income': 0,
'total_stock_value': -44093,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 3285,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 3285},
'SHANKMAN JEFFREY A': {'salary': 304110,
'to_messages': 3221,
'deferral_payments': 0,
'total_payments': 3038702,
'loan_advances': 0,
'bonus': 2000000,
'email_address': 'jeffrey.shankman@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2072035,
'expenses': 178979,
'from_poi_to_this_person': 94,
'exercised_stock_options': 1441898,
'from_messages': 2681,
'other': 1191,
'from_this_person_to_poi': 83,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 1730,
'restricted_stock': 630137,
'director_fees': 0},
'WODRASKA JOHN': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 189583,
'loan_advances': 0,
'bonus': 0,
'email_address': 'john.wodraska@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 189583,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'BERGSIEKER RICHARD P': {'salary': 187922,
'to_messages': 383,
'deferral_payments': 0,
'total_payments': 618850,
'loan_advances': 0,
'bonus': 250000,
'email_address': 'rick.bergsieker@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -485813,
'total_stock_value': 659249,
'expenses': 59175,
'from_poi_to_this_person': 4,
'exercised_stock_options': 0,
'from_messages': 59,
'other': 427316,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 180250,
'shared_receipt_with_poi': 233,
'restricted_stock': 659249,
'director_fees': 0},
'URQUHART JOHN A': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 228656,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -36666,
'total_stock_value': 0,
'expenses': 228656,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 36666},
'BIBI PHILIPPE A': {'salary': 213625,
'to_messages': 1607,
'deferral_payments': 0,
'total_payments': 2047593,
'loan_advances': 0,
'bonus': 1000000,
'email_address': 'philippe.bibi@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1843816,
'expenses': 38559,
'from_poi_to_this_person': 23,
'exercised_stock_options': 1465734,
'from_messages': 40,
'other': 425688,
'from_this_person_to_poi': 8,
'poi': False,
'long_term_incentive': 369721,
'shared_receipt_with_poi': 1336,
'restricted_stock': 378082,
'director_fees': 0},
'RIEKER PAULA H': {'salary': 249201,
'to_messages': 1328,
'deferral_payments': 214678,
'total_payments': 1099100,
'loan_advances': 0,
'bonus': 700000,
'email_address': 'paula.rieker@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -100000,
'total_stock_value': 1918887,
'expenses': 33271,
'from_poi_to_this_person': 35,
'exercised_stock_options': 1635238,
'from_messages': 82,
'other': 1950,
'from_this_person_to_poi': 48,
'poi': True,
'long_term_incentive': 0,
'shared_receipt_with_poi': 1258,
'restricted_stock': 283649,
'director_fees': 0},
'WHALEY DAVID A': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 98718,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 98718,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'BECK SALLY W': {'salary': 231330,
'to_messages': 7315,
'deferral_payments': 0,
'total_payments': 969068,
'loan_advances': 0,
'bonus': 700000,
'email_address': 'sally.beck@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 126027,
'expenses': 37172,
'from_poi_to_this_person': 144,
'exercised_stock_options': 0,
'from_messages': 4343,
'other': 566,
'from_this_person_to_poi': 386,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 2639,
'restricted_stock': 126027,
'director_fees': 0},
'HAUG DAVID L': {'salary': 0,
'to_messages': 573,
'deferral_payments': 0,
'total_payments': 475,
'loan_advances': 0,
'bonus': 0,
'email_address': 'david.haug@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2217299,
'expenses': 475,
'from_poi_to_this_person': 4,
'exercised_stock_options': 0,
'from_messages': 19,
'other': 0,
'from_this_person_to_poi': 7,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 471,
'restricted_stock': 2217299,
'director_fees': 0},
'ECHOLS JOHN B': {'salary': 182245,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 2692324,
'loan_advances': 0,
'bonus': 200000,
'email_address': 'john.echols@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1008941,
'expenses': 21530,
'from_poi_to_this_person': 0,
'exercised_stock_options': 601438,
'from_messages': 0,
'other': 53775,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 2234774,
'shared_receipt_with_poi': 0,
'restricted_stock': 407503,
'director_fees': 0},
'MENDELSOHN JOHN': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 148,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -103750,
'total_stock_value': 0,
'expenses': 148,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 103750},
'HICKERSON GARY J': {'salary': 211788,
'to_messages': 1320,
'deferral_payments': 0,
'total_payments': 2081796,
'loan_advances': 0,
'bonus': 1700000,
'email_address': 'gary.hickerson@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 441096,
'expenses': 98849,
'from_poi_to_this_person': 40,
'exercised_stock_options': 0,
'from_messages': 27,
'other': 1936,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 69223,
'shared_receipt_with_poi': 900,
'restricted_stock': 441096,
'director_fees': 0},
'CLINE KENNETH W': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': -472568,
'deferred_income': 0,
'total_stock_value': 189518,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 662086,
'director_fees': 0},
'LEWIS RICHARD': {'salary': 0,
'to_messages': 952,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'richard.lewis@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 850477,
'expenses': 0,
'from_poi_to_this_person': 10,
'exercised_stock_options': 850477,
'from_messages': 26,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 739,
'restricted_stock': 0,
'director_fees': 0},
'HAYES ROBERT E': {'salary': 0,
'to_messages': 504,
'deferral_payments': 7961,
'total_payments': 7961,
'loan_advances': 0,
'bonus': 0,
'email_address': 'robert.hayes@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 151418,
'expenses': 0,
'from_poi_to_this_person': 16,
'exercised_stock_options': 0,
'from_messages': 12,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 50,
'restricted_stock': 151418,
'director_fees': 0},
'KOPPER MICHAEL J': {'salary': 224305,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 2652612,
'loan_advances': 0,
'bonus': 800000,
'email_address': 'michael.kopper@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 985032,
'expenses': 118134,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 907502,
'from_this_person_to_poi': 0,
'poi': True,
'long_term_incentive': 602671,
'shared_receipt_with_poi': 0,
'restricted_stock': 985032,
'director_fees': 0},
'LEFF DANIEL P': {'salary': 273746,
'to_messages': 2822,
'deferral_payments': 0,
'total_payments': 2664228,
'loan_advances': 0,
'bonus': 1000000,
'email_address': 'dan.leff@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 360528,
'expenses': 0,
'from_poi_to_this_person': 67,
'exercised_stock_options': 0,
'from_messages': 63,
'other': 3083,
'from_this_person_to_poi': 14,
'poi': False,
'long_term_incentive': 1387399,
'shared_receipt_with_poi': 2672,
'restricted_stock': 360528,
'director_fees': 0},
'LAVORATO JOHN J': {'salary': 339288,
'to_messages': 7259,
'deferral_payments': 0,
'total_payments': 10425757,
'loan_advances': 0,
'bonus': 8000000,
'email_address': 'john.lavorato@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 5167144,
'expenses': 49537,
'from_poi_to_this_person': 528,
'exercised_stock_options': 4158995,
'from_messages': 2585,
'other': 1552,
'from_this_person_to_poi': 411,
'poi': False,
'long_term_incentive': 2035380,
'shared_receipt_with_poi': 3962,
'restricted_stock': 1008149,
'director_fees': 0},
'BERBERIAN DAVID': {'salary': 216582,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 228474,
'loan_advances': 0,
'bonus': 0,
'email_address': 'david.berberian@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2493616,
'expenses': 11892,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1624396,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 869220,
'director_fees': 0},
'DETMERING TIMOTHY J': {'salary': 210500,
'to_messages': 0,
'deferral_payments': 875307,
'total_payments': 1204583,
'loan_advances': 0,
'bonus': 425000,
'email_address': 'timothy.detmering@enron.com',
'restricted_stock_deferred': -315068,
'deferred_income': -775241,
'total_stock_value': 2027865,
'expenses': 52255,
'from_poi_to_this_person': 0,
'exercised_stock_options': 2027865,
'from_messages': 0,
'other': 1105,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 415657,
'shared_receipt_with_poi': 0,
'restricted_stock': 315068,
'director_fees': 0},
'WAKEHAM JOHN': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 213071,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 103773,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 109298},
'POWERS WILLIAM': {'salary': 0,
'to_messages': 653,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'ken.powers@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -17500,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 26,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 12,
'restricted_stock': 0,
'director_fees': 17500},
'GOLD JOSEPH': {'salary': 272880,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 2146973,
'loan_advances': 0,
'bonus': 750000,
'email_address': 'joe.gold@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 877611,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 436515,
'from_messages': 0,
'other': 819288,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 304805,
'shared_receipt_with_poi': 0,
'restricted_stock': 441096,
'director_fees': 0},
'BANNANTINE JAMES M': {'salary': 477,
'to_messages': 566,
'deferral_payments': 0,
'total_payments': 916197,
'loan_advances': 0,
'bonus': 0,
'email_address': 'james.bannantine@enron.com',
'restricted_stock_deferred': -560222,
'deferred_income': -5104,
'total_stock_value': 5243487,
'expenses': 56301,
'from_poi_to_this_person': 39,
'exercised_stock_options': 4046157,
'from_messages': 29,
'other': 864523,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 465,
'restricted_stock': 1757552,
'director_fees': 0},
'DUNCAN JOHN H': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 77492,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -25000,
'total_stock_value': 371750,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 371750,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 102492},
'SHAPIRO RICHARD S': {'salary': 269076,
'to_messages': 15149,
'deferral_payments': 0,
'total_payments': 1057548,
'loan_advances': 0,
'bonus': 650000,
'email_address': 'richard.shapiro@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 987001,
'expenses': 137767,
'from_poi_to_this_person': 74,
'exercised_stock_options': 607837,
'from_messages': 1215,
'other': 705,
'from_this_person_to_poi': 65,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 4527,
'restricted_stock': 379164,
'director_fees': 0},
'SHERRIFF JOHN R': {'salary': 428780,
'to_messages': 3187,
'deferral_payments': 0,
'total_payments': 4335388,
'loan_advances': 0,
'bonus': 1500000,
'email_address': 'john.sherriff@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 3128982,
'expenses': 0,
'from_poi_to_this_person': 28,
'exercised_stock_options': 1835558,
'from_messages': 92,
'other': 1852186,
'from_this_person_to_poi': 23,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 2103,
'restricted_stock': 1293424,
'director_fees': 0},
'SHELBY REX': {'salary': 211844,
'to_messages': 225,
'deferral_payments': 0,
'total_payments': 2003885,
'loan_advances': 0,
'bonus': 200000,
'email_address': 'rex.shelby@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -4167,
'total_stock_value': 2493616,
'expenses': 22884,
'from_poi_to_this_person': 13,
'exercised_stock_options': 1624396,
'from_messages': 39,
'other': 1573324,
'from_this_person_to_poi': 14,
'poi': True,
'long_term_incentive': 0,
'shared_receipt_with_poi': 91,
'restricted_stock': 869220,
'director_fees': 0},
'LEMAISTRE CHARLES': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 87492,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -25000,
'total_stock_value': 412878,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 412878,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 112492},
'DEFFNER JOSEPH M': {'salary': 206121,
'to_messages': 714,
'deferral_payments': 0,
'total_payments': 1208649,
'loan_advances': 0,
'bonus': 600000,
'email_address': 'joseph.deffner@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 159211,
'expenses': 41626,
'from_poi_to_this_person': 115,
'exercised_stock_options': 17378,
'from_messages': 74,
'other': 25553,
'from_this_person_to_poi': 4,
'poi': False,
'long_term_incentive': 335349,
'shared_receipt_with_poi': 552,
'restricted_stock': 141833,
'director_fees': 0},
'KISHKILL JOSEPH G': {'salary': 174246,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 704896,
'loan_advances': 0,
'bonus': 0,
'email_address': 'joe.kishkill@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -51042,
'total_stock_value': 1034346,
'expenses': 116335,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 465357,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 1034346,
'director_fees': 0},
'WHALLEY LAWRENCE G': {'salary': 510364,
'to_messages': 6019,
'deferral_payments': 0,
'total_payments': 4677574,
'loan_advances': 0,
'bonus': 3000000,
'email_address': 'greg.whalley@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 6079137,
'expenses': 57838,
'from_poi_to_this_person': 186,
'exercised_stock_options': 3282960,
'from_messages': 556,
'other': 301026,
'from_this_person_to_poi': 24,
'poi': False,
'long_term_incentive': 808346,
'shared_receipt_with_poi': 3920,
'restricted_stock': 2796177,
'director_fees': 0},
'MCCONNELL MICHAEL S': {'salary': 365038,
'to_messages': 3329,
'deferral_payments': 0,
'total_payments': 2101364,
'loan_advances': 0,
'bonus': 1100000,
'email_address': 'mike.mcconnell@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 3101279,
'expenses': 81364,
'from_poi_to_this_person': 92,
'exercised_stock_options': 1623010,
'from_messages': 2742,
'other': 540,
'from_this_person_to_poi': 194,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 2189,
'restricted_stock': 1478269,
'director_fees': 0},
'PIRO JIM': {'salary': 0,
'to_messages': 58,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'jim.piro@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 47304,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 16,
'other': 0,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 3,
'restricted_stock': 47304,
'director_fees': 0},
'DELAINEY DAVID W': {'salary': 365163,
'to_messages': 3093,
'deferral_payments': 0,
'total_payments': 4747979,
'loan_advances': 0,
'bonus': 3000000,
'email_address': 'david.delainey@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 3614261,
'expenses': 86174,
'from_poi_to_this_person': 66,
'exercised_stock_options': 2291113,
'from_messages': 3069,
'other': 1661,
'from_this_person_to_poi': 609,
'poi': True,
'long_term_incentive': 1294981,
'shared_receipt_with_poi': 2097,
'restricted_stock': 1323148,
'director_fees': 0},
'SULLIVAN-SHAKLOVITZ COLLEEN': {'salary': 162779,
'to_messages': 0,
'deferral_payments': 181993,
'total_payments': 999356,
'loan_advances': 0,
'bonus': 100000,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1362375,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1362375,
'from_messages': 0,
'other': 162,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 554422,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'WROBEL BRUCE': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 139130,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 139130,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'LINDHOLM TOD A': {'salary': 236457,
'to_messages': 0,
'deferral_payments': 204075,
'total_payments': 875889,
'loan_advances': 0,
'bonus': 200000,
'email_address': 'tod.lindholm@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 3064208,
'expenses': 57727,
'from_poi_to_this_person': 0,
'exercised_stock_options': 2549361,
'from_messages': 0,
'other': 2630,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 175000,
'shared_receipt_with_poi': 0,
'restricted_stock': 514847,
'director_fees': 0},
'MEYER JEROME J': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 2151,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -38346,
'total_stock_value': 0,
'expenses': 2151,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 38346},
'LAY KENNETH L': {'salary': 1072321,
'to_messages': 4273,
'deferral_payments': 202911,
'total_payments': 103559793,
'loan_advances': 81525000,
'bonus': 7000000,
'email_address': 'kenneth.lay@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -300000,
'total_stock_value': 49110078,
'expenses': 99832,
'from_poi_to_this_person': 123,
'exercised_stock_options': 34348384,
'from_messages': 36,
'other': 10359729,
'from_this_person_to_poi': 16,
'poi': True,
'long_term_incentive': 3600000,
'shared_receipt_with_poi': 2411,
'restricted_stock': 14761694,
'director_fees': 0},
'BUTTS ROBERT H': {'salary': 261516,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 1271582,
'loan_advances': 0,
'bonus': 750000,
'email_address': 'bob.butts@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -75000,
'total_stock_value': 417619,
'expenses': 9410,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 150656,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 175000,
'shared_receipt_with_poi': 0,
'restricted_stock': 417619,
'director_fees': 0},
'OLSON CINDY K': {'salary': 329078,
'to_messages': 1184,
'deferral_payments': 77716,
'total_payments': 1321557,
'loan_advances': 0,
'bonus': 750000,
'email_address': 'cindy.olson@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2606763,
'expenses': 63791,
'from_poi_to_this_person': 20,
'exercised_stock_options': 1637034,
'from_messages': 52,
'other': 972,
'from_this_person_to_poi': 15,
'poi': False,
'long_term_incentive': 100000,
'shared_receipt_with_poi': 856,
'restricted_stock': 969729,
'director_fees': 0},
'MCDONALD REBECCA': {'salary': 0,
'to_messages': 894,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'rebecca.mcdonald@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1691366,
'expenses': 0,
'from_poi_to_this_person': 54,
'exercised_stock_options': 757301,
'from_messages': 13,
'other': 0,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 720,
'restricted_stock': 934065,
'director_fees': 0},
'CUMBERLAND MICHAEL S': {'salary': 184899,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 807956,
'loan_advances': 0,
'bonus': 325000,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 207940,
'expenses': 22344,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 713,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 275000,
'shared_receipt_with_poi': 0,
'restricted_stock': 207940,
'director_fees': 0},
'GAHN ROBERT S': {'salary': 192008,
'to_messages': 0,
'deferral_payments': 73122,
'total_payments': 900585,
'loan_advances': 0,
'bonus': 509870,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -1042,
'total_stock_value': 318607,
'expenses': 50080,
'from_poi_to_this_person': 0,
'exercised_stock_options': 83237,
'from_messages': 0,
'other': 76547,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 235370,
'director_fees': 0},
'BADUM JAMES P': {'salary': 0,
'to_messages': 0,
'deferral_payments': 178980,
'total_payments': 182466,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 257817,
'expenses': 3486,
'from_poi_to_this_person': 0,
'exercised_stock_options': 257817,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'HERMANN ROBERT J': {'salary': 262663,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 1297461,
'loan_advances': 0,
'bonus': 700000,
'email_address': 'robert.hermann@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -280000,
'total_stock_value': 668132,
'expenses': 48357,
'from_poi_to_this_person': 0,
'exercised_stock_options': 187500,
'from_messages': 0,
'other': 416441,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 150000,
'shared_receipt_with_poi': 0,
'restricted_stock': 480632,
'director_fees': 0},
'FALLON JAMES B': {'salary': 304588,
'to_messages': 1755,
'deferral_payments': 0,
'total_payments': 3676340,
'loan_advances': 0,
'bonus': 2500000,
'email_address': 'jim.fallon@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2332399,
'expenses': 95924,
'from_poi_to_this_person': 42,
'exercised_stock_options': 940257,
'from_messages': 75,
'other': 401481,
'from_this_person_to_poi': 37,
'poi': False,
'long_term_incentive': 374347,
'shared_receipt_with_poi': 1604,
'restricted_stock': 1392142,
'director_fees': 0},
'GATHMANN WILLIAM D': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': -72419,
'deferred_income': 0,
'total_stock_value': 1945360,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1753766,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 264013,
'director_fees': 0},
'HORTON STANLEY C': {'salary': 0,
'to_messages': 2350,
'deferral_payments': 3131860,
'total_payments': 3131860,
'loan_advances': 0,
'bonus': 0,
'email_address': 'stanley.horton@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 7256648,
'expenses': 0,
'from_poi_to_this_person': 44,
'exercised_stock_options': 5210569,
'from_messages': 1073,
'other': 0,
'from_this_person_to_poi': 15,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 1074,
'restricted_stock': 2046079,
'director_fees': 0},
'BOWEN JR RAYMOND M': {'salary': 278601,
'to_messages': 1858,
'deferral_payments': 0,
'total_payments': 2669589,
'loan_advances': 0,
'bonus': 1350000,
'email_address': 'raymond.bowen@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -833,
'total_stock_value': 252055,
'expenses': 65907,
'from_poi_to_this_person': 140,
'exercised_stock_options': 0,
'from_messages': 27,
'other': 1621,
'from_this_person_to_poi': 15,
'poi': True,
'long_term_incentive': 974293,
'shared_receipt_with_poi': 1593,
'restricted_stock': 252055,
'director_fees': 0},
'GILLIS JOHN': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 85641,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 9803,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 75838,
'director_fees': 0},
'FITZGERALD JAY L': {'salary': 199157,
'to_messages': 936,
'deferral_payments': 0,
'total_payments': 1414857,
'loan_advances': 0,
'bonus': 350000,
'email_address': 'jay.fitzgerald@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1621236,
'expenses': 23870,
'from_poi_to_this_person': 1,
'exercised_stock_options': 664461,
'from_messages': 16,
'other': 285414,
'from_this_person_to_poi': 8,
'poi': False,
'long_term_incentive': 556416,
'shared_receipt_with_poi': 723,
'restricted_stock': 956775,
'director_fees': 0},
'MORAN MICHAEL P': {'salary': 0,
'to_messages': 672,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'michael.moran@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 221141,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 59539,
'from_messages': 19,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 127,
'restricted_stock': 161602,
'director_fees': 0},
'REDMOND BRIAN L': {'salary': 96840,
'to_messages': 1671,
'deferral_payments': 0,
'total_payments': 111529,
'loan_advances': 0,
'bonus': 0,
'email_address': 'brian.redmond@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 7890324,
'expenses': 14689,
'from_poi_to_this_person': 204,
'exercised_stock_options': 7509039,
'from_messages': 221,
'other': 0,
'from_this_person_to_poi': 49,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 1063,
'restricted_stock': 381285,
'director_fees': 0},
'BAZELIDES PHILIP J': {'salary': 80818,
'to_messages': 0,
'deferral_payments': 684694,
'total_payments': 860136,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1599641,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1599641,
'from_messages': 0,
'other': 874,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 93750,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'BELDEN TIMOTHY N': {'salary': 213999,
'to_messages': 7991,
'deferral_payments': 2144013,
'total_payments': 5501630,
'loan_advances': 0,
'bonus': 5249999,
'email_address': 'tim.belden@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -2334434,
'total_stock_value': 1110705,
'expenses': 17355,
'from_poi_to_this_person': 228,
'exercised_stock_options': 953136,
'from_messages': 484,
'other': 210698,
'from_this_person_to_poi': 108,
'poi': True,
'long_term_incentive': 0,
'shared_receipt_with_poi': 5521,
'restricted_stock': 157569,
'director_fees': 0},
'DIMICHELE RICHARD G': {'salary': 262788,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 2368151,
'loan_advances': 0,
'bonus': 1000000,
'email_address': 'richard.dimichele@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 8317782,
'expenses': 35812,
'from_poi_to_this_person': 0,
'exercised_stock_options': 8191755,
'from_messages': 0,
'other': 374689,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 694862,
'shared_receipt_with_poi': 0,
'restricted_stock': 126027,
'director_fees': 0},
'DURAN WILLIAM D': {'salary': 210692,
'to_messages': 904,
'deferral_payments': 0,
'total_payments': 2093263,
'loan_advances': 0,
'bonus': 750000,
'email_address': 'w.duran@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1640910,
'expenses': 25785,
'from_poi_to_this_person': 106,
'exercised_stock_options': 1451869,
'from_messages': 12,
'other': 1568,
'from_this_person_to_poi': 3,
'poi': False,
'long_term_incentive': 1105218,
'shared_receipt_with_poi': 599,
'restricted_stock': 189041,
'director_fees': 0},
'THORN TERENCE H': {'salary': 222093,
'to_messages': 266,
'deferral_payments': 16586,
'total_payments': 911453,
'loan_advances': 0,
'bonus': 0,
'email_address': 'terence.thorn@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 4817796,
'expenses': 46145,
'from_poi_to_this_person': 0,
'exercised_stock_options': 4452476,
'from_messages': 41,
'other': 426629,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 200000,
'shared_receipt_with_poi': 73,
'restricted_stock': 365320,
'director_fees': 0},
'FASTOW ANDREW S': {'salary': 440698,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 2424083,
'loan_advances': 0,
'bonus': 1300000,
'email_address': 'andrew.fastow@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -1386055,
'total_stock_value': 1794412,
'expenses': 55921,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 277464,
'from_this_person_to_poi': 0,
'poi': True,
'long_term_incentive': 1736055,
'shared_receipt_with_poi': 0,
'restricted_stock': 1794412,
'director_fees': 0},
'FOY JOE': {'salary': 0,
'to_messages': 57,
'deferral_payments': 181755,
'total_payments': 181755,
'loan_advances': 0,
'bonus': 0,
'email_address': 'tracy.foy@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 343434,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 343434,
'from_messages': 13,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 2,
'restricted_stock': 0,
'director_fees': 0},
'CALGER CHRISTOPHER F': {'salary': 240189,
'to_messages': 2598,
'deferral_payments': 0,
'total_payments': 1639297,
'loan_advances': 0,
'bonus': 1250000,
'email_address': 'christopher.calger@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -262500,
'total_stock_value': 126027,
'expenses': 35818,
'from_poi_to_this_person': 199,
'exercised_stock_options': 0,
'from_messages': 144,
'other': 486,
'from_this_person_to_poi': 25,
'poi': True,
'long_term_incentive': 375304,
'shared_receipt_with_poi': 2188,
'restricted_stock': 126027,
'director_fees': 0},
'RICE KENNETH D': {'salary': 420636,
'to_messages': 905,
'deferral_payments': 0,
'total_payments': 505050,
'loan_advances': 0,
'bonus': 1750000,
'email_address': 'ken.rice@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -3504386,
'total_stock_value': 22542539,
'expenses': 46950,
'from_poi_to_this_person': 42,
'exercised_stock_options': 19794175,
'from_messages': 18,
'other': 174839,
'from_this_person_to_poi': 4,
'poi': True,
'long_term_incentive': 1617011,
'shared_receipt_with_poi': 864,
'restricted_stock': 2748364,
'director_fees': 0},
'KAMINSKI WINCENTY J': {'salary': 275101,
'to_messages': 4607,
'deferral_payments': 0,
'total_payments': 1086821,
'loan_advances': 0,
'bonus': 400000,
'email_address': 'vince.kaminski@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 976037,
'expenses': 83585,
'from_poi_to_this_person': 41,
'exercised_stock_options': 850010,
'from_messages': 14368,
'other': 4669,
'from_this_person_to_poi': 171,
'poi': False,
'long_term_incentive': 323466,
'shared_receipt_with_poi': 583,
'restricted_stock': 126027,
'director_fees': 0},
'LOCKHART EUGENE E': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'COX DAVID': {'salary': 314288,
'to_messages': 102,
'deferral_payments': 0,
'total_payments': 1101393,
'loan_advances': 0,
'bonus': 800000,
'email_address': 'chip.cox@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -41250,
'total_stock_value': 495633,
'expenses': 27861,
'from_poi_to_this_person': 0,
'exercised_stock_options': 117551,
'from_messages': 33,
'other': 494,
'from_this_person_to_poi': 4,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 71,
'restricted_stock': 378082,
'director_fees': 0},
'OVERDYKE JR JERE C': {'salary': 94941,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 249787,
'loan_advances': 0,
'bonus': 0,
'email_address': 'jere.overdyke@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 7307594,
'expenses': 18834,
'from_poi_to_this_person': 0,
'exercised_stock_options': 5266578,
'from_messages': 0,
'other': 176,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 135836,
'shared_receipt_with_poi': 0,
'restricted_stock': 2041016,
'director_fees': 0},
'PEREIRA PAULO V. FERRAZ': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 27942,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -101250,
'total_stock_value': 0,
'expenses': 27942,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 101250},
'STABLER FRANK': {'salary': 239502,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 1112087,
'loan_advances': 0,
'bonus': 500000,
'email_address': 'frank.stabler@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 511734,
'expenses': 16514,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 356071,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 511734,
'director_fees': 0},
'SKILLING JEFFREY K': {'salary': 1111258,
'to_messages': 3627,
'deferral_payments': 0,
'total_payments': 8682716,
'loan_advances': 0,
'bonus': 5600000,
'email_address': 'jeff.skilling@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 26093672,
'expenses': 29336,
'from_poi_to_this_person': 88,
'exercised_stock_options': 19250000,
'from_messages': 108,
'other': 22122,
'from_this_person_to_poi': 30,
'poi': True,
'long_term_incentive': 1920000,
'shared_receipt_with_poi': 2042,
'restricted_stock': 6843672,
'director_fees': 0},
'BLAKE JR. NORMAN P': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 1279,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -113784,
'total_stock_value': 0,
'expenses': 1279,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 113784},
'SHERRICK JEFFREY B': {'salary': 0,
'to_messages': 613,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'jeffrey.sherrick@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1832468,
'expenses': 0,
'from_poi_to_this_person': 39,
'exercised_stock_options': 1426469,
'from_messages': 25,
'other': 0,
'from_this_person_to_poi': 18,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 583,
'restricted_stock': 405999,
'director_fees': 0},
'PRENTICE JAMES': {'salary': 0,
'to_messages': 0,
'deferral_payments': 564348,
'total_payments': 564348,
'loan_advances': 0,
'bonus': 0,
'email_address': 'james.prentice@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1095040,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 886231,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 208809,
'director_fees': 0},
'GRAY RODNEY': {'salary': 6615,
'to_messages': 0,
'deferral_payments': 93585,
'total_payments': 1146658,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 680833,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 365625,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'THE TRAVEL AGENCY IN THE PARK': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 362096,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 362096,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'UMANOFF ADAM S': {'salary': 288589,
'to_messages': 111,
'deferral_payments': 0,
'total_payments': 1130461,
'loan_advances': 0,
'bonus': 788750,
'email_address': 'adam.umanoff@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 53122,
'from_poi_to_this_person': 12,
'exercised_stock_options': 0,
'from_messages': 18,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 41,
'restricted_stock': 0,
'director_fees': 0},
'KEAN STEVEN J': {'salary': 404338,
'to_messages': 12754,
'deferral_payments': 0,
'total_payments': 1747522,
'loan_advances': 0,
'bonus': 1000000,
'email_address': 'steven.kean@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 6153642,
'expenses': 41953,
'from_poi_to_this_person': 140,
'exercised_stock_options': 2022048,
'from_messages': 6759,
'other': 1231,
'from_this_person_to_poi': 387,
'poi': False,
'long_term_incentive': 300000,
'shared_receipt_with_poi': 3639,
'restricted_stock': 4131594,
'director_fees': 0},
'TOTAL': {'salary': 26704229,
'to_messages': 0,
'deferral_payments': 32083396,
'total_payments': 309886585,
'loan_advances': 83925000,
'bonus': 97343619,
'email_address': 0,
'restricted_stock_deferred': -7576788,
'deferred_income': -27992891,
'total_stock_value': 434509511,
'expenses': 5235198,
'from_poi_to_this_person': 0,
'exercised_stock_options': 311764000,
'from_messages': 0,
'other': 42667589,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 48521928,
'shared_receipt_with_poi': 0,
'restricted_stock': 130322299,
'director_fees': 1398517},
'FOWLER PEGGY': {'salary': 0,
'to_messages': 517,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'kulvinder.fowler@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1884748,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1324578,
'from_messages': 36,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 10,
'restricted_stock': 560170,
'director_fees': 0},
'WASAFF GEORGE': {'salary': 259996,
'to_messages': 400,
'deferral_payments': 831299,
'total_payments': 1034395,
'loan_advances': 0,
'bonus': 325000,
'email_address': 'george.wasaff@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -583325,
'total_stock_value': 2056427,
'expenses': 0,
'from_poi_to_this_person': 22,
'exercised_stock_options': 1668260,
'from_messages': 30,
'other': 1425,
'from_this_person_to_poi': 7,
'poi': False,
'long_term_incentive': 200000,
'shared_receipt_with_poi': 337,
'restricted_stock': 388167,
'director_fees': 0},
'WHITE JR THOMAS E': {'salary': 317543,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 1934359,
'loan_advances': 0,
'bonus': 450000,
'email_address': 'thomas.white@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 15144123,
'expenses': 81353,
'from_poi_to_this_person': 0,
'exercised_stock_options': 1297049,
'from_messages': 0,
'other': 1085463,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 13847074,
'director_fees': 0},
'CHRISTODOULOU DIOMEDES': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'diomedes.christodoulou@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 6077885,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 5127155,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 950730,
'director_fees': 0},
'ALLEN PHILLIP K': {'salary': 201955,
'to_messages': 2902,
'deferral_payments': 2869717,
'total_payments': 4484442,
'loan_advances': 0,
'bonus': 4175000,
'email_address': 'phillip.allen@enron.com',
'restricted_stock_deferred': -126027,
'deferred_income': -3081055,
'total_stock_value': 1729541,
'expenses': 13868,
'from_poi_to_this_person': 47,
'exercised_stock_options': 1729541,
'from_messages': 2195,
'other': 152,
'from_this_person_to_poi': 65,
'poi': False,
'long_term_incentive': 304805,
'shared_receipt_with_poi': 1407,
'restricted_stock': 126027,
'director_fees': 0},
'SHARP VICTORIA T': {'salary': 248146,
'to_messages': 3136,
'deferral_payments': 187469,
'total_payments': 1576511,
'loan_advances': 0,
'bonus': 600000,
'email_address': 'vicki.sharp@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 494136,
'expenses': 116337,
'from_poi_to_this_person': 24,
'exercised_stock_options': 281073,
'from_messages': 136,
'other': 2401,
'from_this_person_to_poi': 6,
'poi': False,
'long_term_incentive': 422158,
'shared_receipt_with_poi': 2477,
'restricted_stock': 213063,
'director_fees': 0},
'JAEDICKE ROBERT': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 83750,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': -44093,
'deferred_income': -25000,
'total_stock_value': 431750,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 431750,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 44093,
'director_fees': 108750},
'WINOKUR JR. HERBERT S': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 84992,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -25000,
'total_stock_value': 0,
'expenses': 1413,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 108579},
'BROWN MICHAEL': {'salary': 0,
'to_messages': 1486,
'deferral_payments': 0,
'total_payments': 49288,
'loan_advances': 0,
'bonus': 0,
'email_address': 'michael.brown@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 49288,
'from_poi_to_this_person': 13,
'exercised_stock_options': 0,
'from_messages': 41,
'other': 0,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 761,
'restricted_stock': 0,
'director_fees': 0},
'MCCLELLAN GEORGE': {'salary': 263413,
'to_messages': 1744,
'deferral_payments': 0,
'total_payments': 1318763,
'loan_advances': 0,
'bonus': 900000,
'email_address': 'george.mcclellan@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -125000,
'total_stock_value': 947861,
'expenses': 228763,
'from_poi_to_this_person': 52,
'exercised_stock_options': 506765,
'from_messages': 49,
'other': 51587,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 1469,
'restricted_stock': 441096,
'director_fees': 0},
'HUGHES JAMES A': {'salary': 0,
'to_messages': 719,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'james.hughes@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1118394,
'expenses': 0,
'from_poi_to_this_person': 35,
'exercised_stock_options': 754966,
'from_messages': 34,
'other': 0,
'from_this_person_to_poi': 5,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 589,
'restricted_stock': 363428,
'director_fees': 0},
'REYNOLDS LAWRENCE': {'salary': 76399,
'to_messages': 0,
'deferral_payments': 51365,
'total_payments': 394475,
'loan_advances': 0,
'bonus': 100000,
'email_address': 0,
'restricted_stock_deferred': -140264,
'deferred_income': -200000,
'total_stock_value': 4221891,
'expenses': 8409,
'from_poi_to_this_person': 0,
'exercised_stock_options': 4160672,
'from_messages': 0,
'other': 202052,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 156250,
'shared_receipt_with_poi': 0,
'restricted_stock': 201483,
'director_fees': 0},
'PICKERING MARK R': {'salary': 655037,
'to_messages': 898,
'deferral_payments': 0,
'total_payments': 1386690,
'loan_advances': 400000,
'bonus': 300000,
'email_address': 'mark.pickering@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 28798,
'expenses': 31653,
'from_poi_to_this_person': 7,
'exercised_stock_options': 28798,
'from_messages': 67,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 728,
'restricted_stock': 0,
'director_fees': 0},
'BHATNAGAR SANJAY': {'salary': 0,
'to_messages': 523,
'total_stock_value': 0,
'deferral_payments': 0,
'total_payments': 15456290,
'loan_advances': 0,
'bonus': 0,
'email_address': 'sanjay.bhatnagar@enron.com',
'restricted_stock_deferred': 15456290,
'deferred_income': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 2604490,
'from_messages': 29,
'other': 137864,
'from_this_person_to_poi': 1,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 463,
'restricted_stock': -2604490,
'director_fees': 137864},
'CARTER REBECCA C': {'salary': 261809,
'to_messages': 312,
'deferral_payments': 0,
'total_payments': 477557,
'loan_advances': 0,
'bonus': 300000,
'email_address': 'rebecca.carter@enron.com',
'restricted_stock_deferred': -307301,
'deferred_income': -159792,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 29,
'exercised_stock_options': 0,
'from_messages': 15,
'other': 540,
'from_this_person_to_poi': 7,
'poi': False,
'long_term_incentive': 75000,
'shared_receipt_with_poi': 196,
'restricted_stock': 307301,
'director_fees': 0},
'BUCHANAN HAROLD G': {'salary': 248017,
'to_messages': 1088,
'deferral_payments': 0,
'total_payments': 1054637,
'loan_advances': 0,
'bonus': 500000,
'email_address': 'john.buchanan@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1014505,
'expenses': 600,
'from_poi_to_this_person': 0,
'exercised_stock_options': 825464,
'from_messages': 125,
'other': 1215,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 304805,
'shared_receipt_with_poi': 23,
'restricted_stock': 189041,
'director_fees': 0},
'YEAP SOON': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 55097,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 192758,
'expenses': 55097,
'from_poi_to_this_person': 0,
'exercised_stock_options': 192758,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'MURRAY JULIA H': {'salary': 229284,
'to_messages': 2192,
'deferral_payments': 0,
'total_payments': 812194,
'loan_advances': 0,
'bonus': 400000,
'email_address': 'julia.murray@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 597461,
'expenses': 57580,
'from_poi_to_this_person': 11,
'exercised_stock_options': 400478,
'from_messages': 45,
'other': 330,
'from_this_person_to_poi': 2,
'poi': False,
'long_term_incentive': 125000,
'shared_receipt_with_poi': 395,
'restricted_stock': 196983,
'director_fees': 0},
'GARLAND C KEVIN': {'salary': 231946,
'to_messages': 209,
'deferral_payments': 0,
'total_payments': 1566469,
'loan_advances': 0,
'bonus': 850000,
'email_address': 'kevin.garland@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 896153,
'expenses': 48405,
'from_poi_to_this_person': 10,
'exercised_stock_options': 636246,
'from_messages': 44,
'other': 60814,
'from_this_person_to_poi': 27,
'poi': False,
'long_term_incentive': 375304,
'shared_receipt_with_poi': 178,
'restricted_stock': 259907,
'director_fees': 0},
'DODSON KEITH': {'salary': 221003,
'to_messages': 176,
'deferral_payments': 0,
'total_payments': 319941,
'loan_advances': 0,
'bonus': 70000,
'email_address': 'keith.dodson@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 28164,
'from_poi_to_this_person': 10,
'exercised_stock_options': 0,
'from_messages': 14,
'other': 774,
'from_this_person_to_poi': 3,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 114,
'restricted_stock': 0,
'director_fees': 0},
'YEAGER F SCOTT': {'salary': 158403,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 360300,
'loan_advances': 0,
'bonus': 0,
'email_address': 'scott.yeager@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 11884758,
'expenses': 53947,
'from_poi_to_this_person': 0,
'exercised_stock_options': 8308552,
'from_messages': 0,
'other': 147950,
'from_this_person_to_poi': 0,
'poi': True,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 3576206,
'director_fees': 0},
'HIRKO JOSEPH': {'salary': 0,
'to_messages': 0,
'deferral_payments': 10259,
'total_payments': 91093,
'loan_advances': 0,
'bonus': 0,
'email_address': 'joe.hirko@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 30766064,
'expenses': 77978,
'from_poi_to_this_person': 0,
'exercised_stock_options': 30766064,
'from_messages': 0,
'other': 2856,
'from_this_person_to_poi': 0,
'poi': True,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'DIETRICH JANET R': {'salary': 250100,
'to_messages': 2572,
'deferral_payments': 0,
'total_payments': 1410464,
'loan_advances': 0,
'bonus': 600000,
'email_address': 'janet.dietrich@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1865087,
'expenses': 3475,
'from_poi_to_this_person': 305,
'exercised_stock_options': 1550019,
'from_messages': 63,
'other': 473,
'from_this_person_to_poi': 14,
'poi': False,
'long_term_incentive': 556416,
'shared_receipt_with_poi': 1902,
'restricted_stock': 315068,
'director_fees': 0},
'DERRICK JR. JAMES V': {'salary': 492375,
'to_messages': 2181,
'deferral_payments': 0,
'total_payments': 550981,
'loan_advances': 0,
'bonus': 800000,
'email_address': 'james.derrick@enron.com',
'restricted_stock_deferred': -1787380,
'deferred_income': -1284000,
'total_stock_value': 8831913,
'expenses': 51124,
'from_poi_to_this_person': 64,
'exercised_stock_options': 8831913,
'from_messages': 909,
'other': 7482,
'from_this_person_to_poi': 20,
'poi': False,
'long_term_incentive': 484000,
'shared_receipt_with_poi': 1401,
'restricted_stock': 1787380,
'director_fees': 0},
'FREVERT MARK A': {'salary': 1060932,
'to_messages': 3275,
'deferral_payments': 6426990,
'total_payments': 17252530,
'loan_advances': 2000000,
'bonus': 2000000,
'email_address': 'mark.frevert@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -3367011,
'total_stock_value': 14622185,
'expenses': 86987,
'from_poi_to_this_person': 242,
'exercised_stock_options': 10433518,
'from_messages': 21,
'other': 7427621,
'from_this_person_to_poi': 6,
'poi': False,
'long_term_incentive': 1617011,
'shared_receipt_with_poi': 2979,
'restricted_stock': 4188667,
'director_fees': 0},
'PAI LOU L': {'salary': 261879,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 3123383,
'loan_advances': 0,
'bonus': 1000000,
'email_address': 'lou.pai@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 23817930,
'expenses': 32047,
'from_poi_to_this_person': 0,
'exercised_stock_options': 15364167,
'from_messages': 0,
'other': 1829457,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 8453763,
'director_fees': 0},
'HAYSLETT RODERICK J': {'salary': 0,
'to_messages': 2649,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'rod.hayslett@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 346663,
'expenses': 0,
'from_poi_to_this_person': 35,
'exercised_stock_options': 0,
'from_messages': 1061,
'other': 0,
'from_this_person_to_poi': 38,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 571,
'restricted_stock': 346663,
'director_fees': 0},
'BAY FRANKLIN R': {'salary': 239671,
'to_messages': 0,
'deferral_payments': 260455,
'total_payments': 827696,
'loan_advances': 0,
'bonus': 400000,
'email_address': 'frank.bay@enron.com',
'restricted_stock_deferred': -82782,
'deferred_income': -201641,
'total_stock_value': 63014,
'expenses': 129142,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 69,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 145796,
'director_fees': 0},
'MCCARTY DANNY J': {'salary': 0,
'to_messages': 1433,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'danny.mccarty@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 758931,
'expenses': 0,
'from_poi_to_this_person': 25,
'exercised_stock_options': 664375,
'from_messages': 215,
'other': 0,
'from_this_person_to_poi': 2,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 508,
'restricted_stock': 94556,
'director_fees': 0},
'FUGH JOHN L': {'salary': 0,
'to_messages': 0,
'deferral_payments': 50591,
'total_payments': 50591,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 176378,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 176378,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'SCRIMSHAW MATTHEW': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 0,
'loan_advances': 0,
'bonus': 0,
'email_address': 'matthew.scrimshaw@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 759557,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 759557,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 0},
'KOENIG MARK E': {'salary': 309946,
'to_messages': 2374,
'deferral_payments': 0,
'total_payments': 1587421,
'loan_advances': 0,
'bonus': 700000,
'email_address': 'mark.koenig@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 1920055,
'expenses': 127017,
'from_poi_to_this_person': 53,
'exercised_stock_options': 671737,
'from_messages': 61,
'other': 150458,
'from_this_person_to_poi': 15,
'poi': True,
'long_term_incentive': 300000,
'shared_receipt_with_poi': 2271,
'restricted_stock': 1248318,
'director_fees': 0},
'SAVAGE FRANK': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 3750,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': -121284,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 125034},
'IZZO LAWRENCE L': {'salary': 85274,
'to_messages': 496,
'deferral_payments': 0,
'total_payments': 1979596,
'loan_advances': 0,
'bonus': 0,
'email_address': 'larry.izzo@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 5819980,
'expenses': 28093,
'from_poi_to_this_person': 28,
'exercised_stock_options': 2165172,
'from_messages': 19,
'other': 1553729,
'from_this_person_to_poi': 5,
'poi': False,
'long_term_incentive': 312500,
'shared_receipt_with_poi': 437,
'restricted_stock': 3654808,
'director_fees': 0},
'TILNEY ELIZABETH A': {'salary': 247338,
'to_messages': 460,
'deferral_payments': 0,
'total_payments': 399393,
'loan_advances': 0,
'bonus': 300000,
'email_address': 'elizabeth.tilney@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -575000,
'total_stock_value': 1168042,
'expenses': 0,
'from_poi_to_this_person': 10,
'exercised_stock_options': 591250,
'from_messages': 19,
'other': 152055,
'from_this_person_to_poi': 11,
'poi': False,
'long_term_incentive': 275000,
'shared_receipt_with_poi': 379,
'restricted_stock': 576792,
'director_fees': 0},
'MARTIN AMANDA K': {'salary': 349487,
'to_messages': 1522,
'deferral_payments': 85430,
'total_payments': 8407016,
'loan_advances': 0,
'bonus': 0,
'email_address': 'a..martin@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 2070306,
'expenses': 8211,
'from_poi_to_this_person': 8,
'exercised_stock_options': 2070306,
'from_messages': 230,
'other': 2818454,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 5145434,
'shared_receipt_with_poi': 477,
'restricted_stock': 0,
'director_fees': 0},
'BUY RICHARD B': {'salary': 330546,
'to_messages': 3523,
'deferral_payments': 649584,
'total_payments': 2355702,
'loan_advances': 0,
'bonus': 900000,
'email_address': 'rick.buy@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -694862,
'total_stock_value': 3444470,
'expenses': 0,
'from_poi_to_this_person': 156,
'exercised_stock_options': 2542813,
'from_messages': 1053,
'other': 400572,
'from_this_person_to_poi': 71,
'poi': False,
'long_term_incentive': 769862,
'shared_receipt_with_poi': 2333,
'restricted_stock': 901657,
'director_fees': 0},
'GRAMM WENDY L': {'salary': 0,
'to_messages': 0,
'deferral_payments': 0,
'total_payments': 119292,
'loan_advances': 0,
'bonus': 0,
'email_address': 0,
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 0,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 0,
'from_messages': 0,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 0,
'restricted_stock': 0,
'director_fees': 119292},
'CAUSEY RICHARD A': {'salary': 415189,
'to_messages': 1892,
'deferral_payments': 0,
'total_payments': 1868758,
'loan_advances': 0,
'bonus': 1000000,
'email_address': 'richard.causey@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -235000,
'total_stock_value': 2502063,
'expenses': 30674,
'from_poi_to_this_person': 58,
'exercised_stock_options': 0,
'from_messages': 49,
'other': 307895,
'from_this_person_to_poi': 12,
'poi': True,
'long_term_incentive': 350000,
'shared_receipt_with_poi': 1585,
'restricted_stock': 2502063,
'director_fees': 0},
'TAYLOR MITCHELL S': {'salary': 265214,
'to_messages': 533,
'deferral_payments': 227449,
'total_payments': 1092663,
'loan_advances': 0,
'bonus': 600000,
'email_address': 'mitchell.taylor@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 3745048,
'expenses': 0,
'from_poi_to_this_person': 0,
'exercised_stock_options': 3181250,
'from_messages': 29,
'other': 0,
'from_this_person_to_poi': 0,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 300,
'restricted_stock': 563798,
'director_fees': 0},
'DONAHUE JR JEFFREY M': {'salary': 278601,
'to_messages': 865,
'deferral_payments': 0,
'total_payments': 875760,
'loan_advances': 0,
'bonus': 800000,
'email_address': 'jeff.donahue@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': -300000,
'total_stock_value': 1080988,
'expenses': 96268,
'from_poi_to_this_person': 188,
'exercised_stock_options': 765920,
'from_messages': 22,
'other': 891,
'from_this_person_to_poi': 11,
'poi': False,
'long_term_incentive': 0,
'shared_receipt_with_poi': 772,
'restricted_stock': 315068,
'director_fees': 0},
'GLISAN JR BEN F': {'salary': 274975,
'to_messages': 873,
'deferral_payments': 0,
'total_payments': 1272284,
'loan_advances': 0,
'bonus': 600000,
'email_address': 'ben.glisan@enron.com',
'restricted_stock_deferred': 0,
'deferred_income': 0,
'total_stock_value': 778546,
'expenses': 125978,
'from_poi_to_this_person': 52,
'exercised_stock_options': 384728,
'from_messages': 16,
'other': 200308,
'from_this_person_to_poi': 6,
'poi': True,
'long_term_incentive': 71023,
'shared_receipt_with_poi': 874,
'restricted_stock': 393818,
'director_fees': 0}}
Now that all NaN values are replaced by 0, we will focus on the 5 variables explaining the interaction with a poi or not poi:</br>
to_messages, from_messages, from_poi_to_this_person, from_this_person_to_poi, shared_receipt_with_poi.
This email data is meaningful information for our prediction of wether an employee will be a POI or not and we will replace, for each of this features, the previously missing values with the mean of the variable grouped by POI profile.
# Replace to_messages = 0 (so previously missing) with the average of to_messages for poi or the average of to_messages
# for not poi, depending on the category of the person
sum_to_messages_poi = 0
sum_to_messages_not_poi = 0
for person in data_dict.keys():
if data_dict[person]['poi'] == True:
sum_to_messages_poi += data_dict[person]['to_messages']
else:
sum_to_messages_not_poi += data_dict[person]['to_messages']
for person in data_dict.keys():
if data_dict[person]['to_messages'] == 0:
if data_dict[person]['poi'] == True:
data_dict[person]['to_messages'] = sum_to_messages_poi/num_poi
else:
data_dict[person]['to_messages'] = sum_to_messages_not_poi/num_not_poi
# Replace from_messages = 0 (so previously missing) with the average of from_messages for poi or the average of from_messages
# for not poi, depending on the category of the person
sum_from_messages_poi = 0
sum_from_messages_not_poi = 0
for person in data_dict.keys():
if data_dict[person]['poi'] == True:
sum_from_messages_poi += data_dict[person]['from_messages']
else:
sum_from_messages_not_poi += data_dict[person]['from_messages']
for person in data_dict.keys():
if data_dict[person]['from_messages'] == 0:
if data_dict[person]['poi'] == True:
data_dict[person]['from_messages'] = sum_to_messages_poi/num_poi
else:
data_dict[person]['from_messages'] = sum_to_messages_not_poi/num_not_poi
# Replace from_poi_to_this_person = 0 (so previously missing) with the average of from_poi_to_this_person for poi or the average of from_poi_to_this_person
# for not poi, depending on the category of the person
sum_from_poi_to_this_person_poi = 0
sum_from_poi_to_this_person_not_poi = 0
for person in data_dict.keys():
if data_dict[person]['poi'] == True:
sum_from_poi_to_this_person_poi += data_dict[person]['from_poi_to_this_person']
else:
sum_from_poi_to_this_person_not_poi += data_dict[person]['from_poi_to_this_person']
for person in data_dict.keys():
if data_dict[person]['from_poi_to_this_person'] == 0:
if data_dict[person]['poi'] == True:
data_dict[person]['from_poi_to_this_person'] = sum_from_poi_to_this_person_poi/num_poi
else:
data_dict[person]['from_poi_to_this_person'] = sum_from_poi_to_this_person_not_poi/num_not_poi
# Replace from_this_person_to_poi = 0 (so previously missing) with the average of from_this_person_to_poi for poi or the average of from_this_person_to_poi
# for not poi, depending on the category of the person
sum_from_this_person_to_poi_poi = 0
sum_from_this_person_to_poi_not_poi = 0
for person in data_dict.keys():
if data_dict[person]['poi'] == True:
sum_from_this_person_to_poi_poi += data_dict[person]['from_this_person_to_poi']
else:
sum_from_this_person_to_poi_not_poi += data_dict[person]['from_this_person_to_poi']
for person in data_dict.keys():
if data_dict[person]['from_this_person_to_poi'] == 0:
if data_dict[person]['poi'] == True:
data_dict[person]['from_this_person_to_poi'] = sum_from_this_person_to_poi_poi/num_poi
else:
data_dict[person]['from_this_person_to_poi'] = sum_from_this_person_to_poi_not_poi/num_not_poi
# Replace shared_receipt_with_poi = 0 (so previously missing) with the average of shared_receipt_with_poi for poi or the average of shared_receipt_with_poi
# for not poi, depending on the category of the person
sum_shared_receipt_with_poi_poi = 0
sum_shared_receipt_with_poi_not_poi = 0
for person in data_dict.keys():
if data_dict[person]['poi'] == True:
sum_shared_receipt_with_poi_poi += data_dict[person]['shared_receipt_with_poi']
else:
sum_shared_receipt_with_poi_not_poi += data_dict[person]['shared_receipt_with_poi']
for person in data_dict.keys():
if data_dict[person]['shared_receipt_with_poi'] == 0:
if data_dict[person]['poi'] == True:
data_dict[person]['shared_receipt_with_poi'] = sum_shared_receipt_with_poi_poi/num_poi
else:
data_dict[person]['shared_receipt_with_poi'] = sum_shared_receipt_with_poi_not_poi/num_not_poi
#Checking if the data has been well modified
import pandas as pd
df = pd.DataFrame.from_dict(data_dict, orient='index')
df.head()
| salary | to_messages | deferral_payments | total_payments | loan_advances | bonus | email_address | restricted_stock_deferred | deferred_income | total_stock_value | ... | from_poi_to_this_person | exercised_stock_options | from_messages | other | from_this_person_to_poi | poi | long_term_incentive | shared_receipt_with_poi | restricted_stock | director_fees | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| METTS MARK | 365788 | 807.0 | 0 | 1061827 | 0 | 600000 | mark.metts@enron.com | 0 | 0 | 585062 | ... | 38.00000 | 0 | 29.0 | 1740 | 1.00000 | False | 0 | 702.000000 | 585062 | 0 |
| BAXTER JOHN C | 267102 | 1129.0 | 1295738 | 5634343 | 0 | 1200000 | 0 | 0 | -1386055 | 10623258 | ... | 32.90625 | 6680544 | 1129.0 | 2660303 | 20.40625 | False | 1586055 | 595.421875 | 3942714 | 0 |
| ELLIOTT STEVEN | 170941 | 1129.0 | 0 | 211725 | 0 | 350000 | steven.elliott@enron.com | 0 | -400729 | 6678735 | ... | 32.90625 | 4890344 | 1129.0 | 12961 | 20.40625 | False | 0 | 595.421875 | 1788391 | 0 |
| CORDES WILLIAM R | 0 | 764.0 | 0 | 0 | 0 | 0 | bill.cordes@enron.com | 0 | 0 | 1038185 | ... | 10.00000 | 651850 | 12.0 | 0 | 20.40625 | False | 0 | 58.000000 | 386335 | 0 |
| HANNON KEVIN P | 243293 | 1045.0 | 0 | 288682 | 0 | 1500000 | kevin.hannon@enron.com | 0 | -3117011 | 6391065 | ... | 32.00000 | 5538001 | 32.0 | 11350 | 21.00000 | True | 1617011 | 1035.000000 | 853064 | 0 |
5 rows × 21 columns
def PlotOutlier(data_dict, feature_x, feature_y):
""" Plot with flag = True in Red """
data = featureFormat(data_dict, [feature_x, feature_y, 'poi'])
for point in data:
x = point[0]
y = point[1]
poi = point[2]
if poi:
color = 'red'
else:
color = 'blue'
plt.scatter(x, y, color=color)
plt.xlabel(feature_x)
plt.ylabel(feature_y)
plt.show()
# 2.1 Visualise outliers
print(PlotOutlier(data_dict, 'total_payments', 'total_stock_value'))
print(PlotOutlier(data_dict, 'from_poi_to_this_person', 'from_this_person_to_poi'))
print(PlotOutlier(data_dict, 'salary', 'bonus'))
#Remove outlier TOTAL line in pickle file.
data_dict.pop( 'TOTAL', 0 )
None
None
None
{'salary': 26704229,
'to_messages': 1129.0,
'deferral_payments': 32083396,
'total_payments': 309886585,
'loan_advances': 83925000,
'bonus': 97343619,
'email_address': 0,
'restricted_stock_deferred': -7576788,
'deferred_income': -27992891,
'total_stock_value': 434509511,
'expenses': 5235198,
'from_poi_to_this_person': 32.90625,
'exercised_stock_options': 311764000,
'from_messages': 1129.0,
'other': 42667589,
'from_this_person_to_poi': 20.40625,
'poi': False,
'long_term_incentive': 48521928,
'shared_receipt_with_poi': 595.421875,
'restricted_stock': 130322299,
'director_fees': 1398517}
The "total row" value displayed in the outliers plots is taken off, as it is not relevant information and will distort our resuls.
# Visualise without otuliers
print(PlotOutlier(data_dict, 'total_payments', 'total_stock_value'))
print(PlotOutlier(data_dict, 'from_poi_to_this_person', 'from_this_person_to_poi'))
print(PlotOutlier(data_dict, 'salary', 'bonus'))
None
None
None
data_dict.keys()
print('Total number of data points: %d' % len(data_dict.keys()))
Total number of data points: 145
Considering the visualization of our outliers, we try to identify the people we could remove from our model according to their high salary and/or bonus, and that have not been identified as POI
for person in data_dict.keys():
if (data_dict[person]['salary'] > 500000 or (data_dict[person]['bonus'] > 1100000 and data_dict[person]['salary'] > 260000)) and data_dict[person]['poi'] == False:
print(person)
BAXTER JOHN C MCMAHON JEFFREY HAEDICKE MARK E KITCHEN LOUISE SHANKMAN JEFFREY A LAVORATO JOHN J SHERRIFF JOHN R WHALLEY LAWRENCE G FALLON JAMES B PICKERING MARK R FREVERT MARK A
From this list of people with very high salaries and/or bonuses but that are not identified as POI, we decided to remove from our study four of them who had upper-level executive positions and are not representative of the average Enron employee:
As we saw a step above, we also will remove the TOTAL row from our dataset.
Two other already identified outliers are "THE TRAVEL AGENCY IN THE PARK" that is not a person, along with "LOCKHART EUGENE E" who has no feature values.
# 2.2 Function to remove outliers
def remove_outlier(dict_object, keys):
""" removes list of outliers keys from dict object """
for key in keys:
dict_object.pop(key, 0)
outliers = ['TOTAL','THE TRAVEL AGENCY IN THE PARK', 'LOCKHART EUGENE E', 'FREVERT MARK A', 'WHALLEY LAWRENCE G', 'BAXTER JOHN C', 'LAVORATO JOHN J']
remove_outlier(data_dict, outliers)
data_dict.keys()
print('Total number of data points after removing the outliers: %d' % len(data_dict.keys()))
Total number of data points after removing the outliers: 139
# 3.1 create new copies of dataset for grading
my_dataset = data_dict
## 3.2 add new features to dataset
def compute_fraction(poi_messages, all_messages):
""" return fraction of messages from/to that person to/from POI"""
if poi_messages == 0 or all_messages == 0:
return 0.
fraction = poi_messages / all_messages
return fraction
for name in my_dataset:
data_point = my_dataset[name]
from_poi_to_this_person = data_point["from_poi_to_this_person"]
to_messages = data_point["to_messages"]
fraction_from_poi = compute_fraction(from_poi_to_this_person, to_messages)
data_point["fraction_from_poi"] = fraction_from_poi
from_this_person_to_poi = data_point["from_this_person_to_poi"]
from_messages = data_point["from_messages"]
fraction_to_poi = compute_fraction(from_this_person_to_poi, from_messages)
data_point["fraction_to_poi"] = fraction_to_poi
shared_receipt_with_poi = data_point["shared_receipt_with_poi"]
fraction_shared_poi = compute_fraction(shared_receipt_with_poi,to_messages)
data_point["fraction_shared_poi"] = fraction_shared_poi
bonus = data_point["bonus"]
salary = data_point["salary"]
total_payments = data_point["total_payments"]
bonus_to_salary = compute_fraction(bonus, salary)
data_point["bonus_to_salary"] = bonus_to_salary
bonus_to_total = compute_fraction(bonus, total_payments)
data_point["bonus_to_total"] = bonus_to_total
# 3.3 create new copies of feature list for grading
my_feature_list = features_list + ['fraction_to_poi', 'fraction_from_poi', 'fraction_shared_poi']
my_feature_list
['poi', 'bonus', 'deferral_payments', 'deferred_income', 'director_fees', 'exercised_stock_options', 'expenses', 'loan_advances', 'long_term_incentive', 'other', 'restricted_stock', 'restricted_stock_deferred', 'salary', 'total_payments', 'total_stock_value', 'from_messages', 'from_poi_to_this_person', 'from_this_person_to_poi', 'shared_receipt_with_poi', 'to_messages', 'fraction_to_poi', 'fraction_from_poi', 'fraction_shared_poi']
After computing our model with a different number of features, we found out that 4 was the number of variables giving the best results with our data. We used the function with selectKBest to get the list of the 4 highest scoring features.
# 3.4 get K-best features
num_features = 4
# 3.5 function using SelectKBest
def get_k_best(data_dict, features_list, k):
""" runs scikit-learn's SelectKBest feature selection
returns dict where keys=features, values=scores
"""
data = featureFormat(data_dict, features_list)
labels, features = targetFeatureSplit(data)
k_best = SelectKBest(k=k)
k_best.fit(features, labels)
scores = k_best.scores_
print(scores)
unsorted_pairs = zip(features_list[1:], scores)
sorted_pairs = list(reversed(sorted(unsorted_pairs, key=lambda x: x[1])))
k_best_features = dict(sorted_pairs[:k])
print ("{0} best features: {1}\n".format(k, k_best_features.keys(), scores))
return k_best_features
best_features = get_k_best(my_dataset, my_feature_list, num_features)
my_feature_list = [target_label] + list(set(best_features.keys()))
[35.7816913 0.06233576 16.95719491 2.20445373 26.5605672 6.27032312 7.00482086 12.56239963 7.79759949 10.37309462 0.06764556 25.10415132 9.53332413 26.46587154 0.30567116 15.2720836 3.47344864 18.28791085 2.28927786 0.24257597 0.07157541 16.00167138] 4 best features: dict_keys(['bonus', 'exercised_stock_options', 'total_stock_value', 'salary'])
# 3.6 print features
print ("{0} selected features: {1}\n".format(len(my_feature_list) - 1, my_feature_list[1:]))
4 selected features: ['total_stock_value', 'exercised_stock_options', 'bonus', 'salary']
# 3.7 extract the features specified in features_list
data = featureFormat(my_dataset, my_feature_list,sort_keys = True)
# split into labels and features
labels, features = targetFeatureSplit(data)
# 3.8 scale features via min-max
from sklearn import preprocessing
scaler = preprocessing.MinMaxScaler()
features = scaler.fit_transform(features)
import warnings
warnings.filterwarnings("ignore")
###4.1 Gaussian Naive Bayes Classifier
from sklearn.naive_bayes import GaussianNB
g_clf = GaussianNB()
###4.2 Logistic Regression Classifier
from sklearn.linear_model import LogisticRegression
l_clf = Pipeline(steps=[
('scaler', StandardScaler()),
('classifier', LogisticRegression(C=1e-08, class_weight=None, dual=False, fit_intercept=True, intercept_scaling=1,
max_iter=100, multi_class='ovr', penalty='l2', random_state=42, solver='liblinear', tol=0.001, verbose=0))])
###4.3 K-means Clustering
from sklearn.cluster import KMeans
k_clf = KMeans(n_clusters=2, tol=0.001)
###4.4 Support Vector Machine Classifier
from sklearn.svm import SVC
s_clf = SVC(kernel='rbf', C=1000,gamma = 0.0001,random_state = 42, class_weight = 'balanced')
###4.5 Random Forest
from sklearn.ensemble import RandomForestClassifier
rf_clf = RandomForestClassifier(max_depth = 5,max_features = 'sqrt',n_estimators = 10, random_state = 42)
###4.6 Gradient Boosting Classifier
from sklearn.ensemble import GradientBoostingClassifier
gb_clf = GradientBoostingClassifier(loss='deviance', learning_rate=0.1, n_estimators=100,random_state = 42)
###4.7 evaluate function
def evaluate_clf(clf, features, labels, num_iters=1000, test_size=0.3):
print (clf)
accuracy = []
precision = []
recall = []
first = True
for trial in range(num_iters):
features_train, features_test, labels_train, labels_test =\
train_test_split(features, labels, test_size=test_size)
clf.fit(features_train, labels_train)
predictions = clf.predict(features_test)
accuracy.append(accuracy_score(labels_test, predictions))
precision.append(precision_score(labels_test, predictions))
recall.append(recall_score(labels_test, predictions))
if trial % 10 == 0:
if first:
sys.stdout.write('\nProcessing')
sys.stdout.write('.')
sys.stdout.flush()
first = False
print ("done.\n")
print ("precision: {}".format(mean(precision)))
print ("recall: {}".format(mean(recall)))
return mean(precision), mean(recall)
### 4.8 Evaluate all functions
evaluate_clf(g_clf, features, labels)
evaluate_clf(l_clf, features, labels)
evaluate_clf(k_clf, features, labels)
evaluate_clf(s_clf, features, labels)
evaluate_clf(rf_clf, features, labels)
evaluate_clf(gb_clf, features, labels)
### Select Logistic Regression as final algorithm
clf = l_clf
# dump your classifier, dataset and features_list so
# anyone can run/check your results
pickle.dump(clf, open("../final_project/my_classifier.pkl", "wb"))
pickle.dump(my_dataset, open("../final_project/my_dataset.pkl", "wb"))
pickle.dump(my_feature_list, open("../final_project/my_feature_list.pkl", "wb"))
GaussianNB()
Processing....................................................................................................done.
precision: 0.500300505050505
recall: 0.36895656565656565
Pipeline(steps=[('scaler', StandardScaler()),
('classifier',
LogisticRegression(C=1e-08, multi_class='ovr', random_state=42,
solver='liblinear', tol=0.001))])
Processing....................................................................................................done.
precision: 0.573896028971029
recall: 0.34958174603174597
KMeans(n_clusters=2, tol=0.001)
Processing....................................................................................................done.
precision: 0.322760586811512
recall: 0.3449353896103896
SVC(C=1000, class_weight='balanced', gamma=0.0001, random_state=42)
Processing....................................................................................................done.
precision: 0.5629471457438331
recall: 0.17624101731601732
RandomForestClassifier(max_depth=5, max_features='sqrt', n_estimators=10,
random_state=42)
Processing....................................................................................................done.
precision: 0.515594227994228
recall: 0.2788791125541125
GradientBoostingClassifier(random_state=42)
Processing....................................................................................................done.
precision: 0.4893010822510822
recall: 0.3428220057720058
We decided to poursue our classification with the logistic regression as it presented the best precision and recall metrics for our data.
### Check the tester.py script in the final project
### folder for details on the evaluation method, especially the test_classifier
### function. Because of the small size of the dataset, the script uses
### stratified shuffle split cross validation. For more info:
### http://scikit-learn.org/stable/modules/generated/sklearn.cross_validation.StratifiedShuffleSplit.html
# Example starting point. Try investigating other evaluation techniques!
features_train, features_test, labels_train, labels_test = \
train_test_split(features, labels, test_size=0.3, random_state=42)
In order to find the best parameters for our logistic regression we used the GridSearchCV algorithm, which also employs cross validation with the StratifiedKFolds cross-validator.
from sklearn.model_selection import GridSearchCV
from sklearn.linear_model import LogisticRegression
from sklearn.metrics import accuracy_score, precision_score, recall_score, f1_score, make_scorer, confusion_matrix
from sklearn.model_selection import StratifiedKFold
import numpy as np
#pipe = Pipeline([('classifier' , LogisticRegression())])
pipe = LogisticRegression()
solvers = ['newton-cg', 'lbfgs', 'liblinear']
penalty = ['l1','l2']
c_values = np.logspace(-4, 4, 20)
n_features = np.arange(1, len(features_list))
param_grid = {
'solver' : solvers,
'penalty' : penalty,
'C' : c_values
}
cv = StratifiedKFold(n_splits=10)
scorers = {
'precision_score': make_scorer(precision_score),
'recall_score': make_scorer(recall_score),
'accuracy_score': make_scorer(accuracy_score),
'f1_score' : make_scorer(f1_score)
}
We chose to optimise the F1 score because it conveys the balance between the precision and the recall.
def grid_search_wrapper(refit_score='f1_score'):
cv = StratifiedKFold(n_splits=10)
best_clf = GridSearchCV(pipe, param_grid, scoring=scorers, refit=refit_score,
cv=cv, return_train_score=True, n_jobs=-1)
best_clf.fit(features_train, labels_train)
# make the predictions
y_pred = best_clf.predict(features_test)
print('Best params for {}'.format(refit_score))
print(best_clf.best_params_)
# confusion matrix on the test data.
print('\nConfusion matrix of Logistic Regression optimized for {} on the test data:'.format(refit_score))
print(pd.DataFrame(confusion_matrix(labels_test, y_pred),
columns=['pred_neg', 'pred_pos'], index=['neg', 'pos']))
return best_clf
grid_search_clf = grid_search_wrapper(refit_score='f1_score')
Best params for f1_score
{'C': 1.623776739188721, 'penalty': 'l1', 'solver': 'liblinear'}
Confusion matrix of Logistic Regression optimized for f1_score on the test data:
pred_neg pred_pos
neg 32 0
pos 5 1
# Assigning best parameters to logistic regression
from sklearn.linear_model import LogisticRegression
l_clf = Pipeline(steps=[
('scaler', StandardScaler()),
('classifier', LogisticRegression(C=1.623776739188721, class_weight='balanced', dual=False, fit_intercept=True, intercept_scaling=1,
max_iter=100, multi_class='ovr', penalty='l1', random_state=42, solver='liblinear', tol=0.001, verbose=0))])
# Updating parameters for logistic regression
clf = l_clf
The code below was used for the tuning of the random forest. However it should not be used as in the end we chose logistic regression, which has better results.
from sklearn.model_selection import GridSearchCV
from sklearn.ensemble import RandomForestClassifier
from sklearn.model_selection import RepeatedStratifiedKFold
from sklearn.metrics import accuracy_score, precision_score, recall_score, f1_score, make_scorer, confusion_matrix
from sklearn.model_selection import StratifiedKFold
import numpy as np
pipe = RandomForestClassifier(n_jobs=-1)
param_grid = {
'min_samples_split': [3, 5, 10],
'n_estimators' : [100, 300],
'max_depth': [3, 5, 15, 25],
'max_features': [3, 5, 10, 20]
}
scorers = {
'precision_score': make_scorer(precision_score),
'recall_score': make_scorer(recall_score),
'accuracy_score': make_scorer(accuracy_score),
'f1_score' : make_scorer(f1_score)
}
def grid_search_wrapper(refit_score='f1_score'):
cv = StratifiedKFold(n_splits=10)
best_clf = GridSearchCV(pipe, param_grid, scoring=scorers, refit=refit_score,
cv=cv, return_train_score=True, n_jobs=-1)
best_clf.fit(features_train, labels_train)
# make the predictions
predict = best_clf.predict(features_test)
print('Best params for {}'.format(refit_score))
print(best_clf.best_params_)
# confusion matrix on the test data.
print('\nConfusion matrix of Random Forest optimized for {} on the test data:'.format(refit_score))
print(pd.DataFrame(confusion_matrix(labels_test, predict),
columns=['pred_neg', 'pred_pos'], index=['neg', 'pos']))
return best_clf
# Assigning best parameters to random forest
grid_search_clf = grid_search_wrapper(refit_score='f1_score')
Best params for f1_score
{'max_depth': 3, 'max_features': 3, 'min_samples_split': 3, 'n_estimators': 100}
Confusion matrix of Random Forest optimized for f1_score on the test data:
pred_neg pred_pos
neg 32 0
pos 5 1
rf_clf = RandomForestClassifier(max_depth = 15 , max_features = 3 , n_estimators = 300, random_state = 42, min_samples_split = 5)
###You do not need to change anything below, but make sure
### that the version of poi_id.py that you submit can be run on its own and
### generates the necessary .pkl files for validating your results.
dump_classifier_and_data(clf, my_dataset, features_list)
#TESTER.PY
#!/usr/bin/pickle python -W ignore::DeprecationWarning
""" a basic script for importing student's POI identifier,
and checking the results that they get from it
requires that the algorithm, dataset, and features list
be written to my_classifier.pkl, my_dataset.pkl, and
my_feature_list.pkl, respectively
that process should happen at the end of poi_id.py
"""
import pickle
import sys
sys.path.append("../tools/")
from feature_format import featureFormat, targetFeatureSplit
from sklearn.model_selection import StratifiedShuffleSplit
PERF_FORMAT_STRING = "\
\tAccuracy: {:>0.{display_precision}f}\tPrecision: {:>0.{display_precision}f}\t\
Recall: {:>0.{display_precision}f}\tF1: {:>0.{display_precision}f}\tF2: {:>0.{display_precision}f}"
RESULTS_FORMAT_STRING = "\tTotal predictions: {:4d}\tTrue positives: {:4d}\tFalse positives: {:4d}\
\tFalse negatives: {:4d}\tTrue negatives: {:4d}"
def test_classifier(clf, dataset, feature_list, folds = 1000):
data = featureFormat(dataset, feature_list, sort_keys = True)
labels, features = targetFeatureSplit(data)
cv = StratifiedShuffleSplit(n_splits=folds, random_state=42)
true_negatives = 0
false_negatives = 0
true_positives = 0
false_positives = 0
for train_idx, test_idx in cv.split(features, labels):
features_train = []
features_test = []
labels_train = []
labels_test = []
for ii in train_idx:
features_train.append( features[ii] )
labels_train.append( labels[ii] )
for jj in test_idx:
features_test.append( features[jj] )
labels_test.append( labels[jj] )
### fit the classifier using training set, and test on test set
clf.fit(features_train, labels_train)
predictions = clf.predict(features_test)
for prediction, truth in zip(predictions, labels_test):
if prediction == 0 and truth == 0:
true_negatives += 1
elif prediction == 0 and truth == 1:
false_negatives += 1
elif prediction == 1 and truth == 0:
false_positives += 1
elif prediction == 1 and truth == 1:
true_positives += 1
else:
print ("Warning: Found a predicted label not == 0 or 1.")
print ("All predictions should take value 0 or 1.")
print ("Evaluating performance for processed predictions:")
break
try:
total_predictions = true_negatives + false_negatives + false_positives + true_positives
accuracy = 1.0*(true_positives + true_negatives)/total_predictions
precision = 1.0*true_positives/(true_positives+false_positives)
recall = 1.0*true_positives/(true_positives+false_negatives)
f1 = 2.0 * true_positives/(2*true_positives + false_positives+false_negatives)
f2 = (1+2.0*2.0) * precision*recall/(4*precision + recall)
print (clf)
print (PERF_FORMAT_STRING.format(accuracy, precision, recall, f1, f2, display_precision = 5))
print (RESULTS_FORMAT_STRING.format(total_predictions, true_positives, false_positives, false_negatives, true_negatives))
print ("")
except:
print ("Got a divide by zero when trying out:", clf)
print ("Precision or recall may be undefined due to a lack of true positive predicitons.")
CLF_PICKLE_FILENAME = "my_classifier.pkl"
DATASET_PICKLE_FILENAME = "my_dataset.pkl"
FEATURE_LIST_FILENAME = "my_feature_list.pkl"
def dump_classifier_and_data(clf, dataset, feature_list):
with open(CLF_PICKLE_FILENAME, "wb") as clf_outfile:
pickle.dump(clf, clf_outfile)
with open(DATASET_PICKLE_FILENAME, "wb") as dataset_outfile:
pickle.dump(dataset, dataset_outfile)
with open(FEATURE_LIST_FILENAME, "wb") as featurelist_outfile:
pickle.dump(feature_list, featurelist_outfile)
def load_classifier_and_data():
with open(CLF_PICKLE_FILENAME, "rb") as clf_infile:
clf = pickle.load(clf_infile)
with open(DATASET_PICKLE_FILENAME, "rb") as dataset_infile:
dataset = pickle.load(dataset_infile)
with open(FEATURE_LIST_FILENAME, "rb") as featurelist_infile:
feature_list = pickle.load(featurelist_infile)
return clf, dataset, feature_list
def main():
### load up student's classifier, dataset, and feature_list
clf, dataset, feature_list = load_classifier_and_data()
### Run testing script
test_classifier(clf, dataset, feature_list)
if __name__ == '__main__':
main()
Pipeline(steps=[('scaler', StandardScaler()),
('classifier',
LogisticRegression(C=1.623776739188721,
class_weight='balanced', multi_class='ovr',
penalty='l1', random_state=42,
solver='liblinear', tol=0.001))])
Accuracy: 0.82286 Precision: 0.42448 Recall: 0.67450 F1: 0.52105 F2: 0.60342
Total predictions: 14000 True positives: 1349 False positives: 1829 False negatives: 651 True negatives: 10171
The feature selection with SelectKBest resulted in 4 features we would not have intuitively think of:
'exercised_stock_options', 'salary', 'total_stock_value', and 'bonus'.
Indeed what would come naturally to the human mind would be features such as the number of emails from/to a POI received or sent by an Enron employee.
We can consider that using this algorithm enabled us to achieve higher metrics, in the same way as the GridSearchCV for tuning our logistic regression parameters.
Our final results have a precision score of 0.424 and a recall score of 0.675. This translates as of all the people identified as POI by our model 42.4% were indeed POI, and that our model identified 67.5% of the POI present in the dataset as such.
Those scores might appear as quite low but we had to consider a relatively small dataset to build our model. Moreover the number of non-POI in the dataset is way higher than the number of POI (128 to 18), which make it more difficult to create a reliable algorithm to detect the POI.
Another way to improve these scores would be to explore the email data we have not handled, which might lead to the finding of new interesting patterns and more accuracy in our prediction.