Overview

Dataset statistics

Number of variables4
Number of observations133
Missing cells11
Missing cells (%)2.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.3 KiB
Average record size in memory33.0 B

Variable types

Categorical1
Text3

Dataset

Description대구광역시_수성구_여행업 현황_20200918
Author대구광역시 수성구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3075495&dataSetDetailId=30754951e8841c48f090&provdMethod=FILE

Alerts

전화번호 has 11 (8.3%) missing valuesMissing

Reproduction

Analysis started2024-04-19 05:47:16.477186
Analysis finished2024-04-19 05:47:17.552182
Duration1.07 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종
Categorical

Distinct3
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
국외여행업
60 
국내여행업
54 
일반여행업
19 

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 (%)
국외여행업 60
45.1%
국내여행업 54
40.6%
일반여행업 19
 
14.3%

Length

2024-04-19T14:47:17.608721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T14:47:17.712985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국외여행업 60
45.1%
국내여행업 54
40.6%
일반여행업 19
 
14.3%

상호
Text

Distinct86
Distinct (%)64.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-04-19T14:47:17.964853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length8.1654135
Min length4

Characters and Unicode

Total characters1086
Distinct characters161
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

Unique39 ?
Unique (%)29.3%

Sample

1st row(주)유성관광여행사
2nd row(주)세일관광여행사
3rd row동화항공여행주식회사
4th row(주)알프스여행사
5th row(주)투어토탈
ValueCountFrequency (%)
주식회사 21
 
12.2%
투어 3
 
1.7%
여행사 3
 
1.7%
주)유성관광여행사 2
 
1.2%
주)칸여행사 2
 
1.2%
나비트레킹투어 2
 
1.2%
주 2
 
1.2%
오로라 2
 
1.2%
관광 2
 
1.2%
참길여행사 2
 
1.2%
Other values (89) 131
76.2%
2024-04-19T14:47:18.341866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 91
 
8.4%
( 68
 
6.3%
) 68
 
6.3%
사 64
 
5.9%
행 56
 
5.2%
여 54
 
5.0%
어 54
 
5.0%
투 51
 
4.7%
39
 
3.6%
이 26
 
2.4%
Other values (151) 515
47.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 908
83.6%
Open Punctuation 68
 
6.3%
Close Punctuation 68
 
6.3%
Space Separator 39
 
3.6%
Other Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 91
 
10.0%
사 64
 
7.0%
행 56
 
6.2%
여 54
 
5.9%
어 54
 
5.9%
투 51
 
5.6%
이 26
 
2.9%
식 25
 
2.8%
회 23
 
2.5%
스 22
 
2.4%
Other values (146) 442
48.7%
Other Punctuation
ValueCountFrequency (%)
& 2
66.7%
/ 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 68
100.0%
Close Punctuation
ValueCountFrequency (%)
) 68
100.0%
Space Separator
ValueCountFrequency (%)
39
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 908
83.6%
Common 178
 
16.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 91
 
10.0%
사 64
 
7.0%
행 56
 
6.2%
여 54
 
5.9%
어 54
 
5.9%
투 51
 
5.6%
이 26
 
2.9%
식 25
 
2.8%
회 23
 
2.5%
스 22
 
2.4%
Other values (146) 442
48.7%
Common
ValueCountFrequency (%)
( 68
38.2%
) 68
38.2%
39
21.9%
& 2
 
1.1%
/ 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 908
83.6%
ASCII 178
 
16.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 91
 
10.0%
사 64
 
7.0%
행 56
 
6.2%
여 54
 
5.9%
어 54
 
5.9%
투 51
 
5.6%
이 26
 
2.9%
식 25
 
2.8%
회 23
 
2.5%
스 22
 
2.4%
Other values (146) 442
48.7%
ASCII
ValueCountFrequency (%)
( 68
38.2%
) 68
38.2%
39
21.9%
& 2
 
1.1%
/ 1
 
0.6%

소재지(도로명)
Text

Distinct87
Distinct (%)65.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-04-19T14:47:18.655083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length42
Mean length31.488722
Min length22

Characters and Unicode

Total characters4188
Distinct characters144
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

Unique44 ?
Unique (%)33.1%

Sample

