従業員データ
Sign In
- Project InformationProject NameExploratory Blog for Data visualizationDataframe NameHR_Employee_DataCreated ByTakato ShirotoCreated Date6/6/2019 2:17:15 PM UTCUpdated Date11/21/2019 2:33:32 AM UTCDesktop Version5.4.0.12ScheduleScheduling is not supported because:
- No Data Source to Refresh
Last Refresh Log (Schedule)Start TimeFinish TimeTime ElapsedProcessed Data SizeProcessed # of Rows
EmployeeNumber
Character
AA-10315102 (1)
AA-10315102 : 1 (0.07%)
AA-10315120 (1)
AA-10315120 : 1 (0.07%)
AA-10315139 (1)
AA-10315139 : 1 (0.07%)
AA-103151402 (1)
AA-103151402: 1 (0.07%)
AA-103151404 (1)
AA-103151404: 1 (0.07%)
AA-103151406 (1)
AA-103151406: 1 (0.07%)
(Other) (1,464)
(Other) : 1,464 (99.59%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values1,470 |
| Min Length7 |
| Max Length12 |
Age
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min18 |
| Max60 |
| Median36 |
| Average36.92 |
| Std Dev9.14 |
Gender
Character
Male (882)
Male : 882 (60.00%)
Female (588)
Female: 588 (40.00%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values2 |
| Min Length4 |
| Max Length6 |
MaritalStatus
Character
Married (673)
Married : 673 (45.78%)
Single (470)
Single : 470 (31.97%)
Divorced (327)
Divorced: 327 (22.24%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values3 |
| Min Length6 |
| Max Length8 |
Education
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max5 |
| Median3 |
| Average2.913 |
| Std Dev1.02 |
EducationField
Character
Life Sciences (606)
Life Sciences : 606 (41.22%)
Medical (464)
Medical : 464 (31.56%)
Marketing (159)
Marketing : 159 (10.82%)
Technical Degree (132)
Technical Degree: 132 (8.98%)
Other (82)
Other : 82 (5.58%)
Human Resources (27)
Human Resources : 27 (1.84%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values6 |
| Min Length5 |
| Max Length16 |
Department
Character
Research & Development (961)
Research & Development: 961 (65.37%)
Sales (446)
Sales : 446 (30.34%)
Human Resources (63)
Human Resources : 63 (4.29%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values3 |
| Min Length5 |
| Max Length22 |
JobRole
Character
Sales Executive (326)
Sales Executive : 326 (22.18%)
Research Scientist (292)
Research Scientist : 292 (19.86%)
Laboratory Technician (259)
Laboratory Technician : 259 (17.62%)
Manufacturing Director (145)
Manufacturing Director : 145 (9.86%)
Healthcare Representative (131)
Healthcare Representative: 131 (8.91%)
Manager (102)
Manager : 102 (6.94%)
(Other) (215)
(Other) : 215 (14.63%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values9 |
| Min Length7 |
| Max Length25 |
Attrition
Logical
TRUE (237)
TRUE : 237 (16.12%)
FALSE (1,233)
FALSE: 1,233 (83.88%)
Not NA: 100.00% |
| NA0 (0.00%) |
| TRUE237 (16.12%) |
| FALSE1,233 (83.88%) |
DailyRate
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min102 |
| Max1,499 |
| Median802 |
| Average802.5 |
| Std Dev403.51 |
BusinessTravel
Character
Travel_Rarely (1,043)
Travel_Rarely : 1,043 (70.95%)
Travel_Frequently (277)
Travel_Frequently: 277 (18.84%)
Non-Travel (150)
Non-Travel : 150 (10.20%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values3 |
| Min Length10 |
| Max Length17 |
DistanceFromHome
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max29 |
| Median7 |
| Average9.193 |
| Std Dev8.11 |
EmployeeCount
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max1 |
| Median1 |
| Average1 |
| Std Dev0.00 |
EnvironmentSatisfaction
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max4 |
| Median3 |
| Average2.722 |
| Std Dev1.09 |
HourlyRate
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min30 |
| Max100 |
| Median66 |
| Average65.89 |
| Std Dev20.33 |
JobInvolvement
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max4 |
| Median3 |
| Average2.73 |
| Std Dev0.71 |
JobLevel
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max5 |
| Median2 |
| Average2.064 |
| Std Dev1.11 |
JobSatisfaction
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max4 |
| Median3 |
| Average2.729 |
| Std Dev1.10 |
MonthlyIncome
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1,009 |
| Max19,999 |
| Median4,919 |
| Average6,503 |
| Std Dev4,707.96 |
MonthlyRate
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min2,094 |
| Max26,999 |
| Median14,236 |
| Average14,313 |
| Std Dev7,117.79 |
NumCompaniesWorked
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max9 |
| Median2 |
| Average2.693 |
| Std Dev2.50 |
Over18
Character
Y (1,470)
Y: 1,470 (100.00%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values1 |
| Min Length1 |
| Max Length1 |
OverTime
Character
No (1,054)
No : 1,054 (71.70%)
Yes (416)
Yes: 416 (28.30%)
Not NA: 100.00% |
| NA0 (0.00%) |
| Unique Values2 |
| Min Length2 |
| Max Length3 |
PercentSalaryHike
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min11 |
| Max25 |
| Median14 |
| Average15.21 |
| Std Dev3.66 |
PerformanceRating
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min3 |
| Max4 |
| Median3 |
| Average3.154 |
| Std Dev0.36 |
RelationshipSatisfaction
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max4 |
| Median3 |
| Average2.712 |
| Std Dev1.08 |
StandardHours
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min80 |
| Max80 |
| Median80 |
| Average80 |
| Std Dev0.00 |
StockOptionLevel
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max3 |
| Median1 |
| Average0.7939 |
| Std Dev0.85 |
TotalWorkingYears
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max40 |
| Median10 |
| Average11.28 |
| Std Dev7.78 |
TrainingTimesLastYear
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max6 |
| Median3 |
| Average2.799 |
| Std Dev1.29 |
WorkLifeBalance
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min1 |
| Max4 |
| Median3 |
| Average2.761 |
| Std Dev0.71 |
YearsAtCompany
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max40 |
| Median5 |
| Average7.008 |
| Std Dev6.13 |
YearsInCurrentRole
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max18 |
| Median3 |
| Average4.229 |
| Std Dev3.62 |
YearsSinceLastPromotion
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max15 |
| Median1 |
| Average2.188 |
| Std Dev3.22 |
YearsWithCurrManager
Numeric
Not NA: 100.00% |
| NA0 (0.00%) |
| Min0 |
| Max17 |
| Median3 |
| Average4.123 |
| Std Dev3.57 |
35 Columns 1,470 Rows
The preview data is not shown because the data was published by an older version of Exploratory Desktop.
35 Columns 1,470 Rows
Updated the column descriptions successfully.
Failed to connect to the server. Please contactsupport@exploratory.io.
Description
Styling with Markdown is supported
Data Dictionary
Column Name
Description
EmployeeNumber
従業員番号
Age
年齢
Gender
性別
MaritalStatus
婚姻区分
Education
教育レベル
EducationField
教育分野
Department
部門
JobRole
職種
Attrition
離職したかどうか
DailyRate
BusinessTravel
出張頻度
DistanceFromHome
家からの距離
EmployeeCount
ヘッドカウント
EnvironmentSatisfaction
環境満足度
HourlyRate
JobInvolvement
職務意欲
JobLevel
職位
JobSatisfaction
役職満足度
MonthlyIncome
給料 (月給)
MonthlyRate
NumCompaniesWorked
勤務企業数
Over18
18歳以上
OverTime
残業
PercentSalaryHike
昇給率
PerformanceRating
人事評価
RelationshipSatisfaction
職場の人間関係満足度
StandardHours
標準時間
StockOptionLevel
ストックオプションのレベル
TotalWorkingYears
金属年数
TrainingTimesLastYear
昨年の研修受講回数
WorkLifeBalance
ワークライフバランス
YearsAtCompany
YearsInCurrentRole
YearsSinceLastPromotion
YearsWithCurrManager
Other Information
Size
240k bytes
Type
Excel - Local
Details
Parameter
Value
File
HR_Employee_Data.xlsx
Folder
/Users/takato/Desktop/Training_Data/EDA
Sheet Name
Sheet 1