Overview

Dataset statistics

Number of variables7
Number of observations28
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory62.6 B

Variable types

DateTime2
Categorical3
Numeric2

Dataset

Description경기도 수원시 수목원 이용 매표 현황으로 시설별 해당연월, 매표유형, 이용자 수, 매표 수익에 대한 데이터를 포함합니다.
Author경기도 수원시
URLhttps://www.data.go.kr/data/15117190/fileData.do

Alerts

데이터 기준일자 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 16 (57.1%) zerosZeros

Reproduction

Analysis started2024-03-14 13:14:55.482959
Analysis finished2024-03-14 13:14:57.298723
Duration1.82 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연월
Date

Distinct8
Distinct (%)28.6%
Missing0
Missing (%)0.0%
Memory size352.0 B
Minimum2023-05-01 00:00:00
Maximum2023-12-01 00:00:00
2024-03-14T22:14:57.442474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:14:57.753823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)

시설구분
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size352.0 B
일월수목원
14 
영흥수목원
14 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일월수목원
2nd row영흥수목원
3rd row일월수목원
4th row영흥수목원
5th row일월수목원

Common Values

ValueCountFrequency (%)
일월수목원 14
50.0%
영흥수목원 14
50.0%

Length

2024-03-14T22:14:57.986638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T22:14:58.152350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일월수목원 14
50.0%
영흥수목원 14
50.0%

권종
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size352.0 B
일반무료
16 
일반유료
12 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
일반무료 16
57.1%
일반유료 12
42.9%

Length

2024-03-14T22:14:58.325791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T22:14:58.588473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반무료 16
57.1%
일반유료 12
42.9%

상세권종
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size352.0 B
무료입장객
16 
유료입장객
12 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row무료입장객
2nd row무료입장객
3rd row무료입장객
4th row무료입장객
5th row무료입장객

Common Values

ValueCountFrequency (%)
무료입장객 16
57.1%
유료입장객 12
42.9%

Length

2024-03-14T22:14:58.921464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T22:14:59.228273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
무료입장객 16
57.1%
유료입장객 12
42.9%

이용객수
Real number (ℝ)

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18036.214
Minimum2195
Maximum84742
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size380.0 B
2024-03-14T22:14:59.543624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2195
5-th percentile2491.3
Q16394.5
median11844.5
Q324966
95-th percentile48380.75
Maximum84742
Range82547
Interquartile range (IQR)18571.5

Descriptive statistics

Standard deviation18142.263
Coefficient of variation (CV)1.0058798
Kurtosis5.9911856
Mean18036.214
Median Absolute Deviation (MAD)7767
Skewness2.1835153
Sum505014
Variance3.2914171 × 108
MonotonicityNot monotonic
2024-03-14T22:14:59.926894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
41247 1
 
3.6%
14987 1
 
3.6%
4728 1
 
3.6%
2195 1
 
3.6%
9899 1
 
3.6%
3906 1
 
3.6%
7794 1
 
3.6%
6832 1
 
3.6%
13790 1
 
3.6%
9077 1
 
3.6%
Other values (18) 18
64.3%
ValueCountFrequency (%)
2195 1
3.6%
2303 1
3.6%
2841 1
3.6%
3906 1
3.6%
4249 1
3.6%
4728 1
3.6%
5082 1
3.6%
6832 1
3.6%
7487 1
3.6%
7794 1
3.6%
ValueCountFrequency (%)
84742 1
3.6%
52222 1
3.6%
41247 1
3.6%
32720 1
3.6%
27494 1
3.6%
27106 1
3.6%
26565 1
3.6%
24433 1
3.6%
23235 1
3.6%
22426 1
3.6%

매표수익
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct13
Distinct (%)46.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14621491
Minimum0
Maximum87181500
Zeros16
Zeros (%)57.1%
Negative0
Negative (%)0.0%
Memory size380.0 B
2024-03-14T22:15:00.303894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q320169375
95-th percentile59022325
Maximum87181500
Range87181500
Interquartile range (IQR)20169375

Descriptive statistics

