Overview

Dataset statistics

Number of variables5
Number of observations26
Missing cells3
Missing cells (%)2.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory47.1 B

Variable types

Numeric2
Text3

Dataset

Description청양군 여행 시 숙박할 수 있는 숙박업소에 대한 데이터(연번,업소명, 영업소 주소, 연락처, 객실수)를 제공합니다.
URLhttps://www.data.go.kr/data/15118758/fileData.do

Alerts

연락처 has 3 (11.5%) missing valuesMissing
연번 has unique valuesUnique
업소명 has unique valuesUnique
영업소 주소(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:17:24.543669
Analysis finished2023-12-12 11:17:26.416800
Duration1.87 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.5
Minimum1
Maximum26
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2023-12-12T20:17:26.530111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.25
Q17.25
median13.5
Q319.75
95-th percentile24.75
Maximum26
Range25
Interquartile range (IQR)12.5

Descriptive statistics

Standard deviation7.6485293
Coefficient of variation (CV)0.56655772
Kurtosis-1.2
Mean13.5
Median Absolute Deviation (MAD)6.5
Skewness0
Sum351
Variance58.5
MonotonicityStrictly increasing
2023-12-12T20:17:26.781452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
1 1
 
3.8%
15 1
 
3.8%
26 1
 
3.8%
25 1
 
3.8%
24 1
 
3.8%
23 1
 
3.8%
22 1
 
3.8%
21 1
 
3.8%
20 1
 
3.8%
19 1
 
3.8%
Other values (16) 16
61.5%
ValueCountFrequency (%)
1 1
3.8%
2 1
3.8%
3 1
3.8%
4 1
3.8%
5 1
3.8%
6 1
3.8%
7 1
3.8%
8 1
3.8%
9 1
3.8%
10 1
3.8%
ValueCountFrequency (%)
26 1
3.8%
25 1
3.8%
24 1
3.8%
23 1
3.8%
22 1
3.8%
21 1
3.8%
20 1
3.8%
19 1
3.8%
18 1
3.8%
17 1
3.8%

업소명
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-12T20:17:27.171614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length8
Mean length5.7692308
Min length2

Characters and Unicode

Total characters150
Distinct characters79
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)100.0%

Sample

1st row나우모텔
2nd row크리스탈모텔
3rd row향수
4th row꿈의궁전모텔
5th row백악관모텔
ValueCountFrequency (%)
나우모텔 1
 
3.6%
크리스탈모텔 1
 
3.6%
청양고추문화마을 1
 
3.6%
알프스글램핑 1
 
3.6%
청양화이트텔 1
 
3.6%
sono 1
 
3.6%
호텔소노(hotel 1
 
3.6%
칠갑산엔에이치(nh)호텔 1
 
3.6%
샾무인텔 1
 
3.6%
청양칸모텔 1
 
3.6%
Other values (18) 18
64.3%
2023-12-12T20:17:27.844439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
텔 20
 
13.3%
모 15
 
10.0%
양 4
 
2.7%
청 4
 
2.7%
스 4
 
2.7%
O 3
 
2.0%
이 3
 
2.0%
호 3
 
2.0%
칠 3
 
2.0%
갑 3
 
2.0%
Other values (69) 88
58.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 133
88.7%
Uppercase Letter 11
 
7.3%
Space Separator 2
 
1.3%
Open Punctuation 2
 
1.3%
Close Punctuation 2
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
텔 20
 
15.0%
모 15
 
11.3%
양 4
 
3.0%
청 4
 
3.0%
스 4
 
3.0%
이 3
 
2.3%
호 3
 
2.3%
칠 3
 
2.3%
갑 3
 
2.3%
산 3
 
2.3%
Other values (59) 71
53.4%
Uppercase Letter
ValueCountFrequency (%)
O 3
27.3%
H 2
18.2%
N 2
18.2%
T 1
 
9.1%
E 1
 
9.1%
L 1
 
9.1%
S 1
 
9.1%
Space Separator
ValueCountFrequency (%)
2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 133
88.7%
Latin 11
 
7.3%
Common 6
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
텔 20
 
15.0%
모 15
 
11.3%
양 4
 
3.0%
청 4
 
3.0%
스 4
 
3.0%
이 3
 
2.3%
호 3
 
2.3%
칠 3
 
2.3%
갑 3
 
2.3%
산 3
 
2.3%
Other values (59) 71
53.4%
Latin
ValueCountFrequency (%)
O 3
27.3%
H 2
18.2%
N 2
18.2%
T 1
 
9.1%
E 1
 
9.1%
L 1
 
9.1%
S 1
 
9.1%
Common
ValueCountFrequency (%)
2
33.3%
( 2
33.3%
) 2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 133
88.7%
ASCII 17
 
11.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
텔 20
 
15.0%
모 15
 
11.3%
양 4
 
3.0%
청 4
 
3.0%
스 4
 
3.0%
이 3
 
2.3%
호 3
 
2.3%
칠 3
 
2.3%
갑 3
 
2.3%
산 3
 
2.3%
Other values (59) 71
53.4%
ASCII
ValueCountFrequency (%)
O 3
17.6%
H 2
11.8%
N 2
11.8%
2
11.8%
( 2
11.8%
) 2
11.8%
T 1
 
5.9%
E 1
 
5.9%
L 1
 
5.9%
S 1
 
5.9%

영업소 주소(도로명)
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-12T20:17:28.219058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length24
Mean length21.615385
Min length18

Characters and Unicode

Total characters562
Distinct characters55
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)100.0%

