Overview

Dataset statistics

Number of variables9
Number of observations165
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.2 KiB
Average record size in memory75.8 B

Variable types

Numeric3
Categorical4
DateTime2

Dataset

Description경상남도 도립미술관 티켓 판매 취소 내역 현황입니다.판매취소 내역의 티켓장수, 원금, 구입날짜, 구입시간 등에 관한 정보를 제공합니다.
Author경상남도
URLhttps://www.data.go.kr/data/15039895/fileData.do

Alerts

관리기관 has constant value ""Constant
관리기관연락처 has constant value ""Constant
데이터기준일자 has constant value ""Constant
인원 is highly overall correlated with 결제금액 and 1 other fieldsHigh correlation
결제금액 is highly overall correlated with 인원 and 1 other fieldsHigh correlation
권종 및 인원 is highly overall correlated with 인원 and 1 other fieldsHigh correlation
순번 has unique valuesUnique
결제일시 has unique valuesUnique
결제금액 has 56 (33.9%) zerosZeros

Reproduction

Analysis started2024-04-13 11:14:26.069365
Analysis finished2024-04-13 11:14:32.386947
Duration6.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct165
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean83
Minimum1
Maximum165
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-13T20:14:32.594952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.2
Q142
median83
Q3124
95-th percentile156.8
Maximum165
Range164
Interquartile range (IQR)82

Descriptive statistics

Standard deviation47.775517
Coefficient of variation (CV)0.57560864
Kurtosis-1.2
Mean83
Median Absolute Deviation (MAD)41
Skewness0
Sum13695
Variance2282.5
MonotonicityStrictly increasing
2024-04-13T20:14:32.934980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
105 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
Other values (155) 155
93.9%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
165 1
0.6%
164 1
0.6%
163 1
0.6%
162 1
0.6%
161 1
0.6%
160 1
0.6%
159 1
0.6%
158 1
0.6%
157 1
0.6%
156 1
0.6%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
경상남도도립미술관
165 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경상남도도립미술관
2nd row경상남도도립미술관
3rd row경상남도도립미술관
4th row경상남도도립미술관
5th row경상남도도립미술관

Common Values

ValueCountFrequency (%)
경상남도도립미술관 165
100.0%

Length

2024-04-13T20:14:33.164777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T20:14:33.354090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경상남도도립미술관 165
100.0%

관리기관연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
055-254-4601
165 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row055-254-4601
2nd row055-254-4601
3rd row055-254-4601
4th row055-254-4601
5th row055-254-4601

Common Values

ValueCountFrequency (%)
055-254-4601 165
100.0%

Length

2024-04-13T20:14:33.528474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T20:14:33.703937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
055-254-4601 165
100.0%

권종 및 인원
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)13.9%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
어른 유료:2명
50 
어른 유료:1명
34 
어린이 무료(8세 이하):1명
18 
청소년 무료(초중고 포함):1명
17 
어른 유료:3명
9 
Other values (18)
37 

Length

Max length24
Median length8
Mean length10.933333
Min length7

Unique

Unique12 ?
Unique (%)7.3%

Sample

1st row청소년 무료(초중고 포함):1명
2nd row어른 유료:2명
3rd row어른 유료:2명
4th row어른 유료:1명
5th row청소년 무료(초중고 포함):1명

Common Values

ValueCountFrequency (%)
어른 유료:2명 50
30.3%
어른 유료:1명 34
20.6%
어린이 무료(8세 이하):1명 18
 
10.9%
청소년 무료(초중고 포함):1명 17
 
10.3%
어른 유료:3명 9
 
5.5%
청소년·군인 유료:1명 7
 
4.2%
청소년 무료(초중고 포함):2명 6
 
3.6%
어린이 무료(8세 이하):2명 4
 
2.4%
경로 무료:1명 3
 
1.8%
어른 유료:4명 3
 
1.8%
Other values (13) 14
 
8.5%

Length

2024-04-13T20:14:33.909871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
어른 97
25.4%
유료:2명 52
13.6%
유료:1명 41
10.7%
청소년 25
 
6.5%
무료(초중고 24
 
6.3%
어린이 23
 
6.0%
무료(8세 23
 
6.0%
이하):1명 18
 
4.7%
포함):1명 17
 
4.5%
유료:3명 9
 
2.4%
Other values (24) 53
13.9%

인원
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.8727273
Minimum1
Maximum34
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-13T20:14:34.094295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q32
95-th percentile3
Maximum34
Range33
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.7389771
Coefficient of variation (CV)1.4625606
Kurtosis117.33506
Mean1.8727273
Median Absolute Deviation (MAD)0
Skewness10.190203
Sum309
Variance7.5019956
MonotonicityNot monotonic
2024-04-13T20:14:34.307742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
1 84
50.9%
2 65
39.4%
3 9
 
5.5%
4 4
 
2.4%
8 1
 
0.6%
34 1
 
0.6%
10 1
 
0.6%
ValueCountFrequency (%)
1 84
50.9%
2 65
39.4%
3 9
 
5.5%
4 4
 
2.4%
8 1
 
0.6%
10 1
 
0.6%
34 1
 
0.6%
ValueCountFrequency (%)
34 1
 
0.6%
10 1
 
0.6%
8 1
 
0.6%
4 4
 
2.4%
3 9
 
5.5%
2 65
39.4%
1 84
50.9%

결제방식
Categorical

