Overview

Dataset statistics

Number of variables10
Number of observations28
Missing cells62
Missing cells (%)22.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory85.7 B

Variable types

Unsupported7
Text3

Dataset

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

Alerts

Unnamed: 0 has 28 (100.0%) missing valuesMissing
Unnamed: 6 has 4 (14.3%) missing valuesMissing
Unnamed: 7 has 4 (14.3%) missing valuesMissing
Unnamed: 8 has 4 (14.3%) missing valuesMissing
Unnamed: 9 has 22 (78.6%) 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 00:58:06.324026
Analysis finished2024-03-14 00:58:06.798204
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

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

REJECTED  UNSUPPORTED 

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

Unnamed: 2
Unsupported

REJECTED  UNSUPPORTED 

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

Unnamed: 3
Unsupported

REJECTED  UNSUPPORTED 

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

Unnamed: 4
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2024-03-14T09:58:06.917273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10.5
Mean length6.7857143
Min length3

Characters and Unicode

Total characters190
Distinct characters65
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

Unique28 ?
Unique (%)100.0%

Sample

1st row업체명
2nd row전인석유㈜
3rd row동일유업㈜
4th row에스제이오일㈜
5th row대림석유㈜
ValueCountFrequency (%)
주식회사 7
 
19.4%
업체명 1
 
2.8%
전인석유㈜ 1
 
2.8%
솔로몬에너지 1
 
2.8%
케이디석유 1
 
2.8%
지에스엠비즈 1
 
2.8%
전국석유 1
 
2.8%
주)제이에스상사 1
 
2.8%
글로벌에너지㈜ 1
 
2.8%
강동석유 1
 
2.8%
Other values (20) 20
55.6%
2024-03-14T09:58:07.210425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
㈜ 16
 
8.4%
유 13
 
6.8%
에 9
 
4.7%
사 8
 
4.2%
주 8
 
4.2%
일 8
 
4.2%
8
 
4.2%
회 7
 
3.7%
식 7
 
3.7%
오 7
 
3.7%
Other values (55) 99
52.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 160
84.2%
Other Symbol 16
 
8.4%
Space Separator 8
 
4.2%
Open Punctuation 3
 
1.6%
Close Punctuation 3
 
1.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 13
 
8.1%
에 9
 
5.6%
사 8
 
5.0%
주 8
 
5.0%
일 8
 
5.0%
회 7
 
4.4%
식 7
 
4.4%
오 7
 
4.4%
석 6
 
3.8%
지 6
 
3.8%
Other values (51) 81
50.6%
Other Symbol
ValueCountFrequency (%)
㈜ 16
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 176
92.6%
Common 14
 
7.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
㈜ 16
 
9.1%
유 13
 
7.4%
에 9
 
5.1%
사 8
 
4.5%
주 8
 
4.5%
일 8
 
4.5%
회 7
 
4.0%
식 7
 
4.0%
오 7
 
4.0%
석 6
 
3.4%
Other values (52) 87
49.4%
Common
ValueCountFrequency (%)
8
57.1%
( 3
 
21.4%
) 3
 
21.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 160
84.2%
None 16
 
8.4%
ASCII 14
 
7.4%

Most frequent character per block

None
ValueCountFrequency (%)
㈜ 16
100.0%
Hangul
ValueCountFrequency (%)
유 13
 
8.1%
에 9
 
5.6%
사 8
 
5.0%
주 8
 
5.0%
일 8
 
5.0%
회 7
 
4.4%
식 7
 
4.4%
오 7
 
4.4%
석 6
 
3.8%
지 6
 
3.8%
Other values (51) 81
50.6%
ASCII
ValueCountFrequency (%)
8
57.1%
( 3
 
21.4%
) 3
 
21.4%

Unnamed: 5
Text

Distinct25
Distinct (%)89.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
2024-03-14T09:58:07.411857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length23
Mean length19.928571
Min length3

