Overview

Dataset statistics

Number of variables11
Number of observations50
Missing cells14
Missing cells (%)2.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.7 KiB
Average record size in memory95.6 B

Variable types

Numeric4
Categorical5
Text1
Boolean1

Dataset

Description제주관광정보센터 상담 S/W 내 제주관광공사 조직 정보를 제공하는 데이터로 조직ID 및 부서명, 단계, 작성일, 작성자, 수정일 수정자 등의 정보를 제공합니다.
Author제주관광공사
URLhttps://www.data.go.kr/data/15038967/fileData.do

Alerts

작성자 is highly overall correlated with 조직아이디 and 4 other fieldsHigh correlation
작성일 is highly overall correlated with 작성자 and 1 other fieldsHigh correlation
조직아이디 is highly overall correlated with 부서아이디 and 1 other fieldsHigh correlation
부서아이디 is highly overall correlated with 조직아이디 and 1 other fieldsHigh correlation
상위부서아이디 is highly overall correlated with 순서 and 2 other fieldsHigh correlation
순서 is highly overall correlated with 상위부서아이디 and 2 other fieldsHigh correlation
사용여부 is highly overall correlated with 상위부서아이디 and 1 other fieldsHigh correlation
수정일 is highly overall correlated with 작성일 and 1 other fieldsHigh correlation
수정자 is highly overall correlated with 수정일High correlation
수정자 is highly imbalanced (75.8%)Imbalance
순서 has 14 (28.0%) missing valuesMissing
조직아이디 has unique valuesUnique
부서아이디 has unique valuesUnique
조직아이디 has 1 (2.0%) zerosZeros
부서아이디 has 1 (2.0%) zerosZeros
상위부서아이디 has 15 (30.0%) zerosZeros
순서 has 1 (2.0%) zerosZeros

Reproduction

Analysis started2023-12-12 02:01:56.775269
Analysis finished2023-12-12 02:01:59.400047
Duration2.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조직아이디
Real number (ℝ)

HIGH CORRELATION  UNIQUE  ZEROS 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean65384
Minimum0
Maximum140000
Zeros1
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-12T11:01:59.518265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile10145
Q130225
median50550
Q3107600
95-th percentile120455
Maximum140000
Range140000
Interquartile range (IQR)77375

Descriptive statistics

Standard deviation41212.18
Coefficient of variation (CV)0.63030987
Kurtosis-1.3886948
Mean65384
Median Absolute Deviation (MAD)39750
Skewness0.1557024
Sum3269200
Variance1.6984438 × 109
MonotonicityNot monotonic
2023-12-12T11:01:59.705126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
70100 1
 
2.0%
140000 1
 
2.0%
50400 1
 
2.0%
60000 1
 
2.0%
60100 1
 
2.0%
10500 1
 
2.0%
80000 1
 
2.0%
50500 1
 
2.0%
70000 1
 
2.0%
50600 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
0 1
2.0%
10000 1
2.0%
10100 1
2.0%
10200 1
2.0%
10300 1
2.0%
10400 1
2.0%
10500 1
2.0%
20000 1
2.0%
20100 1
2.0%
20200 1
2.0%
ValueCountFrequency (%)
140000 1
2.0%
130000 1
2.0%
120500 1
2.0%
120400 1
2.0%
120300 1
2.0%
120200 1
2.0%
120100 1
2.0%
120000 1
2.0%
110400 1
2.0%
110300 1
2.0%

부서아이디
Real number (ℝ)

HIGH CORRELATION  UNIQUE  ZEROS 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean65384
Minimum0
Maximum140000
Zeros1
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-12T11:01:59.872222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile10145
Q130225
median50550
Q3107600
95-th percentile120455
Maximum140000
Range140000
Interquartile range (IQR)77375

Descriptive statistics

