Overview

Dataset statistics

Number of variables11
Number of observations154
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.7 KiB
Average record size in memory90.9 B

Variable types

Categorical7
DateTime2
Numeric2

Dataset

Description문화체육관광부 소속기관인 국립아시아문화전당의 공연, 전시 등 거래창구(현장, PC 등) 거래건수 및 거래금액에 대한 정보를 제공합니다.
Author문화체육관광부
URLhttps://www.data.go.kr/data/15071304/fileData.do

Alerts

구분 is highly overall correlated with 공연명 and 4 other fieldsHigh correlation
공연명 is highly overall correlated with 구분 and 4 other fieldsHigh correlation
장르 is highly overall correlated with 구분 and 4 other fieldsHigh correlation
대상 is highly overall correlated with 구분 and 3 other fieldsHigh correlation
상영시간(분) is highly overall correlated with 구분 and 4 other fieldsHigh correlation
요금정보 is highly overall correlated with 구분 and 3 other fieldsHigh correlation
가격 has 63 (40.9%) zerosZeros

Reproduction

Analysis started2023-12-12 20:23:51.688980
Analysis finished2023-12-12 20:23:52.881992
Duration1.19 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
공연
80 
행사
37 
전시
24 
어린이프로그램
 
7
영화
 
6

Length

Max length7
Median length2
Mean length2.2272727
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row행사
2nd row행사
3rd row행사
4th row어린이프로그램
5th row어린이프로그램

Common Values

ValueCountFrequency (%)
공연 80
51.9%
행사 37
24.0%
전시 24
 
15.6%
어린이프로그램 7
 
4.5%
영화 6
 
3.9%

Length

2023-12-13T05:23:53.245179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:23:53.344891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공연 80
51.9%
행사 37
24.0%
전시 24
 
15.6%
어린이프로그램 7
 
4.5%
영화 6
 
3.9%

공연명
Categorical

HIGH CORRELATION 

Distinct47
Distinct (%)30.5%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2020 문화창조원 통합관람권
 
4
2020 ACC 브런치<하피스트 곽정하피데이 앙상블의 하프 콘서트>
 
4
2020 유아놀이터
 
4
2020 어린이체험관
 
4
2020 ACC 브런치콘서트 연간 패키지
 
4
Other values (42)
134 

Length

Max length44
Median length31
Mean length23.454545
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021 유아놀이터
2nd row2021 유아놀이터
3rd row2021 유아놀이터
4th row2021 어린이체험관
5th row2021 어린이체험관

Common Values

ValueCountFrequency (%)
2020 문화창조원 통합관람권 4
 
2.6%
2020 ACC 브런치<하피스트 곽정하피데이 앙상블의 하프 콘서트> 4
 
2.6%
2020 유아놀이터 4
 
2.6%
2020 어린이체험관 4
 
2.6%
2020 ACC 브런치콘서트 연간 패키지 4
 
2.6%
2020 ACC 브런치<TIMF앙상블 X 성민제 트위스트 인 클래식> 4
 
2.6%
2020 어린이극장 활성화사업<하티와 광대들> 4
 
2.6%
2020 어린이도서관 4
 
2.6%
2020 라이브러리파크 4
 
2.6%
2020 ACC 브런치<타악그룹 타고의 MAN AND DRUM> 4
 
2.6%
Other values (37) 114
74.0%

Length

2023-12-13T05:23:53.476201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2020 102
 
14.6%
acc 70
 
10.0%
어린이극장 12
 
1.7%
인 11
 
1.6%
40주년 9
 
1.3%
콘서트 8
 
1.1%
통합관람권 7
 
1.0%
5.18 7
 
1.0%
and 7
 
1.0%
브런치<재즈 7
 
1.0%
Other values (132) 457
65.6%

장르
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)10.4%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
콘서트
44 
기타
15 
복합
14 
전시
14 
체험
13 
Other values (11)
54 

Length

Max length5
Median length2
Mean length2.5584416
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기타
2nd row기타
3rd row기타
4th row체험
5th row체험

Common Values

