Overview

Dataset statistics

Number of variables5
Number of observations1173
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory45.9 KiB
Average record size in memory40.1 B

Variable types

DateTime1
Categorical2
Text2

Dataset

Description한국전력공사와 전력공급계약을 체결한 고객중 86101 종합병원,86102 일반병원,87111 노인요양 복지시설 운영업 산업분류코드 고객의 고객 호수 및 계약 전력데이터 입니다.
Author한국전력공사
URLhttps://www.data.go.kr/data/15125797/fileData.do

Reproduction

Analysis started2024-01-06 12:22:56.384538
Analysis finished2024-01-06 12:22:58.161602
Duration1.78 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

년월
Date

Distinct23
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2022-01-01 00:00:00
Maximum2023-11-01 00:00:00
2024-01-06T12:22:58.443397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-06T12:22:58.944637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

시도
Categorical

Distinct17
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
강원특별자치도
 
69
경기도
 
69
경상남도
 
69
경상북도
 
69
광주광역시
 
69
Other values (12)
828 

Length

Max length7
Median length5
Mean length4.8823529
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강원특별자치도
2nd row강원특별자치도
3rd row강원특별자치도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
강원특별자치도 69
 
5.9%
경기도 69
 
5.9%
경상남도 69
 
5.9%
경상북도 69
 
5.9%
광주광역시 69
 
5.9%
대구광역시 69
 
5.9%
대전광역시 69
 
5.9%
부산광역시 69
 
5.9%
서울특별시 69
 
5.9%
세종특별자치시 69
 
5.9%
Other values (7) 483
41.2%

Length

2024-01-06T12:22:59.556354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
강원특별자치도 69
 
5.9%
세종특별자치시 69
 
5.9%
충청남도 69
 
5.9%
제주특별자치도 69
 
5.9%
전라북도 69
 
5.9%
전라남도 69
 
5.9%
인천광역시 69
 
5.9%
울산광역시 69
 
5.9%
서울특별시 69
 
5.9%
경기도 69
 
5.9%
Other values (7) 483
41.2%

산업분류
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
86101 종합 병원
391 
86102 일반 병원
391 
87111 노인 요양 복지시설 운영업
391 

Length

Max length20
Median length11
Mean length14
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row86101 종합 병원
2nd row86102 일반 병원
3rd row87111 노인 요양 복지시설 운영업
4th row86101 종합 병원
5th row86102 일반 병원

Common Values

ValueCountFrequency (%)
86101 종합 병원 391
33.3%
86102 일반 병원 391
33.3%
87111 노인 요양 복지시설 운영업 391
33.3%

Length

2024-01-06T12:23:00.121762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T12:23:00.440742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
병원 782
18.2%
86101 391
9.1%
종합 391
9.1%
86102 391
9.1%
일반 391
9.1%
87111 391
9.1%
노인 391
9.1%
요양 391
9.1%
복지시설 391
9.1%
운영업 391
9.1%

고객호수
Text

Distinct481
Distinct (%)41.0%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-01-06T12:23:01.348386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length4
Mean length3.7672634
Min length2

Characters and Unicode

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

Unique

Unique256 ?
Unique (%)21.8%

Sample

1st row75
2nd row422
3rd row507
4th row271
5th row1283
ValueCountFrequency (%)
40 24
 
2.0%
미만 23
 
1.9%
5호 23
 
1.9%
69 20
 
1.7%
8 20
 
1.7%
75 17
 
1.4%
37 16
 
1.3%
45 15
 
1.3%
36 15
 
1.3%
46 14
 
1.2%
Other values (472) 1009
84.4%
2024-01-06T12:23:03.002242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1173
26.5%
1 502
11.4%
4 453
 
10.3%
3 380
 
8.6%
2 340
 
7.7%
5 291
 
6.6%
6 271
 
6.1%
7 268
 
6.1%
8 235
 
5.3%
9 223
 
5.0%
Other values (4) 283
 
6.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3177
71.9%
Space Separator 1173
 
26.5%
Other Letter 69
 
1.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 502
15.8%
4 453
14.3%
3 380
12.0%
2 340
10.7%
5 291
9.2%
6 271
8.5%
7 268
8.4%
8 235
7.4%
9 223
7.0%
0 214
6.7%
Other Letter
ValueCountFrequency (%)
호 23
33.3%
미 23
33.3%
만 23
33.3%
Space Separator
ValueCountFrequency (%)
1173
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4350
98.4%
Hangul 69
 
1.6%

Most frequent character per script

Common
ValueCountFrequency (%)
1173
27.0%
1 502
11.5%
4 453
 
10.4%
3 380
 
8.7%
2 340
 
7.8%
5 291
 