Standard deviation41212.18
Coefficient of variation (CV)0.63030987
Kurtosis-1.3886948
Mean65384
Median Absolute Deviation (MAD)39750
Skewness0.1557024
Sum3269200
Variance1.6984438 × 109
MonotonicityNot monotonic
2023-12-12T11:02:00.061746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
70100 1
 
2.0%
140000 1
 
2.0%
50400 1
 
2.0%
60000 1
 
2.0%
60100 1
 
2.0%
10500 1
 
2.0%
80000 1
 
2.0%
50500 1
 
2.0%
70000 1
 
2.0%
50600 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
0 1
2.0%
10000 1
2.0%
10100 1
2.0%
10200 1
2.0%
10300 1
2.0%
10400 1
2.0%
10500 1
2.0%
20000 1
2.0%
20100 1
2.0%
20200 1
2.0%
ValueCountFrequency (%)
140000 1
2.0%
130000 1
2.0%
120500 1
2.0%
120400 1
2.0%
120300 1
2.0%
120200 1
2.0%
120100 1
2.0%
120000 1
2.0%
110400 1
2.0%
110300 1
2.0%

상위부서아이디
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct11
Distinct (%)22.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean44200
Minimum0
Maximum120000
Zeros15
Zeros (%)30.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-12T11:02:00.204833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median35000
Q392500
95-th percentile120000
Maximum120000
Range120000
Interquartile range (IQR)92500

Descriptive statistics

Standard deviation44404.909
Coefficient of variation (CV)1.0046359
Kurtosis-1.1504334
Mean44200
Median Absolute Deviation (MAD)35000
Skewness0.60745095
Sum2210000
Variance1.9717959 × 109
MonotonicityNot monotonic
2023-12-12T11:02:00.333619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
0 15
30.0%
50000 6
 
12.0%
10000 5
 
10.0%
120000 5
 
10.0%
100000 4
 
8.0%
110000 4
 
8.0%
40000 4
 
8.0%
30000 3
 
6.0%
20000 2
 
4.0%
70000 1
 
2.0%
ValueCountFrequency (%)
0 15
30.0%
10000 5
 
10.0%
20000 2
 
4.0%
30000 3
 
6.0%
40000 4
 
8.0%
50000 6
 
12.0%
60000 1
 
2.0%
70000 1
 
2.0%
100000 4
 
8.0%
110000 4
 
8.0%
ValueCountFrequency (%)
120000 5
10.0%
110000 4
8.0%
100000 4
8.0%
70000 1
 
2.0%
60000 1
 
2.0%
50000 6
12.0%
40000 4
8.0%
30000 3
6.0%
20000 2
 
4.0%
10000 5
10.0%

단계
Categorical

Distinct3
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2
35 
1
14 
0
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)2.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 35
70.0%
1 14
 
28.0%
0 1
 
2.0%

Length

2023-12-12T11:02:00.472784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:02:00.585493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 35
70.0%
1 14
 
28.0%
0 1
 
2.0%

순서
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct32
Distinct (%)88.9%
Missing14
Missing (%)28.0%
Infinite0
Infinite (%)0.0%
Mean23.916667
Minimum0
Maximum61
Zeros1
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-12T11:02:00.710915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.75
Q18.75
median14
Q342.25
95-th percentile55.25
Maximum61
Range61
Interquartile range (IQR)33.5

Descriptive statistics

Standard deviation19.58042
Coefficient of variation (CV)0.81869353
Kurtosis-1.2270853
Mean23.916667
Median Absolute Deviation (MAD)10.5
Skewness0.57136791
Sum861
Variance383.39286
MonotonicityNot monotonic
2023-12-12T11:02:00.838211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
13 2
 
4.0%
11 2
 
4.0%
12 2
 
4.0%
14 2
 
4.0%
15 1
 
2.0%
53 1
 
2.0%
54 1
 
2.0%
6 1
 
2.0%
61 1
 
2.0%
55 1
 
