Overview

Dataset statistics

Number of variables8
Number of observations98
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.4 KiB
Average record size in memory67.3 B

Variable types

Categorical3
Text1
Numeric2
DateTime2

Dataset

Description국립아시아문화전당 공연, 전시, 행사 등 구분별 공연 등에 대하여 구매 고객이 티켓을 재출력한 건수를 알 수 있는 정보입니다.
Author문화체육관광부 국립아시아문화전당
URLhttps://www.data.go.kr/data/15071296/fileData.do

Alerts

티켓재출력건수 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 티켓재출력건수 and 1 other fieldsHigh correlation
장르 is highly overall correlated with 구분High correlation

Reproduction

Analysis started2023-12-12 18:40:22.357085
Analysis finished2023-12-12 18:40:25.316806
Duration2.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size916.0 B
공연
49 
행사
47 
전시
 
1
어린이프로그램
 
1

Length

Max length7
Median length2
Mean length2.0510204
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row공연
2nd row공연
3rd row행사
4th row공연
5th row공연

Common Values

ValueCountFrequency (%)
공연 49
50.0%
행사 47
48.0%
전시 1
 
1.0%
어린이프로그램 1
 
1.0%

Length

2023-12-13T03:40:25.445668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:40:25.642231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공연 49
50.0%
행사 47
48.0%
전시 1
 
1.0%
어린이프로그램 1
 
1.0%
Distinct97
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Memory size916.0 B
2023-12-13T03:40:26.002619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length32.5
Mean length26.387755
Min length4

Characters and Unicode

Total characters2586
Distinct characters393
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique96 ?
Unique (%)98.0%

Sample

1st row2019 ACC 어린이극장 기획대관<팥죽할멈과 호랑이 시즌2>
2nd row2019 ACC 창제작공연<R.E.X(무사) : 불멸의 영웅들>
3rd row[대관]연극 이프온리
4th row새해는 어떤 계절에 시작될까?
5th row2019 ACC 어린이극장 기획대관<호랑이의 꽃길>
ValueCountFrequency (%)
2019 45
 
9.3%
acc 34
 
7.0%
브런치 15
 
3.1%
10
 
2.1%
슈퍼클래식 7
 
1.4%
광주국제평화연극제 4
 
0.8%
대관]2019 4
 
0.8%
리사이틀 4
 
0.8%
어린이극장 4
 
0.8%
콘텐츠 4
 
0.8%
Other values (309) 353
72.9%
2023-12-13T03:40:26.884643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
386
 
14.9%
C 72
 
2.8%
1 71
 
2.7%
0 59
 
2.3%
2 58
 
2.2%
> 57
 
2.2%
< 56
 
2.2%
9 53
 
2.0%
A 42
 
1.6%
39
 
1.5%
Other values (383) 1693
65.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1438
55.6%
Space Separator 387
 
15.0%
Decimal Number 271
 
10.5%
Uppercase Letter 194
 
7.5%
Math Symbol 114
 
4.4%
Lowercase Letter 81
 
3.1%
Other Punctuation 39
 
1.5%
Close Punctuation 26
 
1.0%
Open Punctuation 26
 
1.0%
Dash Punctuation 4
 
0.2%
Other values (2) 6
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
39
 
2.7%
38
 
2.6%
37
 
2.6%
30
 
2.1%
26
 
1.8%
24
 
1.7%
23
 
1.6%
23
 
1.6%
22
 
1.5%
21
 
1.5%
Other values (308) 1155
80.3%
Uppercase Letter
ValueCountFrequency (%)
C 72
37.1%
A 42
21.6%
E 11
 
5.7%
X 8
 
4.1%
N 7
 
3.6%
R 6
 
3.1%
T 6
 
3.1%
O 5
 
2.6%
L 4
 
2.1%
S 4
 
2.1%
Other values (13) 29
14.9%
Lowercase Letter
ValueCountFrequency (%)
e 14
17.3%
i 10
12.3%
t 9
11.1%
o 8
9.9%
n 7
8.6%
l 6
7.4%
s 5
 
6.2%
a 3
 
3.7%
d 3
 
3.7%
v 2
 
2.5%
Other values (9) 14
17.3%
Decimal Number
ValueCountFrequency (%)
1 71
26.2%
0 59
21.8%
2 58
21.4%
9 53
19.6%
3 13
 
4.8%
5 5
 
