Overview

Dataset statistics

Number of variables22
Number of observations500
Missing cells2500
Missing cells (%)22.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory90.0 KiB
Average record size in memory184.3 B

Variable types

Text1
Categorical10
DateTime5
Unsupported5
Boolean1

Dataset

Description해당 파일 데이터는 신용보증기금의 공통일반PCOFF현황정보에 대해 확인하실 수 있는 자료이니 데이터 활용에 참고하여 주시기 바랍니다.
Author신용보증기금
URLhttps://www.data.go.kr/data/15093131/fileData.do

Alerts

기준일자 has constant value ""Constant
PCOFF근무구분코드 has constant value ""Constant
PCOFF결재상태구분코드 has constant value ""Constant
승인일자 has constant value ""Constant
동기화여부 has constant value ""Constant
전일심야근무여부 has constant value ""Constant
PC종료예정시간 has constant value ""Constant
성과평가구분코드 has constant value ""Constant
유효개시일자 has constant value ""Constant
유효종료일자 has constant value ""Constant
이력일련번호 is highly imbalanced (93.2%)Imbalance
초과근무시간 is highly imbalanced (75.1%)Imbalance
최종수정수 is highly imbalanced (91.4%)Imbalance
PCOFF전무이사근무승인ID has 500 (100.0%) missing valuesMissing
PCOFF부점근무승인ID has 500 (100.0%) missing valuesMissing
심야근무PC시작시간 has 500 (100.0%) missing valuesMissing
심야근무PC종료시간 has 500 (100.0%) missing valuesMissing
심야초과근무시간 has 500 (100.0%) missing valuesMissing
PCOFF전무이사근무승인ID is an unsupported type, check if it needs cleaning or further analysisUnsupported
PCOFF부점근무승인ID is an unsupported type, check if it needs cleaning or further analysisUnsupported
심야근무PC시작시간 is an unsupported type, check if it needs cleaning or further analysisUnsupported
심야근무PC종료시간 is an unsupported type, check if it needs cleaning or further analysisUnsupported
심야초과근무시간 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 15:54:54.967761
Analysis finished2023-12-12 15:54:55.307899
Duration0.34 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

PCOFF현황관리ID
Text

Distinct492
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
2023-12-13T00:54:55.523224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters5000
Distinct characters62
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique486 ?
Unique (%)97.2%

Sample

1st row9dat5GThU0
2nd row9dat5GRjKk
3rd row9damt81d8F
4th row9dfuoOxcLB
5th row9dfuoPeUb3
ValueCountFrequency (%)
9dflgx0hem 4
 
0.8%
9dfjkfblqs 2
 
0.4%
9dfojafhsc 2
 
0.4%
9dfjkfcbjo 2
 
0.4%
9dfuoo5rzb 2
 
0.4%
9dflgxbfcb 2
 
0.4%
9dflgxsqir 1
 
0.2%
9dflgxtvd4 1
 
0.2%
9dat5gthu0 1
 
0.2%
9dflgxsxwn 1
 
0.2%
Other values (482) 482
96.4%
2023-12-13T00:54:55.991736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
f 545
 
10.9%
9 539
 
10.8%
d 533
 
10.7%
g 310
 
6.2%
X 262
 
5.2%
l 257
 
5.1%
j 214
 
4.3%
K 179
 
3.6%
E 149
 
3.0%
m 86
 
1.7%
Other values (52) 1926
38.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 2709
54.2%
Uppercase Letter 1442
28.8%
Decimal Number 849
 
17.0%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
f 545
20.1%
d 533
19.7%
g 310
11.4%
l 257
9.5%
j 214
 
7.9%
m 86
 
3.2%
o 85
 
3.1%
h 58
 
2.1%
b 55
 
2.0%
u 52
 
1.9%
Other values (16) 514
19.0%
Uppercase Letter
ValueCountFrequency (%)
X 262
18.2%
K 179
 
12.4%
E 149
 
10.3%
N 83
 
5.8%
O 57
 
4.0%
A 52
 
3.6%
P 47
 
3.3%
F 46
 
3.2%
S 41
 
2.8%
R 39
 
2.7%
Other values (16) 487
33.8%
Decimal Number
ValueCountFrequency (%)
9 539
63.5%
0 41
 
4.8%
6 38
 
4.5%
4 38
 
4.5%
8 35
 
4.1%
1 34
 
4.0%
3 33
 
3.9%
7 32
 
3.8%
2 30
 
3.5%
5 29
 
3.4%

Most occurring scripts

ValueCountFrequency (%)
Latin 4151
83.0%
Common 849
 
17.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
f 545
 
13.1%
d 533
 
12.8%
g 310
 
7.5%
X 262
 
6.3%
l 257
 
6.2%
j 214
 
5.2%
K 179
 
4.3%
E 149
 
