Overview

Dataset statistics

Number of variables4
Number of observations64
Missing cells1
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory34.0 B

Variable types

Text3
Categorical1

Dataset

Description광주광역시 북구지역 석유판매업(주유소) 현황에 관한 데이터로 명칭, 소재지, 상표, 전화번호를 포함하고 있습니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15043905/fileData.do

Alerts

전화번호 has 1 (1.6%) missing valuesMissing
상호 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2024-03-15 00:50:43.744059
Analysis finished2024-03-15 00:50:44.612465
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size640.0 B
2024-03-15T09:50:45.298425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length17
Mean length9.109375
Min length5

Characters and Unicode

Total characters583
Distinct characters134
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

Unique64 ?
Unique (%)100.0%

Sample

1st row용전IC주유소
2nd row행복가득주유소
3rd row(유)착한주유소
4th row(주)아승클린주유소
5th row(주)스피드주유소
ValueCountFrequency (%)
hd현대오일뱅크㈜직영 2
 
2.6%
sk에너지(주 2
 
2.6%
용전ic주유소 1
 
1.3%
광주화물터미널(주 1
 
1.3%
매곡주유소 1
 
1.3%
코끼리주유소(sk 1
 
1.3%
서림주유소 1
 
1.3%
테크노파크주유소 1
 
1.3%
으뜸주유소 1
 
1.3%
첨단북광주ic주유소 1
 
1.3%
Other values (64) 64
84.2%
2024-03-15T09:50:46.717980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 88
 
15.1%
유 67
 
11.5%
소 62
 
10.6%
) 23
 
3.9%
( 23
 
3.9%
지 13
 
2.2%
에 12
 
2.1%
12
 
2.1%
일 10
 
1.7%
너 8
 
1.4%
Other values (124) 265
45.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 493
84.6%
Uppercase Letter 28
 
4.8%
Close Punctuation 23
 
3.9%
Open Punctuation 23
 
3.9%
Space Separator 12
 
2.1%
Other Symbol 4
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 88
17.8%
유 67
 
13.6%
소 62
 
12.6%
지 13
 
2.6%
에 12
 
2.4%
일 10
 
2.0%
너 8
 
1.6%
스 8
 
1.6%
셀 7
 
1.4%
용 7
 
1.4%
Other values (114) 211
42.8%
Uppercase Letter
ValueCountFrequency (%)
S 6
21.4%
K 6
21.4%
C 5
17.9%
I 5
17.9%
D 3
10.7%
H 3
10.7%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Space Separator
ValueCountFrequency (%)
12
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 497
85.2%
Common 58
 
9.9%
Latin 28
 
4.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 88
17.7%
유 67
 
13.5%
소 62
 
12.5%
지 13
 
2.6%
에 12
 
2.4%
일 10
 
2.0%
너 8
 
1.6%
스 8
 
1.6%
셀 7
 
1.4%
용 7
 
1.4%
Other values (115) 215
43.3%
Latin
ValueCountFrequency (%)
S 6
21.4%
K 6
21.4%
C 5
17.9%
I 5
17.9%
D 3
10.7%
H 3
10.7%
Common
ValueCountFrequency (%)
) 23
39.7%
( 23
39.7%
12
20.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 493
84.6%
ASCII 86
 
14.8%
None 4
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 88
17.8%
유 67
 
13.6%
소 62
 
12.6%
지 13
 
2.6%
에 12
 
2.4%
일 10
 
2.0%
너 8
 
1.6%
스 8
 
1.6%
셀 7
 
1.4%
용 7
 
1.4%
Other values (114) 211
42.8%
ASCII
ValueCountFrequency (%)
) 23
26.7%
( 23
26.7%
12
14.0%
S 6
 
7.0%
K 6
 
7.0%
C 5
 
5.8%
I 5
 
5.8%
D 3
 
3.5%
H 3
 
3.5%
None
ValueCountFrequency (%)
㈜ 4
100.0%

주소
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size640.0 B
2024-03-15T09:50:47.910302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length22
Mean length17.796875
Min length12

Characters and Unicode

Total characters1139
Distinct characters77
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

Unique64 ?
Unique (%)100.0%

Sample

1st row광주 북구 우치로 842 (용전동)
2nd row광주 북구 우치로 952(용전동)
3rd row광주 북구 동문대로 452 (장등동)
4th row광주 북구 우치로 170 (용봉동)
5th row광주 북구 설죽로 226
ValueCountFrequency (%)
북구 64
21.3%
광주 62
20.7%
우치로 9
 
3.0%
하서로 7
 
2.3%
동문대로 6
 
2.0%
설죽로 5
 
1.7%
운암동 5
 
1.7%
서하로 5
 
1.7%
삼각동 5
 
1.7%
빛고을대로 5
 
1.7%
Other values (99) 127
42.3%
2024-03-15T09:50:49.610097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
239
21.0%
북 67
 
5.9%
광 66
 
5.8%
주 65
 
5.7%
구 64
 
5.6%
로 64
 
5.6%
동 53
 
4.7%
) 46
 
4.0%
( 46
 
4.0%
2 28
 
2.5%
Other values (67) 401
35.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 625
54.9%
Space Separator 239
 
21.0%
Decimal Number 183
 
16.1%
Close Punctuation 46
 
4.0%
Open Punctuation 46
 
4.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
북 67
 
10.7%
광 66
 
10.6%
주 65
 
10.4%
구 64
 
10.2%
로 64
 
10.2%
동 53
 
8.5%
대 22
 
3.5%
하 16
 
2.6%
치 13
 
2.1%
서 13
 
2.1%
Other values (54) 182
29.1%
Decimal Number
ValueCountFrequency (%)
2 28
15.3%
7 23
12.6%
1 22
12.0%
3 19
10.4%
5 18
9.8%
8 17
9.3%
6 15
8.2%
9 15
8.2%
4 14
7.7%
0 12
6.6%
Space Separator
ValueCountFrequency (%)
239
100.0%
Close Punctuation
ValueCountFrequency (%)
) 46
100.0%
Open Punctuation
ValueCountFrequency (%)
( 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 625
54.9%
Common 514
45.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
북 67
 
10.7%
광 66
 
10.6%
주 65
 
10.4%
구 64
 
10.2%
로 64
 
10.2%
동 53
 
8.5%
대 22
 
3.5%
하 16
 
2.6%
치 13
 
2.1%
서 13
 
2.1%
Other values (54) 182
29.1%
Common
ValueCountFrequency (%)
239
46.5%
) 46
 
8.9%
( 46
 
8.9%
2 28
 
5.4%
7 23
 
4.5%
1 22
 
4.3%
3 19
 
3.7%
5 18
 
3.5%
8 17
 
3.3%
6 15
 
2.9%
Other values (3) 41
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 625
54.9%
ASCII 514
45.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
239
46.5%
) 46
 
8.9%
( 46
 
8.9%
2 28
 
5.4%
7 23
 
4.5%
1 22
 
4.3%
3 19
 
3.7%
5 18
 
3.5%
8 17
 
3.3%
6 15
 
2.9%
Other values (3) 41
 
8.0%
Hangul
ValueCountFrequency (%)
북 67
 
10.7%
광 66
 
10.6%
주 65
 
10.4%
구 64
 
10.2%
로 64
 
10.2%
동 53
 
8.5%
대 22
 
3.5%
하 16
 
2.6%
치 13
 
2.1%
서 13
 
2.1%
Other values (54) 182
29.1%

상표
Categorical

Distinct6
Distinct (%)9.4%
Missing0
Missing (%)0.0%
Memory size640.0 B
SK에너지
21 
HD현대오일뱅크
16 
S-OIL
12 
GS칼텍스
11 
알뜰주유소
 
2

Length

Max length8
Median length5
Mean length5.71875
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowHD현대오일뱅크
2nd rowSK에너지
3rd row알뜰주유소
4th rowSK에너지
5th row자가상표

Common Values

ValueCountFrequency (%)
SK에너지 21
32.8%
HD현대오일뱅크 16
25.0%
S-OIL 12
18.8%
GS칼텍스 11
17.2%
알뜰주유소 2
 
3.1%
자가상표 2
 
3.1%

Length

2024-03-15T09:50:50.071695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T09:50:50.468299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
sk에너지 21
32.8%
hd현대오일뱅크 16
25.0%
s-oil 12
18.8%
gs칼텍스 11
17.2%
알뜰주유소 2
 
3.1%
자가상표 2
 
3.1%

전화번호
Text

MISSING 

Distinct63
Distinct (%)100.0%
Missing1
Missing (%)1.6%
Memory size640.0 B
2024-03-15T09:50:51.473415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.015873
Min length12

Characters and Unicode

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

Unique63 ?
Unique (%)100.0%

Sample

1st row062-574-5224
2nd row062-576-5185
3rd row062-266-1181
4th row062-268-1215
5th row062-515-1511
ValueCountFrequency (%)
062-574-5224 1
 
1.6%
062-576-9393 1
 
1.6%
062-511-5106 1
 
1.6%
062-511-5155 1
 
1.6%
062-571-5050 1
 
1.6%
062-266-5185 1
 
1.6%
062-572-9800 1
 
1.6%
062-265-1144 1
 
1.6%
062-267-5145 1
 
1.6%
062-261-2514 1
 
1.6%
Other values (53) 53
84.1%
2024-03-15T09:50:53.566278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 126
16.6%
2 112
14.8%
5 107
14.1%
6 103
13.6%
0 92
12.2%
1 74
9.8%
7 48
 
6.3%
8 38
 
5.0%
9 23
 
3.0%
3 20
 
2.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 631
83.4%
Dash Punctuation 126
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 112
17.7%
5 107
17.0%
6 103
16.3%
0 92
14.6%
1 74
11.7%
7 48
7.6%
8 38
 
6.0%
9 23
 
3.6%
3 20
 
3.2%
4 14
 
2.2%
Dash Punctuation
ValueCountFrequency (%)
- 126
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 757
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 126
16.6%
2 112
14.8%
5 107
14.1%
6 103
13.6%
0 92
12.2%
1 74
9.8%
7 48
 
6.3%
8 38
 
5.0%
9 23
 
3.0%
3 20
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 757
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 126
16.6%
2 112
14.8%
5 107
14.1%
6 103
13.6%
0 92
12.2%
1 74
9.8%
7 48
 
6.3%
8 38
 
5.0%
9 23
 
3.0%
3 20
 
2.6%

Correlations

2024-03-15T09:50:53.837494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호주소상표전화번호
상호1.0001.0001.0001.000
주소1.0001.0001.0001.000
상표1.0001.0001.0001.000
전화번호1.0001.0001.0001.000

Missing values

2024-03-15T09:50:44.213037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T09:50:44.500833image/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용전IC주유소광주 북구 우치로 842 (용전동)HD현대오일뱅크062-574-5224
1행복가득주유소광주 북구 우치로 952(용전동)SK에너지062-576-5185
2(유)착한주유소광주 북구 동문대로 452 (장등동)알뜰주유소062-266-1181
3(주)아승클린주유소광주 북구 우치로 170 (용봉동)SK에너지062-268-1215
4(주)스피드주유소광주 북구 설죽로 226자가상표062-515-1511
5오치한전주유소광주 북구 천지인로 91 (오치동)SK에너지070-8836-5051
6(주)레드카펫주유소광주 북구 용봉로 24 (신안동)SK에너지062-524-7700
7성실주유소광주 북구 우치로 347 (삼각동)SK에너지062-262-6051
8(주)일곡우리주유소광주 북구 우치로 595 (일곡동)HD현대오일뱅크062-268-8951
9용전주유소광주 북구 우치로 809S-OIL062-576-5189
상호주소상표전화번호
54SK에너지 일곡제일주유소광주 북구 설죽로 421 (삼각동)SK에너지062-576-0051
55지에스칼텍스(주)북광주IC주유소광주 북구 삼소로 330 (월출동)GS칼텍스062-574-5153
56SK에너지㈜ 고려셀프주유소광주 북구 설죽로 398 (삼각동)SK에너지062-263-2228
57북성주유소광주 북구 금남로 49 (임동)GS칼텍스062-521-7878
58도동재주유소광주 북구 동문대로 410S-OIL062-251-8536
59일곡주유소광주 북구 우치로422번길 22 (삼각동)S-OIL062-573-6005
60주공주유소광주 북구 북문대로 190 (운암동)GS칼텍스062-514-9988
61SK에너지(주)직영 경기장주유소광주 북구 무등로 76 (임동)SK에너지062-521-8838
62세오(주)직영 미래주유소광주 북구 임방울대로 979 (신용동)SK에너지062-571-7100
63세본주유소광주 북구 용주로 21SK에너지062-526-5818