Overview

Dataset statistics

Number of variables19
Number of observations4278
Missing cells30659
Missing cells (%)37.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory689.5 KiB
Average record size in memory165.0 B

Variable types

Numeric5
Categorical7
Unsupported5
DateTime2

Dataset

Description2011~2016년도 소싸움경기 회차별 심판 경기전 입소 시간 데이터. 매 회차별 심판의 경기장 입소 시간 등록 테이블
Author청도공영사업공사
URLhttps://www.data.go.kr/data/15123736/fileData.do

Alerts

경기장 코드 has constant value ""Constant
수정자 아이디 is highly overall correlated with 기준년도 and 5 other fieldsHigh correlation
입소 승인자 아이디 is highly overall correlated with 기준년도 and 4 other fieldsHigh correlation
기준년도 is highly overall correlated with 입소 일자 and 3 other fieldsHigh correlation
입소 일자 is highly overall correlated with 기준년도 and 3 other fieldsHigh correlation
입소시간 is highly overall correlated with 상태코드 and 3 other fieldsHigh correlation
심판아이디 is highly overall correlated with 상태코드High correlation
상태코드 is highly overall correlated with 입소시간 and 2 other fieldsHigh correlation
작성자 아이디 is highly overall correlated with 기준년도 and 4 other fieldsHigh correlation
입소 승인자 아이디 is highly imbalanced (65.8%)Imbalance
작성자 아이디 is highly imbalanced (64.8%)Imbalance
수정자 아이디 is highly imbalanced (50.4%)Imbalance
입소 일자 has 2255 (52.7%) missing valuesMissing
입소시간 has 2255 (52.7%) missing valuesMissing
입소순번 has 2255 (52.7%) missing valuesMissing
퇴소 상세 코드 has 4278 (100.0%) missing valuesMissing
퇴소 일자 has 4278 (100.0%) missing valuesMissing
퇴소 시간 has 4278 (100.0%) missing valuesMissing
퇴소 승인자 아이디 has 4278 (100.0%) missing valuesMissing
퇴소 상세 내용 has 4278 (100.0%) missing valuesMissing
수정 일시 has 2504 (58.5%) missing valuesMissing
퇴소 상세 코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
퇴소 일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
퇴소 시간 is an unsupported type, check if it needs cleaning or further analysisUnsupported
퇴소 승인자 아이디 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 06:18:12.450497
Analysis finished2023-12-12 06:18:17.629041
Duration5.18 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년도
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2012.8282
Minimum2011
Maximum2016
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size37.7 KiB
2023-12-12T15:18:17.717274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2011
5-th percentile2011
Q12012
median2013
Q32013
95-th percentile2015
Maximum2016
Range5
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.1371591
Coefficient of variation (CV)0.00056495585
Kurtosis-0.10289365
Mean2012.8282
Median Absolute Deviation (MAD)1
Skewness0.67501339
Sum8610879
Variance1.2931307
MonotonicityNot monotonic
2023-12-12T15:18:17.858201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2013 1710
40.0%
2012 1456
34.0%
2015 627
 
14.7%
2011 352
 
8.2%
2014 114
 
2.7%
2016 19
 
0.4%
ValueCountFrequency (%)
2011 352
 
8.2%
2012 1456
34.0%
2013 1710
40.0%
2014 114
 
2.7%
2015 627
 
14.7%
2016 19
 
0.4%
ValueCountFrequency (%)
2016 19
 
0.4%
2015 627
 
14.7%
2014 114
 
2.7%
2013 1710
40.0%
2012 1456
34.0%
2011 352
 
8.2%

경기장 코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
1
4278 

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 4278
100.0%

Length

2023-12-12T15:18:17.974178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:18:18.087819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 4278
100.0%

회차
Real number (ℝ)

Distinct46
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.389201
Minimum1
Maximum46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size37.7 KiB
2023-12-12T15:18:18.237002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q18
median17
Q330
95-th percentile43
Maximum46
Range45
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.345387
Coefficient of variation (CV)0.68828972
Kurtosis-1.092146
Mean19.389201
Median Absolute Deviation (MAD)11
Skewness0.38328046
Sum82947
Variance178.09936
MonotonicityNot monotonic
2023-12-12T15:18:18.418982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
3 187
 
4.4%
1 168
 
