Overview

Dataset statistics

Number of variables4
Number of observations154
Missing cells77
Missing cells (%)12.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.9 KiB
Average record size in memory32.9 B

Variable types

Categorical1
Text3

Dataset

Description안양시에 등록되어 있는 국내 및 국외 여행업소 현황(국내 및 국외 여행업 업종, 국내 및 국외 여행업소 상호, 국내 및 국외 여행업소 소재지, 국내 및 국외 여행업 전화번호)데이터 정보입니다.
Author경기도 안양시
URLhttps://www.data.go.kr/data/3079508/fileData.do

Alerts

전화번호 has 77 (50.0%) missing valuesMissing

Reproduction

Analysis started2024-04-17 23:23:47.106323
Analysis finished2024-04-17 23:23:48.261219
Duration1.15 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종
Categorical

Distinct3
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
국내외여행업
90 
종합여행업
39 
국내여행업
25 

Length

Max length6
Median length6
Mean length5.5844156
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row국내여행업
2nd row국내여행업
3rd row국내여행업
4th row국내여행업
5th row국내여행업

Common Values

ValueCountFrequency (%)
국내외여행업 90
58.4%
종합여행업 39
25.3%
국내여행업 25
 
16.2%

Length

2024-04-18T08:23:48.327087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T08:23:48.431522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국내외여행업 90
58.4%
종합여행업 39
25.3%
국내여행업 25
 
16.2%

상호
Text

Distinct140
Distinct (%)90.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-18T08:23:48.695678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length20
Mean length8.1753247
Min length3

Characters and Unicode

Total characters1259
Distinct characters250
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique126 ?
Unique (%)81.8%

Sample

1st row성우항공(주)
2nd row삼성관광여행사
3rd row(주)세기여행사
4th row(주)큰별여행사
5th row주식회사 올댓
ValueCountFrequency (%)
주식회사 29
 
13.6%
투어 7
 
3.3%
3
 
1.4%
tour 3
 
1.4%
여행사 3
 
1.4%
스마일투어 2
 
0.9%
동백항공여행사 2
 
0.9%
한라여행사 2
 
0.9%
주)골프클릭 2
 
0.9%
미소골프 2
 
0.9%
Other values (150) 159
74.3%
2024-04-18T08:23:49.088674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
91
 
7.2%
68
 
5.4%
( 67
 
5.3%
) 67
 
5.3%
60
 
4.8%
51
 
4.1%
51
 
4.1%
38
 
3.0%
35
 
2.8%
34
 
2.7%
Other values (240) 697
55.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 976
77.5%
Uppercase Letter 70
 
5.6%
Open Punctuation 67
 
5.3%
Close Punctuation 67
 
5.3%
Space Separator 60
 
4.8%
Lowercase Letter 15
 
1.2%
Other Symbol 2
 
0.2%
Other Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
91
 
9.3%
68
 
7.0%
51
 
5.2%
51
 
5.2%
38
 
3.9%
35
 
3.6%
34
 
3.5%
29
 
3.0%
29
 
3.0%
21
 
2.2%
Other values (207) 529
54.2%
Uppercase Letter
ValueCountFrequency (%)
T 13
18.6%
N 8
11.4%
A 7
10.0%
R 6
8.6%
I 6
8.6%
O 5
 
7.1%
U 3
 
4.3%
S 3
 
4.3%
J 3
 
4.3%
L 3
 
4.3%
Other values (7) 13
18.6%
Lowercase Letter
ValueCountFrequency (%)
e 5
33.3%
r 2
 
13.3%
i 1
 
6.7%
o 1
 
6.7%
p 1
 
6.7%
b 1
 
6.7%
l 1
 
6.7%
n 1
 
6.7%
c 1
 
6.7%
u 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
& 1
50.0%
. 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 67
100.0%
Close Punctuation
ValueCountFrequency (%)
) 67
100.0%
Space Separator
ValueCountFrequency (%)
60
100.0%
Other Symbol
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 977
77.6%
Common 196
 
