Overview

Dataset statistics

Number of variables6
Number of observations84
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.1 KiB
Average record size in memory49.6 B

Variable types

Text3
Categorical1
Boolean1
DateTime1

Dataset

Description서산시내 석유판매업소(주유소) 등록현황으로 상호명, 주소, 상표, 전화번호, 셀프여부에 대한 정보를 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=447&beforeMenuCd=DOM_000000201001001000&publicdatapk=3080555

Alerts

데이터기준일자 has constant value ""Constant
상호 has unique valuesUnique
주소 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:55:58.367931
Analysis finished2024-01-09 20:55:59.146384
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

UNIQUE 

Distinct84
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size804.0 B
2024-01-10T05:55:59.270360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17
Mean length7.1428571
Min length5

Characters and Unicode

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

Unique

Unique84 ?
Unique (%)100.0%

Sample

1st row서동알뜰주유소
2nd row애향셀프주유소
3rd row서산IC주유소
4th row김여사네self주유소
5th row착한셀프주유소
ValueCountFrequency (%)
대산 2
 
2.2%
현대오일뱅크㈜직영 2
 
2.2%
현대오일뱅크(주 2
 
2.2%
서동알뜰주유소 1
 
1.1%
죽성주유소 1
 
1.1%
만석에너지 1
 
1.1%
신성주유소 1
 
1.1%
광천주유소 1
 
1.1%
잠홍셀프주유소 1
 
1.1%
동주오일뱅크 1
 
1.1%
Other values (79) 79
85.9%
2024-01-10T05:55:59.562667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 87
 
14.5%
소 82
 
13.7%
유 78
 
13.0%
산 19
 
3.2%
서 15
 
2.5%
대 15
 
2.5%
( 11
 
1.8%
) 11
 
1.8%
협 10
 
1.7%
농 10
 
1.7%
Other values (138) 262
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 551
91.8%
Open Punctuation 11
 
1.8%
Close Punctuation 11
 
1.8%
Space Separator 8
 
1.3%
Uppercase Letter 6
 
1.0%
Other Symbol 4
 
0.7%
Other Punctuation 4
 
0.7%
Lowercase Letter 4
 
0.7%
Decimal Number 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 87
 
15.8%
소 82
 
14.9%
유 78
 
14.2%
산 19
 
3.4%
서 15
 
2.7%
대 15
 
2.7%
협 10
 
1.8%
농 10
 
1.8%
현 8
 
1.5%
오 8
 
1.5%
Other values (123) 219
39.7%
Uppercase Letter
ValueCountFrequency (%)
I 2
33.3%
C 2
33.3%
K 1
16.7%
S 1
16.7%
Lowercase Letter
ValueCountFrequency (%)
s 1
25.0%
e 1
25.0%
l 1
25.0%
f 1
25.0%
Other Punctuation
ValueCountFrequency (%)
/ 3
75.0%
. 1
 
25.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 555
92.5%
Common 35
 
5.8%
Latin 10
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 87
 
15.7%
소 82
 
14.8%
유 78
 
14.1%
산 19
 
3.4%
서 15
 
2.7%
대 15
 
2.7%
협 10
 
1.8%
농 10
 
1.8%
현 8
 
1.4%
오 8
 
1.4%
Other values (124) 223
40.2%
Latin
ValueCountFrequency (%)
I 2
20.0%
C 2
20.0%
K 1
10.0%
S 1
10.0%
s 1
10.0%
e 1
10.0%
l 1
10.0%
f 1
10.0%
Common
ValueCountFrequency (%)
( 11
31.4%
) 11
31.4%
8
22.9%
/ 3
 
8.6%
2 1
 
2.9%
. 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 551
91.8%
ASCII 45
 
7.5%
None 4
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 87
 
15.8%
소 82
 
14.9%
유 78
 
14.2%
산 19
 
3.4%
서 15
 
2.7%
대 15
 
2.7%
협 10
 
1.8%
농 10
 
1.8%
현 8
 
1.5%
오 8
 
1.5%
Other values (123) 219
39.7%
ASCII
ValueCountFrequency (%)
( 11
24.4%
) 11
24.4%
8
17.8%
/ 3
 
6.7%
I 2
 
4.4%
C 2
 
4.4%
K 1
 
2.2%
S 1
 
2.2%
2 1
 
2.2%
s 1
 
2.2%
Other values (4) 4
 
8.9%
None
ValueCountFrequency (%)
㈜ 4
100.0%

주소
Text

UNIQUE 

Distinct84
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size804.0 B
2024-01-10T05:55:59.842811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length19.333333
Min length14

Characters and Unicode

Total characters1624
Distinct characters95
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

Unique84 ?
Unique (%)100.0%

Sample

1st row충남 서산시 고운로 320
2nd row충남 서산시 고운로 254 (동문동)
3rd row충남 서산시 음암면 서해로 4020
4th row충남 서산시 음암면 서해로 4019
5th row충남 서산시 음암면 서해로 3837
ValueCountFrequency (%)
서산시 84
20.1%
충남 79
18.9%
충의로 15
 
3.6%
서해로 15
 
3.6%
음암면 14
 
3.4%
대산읍 10
 
2.4%
운암로 8
 
1.9%
해미면 7
 
1.7%
지곡면 6
 
1.4%
무학로 5
 
1.2%
Other values (129) 174
41.7%
2024-01-10T05:56:00.295059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
334
20.6%
서 103
 
6.3%
산 102
 
6.3%
충 99
 
6.1%
남 87
 
5.4%
시 84
 
5.2%
로 80
 
4.9%
1 53
 
3.3%
면 51
 
3.1%
2 40
 
2.5%
Other values (85) 591
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 947
58.3%
Space Separator 334
 
20.6%
Decimal Number 299
 
18.4%
Close Punctuation 20
 
1.2%
Open Punctuation 20
 
1.2%
Dash Punctuation 4
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 103
 
10.9%
산 102
 
10.8%
충 99
 
10.5%
남 87
 
9.2%
시 84
 
8.9%
로 80
 
8.4%
면 51
 
5.4%
해 25
 
2.6%
동 23
 
2.4%
암 22
 
2.3%
Other values (71) 271
28.6%
Decimal Number
ValueCountFrequency (%)
1 53
17.7%
2 40
13.4%
0 39
13.0%
4 33
11.0%
3 29
9.7%
8 25
8.4%
9 25
8.4%
6 20
 
6.7%
5 19
 
6.4%
7 16
 
5.4%
Space Separator
ValueCountFrequency (%)
334
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 947
58.3%
Common 677
41.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 103
 
10.9%
산 102
 
10.8%
충 99
 
10.5%
남 87
 
9.2%
시 84
 
8.9%
로 80
 
8.4%
면 51
 
5.4%
해 25
 
2.6%
동 23
 
2.4%
암 22
 
2.3%
Other values (71) 271
28.6%
Common
ValueCountFrequency (%)
334
49.3%
1 53
 
7.8%
2 40
 
5.9%
0 39
 
5.8%
4 33
 
4.9%
3 29
 
4.3%
8 25
 
3.7%
9 25
 
3.7%
6 20
 
3.0%
) 20
 
