Overview

Dataset statistics

Number of variables6
Number of observations31
Missing cells3
Missing cells (%)1.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory53.3 B

Variable types

Numeric1
Text4
DateTime1

Dataset

Description경상북도 영덕군 관내에서 운영 중인 주유소 업종구분, 업체명, 소재지주소, 전화번호 등 관련 정보를 아래와 같이 제공하고자 합니다.
Author경상북도 영덕군
URLhttps://www.data.go.kr/data/15090270/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
영업소전화번호 has 3 (9.7%) missing valuesMissing
연번 has unique valuesUnique
상호 has unique valuesUnique
영업소소재지_도로명 has unique valuesUnique
영업소소재지_지번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:32:13.479123
Analysis finished2023-12-12 11:32:14.429362
Duration0.95 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-12T20:32:14.540312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.5
Q18.5
median16
Q323.5
95-th percentile29.5
Maximum31
Range30
Interquartile range (IQR)15

Descriptive statistics

Standard deviation9.0921211
Coefficient of variation (CV)0.56825757
Kurtosis-1.2
Mean16
Median Absolute Deviation (MAD)8
Skewness0
Sum496
Variance82.666667
MonotonicityStrictly increasing
2023-12-12T20:32:14.767750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
1 1
 
3.2%
2 1
 
3.2%
31 1
 
3.2%
30 1
 
3.2%
29 1
 
3.2%
28 1
 
3.2%
27 1
 
3.2%
26 1
 
3.2%
25 1
 
3.2%
24 1
 
3.2%
Other values (21) 21
67.7%
ValueCountFrequency (%)
1 1
3.2%
2 1
3.2%
3 1
3.2%
4 1
3.2%
5 1
3.2%
6 1
3.2%
7 1
3.2%
8 1
3.2%
9 1
3.2%
10 1
3.2%
ValueCountFrequency (%)
31 1
3.2%
30 1
3.2%
29 1
3.2%
28 1
3.2%
27 1
3.2%
26 1
3.2%
25 1
3.2%
24 1
3.2%
23 1
3.2%
22 1
3.2%

상호
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T20:32:15.095706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length5
Mean length6.9032258
Min length5

Characters and Unicode

Total characters214
Distinct characters60
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

Unique31 ?
Unique (%)100.0%

Sample

1st row강구농협 달산지점
2nd row영해벌영주유소
3rd row강구농협 남정지점 주유소
4th row강구농협주유소
5th row영덕농협주유소
ValueCountFrequency (%)
강구농협 2
 
5.4%
주유소 2
 
5.4%
영해농협주유소 2
 
5.4%
평강주유소 1
 
2.7%
ok주유소 1
 
2.7%
병곡주유소 1
 
2.7%
대성주유소 1
 
2.7%
삼화주유소 1
 
2.7%
해변주유소 1
 
2.7%
동화주유소 1
 
2.7%
Other values (24) 24
64.9%
2023-12-12T20:32:15.748103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
33
15.4%
30
 
14.0%
30
 
14.0%
9
 
4.2%
8
 
3.7%
7
 
3.3%
6
 
2.8%
6
 
2.8%
5
 
2.3%
4
 
1.9%
Other values (50) 76
35.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 200
93.5%
Space Separator 6
 
2.8%
Close Punctuation 3
 
1.4%
Open Punctuation 3
 
1.4%
Uppercase Letter 2
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
33
16.5%
30
15.0%
30
15.0%
9
 
4.5%
8
 
4.0%
7
 
3.5%
6
 
3.0%
5
 
2.5%
4
 
2.0%
4
 
2.0%
Other values (45) 64
32.0%
Uppercase Letter
ValueCountFrequency (%)
K 1
50.0%
O 1
50.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 200
93.5%
Common 12
 
5.6%
Latin 2
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
33
16.5%
30
15.0%
30
15.0%
9
 
4.5%
8
 
4.0%
7
 
3.5%
6
 
3.0%
5
 
2.5%
4
 
2.0%
4
 