15.6%
Latin 85
 
6.8%
Han 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
91
 
9.3%
68
 
7.0%
51
 
5.2%
51
 
5.2%
38
 
3.9%
35
 
3.6%
34
 
3.5%
29
 
3.0%
29
 
3.0%
21
 
2.1%
Other values (207) 530
54.2%
Latin
ValueCountFrequency (%)
T 13
15.3%
N 8
 
9.4%
A 7
 
8.2%
R 6
 
7.1%
I 6
 
7.1%
e 5
 
5.9%
O 5
 
5.9%
U 3
 
3.5%
S 3
 
3.5%
J 3
 
3.5%
Other values (17) 26
30.6%
Common
ValueCountFrequency (%)
( 67
34.2%
) 67
34.2%
60
30.6%
& 1
 
0.5%
. 1
 
0.5%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 975
77.4%
ASCII 281
 
22.3%
None 2
 
0.2%
CJK 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
91
 
9.3%
68
 
7.0%
51
 
5.2%
51
 
5.2%
38
 
3.9%
35
 
3.6%
34
 
3.5%
29
 
3.0%
29
 
3.0%
21
 
2.2%
Other values (206) 528
54.2%
ASCII
ValueCountFrequency (%)
( 67
23.8%
) 67
23.8%
60
21.4%
T 13
 
4.6%
N 8
 
2.8%
A 7
 
2.5%
R 6
 
2.1%
I 6
 
2.1%
e 5
 
1.8%
O 5
 
1.8%
Other values (22) 37
13.2%
None
ValueCountFrequency (%)
2
100.0%
CJK
ValueCountFrequency (%)
1
100.0%
Distinct138
Distinct (%)89.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2024-04-18T08:23:49.411691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length67
Median length50
Mean length39.779221
Min length25

Characters and Unicode

Total characters6126
Distinct characters210
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique123 ?
Unique (%)79.9%

Sample

1st row경기도 안양시 동안구 엘에스로 112, 두림야스카와 308호 (호계동)
2nd row경기도 안양시 만안구 만안로 241-10 (안양동)
3rd row경기도 안양시 만안구 안양로 599 (석수동)
4th row경기도 안양시 만안구 안양로 320 (안양동)
5th row경기도 안양시 동안구 시민대로 230, 평촌아크로타워 B동 305호 (관양동)
ValueCountFrequency (%)
경기도 154
 
12.2%
안양시 154
 
12.2%
동안구 106
 
8.4%
관양동 52
 
4.1%
만안구 48
 
3.8%
안양동 41
 
3.2%
시민대로 27
 
2.1%
비산동 23
 
1.8%
호계동 21
 
1.7%
안양로 14
 
1.1%
Other values (360) 622
49.3%
2024-04-18T08:23:49.804402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1108
 
18.1%
414
 
6.8%
294
 
4.8%
288
 
4.7%
1 230
 
3.8%
195
 
3.2%
, 174
 
2.8%
171
 
2.8%
163
 
2.7%
2 162
 
2.6%
Other values (200) 2927
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3440
56.2%
Space Separator 1108
 
18.1%
Decimal Number 999
 
16.3%
Other Punctuation 174
 
2.8%
Close Punctuation 154
 
2.5%
Open Punctuation 154
 
2.5%
Uppercase Letter 45
 
0.7%
Lowercase Letter 25
 
0.4%
Dash Punctuation 24
 
0.4%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
414
 
12.0%
294
 
8.5%
288
 
8.4%
195
 
5.7%
171
 
5.0%
163
 
4.7%
157
 
4.6%
155
 
4.5%
154
 
4.5%
150
 
4.4%
Other values (163) 1299
37.8%
Uppercase Letter
ValueCountFrequency (%)
B 12
26.7%
S 7
15.6%
A 5
11.1%
V 4
 
8.9%
K 4
 
8.9%
I 3
 
6.7%
W 2
 
4.4%
Z 2
 
4.4%
E 2
 
4.4%
C 2
 
4.4%
Other values (2) 2
 
4.4%
Decimal Number
ValueCountFrequency (%)
1 230
23.0%
2 162
16.2%
0 141
14.1%
3 114
11.4%
6 72
 
7.2%
5 68
 
6.8%
4 65
 
6.5%
9 55
 
5.5%
7 55
 
5.5%
8 37
 
3.7%
Lowercase Letter
ValueCountFrequency (%)
e 7
28.0%
t 5
20.0%
r 4
16.0%
c 3
12.0%
n 3
12.0%
w 1
 
4.0%
o 1
 
4.0%
s 1
 
4.0%
Space Separator
ValueCountFrequency (%)
1108
100.0%
Other Punctuation
ValueCountFrequency (%)
, 174
100.0%
Close Punctuation
ValueCountFrequency (%)
) 154
100.0%
Open Punctuation
ValueCountFrequency (%)
( 154
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3440
56.2%
Common 2615
42.7%
Latin 71
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
414
 
12.0%
294
 
8.5%
288
 
8.4%
195
 
5.7%
171
 
5.0%
163
 
4.7%
157
 
4.6%
155
 
4.5%
154
 
4.5%
150
 
4.4%
Other values (163) 1299
37.8%
Latin
ValueCountFrequency (%)
B 12
16.9%
S 7
9.9%
e 7
9.9%
t 5
 
7.0%
A 5
 
7.0%
V 4
 
5.6%
K 4
 
5.6%
r 4
 
5.6%
I 3
 
4.2%
c 3
 
4.2%
Other values (11) 17
23.9%
Common
ValueCountFrequency (%)
1108
42.4%
1 230
 
8.8%
, 174
 
6.7%
2 162
 
6.2%
) 154
 
5.9%
( 154
 
5.9%
0 141
 
5.4%
3 114
 
4.4%
6 72
 
2.8%
5 68
 
2.6%
Other values (6) 238
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3440
56.2%
ASCII 2685
43.8%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1108
41.3%
1 230
 
8.6%
, 174
 
6.5%
2 162
 
6.0%
) 154
 
5.7%
( 154
 
5.7%
0 141
 
5.3%
3 114
 
4.2%
6 72
 
2.7%
5 68
 
2.5%
Other values (26) 308
 
11.5%
Hangul
ValueCountFrequency (%)
414
 
12.0%
294
 
8.5%
288
 
8.4%
195
 
5.7%
171
 
5.0%
163
 
4.7%
157
 
4.6%
155
 
4.5%
154
 
4.5%
150
 
4.4%
Other values (163) 1299
37.8%
Number Forms
ValueCountFrequency (%)
1
100.0%

전화번호
Text

MISSING 

Distinct72
Distinct (%)93.5%
Missing77
Missing (%)50.0%
Memory size1.3 KiB
2024-04-18T08:23:50.099504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.675325
Min length8

Characters and Unicode

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

Unique67 ?
Unique (%)87.0%

Sample

1st row031-425-1515
2nd row031-449-2000
3rd row031-8003-1708
4th row031-448-4800
5th row031-382-0741
ValueCountFrequency (%)
031-448-4800 2
 
2.6%
02-502-0950 2
 
2.6%
031-477-8752 2
 
2.6%
031-425-1515 2
 
2.6%
02-521-3700 2
 
2.6%
02-567-5022 1
 
1.3%
031-689-3991 1
 
1.3%
031-444-3188 1
 
1.3%
070-8064-3016 1
 
1.3%
070-4352-0368 1
 
1.3%
Other values (62) 62
80.5%
2024-04-18T08:23:50.578924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 145
16.1%
0 137
15.2%
3 96
10.7%
1 90
10.0%
4 89
9.9%
8 79
8.8%
2 73
8.1%
5 53
 
5.9%
7 49
 
5.5%
6 49
 
5.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 754
83.9%
Dash Punctuation 145
 
16.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 137
18.2%
3 96
12.7%
1 90
11.9%
4 89
11.8%
8 79
10.5%
2 73
9.7%
5 53
 
7.0%
7 49
 
6.5%
6 49
 
6.5%
9 39
 
5.2%
Dash Punctuation
ValueCountFrequency (%)
- 145
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 899
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 145
16.1%
0 137
15.2%
3 96
10.7%
1 90
10.0%
4 89
9.9%
8 79
8.8%
2 73
8.1%
5 53
 
5.9%
7 49
 
5.5%
6 49
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 899
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 145
16.1%
0 137
15.2%
3 96
10.7%
1 90
10.0%
4 89
9.9%
8 79
8.8%
2 73
8.1%
5 53
 
5.9%
7 49
 
5.5%
6 49
 
5.5%

Correlations

2024-04-18T08:23:50.708972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종전화번호
업종1.0000.000
전화번호0.0001.000

Missing values

2024-04-18T08:23:48.228133image/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국내여행업성우항공(주)경기도 안양시 동안구 엘에스로 112, 두림야스카와 308호 (호계동)031-425-1515
1국내여행업삼성관광여행사경기도 안양시 만안구 만안로 241-10 (안양동)031-449-2000
2국내여행업(주)세기여행사경기도 안양시 만안구 안양로 599 (석수동)031-8003-1708
3국내여행업(주)큰별여행사경기도 안양시 만안구 안양로 320 (안양동)031-448-4800
4국내여행업주식회사 올댓경기도 안양시 동안구 시민대로 230, 평촌아크로타워 B동 305호 (관양동)<NA>
5국내여행업(주)스카이피전항공경기도 안양시 만안구 안양로 282 (안양동)<NA>
6국내여행업(주)참빛여행사경기도 안양시 동안구 시민대로 180, 롯데백화점 내 6층 (호계동)<NA>
7국내여행업우리모두여행사경기도 안양시 동안구 부림로 113, B01호 (관양동, 현대아이파크)031-382-0741
8국내여행업신동방여행사경기도 안양시 만안구 박달로 553 (안양동)031-465-8818
9국내여행업수도관광경기도 안양시 만안구 안양로 29, 지하층 (안양동)031-469-1846
업종상호소재지(도로명)전화번호
144종합여행업해피국제관광(HAPPY INTERNATIONAL TOUR)경기도 안양시 만안구 문예로 50, 203-10호 (안양동, 한림시티빌아파트)<NA>
145종합여행업(주)제트캡경기도 안양시 동안구 안양판교로 20, 신한데뷰오피스텔 910호 (관양동)02-6929-1993
146종합여행업팜스투어경기도 안양시 동안구 관평로176번길 10, 1층 (관양동)<NA>
147종합여행업주식회사 액팅팜경기도 안양시 만안구 안양로 111, 경기벤처창업지원센터 11층 에이-06호 (안양동)<NA>
148종합여행업미라클경기도 안양시 만안구 만안로 49, 호정타워 406호 (안양동)<NA>
149종합여행업주식회사 어깨동무야경기도 안양시 동안구 흥안대로 519, 아이퍼스트타워 ES601-206호 (관양동)070-4289-9351
150종합여행업주식회사 삼유경기도 안양시 동안구 시민대로 230, 평촌아크로타워 지니센터 디동 5866호 (관양동)<NA>
151종합여행업주식회사 꿈꾸는 기차여행경기도 안양시 동안구 흥안대로 313, 수산동, 안양사회적경제지원센터 2층 (평촌동)070-8242-9525
152종합여행업나이스투어경기도 안양시 만안구 안양로 115, 도정오피스텔 1512호 (안양동)<NA>
153종합여행업(주)시원관광경기도 안양시 만안구 덕천로152번길 25, 안양아이에스BIZ타워센트럴 A동 1010호 (안양동)031-428-0725