3.9%
2 168
 
3.9%
12 130
 
3.0%
4 130
 
3.0%
5 130
 
3.0%
9 130
 
3.0%
10 130
 
3.0%
11 130
 
3.0%
7 130
 
3.0%
Other values (36) 2845
66.5%
ValueCountFrequency (%)
1 168
3.9%
2 168
3.9%
3 187
4.4%
4 130
3.0%
5 130
3.0%
6 130
3.0%
7 130
3.0%
8 111
2.6%
9 130
3.0%
10 130
3.0%
ValueCountFrequency (%)
46 32
0.7%
45 70
1.6%
44 70
1.6%
43 70
1.6%
42 70
1.6%
41 70
1.6%
40 70
1.6%
39 70
1.6%
38 70
1.6%
37 70
1.6%

일차
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
1
2204 
2
2074 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 2204
51.5%
2 2074
48.5%

Length

2023-12-12T15:18:18.564303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:18:18.666199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 2204
51.5%
2 2074
48.5%

심판아이디
Categorical

HIGH CORRELATION 

Distinct19
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
R0110009
 
253
R0110007
 
253
R0110001
 
253
R0110010
 
253
R0110003
 
253
Other values (14)
3013 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowR0110009
2nd rowR0110002
3rd rowR0110001
4th rowR0120005
5th rowR0110004

Common Values

ValueCountFrequency (%)
R0110009 253
 
5.9%
R0110007 253
 
5.9%
R0110001 253
 
5.9%
R0110010 253
 
5.9%
R0110003 253
 
5.9%
R0110011 253
 
5.9%
R0110004 253
 
5.9%
R0110008 253
 
5.9%
R0110002 253
 
5.9%
R0110006 253
 
5.9%
Other values (9) 1748
40.9%

Length

2023-12-12T15:18:18.772813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
r0110009 253
 
5.9%
r0110004 253
 
5.9%
r0110005 253
 
5.9%
r0110007 253
 
5.9%
r0110002 253
 
5.9%
r0110008 253
 
5.9%
r0110006 253
 
5.9%
r0110011 253
 
5.9%
r0110003 253
 
5.9%
r0110010 253
 
5.9%
Other values (9) 1748
40.9%

상태코드
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
202
2258 
201
2011 
<NA>
 
9

Length

Max length4
Median length3
Mean length3.0021038
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row201
2nd row201
3rd row201
4th row201
5th row202

Common Values

ValueCountFrequency (%)
202 2258
52.8%
201 2011
47.0%
<NA> 9
 
0.2%

Length

2023-12-12T15:18:18.910110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:18:19.045963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202 2258
52.8%
201 2011
47.0%
na 9
 
0.2%

입소 일자
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct254
Distinct (%)12.6%
Missing2255
Missing (%)52.7%
Infinite0
Infinite (%)0.0%
Mean20127446
Minimum20110901
Maximum20150905
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size37.7 KiB
2023-12-12T15:18:19.556329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20110901
5-th percentile20111009
Q120120519
median20130223
Q320131005
95-th percentile20150607
Maximum20150905
Range40004
Interquartile range (IQR)10486

Descriptive statistics

Standard deviation11418.959
Coefficient of variation (CV)0.0005673327
Kurtosis-0.12024085
Mean20127446
Median Absolute Deviation (MAD)9412
Skewness0.69174109
Sum4.0717824 × 1010
Variance1.3039261 × 108
MonotonicityNot monotonic
2023-12-12T15:18:19.795424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20110911 11
 
0.3%
20110904 11
 
0.3%
20150815 9
 
0.2%
20150905 9
 
0.2%
20150830 9
 
0.2%
20111113 9
 
0.2%
20150829 9
 
0.2%
20130721 8
 
0.2%
20130303 8
 
0.2%
20130811 8
 
0.2%
Other values (244) 1932
45.2%
(Missing) 2255
52.7%
ValueCountFrequency (%)
20110901 3
 
0.1%
20110903 8
0.2%
20110904 11
0.3%
20110909 3
 
0.1%
20110910 8
0.2%
20110911 11
0.3%
20110917 7
0.2%
20110918 8
0.2%
20110924 8
0.2%
20110925 7
0.2%
ValueCountFrequency (%)
20150905 9
0.2%
20150830 9
0.2%
20150829 9
0.2%
20150815 9
0.2%
20150725 8
0.2%
20150718 8
0.2%
20150712 8
0.2%
20150704 8
0.2%
20150628 8
0.2%
20150620 8
0.2%

