Overview

Dataset statistics

Number of variables5
Number of observations50
Missing cells1
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory42.6 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description대구광역시_남구_숙박업소현황_20190916
Author대구광역시 남구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15053370&dataSetDetailId=150533701f223d1e090c6&provdMethod=FILE

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
소재지전화 has 1 (2.0%) missing valuesMissing
업소명 has unique valuesUnique
업소소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-10 19:05:48.331709
Analysis finished2023-12-10 19:05:48.824572
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
숙박업(일반)
50 

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 (%)
숙박업(일반) 50
100.0%

Length

2023-12-11T04:05:48.926580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:05:49.068337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
숙박업(일반 50
100.0%

업소명
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-11T04:05:49.389964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length9
Mean length4.62
Min length2

Characters and Unicode

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

Unique

Unique50 ?
Unique (%)100.0%

Sample

1st row금성
2nd row청운
3rd rowS(에스)모텔
4th row샘물여관
5th row수정여관
ValueCountFrequency (%)
금성 1
 
2.0%
삐에로 1
 
2.0%
호텔 1
 
2.0%
성동장 1
 
2.0%
삼정여관 1
 
2.0%
앤모텔 1
 
2.0%
와자자 1
 
2.0%
대덕여관 1
 
2.0%
야크모텔 1
 
2.0%
주)호텔더팔래스 1
 
2.0%
Other values (41) 41
80.4%
2023-12-11T04:05:50.061837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
텔 25
 
10.8%
모 20
 
8.7%
장 13
 
5.6%
여 10
 
4.3%
관 10
 
4.3%
대 7
 
3.0%
호 6
 
2.6%
스 6
 
2.6%
) 4
 
