Overview

Dataset statistics

Number of variables22
Number of observations31
Missing cells537
Missing cells (%)78.7%
Duplicate rows1
Duplicate rows (%)3.2%
Total size in memory6.0 KiB
Average record size in memory198.3 B

Variable types

Categorical4
Numeric1
Unsupported17

Dataset

Description계룡시 관내 석유판매업소 현황에 대한 데이터로서, 면동별, 상호, 주소, 유종, 유량에 관한 공공데이터를 제공합니다.
Author충청남도 계룡시
URLhttps://www.data.go.kr/data/15093898/fileData.do

Alerts

Dataset has 1 (3.2%) duplicate rowsDuplicates
유량 has 10 (32.3%) missing valuesMissing
Unnamed: 5 has 31 (100.0%) missing valuesMissing
Unnamed: 6 has 31 (100.0%) missing valuesMissing
Unnamed: 7 has 31 (100.0%) missing valuesMissing
Unnamed: 8 has 31 (100.0%) missing valuesMissing
Unnamed: 9 has 31 (100.0%) missing valuesMissing
Unnamed: 10 has 31 (100.0%) missing valuesMissing
Unnamed: 11 has 31 (100.0%) missing valuesMissing
Unnamed: 12 has 31 (100.0%) missing valuesMissing
Unnamed: 13 has 31 (100.0%) missing valuesMissing
Unnamed: 14 has 31 (100.0%) missing valuesMissing
Unnamed: 15 has 31 (100.0%) missing valuesMissing
Unnamed: 16 has 31 (100.0%) missing valuesMissing
Unnamed: 17 has 31 (100.0%) missing valuesMissing
Unnamed: 18 has 31 (100.0%) missing valuesMissing
Unnamed: 19 has 31 (100.0%) missing valuesMissing
Unnamed: 20 has 31 (100.0%) missing valuesMissing
Unnamed: 21 has 31 (100.0%) missing valuesMissing
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 12:51:47.821299
Analysis finished2023-12-12 12:51:47.984314
Duration0.16 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct3
Distinct (%)9.7%
Missing0
Missing (%)0.0%
Memory size380.0 B
주유소
19 
<NA>
10 
일반판매소
2 

Length

Max length5
Median length3
Mean length3.4516129
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
주유소 19
61.3%
<NA> 10
32.3%
일반판매소 2
 
6.5%

Length

2023-12-12T21:51:48.088786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:51:48.222092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 19
61.3%
na 10
32.3%
일반판매소 2
 
6.5%

상호
Categorical

Distinct8
Distinct (%)25.8%
Missing0
Missing (%)0.0%
Memory size380.0 B
<NA>
10 
sk에너지(주)신도시주유소
4 
참좋은셀프주유소
4 
(재)우체국물류지원단주유소
3 
두마주유소
3 
Other values (3)
7 

Length

Max length14
Median length10
Mean length7.4193548
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row(재)우체국물류지원단주유소
2nd row(재)우체국물류지원단주유소
3rd row(재)우체국물류지원단주유소
4th row대운주유소(계룡대)
5th row대운주유소(계룡대)

Common Values

ValueCountFrequency (%)
<NA> 10
32.3%
sk에너지(주)신도시주유소 4
 
12.9%
참좋은셀프주유소 4
 
12.9%
(재)우체국물류지원단주유소 3
 
9.7%
두마주유소 3
 
9.7%
양정주유소 3
 
9.7%
대운주유소(계룡대) 2
 
6.5%
한빛에너지 2
 
6.5%

Length

2023-12-12T21:51:48.364520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:51:48.512309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 10
32.3%
sk에너지(주)신도시주유소 4
 
12.9%
참좋은셀프주유소 4
 
12.9%
재)우체국물류지원단주유소 3
 
9.7%
두마주유소 3
 
9.7%
양정주유소 3
 
