Overview

Dataset statistics

Number of variables5
Number of observations3409
Missing cells3340
Missing cells (%)19.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory140.0 KiB
Average record size in memory42.0 B

Variable types

Numeric1
Categorical2
Text2

Dataset

Description국립중앙극장 공연예술자료 조직에 대한 정보로 조직코드, 조직유형, 조직명, 비고, 등록일 등의 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15090174/fileData.do

Alerts

등록일 has constant value ""Constant
조직코드 is highly overall correlated with 조직유형High correlation
조직유형 is highly overall correlated with 조직코드High correlation
조직유형 is highly imbalanced (75.8%)Imbalance
비고 has 3339 (97.9%) missing valuesMissing
조직코드 has unique valuesUnique

Reproduction

Analysis started2023-12-12 02:42:32.798457
Analysis finished2023-12-12 02:42:34.234548
Duration1.44 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조직코드
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct3409
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2046.5975
Minimum1
Maximum5857
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.1 KiB
2023-12-12T11:42:34.315058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile172.4
Q1854
median1706
Q32558
95-th percentile5686.6
Maximum5857
Range5856
Interquartile range (IQR)1704

Descriptive statistics

Standard deviation1617.1794
Coefficient of variation (CV)0.7901795
Kurtosis0.36630114
Mean2046.5975
Median Absolute Deviation (MAD)852
Skewness1.1109037
Sum6976851
Variance2615269.2
MonotonicityNot monotonic
2023-12-12T11:42:34.535060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
353 1
 
< 0.1%
5564 1
 
< 0.1%
5566 1
 
< 0.1%
5567 1
 
< 0.1%
5568 1
 
< 0.1%
5569 1
 
< 0.1%
5570 1
 
< 0.1%
5571 1
 
< 0.1%
5572 1
 
< 0.1%
5573 1
 
< 0.1%
Other values (3399) 3399
99.7%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
5857 1
< 0.1%
5856 1
< 0.1%
5855 1
< 0.1%
5854 1
< 0.1%
5853 1
< 0.1%
5852 1
< 0.1%
5851 1
< 0.1%
5850 1
< 0.1%
5849 1
< 0.1%
5848 1
< 0.1%

조직유형
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size26.8 KiB
1
3156 
2
 
252
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
1 3156
92.6%
2 252
 
7.4%
3 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-12T11:42:34.810660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 3156
92.6%
2 252
 
7.4%
3 1
 
< 0.1%

조직명
Text

Distinct3154
Distinct (%)92.5%
Missing1
Missing (%)< 0.1%
Memory size26.8 KiB
2023-12-12T11:42:35.097735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length42
Mean length11.38615
Min length2

Characters and Unicode

Total characters38804
Distinct characters1094
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2901 ?
Unique (%)85.1%

Sample

1st row코리안체임버 오페라단
2nd row명품극단
3rd rowHaydn di Bolzano e Trento
4th rowTeatro alla Scala
5th rowThe Dance Theatre of Harlem
ValueCountFrequency (%)
극단 246
 
3.3%
외 187
 
2.5%
orchestra 123
 
1.7%
opera 81
 
1.1%
the 78
 
1.1%
ballet 75
 
1.0%
국립극장 53
 
0.7%
teatro 45
 
0.6%
de 44
 
0.6%
劇團 38
 
0.5%
Other values (3995) 6451
86.9%
2023-12-12T11:42:35.663021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4031
 
10.4%
e 1323
 
3.4%
a 1229
 
3.2%
r 1021
 
2.6%
단 957
 
2.5%
t 692
 
1.8%
o 692
 
1.8%
l 673
 
1.7%
극 629
 
1.6%
n 612
 
1.6%
Other values (1084) 26945
69.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21252
54.8%
Lowercase Letter 9594
24.7%
Space Separator 4031
 
10.4%
Uppercase Letter 2159
 
5.6%
Other Punctuation 578
 