ValueCountFrequency (%)
콘서트 44
28.6%
기타 15
 
9.7%
복합 14
 
9.1%
전시 14
 
9.1%
체험 13
 
8.4%
영화 9
 
5.8%
연극 7
 
4.5%
가족,아동 7
 
4.5%
인형극 6
 
3.9%
공연 5
 
3.2%
Other values (6) 20
13.0%

Length

2023-12-13T05:23:53.603487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
콘서트 44
28.6%
기타 15
 
9.7%
복합 14
 
9.1%
전시 14
 
9.1%
체험 13
 
8.4%
영화 9
 
5.8%
연극 7
 
4.5%
가족,아동 7
 
4.5%
인형극 6
 
3.9%
공연 5
 
3.2%
Other values (6) 20
13.0%

대상
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
8세이상
65 
전체관람
54 
5세 이상
21 
14세이상
 
4
12세이상
 
3
Other values (3)
7 

Length

Max length5
Median length4
Mean length4.2142857
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전체관람
2nd row전체관람
3rd row전체관람
4th row전체관람
5th row전체관람

Common Values

ValueCountFrequency (%)
8세이상 65
42.2%
전체관람 54
35.1%
5세 이상 21
 
13.6%
14세이상 4
 
2.6%
12세이상 3
 
1.9%
10세이상 3
 
1.9%
4세 이상 2
 
1.3%
7세이상 2
 
1.3%

Length

2023-12-13T05:23:53.722223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:23:53.887238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
8세이상 65
36.7%
전체관람 54
30.5%
이상 23
 
13.0%
5세 21
 
11.9%
14세이상 4
 
2.3%
12세이상 3
 
1.7%
10세이상 3
 
1.7%
4세 2
 
1.1%
7세이상 2
 
1.1%

상영시간(분)
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
90
45 
30 
60
17 
100
13 
50
13 
Other values (8)
36 

Length

Max length4
Median length2
Mean length2.512987
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
90 45
29.2%
30
19.5%
60 17
 
11.0%
100 13
 
8.4%
50 13
 
8.4%
70 8
 
5.2%
95 7
 
4.5%
75 6
 
3.9%
45 4
 
2.6%
150 3
 
1.9%
Other values (3) 8
 
5.2%

Length

2023-12-13T05:23:54.036652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
90 45
36.3%
60 17
 
13.7%
100 13
 
10.5%
50 13
 
10.5%
70 8
 
6.5%
95 7
 
5.6%
75 6
 
4.8%
45 4
 
3.2%
150 3
 
2.4%
65 3
 
2.4%
Other values (2) 5
 
4.0%

공연시작일
Date

Distinct42
Distinct (%)27.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Minimum2019-09-05 00:00:00
Maximum2021-01-02 00:00:00
2023-12-13T05:23:54.240245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:23:54.382055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)

공연종료일
Date

Distinct37
Distinct (%)24.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Minimum2020-01-24 00:00:00
Maximum2021-12-31 00:00:00
2023-12-13T05:23:54.564550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:23:54.697908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)

요금정보
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
유료
91 
무료
63 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row무료
2nd row무료
3rd row무료
4th row유료
5th row유료

Common Values

ValueCountFrequency (%)
유료 91
59.1%
무료 63
40.9%

Length

2023-12-13T05:23:54.858346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:23:54.998988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유료 91
59.1%
무료 63
40.9%

창구
Categorical

Distinct4
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Mobile
47 
PC
47 
현장
40 
콜센터
20 

Length

Max length6
Median length2
Mean length3.3506494
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMobile
2nd rowPC
3rd row현장
4th rowMobile
5th rowPC

Common Values

ValueCountFrequency (%)
Mobile 47
30.5%
PC 47
30.5%
현장 40
26.0%
콜센터 20
13.0%

Length

2023-12-13T05:23:55.130708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:23:55.267815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mobile 47
30.5%
pc 47
30.5%
현장 40
26.0%
콜센터 20
13.0%

거래건수
Real number (ℝ)