2.0%
Other values (45) 64
32.0%
Common
ValueCountFrequency (%)
6
50.0%
) 3
25.0%
( 3
25.0%
Latin
ValueCountFrequency (%)
K 1
50.0%
O 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 200
93.5%
ASCII 14
 
6.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
33
16.5%
30
15.0%
30
15.0%
9
 
4.5%
8
 
4.0%
7
 
3.5%
6
 
3.0%
5
 
2.5%
4
 
2.0%
4
 
2.0%
Other values (45) 64
32.0%
ASCII
ValueCountFrequency (%)
6
42.9%
) 3
21.4%
( 3
21.4%
K 1
 
7.1%
O 1
 
7.1%
Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T20:32:16.109208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length24
Mean length21.290323
Min length18

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row경상북도 영덕군 달산면 팔각산로 1828-15
2nd row경상북도 영덕군 영해면 동해대로 6643
3rd row경상북도 영덕군 남정면 산정로 8
4th row경상북도 영덕군 강구면 강구시장길 40-6
5th row경상북도 영덕군 영덕읍 중앙길 122
ValueCountFrequency (%)
경상북도 31
20.0%
영덕군 31
20.0%
동해대로 14
 
9.0%
영덕로 6
 
3.9%
강구면 5
 
3.2%
영해면 5
 
3.2%
영덕읍 5
 
3.2%
경동로 4
 
2.6%
병곡면 4
 
2.6%
지품면 4
 
2.6%
Other values (41) 46
29.7%
2023-12-12T20:32:16.837817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
124
18.8%
47
 
7.1%
42
 
6.4%
35
 
5.3%
31
 
4.7%
31
 
4.7%
31
 
4.7%
31
 
4.7%
27
 
4.1%
26
 
3.9%
Other values (38) 235
35.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 421
63.8%
Space Separator 124
 
18.8%
Decimal Number 112
 
17.0%
Dash Punctuation 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
47
11.2%
42
10.0%
35
 
8.3%
31
 
7.4%
31
 
7.4%
31
 
7.4%
31
 
7.4%
27
 
6.4%
26
 
6.2%
19
 
4.5%
Other values (26) 101
24.0%
Decimal Number
ValueCountFrequency (%)
7 15
13.4%
4 15
13.4%
6 13
11.6%
1 13
11.6%
5 11
9.8%
3 11
9.8%
8 11
9.8%
9 9
8.0%
2 9
8.0%
0 5
 
4.5%
Space Separator
ValueCountFrequency (%)
124
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 421
63.8%
Common 239
36.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
47
11.2%
42
10.0%
35
 
8.3%
31
 
7.4%
31
 
7.4%
31
 
7.4%
31
 
7.4%
27
 
6.4%
26
 
6.2%
19
 
4.5%
Other values (26) 101
24.0%
Common
ValueCountFrequency (%)
124
51.9%
7 15
 
6.3%
4 15
 
6.3%
6 13
 
5.4%
1 13
 
5.4%
5 11
 
4.6%
3 11
 
4.6%
8 11
 
4.6%
9 9
 
3.8%
2 9
 
3.8%
Other values (2) 8
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 421
63.8%
ASCII 239
36.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
124
51.9%
7 15
 
6.3%
4 15
 
6.3%
6 13
 
5.4%
1 13
 
5.4%
5 11
 
4.6%
3 11
 
4.6%
8 11
 
4.6%
9 9
 
3.8%
2 9
 
3.8%
Other values (2) 8
 
3.3%
Hangul
ValueCountFrequency (%)
47
11.2%
42
10.0%
35
 
8.3%
31
 
7.4%
31
 
7.4%
31
 
7.4%
31
 
7.4%
27
 
6.4%
26
 
6.2%
19
 
4.5%
Other values (26) 101
24.0%
Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T20:32:17.307349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length34
Mean length26.741935
Min length23

Characters and Unicode

Total characters829
Distinct characters66
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

Unique31 ?
Unique (%)100.0%

Sample

1st row경상북도 영덕군 달산면 대지리 85 번지
2nd row경상북도 영덕군 영해면 벌영리 98 번지
3rd row경상북도 영덕군 남정면 장사리 8 번지1 호
4th row경상북도 영덕군 강구면 오포리 555 번지7 호
5th row경상북도 영덕군 영덕읍 남석리 108 번지1 호
ValueCountFrequency (%)
경상북도 31
 
14.7%
영덕군 31
 
14.7%
18
 
8.5%
번지1 12
 
5.7%
번지 8
 
3.8%
강구면 5
 
2.4%
영덕읍 5
 
2.4%
영해면 5
 
2.4%
지품면 4
 
1.9%
병곡면 4
 
1.9%
Other values (70) 88
41.7%
2023-12-12T20:32:17.972808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
211
25.5%
42
 
5.1%
38
 
4.6%
37
 
4.5%
1 32
 
3.9%
31
 
3.7%
31
 
3.7%
31
 
3.7%
31
 
3.7%
31
 
3.7%
Other values (56) 314
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 497
60.0%
Space Separator 211
25.5%
Decimal Number 116
 
14.0%
Dash Punctuation 3
 
0.4%
Other Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
42
 
8.5%
38
 
7.6%
37
 
7.4%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
Other values (43) 163
32.8%
Decimal Number
ValueCountFrequency (%)
1 32
27.6%
2 15
12.9%
4 12
 
10.3%
5 11
 
9.5%
9 11
 
9.5%
8 10
 
8.6%
3 7
 
6.0%
6 6
 
5.2%
7 6
 
5.2%
0 6
 
5.2%
Space Separator
ValueCountFrequency (%)
211
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 497
60.0%
Common 332
40.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
42
 
8.5%
38
 
7.6%
37
 
7.4%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
Other values (43) 163
32.8%
Common
ValueCountFrequency (%)
211
63.6%
1 32
 
9.6%
2 15
 
4.5%
4 12
 
3.6%
5 11
 
3.3%
9 11
 
3.3%
8 10
 
3.0%
3 7
 
2.1%
6 6
 
1.8%
7 6
 
1.8%
Other values (3) 11
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 497
60.0%
ASCII 332
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
211
63.6%
1 32
 
9.6%
2 15
 
4.5%
4 12
 
3.6%
5 11
 
3.3%
9 11
 
3.3%
8 10
 
3.0%
3 7
 
2.1%
6 6
 
1.8%
7 6
 
1.8%
Other values (3) 11
 
3.3%
Hangul
ValueCountFrequency (%)
42
 
8.5%
38
 
7.6%
37
 
7.4%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
31
 
6.2%
Other values (43) 163
32.8%

영업소전화번호
Text

MISSING 

Distinct28
Distinct (%)100.0%
Missing3
Missing (%)9.7%
Memory size380.0 B
2023-12-12T20:32:18.345256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique28 ?
Unique (%)100.0%

Sample

1st row054-733-9810
2nd row054-733-4021
3rd row054-734-6571
4th row054-734-1212
5th row054-733-3688
ValueCountFrequency (%)
054-734-0901 1
 
3.6%
054-733-4021 1
 
3.6%
054-734-1313 1
 
3.6%
054-732-1991 1
 
3.6%
054-733-4077 1
 
3.6%
054-733-4159 1
 
3.6%
054-732-2451 1
 
3.6%
054-734-2800 1
 
3.6%
054-733-7717 1
 
3.6%
054-732-5454 1
 
3.6%
Other values (18) 18
64.3%
2023-12-12T20:32:18.921028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 56
16.7%
3 48
14.3%
4 46
13.7%
0 41
12.2%
7 40
11.9%
5 38
11.3%
1 24
7.1%
2 18
 
5.4%
8 12
 
3.6%
9 10
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 280
83.3%
Dash Punctuation 56
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 48
17.1%
4 46
16.4%
0 41
14.6%
7 40
14.3%
5 38
13.6%
1 24
8.6%
2 18
 
6.4%
8 12
 
4.3%
9 10
 
3.6%
6 3
 
1.1%
Dash Punctuation
ValueCountFrequency (%)
- 56
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 336
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 56
16.7%
3 48
14.3%
4 46
13.7%
0 41
12.2%
7 40
11.9%
5 38
11.3%
1 24
7.1%
2 18
 
5.4%
8 12
 
3.6%
9 10
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 336
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 56
16.7%
3 48
14.3%
4 46
13.7%
0 41
12.2%
7 40
11.9%
5 38
11.3%
1 24
7.1%
2 18
 
5.4%
8 12
 
3.6%
9 10
 
3.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
Minimum2022-08-25 00:00:00
Maximum2022-08-25 00:00:00
2023-12-12T20:32:19.125959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:32:19.297860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T20:32:13.973254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:32:19.410780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호영업소소재지_도로명영업소소재지_지번영업소전화번호
연번1.0001.0001.0001.0001.000
상호1.0001.0001.0001.0001.000
영업소소재지_도로명1.0001.0001.0001.0001.000
영업소소재지_지번1.0001.0001.0001.0001.000
영업소전화번호1.0001.0001.0001.0001.000

Missing values

2023-12-12T20:32:14.172225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:32:14.356098image/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강구농협 달산지점경상북도 영덕군 달산면 팔각산로 1828-15경상북도 영덕군 달산면 대지리 85 번지054-733-98102022-08-25
12영해벌영주유소경상북도 영덕군 영해면 동해대로 6643경상북도 영덕군 영해면 벌영리 98 번지<NA>2022-08-25
23강구농협 남정지점 주유소경상북도 영덕군 남정면 산정로 8경상북도 영덕군 남정면 장사리 8 번지1 호054-733-40212022-08-25
34강구농협주유소경상북도 영덕군 강구면 강구시장길 40-6경상북도 영덕군 강구면 오포리 555 번지7 호054-734-65712022-08-25
45영덕농협주유소경상북도 영덕군 영덕읍 중앙길 122경상북도 영덕군 영덕읍 남석리 108 번지1 호054-734-12122022-08-25
56유창주유소경상북도 영덕군 강구면 동해대로 4369경상북도 영덕군 강구면 삼사리 91 번지1 호054-733-36882022-08-25
67영덕휴게소 영해농협주유소경상북도 영덕군 영해면 동해대로 6568경상북도 영덕군 영해면 성내리 산49 번지1 호외 24필지<NA>2022-08-25
78(주)서광 해맞이휴게주유소경상북도 영덕군 병곡면 동해대로 7918경상북도 영덕군 병곡면 금곡리 10 번지11,12-1,12-2054-734-82002022-08-25
89영덕울진축산업협동조합 주유소경상북도 영덕군 축산면 동해대로 5937경상북도 영덕군 축산면 고곡리 329 번지054-732-17182022-08-25
910해맞이주유소경상북도 영덕군 영덕읍 동해대로 5354경상북도 영덕군 영덕읍 화수리 229 번지1 호054-732-51452022-08-25
연번상호영업소소재지_도로명영업소소재지_지번영업소전화번호데이터기준일자
2122달산고속주유소경상북도 영덕군 지품면 경동로 7526경상북도 영덕군 지품면 신양리 25 번지054-733-77912022-08-25
2223금곡주유소경상북도 영덕군 병곡면 동해대로 7801경상북도 영덕군 병곡면 금곡리 203 번지4 호054-733-81182022-08-25
2324해변주유소경상북도 영덕군 남정면 동해대로 4079경상북도 영덕군 남정면 구계리 22 번지1 호외9필054-732-54542022-08-25
2425삼화주유소경상북도 영덕군 지품면 경동로 7874경상북도 영덕군 지품면 삼화리 169 번지5 호054-733-77172022-08-25
2526대성주유소경상북도 영덕군 영해면 영덕로 1831경상북도 영덕군 영해면 성내리 481 번지054-734-28002022-08-25
2627병곡주유소경상북도 영덕군 병곡면 흰돌로 20경상북도 영덕군 병곡면 병곡리 331 번지7 호054-732-24512022-08-25
2728평강주유소경상북도 영덕군 강구면 동해대로 4468경상북도 영덕군 강구면 오포리 49 번지8 호054-733-41592022-08-25
2829OK주유소경상북도 영덕군 강구면 동해대로 4499경상북도 영덕군 강구면 오포리 557 번지4 호054-733-40772022-08-25
2930영해농협주유소경상북도 영덕군 영해면 연평길 13경상북도 영덕군 영해면 연평리 117 번지6 호16 통1 반054-732-19912022-08-25
3031영덕제일주유소경상북도 영덕군 영덕읍 영덕로 247경상북도 영덕군 영덕읍 덕곡리 195 번지4 호054-734-38222022-08-25