입소시간
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct299
Distinct (%)14.8%
Missing2255
Missing (%)52.7%
Infinite0
Infinite (%)0.0%
Mean94921.357
Minimum80000
Maximum185551
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size37.7 KiB
2023-12-12T15:18:19.998163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum80000
5-th percentile90000
Q193000
median94000
Q395000
95-th percentile104603.9
Maximum185551
Range105551
Interquartile range (IQR)2000

Descriptive statistics

Standard deviation5940.8096
Coefficient of variation (CV)0.062586648
Kurtosis82.966879
Mean94921.357
Median Absolute Deviation (MAD)1000
Skewness6.3412166
Sum1.9202591 × 108
Variance35293218
MonotonicityNot monotonic
2023-12-12T15:18:20.314277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
94000 459
 
10.7%
93000 459
 
10.7%
95000 173
 
4.0%
92000 126
 
2.9%
90000 122
 
2.9%
93500 112
 
2.6%
94500 58
 
1.4%
100000 50
 
1.2%
91000 47
 
1.1%
92500 43
 
1.0%
Other values (289) 374
 
8.7%
(Missing) 2255
52.7%
ValueCountFrequency (%)
80000 1
 
< 0.1%
80900 1
 
< 0.1%
81000 2
 
< 0.1%
82000 1
 
< 0.1%
82900 1
 
< 0.1%
83000 10
0.2%
84000 4
 
0.1%
84500 2
 
< 0.1%
85000 16
0.4%
85500 4
 
0.1%
ValueCountFrequency (%)
185551 3
0.1%
135810 1
 
< 0.1%
135804 1
 
< 0.1%
135752 1
 
< 0.1%
115454 3
0.1%
112949 1
 
< 0.1%
112947 1
 
< 0.1%
112945 1
 
< 0.1%
112943 1
 
< 0.1%
112941 1
 
< 0.1%

입소순번
Real number (ℝ)

MISSING 

Distinct19
Distinct (%)0.9%
Missing2255
Missing (%)52.7%
Infinite0
Infinite (%)0.0%
Mean4.6767177
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size37.7 KiB
2023-12-12T15:18:20.595153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median5
Q37
95-th percentile8
Maximum21
Range20
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.717909
Coefficient of variation (CV)0.58115737
Kurtosis4.442519
Mean4.6767177
Median Absolute Deviation (MAD)2
Skewness1.2241937
Sum9461
Variance7.3870294
MonotonicityNot monotonic
2023-12-12T15:18:20.756307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
4 251
 
5.9%
3 250
 
5.8%
1 250
 
5.8%
2 249
 
5.8%
5 249
 
5.8%
7 248
 
5.8%
6 248
 
5.8%
8 239
 
5.6%
9 7
 
0.2%
17 4
 
0.1%
Other values (9) 28
 
0.7%
(Missing) 2255
52.7%
ValueCountFrequency (%)
1 250
5.8%
2 249
5.8%
3 250
5.8%
4 251
5.9%
5 249
5.8%
6 248
5.8%
7 248
5.8%
8 239
5.6%
9 7
 
0.2%
12 3
 
0.1%
ValueCountFrequency (%)
21 2
< 0.1%
20 2
< 0.1%
19 2
< 0.1%
18 4
0.1%
17 4
0.1%
16 4
0.1%
15 4
0.1%
14 4
0.1%
13 3
0.1%
12 3
0.1%

입소 승인자 아이디
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
envred
3626 
shkim0542
379 
j30104
 
251
inhwan7
 
19
yong7321
 
3

Length

Max length9
Median length6
Mean length6.2716223
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
envred 3626
84.8%
shkim0542 379
 
8.9%
j30104 251
 
5.9%
inhwan7 19
 
0.4%
yong7321 3
 
0.1%

Length

2023-12-12T15:18:20.937651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:18:21.079095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
envred 3626
84.8%
shkim0542 379
 
8.9%
j30104 251
 
5.9%
inhwan7 19
 
0.4%
yong7321 3
 
0.1%

퇴소 상세 코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4278
Missing (%)100.0%
Memory size37.7 KiB

