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.