In [1]:
%matplotlib inline
from matplotlib import pylab as pl
import cPickle as pickle
import pandas as pd
import numpy as np
import os
import random
In [15]:
np.array([[np.array([[3,4,5]])]])[0,0][0]
Out[15]:
array([3, 4, 5])
In [2]:
!ls ~/Downloads/shiri*
/Users/udi/Downloads/shiri-140908.csv
/Users/udi/Downloads/shiri-140908.csv.links
/Users/udi/Downloads/shiri-141006-1.csv
/Users/udi/Downloads/shiri-141006-1.csv.links
/Users/udi/Downloads/shiri-141006-2.csv
/Users/udi/Downloads/shiri-141006-2.csv.links
/Users/udi/Downloads/shiri-141006-3.csv
/Users/udi/Downloads/shiri-141006-3.csv.links
In [4]:
!head /Users/udi/Downloads/shiri-140908.csv
In [5]:
df = pd.read_csv('/Users/udi/Downloads/shiri-140908.csv')
In [14]:
df = df.set_index('mpid')
In [21]:
df['domain'] = df['ContactEmailAddress'].apply(lambda x: x[x.find('@')+1:])
In [22]:
df
Out[22]:
CompanyName
ContactFirstName
ContactLastName
ContactTitle
ContactEmailAddress
linkedin_profile_url
domain
mpid
46690386
Hitachi Data Systems
Tony
Guerrero
Director Of Customer Relations
tony.guerrero@hds.com
www.linkedin.com/pub/tony-guerrero/5/472/3b2
hds.com
46683821
Hitachi Data Systems
Greg
Sanders
Customer Relationship Manager
greg.sanders@hds.com
www.linkedin.com/pub/greg-sanders/8/A53/26
hds.com
46682903
Hitachi Data Systems
Frank
Lukacs
Customer Relationship Manager
frank.lukacs@hds.com
www.linkedin.com/pub/frank-lukacs/0/6b5/3ab
hds.com
46691273
Hitachi Data Systems
Bob
Born
Customer Relationship Manager
bob@hds.com
www.linkedin.com/pub/bob-born/4/393/365
hds.com
52561683
Hitachi Data Systems
Andrew
Hastings
Technical Support Team Leader
andrewh@hds.com
www.linkedin.com/pub/andrew-hastings/57/497/592
hds.com
104253205
Hitachi Data Systems
Alan
Johns
District Manager , Customer Service and Suppor...
alan.johns@hds.com
www.linkedin.com/pub/alan-johns/47/b87/b34
hds.com
53654091
Hitachi Data Systems
Connie
Wai
Master Client Services Project-Program Manager
connie@hds.com
sg.linkedin.com/pub/connie-wai/8/195/aa1
hds.com
46684457
Hitachi Data Systems
Mitch
McCradic
Account Manager
mitch.mccradic@hds.com
www.linkedin.com/pub/mitch-mccradic/85/591/5a9
hds.com
46680043
Hitachi Data Systems
Tim
Stiles
Customer Service And Support Manager
tim.stiles@hds.com
www.linkedin.com/pub/tim-stiles/6/2a4/a09
hds.com
49968416
Hitachi Data Systems
Nicky
Wang
Customer Service Manager
nickyw@hds.com
www.linkedin.com/pub/nicky-wang/4b/b31/bb2
hds.com
46717065
Hitachi Data Systems
Peter
Vranckx
Customer Services Manager - Crit Sit Manager
peter.vranckx@hds.com
www.linkedin.com/pub/peter-vranckx/6/a71/1ba
hds.com
46681294
Hitachi Data Systems
Lanny
Jennings
Customer Relationship Manager
lanny@hds.com
www.linkedin.com/pub/lanny-jennings/37/b47/911
hds.com
46717334
Hitachi Data Systems
Chris
Lobban
Customer Relationship Manager / Territory Manager
chrisl@hds.com
www.linkedin.com/pub/chris-lobban/9/4a5/594
hds.com
104247862
Hitachi Data Systems
Dan
Howe
Customer Relationship Mgr
dan.howe@hds.com
www.linkedin.com/pub/dan-howe/10/529/31a
hds.com
46688512
Hitachi Data Systems
Andrew
Scarman
Manager - Customer Services
andrews@hds.com
www.linkedin.com/pub/andrew-scarman/10/334/94
hds.com
104258389
Hitachi Data Systems
Sam
Lusk
District Manager of Customer Service and Support
saml@hds.com
www.linkedin.com/pub/sam-lusk/13/b91/39a
hds.com
46683232
Hitachi Data Systems
Lou
Mackenzie
District Customer Service and Support Manager
lou.mackenzie@hds.com
www.linkedin.com/pub/lou-mackenzie/13/738/94
hds.com
46657526
Hitachi Data Systems
Paul
Carnell
Sales Support.Post-Sales.Customer Support Mana...
paul@hds.com
www.linkedin.com/in/paulcarnell
hds.com
104253504
Hitachi Data Systems
Kevin
Taylor
Senior District Manager, Customer Service & Su...
kevin.taylor@hds.com
www.linkedin.com/pub/kevin-taylor/20/925/961
hds.com
46683793
Hitachi Data Systems
Joe
Stadler
Customer Service and Support District Manager
joe.stadler@hds.com
www.linkedin.com/pub/joe-stadler/6/871/ab9
hds.com
103875205
DealerTrack Holdings
Jonathan
Wettstein
Crm Manager
jonathan.wettstein@dealertrack.com
www.linkedin.com/pub/jonathan-wettstein/11/2b6...
dealertrack.com
101007593
MedAssets
Denise
Schmidt
Director, Client Relations
dschmidt@medassets.com
www.linkedin.com/in/deniseschmidt14
medassets.com
104208304
MedAssets
Ann
Pentz
Senior Vice President, Client Executives
apentz@medassets.com
www.linkedin.com/pub/ann-pentz/14/267/99b
medassets.com
46703815
MedAssets
Jessica
Andrisani
Manager, Client Implement and Services
jandrisani@medassets.com
www.linkedin.com/pub/jessica-andrisani-schmid/...
medassets.com
101015117
MedAssets
Dana
Mojica
Vice President, Client Management - NE Zone
dmojica@medassets.com
www.linkedin.com/pub/dana-mojica/12/587/864
medassets.com
111194746
MedAssets
Amy
Sebero
General Manager and Senior Vice President , RC...
amsebero@medassets.com
www.linkedin.com/pub/amy-sebero/2/135/405
medassets.com
104195588
MedAssets
Charlie
Kirkpatrick
Vice President, Client Executive
ckirkpatrick@medassets.com
www.linkedin.com/pub/charlie-kirkpatrick/18/b7...
medassets.com
104206818
MedAssets
Leslie
Flowers
Vice President, Strategic Client Management
lflowers@medassets.com
www.linkedin.com/pub/leslie-flowers/8/483/ab0
medassets.com
104192136
MedAssets
Lisa
Haley
Director, Client Management, Revenue Cycle Tec...
lhaley@medassets.com
www.linkedin.com/in/lisahaley
medassets.com
46637865
MedAssets
Bryan
Hardman
Vice President, SM Client Management, West
bhardman@medassets.com
www.linkedin.com/pub/bryan-hardman/0/89a/817
medassets.com
...
...
...
...
...
...
...
...
28640787
TIBCO Software
Peter
McKinnis
Enterprise Architect, Enterprise Architects Group
pmckinni@tibco.com
www.linkedin.com/pub/peter-mckinnis/4/b71/355
tibco.com
11669803
TIBCO Software
Phill
Watson
Application Architect
pwatson@tibco.com
www.linkedin.com/pub/phill-watson/5/6A2/B10
tibco.com
6236821
TIBCO Software
Anurag
Saran
Innovation Architect(Enterprise Architecture) ...
asaran@tibco.com
www.linkedin.com/in/anuragsaran
tibco.com
96544189
ManTech International
Robert
Harney
Vice President, Director/Security Center Of Ex...
robert.harney@mantech.com
www.linkedin.com/pub/robert-harney/37/371/b29
mantech.com
41113467
Investment Technology Group
Wendy
Zheng
Vp, Consulting Information Systems Architect
wendy.zheng@itg.com
www.linkedin.com/pub/wendy-zheng/5/83a/658
itg.com
107798405
DuPont USA
Chris
Leeder
One Dupont Technology Leader
chris.leeder@usa.dupont.com
www.linkedin.com/pub/chris-leeder/83/490/292
usa.dupont.com
110370321
Wright Express - WEX
Peter
Burnell
Enterprise Architect
peter@wexinc.com
www.linkedin.com/pub/peter-burnell/3/a18/baa
wexinc.com
102573507
Milwaukee Electric Tool
Eric
Hanson
Vp Of Information Technology & Business Optimi...
eric@milwaukeetool.com
www.linkedin.com/pub/eric-hanson/3/559/b45
milwaukeetool.com
80795692
SPLUNK
Declan
Morris
Vp, Cloud & It Ops
dmorris@splunk.com
www.linkedin.com/pub/declan-morris/2/274/aa2
splunk.com
7275998
DocuSign
Dan
Pitta
Database Architect
danpitta@docusign.com
www.linkedin.com/in/danpitta
docusign.com
101989974
Quicken Loans
James
Fisher
Business Technology Executive
jamesfisher1@quickenloans.com
www.linkedin.com/in/jamescfisher
quickenloans.com
22794946
Bazaarvoice
Diana
Mohan
Salesforce.Com Admin/ Business Analyst
diana_mohan@bazaarvoice.com
www.linkedin.com/in/dianamohan
bazaarvoice.com
107863923
Providence Equity Partners
Larry
Lou
Director Of Information Technology
l.lou@provequity.com
www.linkedin.com/pub/larry-lou/17/846/21A
provequity.com
64244119
Encore Capital Group
Shelly
Ludwig
Senior Vendor Specialist and Salesforce Admini...
shelly.ludwig@encorecapital.com
www.linkedin.com/pub/shelly-ludwig/50/134/7a5
encorecapital.com
88566045
Encore Capital Group
Rajeev
Mehndiratta
Manager/Architect Db2 Iseries
rajeev.mehndiratta@encorecapital.com
www.linkedin.com/pub/rajeev-mehndiratta/15/A38...
encorecapital.com
105497453
VMware
Cheng
Dan
Solution Architect - Cloud Application Platform
cdan@vmware.com
www.linkedin.com/pub/cheng-dan/32/7b6/ab6
vmware.com
22903284
iGATE
Abhishek
Jagtap
Technical Lead - Salesforce
abhishek.jagtap@igate.com
www.linkedin.com/pub/abhishek-jagtap/9/349/267
igate.com
70465925
Avery Dennison
Cliff
Hart
Sr. Data Warehouse Architect
cliff.hart@averydennison.com
www.linkedin.com/pub/cliff-hart/11/827/4b1
averydennison.com
67453603
Avery Dennison
Robert
Devers
Vp, It Global Strategy And Architecture
robert.devers@averydennison.com
www.linkedin.com/pub/robert-devers/8/b84/5aa
averydennison.com
106997649
World Wide Technology
Kathi
Bomar
Technical Solutions Architect
kathi.bomar@wwt.com
www.linkedin.com/pub/kathi-bomar/14/50b/ab8
wwt.com
44036523
World Wide Technology
Brian
Kennedy
Information Technology ITG Enterprise Architec...
brian.kennedy@wwt.com
www.linkedin.com/pub/brian-kennedy/13/604/B9A
wwt.com
44124341
World Wide Technology
Michael
Taylor
Vice President of Information Technology
michael.taylor@wwt.com
www.linkedin.com/in/michaelptaylor1
wwt.com
106884906
Equinix
Siddharth
Naik
Senior Database Architect
snaik@equinix.com
www.linkedin.com/pub/siddharth-naik/0/1b7/560
equinix.com
27915960
NTT DATA
Tariq
Iqbal
Enterprise Architect
tariq.iqbal@nttdata.com
www.linkedin.com/pub/tariq-iqbal/2/448/969
nttdata.com
66269926
NTT DATA
Zoran
Djordjevic
Software Architect
zoran.djordjevic@nttdata.com
www.linkedin.com/pub/zoran-djordjevic/87/882/602
nttdata.com
103880105
Electronic Arts
Nicholas
Eddy
Application Architect
nicholas@ea.com
www.linkedin.com/in/nicholaseddy
ea.com
93088302
Crocs
Brian
Horsman
Vice President - Information Technology
bhorsman@crocs.com
www.linkedin.com/pub/brian-horsman/a/544/104
crocs.com
106374852
NeuStar
Nick
Salem
Distinguished Engineer
nick.salem@neustar.biz
www.linkedin.com/pub/nick-salem/1a/302/1b7
neustar.biz
100780904
Newmont Mining
Scott
Burgoz
Director of Information Technology Application...
burgoz.scott@newmont.com
www.linkedin.com/in/scottburgoz
newmont.com
50125444
Newmont Mining
Paul
Santaniello
Lead Enterprise Data Warehouse Architect
paul.santaniello@newmont.com
www.linkedin.com/pub/paul-santaniello/27/b3/3
newmont.com
1133 rows × 7 columns
In [11]:
s = pd.value_counts(df.CompanyName)
In [18]:
df.columns
Out[18]:
Index([u'CompanyName', u'ContactFirstName', u'ContactLastName', u'ContactTitle', u'ContactEmailAddress', u'linkedin_profile_url'], dtype='object')
In [26]:
df = pd.DataFrame({'A':np.random.random(100), 'B':np.random.random(100)+0.3})
In [31]:
pd.scatter_matrix(df);
In [30]:
df['C'] = df.A + df.B
In [ ]:
Content source: udibr/seizure-prediction
Similar notebooks: