Overview

Dataset statistics

Number of variables5
Number of observations47
Missing cells19
Missing cells (%)8.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory43.8 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description인천광역시 미추홀구 여행업현황에 대한 데이터이며 상호명, 도로명주소, 전화번호, 죄표값 등의 항목을 제공합니다.
Author인천광역시 미추홀구
URLhttps://www.data.go.kr/data/15087015/fileData.do

Alerts

연번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 연번High correlation
전화번호 has 19 (40.4%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-13 00:19:43.423546
Analysis finished2023-12-13 00:19:43.895229
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct47
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24
Minimum1
Maximum47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size555.0 B
2023-12-13T09:19:43.951298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.3
Q112.5
median24
Q335.5
95-th percentile44.7
Maximum47
Range46
Interquartile range (IQR)23

Descriptive statistics

Standard deviation13.711309
Coefficient of variation (CV)0.57130455
Kurtosis-1.2
Mean24
Median Absolute Deviation (MAD)12
Skewness0
Sum1128
Variance188
MonotonicityStrictly increasing
2023-12-13T09:19:44.078037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
1 1
 
2.1%
2 1
 
2.1%
27 1
 
2.1%
28 1
 
2.1%
29 1
 
2.1%
30 1
 
2.1%
31 1
 
2.1%
32 1
 
2.1%
33 1
 
2.1%
34 1
 
2.1%
Other values (37) 37
78.7%
ValueCountFrequency (%)
1 1
2.1%
2 1
2.1%
3 1
2.1%
4 1
2.1%
5 1
2.1%
6 1
2.1%
7 1
2.1%
8 1
2.1%
9 1
2.1%
10 1
2.1%
ValueCountFrequency (%)
47 1
2.1%
46 1
2.1%
45 1
2.1%
44 1
2.1%
43 1
2.1%
42 1
2.1%
41 1
2.1%
40 1
2.1%
39 1
2.1%
38 1
2.1%

업종
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Memory size508.0 B
국내외여행업
21 
종합여행업
18 
국내여행업
8 

Length

Max length6
Median length5
Mean length5.4468085
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
국내외여행업 21
44.7%
종합여행업 18
38.3%
국내여행업 8
 
17.0%

Length

2023-12-13T09:19:44.186419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:19:44.258971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국내외여행업 21
44.7%
종합여행업 18
38.3%
국내여행업 8
 
17.0%

상호
Text

Distinct42
Distinct (%)89.4%
Missing0
Missing (%)0.0%
Memory size508.0 B
2023-12-13T09:19:44.412109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length10
Mean length7.1702128
Min length4

Characters and Unicode

Total characters337
Distinct characters106
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

Unique37 ?
Unique (%)78.7%

Sample

1st row(주)유성항공여행사
2nd row동아여행사
3rd row라온여행
4th row인천투어
5th row(주)제주렌트로
ValueCountFrequency (%)
주식회사 6
 
10.7%
라온여행 2
 
3.6%
인천투어 2
 
3.6%
주)유성항공여행사 2
 
3.6%
주)청춘골프투어 2
 
3.6%
주)거산투어 2
 
3.6%
주)매일항공여행사 1
 
1.8%
트래블 1
 
1.8%
유어스투어 1
 
1.8%
남인천여행사 1
 
1.8%
Other values (36) 36
64.3%
2023-12-13T09:19:44.690637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 23
 
6.8%
어 21
 
6.2%
투 20
 
5.9%
사 19
 
5.6%
( 16
 
4.7%
) 16
 
4.7%
행 15
 
4.5%
여 14
 
4.2%
9
 
2.7%
스 8
 
2.4%
Other values (96) 176
52.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 285
84.6%
Open Punctuation 16
 
4.7%
Close Punctuation 16
 
4.7%
Uppercase Letter 11
 
3.3%
Space Separator 9
 
2.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 23
 
8.1%
어 21
 
7.4%
투 20
 
7.0%
사 19
 
6.7%
행 15
 
5.3%
여 14
 
4.9%
스 8
 
2.8%
식 6
 
2.1%
회 6
 
2.1%
아 5
 
1.8%
Other values (84) 148
51.9%
Uppercase Letter
ValueCountFrequency (%)
N 2
18.2%
Y 2
18.2%
S 1
9.1%
B 1
9.1%
C 1
9.1%
O 1
9.1%
M 1
9.1%
P 1
9.1%
A 1
9.1%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Space Separator
ValueCountFrequency (%)
9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 285
84.6%
Common 41
 
12.2%
Latin 11
 
3.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 23
 
8.1%
어 21
 
7.4%
투 20
 
7.0%
사 19
 
6.7%
행 15
 
5.3%
여 14
 
4.9%
스 8
 
2.8%
식 6
 
2.1%
회 6
 
2.1%
아 5
 
1.8%
Other values (84) 148
51.9%
Latin
ValueCountFrequency (%)
N 2
18.2%
Y 2
18.2%
S 1
9.1%
B 1
9.1%
C 1
9.1%
O 1
9.1%
M 1
9.1%
P 1
9.1%
A 1
9.1%
Common
ValueCountFrequency (%)
( 16
39.0%
) 16
39.0%
9
22.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 285
84.6%
ASCII 52
 
15.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 23
 
8.1%
어 21
 
7.4%
투 20
 
7.0%
사 19
 
6.7%
행 15
 
5.3%
여 14
 
4.9%
스 8
 
2.8%
식 6
 
2.1%
회 6
 
2.1%
아 5
 
1.8%
Other values (84) 148
51.9%
ASCII
ValueCountFrequency (%)
( 16
30.8%
) 16
30.8%
9
17.3%
N 2
 
3.8%
Y 2
 
3.8%
S 1
 
1.9%
B 1
 
1.9%
C 1
 
1.9%
O 1
 
1.9%
M 1
 
1.9%
Other values (2) 2
 
3.8%

도로명주소
Text

Distinct42
Distinct (%)89.4%
Missing0
Missing (%)0.0%
Memory size508.0 B
2023-12-13T09:19:44.939632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length38
Mean length33.510638
Min length24

Characters and Unicode

Total characters1575
Distinct characters103
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

Unique38 ?
Unique (%)80.9%

Sample

1st row인천광역시 미추홀구 미추홀대로 718 (주안동)
2nd row인천광역시 미추홀구 인하로183번길 24 (주안동)
3rd row인천광역시 미추홀구 소성로 6, 지하1층 (용현동, 홈플러스 인하점)
4th row인천광역시 미추홀구 한나루로 465, 202호 (용현동)
5th row인천광역시 미추홀구 주안중로 25, 신성쇼핑 2층 234호 (주안동)
ValueCountFrequency (%)
인천광역시 47
 
15.2%
미추홀구 47
 
15.2%
주안동 24
 
7.7%
2층 8
 
2.6%
용현동 8
 
2.6%
학익동 8
 
2.6%
미추홀대로 7
 
2.3%
1층 6
 
1.9%
경인로 5
 
1.6%
소성로 4
 
1.3%
Other values (110) 146
47.1%
2023-12-13T09:19:45.300752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
263
 
16.7%
인 63
 
4.0%
홀 60
 
3.8%
1 57
 
3.6%
미 56
 
3.6%
추 56
 
3.6%
천 48
 
3.0%
구 48
 
3.0%
동 48
 
3.0%
광 48
 
3.0%
Other values (93) 828
52.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 906
57.5%
Space Separator 263
 
16.7%
Decimal Number 254
 
16.1%
Close Punctuation 47
 
3.0%
Other Punctuation 47
 
3.0%
Open Punctuation 47
 
3.0%
Uppercase Letter 6
 
0.4%
Dash Punctuation 5
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 63
 
7.0%
홀 60
 
6.6%
미 56
 
6.2%
추 56
 
