Overview

Dataset statistics

Number of variables4
Number of observations73
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.4 KiB
Average record size in memory33.8 B

Variable types

Categorical1
Text2
DateTime1

Dataset

Description. 대전광역시 대덕구에 등록·신고된 석유판매업현황에 대한 데이터로, 업소의 상호명과 주소 등에 대한 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15035774/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
상호명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:01:08.084721
Analysis finished2023-12-12 06:01:08.518849
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct2
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size716.0 B
주유소
59 
일반판매소
14 

Length

Max length5
Median length3
Mean length3.3835616
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
주유소 59
80.8%
일반판매소 14
 
19.2%

Length

2023-12-12T15:01:08.621159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:01:08.746500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 59
80.8%
일반판매소 14
 
19.2%

상호명
Text

UNIQUE 

Distinct73
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size716.0 B
2023-12-12T15:01:08.981597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length8.1917808
Min length4

Characters and Unicode

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

Unique

Unique73 ?
Unique (%)100.0%

Sample

1st row중도석유㈜오정동주유소
2nd row공단주유소
3rd row으뜸회덕주유소
4th row지에스칼텍스㈜톨게이트주유소
5th row현대오일뱅크㈜ 직영 대원셀프주유소
ValueCountFrequency (%)
직영 4
 
4.2%
현대오일뱅크㈜ 3
 
3.1%
㈜연정 2
 
2.1%
일등주유소 2
 
2.1%
주유소 2
 
2.1%
㈜sh에너지 2
 
2.1%
중도석유㈜오정동주유소 1
 
1.0%
sk주홍셀프주유소 1
 
1.0%
㈜학하 1
 
1.0%
개나리주유소 1
 
1.0%
Other values (77) 77
80.2%
2023-12-12T15:01:09.460414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
유 72
 
12.0%
소 63
 
10.5%
주 61
 
10.2%
23
 
3.8%
㈜ 22
 
3.7%
대 15
 
2.5%
에 15
 
2.5%
일 12
 
2.0%
지 11
 
1.8%
석 11
 
1.8%
Other values (126) 293
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 538
90.0%
Space Separator 23
 
3.8%
Other Symbol 22
 
3.7%
Uppercase Letter 12
 
2.0%
Decimal Number 1
 
0.2%
Open Punctuation 1
 
0.2%
Close Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 72
 
13.4%
소 63
 
11.7%
주 61
 
11.3%
대 15
 
2.8%
에 15
 
2.8%
일 12
 
2.2%
지 11
 
2.0%
석 11
 
2.0%
영 8
 
1.5%
너 8
 
1.5%
Other values (115) 262
48.7%
Uppercase Letter
ValueCountFrequency (%)
S 3
25.0%
I 2
16.7%
C 2
16.7%
H 2
16.7%
K 2
16.7%
O 1
 
8.3%
Space Separator
ValueCountFrequency (%)
23
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 22
100.0%
Decimal Number
ValueCountFrequency (%)
4 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 560
93.6%
Common 26
 
4.3%
Latin 12
 
2.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 72
 
12.9%
소 63
 
11.2%
주 61
 
10.9%
㈜ 22
 
3.9%
대 15
 
2.7%
에 15
 
2.7%
일 12
 
2.1%
지 11
 
2.0%
석 11
 
2.0%
영 8
 
1.4%
Other values (116) 270
48.2%
Latin
ValueCountFrequency (%)
S 3
25.0%
I 2
16.7%
C 2
16.7%
H 2
16.7%
K 2
16.7%
O 1
 
8.3%
Common
ValueCountFrequency (%)
23
88.5%
4 1
 
3.8%
( 1
 
3.8%
) 1
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 538
90.0%
ASCII 38
 
6.4%
None 22
 
3.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
유 72
 
13.4%
소 63
 
11.7%
주 61
 
11.3%
대 15
 
2.8%
에 15
 
2.8%
일 12
 
2.2%
지 11
 
2.0%
석 11
 
2.0%
영 8
 
1.5%
너 8
 
1.5%
Other values (115) 262
48.7%
ASCII
ValueCountFrequency (%)
23
60.5%
S 3
 
7.9%
I 2
 
5.3%
C 2
 
5.3%
H 2
 
5.3%
K 2
 
5.3%
4 1
 
2.6%
( 1
 
2.6%
) 1
 
2.6%
O 1
 
2.6%
None
ValueCountFrequency (%)
㈜ 22
100.0%

소재지도로명주소
Text

UNIQUE 

Distinct73
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size716.0 B
2023-12-12T15:01:09.824494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length29
Mean length24.849315
Min length22

Characters and Unicode

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

Unique

Unique73 ?
Unique (%)100.0%

Sample

1st row대전광역시 대덕구 대전로 1144 (오정동)
2nd row대전광역시 대덕구 대전로 1285 (대화동)
3rd row대전광역시 대덕구 신탄진로 222 (와동)
4th row대전광역시 대덕구 동서대로 1762 (비래동)
5th row대전광역시 대덕구 동서대로 1772 (비래동)
ValueCountFrequency (%)
대전광역시 73
20.8%
대덕구 73
20.8%
신탄진로 18
 
5.1%
읍내동 10
 
2.8%
오정동 8
 
2.3%
상서동 8
 
2.3%
한밭대로 7
 
2.0%
동서대로 6
 
1.7%
대전로 6
 
1.7%
아리랑로 6
 
1.7%
Other values (109) 136
38.7%
2023-12-12T15:01:10.302932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
278
 
