Overview

Dataset statistics

Number of variables15
Number of observations1513
Missing cells6050
Missing cells (%)26.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory178.9 KiB
Average record size in memory121.1 B

Variable types

Numeric1
Categorical4
Text6
DateTime4

Dataset

Description공연일련번호,공연구분1,공연구분2,공연구분3,공연명,공연장소,공연일시,티켓가격,곡목,프로그램소개,공연이미지URL,유료회원 일반 예매시작일,무료회원 일반 예매시작일,아티스트사전,등록일시
Author서울시립교향악단
URLhttps://data.seoul.go.kr/dataList/OA-13624/S/1/datasetView.do

Alerts

공연구분3 is highly overall correlated with 공연구분1 and 2 other fieldsHigh correlation
공연구분1 is highly overall correlated with 공연구분2 and 2 other fieldsHigh correlation
공연구분2 is highly overall correlated with 공연구분1 and 2 other fieldsHigh correlation
티켓가격 is highly overall correlated with 공연구분1 and 2 other fieldsHigh correlation
공연구분3 is highly imbalanced (85.2%)Imbalance
티켓가격 is highly imbalanced (52.0%)Imbalance
공연명 has 309 (20.4%) missing valuesMissing
공연장소 has 1420 (93.9%) missing valuesMissing
곡목 has 874 (57.8%) missing valuesMissing
프로그램소개 has 1298 (85.8%) missing valuesMissing
공연이미지URL has 50 (3.3%) missing valuesMissing
유료회원 일반 예매시작일 has 640 (42.3%) missing valuesMissing
무료회원 일반 예매시작일 has 640 (42.3%) missing valuesMissing
아티스트사전 has 819 (54.1%) missing valuesMissing
공연일련번호 has unique valuesUnique

Reproduction

Analysis started2024-05-18 03:05:46.358861
Analysis finished2024-05-18 03:05:51.323256
Duration4.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공연일련번호
Real number (ℝ)

UNIQUE 

Distinct1513
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3602.7217
Minimum1099
Maximum6219
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.4 KiB
2024-05-18T12:05:51.749140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1099
5-th percentile2657.6
Q12960
median3344
Q33733
95-th percentile5857.8
Maximum6219
Range5120
Interquartile range (IQR)773

Descriptive statistics

Standard deviation1042.2434
Coefficient of variation (CV)0.28929335
Kurtosis0.59002319
Mean3602.7217
Median Absolute Deviation (MAD)387
Skewness0.76009856
Sum5450918
Variance1086271.4
MonotonicityNot monotonic
2024-05-18T12:05:52.351048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6219 1
 
0.1%
3075 1
 
0.1%
3095 1
 
0.1%
3061 1
 
0.1%
3071 1
 
0.1%
3112 1
 
0.1%
3074 1
 
0.1%
3080 1
 
0.1%
3105 1
 
0.1%
3073 1
 
0.1%
Other values (1503) 1503
99.3%
ValueCountFrequency (%)
1099 1
0.1%
1117 1
0.1%
1118 1
0.1%
1120 1
0.1%
1154 1
0.1%
1164 1
0.1%
1165 1
0.1%
1167 1
0.1%
1169 1
0.1%
1170 1
0.1%
ValueCountFrequency (%)
6219 1
0.1%
6217 1
0.1%
6215 1
0.1%
6213 1
0.1%
6211 1
0.1%
6209 1
0.1%
6193 1
0.1%
6191 1
0.1%
6189 1
0.1%
6171 1
0.1%

공연구분1
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size11.9 KiB
시민공연
818 
정기공연
617 
교육공연
 
37
순회공연
 
21
외부공연
 
20

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row시민공연
2nd row교육공연
3rd row교육공연
4th row시민공연
5th row시민공연

Common Values

ValueCountFrequency (%)
시민공연 818
54.1%
정기공연 617
40.8%
교육공연 37
 
2.4%
순회공연 21
 
1.4%
외부공연 20
 
1.3%

Length

2024-05-18T12:05:52.857382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T12:05:53.358623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시민공연 818
54.1%
정기공연 617
40.8%
교육공연 37
 
2.4%
순회공연 21
 
1.4%
외부공연 20
 
1.3%

공연구분2
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size11.9 KiB
찾아가는음악회
671 
관현악
569 
특별공연
109 
실내악
89 
기획공연
 
38
Other values (4)
 
37

Length

Max length7
Median length5
Mean length4.9193655
Min length3

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row찾아가는음악회
2nd row청소년교육
3rd row청소년교육
4th row찾아가는음악회
5th row찾아가는음악회

Common Values

ValueCountFrequency (%)
찾아가는음악회 671
44.3%
관현악 569
37.6%
특별공연 109
 
7.2%
실내악 89
 
5.9%
기획공연 38
 
2.5%
일반인교육 22
 
1.5%
청소년교육 12
 
0.8%
영유아교육 2
 
0.1%
<NA> 1
 
0.1%

Length

2024-05-18T12:05:53.880825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T12:05:54.332779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
찾아가는음악회 671
44.3%
관현악 569
37.6%
특별공연 109
 
7.2%
실내악 89
 
5.9%
기획공연 38
 
2.5%
일반인교육 22
 
1.5%
청소년교육 12
 
0.8%
영유아교육 2
 
0.1%
na 1
 
0.1%

공연구분3
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct14
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size11.9 KiB
<NA>
1402 
우리동네음악회실내악
 
58
우리동네음악회관현악
 
12
퇴근길토크콘서트
 
9
순회공연
 
7
Other values (9)
 
25

Length

Max length12
Median length4
Mean length4.3536021
Min length3

Unique

Unique1 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 1402
92.7%
우리동네음악회실내악 58
 
3.8%
우리동네음악회관현악 12
 
0.8%
퇴근길토크콘서트 9
 
0.6%
순회공연 7
 
0.5%
행복한 음악회, 함께! 6
 
0.4%
음악이야기 4
 
0.3%
음악회 3
 
0.2%
강변음악회 3
 
0.2%
SPO Day 2
 
0.1%
Other values (4) 7
 
0.5%

Length

2024-05-18T12:05:54.811098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 1402
91.6%
우리동네음악회실내악 58
 
3.8%
우리동네음악회관현악 12
 
0.8%
퇴근길토크콘서트 9
 
0.6%
음악회 9
 
0.6%
순회공연 7
 
0.5%
행복한 6
 
0.4%
함께 6
 
0.4%
음악이야기 4
 
0.3%
강변음악회 3
 
0.2%
Other values (8) 15
 
1.0%

공연명
Text

MISSING 

Distinct899
Distinct (%)74.7%
Missing309
Missing (%)20.4%
Memory size11.9 KiB
2024-05-18T12:05:56.004634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length92
Median length67
Mean length32.630399
Min length1

Characters and Unicode

Total characters39287
Distinct characters115
Distinct categories17 ?
Distinct scripts3 ?
Distinct blocks6 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique821 ?
Unique (%)68.2%

Sample

1st rowSPO Park Concert 2024
2nd rowKids Concert with Seoul Philharmonic Orchestra 2024
3rd rowKids Concert with Seoul Philharmonic Orchestra 2024
4th row2024 SPO Museum Concert
5th row2024 SPO Museum Concert
ValueCountFrequency (%)
concert 342
 
5.8%
chamber 326
 
5.5%
neighborhood 218
 
3.7%
215
 
3.7%
music 214
 
3.6%
spo 179
 
3.0%
series 165
 
2.8%
① 110
 
1.9%
② 109
 
1.9%
symphony 81
 
1.4%
Other values (942) 3922
66.7%
2024-05-18T12:05:57.489382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4771
 
12.1%
e 2611
 
6.6%
o 2071
 
5.3%
r 2052
 
5.2%
h 1470
 
3.7%
a 1422
 
