Overview

Dataset statistics

Number of variables8
Number of observations2892
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory186.5 KiB
Average record size in memory66.0 B

Variable types

Numeric2
Categorical3
DateTime2
Text1

Dataset

Description대전광역시 서구 기초생활수급자 급여지원현황(지급분야명, 연월, 지급건수, 지급금액, 행정동명 등) 정보를 제공합니다.
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15113069/fileData.do

Alerts

시군구명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
순번 is highly overall correlated with 행정동명High correlation
행정동명 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique
지급금액(원) has 1133 (39.2%) zerosZeros

Reproduction

Analysis started2024-03-23 05:44:06.201526
Analysis finished2024-03-23 05:44:08.046635
Duration1.85 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2892
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1446.5
Minimum1
Maximum2892
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size25.5 KiB
2024-03-23T14:44:08.169239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile145.55
Q1723.75
median1446.5
Q32169.25
95-th percentile2747.45
Maximum2892
Range2891
Interquartile range (IQR)1445.5

Descriptive statistics

Standard deviation834.99281
Coefficient of variation (CV)0.57725048
Kurtosis-1.2
Mean1446.5
Median Absolute Deviation (MAD)723
Skewness0
Sum4183278
Variance697213
MonotonicityStrictly increasing
2024-03-23T14:44:08.427244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1923 1
 
< 0.1%
1925 1
 
< 0.1%
1926 1
 
< 0.1%
1927 1
 
< 0.1%
1928 1
 
< 0.1%
1929 1
 
< 0.1%
1930 1
 
< 0.1%
1931 1
 
< 0.1%
1932 1
 
< 0.1%
Other values (2882) 2882
99.7%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2892 1
< 0.1%
2891 1
< 0.1%
2890 1
< 0.1%
2889 1
< 0.1%
2888 1
< 0.1%
2887 1
< 0.1%
2886 1
< 0.1%
2885 1
< 0.1%
2884 1
< 0.1%
2883 1
< 0.1%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.7 KiB
서구
2892 

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 (%)
서구 2892
100.0%

Length

2024-03-23T14:44:08.699483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T14:44:08.877405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서구 2892
100.0%

행정동명
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size22.7 KiB
갈마1동
 
192
관저2동
 
180
월평1동
 
168
월평2동
 
156
탄방동
 
156
Other values (20)
2040 

Length

Max length4
Median length4
Mean length3.3983402
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
갈마1동 192
 
6.6%
관저2동 180
 
6.2%
월평1동 168
 
5.8%
월평2동 156
 
5.4%
탄방동 156
 
5.4%
도마1동 144
 
5.0%
정림동 144
 
5.0%
복수동 144
 
5.0%
서구 144
 
5.0%
용문동 132
 
4.6%
Other values (15) 1332
46.1%

Length

2024-03-23T14:44:09.266310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
갈마1동 192
 
6.6%
관저2동 180
 
6.2%
월평1동 168
 
5.8%
월평2동 156
 
5.4%
탄방동 156
 
5.4%
도마1동 144
 
5.0%
정림동 144
 
5.0%
복수동 144
 
5.0%
서구 144
 
5.0%
용문동 132
 
4.6%
Other values (15) 1332
46.1%

지급분야명
Categorical

Distinct16
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size22.7 KiB
기초생계급여(일반)
300 
기초주거급여(현금-월차임)
300 
기초주거급여(현금-보증금)
288 
기초생계_장제급여
276 
기초청년주거급여(현금-보증금)
264 
Other values (11)
1464 

Length

Max length21
Median length17
Mean length14.049793
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기초생계_장제급여
2nd row기초생계_장제급여
3rd row기초생계_장제급여
4th row기초생계_장제급여
5th row기초생계_장제급여

Common Values