15.3%
대 184
 
10.1%
덕 83
 
4.6%
동 82
 
4.5%
전 81
 
4.5%
시 74
 
4.1%
( 73
 
4.0%
) 73
 
4.0%
광 73
 
4.0%
구 73
 
4.0%
Other values (56) 740
40.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1120
61.7%
Space Separator 278
 
15.3%
Decimal Number 268
 
14.8%
Open Punctuation 73
 
4.0%
Close Punctuation 73
 
4.0%
Other Punctuation 1
 
0.1%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 184
16.4%
덕 83
 
7.4%
동 82
 
7.3%
전 81
 
7.2%
시 74
 
6.6%
광 73
 
6.5%
구 73
 
6.5%
역 73
 
6.5%
로 71
 
6.3%
신 33
 
2.9%
Other values (41) 293
26.2%
Decimal Number
ValueCountFrequency (%)
1 62
23.1%
5 29
10.8%
3 28
10.4%
7 27
10.1%
0 26
9.7%
6 25
9.3%
2 24
 
9.0%
8 18
 
6.7%
4 17
 
6.3%
9 12
 
4.5%
Space Separator
ValueCountFrequency (%)
278
100.0%
Open Punctuation
ValueCountFrequency (%)
( 73
100.0%
Close Punctuation
ValueCountFrequency (%)
) 73
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1120
61.7%
Common 694
38.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 184
16.4%
덕 83
 
7.4%
동 82
 
7.3%
전 81
 
7.2%
시 74
 
6.6%
광 73
 
6.5%
구 73
 
6.5%
역 73
 
6.5%
로 71
 
6.3%
신 33
 
2.9%
Other values (41) 293
26.2%
Common
ValueCountFrequency (%)
278
40.1%
( 73
 
10.5%
) 73
 
10.5%
1 62
 
8.9%
5 29
 
4.2%
3 28
 
4.0%
7 27
 
3.9%
0 26
 
3.7%
6 25
 
3.6%
2 24
 
3.5%
Other values (5) 49
 
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1120
61.7%
ASCII 694
38.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
278
40.1%
( 73
 
10.5%
) 73
 
10.5%
1 62
 
8.9%
5 29
 
4.2%
3 28
 
4.0%
7 27
 
3.9%
0 26
 
3.7%
6 25
 
3.6%
2 24
 
3.5%
Other values (5) 49
 
7.1%
Hangul
ValueCountFrequency (%)
대 184
16.4%
덕 83
 
7.4%
동 82
 
7.3%
전 81
 
7.2%
시 74
 
6.6%
광 73
 
6.5%
구 73
 
6.5%
역 73
 
6.5%
로 71
 
6.3%
신 33
 
2.9%
Other values (41) 293
26.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size716.0 B
Minimum2023-06-08 00:00:00
Maximum2023-06-08 00:00:00
2023-12-12T15:01:10.463008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:01:10.568124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T15:01:10.645524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분상호명소재지도로명주소
구분1.0001.0001.000
상호명1.0001.0001.000
소재지도로명주소1.0001.0001.000

Missing values

2023-12-12T15:01:08.360658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:01:08.474800image/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주유소중도석유㈜오정동주유소대전광역시 대덕구 대전로 1144 (오정동)2023-06-08
1주유소공단주유소대전광역시 대덕구 대전로 1285 (대화동)2023-06-08
2주유소으뜸회덕주유소대전광역시 대덕구 신탄진로 222 (와동)2023-06-08
3주유소지에스칼텍스㈜톨게이트주유소대전광역시 대덕구 동서대로 1762 (비래동)2023-06-08
4주유소현대오일뱅크㈜ 직영 대원셀프주유소대전광역시 대덕구 동서대로 1772 (비래동)2023-06-08
5주유소쌍용주유소대전광역시 대덕구 신탄진로 83 (연축동)2023-06-08
6주유소덕암셀프주유소대전광역시 대덕구 덕암로 219 (덕암동)2023-06-08
7주유소신탄진농협 주유소대전광역시 대덕구 덕암로 164 (평촌동)2023-06-08
8주유소대림석유㈜직영 신탄진주유소대전광역시 대덕구 신탄진로681번길 22 (덕암동)2023-06-08
9주유소직영 대덕주유소대전광역시 대덕구 신탄진로 470 (상서동)2023-06-08
구분상호명소재지도로명주소데이터기준일자
63일반판매소신광에너지대전광역시 대덕구 중리남로40번길 63(중리동)2023-06-08
64일반판매소동양에너지대전광역시 대덕구 비래동로7번길 58(비래동)2023-06-08
65일반판매소제일석유판매소대전광역시 대덕구 덕암로203번길 19(덕암동)2023-06-08
66일반판매소평화석유대전광역시 대덕구 오정로63번길 78-11(오정동)2023-06-08
67일반판매소조은석유대전광역시 대덕구 대전로1033번길 63(오정동)2023-06-08
68일반판매소공짱에너지대전광역시 대덕구 한밭대로1006번길 34(오정동)2023-06-08
69일반판매소대왕석유대전광역시 대덕구 대화9길 54(대화동)2023-06-08
70일반판매소은진석유대전광역시 대덕구 새말1길 31(상서동)2023-06-08
71일반판매소남경에너지대전광역시 대덕구 신탄진로738번길 5(신탄진동)2023-06-08
72일반판매소직영에너지대전광역시 대덕구 대전로1066번길 57(오정동)2023-06-08