2.0%
Other values (22) 22
44.0%
(Missing) 14
28.0%
ValueCountFrequency (%)
0 1
2.0%
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
ValueCountFrequency (%)
61 1
2.0%
56 1
2.0%
55 1
2.0%
54 1
2.0%
53 1
2.0%
52 1
2.0%
51 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%

부서명
Text

Distinct41
Distinct (%)82.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-12T11:02:01.101434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.92
Min length2

Characters and Unicode

Total characters296
Distinct characters112
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)66.0%

Sample

1st row일본팀
2nd row보안실
3rd row지역관광그룹
4th row문화관광그룹
5th row관광산업혁신그룹
ValueCountFrequency (%)
관광산업혁신그룹 3
 
5.9%
경영지원팀 2
 
3.9%
글로벌마케팅그룹 2
 
3.9%
기획조정팀 2
 
3.9%
문화관광그룹 2
 
3.9%
지역관광그룹 2
 
3.9%
일본팀 2
 
3.9%
통합디지털플랫폼그룹 2
 
3.9%
대외협력담당관 1
 
2.0%
면세기획팀 1
 
2.0%
Other values (32) 32
62.7%
2023-12-12T11:02:01.513845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
팀 24
 
8.1%
관 14
 
4.7%
광 13
 
4.4%
그 12
 
4.1%
룹 12
 
4.1%
기 10
 
3.4%
지 9
 
3.0%
영 7
 
2.4%
업 7
 
2.4%
실 6
 
2.0%
Other values (102) 182
61.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 273
92.2%
Uppercase Letter 8
 
2.7%
Decimal Number 5
 
1.7%
Lowercase Letter 3
 
1.0%
Open Punctuation 2
 
0.7%
Close Punctuation 2
 
0.7%
Other Punctuation 2
 
0.7%
Space Separator 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팀 24
 
8.8%
관 14
 
5.1%
광 13
 
4.8%
그 12
 
4.4%
룹 12
 
4.4%
기 10
 
3.7%
지 9
 
3.3%
영 7
 
2.6%
업 7
 
2.6%
실 6
 
2.2%
Other values (84) 159
58.2%
Uppercase Letter
ValueCountFrequency (%)
T 3
37.5%
S 1
 
12.5%
E 1
 
12.5%
F 1
 
12.5%
D 1
 
12.5%
R 1
 
12.5%
Decimal Number
ValueCountFrequency (%)
2 2
40.0%
3 1
20.0%
4 1
20.0%
5 1
20.0%
Lowercase Letter
ValueCountFrequency (%)
a 1
33.3%
m 1
33.3%
p 1
33.3%
Other Punctuation
ValueCountFrequency (%)
; 1
50.0%
& 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 273
92.2%
Common 12
 
4.1%
Latin 11
 
3.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팀 24
 
8.8%
관 14
 
5.1%
광 13
 
4.8%
그 12
 
4.4%
룹 12
 
4.4%
기 10
 
3.7%
지 9
 
3.3%
영 7
 
2.6%
업 7
 
2.6%
실 6
 
2.2%
Other values (84) 159
58.2%
Latin
ValueCountFrequency (%)
T 3
27.3%
S 1
 
9.1%
E 1
 
9.1%
F 1
 
9.1%
D 1
 
9.1%
R 1
 
9.1%
a 1
 
9.1%
m 1
 
9.1%
p 1
 
9.1%
Common
ValueCountFrequency (%)
2 2
16.7%
( 2
16.7%
) 2
16.7%
1
8.3%
; 1
8.3%
3 1
8.3%
4 1
8.3%
5 1
8.3%
& 1
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 273
92.2%
ASCII 23
 
7.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
팀 24
 
8.8%
관 14
 
5.1%
광 13
 
4.8%
그 12
 
4.4%
룹 12
 
4.4%
기 10
 
3.7%
지 9
 
3.3%
영 7
 
2.6%
업 7
 
2.6%
실 6
 
2.2%
Other values (84) 159
58.2%
ASCII
ValueCountFrequency (%)
T 3
 