1.8%
4 4
 
1.5%
6 3
 
1.1%
7 3
 
1.1%
8 2
 
0.7%
Other Punctuation
ValueCountFrequency (%)
: 8
20.5%
. 8
20.5%
, 6
15.4%
& 4
10.3%
· 4
10.3%
' 3
 
7.7%
" 2
 
5.1%
? 2
 
5.1%
! 2
 
5.1%
Math Symbol
ValueCountFrequency (%)
> 57
50.0%
< 56
49.1%
× 1
 
0.9%
Space Separator
ValueCountFrequency (%)
386
99.7%
  1
 
0.3%
Close Punctuation
ValueCountFrequency (%)
] 20
76.9%
) 6
 
23.1%
Open Punctuation
ValueCountFrequency (%)
[ 20
76.9%
( 6
 
23.1%
Final Punctuation
ValueCountFrequency (%)
2
66.7%
1
33.3%
Initial Punctuation
ValueCountFrequency (%)
2
66.7%
1
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1438
55.6%
Common 873
33.8%
Latin 275
 
10.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
39
 
2.7%
38
 
2.6%
37
 
2.6%
30
 
2.1%
26
 
1.8%
24
 
1.7%
23
 
1.6%
23
 
1.6%
22
 
1.5%
21
 
1.5%
Other values (308) 1155
80.3%
Latin
ValueCountFrequency (%)
C 72
26.2%
A 42
15.3%
e 14
 
5.1%
E 11
 
4.0%
i 10
 
3.6%
t 9
 
3.3%
o 8
 
2.9%
X 8
 
2.9%
N 7
 
2.5%
n 7
 
2.5%
Other values (32) 87
31.6%
Common
ValueCountFrequency (%)
386
44.2%
1 71
 
8.1%
0 59
 
6.8%
2 58
 
6.6%
> 57
 
6.5%
< 56
 
6.4%
9 53
 
6.1%
] 20
 
2.3%
[ 20
 
2.3%
3 13
 
1.5%
Other values (23) 80
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1438
55.6%
ASCII 1136
43.9%
None 6
 
0.2%
Punctuation 6
 
0.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
386
34.0%
C 72
 
6.3%
1 71
 
6.2%
0 59
 
5.2%
2 58
 
5.1%
> 57
 
5.0%
< 56
 
4.9%
9 53
 
4.7%
A 42
 
3.7%
] 20
 
1.8%
Other values (58) 262
23.1%
Hangul
ValueCountFrequency (%)
39
 
2.7%
38
 
2.6%
37
 
2.6%
30
 
2.1%
26
 
1.8%
24
 
1.7%
23
 
1.6%
23
 
1.6%
22
 
1.5%
21
 
1.5%
Other values (308) 1155
80.3%
None
ValueCountFrequency (%)
· 4
66.7%
  1
 
16.7%
× 1
 
16.7%
Punctuation
ValueCountFrequency (%)
2
33.3%
2
33.3%
1
16.7%
1
16.7%

장르
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)18.4%
Missing0
Missing (%)0.0%
Memory size916.0 B
공연
22 
연극
14 
콘서트
12 
가족,아동
기타
Other values (13)
35 

Length

Max length5
Median length2
Mean length2.5510204
Min length2

Unique

Unique3 ?
Unique (%)3.1%

Sample

1st row가족,아동
2nd row공연
3rd row연극
4th row연극
5th row가족,아동

Common Values

ValueCountFrequency (%)
공연 22
22.4%
연극 14
14.3%
콘서트 12
12.2%
가족,아동 8
 
8.2%
기타 7
 
7.1%
클래식 7
 
7.1%
음악 5
 
5.1%
음악극 4
 
4.1%
인형극 3
 
3.1%
국악 3
 
3.1%
Other values (8) 13
13.3%

Length

2023-12-13T03:40:27.161554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
공연 22
22.4%
연극 14
14.3%
콘서트 12
12.2%
가족,아동 8
 
8.2%
기타 7
 
7.1%
클래식 7
 
7.1%
음악 5
 
5.1%
음악극 4
 
4.1%
국악 3
 
3.1%
인형극 3
 
3.1%
Other values (8) 13
13.3%

대상
Categorical

Distinct18
Distinct (%)18.4%
Missing0
Missing (%)0.0%
Memory size916.0 B
8세이상
31 
만7세이상
22 
전체관람
5세 이상
만36개월이상
Other values (13)
25 

