Overview

Dataset statistics

Number of variables4
Number of observations37
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory35.6 B

Variable types

Text3
Categorical1

Dataset

Description광주광역시 서구의 관내에 위치하고 있는 유류판매업소(주유소)에 대한 상호명, 도로명주소, 연락처 등에 대한 정보 현황입니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15011783/fileData.do

Alerts

사업구분 is highly imbalanced (59.4%)Imbalance
상호명 has unique valuesUnique
주소 has unique valuesUnique
연락처 has unique valuesUnique

Reproduction

Analysis started2023-12-23 07:42:25.699227
Analysis finished2023-12-23 07:42:28.143683
Duration2.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-23T07:42:28.673656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length15
Mean length7.5405405
Min length4

Characters and Unicode

Total characters279
Distinct characters90
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

Unique37 ?
Unique (%)100.0%

Sample

1st row(유)매월주유소
2nd row(유)신상무주유소
3rd row(주)대원 강변주유소
4th row(주)대창석유직영 염주주유소
5th row(주)아프리카주유소
ValueCountFrequency (%)
유)매월주유소 1
 
2.3%
주유소 1
 
2.3%
영광주유소 1
 
2.3%
예향주유소 1
 
2.3%
우리셀프주유소 1
 
2.3%
운천주유소 1
 
2.3%
㈜대양케미칼 1
 
2.3%
대양서광주주유소 1
 
2.3%
청우주유소 1
 