Distinct105
Distinct (%)68.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean162.17532
Minimum1
Maximum5171
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T05:23:55.414797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q129
median57.5
Q3137.25
95-th percentile463.3
Maximum5171
Range5170
Interquartile range (IQR)108.25

Descriptive statistics

Standard deviation459.36932
Coefficient of variation (CV)2.8325476
Kurtosis94.123637
Mean162.17532
Median Absolute Deviation (MAD)47.5
Skewness8.9572412
Sum24975
Variance211020.17
MonotonicityNot monotonic
2023-12-13T05:23:55.591719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 6
 
3.9%
1 4
 
2.6%
39 4
 
2.6%
33 4
 
2.6%
3 4
 
2.6%
32 3
 
1.9%
42 3
 
1.9%
10 3
 
1.9%
60 3
 
1.9%
63 3
 
1.9%
Other values (95) 117
76.0%
ValueCountFrequency (%)
1 4
2.6%
2 6
3.9%
3 4
2.6%
4 3
1.9%
5 2
 
1.3%
6 2
 
1.3%
7 2
 
1.3%
8 1
 
0.6%
9 1
 
0.6%
10 3
1.9%
ValueCountFrequency (%)
5171 1
0.6%
1697 1
0.6%
1163 1
0.6%
877 1
0.6%
875 1
0.6%
637 1
0.6%
559 1
0.6%
488 1
0.6%
450 1
0.6%
429 1
0.6%

가격
Real number (ℝ)

ZEROS 

Distinct88
Distinct (%)57.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean937237.01
Minimum0
Maximum12000000
Zeros63
Zeros (%)40.9%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T05:23:55.775133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median79000
Q3988125
95-th percentile6235200
Maximum12000000
Range12000000
Interquartile range (IQR)988125

Descriptive statistics

Standard deviation1968316.9
Coefficient of variation (CV)2.1001271
Kurtosis10.801304
Mean937237.01
Median Absolute Deviation (MAD)79000
Skewness3.1981992
Sum1.443345 × 108
Variance3.8742712 × 1012
MonotonicityNot monotonic
2023-12-13T05:23:55.961116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 63
40.9%
57500 2
 
1.3%
200000 2
 
1.3%
510000 2
 
1.3%
1140000 2
 
1.3%
3402000 1
 
0.6%
1744000 1
 
0.6%
226000 1
 
0.6%
984000 1
 
0.6%
2246000 1
 
0.6%
Other values (78) 78
50.6%
ValueCountFrequency (%)
0 63
40.9%
7000 1
 
0.6%
10000 1
 
0.6%
12000 1
 
0.6%
19500 1
 
0.6%
30000 1
 
0.6%
34000 1
 
0.6%
35000 1
 
0.6%
45000 1
 
0.6%
57500 2
 
1.3%
ValueCountFrequency (%)
12000000 1
0.6%
8855000 1
0.6%
8122000 1
0.6%
7584000 1
0.6%
7311000 1
0.6%
7220000 1
0.6%
7000000 1
0.6%
6932000 1
0.6%
5860000 1
0.6%
4910000 1
0.6%

Interactions

