Overview

Dataset statistics

Number of variables5
Number of observations368
Missing cells341
Missing cells (%)18.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.2 KiB
Average record size in memory42.4 B

Variable types

Numeric2
Text3

Dataset

Description2000-2005 국내 공연예술 관련 소사 정보(소사 연도, 일자, 내용, 비고 포함)
Author한국문화예술위원회
URLhttps://www.data.go.kr/data/15096997/fileData.do

Alerts

연번 is highly overall correlated with 연도High correlation
연도 is highly overall correlated with 연번High correlation
비고 has 341 (92.7%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 16:18:12.171563
Analysis finished2023-12-12 16:18:13.512621
Duration1.34 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct368
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean184.5
Minimum1
Maximum368
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.4 KiB
2023-12-13T01:18:13.587246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile19.35
Q192.75
median184.5
Q3276.25
95-th percentile349.65
Maximum368
Range367
Interquartile range (IQR)183.5

Descriptive statistics

Standard deviation106.37669
Coefficient of variation (CV)0.57656742
Kurtosis-1.2
Mean184.5
Median Absolute Deviation (MAD)92
Skewness0
Sum67896
Variance11316
MonotonicityStrictly increasing
2023-12-13T01:18:13.739452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
244 1
 
0.3%
253 1
 
0.3%
252 1
 
0.3%
251 1
 
0.3%
250 1
 
0.3%
249 1
 
0.3%
248 1
 
0.3%
247 1
 
0.3%
246 1
 
0.3%
Other values (358) 358
97.3%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
368 1
0.3%
367 1
0.3%
366 1
0.3%
365 1
0.3%
364 1
0.3%
363 1
0.3%
362 1
0.3%
361 1
0.3%
360 1
0.3%
359 1
0.3%

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2003.0679
Minimum2000
Maximum2005
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.4 KiB
2023-12-13T01:18:13.918106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2000
5-th percentile2000
Q12002
median2003
Q32005
95-th percentile2005
Maximum2005
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.5981099
Coefficient of variation (CV)0.00079783113
Kurtosis-1.0707637
Mean2003.0679
Median Absolute Deviation (MAD)1
Skewness-0.33705971
Sum737129
Variance2.5539554
MonotonicityIncreasing
2023-12-13T01:18:14.057495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2005 94
25.5%
2004 76
20.7%
2002 69
18.8%
2003 57
15.5%
2001 46
12.5%
2000 26
 
7.1%
ValueCountFrequency (%)
2000 26
 
7.1%
2001 46
12.5%
2002 69
18.8%
2003 57
15.5%
2004 76
20.7%
2005 94
25.5%
ValueCountFrequency (%)
2005 94
25.5%
2004 76
20.7%
2003 57
15.5%
2002 69
18.8%
2001 46
12.5%
2000 26
 
7.1%

일자
Text

Distinct256
Distinct (%)69.6%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
2023-12-13T01:18:14.328280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length10
Mean length10.6875
Min length10

Characters and Unicode

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

Unique

Unique211 ?
Unique (%)57.3%

Sample

1st row2000-01-03
2nd row2000-01-03
3rd row2000-02-25
4th row2000-03-02
5th row2000-03-02
ValueCountFrequency (%)
2004-00-00 21
 
5.7%
2005-12-00 14
 
3.8%
2005-02-00 9
 
2.4%
2005-01-00 5
 
1.4%
2000-11-06 5
 
1.4%
2001-10-20 5
 
1.4%
2001-03-02 5
 
1.4%
2000-03-02 4
 
1.1%
2001-04-10 4
 
1.1%
2005-04-00 4
 
1.1%
Other values (246) 292
79.3%
2023-12-13T01:18:14.858651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1472
37.4%
- 782
19.9%
2 652
16.6%
1 386
 
9.8%
5 147
 
3.7%
3 139
 
3.5%
4 138
 
3.5%
8 51
 
1.3%
6 48
 
1.2%
9 48
 
1.2%
Other values (2) 70
 
1.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3128
79.5%
Dash Punctuation 782
 
19.9%
Math Symbol 23
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1472
47.1%
2 652
20.8%
1 386
 
12.3%
5 147
 
4.7%
3 139
 
4.4%
4 138
 
4.4%
8 51
 
1.6%
6 48
 
1.5%
9 48
 
1.5%
7 47
 
1.5%
Dash Punctuation
ValueCountFrequency (%)
- 782
100.0%
Math Symbol
ValueCountFrequency (%)
~ 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3933
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1472
37.4%
- 782
19.9%
2 652
16.6%
1 386
 
9.8%
5 147
 
3.7%
3 139
 
3.5%
4 138
 
3.5%
8 51
 
1.3%
6 48
 
1.2%
9 48
 
1.2%
Other values (2) 70
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3933
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1472
37.4%
- 782
19.9%
2 652
16.6%
1 386
 
9.8%
5 147
 
3.7%
3 139
 
3.5%
4 138
 
3.5%
8 51
 
1.3%
6 48
 
1.2%
9 48
 
1.2%
Other values (2) 70
 
1.8%

내용
Text

Distinct367
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
2023-12-13T01:18:15.294381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length277
Median length120
Mean length48.654891
Min length8

Characters and Unicode

Total characters17905
Distinct characters641
Distinct categories14 ?
Distinct scripts4 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique366 ?
Unique (%)99.5%

Sample

1st row한상일 국립국악관현악단장 겸 예술감독 위촉
2nd row안숙선 국립창극단장 위촉
3rd row이성림 한국예술문화단체총연합회 회장 선출
4th row주영위 경북대 국악과 전임강사 임용
5th row조상현 전남도립 남도대학 국악과 겸임교수 임용
ValueCountFrequency (%)
수상 65
 
1.7%
40
 
1.1%
별세 31
 
0.8%
개관 28
 
0.7%
피아니스트 19
 
0.5%
18
 
0.5%
18
 
0.5%
선출 16
 
0.4%
교수 16
 
0.4%
위촉 16
 
0.4%
Other values (2481) 3474
92.9%
2023-12-13T01:18:15.983178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3381
 
18.9%
313
 
1.7%
298
 
1.7%
274
 
1.5%
244
 
1.4%
233
 
1.3%
, 226
 
1.3%
216
 
1.2%
210
 
1.2%
189
 
1.1%
Other values (631) 12321
68.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12789
71.4%
Space Separator 3381
 
18.9%
Decimal Number 633
 
3.5%
Other Punctuation 393
 
2.2%
Close Punctuation 196
 
1.1%
Open Punctuation 193
 
1.1%
Uppercase Letter 108
 
0.6%
Initial Punctuation 56
 
0.3%
Final Punctuation 53
 
0.3%
Math Symbol 42
 
0.2%
Other values (4) 61
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
313
 
2.4%
298
 
2.3%
274
 
2.1%
244
 
1.9%
233
 
1.8%
216
 
1.7%
210
 
1.6%
189
 
1.5%
188
 
1.5%
185
 
1.4%
Other values (552) 10439
81.6%
Uppercase Letter
ValueCountFrequency (%)
S 18
16.7%
K 17
15.7%
B 15
13.9%
M 12
11.1%
A 7
 
6.5%
C 6
 
5.6%
H 4
 
3.7%
P 4
 
3.7%
L 3
 
2.8%
N 3
 
2.8%
Other values (11) 19
17.6%
Lowercase Letter
ValueCountFrequency (%)
r 5
14.7%
i 4
11.8%
a 4
11.8%
t 4
11.8%
o 3
8.8%
e 3
8.8%
h 1
 
2.9%
x 1
 
2.9%
l 1
 
2.9%
d 1
 
2.9%
Other values (7) 7
20.6%
Decimal Number
ValueCountFrequency (%)
0 135
21.3%
1 131
20.7%
2 111
17.5%
5 49
 
7.7%
4 48
 
7.6%
3 44
 
7.0%
6 39
 
6.2%
9 29
 
4.6%
8 29
 
4.6%
7 18
 
2.8%
Other Punctuation
ValueCountFrequency (%)
, 226
57.5%
. 97
24.7%
/ 39
 
9.9%
10
 
2.5%
' 6
 
1.5%
% 6
 
1.5%
: 5
 
1.3%
& 4
 
1.0%
Open Punctuation
ValueCountFrequency (%)
180
93.3%
( 10
 
5.2%
1
 
0.5%
1
 
0.5%
1
 
0.5%
Math Symbol
ValueCountFrequency (%)
= 15
35.7%
13
31.0%
11
26.2%
> 2
 
4.8%
< 1
 
2.4%
Close Punctuation
ValueCountFrequency (%)
183
93.4%
) 10
 
5.1%
2
 
1.0%
1
 
0.5%
Initial Punctuation
ValueCountFrequency (%)
54
96.4%
2
 
3.6%
Other Symbol
ValueCountFrequency (%)
6
60.0%
4
40.0%
Letter Number
ValueCountFrequency (%)
1
50.0%
1
50.0%
Space Separator
ValueCountFrequency (%)
3381
100.0%
Final Punctuation
ValueCountFrequency (%)
53
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12781
71.4%
Common 4972
 
27.8%
Latin 144
 
0.8%
Han 8
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
313
 
2.4%
298
 
2.3%
274
 
2.1%
244
 
1.9%
233
 
1.8%
216
 
1.7%
210
 
1.6%
189
 
1.5%
188
 
1.5%
185
 
1.4%
Other values (545) 10431
81.6%
Latin
ValueCountFrequency (%)
S 18
 
12.5%
K 17
 
11.8%
B 15
 
10.4%
M 12
 
8.3%
A 7
 
4.9%
C 6
 
4.2%
r 5
 
3.5%
H 4
 
2.8%
i 4
 
2.8%
a 4
 
2.8%
Other values (30) 52
36.1%
Common
ValueCountFrequency (%)
3381
68.0%
, 226
 
4.5%
183
 
3.7%
180
 
3.6%
0 135
 
2.7%
1 131
 
2.6%
2 111
 
2.2%
. 97
 
2.0%
54
 
1.1%
53
 
1.1%
Other values (29) 421
 
8.5%
Han
ValueCountFrequency (%)
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12781
71.4%
ASCII 4592
 
25.6%
None 393
 
2.2%
Punctuation 119
 
0.7%
Geometric Shapes 10
 
0.1%
CJK 8
 
< 0.1%
Number Forms 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3381
73.6%
, 226
 
4.9%
0 135
 
2.9%
1 131
 
2.9%
2 111
 
2.4%
. 97
 
2.1%
5 49
 
1.1%
4 48
 
1.0%
3 44
 
1.0%
6 39
 
0.8%
Other values (52) 331
 
7.2%
Hangul
ValueCountFrequency (%)
313
 
2.4%
298
 
2.3%
274
 
2.1%
244
 
1.9%
233
 
1.8%
216
 
1.7%
210
 
1.6%
189
 
1.5%
188
 
1.5%
185
 
1.4%
Other values (545) 10431
81.6%
None
ValueCountFrequency (%)
183
46.6%
180
45.8%
13
 
3.3%
11
 
2.8%
2
 
0.5%
1
 
0.3%
1
 
0.3%
1
 
0.3%
1
 
0.3%
Punctuation
ValueCountFrequency (%)
54
45.4%
53
44.5%
10
 
8.4%
2
 
1.7%
Geometric Shapes
ValueCountFrequency (%)
6
60.0%
4
40.0%
CJK
ValueCountFrequency (%)
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
Number Forms
ValueCountFrequency (%)
1
50.0%
1
50.0%

비고
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing341
Missing (%)92.7%
Memory size3.0 KiB
2023-12-13T01:18:16.309703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length75
Median length22
Mean length17.296296
Min length2

Characters and Unicode

Total characters467
Distinct characters162
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row경기도문화예술회관
2nd row예술의전당 서예관 허은무(바이올린), 심윤 숙(첼로)-신인음악상, 음악저널
3rd row미국 필라델피아
4th row세종문화회관 세종홀 한국음악비평가협회
5th row루이빌 대학
ValueCountFrequency (%)
금호문화재단 3
 
2.9%
세종문화회관 3
 
2.9%
미국 2
 
1.9%
세종홀 2
 
1.9%
금호아트갤러리 2
 
1.9%
경기 2
 
1.9%
경기도문화예술회관 1
 
1.0%
국제현대음악협회 1
 
1.0%
제네바 1
 
1.0%
1
 
1.0%
Other values (85) 85
82.5%
2023-12-13T01:18:16.832682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
80
 
17.1%
13
 
2.8%
11
 
2.4%
, 10
 
2.1%
8
 
1.7%
8
 
1.7%
8
 
1.7%
7
 
1.5%
7
 
1.5%
7
 
1.5%
Other values (152) 308
66.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 356
76.2%
Space Separator 80
 
17.1%
Other Punctuation 10
 
2.1%
Decimal Number 8
 
1.7%
Open Punctuation 5
 
1.1%
Close Punctuation 5
 
1.1%
Dash Punctuation 1
 
0.2%
Final Punctuation 1
 
0.2%
Initial Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
13
 
3.7%
11
 
3.1%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
2.0%
7
 
2.0%
7
 
2.0%
7
 
2.0%
6
 
1.7%
Other values (142) 274
77.0%
Decimal Number
ValueCountFrequency (%)
1 4
50.0%
2 2
25.0%
0 2
25.0%
Space Separator
ValueCountFrequency (%)
80
100.0%
Other Punctuation
ValueCountFrequency (%)
, 10
100.0%
Open Punctuation
ValueCountFrequency (%)
5
100.0%
Close Punctuation
ValueCountFrequency (%)
5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Final Punctuation
ValueCountFrequency (%)
1
100.0%
Initial Punctuation
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 356
76.2%
Common 111
 
23.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
13
 
3.7%
11
 
3.1%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
2.0%
7
 
2.0%
7
 
2.0%
7
 
2.0%
6
 
1.7%
Other values (142) 274
77.0%
Common
ValueCountFrequency (%)
80
72.1%
, 10
 
9.0%
5
 
4.5%
5
 
4.5%
1 4
 
3.6%
2 2
 
1.8%
0 2
 
1.8%
- 1
 
0.9%
1
 
0.9%
1
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 356
76.2%
ASCII 99
 
21.2%
None 10
 
2.1%
Punctuation 2
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
80
80.8%
, 10
 
10.1%
1 4
 
4.0%
2 2
 
2.0%
0 2
 
2.0%
- 1
 
1.0%
Hangul
ValueCountFrequency (%)
13
 
3.7%
11
 
3.1%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
2.0%
7
 
2.0%
7
 
2.0%
7
 
2.0%
6
 
1.7%
Other values (142) 274
77.0%
None
ValueCountFrequency (%)
5
50.0%
5
50.0%
Punctuation
ValueCountFrequency (%)
1
50.0%
1
50.0%

Interactions

2023-12-13T01:18:12.834417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:18:12.629481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:18:12.951520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:18:12.731037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:18:16.958977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도비고
연번1.0000.9961.000
연도0.9961.000NaN
비고1.000NaN1.000
2023-12-13T01:18:17.065377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도
연번1.0000.981
연도0.9811.000

Missing values

2023-12-13T01:18:13.388869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:18:13.475819image/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

연번연도일자내용비고
0120002000-01-03한상일 국립국악관현악단장 겸 예술감독 위촉<NA>
1220002000-01-03안숙선 국립창극단장 위촉<NA>
2320002000-02-25이성림 한국예술문화단체총연합회 회장 선출<NA>
3420002000-03-02주영위 경북대 국악과 전임강사 임용<NA>
4520002000-03-02조상현 전남도립 남도대학 국악과 겸임교수 임용<NA>
5620002000-03-02윤명원 단국대 국악과 조교수 임용<NA>
6720002000-03-02안성우 영남대 국악과 조교수 임용<NA>
7820002000-03-16여성국극 창시자 임춘앵 25기 추모제<NA>
8920002000-03-25박찬범 무형문화재 기능보유자 지정<NA>
91020002000-03-25풀피리 서울시 무형문화재 지정<NA>
연번연도일자내용비고
35835920052005-12-00한국메세나협의회 2006 문화나눔사업 각 예술분야 채용 계획 한국메세나협의회 보육원 아이들의 변화를 돕는 선생님 역할로 음악을 비롯한 예술 각 분야 250명 채용 공고<NA>
35936020052005-12-00관객 참여형 <메시아> 공연 예술의전당에서 열리는 서울 모테트 합창단 송년공연 <메시아>에서 합창석에서 관객으로 참관하다가 합창단으로 들어오는 열린공연 시도<NA>
36036120052005-12-08음악저작권협회 ‘소리바다2, 3’에 대해 소송 음악저작권협회 ‘소리바다’ 개발자 양정환 형제에 대해 후속프로그램인 ‘소리바다 2, 3’도 저작권을 침해했다고 27억여원 손해배상 청구<NA>
36136220052005-12-16한국음악비평가협회 제13회 음악대상 수상자 충무아트홀에서 한국음악비평가협회가 제13회 음악대상 수상자로 박은성(지휘자) 선정, 시상<NA>
36236320052005-12-00나유창(바리톤), 독일쾰른음대 교수 공채 나유창( 성악가 - 바리톤)이 쾰른음대에 한국인 교수로 임용<NA>
36336420052005-12-00(사)한국예술실연자단체연합회, 아시아나 항공 형사고소 (사)한국예술실연자단체연합회, 아시아나항공이 신탁관리하고 있는 음악을 무단으로 탑승 승객에게 제공한 혐의로 형사 고소<NA>
36436520052005-12-00임형주(테너) 일본 방송에 출연 성악가 임형주 일본의 연말 최대 가요 축제인 NHK ‘홍백가합전’에 출연.<NA>
36536620052005-12-01광주시민방송국 개국 광주 북구 주민들을 대상으로 소출력 방송 광주시민방송국 개국<NA>
36636720052005-12-07~2005-12-09제3회 2006 문화예술교육박람회 성남아트센터 콘서트홀에서 한국문화예술 위원회 주최로 문화예술 교육 박람회 열려 문화예술 교육에 관련된 프로그램의 기획자와 문예회관, 문화의집 관계자, 교사, 학생 등 문화예술에 참여하는 주체들이 서로의 경험과 생각을 나누는 교류의 장을 가짐<NA>
36736820052005-00-00오페라 <투란도트> 최장 공연 기록 오페라 <투란도트> 15회로 국내 최장기 공연 기록 수립.<NA>