Overview

Dataset statistics

Number of variables14
Number of observations200
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.4 KiB
Average record size in memory119.7 B

Variable types

Categorical13
Text1

Dataset

DescriptionSample
Author한국스마트그리드
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KSG2019111100AMCU01a

Alerts

통합운영센터 번호 has constant value ""Constant
스마트그리드 보급지원 계약 상태코드 has constant value ""Constant
적재일시 has constant value ""Constant
수용가 타입 번호 has constant value ""Constant
요금제 has constant value ""Constant
요금제 전압 구분 has constant value ""Constant
요금제 선택 구분 has constant value ""Constant
요금제 시작 일자 has constant value ""Constant
스마트그리드 보급지원 계약 종료일자 has constant value ""Constant
스마트그리드 보급지원 계약 시작일자 is highly overall correlated with 등록일시 and 2 other fieldsHigh correlation
법정동 코드 is highly overall correlated with 등록일시 and 2 other fieldsHigh correlation
등록일시 is highly overall correlated with 수정일시 and 2 other fieldsHigh correlation
수정일시 is highly overall correlated with 등록일시 and 2 other fieldsHigh correlation
등록일시 is highly imbalanced (78.1%)Imbalance
수정일시 is highly imbalanced (78.1%)Imbalance
법정동 코드 is highly imbalanced (78.1%)Imbalance
스마트그리드 보급지원 계약 시작일자 is highly imbalanced (78.1%)Imbalance
수용가 번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 06:25:09.798719
Analysis finished2023-12-10 06:25:10.798676
Duration1 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

통합운영센터 번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
A000000003
200 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
A000000003 200
100.0%

Length

2023-12-10T15:25:10.943659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:11.134427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
a000000003 200
100.0%

수용가 번호
Text

UNIQUE 

Distinct200
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:25:11.443975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

Total characters3000
Distinct characters12
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

Unique200 ?
Unique (%)100.0%

Sample

1st rowSE0400112001204
2nd rowSE0400112001205
3rd rowSE0400112001404
4th rowSE0400112001504
5th rowSE0400112001704
ValueCountFrequency (%)
se0400112001204 1
 
0.5%
se0500105002202 1
 
0.5%
se0500106001001 1
 
0.5%
se0500105001402 1
 
0.5%
se0500105001403 1
 
0.5%
se0500105001501 1
 
0.5%
se0500105001503 1
 
0.5%
se0500105001604 1
 
0.5%
se0500105001701 1
 
0.5%
se0500105001902 1
 
0.5%
Other values (190) 190
95.0%
2023-12-10T15:25:12.044312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1492
49.7%
1 390
 
13.0%
5 247
 
8.2%
S 200
 
6.7%
E 200
 
6.7%
2 132
 
4.4%
4 107
 
3.6%
3 101
 
3.4%
8 54
 
1.8%
6 33
 
1.1%
Other values (2) 44
 
1.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2600
86.7%
Uppercase Letter 400
 
13.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1492
57.4%
1 390
 
15.0%
5 247
 
9.5%
2 132
 
5.1%
4 107
 
4.1%
3 101
 
3.9%
8 54
 
2.1%
6 33
 
1.3%
7 27
 
1.0%
9 17
 
0.7%
Uppercase Letter
ValueCountFrequency (%)
S 200
50.0%
E 200
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2600
86.7%
Latin 400
 
13.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1492
57.4%
1 390
 
15.0%
5 247
 
9.5%
2 132
 
5.1%
4 107
 
4.1%
3 101
 
3.9%
8 54
 
2.1%
6 33
 
1.3%
7 27
 
1.0%
9 17
 
0.7%
Latin
ValueCountFrequency (%)
S 200
50.0%
E 200
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1492
49.7%
1 390
 
13.0%
5 247
 
8.2%
S 200
 
6.7%
E 200
 
6.7%
2 132
 
4.4%
4 107
 
3.6%
3 101
 
3.4%
8 54
 
1.8%
6 33
 
1.1%
Other values (2) 44
 
1.5%

스마트그리드 보급지원 계약 상태코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
200 

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 200
100.0%

Length

2023-12-10T15:25:12.271241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:12.432229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 200
100.0%

등록일시
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20170927112506
193 
20170825142354
 
7

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20170927112506 193
96.5%
20170825142354 7
 
3.5%

Length

2023-12-10T15:25:12.607539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:12.761030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20170927112506 193
96.5%
20170825142354 7
 
3.5%

수정일시
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20170927112506
193 
20170825142354
 
7

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20170927112506 193
96.5%
20170825142354 7
 
3.5%

Length

2023-12-10T15:25:12.940053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:13.106302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20170927112506 193
96.5%
20170825142354 7
 
3.5%

적재일시
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20200227154311
200 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20200227154311 200
100.0%

Length

2023-12-10T15:25:13.288136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:13.805377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20200227154311 200
100.0%

