Overview

Dataset statistics

Number of variables5
Number of observations58
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory43.3 B

Variable types

Numeric1
Categorical2
Text2

Dataset

Description대구광역시 서구_여행업 현황_20240220
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15053841&dataSetDetailId=150538411d28201131d3c_201910161623&provdMethod=FILE

Alerts

연번 is highly overall correlated with 업종중분류High correlation
업종중분류 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-13 13:48:15.484046
Analysis finished2024-03-13 13:48:15.955173
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.5
Minimum1
Maximum58
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size654.0 B
2024-03-13T22:48:16.025261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.85
Q115.25
median29.5
Q343.75
95-th percentile55.15
Maximum58
Range57
Interquartile range (IQR)28.5

Descriptive statistics

Standard deviation16.886879
Coefficient of variation (CV)0.57243656
Kurtosis-1.2
Mean29.5
Median Absolute Deviation (MAD)14.5
Skewness0
Sum1711
Variance285.16667
MonotonicityStrictly increasing
2024-03-13T22:48:16.156704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.7%
45 1
 
1.7%
33 1
 
1.7%
34 1
 
1.7%
35 1
 
1.7%
36 1
 
1.7%
37 1
 
1.7%
38 1
 
1.7%
39 1
 
1.7%
40 1
 
1.7%
Other values (48) 48
82.8%
ValueCountFrequency (%)
1 1
1.7%
2 1
1.7%
3 1
1.7%
4 1
1.7%
5 1
1.7%
6 1
1.7%
7 1
1.7%
8 1
1.7%
9 1
1.7%
10 1
1.7%
ValueCountFrequency (%)
58 1
1.7%
57 1
1.7%
56 1
1.7%
55 1
1.7%
54 1
1.7%
53 1
1.7%
52 1
1.7%
51 1
1.7%
50 1
1.7%
49 1
1.7%

업종중분류
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size596.0 B
국내여행업
30 
국외여행업
23 
종합여행업
5 

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 (%)
국내여행업 30
51.7%
국외여행업 23
39.7%
종합여행업 5
 
8.6%

Length

2024-03-13T22:48:16.282644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:48:16.393970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
국내여행업 30
51.7%
국외여행업 23
39.7%
종합여행업 5
 
8.6%

업체명
Text

Distinct35
Distinct (%)60.3%
Missing0
Missing (%)0.0%
Memory size596.0 B
2024-03-13T22:48:16.594652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length9
Mean length6.8965517
Min length3

Characters and Unicode

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

Unique

Unique12 ?
Unique (%)20.7%

Sample

1st row(주)신도관광여행사
2nd row㈜신동아관광
3rd row무궁화고속관광㈜
4th row대구관광여행사(주)
5th row신지여행사
ValueCountFrequency (%)
주식회사 3
 
4.5%
주)신도관광여행사 2
 
3.0%
위너스투어㈜ 2
 
3.0%
이원 2
 
3.0%
㈜케이볼런투어 2
 
3.0%
㈜대명여행사 2
 
3.0%
㈜에스엠투어 2
 
3.0%
원언더여행사 2
 
3.0%
세나투어 2
 
3.0%
㈜푸른하늘 2
 
3.0%
Other values (30) 45
68.2%
2024-03-13T22:48:17.008904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
㈜ 28
 
7.0%
어 23
 
5.8%
투 21
 
5.2%
사 18
 
4.5%
행 17
 
4.2%
여 17
 
4.2%
주 13
 
3.2%
스 12
 
3.0%
( 10
 
2.5%
) 10
 
2.5%
Other values (88) 231
57.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 342
85.5%
Other Symbol 28
 
7.0%
Open Punctuation 10
 
2.5%
Close Punctuation 10
 
2.5%
Space Separator 8
 
2.0%
Uppercase Letter 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
어 23
 
6.7%
투 21
 
6.1%
사 18
 
5.3%
행 17
 
5.0%
여 17
 
5.0%
주 13
 
3.8%
스 12
 
3.5%
신 9
 
2.6%
광 8
 
2.3%
원 8
 
2.3%
Other values (82) 196
57.3%
Uppercase Letter
ValueCountFrequency (%)
K 1
50.0%
N 1
50.0%
Other Symbol
ValueCountFrequency (%)
㈜ 28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 370
92.5%
Common 28
 
7.0%
Latin 2
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
㈜ 28
 