13.0%
2 2
 
8.7%
( 2
 
8.7%
) 2
 
8.7%
1
 
4.3%
S 1
 
4.3%
E 1
 
4.3%
F 1
 
4.3%
; 1
 
4.3%
D 1
 
4.3%
Other values (8) 8
34.8%

사용여부
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size182.0 B
False
31 
True
19 
ValueCountFrequency (%)
False 31
62.0%
True 19
38.0%
2023-12-12T11:02:01.659369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

작성일
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2016-11-28
24 
2021-07-01
16 
2019-10-10
4 
2019-11-29
 
2
2021-07-02
 
1
Other values (3)
3 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique4 ?
Unique (%)8.0%

Sample

1st row2019-10-10
2nd row2019-11-29
3rd row2021-07-01
4th row2021-07-01
5th row2021-07-01

Common Values

ValueCountFrequency (%)
2016-11-28 24
48.0%
2021-07-01 16
32.0%
2019-10-10 4
 
8.0%
2019-11-29 2
 
4.0%
2021-07-02 1
 
2.0%
2019-10-18 1
 
2.0%
2023-06-14 1
 
2.0%
2020-08-10 1
 
2.0%

Length

2023-12-12T11:02:01.785478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:02:01.908796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2016-11-28 24
48.0%
2021-07-01 16
32.0%
2019-10-10 4
 
8.0%
2019-11-29 2
 
4.0%
2021-07-02 1
 
2.0%
2019-10-18 1
 
2.0%
2023-06-14 1
 
2.0%
2020-08-10 1
 
2.0%

작성자
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
825000
25 
sysmanager
25 

Length

Max length10
Median length8
Mean length8
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
825000 25
50.0%
sysmanager 25
50.0%

Length

2023-12-12T11:02:02.040614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:02:02.156936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
825000 25
50.0%
sysmanager 25
50.0%

수정일
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2021-07-01
38 
2019-10-10
5 
2021-07-02
5 
2016-11-28
 
1
2023-06-14
 
1

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique2 ?
Unique (%)4.0%

Sample

1st row2019-10-10
2nd row2021-07-01
3rd row2021-07-01
4th row2021-07-01
5th row2021-07-01

Common Values

ValueCountFrequency (%)
2021-07-01 38
76.0%
2019-10-10 5
 
10.0%
2021-07-02 5
 
10.0%
2016-11-28 1
 
2.0%
2023-06-14 1
 
2.0%

Length

2023-12-12T11:02:02.246859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:02:02.363978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-07-01 38
76.0%
2019-10-10 5
 
10.0%
2021-07-02 5
 
10.0%
2016-11-28 1
 
2.0%
2023-06-14 1
 
2.0%

수정자
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
825000
48 
sysmanager
 
2

Length

Max length10
Median length6
Mean length6.16
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
825000 48
96.0%
sysmanager 2
 
4.0%

Length

2023-12-12T11:02:02.480482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:02:02.835978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
825000 48
96.0%
sysmanager 2
 
4.0%

Interactions