3.0%
Other values (4) 59
 
8.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 947
58.3%
ASCII 677
41.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
334
49.3%
1 53
 
7.8%
2 40
 
5.9%
0 39
 
5.8%
4 33
 
4.9%
3 29
 
4.3%
8 25
 
3.7%
9 25
 
3.7%
6 20
 
3.0%
) 20
 
3.0%
Other values (4) 59
 
8.7%
Hangul
ValueCountFrequency (%)
서 103
 
10.9%
산 102
 
10.8%
충 99
 
10.5%
남 87
 
9.2%
시 84
 
8.9%
로 80
 
8.4%
면 51
 
5.4%
해 25
 
2.6%
동 23
 
2.4%
암 22
 
2.3%
Other values (71) 271
28.6%

상표
Categorical

Distinct7
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size804.0 B
현대오일뱅크
37 
SK에너지
14 
GS칼텍스
11 
S-OIL
10 
NH-OIL
7 
Other values (2)
5 

Length

Max length6
Median length6
Mean length5.547619
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row알뜰주유소
2nd rowSK에너지
3rd row현대오일뱅크
4th rowS-OIL
5th rowSK에너지

Common Values

ValueCountFrequency (%)
현대오일뱅크 37
44.0%
SK에너지 14
 
16.7%
GS칼텍스 11
 
13.1%
S-OIL 10
 
11.9%
NH-OIL 7
 
8.3%
알뜰주유소 3
 
3.6%
알뜰(ex) 2
 
2.4%

Length

2024-01-10T05:56:00.420383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:56:00.528651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
현대오일뱅크 37
44.0%
sk에너지 14
 
16.7%
gs칼텍스 11
 
13.1%
s-oil 10
 
11.9%
nh-oil 7
 
8.3%
알뜰주유소 3
 
