Overview

Dataset statistics

Number of variables6
Number of observations132
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.7 KiB
Average record size in memory52.0 B

Variable types

Categorical4
Numeric2

Dataset

Description사회보장정보시스템(행복e음)에 등록된 기초생활보장, 기초(노령)연금, 장애인연금 수급자의 급여지급 현황을 지역별로 집계한 통계데이터
URLhttps://www.data.go.kr/data/15062447/fileData.do

Alerts

기준년월 has constant value ""Constant
서비스 is highly overall correlated with 자격High correlation
자격 is highly overall correlated with 서비스High correlation
지급건수 is highly overall correlated with 지급금액High correlation
지급금액 is highly overall correlated with 지급건수High correlation
지급금액 has 5 (3.8%) zerosZeros

Reproduction

Analysis started2023-12-12 14:35:29.028649
Analysis finished2023-12-12 14:35:29.926344
Duration0.9 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자격
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
기초생활보장
98 
장애인복지
17 
기초연금
17 

Length

Max length6
Median length6
Mean length5.6136364
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기초생활보장
2nd row기초생활보장
3rd row기초생활보장
4th row기초생활보장
5th row기초생활보장

Common Values

ValueCountFrequency (%)
기초생활보장 98
74.2%
장애인복지 17
 
12.9%
기초연금 17
 
12.9%

Length

2023-12-12T23:35:30.002087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:35:30.127127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기초생활보장 98
74.2%
장애인복지 17
 
12.9%
기초연금 17
 
12.9%

서비스
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
생계급여(일반)
17 
주거급여
17 
생계급여(시설)
17 
장제급여
17 
장애인연금
17 
Other values (4)
47 

Length

Max length12
Median length4
Mean length5.8863636
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생계급여(일반)
2nd row생계급여(일반)
3rd row생계급여(일반)
4th row생계급여(일반)
5th row생계급여(일반)

Common Values

ValueCountFrequency (%)
생계급여(일반) 17
12.9%
주거급여 17
12.9%
생계급여(시설) 17
12.9%
장제급여 17
12.9%
장애인연금 17
12.9%
기초연금 17
12.9%
해산급여 16
12.1%
사할린한인(특별지원금) 10
7.6%
생계급여(긴급) 4
 
3.0%

Length