7.6%
어 23
 
6.2%
투 21
 
5.7%
사 18
 
4.9%
행 17
 
4.6%
여 17
 
4.6%
주 13
 
3.5%
스 12
 
3.2%
신 9
 
2.4%
광 8
 
2.2%
Other values (83) 204
55.1%
Common
ValueCountFrequency (%)
( 10
35.7%
) 10
35.7%
8
28.6%
Latin
ValueCountFrequency (%)
K 1
50.0%
N 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 342
85.5%
ASCII 30
 
7.5%
None 28
 
7.0%

Most frequent character per block

None
ValueCountFrequency (%)
㈜ 28
100.0%
Hangul
ValueCountFrequency (%)
어 23
 
6.7%
투 21
 
6.1%
사 18
 
5.3%
행 17
 
5.0%
여 17
 
5.0%
주 13
 
3.8%
스 12
 
3.5%
신 9
 
2.6%
광 8
 
2.3%
원 8
 
2.3%
Other values (82) 196
57.3%
ASCII
ValueCountFrequency (%)
( 10
33.3%
) 10
33.3%
8
26.7%
K 1
 
3.3%
N 1
 
3.3%

소재지
Categorical

Distinct28
Distinct (%)48.3%
Missing0
Missing (%)0.0%
Memory size596.0 B
대구광역시 서구 평리로 403 (평리동)
 
4
대구광역시 서구 달서로26길 20 (비산동)
 
4
대구광역시 서구 와룡로 307, 디센터1976 812호 (중리동)
 
4
대구광역시 서구 통학로 4, 2층 (내당동)
 
3
대구광역시 서구 통학로 30 (내당동)
 
3
Other values (23)
40 

Length

Max length43
Median length30
Mean length27.810345
Min length21

Unique

Unique8 ?
Unique (%)13.8%

Sample

1st row대구광역시 서구 달구벌대로 1791 (내당동)
2nd row대구광역시 서구 국채보상로 316, 201동 402호 (평리동, 평리롯데캐슬)
3rd row대구광역시 서구 통학로 30 (내당동)
4th row대구광역시 서구 평리로 403 (평리동)
5th row대구광역시 서구 고성로15길 25 (원대동3가)

Common Values

ValueCountFrequency (%)
대구광역시 서구 평리로 403 (평리동) 4
 
6.9%
대구광역시 서구 달서로26길 20 (비산동) 4
 
6.9%
대구광역시 서구 와룡로 307, 디센터1976 812호 (중리동) 4
 
6.9%
대구광역시 서구 통학로 4, 2층 (내당동) 3
 
5.2%
대구광역시 서구 통학로 30 (내당동) 3
 
5.2%
대구광역시 서구 달서로 123 (비산동) 3
 
5.2%
대구광역시 서구 국채보상로 316, 201동 402호 (평리동, 평리롯데캐슬) 3
 
5.2%
대구광역시 서구 서대구로 13, 1층 (내당동) 2
 
3.4%
대구광역시 서구 고성로15길 25 (원대동3가) 2
 
3.4%
대구광역시 서구 달구벌대로 1821, 2층 (내당동) 2
 
3.4%
Other values (18) 28
48.3%

Length

2024-03-13T22:48:17.150822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대구광역시 58
17.3%
서구 58
17.3%
비산동 20
 
6.0%
내당동 15
 
4.5%
중리동 9
 
2.7%
평리동 9
 
2.7%
2층 8
 
2.4%
평리로 7
 
2.1%
서대구로 6
 
1.8%
통학로 6
 
1.8%
Other values (60) 140
41.7%

전화번호
Text

Distinct32
Distinct (%)55.2%
Missing0
Missing (%)0.0%
Memory size596.0 B
2024-03-13T22:48:17.336020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.051724
Min length9

Characters and Unicode

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

Unique8 ?
Unique (%)13.8%

Sample

1st row053-559-3131
2nd row053-572-4000
3rd row053-572-3838
4th row053-421-5581
5th row053-627-9858
ValueCountFrequency (%)
053-639-7878 3
 
5.2%
053-572-4000 3
 
5.2%
053-431-8886 2
 
3.4%
053-526-5677 2
 
3.4%
053-424-3141 2
 
3.4%
053-255-3141 2
 
3.4%
053-426-1171 2
 
3.4%
053-215-8800 2
 
3.4%
053-234-6000 2
 