Standard deviation23086532
Coefficient of variation (CV)1.5789452
Kurtosis2.6552302
Mean14621491
Median Absolute Deviation (MAD)0
Skewness1.7499128
Sum4.0940174 × 108
Variance5.3298798 × 1014
MonotonicityNot monotonic
2024-03-14T22:15:00.665924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
0 16
57.1%
15114500 1
 
3.6%
5668000 1
 
3.6%
42230500 1
 
3.6%
17951500 1
 
3.6%
63492000 1
 
3.6%
34656000 1
 
3.6%
87181500 1
 
3.6%
50721500 1
 
3.6%
38694500 1
 
3.6%
Other values (3) 3
 
10.7%
ValueCountFrequency (%)
0 16
57.1%
5668000 1
 
3.6%
9744236 1
 
3.6%
15114500 1
 
3.6%
17124500 1
 
3.6%
17951500 1
 
3.6%
26823000 1
 
3.6%
34656000 1
 
3.6%
38694500 1
 
3.6%
42230500 1
 
3.6%
ValueCountFrequency (%)
87181500 1
3.6%
63492000 1
3.6%
50721500 1
3.6%
42230500 1
3.6%
38694500 1
3.6%
34656000 1
3.6%
26823000 1
3.6%
17951500 1
3.6%
17124500 1
3.6%
15114500 1
3.6%

데이터 기준일자
Date

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size352.0 B
Minimum2024-02-08 00:00:00
Maximum2024-02-08 00:00:00
2024-03-14T22:15:00.985747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:15:01.326545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-14T22:14:56.227777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:14:55.774453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:14:56.457349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T22:14:56.000501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T22:15:01.541285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연월시설구분권종상세권종이용객수매표수익
연월1.0000.0000.0000.0000.6530.000
시설구분0.0001.0000.0000.0000.0000.000
권종0.0000.0001.0000.9930.0000.988
상세권종0.0000.0000.9931.0000.0000.988
이용객수0.6530.0000.0000.0001.0000.000
매표수익0.0000.0000.9880.9880.0001.000
2024-03-14T22:15:01.814295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상세권종권종시설구분
상세권종1.0000.9240.000
권종0.9241.0000.000
시설구분0.0000.0001.000
2024-03-14T22:15:02.064927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이용객수매표수익시설구분권종상세권종
이용객수1.0000.0370.0000.0000.000
매표수익0.0371.0000.0000.7920.792
시설구분0.0000.0001.0000.0000.000
권종0.0000.7920.0001.0000.924
상세권종0.0000.7920.0000.9241.000

Missing values

2024-03-14T22:14:56.775987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T22:14:57.152475image/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

연월시설구분권종상세권종이용객수매표수익데이터 기준일자
02023-05일월수목원일반무료무료입장객4124702024-02-08
12023-05영흥수목원일반무료무료입장객2749402024-02-08
22023-06일월수목원일반무료무료입장객8474202024-02-08
32023-06영흥수목원일반무료무료입장객5222202024-02-08
42023-07일월수목원일반무료무료입장객2443302024-02-08
52023-07일월수목원일반유료유료입장객5082151145002024-02-08
62023-07영흥수목원일반무료무료입장객1637602024-02-08
72023-07영흥수목원일반유료유료입장객230356680002024-02-08
82023-08일월수목원일반무료무료입장객424902024-02-08
92023-08일월수목원일반유료유료입장객14614422305002024-02-08
연월시설구분권종상세권종이용객수매표수익데이터 기준일자
182023-10영흥수목원일반무료무료입장객2656502024-02-08
192023-10영흥수목원일반유료유료입장객22426507215002024-02-08
202023-11일월수목원일반무료무료입장객907702024-02-08
212023-11일월수목원일반유료유료입장객13790386945002024-02-08
222023-11영흥수목원일반무료무료입장객683202024-02-08
232023-11영흥수목원일반유료유료입장객7794171245002024-02-08
242023-12일월수목원일반무료무료입장객390602024-02-08
252023-12일월수목원일반유료유료입장객9899268230002024-02-08
262023-12영흥수목원일반무료무료입장객219502024-02-08
272023-12영흥수목원일반유료유료입장객472897442362024-02-08