1st row대구광역시 수성구 국채보상로 826 (범어동)
2nd row대구광역시 수성구 지범로 192 (범물동)
3rd row대구광역시 수성구 국채보상로 1049 (만촌동)
4th row대구광역시 수성구 지범로 91 (지산동)
5th row대구광역시 수성구 달구벌대로 3188, 아레나스포츠센터 (신매동)
ValueCountFrequency (%)
대구광역시 133
 
16.3%
수성구 133
 
16.3%
범어동 34
 
4.2%
달구벌대로 22
 
2.7%
동대구로 17
 
2.1%
지산동 14
 
1.7%
시지동 12
 
1.5%
지범로 12
 
1.5%
만촌동 11
 
1.3%
범물동 10
 
1.2%
Other values (200) 418
51.2%
2024-04-19T14:47:19.090111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
685
 
16.4%
구 321
 
7.7%
대 190
 
4.5%
동 181
 
4.3%
수 171
 
4.1%
성 167
 
4.0%
시 156
 
3.7%
1 147
 
3.5%
( 136
 
3.2%
) 136
 
3.2%
Other values (134) 1898
45.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2409
57.5%
Decimal Number 688
 
16.4%
Space Separator 685
 
16.4%
Open Punctuation 136
 
3.2%
Close Punctuation 136
 
3.2%
Other Punctuation 112
 
2.7%
Dash Punctuation 20
 
0.5%
Uppercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 321
13.3%
대 190
 
7.9%
동 181
 
7.5%
수 171
 
7.1%
성 167
 
6.9%
시 156
 
6.5%
로 133
 
5.5%
역 133
 
5.5%
광 133
 
5.5%
범 77
 
3.2%
Other values (117) 747
31.0%
Decimal Number
ValueCountFrequency (%)
1 147
21.4%
3 98
14.2%
2 96
14.0%
0 91
13.2%
6 52
 
7.6%
4 50
 
7.3%
8 44
 
6.4%
5 42
 
6.1%
9 37
 
5.4%
7 31
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%
Space Separator
ValueCountFrequency (%)
685
100.0%
Open Punctuation
ValueCountFrequency (%)
( 136
100.0%
Close Punctuation
ValueCountFrequency (%)
) 136
100.0%
Other Punctuation
ValueCountFrequency (%)
, 112
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2409
57.5%
Common 1777
42.4%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 321
13.3%
대 190
 
7.9%
동 181
 
7.5%
수 171
 
7.1%
성 167
 
6.9%
시 156
 
6.5%
로 133
 
5.5%
역 133
 
5.5%
광 133
 
5.5%
범 77
 
3.2%
Other values (117) 747
31.0%
Common
ValueCountFrequency (%)
685
38.5%
1 147
 
8.3%
( 136
 
7.7%
) 136
 
7.7%
, 112
 
6.3%
3 98
 
5.5%
2 96
 
5.4%
0 91
 
5.1%
6 52
 
2.9%
4 50
 
2.8%
Other values (5) 174
 
9.8%
Latin
ValueCountFrequency (%)
K 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2409
57.5%
ASCII 1779
42.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
685
38.5%
1 147
 
8.3%
( 136
 
7.6%
) 136
 
7.6%
, 112
 
6.3%
3 98
 
5.5%
2 96
 
5.4%
0 91
 
5.1%
6 52
 
2.9%
4 50
 
2.8%
Other values (7) 176
 
9.9%
Hangul
ValueCountFrequency (%)
구 321
13.3%
대 190
 
7.9%
동 181
 
7.5%
수 171
 
7.1%
성 167
 
6.9%
시 156
 
6.5%
로 133
 
5.5%
역 133
 
5.5%
광 133
 
5.5%
범 77
 
3.2%
Other values (117) 747
31.0%

전화번호
Text

MISSING 

Distinct76
Distinct (%)62.3%
Missing11
Missing (%)8.3%
Memory size1.2 KiB
2024-04-19T14:47:19.313864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.959016
Min length9

Characters and Unicode

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

Unique31 ?
Unique (%)25.4%

Sample

1st row053-742-0333
2nd row053-784-6701
3rd row053-752-6200
4th row053-784-9005
5th row053-794-3388
ValueCountFrequency (%)
053-756-0010 3
 
2.5%
053-751-3366 2
 
1.6%
053-753-9997 2
 
1.6%
053-742-0333 2
 
1.6%
053-755-2562 2
 
1.6%
1899-5887 2
 