9.7%
대운주유소(계룡대 2
 
6.5%
한빛에너지 2
 
6.5%

주소
Categorical

Distinct8
Distinct (%)25.8%
Missing0
Missing (%)0.0%
Memory size380.0 B
<NA>
10 
엄사면 계룡대로 465
4 
엄사면 계룡대로 449
4 
두마면 왕대로 102
3 
엄사면 계백로 3025
3 
Other values (3)
7 

Length

Max length13
Median length12
Mean length9.2580645
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row두마면 왕대로 102
2nd row두마면 왕대로 102
3rd row두마면 왕대로 102
4th row신도안면 계룡대로 663
5th row신도안면 계룡대로 663

Common Values

ValueCountFrequency (%)
<NA> 10
32.3%
엄사면 계룡대로 465 4
 
12.9%
엄사면 계룡대로 449 4
 
12.9%
두마면 왕대로 102 3
 
9.7%
엄사면 계백로 3025 3
 
9.7%
엄사면 계백로 3107 3
 
9.7%
신도안면 계룡대로 663 2
 
6.5%
두마면 왕대1길24 2
 
6.5%

Length

2023-12-12T21:51:48.677775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:51:48.833441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
엄사면 14
19.7%
na 10
14.1%
계룡대로 10
14.1%
계백로 6
8.5%
두마면 5
 
7.0%
465 4
 
5.6%
449 4
 
5.6%
왕대로 3
 
4.2%
102 3
 
4.2%
3025 3
 
4.2%
Other values (4) 9
12.7%

유종
Categorical

Distinct5
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size380.0 B
<NA>
10 
경유
8 
휘발유
7 
등유
5 
고급휘발유
 
1

Length

Max length5
Median length4
Mean length2.9677419
Min length2

Unique

Unique1 ?
Unique (%)3.2%

Sample

1st row휘발유
2nd row경유
3rd row경유
4th row휘발유
5th row경유

Common Values

ValueCountFrequency (%)
<NA> 10
32.3%
경유 8
25.8%
휘발유 7
22.6%
등유 5
16.1%
고급휘발유 1
 
3.2%

Length

2023-12-12T21:51:49.000239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:51:49.124071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 10
32.3%
경유 8
25.8%
휘발유 7
22.6%
등유 5
16.1%
고급휘발유 1
 
3.2%

유량
Real number (ℝ)

MISSING 

Distinct9
Distinct (%)42.9%
Missing10
Missing (%)32.3%
Infinite0
Infinite (%)0.0%
Mean54.571429
Minimum16
Maximum230
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-12T21:51:49.250708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum16
5-th percentile20
Q120
median40
Q350
95-th percentile200
Maximum230
Range214
Interquartile range (IQR)30

Descriptive statistics

Standard deviation55.775058
Coefficient of variation (CV)1.022056
Kurtosis6.2965372
Mean54.571429
Median Absolute Deviation (MAD)10
Skewness2.6086877
Sum1146
Variance3110.8571
MonotonicityNot monotonic
2023-12-12T21:51:49.359234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
40 7
22.6%
20 5
16.1%
50 3
 
9.7%
200 1
 
3.2%
230 1
 
3.2%
16 1
 
3.2%
30 1
 
3.2%
60 1
 
3.2%
80 1
 
3.2%
(Missing) 10
32.3%
ValueCountFrequency (%)
16 1
 
3.2%
20 5
16.1%
30 1
 
3.2%
40 7
22.6%
50 3
9.7%
60 1
 
3.2%
80 1
 
3.2%
200 1
 
3.2%
230 1
 
3.2%
ValueCountFrequency (%)
230 1
 
3.2%
200 1
 
3.2%
80 1
 
3.2%
60 1
 
3.2%
50 3
9.7%
40 7
22.6%
30 1
 
3.2%
20 5
16.1%
16 1
 
3.2%

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Sample

구분상호주소유종유량Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
0주유소(재)우체국물류지원단주유소두마면 왕대로 102휘발유50<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
1주유소(재)우체국물류지원단주유소두마면 왕대로 102경유40<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
2주유소(재)우체국물류지원단주유소두마면 왕대로 102경유200<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
3주유소대운주유소(계룡대)신도안면 계룡대로 663휘발유40<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
4주유소대운주유소(계룡대)신도안면 계룡대로 663경유40<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
5주유소두마주유소엄사면 계백로 3025휘발유50<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
6주유소두마주유소엄사면 계백로 3025등유20<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
7주유소두마주유소엄사면 계백로 3025경유230<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
8주유소sk에너지(주)신도시주유소엄사면 계룡대로 465휘발유40<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
9주유소sk에너지(주)신도시주유소엄사면 계룡대로 465등유16<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
구분상호주소유종유량Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
21<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
22<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
23<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
24<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
25<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
26<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
27<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
28<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
29<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
30<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

구분상호주소유종유량# duplicates
0<NA><NA><NA><NA><NA>10