Characters and Unicode

Total characters558
Distinct characters101
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 (%)78.6%

Sample

1st row소재지
2nd row전주시 덕진구 감수길 39(팔복동4가)
3rd row익산시 평동로 710(동산동)
4th row군산시 해망로 252(장미동)
5th row완주군 이서면 콩쥐팥쥐로 1068
ValueCountFrequency (%)
전주시 14
 
13.3%
덕진구 8
 
7.6%
군산시 6
 
5.7%
완산구 6
 
5.7%
익산시 4
 
3.8%
91(삼천동1가,5층 2
 
1.9%
풍전1길 2
 
1.9%
3(소룡동 2
 
1.9%
장승배기로 2
 
1.9%
백제대로 2
 
1.9%
Other values (52) 57
54.3%
2024-03-14T09:58:07.694776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
77
 
13.8%
동 26
 
4.7%
시 26
 
4.7%
1 25
 
4.5%
) 22
 
3.9%
( 22
 
3.9%
산 21
 
3.8%
로 21
 
3.8%
전 16
 
2.9%
주 15
 
2.7%
Other values (91) 287
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 328
58.8%
Decimal Number 99
 
17.7%
Space Separator 77
 
13.8%
Close Punctuation 22
 
3.9%
Open Punctuation 22
 
3.9%
Other Punctuation 7
 
1.3%
Dash Punctuation 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 26
 
7.9%
시 26
 
7.9%
산 21
 
6.4%
로 21
 
6.4%
전 16
 
4.9%
주 15
 
4.6%
구 15
 
4.6%
가 10
 
3.0%
진 9
 
2.7%
덕 9
 
2.7%
Other values (76) 160
48.8%
Decimal Number
ValueCountFrequency (%)
1 25
25.3%
2 14
14.1%
4 11
11.1%
3 9
 
9.1%
0 8
 
8.1%
5 8
 
8.1%
9 8
 
8.1%
6 6
 
6.1%
7 6
 
6.1%
8 4
 
4.0%
Space Separator
ValueCountFrequency (%)
77
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 328
58.8%
Common 230
41.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 26
 
7.9%
시 26
 
7.9%
산 21
 
6.4%
로 21
 
6.4%
전 16
 
4.9%
주 15
 
4.6%
구 15
 
4.6%
가 10
 
3.0%
진 9
 
2.7%
덕 9
 
2.7%
Other values (76) 160
48.8%
Common
ValueCountFrequency (%)
77
33.5%
1 25
 
10.9%
) 22
 
9.6%
( 22
 
9.6%
2 14
 
6.1%
4 11
 
4.8%
3 9
 
3.9%
0 8
 
3.5%
5 8
 
3.5%
9 8
 
3.5%
Other values (5) 26
 
11.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 328
58.8%
ASCII 230
41.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
77
33.5%
1 25
 
10.9%
) 22
 
9.6%
( 22
 
9.6%
2 14
 
6.1%
4 11
 
4.8%
3 9
 
3.9%
0 8
 
3.5%
5 8
 
3.5%
9 8
 
3.5%
Other values (5) 26
 
11.3%
Hangul
ValueCountFrequency (%)
동 26
 
7.9%
시 26
 
7.9%
산 21
 
6.4%
로 21
 
6.4%
전 16
 
4.9%
주 15
 
4.6%
구 15
 
4.6%
가 10
 
3.0%
진 9
 
2.7%
덕 9
 
2.7%
Other values (76) 160
48.8%

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)14.3%
Memory size356.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)14.3%
Memory size356.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)14.3%
Memory size356.0 B

Unnamed: 9
Text

MISSING 

Distinct3
Distinct (%)50.0%
Missing22
Missing (%)78.6%
Memory size356.0 B
2024-03-14T09:58:07.783535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length2
Mean length2.1666667
Min length2

Characters and Unicode

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

Unique

Unique2 ?
Unique (%)33.3%