3.6%
n 1392
 
3.5%
i 1347
 
3.4%
S 1264
 
3.2%
s 1230
 
3.1%
Other values (105) 19657
50.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 20610
52.5%
Uppercase Letter 11574
29.5%
Space Separator 4771
 
12.1%
Decimal Number 1055
 
2.7%
Other Punctuation 445
 
1.1%
Dash Punctuation 314
 
0.8%
Other Number 223
 
0.6%
Final Punctuation 143
 
0.4%
Letter Number 50
 
0.1%
Other Letter 29
 
0.1%
Other values (7) 73
 
0.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 2611
12.7%
o 2071
10.0%
r 2052
10.0%
h 1470
 
7.1%
a 1422
 
6.9%
n 1392
 
6.8%
i 1347
 
6.5%
s 1230
 
6.0%
t 1120
 
5.4%
c 1098
 
5.3%
Other values (17) 4797
23.3%
Uppercase Letter
ValueCountFrequency (%)
S 1264
10.9%
C 1206
 
10.4%
O 920
 
7.9%
N 904
 
7.8%
E 851
 
7.4%
I 753
 
6.5%
A 706
 
6.1%
R 642
 
5.5%
M 589
 
5.1%
T 583
 
5.0%
Other values (17) 3156
27.3%
Other Letter
ValueCountFrequency (%)
시 5
17.2%
악 3
10.3%
향 3
10.3%
울 3
10.3%
서 3
10.3%
즈 2
 
6.9%
리 2
 
6.9%
내 2
 
6.9%
실 2
 
6.9%
특 1
 
3.4%
Other values (3) 3
10.3%
Decimal Number
ValueCountFrequency (%)
2 495
46.9%
0 254
24.1%
1 93
 
8.8%
3 78
 
7.4%
4 65
 
6.2%
7 18
 
1.7%
9 15
 
1.4%
6 13
 
1.2%
8 12
 
1.1%
5 12
 
1.1%
Other Punctuation
ValueCountFrequency (%)
: 165
37.1%
' 79
17.8%
? 69
15.5%
. 55
 
12.4%
, 28
 
6.3%
! 25
 
5.6%
& 23
 
5.2%
… 1
 
0.2%
Letter Number
ValueCountFrequency (%)
Ⅲ 13
26.0%
Ⅱ 13
26.0%
Ⅳ 9
18.0%
Ⅰ 8
16.0%
Ⅴ 3
 
6.0%
Ⅵ 2
 
4.0%
Ⅷ 1
 
2.0%
Ⅶ 1
 
2.0%
Other Number
ValueCountFrequency (%)
② 110
49.3%
① 110
49.3%
③ 2
 
0.9%
④ 1
 
0.4%
Close Punctuation
ValueCountFrequency (%)
] 13
61.9%
) 7
33.3%
」 1
 
