Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory566.4 KiB
Average record size in memory58.0 B

Variable types

Categorical5
Text1

Dataset

Description전국 전주전산화번호(전주번호)
Author한국전력공사
URLhttps://www.data.go.kr/data/15069455/fileData.do

Alerts

1차순번 has constant value ""Constant
1차본부 has constant value ""Constant
2차사업소 is highly overall correlated with 2차순번High correlation
2차순번 is highly overall correlated with 2차사업소High correlation
전산화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:29:09.422643
Analysis finished2023-12-12 09:29:10.013534
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

1차순번
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
3
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3
2nd row3
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
3 10000
100.0%

Length

2023-12-12T18:29:10.085890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:10.218497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 10000
100.0%

1차본부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
인천본부
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천본부
2nd row인천본부
3rd row인천본부
4th row인천본부
5th row인천본부

Common Values

ValueCountFrequency (%)
인천본부 10000
100.0%

Length

2023-12-12T18:29:10.335942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:10.433592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천본부 10000
100.0%

2차순번
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
4
3168 
1
2851 
2
2008 
3
1973 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4
2nd row1
3rd row4
4th row1
5th row2

Common Values

ValueCountFrequency (%)
4 3168
31.7%
1 2851
28.5%
2 2008
20.1%
3 1973
19.7%

Length

2023-12-12T18:29:10.535203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:10.670582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
4 3168
31.7%
1 2851
28.5%
2 2008
20.1%
3 1973
19.7%

2차사업소
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
김포지사
3168 
인천본부직할
2851 
남인천지사
2008 
부천지사
1973 

Length

Max length6
Median length4
Mean length4.771
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row김포지사
2nd row인천본부직할
3rd row김포지사
4th row인천본부직할
5th row남인천지사

Common Values

ValueCountFrequency (%)
김포지사 3168
31.7%
인천본부직할 2851
28.5%
남인천지사 2008
20.1%
부천지사 1973
19.7%

Length

2023-12-12T18:29:10.822276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:10.985892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
김포지사 3168
31.7%
인천본부직할 2851
28.5%
남인천지사 2008
20.1%
부천지사 1973
19.7%

전산화번호
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T18:29:11.298316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

Total characters80000
Distinct characters28
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st row8235E381
2nd row8724Q691
3rd row8531R753
4th row8723R814
5th row8720D891
ValueCountFrequency (%)
8235e381 1
 
< 0.1%
8719f943 1
 
< 0.1%
8130z473 1
 
< 0.1%
8928h431 1
 
< 0.1%
8228w203 1
 
< 0.1%
8128p371 1
 
< 0.1%
9127q352 1
 
< 0.1%
9221c252 1
 
< 0.1%
8820x081 1
 
< 0.1%
9021f782 1
 
< 0.1%
Other values (9990) 9990
99.9%
2023-12-12T18:29:11.869499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 12603
15.8%
8 11924
14.9%
1 11075
13.8%
3 7778
9.7%
9 5911
7.4%
0 4891
 
6.1%
7 4686
 
5.9%
4 4518
 
5.6%
6 3549
 
4.4%
5 3274
 
4.1%
Other values (18) 9791
12.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 70209
87.8%
Uppercase Letter 9789
 
12.2%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
D 684
 
7.0%
A 683
 
7.0%
F 657
 
6.7%
E 654
 
6.7%
G 646
 
6.6%
B 637
 
6.5%
R 635
 
6.5%
Q 617
 
6.3%
H 616
 
6.3%
C 610
 
6.2%
Other values (6) 3350
34.2%
Decimal Number
ValueCountFrequency (%)
2 12603
18.0%
8 11924
17.0%
1 11075
15.8%
3 7778
11.1%
9 5911
8.4%
0 4891
 
7.0%
7 4686
 
6.7%
4 4518
 
6.4%
6 3549
 
5.1%
5 3274
 
4.7%
Lowercase Letter
ValueCountFrequency (%)
z 1
50.0%
s 1
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 70209
87.8%
Latin 9791
 
12.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
D 684
 
7.0%
A 683
 
7.0%
F 657
 
6.7%
E 654
 
6.7%
G 646
 
6.6%
B 637
 
6.5%
R 635
 
6.5%
Q 617
 
6.3%
H 616
 
6.3%
C 610
 
6.2%
Other values (8) 3352
34.2%
Common
ValueCountFrequency (%)
2 12603
18.0%
8 11924
17.0%
1 11075
15.8%
3 7778
11.1%
9 5911
8.4%
0 4891
 
7.0%
7 4686
 
6.7%
4 4518
 
6.4%
6 3549
 
5.1%
5 3274
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 80000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 12603
15.8%
8 11924
14.9%
1 11075
13.8%
3 7778
9.7%
9 5911
7.4%
0 4891
 
6.1%
7 4686
 
5.9%
4 4518
 
5.6%
6 3549
 
4.4%
5 3274
 
4.1%
Other values (18) 9791
12.2%

지역구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
4049 
주택가
4009 
농어촌
1472 
번화가
468 
공란
 
2

Length

Max length4
Median length3
Mean length3.4047
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주택가
2nd row주택가
3rd row농어촌
4th row주택가
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 4049
40.5%
주택가 4009
40.1%
농어촌 1472
 
14.7%
번화가 468
 
4.7%
공란 2
 
< 0.1%

Length

2023-12-12T18:29:12.087719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:29:12.240663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 4049
40.5%
주택가 4009
40.1%
농어촌 1472
 
14.7%
번화가 468
 
4.7%
공란 2
 
< 0.1%

Correlations

2023-12-12T18:29:12.340325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2차순번2차사업소지역구분
2차순번1.0001.0000.525
2차사업소1.0001.0000.525
지역구분0.5250.5251.000
2023-12-12T18:29:12.815834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역구분2차사업소2차순번
지역구분1.0000.2270.227
2차사업소0.2271.0001.000
2차순번0.2271.0001.000
2023-12-12T18:29:12.931911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2차순번2차사업소지역구분
2차순번1.0001.0000.227
2차사업소1.0001.0000.227
지역구분0.2270.2271.000

Missing values

2023-12-12T18:29:09.816485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:29:09.950383image/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

1차순번1차본부2차순번2차사업소전산화번호지역구분
671723인천본부4김포지사8235E381주택가
10343인천본부1인천본부직할8724Q691주택가
907413인천본부4김포지사8531R753농어촌
129513인천본부1인천본부직할8723R814주택가
319033인천본부2남인천지사8720D891<NA>
608533인천본부3부천지사9021C303주택가
414183인천본부2남인천지사8718Z621<NA>
281493인천본부2남인천지사8616X383주택가
750783인천본부4김포지사8130Z343농어촌
646573인천본부3부천지사9123F961<NA>
1차순번1차본부2차순번2차사업소전산화번호지역구분
628083인천본부3부천지사9224C631농어촌
89883인천본부1인천본부직할8721B823<NA>
720383인천본부4김포지사8729C862번화가
720033인천본부4김포지사8731R673<NA>
215153인천본부1인천본부직할3131X314농어촌
74733인천본부1인천본부직할8823H053<NA>
836603인천본부4김포지사8036C333농어촌
615323인천본부3부천지사8924H952주택가
435543인천본부2남인천지사8819Q844농어촌
224693인천본부1인천본부직할8723G524<NA>