Overview

Dataset statistics

Number of variables7
Number of observations1688
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory95.7 KiB
Average record size in memory58.1 B

Variable types

Numeric2
Categorical5

Dataset

Description경기도 의정부시 국민기초생활 수급자 동별 현황(연도, 시도, 시군구, 읍면동, 자격, 연령구간, 수급권자수) 입니다. 의정부시의 기초생계급여, 기초의료급여, 기초주거급여, 기초교육급여 별로 확인 가능합니다.
URLhttps://www.data.go.kr/data/15114170/fileData.do

Alerts

시도 has constant value ""Constant
시군구 has constant value ""Constant
수급권자수 has 381 (22.6%) zerosZeros

Reproduction

Analysis started2023-12-12 12:39:32.478053
Analysis finished2023-12-12 12:39:33.580218
Duration1.1 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Real number (ℝ)

Distinct8
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018.5
Minimum2015
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.0 KiB
2023-12-12T21:39:33.636980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2015
5-th percentile2015
Q12016.75
median2018.5
Q32020.25
95-th percentile2022
Maximum2022
Range7
Interquartile range (IQR)3.5

Descriptive statistics

Standard deviation2.2919668
Coefficient of variation (CV)0.0011354802
Kurtosis-1.2382075
Mean2018.5
Median Absolute Deviation (MAD)2
Skewness0
Sum3407228
Variance5.253112
MonotonicityIncreasing
2023-12-12T21:39:34.132598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2015 211
12.5%
2016 211
12.5%
2017 211
12.5%
2018 211
12.5%
2019 211
12.5%
2020 211
12.5%
2021 211
12.5%
2022 211
12.5%
ValueCountFrequency (%)
2015 211
12.5%
2016 211
12.5%
2017 211
12.5%
2018 211
12.5%
2019 211
12.5%
2020 211
12.5%
2021 211
12.5%
2022 211
12.5%
ValueCountFrequency (%)
2022 211
12.5%
2021 211
12.5%
2020 211
12.5%
2019 211
12.5%
2018 211
12.5%
2017 211
12.5%
2016 211
12.5%
2015 211
12.5%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size13.3 KiB
경기도
1688 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 1688
100.0%

Length

2023-12-12T21:39:34.283749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:39:34.422519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 1688
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size13.3 KiB
의정부시
1688 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의정부시
2nd row의정부시
3rd row의정부시
4th row의정부시
5th row의정부시

Common Values

ValueCountFrequency (%)
의정부시 1688
100.0%

Length

2023-12-12T21:39:34.549606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:39:34.682941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의정부시 1688
100.0%

읍면동
Categorical

Distinct19
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size13.3 KiB
장암동
 
96
가능1동
 
96
송산1동
 
88
의정부2동
 
88
의정부3동
 
88
Other values (14)
1232 

Length

Max length5
Median length4
Mean length3.8909953
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의정부시
2nd row의정부시
3rd row의정부시
4th row의정부시
5th row의정부시

Common Values

ValueCountFrequency (%)
장암동 96
 
5.7%
가능1동 96
 
5.7%
송산1동 88
 
5.2%
의정부2동 88
 
5.2%
의정부3동 88
 
5.2%
호원1동 88
 
5.2%
호원2동 88
 
5.2%
신곡1동 88
 
5.2%
신곡2동 88
 
5.2%
의정부1동 88
 
5.2%
Other values (9) 792
46.9%

Length

2023-12-12T21:39:34.816010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
장암동 96
 
5.7%
가능1동 96
 
5.7%
송산3동 88
 
5.2%
의정부시 88
 
5.2%
송산2동 88
 
5.2%
흥선동 88
 
5.2%
가능3동 88
 
5.2%
가능2동 88
 
5.2%
가능동 88
 
5.2%
자금동 88
 
5.2%
Other values (9) 792
46.9%

자격
Categorical

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size13.3 KiB
기초생계급여
457 
기초의료급여
456 
기초주거급여
456 
기초교육급여
319 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기초생계급여
2nd row기초생계급여
3rd row기초생계급여
4th row기초의료급여
5th row기초의료급여

Common Values

ValueCountFrequency (%)
기초생계급여 457
27.1%
기초의료급여 456
27.0%
기초주거급여 456
27.0%
기초교육급여 319
18.9%

Length

2023-12-12T21:39:34.977898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:39:35.099291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기초생계급여 457
27.1%
기초의료급여 456
27.0%
기초주거급여 456
27.0%
기초교육급여 319
18.9%

연령구간
Categorical