6.2%
천 48
 
5.3%
구 48
 
5.3%
동 48
 
5.3%
광 48
 
5.3%
시 47
 
5.2%
역 47
 
5.2%
Other values (73) 385
42.5%
Decimal Number
ValueCountFrequency (%)
1 57
22.4%
2 46
18.1%
0 25
9.8%
3 24
9.4%
4 21
 
8.3%
6 20
 
7.9%
5 18
 
7.1%
7 16
 
6.3%
8 16
 
6.3%
9 11
 
4.3%
Uppercase Letter
ValueCountFrequency (%)
I 2
33.3%
E 1
16.7%
P 1
16.7%
N 1
16.7%
T 1
16.7%
Space Separator
ValueCountFrequency (%)
263
100.0%
Close Punctuation
ValueCountFrequency (%)
) 47
100.0%
Other Punctuation
ValueCountFrequency (%)
, 47
100.0%
Open Punctuation
ValueCountFrequency (%)
( 47
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 906
57.5%
Common 663
42.1%
Latin 6
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 63
 
7.0%
홀 60
 
6.6%
미 56
 
6.2%
추 56
 
6.2%
천 48
 
5.3%
구 48
 
5.3%
동 48
 
5.3%
광 48
 
5.3%
시 47
 
5.2%
역 47
 
5.2%
Other values (73) 385
42.5%
Common
ValueCountFrequency (%)
263
39.7%
1 57
 
8.6%
) 47
 
7.1%
, 47
 
7.1%
( 47
 
7.1%
2 46
 
6.9%
0 25
 
3.8%
3 24
 
3.6%
4 21
 
3.2%
6 20
 
3.0%
Other values (5) 66
 
10.0%
Latin
ValueCountFrequency (%)
I 2
33.3%
E 1
16.7%
P 1
16.7%
N 1
16.7%
T 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 906
57.5%
ASCII 669
42.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
263
39.3%
1 57
 
8.5%
) 47
 
7.0%
, 47
 
