Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.5 KiB
Average record size in memory66.3 B

Variable types

Categorical6
Numeric1
Text1

Alerts

전망월 has constant value ""Constant
수원_취수구분 has constant value ""Constant
전망1월 has constant value ""Constant
전망2월 has constant value ""Constant
전망3월 has constant value ""Constant
등록일자 has constant value ""Constant
행정동코드 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:34:27.637070
Analysis finished2023-12-10 10:34:29.601387
Duration1.96 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

전망월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2021-02
100 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02
2nd row2021-02
3rd row2021-02
4th row2021-02
5th row2021-02

Common Values

ValueCountFrequency (%)
2021-02 100
100.0%

Length

2023-12-10T19:34:29.825056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:34:30.077144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02 100
100.0%

행정동코드
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1181591 × 109
Minimum1.1110515 × 109
Maximum1.1260575 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:34:30.360933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.1110515 × 109
5-th percentile1.111057 × 109
Q11.1140622 × 109
median1.1200538 × 109
Q31.1215832 × 109
95-th percentile1.1260521 × 109
Maximum1.1260575 × 109
Range15006000
Interquartile range (IQR)7521000

Descriptive statistics

Standard deviation4579004.6
Coefficient of variation (CV)0.0040951278
Kurtosis-1.1130102
Mean1.1181591 × 109
Median Absolute Deviation (MAD)3002500
Skewness-0.19411777
Sum1.1181591 × 1011
Variance2.0967283 × 1013
MonotonicityNot monotonic
2023-12-10T19:34:30.726382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1111053000 1
 
1.0%
1121571000 1
 
1.0%
1121584000 1
 
1.0%
1121583000 1
 
1.0%
1121582000 1
 
1.0%
1121581000 1
 
1.0%
1121578000 1
 
1.0%
1121577000 1
 
1.0%
1121576000 1
 
1.0%
1121575000 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1111051500 1
1.0%
1111053000 1
1.0%
1111054000 1
1.0%
1111055000 1
1.0%
1111056000 1
1.0%
1111057000 1
1.0%
1111058000 1
1.0%
1111060000 1
1.0%
1111061500 1
1.0%
1111063000 1
1.0%
ValueCountFrequency (%)
1126057500 1
1.0%
1126057000 1
1.0%
1126056500 1
1.0%
1126055000 1
1.0%
1126054000 1
1.0%
1126052000 1
1.0%
1123075000 1
1.0%
1123074000 1
1.0%
1123073000 1
1.0%
1123072000 1
1.0%

주소
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T19:34:31.192410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length15
Mean length11.9
Min length9

Characters and Unicode

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

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row서울특별시종로구사직동
2nd row서울특별시종로구삼청동
3rd row서울특별시종로구부암동
4th row서울특별시종로구평창동
5th row서울특별시종로구무악동
ValueCountFrequency (%)
서울특별시종로구사직동 1
 
1.0%
서울특별시성동구송정동 1
 
1.0%
서울특별시광진구자양2동 1
 
1.0%
서울특별시광진구자양1동 1
 
1.0%
서울특별시광진구광장동 1
 
1.0%
서울특별시광진구능동 1
 
1.0%
서울특별시광진구중곡4동 1
 
1.0%
서울특별시광진구중곡3동 1
 
1.0%
서울특별시광진구중곡2동 1
 
1.0%
서울특별시광진구중곡1동 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T19:34:31.840704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 132
 
11.1%
구 104
 
8.7%
서 101
 
8.5%
특 100
 
8.4%
별 100
 
8.4%
시 100
 
8.4%
울 100
 
8.4%
중 26
 
2.2%
로 23
 
1.9%
2 22
 
1.8%
Other values (100) 382
32.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1123
94.4%
Decimal Number 61
 
5.1%
Other Punctuation 6
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 132
11.8%
구 104
 
9.3%
서 101
 
9.0%
특 100
 
8.9%
별 100
 
8.9%
시 100
 
8.9%
울 100
 
8.9%
중 26
 
2.3%
로 23
 
2.0%
성 21
 
1.9%
Other values (91) 316
28.1%
Decimal Number
ValueCountFrequency (%)
2 22
36.1%
1 20
32.8%
3 8
 
13.1%
4 5
 
8.2%
5 3
 
4.9%
7 1
 
1.6%
8 1
 