Sample

1st row비 고
2nd row해상
3rd row해상
4th row해상
5th row용제
ValueCountFrequency (%)
해상 4
57.1%
비 1
 
14.3%
고 1
 
14.3%
용제 1
 
14.3%
2024-03-14T09:58:07.959480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
해 4
30.8%
상 4
30.8%
비 1
 
7.7%
1
 
7.7%
고 1
 
7.7%
용 1
 
7.7%
제 1
 
7.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12
92.3%
Space Separator 1
 
7.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
해 4
33.3%
상 4
33.3%
비 1
 
8.3%
고 1
 
8.3%
용 1
 
8.3%
제 1
 
8.3%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12
92.3%
Common 1
 
7.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
해 4
33.3%
상 4
33.3%
비 1
 
8.3%
고 1
 
8.3%
용 1
 
8.3%
제 1
 
8.3%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12
92.3%
ASCII 1
 
7.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
해 4
33.3%
상 4
33.3%
비 1
 
8.3%
고 1
 
8.3%
용 1
 
8.3%
제 1
 
8.3%
ASCII
ValueCountFrequency (%)
1
100.0%

Correlations

2024-03-14T09:58:08.024276image/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-14T09:58:06.542937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:58:06.653736image/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-14T09:58:06.746927image/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가)908555<NA>
2<NA>21031976-09-26 00:00:00동일유업㈜익산시 평동로 710(동산동)700360<NA>
3<NA>31041977-10-23 00:00:00에스제이오일㈜군산시 해망로 252(장미동)1260496<NA>
4<NA>41181989-10-25 00:00:00대림석유㈜완주군 이서면 콩쥐팥쥐로 106810906144<NA>
5<NA>51362001-06-04 00:00:00㈜케이원에너지전주시 완산구 팔달로 291(서노송동)780550<NA>
6<NA>61382001-10-30 00:00:00㈜유진오일전주시 덕진구 원만성로 47(팔복동3가)13969180<NA>
7<NA>71412002-10-02 00:00:00㈜해양유업군산시 풍전1길 3(소룡동)NaNNaNNaN해상
8<NA>81512005-11-17 00:00:00(유)이레석유전주시 덕진구 동부대로 985(송천동2가)766556<NA>
9<NA>91542006-08-30 00:00:00㈜필오일군산시 해령1길 140(내흥동)730264<NA>
Unnamed: 0석유판매업(일반·용제대리점) 등록현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
18<NA>181842013-04-16 00:00:00페트로 앰엔에스 주식회사익산시 석암로 122(용제동)840256<NA>
19<NA>191852013-06-26 00:00:00주식회사 한영전주시 완산구 장승배기로 91(삼천동1가,5층)700360<NA>
20<NA>201862013-07-25 00:00:00강동석유전주시 덕진구 백제대로 600, 2층(금암동)1080250<NA>
21<NA>211882014-03-18 00:00:00글로벌에너지㈜군산시 풍전1길 3(소룡동)NaNNaNNaN해상
22<NA>221892014-04-08 00:00:00(주)제이에스상사전주시 덕진구 감수길 87-1(팔복동4가)728364<NA>
23<NA>231902014-11-10 00:00:00전국석유 주식회사익산시 익산대로4길 31(인화동1가)1000356<NA>
24<NA>241912014-12-24 00:00:00지에스엠비즈 주식회사전주시 덕진구 팔과정로 167(동산동)493120용제
25<NA>251922014-12-24 00:00:00주식회사 케이디석유전주시 덕진구 백제대로 600, 2층(금암동)800354<NA>
26<NA>261942015-07-07 00:00:00솔로몬에너지 주식회사전주시 완산구 신봉1길 14-8(효자동1가)NaNNaNNaN해상
27<NA>271952016-07-19 00:00:00주식회사 한보전주시 완산구 홍산중앙로 41, 402호(효자동3가)820254.7<NA>