Predicting Employee Attrition

To Predict Whether the employees Leave the Company or Not

@kaggle.pavan9065_predicting_employee_attrition

Table List

3 tables(207.45 KB)

Sample Submission

Test Data

Train Data

Train Data

@kaggle.pavan9065_predicting_employee_attrition.train_data

195.71 KB
19104 rows
13 columns

mmm_yy MMM-YY	emp_id Emp ID	age Age	gender Gender	city City	education_level Education Level	salary Salary	dateofjoining Dateofjoining	lastworkingdate LastWorkingDate	joining_designation Joining Designation	designation Designation	total_business_value Total Business Value	quarterly_rating Quarterly Rating
Fri Jan 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	28	Male	C23	Master	57387	Thu Dec 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time)		1	1	2381060	2
Mon Feb 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	28	Male	C23	Master	57387	Thu Dec 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time)		1	1	-665480	2
Tue Mar 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	28	Male	C23	Master	57387	Thu Dec 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1		2
Wed Nov 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2	31	Male	C7	Master	67016	Mon Nov 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		2	2		1
Fri Dec 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2	31	Male	C7	Master	67016	Mon Nov 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)		2	2		1
Thu Dec 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	4	43	Male	C13	Master	65603	Wed Dec 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		2	2		1
Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4	43	Male	C13	Master	65603	Wed Dec 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		2	2		1
Wed Feb 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4	43	Male	C13	Master	65603	Wed Dec 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		2	2		1
Wed Mar 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4	43	Male	C13	Master	65603	Wed Dec 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)		2	2	350000	1
Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	4	43	Male	C13	Master	65603	Wed Dec 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2	2		1


CREATE TABLE train_data (
  "mmm_yy" TIMESTAMP,
  "emp_id" BIGINT,
  "age" BIGINT,
  "gender" VARCHAR,
  "city" VARCHAR,
  "education_level" VARCHAR,
  "salary" BIGINT,
  "dateofjoining" TIMESTAMP,
  "lastworkingdate" TIMESTAMP,
  "joining_designation" BIGINT,
  "designation" BIGINT,
  "total_business_value" BIGINT,
  "quarterly_rating" BIGINT
);