퇴소 일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4278
Missing (%)100.0%
Memory size37.7 KiB

퇴소 시간
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4278
Missing (%)100.0%
Memory size37.7 KiB

퇴소 승인자 아이디
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4278
Missing (%)100.0%
Memory size37.7 KiB

퇴소 상세 내용
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4278
Missing (%)100.0%
Memory size37.7 KiB

작성자 아이디
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
envred
3610 
shkim0542
380 
j30104
 
258
inhwan7
 
19
yong7321
 
11

Length

Max length9
Median length6
Mean length6.2760636
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
envred 3610
84.4%
shkim0542 380
 
8.9%
j30104 258
 
6.0%
inhwan7 19
 
0.4%
yong7321 11
 
0.3%

Length

2023-12-12T15:18:21.212894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:18:21.361276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
envred 3610
84.4%
shkim0542 380
 
8.9%
j30104 258
 
6.0%
inhwan7 19
 
0.4%
yong7321 11
 
0.3%

작성 일시
Date

Distinct285
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
Minimum2011-09-01 18:55:51
Maximum2016-01-22 10:16:35
2023-12-12T15:18:21.526517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:21.679224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정자 아이디
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size33.6 KiB
<NA>
2504 
envred
1528 
shkim0542
 
144
j30104
 
98
yong7321
 
3

Length

Max length9
Median length4
Mean length4.9319776
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 2504
58.5%
envred 1528
35.7%
shkim0542 144
 
3.4%
j30104 98
 
2.3%
yong7321 3
 
0.1%
inhwan7 1
 
< 0.1%

Length

2023-12-12T15:18:21.821376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:18:21.957398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 2504
58.5%
envred 1528
35.7%
shkim0542 144
 
3.4%
j30104 98
 
2.3%
yong7321 3
 
0.1%
inhwan7 1
 
< 0.1%

수정 일시
Date

MISSING 

Distinct1774
Distinct (%)100.0%
Missing2504
Missing (%)58.5%
Memory size33.6 KiB
Minimum2011-09-03 14:11:44
Maximum2016-01-22 10:16:38
2023-12-12T15:18:22.096422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:22.258756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T15:18:16.171921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:13.713585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.399693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.895453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.558420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:16.323114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:13.834788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.483749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.038413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.688862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:16.451744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:13.941235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.561917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.140354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.778853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:16.616755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.078572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.685271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.297856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.904948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:16.768427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.261154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:14.778332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:15.426181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:18:16.037325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:18:22.391254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년도회차일차심판아이디상태코드입소 일자입소시간입소순번입소 승인자 아이디작성자 아이디수정자 아이디
기준년도1.0000.5760.0660.2150.0761.0000.8770.0780.8410.8410.841
회차0.5761.0000.0000.0000.0000.6100.2950.2040.5460.5500.500
일차0.0660.0001.0000.0000.0000.0240.1640.0240.0710.0830.049
심판아이디0.2150.0000.0001.0000.7250.4750.5950.7160.0000.0000.712
상태코드0.0760.0000.0000.7251.0000.1241.0000.5100.0590.0570.527
입소 일자1.0000.6100.0240.4750.1241.0000.6300.2690.7420.7420.743
입소시간0.8770.2950.1640.5951.0000.6301.0000.4350.9030.7740.821
입소순번0.0780.2040.0240.7160.5100.2690.4351.0000.3910.5200.395
입소 승인자 아이디0.8410.5460.0710.0000.0590.7420.9030.3911.0000.9951.000
작성자 아이디0.8410.5500.0830.0000.0570.7420.7740.5200.9951.0000.994
수정자 아이디0.8410.5000.0490.7120.5270.7430.8210.3951.0000.9941.000
2023-12-12T15:18:22.543878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상태코드일차수정자 아이디입소 승인자 아이디심판아이디작성자 아이디
상태코드1.0000.0000.6380.0720.6570.070
일차0.0001.0000.0600.0870.0000.101
수정자 아이디0.6380.0601.0001.0000.4490.891
입소 승인자 아이디0.0720.0871.0001.0000.0000.899
심판아이디0.6570.0000.4490.0001.0000.000
작성자 아이디0.0700.1010.8910.8990.0001.000
2023-12-12T15:18:22.672952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년도회차입소 일자입소시간입소순번일차심판아이디상태코드입소 승인자 아이디작성자 아이디수정자 아이디
기준년도1.000-0.1470.9510.393-0.0230.0760.1350.1760.7070.7080.708
회차-0.1471.0000.234-0.199-0.0350.0000.0000.0000.2500.2520.224
입소 일자0.9510.2341.0000.372-0.0260.0150.2440.0890.5750.5750.579
입소시간0.393-0.1990.3721.0000.0140.1180.3250.9990.7860.6150.788
입소순번-0.023-0.035-0.0260.0141.0000.0000.3750.4670.2670.3200.266
일차0.0760.0000.0150.1180.0001.0000.0000.0000.0870.1010.060
심판아이디0.1350.0000.2440.3250.3750.0001.0000.6570.0000.0000.449
상태코드0.1760.0000.0890.9990.4670.0000.6571.0000.0720.0700.638
입소 승인자 아이디0.7070.2500.5750.7860.2670.0870.0000.0721.0000.8991.000
작성자 아이디0.7080.2520.5750.6150.3200.1010.0000.0700.8991.0000.891
수정자 아이디0.7080.2240.5790.7880.2660.0600.4490.6381.0000.8911.000

