HR Analytics: Employee Promotion Data

Predict the eligible candidates for promotion

@kaggle.arashnic_hr_ana

Table List

2 tables(896.22 KB)

Test

@kaggle.arashnic_hr_ana.test

268.95 KB
23490 rows
12 columns

employee_id Employee Id	department Department	region Region	education Education	gender Gender	recruitment_channel Recruitment Channel	no_of_trainings No Of Trainings	age Age	previous_year_rating Previous Year Rating	length_of_service Length Of Service	avg_training_score Avg Training Score
8724	Technology	region_26	Bachelor's	m	sourcing	1	24		1	77
74430	HR	region_4	Bachelor's	f	other	1	31	3	5	51
72255	Sales & Marketing	region_13	Bachelor's	m	other	1	31	1	4	47
38562	Procurement	region_2	Bachelor's	f	other	3	31	2	9	65
64486	Finance	region_29	Bachelor's	m	sourcing	1	30	4	7	61
46232	Procurement	region_7	Bachelor's	m	sourcing	1	36	3	2	68
54542	Finance	region_2	Bachelor's	m	other	1	33	5	3	57
67269	Analytics	region_22	Bachelor's	m	sourcing	2	36	3	3	85
66174	Technology	region_7	Master's & above	m	other	1	51	4	11	75
76303	Technology	region_22	Bachelor's	m	sourcing	1	29	5	2	76


CREATE TABLE test (
  "employee_id" BIGINT,
  "department" VARCHAR,
  "region" VARCHAR,
  "education" VARCHAR,
  "gender" VARCHAR,
  "recruitment_channel" VARCHAR,
  "no_of_trainings" BIGINT,
  "age" BIGINT,
  "previous_year_rating" DOUBLE,
  "length_of_service" BIGINT,
  "awards_won" BIGINT,
  "avg_training_score" BIGINT
);