Distinct2
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
카드
109 
현금
56 

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 (%)
카드 109
66.1%
현금 56
33.9%

Length

2024-04-13T20:14:34.652878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T20:14:34.873914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
카드 109
66.1%
현금 56
33.9%

결제금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct8
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1113.3333
Minimum0
Maximum4000
Zeros56
Zeros (%)33.9%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-04-13T20:14:35.176824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1000
Q32000
95-th percentile3000
Maximum4000
Range4000
Interquartile range (IQR)2000

Descriptive statistics

Standard deviation1013.1172
Coefficient of variation (CV)0.90998553
Kurtosis-0.41538676
Mean1113.3333
Median Absolute Deviation (MAD)1000
Skewness0.52956346
Sum183700
Variance1026406.5
MonotonicityNot monotonic
2024-04-13T20:14:35.564149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 56
33.9%
2000 50
30.3%
1000 36
21.8%
3000 9
 
5.5%
700 7
 
4.2%
4000 3
 
1.8%
1400 2
 
1.2%
500 2
 
1.2%
ValueCountFrequency (%)
0 56
33.9%
500 2
 
1.2%
700 7
 
4.2%
1000 36
21.8%
1400 2
 
1.2%
2000 50
30.3%
3000 9
 
5.5%
4000 3
 
1.8%
ValueCountFrequency (%)
4000 3
 
1.8%
3000 9
 
5.5%
2000 50
30.3%
1400 2
 
1.2%
1000 36
21.8%
700 7
 
4.2%
500 2
 
1.2%
0 56
33.9%

결제일시
Date

UNIQUE 

Distinct165
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2023-03-22 13:48:00
Maximum2024-01-01 14:35:00
2024-04-13T20:14:36.002570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:36.321294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2023-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-04-13T20:14:36.641601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:36.919870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-13T20:14:30.773032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:28.898331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:29.963990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:31.038271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:29.354771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:30.230822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:31.316213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:29.691860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:14:30.498219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-13T20:14:37.129021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번권종 및 인원인원결제방식결제금액
순번1.0000.0000.0000.4100.000
권종 및 인원0.0001.0001.0000.0951.000
인원0.0001.0001.0000.0210.000
결제방식0.4100.0950.0211.0000.000
결제금액0.0001.0000.0000.0001.000
2024-04-13T20:14:37.383170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
권종 및 인원결제방식
권종 및 인원1.0000.071
결제방식0.0711.000
2024-04-13T20:14:37.623741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번인원결제금액권종 및 인원결제방식
순번1.0000.2240.0200.0000.298
인원0.2241.0000.6240.9360.034
결제금액0.0200.6241.0000.9480.000
권종 및 인원0.0000.9360.9481.0000.071
결제방식0.2980.0340.0000.0711.000

Missing values

2024-04-13T20:14:31.713119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-13T20:14:32.192422image/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

순번관리기관관리기관연락처권종 및 인원인원결제방식결제금액결제일시데이터기준일자
01경상남도도립미술관055-254-4601청소년 무료(초중고 포함):1명1카드02023-03-31 16:482023-12-31
12경상남도도립미술관055-254-4601어른 유료:2명2카드20002023-04-01 16:482023-12-31
23경상남도도립미술관055-254-4601어른 유료:2명2카드20002023-03-31 10:382023-12-31
34경상남도도립미술관055-254-4601어른 유료:1명1현금10002023-03-30 13:112023-12-31
45경상남도도립미술관055-254-4601청소년 무료(초중고 포함):1명1카드02023-03-28 14:092023-12-31
56경상남도도립미술관055-254-4601어른 유료:1명1카드10002023-03-29 14:092023-12-31
67경상남도도립미술관055-254-4601어린이 무료(8세 이하):1명1카드02023-03-30 14:092023-12-31
78경상남도도립미술관055-254-4601어린이 무료(8세 이하):1명1카드02023-03-26 14:342023-12-31
89경상남도도립미술관055-254-4601어른 유료:2명2카드20002023-03-27 14:342023-12-31
910경상남도도립미술관055-254-4601어린이 무료(8세 이하):1명1현금02023-03-25 15:492023-12-31
순번관리기관관리기관연락처권종 및 인원인원결제방식결제금액결제일시데이터기준일자
155156경상남도도립미술관055-254-4601어른 유료:1명1현금10002023-11-30 11:582023-12-31
156157경상남도도립미술관055-254-4601어른 유료:1명1현금10002023-11-28 16:522023-12-31
157158경상남도도립미술관055-254-4601청소년 무료(초중고 포함):2명2카드02023-11-26 14:052023-12-31
158159경상남도도립미술관055-254-4601어른 유료:2명2카드20002023-11-27 14:052023-12-31
159160경상남도도립미술관055-254-4601어른 유료:3명3카드30002023-11-26 13:302023-12-31
160161경상남도도립미술관055-254-4601어린이 무료(8세 이하):34명34현금02023-11-07 09:572023-12-31
161162경상남도도립미술관055-254-4601복지카드 무료:10명10현금02023-10-18 11:502023-12-31
162163경상남도도립미술관055-254-4601어른 무료:2명2현금02023-10-19 11:502023-12-31
163164경상남도도립미술관055-254-4601어린이 무료(8세 이하):1명1현금02023-10-20 11:502023-12-31
164165경상남도도립미술관055-254-4601청소년 무료(19세 이상~24세 이하):4명4현금02023-10-21 11:502023-12-31