Overview

Dataset statistics

Number of variables5
Number of observations696
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory29.4 KiB
Average record size in memory43.2 B

Variable types

DateTime1
Numeric2
Categorical2

Dataset

Description전북특별자치도 투어패스 이용통계1일권-경기전1일권-경기전2일권-경기전2일권-순창 천재의공간 영화산책(순창 작은 영화관)3일권-무주 태권도원 매표소한옥마을권-경기전
Author전북특별자치도
URLhttps://www.data.go.kr/data/15120922/fileData.do

Alerts

상품아이디 has constant value ""Constant
상품번호 is highly overall correlated with 종류High correlation
종류 is highly overall correlated with 상품번호High correlation
판매량 is highly skewed (γ1 = 21.00037642)Skewed

Reproduction

Analysis started2024-03-14 20:55:07.064594
Analysis finished2024-03-14 20:55:08.916697
Duration1.85 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일자
Date

Distinct59
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Minimum2017-02-01 00:00:00
Maximum2022-07-01 00:00:00
2024-03-15T05:55:09.119304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:55:09.567379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상품번호
Real number (ℝ)

HIGH CORRELATION 

Distinct47
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30.95977
Minimum11
Maximum101
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.2 KiB
2024-03-15T05:55:09.994128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile11
Q114
median20
Q339
95-th percentile85
Maximum101
Range90
Interquartile range (IQR)25

Descriptive statistics

Standard deviation23.988992
Coefficient of variation (CV)0.77484401
Kurtosis0.35708675
Mean30.95977
Median Absolute Deviation (MAD)7
Skewness1.2981059
Sum21548
Variance575.47176
MonotonicityNot monotonic
2024-03-15T05:55:10.428708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
12 60
 
8.6%
11 59
 
8.5%
21 54
 
7.8%
15 49
 
7.0%
20 49
 
7.0%
13 41
 
5.9%
14 40
 
5.7%
18 37
 
5.3%
38 26
 
3.7%
27 24
 
3.4%
Other values (37) 257
36.9%
ValueCountFrequency (%)
11 59
8.5%
12 60
8.6%
13 41
5.9%
14 40
5.7%
15 49
7.0%
16 12
 
1.7%
17 19
 
2.7%
18 37
5.3%
20 49
7.0%
21 54
7.8%
ValueCountFrequency (%)
101 1
 
0.1%
99 3
0.4%
96 3
0.4%
93 2
 
0.3%
92 2
 
0.3%
91 4
0.6%
90 4
0.6%
88 4
0.6%
87 4
0.6%
86 7
1.0%

상품아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
1
696 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 696
100.0%

Length

2024-03-15T05:55:10.730972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:55:10.903801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 696
100.0%

판매량
Real number (ℝ)

SKEWED 

Distinct339
Distinct (%)48.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean548.48994
Minimum0
Maximum71712
Zeros3
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size6.2 KiB
2024-03-15T05:55:11.089898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q19
median44
Q3340.5
95-th percentile2363.75
Maximum71712
Range71712
Interquartile range (IQR)331.5

Descriptive statistics

Standard deviation2936.9895
Coefficient of variation (CV)5.3546825
Kurtosis499.62703
Mean548.48994
Median Absolute Deviation (MAD)42
Skewness21.000376
Sum381749
Variance8625907.4
MonotonicityNot monotonic
2024-03-15T05:55:11.364886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 45
 
6.5%
4 28
 
4.0%
6 24
 
3.4%
1 23
 
3.3%
8 18
 
2.6%
10 16
 
2.3%
12 14
 
2.0%
9 13
 
1.9%
3 13
 
1.9%
18 11
 
1.6%
Other values (329) 491
70.5%
ValueCountFrequency (%)
0 3
 
0.4%
1 23
3.3%
2 45
6.5%
3 13
 
1.9%
4 28
4.0%
5 8
 
1.1%
6 24
3.4%
7 8
 
1.1%
8 18
 
2.6%
9 13
 
1.9%
ValueCountFrequency (%)
71712 1
0.1%
17740 1
0.1%
13978 1
0.1%
5584 1
0.1%
4850 1
0.1%
4590 1
0.1%
4266 1
0.1%
4252 1
0.1%
3724 1
0.1%
3652 1
0.1%

종류
Categorical

HIGH CORRELATION 

Distinct42
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
1일권-경기전
160 
한옥마을권-경기전
103 
2일권-순창 천재의공간 영화산책(순창 작은 영화관)
49 
2일권-경기전
40 
3일권-경기전
37 
Other values (37)
307 

Length

Max length35
Median length28
Mean length13.181034
Min length7

Unique

Unique2 ?
Unique (%)0.3%

Sample

1st row1일권-경기전
2nd row1일권-경기전
3rd row2일권-경기전
4th row2일권-순창 천재의공간 영화산책(순창 작은 영화관)
5th row3일권-무주 태권도원 매표소

Common Values

ValueCountFrequency (%)
1일권-경기전 160
23.0%
한옥마을권-경기전 103
14.8%
2일권-순창 천재의공간 영화산책(순창 작은 영화관) 49
 
7.0%
2일권-경기전 40
 
5.7%
3일권-경기전 37
 
5.3%
남원춘향여행권-광한루원 36
 
5.2%
무주반디여행권-반디랜드 곤충박물관 28
 
4.0%
한옥마을종합권(한복대여,사진)-경기전 24
 
3.4%
3일권-무주 태권도원 매표소 19
 
2.7%
한옥마을권 + 한복 대여권-경기전 17
 
2.4%
Other values (32) 183
26.3%

Length

2024-03-15T05:55:11.841970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1일권-경기전 160
 
12.5%
한옥마을권-경기전 103
 
8.1%
60
 
4.7%
2일권-순창 49
 
3.8%
한옥마을권 49
 
3.8%
영화산책(순창 49
 
3.8%
작은 49
 
3.8%
영화관 49
 
3.8%
천재의공간 49
 
3.8%
2일권-경기전 40
 
3.1%
Other values (69) 619
48.5%

Interactions

2024-03-15T05:55:07.794754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:55:07.276526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:55:08.053904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:55:07.523425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T05:55:12.022752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일자상품번호판매량종류
일자1.0000.3300.4070.000
상품번호0.3301.0000.0000.996
판매량0.4070.0001.0000.000
종류0.0000.9960.0001.000
2024-03-15T05:55:12.274447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상품번호판매량종류
상품번호1.000-0.2670.916
판매량-0.2671.0000.000
종류0.9160.0001.000

Missing values

2024-03-15T05:55:08.476524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T05:55:08.793653image/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

일자상품번호상품아이디판매량종류
02017-021111111일권-경기전
12017-021211041일권-경기전
22017-02141332일권-경기전
32017-02151492일권-순창 천재의공간 영화산책(순창 작은 영화관)
42017-0217123일권-무주 태권도원 매표소
52017-02201483한옥마을권-경기전
62017-0221194한옥마을권-경기전
72017-031111941일권-경기전
82017-031211051일권-경기전
92017-0313121일권-경기전
일자상품번호상품아이디판매량종류
6862022-052018한옥마을권-경기전
6872022-06111711일권-경기전
6882022-061212271일권-경기전
6892022-07111461일권-경기전
6902022-071211741일권-경기전
6912022-0715162일권-순창 천재의공간 영화산책(순창 작은 영화관)
6922022-0711121일권-경기전
6932022-0712101일권-경기전
6942022-0715102일권-순창 천재의공간 영화산책(순창 작은 영화관)
6952022-072110한옥마을권-경기전