2.3%
청정이엔지(주 1
 
2.3%
Other values (33) 33
76.7%
2023-12-23T07:42:30.969586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
유 41
 
14.7%
주 41
 
14.7%
소 33
 
11.8%
대 9
 
3.2%
( 8
 
2.9%
) 8
 
2.9%
8
 
2.9%
석 5
 
1.8%
일 4
 
1.4%
광 4
 
1.4%
Other values (80) 118
42.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 249
89.2%
Open Punctuation 8
 
2.9%
Close Punctuation 8
 
2.9%
Space Separator 8
 
2.9%
Uppercase Letter 4
 
1.4%
Other Symbol 2
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 41
16.5%
주 41
16.5%
소 33
 
13.3%
대 9
 
3.6%
석 5
 
2.0%
일 4
 
1.6%
광 4
 
1.6%
서 4
 
1.6%
동 3
 
1.2%
청 3
 
1.2%
Other values (74) 102
41.0%
Uppercase Letter
ValueCountFrequency (%)
K 2
50.0%
S 2
50.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 251
90.0%
Common 24
 
8.6%
Latin 4
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 41
 
16.3%
주 41
 
16.3%
소 33
 
13.1%
대 9
 
3.6%
석 5
 
2.0%
일 4
 
1.6%
광 4
 
1.6%
서 4
 
1.6%
동 3
 
1.2%
청 3
 
1.2%
Other values (75) 104
41.4%
Common
ValueCountFrequency (%)
( 8
33.3%
) 8
33.3%
8
33.3%
Latin
ValueCountFrequency (%)
K 2
50.0%
S 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 249
89.2%
ASCII 28
 
10.0%
None 2
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
유 41
16.5%
주 41
16.5%
소 33
 
13.3%
대 9
 
3.6%
석 5
 
2.0%
일 4
 
1.6%
광 4
 
1.6%
서 4
 
1.6%
동 3
 
1.2%
청 3
 
1.2%
Other values (74) 102
41.0%
ASCII
ValueCountFrequency (%)
( 8
28.6%
) 8
28.6%
8
28.6%
K 2
 
7.1%
S 2
 
7.1%
None
ValueCountFrequency (%)
㈜ 2
100.0%

사업구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size428.0 B
주유소
34 
일반판매소
 
3

Length

Max length5
Median length3
Mean length3.1621622
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주유소
2nd row주유소
3rd row주유소
4th row주유소
5th row주유소

Common Values

ValueCountFrequency (%)
주유소 34
91.9%
일반판매소 3
 
8.1%

Length

2023-12-23T07:42:31.554321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:42:32.008745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 34
91.9%
일반판매소 3
 
8.1%

주소
Text

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-23T07:42:33.013131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length21.081081
Min length16

Characters and Unicode

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

Unique

Unique37 ?
Unique (%)100.0%

Sample

1st row광주광역시 서구 회재로 845
2nd row광주광역시 서구 운천로 170 (쌍촌동)
3rd row광주광역시 서구 천변좌하로 142 (치평동)
4th row광주광역시 서구 월드컵4강로 120 (화정동)
5th row광주광역시 서구 천변좌하로 168(치평동)
ValueCountFrequency (%)
광주광역시 37
24.0%
서구 37
24.0%
회재로 6
 
3.9%
상무대로 6
 
3.9%
천변좌하로 3
 
1.9%
풍서우로 3
 
1.9%
풍서좌로 2
 
1.3%
내방로 2
 
1.3%
운천로 2
 
1.3%
쌍촌동 2
 
1.3%
Other values (54) 54
35.1%
2023-12-23T07:42:34.357064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
117
 
15.0%
광 76
 
9.7%
서 44
 
5.6%
역 37
 
4.7%
시 37
 
4.7%
구 37
 
4.7%
주 37
 
4.7%
로 36
 
4.6%
동 32
 
4.1%
( 31
 
4.0%
Other values (62) 296
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 494
63.3%
Space Separator 117
 
15.0%
Decimal Number 106
 
13.6%
Open Punctuation 31
 
4.0%
Close Punctuation 31
 
4.0%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 76
15.4%
서 44
 
8.9%
역 37
 
7.5%
시 37
 
7.5%
구 37
 
7.5%
주 37
 
7.5%
로 36
 
7.3%
동 32
 
6.5%
천 9
 
1.8%
대 9
 
1.8%
Other values (48) 140
28.3%
Decimal Number
ValueCountFrequency (%)
1 17
16.0%
2 15
14.2%
4 13
12.3%
6 12
11.3%
8 12
11.3%
5 9
8.5%
0 9
8.5%
7 8
7.5%
3 7
6.6%
9 4
 
3.8%
Space Separator
ValueCountFrequency (%)
117
100.0%
Open Punctuation
ValueCountFrequency (%)
( 31
100.0%
Close Punctuation
ValueCountFrequency (%)
) 31
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 494
63.3%
Common 286
36.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 76
15.4%
서 44
 
8.9%
역 37
 
7.5%
시 37
 
7.5%
구 37
 
7.5%
주 37
 
7.5%
로 36
 
7.3%
동 32
 
6.5%
천 9
 
1.8%
대 9
 
1.8%
Other values (48) 140
28.3%
Common
ValueCountFrequency (%)
117
40.9%
( 31
 
10.8%
) 31
 
10.8%
1 17
 
5.9%
2 15
 
5.2%
4 13
 
4.5%
6 12
 
4.2%
8 12
 
4.2%
5 9
 
3.1%
0 9
 
3.1%
Other values (4) 20
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 494
63.3%
ASCII 286
36.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
117
40.9%
( 31
 
10.8%
) 31
 
10.8%
1 17
 
5.9%
2 15
 
5.2%
4 13
 
4.5%
6 12
 
4.2%
8 12
 
4.2%
5 9
 
3.1%
0 9
 
3.1%
Other values (4) 20
 
7.0%
Hangul
ValueCountFrequency (%)
광 76
15.4%
서 44
 
8.9%
역 37
 
7.5%
시 37
 
7.5%
구 37
 
7.5%
주 37
 
7.5%
로 36
 
7.3%
동 32
 
6.5%
천 9
 
1.8%
대 9
 
1.8%
Other values (48) 140
28.3%

연락처
Text

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-23T07:42:35.257459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length12
Mean length12.405405
Min length12

Characters and Unicode

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

Unique

Unique37 ?
Unique (%)100.0%

Sample

1st row062-682-2359
2nd row062-384-5185
3rd row062-941-7319
4th row062-376-5151
5th row062-381-5151
ValueCountFrequency (%)
062-682-2359 1
 
2.6%
1
 
2.6%
062-671-5151 1
 
2.6%
062-655-7728 1
 
2.6%
062-361-4505 1
 
2.6%
062-383-5182 1
 
2.6%
062-655-1500 1
 
2.6%
062-655-5189 1
 
2.6%
062-382-5503 1
 
2.6%
062-371-7319 1
 
2.6%
Other values (29) 29
74.4%
2023-12-23T07:42:37.131255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 76
16.6%
2 60
13.1%
6 56
12.2%
0 52
11.3%
5 48
10.5%
1 41
8.9%
3 38
8.3%
8 28
 
6.1%
7 28
 
6.1%
9 15
 
3.3%
Other values (3) 17
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 380
82.8%
Dash Punctuation 76
 
16.6%
Space Separator 2
 
0.4%
Math Symbol 1
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 60
15.8%
6 56
14.7%
0 52
13.7%
5 48
12.6%
1 41
10.8%
3 38
10.0%
8 28
7.4%
7 28
7.4%
9 15
 
3.9%
4 14
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 76
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 459
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 76
16.6%
2 60
13.1%
6 56
12.2%
0 52
11.3%
5 48
10.5%
1 41
8.9%
3 38
8.3%
8 28
 
6.1%
7 28
 
6.1%
9 15
 
3.3%
Other values (3) 17
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 459
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 76
16.6%
2 60
13.1%
6 56
12.2%
0 52
11.3%
5 48
10.5%
1 41
8.9%
3 38
8.3%
8 28
 
6.1%
7 28
 
6.1%
9 15
 
3.3%
Other values (3) 17
 
3.7%

Correlations

2023-12-23T07:42:37.468751image/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

2023-12-23T07:42:27.284618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-23T07:42:27.686635image/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(유)매월주유소주유소광주광역시 서구 회재로 845062-682-2359
1(유)신상무주유소주유소광주광역시 서구 운천로 170 (쌍촌동)062-384-5185
2(주)대원 강변주유소주유소광주광역시 서구 천변좌하로 142 (치평동)062-941-7319
3(주)대창석유직영 염주주유소주유소광주광역시 서구 월드컵4강로 120 (화정동)062-376-5151
4(주)아프리카주유소주유소광주광역시 서구 천변좌하로 168(치평동)062-381-5151
5(주)일프로주유소주유소광주광역시 서구 운천로 206(치평동)062-383-4007
6가람주유소주유소광주광역시 서구 상무대로1206번길 3(농성동)062-365-5189
7대광주유소주유소광주광역시 서구 하남대로 556(동천동)062-512-0022
8대동에너지주유소주유소광주광역시 서구 회재로 783062-674-2700
9돌고개주유소주유소광주광역시 서구 경열로 54(농성동)062-368-5557
상호명사업구분주소연락처
27청우주유소주유소광주광역시 서구 회재로 807(매월동)062-655-5189
28청정이엔지(주) 주유소주유소광주광역시 서구 상무자유로 18(치평동)062-382-5503 + 062-371-7319
29치평주유소주유소광주광역시 서구 내방로 11(치평동)062-381-5152
30컨벤션주유소주유소광주광역시 서구 상무대로 714062-382-5188
31풍암대림주유소주유소광주광역시 서구 풍서좌로 83(매월동)062-655-2211
32한강주유소주유소광주광역시 서구 천변좌로 6(광천동)062-369-3167
33에이치디 현대오일뱅크㈜직영 공항가는길주유소주유소광주광역시 서구 상무대로 699(마륵동)062-372-5189
34SK신안석유일반판매소광주광역시 서구 칠성로 141 (광천동)062-383-1788
35동화석유일반판매소광주광역시 서구 쌍촌로47번길 22 (쌍촌동)062-372-0997
36대성석유일반판매소광주광역시 서구 화개길 24-3 (매월동)062-374-6625