수용가 타입 번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
AP
200 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
AP 200
100.0%

Length

2023-12-10T15:25:13.989921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:14.166521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
ap 200
100.0%

법정동 코드
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1126010400
193 
1129013700
 
7

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1126010400 193
96.5%
1129013700 7
 
3.5%

Length

2023-12-10T15:25:14.342201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:14.523263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1126010400 193
96.5%
1129013700 7
 
3.5%

요금제
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
100 주택용전력
200 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row100 주택용전력
2nd row100 주택용전력
3rd row100 주택용전력
4th row100 주택용전력
5th row100 주택용전력

Common Values

ValueCountFrequency (%)
100 주택용전력 200
100.0%

Length

2023-12-10T15:25:14.714948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:14.918243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
100 200
50.0%
주택용전력 200
50.0%

요금제 전압 구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
주택용고압
200 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주택용고압
2nd row주택용고압
3rd row주택용고압
4th row주택용고압
5th row주택용고압

Common Values

ValueCountFrequency (%)
주택용고압 200
100.0%

Length

2023-12-10T15:25:15.098368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:15.262937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주택용고압 200
100.0%

요금제 선택 구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
4 단일계약아파트
200 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4 단일계약아파트
2nd row4 단일계약아파트
3rd row4 단일계약아파트
4th row4 단일계약아파트
5th row4 단일계약아파트

Common Values

ValueCountFrequency (%)
4 단일계약아파트 200
100.0%

Length

2023-12-10T15:25:15.432779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:15.574906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
4 200
50.0%
단일계약아파트 200
50.0%

요금제 시작 일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
200 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
200
100.0%

Length

2023-12-10T15:25:15.733660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:15.898644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
No values found.

스마트그리드 보급지원 계약 시작일자
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20170515
193 
20170427
 
7

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20170515 193
96.5%
20170427 7
 
3.5%

Length

2023-12-10T15:25:16.087355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:16.254863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20170515 193
96.5%
20170427 7
 
3.5%

스마트그리드 보급지원 계약 종료일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20251231
200 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20251231 200
100.0%

Length

2023-12-10T15:25:16.452316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:25:16.703645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20251231 200
100.0%

Correlations

2023-12-10T15:25:16.827537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록일시수정일시법정동 코드스마트그리드 보급지원 계약 시작일자
등록일시1.0000.9930.9930.993
수정일시0.9931.0000.9930.993
법정동 코드0.9930.9931.0000.993
스마트그리드 보급지원 계약 시작일자0.9930.9930.9931.000
2023-12-10T15:25:17.011905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
스마트그리드 보급지원 계약 시작일자법정동 코드등록일시수정일시
스마트그리드 보급지원 계약 시작일자1.0000.9260.9260.926
법정동 코드0.9261.0000.9260.926
등록일시0.9260.9261.0000.926
수정일시0.9260.9260.9261.000
2023-12-10T15:25:17.194620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록일시수정일시법정동 코드스마트그리드 보급지원 계약 시작일자
등록일시1.0000.9260.9260.926
수정일시0.9261.0000.9260.926
법정동 코드0.9260.9261.0000.926
스마트그리드 보급지원 계약 시작일자0.9260.9260.9261.000

Missing values

2023-12-10T15:25:10.316228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:25:10.665023image/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

통합운영센터 번호수용가 번호스마트그리드 보급지원 계약 상태코드등록일시수정일시적재일시수용가 타입 번호법정동 코드요금제요금제 전압 구분요금제 선택 구분요금제 시작 일자스마트그리드 보급지원 계약 시작일자스마트그리드 보급지원 계약 종료일자
0A000000003SE04001120012041201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
1A000000003SE04001120012051201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
2A000000003SE04001120014041201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
3A000000003SE04001120015041201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
4A000000003SE04001120017041201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
5A000000003SE04001120017051201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
6A000000003SE04001120018041201708251423542017082514235420200227154311AP1129013700100 주택용전력주택용고압4 단일계약아파트2017042720251231
7A000000003SE05001010001031201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
8A000000003SE05001010002011201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
9A000000003SE05001010002021201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
통합운영센터 번호수용가 번호스마트그리드 보급지원 계약 상태코드등록일시수정일시적재일시수용가 타입 번호법정동 코드요금제요금제 전압 구분요금제 선택 구분요금제 시작 일자스마트그리드 보급지원 계약 시작일자스마트그리드 보급지원 계약 종료일자
190A000000003SE05001080017031201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
191A000000003SE05001080017041201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
192A000000003SE05001080019031201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
193A000000003SE05001080019041201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
194A000000003SE05001080020011201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
195A000000003SE05001080020041201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
196A000000003SE05001080021011201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
197A000000003SE05001080021041201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
198A000000003SE05001080022041201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231
199A000000003SE05001080023011201709271125062017092711250620200227154311AP1126010400100 주택용전력주택용고압4 단일계약아파트2017051520251231