Length

Max length7
Median length6
Mean length4.622449
Min length3

Unique

Unique7 ?
Unique (%)7.1%

Sample

1st row5세 이상
2nd row6세이상
3rd row11세이상
4th row5세 이상
5th row5세 이상

Common Values

ValueCountFrequency (%)
8세이상 31
31.6%
만7세이상 22
22.4%
전체관람 8
 
8.2%
5세 이상 7
 
7.1%
만36개월이상 5
 
5.1%
36개월 4
 
4.1%
만5세이상 4
 
4.1%
4세 이상 3
 
3.1%
6세이상 3
 
3.1%
만13세이상 2
 
2.0%
Other values (8) 9
 
9.2%

Length

2023-12-13T03:40:27.420933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
8세이상 31
28.4%
만7세이상 22
20.2%
이상 10
 
9.2%
전체관람 8
 
7.3%
5세 7
 
6.4%
만36개월이상 5
 
4.6%
36개월 4
 
3.7%
만5세이상 4
 
3.7%
4세 3
 
2.8%
6세이상 3
 
2.8%
Other values (10) 12
 
11.0%

상영시간
Real number (ℝ)

Distinct17
Distinct (%)17.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean77.785714
Minimum30
Maximum180
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1014.0 B
2023-12-13T03:40:27.652735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum30
5-th percentile40
Q160
median80
Q390
95-th percentile120
Maximum180
Range150
Interquartile range (IQR)30

Descriptive statistics

Standard deviation27.601453
Coefficient of variation (CV)0.35483962
Kurtosis1.1002179
Mean77.785714
Median Absolute Deviation (MAD)20
Skewness0.74440395
Sum7623
Variance761.84021
MonotonicityNot monotonic
2023-12-13T03:40:27.904384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
90 28
28.6%
60 17
17.3%
50 13
13.3%
100 8
 
8.2%
40 6
 
6.1%
120 5
 
5.1%
70 5
 
5.1%
80 3
 
3.1%
115 2
 
2.0%
150 2
 
2.0%
Other values (7) 9
 
9.2%
ValueCountFrequency (%)
30 2
 
2.0%
40 6
 
6.1%
45 2
 
2.0%
50 13
13.3%
55 1
 
1.0%
60 17
17.3%
70 5
 
5.1%
75 1
 
1.0%
80 3
 
3.1%
90 28
28.6%
ValueCountFrequency (%)
180 1
 
1.0%
150 2
 
2.0%
120 5
 
5.1%
115 2
 
2.0%
110 1
 
1.0%
103 1
 
1.0%
100 8
 
8.2%
90 28
28.6%
80 3
 
3.1%
75 1
 
1.0%
Distinct88
Distinct (%)89.8%
Missing0
Missing (%)0.0%
Memory size916.0 B
Minimum2019-01-01 00:00:00
Maximum2019-12-21 00:00:00
2023-12-13T03:40:28.160229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:40:28.393500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct89
Distinct (%)90.8%
Missing0
Missing (%)0.0%
Memory size916.0 B
Minimum2019-02-03 00:00:00
Maximum2020-02-23 00:00:00
2023-12-13T03:40:28.664735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:40:28.970284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

티켓재출력건수
Real number (ℝ)

HIGH CORRELATION 

Distinct62
Distinct (%)63.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean99.55102
Minimum1
Maximum1586
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1014.0 B
2023-12-13T03:40:29.229631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q17
median22
Q376
95-th percentile347.45
Maximum1586
Range1585
Interquartile range (IQR)69

Descriptive statistics

Standard deviation252.80293
Coefficient of variation (CV)2.5394308
Kurtosis23.100004
Mean99.55102
Median Absolute Deviation (MAD)19
Skewness4.6944697
Sum9756
Variance63909.322
MonotonicityNot monotonic
2023-12-13T03:40:29.518453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 7
 
7.1%
3 5
 
5.1%
10 5
 
5.1%
4 5
 
5.1%
11 4
 
4.1%
23 3
 
3.1%
2 3
 
3.1%
25 2
 
2.0%
21 2
 
2.0%
15 2
 
2.0%
Other values (52) 60
61.2%
ValueCountFrequency (%)
1 7
7.1%
2 3
3.1%
3 5
5.1%
4 5
5.1%
5 2
 
