Scribd
Upload
31 views4 pages

Lecture 1

The document contains employee data including ID, name, department, age, joining date, salary, and performance score for 50 employees. It also summarizes the total salary, average salary, median salary, maximum salary, and minimum salary. Additionally, the document lists the employment status of each employee.

Uploaded by

comedysession7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
31 views4 pages

Lecture 1

The document contains employee data including ID, name, department, age, joining date, salary, and performance score for 50 employees. It also summarizes the total salary, average salary, median salary, maximum salary, and minimum salary. Additionally, the document lists the employment status of each employee.

Uploaded by

comedysession7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Employee_ID Full Name Full_name_cleaned Department Age Joining_Date Salary Performance_Score

1 alice JOHNSON Alice Johnson HR 39 2017-03-07 00:00:00 86933 3


2 Bob Williams Bob Williams finance 50 2015-06-17 00:00:00 95323 1
3 CHARLIE brown Charlie Brown IT 27 2016-08-13 00:00:00 55275 4
4 David Smith David Smith SALES 30 2020-06-01 00:00:00 36012 4
5 EMMA WATSON Emma Watson Marketing 57 2018-11-08 00:00:00 137345 2
6 Frank Lewis Frank Lewis OPERATIONS 47 2015-03-22 00:00:00 73126 2
7 Grace Hall Grace Hall HR 59 2019-06-22 00:00:00 65185 3
8 Hannah white Hannah White finance 31 2016-01-10 00:00:00 65348 1
9 John Doe John Doe IT 45 2017-03-01 00:00:00 82273 2
10 sArAh khan Sarah Khan SALES 20 2017-05-08 00:00:00 35799 4
11 alice JOHNSON Alice Johnson Marketing 31 2015-06-09 00:00:00 37788 1
12 Bob Williams Bob Williams OPERATIONS 53 2017-09-07 00:00:00 50863 3
13 CHARLIE brown Charlie Brown HR 37 2018-06-05 00:00:00 145493 4
14 David Smith David Smith finance 45 2016-01-25 00:00:00 124726 1
15 EMMA WATSON Emma Watson IT 40 2015-10-10 00:00:00 66928 4
16 Frank Lewis Frank Lewis SALES 50 2015-08-18 00:00:00 135580 3
17 Grace Hall Grace Hall Marketing 27 2016-02-01 00:00:00 76061 2
18 Hannah white Hannah White OPERATIONS 30 2018-12-29 00:00:00 33881 3
19 John Doe John Doe HR 48 2016-10-31 00:00:00 107532 2
20 sArAh khan Sarah Khan finance 26 2016-02-23 00:00:00 61956 2
21 alice JOHNSON Alice Johnson IT 36 2016-06-29 00:00:00 32263 1
22 Bob Williams Bob Williams SALES 53 2017-09-26 00:00:00 120708 4
23 CHARLIE brown Charlie Brown Marketing 37 2018-03-24 00:00:00 78277 2
24 David Smith David Smith OPERATIONS 37 2017-03-02 00:00:00 96555 1
25 EMMA WATSON Emma Watson HR 40 2015-02-24 00:00:00 56098 3
26 Frank Lewis Frank Lewis finance 58 2019-12-13 00:00:00 144556 2
27 Grace Hall Grace Hall IT 44 2020-03-02 00:00:00 64691 4
28 Hannah white Hannah White SALES 44 2018-01-07 00:00:00 35302 2
29 John Doe John Doe Marketing 39 2015-02-27 00:00:00 119567 4
30 sArAh khan Sarah Khan OPERATIONS 37 2015-07-04 00:00:00 94509 4
31 alice JOHNSON Alice Johnson HR 44 2019-04-18 00:00:00 43254 1
32 Bob Williams Bob Williams finance 26 2018-10-29 00:00:00 48238 1
33 CHARLIE brown Charlie Brown IT 53 2017-06-26 00:00:00 41203 2
34 David Smith David Smith SALES 44 2019-10-17 00:00:00 91499 4
35 EMMA WATSON Emma Watson Marketing 45 2018-12-12 00:00:00 147484 2
36 Frank Lewis Frank Lewis OPERATIONS 54 2018-02-06 00:00:00 121045 2
37 Grace Hall Grace Hall HR 21 2018-08-08 00:00:00 100041 4
38 Hannah white Hannah White finance 54 2020-04-17 00:00:00 43314 4
39 John Doe John Doe IT 53 2015-04-04 00:00:00 120940 1
40 sArAh khan Sarah Khan SALES 52 2020-05-10 00:00:00 39017 4
41 alice JOHNSON Alice Johnson Marketing 55 2017-07-14 00:00:00 130643 1
42 Bob Williams Bob Williams OPERATIONS 33 2018-09-18 00:00:00 116850 1
43 CHARLIE brown Charlie Brown HR 50 2016-03-19 00:00:00 77512 2
44 David Smith David Smith finance 20 2019-01-31 00:00:00 56436 4
45 EMMA WATSON Emma Watson IT 56 2017-06-10 00:00:00 38063 1
46 Frank Lewis Frank Lewis SALES 36 2017-10-08 00:00:00 66203 3
47 Grace Hall Grace Hall Marketing 31 2018-01-30 00:00:00 47045 3
48 Hannah white Hannah White OPERATIONS 39 2017-11-29 00:00:00 55849 3
49 John Doe John Doe HR 37 2018-10-18 00:00:00 65866 4
50 sArAh khan Sarah Khan Finance 58 2020-06-22 00:00:00 65563 4
Email Status
user1 @company.com Active
user2@company..com resigned
user3 @company.com on leave
user4@company..com Resigned
user5 @company.com On_Leave
user6@company..com Active
user7 @company.com Active
user8@company..com resigned Total Salary 3932018
user9 @company.com on leave Total # of emps 50
user10@company..com Resigned Avg salary 78640.36
user11 @company.com On_Leave median salary 66565.5
user12@company..com Active max salary 147484
user13 @company.com Active min salary 32263
user14@company..com resigned
user15 @company.com on leave
user16@company..com Resigned
user17 @company.com On_Leave
user18@company..com Active
user19 @company.com Active
user20@company..com resigned
user21 @company.com on leave
user22@company..com Resigned
user23 @company.com On_Leave
user24@company..com Active
user25 @company.com Active
user26@company..com resigned
user27 @company.com on leave
user28@company..com Resigned
user29 @company.com On_Leave
user30@company..com Active
user31 @company.com Active
user32@company..com resigned
user33 @company.com on leave
user34@company..com Resigned
user35 @company.com On_Leave
user36@company..com Active
user37 @company.com Active
user38@company..com resigned
user39 @company.com on leave
user40@company..com Resigned
user41 @company.com On_Leave
user42@company..com Active
user43 @company.com Active
user44@company..com resigned
user45 @company.com on leave
user46@company..com Resigned
user47 @company.com On_Leave
user48@company..com Active
user49 @company.com Resigned
user50@company..com On Leave

You might also like