2023-12-12T23:35:30.278800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:35:30.428124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생계급여(일반 17
12.9%
주거급여 17
12.9%
생계급여(시설 17
12.9%
장제급여 17
12.9%
장애인연금 17
12.9%
기초연금 17
12.9%
해산급여 16
12.1%
사할린한인(특별지원금 10
7.6%
생계급여(긴급 4
 
3.0%

기준년월
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
202212
132 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
202212 132
100.0%

Length

2023-12-12T23:35:30.929744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:35:31.019524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202212 132
100.0%

시도
Categorical

Distinct17
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
서울특별시
9 
강원도
9 
인천광역시
9 
충청북도
 
8
대구광역시
 
8
Other values (12)
89 

Length

Max length7
Median length5
Mean length4.5909091
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시
2nd row부산광역시
3rd row대구광역시
4th row인천광역시
5th row광주광역시

Common Values

ValueCountFrequency (%)
서울특별시 9
 
6.8%
강원도 9
 
6.8%
인천광역시 9
 
6.8%
충청북도 8
 
6.1%
대구광역시 8
 
6.1%
울산광역시 8
 
6.1%
경기도 8
 
6.1%
충청남도 8
 
6.1%
경상북도 8
 
6.1%
경상남도 8
 
6.1%
Other values (7) 49
37.1%

Length

2023-12-12T23:35:31.119735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 9
 
6.8%
인천광역시 9
 
6.8%
강원도 9
 
6.8%
충청남도 8
 
6.1%
부산광역시 8
 
6.1%
경상남도 8
 
6.1%
경상북도 8
 
6.1%
경기도 8
 
6.1%
울산광역시 8
 
6.1%
대구광역시 8
 
6.1%
Other values (7) 49
37.1%

지급건수
Real number (ℝ)

HIGH CORRELATION 

Distinct121
Distinct (%)91.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean78656.591
Minimum1
Maximum1239646
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T23:35:31.263844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.55
Q1210.75
median9242.5
Q371938.75
95-th percentile395062.4
Maximum1239646
Range1239645
Interquartile range (IQR)71728

Descriptive statistics

Standard deviation168092.9
Coefficient of variation (CV)2.1370478
Kurtosis21.337781
Mean78656.591
Median Absolute Deviation (MAD)9240.5
Skewness4.0845215
Sum10382670
Variance2.8255222 × 1010
MonotonicityNot monotonic
2023-12-12T23:35:31.436098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 4
 
3.0%
9 3
 
2.3%
2 3
 
2.3%
8 2
 
1.5%
7 2
 
1.5%
10 2
 
1.5%
11 2
 
1.5%
318281 1
 
0.8%
119 1
 
0.8%
71 1
 
0.8%
Other values (111) 111
84.1%
ValueCountFrequency (%)
1 4
3.0%
2 3
2.3%
3 1
 
0.8%
5 1
 
0.8%
7 2
1.5%
8 2
1.5%
9 3
2.3%
10 2
1.5%
11 2
1.5%
13 1
 
0.8%
ValueCountFrequency (%)
1239646 1
0.8%
909395 1
0.8%
511900 1
0.8%
472345 1
0.8%
469105 1
0.8%
467420 1
0.8%
431512 1
0.8%
365240 1
0.8%
334978 1
0.8%
318281 1
0.8%

지급금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct116
Distinct (%)87.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19417.689
Minimum0
Maximum342033
Zeros5
Zeros (%)3.8%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T23:35:31.568192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.55
Q195.75
median1835
Q316201.75
95-th percentile91182.85
Maximum342033
Range342033
Interquartile range (IQR)16106

Descriptive statistics

Standard deviation45308.388
Coefficient of variation (CV)2.3333563
Kurtosis24.219973
Mean19417.689
Median Absolute Deviation (MAD)1834.5
Skewness4.3729751
Sum2563135
Variance2.05285 × 109
MonotonicityNot monotonic
2023-12-12T23:35:31.776475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 5
 
3.8%
6 3
 
2.3%
9 3
 
2.3%
3 3
 
2.3%
7 3
 
2.3%
5 2
 
1.5%
4 2
 
1.5%
1 2
 
1.5%
2 2
 
1.5%
342 1
 
0.8%
Other values (106) 106
80.3%
ValueCountFrequency (%)
0 5
3.8%
1 2
 
1.5%
2 2
 
1.5%
3 3
2.3%
4 2
 
1.5%
5 2
 
1.5%
6 3
2.3%
7 3
2.3%
8 1
 
0.8%
9 3
2.3%
ValueCountFrequency (%)
342033 1
0.8%
251126 1
0.8%
139346 1
0.8%
128240 1
0.8%
127471 1
0.8%
100672 1
0.8%
92059 1
0.8%
90466 1
0.8%
87201 1
0.8%
84786 1
0.8%

Interactions

2023-12-12T23:35:29.519681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:35:29.295699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:35:29.627203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:35:29.409924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:35:31.891258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자격서비스시도지급건수지급금액
자격1.0001.0000.0000.6040.603
서비스1.0001.0000.0000.4330.407
시도0.0000.0001.0000.0000.000
지급건수0.6040.4330.0001.0000.992
지급금액0.6030.4070.0000.9921.000
2023-12-12T23:35:31.990657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
서비스시도자격
서비스1.0000.0000.976
시도0.0001.0000.000
자격0.9760.0001.000
2023-12-12T23:35:32.085233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지급건수지급금액자격서비스시도
지급건수1.0000.9760.4900.2420.000
지급금액0.9761.0000.4890.2250.000
자격0.4900.4891.0000.9760.000
서비스0.2420.2250.9761.0000.000
시도0.0000.0000.0000.0001.000

Missing values

2023-12-12T23:35:29.769560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:35:29.880276image/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기초생활보장생계급여(일반)202212서울특별시20373390466
1기초생활보장생계급여(일반)202212부산광역시11699452028
2기초생활보장생계급여(일반)202212대구광역시7162932555
3기초생활보장생계급여(일반)202212인천광역시7286834834
4기초생활보장생계급여(일반)202212광주광역시3944219123
5기초생활보장생계급여(일반)202212대전광역시3505216747
6기초생활보장생계급여(일반)202212울산광역시174467596
7기초생활보장생계급여(일반)202212세종특별자치시28711279
8기초생활보장생계급여(일반)202212경기도18588582844
9기초생활보장생계급여(일반)202212강원도4099617896
자격서비스기준년월시도지급건수지급금액
122기초연금기초연금202212세종특별자치시225856193
123기초연금기초연금202212경기도1239646342033
124기초연금기초연금202212강원도24271166632
125기초연금기초연금202212충청북도22619761889
126기초연금기초연금202212충청남도31828187201
127기초연금기초연금202212전라북도30876784786
128기초연금기초연금202212전라남도365240100672
129기초연금기초연금202212경상북도467420127471
130기초연금기초연금202212경상남도469105128240
131기초연금기초연금202212제주특별자치도7091419881