2023-12-12T11:01:58.663688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.366883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.725421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.186783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.762323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.460913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.817950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.320602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.869246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.553300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.938705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.432501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.963016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:57.638994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.065233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:01:58.546904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:02:02.900075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조직아이디부서아이디상위부서아이디단계순서부서명사용여부작성일작성자수정일수정자
조직아이디1.0001.0000.8430.1480.6900.7640.5090.7540.9660.6850.396
부서아이디1.0001.0000.8430.1480.6900.7640.5090.7540.9660.6850.396
상위부서아이디0.8430.8431.0000.5911.0000.0000.8870.6630.7680.5830.000
단계0.1480.1480.5911.0000.7460.8670.2160.0000.0000.0000.000
순서0.6900.6901.0000.7461.0000.9450.7520.4690.5870.6830.428
부서명0.7640.7640.0000.8670.9451.0000.0000.9620.0000.9881.000
사용여부0.5090.5090.8870.2160.7520.0001.0000.4970.1340.1990.000
작성일0.7540.7540.6630.0000.4690.9620.4971.0000.9980.7690.000
작성자0.9660.9660.7680.0000.5870.0000.1340.9981.0000.0000.000
수정일0.6850.6850.5830.0000.6830.9880.1990.7690.0001.0000.614
수정자0.3960.3960.0000.0000.4281.0000.0000.0000.0000.6141.000
2023-12-12T11:02:03.041619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수정자단계수정일작성자사용여부작성일
수정자1.0000.0000.7160.0000.0000.000
단계0.0001.0000.0000.0000.3480.000
수정일0.7160.0001.0000.0000.2320.593
작성자0.0000.0000.0001.0000.0830.902
사용여부0.0000.3480.2320.0831.0000.347
작성일0.0000.0000.5930.9020.3471.000
2023-12-12T11:02:03.190145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조직아이디부서아이디상위부서아이디순서단계사용여부작성일작성자수정일수정자
조직아이디1.0001.0000.4600.1960.0540.3530.4740.7680.3270.272
부서아이디1.0001.0000.4600.1960.0540.3530.4740.7680.3270.272
상위부서아이디0.4600.4601.0000.9370.4310.6650.2700.5520.3900.000
순서0.1960.1960.9371.0000.4010.6830.2460.5230.4440.374
단계0.0540.0540.4310.4011.0000.3480.0000.0000.0000.000
사용여부0.3530.3530.6650.6830.3481.0000.3470.0830.2320.000
작성일0.4740.4740.2700.2460.0000.3471.0000.9020.5930.000
작성자0.7680.7680.5520.5230.0000.0830.9021.0000.0000.000
수정일0.3270.3270.3900.4440.0000.2320.5930.0001.0000.716
수정자0.2720.2720.0000.3740.0000.0000.0000.0000.7161.000

Missing values

2023-12-12T11:01:59.113832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:01:59.304619image/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.

Sample

조직아이디부서아이디상위부서아이디단계순서부서명사용여부작성일작성자수정일수정자
07010070100700002<NA>일본팀N2019-10-108250002019-10-10825000
19000090000019보안실N2019-11-298250002021-07-01825000
21002001002001000002<NA>지역관광그룹N2021-07-018250002021-07-01825000
31003001003001000002<NA>문화관광그룹N2021-07-018250002021-07-01825000
41004001004001000002<NA>관광산업혁신그룹N2021-07-018250002021-07-01825000
51300001300000113통합디지털플랫폼그룹N2021-07-018250002021-07-01825000
61104001104001100002<NA>기타(인도장)Y2021-07-028250002021-07-02825000
700000관광진흥본부Y2016-11-28sysmanager2021-07-01825000
81000010000011글로벌마케팅그룹Y2016-11-28sysmanager2021-07-01825000
9101001010010000211마케팅기획팀N2016-11-28sysmanager2021-07-01825000
조직아이디부서아이디상위부서아이디단계순서부서명사용여부작성일작성자수정일수정자
401000001000000110관광산업혁신그룹N2021-07-018250002021-07-01825000
411001001001001000002<NA>글로벌마케팅그룹N2021-07-018250002021-07-01825000
421100001100000111수익사업실Y2021-07-018250002021-07-01825000
431200001200000112경영전략실Y2021-07-018250002021-07-01825000
441201001201001200002<NA>기획조정팀Y2021-07-018250002021-07-01825000
451202001202001200002<NA>미래전략팀Y2021-07-018250002021-07-01825000
461203001203001200002<NA>경영지원팀Y2021-07-018250002021-07-01825000
471204001204001200002<NA>감사팀Y2021-07-018250002021-07-01825000
481101001101001100002<NA>면세기획팀Y2021-07-018250002021-07-01825000
491205001205001200002<NA>기타(기자실)Y2021-07-018250002021-07-01825000