1.6%
053-781-3885 2
 
1.6%
053-742-2338 2
 
1.6%
053-219-0047 2
 
1.6%
053-782-2232 2
 
1.6%
Other values (66) 101
82.8%
2024-04-19T14:47:19.804109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 242
16.6%
0 215
14.7%
5 206
14.1%
3 177
12.1%
7 141
9.7%
2 109
7.5%
8 97
6.6%
4 81
 
5.6%
6 69
 
4.7%
1 63
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1217
83.4%
Dash Punctuation 242
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 215
17.7%
5 206
16.9%
3 177
14.5%
7 141
11.6%
2 109
9.0%
8 97
8.0%
4 81
 
6.7%
6 69
 
5.7%
1 63
 
5.2%
9 59
 
4.8%
Dash Punctuation
ValueCountFrequency (%)
- 242
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1459
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 242
16.6%
0 215
14.7%
5 206
14.1%
3 177
12.1%
7 141
9.7%
2 109
7.5%
8 97
6.6%
4 81
 
5.6%
6 69
 
4.7%
1 63
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1459
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 242
16.6%
0 215
14.7%
5 206
14.1%
3 177
12.1%
7 141
9.7%
2 109
7.5%
8 97
6.6%
4 81
 
5.6%
6 69
 
4.7%
1 63
 
4.3%

Correlations

2024-04-19T14:47:19.910838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종상호소재지(도로명)전화번호
업종1.0000.0000.0000.000
상호0.0001.0000.9991.000
소재지(도로명)0.0000.9991.0000.999
전화번호0.0001.0000.9991.000

Missing values

2024-04-19T14:47:17.435946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-19T14:47:17.519854image/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국내여행업(주)유성관광여행사대구광역시 수성구 국채보상로 826 (범어동)053-742-0333
1국내여행업(주)세일관광여행사대구광역시 수성구 지범로 192 (범물동)053-784-6701
2국내여행업동화항공여행주식회사대구광역시 수성구 국채보상로 1049 (만촌동)053-752-6200
3국내여행업(주)알프스여행사대구광역시 수성구 지범로 91 (지산동)053-784-9005
4국내여행업(주)투어토탈대구광역시 수성구 달구벌대로 3188, 아레나스포츠센터 (신매동)053-794-3388
5국내여행업(주)동성여행사대구광역시 수성구 달구벌대로627길 5-4 (매호동)053-792-8952
6국내여행업(주)수은관광대구광역시 수성구 달구벌대로 3103 (시지동)053-792-2888
7국내여행업(주)범어투어대구광역시 수성구 달구벌대로 2378 (범어동,2층)053-755-8888
8국내여행업꿈의교실&꿈의여행대구광역시 수성구 달구벌대로 3138 (시지동,5층)053-795-6624
9국내여행업삼성고속관광(주)대구광역시 수성구 들안로 250-1 (수성동3가)053-427-3077
업종상호소재지(도로명)전화번호
123일반여행업(주)평화고속관광대구광역시 수성구 수성로69길 65, 7동 301호 (수성동1가, 수성롯데캐슬더퍼스트2단지)053-422-9925
124일반여행업(주)평화여행사대구광역시 수성구 수성로69길 65, 7동 301호 (수성동1가, 수성롯데캐슬더퍼스트2단지)053-422-9925
125일반여행업(주)힐링투어 앤 골프대구광역시 수성구 상록로 82 (범어동)053-742-3535
126일반여행업(주)드림투어로대구광역시 수성구 들안로 181, 3층 (중동)053-764-2625
127일반여행업더블유티앤씨대구광역시 수성구 용학로 293-9, 2층 (지산동)053-639-7875
128일반여행업(주)투어인터불고대구광역시 수성구 화랑로 108, 3층 (만촌동)053-714-5055
129일반여행업퍼스트여행사대구광역시 수성구 신매로 102-1, 2층층 (신매동)053-793-4418
130일반여행업마루투어대구광역시 수성구 국채보상로 931, 3층 (만촌동)053-721-7121
131일반여행업라온컨벤션대구광역시 수성구 미술관로 40, 대구미술관 1층 (삼덕동)053-792-7788
132일반여행업아이피엠 코퍼레이션대구광역시 수성구 청수로26길 36, 한성스퀘어 601호 (두산동)070-4797-1712