Email-blog

Classified emails taken from the public Enron repository.

@kaggle.mikeschmidtavemac_emailblog

Table List

1 table(21.63 MB)

Supervised Email Train

@kaggle.mikeschmidtavemac_emailblog.supervised_email_train

21.63 MB
83691 rows
19 columns

datetime DateTime	day Day	outside_hours Outside Hours	from_address From Address	to_address To Address	cc_address Cc Address	subject Subject	forwarded Forwarded	source Source	body Body	datetime_ts DateTime TS	datetime_hour DateTime HOUR	datetime_month DateTime MONTH	class_sentiment_1 Class Sentiment 1	class_sentiment_2 Class Sentiment 2	class_sentiment_vader Class Sentiment Vader	class_alignment_1 Class Alignment 1	class_alignment_2 Class Alignment 2	class_alignment_3 Class Alignment 3
Thu Nov 15 2001 16:29:57 GMT+0000 (Coordinated Universal Time)	3		['cora.pendergrass@enron.com']	['jana.mills@enron.com', 'james.simpson@enron.com', 'l..mims@enron.com', 's..shively@enron.com', 'brian.kinsey@enron.com', 't..muzzy@enron.com']	['']	FW: Holiday nominations	true	deleted	FYI	1005841797	8	11	unknown	unknown	pos	unknown	unknown	unknown
Thu Nov 08 2001 22:34:22 GMT+0000 (Coordinated Universal Time)	3		['ora.cross@enron.com']	['l..mims@enron.com']	['']	RE: What's Going On		deleted	Hey Homey, I really do need to leave at 5:00. If anything changes I will let you know. Thanks	1005258862	14	11	unknown	pos	pos	work	work	work
Mon Oct 08 2001 15:51:38 GMT+0000 (Coordinated Universal Time)			['veronica.espinoza@enron.com']	['r..brackett@enron.com', 's..bradford@enron.com', 'r..conner@enron.com', 'genia.fitzgerald@enron.com', 'patrick.hanse@enron.com', 'ann.murphy@enron.com', 's..theriot@enron.com', 'christian.yoder@enron.com', 'j..miller@enron.com', 'steve.neal@enron.com', 's..olinger@enron.com', 'h..otto@enron.com', …	['']	Credit Watch List--Week of 10/8/01		deleted	Attached is a revised Credit Watch listing for the week of 100801. Please note that Federal-Mogul Corp. was placed on "NO TRADES". If there are any personnel in your group that were not included in this distribution, please insure that they receive a copy of this report. To add additional people to …	1002556298	8	10	neg	pos	pos	work	work	fun
Mon Oct 29 2001 16:51:46 GMT+0000 (Coordinated Universal Time)			['d..hogan@enron.com']	['l..mims@enron.com']	['']	Flight Prices		deleted	Continental has a price of $297.17(non-refundable) for the following roundtrip flights: Depart Houston, Nov. 8 1:40 PM - 4:08 PM Depart Chicago, Nov. 11 11:05 AM - 1:38 PM United has a price of $259.12 (non-refundable) for the following roundtrip flights: Depart Houston, Nov. 8 12:50 PM - 3:15 PM or…	1004374306	8	10	pos	pos	pos	work	work	work
Wed Oct 24 2001 21:17:19 GMT+0000 (Coordinated Universal Time)	2		['darren.vanek@enron.com']	['l..mims@enron.com']	['']	Cilcorp Energy Services		deleted	You hurt my feelings bc you didn't wait for my call. Give me a call when you can. -d	1003958239	14	10	neg	pos	neg	work	work	work
Thu Jan 31 2002 17:44:28 GMT+0000 (Coordinated Universal Time)	3		['cheryl.johnson@enron.com']	['laurel.adams@enron.com', 'bridgette.anderson@enron.com', 'cyndie.balfour-flanagan@enron.com', 'edward.baughman@enron.com', 'bryce.baxter@enron.com', 'georgia.blanchard@enron.com', 'fred.boas@enron.com', 'bob.bowen@enron.com', 'r..brackett@enron.com', 'kathryn.bussell@enron.com', 'anthony.campos@en…	['']	Name Change Notification Report-Jan 2002		deleted	Attached is the final notification report for January, 2002. Click below, then click FETCH to view. http:nahou-dmagn01penalivelink.exe?funcll.loginusernameGCPGuestpasswordnextURL%2fena%2flivelink.exe?funcll%26objId965334objActionbrowsesortname Documents should be available for review on Friday, Feb …	1012499068	9	1	pos	pos	pos	work	work	work
Tue Oct 23 2001 18:29:07 GMT+0000 (Coordinated Universal Time)	1		['cora.pendergrass@enron.com']	['james.simpson@enron.com', 'l..mims@enron.com', 'geoff.storey@enron.com', 'richard.tomaski@enron.com']	['jessica.white@enron.com', 'brian.wesneske@enron.com', 'lisa.kinsey@enron.com']	New Meters and products on PGLC		deleted	The basic reason we are changing meters in Sitara is because when PGLC was originally set up, the meters were set up using the same name as what the pipeline called them, i.e. NGPL909265. This is the NGPL meter number NOT the PGLC meter number. The PGLC Meter number is PGLCNGPL. The only reason we …	1003861747	11	10	pos	pos	pos	work	work	work
Mon Oct 22 2001 19:45:32 GMT+0000 (Coordinated Universal Time)			['cora.pendergrass@enron.com']	['richard.tomaski@enron.com', 'robin.rodrigue@enron.com', 'daryll.fuentes@enron.com', 'mark.mixon@enron.com', 'steve.richman@enron.com', 'kay.classen@enron.com', 'lee.fascetti@enron.com', 'l..mims@enron.com', 'james.simpson@enron.com', 'geoff.storey@enron.com']	['lisa.kinsey@enron.com', 'brian.wesneske@enron.com', 'jessica.white@enron.com', 'm..love@enron.com']	New Meters for PGLC		deleted	We are going to try to get to the point of uploading our nomination into pegasys this month so we are changing the meters to correctly reflect what Sitara has vs what PGLC has. The trade zone TTP is available now and I am going forward and moving November deals into the new trade zone. I am making a…	1003779932	12	10	pos	pos	pos	work	work	work
Thu Oct 25 2001 13:52:26 GMT+0000 (Coordinated Universal Time)	3	true	['d..hogan@enron.com']	['lindsay.culotta@enron.com', 'bryant.frihart@enron.com', 'c..giron@enron.com', 'laura.luce@enron.com', 'l..mims@enron.com', 'e.murrell@enron.com', 'gregg.penman@enron.com', 's..pollan@enron.com', 'linda.roberts@enron.com', 'patrick.tucker@enron.com']	['']	FW: Originators Meeting	true	deleted	THIS MEETING WILL TAKE PLACE IN 30C1	1004017946	6	10	unknown	unknown	neu	work	work	fun
Mon Oct 15 2001 22:01:21 GMT+0000 (Coordinated Universal Time)			['richard.tomaski@enron.com']	['l..mims@enron.com']	['']	RE: PEPL Class		deleted	Thanks. I've sent you the NGPL presentation. Nothing Earth shattering, but you may find some of the expansion storage info interesting.	1003183281	15	10	neg	pos	pos	work	work	work


CREATE TABLE supervised_email_train (
  "datetime" VARCHAR,
  "day" BIGINT,
  "outside_hours" BOOLEAN,
  "from_address" VARCHAR,
  "to_address" VARCHAR,
  "cc_address" VARCHAR,
  "subject" VARCHAR,
  "forwarded" BOOLEAN,
  "source" VARCHAR,
  "body" VARCHAR,
  "datetime_ts" DOUBLE,
  "datetime_hour" BIGINT,
  "datetime_month" BIGINT,
  "class_sentiment_1" VARCHAR,
  "class_sentiment_2" VARCHAR,
  "class_sentiment_vader" VARCHAR,
  "class_alignment_1" VARCHAR,
  "class_alignment_2" VARCHAR,
  "class_alignment_3" VARCHAR
);