HR Analytics
Employee attrition prediction
@kaggle.rishikeshkonapure_hr_analytics_prediction
Employee attrition prediction
@kaggle.rishikeshkonapure_hr_analytics_prediction
HR Analytics helps us with interpreting organizational data. It finds the people-related trends in the data and allows the HR Department to take the appropriate steps to keep the organization running smoothly and profitably. Attrition in a corporate setup is one of the complex challenges that the people managers and the HRs personnel have to deal with.
Interestingly, machine learning models can be deployed to predict potential attrition cases, helping the appropriate HR Personnel take the necessary steps to retain the employee.
**Tasks to perform: **
Data Cleaning:
Deleting redundant columns.
Renaming the columns.
Dropping duplicates.
Cleaning individual columns.
Remove the NaN values from the dataset
Check for some more Transformations
Data Visualization:
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
);Anyone who has the link will be able to view this.