1.6%
6 1
 
1.6%
Other Punctuation
ValueCountFrequency (%)
· 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1123
94.4%
Common 67
 
5.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 132
11.8%
구 104
 
9.3%
서 101
 
9.0%
특 100
 
8.9%
별 100
 
8.9%
시 100
 
8.9%
울 100
 
8.9%
중 26
 
2.3%
로 23
 
2.0%
성 21
 
1.9%
Other values (91) 316
28.1%
Common
ValueCountFrequency (%)
2 22
32.8%
1 20
29.9%
3 8
 
11.9%
· 6
 
9.0%
4 5
 
7.5%
5 3
 
4.5%
7 1
 
1.5%
8 1
 
1.5%
6 1
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1123
94.4%
ASCII 61
 
5.1%
None 6
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 132
11.8%
구 104
 
9.3%
서 101
 
9.0%
특 100
 
8.9%
별 100
 
8.9%
시 100
 
8.9%
울 100
 
8.9%
중 26
 
2.3%
로 23
 
2.0%
성 21
 
1.9%
Other values (91) 316
28.1%
ASCII
ValueCountFrequency (%)
2 22
36.1%
1 20
32.8%
3 8
 
13.1%
4 5
 
8.2%
5 3
 
4.9%
7 1
 
1.6%
8 1
 
1.6%
6 1
 
1.6%
None
ValueCountFrequency (%)
· 6
100.0%

수원_취수구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
수원
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
수원 100
100.0%

Length

2023-12-10T19:34:32.090355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:34:32.265403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수원 100
100.0%

전망1월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
정상
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
정상 100
100.0%

Length

2023-12-10T19:34:32.449881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:34:32.719717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

전망2월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
정상
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
정상 100
100.0%

Length

2023-12-10T19:34:32.958472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:34:33.178121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

전망3월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
정상
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
정상 100
100.0%

Length

2023-12-10T19:34:33.500950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:34:33.763624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

등록일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2021-02-18
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-02-18
2nd row2021-02-18
3rd row2021-02-18
4th row2021-02-18
5th row2021-02-18

Common Values

ValueCountFrequency (%)
2021-02-18 100
100.0%

Length

2023-12-10T19:34:34.089633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:34:34.289499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-02-18 100
100.0%

Interactions

2023-12-10T19:34:28.207156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:34:34.423040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드주소
행정동코드1.0001.000
주소1.0001.000

Missing values

2023-12-10T19:34:29.194364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:34:29.506675image/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월전망2월전망3월등록일자
02021-021111053000서울특별시종로구사직동수원정상정상정상2021-02-18
12021-021111054000서울특별시종로구삼청동수원정상정상정상2021-02-18
22021-021111055000서울특별시종로구부암동수원정상정상정상2021-02-18
32021-021111056000서울특별시종로구평창동수원정상정상정상2021-02-18
42021-021111057000서울특별시종로구무악동수원정상정상정상2021-02-18
52021-021111058000서울특별시종로구교남동수원정상정상정상2021-02-18
62021-021111060000서울특별시종로구가회동수원정상정상정상2021-02-18
72021-021111061500서울특별시종로구종로1·2·3·4가동수원정상정상정상2021-02-18
82021-021111063000서울특별시종로구종로5·6가동수원정상정상정상2021-02-18
92021-021111064000서울특별시종로구이화동수원정상정상정상2021-02-18
전망월행정동코드주소수원_취수구분전망1월전망2월전망3월등록일자
902021-021123073000서울특별시동대문구휘경2동수원정상정상정상2021-02-18
912021-021123074000서울특별시동대문구이문1동수원정상정상정상2021-02-18
922021-021123075000서울특별시동대문구이문2동수원정상정상정상2021-02-18
932021-021126052000서울특별시중랑구면목2동수원정상정상정상2021-02-18
942021-021126054000서울특별시중랑구면목4동수원정상정상정상2021-02-18
952021-021126055000서울특별시중랑구면목5동수원정상정상정상2021-02-18
962021-021126056500서울특별시중랑구면목본동수원정상정상정상2021-02-18
972021-021126057000서울특별시중랑구면목7동수원정상정상정상2021-02-18
982021-021126057500서울특별시중랑구면목3·8동수원정상정상정상2021-02-18
992021-021111051500서울특별시종로구청운효자동수원정상정상정상2021-02-18