4.8%
Open Punctuation
ValueCountFrequency (%)
[ 13
61.9%
( 7
33.3%
「 1
 
4.8%
Math Symbol
ValueCountFrequency (%)
+ 5
45.5%
< 3
27.3%
> 3
27.3%
Final Punctuation
ValueCountFrequency (%)
’ 141
98.6%
” 2
 
1.4%
Initial Punctuation
ValueCountFrequency (%)
‘ 3
60.0%
“ 2
40.0%
Space Separator
ValueCountFrequency (%)
4771
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 314
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 12
100.0%
Other Symbol
ValueCountFrequency (%)
° 2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 32234
82.0%
Common 7024
 
17.9%
Hangul 29
 
0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 2611
 
8.1%
o 2071
 
6.4%
r 2052
 
6.4%
h 1470
 
4.6%
a 1422
 
4.4%
n 1392
 
4.3%
i 1347
 
4.2%
S 1264
 
3.9%
s 1230
 
3.8%
C 1206
 
3.7%
Other values (52) 16169
50.2%
Common
ValueCountFrequency (%)
4771
67.9%
2 495
 
7.0%
- 314
 
4.5%
0 254
 
3.6%
: 165
 
2.3%
’ 141
 
2.0%
② 110
 
1.6%
① 110
 
1.6%
1 93
 
1.3%
' 79
 
1.1%
Other values (30) 492
 
7.0%
Hangul
ValueCountFrequency (%)
시 5
17.2%
악 3
10.3%
향 3
10.3%
울 3
10.3%
서 3
10.3%
즈 2
 
6.9%
리 2
 
6.9%
내 2
 
6.9%
실 2
 
6.9%
특 1
 
3.4%
Other values (3) 3
10.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 38827
98.8%
Enclosed Alphanum 223
 
0.6%
Punctuation 149
 
0.4%
Number Forms 50
 
0.1%
Hangul 29
 
0.1%
None 9
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4771
 
12.3%
e 2611
 
6.7%
o 2071
 
5.3%
r 2052
 
5.3%
h 1470
 
3.8%
a 1422
 
3.7%
n 1392
 
3.6%
i 1347
 
3.5%
S 1264
 
3.3%
s 1230
 
3.2%
Other values (70) 19197
49.4%
Punctuation
ValueCountFrequency (%)
’ 141
94.6%
‘ 3
 
2.0%
“ 2
 
1.3%
” 2
 
1.3%
… 1
 
0.7%
Enclosed Alphanum
ValueCountFrequency (%)
② 110
49.3%
① 110
49.3%
③ 2
 
0.9%
④ 1
 
0.4%
Number Forms
ValueCountFrequency (%)
Ⅲ 13
26.0%
Ⅱ 13
26.0%
Ⅳ 9
18.0%
Ⅰ 8
16.0%
Ⅴ 3
 
6.0%
Ⅵ 2
 
4.0%
Ⅷ 1
 
2.0%
Ⅶ 1
 
2.0%
Hangul
ValueCountFrequency (%)
시 5
17.2%
악 3
10.3%
향 3
10.3%
울 3
10.3%
서 3
10.3%
즈 2
 
6.9%
리 2
 
6.9%
내 2
 
6.9%
실 2
 
6.9%
특 1
 
3.4%
Other values (3) 3
10.3%
None
ValueCountFrequency (%)
Ø 3
33.3%
° 2
22.2%
ø 2
22.2%
」 1
 
11.1%
「 1
 
11.1%

공연장소
Text

MISSING 

Distinct78
Distinct (%)83.9%
Missing1420
Missing (%)93.9%
Memory size11.9 KiB
2024-05-18T12:05:58.404341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length35
Mean length22.44086
Min length4

Characters and Unicode

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

Unique

Unique66 ?
Unique (%)71.0%

Sample

1st rowFamily yard
2nd rowSongpa Book Museum
3rd rowSeoul Museum of Craft Art
4th rowBuk Seoul Museum of Art
5th rowKorea War memorial
ValueCountFrequency (%)
center 20
 
6.2%
seoul 18
 
5.6%
hall 17
 
5.3%
museum 14
 
4.4%
art 12
 
3.7%
of 11
 
3.4%
arts 10
 
3.1%
korea 7
 
2.2%
university 5
 
1.6%
lg 4
 
1.2%
Other values (139) 203
63.2%
2024-05-18T12:06:00.074491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
229
 
11.0%
e 163
 
7.8%
a 133
 
6.4%
o 125
 
6.0%
n 115
 
5.5%
r 109
 
5.2%
u 105
 
5.0%
t 96
 
4.6%
l 87
 
4.2%
i 62
 
3.0%
Other values (84) 863
41.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1334
63.9%
Uppercase Letter 440
 
21.1%
Space Separator 229
 
11.0%
Other Letter 74
 
3.5%
Dash Punctuation 5
 
0.2%
Decimal Number 3
 
0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
관 6
 
8.1%
물 5
 
6.8%
박 5
 
6.8%
당 4
 
5.4%
예 3
 
4.1%
공 3
 
4.1%
마 3
 
4.1%
비 3
 
4.1%
로 3
 
4.1%
회 2
 
2.7%
Other values (28) 37
50.0%
Lowercase Letter
ValueCountFrequency (%)
e 163
12.2%
a 133
10.0%
o 125
9.4%
n 115
8.6%
r 109
 
8.2%
u 105
 
7.9%
t 96
 
7.2%
l 87
 
6.5%
i 62
 
4.6%
s 56
 
4.2%
Other values (17) 283
21.2%
Uppercase Letter
ValueCountFrequency (%)
S 49
 
11.1%
C 43
 
9.8%
A 40
 
9.1%
H 29
 
6.6%
G 27
 
6.1%
R 27
 
6.1%
E 26
 
5.9%
M 26
 
5.9%
L 26
 
5.9%
N 24
 
5.5%
Other values (13) 123
28.0%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
6 1
33.3%
Space Separator
ValueCountFrequency (%)
229
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1774
85.0%
Common 239
 
11.5%
Hangul 74
 
3.5%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 163
 
9.2%
a 133
 
7.5%
o 125
 
7.0%
n 115
 
6.5%
r 109
 
6.1%
u 105
 
5.9%
t 96
 
5.4%
l 87
 
4.9%
i 62
 
3.5%
s 56
 
3.2%
Other values (40) 723
40.8%
Hangul
ValueCountFrequency (%)
관 6
 
8.1%
물 5
 
6.8%
박 5
 
6.8%
당 4
 
5.4%
예 3
 
4.1%
공 3
 
4.1%
마 3
 
4.1%
비 3
 
4.1%
로 3
 
4.1%
회 2
 
2.7%
Other values (28) 37
50.0%
Common
ValueCountFrequency (%)
229
95.8%
- 5
 
2.1%
1 2
 
0.8%
( 1
 
0.4%
) 1
 
0.4%
6 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2010
96.3%
Hangul 74
 
3.5%
None 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
229
 
11.4%
e 163
 
8.1%
a 133
 
6.6%
o 125
 
6.2%
n 115
 
5.7%
r 109
 
5.4%
u 105
 
5.2%
t 96
 
4.8%
l 87
 
4.3%
i 62
 
3.1%
Other values (45) 786
39.1%
Hangul
ValueCountFrequency (%)
관 6
 
8.1%
물 5
 
6.8%
박 5
 
6.8%
당 4
 
5.4%
예 3
 
4.1%
공 3
 
4.1%
마 3
 
4.1%
비 3
 
4.1%
로 3
 
4.1%
회 2
 
2.7%
Other values (28) 37
50.0%
None
ValueCountFrequency (%)
ß 3
100.0%

공연일시
Date

Distinct1486
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size11.9 KiB
Minimum2009-03-01 17:00:00
Maximum2024-12-20 20:00:00
2024-05-18T12:06:00.738587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:06:01.226499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

티켓가격
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct39
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size11.9 KiB
<NA>
870 
70,000(R), 50,000(S), 30,000(A), 20,000(B), 10,000(C)
178 
90,000(R), 70,000(S), 50,000(A), 30,000(B), 10,000(C)
 
81
120,000(R), 90,000(S), 60,000(A), 30,000(B), 10,000(C)
 
79
50,000(R), 30,000(S), 10,000(A)
 
55
Other values (34)
250 

Length

Max length56
Median length4
Mean length21.339061
Min length4

Unique

Unique14 ?
Unique (%)0.9%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 870
57.5%
70,000(R), 50,000(S), 30,000(A), 20,000(B), 10,000(C) 178
 
11.8%
90,000(R), 70,000(S), 50,000(A), 30,000(B), 10,000(C) 81
 
5.4%
120,000(R), 90,000(S), 60,000(A), 30,000(B), 10,000(C) 79
 
5.2%
50,000(R), 30,000(S), 10,000(A) 55
 
3.6%
50,000(R), 30,000(S), 20,000(A), 10,000(B) 38
 
2.5%
30,000(R), 20,000(S), 10,000(A) 35
 
2.3%
100,000(R), 80,000(S), 50,000(A), 30,000(B), 10,000(C) 33
 
2.2%
10,000(전체) 23
 
1.5%
20,000(전체) 17
 
1.1%
Other values (29) 104
 
6.9%

Length

2024-05-18T12:06:01.692379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 870
24.2%
10,000(c 412
11.5%
30,000(a 210
 
5.8%
30,000(b 203
 
5.7%
20,000(b 197
 
5.5%
70,000(r 188
 
5.2%
50,000(s 182
 
5.1%
50,000(a 124
 
3.5%
10,000(a 116
 
3.2%
50,000(r 97
 
2.7%
Other values (49) 991
27.6%

곡목
Text

MISSING 

Distinct461
Distinct (%)72.1%
Missing874
Missing (%)57.8%
Memory size11.9 KiB
2024-05-18T12:06:02.638905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length422
Median length189
Mean length91.492958
Min length6

Characters and Unicode

Total characters58464
Distinct characters93
Distinct categories14 ?
Distinct scripts3 ?
Distinct blocks6 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique319 ?
Unique (%)49.9%

Sample

1st rowViolin Concerto No. 3 in G major, K. 216,Symphony No. 1 in C major Op. 21,Fr?hlingsstimmen, Op.410
2nd rowSymphony No. 40 in G minor, K.550,Die Walk?re, WWV 86B: Act 1
3rd rowPiano Concerto No. 1 in E-flat major, S. 124,Espa?a ,Romanian Rhapsody No. 1,Hungarian Rhapsody No. 2
4th rowSymphony No. 8 in G Major, Op. 88,Tzigane,Capriccio Italien, Op.45,Zigeunerweisen, Op. 20
5th rowPiano Concerto No. 5, Op. 73 &#39;Emperor&#39;,Symphony No. 1 ‘Titan’
ValueCountFrequency (%)
op 706
 
7.3%
in 700
 
7.2%
no 601
 
6.2%
minor 333
 
3.4%
concerto 317
 
3.3%
major 314
 
3.2%
for 254
 
2.6%
symphony 236
 
2.4%
d 184
 
1.9%
and 181
 
1.9%
Other values (1625) 5872
60.5%
2024-05-18T12:06:04.424112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9148
 
15.6%
o 4674
 
8.0%
n 3796
 
6.5%
e 3343
 
5.7%
r 3343
 
5.7%
i 3040
 
5.2%
a 2539
 
4.3%
, 2023
 
3.5%
t 1894
 
3.2%
m 1595
 
2.7%
Other values (83) 23069
39.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 34609
59.2%
Space Separator 9148
 
15.6%
Uppercase Letter 6380
 
10.9%
Other Punctuation 4162
 
7.1%
Decimal Number 3462
 
5.9%
Open Punctuation 143
 
0.2%
Close Punctuation 143
 
0.2%
Final Punctuation 140
 
0.2%
Dash Punctuation 131
 
0.2%
Initial Punctuation 110
 
0.2%
Other values (4) 36
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 4674
13.5%
n 3796
11.0%
e 3343
9.7%
r 3343
9.7%
i 3040
 
8.8%
a 2539
 
7.3%
t 1894
 
5.5%
m 1595
 
4.6%
p 1538
 
4.4%
l 1186
 
3.4%
Other values (16) 7661
22.1%
Uppercase Letter
ValueCountFrequency (%)
O 917
14.4%
S 807
12.6%
N 685
10.7%
C 667
10.5%
P 385
 
6.0%
D 314
 
4.9%
V 259
 
4.1%
T 249
 
3.9%
E 241
 
3.8%
F 225
 
3.5%
Other values (16) 1631
25.6%
Other Punctuation
ValueCountFrequency (%)
, 2023
48.6%
. 1593
38.3%
& 111
 
2.7%
# 100
 
2.4%
; 98
 
2.4%
: 72
 
1.7%
? 60
 
1.4%
' 39
 
0.9%
* 35
 
0.8%
/ 22
 
0.5%
Other values (3) 9
 
0.2%
Decimal Number
ValueCountFrequency (%)
1 627
18.1%
2 437
12.6%
3 426
12.3%
5 349
10.1%
9 342
9.9%
4 328
9.5%
0 254
7.3%
6 246
 
7.1%
7 244
 
7.0%
8 209
 
6.0%
Other Letter
ValueCountFrequency (%)
곡 1
25.0%
목 1
25.0%
변 1
25.0%
경 1
25.0%
Open Punctuation
ValueCountFrequency (%)
( 139
97.2%
[ 4
 
2.8%
Close Punctuation
ValueCountFrequency (%)
) 139
97.2%
] 4
 
2.8%
Final Punctuation
ValueCountFrequency (%)
’ 131
93.6%
” 9
 
6.4%
Dash Punctuation
ValueCountFrequency (%)
- 129
98.5%
― 2
 
1.5%
Initial Punctuation
ValueCountFrequency (%)
‘ 101
91.8%
“ 9
 
8.2%
Space Separator
ValueCountFrequency (%)
9148
100.0%
Other Symbol
ValueCountFrequency (%)
♭ 29
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 40990
70.1%
Common 17470
29.9%
Hangul 4
 
< 0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 4674
 
11.4%
n 3796
 
9.3%
e 3343
 
8.2%
r 3343
 
8.2%
i 3040
 
7.4%
a 2539
 
6.2%
t 1894
 
4.6%
m 1595
 
3.9%
p 1538
 
3.8%
l 1186
 
2.9%
Other values (43) 14042
34.3%
Common
ValueCountFrequency (%)
9148
52.4%
, 2023
 
11.6%
. 1593
 
9.1%
1 627
 
3.6%
2 437
 
2.5%
3 426
 
2.4%
5 349
 
2.0%
9 342
 
2.0%
4 328
 
1.9%
0 254
 
1.5%
Other values (26) 1943
 
11.1%
Hangul
ValueCountFrequency (%)
곡 1
25.0%
목 1
25.0%
변 1
25.0%
경 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 58173
99.5%
Punctuation 253
 
0.4%
Misc Symbols 29
 
< 0.1%
None 4
 
< 0.1%
Hangul 4
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9148
15.7%
o 4674
 
8.0%
n 3796
 
6.5%
e 3343
 
5.7%
r 3343
 
5.7%
i 3040
 
5.2%
a 2539
 
4.4%
, 2023
 
3.5%
t 1894
 
3.3%
m 1595
 
2.7%
Other values (70) 22778
39.2%
Punctuation
ValueCountFrequency (%)
’ 131
51.8%
‘ 101
39.9%
” 9
 
3.6%
“ 9
 
3.6%
― 2
 
0.8%
… 1
 
0.4%
Misc Symbols
ValueCountFrequency (%)
♭ 29
100.0%
None
ValueCountFrequency (%)
？ 4
100.0%
Hangul
ValueCountFrequency (%)
곡 1
25.0%
목 1
25.0%
변 1
25.0%
경 1
25.0%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

프로그램소개
Text

MISSING 

Distinct176
Distinct (%)81.9%
Missing1298
Missing (%)85.8%
Memory size11.9 KiB
2024-05-18T12:06:05.242950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length1024
Median length1024
Mean length964.92558
Min length1

Characters and Unicode

Total characters207459
Distinct characters1108
Distinct categories15 ?
Distinct scripts4 ?
Distinct blocks8 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique138 ?
Unique (%)64.2%

Sample

1st rowSupp?, Light Cavalry Overture (8’)주페, 경기병&nbsp;서곡프란츠 폰 주페(1819~1895)는 오스트리아의 작곡가로, 극장용 음악을 주로 썼다. &lt;경기병&gt;은 그가 1866년에 쓴 오페레타로, 오늘날에는 ‘서곡’만이 꾸준히 연주되고 있다. 용감한 경기병을 암시하는 금관 팡파르로 시작해 오페레타에 나오는 선율 다섯 가지가 차례로 등장하면서 경쾌한 분위기를 이어간다. &nbsp; Sarasate, Navarra, Op. 33 (10’)사라사테, 나바라 *바이올린 : 엄성용, 주연경사라사테는 자신의 고향인 나바라 지방의 음악을 즐겨 활용했다. ‘나바라’도 그중 하나로, 사라사테의 작품으로서는 드물게도 피아노가 반주하는 가운데 바이올린 두 대가 연주하게 되어 있다. 두 바이올린이 마치 이중나선처럼 서로를 감싸고 돌면서 펼쳐내는 화음과 기교는 실로 눈부실 정도로 현란하다. &nbsp; John Williams, Raiders March from Indiana Jones and the Raiders of the Lost Ark (5‘)존 윌리엄스, 레이더스 행진곡 (영화 ‘인디아나 존스’)스티븐 스필버그 감독의 영화 &lt;인디아나 존스&gt; 시리즈는 인디아나 존스라는 미국 고고학자의 모험담을 다룬다. 영화음악의 거장 존 윌리엄스 특유의 금관 팡파르로 시작하는 ‘레이더스 행진곡’은 인디아나 존스의 모험심 강한 성격을 단적으로 드러내면서 사실상의 주제가 역할을 한다. &nbsp; Mozart, Clarinet Concerto K. 622, A major, 2nd movement (7’)모차르트, 클라리넷 협주곡 K.622, 2악장 *클라리넷, 임상우모차르트는 이 곡을 1791년에 완성하고 두 달도 채 안 되어 사망했다. 따라서 이 곡은 그의 마지막 완성작 중 하나이다. 모차르트의 작품 중에서도 걸작에 속하며, 특히 2악장은 지극히 부드럽고 고상한 서정미를 지니고 있어 영화 &lt;아웃 오브 아프리카&gt;에 사용되는 등 오래전부터 널리 사랑받고 있다. &nbsp
2nd rowSupp?, Light Cavalry Overture (8’)주페, 경기병&nbsp;서곡프란츠 폰 주페(1819~1895)는 오스트리아의 작곡가로, 극장용 음악을 주로 썼다. &lt;경기병&gt;은 그가 1866년에 쓴 오페레타로, 오늘날에는 ‘서곡’만이 꾸준히 연주되고 있다. 용감한 경기병을 암시하는 금관 팡파르로 시작해 오페레타에 나오는 선율 다섯 가지가 차례로 등장하면서 경쾌한 분위기를 이어간다. &nbsp; Sarasate, Fantasy on Bizet's 'Carmen' Op. 25 (12’)사라사테, 카르멘 판타지 *바이올린 : 이현정사라사테가 1880년대 초에 비제의 오페라 &lt;카르멘&gt;에 기초해 쓴 곡이다. 1악장은 4막 전주곡(‘아라고네즈’)을 차용한 전주와 ‘하바네라’(1막)에 기초한 주부로 구성된다. 부드러운 분위기의 2악장에 이은 3악장은 ‘세기디야’(1막)를 중심으로 하며, 4악장에서는 바이올린이 불꽃 튀는 기교를 펼친다. &nbsp; Rachmaninoff, Piano Concerto No. 2, Op. 18, C minor, 1st movement (11’)라흐마니노프, 피아노 협주곡 2번 1악장 *피아노 : 일리야 라쉬코프스키라흐마니노프는 ‘교향곡 제1번’의 초연이 실패하자 한동안 불안감에 사로잡혔으나, 최면 요법으로 자신감을 회복해 1901년에 ‘피아노 협주곡 제2번’을 써서 대성공을 거두었다. 1악장은 전체 세 악장 중 마지막으로 완성한 악장으로, 비장한 서주로 시작해 역시 격정적이며 비극미가 넘치는 주부로 이어진다. &nbsp; Liszt, Les Pr?ludes, S. 97 (Symphonic Poem No. 3) (16’)리스트, 교향시 3번 “전주곡”프란츠 리스트는 음악 외적인 소재(문학, 회화 등)를 음악으로 풀어내는 장르인 교향시를 처음으로 창안한 작곡가이다. 그의 교향시는 총 열세 곡인데, 1850~55년에 걸쳐 쓴 ‘전주곡’은 그 가운데 세 번째로 쓴 곡이지만 ‘교향시’라는 명칭을 처음부터 사용한 사례로는 맨 첫 번째에 해당한다.&nbs
3rd row엘가,&nbsp;첼로 협주곡&nbsp;E단조&nbsp;4악장 *첼로 : 주연선Elgar, Cello Concerto, Op. 85, E minor, 4th movementIV. Allegro; Moderato; Allegro, ma non troppo&nbsp; &nbsp; 영국 국민 음악가로 사랑받는 에드워드 엘가(1857~1934)는 1919년 퀸즈 홀에서 첼리스트 잘몬트의 협연으로 런던 심포니 오케스트라와 함께 이 &lt;첼로 협주곡&gt;을 초연했다. 협주곡은 대개 3악장으로 구성되지만 엘가는 이 협주곡을 교향곡처럼 4악장으로 구성했으며, 곡에 서린 깊은 슬픔과 우울한 정서는 청중을 놀라게 했다. 오늘 연주할 4악장은 차분하고 명상적인 3악장에 바로 이어 연주되는 부분으로, 오케스트라의 강렬한 제1주제를 첼로가 받아 마치 특별한 이야기를 들려주듯 연주한다. &nbsp; 드보르자크,&nbsp;교향곡&nbsp;9번&nbsp;‘신세계로부터’ 발췌Dvo??k, Symphony No. 9 I. Adagio - Allegro molto&nbsp;II. Largo IV. Allegro con fuoco &nbsp; 체코 작곡가 안토닌 드보르자크(1941~1904)는 프라하 음악원 교수로 재직하던 중 뉴욕음악원장직을 제안 받았다. 가족과 함께 미국에 건너간 그는 1893년 12월 15일 카네기 홀에서 &lt;교향곡 9번 ‘신세계로부터’&gt;를 초연해 미국인들의 열렬한 환영을 받았을 뿐만 아니라 유럽의 작곡가와 비평가들 모두에게서 찬사를 받았다. “미국을 보지 않았더라면 이런 교향곡을 쓸 수 없었을 것”이라고 작곡가 스스로 말한 이 작품은 1악장에 흑인영가의 영향이 나타나며, 2악장 ‘라르고’에서는 잘 알려진 노래 ‘고잉 홈 Going Home’의 선율을 잉글리시 호른이 연주한다. &nbsp; 글 이용숙(음악 칼럼니스트)
4th rowJ. Strauss II, Die Fledermaus Overture슈트라우스 2세, 오페레타 &lt;박쥐&gt; 서곡해마다 연말연시에 전 세계 오페라극장에서 공연되는 송년 오페레타 &lt;박쥐&gt;는 요한 슈트라우스 2세의 대표작으로, 화려한 춤과 음악, 유머 넘치는 대사들이 가득한 희극이다. 경쾌하고 영롱한 이 서곡에는 오페레타에 수록된 왈츠, 폴카 등의 춤곡 선율과 주요 주제들이 들어있다. &nbsp; Grieg, Peer Gynt: Suite No. 1그리그, &lt;페르 귄트&gt; 모음곡 1번1876년에 오슬로에서 초연한 에드바르 그리그의 &lt;페르 귄트&gt;는 노르웨이의 문호 헨리크 입센의 &lt;페르 귄트&gt;를 토대로 한 모음곡이다. 1곡 ‘아침의 기분’은 주인공 페르 귄트가 모로코 해안에 도착했을 때의 아침 풍경을 묘사한 것으로, 플루트로 연주하는 주제 선율이 인상적이다. &nbsp; Beethoven, Romance No. 2 in F major *Violin: Wayne Lin베토벤, &lt;로망스&gt; 2번 F장조 *바이올린: 웨인 린바이올린과 오케스트라가 함께 연주하는 베토벤의 &lt;로망스&gt; 2번은 모차르트의 피아노 협주곡과 세레나데를 모범으로 삼아 따뜻하고 밝은 분위기를 전달하는 젊은 베토벤의 걸작이다. 바이올린이 먼저 우아하고 서정적인 주제 선율을 연주하면 오케스트라가 이에 호응하며 스케일을 키워간다. &nbsp; Dvo??k, Symphony No. 7, Op. 70, D minor, 3rd movement 드보르자크, &lt;교향곡 7번&gt; 3악장영국 로열필하모니 협회의 의뢰로 작곡한 &lt;교향곡 7번&gt;은 브람스를 모범으로 삼은 독일적인 형식에 작곡가의 고향인 체코 보헤미아의 정서를 담은 작품으로, 1885년 영국에서 작곡가 자신의 지휘로 초연했다. &nbsp; Brahms, Hungarian Dance No. 1브람스, &lt;헝가리 무곡&gt; 1번집시들이 많이 거주했던 지역인 헝가리의 음악에는 집시 음악의 영향이 강하게 나타
5th rowJ. Strauss II, Die Fledermaus Overture슈트라우스 2세, 오페레타 &lt;박쥐&gt; 서곡해마다 연말연시에 전 세계 오페라극장에서 공연되는 송년 오페레타 &lt;박쥐&gt;는 요한 슈트라우스 2세의 대표작으로, 화려한 춤과 음악, 유머 넘치는 대사들이 가득한 희극이다. 경쾌하고 영롱한 이 서곡에는 오페레타에 수록된 왈츠, 폴카 등의 춤곡 선율과 주요 주제들이 들어있다. &nbsp; Grieg, Peer Gynt: Suite No. 1그리그, &lt;페르 귄트&gt; 모음곡 1번1876년에 오슬로에서 초연한 에드바르 그리그의 &lt;페르 귄트&gt;는 노르웨이의 문호 헨리크 입센의 &lt;페르 귄트&gt;를 토대로 한 모음곡이다. 1곡 ‘아침의 기분’은 주인공 페르 귄트가 모로코 해안에 도착했을 때의 아침 풍경을 묘사한 것으로, 플루트로 연주하는 주제 선율이 인상적이다. &nbsp; Beethoven, Romance No. 2 in F major *Violin: Wayne Lin베토벤, &lt;로망스&gt; 2번 F장조 *바이올린: 웨인 린바이올린과 오케스트라가 함께 연주하는 베토벤의 &lt;로망스&gt; 2번은 모차르트의 피아노 협주곡과 세레나데를 모범으로 삼아 따뜻하고 밝은 분위기를 전달하는 젊은 베토벤의 걸작이다. 바이올린이 먼저 우아하고 서정적인 주제 선율을 연주하면 오케스트라가 이에 호응하며 스케일을 키워간다. &nbsp; Dvo??k, Symphony No. 7, Op. 70, D minor, 3rd movement 드보르자크, &lt;교향곡 7번&gt; 3악장영국 로열필하모니 협회의 의뢰로 작곡한 &lt;교향곡 7번&gt;은 브람스를 모범으로 삼은 독일적인 형식에 작곡가의 고향인 체코 보헤미아의 정서를 담은 작품으로, 1885년 영국에서 작곡가 자신의 지휘로 초연했다. &nbsp; Brahms, Hungarian Dance No. 1브람스, &lt;헝가리 무곡&gt; 1번집시들이 많이 거주했던 지역인 헝가리의 음악에는 집시 음악의 영향이 강하게 나타
ValueCountFrequency (%)
이 517
 
1.2%
2 264
 
0.6%
205
 
0.5%
그 155
 
0.4%
있다 150
 
0.4%
수 143
 
0.3%
교향곡 142
 
0.3%
피아노 128
 
0.3%
그의 123
 
0.3%
op 118
 
0.3%
Other values (13887) 40734
95.4%
2024-05-18T12:06:07.873108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
42639
 
20.6%
이 4293
 
2.1%
다 3249
 
1.6%
의 3000
 
1.4%
. 2990
 
1.4%
는 2754
 
1.3%
에 2623
 
1.3%
로 2376
 
1.1%
, 2323
 
1.1%
을 2141
 
1.0%
Other values (1098) 139071
67.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 125927
60.7%
Space Separator 42639
 
20.6%
Lowercase Letter 15893
 
7.7%
Other Punctuation 9049
 
4.4%
Decimal Number 7828
 
3.8%
Uppercase Letter 1773
 
0.9%
Final Punctuation 1017
 
0.5%
Initial Punctuation 1011
 
0.5%
Open Punctuation 867
 
0.4%
Close Punctuation 861
 
0.4%
Other values (5) 594
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 4293
 
3.4%
다 3249
 
2.6%
의 3000
 
2.4%
는 2754
 
2.2%
에 2623
 
2.1%
로 2376
 
1.9%
을 2141
 
1.7%
곡 2059
 
1.6%
가 2018
 
1.6%
한 1936
 
1.5%
Other values (1004) 99478
79.0%
Lowercase Letter
ValueCountFrequency (%)
n 2089
13.1%
s 1775
11.2%
p 1676
10.5%
b 1385
8.7%
e 1104
 
6.9%
t 1034
 
6.5%
r 956
 
6.0%
o 899
 
5.7%
a 851
 
5.4%
i 693
 
4.4%
Other values (16) 3431
21.6%
Uppercase Letter
ValueCountFrequency (%)
S 192
 
10.8%
O 191
 
10.8%
C 169
 
9.5%
A 130
 
7.3%
D 105
 
5.9%
E 96
 
5.4%
B 93
 
5.2%
N 85
 
4.8%
P 74
 
4.2%
I 71
 
4.0%
Other values (15) 567
32.0%
Other Punctuation
ValueCountFrequency (%)
. 2990
33.0%
, 2323
25.7%
& 1676
18.5%
; 1674
18.5%
? 144
 
1.6%
: 85
 
0.9%
* 58
 
0.6%
' 52
 
0.6%
! 19
 
0.2%
… 14
 
0.2%
Decimal Number
ValueCountFrequency (%)
1 2052
26.2%
2 1263
16.1%
9 799
 
10.2%
0 769
 
9.8%
8 671
 
8.6%
3 622
 
7.9%
7 481
 
6.1%
4 444
 
5.7%
5 405
 
5.2%
6 322
 
4.1%
Open Punctuation
ValueCountFrequency (%)
( 756
87.2%
[ 73
 
8.4%
「 21
 
2.4%
『 15
 
1.7%
〈 2
 
0.2%
Close Punctuation
ValueCountFrequency (%)
) 750
87.1%
] 73
 
8.5%
」 21
 
2.4%
』 15
 
1.7%
〉 2
 
0.2%
Final Punctuation
ValueCountFrequency (%)
’ 915
90.0%
” 102
 
10.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 902
89.2%
“ 109
 
10.8%
Dash Punctuation
ValueCountFrequency (%)
- 412
98.6%
― 6
 
1.4%
Math Symbol
ValueCountFrequency (%)
~ 101
69.2%
+ 45
30.8%
Space Separator
ValueCountFrequency (%)
42639
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 16
100.0%
Other Symbol
ValueCountFrequency (%)
♭ 13
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 125905
60.7%
Common 63866
30.8%
Latin 17666
 
8.5%
Han 22
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 4293
 
3.4%
다 3249
 
2.6%
의 3000
 
2.4%
는 2754
 
2.2%
에 2623
 
2.1%
로 2376
 
1.9%
을 2141
 
1.7%
곡 2059
 
1.6%
가 2018
 
1.6%
한 1936
 
1.5%
Other values (992) 99456
79.0%
Latin
ValueCountFrequency (%)
n 2089
11.8%
s 1775
 
10.0%
p 1676
 
9.5%
b 1385
 
7.8%
e 1104
 
6.2%
t 1034
 
5.9%
r 956
 
5.4%
o 899
 
5.1%
a 851
 
4.8%
i 693
 
3.9%
Other values (41) 5204
29.5%
Common
ValueCountFrequency (%)
42639
66.8%
. 2990
 
4.7%
, 2323
 
3.6%
1 2052
 
3.2%
& 1676
 
2.6%
; 1674
 
2.6%
2 1263
 
2.0%
’ 915
 
1.4%
‘ 902
 
1.4%
9 799
 
1.3%
Other values (33) 6633
 
10.4%
Han
ValueCountFrequency (%)
中 4
18.2%
理 2
9.1%
想 2
9.1%
牧 2
9.1%
聖 2
9.1%
樂 2
9.1%
歌 2
9.1%
老 2
9.1%
音 1
 
4.5%
詩 1
 
4.5%
Other values (2) 2
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 125903
60.7%
ASCII 79395
38.3%
Punctuation 2048
 
1.0%
None 76
 
< 0.1%
CJK 20
 
< 0.1%
Misc Symbols 13
 
< 0.1%
CJK Compat Ideographs 2
 
< 0.1%
Compat Jamo 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
42639
53.7%
. 2990
 
3.8%
, 2323
 
2.9%
n 2089
 
2.6%
1 2052
 
2.6%
s 1775
 
2.2%
& 1676
 
2.1%
p 1676
 
2.1%
; 1674
 
2.1%
b 1385
 
1.7%
Other values (71) 19116
24.1%
Hangul
ValueCountFrequency (%)
이 4293
 
3.4%
다 3249
 
2.6%
의 3000
 
2.4%
는 2754
 
2.2%
에 2623
 
2.1%
로 2376
 
1.9%
을 2141
 
1.7%
곡 2059
 
1.6%
가 2018
 
1.6%
한 1936
 
1.5%
Other values (991) 99454
79.0%
Punctuation
ValueCountFrequency (%)
’ 915
44.7%
‘ 902
44.0%
“ 109
 
5.3%
” 102
 
5.0%
… 14
 
0.7%
― 6
 
0.3%
None
ValueCountFrequency (%)
」 21
27.6%
「 21
27.6%
』 15
19.7%
『 15
19.7%
〈 2
 
2.6%
〉 2
 
2.6%
Misc Symbols
ValueCountFrequency (%)
♭ 13
100.0%
CJK
ValueCountFrequency (%)
中 4
20.0%
理 2
10.0%
想 2
10.0%
牧 2
10.0%
聖 2
10.0%
樂 2
10.0%
歌 2
10.0%
音 1
 
5.0%
詩 1
 
5.0%
力 1
 
5.0%
CJK Compat Ideographs
ValueCountFrequency (%)
老 2
100.0%
Compat Jamo
ValueCountFrequency (%)
ㅡ 2
100.0%

공연이미지URL
Text

MISSING 

Distinct1463
Distinct (%)100.0%
Missing50
Missing (%)3.3%
Memory size11.9 KiB
2024-05-18T12:06:08.951774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length56
Mean length56.092276
Min length56

Characters and Unicode

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

Unique

Unique1463 ?
Unique (%)100.0%

Sample

1st rowhttps://www.seoulphil.or.kr/file/displayFile?fileNo=11449
2nd rowhttps://www.seoulphil.or.kr/file/displayFile?fileNo=11448
3rd rowhttps://www.seoulphil.or.kr/file/displayFile?fileNo=11436
4th rowhttps://www.seoulphil.or.kr/file/displayFile?fileNo=11407
5th rowhttps://www.seoulphil.or.kr/file/displayFile?fileNo=11401
ValueCountFrequency (%)
https://www.seoulphil.or.kr/file/displayfile?fileno=11189 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5053 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5090 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5098 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5106 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5114 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5122 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5042 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5068 1
 
0.1%
https://www.seoulphil.or.kr/file/displayfile?fileno=5089 1
 
0.1%
Other values (1453) 1453
99.3%
2024-05-18T12:06:10.599326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
l 8778
 
10.7%
i 7315
 
8.9%
/ 5852
 
7.1%
e 5852
 
7.1%
o 4389
 
5.3%
p 4389
 
5.3%
s 4389
 
5.3%
w 4389
 
5.3%
. 4389
 
5.3%
t 2926
 
3.6%
Other values (23) 29395
35.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 58520
71.3%
Other Punctuation 13167
 
16.0%
Decimal Number 5987
 
7.3%
Uppercase Letter 2926
 
3.6%
Math Symbol 1463
 
1.8%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
l 8778
15.0%
i 7315
12.5%
e 5852
10.0%
o 4389
7.5%
p 4389
7.5%
s 4389
7.5%
w 4389
7.5%
t 2926
 
5.0%
f 2926
 
5.0%
r 2926
 
5.0%
Other values (6) 10241
17.5%
Decimal Number
ValueCountFrequency (%)
5 1096
18.3%
4 765
12.8%
1 655
10.9%
8 543
9.1%
6 520
8.7%
0 519
8.7%
9 501
8.4%
2 477
8.0%
7 476
8.0%
3 435
 
7.3%
Other Punctuation
ValueCountFrequency (%)
/ 5852
44.4%
. 4389
33.3%
? 1463
 
11.1%
: 1463
 
11.1%
Uppercase Letter
ValueCountFrequency (%)
N 1463
50.0%
F 1463
50.0%
Math Symbol
ValueCountFrequency (%)
= 1463
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 61446
74.9%
Common 20617
 
25.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
l 8778
14.3%
i 7315
11.9%
e 5852
9.5%
o 4389
 
7.1%
p 4389
 
7.1%
s 4389
 
7.1%
w 4389
 
7.1%
t 2926
 
4.8%
f 2926
 
4.8%
r 2926
 
4.8%
Other values (8) 13167
21.4%
Common
ValueCountFrequency (%)
/ 5852
28.4%
. 4389
21.3%
? 1463
 
7.1%
= 1463
 
7.1%
: 1463
 
7.1%
5 1096
 
5.3%
4 765
 
3.7%
1 655
 
3.2%
8 543
 
2.6%
6 520
 
2.5%
Other values (5) 2408
11.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 82063
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
l 8778
 
10.7%
i 7315
 
8.9%
/ 5852
 
7.1%
e 5852
 
7.1%
o 4389
 
5.3%
p 4389
 
5.3%
s 4389
 
5.3%
w 4389
 
5.3%
. 4389
 
5.3%
t 2926
 
3.6%
Other values (23) 29395
35.8%

유료회원 일반 예매시작일
Date

MISSING 

Distinct271
Distinct (%)31.0%
Missing640
Missing (%)42.3%
Memory size11.9 KiB
Minimum2008-10-31 00:00:00
Maximum2024-12-03 19:30:00
2024-05-18T12:06:11.195346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:06:11.892593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

무료회원 일반 예매시작일
Date

MISSING 

Distinct272
Distinct (%)31.2%
Missing640
Missing (%)42.3%
Memory size11.9 KiB
Minimum2008-10-31 00:00:00
Maximum2024-12-03 19:30:00
2024-05-18T12:06:12.423126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:06:13.069227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

아티스트사전
Text

MISSING 

Distinct421
Distinct (%)60.7%
Missing819
Missing (%)54.1%
Memory size11.9 KiB
2024-05-18T12:06:13.959754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length166
Median length102
Mean length37.805476
Min length4

Characters and Unicode

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

Unique

Unique267 ?
Unique (%)38.5%

Sample

1st row지휘자 Jaap van Zweden
2nd row지휘자 David Yi
3rd row지휘자 David Yi
4th row지휘자 Jaap van Zweden,협연자 Minbae Gong,협연자 Junhyung Park
5th row지휘자 David Yi,협연자 Eunah Cho,협연자 Juyong Park
ValueCountFrequency (%)
지휘자 489
 
12.8%
협연자 225
 
5.9%
myung-whun 76
 
2.0%
osmo 58
 
1.5%
chung,협연자 53
 
1.4%
david 50
 
1.3%
kim 50
 
1.3%
thierry 45
 
1.2%
markus 40
 
1.0%
v?nsk?,협연자 39
 
1.0%
Other values (803) 2710
70.7%
2024-05-18T12:06:15.340072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3187
 
12.1%
n 1672
 
6.4%
자 1435
 
5.5%
a 1429
 
5.4%
e 1397
 
5.3%
o 1235
 
4.7%
i 1138
 
4.3%
u 879
 
3.4%
r 877
 
3.3%
협 810
 
3.1%
Other values (66) 12178
46.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 14025
53.5%
Other Letter 4354
 
16.6%
Uppercase Letter 3485
 
13.3%
Space Separator 3187
 
12.1%
Other Punctuation 906
 
3.5%
Dash Punctuation 276
 
1.1%
Open Punctuation 2
 
< 0.1%
Close Punctuation 2
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
n 1672
11.9%
a 1429
10.2%
e 1397
10.0%
o 1235
 
8.8%
i 1138
 
8.1%
u 879
 
6.3%
r 877
 
6.3%
h 740
 
5.3%
s 648
 
4.6%
g 605
 
4.3%
Other values (18) 3405
24.3%
Uppercase Letter
ValueCountFrequency (%)
S 422
 
12.1%
C 299
 
8.6%
M 256
 
7.3%
Y 238
 
6.8%
K 230
 
6.6%
J 212
 
6.1%
H 209
 
6.0%
A 154
 
4.4%
W 146
 
4.2%
P 135
 
3.9%
Other values (16) 1184
34.0%
Other Letter
ValueCountFrequency (%)
자 1435
33.0%
협 810
18.6%
연 810
18.6%
휘 625
14.4%
지 625
14.4%
성 18
 
0.4%
악 18
 
0.4%
컬 5
 
0.1%
보 5
 
0.1%
합 1
 
< 0.1%
Other values (2) 2
 
< 0.1%
Other Punctuation
ValueCountFrequency (%)
, 767
84.7%
? 130
 
14.3%
' 4
 
0.4%
& 2
 
0.2%
. 2
 
0.2%
/ 1
 
0.1%
Space Separator
ValueCountFrequency (%)
3187
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 276
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 17510
66.7%
Common 4373
 
16.7%
Hangul 4354
 
16.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
n 1672
 
9.5%
a 1429
 
8.2%
e 1397
 
8.0%
o 1235
 
7.1%
i 1138
 
6.5%
u 879
 
5.0%
r 877
 
5.0%
h 740
 
4.2%
s 648
 
3.7%
g 605
 
3.5%
Other values (44) 6890
39.3%
Hangul
ValueCountFrequency (%)
자 1435
33.0%
협 810
18.6%
연 810
18.6%
휘 625
14.4%
지 625
14.4%
성 18
 
0.4%
악 18
 
0.4%
컬 5
 
0.1%
보 5
 
0.1%
합 1
 
< 0.1%
Other values (2) 2
 
< 0.1%
Common
ValueCountFrequency (%)
3187
72.9%
, 767
 
17.5%
- 276
 
6.3%
? 130
 
3.0%
' 4
 
0.1%
& 2
 
< 0.1%
( 2
 
< 0.1%
) 2
 
< 0.1%
. 2
 
< 0.1%
/ 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 21877
83.4%
Hangul 4354
 
16.6%
None 6
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3187
 
14.6%
n 1672
 
7.6%
a 1429
 
6.5%
e 1397
 
6.4%
o 1235
 
5.6%
i 1138
 
5.2%
u 879
 
4.0%
r 877
 
4.0%
, 767
 
3.5%
h 740
 
3.4%
Other values (52) 8556
39.1%
Hangul
ValueCountFrequency (%)
자 1435
33.0%
협 810
18.6%
연 810
18.6%
휘 625
14.4%
지 625
14.4%
성 18
 
0.4%
악 18
 
0.4%
컬 5
 
0.1%
보 5
 
0.1%
합 1
 
< 0.1%
Other values (2) 2
 
< 0.1%
None
ValueCountFrequency (%)
ø 5
83.3%
ß 1
 
16.7%

등록일시
Date

Distinct1374
Distinct (%)90.8%
Missing0
Missing (%)0.0%
Memory size11.9 KiB
Minimum2009-02-26 18:32:40
Maximum2024-05-10 11:39:46
2024-05-18T12:06:15.994111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:06:16.471085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-18T12:05:49.159072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-18T12:06:16.805532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공연일련번호공연구분1공연구분2공연구분3공연장소티켓가격
공연일련번호1.0000.3770.3500.4390.9970.775
공연구분10.3771.0000.8311.0001.0000.824
공연구분20.3500.8311.0001.0001.0000.860
공연구분30.4391.0001.0001.0001.0000.882
공연장소0.9971.0001.0001.0001.0001.000
티켓가격0.7750.8240.8600.8821.0001.000
2024-05-18T12:06:17.080224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
티켓가격공연구분3공연구분1공연구분2
티켓가격1.0000.5730.6000.575
공연구분30.5731.0000.9530.966
공연구분10.6000.9531.0000.706
공연구분20.5750.9660.7061.000
2024-05-18T12:06:17.351496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공연일련번호공연구분1공연구분2공연구분3티켓가격
공연일련번호1.0000.2290.1800.2620.406
공연구분10.2291.0000.7060.9530.600
공연구분20.1800.7061.0000.9660.575
공연구분30.2620.9530.9661.0000.573
티켓가격0.4060.6000.5750.5731.000

Missing values

2024-05-18T12:05:49.659528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-18T12:05:50.359576image/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.
2024-05-18T12:05:50.946201image/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

공연일련번호공연구분1공연구분2공연구분3공연명공연장소공연일시티켓가격곡목프로그램소개공연이미지URL유료회원 일반 예매시작일무료회원 일반 예매시작일아티스트사전등록일시
06219시민공연찾아가는음악회<NA>SPO Park Concert 2024Family yard2024.09.21 19:00<NA><NA><NA><NA>2024-09-21 00:00:002024-09-21 00:00:00지휘자 Jaap van Zweden2024-05-10 11:39:46.0
16217교육공연청소년교육<NA>Kids Concert with Seoul Philharmonic Orchestra 2024<NA>2024.10.09 16:00<NA><NA><NA><NA>2024-10-01 00:00:002024-10-01 00:00:00지휘자 David Yi2024-05-09 12:13:51.0
26215교육공연청소년교육<NA>Kids Concert with Seoul Philharmonic Orchestra 2024<NA>2024.10.09 13:00<NA><NA><NA><NA>2024-10-01 00:00:002024-10-01 00:00:00지휘자 David Yi2024-05-09 12:09:08.0
36213시민공연찾아가는음악회<NA>2024 SPO Museum ConcertSongpa Book Museum2024.08.23 19:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=114492024-05-08 00:00:002024-05-08 00:00:00<NA>2024-05-08 18:08:30.0
46211시민공연찾아가는음악회<NA>2024 SPO Museum ConcertSeoul Museum of Craft Art2024.08.22 19:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=114482024-05-08 00:00:002024-05-08 00:00:00<NA>2024-05-08 18:01:31.0
56209시민공연찾아가는음악회<NA>2024 SPO Museum ConcertBuk Seoul Museum of Art2024.08.21 19:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=114362024-05-08 01:00:002024-05-08 00:00:00<NA>2024-05-08 17:53:19.0
66193시민공연찾아가는음악회<NA>2024 SPO Outreach Chamber ConcertKorea War memorial2024.06.12 15:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=114072024-06-12 15:00:002024-06-12 15:00:00<NA>2024-04-29 15:54:28.0
76191시민공연찾아가는음악회<NA>2024 SPO Outreach Chamber ConcertSeoul National University Hospital Daehan Center Lobby2024.06.04 12:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=114012024-06-04 12:00:002024-06-04 12:00:00<NA>2024-04-29 15:41:14.0
86189시민공연찾아가는음악회<NA>2024 SPO Outreach Chamber ConcertSeonam Hospital Lobby2024.06.03 12:30<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=114002024-06-03 12:30:002024-06-03 12:30:00<NA>2024-04-29 15:28:02.0
96171시민공연기획공연SPO Day2024 SPO Day<NA>2024.05.12 14:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=113752024-04-18 00:00:002024-04-24 00:00:00<NA>2024-04-18 18:14:29.0
공연일련번호공연구분1공연구분2공연구분3공연명공연장소공연일시티켓가격곡목프로그램소개공연이미지URL유료회원 일반 예매시작일무료회원 일반 예매시작일아티스트사전등록일시
15032636시민공연찾아가는음악회<NA><NA><NA>2009.03.18 15:30<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4615<NA><NA><NA>2009-02-26 20:01:08.0
15042635시민공연찾아가는음악회<NA><NA><NA>2009.03.17 15:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4614<NA><NA><NA>2009-02-26 20:00:22.0
15052634시민공연찾아가는음악회<NA><NA><NA>2009.03.16 14:40<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4613<NA><NA><NA>2009-02-26 19:59:40.0
15062632시민공연찾아가는음악회<NA><NA><NA>2009.03.11 19:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4611<NA><NA><NA>2009-02-26 19:57:43.0
15072630시민공연특별공연<NA><NA><NA>2009.03.06 10:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4609<NA><NA><NA>2009-02-26 19:56:03.0
15082631시민공연찾아가는음악회<NA><NA><NA>2009.03.06 19:30<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4610<NA><NA><NA>2009-02-26 19:54:16.0
15092640정기공연관현악<NA>Virtuoso Series 1<NA>2009.03.27 20:0050,000(R), 30,000(S), 20,000(A), 10,000(B)Symphony No. 5 in E minor, Op. 64,Piano Concerto No. 1 in B-flat minor, Op. 23<NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=46192008-10-31 00:00:002008-10-31 00:00:00지휘자 Kirill Karabits,협연자 Sunwook Kim2009-02-26 19:51:26.0
15102633정기공연관현악<NA>Great Concerto Series 1<NA>2009.03.15 20:0050,000(R), 30,000(S), 20,000(A), 10,000(B)Prelude to the Afternoon of a Faun,Cello Concerto in E minor, Op. 85,Manfred, Op. 58<NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=46122008-10-31 00:00:002008-10-31 00:00:00지휘자 Rossen Milanov,협연자 Sol Gabetta2009-02-26 19:48:43.0
15112629정기공연관현악<NA>Masterpiece Series 3<NA>2009.03.05 19:3070,000(R), 50,000(S), 30,000(A), 20,000(B), 10,000(C)Piano Concerto No. 24,The Rite of Spring<NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=46082008-10-31 00:00:002008-10-31 00:00:00지휘자 Myung-Whun Chung,협연자 Finghin Collins2009-02-26 19:43:57.0
15122628시민공연특별공연<NA><NA><NA>2009.03.01 17:00<NA><NA><NA>https://www.seoulphil.or.kr/file/displayFile?fileNo=4607<NA><NA><NA>2009-02-26 18:32:40.0