1.5%
Close Punctuation 507
 
1.3%
Open Punctuation 505
 
1.3%
Decimal Number 150
 
0.4%
Dash Punctuation 16
 
< 0.1%
Math Symbol 10
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
단 957
 
4.5%
극 629
 
3.0%
국 554
 
2.6%
학 451
 
2.1%
대 441
 
2.1%
악 353
 
1.7%
회 319
 
1.5%
교 315
 
1.5%
무 309
 
1.5%
김 294
 
1.4%
Other values (1008) 16630
78.3%
Lowercase Letter
ValueCountFrequency (%)
e 1323
13.8%
a 1229
12.8%
r 1021
10.6%
t 692
 
7.2%
o 692
 
7.2%
l 673
 
7.0%
n 612
 
6.4%
i 602
 
6.3%
h 513
 
5.3%
s 482
 
5.0%
Other values (16) 1755
18.3%
Uppercase Letter
ValueCountFrequency (%)
O 281
13.0%
B 203
 
9.4%
T 192
 
8.9%
C 177
 
8.2%
S 173
 
8.0%
M 109
 
5.0%
L 106
 
4.9%
A 102
 
4.7%
R 96
 
4.4%
N 84
 
3.9%
Other values (16) 636
29.5%
Decimal Number
ValueCountFrequency (%)
1 37
24.7%
0 36
24.0%
2 34
22.7%
3 10
 
6.7%
6 9
 
6.0%
4 7
 
4.7%
9 5
 
3.3%
8 5
 
3.3%
5 4
 
2.7%
7 3
 
2.0%
Other Punctuation
ValueCountFrequency (%)
, 529
91.5%
. 34
 
5.9%
& 8
 
1.4%
/ 4
 
0.7%
: 2
 
0.3%
' 1
 
0.2%
Math Symbol
ValueCountFrequency (%)
< 4
40.0%
> 4
40.0%
+ 2
20.0%
Space Separator
ValueCountFrequency (%)
4031
100.0%
Close Punctuation
ValueCountFrequency (%)
) 507
100.0%
Open Punctuation
ValueCountFrequency (%)
( 505
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 19570
50.4%
Latin 11753
30.3%
Common 5799
 
14.9%
Han 1682
 
4.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
단 957
 
4.9%
극 629
 
3.2%
국 554
 
2.8%
학 451
 
2.3%
대 441
 
2.3%
악 353
 
1.8%
회 319
 
1.6%
교 315
 
1.6%
무 309
 
1.6%
김 294
 
1.5%
Other values (589) 14948
76.4%
Han
ValueCountFrequency (%)
劇 83
 
4.9%
團 78
 
4.6%
金 68
 
4.0%
李 44
 
2.6%
樂 36
 
2.1%
會 36
 
2.1%
大 32
 
1.9%
學 31
 
1.8%
子 27
 
1.6%
場 26
 
1.5%
Other values (409) 1221
72.6%
Latin
ValueCountFrequency (%)
e 1323
 
11.3%
a 1229
 
10.5%
r 1021
 
8.7%
t 692
 
5.9%
o 692
 
5.9%
l 673
 
5.7%
n 612
 
5.2%
i 602
 
5.1%
h 513
 
4.4%
s 482
 
4.1%
Other values (42) 3914
33.3%
Common
ValueCountFrequency (%)
4031
69.5%
, 529
 
9.1%
) 507
 
