Overview

Dataset statistics

Number of variables7
Number of observations1645
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory94.9 KiB
Average record size in memory59.1 B

Variable types

DateTime1
Categorical6

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=15084527

Alerts

기관 has constant value ""Constant
결제금액 is highly overall correlated with 결제High correlation
결제 is highly overall correlated with 결제금액High correlation
결제 is highly imbalanced (61.9%)Imbalance

Reproduction

Analysis started2024-01-09 23:00:16.207824
Analysis finished2024-01-09 23:00:16.657457
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

숙박일
Date

Distinct145
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
Minimum2022-01-01 00:00:00
Maximum2022-07-31 00:00:00
2024-01-10T08:00:16.717384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T08:00:16.865214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
동강리오토캠핑장
1645 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동강리오토캠핑장
2nd row동강리오토캠핑장
3rd row동강리오토캠핑장
4th row동강리오토캠핑장
5th row동강리오토캠핑장

Common Values

ValueCountFrequency (%)
동강리오토캠핑장 1645
100.0%

Length

2024-01-10T08:00:17.015526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:00:17.119785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동강리오토캠핑장 1645
100.0%

시설
Categorical

Distinct42
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
A-11(50㎡이상)
 
67
A-14(50㎡이상)
 
63
A-10(50㎡이상)
 
58
A-18(50㎡이상)
 
55
B-13(50㎡이하)
 
53
Other values (37)
1349 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowA-01(50㎡이상)
2nd rowA-02(50㎡이상)
3rd rowA-03(50㎡이상)
4th rowA-05(50㎡이상)
5th rowA-06(50㎡이상)

Common Values

ValueCountFrequency (%)
A-11(50㎡이상) 67
 
4.1%
A-14(50㎡이상) 63
 
3.8%
A-10(50㎡이상) 58
 
3.5%
A-18(50㎡이상) 55
 
3.3%
B-13(50㎡이하) 53
 
3.2%
A-16(50㎡이상) 53
 
3.2%
A-13(50㎡이상) 49
 
3.0%
A-12(50㎡이상) 48
 
2.9%
A-17(50㎡이상) 47
 
2.9%
A-05(50㎡이상) 44
 
2.7%
Other values (32) 1108
67.4%

Length

2024-01-10T08:00:17.204834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
a-11(50㎡이상 67
 
4.1%
a-14(50㎡이상 63
 
3.8%
a-10(50㎡이상 58
 
3.5%
a-18(50㎡이상 55
 
3.3%
b-13(50㎡이하 53
 
3.2%
a-16(50㎡이상 53
 
3.2%
a-13(50㎡이상 49
 
3.0%
a-12(50㎡이상 48
 
2.9%
a-17(50㎡이상 47
 
2.9%
a-05(50㎡이상 44
 
2.7%
Other values (32) 1108
67.4%

결제
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
I
1523 
A
 
122

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 1523
92.6%
A 122
 
7.4%

Length

2024-01-10T08:00:17.301252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:00:17.395278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 1523
92.6%
a 122
 
7.4%

숙박일수
Categorical

Distinct3
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
1
948 
2
605 
3
 
92

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 948
57.6%
2 605
36.8%
3 92
 
5.6%

Length

2024-01-10T08:00:17.487627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:00:17.578547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 948
57.6%
2 605
36.8%
3 92
 
5.6%

결제금액
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
25000
788 
35000
647 
0
122 
20000
88 

Length

Max length5
Median length5
Mean length4.7033435
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
25000 788
47.9%
35000 647
39.3%
0 122
 
7.4%
20000 88
 
5.3%

Length

2024-01-10T08:00:17.685117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:00:17.807389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
25000 788
47.9%
35000 647
39.3%
0 122
 
7.4%
20000 88
 
5.3%

발매
Categorical

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size13.0 KiB
1
1442 
0
203 

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 1442
87.7%
0 203
 
12.3%

Length

2024-01-10T08:00:17.912006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T08:00:18.010209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1442
87.7%
0 203
 
12.3%

Correlations

2024-01-10T08:00:18.071616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설결제숙박일수결제금액발매
시설1.0000.0770.3170.7490.000
결제0.0771.0000.0591.0000.566
숙박일수0.3170.0591.0000.1280.027
결제금액0.7491.0000.1281.0000.574
발매0.0000.5660.0270.5741.000
2024-01-10T08:00:18.163327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발매결제금액숙박일수시설결제
발매1.0000.3940.0440.0000.383
결제금액0.3941.0000.1210.4780.999
숙박일수0.0440.1211.0000.1530.098
시설0.0000.4780.1531.0000.061
결제0.3830.9990.0980.0611.000
2024-01-10T08:00:18.250030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설결제숙박일수결제금액발매
시설1.0000.0610.1530.4780.000
결제0.0611.0000.0980.9990.383
숙박일수0.1530.0981.0000.1210.044
결제금액0.4780.9990.1211.0000.394
발매0.0000.3830.0440.3941.000

Missing values

2024-01-10T08:00:16.511156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T08:00:16.616538image/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-01-01동강리오토캠핑장A-01(50㎡이상)I1350001
12022-01-01동강리오토캠핑장A-02(50㎡이상)I2350001
22022-01-01동강리오토캠핑장A-03(50㎡이상)I1350001
32022-01-01동강리오토캠핑장A-05(50㎡이상)I1350001
42022-01-01동강리오토캠핑장A-06(50㎡이상)I2350001
52022-01-01동강리오토캠핑장A-07(50㎡이상)I2350001
62022-01-01동강리오토캠핑장A-08(50㎡이상)I1350001
72022-01-01동강리오토캠핑장A-11(50㎡이상)I1350001
82022-01-01동강리오토캠핑장A-12(50㎡이상)I2350001
92022-01-01동강리오토캠핑장A-13(50㎡이상)I2350001
숙박일기관시설결제숙박일수결제금액발매
16352022-07-30동강리오토캠핑장A-11(50㎡이상)I1350000
16362022-07-30동강리오토캠핑장A-12(50㎡이상)I1350000
16372022-07-30동강리오토캠핑장A-14(50㎡이상)I1350000
16382022-07-30동강리오토캠핑장A-15(50㎡이상)A100
16392022-07-30동강리오토캠핑장A-18(50㎡이상)I2350000
16402022-07-30동강리오토캠핑장B-13(50㎡이하)A100
16412022-07-30동강리오토캠핑장B-20(50㎡이하)I2250000
16422022-07-30동강리오토캠핑장B-22(50㎡이하)I1250000
16432022-07-31동강리오토캠핑장A-14(50㎡이상)I1350000
16442022-07-31동강리오토캠핑장A-18(50㎡이상)I2350000