Sample

1st row충청남도 청양군 청양읍 중앙로9길 7
2nd row충청남도 청양군 청양읍 중앙로11길 9
3rd row충청남도 청양군 정산면 칠갑산로 1806
4th row충청남도 청양군 대치면 칠갑산로 419-2
5th row충청남도 청양군 청양읍 중앙로8길 11
ValueCountFrequency (%)
충청남도 26
19.8%
청양군 26
19.8%
청양읍 16
 
12.2%
중앙로9길 4
 
3.1%
대치면 4
 
3.1%
정산면 3
 
2.3%
칠갑산로 3
 
2.3%
칠갑산로8길 3
 
2.3%
11 2
 
1.5%
칠갑산로5길 2
 
1.5%
Other values (37) 42
32.1%
2023-12-12T20:17:28.806489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
105
18.7%
청 68
 
12.1%
양 43
 
7.7%
충 29
 
5.2%
남 27
 
4.8%
도 26
 
4.6%
군 26
 
4.6%
로 22
 
3.9%
1 21
 
3.7%
길 17
 
3.0%
Other values (45) 178
31.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 364
64.8%
Space Separator 105
 
18.7%
Decimal Number 83
 
14.8%
Dash Punctuation 9
 
1.6%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 68
18.7%
양 43
11.8%
충 29
 
8.0%
남 27
 
7.4%
도 26
 
7.1%
군 26
 
7.1%
로 22
 
6.0%
길 17
 
4.7%
읍 16
 
4.4%
산 11
 
3.0%
Other values (32) 79
21.7%
Decimal Number
ValueCountFrequency (%)
1 21
25.3%
9 9
10.8%
5 8
 
9.6%
8 8
 
9.6%
2 8
 
9.6%
0 6
 
7.2%
4 6
 
7.2%
7 6
 
7.2%
3 6
 
7.2%
6 5
 
6.0%
Space Separator
ValueCountFrequency (%)
105
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 364
64.8%
Common 198
35.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 68
18.7%
양 43
11.8%
충 29
 
8.0%
남 27
 
7.4%
도 26
 
7.1%
군 26
 
7.1%
로 22
 
6.0%
길 17
 
4.7%
읍 16
 
4.4%
산 11
 
3.0%
Other values (32) 79
21.7%
Common
ValueCountFrequency (%)
105
53.0%
1 21
 
10.6%
9 9
 
4.5%
- 9
 
4.5%
5 8
 
4.0%
8 8
 
4.0%
2 8
 
4.0%
0 6
 
3.0%
4 6
 
3.0%
7 6
 
3.0%
Other values (3) 12
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 364
64.8%
ASCII 198
35.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
105
53.0%
1 21
 
10.6%
9 9
 
4.5%
- 9
 
4.5%
5 8
 
4.0%
8 8
 
4.0%
2 8
 
4.0%
0 6
 
3.0%
4 6
 
3.0%
7 6
 
3.0%
Other values (3) 12
 
6.1%
Hangul
ValueCountFrequency (%)
청 68
18.7%
양 43
11.8%
충 29
 
8.0%
남 27
 
7.4%
도 26
 
7.1%
군 26
 
7.1%
로 22
 
6.0%
길 17
 
4.7%
읍 16
 
4.4%
산 11
 
3.0%
Other values (32) 79
21.7%

연락처
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing3
Missing (%)11.5%
Memory size340.0 B
2023-12-12T20:17:29.147769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique

Unique23 ?
Unique (%)100.0%

Sample

1st row041-944-0933
2nd row041-943-6612
3rd row041-943-8077
4th row041-943-8255
5th row041-943-8881
ValueCountFrequency (%)
041-944-0933 1
 
4.3%
041-943-0057 1
 
4.3%
041-944-0505 1
 
4.3%
041-940-2875 1
 
4.3%
041-943-5070 1
 
4.3%
041-942-4681 1
 
4.3%
041-942-8584 1
 
4.3%
041-944-0008 1
 
4.3%
041-943-3379 1
 
4.3%
041-943-7411 1
 
4.3%
Other values (13) 13
56.5%
2023-12-12T20:17:29.713140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 53
19.2%
- 46
16.7%
0 41
14.9%
1 31
11.2%
9 29
10.5%
3 23
8.3%
8 13
 
4.7%
2 13
 