3.6%
알뜰(ex 2
 
2.4%

전화번호
Text

UNIQUE 

Distinct84
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size804.0 B
2024-01-10T05:56:00.764119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique84 ?
Unique (%)100.0%

Sample

1st row041-665-5839
2nd row041-666-6655
3rd row041-664-5191
4th row041-669-5189
5th row041-662-0347
ValueCountFrequency (%)
041-665-5839 1
 
1.2%
041-688-5381 1
 
1.2%
041-664-2213 1
 
1.2%
041-664-4170 1
 
1.2%
041-665-2526 1
 
1.2%
041-663-5156 1
 
1.2%
041-664-0073 1
 
1.2%
041-669-2877 1
 
1.2%
041-666-1787 1
 
1.2%
041-669-3319 1
 
1.2%
Other values (74) 74
88.1%
2024-01-10T05:56:01.092612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 190
18.8%
- 168
16.7%
1 148
14.7%
0 129
12.8%
4 123
12.2%
5 58
 
5.8%
8 56
 
5.6%
3 41
 
4.1%
2 36
 
3.6%
7 30
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 840
83.3%
Dash Punctuation 168
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 190
22.6%
1 148
17.6%
0 129
15.4%
4 123
14.6%
5 58
 
6.9%
8 56
 
6.7%
3 41
 
4.9%
2 36
 
4.3%
7 30
 
3.6%
9 29
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 168
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1008
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 190
18.8%
- 168
16.7%
1 148
14.7%
0 129
12.8%
4 123
12.2%
5 58
 
5.8%
8 56
 
5.6%
3 41
 
4.1%
2 36
 
3.6%
7 30
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1008
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 190
18.8%
- 168
16.7%
1 148
14.7%
0 129
12.8%
4 123
12.2%
5 58
 
5.8%
8 56
 
5.6%
3 41
 
4.1%
2 36
 
3.6%
7 30
 
3.0%

셀프여부
Boolean

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size216.0 B
False
60 
True
24 
ValueCountFrequency (%)
False 60
71.4%
True 24
 
28.6%
2024-01-10T05:56:01.205295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size804.0 B
Minimum2021-09-29 00:00:00
Maximum2021-09-29 00:00:00
2024-01-10T05:56:01.282519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:56:01.364282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T05:56:01.428805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호주소상표전화번호셀프여부
상호1.0001.0001.0001.0001.000
주소1.0001.0001.0001.0001.000
상표1.0001.0001.0001.0000.155
전화번호1.0001.0001.0001.0001.000
셀프여부1.0001.0000.1551.0001.000
2024-01-10T05:56:01.514238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상표셀프여부
상표1.0000.158
셀프여부0.1581.000
2024-01-10T05:56:01.585751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상표셀프여부
상표1.0000.158
셀프여부0.1581.000

Missing values

2024-01-10T05:55:59.021881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:55:59.109786image/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서동알뜰주유소충남 서산시 고운로 320알뜰주유소041-665-5839Y2021-09-29
1애향셀프주유소충남 서산시 고운로 254 (동문동)SK에너지041-666-6655Y2021-09-29
2서산IC주유소충남 서산시 음암면 서해로 4020현대오일뱅크041-664-5191Y2021-09-29
3김여사네self주유소충남 서산시 음암면 서해로 4019S-OIL041-669-5189Y2021-09-29
4착한셀프주유소충남 서산시 음암면 서해로 3837SK에너지041-662-0347Y2021-09-29
5해미 I.C 주유소충남 서산시 해미면 중앙로 1142SK에너지041-688-5105Y2021-09-29
6서창셀프주유소충남 서산시 안견로 255 (동문동)현대오일뱅크041-665-5241Y2021-09-29
7이레주유소충남 서산시 팔봉면 서해로 2294GS칼텍스041-662-6897Y2021-09-29
8하이웨이주유소충남 서산시 음암면 서해로 3986GS칼텍스041-663-8636Y2021-09-29
9서산자연주유소충남 서산시 소탐2길 17-8 (수석동)GS칼텍스041-668-0101Y2021-09-29
상호주소상표전화번호셀프여부데이터기준일자
74현대오일뱅크(주) 황금산주유소충남 서산시 대산읍 독곶1로 46현대오일뱅크041-681-3280N2021-09-29
75해미읍성주유소충남 서산시 해미면 남문1로 7S-OIL041-688-6770N2021-09-29
76서산인삼농협주유소충남 서산시 중앙로 520현대오일뱅크041-668-0606N2021-09-29
77어송주유소충남 서산시 팔봉면 어송1길 237GS칼텍스041-664-2020N2021-09-29
78(주)SK대기주유소충남 서산시 대산읍 명지1로 154SK에너지041-669-0830N2021-09-29
79(주)유니주유소/충전소충남 서산시 서해로 3621 (잠홍동)GS칼텍스041-668-5182N2021-09-29
80바위주유소충남 서산시 해미면 남문2로 84현대오일뱅크041-688-2514N2021-09-29
81오성주유소충남 서산시 중앙로 120 (석림동)S-OIL041-669-6688N2021-09-29
82석림주유소충남 서산시 한마음10로 26 (석림동)현대오일뱅크041-665-1018N2021-09-29
83늘푸른주유소충남 서산시 문화로 58 (읍내동)GS칼텍스041-669-8951N2021-09-29