Missing values

2023-12-12T15:18:16.996588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:18:17.334136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2023-12-12T15:18:17.506761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

기준년도경기장 코드회차일차심판아이디상태코드입소 일자입소시간입소순번입소 승인자 아이디퇴소 상세 코드퇴소 일자퇴소 시간퇴소 승인자 아이디퇴소 상세 내용작성자 아이디작성 일시수정자 아이디수정 일시
02012132R011000920120120219930001envred<NA><NA><NA><NA><NA>envred02-19-2012 10:33:11<NA><NA>
12012132R011000220120120219940005envred<NA><NA><NA><NA><NA>envred02-19-2012 10:33:11envred02-19-2012 10:33:31
22012132R011000120120120219950004envred<NA><NA><NA><NA><NA>envred02-19-2012 10:33:11envred02-19-2012 10:33:26
32012132R012000520120120219930008envred<NA><NA><NA><NA><NA>envred02-19-2012 10:33:11envred02-19-2012 10:33:44
420111121R0110004202<NA><NA><NA>envred<NA><NA><NA><NA><NA>envred11-19-2011 10:29:19<NA><NA>
520111121R0110003202<NA><NA><NA>envred<NA><NA><NA><NA><NA>envred11-19-2011 10:29:19<NA><NA>
620111121R0110011202<NA><NA><NA>envred<NA><NA><NA><NA><NA>envred11-19-2011 10:29:19<NA><NA>
720111121R011000220120111119920007envred<NA><NA><NA><NA><NA>envred11-19-2011 10:29:19envred11-19-2011 10:29:57
820111121R011001020120111119900001envred<NA><NA><NA><NA><NA>envred11-19-2011 10:29:19<NA><NA>
920111121R011000820120111119950008envred<NA><NA><NA><NA><NA>envred11-19-2011 10:29:19envred11-19-2011 10:30:01
기준년도경기장 코드회차일차심판아이디상태코드입소 일자입소시간입소순번입소 승인자 아이디퇴소 상세 코드퇴소 일자퇴소 시간퇴소 승인자 아이디퇴소 상세 내용작성자 아이디작성 일시수정자 아이디수정 일시
426820151112R0120004201201506071039484shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36shkim054206-07-2015 10:39:48
426920151112R0110009201201506071039546shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36shkim054206-07-2015 10:39:54
427020151112R0110002201201506071039361shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36<NA><NA>
427120151112R0130001202<NA><NA><NA>shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36<NA><NA>
427220151112R0110001201201506071039402shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36shkim054206-07-2015 10:39:40
427320151112R0120005201201506071040028shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36shkim054206-07-2015 10:40:02
427420151112R0120001202<NA><NA><NA>shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36<NA><NA>
427520151112R0120003201201506071039443shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36shkim054206-07-2015 10:39:44
427620151112R0130002201201506071039515shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36shkim054206-07-2015 10:39:51
427720151112R0110004202<NA><NA><NA>shkim0542<NA><NA><NA><NA><NA>shkim054206-07-2015 10:39:36<NA><NA>