Overview

Dataset statistics

Number of variables22
Number of observations46
Missing cells387
Missing cells (%)38.2%
Duplicate rows1
Duplicate rows (%)2.2%
Total size in memory8.0 KiB
Average record size in memory178.9 B

Variable types

Text1
Unsupported21

Dataset

Description안양시 국민기초생활보장 수급자 현황에 대한 현황 통계 자료입니다. 총수급자, 생계수급자, 의료급여수급자, 주거급여수급자, 교육급여수급자로 구성되어 있으며 주기적 데이터가 아닌 일시적, 1회성 데이터입니다.
Author경기도 안양시
URLhttps://www.data.go.kr/data/15103502/fileData.do

Alerts

Dataset has 1 (2.2%) duplicate rowsDuplicates
2020. 12월 기초생활보장수급자 현황 (실인원) has 4 (8.7%) missing valuesMissing
Unnamed: 1 has 3 (6.5%) missing valuesMissing
Unnamed: 2 has 3 (6.5%) missing valuesMissing
Unnamed: 3 has 4 (8.7%) missing valuesMissing
Unnamed: 4 has 4 (8.7%) missing valuesMissing
Unnamed: 5 has 2 (4.3%) missing valuesMissing
Unnamed: 6 has 2 (4.3%) missing valuesMissing
Unnamed: 7 has 29 (63.0%) missing valuesMissing
Unnamed: 8 has 29 (63.0%) missing valuesMissing
Unnamed: 9 has 29 (63.0%) missing valuesMissing
Unnamed: 10 has 3 (6.5%) missing valuesMissing
Unnamed: 11 has 30 (65.2%) missing valuesMissing
Unnamed: 12 has 30 (65.2%) missing valuesMissing
Unnamed: 13 has 29 (63.0%) missing valuesMissing
Unnamed: 14 has 3 (6.5%) missing valuesMissing
Unnamed: 15 has 30 (65.2%) missing valuesMissing
Unnamed: 16 has 30 (65.2%) missing valuesMissing
Unnamed: 17 has 29 (63.0%) missing valuesMissing
Unnamed: 18 has 3 (6.5%) missing valuesMissing
Unnamed: 19 has 30 (65.2%) missing valuesMissing
Unnamed: 20 has 31 (67.4%) missing valuesMissing
Unnamed: 21 has 30 (65.2%) missing valuesMissing
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 06:48:56.198434
Analysis finished2023-12-12 06:48:56.298053
Duration0.1 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct42
Distinct (%)100.0%
Missing4
Missing (%)8.7%
Memory size500.0 B
2023-12-12T15:48:56.475420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length4
Mean length3.7142857
Min length2

Characters and Unicode

Total characters156
Distinct characters56
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row동명
2nd row총계
3rd row안양1동
4th row안양2동
5th row안양3동
ValueCountFrequency (%)
안양9동 1
 
2.4%
동안구 1
 
2.4%
비산2동 1
 
2.4%
비산3동 1
 
2.4%
부흥동 1
 
2.4%
달안동 1
 
2.4%
관양1동 1
 
2.4%
관양2동 1
 
2.4%
부림동 1
 
2.4%
평촌동 1
 
2.4%
Other values (32) 32
76.2%
2023-12-12T15:48:56.890483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
33
21.2%
13
 
8.3%
13
 
8.3%
1 6
 
3.8%
2 6
 
3.8%
5
 
3.2%
5
 
3.2%
4
 
2.6%
3 4
 
2.6%
4
 
2.6%
Other values (46) 63
40.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134
85.9%
Decimal Number 22
 
14.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
33
24.6%
13
 
9.7%
13
 
9.7%
5
 
3.7%
5
 
3.7%
4
 
3.0%
4
 
3.0%
3
 
2.2%
3
 
2.2%
3
 
2.2%
Other values (37) 48
35.8%
Decimal Number
ValueCountFrequency (%)
1 6
27.3%
2 6
27.3%
3 4
18.2%
9 1
 
4.5%
4 1
 
4.5%
5 1
 
4.5%
6 1
 
4.5%
7 1
 
4.5%
8 1
 
4.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134
85.9%
Common 22
 
14.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
33
24.6%
13
 
9.7%
13
 
9.7%
5
 
3.7%
5
 
3.7%
4
 
3.0%
4
 
3.0%
3
 
2.2%
3
 
2.2%
3
 
2.2%
Other values (37) 48
35.8%
Common
ValueCountFrequency (%)
1 6
27.3%
2 6
27.3%
3 4
18.2%
9 1
 
4.5%
4 1
 
4.5%
5 1
 
4.5%
6 1
 
4.5%
7 1
 
4.5%
8 1
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134
85.9%
ASCII 22
 
14.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
33
24.6%
13
 
9.7%
13
 
9.7%
5
 
3.7%
5
 
3.7%
4
 
3.0%
4
 
3.0%
3
 
2.2%
3
 
2.2%
3
 
2.2%
Other values (37) 48
35.8%
ASCII
ValueCountFrequency (%)
1 6
27.3%
2 6
27.3%
3 4
18.2%
9 1
 
4.5%
4 1
 
4.5%
5 1
 
4.5%
6 1
 
4.5%
7 1
 
4.5%
8 1
 
4.5%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)6.5%
Memory size500.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)6.5%
Memory size500.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.7%
Memory size500.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.7%
Memory size500.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.3%
Memory size500.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.3%
Memory size500.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing29
Missing (%)63.0%
Memory size500.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing29
Missing (%)63.0%
Memory size500.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing29
Missing (%)63.0%
Memory size500.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)6.5%
Memory size500.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)65.2%
Memory size500.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)65.2%
Memory size500.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing29
Missing (%)63.0%
Memory size500.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)6.5%
Memory size500.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)65.2%
Memory size500.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)65.2%
Memory size500.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing29
Missing (%)63.0%
Memory size500.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)6.5%
Memory size500.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)65.2%
Memory size500.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)67.4%
Memory size500.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)65.2%
Memory size500.0 B

Sample

2020. 12월 기초생활보장수급자 현황 (실인원)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
0<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1동명총수급자NaNNaNNaN생계수급자NaNNaNNaN의료급여수급자NaNNaNNaN주거급여수급자NaNNaNNaN교육급여수급자NaNNaNNaN총가구수
2<NA>가구인원NaNNaN가구인원NaNNaN가구인원NaNNaN가구인원NaNNaN가구인원NaNNaN순위
3<NA>NaNNaNNaNNaNNaNNaN
4총계539672693512375731393876197918973435282652631624243710421395290428226202NaN
5안양1동160174120548592652711118361674324344NaN12
6안양2동60680839541336344122221936572829171257118139365327262
7안양3동4265742663082383021511512640152511917366107435934257
8안양4동253304164140136152896312131031021366472331210
9안양5동487610291319308353186167253720171381997712216218135
2020. 12월 기초생활보장수급자 현황 (실인원)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
36호계1동000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
37호계2동000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
38호계3동000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
39범계동000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
40신촌동000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
41갈산동000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
42평화의집000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
43돋움터000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
44꿈이있는집000000NaNNaNNaN0NaNNaNNaN0NaNNaNNaN0NaNNaNNaN
45<NA>NaNNaNNaNNaN00NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN

Duplicate rows

Most frequently occurring

2020. 12월 기초생활보장수급자 현황 (실인원)# duplicates
0<NA>4