Distinct3
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size13.3 KiB
18세미만
608 
18~64세
608 
65세이상
472 

Length

Max length6
Median length5
Mean length5.3601896
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row18세미만
2nd row18~64세
3rd row65세이상
4th row18세미만
5th row18~64세

Common Values

ValueCountFrequency (%)
18세미만 608
36.0%
18~64세 608
36.0%
65세이상 472
28.0%

Length

2023-12-12T21:39:35.233479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:39:35.366552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
18세미만 608
36.0%
18~64세 608
36.0%
65세이상 472
28.0%

수급권자수
Real number (ℝ)

ZEROS 

Distinct369
Distinct (%)21.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean86.492891
Minimum0
Maximum790
Zeros381
Zeros (%)22.6%
Negative0
Negative (%)0.0%
Memory size15.0 KiB
2023-12-12T21:39:35.524122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median28
Q3107
95-th percentile404.65
Maximum790
Range790
Interquartile range (IQR)105

Descriptive statistics

Standard deviation131.63537
Coefficient of variation (CV)1.5219212
Kurtosis4.5025753
Mean86.492891
Median Absolute Deviation (MAD)28
Skewness2.1676128
Sum146000
Variance17327.87
MonotonicityNot monotonic
2023-12-12T21:39:35.681321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 381
 
22.6%
1 28
 
1.7%
11 24
 
1.4%
7 24
 
1.4%
12 23
 
1.4%
5 23
 
1.4%
8 22
 
1.3%
10 21
 
1.2%
18 19
 
1.1%
16 19
 
1.1%
Other values (359) 1104
65.4%
ValueCountFrequency (%)
0 381
22.6%
1 28
 
1.7%
2 17
 
1.0%
3 16
 
0.9%
4 14
 
0.8%
5 23
 
1.4%
6 16
 
0.9%
7 24
 
1.4%
8 22
 
1.3%
9 16
 
0.9%
ValueCountFrequency (%)
790 1
0.1%
723 1
0.1%
713 1
0.1%
662 1
0.1%
653 2
0.1%
648 1
0.1%
627 1
0.1%
618 1
0.1%
609 1
0.1%
599 1
0.1%

Interactions

2023-12-12T21:39:32.960616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:39:32.726967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:39:33.163203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:39:32.846203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:39:35.795612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도읍면동자격연령구간수급권자수
연도1.0000.0000.0000.0000.081
읍면동0.0001.0000.0000.0000.367
자격0.0000.0001.0000.1810.493
연령구간0.0000.0000.1811.0000.337
수급권자수0.0810.3670.4930.3371.000
2023-12-12T21:39:35.927265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자격연령구간읍면동
자격1.0000.1720.000
연령구간0.1721.0000.000
읍면동0.0000.0001.000
2023-12-12T21:39:36.036807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도수급권자수읍면동자격연령구간
연도1.0000.0930.0000.0000.000
수급권자수0.0931.0000.1470.3150.214
읍면동0.0000.1471.0000.0000.000
자격0.0000.3150.0001.0000.172
연령구간0.0000.2140.0000.1721.000

Missing values

2023-12-12T21:39:33.377870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:39:33.512660image/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

연도시도시군구읍면동자격연령구간수급권자수
02015경기도의정부시의정부시기초생계급여18세미만138
12015경기도의정부시의정부시기초생계급여18~64세75
22015경기도의정부시의정부시기초생계급여65세이상247
32015경기도의정부시의정부시기초의료급여18세미만0
42015경기도의정부시의정부시기초의료급여18~64세0
52015경기도의정부시의정부시기초의료급여65세이상8
62015경기도의정부시의정부시기초주거급여18세미만0
72015경기도의정부시의정부시기초주거급여18~64세0
82015경기도의정부시의정부시기초주거급여65세이상0
92015경기도의정부시의정부시기초교육급여18세미만2
연도시도시군구읍면동자격연령구간수급권자수
16782022경기도의정부시녹양동기초생계급여18~64세294
16792022경기도의정부시녹양동기초생계급여65세이상356
16802022경기도의정부시녹양동기초의료급여18세미만18
16812022경기도의정부시녹양동기초의료급여18~64세59
16822022경기도의정부시녹양동기초의료급여65세이상24
16832022경기도의정부시녹양동기초주거급여18세미만99
16842022경기도의정부시녹양동기초주거급여18~64세258
16852022경기도의정부시녹양동기초주거급여65세이상162
16862022경기도의정부시녹양동기초교육급여18세미만42
16872022경기도의정부시녹양동기초교육급여18~64세8