HR Employee Attrition

HR Employee Dataset Analysis

@kaggle.bishop36_hr_employee_attrition

Table List

1 table(71.09 KB)

Hr Employee Attrition

@kaggle.bishop36_hr_employee_attrition.hr_employee_attrition

71.09 KB
1470 rows
35 columns

age Age	attrition Attrition	businesstravel BusinessTravel	dailyrate DailyRate	department Department	distancefromhome DistanceFromHome	education Education	educationfield EducationField	employeecount EmployeeCount	employeenumber EmployeeNumber	environmentsatisfaction EnvironmentSatisfaction	gender Gender	hourlyrate HourlyRate	jobinvolvement JobInvolvement	joblevel JobLevel	jobrole JobRole	jobsatisfaction JobSatisfaction	maritalstatus MaritalStatus	monthlyincome MonthlyIncome	monthlyrate MonthlyRate	numcompaniesworked NumCompaniesWorked	over18 Over18	overtime OverTime	percentsalaryhike PercentSalaryHike	performancerating PerformanceRating	relationshipsatisfaction RelationshipSatisfaction	standardhours StandardHours	stockoptionlevel StockOptionLevel	totalworkingyears TotalWorkingYears	trainingtimeslastyear TrainingTimesLastYear	worklifebalance WorkLifeBalance	yearsatcompany YearsAtCompany	yearsincurrentrole YearsInCurrentRole	yearssincelastpromotion YearsSinceLastPromotion	yearswithcurrmanager YearsWithCurrManager
41	Yes	Travel_Rarely	1102	Sales	1	2	Life Sciences	1	1	2	Female	94	3	2	Sales Executive	4	Single	5993	19479	8	Y	Yes	11	3	1	80		8		1	6	4		5
49	No	Travel_Frequently	279	Research & Development	8	1	Life Sciences	1	2	3	Male	61	2	2	Research Scientist	2	Married	5130	24907	1	Y	No	23	4	4	80	1	10	3	3	10	7	1	7
37	Yes	Travel_Rarely	1373	Research & Development	2	2	Other	1	4	4	Male	92	2	1	Laboratory Technician	3	Single	2090	2396	6	Y	Yes	15	3	2	80		7	3	3
33	No	Travel_Frequently	1392	Research & Development	3	4	Life Sciences	1	5	4	Female	56	3	1	Research Scientist	3	Married	2909	23159	1	Y	Yes	11	3	3	80		8	3	3	8	7	3
27	No	Travel_Rarely	591	Research & Development	2	1	Medical	1	7	1	Male	40	3	1	Laboratory Technician	2	Married	3468	16632	9	Y	No	12	3	4	80	1	6	3	3	2	2	2	2
32	No	Travel_Frequently	1005	Research & Development	2	2	Life Sciences	1	8	4	Male	79	3	1	Laboratory Technician	4	Single	3068	11864		Y	No	13	3	3	80		8	2	2	7	7	3	6
59	No	Travel_Rarely	1324	Research & Development	3	3	Medical	1	10	3	Female	81	4	1	Laboratory Technician	1	Married	2670	9964	4	Y	Yes	20	4	1	80	3	12	3	2	1
30	No	Travel_Rarely	1358	Research & Development	24	1	Life Sciences	1	11	4	Male	67	3	1	Laboratory Technician	3	Divorced	2693	13335	1	Y	No	22	4	2	80	1	1	2	3	1
38	No	Travel_Frequently	216	Research & Development	23	3	Life Sciences	1	12	4	Male	44	2	3	Manufacturing Director	3	Single	9526	8787		Y	No	21	4	2	80		10	2	3	9	7	1	8
36	No	Travel_Rarely	1299	Research & Development	27	3	Medical	1	13	3	Male	94	3	2	Healthcare Representative	3	Married	5237	16577	6	Y	No	13	3	2	80	2	17	3	2	7	7	7	7


CREATE TABLE hr_employee_attrition (
  "age" BIGINT,
  "attrition" VARCHAR,
  "businesstravel" VARCHAR,
  "dailyrate" BIGINT,
  "department" VARCHAR,
  "distancefromhome" BIGINT,
  "education" BIGINT,
  "educationfield" VARCHAR,
  "employeecount" BIGINT,
  "employeenumber" BIGINT,
  "environmentsatisfaction" BIGINT,
  "gender" VARCHAR,
  "hourlyrate" BIGINT,
  "jobinvolvement" BIGINT,
  "joblevel" BIGINT,
  "jobrole" VARCHAR,
  "jobsatisfaction" BIGINT,
  "maritalstatus" VARCHAR,
  "monthlyincome" BIGINT,
  "monthlyrate" BIGINT,
  "numcompaniesworked" BIGINT,
  "over18" VARCHAR,
  "overtime" VARCHAR,
  "percentsalaryhike" BIGINT,
  "performancerating" BIGINT,
  "relationshipsatisfaction" BIGINT,
  "standardhours" BIGINT,
  "stockoptionlevel" BIGINT,
  "totalworkingyears" BIGINT,
  "trainingtimeslastyear" BIGINT,
  "worklifebalance" BIGINT,
  "yearsatcompany" BIGINT,
  "yearsincurrentrole" BIGINT,
  "yearssincelastpromotion" BIGINT,
  "yearswithcurrmanager" BIGINT
);