Overview

Dataset statistics

Number of variables5
Number of observations553
Missing cells67
Missing cells (%)2.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory22.3 KiB
Average record size in memory41.2 B

Variable types

Categorical3
Numeric1
DateTime1

Dataset

Description서울특별시 동작구 통장 위촉 현황 정보(동별, 통별 통장 위촉일)에 대한 정보를 제공합니다.*제공부서 : 동작구 행정자치국 행정자치과
Author서울특별시 동작구
URLhttps://www.data.go.kr/data/15114601/fileData.do

Alerts

기준일자 has constant value ""Constant
동명 is highly overall correlated with 비고 High correlation
비고 is highly overall correlated with 동명High correlation
비고 is highly imbalanced (59.0%)Imbalance
위촉일 has 67 (12.1%) missing valuesMissing

Reproduction

Analysis started2024-04-13 11:16:12.479533
Analysis finished2024-04-13 11:16:14.772401
Duration2.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

동명
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
흑석동
68 
노량진제1동
55 
상도제1동
45 
사당제2동
44 
대방동
43 
Other values (10)
298 

Length

Max length6
Median length5
Mean length4.8517179
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row노량진제1동
2nd row노량진제1동
3rd row노량진제1동
4th row노량진제1동
5th row노량진제1동

Common Values

ValueCountFrequency (%)
흑석동 68
12.3%
노량진제1동 55
9.9%
상도제1동 45
 
8.1%
사당제2동 44
 
8.0%
대방동 43
 
7.8%
상도제2동 39
 
7.1%
사당제3동 38
 
6.9%
신대방제1동 38
 
6.9%
상도제4동 35
 
6.3%
사당제1동 32
 
5.8%
Other values (5) 116
21.0%

Length

2024-04-13T20:16:15.011774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
흑석동 68
12.3%
노량진제1동 55
9.9%
상도제1동 45
 
8.1%
사당제2동 44
 
8.0%
대방동 43
 
7.8%
상도제2동 39
 
7.1%
사당제3동 38
 
6.9%
신대방제1동 38
 
6.9%
상도제4동 35
 
6.3%
사당제1동 32
 
5.8%
Other values (5) 116
21.0%

통번
Real number (ℝ)

Distinct68
Distinct (%)12.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.16094
Minimum1
Maximum68
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.0 KiB
2024-04-13T20:16:15.447920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q110
median19
Q330
95-th percentile48
Maximum68
Range67
Interquartile range (IQR)20

Descriptive statistics

Standard deviation14.293677
Coefficient of variation (CV)0.67547456
Kurtosis0.21904345
Mean21.16094
Median Absolute Deviation (MAD)10
Skewness0.76741193
Sum11702
Variance204.3092
MonotonicityNot monotonic
2024-04-13T20:16:15.892593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 15
 
2.7%
10 15
 
2.7%
18 15
 
2.7%
16 15
 
2.7%
15 15
 
2.7%
14 15
 
2.7%
13 15
 
2.7%
12 15
 
2.7%
11 15
 
2.7%
17 15
 
2.7%
Other values (58) 403
72.9%
ValueCountFrequency (%)
1 15
2.7%
2 15
2.7%
3 15
2.7%
4 15
2.7%
5 15
2.7%
6 15
2.7%
7 15
2.7%
8 15
2.7%
9 15
2.7%
10 15
2.7%
ValueCountFrequency (%)
68 1
0.2%
67 1
0.2%
66 1
0.2%
65 1
0.2%
64 1
0.2%
63 1
0.2%
62 1
0.2%
61 1
0.2%
60 1
0.2%
59 1
0.2%

위촉일
Date

MISSING 

Distinct105
Distinct (%)21.6%
Missing67
Missing (%)12.1%
Memory size4.4 KiB
Minimum2021-08-01 00:00:00
Maximum2024-04-10 00:00:00
2024-04-13T20:16:16.274111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-13T20:16:16.506660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2024-03-31
553 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-31
2nd row2024-03-31
3rd row2024-03-31
4th row2024-03-31
5th row2024-03-31

Common Values

ValueCountFrequency (%)
2024-03-31 553
100.0%

Length

2024-04-13T20:16:16.786950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T20:16:17.075149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-31 553
100.0%

비고
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
<NA>
486 
공석
 
40
통없음
 
27

Length

Max length4
Median length4
Mean length3.8065099
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 486
87.9%
공석 40
 
7.2%
통없음 27
 
4.9%

Length

2024-04-13T20:16:17.496011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-13T20:16:17.834928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 486
87.9%
공석 40
 
7.2%
통없음 27
 
4.9%

Interactions

2024-04-13T20:16:13.953733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-13T20:16:18.034384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
동명통번비고
동명1.0000.4110.768
통번0.4111.0000.000
비고0.7680.0001.000
2024-04-13T20:16:18.186826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비고동명
비고1.0000.563
동명0.5631.000
2024-04-13T20:16:18.416897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
통번동명비고
통번1.0000.1650.000
동명0.1651.0000.563
비고0.0000.5631.000

Missing values

2024-04-13T20:16:14.311665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-13T20:16:14.635946image/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

동명통번위촉일기준일자비고
0노량진제1동12024-01-152024-03-31<NA>
1노량진제1동22023-02-052024-03-31<NA>
2노량진제1동32023-11-152024-03-31<NA>
3노량진제1동42023-07-012024-03-31<NA>
4노량진제1동52024-02-012024-03-31<NA>
5노량진제1동62023-08-152024-03-31<NA>
6노량진제1동72022-06-162024-03-31<NA>
7노량진제1동82022-12-012024-03-31<NA>
8노량진제1동92022-07-012024-03-31<NA>
9노량진제1동102022-04-012024-03-31<NA>
동명통번위촉일기준일자비고
543흑석동59<NA>2024-03-31통없음
544흑석동60<NA>2024-03-31공석
545흑석동61<NA>2024-03-31공석
546흑석동62<NA>2024-03-31공석
547흑석동632022-04-182024-03-31<NA>
548흑석동642023-08-012024-03-31<NA>
549흑석동652022-07-082024-03-31<NA>
550흑석동662023-08-012024-03-31<NA>
551흑석동67<NA>2024-03-31통없음
552흑석동68<NA>2024-03-31통없음