8.7%
( 505
 
8.7%
1 37
 
0.6%
0 36
 
0.6%
. 34
 
0.6%
2 34
 
0.6%
- 16
 
0.3%
3 10
 
0.2%
Other values (14) 60
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 19568
50.4%
ASCII 17552
45.2%
CJK 1583
 
4.1%
CJK Compat Ideographs 99
 
0.3%
Compat Jamo 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4031
23.0%
e 1323
 
7.5%
a 1229
 
7.0%
r 1021
 
5.8%
t 692
 
3.9%
o 692
 
3.9%
l 673
 
3.8%
n 612
 
3.5%
i 602
 
3.4%
, 529
 
3.0%
Other values (66) 6148
35.0%
Hangul
ValueCountFrequency (%)
단 957
 
4.9%
극 629
 
3.2%
국 554
 
2.8%
학 451
 
2.3%
대 441
 
2.3%
악 353
 
1.8%
회 319
 
1.6%
교 315
 
1.6%
무 309
 
1.6%
김 294
 
1.5%
Other values (588) 14946
76.4%
CJK
ValueCountFrequency (%)
劇 83
 
5.2%
團 78
 
4.9%
金 68
 
4.3%
樂 36
 
2.3%
會 36
 
2.3%
大 32
 
2.0%
學 31
 
2.0%
子 27
 
1.7%
場 26
 
1.6%
國 22
 
1.4%
Other values (385) 1144
72.3%
CJK Compat Ideographs
ValueCountFrequency (%)
李 44
44.4%
女 9
 
9.1%
林 9
 
9.1%
金 4
 
4.0%
梁 4
 
4.0%
盧 3
 
3.0%
烈 3
 
3.0%
聯 2
 
2.0%
禮 2
 
2.0%
樂 2
 
2.0%
Other values (14) 17
 
17.2%
Compat Jamo
ValueCountFrequency (%)
ㄹ 2
100.0%

비고
Text

MISSING 

Distinct45
Distinct (%)64.3%
Missing3339
Missing (%)97.9%
Memory size26.8 KiB
2023-12-12T11:42:35.935087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length9.3571429
Min length2

Characters and Unicode

Total characters655
Distinct characters148
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique39 ?
Unique (%)55.7%

Sample

1st row무용인
2nd row교수극단 (셰익스피어 아해들) 원어연극
3rd row한양대 교수
4th row한국예술종합학교 교수
5th row고려대 교수
ValueCountFrequency (%)
소리꾼 15
 
10.3%
교수 11
 
7.5%
참가 8
 
5.5%
2014 8
 
5.5%
국립극장 6
 
4.1%
여우락(樂)페스티벌 6
 
4.1%
국립극장에서 4
 
2.7%
분리됨 4
 
2.7%
고려대 3
 
2.1%
2000년 3
 
2.1%
Other values (68) 78
53.4%
2023-12-12T11:42:36.358479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
76
 
11.6%
리 22
 
3.4%
국 20
 
3.1%
0 19
 
2.9%
소 16
 
2.4%
꾼 15
 
2.3%
극 14
 
2.1%
교 14
 
2.1%
수 14
 
2.1%
장 13
 
2.0%
Other values (138) 432
66.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 460
70.2%
Space Separator 76
 
11.6%
Decimal Number 48
 
7.3%
Lowercase Letter 48
 
7.3%
Close Punctuation 8
 
1.2%
Open Punctuation 7
 
1.1%
Uppercase Letter 5
 
0.8%
Other Punctuation 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 22
 
4.8%
국 20
 
4.3%
소 16
 
3.5%
꾼 15
 
3.3%
극 14
 
3.0%
교 14
 
3.0%
수 14
 
3.0%
장 13
 
2.8%
립 13
 
2.8%
가 13
 
2.8%
Other values (110) 306
66.5%
Lowercase Letter
ValueCountFrequency (%)
e 10
20.8%
m 6
12.5%
s 5
10.4%
n 4
 
8.3%
a 4
 
8.3%
r 4
 
8.3%
y 3
 
6.2%
t 2
 
4.2%
i 2
 
4.2%
b 2
 
4.2%
Other values (5) 6
12.5%
Uppercase Letter
ValueCountFrequency (%)
M 1
20.0%
A 1
20.0%
T 1
20.0%
D 1
20.0%
E 1
20.0%
Decimal Number
ValueCountFrequency (%)
0 19
39.6%
2 12
25.0%
1 9
18.8%
4 8
16.7%
Space Separator
ValueCountFrequency (%)
76
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 454
69.3%
Common 142
 
21.7%
Latin 53
 
8.1%
Han 6
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 22
 
4.8%
국 20
 
4.4%
소 16
 
3.5%
꾼 15
 
3.3%
극 14
 
3.1%
교 14
 
3.1%
수 14
 
3.1%
장 13
 
2.9%
립 13
 
2.9%
가 13
 
2.9%
Other values (109) 300
66.1%
Latin
ValueCountFrequency (%)
e 10
18.9%
m 6
11.3%
s 5
9.4%
n 4
 
7.5%
a 4
 
7.5%
r 4
 
7.5%
y 3
 
5.7%
t 2
 
3.8%
i 2
 
3.8%
b 2
 
3.8%
Other values (10) 11
20.8%
Common
ValueCountFrequency (%)
76
53.5%
0 19
 
13.4%
2 12
 
8.5%
1 9
 
6.3%
) 8
 