2.0%
6 2
 
2.0%
7 2
 
2.0%
8 1
 
1.0%
9 1
 
1.0%
10 5
5.1%
ValueCountFrequency (%)
1586 1
1.0%
1412 1
1.0%
1269 1
1.0%
474 1
1.0%
367 1
1.0%
344 1
1.0%
335 1
1.0%
242 1
1.0%
206 1
1.0%
201 1
1.0%

Interactions

2023-12-13T03:40:24.537319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:40:24.171343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:40:24.723364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:40:24.343141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:40:29.730568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분공연명장르대상상영시간공연시작일공연종료일티켓재출력건수
구분1.0001.0000.8380.3040.0000.9840.9740.788
공연명1.0001.0001.0001.0001.0000.9980.9981.000
장르0.8381.0001.0000.7970.7060.9700.9180.402
대상0.3041.0000.7971.0000.5760.0000.7970.303
상영시간0.0001.0000.7060.5761.0000.3450.0000.000
공연시작일0.9840.9980.9700.0000.3451.0000.9990.000
공연종료일0.9740.9980.9180.7970.0000.9991.0000.967
티켓재출력건수0.7881.0000.4020.3030.0000.0000.9671.000
2023-12-13T03:40:29.942307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
장르대상구분
장르1.0000.2920.585
대상0.2921.0000.151
구분0.5850.1511.000
2023-12-13T03:40:30.133396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상영시간티켓재출력건수구분장르대상
상영시간1.0000.0850.0000.3280.243
티켓재출력건수0.0851.0000.6270.1540.108
구분0.0000.6271.0000.5850.151
장르0.3280.1540.5851.0000.292
대상0.2430.1080.1510.2921.000

Missing values

2023-12-13T03:40:25.005245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:40:25.223807image/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

구분공연명장르대상상영시간공연시작일공연종료일티켓재출력건수
0공연2019 ACC 어린이극장 기획대관<팥죽할멈과 호랑이 시즌2>가족,아동5세 이상502019-12-212019-12-2225
1공연2019 ACC 창제작공연<R.E.X(무사) : 불멸의 영웅들>공연6세이상752019-12-202019-12-2152
2행사[대관]연극 이프온리연극11세이상902019-12-202019-12-25474
3공연새해는 어떤 계절에 시작될까?연극5세 이상402019-12-142019-12-1551
4공연2019 ACC 어린이극장 기획대관<호랑이의 꽃길>가족,아동5세 이상502019-12-072019-12-0840
5행사[대관]제23회 동구합창단 정기연주회공연6세이상1202019-12-052019-12-0576
6행사제 36회 대한민국 국제음악제콘서트8세이상1202019-11-302019-11-30367
7공연삼성전자 사랑나눔 콘서트없음8세이상802019-11-292019-11-291
8행사테크니컬 퍼포먼스 <No Title>공연8세이상602019-11-282019-11-2844
9공연2019 ACC 브런치 15회<김소현 손준호의 LOVE&MUSICAL토크콘서트>음악8세이상902019-11-272019-11-2755
구분공연명장르대상상영시간공연시작일공연종료일티켓재출력건수
88행사[대관]2019 대한민국 한복모델 선발대회기타만7세이상602019-03-232019-03-234
89공연[어린이극장]용감한 탄티가족,아동만36개월이상502019-03-162019-03-1718
90공연2019 ACC 브런치 2회<문태국X한지호 클래식한 봄>콘서트만7세이상902019-03-132019-03-1343
91행사[기획대관]KTG상상univ.2019 상상뮤지컬<올슉업>뮤지컬만5세이상902019-03-092019-03-096
92공연2019 ACC 브런치 1회<김남윤X코리안솔로이스츠>콘서트만7세이상902019-02-272019-02-27156
93공연2019 ACC 슈퍼클래식 1회<라파우 블레하츠&김봄소리 듀오>클래식만7세이상902019-02-162019-02-1640
94행사[대관]평창동계올림픽·패럴림픽 1주년 기념 패션문화행사,광주기타만7세이상602019-02-152019-02-1511
95공연2019 ACC 브런치콘서트 연간 패키지콘서트만7세이상902019-02-142019-02-141586
96공연달아난 수염연극만36개월이상502019-02-022019-02-0315
97어린이프로그램2019 어린이체험관체험전체관람602019-01-012019-12-311412