ValueCountFrequency (%)
기초생계급여(일반) 300
10.4%
기초주거급여(현금-월차임) 300
10.4%
기초주거급여(현금-보증금) 288
10.0%
기초생계_장제급여 276
9.5%
기초청년주거급여(현금-보증금) 264
9.1%
기초청년주거급여(현금-월차임) 264
9.1%
기초의료급여(생계-시설)-월동대책비 228
7.9%
기초의료급여(생계-시설)-주,부식비 등 228
7.9%
기초의료급여(생계-시설)-특별위로금 228
7.9%
기초주거_장제급여 168
5.8%
Other values (6) 348
12.0%

Length

2024-03-23T14:44:09.521689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기초생계급여(일반 300
9.6%
기초주거급여(현금-월차임 300
9.6%
기초주거급여(현금-보증금 288
9.2%
기초생계_장제급여 276
8.8%
기초청년주거급여(현금-보증금 264
8.4%
기초청년주거급여(현금-월차임 264
8.4%
등 228
7.3%
기초의료급여(생계-시설)-특별위로금 228
7.3%
기초의료급여(생계-시설)-주,부식비 228
7.3%
기초의료급여(생계-시설)-월동대책비 228
7.3%
Other values (8) 528
16.9%

연월
Date

Distinct12
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size22.7 KiB
Minimum2023-01-01 00:00:00
Maximum2023-12-01 00:00:00
2024-03-23T14:44:09.684945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:44:10.018828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

지급건수(건)
Text

Distinct505
Distinct (%)17.5%
Missing0
Missing (%)0.0%
Memory size22.7 KiB
2024-03-23T14:44:10.578161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length1
Mean length1.6327801
Min length1

Characters and Unicode

Total characters4722
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique273 ?
Unique (%)9.4%

Sample

1st row0
2nd row1
3rd row3
4th row0
5th row0
ValueCountFrequency (%)
0 751
26.0%
1 488
16.9%
2 260
 
9.0%
3 155
 
5.4%
4 59
 
2.0%
6 57
 
2.0%
5 49
 
1.7%
7 37
 
1.3%
23 27
 
0.9%
24 27
 
0.9%
Other values (495) 982
34.0%
2024-03-23T14:44:11.463263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 960
20.3%
1 876
18.6%
2 668
14.1%
3 409
8.7%
6 366
 
7.8%
5 354
 
7.5%
7 308
 
6.5%
4 298
 
6.3%
8 254
 
5.4%
9 193
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4686
99.2%
Other Punctuation 36
 
0.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 960
20.5%
1 876
18.7%
2 668
14.3%
3 409
8.7%
6 366
 
7.8%
5 354
 
7.6%
7 308
 
6.6%
4 298
 
6.4%
8 254
 
5.4%
9 193
 
4.1%
Other Punctuation
ValueCountFrequency (%)
, 36
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4722
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 960
20.3%
1 876
18.6%
2 668
14.1%
3 409
8.7%
6 366
 
7.8%
5 354
 
7.5%
7 308
 
6.5%
4 298
 
6.3%
8 254
 
5.4%
9 193
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4722
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 960
20.3%
1 876
18.6%
2 668
14.1%
3 409
8.7%
6 366
 
7.8%
5 354
 
7.5%
7 308
 
6.5%
4 298
 
6.3%
8 254
 
5.4%
9 193
 
4.1%

지급금액(원)
Real number (ℝ)

ZEROS 

Distinct1113
Distinct (%)38.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28796800
Minimum-100000
Maximum7.4887271 × 108
Zeros1133
Zeros (%)39.2%
Negative1
Negative (%)< 0.1%
Memory size25.5 KiB
2024-03-23T14:44:11.749644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-100000
5-th percentile0
Q10
median303266
Q36445027.5
95-th percentile2.0221656 × 108
Maximum7.4887271 × 108
Range7.4897271 × 108
Interquartile range (IQR)6445027.5

Descriptive statistics

Standard deviation80853984
Coefficient of variation (CV)2.8077419
Kurtosis25.041511
Mean28796800
Median Absolute Deviation (MAD)303266
Skewness4.388547
Sum8.3280346 × 1010
Variance6.5373667 × 1015
MonotonicityNot monotonic
2024-03-23T14:44:12.047456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1133
39.2%
800000 106
 
3.7%
303266 61
 
2.1%
3340 52
 
1.8%
606532 38
 
1.3%
1600000 33
 
1.1%
700000 33
 
1.1%
2400000 21
 
0.7%
164000 20
 
0.7%
909798 16
 
0.6%
Other values (1103) 1379
47.7%
ValueCountFrequency (%)
-100000 1
 
< 0.1%
0 1133
39.2%
6 1
 
< 0.1%
1370 1
 
< 0.1%
1760 1
 
< 0.1%
2740 2
 
0.1%
3340 52
 
1.8%
4330 3
 
0.1%
6680 11
 
0.4%
7670 7
 
0.2%
ValueCountFrequency (%)
748872710 1
< 0.1%
740378630 1
< 0.1%
735843510 1
< 0.1%
723013690 1
< 0.1%
720759060 1
< 0.1%
719721250 1
< 0.1%
707453420 1
< 0.1%
706824990 1
< 0.1%
705473840 1
< 0.1%
697858030 1
< 0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size22.7 KiB
Minimum2023-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-03-23T14:44:12.337765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:44:12.611674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-23T14:44:07.156573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:44:06.834786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:44:07.389287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:44:06.995840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T14:44:12.766810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번행정동명지급분야명연월지급금액(원)
순번1.0000.9910.4210.0000.291
행정동명0.9911.0000.5680.0000.466
지급분야명0.4210.5681.0000.0000.653
연월0.0000.0000.0001.0000.000
지급금액(원)0.2910.4660.6530.0001.000
2024-03-23T14:44:12.941454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동명지급분야명
행정동명1.0000.203
지급분야명0.2031.000
2024-03-23T14:44:13.083970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번지급금액(원)행정동명지급분야명
순번1.000-0.0620.9070.179
지급금액(원)-0.0621.0000.2180.370
행정동명0.9070.2181.0000.203
지급분야명0.1790.3700.2031.000

Missing values

2024-03-23T14:44:07.688689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T14:44:07.957798image/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

순번시군구명행정동명지급분야명연월지급건수(건)지급금액(원)데이터기준일자
01서구가수원동기초생계_장제급여2023-01002023-12-31
12서구가수원동기초생계_장제급여2023-0218000002023-12-31
23서구가수원동기초생계_장제급여2023-03324000002023-12-31
34서구가수원동기초생계_장제급여2023-04002023-12-31
45서구가수원동기초생계_장제급여2023-05002023-12-31
56서구가수원동기초생계_장제급여2023-06002023-12-31
67서구가수원동기초생계_장제급여2023-07002023-12-31
78서구가수원동기초생계_장제급여2023-0818000002023-12-31
89서구가수원동기초생계_장제급여2023-09002023-12-31
910서구가수원동기초생계_장제급여2023-1018000002023-12-31
순번시군구명행정동명지급분야명연월지급건수(건)지급금액(원)데이터기준일자
28822883서구탄방동기초청년주거급여(현금-월차임)2023-03613342502023-12-31
28832884서구탄방동기초청년주거급여(현금-월차임)2023-04615046602023-12-31
28842885서구탄방동기초청년주거급여(현금-월차임)2023-05511774002023-12-31
28852886서구탄방동기초청년주거급여(현금-월차임)2023-06518748502023-12-31
28862887서구탄방동기초청년주거급여(현금-월차임)2023-07512117502023-12-31
28872888서구탄방동기초청년주거급여(현금-월차임)2023-08512117502023-12-31
28882889서구탄방동기초청년주거급여(현금-월차임)2023-09616914302023-12-31
28892890서구탄방동기초청년주거급여(현금-월차임)2023-10716721502023-12-31
28902891서구탄방동기초청년주거급여(현금-월차임)2023-11716649202023-12-31
28912892서구탄방동기초청년주거급여(현금-월차임)2023-12716649202023-12-31