3.6%
m 86
 
2.1%
o 85
 
2.0%
Other values (42) 1531
36.9%
Common
ValueCountFrequency (%)
9 539
63.5%
0 41
 
4.8%
6 38
 
4.5%
4 38
 
4.5%
8 35
 
4.1%
1 34
 
4.0%
3 33
 
3.9%
7 32
 
3.8%
2 30
 
3.5%
5 29
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
f 545
 
10.9%
9 539
 
10.8%
d 533
 
10.7%
g 310
 
6.2%
X 262
 
5.2%
l 257
 
5.1%
j 214
 
4.3%
K 179
 
3.6%
E 149
 
3.0%
m 86
 
1.7%
Other values (52) 1926
38.5%

이력일련번호
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
1
492 
2
 
6
4
 
1
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)0.4%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 492
98.4%
2 6
 
1.2%
4 1
 
0.2%
3 1
 
0.2%

Length

2023-12-13T00:54:56.178970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:56.291829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 492
98.4%
2 6
 
1.2%
4 1
 
0.2%
3 1
 
0.2%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 00:00:00
2023-12-13T00:54:56.380299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:56.485912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

팀코드
Categorical

Distinct12
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
1
228 
2
80 
9
69 
3
54 
4
28 
Other values (7)
41 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique3 ?
Unique (%)0.6%

Sample

1st row2
2nd row1
3rd row2
4th row2
5th row2

Common Values

ValueCountFrequency (%)
1 228
45.6%
2 80
 
16.0%
9 69
 
13.8%
3 54
 
10.8%
4 28
 
5.6%
5 22
 
4.4%
C 8
 
1.6%
8 5
 
1.0%
Z 3
 
0.6%
7 1
 
0.2%
Other values (2) 2
 
0.4%

Length

2023-12-13T00:54:56.602232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1 228
45.6%
2 80
 
16.0%
9 69
 
13.8%
3 54
 
10.8%
4 28
 
5.6%
5 22
 
4.4%
c 8
 
1.6%
8 5
 
1.0%
z 3
 
0.6%
7 1
 
0.2%
Other values (2) 2
 
0.4%

PCOFF근무구분코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
500
100.0%

Length

2023-12-13T00:54:56.718009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:56.820233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
No values found.

PCOFF결재상태구분코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
500
100.0%

Length

2023-12-13T00:54:56.907065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:56.988300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
No values found.

승인일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
0001-01-01 00:00:00.000000
500 

Length

Max length26
Median length26
Mean length26
Min length26

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0001-01-01 00:00:00.000000
2nd row0001-01-01 00:00:00.000000
3rd row0001-01-01 00:00:00.000000
4th row0001-01-01 00:00:00.000000
5th row0001-01-01 00:00:00.000000

Common Values

ValueCountFrequency (%)
0001-01-01 00:00:00.000000 500
100.0%

Length

2023-12-13T00:54:57.081220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:57.184734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0001-01-01 500
50.0%
00:00:00.000000 500
50.0%

동기화여부
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
500
100.0%

Length

2023-12-13T00:54:57.283568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:57.389693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
No values found.

PCOFF전무이사근무승인ID
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing500
Missing (%)100.0%
Memory size4.5 KiB

PCOFF부점근무승인ID
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing500
Missing (%)100.0%
Memory size4.5 KiB

전일심야근무여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size632.0 B
False
500 
ValueCountFrequency (%)
False 500
100.0%
2023-12-13T00:54:57.468532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

PC종료예정시간
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
500
100.0%

Length

2023-12-13T00:54:57.560576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:57.641335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
No values found.

성과평가구분코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
1
500 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 500
100.0%

Length

2023-12-13T00:54:57.731266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:57.831590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 500
100.0%

PC시작시간
Date

Distinct219
Distinct (%)43.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2023-12-13 08:03:00
Maximum2023-12-13 21:04:00
2023-12-13T00:54:57.931392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:58.053013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

PC종료시간
Date

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2023-12-13 18:30:00
Maximum2023-12-13 21:04:00
2023-12-13T00:54:58.176266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:58.286696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

초과근무시간
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
<NA>
463 
 
36
2:04
 
1

Length

Max length4
Median length4
Mean length3.784
Min length1

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 463
92.6%
36
 
7.2%
2:04 1
 
0.2%

Length

2023-12-13T00:54:58.398973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:58.495801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 463
99.8%
2:04 1
 
0.2%

심야근무PC시작시간
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing500
Missing (%)100.0%
Memory size4.5 KiB

심야근무PC종료시간
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing500
Missing (%)100.0%
Memory size4.5 KiB

심야초과근무시간
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing500
Missing (%)100.0%
Memory size4.5 KiB

유효개시일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 00:00:00
2023-12-13T00:54:58.577135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:58.678081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