1.7%
( 4
 
1.7%
Other values (92) 126
54.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 210
90.9%
Decimal Number 8
 
3.5%
Close Punctuation 4
 
1.7%
Open Punctuation 4
 
1.7%
Uppercase Letter 2
 
0.9%
Lowercase Letter 1
 
0.4%
Space Separator 1
 
0.4%
Other Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
텔 25
 
11.9%
모 20
 
9.5%
장 13
 
6.2%
여 10
 
4.8%
관 10
 
4.8%
대 7
 
3.3%
호 6
 
2.9%
스 6
 
2.9%
수 4
 
1.9%
가 3
 
1.4%
Other values (79) 106
50.5%
Decimal Number
ValueCountFrequency (%)
1 2
25.0%
9 2
25.0%
0 1
12.5%
2 1
12.5%
3 1
12.5%
6 1
12.5%
Uppercase Letter
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Lowercase Letter
ValueCountFrequency (%)
h 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%
Other Punctuation
ValueCountFrequency (%)
! 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 210
90.9%
Common 18
 
7.8%
Latin 3
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
텔 25
 
11.9%
모 20
 
9.5%
장 13
 
6.2%
여 10
 
4.8%
관 10
 
4.8%
대 7
 
3.3%
호 6
 
2.9%
스 6
 
2.9%
수 4
 
1.9%
가 3
 
1.4%
Other values (79) 106
50.5%
Common
ValueCountFrequency (%)
) 4
22.2%
( 4
22.2%
1 2
11.1%
9 2
11.1%
0 1
 
5.6%
1
 
5.6%
2 1
 
5.6%
! 1
 
5.6%
3 1
 
5.6%
6 1
 
5.6%
Latin
ValueCountFrequency (%)
h 1
33.3%
K 1
33.3%
S 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 210
90.9%
ASCII 21
 
9.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
텔 25
 
11.9%
모 20
 
9.5%
장 13
 
6.2%
여 10
 
4.8%
관 10
 
4.8%
대 7
 
3.3%
호 6
 
2.9%
스 6
 
2.9%
수 4
 
1.9%
가 3
 
1.4%
Other values (79) 106
50.5%
ASCII
ValueCountFrequency (%)
) 4
19.0%
( 4
19.0%
1 2
9.5%
9 2
9.5%
h 1
 
4.8%
0 1
 
4.8%
1
 
4.8%
K 1
 
4.8%
2 1
 
4.8%
S 1
 
4.8%
Other values (3) 3
14.3%

업소소재지(도로명)
Text

UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-11T04:05:50.443589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24.5
Mean length22.78
Min length20

Characters and Unicode

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

Unique

Unique50 ?
Unique (%)100.0%

Sample

1st row대구광역시 남구 관문시장2길 6-3 (대명동)
2nd row대구광역시 남구 대명로 310 (대명동)
3rd row대구광역시 남구 중앙대로 118 (봉덕동)
4th row대구광역시 남구 대명로25길 17-8 (대명동)
5th row대구광역시 남구 관문시장1길 16-4 (대명동)
ValueCountFrequency (%)
대구광역시 50
20.0%
남구 50
20.0%
대명동 37
14.8%
봉덕동 12
 
4.8%
대명로 9
 
3.6%
두류공원로 6
 
2.4%
이천로 5
 
2.0%
현충로 5
 
2.0%
명덕로 5
 
2.0%
성당로 3
 
1.2%
Other values (62) 68
27.2%
2023-12-11T04:05:51.022683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
200
17.6%
대 104
 
9.1%
구 100
 
8.8%
명 56
 
4.9%
시 54
 
4.7%
남 51
 
4.5%
( 50
 
4.4%
광 50
 
4.4%
역 50
 
4.4%
) 50
 
4.4%
Other values (37) 374
32.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 683
60.0%
Space Separator 200
 
17.6%
Decimal Number 144
 
12.6%
Open Punctuation 50
 
4.4%
Close Punctuation 50
 
4.4%
Dash Punctuation 12
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 104
15.2%
구 100
14.6%
명 56
8.2%
시 54
7.9%
남 51
7.5%
광 50
7.3%
역 50
7.3%
동 50
7.3%
로 44
6.4%
덕 23
 
3.4%
Other values (23) 101
14.8%
Decimal Number
ValueCountFrequency (%)
1 35
24.3%
2 28
19.4%
3 15
10.4%
4 12
 
8.3%
6 12
 
8.3%
0 10
 
6.9%
7 9
 
6.2%
5 9
 
6.2%
8 9
 
6.2%
9 5
 
3.5%
Space Separator
ValueCountFrequency (%)
200
100.0%
Open Punctuation
ValueCountFrequency (%)
( 50
100.0%
Close Punctuation
ValueCountFrequency (%)
) 50
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 683
60.0%
Common 456
40.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 104
15.2%
구 100
14.6%
명 56
8.2%
시 54
7.9%
남 51
7.5%
광 50
7.3%
역 50
7.3%
동 50
7.3%
로 44
6.4%
덕 23
 
3.4%
Other values (23) 101
14.8%
Common
ValueCountFrequency (%)
200
43.9%
( 50
 
11.0%
) 50
 
11.0%
1 35
 
7.7%
2 28
 
6.1%
3 15
 
3.3%
4 12
 
2.6%
- 12
 
2.6%
6 12
 
2.6%
0 10
 
2.2%
Other values (4) 32
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 683
60.0%
ASCII 456
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
200
43.9%
( 50
 
11.0%
) 50
 
11.0%
1 35
 
7.7%
2 28
 
6.1%
3 15
 
3.3%
4 12
 
2.6%
- 12
 
2.6%
6 12
 
2.6%
0 10
 
2.2%
Other values (4) 32
 
7.0%
Hangul
ValueCountFrequency (%)
대 104
15.2%
구 100
14.6%
명 56
8.2%
시 54
7.9%
남 51
7.5%
광 50
7.3%
역 50
7.3%
동 50
7.3%
로 44
6.4%
덕 23
 
3.4%
Other values (23) 101
14.8%

소재지전화
Text

MISSING 

Distinct49
Distinct (%)100.0%
Missing1
Missing (%)2.0%
Memory size532.0 B
2023-12-11T04:05:51.416472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters588
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

Unique49 ?
Unique (%)100.0%

Sample

1st row053-656-5257
2nd row053-471-2289
3rd row053-626-1535
4th row053-654-2563
5th row053-471-3389
ValueCountFrequency (%)
053-656-5257 1
 
2.0%
053-625-8601 1
 
2.0%
053-625-8118 1
 
2.0%
053-621-7777 1
 
2.0%
053-474-0757 1
 
2.0%
053-655-8990 1
 
2.0%
053-625-1474 1
 
2.0%
053-626-2802 1
 
2.0%
053-621-4009 1
 
2.0%
053-471-9911 1
 
2.0%
Other values (39) 39
79.6%
2023-12-11T04:05:52.078879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 98
16.7%
5 89
15.1%
0 79
13.4%
3 74
12.6%
6 60
10.2%
2 46
7.8%
4 42
7.1%
7 40
6.8%
1 32
 
5.4%
8 14
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 490
83.3%
Dash Punctuation 98
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 89
18.2%
0 79
16.1%
3 74
15.1%
6 60
12.2%
2 46
9.4%
4 42
8.6%
7 40
8.2%
1 32
 
6.5%
8 14
 
2.9%
9 14
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 98
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 588
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 98
16.7%
5 89
15.1%
0 79
13.4%
3 74
12.6%
6 60
10.2%
2 46
7.8%
4 42
7.1%
7 40
6.8%
1 32
 
5.4%
8 14
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 588
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 98
16.7%
5 89
15.1%
0 79
13.4%
3 74
12.6%
6 60
10.2%
2 46
7.8%
4 42
7.1%
7 40
6.8%
1 32
 
5.4%
8 14
 
2.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
Minimum2019-09-16 00:00:00
Maximum2019-09-16 00:00:00
2023-12-11T04:05:52.395255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:05:52.613489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-11T04:05:52.731093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명업소소재지(도로명)소재지전화
업소명1.0001.0001.000
업소소재지(도로명)1.0001.0001.000
소재지전화1.0001.0001.000

Missing values

2023-12-11T04:05:48.623716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T04:05:48.766531image/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

업종명업소명업소소재지(도로명)소재지전화데이터기준일자
0숙박업(일반)금성대구광역시 남구 관문시장2길 6-3 (대명동)053-656-52572019-09-16
1숙박업(일반)청운대구광역시 남구 대명로 310 (대명동)<NA>2019-09-16
2숙박업(일반)S(에스)모텔대구광역시 남구 중앙대로 118 (봉덕동)053-471-22892019-09-16
3숙박업(일반)샘물여관대구광역시 남구 대명로25길 17-8 (대명동)053-626-15352019-09-16
4숙박업(일반)수정여관대구광역시 남구 관문시장1길 16-4 (대명동)053-654-25632019-09-16
5숙박업(일반)국화장모텔대구광역시 남구 봉덕로 46-1 (봉덕동)053-471-33892019-09-16
6숙박업(일반)천도여관대구광역시 남구 명덕시장길 106-1 (대명동)053-625-06142019-09-16
7숙박업(일반)대아장대구광역시 남구 대명로 6 (대명동)053-654-79742019-09-16
8숙박업(일반)케이(K)모텔대구광역시 남구 대명로 317 (대명동)053-627-58582019-09-16
9숙박업(일반)대림여관대구광역시 남구 관문시장1길 16-8 (대명동)053-625-44722019-09-16
업종명업소명업소소재지(도로명)소재지전화데이터기준일자
40숙박업(일반)뉴세신장모텔대구광역시 남구 대명로 202 (대명동)053-654-77372019-09-16
41숙박업(일반)대명장대구광역시 남구 명덕로 52 (대명동)053-653-75852019-09-16
42숙박업(일반)리젠시모텔대구광역시 남구 대명남2길 74-11 (대명동)053-656-90092019-09-16
43숙박업(일반)10번가대구광역시 남구 봉덕로 20 (봉덕동)053-471-33932019-09-16
44숙박업(일반)마이더스모텔대구광역시 남구 대덕로 184 (봉덕동)053-471-06632019-09-16
45숙박업(일반)모텔카라대구광역시 남구 대명로 234-2 (대명동)053-627-13512019-09-16
46숙박업(일반)푸른장여관대구광역시 남구 성당로 48 (대명동)053-653-13112019-09-16
47숙박업(일반)요요모텔대구광역시 남구 봉덕로2길 7 (봉덕동)053-477-50052019-09-16
48숙박업(일반)앞산비즈니스 호텔대구광역시 남구 현충로 148 (대명동)053-625-81182019-09-16
49숙박업(일반)선화장대구광역시 남구 중앙대로27길 36 (대명동)053-623-40442019-09-16