6.7%
6 271
 
6.2%
7 268
 
6.2%
8 235
 
5.4%
9 223
 
5.1%
Hangul
ValueCountFrequency (%)
호 23
33.3%
미 23
33.3%
만 23
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4350
98.4%
Hangul 69
 
1.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1173
27.0%
1 502
11.5%
4 453
 
10.4%
3 380
 
8.7%
2 340
 
7.8%
5 291
 
6.7%
6 271
 
6.2%
7 268
 
6.2%
8 235
 
5.4%
9 223
 
5.1%
Hangul
ValueCountFrequency (%)
호 23
33.3%
미 23
33.3%
만 23
33.3%

계약전력합계
Text

Distinct843
Distinct (%)71.9%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-01-06T12:23:03.938775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length6.0716113
Min length4

Characters and Unicode

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

Unique

Unique711 ?
Unique (%)60.6%

Sample

1st row44819
2nd row58990
3rd row34406
4th row247286
5th row282703
ValueCountFrequency (%)
5호미만 23
 
2.0%
17458 20
 
1.7%
86442 16
 
1.4%
60538 11
 
0.9%
92614 10
 
0.9%
39421 9
 
0.8%
36621 8
 
0.7%
36977 7
 
0.6%
45328 7
 
0.6%
43162 7
 
0.6%
Other values (833) 1055
89.9%
2024-01-06T12:23:05.342615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1150
16.1%
1 673
9.4%
3 667
9.4%
4 659
9.3%
2 656
9.2%
5 610
8.6%
8 599
8.4%
6 569
8.0%
7 503
7.1%
0 490
6.9%
Other values (4) 546
7.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5903
82.9%
Space Separator 1150
 
16.1%
Other Letter 69
 
1.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 673
11.4%
3 667
11.3%
4 659
11.2%
2 656
11.1%
5 610
10.3%
8 599
10.1%
6 569
9.6%
7 503
8.5%
0 490
8.3%
9 477
8.1%
Other Letter
ValueCountFrequency (%)
호 23
33.3%
미 23
33.3%
만 23
33.3%
Space Separator
ValueCountFrequency (%)
1150
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 7053
99.0%
Hangul 69
 
1.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1150
16.3%
1 673
9.5%
3 667
9.5%
4 659
9.3%
2 656
9.3%
5 610
8.6%
8 599
8.5%
6 569
8.1%
7 503
7.1%
0 490
6.9%
Hangul
ValueCountFrequency (%)
호 23
33.3%
미 23
33.3%
만 23
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7053
99.0%
Hangul 69
 
1.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1150
16.3%
1 673
9.5%
3 667
9.5%
4 659
9.3%
2 656
9.3%
5 610
8.6%
8 599
8.5%
6 569
8.1%
7 503
7.1%
0 490
6.9%
Hangul
ValueCountFrequency (%)
호 23
33.3%
미 23
33.3%
만 23
33.3%

Correlations

2024-01-06T12:23:05.834142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
년월시도산업분류
년월1.0000.0000.000
시도0.0001.0000.000
산업분류0.0000.0001.000
2024-01-06T12:23:06.106667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
산업분류시도
산업분류1.0000.000
시도0.0001.000
2024-01-06T12:23:06.304517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시도산업분류
시도1.0000.000
산업분류0.0001.000

Missing values

2024-01-06T12:22:57.089203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-06T12:22:57.809572image/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

년월시도산업분류고객호수계약전력합계
02022-01강원특별자치도86101 종합 병원7544819
12022-01강원특별자치도86102 일반 병원42258990
22022-01강원특별자치도87111 노인 요양 복지시설 운영업50734406
32022-01경기도86101 종합 병원271247286
42022-01경기도86102 일반 병원1283282703
52022-01경기도87111 노인 요양 복지시설 운영업1361118980
62022-01경상남도86101 종합 병원111136967
72022-01경상남도86102 일반 병원663123419
82022-01경상남도87111 노인 요양 복지시설 운영업39852638
92022-01경상북도86101 종합 병원10050298
년월시도산업분류고객호수계약전력합계
11632023-11전라북도87111 노인 요양 복지시설 운영업51444216
11642023-11제주특별자치도86101 종합 병원817458
11652023-11제주특별자치도86102 일반 병원14815653
11662023-11제주특별자치도87111 노인 요양 복지시설 운영업618658
11672023-11충청남도86101 종합 병원6945202
11682023-11충청남도86102 일반 병원48960575
11692023-11충청남도87111 노인 요양 복지시설 운영업44939485
11702023-11충청북도86101 종합 병원4525910
11712023-11충청북도86102 일반 병원39971937
11722023-11충청북도87111 노인 요양 복지시설 운영업43027763