{ "cells": [ { "cell_type": "markdown", "metadata": { "id": "lxWg-88vlXNr" }, "source": [ "##
| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "65438 | \n", "Sales & Marketing | \n", "region_7 | \n", "Master's & above | \n", "f | \n", "sourcing | \n", "1 | \n", "35 | \n", "5.0 | \n", "8 | \n", "0 | \n", "49 | \n", "0 | \n", "
| 1 | \n", "65141 | \n", "Operations | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "30 | \n", "5.0 | \n", "4 | \n", "0 | \n", "60 | \n", "0 | \n", "
| 2 | \n", "7513 | \n", "Sales & Marketing | \n", "region_19 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "34 | \n", "3.0 | \n", "7 | \n", "0 | \n", "50 | \n", "0 | \n", "
| 3 | \n", "2542 | \n", "Sales & Marketing | \n", "region_23 | \n", "Bachelor's | \n", "m | \n", "other | \n", "2 | \n", "39 | \n", "1.0 | \n", "10 | \n", "0 | \n", "50 | \n", "0 | \n", "
| 4 | \n", "48945 | \n", "Technology | \n", "region_26 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "45 | \n", "3.0 | \n", "2 | \n", "0 | \n", "73 | \n", "0 | \n", "
| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "8724 | \n", "Technology | \n", "region_26 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "24 | \n", "NaN | \n", "1 | \n", "0 | \n", "77 | \n", "
| 1 | \n", "74430 | \n", "HR | \n", "region_4 | \n", "Bachelor's | \n", "f | \n", "other | \n", "1 | \n", "31 | \n", "3.0 | \n", "5 | \n", "0 | \n", "51 | \n", "
| 2 | \n", "72255 | \n", "Sales & Marketing | \n", "region_13 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "31 | \n", "1.0 | \n", "4 | \n", "0 | \n", "47 | \n", "
| 3 | \n", "38562 | \n", "Procurement | \n", "region_2 | \n", "Bachelor's | \n", "f | \n", "other | \n", "3 | \n", "31 | \n", "2.0 | \n", "9 | \n", "0 | \n", "65 | \n", "
| 4 | \n", "64486 | \n", "Finance | \n", "region_29 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "30 | \n", "4.0 | \n", "7 | \n", "0 | \n", "61 | \n", "
| \n", " | employee_id | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|
| count | \n", "54808.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "50684.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "
| mean | \n", "39195.830627 | \n", "1.253011 | \n", "34.803915 | \n", "3.329256 | \n", "5.865512 | \n", "0.023172 | \n", "63.386750 | \n", "0.085170 | \n", "
| std | \n", "22586.581449 | \n", "0.609264 | \n", "7.660169 | \n", "1.259993 | \n", "4.265094 | \n", "0.150450 | \n", "13.371559 | \n", "0.279137 | \n", "
| min | \n", "1.000000 | \n", "1.000000 | \n", "20.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "39.000000 | \n", "0.000000 | \n", "
| 25% | \n", "19669.750000 | \n", "1.000000 | \n", "29.000000 | \n", "3.000000 | \n", "3.000000 | \n", "0.000000 | \n", "51.000000 | \n", "0.000000 | \n", "
| 50% | \n", "39225.500000 | \n", "1.000000 | \n", "33.000000 | \n", "3.000000 | \n", "5.000000 | \n", "0.000000 | \n", "60.000000 | \n", "0.000000 | \n", "
| 75% | \n", "58730.500000 | \n", "1.000000 | \n", "39.000000 | \n", "4.000000 | \n", "7.000000 | \n", "0.000000 | \n", "76.000000 | \n", "0.000000 | \n", "
| max | \n", "78298.000000 | \n", "10.000000 | \n", "60.000000 | \n", "5.000000 | \n", "37.000000 | \n", "1.000000 | \n", "99.000000 | \n", "1.000000 | \n", "
| \n", " | employee_id | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "
|---|---|---|---|---|---|---|---|
| count | \n", "23490.000000 | \n", "23490.000000 | \n", "23490.000000 | \n", "21678.000000 | \n", "23490.000000 | \n", "23490.000000 | \n", "23490.000000 | \n", "
| mean | \n", "39041.399149 | \n", "1.254236 | \n", "34.782929 | \n", "3.339146 | \n", "5.810387 | \n", "0.022776 | \n", "63.263133 | \n", "
| std | \n", "22640.809201 | \n", "0.600910 | \n", "7.679492 | \n", "1.263294 | \n", "4.207917 | \n", "0.149191 | \n", "13.411750 | \n", "
| min | \n", "3.000000 | \n", "1.000000 | \n", "20.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "39.000000 | \n", "
| 25% | \n", "19370.250000 | \n", "1.000000 | \n", "29.000000 | \n", "3.000000 | \n", "3.000000 | \n", "0.000000 | \n", "51.000000 | \n", "
| 50% | \n", "38963.500000 | \n", "1.000000 | \n", "33.000000 | \n", "3.000000 | \n", "5.000000 | \n", "0.000000 | \n", "60.000000 | \n", "
| 75% | \n", "58690.000000 | \n", "1.000000 | \n", "39.000000 | \n", "4.000000 | \n", "7.000000 | \n", "0.000000 | \n", "76.000000 | \n", "
| max | \n", "78295.000000 | \n", "9.000000 | \n", "60.000000 | \n", "5.000000 | \n", "34.000000 | \n", "1.000000 | \n", "99.000000 | \n", "
| employee_id | no_of_trainings | age | previous_year_rating | length_of_service | awards_won? | avg_training_score | is_promoted | |
|---|---|---|---|---|---|---|---|---|
| count | \n", "54808.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "50684.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "54808.000000 | \n", "
| mean | \n", "39195.830627 | \n", "1.253011 | \n", "34.803915 | \n", "3.329256 | \n", "5.865512 | \n", "0.023172 | \n", "63.386750 | \n", "0.085170 | \n", "
| std | \n", "22586.581449 | \n", "0.609264 | \n", "7.660169 | \n", "1.259993 | \n", "4.265094 | \n", "0.150450 | \n", "13.371559 | \n", "0.279137 | \n", "
| min | \n", "1.000000 | \n", "1.000000 | \n", "20.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "39.000000 | \n", "0.000000 | \n", "
| 25% | \n", "19669.750000 | \n", "1.000000 | \n", "29.000000 | \n", "3.000000 | \n", "3.000000 | \n", "0.000000 | \n", "51.000000 | \n", "0.000000 | \n", "
| 50% | \n", "39225.500000 | \n", "1.000000 | \n", "33.000000 | \n", "3.000000 | \n", "5.000000 | \n", "0.000000 | \n", "60.000000 | \n", "0.000000 | \n", "
| 75% | \n", "58730.500000 | \n", "1.000000 | \n", "39.000000 | \n", "4.000000 | \n", "7.000000 | \n", "0.000000 | \n", "76.000000 | \n", "0.000000 | \n", "
| max | \n", "78298.000000 | \n", "10.000000 | \n", "60.000000 | \n", "5.000000 | \n", "37.000000 | \n", "1.000000 | \n", "99.000000 | \n", "1.000000 | \n", "
| \n", " | department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "
|---|---|---|---|---|---|
| count | \n", "54808 | \n", "54808 | \n", "52399 | \n", "54808 | \n", "54808 | \n", "
| unique | \n", "9 | \n", "34 | \n", "3 | \n", "2 | \n", "3 | \n", "
| top | \n", "Sales & Marketing | \n", "region_2 | \n", "Bachelor's | \n", "m | \n", "other | \n", "
| freq | \n", "16840 | \n", "12343 | \n", "36669 | \n", "38496 | \n", "30446 | \n", "
| \n", " | employee_id | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "65438 | \n", "1 | \n", "35 | \n", "5.0 | \n", "8 | \n", "0 | \n", "49 | \n", "0 | \n", "
| 1 | \n", "65141 | \n", "1 | \n", "30 | \n", "5.0 | \n", "4 | \n", "0 | \n", "60 | \n", "0 | \n", "
| 2 | \n", "7513 | \n", "1 | \n", "34 | \n", "3.0 | \n", "7 | \n", "0 | \n", "50 | \n", "0 | \n", "
| 3 | \n", "2542 | \n", "2 | \n", "39 | \n", "1.0 | \n", "10 | \n", "0 | \n", "50 | \n", "0 | \n", "
| 4 | \n", "48945 | \n", "1 | \n", "45 | \n", "3.0 | \n", "2 | \n", "0 | \n", "73 | \n", "0 | \n", "
| is_promoted | \n", "0 | \n", "1 | \n", "
|---|---|---|
| gender | \n", "\n", " | \n", " |
| f | \n", "14321 | \n", "1428 | \n", "
| m | \n", "34141 | \n", "3119 | \n", "
| is_promoted | \n", "0 | \n", "1 | \n", "
|---|---|---|
| gender | \n", "\n", " | \n", " |
| f | \n", "0.909328 | \n", "0.090672 | \n", "
| m | \n", "0.916291 | \n", "0.083709 | \n", "
| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | \n", "49017 | \n", "Sales & Marketing | \n", "region_7 | \n", "Bachelor's | \n", "f | \n", "sourcing | \n", "1 | \n", "35 | \n", "5.0 | \n", "3 | \n", "0 | \n", "50 | \n", "1 | \n", "
| 39 | \n", "58304 | \n", "Sales & Marketing | \n", "region_28 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "33 | \n", "5.0 | \n", "6 | \n", "0 | \n", "51 | \n", "1 | \n", "
| 71 | \n", "24040 | \n", "Technology | \n", "region_22 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "34 | \n", "5.0 | \n", "7 | \n", "0 | \n", "78 | \n", "1 | \n", "
| 75 | \n", "54782 | \n", "Sales & Marketing | \n", "region_2 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "1 | \n", "38 | \n", "4.0 | \n", "2 | \n", "0 | \n", "49 | \n", "1 | \n", "
| 85 | \n", "47498 | \n", "Operations | \n", "region_11 | \n", "Master's & above | \n", "f | \n", "sourcing | \n", "1 | \n", "42 | \n", "5.0 | \n", "11 | \n", "0 | \n", "60 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 54722 | \n", "47608 | \n", "Procurement | \n", "region_10 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "1 | \n", "34 | \n", "5.0 | \n", "2 | \n", "0 | \n", "72 | \n", "1 | \n", "
| 54734 | \n", "11685 | \n", "Operations | \n", "region_15 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "31 | \n", "3.0 | \n", "1 | \n", "0 | \n", "56 | \n", "1 | \n", "
| 54757 | \n", "14502 | \n", "Technology | \n", "region_7 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "54 | \n", "4.0 | \n", "7 | \n", "0 | \n", "81 | \n", "1 | \n", "
| 54792 | \n", "994 | \n", "Sales & Marketing | \n", "region_14 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "59 | \n", "3.0 | \n", "11 | \n", "0 | \n", "65 | \n", "1 | \n", "
| 54796 | \n", "12592 | \n", "Sales & Marketing | \n", "region_25 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "34 | \n", "3.0 | \n", "7 | \n", "0 | \n", "60 | \n", "1 | \n", "
2997 rows × 13 columns
\n", "| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66 | \n", "77981 | \n", "Finance | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "27 | \n", "3.0 | \n", "1 | \n", "1 | \n", "58 | \n", "1 | \n", "
| 67 | \n", "16502 | \n", "Sales & Marketing | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "27 | \n", "3.0 | \n", "1 | \n", "0 | \n", "61 | \n", "1 | \n", "
| 69 | \n", "45624 | \n", "Analytics | \n", "region_31 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "30 | \n", "3.0 | \n", "7 | \n", "0 | \n", "84 | \n", "1 | \n", "
| 79 | \n", "59147 | \n", "Sales & Marketing | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "30 | \n", "3.0 | \n", "3 | \n", "0 | \n", "58 | \n", "1 | \n", "
| 84 | \n", "44575 | \n", "Legal | \n", "region_7 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "29 | \n", "3.0 | \n", "1 | \n", "0 | \n", "65 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 54624 | \n", "57131 | \n", "Finance | \n", "region_2 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "24 | \n", "3.0 | \n", "1 | \n", "0 | \n", "71 | \n", "1 | \n", "
| 54713 | \n", "56396 | \n", "Procurement | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "30 | \n", "4.0 | \n", "4 | \n", "0 | \n", "67 | \n", "1 | \n", "
| 54720 | \n", "38719 | \n", "Analytics | \n", "region_4 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "29 | \n", "2.0 | \n", "3 | \n", "0 | \n", "88 | \n", "1 | \n", "
| 54730 | \n", "51059 | \n", "Sales & Marketing | \n", "region_2 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "29 | \n", "5.0 | \n", "4 | \n", "0 | \n", "58 | \n", "1 | \n", "
| 54761 | \n", "8278 | \n", "Procurement | \n", "region_13 | \n", "Bachelor's | \n", "f | \n", "sourcing | \n", "1 | \n", "30 | \n", "4.0 | \n", "2 | \n", "0 | \n", "86 | \n", "1 | \n", "
1550 rows × 13 columns
\n", "| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | \n", "49017 | \n", "Sales & Marketing | \n", "region_7 | \n", "Bachelor's | \n", "f | \n", "sourcing | \n", "1 | \n", "35 | \n", "5.0 | \n", "3 | \n", "0 | \n", "50 | \n", "1 | \n", "
| 39 | \n", "58304 | \n", "Sales & Marketing | \n", "region_28 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "33 | \n", "5.0 | \n", "6 | \n", "0 | \n", "51 | \n", "1 | \n", "
| 66 | \n", "77981 | \n", "Finance | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "27 | \n", "3.0 | \n", "1 | \n", "1 | \n", "58 | \n", "1 | \n", "
| 67 | \n", "16502 | \n", "Sales & Marketing | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "27 | \n", "3.0 | \n", "1 | \n", "0 | \n", "61 | \n", "1 | \n", "
| 69 | \n", "45624 | \n", "Analytics | \n", "region_31 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "30 | \n", "3.0 | \n", "7 | \n", "0 | \n", "84 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 54734 | \n", "11685 | \n", "Operations | \n", "region_15 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "31 | \n", "3.0 | \n", "1 | \n", "0 | \n", "56 | \n", "1 | \n", "
| 54757 | \n", "14502 | \n", "Technology | \n", "region_7 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "54 | \n", "4.0 | \n", "7 | \n", "0 | \n", "81 | \n", "1 | \n", "
| 54761 | \n", "8278 | \n", "Procurement | \n", "region_13 | \n", "Bachelor's | \n", "f | \n", "sourcing | \n", "1 | \n", "30 | \n", "4.0 | \n", "2 | \n", "0 | \n", "86 | \n", "1 | \n", "
| 54792 | \n", "994 | \n", "Sales & Marketing | \n", "region_14 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "59 | \n", "3.0 | \n", "11 | \n", "0 | \n", "65 | \n", "1 | \n", "
| 54796 | \n", "12592 | \n", "Sales & Marketing | \n", "region_25 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "34 | \n", "3.0 | \n", "7 | \n", "0 | \n", "60 | \n", "1 | \n", "
4547 rows × 13 columns
\n", "| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66 | \n", "77981 | \n", "Finance | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "27 | \n", "3.0 | \n", "1 | \n", "1 | \n", "58 | \n", "1 | \n", "
| 122 | \n", "38052 | \n", "Procurement | \n", "region_34 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "1 | \n", "37 | \n", "5.0 | \n", "3 | \n", "1 | \n", "92 | \n", "1 | \n", "
| 138 | \n", "51164 | \n", "Technology | \n", "region_14 | \n", "Bachelor's | \n", "f | \n", "other | \n", "1 | \n", "31 | \n", "4.0 | \n", "4 | \n", "1 | \n", "78 | \n", "0 | \n", "
| 140 | \n", "7606 | \n", "Technology | \n", "region_29 | \n", "Bachelor's | \n", "f | \n", "other | \n", "2 | \n", "30 | \n", "3.0 | \n", "7 | \n", "1 | \n", "76 | \n", "0 | \n", "
| 200 | \n", "53630 | \n", "Sales & Marketing | \n", "region_23 | \n", "Master's & above | \n", "f | \n", "sourcing | \n", "1 | \n", "34 | \n", "4.0 | \n", "5 | \n", "1 | \n", "94 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 54641 | \n", "2467 | \n", "Sales & Marketing | \n", "region_27 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "42 | \n", "2.0 | \n", "4 | \n", "1 | \n", "47 | \n", "0 | \n", "
| 54702 | \n", "4952 | \n", "Operations | \n", "region_28 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "28 | \n", "3.0 | \n", "2 | \n", "1 | \n", "62 | \n", "0 | \n", "
| 54772 | \n", "34501 | \n", "Operations | \n", "region_27 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "37 | \n", "5.0 | \n", "2 | \n", "1 | \n", "57 | \n", "0 | \n", "
| 54797 | \n", "62450 | \n", "Sales & Marketing | \n", "region_11 | \n", "Bachelor's | \n", "m | \n", "sourcing | \n", "1 | \n", "28 | \n", "5.0 | \n", "3 | \n", "1 | \n", "47 | \n", "0 | \n", "
| 54799 | \n", "68093 | \n", "Procurement | \n", "region_2 | \n", "Master's & above | \n", "f | \n", "other | \n", "1 | \n", "50 | \n", "5.0 | \n", "6 | \n", "1 | \n", "67 | \n", "0 | \n", "
1253 rows × 13 columns
\n", "| \n", " | employee_id | \n", "department | \n", "region | \n", "education | \n", "gender | \n", "recruitment_channel | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66 | \n", "77981 | \n", "Finance | \n", "region_22 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "27 | \n", "3.0 | \n", "1 | \n", "1 | \n", "58 | \n", "1 | \n", "
| 122 | \n", "38052 | \n", "Procurement | \n", "region_34 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "1 | \n", "37 | \n", "5.0 | \n", "3 | \n", "1 | \n", "92 | \n", "1 | \n", "
| 200 | \n", "53630 | \n", "Sales & Marketing | \n", "region_23 | \n", "Master's & above | \n", "f | \n", "sourcing | \n", "1 | \n", "34 | \n", "4.0 | \n", "5 | \n", "1 | \n", "94 | \n", "1 | \n", "
| 230 | \n", "62923 | \n", "Operations | \n", "region_13 | \n", "Master's & above | \n", "f | \n", "other | \n", "1 | \n", "38 | \n", "5.0 | \n", "2 | \n", "1 | \n", "93 | \n", "1 | \n", "
| 317 | \n", "22865 | \n", "Analytics | \n", "region_20 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "40 | \n", "5.0 | \n", "5 | \n", "1 | \n", "83 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 54017 | \n", "69878 | \n", "Analytics | \n", "region_26 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "1 | \n", "41 | \n", "5.0 | \n", "5 | \n", "1 | \n", "90 | \n", "1 | \n", "
| 54024 | \n", "3752 | \n", "HR | \n", "region_2 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "1 | \n", "60 | \n", "5.0 | \n", "8 | \n", "1 | \n", "50 | \n", "1 | \n", "
| 54146 | \n", "37302 | \n", "Operations | \n", "region_2 | \n", "Bachelor's | \n", "m | \n", "other | \n", "1 | \n", "37 | \n", "5.0 | \n", "7 | \n", "1 | \n", "79 | \n", "1 | \n", "
| 54503 | \n", "10882 | \n", "Sales & Marketing | \n", "region_25 | \n", "Master's & above | \n", "m | \n", "sourcing | \n", "2 | \n", "32 | \n", "4.0 | \n", "5 | \n", "1 | \n", "92 | \n", "1 | \n", "
| 54507 | \n", "43314 | \n", "Analytics | \n", "region_25 | \n", "Master's & above | \n", "m | \n", "other | \n", "1 | \n", "35 | \n", "5.0 | \n", "3 | \n", "1 | \n", "81 | \n", "1 | \n", "
552 rows × 13 columns
\n", "| \n", " | department | \n", "education | \n", "gender | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "sum_metric | \n", "total_score | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 573 | \n", "Sales & Marketing | \n", "Master's & above | \n", "f | \n", "1 | \n", "39 | \n", "1.0 | \n", "10 | \n", "0 | \n", "52 | \n", "1 | \n", "1.0 | \n", "52 | \n", "
| 3451 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "24 | \n", "1.0 | \n", "3 | \n", "0 | \n", "50 | \n", "1 | \n", "1.0 | \n", "50 | \n", "
| 4888 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "42 | \n", "1.0 | \n", "10 | \n", "0 | \n", "50 | \n", "1 | \n", "1.0 | \n", "50 | \n", "
| 11803 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "42 | \n", "1.0 | \n", "14 | \n", "0 | \n", "49 | \n", "1 | \n", "1.0 | \n", "49 | \n", "
| 12241 | \n", "Legal | \n", "Bachelor's | \n", "m | \n", "1 | \n", "31 | \n", "1.0 | \n", "6 | \n", "0 | \n", "56 | \n", "1 | \n", "1.0 | \n", "56 | \n", "
| 16807 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "35 | \n", "1.0 | \n", "10 | \n", "0 | \n", "57 | \n", "1 | \n", "1.0 | \n", "57 | \n", "
| 17281 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "30 | \n", "1.0 | \n", "4 | \n", "0 | \n", "49 | \n", "1 | \n", "1.0 | \n", "49 | \n", "
| 19582 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "2 | \n", "27 | \n", "1.0 | \n", "2 | \n", "0 | \n", "46 | \n", "1 | \n", "1.0 | \n", "92 | \n", "
| 21266 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "34 | \n", "1.0 | \n", "10 | \n", "0 | \n", "52 | \n", "1 | \n", "1.0 | \n", "52 | \n", "
| 23209 | \n", "Operations | \n", "Bachelor's | \n", "m | \n", "1 | \n", "37 | \n", "1.0 | \n", "5 | \n", "0 | \n", "58 | \n", "1 | \n", "1.0 | \n", "58 | \n", "
| 24564 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "2 | \n", "30 | \n", "1.0 | \n", "7 | \n", "0 | \n", "45 | \n", "1 | \n", "1.0 | \n", "90 | \n", "
| 27296 | \n", "Operations | \n", "Bachelor's | \n", "m | \n", "1 | \n", "43 | \n", "1.0 | \n", "13 | \n", "0 | \n", "59 | \n", "1 | \n", "1.0 | \n", "59 | \n", "
| 31860 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "27 | \n", "1.0 | \n", "2 | \n", "0 | \n", "58 | \n", "1 | \n", "1.0 | \n", "58 | \n", "
| 33769 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "37 | \n", "1.0 | \n", "7 | \n", "0 | \n", "50 | \n", "1 | \n", "1.0 | \n", "50 | \n", "
| 45455 | \n", "Sales & Marketing | \n", "Master's & above | \n", "m | \n", "1 | \n", "39 | \n", "1.0 | \n", "7 | \n", "0 | \n", "51 | \n", "1 | \n", "1.0 | \n", "51 | \n", "
| 47782 | \n", "Sales & Marketing | \n", "Master's & above | \n", "m | \n", "1 | \n", "34 | \n", "1.0 | \n", "7 | \n", "0 | \n", "48 | \n", "1 | \n", "1.0 | \n", "48 | \n", "
| 51374 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "1 | \n", "31 | \n", "1.0 | \n", "5 | \n", "0 | \n", "58 | \n", "1 | \n", "1.0 | \n", "58 | \n", "
| \n", " | department | \n", "education | \n", "gender | \n", "
|---|---|---|---|
| 0 | \n", "Sales & Marketing | \n", "Master's & above | \n", "f | \n", "
| 1 | \n", "Operations | \n", "Bachelor's | \n", "m | \n", "
| 2 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "
| 3 | \n", "Sales & Marketing | \n", "Bachelor's | \n", "m | \n", "
| 4 | \n", "Technology | \n", "Bachelor's | \n", "m | \n", "
| \n", " | department | \n", "education | \n", "gender | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "sum_metric | \n", "total_score | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "7 | \n", "3 | \n", "0 | \n", "1 | \n", "35 | \n", "5.0 | \n", "8 | \n", "0 | \n", "49 | \n", "0 | \n", "5.0 | \n", "49 | \n", "
| 1 | \n", "4 | \n", "2 | \n", "1 | \n", "1 | \n", "30 | \n", "5.0 | \n", "4 | \n", "0 | \n", "60 | \n", "0 | \n", "5.0 | \n", "60 | \n", "
| 2 | \n", "7 | \n", "2 | \n", "1 | \n", "1 | \n", "34 | \n", "3.0 | \n", "7 | \n", "0 | \n", "50 | \n", "0 | \n", "3.0 | \n", "50 | \n", "
LogisticRegression()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
LogisticRegression()
| \n", " | Actual Values | \n", "Predicted Values | \n", "
|---|---|---|
| 0 | \n", "1 | \n", "0 | \n", "
| 1 | \n", "1 | \n", "0 | \n", "
| 2 | \n", "1 | \n", "1 | \n", "
| 3 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "0 | \n", "0 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 19380 | \n", "1 | \n", "1 | \n", "
| 19381 | \n", "1 | \n", "1 | \n", "
| 19382 | \n", "0 | \n", "0 | \n", "
| 19383 | \n", "1 | \n", "1 | \n", "
| 19384 | \n", "1 | \n", "0 | \n", "
19385 rows × 2 columns
\n", "| \n", " | Actual Values | \n", "Predicted Values | \n", "
|---|---|---|
| 0 | \n", "1 | \n", "0 | \n", "
| 1 | \n", "1 | \n", "0 | \n", "
| 10 | \n", "0 | \n", "1 | \n", "
| 13 | \n", "1 | \n", "0 | \n", "
| 15 | \n", "0 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 19369 | \n", "0 | \n", "1 | \n", "
| 19370 | \n", "1 | \n", "0 | \n", "
| 19376 | \n", "1 | \n", "0 | \n", "
| 19377 | \n", "0 | \n", "1 | \n", "
| 19384 | \n", "1 | \n", "0 | \n", "
5972 rows × 2 columns
\n", "KNeighborsClassifier()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
KNeighborsClassifier()
| \n", " | Actual Values | \n", "Predicted Values | \n", "
|---|---|---|
| 0 | \n", "1 | \n", "1 | \n", "
| 1 | \n", "1 | \n", "1 | \n", "
| 2 | \n", "1 | \n", "1 | \n", "
| 3 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "0 | \n", "0 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 19380 | \n", "1 | \n", "1 | \n", "
| 19381 | \n", "1 | \n", "1 | \n", "
| 19382 | \n", "0 | \n", "1 | \n", "
| 19383 | \n", "1 | \n", "1 | \n", "
| 19384 | \n", "1 | \n", "1 | \n", "
19385 rows × 2 columns
\n", "| \n", " | Actual Values | \n", "Predicted Values | \n", "
|---|---|---|
| 6 | \n", "0 | \n", "1 | \n", "
| 10 | \n", "0 | \n", "1 | \n", "
| 13 | \n", "1 | \n", "0 | \n", "
| 30 | \n", "0 | \n", "1 | \n", "
| 55 | \n", "1 | \n", "0 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 19365 | \n", "0 | \n", "1 | \n", "
| 19369 | \n", "0 | \n", "1 | \n", "
| 19370 | \n", "1 | \n", "0 | \n", "
| 19371 | \n", "0 | \n", "1 | \n", "
| 19382 | \n", "0 | \n", "1 | \n", "
2775 rows × 2 columns
\n", "RandomForestClassifier(random_state=0)In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
RandomForestClassifier(random_state=0)
| \n", " | Actual Values | \n", "Predicted Values | \n", "
|---|---|---|
| 0 | \n", "1 | \n", "1 | \n", "
| 1 | \n", "1 | \n", "1 | \n", "
| 2 | \n", "1 | \n", "1 | \n", "
| 3 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "0 | \n", "0 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 19380 | \n", "1 | \n", "1 | \n", "
| 19381 | \n", "1 | \n", "1 | \n", "
| 19382 | \n", "0 | \n", "1 | \n", "
| 19383 | \n", "1 | \n", "1 | \n", "
| 19384 | \n", "1 | \n", "1 | \n", "
19385 rows × 2 columns
\n", "| \n", " | Actual Values | \n", "Predicted Values | \n", "
|---|---|---|
| 10 | \n", "0 | \n", "1 | \n", "
| 55 | \n", "1 | \n", "0 | \n", "
| 58 | \n", "0 | \n", "1 | \n", "
| 91 | \n", "1 | \n", "0 | \n", "
| 95 | \n", "1 | \n", "0 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 19345 | \n", "0 | \n", "1 | \n", "
| 19355 | \n", "1 | \n", "0 | \n", "
| 19357 | \n", "1 | \n", "0 | \n", "
| 19377 | \n", "0 | \n", "1 | \n", "
| 19382 | \n", "0 | \n", "1 | \n", "
1347 rows × 2 columns
\n", "| \n", " | feature | \n", "importance | \n", "
|---|---|---|
| 9 | \n", "sum_metric | \n", "0.200714 | \n", "
| 4 | \n", "age | \n", "0.161918 | \n", "
| 5 | \n", "previous_year_rating | \n", "0.154727 | \n", "
| 8 | \n", "avg_training_score | \n", "0.136921 | \n", "
| 6 | \n", "length_of_service | \n", "0.110861 | \n", "
| 10 | \n", "total_score | \n", "0.109354 | \n", "
| 0 | \n", "department | \n", "0.070437 | \n", "
| 2 | \n", "gender | \n", "0.024362 | \n", "
| 1 | \n", "education | \n", "0.016129 | \n", "
| 3 | \n", "no_of_trainings | \n", "0.010493 | \n", "
| 7 | \n", "awards_won? | \n", "0.004085 | \n", "
| \n", " | department | \n", "education | \n", "gender | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "is_promoted | \n", "sum_metric | \n", "total_score | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "52992.000000 | \n", "
| mean | \n", "4.958296 | \n", "2.249132 | \n", "0.702823 | \n", "1.255944 | \n", "34.254321 | \n", "3.304725 | \n", "5.381869 | \n", "0.023645 | \n", "63.431273 | \n", "0.085485 | \n", "3.328370 | \n", "80.021588 | \n", "
| std | \n", "2.516290 | \n", "0.466317 | \n", "0.457019 | \n", "0.611910 | \n", "7.121299 | \n", "1.214213 | \n", "3.352458 | \n", "0.151942 | \n", "13.404240 | \n", "0.279604 | \n", "1.227811 | \n", "44.125775 | \n", "
| min | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "1.000000 | \n", "20.000000 | \n", "1.000000 | \n", "1.000000 | \n", "0.000000 | \n", "39.000000 | \n", "0.000000 | \n", "1.000000 | \n", "39.000000 | \n", "
| 25% | \n", "4.000000 | \n", "2.000000 | \n", "0.000000 | \n", "1.000000 | \n", "29.000000 | \n", "3.000000 | \n", "3.000000 | \n", "0.000000 | \n", "51.000000 | \n", "0.000000 | \n", "3.000000 | \n", "53.000000 | \n", "
| 50% | \n", "5.000000 | \n", "2.000000 | \n", "1.000000 | \n", "1.000000 | \n", "33.000000 | \n", "3.000000 | \n", "5.000000 | \n", "0.000000 | \n", "60.000000 | \n", "0.000000 | \n", "3.000000 | \n", "64.000000 | \n", "
| 75% | \n", "7.000000 | \n", "3.000000 | \n", "1.000000 | \n", "1.000000 | \n", "38.000000 | \n", "4.000000 | \n", "7.000000 | \n", "0.000000 | \n", "76.000000 | \n", "0.000000 | \n", "4.000000 | \n", "84.000000 | \n", "
| max | \n", "8.000000 | \n", "3.000000 | \n", "1.000000 | \n", "10.000000 | \n", "60.000000 | \n", "5.000000 | \n", "16.000000 | \n", "1.000000 | \n", "99.000000 | \n", "1.000000 | \n", "6.000000 | \n", "710.000000 | \n", "
| \n", " | department | \n", "education | \n", "gender | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "sum_metric | \n", "total_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "8 | \n", "2 | \n", "1 | \n", "1 | \n", "24 | \n", "3.0 | \n", "1 | \n", "0 | \n", "77 | \n", "3.0 | \n", "77 | \n", "0 | \n", "
| 1 | \n", "2 | \n", "2 | \n", "0 | \n", "1 | \n", "31 | \n", "3.0 | \n", "5 | \n", "0 | \n", "51 | \n", "3.0 | \n", "51 | \n", "0 | \n", "
| 2 | \n", "7 | \n", "2 | \n", "1 | \n", "1 | \n", "31 | \n", "1.0 | \n", "4 | \n", "0 | \n", "47 | \n", "1.0 | \n", "47 | \n", "0 | \n", "
| 3 | \n", "5 | \n", "2 | \n", "0 | \n", "3 | \n", "31 | \n", "2.0 | \n", "9 | \n", "0 | \n", "65 | \n", "2.0 | \n", "195 | \n", "0 | \n", "
| 4 | \n", "1 | \n", "2 | \n", "1 | \n", "1 | \n", "30 | \n", "4.0 | \n", "7 | \n", "0 | \n", "61 | \n", "4.0 | \n", "61 | \n", "0 | \n", "
| \n", " | department | \n", "education | \n", "gender | \n", "no_of_trainings | \n", "age | \n", "previous_year_rating | \n", "length_of_service | \n", "awards_won? | \n", "avg_training_score | \n", "sum_metric | \n", "total_score | \n", "is_promoted | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | \n", "8 | \n", "2 | \n", "1 | \n", "1 | \n", "29 | \n", "5.0 | \n", "2 | \n", "0 | \n", "76 | \n", "5.0 | \n", "76 | \n", "1 | \n", "
| 20 | \n", "7 | \n", "3 | \n", "1 | \n", "1 | \n", "37 | \n", "5.0 | \n", "3 | \n", "0 | \n", "47 | \n", "5.0 | \n", "47 | \n", "1 | \n", "
| 40 | \n", "0 | \n", "2 | \n", "1 | \n", "1 | \n", "26 | \n", "5.0 | \n", "4 | \n", "0 | \n", "90 | \n", "5.0 | \n", "90 | \n", "1 | \n", "
| 63 | \n", "8 | \n", "1 | \n", "1 | \n", "1 | \n", "23 | \n", "3.0 | \n", "1 | \n", "0 | \n", "81 | \n", "3.0 | \n", "81 | \n", "1 | \n", "
| 67 | \n", "4 | \n", "2 | \n", "1 | \n", "1 | \n", "28 | \n", "3.0 | \n", "3 | \n", "0 | \n", "59 | \n", "3.0 | \n", "59 | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 23461 | \n", "7 | \n", "2 | \n", "0 | \n", "2 | \n", "27 | \n", "4.0 | \n", "4 | \n", "0 | \n", "48 | \n", "4.0 | \n", "96 | \n", "1 | \n", "
| 23470 | \n", "7 | \n", "2 | \n", "1 | \n", "1 | \n", "36 | \n", "5.0 | \n", "3 | \n", "0 | \n", "49 | \n", "5.0 | \n", "49 | \n", "1 | \n", "
| 23472 | \n", "8 | \n", "2 | \n", "0 | \n", "1 | \n", "29 | \n", "3.0 | \n", "3 | \n", "0 | \n", "87 | \n", "3.0 | \n", "87 | \n", "1 | \n", "
| 23475 | \n", "3 | \n", "2 | \n", "0 | \n", "1 | \n", "28 | \n", "3.0 | \n", "2 | \n", "0 | \n", "61 | \n", "3.0 | \n", "61 | \n", "1 | \n", "
| 23489 | \n", "8 | \n", "3 | \n", "1 | \n", "3 | \n", "40 | \n", "5.0 | \n", "5 | \n", "0 | \n", "89 | \n", "5.0 | \n", "267 | \n", "1 | \n", "
2471 rows × 12 columns
\n", "