5.6%
4 8
 
5.6%
( 7
 
4.9%
, 3
 
2.1%
Han
ValueCountFrequency (%)
樂 6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 454
69.3%
ASCII 195
29.8%
CJK Compat Ideographs 6
 
0.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
76
39.0%
0 19
 
9.7%
2 12
 
6.2%
e 10
 
5.1%
1 9
 
4.6%
) 8
 
4.1%
4 8
 
4.1%
( 7
 
3.6%
m 6
 
3.1%
s 5
 
2.6%
Other values (18) 35
17.9%
Hangul
ValueCountFrequency (%)
리 22
 
4.8%
국 20
 
4.4%
소 16
 
3.5%
꾼 15
 
3.3%
극 14
 
3.1%
교 14
 
3.1%
수 14
 
3.1%
장 13
 
2.9%
립 13
 
2.9%
가 13
 
2.9%
Other values (109) 300
66.1%
CJK Compat Ideographs
ValueCountFrequency (%)
樂 6
100.0%

등록일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size26.8 KiB
2013-03-27
3409 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2013-03-27
2nd row2013-03-27
3rd row2013-03-27
4th row2013-03-27
5th row2013-03-27

Common Values

ValueCountFrequency (%)
2013-03-27 3409
100.0%

Length

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

Common Values (Plot)

2023-12-12T11:42:36.617399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2013-03-27 3409
100.0%

Interactions

2023-12-12T11:42:33.814576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T11:42:36.689807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조직코드조직유형비고
조직코드1.0000.7740.978
조직유형0.7741.000NaN
비고0.978NaN1.000
2023-12-12T11:42:36.775951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조직코드조직유형
조직코드1.0000.654
조직유형0.6541.000

Missing values

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

조직코드조직유형조직명비고등록일
03531코리안체임버 오페라단<NA>2013-03-27
13541명품극단<NA>2013-03-27
23551Haydn di Bolzano e Trento<NA>2013-03-27
33561Teatro alla Scala<NA>2013-03-27
43571The Dance Theatre of Harlem<NA>2013-03-27
53581Del Teatro la Fenice<NA>2013-03-27
63591Age of Englihtement<NA>2013-03-27
73601St. Thomas Boys Choir Leipzig<NA>2013-03-27
83611홍신자<NA>2013-03-27
93621정은혜무용인2013-03-27
조직코드조직유형조직명비고등록일
339923191사단법인 벽사춤아카데미<NA>2013-03-27
340023201극단예맥<NA>2013-03-27
340123211그레이스여성성가단 외<NA>2013-03-27
340223221우재현 외<NA>2013-03-27
340323231한국음악극연구소<NA>2013-03-27
340423241Labo. C.J.K<NA>2013-03-27
340523251국립극장 공연사업팀<NA>2013-03-27
340623261김준희의 나비6<NA>2013-03-27
340723271Pacific Northwest Ballet<NA>2013-03-27
340823281The Bavarian State Ballet<NA>2013-03-27