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/15069485/fileData.do

Alerts

1차순번 has constant value ""Constant
1차본부 has constant value ""Constant
2차순번 has constant value ""Constant
2차사업소 has constant value ""Constant
전산화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:04:10.652650
Analysis finished2023-12-12 12:04:11.211888
Duration0.56 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
12
10000 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
12 10000
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:04:11.407175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
12 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-12T21:04:11.510418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:04:11.606183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경북본부 10000
100.0%

2차순번
Categorical

CONSTANT 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 10000
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:04:11.804744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%

2차사업소
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
경북본부직할
10000 

Length

Max length6
Median length6
Mean length6
Min length6

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-12T21:04:11.901703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:04:11.999693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경북본부직할 10000
100.0%

전산화번호
Text

UNIQUE 

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

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

Total characters80000
Distinct characters26
Distinct categories2 ?
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 row8774E641
2nd row84761994
3rd row7667D851
4th row7869E232
5th row9763W291
ValueCountFrequency (%)
8774e641 1
 
< 0.1%
88771644 1
 
< 0.1%
8976x761 1
 
< 0.1%
9169z811 1
 
< 0.1%
90684697 1
 
< 0.1%
76681772 1
 
< 0.1%
9069f421 1
 
< 0.1%
8072x671 1
 
< 0.1%
7870d862 1
 
< 0.1%
97604683 1
 
< 0.1%
Other values (9990) 9990
99.9%
2023-12-12T21:04:12.728019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 11011
13.8%
1 10465
13.1%
8 10424
13.0%
9 7977
10.0%
6 7055
8.8%
2 6576
8.2%
3 5207
6.5%
4 4554
5.7%
0 4393
 
5.5%
5 4193
 
5.2%
Other values (16) 8145
10.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 71855
89.8%
Uppercase Letter 8145
 
10.2%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
X 569
 
7.0%
P 550
 
6.8%
F 538
 
6.6%
E 532
 
6.5%
C 529
 
6.5%
R 527
 
6.5%
Z 525
 
6.4%
W 510
 
6.3%
A 506
 
6.2%
H 488
 
6.0%
Other values (6) 2871
35.2%
Decimal Number
ValueCountFrequency (%)
7 11011
15.3%
1 10465
14.6%
8 10424
14.5%
9 7977
11.1%
6 7055
9.8%
2 6576
9.2%
3 5207
7.2%
4 4554
6.3%
0 4393
 
6.1%
5 4193
 
5.8%

Most occurring scripts

ValueCountFrequency (%)
Common 71855
89.8%
Latin 8145
 
10.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
X 569
 
7.0%
P 550
 
6.8%
F 538
 
6.6%
E 532
 
6.5%
C 529
 
6.5%
R 527
 
6.5%
Z 525
 
6.4%
W 510
 
6.3%
A 506
 
6.2%
H 488
 
6.0%
Other values (6) 2871
35.2%
Common
ValueCountFrequency (%)
7 11011
15.3%
1 10465
14.6%
8 10424
14.5%
9 7977
11.1%
6 7055
9.8%
2 6576
9.2%
3 5207
7.2%
4 4554
6.3%
0 4393
 
6.1%
5 4193
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 80000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7 11011
13.8%
1 10465
13.1%
8 10424
13.0%
9 7977
10.0%
6 7055
8.8%
2 6576
8.2%
3 5207
6.5%
4 4554
5.7%
0 4393
 
5.5%
5 4193
 
5.2%
Other values (16) 8145
10.2%

지역구분
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
농어촌
4918 
<NA>
3500 
주택가
1515 
번화가
 
67

Length

Max length4
Median length3
Mean length3.35
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
농어촌 4918
49.2%
<NA> 3500
35.0%
주택가 1515
 
15.2%
번화가 67
 
0.7%

Length

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

Common Values (Plot)

2023-12-12T21:04:12.971338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
농어촌 4918
49.2%
na 3500
35.0%
주택가 1515
 
15.2%
번화가 67
 
0.7%

Missing values

2023-12-12T21:04:10.987893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:04:11.149194image/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차사업소전산화번호지역구분
6956212경북본부1경북본부직할8774E641농어촌
4067012경북본부1경북본부직할84761994농어촌
6594012경북본부1경북본부직할7667D851주택가
6602712경북본부1경북본부직할7869E232농어촌
7970012경북본부1경북본부직할9763W291<NA>
3514312경북본부1경북본부직할97642912농어촌
8444812경북본부1경북본부직할9070Y812<NA>
886712경북본부1경북본부직할85772502농어촌
3409312경북본부1경북본부직할91784584<NA>
4903212경북본부1경북본부직할8771Z113주택가
1차순번1차본부2차순번2차사업소전산화번호지역구분
6932112경북본부1경북본부직할9577Z721농어촌
9199012경북본부1경북본부직할9363Q061<NA>
5490512경북본부1경북본부직할9971E241<NA>
8100312경북본부1경북본부직할8170X122<NA>
4640812경북본부1경북본부직할87671383<NA>
1193512경북본부1경북본부직할91681663농어촌
6690512경북본부1경북본부직할8665P813농어촌
3157912경북본부1경북본부직할9275C541농어촌
1694912경북본부1경북본부직할8770C971번화가
3176612경북본부1경북본부직할93664462농어촌