3.4%
053-955-5058 2
 
3.4%
Other values (22) 36
62.1%
2024-03-13T22:48:17.713769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 127
18.2%
- 115
16.5%
0 100
14.3%
3 83
11.9%
7 48
 
6.9%
2 48
 
6.9%
8 47
 
6.7%
1 40
 
5.7%
4 39
 
5.6%
6 38
 
5.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 584
83.5%
Dash Punctuation 115
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 127
21.7%
0 100
17.1%
3 83
14.2%
7 48
 
8.2%
2 48
 
8.2%
8 47
 
8.0%
1 40
 
6.8%
4 39
 
6.7%
6 38
 
6.5%
9 14
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 115
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 699
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 127
18.2%
- 115
16.5%
0 100
14.3%
3 83
11.9%
7 48
 
6.9%
2 48
 
6.9%
8 47
 
6.7%
1 40
 
5.7%
4 39
 
5.6%
6 38
 
5.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 699
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 127
18.2%
- 115
16.5%
0 100
14.3%
3 83
11.9%
7 48
 
6.9%
2 48
 
6.9%
8 47
 
6.7%
1 40
 
5.7%
4 39
 
5.6%
6 38
 
5.4%

Interactions

2024-03-13T22:48:15.721271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:48:17.834402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종중분류업체명소재지전화번호
연번1.0000.9360.0000.2940.415
업종중분류0.9361.0000.0000.3140.294
업체명0.0000.0001.0000.9991.000
소재지0.2940.3140.9991.0000.998
전화번호0.4150.2941.0000.9981.000
2024-03-13T22:48:17.933195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종중분류소재지
업종중분류1.0000.084
소재지0.0841.000
2024-03-13T22:48:18.020508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종중분류소재지
연번1.0000.8570.000
업종중분류0.8571.0000.084
소재지0.0000.0841.000

Missing values

2024-03-13T22:48:15.823774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:48:15.919270image/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국내여행업(주)신도관광여행사대구광역시 서구 달구벌대로 1791 (내당동)053-559-3131
12국내여행업㈜신동아관광대구광역시 서구 국채보상로 316, 201동 402호 (평리동, 평리롯데캐슬)053-572-4000
23국내여행업무궁화고속관광㈜대구광역시 서구 통학로 30 (내당동)053-572-3838
34국내여행업대구관광여행사(주)대구광역시 서구 평리로 403 (평리동)053-421-5581
45국내여행업신지여행사대구광역시 서구 고성로15길 25 (원대동3가)053-627-9858
56국내여행업(주)신동아고속관광대구광역시 서구 국채보상로 316, 201동 402호 (평리동, 평리롯데캐슬)053-572-4000
67국내여행업위너스투어(주)대구광역시 서구 달서로 123 (비산동)053-639-7878
78국내여행업(주)웰컴투어대구광역시 서구 달구벌대로 1821, 2층 (내당동)053-526-0052
89국내여행업㈜고경자여행사대구광역시 서구 서대구로10길 6 (내당동)053-427-8721
910국내여행업위너스투어㈜대구광역시 서구 달서로 123 (비산동)053-639-7878
연번업종중분류업체명소재지전화번호
4849국외여행업세나투어대구광역시 서구 평리로 236, 115호 (내당동, 삼익뉴타운)053-426-1171
4950국외여행업원언더여행사대구광역시 서구 달서로26길 20 (비산동)053-566-5677
5051국외여행업㈜위더스투어앤골프대구광역시 서구 와룡로66길 56, 106호 (중리동)053-234-6000
5152국외여행업㈜대명여행사대구광역시 서구 국채보상로 182, 정학빌딩 3층 (중리동)053-955-5058
5253국외여행업㈜케이볼런투어대구광역시 서구 북비산로71길 25-12 (비산동)053-355-8055
5354종합여행업㈜엠에스네트웍스대구광역시 서구 통학로 30 (내당동)053-431-8886
5455종합여행업㈜담비대구광역시 서구 통학로 30 (내당동)053-431-8886
5556종합여행업NK 투어대구광역시 서구 와룡로 307, 디센터1976 513호 (중리동)070-7635-2401
5657종합여행업㈜엑스코투어대구광역시 서구 통학로48길 34-3, 2층 (비산동)053-428-4002
5758종합여행업주식회사 드림와이드대구광역시 서구 팔달로 152, 340-1호 (비산동)053-313-2366