Overview

Dataset statistics

Number of variables3
Number of observations314
Missing cells38
Missing cells (%)4.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory26.4 B

Variable types

Numeric2
Text1

Dataset

Description한국콘텐츠진흥원의 홍릉 시연장(문화광장)에 관한 좌석예약 정보를 나타내는 데이터 자료 입니다. 주로 좌석에 대한 데이터 입니다.
Author한국콘텐츠진흥원
URLhttps://www.data.go.kr/data/15041614/fileData.do

Alerts

순번 is highly overall correlated with 공연회차번호High correlation
공연회차번호 is highly overall correlated with 순번High correlation
좌석번호 has 38 (12.1%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:46:27.094694
Analysis finished2023-12-12 19:46:27.920780
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct314
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean178.63694
Minimum1
Maximum352
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-13T04:46:28.051028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile18.65
Q186.25
median179.5
Q3272.75
95-th percentile335.35
Maximum352
Range351
Interquartile range (IQR)186.5

Descriptive statistics

Standard deviation105.0382
Coefficient of variation (CV)0.58799822
Kurtosis-1.310194
Mean178.63694
Median Absolute Deviation (MAD)93.5
Skewness-0.026596031
Sum56092
Variance11033.024
MonotonicityStrictly increasing
2023-12-13T04:46:28.337940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
245 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%
244 1
 
0.3%
Other values (304) 304
96.8%
ValueCountFrequency (%)
1 1
0.3%
2 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%
11 1
0.3%
12 1
0.3%
ValueCountFrequency (%)
352 1
0.3%
351 1
0.3%
350 1
0.3%
349 1
0.3%
348 1
0.3%
347 1
0.3%
346 1
0.3%
345 1
0.3%
344 1
0.3%
342 1
0.3%

좌석번호
Text

MISSING 

Distinct133
Distinct (%)48.2%
Missing38
Missing (%)12.1%
Memory size2.6 KiB
2023-12-13T04:46:28.791233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)14.9%

Sample

1st rowA01
2nd rowB05
3rd rowB04
4th rowD06
5th rowB09
ValueCountFrequency (%)
a01 9
 
3.3%
b08 6
 
2.2%
z02 6
 
2.2%
a03 6
 
2.2%
f09 4
 
1.4%
c05 4
 
1.4%
z01 4
 
1.4%
g08 4
 
1.4%
k18 4
 
1.4%
k19 4
 
1.4%
Other values (123) 225
81.5%
2023-12-13T04:46:29.401959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 176
21.3%
1 123
14.9%
K 75
9.1%
2 64
 
7.7%
J 51
 
6.2%
A 37
 
4.5%
8 35
 
4.2%
3 33
 
4.0%
5 29
 
3.5%
9 27
 
3.3%
Other values (12) 178
21.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 552
66.7%
Uppercase Letter 276
33.3%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
K 75
27.2%
J 51
18.5%
A 37
13.4%
B 23
 
8.3%
E 17
 
6.2%
C 16
 
5.8%
G 14
 
5.1%
F 12
 
4.3%
Z 10
 
3.6%
I 8
 
2.9%
Other values (2) 13
 
4.7%
Decimal Number
ValueCountFrequency (%)
0 176
31.9%
1 123
22.3%
2 64
 
11.6%
8 35
 
6.3%
3 33
 
6.0%
5 29
 
5.3%
9 27
 
4.9%
4 24
 
4.3%
6 21
 
3.8%
7 20
 
3.6%

Most occurring scripts

ValueCountFrequency (%)
Common 552
66.7%
Latin 276
33.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
K 75
27.2%
J 51
18.5%
A 37
13.4%
B 23
 
8.3%
E 17
 
6.2%
C 16
 
5.8%
G 14
 
5.1%
F 12
 
4.3%
Z 10
 
3.6%
I 8
 
2.9%
Other values (2) 13
 
4.7%
Common
ValueCountFrequency (%)
0 176
31.9%
1 123
22.3%
2 64
 
11.6%
8 35
 
6.3%
3 33
 
6.0%
5 29
 
5.3%
9 27
 
4.9%
4 24
 
4.3%
6 21
 
3.8%
7 20
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 828
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 176
21.3%
1 123
14.9%
K 75
9.1%
2 64
 
7.7%
J 51
 
6.2%
A 37
 
4.5%
8 35
 
4.2%
3 33
 
4.0%
5 29
 
3.5%
9 27
 
3.3%
Other values (12) 178
21.5%

공연회차번호
Real number (ℝ)

HIGH CORRELATION 

Distinct52
Distinct (%)16.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean174.09554
Minimum1
Maximum529
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-13T04:46:29.640554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.65
Q122
median223
Q3306
95-th percentile307
Maximum529
Range528
Interquartile range (IQR)284

Descriptive statistics

Standard deviation135.20961
Coefficient of variation (CV)0.7766403
Kurtosis-1.5183745
Mean174.09554
Median Absolute Deviation (MAD)84
Skewness0.026430144
Sum54666
Variance18281.639
MonotonicityNot monotonic
2023-12-13T04:46:29.827999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
306 60
19.1%
307 58
18.5%
11 29
 
9.2%
58 14
 
4.5%
224 13
 
4.1%
17 12
 
3.8%
15 12
 
3.8%
223 9
 
2.9%
10 8
 
2.5%
14 7
 
2.2%
Other values (42) 92
29.3%
ValueCountFrequency (%)
1 1
 
0.3%
2 1
 
0.3%
9 6
 
1.9%
10 8
 
2.5%
11 29
9.2%
13 2
 
0.6%
14 7
 
2.2%
15 12
3.8%
17 12
3.8%
22 3
 
1.0%
ValueCountFrequency (%)
529 1
 
0.3%
500 1
 
0.3%
477 1
 
0.3%
423 1
 
0.3%
408 1
 
0.3%
393 4
 
1.3%
307 58
18.5%
306 60
19.1%
251 1
 
0.3%
234 2
 
0.6%

Interactions

2023-12-13T04:46:27.415910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:46:27.186627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:46:27.540208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:46:27.304603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:46:29.945072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번공연회차번호
순번1.0000.813
공연회차번호0.8131.000
2023-12-13T04:46:30.062073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번공연회차번호
순번1.0000.900
공연회차번호0.9001.000

Missing values

2023-12-13T04:46:27.713322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:46:27.865679image/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

순번좌석번호공연회차번호
01A011
12B052
25B0411
36D0611
47B0911
58D0911
69C1011
710K2011
811K1911
912K1811
순번좌석번호공연회차번호
304342A09306
305344E07393
306345E06393
307346E05393
308347E04393
309348C06408
310349G08423
311350B08477
312351B07529
313352D08500