Overview

Dataset statistics

Number of variables7
Number of observations110
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.5 KiB
Average record size in memory60.2 B

Variable types

DateTime1
Categorical5
Numeric1

Dataset

Description충청남도 청양군에 소재하는 칠갑산휴양랜드에 관한 데이터로 칠갑산휴양랜드의 숙박일 시설, 결제금액 등에 관한 정보를 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=335&beforeMenuCd=DOM_000000201001001000&publicdatapk=15084532

Alerts

기관 has constant value ""Constant
결제 has constant value ""Constant
결제금액 is highly overall correlated with 시설High correlation
시설 is highly overall correlated with 결제금액High correlation

Reproduction

Analysis started2024-01-09 22:55:03.085557
Analysis finished2024-01-09 22:55:03.579282
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

숙박일
Date

Distinct37
Distinct (%)33.6%
Missing0
Missing (%)0.0%
Memory size1012.0 B
Minimum2022-04-03 00:00:00
Maximum2022-07-31 00:00:00
2024-01-10T07:55:03.641777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:55:03.763917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)

기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1012.0 B
칠갑산휴양랜드
110 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row칠갑산휴양랜드
2nd row칠갑산휴양랜드
3rd row칠갑산휴양랜드
4th row칠갑산휴양랜드
5th row칠갑산휴양랜드

Common Values

ValueCountFrequency (%)
칠갑산휴양랜드 110
100.0%

Length

2024-01-10T07:55:03.869558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:55:03.952954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
칠갑산휴양랜드 110
100.0%

시설
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size1012.0 B
401호(7인실)
16 
101호(8인실)
14 
301호(7인실)
13 
102호(10인실)
12 
103호(8인실)
11 
Other values (7)
44 

Length

Max length10
Median length9
Mean length9.4181818
Min length9

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row401호(7인실)
2nd row101호(8인실)
3rd row102호(10인실)
4th row103호(8인실)
5th row103호(8인실)

Common Values

ValueCountFrequency (%)
401호(7인실) 16
14.5%
101호(8인실) 14
12.7%
301호(7인실) 13
11.8%
102호(10인실) 12
10.9%
103호(8인실) 11
10.0%
403호(11인실) 11
10.0%
303호(11인실) 11
10.0%
104호(10인실) 8
7.3%
402호(9인실) 6
 
5.5%
302호(9인실) 4
 
3.6%
Other values (2) 4
 
3.6%

Length

2024-01-10T07:55:04.042727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
401호(7인실 16
14.5%
101호(8인실 14
12.7%
301호(7인실 13
11.8%
102호(10인실 12
10.9%
103호(8인실 11
10.0%
403호(11인실 11
10.0%
303호(11인실 11
10.0%
104호(10인실 8
7.3%
402호(9인실 6
 
5.5%
302호(9인실 4
 
3.6%
Other values (2) 4
 
3.6%

결제
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1012.0 B
I
110 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 110
100.0%

Length

2024-01-10T07:55:04.146849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:55:04.226942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 110
100.0%

숙박일수
Categorical

Distinct3
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size1012.0 B
1
92 
2
12 
3
 
6

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 92
83.6%
2 12
 
10.9%
3 6
 
5.5%

Length

2024-01-10T07:55:04.319052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:55:04.403741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 92
83.6%
2 12
 
10.9%
3 6
 
5.5%

결제금액
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)7.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean142045.45
Minimum90000
Maximum275000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-01-10T07:55:04.477256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum90000
5-th percentile106750
Q1115000
median140000
Q3150000
95-th percentile175000
Maximum275000
Range185000
Interquartile range (IQR)35000

Descriptive statistics

Standard deviation35083.749
Coefficient of variation (CV)0.2469896
Kurtosis5.3974433
Mean142045.45
Median Absolute Deviation (MAD)25000
Skewness1.9131343
Sum15625000
Variance1.2308695 × 109
MonotonicityNot monotonic
2024-01-10T07:55:04.597057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
115000 25
22.7%
125000 23
20.9%
175000 21
19.1%
150000 20
18.2%
140000 11
10.0%
90000 4
 
3.6%
275000 4
 
3.6%
100000 2
 
1.8%
ValueCountFrequency (%)
90000 4
 
3.6%
100000 2
 
1.8%
115000 25
22.7%
125000 23
20.9%
140000 11
10.0%
150000 20
18.2%
175000 21
19.1%
275000 4
 
3.6%
ValueCountFrequency (%)
275000 4
 
3.6%
175000 21
19.1%
150000 20
18.2%
140000 11
10.0%
125000 23
20.9%
115000 25
22.7%
100000 2
 
1.8%
90000 4
 
3.6%

발매
Categorical

Distinct2
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1012.0 B
1
58 
0
52 

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 58
52.7%
0 52
47.3%

Length

2024-01-10T07:55:04.740973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:55:04.835915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 58
52.7%
0 52
47.3%

Interactions

2024-01-10T07:55:03.302328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:55:04.893782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
숙박일시설숙박일수결제금액발매
숙박일1.0000.0000.8740.6471.000
시설0.0001.0000.4930.9940.403
숙박일수0.8740.4931.0000.6290.134
결제금액0.6470.9940.6291.0000.412
발매1.0000.4030.1340.4121.000
2024-01-10T07:55:04.987151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발매숙박일수시설
발매1.0000.2190.297
숙박일수0.2191.0000.243
시설0.2970.2431.000
2024-01-10T07:55:05.074122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
결제금액시설숙박일수발매
결제금액1.0000.8480.3150.340
시설0.8481.0000.2430.297
숙박일수0.3150.2431.0000.219
발매0.3400.2970.2191.000

Missing values

2024-01-10T07:55:03.427066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:55:03.539877image/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

숙박일기관시설결제숙박일수결제금액발매
02022-04-03칠갑산휴양랜드401호(7인실)I11150001
12022-04-03칠갑산휴양랜드101호(8인실)I11250001
22022-04-03칠갑산휴양랜드102호(10인실)I11500001
32022-04-05칠갑산휴양랜드103호(8인실)I21000001
42022-04-06칠갑산휴양랜드103호(8인실)I21000001
52022-04-09칠갑산휴양랜드101호(8인실)I11250001
62022-04-10칠갑산휴양랜드101호(8인실)I11250001
72022-04-10칠갑산휴양랜드103호(8인실)I11250001
82022-04-10칠갑산휴양랜드102호(10인실)I11500001
92022-04-10칠갑산휴양랜드403호(11인실)I11750001
숙박일기관시설결제숙박일수결제금액발매
1002022-07-30칠갑산휴양랜드104호(10인실)I11500000
1012022-07-31칠갑산휴양랜드401호(7인실)I11150000
1022022-07-31칠갑산휴양랜드101호(8인실)I31250000
1032022-07-31칠갑산휴양랜드103호(8인실)I11250000
1042022-07-31칠갑산휴양랜드302호(9인실)I11400000
1052022-07-31칠갑산휴양랜드402호(9인실)I11400000
1062022-07-31칠갑산휴양랜드102호(10인실)I11500000
1072022-07-31칠갑산휴양랜드104호(10인실)I11500000
1082022-07-31칠갑산휴양랜드303호(11인실)I11750000
1092022-07-31칠갑산휴양랜드403호(11인실)I11750000