4.7%
5 11
 
4.0%
7 10
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 230
83.3%
Dash Punctuation 46
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 53
23.0%
0 41
17.8%
1 31
13.5%
9 29
12.6%
3 23
10.0%
8 13
 
5.7%
2 13
 
5.7%
5 11
 
4.8%
7 10
 
4.3%
6 6
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 53
19.2%
- 46
16.7%
0 41
14.9%
1 31
11.2%
9 29
10.5%
3 23
8.3%
8 13
 
4.7%
2 13
 
4.7%
5 11
 
4.0%
7 10
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 276
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 53
19.2%
- 46
16.7%
0 41
14.9%
1 31
11.2%
9 29
10.5%
3 23
8.3%
8 13
 
4.7%
2 13
 
4.7%
5 11
 
4.0%
7 10
 
3.6%

객실수
Real number (ℝ)

Distinct18
Distinct (%)69.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.923077
Minimum9
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2023-12-12T20:17:29.911493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile12.5
Q118
median19.5
Q329.5
95-th percentile35
Maximum45
Range36
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation8.2700572
Coefficient of variation (CV)0.36077431
Kurtosis0.47972213
Mean22.923077
Median Absolute Deviation (MAD)5.5
Skewness0.69200453
Sum596
Variance68.393846
MonotonicityNot monotonic
2023-12-12T20:17:30.088438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
19 4
15.4%
18 3
 
11.5%
30 3
 
11.5%
15 2
 
7.7%
26 1
 
3.8%
31 1
 
3.8%
32 1
 
3.8%
20 1
 
3.8%
45 1
 
3.8%
17 1
 
3.8%
Other values (8) 8
30.8%
ValueCountFrequency (%)
9 1
 
3.8%
12 1
 
3.8%
14 1
 
3.8%
15 2
7.7%
17 1
 
3.8%
18 3
11.5%
19 4
15.4%
20 1
 
3.8%
24 1
 
3.8%
25 1
 
3.8%
ValueCountFrequency (%)
45 1
 
3.8%
36 1
 
3.8%
32 1
 
3.8%
31 1
 
3.8%
30 3
11.5%
28 1
 
3.8%
27 1
 
3.8%
26 1
 
3.8%
25 1
 
3.8%
24 1
 
3.8%

Interactions

2023-12-12T20:17:25.340616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:17:24.963388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:17:25.492525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:17:25.181830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:17:30.231291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업소명영업소 주소(도로명)연락처객실수
연번1.0001.0001.0001.0000.739
업소명1.0001.0001.0001.0001.000
영업소 주소(도로명)1.0001.0001.0001.0001.000
연락처1.0001.0001.0001.0001.000
객실수0.7391.0001.0001.0001.000
2023-12-12T20:17:30.391377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번객실수
연번1.000-0.063
객실수-0.0631.000

Missing values

2023-12-12T20:17:26.189143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:17:26.352057image/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

연번업소명영업소 주소(도로명)연락처객실수
01나우모텔충청남도 청양군 청양읍 중앙로9길 7041-944-093318
12크리스탈모텔충청남도 청양군 청양읍 중앙로11길 9041-943-661219
23향수충청남도 청양군 정산면 칠갑산로 1806041-943-807718
34꿈의궁전모텔충청남도 청양군 대치면 칠갑산로 419-2041-943-825517
45백악관모텔충청남도 청양군 청양읍 중앙로8길 11041-943-888126
56레전드모텔충청남도 청양군 청양읍 칠갑산로8길 8041-943-933331
67에덴모텔충청남도 청양군 청양읍 충절로 1390041-942-797132
78샤인모텔충청남도 청양군 정산면 충의로 1314041-943-900819
89파라다이스 모텔충청남도 청양군 대치면 칠갑산로 424-6041-943-223319
910힐링모텔충청남도 청양군 청양읍 중앙로12길 14041-943-246520
연번업소명영업소 주소(도로명)연락처객실수
1617청도모텔충청남도 청양군 정산면 효자길 9-7041-943-741118
1718퀸모텔충청남도 청양군 청양읍 중앙로9길 5041-943-337919
1819청양칸모텔충청남도 청양군 청양읍 칠갑산로8길 3041-944-000827
1920샾무인텔충청남도 청양군 목면 안심길 16041-942-858430
2021칠갑산엔에이치(NH)호텔충청남도 청양군 비봉면 록평용당로 775-3041-942-468124
2122호텔소노(HOTEL SONO)충청남도 청양군 청양읍 칠갑산로5길 5-1041-943-507036
2223청양화이트텔충청남도 청양군 청양읍 충절로 1030-17, 2-3층<NA>30
2324알프스글램핑충청남도 청양군 남양면 만수로 1202-20<NA>9
2425청양고추문화마을충청남도 청양군 청양읍 묵동길 14041-940-287514
2526칠갑산휴양랜드충청남도 청양군 대치면 까치내로 815041-940-287112