Overview

Dataset statistics

Number of variables10
Number of observations26
Missing cells38
Missing cells (%)14.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory86.1 B

Variable types

Unsupported7
Text2
Categorical1

Dataset

Description석유판매업일반대리점등록현황2017년7월말기준
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202914

Alerts

Unnamed: 0 has 26 (100.0%) missing valuesMissing
Unnamed: 6 has 4 (15.4%) missing valuesMissing
Unnamed: 7 has 4 (15.4%) missing valuesMissing
Unnamed: 8 has 4 (15.4%) missing valuesMissing
Unnamed: 4 has unique valuesUnique
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
석유판매업(일반대리점) 등록현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 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

Reproduction

Analysis started2024-03-14 01:46:57.938529
Analysis finished2024-03-14 01:46:58.427940
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing26
Missing (%)100.0%
Memory size366.0 B

석유판매업(일반대리점) 등록현황
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size340.0 B

Unnamed: 2
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size340.0 B

Unnamed: 3
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size340.0 B

Unnamed: 4
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2024-03-14T10:46:58.548006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length6.7307692
Min length3

Characters and Unicode

Total characters175
Distinct characters61
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)100.0%

Sample

1st row업체명
2nd row전인석유㈜
3rd row동일유업㈜
4th row에스제이오일㈜
5th row대림석유㈜
ValueCountFrequency (%)
주식회사 5
 
15.2%
업체명 1
 
3.0%
㈜오일랜드 1
 
3.0%
유한회사 1
 
3.0%
송강에너지 1
 
3.0%
한보 1
 
3.0%
솔로몬에너지 1
 
3.0%
주)제이에스상사 1
 
3.0%
글로벌에너지㈜ 1
 
3.0%
서린에너지 1
 
3.0%
Other values (19) 19
57.6%
2024-03-14T10:46:58.809597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
㈜ 15
 
8.6%
에 11
 
6.3%
유 10
 
5.7%
지 8
 
4.6%
너 8
 
4.6%
7
 
4.0%
일 7
 
4.0%
사 7
 
4.0%
오 6
 
3.4%
주 6
 
3.4%
Other values (51) 90
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 147
84.0%
Other Symbol 15
 
8.6%
Space Separator 7
 
4.0%
Open Punctuation 3
 
1.7%
Close Punctuation 3
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
에 11
 
7.5%
유 10
 
6.8%
지 8
 
5.4%
너 8
 
5.4%
일 7
 
4.8%
사 7
 
4.8%
오 6
 
4.1%
주 6
 
4.1%
회 6
 
4.1%
식 5
 
3.4%
Other values (47) 73
49.7%
Other Symbol
ValueCountFrequency (%)
㈜ 15
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 162
92.6%
Common 13
 
7.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
㈜ 15
 
9.3%
에 11
 
6.8%
유 10
 
6.2%
지 8
 
4.9%
너 8
 
4.9%
일 7
 
4.3%
사 7
 
4.3%
오 6
 
3.7%
주 6
 
3.7%
회 6
 
3.7%
Other values (48) 78
48.1%
Common
ValueCountFrequency (%)
7
53.8%
( 3
23.1%
) 3
23.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 147
84.0%
None 15
 
8.6%
ASCII 13
 
7.4%

Most frequent character per block

None
ValueCountFrequency (%)
㈜ 15
100.0%
Hangul
ValueCountFrequency (%)
에 11
 
7.5%
유 10
 
6.8%
지 8
 
5.4%
너 8
 
5.4%
일 7
 
4.8%
사 7
 
4.8%
오 6
 
4.1%
주 6
 
4.1%
회 6
 
4.1%
식 5
 
3.4%
Other values (47) 73
49.7%
ASCII
ValueCountFrequency (%)
7
53.8%
( 3
23.1%
) 3
23.1%

Unnamed: 5
Text

Distinct24
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Memory size340.0 B
2024-03-14T10:46:58.992635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length20.346154
Min length3

Characters and Unicode

Total characters529
Distinct characters103
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

Unique22 ?
Unique (%)84.6%

Sample

1st row소재지
2nd row전주시 덕진구 감수길 39(팔복동4가)
3rd row익산시 평동로 710(동산동)
4th row군산시 해망로 252(장미동)
5th row완주군 이서면 콩쥐팥쥐로 1068
ValueCountFrequency (%)
전주시 14
 
14.1%
덕진구 9
 
9.1%
군산시 5
 
5.1%
완산구 5
 
5.1%
익산시 3
 
3.0%
콩쥐팥쥐로 2
 
2.0%
기린대로 2
 
2.0%
풍전1길 2
 
2.0%
감수길 2
 
2.0%
김제시 2
 
2.0%
Other values (50) 53
53.5%
2024-03-14T10:46:59.296150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
73
 
13.8%
1 25
 
4.7%
시 24
 
4.5%
동 24
 
4.5%
( 21
 
4.0%
) 21
 
4.0%
로 18
 
3.4%
구 16
 
3.0%
전 16
 
3.0%
산 15
 
2.8%
Other values (93) 276
52.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 310
58.6%
Decimal Number 94
 
17.8%
Space Separator 73
 
13.8%
Open Punctuation 21
 
4.0%
Close Punctuation 21
 
4.0%
Other Punctuation 7
 
1.3%
Dash Punctuation 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 24
 
7.7%
동 24
 
7.7%
로 18
 
5.8%
구 16
 
5.2%
전 16
 
5.2%
산 15
 
4.8%
주 15
 
4.8%
가 12
 
3.9%
진 11
 
3.5%
덕 11
 
3.5%
Other values (78) 148
47.7%
Decimal Number
ValueCountFrequency (%)
1 25
26.6%
2 13
13.8%
4 11
11.7%
5 10
 
