In [24]:
from IPython.core.display import display, HTML
display(HTML("<style>.container { width:100% !important; }</style>"))
Databases are designed to minimize redundancy and maintain data integrity, particularly when data is added, changed, or deleted.
Side note: you may also have to think about isolation level when working with a database where someone may be updating data as you're trying to read it. The isolation level determines the database read behavior in this situation. See https://en.wikipedia.org/wiki/Isolation_(database_systems).
key values that can be matched. Usually one table has a primary key and the other table has a foreign key.In this class, we will cover table joining, merging and concatenation. We will also go over using some of the time-series handling capabilities in Pandas.
In [25]:
import pandas as pd
import numpy as np
To introduce join operations, we will be working with the AdventureWorks dataset, a standard dataset from Microsoft SLQ Server for learing to work with databases. It contains data for the fictitious bicycle manufacturer (Adventure Works Cycles).
Let's starts by importing some tables from AdventureWorks in /home/data/AdventureWorks. These tables contain data on AdventureWorks employees, sales territories, customers, and orders placed by the customers.
In [101]:
print(x)
(0, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
0 259 250.0 NaN NaN Ben T Miller
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
0 NaN Buyer 20269531 ... 47
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
0 151-555-0113 Work ben0@adventure-works.com 101 Candy Rd.
AddressLine2 City StateProvinceName PostalCode CountryName
0 NaN Redmond Washington 98052 United States
[1 rows x 26 columns])
(1, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
1 278 274.0 6.0 NaN Garrett R Vargas
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
1 NaN Sales Representative 234474252 ... 36
PhoneNumber PhoneNumberType EmailAddress \
1 922-555-0165 Work garrett1@mapleleafmail.ca
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
1 10203 Acorn Avenue NaN Calgary Alberta T2P 2G8
CountryName
1 Canada
[1 rows x 26 columns])
(2, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
2 204 26.0 NaN NaN Gabe B Mares
Suffix JobTitle NationalIDNumber ... \
2 NaN Production Technician - WC40 440379437 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
2 48 310-555-0117 Work gabe0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
2 1061 Buskrik Avenue NaN Edmonds Washington 98020
CountryName
2 United States
[1 rows x 26 columns])
(3, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
3 78 26.0 NaN NaN Reuben H D'sa
Suffix JobTitle NationalIDNumber ... \
3 NaN Production Supervisor - WC40 370989364 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
3 56 191-555-0112 Work reuben0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
3 1064 Slow Creek Road NaN Seattle Washington 98104
CountryName
3 United States
[1 rows x 26 columns])
(4, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
4 255 250.0 NaN NaN Gordon L Hee
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
4 NaN Buyer 466142721 ... 46
PhoneNumber PhoneNumberType EmailAddress \
4 230-555-0144 Cell gordon0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
4 108 Lakeside Court NaN Bellevue Washington 98004
CountryName
4 United States
[1 rows x 26 columns])
(5, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
5 66 26.0 NaN NaN Karan R Khanna
Suffix JobTitle NationalIDNumber ... \
5 NaN Production Technician - WC60 834186596 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
5 34 447-555-0186 Work karan0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
5 1102 Ravenwood NaN Seattle Washington 98104
CountryName
5 United States
[1 rows x 26 columns])
(6, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
6 270 263.0 NaN NaN François P Ajenstat
Suffix JobTitle NationalIDNumber ... \
6 NaN Database Administrator 643805155 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
6 53 785-555-0110 Cell françois0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
6 1144 Paradise Ct. NaN Issaquah Washington 98027
CountryName
6 United States
[1 rows x 26 columns])
(7, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
7 22 16.0 NaN NaN Sariya E
LastName Suffix JobTitle NationalIDNumber \
7 Harnpadoungsataya NaN Marketing Specialist 95958330
... SickLeaveHours PhoneNumber PhoneNumberType \
7 ... 42 399-555-0176 Work
EmailAddress AddressLine1 AddressLine2 City \
7 sariya0@adventure-works.com 1185 Dallas Drive NaN Everett
StateProvinceName PostalCode CountryName
7 Washington 98201 United States
[1 rows x 26 columns])
(8, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
8 161 26.0 NaN NaN Kirk J
LastName Suffix JobTitle NationalIDNumber \
8 Koenigsbauer NaN Production Technician - WC45 275962311
... SickLeaveHours PhoneNumber PhoneNumberType \
8 ... 57 669-555-0150 Work
EmailAddress AddressLine1 AddressLine2 City \
8 kirk0@hotmail.com 1220 Bradford Way NaN Seattle
StateProvinceName PostalCode CountryName
8 Washington 98104 United States
[1 rows x 26 columns])
(9, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
9 124 250.0 NaN NaN Kim T Ralls
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
9 NaN Stocker 420776180 ... 69
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
9 309-555-0129 Work kim0@adventure-works.com 1226 Shoe St.
AddressLine2 City StateProvinceName PostalCode CountryName
9 NaN Bothell Washington 98011 United States
[1 rows x 26 columns])
(10, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
10 10 25.0 NaN NaN Michael NaN Raheem
Suffix JobTitle NationalIDNumber ... \
10 NaN Research and Development Manager 879342154 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
10 64 330-555-2568 Work michael6@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
10 1234 Seaside Way NaN San Francisco California
PostalCode CountryName
10 94109 United States
[1 rows x 26 columns])
(11, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
11 248 249.0 NaN NaN Mike K Seamans
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
11 NaN Accountant 480951955 ... 49
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
11 927-555-0150 Work mike0@safe-mail.net 1245 Clay Road
AddressLine2 City StateProvinceName PostalCode CountryName
11 NaN Index Washington 98256 United States
[1 rows x 26 columns])
(12, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
12 175 26.0 NaN NaN Reed T Koch
Suffix JobTitle NationalIDNumber ... \
12 NaN Production Technician - WC30 259388196 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
12 31 678-555-0110 Work reed0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
12 1275 West Street NaN Redmond Washington 98052
CountryName
12 United States
[1 rows x 26 columns])
(13, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
13 155 26.0 NaN NaN Fadi K Fakhouri
Suffix JobTitle NationalIDNumber ... \
13 NaN Production Technician - WC20 212801092 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
13 28 935-555-0116 Work fadi0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
13 1285 Greenbrier Street NaN Snohomish Washington
PostalCode CountryName
13 98296 United States
[1 rows x 26 columns])
(14, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
14 144 26.0 NaN NaN Paul R Singh
Suffix JobTitle NationalIDNumber ... \
14 NaN Production Technician - WC20 886023130 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
14 23 727-555-0112 Cell paul1@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
14 1343 Prospect St NaN Bellevue Washington 98004
CountryName
14 United States
[1 rows x 26 columns])
(15, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
15 192 26.0 NaN NaN Brenda M Diaz
Suffix JobTitle NationalIDNumber ... \
15 NaN Production Supervisor - WC40 634335025 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
15 55 142-555-0139 Work brenda0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
15 1349 Steven Way NaN Seattle Washington 98104
CountryName
15 United States
[1 rows x 26 columns])
(16, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
16 166 26.0 NaN NaN Jack S Richins
Suffix JobTitle NationalIDNumber ... \
16 NaN Production Supervisor - WC30 60114406 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
16 54 552-555-0111 Work jack0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
16 1356 Grove Way NaN Monroe Washington 98272
CountryName
16 United States
[1 rows x 26 columns])
(17, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
17 112 26.0 NaN NaN John P Evans
Suffix JobTitle NationalIDNumber ... \
17 NaN Production Technician - WC50 981597097 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
17 65 172-555-0130 Cell john1@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
17 136 Balboa Court NaN Seattle Washington 98104
CountryName
17 United States
[1 rows x 26 columns])
(18, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
18 203 26.0 NaN NaN Ken L Myer
Suffix JobTitle NationalIDNumber ... \
18 NaN Production Technician - WC40 693168613 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
18 45 949-555-0174 Work ken1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
18 1362 Somerset Place NaN Calgary Alberta T2P 2G8
CountryName
18 Canada
[1 rows x 26 columns])
(19, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
19 245 249.0 NaN NaN Barbara C Moreland
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
19 NaN Accountant 363910111 ... 49
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
19 822-555-0145 Cell barbara1@adventure-works.com 137 Mazatlan
AddressLine2 City StateProvinceName PostalCode CountryName
19 NaN Seattle Washington 98104 United States
[1 rows x 26 columns])
(20, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
20 257 250.0 NaN NaN Eric S Kurjan
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
20 NaN Buyer 381073001 ... 47
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
20 265-555-0195 Work eric2@hotmail.com 1378 String Dr
AddressLine2 City StateProvinceName PostalCode CountryName
20 NaN Renton Washington 98055 United States
[1 rows x 26 columns])
(21, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
21 244 249.0 NaN NaN Bryan A Walton
Suffix JobTitle NationalIDNumber ... \
21 NaN Accounts Receivable Specialist 931190412 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
21 51 935-555-0199 Work bryan1@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
21 1397 Paradise Ct. NaN Calgary Alberta T2P 2G8
CountryName
21 Canada
[1 rows x 26 columns])
(22, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
22 69 26.0 NaN NaN Steve F Masters
Suffix JobTitle NationalIDNumber ... \
22 NaN Production Technician - WC60 752513276 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
22 35 712-555-0170 Work steve0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
22 1398 Yorba Linda NaN Seattle Washington 98104
CountryName
22 United States
[1 rows x 26 columns])
(23, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
23 210 26.0 NaN NaN Belinda M Newman
Suffix JobTitle NationalIDNumber ... \
23 NaN Production Technician - WC45 20244403 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
23 61 319-555-0126 Cell belinda0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
23 1399 Firestone Drive NaN Bothell Washington 98011
CountryName
23 United States
[1 rows x 26 columns])
(24, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
24 163 26.0 NaN NaN Alex M Nayberg
Suffix JobTitle NationalIDNumber ... \
24 NaN Production Technician - WC45 377784364 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
24 58 819-555-0198 Work alex0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
24 1400 Gate Drive NaN Newport Hills Washington 98006
CountryName
24 United States
[1 rows x 26 columns])
(25, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
25 118 26.0 NaN NaN Don L Hall
Suffix JobTitle NationalIDNumber ... \
25 NaN Production Technician - WC50 222400012 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
25 64 100-555-0174 Work don0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
25 1411 Ranch Drive NaN Carnation Washington 98014
CountryName
25 United States
[1 rows x 26 columns])
(26, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
26 176 26.0 NaN NaN David Oliver Lawrence
Suffix JobTitle NationalIDNumber ... \
26 NaN Production Technician - WC30 860123571 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
26 34 118-555-0177 Work david7@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
26 158 Walnut Ave NaN Monroe Washington 98272
CountryName
26 United States
[1 rows x 26 columns])
(27, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
27 147 26.0 NaN NaN Sandra NaN
LastName Suffix JobTitle NationalIDNumber \
27 Reátegui Alayo NaN Production Technician - WC30 604664374
... SickLeaveHours PhoneNumber PhoneNumberType \
27 ... 38 896-555-0168 Work
EmailAddress AddressLine1 AddressLine2 City \
27 sandra0@adventure-works.com 1619 Stillman Court NaN Seattle
StateProvinceName PostalCode CountryName
27 Washington 98104 United States
[1 rows x 26 columns])
(28, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
28 138 26.0 NaN NaN Samantha H Smith
Suffix JobTitle NationalIDNumber ... \
28 NaN Production Technician - WC20 25011600 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
28 23 587-555-0114 Cell samantha0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
28 1648 Eastgate Lane NaN Bellevue Washington 98004
CountryName
28 United States
[1 rows x 26 columns])
(29, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
29 95 26.0 NaN NaN Jim H Scardelis
Suffix JobTitle NationalIDNumber ... \
29 NaN Production Technician - WC50 674171828 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
29 20 679-555-0113 Work jim0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
29 172 Turning Dr. NaN Edmonds Washington 98020
CountryName
29 United States
[1 rows x 26 columns])
(30, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
30 231 227.0 NaN NaN Jo L Berry
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
30 NaN Janitor 153479919 ... 65
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
30 228-555-0159 Cell jo1@adventure-works.com 1748 Bird Drive
AddressLine2 City StateProvinceName PostalCode CountryName
30 NaN Index Washington 98256 United States
[1 rows x 26 columns])
(31, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
31 86 26.0 NaN NaN Ryan L Cornelsen
Suffix JobTitle NationalIDNumber ... \
31 NaN Production Technician - WC40 769680433 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
31 49 208-555-0114 Work ryan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
31 177 11th Ave NaN Sammamish Washington 98074
CountryName
31 United States
[1 rows x 26 columns])
(32, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
32 181 26.0 NaN NaN Michael T Hines
Suffix JobTitle NationalIDNumber ... \
32 NaN Production Technician - WC20 545337468 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
32 30 218-555-0126 Work michael0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
32 1792 Belmont Rd. NaN Calgary Alberta T2P 2G8
CountryName
32 Canada
[1 rows x 26 columns])
(33, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
33 214 25.0 NaN NaN Andreas T Berglund
Suffix JobTitle NationalIDNumber ... \
33 NaN Quality Assurance Technician 131471224 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
33 62 181-555-0124 Cell andreas0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
33 1803 Olive Hill NaN Renton Washington 98055
CountryName
33 United States
[1 rows x 26 columns])
(34, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
34 72 26.0 NaN NaN Steven T Selikoff
Suffix JobTitle NationalIDNumber ... \
34 NaN Production Technician - WC30 443968955 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
34 40 925-555-0114 Work steven0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
34 181 Gaining Drive NaN Everett Washington 98201
CountryName
34 United States
[1 rows x 26 columns])
(35, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
35 162 26.0 NaN NaN Laura C Steele
Suffix JobTitle NationalIDNumber ... \
35 NaN Production Technician - WC45 514829225 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
35 57 777-555-0141 Work laura0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
35 1825 Corte Del Prado NaN Duvall Washington 98019
CountryName
35 United States
[1 rows x 26 columns])
(36, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
36 107 26.0 NaN NaN Christopher E Hill
Suffix JobTitle NationalIDNumber ... \
36 NaN Production Technician - WC10 393421437 ...
SickLeaveHours PhoneNumber PhoneNumberType \
36 65 153-555-0166 Cell
EmailAddress AddressLine1 AddressLine2 City \
36 christopher0@adventure-works.com 1902 Santa Cruz NaN Bothell
StateProvinceName PostalCode CountryName
36 Washington 98011 United States
[1 rows x 26 columns])
(37, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
37 269 263.0 NaN NaN Dan K Bacon
Suffix JobTitle NationalIDNumber ... \
37 Jr. Application Specialist 671089628 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
37 56 166-555-0159 Work dan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
37 1921 Ranch Road NaN Issaquah Washington 98027
CountryName
37 United States
[1 rows x 26 columns])
(38, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
38 187 26.0 NaN NaN Yvonne S McKay
Suffix JobTitle NationalIDNumber ... \
38 NaN Production Technician - WC45 713403643 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
38 59 286-555-0189 Work yvonne0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
38 1962 Cotton Ct. NaN Everett Washington 98201
CountryName
38 United States
[1 rows x 26 columns])
(39, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
39 75 26.0 NaN NaN Michiko F Osada
Suffix JobTitle NationalIDNumber ... \
39 NaN Production Technician - WC30 363996959 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
39 42 984-555-0148 Work michiko0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
39 1962 Ferndale Lane NaN Sammamish Washington 98074
CountryName
39 United States
[1 rows x 26 columns])
(40, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
40 12 25.0 NaN NaN Thierry B D'Hers
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
40 NaN Tool Designer 480168528 ... 24
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
40 168-555-0183 Work thierry0@adventure-works.com 1970 Napa Ct.
AddressLine2 City StateProvinceName PostalCode CountryName
40 NaN Bothell Washington 98011 United States
[1 rows x 26 columns])
(41, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
41 116 26.0 NaN NaN Michael W Patten
Suffix JobTitle NationalIDNumber ... \
41 NaN Production Technician - WC50 398737566 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
41 69 441-555-0195 Work michael2@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
41 2038 Encino Drive NaN Edmonds Washington 98020
CountryName
41 United States
[1 rows x 26 columns])
(42, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
42 30 26.0 NaN NaN Britta L Simon
Suffix JobTitle NationalIDNumber ... \
42 NaN Production Technician - WC60 410742000 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
42 27 955-555-0169 Cell britta0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
42 2046 Las Palmas NaN Edmonds Washington 98020
CountryName
42 United States
[1 rows x 26 columns])
(43, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
43 198 26.0 NaN NaN Lorraine O Nay
Suffix JobTitle NationalIDNumber ... \
43 NaN Production Technician - WC40 19312190 ...
SickLeaveHours PhoneNumber PhoneNumberType \
43 44 845-555-0184 Work
EmailAddress AddressLine1 AddressLine2 City \
43 lorraine0@adventure-works.com 2059 Clay Rd NaN Edmonds
StateProvinceName PostalCode CountryName
43 Washington 98020 United States
[1 rows x 26 columns])
(44, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
44 133 26.0 NaN NaN Michael L Rothkugel
Suffix JobTitle NationalIDNumber ... \
44 NaN Production Technician - WC40 830150469 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
44 55 454-555-0119 Work michael1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
44 207 Berry Court NaN Edmonds Washington 98020
CountryName
44 United States
[1 rows x 26 columns])
(45, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
45 31 26.0 NaN NaN Margie W Shoop
Suffix JobTitle NationalIDNumber ... \
45 NaN Production Technician - WC60 750246141 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
45 29 818-555-0128 Cell margie0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
45 2080 Sycamore Drive NaN Edmonds Washington 98020
CountryName
45 United States
[1 rows x 26 columns])
(46, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
46 168 26.0 NaN NaN Garrett R Young
Suffix JobTitle NationalIDNumber ... \
46 NaN Production Technician - WC30 271438431 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
46 37 609-555-0179 Work garrett0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
46 2115 Passing NaN Snohomish Washington 98296
CountryName
46 United States
[1 rows x 26 columns])
(47, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
47 236 235.0 NaN NaN Grant N Culbertson
Suffix JobTitle NationalIDNumber \
47 NaN Human Resources Administrative Assistant 476980013
... SickLeaveHours PhoneNumber PhoneNumberType \
47 ... 46 955-555-0131 Work
EmailAddress AddressLine1 AddressLine2 City \
47 grant0@adventure-works.com 213 Stonewood Drive NaN Gold Bar
StateProvinceName PostalCode CountryName
47 Washington 98251 United States
[1 rows x 26 columns])
(48, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
48 3 25.0 NaN NaN Roberto NaN Tamburello
Suffix JobTitle NationalIDNumber ... \
48 NaN Engineering Manager 509647174 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
48 21 212-555-0187 Cell roberto0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
48 2137 Birchwood Dr NaN Redmond Washington 98052
CountryName
48 United States
[1 rows x 26 columns])
(49, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
49 199 26.0 NaN NaN Paula R Nartker
Suffix JobTitle NationalIDNumber ... \
49 NaN Production Technician - WC40 992874797 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
49 47 476-555-0119 Cell paula1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
49 2144 San Rafael NaN Seattle Washington 98104
CountryName
49 United States
[1 rows x 26 columns])
(50, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
50 48 26.0 NaN NaN Ruth Ann Ellerbrock
Suffix JobTitle NationalIDNumber ... \
50 NaN Production Technician - WC10 690627818 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
50 61 145-555-0130 Cell ruth0@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
50 2176 Apollo Way NaN Everett Washington 98201
CountryName
50 United States
[1 rows x 26 columns])
(51, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
51 126 250.0 NaN NaN Jimmy T Bischoff
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
51 NaN Stocker 652779496 ... 68
PhoneNumber PhoneNumberType EmailAddress \
51 927-555-0168 Cell jimmy0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
51 2176 Brown Street NaN Renton Washington 98055
CountryName
51 United States
[1 rows x 26 columns])
(52, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
52 230 227.0 NaN NaN Stuart J Macrae
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
52 NaN Janitor 28414965 ... 64
PhoneNumber PhoneNumberType EmailAddress \
52 539-555-0149 Work stuart1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
52 2266 Greenwood Circle NaN Renton Washington 98055
CountryName
52 United States
[1 rows x 26 columns])
(53, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
53 41 26.0 NaN NaN Bryan NaN Baker
Suffix JobTitle NationalIDNumber ... \
53 NaN Production Technician - WC60 458159238 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
53 37 712-555-0113 Cell bryan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
53 2275 Valley Blvd. NaN Monroe Washington 98272
CountryName
53 United States
[1 rows x 26 columns])
(54, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
54 283 274.0 1.0 NaN David R Campbell
Suffix JobTitle NationalIDNumber ... \
54 NaN Sales Representative 987554265 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
54 31 740-555-0182 Work david8@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
54 2284 Azalea Avenue NaN Bellevue Washington 98004
CountryName
54 United States
[1 rows x 26 columns])
(55, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
55 226 25.0 NaN NaN Brian P LaMee
Suffix JobTitle NationalIDNumber ... \
55 NaN Scheduling Assistant 368691270 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
55 44 313-555-0196 Cell brian1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
55 2294 West 39th St. NaN Everett Washington 98201
CountryName
55 United States
[1 rows x 26 columns])
(56, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
56 104 26.0 NaN NaN Mary R Baker
Suffix JobTitle NationalIDNumber ... \
56 NaN Production Technician - WC10 717889520 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
56 67 283-555-0185 Work mary1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
56 2354 Frame Ln. NaN Seattle Washington 98104
CountryName
56 United States
[1 rows x 26 columns])
(57, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
57 263 234.0 NaN NaN Jean E Trenary
Suffix JobTitle NationalIDNumber ... \
57 NaN Information Services Manager 441044382 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
57 52 685-555-0120 Work jean0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
57 2383 Pepper Drive NaN Redmond Washington 98052
CountryName
57 United States
[1 rows x 26 columns])
(58, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
58 232 227.0 NaN NaN Pat H Coleman
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
58 NaN Janitor 646304055 ... 64
PhoneNumber PhoneNumberType EmailAddress \
58 720-555-0158 Work pat0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
58 2425 Notre Dame Ave NaN Gold Bar Washington 98251
CountryName
58 United States
[1 rows x 26 columns])
(59, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
59 274 273.0 NaN NaN Stephen Y Jiang
Suffix JobTitle NationalIDNumber ... \
59 NaN North American Sales Manager 502097814 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
59 27 238-555-0197 Cell stephen0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
59 2427 Notre Dame Ave. NaN Redmond Washington 98052
CountryName
59 United States
[1 rows x 26 columns])
(60, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
60 81 26.0 NaN NaN Mihail U Frintu
Suffix JobTitle NationalIDNumber ... \
60 NaN Production Technician - WC40 413787783 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
60 52 733-555-0128 Work mihail0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
60 2466 Clearland Circle NaN Edmonds Washington 98020
CountryName
60 United States
[1 rows x 26 columns])
(61, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
61 172 26.0 NaN NaN Marc J Ingle
Suffix JobTitle NationalIDNumber ... \
61 NaN Production Technician - WC30 364818297 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
61 31 234-555-0169 Cell marc0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
61 2473 Orchard Way NaN Sammamish Washington 98074
CountryName
61 United States
[1 rows x 26 columns])
(62, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
62 119 26.0 NaN NaN Michael T Entin
Suffix JobTitle NationalIDNumber ... \
62 NaN Production Technician - WC50 334834274 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
62 67 817-555-0186 Work michael4@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
62 2482 Buckingham Dr. NaN Redmond Washington 98052
CountryName
62 United States
[1 rows x 26 columns])
(63, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
63 276 274.0 4.0 NaN Linda C Mitchell
Suffix JobTitle NationalIDNumber ... \
63 NaN Sales Representative 191644724 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
63 33 883-555-0116 Work linda3@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
63 2487 Riverside Drive NaN Nevada Utah 84407
CountryName
63 United States
[1 rows x 26 columns])
(64, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
64 225 25.0 NaN NaN Alan J Brewer
Suffix JobTitle NationalIDNumber ... \
64 NaN Scheduling Assistant 470689086 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
64 43 438-555-0172 Work alan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
64 25 95th Ave NE NaN Kenmore Washington 98028
CountryName
64 United States
[1 rows x 26 columns])
(65, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
65 212 25.0 NaN NaN Peng J Wu
Suffix JobTitle NationalIDNumber ... \
65 NaN Quality Assurance Supervisor 885055826 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
65 60 164-555-0164 Work peng0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
65 250 Race Court NaN Bothell Washington 98011
CountryName
65 United States
[1 rows x 26 columns])
(66, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
66 227 1.0 NaN NaN Gary E. Altman
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
66 III Facilities Manager 141165819 ... 63
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
66 110-555-0112 Cell gary1@yahoo.com 2598 Breck Court
AddressLine2 City StateProvinceName PostalCode CountryName
66 NaN Renton Washington 98055 United States
[1 rows x 26 columns])
(67, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
67 97 26.0 NaN NaN Mandar H Samant
Suffix JobTitle NationalIDNumber ... \
67 NaN Production Technician - WC50 370581729 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
67 20 140-555-0132 Work mandar0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
67 2598 La Vista Circle NaN Duvall Washington 98019
CountryName
67 United States
[1 rows x 26 columns])
(68, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
68 194 26.0 NaN NaN Fred T Northup
Suffix JobTitle NationalIDNumber ... \
68 NaN Production Technician - WC40 295971920 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
68 43 818-555-0192 Cell fred0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
68 2601 Cambridge Drive NaN Snohomish Washington
PostalCode CountryName
68 98296 United States
[1 rows x 26 columns])
(69, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
69 62 26.0 NaN NaN John T Campbell
Suffix JobTitle NationalIDNumber ... \
69 NaN Production Supervisor - WC60 494170342 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
69 60 435-555-0113 Work john0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
69 2639 Anchor Court NaN Seattle Washington 98104
CountryName
69 United States
[1 rows x 26 columns])
(70, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
70 115 26.0 NaN NaN Angela W Barbariol
Suffix JobTitle NationalIDNumber ... \
70 NaN Production Technician - WC50 563680513 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
70 66 150-555-0194 Cell angela0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
70 2687 Ridge Road NaN Edmonds Washington 98020
CountryName
70 United States
[1 rows x 26 columns])
(71, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
71 122 250.0 NaN NaN Susan W Eaton
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
71 NaN Stocker 586486572 ... 68
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
71 943-555-0196 Work susan0@gmail.com 2736 Scramble Rd
AddressLine2 City StateProvinceName PostalCode CountryName
71 NaN Renton Washington 98055 United States
[1 rows x 26 columns])
(72, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
72 150 26.0 NaN NaN Michael T Vanderhyde
Suffix JobTitle NationalIDNumber ... \
72 NaN Production Technician - WC30 878395493 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
72 37 296-555-0121 Cell michael5@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
72 2812 Mazatlan NaN Edmonds Washington 98020
CountryName
72 United States
[1 rows x 26 columns])
(73, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
73 258 250.0 NaN NaN Erin M Hagens
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
73 NaN Buyer 785853949 ... 46
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
73 842-555-0158 Work erin0@adventure-works.com 2947 Vine Lane
AddressLine2 City StateProvinceName PostalCode CountryName
73 NaN Bellevue Washington 98004 United States
[1 rows x 26 columns])
(74, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
74 63 26.0 NaN NaN Maciej W Dusza
Suffix JobTitle NationalIDNumber ... \
74 NaN Production Technician - WC60 414476027 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
74 35 237-555-0128 Cell maciej0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
74 3026 Anchor Drive NaN Edmonds Washington 98020
CountryName
74 United States
[1 rows x 26 columns])
(75, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
75 156 26.0 NaN NaN Lane M Sacksteder
Suffix JobTitle NationalIDNumber ... \
75 NaN Production Technician - WC20 322160340 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
75 25 200-555-0117 Cell lane0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
75 3029 Pastime Dr # 2 Seattle Washington 98104
CountryName
75 United States
[1 rows x 26 columns])
(76, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
76 238 235.0 NaN NaN Vidur X Luthra
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
76 NaN Recruiter 264306399 ... 45
PhoneNumber PhoneNumberType EmailAddress \
76 153-555-0186 Work vidur0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
76 3030 Blackburn Ct. NaN Newport Hills Washington
PostalCode CountryName
76 98006 United States
[1 rows x 26 columns])
(77, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
77 205 26.0 NaN NaN Lori A Kane
Suffix JobTitle NationalIDNumber ... \
77 NaN Production Supervisor - WC45 332349500 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
77 58 289-555-0196 Cell lori0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
77 3066 Wallace Dr. NaN Redmond Washington 98052
CountryName
77 United States
[1 rows x 26 columns])
(78, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
78 89 26.0 NaN NaN Patrick C Wedge
Suffix JobTitle NationalIDNumber ... \
78 NaN Production Technician - WC10 90888098 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
78 68 413-555-0124 Cell patrick0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
78 3067 Maya NaN Bellevue Washington 98004
CountryName
78 United States
[1 rows x 26 columns])
(79, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
79 170 26.0 NaN NaN George Z Li
Suffix JobTitle NationalIDNumber ... \
79 NaN Production Technician - WC30 476115505 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
79 33 518-555-0199 Cell george0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
79 3074 Arbor Drive NaN Carnation Washington 98014
CountryName
79 United States
[1 rows x 26 columns])
(80, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
80 243 249.0 NaN NaN Candy L Spoon
Suffix JobTitle NationalIDNumber ... \
80 NaN Accounts Receivable Specialist 60517918 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
80 50 920-555-0177 Cell candy0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
80 310 Winter Lane NaN Index Washington 98256
CountryName
80 United States
[1 rows x 26 columns])
(81, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
81 49 26.0 NaN NaN Barry K Johnson
Suffix JobTitle NationalIDNumber ... \
81 NaN Production Technician - WC10 912265825 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
81 64 206-555-0180 Work barry0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
81 3114 Notre Dame Ave. NaN Snohomish Washington
PostalCode CountryName
81 98296 United States
[1 rows x 26 columns])
(82, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
82 220 25.0 NaN NaN Karen R Berge
Suffix JobTitle NationalIDNumber ... \
82 NaN Document Control Assistant 260770918 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
82 59 746-555-0164 Work karen0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
82 3127 El Camino Drive NaN Index Washington 98256
CountryName
82 United States
[1 rows x 26 columns])
(83, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
83 32 26.0 NaN NaN Rebecca A Laszlo
Suffix JobTitle NationalIDNumber ... \
83 NaN Production Technician - WC60 330211482 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
83 31 314-555-0113 Cell rebecca0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
83 3197 Thornhill Place NaN Bellevue Washington 98004
CountryName
83 United States
[1 rows x 26 columns])
(84, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
84 24 16.0 NaN Ms. Jill A Williams
Suffix JobTitle NationalIDNumber ... \
84 NaN Marketing Specialist 72636981 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
84 43 510-555-0121 Work jill0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
84 3238 Laguna Circle NaN Everett Washington 98201
CountryName
84 United States
[1 rows x 26 columns])
(85, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
85 132 26.0 NaN NaN Nicole B Holliday
Suffix JobTitle NationalIDNumber ... \
85 NaN Production Technician - WC40 1300049 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
85 53 508-555-0129 Cell nicole0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
85 3243 Buckingham Dr. # 207 Seattle Washington 98104
CountryName
85 United States
[1 rows x 26 columns])
(86, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
86 109 26.0 NaN NaN Alice O Ciccu
Suffix JobTitle NationalIDNumber ... \
86 NaN Production Technician - WC50 113695504 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
86 67 333-555-0173 Cell alice0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
86 3280 Pheasant Circle NaN Snohomish Washington
PostalCode CountryName
86 98296 United States
[1 rows x 26 columns])
(87, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
87 111 26.0 NaN NaN Suroor R Fatima
Suffix JobTitle NationalIDNumber ... \
87 NaN Production Technician - WC50 415823523 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
87 66 932-555-0161 Work suroor0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
87 3281 Hillview Dr. NaN Edmonds Washington 98020
CountryName
87 United States
[1 rows x 26 columns])
(88, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
88 113 26.0 NaN NaN Linda K Moschell
Suffix JobTitle NationalIDNumber ... \
88 NaN Production Technician - WC50 54759846 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
88 68 612-555-0171 Cell linda0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
88 3284 S. Blank Avenue NaN Bellevue Washington 98004
CountryName
88 United States
[1 rows x 26 columns])
(89, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
89 196 26.0 NaN NaN Shammi G Mohamed
Suffix JobTitle NationalIDNumber ... \
89 NaN Production Technician - WC40 370487086 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
89 46 793-555-0179 Cell shammi0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
89 332 Laguna Niguel NaN Bellevue Washington 98004
CountryName
89 United States
[1 rows x 26 columns])
(90, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
90 218 25.0 NaN NaN Tengiz N
LastName Suffix JobTitle NationalIDNumber ... \
90 Kharatishvili NaN Control Specialist 540688287 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
90 58 910-555-0116 Work tengiz0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName \
90 3333 Madhatter Circle NaN Issaquah Washington
PostalCode CountryName
90 98027 United States
[1 rows x 26 columns])
(91, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
91 160 26.0 NaN NaN Jeff V Hay
Suffix JobTitle NationalIDNumber ... \
91 NaN Production Supervisor - WC45 712885347 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
91 57 350-555-0167 Cell jeff0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
91 3385 Crestview Drive NaN Everett Washington 98201
CountryName
91 United States
[1 rows x 26 columns])
(92, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
92 13 25.0 NaN Ms. Janice M Galvin
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
92 NaN Tool Designer 486228782 ... 24
PhoneNumber PhoneNumberType EmailAddress \
92 473-555-0117 Work janice0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
92 3397 Rancho View Drive NaN Redmond Washington
PostalCode CountryName
92 98052 United States
[1 rows x 26 columns])
(93, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
93 286 285.0 9.0 NaN Lynn N Tsoflias
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
93 NaN Sales Representative 758596752 ... 38
PhoneNumber PhoneNumberType EmailAddress \
93 1 (11) 500 555-0190 Cell lynn0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
93 34 Waterloo Road NaN Melbourne Victoria 3000
CountryName
93 Australia
[1 rows x 26 columns])
(94, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
94 217 25.0 NaN NaN Zainal T Arifin
Suffix JobTitle NationalIDNumber ... \
94 NaN Document Control Manager 345106466 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
94 58 204-555-0115 Cell zainal0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
94 342 San Simeon NaN Issaquah Washington 98027
CountryName
94 United States
[1 rows x 26 columns])
(95, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
95 44 26.0 NaN NaN Simon D Rapier
Suffix JobTitle NationalIDNumber ... \
95 NaN Production Technician - WC60 276751903 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
95 39 963-555-0134 Work simon0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
95 3421 Bouncing Road NaN Duvall Washington 98019
CountryName
95 United States
[1 rows x 26 columns])
(96, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
96 99 26.0 NaN NaN Nuan NaN Yu
Suffix JobTitle NationalIDNumber ... \
96 NaN Production Technician - WC50 431859843 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
96 21 913-555-0184 Cell nuan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
96 3454 Bel Air Drive NaN Bellevue Washington 98004
CountryName
96 United States
[1 rows x 26 columns])
(97, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
97 96 26.0 NaN NaN Elizabeth I Keyser
Suffix JobTitle NationalIDNumber ... \
97 NaN Production Technician - WC50 912141525 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
97 22 318-555-0137 Cell elizabeth0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
97 350 Pastel Drive NaN Kent Washington 98031
CountryName
97 United States
[1 rows x 26 columns])
(98, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
98 229 227.0 NaN NaN Lori K Penor
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
98 NaN Janitor 879334904 ... 65
PhoneNumber PhoneNumberType EmailAddress AddressLine1 AddressLine2 \
98 295-555-0161 Cell lori1@aol.com 3514 Sunshine NaN
City StateProvinceName PostalCode CountryName
98 Index Washington 98256 United States
[1 rows x 26 columns])
(99, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
99 65 26.0 NaN NaN Randy T Reeves
Suffix JobTitle NationalIDNumber ... \
99 NaN Production Technician - WC60 8066363 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
99 34 961-555-0122 Cell randy0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
99 3632 Bank Way NaN Edmonds Washington 98020
CountryName
99 United States
[1 rows x 26 columns])
(100, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
100 178 26.0 NaN NaN John N Frum
Suffix JobTitle NationalIDNumber ... \
100 NaN Production Technician - WC30 568626529 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
100 33 663-555-0172 Cell john3@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
100 3665 Oak Creek Ct. NaN Everett Washington 98201
CountryName
100 United States
[1 rows x 26 columns])
(101, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
101 26 25.0 NaN NaN Peter J Krebs
Suffix JobTitle NationalIDNumber ... \
101 NaN Production Control Manager 277173473 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
101 41 913-555-0196 Work peter0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
101 3670 All Ways Drive NaN Bellevue Washington 98004
CountryName
101 United States
[1 rows x 26 columns])
(102, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
102 93 26.0 NaN NaN Kok-Ho T Loh
Suffix JobTitle NationalIDNumber ... \
102 NaN Production Supervisor - WC50 778552911 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
102 59 999-555-0155 Work kok-ho0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
102 3708 Montana NaN Bellevue Washington 98004
CountryName
102 United States
[1 rows x 26 columns])
(103, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
103 134 26.0 NaN NaN Eric NaN Gubbels
Suffix JobTitle NationalIDNumber ... \
103 NaN Production Supervisor - WC20 45615666 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
103 40 260-555-0119 Cell eric0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
103 371 Apple Dr. NaN Edmonds Washington 98020
CountryName
103 United States
[1 rows x 26 columns])
(104, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
104 151 26.0 NaN NaN Rostislav E Shabalin
Suffix JobTitle NationalIDNumber ... \
104 NaN Production Technician - WC30 993310268 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
104 40 751-555-0134 Cell rostislav0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
104 3711 Rollingwood Dr NaN Bellevue Washington 98004
CountryName
104 United States
[1 rows x 26 columns])
(105, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
105 158 26.0 NaN NaN Shelley N Dyck
Suffix JobTitle NationalIDNumber ... \
105 NaN Production Technician - WC20 300946911 ...
SickLeaveHours PhoneNumber PhoneNumberType \
105 27 991-555-0184 Cell
EmailAddress AddressLine1 AddressLine2 \
105 shelley0@adventure-works.com 3747 W. Landing Avenue NaN
City StateProvinceName PostalCode CountryName
105 Monroe Washington 98272 United States
[1 rows x 26 columns])
(106, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
106 16 1.0 NaN NaN David M Bradley
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
106 NaN Marketing Manager 24756624 ... 40
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
106 913-555-0172 Work david0@adventure-works.com 3768 Door Way
AddressLine2 City StateProvinceName PostalCode CountryName
106 NaN Redmond Washington 98052 United States
[1 rows x 26 columns])
(107, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
107 135 26.0 NaN NaN Ivo William Salmre
Suffix JobTitle NationalIDNumber ... \
107 NaN Production Technician - WC20 964089218 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
107 24 115-555-0179 Work ivo0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName \
107 3841 Silver Oaks Place NaN Calgary Alberta
PostalCode CountryName
107 T2P 2G8 Canada
[1 rows x 26 columns])
(108, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
108 268 263.0 NaN NaN Ramesh V Meyyappan
Suffix JobTitle NationalIDNumber ... \
108 NaN Application Specialist 314747499 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
108 56 182-555-0134 Work ramesh0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
108 3848 East 39th Street NaN Issaquah Washington
PostalCode CountryName
108 98027 United States
[1 rows x 26 columns])
(109, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
109 246 249.0 NaN NaN Dragan K Tomic
Suffix JobTitle NationalIDNumber ... \
109 NaN Accounts Payable Specialist 663843431 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
109 51 117-555-0185 Work dragan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
109 3884 Beauty Street # 14 Gold Bar Washington 98251
CountryName
109 United States
[1 rows x 26 columns])
(110, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
110 188 26.0 NaN NaN Douglas B Hite
Suffix JobTitle NationalIDNumber ... \
110 NaN Production Technician - WC45 435234965 ...
SickLeaveHours PhoneNumber PhoneNumberType \
110 60 808-555-0172 Cell
EmailAddress AddressLine1 AddressLine2 City \
110 douglas0@adventure-works.com 390 Ridgewood Ct. NaN Carnation
StateProvinceName PostalCode CountryName
110 Washington 98014 United States
[1 rows x 26 columns])
(111, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
111 177 26.0 NaN NaN Russell M King
Suffix JobTitle NationalIDNumber ... \
111 NaN Production Technician - WC30 551346974 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
111 32 517-555-0122 Work russell1@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
111 3919 Pinto Road NaN Bellevue Washington 98004
CountryName
111 United States
[1 rows x 26 columns])
(112, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
112 23 16.0 NaN NaN Mary E Gibson
Suffix JobTitle NationalIDNumber ... \
112 NaN Marketing Specialist 767955365 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
112 43 531-555-0183 Work mary0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
112 3928 San Francisco NaN Everett Washington 98201
CountryName
112 United States
[1 rows x 26 columns])
(113, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
113 184 26.0 NaN NaN John Y Chen
Suffix JobTitle NationalIDNumber ... \
113 NaN Production Technician - WC20 305522471 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
113 29 201-555-0163 Cell john2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
113 3977 Central Avenue NaN Duvall Washington 98019
CountryName
113 United States
[1 rows x 26 columns])
(114, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
114 284 274.0 1.0 Mr. Tete A
LastName Suffix JobTitle NationalIDNumber \
114 Mensa-Annan NaN Sales Representative 90836195
... SickLeaveHours PhoneNumber PhoneNumberType \
114 ... 39 615-555-0153 Work
EmailAddress AddressLine1 AddressLine2 City \
114 tete0@adventure-works.com 3997 Via De Luna NaN Cambridge
StateProvinceName PostalCode CountryName
114 Massachusetts 02139 United States
[1 rows x 26 columns])
(115, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
115 127 26.0 NaN NaN David P Hamilton
Suffix JobTitle NationalIDNumber ... \
115 NaN Production Supervisor - WC40 750905084 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
115 56 986-555-0177 Cell david4@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
115 4095 Cooper Dr. NaN Kenmore Washington 98028
CountryName
115 United States
[1 rows x 26 columns])
(116, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
116 182 26.0 NaN NaN Nitin S
LastName Suffix JobTitle NationalIDNumber \
116 Mirchandani NaN Production Technician - WC20 368920189
... SickLeaveHours PhoneNumber PhoneNumberType \
116 ... 30 143-555-0173 Cell
EmailAddress AddressLine1 AddressLine2 City \
116 nitin0@adventure-works.com 4096 San Remo NaN Sammamish
StateProvinceName PostalCode CountryName
116 Washington 98074 United States
[1 rows x 26 columns])
(117, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
117 213 25.0 NaN NaN Sootha T
LastName Suffix JobTitle NationalIDNumber \
117 Charncherngkha NaN Quality Assurance Technician 343861179
... SickLeaveHours PhoneNumber PhoneNumberType \
117 ... 62 325-555-0137 Work
EmailAddress AddressLine1 AddressLine2 City \
117 sootha0@adventure-works.com 4155 Working Drive NaN Kenmore
StateProvinceName PostalCode CountryName
117 Washington 98028 United States
[1 rows x 26 columns])
(118, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
118 174 26.0 NaN NaN Benjamin R Martin
Suffix JobTitle NationalIDNumber ... \
118 NaN Production Technician - WC30 585408256 ...
SickLeaveHours PhoneNumber PhoneNumberType \
118 34 533-555-0111 Cell
EmailAddress AddressLine1 AddressLine2 City \
118 benjamin0@adventure-works.com 4231 Spar Court NaN Snohomish
StateProvinceName PostalCode CountryName
118 Washington 98296 United States
[1 rows x 26 columns])
(119, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
119 131 26.0 NaN NaN Baris F Cetinok
Suffix JobTitle NationalIDNumber ... \
119 NaN Production Technician - WC40 273260055 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
119 56 164-555-0114 Work baris0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
119 426 San Rafael NaN Seattle Washington 98104
CountryName
119 United States
[1 rows x 26 columns])
(120, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
120 80 26.0 NaN NaN Sandeep P Kaliyath
Suffix JobTitle NationalIDNumber ... \
120 NaN Production Technician - WC40 943170460 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
120 52 166-555-0156 Work sandeep0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
120 4310 Kenston Dr. NaN Sammamish Washington 98074
CountryName
120 United States
[1 rows x 26 columns])
(121, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
121 235 1.0 NaN NaN Paula M
LastName Suffix JobTitle NationalIDNumber \
121 Barreto de Mattos NaN Human Resources Manager 535145551
... SickLeaveHours PhoneNumber PhoneNumberType \
121 ... 47 523-555-0175 Cell
EmailAddress AddressLine1 AddressLine2 City \
121 paula0@adventure-works.com 4311 Clay Rd NaN Bellevue
StateProvinceName PostalCode CountryName
121 Washington 98004 United States
[1 rows x 26 columns])
(122, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
122 125 250.0 NaN NaN Matthias T Berndt
Suffix JobTitle NationalIDNumber ... \
122 NaN Shipping and Receiving Clerk 584205124 ...
SickLeaveHours PhoneNumber PhoneNumberType \
122 67 139-555-0120 Cell
EmailAddress AddressLine1 AddressLine2 \
122 matthias0@adventure-works.com 4312 Cambridge Drive NaN
City StateProvinceName PostalCode CountryName
122 Renton Washington 98055 United States
[1 rows x 26 columns])
(123, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
123 1 NaN NaN NaN Ken J Sánchez
Suffix JobTitle NationalIDNumber ... \
123 NaN Chief Executive Officer 295847284 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
123 69 697-555-0142 Cell ken0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName \
123 4350 Minute Dr. NaN Newport Hills Washington
PostalCode CountryName
123 98006 United States
[1 rows x 26 columns])
(124, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
124 164 26.0 NaN NaN Andrew M Cencini
Suffix JobTitle NationalIDNumber ... \
124 NaN Production Technician - WC45 65848458 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
124 56 207-555-0192 Cell andrew1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
124 4444 Pepper Way NaN Sammamish Washington 98074
CountryName
124 United States
[1 rows x 26 columns])
(125, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
125 249 234.0 NaN NaN Wendy Beth Kahn
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
125 NaN Finance Manager 121491555 ... 47
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
125 248-555-0134 Work wendy0@hotmail.com 4525 Benedict Ct.
AddressLine2 City StateProvinceName PostalCode CountryName
125 NaN Sammamish Washington 98074 United States
[1 rows x 26 columns])
(126, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
126 189 26.0 NaN NaN Janeth M Esteves
Suffix JobTitle NationalIDNumber ... \
126 NaN Production Technician - WC45 187369436 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
126 60 540-555-0191 Work janeth0@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
126 4566 La Jolla NaN Monroe Washington 98272
CountryName
126 United States
[1 rows x 26 columns])
(127, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
127 39 26.0 NaN NaN Ed R
LastName Suffix JobTitle NationalIDNumber \
127 Dudenhoefer NaN Production Technician - WC60 461786517
... SickLeaveHours PhoneNumber PhoneNumberType \
127 ... 32 919-555-0140 Work
EmailAddress AddressLine1 AddressLine2 City \
127 ed0@adventure-works.com 4598 Manila Avenue NaN Seattle
StateProvinceName PostalCode CountryName
127 Washington 98104 United States
[1 rows x 26 columns])
(128, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
128 145 26.0 NaN NaN Cynthia S Randall
Suffix JobTitle NationalIDNumber ... \
128 NaN Production Supervisor - WC30 386315192 ...
SickLeaveHours PhoneNumber PhoneNumberType \
128 54 352-555-0138 Cell
EmailAddress AddressLine1 AddressLine2 \
128 cynthia0@adventure-works.com 463 H Stagecoach Rd. NaN
City StateProvinceName PostalCode CountryName
128 Kenmore Washington 98028 United States
[1 rows x 26 columns])
(129, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
129 42 26.0 NaN NaN James D Kramer
Suffix JobTitle NationalIDNumber ... \
129 NaN Production Technician - WC60 339712426 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
129 39 119-555-0117 Cell james0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
129 4734 Sycamore Court NaN Monroe Washington 98272
CountryName
129 United States
[1 rows x 26 columns])
(130, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
130 8 25.0 NaN NaN Diane L Margheim
Suffix JobTitle NationalIDNumber \
130 NaN Research and Development Engineer 811994146
... SickLeaveHours PhoneNumber PhoneNumberType \
130 ... 51 815-555-0138 Cell
EmailAddress AddressLine1 AddressLine2 City \
130 diane1@adventure-works.com 475 Santa Maria NaN Everett
StateProvinceName PostalCode CountryName
130 Washington 98201 United States
[1 rows x 26 columns])
(131, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
131 149 26.0 NaN NaN Andy M Ruth
Suffix JobTitle NationalIDNumber ... \
131 NaN Production Technician - WC30 764853868 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
131 39 118-555-0110 Cell andy0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
131 4777 Rockne Drive NaN Bellevue Washington 98004
CountryName
131 United States
[1 rows x 26 columns])
(132, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
132 54 26.0 NaN NaN Bonnie N Kearney
Suffix JobTitle NationalIDNumber ... \
132 NaN Production Technician - WC10 109272464 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
132 64 264-555-0150 Work bonnie0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName \
132 4852 Chaparral Court NaN Snohomish Washington
PostalCode CountryName
132 98296 United States
[1 rows x 26 columns])
(133, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
133 110 26.0 NaN NaN Jun T Cao
Suffix JobTitle NationalIDNumber ... \
133 NaN Production Technician - WC50 857651804 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
133 65 299-555-0113 Work jun0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
133 4909 Poco Lane NaN Redmond Washington 98052
CountryName
133 United States
[1 rows x 26 columns])
(134, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
134 180 26.0 NaN NaN Katie L
LastName Suffix JobTitle NationalIDNumber \
134 McAskill-White NaN Production Supervisor - WC20 862951447
... SickLeaveHours PhoneNumber PhoneNumberType \
134 ... 41 809-555-0133 Work
EmailAddress AddressLine1 AddressLine2 City \
134 katie0@adventure-works.com 4948 West 4th St NaN Seattle
StateProvinceName PostalCode CountryName
134 Washington 98104 United States
[1 rows x 26 columns])
(135, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
135 287 273.0 NaN NaN Amy E Alberts
Suffix JobTitle NationalIDNumber ... \
135 NaN European Sales Manager 982310417 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
135 30 775-555-0164 Work amy0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
135 5009 Orange Street NaN Renton Washington 98055
CountryName
135 United States
[1 rows x 26 columns])
(136, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
136 152 26.0 NaN NaN Yuhong L Li
Suffix JobTitle NationalIDNumber ... \
136 NaN Production Supervisor - WC20 319472946 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
136 40 965-555-0155 Cell yuhong0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
136 502 Alexander Pl. NaN Seattle Washington 98104
CountryName
136 United States
[1 rows x 26 columns])
(137, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
137 171 26.0 NaN NaN David A Yalovsky
Suffix JobTitle NationalIDNumber ... \
137 NaN Production Technician - WC30 746373306 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
137 36 373-555-0142 Work david3@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
137 5025 Holiday Hills NaN Seattle Washington 98104
CountryName
137 United States
[1 rows x 26 columns])
(138, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
138 130 26.0 NaN NaN Rob T Caron
Suffix JobTitle NationalIDNumber ... \
138 NaN Production Technician - WC40 578953538 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
138 55 238-555-0116 Work rob1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
138 5030 Blue Ridge Dr. NaN Monroe Washington 98272
CountryName
138 United States
[1 rows x 26 columns])
(139, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
139 55 26.0 NaN NaN Taylor R Maxwell
Suffix JobTitle NationalIDNumber ... \
139 NaN Production Supervisor - WC50 233069302 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
139 59 508-555-0165 Work taylor0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
139 504 O St. NaN Edmonds Washington 98020
CountryName
139 United States
[1 rows x 26 columns])
(140, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
140 211 25.0 NaN NaN Hazem E Abolrous
Suffix JobTitle NationalIDNumber ... \
140 NaN Quality Assurance Manager 398223854 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
140 60 869-555-0125 Work hazem0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
140 5050 Mt. Wilson Way NaN Kenmore Washington 98028
CountryName
140 United States
[1 rows x 26 columns])
(141, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
141 79 26.0 NaN NaN Eric L Brown
Suffix JobTitle NationalIDNumber ... \
141 NaN Production Technician - WC40 697712387 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
141 50 680-555-0118 Cell eric1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
141 5086 Nottingham Place NaN Duvall Washington 98019
CountryName
141 United States
[1 rows x 26 columns])
(142, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
142 36 26.0 NaN NaN Jose R Lugo
Suffix JobTitle NationalIDNumber ... \
142 NaN Production Technician - WC60 788456780 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
142 30 587-555-0115 Cell jose0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
142 5125 Cotton Ct. NaN Seattle Washington 98104
CountryName
142 United States
[1 rows x 26 columns])
(143, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
143 90 26.0 NaN NaN Danielle C Tiedt
Suffix JobTitle NationalIDNumber ... \
143 NaN Production Technician - WC10 82638150 ...
SickLeaveHours PhoneNumber PhoneNumberType \
143 68 500-555-0172 Cell
EmailAddress AddressLine1 AddressLine2 City \
143 danielle0@adventure-works.com 5203 Virginia Lane NaN Kenmore
StateProvinceName PostalCode CountryName
143 Washington 98028 United States
[1 rows x 26 columns])
(144, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
144 92 26.0 NaN NaN Tom M
LastName Suffix JobTitle NationalIDNumber \
144 Vande Velde NaN Production Technician - WC10 826454897
... SickLeaveHours PhoneNumber PhoneNumberType \
144 ... 69 295-555-0161 Work
EmailAddress AddressLine1 AddressLine2 City \
144 tom0@adventure-works.com 5242 Marvelle Ln. NaN Everett
StateProvinceName PostalCode CountryName
144 Washington 98201 United States
[1 rows x 26 columns])
(145, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
145 267 263.0 NaN NaN Karen A Berg
Suffix JobTitle NationalIDNumber ... \
145 NaN Application Specialist 58317344 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
145 57 654-555-0177 Work karen1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
145 5256 Chickpea Ct. NaN Issaquah Washington 98027
CountryName
145 United States
[1 rows x 26 columns])
(146, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
146 68 26.0 NaN NaN Charles B
LastName Suffix JobTitle NationalIDNumber \
146 Fitzgerald NaN Production Technician - WC60 537092325
... SickLeaveHours PhoneNumber PhoneNumberType \
146 ... 33 931-555-0118 Work
EmailAddress AddressLine1 AddressLine2 \
146 charles0@adventure-works.com 5263 Etcheverry Dr NaN
City StateProvinceName PostalCode CountryName
146 Sammamish Washington 98074 United States
[1 rows x 26 columns])
(147, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
147 250 249.0 NaN NaN Sheela H Word
Suffix JobTitle NationalIDNumber ... \
147 NaN Purchasing Manager 895209680 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
147 44 210-555-0193 Work sheela0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
147 535 Greendell Pl NaN Sammamish Washington 98074
CountryName
147 United States
[1 rows x 26 columns])
(148, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
148 60 26.0 NaN NaN Pete C Male
Suffix JobTitle NationalIDNumber ... \
148 NaN Production Technician - WC50 827686041 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
148 26 768-555-0123 Cell pete0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
148 5375 Clearland Circle NaN Seattle Washington
PostalCode CountryName
148 98104 United States
[1 rows x 26 columns])
(149, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
149 120 26.0 NaN NaN Kitti H
LastName Suffix JobTitle NationalIDNumber \
149 Lertpiriyasuwat NaN Production Technician - WC50 211789056
... SickLeaveHours PhoneNumber PhoneNumberType \
149 ... 64 785-555-0132 Work
EmailAddress AddressLine1 AddressLine2 City \
149 kitti0@adventure-works.com 5376 Catanzaro Way NaN Seattle
StateProvinceName PostalCode CountryName
149 Washington 98104 United States
[1 rows x 26 columns])
(150, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
150 98 26.0 NaN NaN Sameer A Tejani
Suffix JobTitle NationalIDNumber ... \
150 NaN Production Technician - WC50 152085091 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
150 22 990-555-0172 Cell sameer0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
150 5379 Treasure Island Way # 14 Duvall Washington
PostalCode CountryName
150 98019 United States
[1 rows x 26 columns])
(151, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
151 121 250.0 NaN NaN Pilar G Ackerman
Suffix JobTitle NationalIDNumber \
151 NaN Shipping and Receiving Supervisor 521265716
... SickLeaveHours PhoneNumber PhoneNumberType \
151 ... 66 577-555-0185 Work
EmailAddress AddressLine1 AddressLine2 City \
151 pilar0@yahoo.com 5407 Cougar Way NaN Seattle
StateProvinceName PostalCode CountryName
151 Washington 98104 United States
[1 rows x 26 columns])
(152, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
152 197 26.0 NaN NaN Rajesh M Patel
Suffix JobTitle NationalIDNumber ... \
152 NaN Production Technician - WC40 632092621 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
152 44 373-555-0137 Cell rajesh0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
152 5423 Champion Rd. NaN Edmonds Washington 98020
CountryName
152 United States
[1 rows x 26 columns])
(153, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
153 240 235.0 NaN NaN Willis T Johnson
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
153 NaN Recruiter 332040978 ... 44
PhoneNumber PhoneNumberType EmailAddress \
153 778-555-0141 Work willis0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
153 5452 Corte Gilberto NaN Everett Washington 98201
CountryName
153 United States
[1 rows x 26 columns])
(154, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
154 11 25.0 NaN NaN Ovidiu V Cracium
Suffix JobTitle NationalIDNumber ... \
154 NaN Senior Tool Designer 974026903 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
154 23 719-555-0181 Cell ovidiu0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
154 5458 Gladstone Drive NaN Kenmore Washington 98028
CountryName
154 United States
[1 rows x 26 columns])
(155, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
155 52 26.0 NaN NaN Doris M Hartwig
Suffix JobTitle NationalIDNumber ... \
155 NaN Production Technician - WC10 565090917 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
155 63 328-555-0150 Cell doris0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
155 5553 Cash Avenue NaN Kenmore Washington 98028
CountryName
155 United States
[1 rows x 26 columns])
(156, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
156 77 26.0 NaN NaN Merav A Netz
Suffix JobTitle NationalIDNumber ... \
156 NaN Production Technician - WC30 301435199 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
156 43 224-555-0187 Work merav0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
156 5666 Hazelnut Lane NaN Seattle Washington 98104
CountryName
156 United States
[1 rows x 26 columns])
(157, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
157 56 26.0 NaN NaN Denise H Smith
Suffix JobTitle NationalIDNumber ... \
157 NaN Production Technician - WC50 652535724 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
157 24 869-555-0119 Cell denise0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
157 5669 Ironwood Way NaN Kenmore Washington 98028
CountryName
157 United States
[1 rows x 26 columns])
(158, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
158 6 25.0 NaN Mr. Jossef H Goldberg
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
158 NaN Design Engineer 998320692 ... 23
PhoneNumber PhoneNumberType EmailAddress \
158 122-555-0189 Work jossef0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
158 5670 Bel Air Dr. NaN Renton Washington 98055
CountryName
158 United States
[1 rows x 26 columns])
(159, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
159 88 26.0 NaN NaN Betsy A Stadick
Suffix JobTitle NationalIDNumber ... \
159 NaN Production Technician - WC10 294148271 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
159 69 405-555-0171 Cell betsy0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
159 5672 Hale Dr. NaN Bothell Washington 98011
CountryName
159 United States
[1 rows x 26 columns])
(160, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
160 34 26.0 NaN NaN Suchitra O Mohan
Suffix JobTitle NationalIDNumber ... \
160 NaN Production Technician - WC60 754372876 ...
SickLeaveHours PhoneNumber PhoneNumberType \
160 27 753-555-0129 Cell
EmailAddress AddressLine1 AddressLine2 City \
160 suchitra0@adventure-works.com 5678 Clear Court NaN Bellevue
StateProvinceName PostalCode CountryName
160 Washington 98004 United States
[1 rows x 26 columns])
(161, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
161 4 25.0 NaN NaN Rob NaN Walters
Suffix JobTitle NationalIDNumber ... \
161 NaN Senior Tool Designer 112457891 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
161 80 612-555-0100 Cell rob0@aol.com
AddressLine1 AddressLine2 City StateProvinceName \
161 5678 Lakeview Blvd. NaN Minneapolis Minnesota
PostalCode CountryName
161 55402 United States
[1 rows x 26 columns])
(162, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
162 84 26.0 NaN NaN Frank R Martinez
Suffix JobTitle NationalIDNumber ... \
162 NaN Production Technician - WC40 947029962 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
162 53 203-555-0196 Work frank3@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
162 5724 Victory Lane NaN Snohomish Washington 98296
CountryName
162 United States
[1 rows x 26 columns])
(163, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
163 281 274.0 4.0 NaN Shu K Ito
Suffix JobTitle NationalIDNumber ... \
163 NaN Sales Representative 139397894 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
163 33 330-555-0120 Cell shu0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
163 5725 Glaze Drive NaN San Francisco California
PostalCode CountryName
163 94109 United States
[1 rows x 26 columns])
(164, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
164 51 26.0 NaN NaN Jeffrey L Ford
Suffix JobTitle NationalIDNumber ... \
164 NaN Production Technician - WC10 132674823 ...
SickLeaveHours PhoneNumber PhoneNumberType \
164 62 984-555-0185 Work
EmailAddress AddressLine1 AddressLine2 City \
164 jeffrey0@adventure-works.com 5734 Ashford Court NaN Monroe
StateProvinceName PostalCode CountryName
164 Washington 98272 United States
[1 rows x 26 columns])
(165, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
165 117 26.0 NaN NaN Chad W Niswonger
Suffix JobTitle NationalIDNumber ... \
165 NaN Production Technician - WC50 599942664 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
165 69 559-555-0175 Work chad0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
165 5747 Shirley Drive NaN Bothell Washington 98011
CountryName
165 United States
[1 rows x 26 columns])
(166, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
166 74 26.0 NaN NaN Bjorn M Rettig
Suffix JobTitle NationalIDNumber ... \
166 NaN Production Technician - WC30 420023788 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
166 41 199-555-0117 Work bjorn0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
166 5802 Ampersand Drive NaN Seattle Washington 98104
CountryName
166 United States
[1 rows x 26 columns])
(167, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
167 271 263.0 NaN NaN Dan B Wilson
Suffix JobTitle NationalIDNumber ... \
167 NaN Database Administrator 929666391 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
167 53 653-555-0144 Work dan1@aol.com 5863 Sierra
AddressLine2 City StateProvinceName PostalCode CountryName
167 NaN Bellevue Washington 98004 United States
[1 rows x 26 columns])
(168, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
168 57 26.0 NaN NaN Frank T Miller
Suffix JobTitle NationalIDNumber ... \
168 NaN Production Technician - WC50 10708100 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
168 25 167-555-0139 Work frank1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
168 591 Merriewood Drive NaN Snohomish Washington
PostalCode CountryName
168 98296 United States
[1 rows x 26 columns])
(169, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
169 272 263.0 NaN NaN Janaina Barreiro Gambaro
LastName Suffix JobTitle NationalIDNumber ... \
169 Bueno NaN Application Specialist 525932996 ...
SickLeaveHours PhoneNumber PhoneNumberType \
169 55 623-555-0155 Work
EmailAddress AddressLine1 AddressLine2 City \
169 janaina0@adventure-works.com 5979 El Pueblo NaN Issaquah
StateProvinceName PostalCode CountryName
169 Washington 98027 United States
[1 rows x 26 columns])
(170, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
170 256 250.0 NaN NaN Frank S Pellow
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
170 NaN Buyer 367453993 ... 49
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
170 163-555-0147 Cell frank2@aol.com 5980 Icicle Circle
AddressLine2 City StateProvinceName PostalCode CountryName
170 Unit H Renton Washington 98055 United States
[1 rows x 26 columns])
(171, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
171 129 26.0 NaN NaN Gary W Yukish
Suffix JobTitle NationalIDNumber ... \
171 NaN Production Technician - WC40 502058701 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
171 54 901-555-0125 Cell gary0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
171 6057 Hill Street NaN Edmonds Washington 98020
CountryName
171 United States
[1 rows x 26 columns])
(172, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
172 105 26.0 NaN NaN Kevin M Homer
Suffix JobTitle NationalIDNumber ... \
172 NaN Production Technician - WC10 801365500 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
172 65 555-555-0113 Work kevin2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
172 6058 Hill Street # 4 Bellevue Washington 98004
CountryName
172 United States
[1 rows x 26 columns])
(173, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
173 253 250.0 NaN NaN Linda P Meisner
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
173 NaN Buyer 407505660 ... 48
PhoneNumber PhoneNumberType EmailAddress \
173 916-555-0165 Cell linda2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
173 6118 Grasswood Circle NaN Bellevue Washington
PostalCode CountryName
173 98004 United States
[1 rows x 26 columns])
(174, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
174 261 250.0 NaN NaN Reinout N Hillmann
Suffix JobTitle NationalIDNumber ... \
174 NaN Purchasing Assistant 280633567 ...
SickLeaveHours PhoneNumber PhoneNumberType \
174 45 370-555-0163 Work
EmailAddress AddressLine1 AddressLine2 City \
174 reinout0@adventure-works.com 620 Woodside Ct. NaN Bellevue
StateProvinceName PostalCode CountryName
174 Washington 98004 United States
[1 rows x 26 columns])
(175, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
175 19 16.0 NaN NaN Mary A Dempsey
Suffix JobTitle NationalIDNumber ... \
175 NaN Marketing Assistant 52541318 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
175 41 124-555-0114 Cell mary2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
175 6307 Greenbelt Way NaN Bellevue Washington 98004
CountryName
175 United States
[1 rows x 26 columns])
(176, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
176 280 274.0 1.0 NaN Pamela O
LastName Suffix JobTitle NationalIDNumber \
176 Ansman-Wolfe NaN Sales Representative 61161660
... SickLeaveHours PhoneNumber PhoneNumberType \
176 ... 31 340-555-0193 Cell
EmailAddress AddressLine1 AddressLine2 City \
176 pamela0@yahoo.com 636 Vine Hill Way NaN Portland
StateProvinceName PostalCode CountryName
176 Oregon 97205 United States
[1 rows x 26 columns])
(177, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
177 260 250.0 NaN NaN Annette L Hill
Suffix JobTitle NationalIDNumber ... \
177 NaN Purchasing Assistant 437296311 ...
SickLeaveHours PhoneNumber PhoneNumberType \
177 45 125-555-0196 Cell
EmailAddress AddressLine1 AddressLine2 City \
177 annette0@adventure-works.com 6369 Ellis Street NaN Redmond
StateProvinceName PostalCode CountryName
177 Washington 98052 United States
[1 rows x 26 columns])
(178, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
178 59 26.0 NaN NaN Bob N Hohman
Suffix JobTitle NationalIDNumber ... \
178 NaN Production Technician - WC50 843479922 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
178 26 611-555-0116 Work bob0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
178 6387 Scenic Avenue NaN Bothell Washington 98011
CountryName
178 United States
[1 rows x 26 columns])
(179, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
179 206 26.0 NaN NaN Stuart V Munson
Suffix JobTitle NationalIDNumber ... \
179 NaN Production Technician - WC45 835460180 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
179 62 413-555-0136 Cell stuart0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
179 6448 Castle Court NaN Bellevue Washington 98004
CountryName
179 United States
[1 rows x 26 columns])
(180, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
180 71 26.0 NaN NaN Michael Sean Ray
Suffix JobTitle NationalIDNumber ... \
180 NaN Production Supervisor - WC30 578935259 ...
SickLeaveHours PhoneNumber PhoneNumberType \
180 55 156-555-0199 Cell
EmailAddress AddressLine1 AddressLine2 City \
180 michael3@adventure-works.com 6498 Mining Rd. NaN Seattle
StateProvinceName PostalCode CountryName
180 Washington 98104 United States
[1 rows x 26 columns])
(181, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
181 14 25.0 NaN NaN Michael I Sullivan
Suffix JobTitle NationalIDNumber ... \
181 NaN Senior Design Engineer 42487730 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
181 21 465-555-0156 Cell michael8@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
181 6510 Hacienda Drive NaN Renton Washington 98055
CountryName
181 United States
[1 rows x 26 columns])
(182, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
182 102 26.0 NaN NaN Zheng W Mu
Suffix JobTitle NationalIDNumber ... \
182 NaN Production Supervisor - WC10 360868122 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
182 53 113-555-0173 Cell zheng0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
182 6578 Woodhaven Ln. NaN Seattle Washington 98104
CountryName
182 United States
[1 rows x 26 columns])
(183, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
183 265 263.0 NaN NaN Ashvini R Sharma
Suffix JobTitle NationalIDNumber ... \
183 NaN Network Administrator 749389530 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
183 55 656-555-0119 Work ashvini0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName \
183 6580 Poor Ridge Court NaN Issaquah Washington
PostalCode CountryName
183 98027 United States
[1 rows x 26 columns])
(184, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
184 47 26.0 NaN NaN Andrew R Hill
Suffix JobTitle NationalIDNumber ... \
184 NaN Production Supervisor - WC10 33237992 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
184 52 908-555-0159 Cell andrew0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
184 6629 Polson Circle NaN Everett Washington 98201
CountryName
184 United States
[1 rows x 26 columns])
(185, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
185 165 26.0 NaN NaN Chris T Preston
Suffix JobTitle NationalIDNumber ... \
185 NaN Production Technician - WC45 539490372 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
185 58 200-555-0112 Cell chris0@aol.com
AddressLine1 AddressLine2 City StateProvinceName \
185 6657 Sand Pointe Lane NaN Seattle Washington
PostalCode CountryName
185 98104 United States
[1 rows x 26 columns])
(186, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
186 167 26.0 NaN NaN David N Johnson
Suffix JobTitle NationalIDNumber ... \
186 NaN Production Technician - WC30 498138869 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
186 32 166-555-0162 Cell david1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
186 6697 Ridge Park Drive NaN Kenmore Washington
PostalCode CountryName
186 98028 United States
[1 rows x 26 columns])
(187, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
187 224 25.0 NaN NaN William S Vong
Suffix JobTitle NationalIDNumber ... \
187 NaN Scheduling Assistant 621209647 ...
SickLeaveHours PhoneNumber PhoneNumberType \
187 42 148-555-0145 Cell
EmailAddress AddressLine1 AddressLine2 City \
187 william0@adventure-works.com 6774 Bonanza NaN Bellevue
StateProvinceName PostalCode CountryName
187 Washington 98004 United States
[1 rows x 26 columns])
(188, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
188 190 26.0 NaN NaN Robert J
LastName Suffix JobTitle NationalIDNumber \
188 Rounthwaite NaN Production Technician - WC45 456839592
... SickLeaveHours PhoneNumber PhoneNumberType \
188 ... 61 589-555-0147 Cell
EmailAddress AddressLine1 AddressLine2 City \
188 robert0@adventure-works.com 6843 San Simeon Dr. NaN Seattle
StateProvinceName PostalCode CountryName
188 Washington 98104 United States
[1 rows x 26 columns])
(189, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
189 143 26.0 NaN NaN Krishna NaN
LastName Suffix JobTitle NationalIDNumber \
189 Sunkammurali NaN Production Technician - WC20 56772045
... SickLeaveHours PhoneNumber PhoneNumberType \
189 ... 21 491-555-0183 Cell
EmailAddress AddressLine1 AddressLine2 City \
189 krishna0@safe-mail.net 6870 D Bel Air Drive NaN Edmonds
StateProvinceName PostalCode CountryName
189 Washington 98020 United States
[1 rows x 26 columns])
(190, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
190 247 249.0 NaN NaN Janet L
LastName Suffix JobTitle NationalIDNumber \
190 Sheperdigian NaN Accounts Payable Specialist 519756660
... SickLeaveHours PhoneNumber PhoneNumberType \
190 ... 52 393-555-0186 Work
EmailAddress AddressLine1 AddressLine2 City \
190 janet0@safe-mail.net 6871 Thornwood Dr. NaN Sammamish
StateProvinceName PostalCode CountryName
190 Washington 98074 United States
[1 rows x 26 columns])
(191, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
191 76 26.0 NaN NaN Carol M Philips
Suffix JobTitle NationalIDNumber ... \
191 NaN Production Technician - WC30 227319668 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
191 42 609-555-0153 Cell carol0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
191 6872 Thornwood Dr. NaN Bothell Washington 98011
CountryName
191 United States
[1 rows x 26 columns])
(192, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
192 137 26.0 NaN NaN Anibal T Sousa
Suffix JobTitle NationalIDNumber ... \
192 NaN Production Technician - WC20 63761469 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
192 24 106-555-0120 Work anibal0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
192 6891 Ham Drive NaN Redmond Washington 98052
CountryName
192 United States
[1 rows x 26 columns])
(193, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
193 234 1.0 NaN NaN Laura F Norman
Suffix JobTitle NationalIDNumber ... \
193 NaN Chief Financial Officer 184188301 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
193 20 615-555-0110 Cell laura1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
193 6937 E. 42nd Street NaN Renton Washington 98055
CountryName
193 United States
[1 rows x 26 columns])
(194, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
194 20 16.0 NaN NaN Wanida M Benshoof
Suffix JobTitle NationalIDNumber ... \
194 NaN Marketing Assistant 323403273 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
194 40 708-555-0141 Work wanida0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
194 6951 Harmony Way NaN Sammamish Washington 98074
CountryName
194 United States
[1 rows x 26 columns])
(195, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
195 159 26.0 NaN NaN Terrence W Earls
Suffix JobTitle NationalIDNumber ... \
195 NaN Production Technician - WC20 404159499 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
195 26 110-555-0115 Work terrence0@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
195 6968 Wren Ave. NaN Bellevue Washington 98004
CountryName
195 United States
[1 rows x 26 columns])
(196, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
196 7 25.0 NaN NaN Dylan A Miller
Suffix JobTitle NationalIDNumber ... \
196 NaN Research and Development Manager 134969118 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
196 50 181-555-0156 Work dylan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
196 7048 Laurel NaN Kenmore Washington 98028
CountryName
196 United States
[1 rows x 26 columns])
(197, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
197 139 26.0 NaN Mr. Hung-Fu T Ting
Suffix JobTitle NationalIDNumber ... \
197 NaN Production Technician - WC20 113393530 ...
SickLeaveHours PhoneNumber PhoneNumberType \
197 20 497-555-0181 Cell
EmailAddress AddressLine1 AddressLine2 City \
197 hung-fu0@adventure-works.com 7086 O St. NaN Sammamish
StateProvinceName PostalCode CountryName
197 Washington 98074 United States
[1 rows x 26 columns])
(198, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
198 40 26.0 NaN NaN JoLynn M Dobney
Suffix JobTitle NationalIDNumber ... \
198 NaN Production Supervisor - WC60 309738752 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
198 61 903-555-0145 Work jolynn0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
198 7126 Ending Ct. NaN Seattle Washington 98104
CountryName
198 United States
[1 rows x 26 columns])
(199, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
199 193 26.0 NaN NaN Alejandro E McGuel
Suffix JobTitle NationalIDNumber ... \
199 NaN Production Technician - WC40 761597760 ...
SickLeaveHours PhoneNumber PhoneNumberType \
199 46 668-555-0130 Work
EmailAddress AddressLine1 AddressLine2 \
199 alejandro0@adventure-works.com 7127 Los Gatos Court NaN
City StateProvinceName PostalCode CountryName
199 Seattle Washington 98104 United States
[1 rows x 26 columns])
(200, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
200 183 26.0 NaN NaN Barbara S Decker
Suffix JobTitle NationalIDNumber ... \
200 NaN Production Technician - WC20 969985265 ...
SickLeaveHours PhoneNumber PhoneNumberType \
200 28 119-555-0192 Cell
EmailAddress AddressLine1 AddressLine2 \
200 barbara0@adventure-works.com 7145 Matchstick Drive NaN
City StateProvinceName PostalCode CountryName
200 Sammamish Washington 98074 United States
[1 rows x 26 columns])
(201, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
201 15 25.0 NaN NaN Sharon B Salavaria
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
201 NaN Design Engineer 56920285 ... 22
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
201 970-555-0138 Cell sharon0@safe-mail.net 7165 Brock Lane
AddressLine2 City StateProvinceName PostalCode CountryName
201 NaN Renton Washington 98055 United States
[1 rows x 26 columns])
(202, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
202 87 26.0 NaN NaN Cristian K
LastName Suffix JobTitle NationalIDNumber \
202 Petculescu NaN Production Supervisor - WC10 7201901
... SickLeaveHours PhoneNumber PhoneNumberType \
202 ... 53 434-555-0133 Cell
EmailAddress AddressLine1 AddressLine2 City \
202 cristian0@aol.com 7166 Brock Lane NaN Seattle
StateProvinceName PostalCode CountryName
202 Washington 98104 United States
[1 rows x 26 columns])
(203, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
203 142 26.0 NaN NaN Olinda C Turner
Suffix JobTitle NationalIDNumber ... \
203 NaN Production Technician - WC20 163347032 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
203 21 306-555-0186 Cell olinda0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
203 7221 Peachwillow Street NaN Bellevue Washington
PostalCode CountryName
203 98004 United States
[1 rows x 26 columns])
(204, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
204 201 26.0 NaN NaN Brian T Lloyd
Suffix JobTitle NationalIDNumber ... \
204 NaN Production Technician - WC40 746201340 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
204 47 110-555-0182 Cell brian0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
204 7230 Vine Maple Street NaN Snohomish Washington
PostalCode CountryName
204 98296 United States
[1 rows x 26 columns])
(205, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
205 128 26.0 NaN NaN Paul B
LastName Suffix JobTitle NationalIDNumber \
205 Komosinski NaN Production Technician - WC40 384162788
... SickLeaveHours PhoneNumber PhoneNumberType \
205 ... 54 147-555-0160 Work
EmailAddress AddressLine1 AddressLine2 City \
205 paul0@hotmail.com 7270 Pepper Way NaN Bellevue
StateProvinceName PostalCode CountryName
205 Washington 98004 United States
[1 rows x 26 columns])
(206, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
206 153 26.0 NaN NaN Hanying P Feng
Suffix JobTitle NationalIDNumber ... \
206 NaN Production Technician - WC20 568596888 ...
SickLeaveHours PhoneNumber PhoneNumberType \
206 27 319-555-0139 Work
EmailAddress AddressLine1 AddressLine2 City \
206 hanying0@adventure-works.com 7297 RisingView NaN Redmond
StateProvinceName PostalCode CountryName
206 Washington 98052 United States
[1 rows x 26 columns])
(207, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
207 45 26.0 NaN NaN Thomas R Michaels
Suffix JobTitle NationalIDNumber ... \
207 NaN Production Technician - WC60 500412746 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
207 38 278-555-0118 Cell thomas0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
207 7338 Green St. NaN Edmonds Washington 98020
CountryName
207 United States
[1 rows x 26 columns])
(208, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
208 141 26.0 NaN NaN Min G Su
Suffix JobTitle NationalIDNumber ... \
208 NaN Production Technician - WC20 872923042 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
208 20 590-555-0152 Work min0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName \
208 7396 Stratton Circle NaN Bellevue Washington
PostalCode CountryName
208 98004 United States
[1 rows x 26 columns])
(209, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
209 208 26.0 NaN NaN Scott R Gode
Suffix JobTitle NationalIDNumber ... \
209 NaN Production Technician - WC45 199546871 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
209 63 391-555-0138 Cell scott0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
209 7403 N. Broadway NaN Seattle Washington 98104
CountryName
209 United States
[1 rows x 26 columns])
(210, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
210 264 263.0 NaN NaN Stephanie A Conroy
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
210 NaN Network Manager 858323870 ... 54
PhoneNumber PhoneNumberType EmailAddress \
210 594-555-0110 Work stephanie0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
210 7435 Ricardo NaN Issaquah Washington 98027
CountryName
210 United States
[1 rows x 26 columns])
(211, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
211 58 26.0 NaN NaN Kendall C Keil
Suffix JobTitle NationalIDNumber ... \
211 NaN Production Technician - WC50 571658797 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
211 25 138-555-0128 Work kendall0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
211 7439 Laguna Niguel NaN Seattle Washington 98104
CountryName
211 United States
[1 rows x 26 columns])
(212, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
212 285 273.0 NaN Mr. Syed E Abbas
Suffix JobTitle NationalIDNumber ... \
212 NaN Pacific Sales Manager 481044938 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
212 30 926-555-0182 Work syed0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
212 7484 Roundtree Drive NaN Bothell Washington 98011
CountryName
212 United States
[1 rows x 26 columns])
(213, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
213 64 26.0 NaN NaN Michael J Zwilling
Suffix JobTitle NationalIDNumber ... \
213 NaN Production Technician - WC60 582347317 ...
SickLeaveHours PhoneNumber PhoneNumberType \
213 33 582-555-0148 Cell
EmailAddress AddressLine1 AddressLine2 City \
213 michael7@adventure-works.com 7511 Cooper Dr. NaN Edmonds
StateProvinceName PostalCode CountryName
213 Washington 98020 United States
[1 rows x 26 columns])
(214, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
214 2 1.0 NaN NaN Terri Lee Duffy
Suffix JobTitle NationalIDNumber ... \
214 NaN Vice President of Engineering 245797967 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
214 20 819-555-0175 Work terri0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
214 7559 Worth Ct. NaN Renton Washington 98055
CountryName
214 United States
[1 rows x 26 columns])
(215, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
215 195 26.0 NaN NaN Kevin H Liu
Suffix JobTitle NationalIDNumber ... \
215 NaN Production Technician - WC40 918737118 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
215 49 714-555-0138 Work kevin1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
215 7594 Alexander Pl. NaN Seattle Washington 98104
CountryName
215 United States
[1 rows x 26 columns])
(216, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
216 94 26.0 NaN NaN Russell NaN Hunter
Suffix JobTitle NationalIDNumber ... \
216 NaN Production Technician - WC50 718299860 ...
SickLeaveHours PhoneNumber PhoneNumberType \
216 23 786-555-0144 Work
EmailAddress AddressLine1 AddressLine2 City \
216 russell0@adventure-works.com 7616 Honey Court NaN Seattle
StateProvinceName PostalCode CountryName
216 Washington 98104 United States
[1 rows x 26 columns])
(217, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
217 242 249.0 NaN NaN Deborah E Poe
Suffix JobTitle NationalIDNumber ... \
217 NaN Accounts Receivable Specialist 363923697 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
217 50 602-555-0194 Cell deborah0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
217 7640 First Ave. NaN Everett Washington 98201
CountryName
217 United States
[1 rows x 26 columns])
(218, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
218 237 235.0 NaN NaN Hao O Chen
Suffix JobTitle NationalIDNumber \
218 NaN Human Resources Administrative Assistant 416679555
... SickLeaveHours PhoneNumber PhoneNumberType \
218 ... 46 806-555-0136 Work
EmailAddress AddressLine1 AddressLine2 City \
218 hao0@adventure-works.com 7691 Benedict Ct. # 141 Issaquah
StateProvinceName PostalCode CountryName
218 Washington 98027 United States
[1 rows x 26 columns])
(219, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
219 157 26.0 NaN NaN Linda A Randall
Suffix JobTitle NationalIDNumber ... \
219 NaN Production Technician - WC20 812797414 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
219 26 696-555-0157 Work linda1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
219 77 Birchwood NaN Seattle Washington 98104
CountryName
219 United States
[1 rows x 26 columns])
(220, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
220 28 26.0 NaN NaN Guy R Gilbert
Suffix JobTitle NationalIDNumber ... \
220 NaN Production Technician - WC60 14417807 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
220 30 320-555-0195 Work guy1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
220 7726 Driftwood Drive NaN Monroe Washington 98272
CountryName
220 United States
[1 rows x 26 columns])
(221, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
221 191 26.0 NaN NaN Lionel C Penuchot
Suffix JobTitle NationalIDNumber ... \
221 NaN Production Technician - WC45 399658727 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
221 59 450-555-0152 Cell lionel0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
221 7765 Sunsine Drive NaN Seattle Washington 98104
CountryName
221 United States
[1 rows x 26 columns])
(222, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
222 273 1.0 NaN Mr. Brian S Welcker
Suffix JobTitle NationalIDNumber ... \
222 NaN Vice President of Sales 112432117 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
222 25 716-555-0127 Cell brian3@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
222 7772 Golden Meadow NaN Issaquah Washington 98027
CountryName
222 United States
[1 rows x 26 columns])
(223, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
223 9 25.0 NaN NaN Gigi N Matthew
Suffix JobTitle NationalIDNumber \
223 NaN Research and Development Engineer 658797903
... SickLeaveHours PhoneNumber PhoneNumberType \
223 ... 51 185-555-0186 Cell
EmailAddress AddressLine1 AddressLine2 City \
223 gigi0@adventure-works.com 7808 Brown St. NaN Bellevue
StateProvinceName PostalCode CountryName
223 Washington 98004 United States
[1 rows x 26 columns])
(224, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
224 43 26.0 NaN NaN Nancy A Anderson
Suffix JobTitle NationalIDNumber ... \
224 NaN Production Technician - WC60 693325305 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
224 37 970-555-0118 Cell nancy0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
224 7820 Bird Drive NaN Sammamish Washington 98074
CountryName
224 United States
[1 rows x 26 columns])
(225, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
225 33 26.0 NaN NaN Annik O Stahl
Suffix JobTitle NationalIDNumber ... \
225 NaN Production Technician - WC60 801758002 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
225 28 499-555-0125 Work annik0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName \
225 7842 Ygnacio Valley Road NaN Seattle Washington
PostalCode CountryName
225 98104 United States
[1 rows x 26 columns])
(226, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
226 17 16.0 NaN NaN Kevin F Brown
Suffix JobTitle NationalIDNumber ... \
226 NaN Marketing Assistant 253022876 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
226 41 150-555-0189 Cell kevin0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
226 7883 Missing Canyon Court NaN Everett Washington
PostalCode CountryName
226 98201 United States
[1 rows x 26 columns])
(227, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
227 136 26.0 NaN NaN Sylvester A Valdez
Suffix JobTitle NationalIDNumber ... \
227 NaN Production Technician - WC20 701156975 ...
SickLeaveHours PhoneNumber PhoneNumberType \
227 22 492-555-0174 Cell
EmailAddress AddressLine1 AddressLine2 \
227 sylvester0@adventure-works.com 7902 Grammercy Lane Unit A
City StateProvinceName PostalCode CountryName
227 Bellevue Washington 98004 United States
[1 rows x 26 columns])
(228, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
228 173 26.0 NaN NaN Eugene R
LastName Suffix JobTitle NationalIDNumber \
228 Zabokritski NaN Production Technician - WC30 87268837
... SickLeaveHours PhoneNumber PhoneNumberType \
228 ... 36 241-555-0191 Cell
EmailAddress AddressLine1 AddressLine2 City \
228 eugene0@adventure-works.com 7939 Bayview Court NaN Sammamish
StateProvinceName PostalCode CountryName
228 Washington 98074 United States
[1 rows x 26 columns])
(229, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
229 216 25.0 NaN NaN Sean P Alexander
Suffix JobTitle NationalIDNumber ... \
229 NaN Quality Assurance Technician 403414852 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
229 61 420-555-0173 Cell sean0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
229 7985 Center Street NaN Renton Washington 98055
CountryName
229 United States
[1 rows x 26 columns])
(230, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
230 277 274.0 3.0 NaN Jillian NaN Carson
Suffix JobTitle NationalIDNumber ... \
230 NaN Sales Representative 615389812 ...
SickLeaveHours PhoneNumber PhoneNumberType \
230 32 517-555-0117 Work
EmailAddress AddressLine1 AddressLine2 City \
230 jillian0@adventure-works.com 80 Sunview Terrace NaN Duluth
StateProvinceName PostalCode CountryName
230 Minnesota 55802 United States
[1 rows x 26 columns])
(231, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
231 35 26.0 NaN NaN Brandon G
LastName Suffix JobTitle NationalIDNumber \
231 Heidepriem NaN Production Technician - WC60 999440576
... SickLeaveHours PhoneNumber PhoneNumberType \
231 ... 31 429-555-0137 Cell
EmailAddress AddressLine1 AddressLine2 City \
231 brandon0@adventure-works.com 8000 Crane Court NaN Redmond
StateProvinceName PostalCode CountryName
231 Washington 98052 United States
[1 rows x 26 columns])
(232, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
232 228 227.0 NaN NaN Christian E
LastName Suffix JobTitle NationalIDNumber \
232 Kleinerman NaN Maintenance Supervisor 553069203
... SickLeaveHours PhoneNumber PhoneNumberType \
232 ... 66 846-555-0157 Cell
EmailAddress AddressLine1 AddressLine2 City \
232 christian0@hotmail.com 8036 Summit View Dr. NaN Gold Bar
StateProvinceName PostalCode CountryName
232 Washington 98251 United States
[1 rows x 26 columns])
(233, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
233 223 25.0 NaN NaN Sairaj L Uddin
Suffix JobTitle NationalIDNumber ... \
233 NaN Scheduling Assistant 981495526 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
233 43 500-555-0159 Cell sairaj0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
233 8040 Hill Ct NaN Redmond Washington 98052
CountryName
233 United States
[1 rows x 26 columns])
(234, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
234 100 26.0 NaN NaN Lolan B Song
Suffix JobTitle NationalIDNumber ... \
234 NaN Production Technician - WC50 204035155 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
234 23 582-555-0178 Cell lolan0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
234 8152 Claudia Dr. NaN Edmonds Washington 98020
CountryName
234 United States
[1 rows x 26 columns])
(235, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
235 275 274.0 2.0 NaN Michael G Blythe
Suffix JobTitle NationalIDNumber ... \
235 NaN Sales Representative 841560125 ...
SickLeaveHours PhoneNumber PhoneNumberType \
235 39 257-555-0154 Cell
EmailAddress AddressLine1 AddressLine2 City \
235 michael9@adventure-works.com 8154 Via Mexico NaN Detroit
StateProvinceName PostalCode CountryName
235 Michigan 48226 United States
[1 rows x 26 columns])
(236, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
236 85 26.0 NaN NaN Brian Richard Goldstein
Suffix JobTitle NationalIDNumber ... \
236 NaN Production Technician - WC40 1662732 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
236 51 730-555-0117 Cell brian2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
236 8157 W. Book NaN Bothell Washington 98011
CountryName
236 United States
[1 rows x 26 columns])
(237, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
237 61 26.0 NaN NaN Diane H Tibbott
Suffix JobTitle NationalIDNumber ... \
237 NaN Production Technician - WC50 92096924 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
237 24 361-555-0180 Work diane2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
237 8192 Seagull Court NaN Kenmore Washington 98028
CountryName
237 United States
[1 rows x 26 columns])
(238, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
238 106 26.0 NaN NaN John T Kane
Suffix JobTitle NationalIDNumber ... \
238 NaN Production Technician - WC10 561196580 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
238 66 254-555-0114 Work john4@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
238 8209 Green View Court NaN Duvall Washington 98019
CountryName
238 United States
[1 rows x 26 columns])
(239, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
239 200 26.0 NaN NaN Frank T Lee
Suffix JobTitle NationalIDNumber ... \
239 NaN Production Technician - WC40 749211824 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
239 48 158-555-0191 Cell frank0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
239 8290 Margaret Ct. NaN Seattle Washington 98104
CountryName
239 United States
[1 rows x 26 columns])
(240, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
240 279 274.0 5.0 NaN Tsvi Michael Reiter
Suffix JobTitle NationalIDNumber ... \
240 NaN Sales Representative 716374314 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
240 34 664-555-0112 Work tsvi0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
240 8291 Crossbow Way NaN Memphis Tennessee 38103
CountryName
240 United States
[1 rows x 26 columns])
(241, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
241 146 26.0 NaN NaN Jian Shuo NaN Wang
Suffix JobTitle NationalIDNumber ... \
241 NaN Production Technician - WC30 160739235 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
241 38 952-555-0178 Cell jianshuo0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
241 8310 Ridge Circle NaN Monroe Washington 98272
CountryName
241 United States
[1 rows x 26 columns])
(242, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
242 103 26.0 NaN NaN Ebru N Ersan
Suffix JobTitle NationalIDNumber ... \
242 NaN Production Technician - WC10 455563743 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
242 66 202-555-0187 Cell ebru0@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
242 8316 La Salle St. NaN Sammamish Washington 98074
CountryName
242 United States
[1 rows x 26 columns])
(243, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
243 73 26.0 NaN NaN Carole M Poland
Suffix JobTitle NationalIDNumber ... \
243 NaN Production Technician - WC30 138280935 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
243 41 688-555-0192 Cell carole0@aol.com
AddressLine1 AddressLine2 City StateProvinceName \
243 8411 Mt. Orange Place NaN Edmonds Washington
PostalCode CountryName
243 98020 United States
[1 rows x 26 columns])
(244, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
244 185 26.0 NaN NaN Stefen A Hesse
Suffix JobTitle NationalIDNumber ... \
244 NaN Production Technician - WC20 621932914 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
244 29 165-555-0113 Cell stefen0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
244 8463 Vista Avenue NaN Duvall Washington 98019
CountryName
244 United States
[1 rows x 26 columns])
(245, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
245 37 26.0 NaN NaN Chris O Okelberry
Suffix JobTitle NationalIDNumber ... \
245 NaN Production Technician - WC60 442121106 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
245 28 315-555-0144 Cell chris2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
245 8467 Clifford Court NaN Redmond Washington 98052
CountryName
245 United States
[1 rows x 26 columns])
(246, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
246 215 25.0 NaN NaN Mark L
LastName Suffix JobTitle NationalIDNumber \
246 Harrington NaN Quality Assurance Technician 381772114
... SickLeaveHours PhoneNumber PhoneNumberType \
246 ... 61 147-555-0179 Cell
EmailAddress AddressLine1 AddressLine2 City \
246 mark0@adventure-works.com 8585 Los Gatos Ct. NaN Issaquah
StateProvinceName PostalCode CountryName
246 Washington 98027 United States
[1 rows x 26 columns])
(247, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
247 179 26.0 NaN NaN Jan S Miksovsky
Suffix JobTitle NationalIDNumber ... \
247 NaN Production Technician - WC30 587567941 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
247 35 139-555-0131 Work jan0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
247 8624 Pepper Way NaN Everett Washington 98201
CountryName
247 United States
[1 rows x 26 columns])
(248, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
248 91 26.0 NaN NaN Kimberly B Zimmerman
Suffix JobTitle NationalIDNumber ... \
248 NaN Production Technician - WC10 390124815 ...
SickLeaveHours PhoneNumber PhoneNumberType \
248 67 123-555-0167 Work
EmailAddress AddressLine1 AddressLine2 \
248 kimberly0@adventure-works.com 8656 Lakespring Place NaN
City StateProvinceName PostalCode CountryName
248 Seattle Washington 98104 United States
[1 rows x 26 columns])
(249, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
249 21 16.0 NaN NaN Terry J Eminhizer
Suffix JobTitle NationalIDNumber ... \
249 NaN Marketing Specialist 243322160 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
249 42 138-555-0118 Cell terry0@gmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
249 8668 Via Neruda NaN Bellevue Washington 98004
CountryName
249 United States
[1 rows x 26 columns])
(250, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
250 207 26.0 NaN NaN Greg F Alderson
Suffix JobTitle NationalIDNumber ... \
250 NaN Production Technician - WC45 687685941 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
250 62 332-555-0150 Work greg0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
250 8684 Military East NaN Bellevue Washington 98004
CountryName
250 United States
[1 rows x 26 columns])
(251, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
251 82 26.0 NaN NaN Jack T Creasey
Suffix JobTitle NationalIDNumber ... \
251 NaN Production Technician - WC40 58791499 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
251 51 521-555-0113 Cell jack1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
251 874 Olivera Road NaN Seattle Washington 98104
CountryName
251 United States
[1 rows x 26 columns])
(252, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
252 254 250.0 NaN NaN Fukiko J Ogisu
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
252 NaN Buyer 482810518 ... 48
PhoneNumber PhoneNumberType EmailAddress \
252 520-555-0177 Work fukiko0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
252 8751 Norse Drive NaN Bellevue Washington 98004
CountryName
252 United States
[1 rows x 26 columns])
(253, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
253 67 26.0 NaN NaN Jay G Adams
Suffix JobTitle NationalIDNumber ... \
253 NaN Production Technician - WC60 63179277 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
253 36 407-555-0165 Work jay0@yahoo.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
253 896 Southdale NaN Monroe Washington 98272
CountryName
253 United States
[1 rows x 26 columns])
(254, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
254 262 234.0 NaN NaN David M Barber
Suffix JobTitle NationalIDNumber \
254 NaN Assistant to the Chief Financial Officer 231203233
... SickLeaveHours PhoneNumber PhoneNumberType \
254 ... 48 477-555-0132 Work
EmailAddress AddressLine1 AddressLine2 \
254 david5@adventure-works.com 8967 Hamilton Ave. NaN
City StateProvinceName PostalCode CountryName
254 Newport Hills Washington 98006 United States
[1 rows x 26 columns])
(255, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
255 53 26.0 NaN NaN Diane R Glimp
Suffix JobTitle NationalIDNumber ... \
255 NaN Production Technician - WC10 9659517 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
255 63 202-555-0151 Cell diane0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
255 9006 Woodside Way NaN Redmond Washington 98052
CountryName
255 United States
[1 rows x 26 columns])
(256, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
256 282 274.0 6.0 NaN José Edvaldo Saraiva
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
256 NaN Sales Representative 399771412 ... 35
PhoneNumber PhoneNumberType EmailAddress \
256 185-555-0169 Work josé1@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName \
256 9100 Sheppard Avenue North NaN Ottawa Ontario
PostalCode CountryName
256 K4B 1T7 Canada
[1 rows x 26 columns])
(257, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
257 169 26.0 NaN NaN Susan A Metters
Suffix JobTitle NationalIDNumber ... \
257 NaN Production Technician - WC30 351069889 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
257 35 639-555-0164 Cell susan1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
257 9104 Mt. Sequoia Ct. NaN Sammamish Washington
PostalCode CountryName
257 98074 United States
[1 rows x 26 columns])
(258, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
258 209 26.0 NaN NaN Kathie E Flood
Suffix JobTitle NationalIDNumber ... \
258 NaN Production Technician - WC45 167554340 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
258 63 446-555-0118 Work kathie0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
258 9241 St George Dr. NaN Everett Washington 98201
CountryName
258 United States
[1 rows x 26 columns])
(259, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
259 50 26.0 NaN NaN Sidney M Higa
Suffix JobTitle NationalIDNumber ... \
259 NaN Production Technician - WC10 844973625 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
259 62 424-555-0189 Work sidney0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
259 9277 Country View Lane NaN Edmonds Washington
PostalCode CountryName
259 98020 United States
[1 rows x 26 columns])
(260, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
260 222 25.0 NaN NaN A. Scott NaN Wright
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
260 NaN Master Scheduler 685233686 ... 42
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
260 992-555-0194 Cell ascott0@aol.com 9297 Kenston Dr.
AddressLine2 City StateProvinceName PostalCode CountryName
260 NaN Newport Hills Washington 98006 United States
[1 rows x 26 columns])
(261, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
261 70 26.0 NaN NaN David J Ortiz
Suffix JobTitle NationalIDNumber ... \
261 NaN Production Technician - WC60 36151748 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
261 36 712-555-0119 Work david2@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
261 931 Corte De Luna NaN Seattle Washington 98104
CountryName
261 United States
[1 rows x 26 columns])
(262, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
262 219 25.0 NaN NaN Sean N Chai
Suffix JobTitle NationalIDNumber ... \
262 NaN Document Control Assistant 242381745 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
262 59 205-555-0132 Cell sean1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
262 9314 Icicle Way NaN Issaquah Washington 98027
CountryName
262 United States
[1 rows x 26 columns])
(263, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
263 148 26.0 NaN NaN Jason M Watters
Suffix JobTitle NationalIDNumber ... \
263 NaN Production Technician - WC30 733022683 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
263 39 571-555-0179 Work jason0@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
263 9320 Teakwood Dr. NaN Bellevue Washington 98004
CountryName
263 United States
[1 rows x 26 columns])
(264, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
264 140 26.0 NaN NaN Prasanna E
LastName Suffix JobTitle NationalIDNumber \
264 Samarawickrama NaN Production Technician - WC20 339233463
... SickLeaveHours PhoneNumber PhoneNumberType \
264 ... 22 129-555-0199 Cell
EmailAddress AddressLine1 AddressLine2 City \
264 prasanna0@safe-mail.net 9322 Driving Drive NaN Redmond
StateProvinceName PostalCode CountryName
264 Washington 98052 United States
[1 rows x 26 columns])
(265, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
265 290 287.0 7.0 NaN Ranjit R
LastName Suffix JobTitle NationalIDNumber \
265 Varkey Chudukatil NaN Sales Representative 134219713
... SickLeaveHours PhoneNumber PhoneNumberType \
265 ... 37 1 (11) 500 555-0117 Cell
EmailAddress AddressLine1 AddressLine2 City \
265 ranjit0@adventure-works.com 94, rue Descartes NaN Bordeaux
StateProvinceName PostalCode CountryName
265 Gironde 33000 France
[1 rows x 26 columns])
(266, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
266 5 25.0 NaN Ms. Gail A Erickson
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
266 NaN Design Engineer 695256908 ... 22
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
266 849-555-0139 Cell gail0@gmail.com 9435 Breck Court
AddressLine2 City StateProvinceName PostalCode CountryName
266 NaN Bellevue Washington 98004 United States
[1 rows x 26 columns])
(267, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
267 252 250.0 NaN NaN Arvind B Rao
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
267 NaN Buyer 792847334 ... 50
PhoneNumber PhoneNumberType EmailAddress \
267 848-555-0163 Cell arvind0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
267 9495 Limewood Place NaN Renton Washington 98055
CountryName
267 United States
[1 rows x 26 columns])
(268, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
268 266 263.0 NaN NaN Peter I Connelly
Suffix JobTitle NationalIDNumber ... \
268 NaN Network Administrator 672243793 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
268 54 310-555-0133 Work peter1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
268 9530 Vine Lane NaN Issaquah Washington 98027
CountryName
268 United States
[1 rows x 26 columns])
(269, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
269 233 227.0 NaN NaN Magnus E Hedlund
Suffix JobTitle NationalIDNumber \
269 NaN Facilities Administrative Assistant 552560652
... SickLeaveHours PhoneNumber PhoneNumberType \
269 ... 63 583-555-0182 Work
EmailAddress AddressLine1 AddressLine2 City \
269 magnus0@adventure-works.com 9533 Working Drive NaN Renton
StateProvinceName PostalCode CountryName
269 Washington 98055 United States
[1 rows x 26 columns])
(270, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
270 83 26.0 NaN NaN Patrick M Cook
Suffix JobTitle NationalIDNumber ... \
270 NaN Production Technician - WC40 988315686 ...
SickLeaveHours PhoneNumber PhoneNumberType \
270 50 425-555-0117 Cell
EmailAddress AddressLine1 AddressLine2 \
270 patrick1@adventure-works.com 9537 Ridgewood Drive NaN
City StateProvinceName PostalCode CountryName
270 Seattle Washington 98104 United States
[1 rows x 26 columns])
(271, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
271 251 250.0 NaN NaN Mikael Q Sandberg
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
271 NaN Buyer 603686790 ... 49
PhoneNumber PhoneNumberType EmailAddress AddressLine1 \
271 309-555-0170 Work mikael0@safe-mail.net 9539 Glenside Dr
AddressLine2 City StateProvinceName PostalCode CountryName
271 NaN Bothell Washington 98011 United States
[1 rows x 26 columns])
(272, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
272 241 249.0 NaN NaN David J Liu
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
272 NaN Accounts Manager 30845 ... 48
PhoneNumber PhoneNumberType EmailAddress \
272 646-555-0185 Work david6@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
272 9605 Pheasant Circle NaN Gold Bar Washington
PostalCode CountryName
272 98251 United States
[1 rows x 26 columns])
(273, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
273 25 1.0 NaN NaN James R Hamilton
Suffix JobTitle NationalIDNumber ... \
273 NaN Vice President of Production 519899904 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
273 52 870-555-0122 Work james1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
273 9652 Los Angeles NaN Monroe Washington 98272
CountryName
273 United States
[1 rows x 26 columns])
(274, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
274 108 26.0 NaN NaN Jinghao K Liu
Suffix JobTitle NationalIDNumber ... \
274 NaN Production Supervisor - WC50 630184120 ...
SickLeaveHours PhoneNumber PhoneNumberType \
274 58 794-555-0159 Cell
EmailAddress AddressLine1 AddressLine2 \
274 jinghao0@adventure-works.com 9666 Northridge Ct. NaN
City StateProvinceName PostalCode CountryName
274 Carnation Washington 98014 United States
[1 rows x 26 columns])
(275, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
275 239 235.0 NaN NaN Mindy C Martin
Suffix JobTitle NationalIDNumber ... \
275 NaN Benefits Specialist 619308550 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
275 45 522-555-0147 Work mindy0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
275 9687 Shakespeare Drive NaN Newport Hills Washington
PostalCode CountryName
275 98006 United States
[1 rows x 26 columns])
(276, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
276 27 26.0 NaN NaN Jo A Brown
Suffix JobTitle NationalIDNumber ... \
276 NaN Production Supervisor - WC60 446466105 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
276 60 632-555-0129 Cell jo0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
276 9693 Mellowood Street NaN Duvall Washington 98019
CountryName
276 United States
[1 rows x 26 columns])
(277, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
277 186 26.0 NaN NaN Shane S Kim
Suffix JobTitle NationalIDNumber ... \
277 NaN Production Supervisor - WC45 551834634 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
277 57 810-555-0178 Cell shane0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
277 9745 Bonita Ct. NaN Bellevue Washington 98004
CountryName
277 United States
[1 rows x 26 columns])
(278, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
278 38 26.0 NaN NaN Kim B
LastName Suffix JobTitle NationalIDNumber \
278 Abercrombie NaN Production Technician - WC60 6298838
... SickLeaveHours PhoneNumber PhoneNumberType \
278 ... 32 208-555-0114 Cell
EmailAddress AddressLine1 AddressLine2 City \
278 kim1@yahoo.com 9752 Jeanne Circle NaN Carnation
StateProvinceName PostalCode CountryName
278 Washington 98014 United States
[1 rows x 26 columns])
(279, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
279 154 26.0 NaN NaN Raymond K Sam
Suffix JobTitle NationalIDNumber ... \
279 NaN Production Technician - WC20 97728960 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
279 25 226-555-0197 Work raymond0@safe-mail.net
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
279 9784 Mt Etna Drive NaN Edmonds Washington 98020
CountryName
279 United States
[1 rows x 26 columns])
(280, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
280 114 26.0 NaN NaN Mindaugas J
LastName Suffix JobTitle NationalIDNumber \
280 Krapauskas NaN Production Technician - WC50 342607223
... SickLeaveHours PhoneNumber PhoneNumberType \
280 ... 68 637-555-0120 Work
EmailAddress AddressLine1 AddressLine2 City \
280 mindaugas0@hotmail.com 9825 Coralie Drive NaN Edmonds
StateProvinceName PostalCode CountryName
280 Washington 98020 United States
[1 rows x 26 columns])
(281, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
281 123 250.0 NaN NaN Vamsi N Kuppa
Suffix JobTitle NationalIDNumber ... \
281 NaN Shipping and Receiving Clerk 337752649 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
281 67 937-555-0137 Work vamsi0@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
281 9833 Mt. Dias Blv. NaN Bothell Washington 98011
CountryName
281 United States
[1 rows x 26 columns])
(282, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
282 29 26.0 NaN NaN Mark K McArthur
Suffix JobTitle NationalIDNumber ... \
282 NaN Production Technician - WC60 948320468 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
282 29 417-555-0154 Work mark1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
282 9863 Ridge Place NaN Redmond Washington 98052
CountryName
282 United States
[1 rows x 26 columns])
(283, EmployeeID ManagerID TerritoryID Title FirstName MiddleName \
283 101 26.0 NaN NaN Houman N
LastName Suffix JobTitle NationalIDNumber \
283 Pournasseh NaN Production Technician - WC50 153288994
... SickLeaveHours PhoneNumber PhoneNumberType \
283 ... 21 180-555-0136 Cell
EmailAddress AddressLine1 AddressLine2 City StateProvinceName \
283 houman0@aol.com 9882 Clay Rde NaN Redmond Washington
PostalCode CountryName
283 98052 United States
[1 rows x 26 columns])
(284, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
284 221 25.0 NaN NaN Chris K Norred
Suffix JobTitle NationalIDNumber ... \
284 NaN Control Specialist 260805477 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
284 57 575-555-0126 Cell chris1@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
284 989 Crown Ct NaN Issaquah Washington 98027
CountryName
284 United States
[1 rows x 26 columns])
(285, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
285 18 16.0 NaN NaN John L Wood
Suffix JobTitle NationalIDNumber ... \
285 NaN Marketing Specialist 222969461 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
285 44 486-555-0150 Work john5@aol.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
285 9906 Oak Grove Road NaN Redmond Washington 98052
CountryName
285 United States
[1 rows x 26 columns])
(286, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
286 46 26.0 NaN NaN Eugene O Kogan
Suffix JobTitle NationalIDNumber ... \
286 NaN Production Technician - WC60 66073987 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
286 38 173-555-0179 Cell eugene1@hotmail.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
286 991 Vista Verde NaN Duvall Washington 98019
CountryName
286 United States
[1 rows x 26 columns])
(287, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
287 202 26.0 NaN NaN Tawana G Nusbaum
Suffix JobTitle NationalIDNumber ... \
287 NaN Production Technician - WC40 436757988 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
287 45 368-555-0113 Work tawana0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName \
287 9964 North Ridge Drive NaN Seattle Washington
PostalCode CountryName
287 98104 United States
[1 rows x 26 columns])
(288, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
288 289 287.0 10.0 NaN Jae B Pak
Suffix JobTitle NationalIDNumber ... \
288 NaN Sales Representative 668991357 ...
SickLeaveHours PhoneNumber PhoneNumberType EmailAddress \
288 38 1 (11) 500 555-0145 Work jae0@aol.co.uk
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
288 Downshire Way NaN Cambridge England BA5 3HX
CountryName
288 United Kingdom
[1 rows x 26 columns])
(289, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
289 288 287.0 8.0 NaN Rachel B Valdez
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
289 NaN Sales Representative 954276278 ... 37
PhoneNumber PhoneNumberType EmailAddress \
289 1 (11) 500 555-0140 Cell rachel0@adventure-works.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
289 Pascalstr 951 NaN Berlin Hamburg 14111
CountryName
289 Germany
[1 rows x 26 columns])
(290, EmployeeID ManagerID TerritoryID Title FirstName MiddleName LastName \
290 999 1.0 NaN NaN Chadwick NaN Smith
Suffix JobTitle NationalIDNumber ... SickLeaveHours \
290 NaN BI Professor 123456789 ... 47
PhoneNumber PhoneNumberType EmailAddress \
290 555-887-9788 Work chadwick.smith@rentpath.com
AddressLine1 AddressLine2 City StateProvinceName PostalCode \
290 565 Peachtree Rd. NaN Atlanta Georgia 30084
CountryName
290 United States
[1 rows x 26 columns])
In [26]:
Employees = pd.read_excel('/home/data/AdventureWorks/Employees.xls')
Territory = pd.read_excel('/home/data/AdventureWorks/SalesTerritory.xls')
Customers = pd.read_excel('/home/data/AdventureWorks/Customers.xls')
Orders = pd.read_excel('/home/data/AdventureWorks/ItemsOrdered.xls')
Let's take a look at the data we'll be working with:
In [27]:
Employees.head()
Out[27]:
EmployeeID
ManagerID
TerritoryID
Title
FirstName
MiddleName
LastName
Suffix
JobTitle
NationalIDNumber
...
SickLeaveHours
PhoneNumber
PhoneNumberType
EmailAddress
AddressLine1
AddressLine2
City
StateProvinceName
PostalCode
CountryName
0
259
250.0
NaN
NaN
Ben
T
Miller
NaN
Buyer
20269531
...
47
151-555-0113
Work
ben0@adventure-works.com
101 Candy Rd.
NaN
Redmond
Washington
98052
United States
1
278
274.0
6.0
NaN
Garrett
R
Vargas
NaN
Sales Representative
234474252
...
36
922-555-0165
Work
garrett1@mapleleafmail.ca
10203 Acorn Avenue
NaN
Calgary
Alberta
T2P 2G8
Canada
2
204
26.0
NaN
NaN
Gabe
B
Mares
NaN
Production Technician - WC40
440379437
...
48
310-555-0117
Work
gabe0@adventure-works.com
1061 Buskrik Avenue
NaN
Edmonds
Washington
98020
United States
3
78
26.0
NaN
NaN
Reuben
H
D'sa
NaN
Production Supervisor - WC40
370989364
...
56
191-555-0112
Work
reuben0@adventure-works.com
1064 Slow Creek Road
NaN
Seattle
Washington
98104
United States
4
255
250.0
NaN
NaN
Gordon
L
Hee
NaN
Buyer
466142721
...
46
230-555-0144
Cell
gordon0@adventure-works.com
108 Lakeside Court
NaN
Bellevue
Washington
98004
United States
5 rows × 26 columns
In [28]:
Territory.head()
Out[28]:
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
0
1
Northwest
US
North America
7887186.79
3298694.49
1
2
Northeast
US
North America
2402176.85
3607148.94
2
3
Central
US
North America
3072175.12
3205014.08
3
4
Southwest
US
North America
10510853.87
5366575.71
4
5
Southeast
US
North America
2538667.25
3925071.43
In [29]:
Customers.head()
Out[29]:
CustomerID
SalesTerritoryID
FirstName
LastName
City
StateName
0
10101
1
John
Gray
Lynden
Washington
1
10298
4
Leroy
Brown
Pinetop
Arizona
2
10299
1
Elroy
Keller
Snoqualmie
Washington
3
10315
3
Lisa
Jones
Oshkosh
Wisconsin
4
10325
1
Ginger
Schultz
Pocatello
Idaho
In [30]:
Orders.head()
Out[30]:
CustomerID
OrderDate
Item
Quantity
Price
0
10330
2004-06-30
Pogo stick
1
28.0
1
10101
2004-06-30
Raft
1
58.0
2
10298
2004-07-01
Skateboard
1
33.0
3
10101
2004-07-01
Life Vest
4
125.0
4
10299
2004-07-06
Parachute
1
1250.0
Let's construct a slightly artificial example. Suppose that AdventureWorks was formed by merging two companies, AdventuresUSA which operated in the US and AdventuresWorld, which operated in other countries. Now we want information on their combined sales territories.
The Pandas "concat" function is good for stacking tables on top of each other. We will use it to combine the AdventuresUSA and AdventuresWorld territories data tables.
In [31]:
help(pd.concat)
Help on function concat in module pandas.tools.merge:
concat(objs, axis=0, join='outer', join_axes=None, ignore_index=False, keys=None, levels=None, names=None, verify_integrity=False, copy=True)
Concatenate pandas objects along a particular axis with optional set logic
along the other axes. Can also add a layer of hierarchical indexing on the
concatenation axis, which may be useful if the labels are the same (or
overlapping) on the passed axis number
Parameters
----------
objs : a sequence or mapping of Series, DataFrame, or Panel objects
If a dict is passed, the sorted keys will be used as the `keys`
argument, unless it is passed, in which case the values will be
selected (see below). Any None objects will be dropped silently unless
they are all None in which case a ValueError will be raised
axis : {0, 1, ...}, default 0
The axis to concatenate along
join : {'inner', 'outer'}, default 'outer'
How to handle indexes on other axis(es)
join_axes : list of Index objects
Specific indexes to use for the other n - 1 axes instead of performing
inner/outer set logic
verify_integrity : boolean, default False
Check whether the new concatenated axis contains duplicates. This can
be very expensive relative to the actual data concatenation
keys : sequence, default None
If multiple levels passed, should contain tuples. Construct
hierarchical index using the passed keys as the outermost level
levels : list of sequences, default None
Specific levels (unique values) to use for constructing a
MultiIndex. Otherwise they will be inferred from the keys
names : list, default None
Names for the levels in the resulting hierarchical index
ignore_index : boolean, default False
If True, do not use the index values along the concatenation axis. The
resulting axis will be labeled 0, ..., n - 1. This is useful if you are
concatenating objects where the concatenation axis does not have
meaningful indexing information. Note the index values on the other
axes are still respected in the join.
copy : boolean, default True
If False, do not copy data unnecessarily
Notes
-----
The keys, levels, and names arguments are all optional
Returns
-------
concatenated : type of objects
In [32]:
# constructing the territory tables... as noted, this is an artificial example
TerritoryUSA = Territory[Territory.CountryCode=='US']; TerritoryUSA['RepID'] = np.random.randint(1,1000,5)
TerritoryWorld = Territory[Territory.CountryCode!='US']
/usr/lib/python3.4/site-packages/ipykernel/__main__.py:2: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead
See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
from ipykernel import kernelapp as app
In [33]:
TerritoryUSA
Out[33]:
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
RepID
0
1
Northwest
US
North America
7887186.79
3298694.49
484
1
2
Northeast
US
North America
2402176.85
3607148.94
323
2
3
Central
US
North America
3072175.12
3205014.08
486
3
4
Southwest
US
North America
10510853.87
5366575.71
617
4
5
Southeast
US
North America
2538667.25
3925071.43
572
In [34]:
TerritoryWorld
Out[34]:
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
5
6
Canada
CA
North America
6771829.14
5693988.860
6
7
France
FR
Europe
4772398.31
2396539.760
7
8
Germany
DE
Europe
3805202.35
1307949.790
8
9
Australia
AU
Pacific
5977814.92
2278548.980
9
10
United Kingdom
GB
Europe
5012905.37
1635823.400
10
11
Brazil
BR
South America
0.00
261589.958
11
12
Mexico
MX
North America
0.00
0.000
In [35]:
# we'll concatenate the databases, but keep separate keys so that we can keep track of which entries came from AdventuresUSA and
# which from AdventuresWorld.
# We'll use "join='inner'" to only keep colunms that are common to both tables;
# that is, we will drop the no-longer needed RepID in AdventuresUSA.
Territory2 = pd.concat([TerritoryUSA, TerritoryWorld], keys=['usa', 'world'], join='inner')
In [36]:
Territory2
Out[36]:
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
usa
0
1
Northwest
US
North America
7887186.79
3298694.490
1
2
Northeast
US
North America
2402176.85
3607148.940
2
3
Central
US
North America
3072175.12
3205014.080
3
4
Southwest
US
North America
10510853.87
5366575.710
4
5
Southeast
US
North America
2538667.25
3925071.430
world
5
6
Canada
CA
North America
6771829.14
5693988.860
6
7
France
FR
Europe
4772398.31
2396539.760
7
8
Germany
DE
Europe
3805202.35
1307949.790
8
9
Australia
AU
Pacific
5977814.92
2278548.980
9
10
United Kingdom
GB
Europe
5012905.37
1635823.400
10
11
Brazil
BR
South America
0.00
261589.958
11
12
Mexico
MX
North America
0.00
0.000
Pandas "append" behaves just like "concat" with axis=0 and join='outer' (i.e., keep all column names). Missing values are set to NaN.
In [37]:
help(pd.DataFrame.append)
Help on function append in module pandas.core.frame:
append(self, other, ignore_index=False, verify_integrity=False)
Append rows of `other` to the end of this frame, returning a new
object. Columns not in this frame are added as new columns.
Parameters
----------
other : DataFrame or Series/dict-like object, or list of these
The data to append.
ignore_index : boolean, default False
If True, do not use the index labels.
verify_integrity : boolean, default False
If True, raise ValueError on creating index with duplicates.
Returns
-------
appended : DataFrame
Notes
-----
If a list of dict/series is passed and the keys are all contained in
the DataFrame's index, the order of the columns in the resulting
DataFrame will be unchanged.
See also
--------
pandas.concat : General function to concatenate DataFrame, Series
or Panel objects
Examples
--------
>>> df = pd.DataFrame([[1, 2], [3, 4]], columns=list('AB'))
>>> df
A B
0 1 2
1 3 4
>>> df2 = pd.DataFrame([[5, 6], [7, 8]], columns=list('AB'))
>>> df.append(df2)
A B
0 1 2
1 3 4
0 5 6
1 7 8
With `ignore_index` set to True:
>>> df.append(df2, ignore_index=True)
A B
0 1 2
1 3 4
2 5 6
3 7 8
In [38]:
Territory3 = TerritoryUSA.append(TerritoryWorld)
In [39]:
Territory3
Out[39]:
CountryCode
Name
Region
RepID
SalesLastYear
SalesYTD
TerritoryID
0
US
Northwest
North America
484.0
3298694.490
7887186.79
1
1
US
Northeast
North America
323.0
3607148.940
2402176.85
2
2
US
Central
North America
486.0
3205014.080
3072175.12
3
3
US
Southwest
North America
617.0
5366575.710
10510853.87
4
4
US
Southeast
North America
572.0
3925071.430
2538667.25
5
5
CA
Canada
North America
NaN
5693988.860
6771829.14
6
6
FR
France
Europe
NaN
2396539.760
4772398.31
7
7
DE
Germany
Europe
NaN
1307949.790
3805202.35
8
8
AU
Australia
Pacific
NaN
2278548.980
5977814.92
9
9
GB
United Kingdom
Europe
NaN
1635823.400
5012905.37
10
10
BR
Brazil
South America
NaN
261589.958
0.00
11
11
MX
Mexico
North America
NaN
0.000
0.00
12
Join and merge are powerful tools for working with multiple tables. We will use them to answer some questions about the AdventureWorks dataset that you might encounter in real-life situations.
Join does fast table joining on a shared index. Merge does the same thing, but gives you the option to specify columns to join on. The idea of joining on a column will become clearer with some examples.
From AdventureWorks, we have a table "Employees" that gives a lot of information about AdventureWorks employees, like 'EmployeeID', 'ManagerID', 'TerritoryID', 'Title', 'FirstName','MiddleName', 'LastName', 'Suffix', 'JobTitle', 'NationalIDNumber', 'BirthDate', 'MaritalStatus', 'Gender', 'HireDate', 'SalariedFlag', 'VacationHours', 'SickLeaveHours', 'PhoneNumber', 'PhoneNumberType', 'EmailAddress', 'AddressLine1', 'AddressLine2', 'City', 'StateProvinceName', 'PostalCode', 'CountryName'. \
Since we're just being asked for a list of employees, we'll give the EmployeeID and their first, middle, and last names, and their role in the company (since additional information is requested for salespeople only). Then, for the salespeople, we must attach information about their sales territories, which is contained in the Territories table.
Notice that the Employees table has a column 'TerritoryID', which corresponds to the primary key in the 'Territory' table (in 'Territory', each territory has a unique 'TerritoryID'). We'll do a join on TerritoryID.
In [40]:
help(pd.merge)
Help on function merge in module pandas.tools.merge:
merge(left, right, how='inner', on=None, left_on=None, right_on=None, left_index=False, right_index=False, sort=False, suffixes=('_x', '_y'), copy=True, indicator=False)
Merge DataFrame objects by performing a database-style join operation by
columns or indexes.
If joining columns on columns, the DataFrame indexes *will be
ignored*. Otherwise if joining indexes on indexes or indexes on a column or
columns, the index will be passed on.
Parameters
----------
left : DataFrame
right : DataFrame
how : {'left', 'right', 'outer', 'inner'}, default 'inner'
* left: use only keys from left frame (SQL: left outer join)
* right: use only keys from right frame (SQL: right outer join)
* outer: use union of keys from both frames (SQL: full outer join)
* inner: use intersection of keys from both frames (SQL: inner join)
on : label or list
Field names to join on. Must be found in both DataFrames. If on is
None and not merging on indexes, then it merges on the intersection of
the columns by default.
left_on : label or list, or array-like
Field names to join on in left DataFrame. Can be a vector or list of
vectors of the length of the DataFrame to use a particular vector as
the join key instead of columns
right_on : label or list, or array-like
Field names to join on in right DataFrame or vector/list of vectors per
left_on docs
left_index : boolean, default False
Use the index from the left DataFrame as the join key(s). If it is a
MultiIndex, the number of keys in the other DataFrame (either the index
or a number of columns) must match the number of levels
right_index : boolean, default False
Use the index from the right DataFrame as the join key. Same caveats as
left_index
sort : boolean, default False
Sort the join keys lexicographically in the result DataFrame
suffixes : 2-length sequence (tuple, list, ...)
Suffix to apply to overlapping column names in the left and right
side, respectively
copy : boolean, default True
If False, do not copy data unnecessarily
indicator : boolean or string, default False
If True, adds a column to output DataFrame called "_merge" with
information on the source of each row.
If string, column with information on source of each row will be added to
output DataFrame, and column will be named value of string.
Information column is Categorical-type and takes on a value of "left_only"
for observations whose merge key only appears in 'left' DataFrame,
"right_only" for observations whose merge key only appears in 'right'
DataFrame, and "both" if the observation's merge key is found in both.
.. versionadded:: 0.17.0
Examples
--------
>>> A >>> B
lkey value rkey value
0 foo 1 0 foo 5
1 bar 2 1 bar 6
2 baz 3 2 qux 7
3 foo 4 3 bar 8
>>> A.merge(B, left_on='lkey', right_on='rkey', how='outer')
lkey value_x rkey value_y
0 foo 1 foo 5
1 foo 4 foo 5
2 bar 2 bar 6
3 bar 2 bar 8
4 baz 3 NaN NaN
5 NaN NaN qux 7
Returns
-------
merged : DataFrame
The output type will the be same as 'left', if it is a subclass
of DataFrame.
In [66]:
Ans = pd.merge(Employees.loc[:,["EmployeeID","FirstName","MiddleName","LastName","JobTitle","TerritoryID"]],
Territory,
how='left', on='TerritoryID')
Ans.head()
Out[66]:
EmployeeID
FirstName
MiddleName
LastName
JobTitle
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
0
259
Ben
T
Miller
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
1
278
Garrett
R
Vargas
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
2
204
Gabe
B
Mares
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
3
78
Reuben
H
D'sa
Production Supervisor - WC40
NaN
NaN
NaN
NaN
NaN
NaN
4
255
Gordon
L
Hee
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
In [69]:
X = Ans[["FirstName","MiddleName","LastName"]]
In [72]:
Ans['EmployeeName'] = X.apply(lambda x: x.LastName+", "+x.FirstName+" "+str(x.MiddleName), axis=1)
In [73]:
Ans
Out[73]:
EmployeeID
FirstName
MiddleName
LastName
JobTitle
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
EmployeeName
0
259
Ben
T
Miller
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
Miller, Ben T
1
278
Garrett
R
Vargas
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
Vargas, Garrett R
2
204
Gabe
B
Mares
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
Mares, Gabe B
3
78
Reuben
H
D'sa
Production Supervisor - WC40
NaN
NaN
NaN
NaN
NaN
NaN
D'sa, Reuben H
4
255
Gordon
L
Hee
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
Hee, Gordon L
5
66
Karan
R
Khanna
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
Khanna, Karan R
6
270
François
P
Ajenstat
Database Administrator
NaN
NaN
NaN
NaN
NaN
NaN
Ajenstat, François P
7
22
Sariya
E
Harnpadoungsataya
Marketing Specialist
NaN
NaN
NaN
NaN
NaN
NaN
Harnpadoungsataya, Sariya E
8
161
Kirk
J
Koenigsbauer
Production Technician - WC45
NaN
NaN
NaN
NaN
NaN
NaN
Koenigsbauer, Kirk J
9
124
Kim
T
Ralls
Stocker
NaN
NaN
NaN
NaN
NaN
NaN
Ralls, Kim T
10
10
Michael
NaN
Raheem
Research and Development Manager
NaN
NaN
NaN
NaN
NaN
NaN
Raheem, Michael nan
11
248
Mike
K
Seamans
Accountant
NaN
NaN
NaN
NaN
NaN
NaN
Seamans, Mike K
12
175
Reed
T
Koch
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
Koch, Reed T
13
155
Fadi
K
Fakhouri
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
Fakhouri, Fadi K
14
144
Paul
R
Singh
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
Singh, Paul R
15
192
Brenda
M
Diaz
Production Supervisor - WC40
NaN
NaN
NaN
NaN
NaN
NaN
Diaz, Brenda M
16
166
Jack
S
Richins
Production Supervisor - WC30
NaN
NaN
NaN
NaN
NaN
NaN
Richins, Jack S
17
112
John
P
Evans
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
Evans, John P
18
203
Ken
L
Myer
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
Myer, Ken L
19
245
Barbara
C
Moreland
Accountant
NaN
NaN
NaN
NaN
NaN
NaN
Moreland, Barbara C
20
257
Eric
S
Kurjan
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
Kurjan, Eric S
21
244
Bryan
A
Walton
Accounts Receivable Specialist
NaN
NaN
NaN
NaN
NaN
NaN
Walton, Bryan A
22
69
Steve
F
Masters
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
Masters, Steve F
23
210
Belinda
M
Newman
Production Technician - WC45
NaN
NaN
NaN
NaN
NaN
NaN
Newman, Belinda M
24
163
Alex
M
Nayberg
Production Technician - WC45
NaN
NaN
NaN
NaN
NaN
NaN
Nayberg, Alex M
25
118
Don
L
Hall
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
Hall, Don L
26
176
David
Oliver
Lawrence
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
Lawrence, David Oliver
27
147
Sandra
NaN
Reátegui Alayo
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
Reátegui Alayo, Sandra nan
28
138
Samantha
H
Smith
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
Smith, Samantha H
29
95
Jim
H
Scardelis
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
Scardelis, Jim H
...
...
...
...
...
...
...
...
...
...
...
...
...
261
70
David
J
Ortiz
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
Ortiz, David J
262
219
Sean
N
Chai
Document Control Assistant
NaN
NaN
NaN
NaN
NaN
NaN
Chai, Sean N
263
148
Jason
M
Watters
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
Watters, Jason M
264
140
Prasanna
E
Samarawickrama
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
Samarawickrama, Prasanna E
265
290
Ranjit
R
Varkey Chudukatil
Sales Representative
7.0
France
FR
Europe
4772398.31
2396539.76
Varkey Chudukatil, Ranjit R
266
5
Gail
A
Erickson
Design Engineer
NaN
NaN
NaN
NaN
NaN
NaN
Erickson, Gail A
267
252
Arvind
B
Rao
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
Rao, Arvind B
268
266
Peter
I
Connelly
Network Administrator
NaN
NaN
NaN
NaN
NaN
NaN
Connelly, Peter I
269
233
Magnus
E
Hedlund
Facilities Administrative Assistant
NaN
NaN
NaN
NaN
NaN
NaN
Hedlund, Magnus E
270
83
Patrick
M
Cook
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
Cook, Patrick M
271
251
Mikael
Q
Sandberg
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
Sandberg, Mikael Q
272
241
David
J
Liu
Accounts Manager
NaN
NaN
NaN
NaN
NaN
NaN
Liu, David J
273
25
James
R
Hamilton
Vice President of Production
NaN
NaN
NaN
NaN
NaN
NaN
Hamilton, James R
274
108
Jinghao
K
Liu
Production Supervisor - WC50
NaN
NaN
NaN
NaN
NaN
NaN
Liu, Jinghao K
275
239
Mindy
C
Martin
Benefits Specialist
NaN
NaN
NaN
NaN
NaN
NaN
Martin, Mindy C
276
27
Jo
A
Brown
Production Supervisor - WC60
NaN
NaN
NaN
NaN
NaN
NaN
Brown, Jo A
277
186
Shane
S
Kim
Production Supervisor - WC45
NaN
NaN
NaN
NaN
NaN
NaN
Kim, Shane S
278
38
Kim
B
Abercrombie
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
Abercrombie, Kim B
279
154
Raymond
K
Sam
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
Sam, Raymond K
280
114
Mindaugas
J
Krapauskas
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
Krapauskas, Mindaugas J
281
123
Vamsi
N
Kuppa
Shipping and Receiving Clerk
NaN
NaN
NaN
NaN
NaN
NaN
Kuppa, Vamsi N
282
29
Mark
K
McArthur
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
McArthur, Mark K
283
101
Houman
N
Pournasseh
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
Pournasseh, Houman N
284
221
Chris
K
Norred
Control Specialist
NaN
NaN
NaN
NaN
NaN
NaN
Norred, Chris K
285
18
John
L
Wood
Marketing Specialist
NaN
NaN
NaN
NaN
NaN
NaN
Wood, John L
286
46
Eugene
O
Kogan
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
Kogan, Eugene O
287
202
Tawana
G
Nusbaum
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
Nusbaum, Tawana G
288
289
Jae
B
Pak
Sales Representative
10.0
United Kingdom
GB
Europe
5012905.37
1635823.40
Pak, Jae B
289
288
Rachel
B
Valdez
Sales Representative
8.0
Germany
DE
Europe
3805202.35
1307949.79
Valdez, Rachel B
290
999
Chadwick
NaN
Smith
BI Professor
NaN
NaN
NaN
NaN
NaN
NaN
Smith, Chadwick nan
291 rows × 12 columns
In [42]:
# Overachiever answer:
Ans['EmployeeName'] = Ans[["FirstName","MiddleName","LastName"]].apply(lambda x: x.LastName+", "+x.FirstName+" "+str(x.MiddleName), axis=1)
Ans = Ans[['EmployeeName', 'EmployeeID', 'JobTitle', 'TerritoryID', 'Name', 'CountryCode', 'Region', 'SalesYTD', 'SalesLastYear']]
Ans
Out[42]:
EmployeeName
EmployeeID
JobTitle
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
0
Miller, Ben T
259
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
1
Vargas, Garrett R
278
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
2
Mares, Gabe B
204
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
3
D'sa, Reuben H
78
Production Supervisor - WC40
NaN
NaN
NaN
NaN
NaN
NaN
4
Hee, Gordon L
255
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
5
Khanna, Karan R
66
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
6
Ajenstat, François P
270
Database Administrator
NaN
NaN
NaN
NaN
NaN
NaN
7
Harnpadoungsataya, Sariya E
22
Marketing Specialist
NaN
NaN
NaN
NaN
NaN
NaN
8
Koenigsbauer, Kirk J
161
Production Technician - WC45
NaN
NaN
NaN
NaN
NaN
NaN
9
Ralls, Kim T
124
Stocker
NaN
NaN
NaN
NaN
NaN
NaN
10
Raheem, Michael nan
10
Research and Development Manager
NaN
NaN
NaN
NaN
NaN
NaN
11
Seamans, Mike K
248
Accountant
NaN
NaN
NaN
NaN
NaN
NaN
12
Koch, Reed T
175
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
13
Fakhouri, Fadi K
155
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
14
Singh, Paul R
144
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
15
Diaz, Brenda M
192
Production Supervisor - WC40
NaN
NaN
NaN
NaN
NaN
NaN
16
Richins, Jack S
166
Production Supervisor - WC30
NaN
NaN
NaN
NaN
NaN
NaN
17
Evans, John P
112
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
18
Myer, Ken L
203
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
19
Moreland, Barbara C
245
Accountant
NaN
NaN
NaN
NaN
NaN
NaN
20
Kurjan, Eric S
257
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
21
Walton, Bryan A
244
Accounts Receivable Specialist
NaN
NaN
NaN
NaN
NaN
NaN
22
Masters, Steve F
69
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
23
Newman, Belinda M
210
Production Technician - WC45
NaN
NaN
NaN
NaN
NaN
NaN
24
Nayberg, Alex M
163
Production Technician - WC45
NaN
NaN
NaN
NaN
NaN
NaN
25
Hall, Don L
118
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
26
Lawrence, David Oliver
176
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
27
Reátegui Alayo, Sandra nan
147
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
28
Smith, Samantha H
138
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
29
Scardelis, Jim H
95
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
...
...
...
...
...
...
...
...
...
...
261
Ortiz, David J
70
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
262
Chai, Sean N
219
Document Control Assistant
NaN
NaN
NaN
NaN
NaN
NaN
263
Watters, Jason M
148
Production Technician - WC30
NaN
NaN
NaN
NaN
NaN
NaN
264
Samarawickrama, Prasanna E
140
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
265
Varkey Chudukatil, Ranjit R
290
Sales Representative
7.0
France
FR
Europe
4772398.31
2396539.76
266
Erickson, Gail A
5
Design Engineer
NaN
NaN
NaN
NaN
NaN
NaN
267
Rao, Arvind B
252
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
268
Connelly, Peter I
266
Network Administrator
NaN
NaN
NaN
NaN
NaN
NaN
269
Hedlund, Magnus E
233
Facilities Administrative Assistant
NaN
NaN
NaN
NaN
NaN
NaN
270
Cook, Patrick M
83
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
271
Sandberg, Mikael Q
251
Buyer
NaN
NaN
NaN
NaN
NaN
NaN
272
Liu, David J
241
Accounts Manager
NaN
NaN
NaN
NaN
NaN
NaN
273
Hamilton, James R
25
Vice President of Production
NaN
NaN
NaN
NaN
NaN
NaN
274
Liu, Jinghao K
108
Production Supervisor - WC50
NaN
NaN
NaN
NaN
NaN
NaN
275
Martin, Mindy C
239
Benefits Specialist
NaN
NaN
NaN
NaN
NaN
NaN
276
Brown, Jo A
27
Production Supervisor - WC60
NaN
NaN
NaN
NaN
NaN
NaN
277
Kim, Shane S
186
Production Supervisor - WC45
NaN
NaN
NaN
NaN
NaN
NaN
278
Abercrombie, Kim B
38
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
279
Sam, Raymond K
154
Production Technician - WC20
NaN
NaN
NaN
NaN
NaN
NaN
280
Krapauskas, Mindaugas J
114
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
281
Kuppa, Vamsi N
123
Shipping and Receiving Clerk
NaN
NaN
NaN
NaN
NaN
NaN
282
McArthur, Mark K
29
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
283
Pournasseh, Houman N
101
Production Technician - WC50
NaN
NaN
NaN
NaN
NaN
NaN
284
Norred, Chris K
221
Control Specialist
NaN
NaN
NaN
NaN
NaN
NaN
285
Wood, John L
18
Marketing Specialist
NaN
NaN
NaN
NaN
NaN
NaN
286
Kogan, Eugene O
46
Production Technician - WC60
NaN
NaN
NaN
NaN
NaN
NaN
287
Nusbaum, Tawana G
202
Production Technician - WC40
NaN
NaN
NaN
NaN
NaN
NaN
288
Pak, Jae B
289
Sales Representative
10.0
United Kingdom
GB
Europe
5012905.37
1635823.40
289
Valdez, Rachel B
288
Sales Representative
8.0
Germany
DE
Europe
3805202.35
1307949.79
290
Smith, Chadwick nan
999
BI Professor
NaN
NaN
NaN
NaN
NaN
NaN
291 rows × 9 columns
In [43]:
Ans2 = Ans[Ans.JobTitle=='Sales Representative']
Ans2
Out[43]:
EmployeeName
EmployeeID
JobTitle
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
1
Vargas, Garrett R
278
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
54
Campbell, David R
283
Sales Representative
1.0
Northwest
US
North America
7887186.79
3298694.49
63
Mitchell, Linda C
276
Sales Representative
4.0
Southwest
US
North America
10510853.87
5366575.71
93
Tsoflias, Lynn N
286
Sales Representative
9.0
Australia
AU
Pacific
5977814.92
2278548.98
114
Mensa-Annan, Tete A
284
Sales Representative
1.0
Northwest
US
North America
7887186.79
3298694.49
163
Ito, Shu K
281
Sales Representative
4.0
Southwest
US
North America
10510853.87
5366575.71
176
Ansman-Wolfe, Pamela O
280
Sales Representative
1.0
Northwest
US
North America
7887186.79
3298694.49
230
Carson, Jillian nan
277
Sales Representative
3.0
Central
US
North America
3072175.12
3205014.08
235
Blythe, Michael G
275
Sales Representative
2.0
Northeast
US
North America
2402176.85
3607148.94
240
Reiter, Tsvi Michael
279
Sales Representative
5.0
Southeast
US
North America
2538667.25
3925071.43
256
Saraiva, José Edvaldo
282
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
265
Varkey Chudukatil, Ranjit R
290
Sales Representative
7.0
France
FR
Europe
4772398.31
2396539.76
288
Pak, Jae B
289
Sales Representative
10.0
United Kingdom
GB
Europe
5012905.37
1635823.40
289
Valdez, Rachel B
288
Sales Representative
8.0
Germany
DE
Europe
3805202.35
1307949.79
In [44]:
# Overachiever: What about *all* employees associated with sales?
Ans2 = Ans[Ans["JobTitle"].apply(lambda x: 'Sales' in x)]
Ans2
Out[44]:
EmployeeName
EmployeeID
JobTitle
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
1
Vargas, Garrett R
278
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
54
Campbell, David R
283
Sales Representative
1.0
Northwest
US
North America
7887186.79
3298694.49
59
Jiang, Stephen Y
274
North American Sales Manager
NaN
NaN
NaN
NaN
NaN
NaN
63
Mitchell, Linda C
276
Sales Representative
4.0
Southwest
US
North America
10510853.87
5366575.71
93
Tsoflias, Lynn N
286
Sales Representative
9.0
Australia
AU
Pacific
5977814.92
2278548.98
114
Mensa-Annan, Tete A
284
Sales Representative
1.0
Northwest
US
North America
7887186.79
3298694.49
135
Alberts, Amy E
287
European Sales Manager
NaN
NaN
NaN
NaN
NaN
NaN
163
Ito, Shu K
281
Sales Representative
4.0
Southwest
US
North America
10510853.87
5366575.71
176
Ansman-Wolfe, Pamela O
280
Sales Representative
1.0
Northwest
US
North America
7887186.79
3298694.49
212
Abbas, Syed E
285
Pacific Sales Manager
NaN
NaN
NaN
NaN
NaN
NaN
222
Welcker, Brian S
273
Vice President of Sales
NaN
NaN
NaN
NaN
NaN
NaN
230
Carson, Jillian nan
277
Sales Representative
3.0
Central
US
North America
3072175.12
3205014.08
235
Blythe, Michael G
275
Sales Representative
2.0
Northeast
US
North America
2402176.85
3607148.94
240
Reiter, Tsvi Michael
279
Sales Representative
5.0
Southeast
US
North America
2538667.25
3925071.43
256
Saraiva, José Edvaldo
282
Sales Representative
6.0
Canada
CA
North America
6771829.14
5693988.86
265
Varkey Chudukatil, Ranjit R
290
Sales Representative
7.0
France
FR
Europe
4772398.31
2396539.76
288
Pak, Jae B
289
Sales Representative
10.0
United Kingdom
GB
Europe
5012905.37
1635823.40
289
Valdez, Rachel B
288
Sales Representative
8.0
Germany
DE
Europe
3805202.35
1307949.79
This looks like another question for "merge"! We have a list of customers with their addresses, and we have a list of territories, but they are in separate tables.
Let's recover a list of customer names and IDs, together with corresponding sales territory names.
This time, we have to be careful, because "TerritoryID" in the Territory table matches "SalesTerritoryID" in the table Customers. So, we'll have to specify different columns names to merge on for the two tables.
In [45]:
Ans3 = pd.merge(Customers[["CustomerID","FirstName","LastName","SalesTerritoryID"]],
Territory[["TerritoryID","Name"]],
how='left',
left_on='SalesTerritoryID', right_on='TerritoryID', )
Ans3
Out[45]:
CustomerID
FirstName
LastName
SalesTerritoryID
TerritoryID
Name
0
10101
John
Gray
1
1
Northwest
1
10298
Leroy
Brown
4
4
Southwest
2
10299
Elroy
Keller
1
1
Northwest
3
10315
Lisa
Jones
3
3
Central
4
10325
Ginger
Schultz
1
1
Northwest
5
10329
Kelly
Mendoza
5
5
Southeast
6
10330
Shawn
Dalton
1
1
Northwest
7
10338
Michael
Howell
1
1
Northwest
8
10339
Anthony
Sanchez
4
4
Southwest
9
10408
Elroy
Cleaver
4
4
Southwest
10
10410
Mary Ann
Howell
5
5
Southeast
11
10413
Donald
Davids
4
4
Southwest
12
10419
Linda
Sakahara
4
4
Southwest
13
10429
Sarah
Graham
5
5
Southeast
14
10438
Kevin
Smith
3
3
Central
15
10439
Conrad
Giles
3
3
Central
16
10449
Isabela
Moore
4
4
Southwest
In [46]:
Ans = pd.merge(Territory, Customers, how="inner", left_on="TerritoryID", right_on="SalesTerritoryID")
In [47]:
Ans
Out[47]:
TerritoryID
Name
CountryCode
Region
SalesYTD
SalesLastYear
CustomerID
SalesTerritoryID
FirstName
LastName
City
StateName
0
1
Northwest
US
North America
7887186.79
3298694.49
10101
1
John
Gray
Lynden
Washington
1
1
Northwest
US
North America
7887186.79
3298694.49
10299
1
Elroy
Keller
Snoqualmie
Washington
2
1
Northwest
US
North America
7887186.79
3298694.49
10325
1
Ginger
Schultz
Pocatello
Idaho
3
1
Northwest
US
North America
7887186.79
3298694.49
10330
1
Shawn
Dalton
Cannon Beach
Oregon
4
1
Northwest
US
North America
7887186.79
3298694.49
10338
1
Michael
Howell
Tillamook
Oregon
5
3
Central
US
North America
3072175.12
3205014.08
10315
3
Lisa
Jones
Oshkosh
Wisconsin
6
3
Central
US
North America
3072175.12
3205014.08
10438
3
Kevin
Smith
Durango
Colorado
7
3
Central
US
North America
3072175.12
3205014.08
10439
3
Conrad
Giles
Telluride
Colorado
8
4
Southwest
US
North America
10510853.87
5366575.71
10298
4
Leroy
Brown
Pinetop
Arizona
9
4
Southwest
US
North America
10510853.87
5366575.71
10339
4
Anthony
Sanchez
Winslow
Arizona
10
4
Southwest
US
North America
10510853.87
5366575.71
10408
4
Elroy
Cleaver
Globe
Arizona
11
4
Southwest
US
North America
10510853.87
5366575.71
10413
4
Donald
Davids
Gila Bend
Arizona
12
4
Southwest
US
North America
10510853.87
5366575.71
10419
4
Linda
Sakahara
Nogales
Arizona
13
4
Southwest
US
North America
10510853.87
5366575.71
10449
4
Isabela
Moore
Yuma
Arizona
14
5
Southeast
US
North America
2538667.25
3925071.43
10329
5
Kelly
Mendoza
Kailua
Hawaii
15
5
Southeast
US
North America
2538667.25
3925071.43
10410
5
Mary Ann
Howell
Charleston
South Carolina
16
5
Southeast
US
North America
2538667.25
3925071.43
10429
5
Sarah
Graham
Greensboro
North Carolina
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [109]:
# In-class exercise! :)
In [49]:
ListNC = Customers[Customers.StateName=='North Carolina']
ListNC
Out[49]:
CustomerID
SalesTerritoryID
FirstName
LastName
City
StateName
13
10429
5
Sarah
Graham
Greensboro
North Carolina
In [51]:
ListNC.CustomerID.count()
Out[51]:
1
In [53]:
Customers = Customers.set_index("StateName")
Customers.loc['North Carolina']
Out[53]:
CustomerID 10429
SalesTerritoryID 5
FirstName Sarah
LastName Graham
City Greensboro
Name: North Carolina, dtype: object
In [113]:
# We'll use the Orders table for this! In-class exercise :)
In [54]:
Orders["TotalItemPrice"] = Orders.Quantity * Orders.Price
Orders.head()
Out[54]:
CustomerID
OrderDate
Item
Quantity
Price
TotalItemPrice
0
10330
2004-06-30
Pogo stick
1
28.0
28.0
1
10101
2004-06-30
Raft
1
58.0
58.0
2
10298
2004-07-01
Skateboard
1
33.0
33.0
3
10101
2004-07-01
Life Vest
4
125.0
500.0
4
10299
2004-07-06
Parachute
1
1250.0
1250.0
In [55]:
Orders.groupby(["CustomerID","OrderDate"]).TotalItemPrice.sum()
Out[55]:
CustomerID OrderDate
10101 2004-06-30 00:00:00.000 58.00
2004-07-01 00:00:00.000 500.00
2004-08-18 00:00:00.000 18.30
2004-12-30 00:00:00.000 44.25
2005-01-02 00:00:00.000 16.00
2005-03-08 00:00:00.000 177.40
10298 2004-07-01 00:00:00.000 33.00
2004-09-19 00:00:00.000 58.00
2004-12-01 00:00:00.000 22.00
2005-03-18 00:00:00.000 22.38
2005-04-01 00:00:00.000 12.50
10299 2004-07-06 00:00:00.000 1250.00
2005-01-18 00:00:00.000 38.00
10315 2005-02-02 00:00:00.000 8.00
10330 2004-06-30 00:00:00.000 28.00
2005-01-01 00:00:00.000 112.00
2005-12-31 23:59:59.997 16.75
10339 2004-07-27 00:00:00.000 4.50
10410 2004-10-28 00:00:00.000 89.22
2005-01-30 00:00:00.000 192.50
10413 2005-01-19 00:00:00.000 128.00
10438 2004-11-01 00:00:00.000 6.75
2004-11-02 00:00:00.000 8.50
2005-01-18 00:00:00.000 79.99
10439 2004-08-14 00:00:00.000 51.00
2004-09-18 00:00:00.000 88.00
10449 2004-08-13 00:00:00.000 180.79
2004-09-01 00:00:00.000 45.00
2004-12-15 00:00:00.000 380.50
2004-12-22 00:00:00.000 280.00
2005-02-28 00:00:00.000 4.50
2005-03-19 00:00:00.000 80.00
Name: TotalItemPrice, dtype: float64
In [ ]:
In [114]:
# In-class exercise! :)
In [56]:
Ans_1 = pd.merge(Customers[["CustomerID","FirstName","LastName"]], Orders[["CustomerID","TotalItemPrice"]], how="inner", on="CustomerID" )
In [57]:
Ans_1
Out[57]:
CustomerID
FirstName
LastName
TotalItemPrice
0
10101
John
Gray
58.00
1
10101
John
Gray
500.00
2
10101
John
Gray
18.30
3
10101
John
Gray
44.25
4
10101
John
Gray
16.00
5
10101
John
Gray
177.40
6
10298
Leroy
Brown
33.00
7
10298
Leroy
Brown
58.00
8
10298
Leroy
Brown
22.00
9
10298
Leroy
Brown
22.38
10
10298
Leroy
Brown
12.50
11
10299
Elroy
Keller
1250.00
12
10299
Elroy
Keller
38.00
13
10315
Lisa
Jones
8.00
14
10330
Shawn
Dalton
28.00
15
10330
Shawn
Dalton
112.00
16
10330
Shawn
Dalton
16.75
17
10339
Anthony
Sanchez
4.50
18
10410
Mary Ann
Howell
89.22
19
10410
Mary Ann
Howell
192.50
20
10413
Donald
Davids
128.00
21
10438
Kevin
Smith
6.75
22
10438
Kevin
Smith
8.50
23
10438
Kevin
Smith
79.99
24
10439
Conrad
Giles
51.00
25
10439
Conrad
Giles
88.00
26
10449
Isabela
Moore
180.79
27
10449
Isabela
Moore
45.00
28
10449
Isabela
Moore
380.50
29
10449
Isabela
Moore
280.00
30
10449
Isabela
Moore
4.50
31
10449
Isabela
Moore
80.00
In [82]:
pd.DataFrame(Ans_1.groupby("CustomerID").TotalItemPrice.sum())
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
<ipython-input-82-b416a23c4273> in <module>()
----> 1 pd.DataFrame(Ans_1.groupby("CustomerID").TotalItemPrice.sum()).set_index(pd.Index(range(len(Ans_1))))
/usr/lib64/python3.4/site-packages/pandas/core/frame.py in set_index(self, keys, drop, append, inplace, verify_integrity)
2853 index._cleanup()
2854
-> 2855 frame.index = index
2856
2857 if not inplace:
/usr/lib64/python3.4/site-packages/pandas/core/generic.py in __setattr__(self, name, value)
2683 try:
2684 object.__getattribute__(self, name)
-> 2685 return object.__setattr__(self, name, value)
2686 except AttributeError:
2687 pass
pandas/src/properties.pyx in pandas.lib.AxisProperty.__set__ (pandas/lib.c:44748)()
/usr/lib64/python3.4/site-packages/pandas/core/generic.py in _set_axis(self, axis, labels)
426
427 def _set_axis(self, axis, labels):
--> 428 self._data.set_axis(axis, labels)
429 self._clear_item_cache()
430
/usr/lib64/python3.4/site-packages/pandas/core/internals.py in set_axis(self, axis, new_labels)
2633 raise ValueError('Length mismatch: Expected axis has %d elements, '
2634 'new values have %d elements' %
-> 2635 (old_len, new_len))
2636
2637 self.axes[axis] = new_labels
ValueError: Length mismatch: Expected axis has 11 elements, new values have 32 elements
In [91]:
Ans_1a = Ans_1[["FirstName","LastName","CustomerID"]].set_index("CustomerID")
Ans_1b = Ans_1a[Ans_1a.duplicated()==False]
In [92]:
Ans_2 = pd.DataFrame(Ans_1.groupby("CustomerID").TotalItemPrice.sum()).join(Ans_1b)
In [95]:
Ans_2.sort_values("TotalItemPrice", ascending=False)
Out[95]:
TotalItemPrice
FirstName
LastName
CustomerID
10299
1288.00
Elroy
Keller
10449
970.79
Isabela
Moore
10101
813.95
John
Gray
10410
281.72
Mary Ann
Howell
10330
156.75
Shawn
Dalton
10298
147.88
Leroy
Brown
10439
139.00
Conrad
Giles
10413
128.00
Donald
Davids
10438
95.24
Kevin
Smith
10315
8.00
Lisa
Jones
10339
4.50
Anthony
Sanchez
In [84]:
Ans_2.sort_values(ascending=False)
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-84-866a1e83de84> in <module>()
----> 1 Ans_2.sort_values(ascending=False)
TypeError: sort_values() missing 1 required positional argument: 'by'
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [ ]:
In [75]:
Territory.apply(max, axis=0)
Out[75]:
TerritoryID 12
Name United Kingdom
CountryCode US
Region South America
SalesYTD 1.05109e+07
SalesLastYear 5.69399e+06
dtype: object
In [10]:
help(pd.DataFrame.combine_first)
Help on function combine_first in module pandas.core.frame:
combine_first(self, other)
Combine two DataFrame objects and default to non-null values in frame
calling the method. Result index columns will be the union of the
respective indexes and columns
Parameters
----------
other : DataFrame
Examples
--------
a's values prioritized, use values from b to fill holes:
>>> a.combine_first(b)
Returns
-------
combined : DataFrame
In [11]:
help(pd.DataFrame.update)
Help on function update in module pandas.core.frame:
update(self, other, join='left', overwrite=True, filter_func=None, raise_conflict=False)
Modify DataFrame in place using non-NA values from passed
DataFrame. Aligns on indices
Parameters
----------
other : DataFrame, or object coercible into a DataFrame
join : {'left'}, default 'left'
overwrite : boolean, default True
If True then overwrite values for common keys in the calling frame
filter_func : callable(1d-array) -> 1d-array<boolean>, default None
Can choose to replace values other than NA. Return True for values
that should be updated
raise_conflict : boolean
If True, will raise an error if the DataFrame and other both
contain data in the same place.
In [118]:
Customers
Out[118]:
CustomerID
SalesTerritoryID
FirstName
LastName
City
StateName
0
10101
1
John
Gray
Lynden
Washington
1
10298
4
Leroy
Brown
Pinetop
Arizona
2
10299
1
Elroy
Keller
Snoqualmie
Washington
3
10315
3
Lisa
Jones
Oshkosh
Wisconsin
4
10325
1
Ginger
Schultz
Pocatello
Idaho
5
10329
5
Kelly
Mendoza
Kailua
Hawaii
6
10330
1
Shawn
Dalton
Cannon Beach
Oregon
7
10338
1
Michael
Howell
Tillamook
Oregon
8
10339
4
Anthony
Sanchez
Winslow
Arizona
9
10408
4
Elroy
Cleaver
Globe
Arizona
10
10410
5
Mary Ann
Howell
Charleston
South Carolina
11
10413
4
Donald
Davids
Gila Bend
Arizona
12
10419
4
Linda
Sakahara
Nogales
Arizona
13
10429
5
Sarah
Graham
Greensboro
North Carolina
14
10438
3
Kevin
Smith
Durango
Colorado
15
10439
3
Conrad
Giles
Telluride
Colorado
16
10449
4
Isabela
Moore
Yuma
Arizona
Content source: squishbug/DataScienceProgramming
Similar notebooks: