Baselight

HR Dataset

This is a dataset about almost 1500 employees of a company.

@kaggle.imtiajemon_hr_dataset

Loading...
Loading...

About this Dataset

HR Dataset

Summary & Description for the data

Summary:

This is a dataset about almost 1500 employees. They works in different departments with different job roles. There are 60% male employee and 40% female employee. Most of them are married. However, around 16% of them have left their job.

Column Descriptions:

  • EmpID: Employee ID of each employee.
  • Age: Age of each employee.
  • AgeGroup: Age group.
  • Attrition: Whether the employee left his/her job or not.
  • BusinessTravel: Describe the employee's business travel frequency.
  • Department: Which department the employee currently working.
  • DistanceFromHome: Distance of office from home.
  • EducationField: Employee's education field.
  • EnvironmentSatisfaction: Satisfaction level on employee's work environment.
  • Gender: Gender of employees.
  • JobLevel: Employee's job level in their office.
  • JobRole: Role of employee's.
  • JobSatisfaction: Job satisfaction level of employees.
  • MaritalStatus: Marital status of employees.
  • MonthlyIncome: Employee's income per month.
  • Over18: Indicate the specific employee is 18+ or not.
  • OverTime: Whether the employee do overtime or not.
  • PercentSalaryHike: Salary hike in percentage.
  • PerformanceRating: Rating on employee's performance.
  • TotalWorkingYears: Total working year of employees.
  • YearsAtCompany: Working year at current company.
  • YearsInCurrentRole: Working year at current role.
  • YearsSinceLastPromotion: Number of year since the last promotion.
  • YearsWithCurrManager: Number of year with current manager.

Tables

Hr Data

@kaggle.imtiajemon_hr_dataset.hr_data
  • 44.36 KB
  • 1473 rows
  • 24 columns
Loading...

CREATE TABLE hr_data (
  "empid" VARCHAR,
  "age" BIGINT,
  "agegroup" VARCHAR,
  "attrition" VARCHAR,
  "businesstravel" VARCHAR,
  "department" VARCHAR,
  "distancefromhome" BIGINT,
  "educationfield" VARCHAR,
  "environmentsatisfaction" VARCHAR,
  "gender" VARCHAR,
  "joblevel" BIGINT,
  "jobrole" VARCHAR,
  "jobsatisfaction" VARCHAR,
  "maritalstatus" VARCHAR,
  "monthlyincome" BIGINT,
  "over18" VARCHAR,
  "overtime" VARCHAR,
  "percentsalaryhike" BIGINT,
  "performancerating" VARCHAR,
  "totalworkingyears" BIGINT,
  "yearsatcompany" BIGINT,
  "yearsincurrentrole" BIGINT,
  "yearssincelastpromotion" BIGINT,
  "yearswithcurrmanager" DOUBLE
);

Share link

Anyone who has the link will be able to view this.