10.6%
3 8
 
8.5%
9 7
 
7.4%
8 6
 
6.4%
7 6
 
6.4%
0 4
 
4.3%
6 4
 
4.3%
Space Separator
ValueCountFrequency (%)
73
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 310
58.6%
Common 219
41.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 24
 
7.7%
동 24
 
7.7%
로 18
 
5.8%
구 16
 
5.2%
전 16
 
5.2%
산 15
 
4.8%
주 15
 
4.8%
가 12
 
3.9%
진 11
 
3.5%
덕 11
 
3.5%
Other values (78) 148
47.7%
Common
ValueCountFrequency (%)
73
33.3%
1 25
 
11.4%
( 21
 
9.6%
) 21
 
9.6%
2 13
 
5.9%
4 11
 
5.0%
5 10
 
4.6%
3 8
 
3.7%
, 7
 
3.2%
9 7
 
3.2%
Other values (5) 23
 
10.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 310
58.6%
ASCII 219
41.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
73
33.3%
1 25
 
11.4%
( 21
 
9.6%
) 21
 
9.6%
2 13
 
5.9%
4 11
 
5.0%
5 10
 
4.6%
3 8
 
3.7%
, 7
 
3.2%
9 7
 
3.2%
Other values (5) 23
 
10.5%
Hangul
ValueCountFrequency (%)
시 24
 
7.7%
동 24
 
7.7%
로 18
 
5.8%
구 16
 
5.2%
전 16
 
5.2%
산 15
 
4.8%
주 15
 
4.8%
가 12
 
3.9%
진 11
 
3.5%
덕 11
 
3.5%
Other values (78) 148
47.7%

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)15.4%
Memory size340.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)15.4%
Memory size340.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)15.4%
Memory size340.0 B

Unnamed: 9
Categorical

Distinct3
Distinct (%)11.5%
Missing0
Missing (%)0.0%
Memory size340.0 B
<NA>
21 
해상
4 
비 고
 
1

Length

Max length4
Median length4
Mean length3.6538462
Min length2

Unique

Unique1 ?
Unique (%)3.8%

Sample

1st row비 고
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 21
80.8%
해상 4
 
15.4%
비 고 1
 
3.8%

Length

2024-03-14T10:46:59.426709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T10:46:59.514349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 21
77.8%
해상 4
 
14.8%
비 1
 
3.7%
고 1
 
3.7%

Correlations

2024-03-14T10:46:59.570950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 4Unnamed: 5Unnamed: 9
Unnamed: 41.0001.0001.000
Unnamed: 51.0001.0001.000
Unnamed: 91.0001.0001.000

Missing values

2024-03-14T10:46:58.127865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T10:46:58.258146image/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.
2024-03-14T10:46:58.361537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

Unnamed: 0석유판매업(일반대리점) 등록현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
0<NA>연번등록\n번호등록일업체명소재지저장시설\n(㎘l)수송장비\n(대)수송장비\n(㎘l)비 고
1<NA>11011976-06-01 00:00:00전인석유㈜전주시 덕진구 감수길 39(팔복동4가)920555<NA>
2<NA>21031976-09-26 00:00:00동일유업㈜익산시 평동로 710(동산동)700480<NA>
3<NA>31041977-10-23 00:00:00에스제이오일㈜군산시 해망로 252(장미동)7204116<NA>
4<NA>41181989-10-25 00:00:00대림석유㈜완주군 이서면 콩쥐팥쥐로 106810906144<NA>
5<NA>51362001-06-04 00:00:00㈜케이원에너지전주시 덕진구 구총목로 5(인후동1가)1080350<NA>
6<NA>61382001-10-30 00:00:00㈜유진오일전주시 덕진구 원만성로 47(팔복동3가)1396360<NA>
7<NA>71412002-10-02 00:00:00㈜해양유업군산시 풍전1길 3(소룡동)NaNNaNNaN해상
8<NA>81512005-11-17 00:00:00(유)이레석유전주시 덕진구 동부대로 985(송천동2가)766456<NA>
9<NA>91542006-08-30 00:00:00㈜필오일군산시 해령1길 140(내흥동)730264<NA>
Unnamed: 0석유판매업(일반대리점) 등록현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
16<NA>161802013-01-04 00:00:00㈜비전에너지전주시 완산구 콩쥐팥쥐로 1697(효자동3가)1229252<NA>
17<NA>171842013-04-16 00:00:00페트로 앰엔에스 주식회사익산시 석암로 122(용제동)840256<NA>
18<NA>181852013-06-26 00:00:00주식회사 한영전주시 완산구 장승배기로 91(삼천동1가,5층)700360<NA>
19<NA>191862013-07-25 00:00:00서린에너지전주시 완산구 평화로 136, 4층(평화동2가)780364<NA>
20<NA>201882014-03-18 00:00:00글로벌에너지㈜군산시 풍전1길 3(소룡동)NaNNaNNaN해상
21<NA>211892014-04-08 00:00:00(주)제이에스상사전주시 덕진구 감수길 87-1(팔복동4가)728368<NA>
22<NA>221942015-07-07 00:00:00솔로몬에너지 주식회사전주시 완산구 신봉1길 14-8(효자동1가)NaNNaNNaN해상
23<NA>231952016-07-19 00:00:00주식회사 한보전주시 덕진구 아중7길 8, 101호(우아동2가)820255<NA>
24<NA>241962016-09-09 00:00:00주식회사 송강에너지전주시 덕진구 기린대로 568(덕진동2가)750360<NA>
25<NA>251972016-12-20 00:00:00유한회사 한결에너지전주시 덕진구 기린대로 1144, 2층(반월동)720264<NA>