2023-12-13T05:23:52.468978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:23:52.283746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:23:52.563359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:23:52.372420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:23:56.073315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분공연명장르대상상영시간(분)공연시작일공연종료일요금정보창구거래건수가격
구분1.0001.0000.9120.7110.8210.9790.8900.5880.0000.4610.117
공연명1.0001.0001.0001.0001.0001.0001.0001.0000.0000.0000.000
장르0.9121.0001.0000.9430.8970.9970.9920.9310.0000.0000.288
대상0.7111.0000.9431.0000.9210.9820.9890.5320.0000.0000.371
상영시간(분)0.8211.0000.8970.9211.0000.9910.9850.5920.0000.0000.418
공연시작일0.9791.0000.9970.9820.9911.0000.9980.9920.0000.0000.169
공연종료일0.8901.0000.9920.9890.9850.9981.0000.8960.0000.0000.425
요금정보0.5881.0000.9310.5320.5920.9920.8961.0000.0000.1450.390
창구0.0000.0000.0000.0000.0000.0000.0000.0001.0000.0000.172
거래건수0.4610.0000.0000.0000.0000.0000.0000.1450.0001.0000.606
가격0.1170.0000.2880.3710.4180.1690.4250.3900.1720.6061.000
2023-12-13T05:23:56.218986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공연명상영시간(분)요금정보창구장르대상구분
공연명1.0000.8710.8390.0000.8810.8560.847
상영시간(분)0.8711.0000.5350.0000.5950.7430.612
요금정보0.8390.5351.0000.0000.7600.3930.703
창구0.0000.0000.0001.0000.0000.0000.000
장르0.8810.5950.7600.0001.0000.6320.729
대상0.8560.7430.3930.0000.6321.0000.535
구분0.8470.6120.7030.0000.7290.5351.000
2023-12-13T05:23:56.359408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
거래건수가격구분공연명장르대상상영시간(분)요금정보창구
거래건수1.0000.1780.1870.0000.0000.0000.0000.1750.000
가격0.1781.0000.0640.0000.1170.1900.1890.3810.107
구분0.1870.0641.0000.8470.7290.5350.6120.7030.000
공연명0.0000.0000.8471.0000.8810.8560.8710.8390.000
장르0.0000.1170.7290.8811.0000.6320.5950.7600.000
대상0.0000.1900.5350.8560.6321.0000.7430.3930.000
상영시간(분)0.0000.1890.6120.8710.5950.7431.0000.5350.000
요금정보0.1750.3810.7030.8390.7600.3930.5351.0000.000
창구0.0000.1070.0000.0000.0000.0000.0000.0001.000

Missing values

2023-12-13T05:23:52.690278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:23:52.829168image/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행사2021 유아놀이터기타전체관람2021-01-022021-12-31무료Mobile3840
1행사2021 유아놀이터기타전체관람2021-01-022021-12-31무료PC480
2행사2021 유아놀이터기타전체관람2021-01-022021-12-31무료현장120
3어린이프로그램2021 어린이체험관체험전체관람2021-01-012021-12-31유료Mobile104200000
4어린이프로그램2021 어린이체험관체험전체관람2021-01-012021-12-31유료PC3157500
5어린이프로그램2021 어린이체험관체험전체관람2021-01-012021-12-31유료현장47000
6공연2020 현대무용 인큐베이팅<호모 루피엔스>무용8세이상602020-12-242020-12-24무료Mobile330
7공연2020 현대무용 인큐베이팅<호모 루피엔스>무용8세이상602020-12-242020-12-24무료PC270
8공연2020 현대무용 인큐베이팅<호모 루피엔스>무용8세이상602020-12-242020-12-24무료현장60
9공연2020 ACC 송년음악회콘서트8세이상952020-12-192020-12-19무료Mobile540
구분공연명장르대상상영시간(분)공연시작일공연종료일요금정보창구거래건수가격
144공연2020년 설맞이 특별공연 <쿵짝 두 번째 이야기-얼쑤>가족,아동8세이상1002020-01-242020-01-24유료Mobile54747000
145공연2020년 설맞이 특별공연 <쿵짝 두 번째 이야기-얼쑤>가족,아동8세이상1002020-01-242020-01-24유료PC32375000
146공연2020년 설맞이 특별공연 <쿵짝 두 번째 이야기-얼쑤>가족,아동8세이상1002020-01-242020-01-24유료현장862500
147어린이프로그램2020 어린이체험관체험전체관람602020-01-012020-12-31유료Mobile11633905900
148어린이프로그램2020 어린이체험관체험전체관람602020-01-012020-12-31유료PC4161216600
149어린이프로그램2020 어린이체험관체험전체관람602020-01-012020-12-31유료콜센터42115500
150어린이프로그램2020 어린이체험관체험전체관람602020-01-012020-12-31유료현장54132500
151전시2019 문화창조원 통합관람권전시전체관람602019-09-052020-02-23유료Mobile2794000
152전시2019 문화창조원 통합관람권전시전체관람602019-09-052020-02-23유료PC1134000
153전시2019 문화창조원 통합관람권전시전체관람602019-09-052020-02-23유료현장312000