유효종료일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
Minimum2023-12-13 00:00:00
Maximum2023-12-13 00:00:00
2023-12-13T00:54:58.773491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:54:58.863367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

최종수정수
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
1
489 
2
 
9
3
 
1
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)0.4%

Sample

1st row2
2nd row2
3rd row2
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 489
97.8%
2 9
 
1.8%
3 1
 
0.2%
4 1
 
0.2%

Length

2023-12-13T00:54:58.992565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:54:59.115017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 489
97.8%
2 9
 
1.8%
3 1
 
0.2%
4 1
 
0.2%

Sample

PCOFF현황관리ID이력일련번호기준일자팀코드PCOFF근무구분코드PCOFF결재상태구분코드승인일자동기화여부PCOFF전무이사근무승인IDPCOFF부점근무승인ID전일심야근무여부PC종료예정시간성과평가구분코드PC시작시간PC종료시간초과근무시간심야근무PC시작시간심야근무PC종료시간심야초과근무시간유효개시일자유효종료일자최종수정수
09dat5GThU0100:00.020001-01-01 00:00:00.000000<NA><NA>N19:0418:30<NA><NA><NA><NA>00:00.000:00.02
19dat5GRjKk100:00.010001-01-01 00:00:00.000000<NA><NA>N19:2918:30<NA><NA><NA><NA>00:00.000:00.02
29damt81d8F100:00.020001-01-01 00:00:00.000000<NA><NA>N18:5918:30<NA><NA><NA><NA>00:00.000:00.02
39dfuoOxcLB100:00.020001-01-01 00:00:00.000000<NA><NA>N114:1018:30<NA><NA><NA><NA>00:00.000:00.01
49dfuoPeUb3100:00.020001-01-01 00:00:00.000000<NA><NA>N110:0918:30<NA><NA><NA><NA>00:00.000:00.01
59dfuoPb0D6100:00.010001-01-01 00:00:00.000000<NA><NA>N19:4118:30<NA><NA><NA><NA>00:00.000:00.01
69dfuoPbCca100:00.070001-01-01 00:00:00.000000<NA><NA>N19:3119:00<NA><NA><NA>00:00.000:00.01
79dfuoO9RJV100:00.030001-01-01 00:00:00.000000<NA><NA>N18:5618:30<NA><NA><NA><NA>00:00.000:00.01
89dfuoO5Rzb200:00.0C0001-01-01 00:00:00.000000<NA><NA>N114:1818:30<NA><NA><NA><NA>00:00.000:00.01
99dfuoO5Rzb100:00.0C0001-01-01 00:00:00.000000<NA><NA>N114:0518:30<NA><NA><NA><NA>00:00.000:00.02
PCOFF현황관리ID이력일련번호기준일자팀코드PCOFF근무구분코드PCOFF결재상태구분코드승인일자동기화여부PCOFF전무이사근무승인IDPCOFF부점근무승인ID전일심야근무여부PC종료예정시간성과평가구분코드PC시작시간PC종료시간초과근무시간심야근무PC시작시간심야근무PC종료시간심야초과근무시간유효개시일자유효종료일자최종수정수
4909dfjKEasJ4100:00.010001-01-01 00:00:00.000000<NA><NA>N111:0618:30<NA><NA><NA><NA>00:00.000:00.01
4919dfjKEanIQ100:00.010001-01-01 00:00:00.000000<NA><NA>N110:2618:30<NA><NA><NA><NA>00:00.000:00.01
4929dfjKEaiGc100:00.010001-01-01 00:00:00.000000<NA><NA>N19:4718:30<NA><NA><NA><NA>00:00.000:00.01
4939dfjKEaeEA100:00.090001-01-01 00:00:00.000000<NA><NA>N18:5418:30<NA><NA><NA><NA>00:00.000:00.01
4949dfjKEaab6100:00.010001-01-01 00:00:00.000000<NA><NA>N19:2618:30<NA><NA><NA><NA>00:00.000:00.01
4959dfjKD95rJ100:00.010001-01-01 00:00:00.000000<NA><NA>N18:1318:30<NA><NA><NA><NA>00:00.000:00.01
4969dfjKD90ot100:00.0Z0001-01-01 00:00:00.000000<NA><NA>N19:4818:30<NA><NA><NA><NA>00:00.000:00.01
4979dfjKD9JbO100:00.010001-01-01 00:00:00.000000<NA><NA>N18:1718:30<NA><NA><NA><NA>00:00.000:00.01
4989dfjKD9DIc100:00.010001-01-01 00:00:00.000000<NA><NA>N18:2818:30<NA><NA><NA><NA>00:00.000:00.01
4999dfjKD9wSj100:00.020001-01-01 00:00:00.000000<NA><NA>N19:4018:30<NA><NA><NA><NA>00:00.000:00.01