7.0%
( 47
 
7.0%
2 46
 
6.9%
0 25
 
3.7%
3 24
 
3.6%
4 21
 
3.1%
6 20
 
3.0%
Other values (10) 72
 
10.8%
Hangul
ValueCountFrequency (%)
인 63
 
7.0%
홀 60
 
6.6%
미 56
 
6.2%
추 56
 
6.2%
천 48
 
5.3%
구 48
 
5.3%
동 48
 
5.3%
광 48
 
5.3%
시 47
 
5.2%
역 47
 
5.2%
Other values (73) 385
42.5%

전화번호
Text

MISSING 

Distinct25
Distinct (%)89.3%
Missing19
Missing (%)40.4%
Memory size508.0 B
2023-12-13T09:19:45.457422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.178571
Min length12

Characters and Unicode

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

Unique

Unique22 ?
Unique (%)78.6%

Sample

1st row032-424-5050
2nd row032-832-7778
3rd row032-876-7500
4th row032-719-4425
5th row032-225-20080
ValueCountFrequency (%)
032-876-7500 2
 
7.1%
032-424-5050 2
 
7.1%
032-719-4425 2
 
7.1%
032-442-9900 1
 
3.6%
032-873-5818 1
 
3.6%
070-8624-8860 1
 
3.6%
032-423-2666 1
 
3.6%
032-422-7001 1
 
3.6%
032-465-9595 1
 
3.6%
032-224-7100 1
 
3.6%
Other values (15) 15
53.6%
2023-12-13T09:19:45.720490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 62
18.2%
- 55
16.1%
2 53
15.5%
3 35
10.3%
4 25
7.3%
8 24
 
7.0%
7 24
 
7.0%
5 18
 
5.3%
6 17
 
5.0%
1 17
 
5.0%
Other values (2) 11
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 285
83.6%
Dash Punctuation 55
 
16.1%
Math Symbol 1
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 62
21.8%
2 53
18.6%
3 35
12.3%
4 25
8.8%
8 24
 
8.4%
7 24
 
8.4%
5 18
 
6.3%
6 17
 
6.0%
1 17
 
6.0%
9 10
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 55
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 341
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 62
18.2%
- 55
16.1%
2 53
15.5%
3 35
10.3%
4 25
7.3%
8 24
 
7.0%
7 24
 
7.0%
5 18
 
5.3%
6 17
 
5.0%
1 17
 
5.0%
Other values (2) 11
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 341
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 62
18.2%
- 55
16.1%
2 53
15.5%
3 35
10.3%
4 25
7.3%
8 24
 
7.0%
7 24
 
7.0%
5 18
 
5.3%
6 17
 
5.0%
1 17
 
5.0%
Other values (2) 11
 
3.2%

Interactions

2023-12-13T09:19:43.714635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T09:19:45.804152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종상호도로명주소전화번호
연번1.0000.9300.7050.6430.886
업종0.9301.0000.0000.0000.000
상호0.7050.0001.0001.0001.000
도로명주소0.6430.0001.0001.0001.000
전화번호0.8860.0001.0001.0001.000
2023-12-13T09:19:45.885080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.830
업종0.8301.000

Missing values

2023-12-13T09:19:43.798295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T09:19:43.867057image/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국내여행업(주)유성항공여행사인천광역시 미추홀구 미추홀대로 718 (주안동)032-424-5050
12국내여행업동아여행사인천광역시 미추홀구 인하로183번길 24 (주안동)032-832-7778
23국내여행업라온여행인천광역시 미추홀구 소성로 6, 지하1층 (용현동, 홈플러스 인하점)032-876-7500
34국내여행업인천투어인천광역시 미추홀구 한나루로 465, 202호 (용현동)032-719-4425
45국내여행업(주)제주렌트로인천광역시 미추홀구 주안중로 25, 신성쇼핑 2층 234호 (주안동)<NA>
56국내여행업(주)거산투어인천광역시 미추홀구 미추홀대로 704, 3층 (주안동)<NA>
67국내여행업(주)청춘골프투어인천광역시 미추홀구 주안로90번길 37 (주안동)032-225-20080
78국내여행업(주)다사랑역사기행인천광역시 미추홀구 경인로 334-17, 2층 (주안동)<NA>
89국내외여행업(주)유성항공여행사인천광역시 미추홀구 미추홀대로 718 (주안동)032-424-5050
910국내외여행업세진해외여행사인천광역시 미추홀구 경인로 358 (주안동)032-438-7600
연번업종상호도로명주소전화번호
3738종합여행업유어스투어인천광역시 미추홀구 미추홀대로 716, 메인프라자 505호 (주안동)<NA>
3839종합여행업주식회사 산들투어인천광역시 미추홀구 인주대로 433, 2층 (주안동)032-465-9595
3940종합여행업(주)오렌지투어인천광역시 미추홀구 매소홀로 262, 12층 21호 (학익동)032-422-7001
4041종합여행업주식회사 가온잡인천광역시 미추홀구 주안로 108, 경향빌딩 410호 (주안동)032-423-2666
4142종합여행업주식회사 나드리투어인천광역시 미추홀구 경원대로716번길 1, 2층 (관교동)<NA>
4243종합여행업베트남달랏골프투어인천광역시 미추홀구 용오로 84, 204호 (용현동)070-8624-8860
4344종합여행업코코 코리아인천광역시 미추홀구 방축로 312, 205호 (주안동)<NA>
4445종합여행업스케치북 트래블인천광역시 미추홀구 경원대로 873, 인성빌딩 3층 302-3호 (주안동)<NA>
4546종합여행업주식회사 케이파크투어인천광역시 미추홀구 매소홀로 262, 15층 15018호 (학익동)032-884-0050
4647종합여행업(주)에스앤와이컴퍼니인천광역시 미추홀구 매소홀로 262, 15층 6호 (학익동)<NA>