Overview

Dataset statistics

Number of variables26
Number of observations198
Missing cells451
Missing cells (%)8.8%
Duplicate rows15
Duplicate rows (%)7.6%
Total size in memory40.3 KiB
Average record size in memory208.7 B

Variable types

Text2
Categorical1
Unsupported23

Alerts

Dataset has 15 (7.6%) duplicate rowsDuplicates
장애수당 수급 장애인 현황(전체) has 193 (97.5%) missing valuesMissing
Unnamed: 1 has 176 (88.9%) missing valuesMissing
Unnamed: 3 has 4 (2.0%) missing valuesMissing
Unnamed: 4 has 2 (1.0%) missing valuesMissing
Unnamed: 5 has 4 (2.0%) missing valuesMissing
Unnamed: 6 has 4 (2.0%) missing valuesMissing
Unnamed: 7 has 3 (1.5%) missing valuesMissing
Unnamed: 8 has 4 (2.0%) missing valuesMissing
Unnamed: 9 has 4 (2.0%) missing valuesMissing
Unnamed: 10 has 3 (1.5%) missing valuesMissing
Unnamed: 11 has 4 (2.0%) missing valuesMissing
Unnamed: 12 has 4 (2.0%) missing valuesMissing
Unnamed: 13 has 2 (1.0%) missing valuesMissing
Unnamed: 14 has 4 (2.0%) missing valuesMissing
Unnamed: 15 has 4 (2.0%) missing valuesMissing
Unnamed: 16 has 3 (1.5%) missing valuesMissing
Unnamed: 17 has 4 (2.0%) missing valuesMissing
Unnamed: 18 has 4 (2.0%) missing valuesMissing
Unnamed: 19 has 3 (1.5%) missing valuesMissing
Unnamed: 20 has 4 (2.0%) missing valuesMissing
Unnamed: 21 has 4 (2.0%) missing valuesMissing
Unnamed: 22 has 2 (1.0%) missing valuesMissing
Unnamed: 23 has 4 (2.0%) missing valuesMissing
Unnamed: 24 has 4 (2.0%) missing valuesMissing
Unnamed: 25 has 4 (2.0%) missing valuesMissing
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
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:25:56.204286
Analysis finished2024-03-14 01:25:56.324201
Duration0.12 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

장애수당 수급 장애인 현황(전체)
Text

MISSING 

Distinct4
Distinct (%)80.0%
Missing193
Missing (%)97.5%
Memory size1.7 KiB
2024-03-14T10:25:56.380397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length4
Mean length4.4
Min length2

Characters and Unicode

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

Unique

Unique3 ?
Unique (%)60.0%

Sample

1st row(2015년 6월)
2nd row전라북도
3rd row시도
4th row합계
5th row전라북도
ValueCountFrequency (%)
전라북도 2
33.3%
2015년 1
16.7%
6월 1
16.7%
시도 1
16.7%
합계 1
16.7%
2024-03-14T10:25:56.579474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
도 3
13.6%
전 2
 
9.1%
북 2
 
9.1%
라 2
 
9.1%
1
 
4.5%
합 1
 
4.5%
시 1
 
4.5%
) 1
 
4.5%
월 1
 
4.5%
6 1
 
4.5%
Other values (7) 7
31.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14
63.6%
Decimal Number 5
 
22.7%
Space Separator 1
 
4.5%
Close Punctuation 1
 
4.5%
Open Punctuation 1
 
4.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 3
21.4%
전 2
14.3%
북 2
14.3%
라 2
14.3%
합 1
 
7.1%
시 1
 
7.1%
월 1
 
7.1%
년 1
 
7.1%
계 1
 
7.1%
Decimal Number
ValueCountFrequency (%)
6 1
20.0%
5 1
20.0%
1 1
20.0%
0 1
20.0%
2 1
20.0%
Space Separator
ValueCountFrequency (%)
1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14
63.6%
Common 8
36.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 3
21.4%
전 2
14.3%
북 2
14.3%
라 2
14.3%
합 1
 
7.1%
시 1
 
7.1%
월 1
 
7.1%
년 1
 
7.1%
계 1
 
7.1%
Common
ValueCountFrequency (%)
1
12.5%
) 1
12.5%
6 1
12.5%
5 1
12.5%
1 1
12.5%
0 1
12.5%
2 1
12.5%
( 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14
63.6%
ASCII 8
36.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
도 3
21.4%
전 2
14.3%
북 2
14.3%
라 2
14.3%
합 1
 
7.1%
시 1
 
7.1%
월 1
 
7.1%
년 1
 
7.1%
계 1
 
7.1%
ASCII
ValueCountFrequency (%)
1
12.5%
) 1
12.5%
6 1
12.5%
5 1
12.5%
1 1
12.5%
0 1
12.5%
2 1
12.5%
( 1
12.5%

Unnamed: 1
Text

MISSING 

Distinct15
Distinct (%)68.2%
Missing176
Missing (%)88.9%
Memory size1.7 KiB
2024-03-14T10:25:56.711823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length4.9090909
Min length3

Characters and Unicode

Total characters108
Distinct characters26
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

Unique8 ?
Unique (%)36.4%

Sample

1st row시군구
2nd row전주시
3rd row군산시
4th row군산시
5th row익산시
ValueCountFrequency (%)
군산시 2
 
9.1%
정읍시 2
 
9.1%
김제시 2
 
9.1%
진안군 2
 
9.1%
장수군 2
 
9.1%
순창군 2
 
9.1%
부안군 2
 
9.1%
시군구 1
 
4.5%
전주시 1
 
4.5%
익산시 1
 
4.5%
Other values (5) 5
22.7%
2024-03-14T10:25:56.975596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
42
38.9%
군 15
 
13.9%
시 10
 
9.3%
안 4
 
3.7%
주 3
 
2.8%
산 3
 
2.8%
창 3
 
2.8%
제 2
 
1.9%
김 2
 
1.9%
장 2
 
1.9%
Other values (16) 22
20.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 66
61.1%
Space Separator 42
38.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 15
22.7%
시 10
15.2%
안 4
 
6.1%
주 3
 
4.5%
산 3
 
4.5%
창 3
 
4.5%
제 2
 
3.0%
김 2
 
3.0%
장 2
 
3.0%
수 2
 
3.0%
Other values (15) 20
30.3%
Space Separator
ValueCountFrequency (%)
42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 66
61.1%
Common 42
38.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 15
22.7%
시 10
15.2%
안 4
 
6.1%
주 3
 
4.5%
산 3
 
4.5%
창 3
 
4.5%
제 2
 
3.0%
김 2
 
3.0%
장 2
 
3.0%
수 2
 
3.0%
Other values (15) 20
30.3%
Common
ValueCountFrequency (%)
42
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 66
61.1%
ASCII 42
38.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
42
100.0%
Hangul
ValueCountFrequency (%)
군 15
22.7%
시 10
15.2%
안 4
 
6.1%
주 3
 
4.5%
산 3
 
4.5%
창 3
 
4.5%
제 2
 
3.0%
김 2
 
3.0%
장 2
 
3.0%
수 2
 
3.0%
Other values (15) 20
30.3%

Unnamed: 2
Categorical

Distinct18
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
정신
14 
지체
14 
시각
14 
청각
14 
언어
14 
Other values (13)
128 

Length

Max length5
Median length2
Mean length2.3484848
Min length1

Unique

Unique2 ?
Unique (%)1.0%

Sample

1st row<NA>
2nd row<NA>
3rd row장애 유형
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
정신 14
 
7.1%
지체 14
 
7.1%
시각 14
 
7.1%
청각 14
 
7.1%
언어 14
 
7.1%
지적 14
 
7.1%
뇌병변 14
 
7.1%
간질 14
 
7.1%
소계 14
 
7.1%
신장 13
 
6.6%
Other values (8) 59
29.8%

Length

2024-03-14T10:25:57.096083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
정신 14
 
7.0%
시각 14
 
7.0%
청각 14
 
7.0%
언어 14
 
7.0%
지적 14
 
7.0%
뇌병변 14
 
7.0%
간질 14
 
7.0%
소계 14
 
7.0%
지체 14
 
7.0%
장루.요루 13
 
6.5%
Other values (9) 60
30.2%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)1.0%
Memory size1.7 KiB

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)1.5%
Memory size1.7 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)1.5%
Memory size1.7 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)1.0%
Memory size1.7 KiB

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)1.5%
Memory size1.7 KiB

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)1.5%
Memory size1.7 KiB

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)1.0%
Memory size1.7 KiB

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)2.0%
Memory size1.7 KiB

Sample

장애수당 수급 장애인 현황(전체)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25
0(2015년 6월)<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1전라북도<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN(단위: 명)NaNNaNNaN
2시도시군구장애 유형합계중증NaNNaNNaNNaNNaNNaNNaNNaN경증NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN해당\n없음
3<NA><NA><NA>NaN1급NaNNaN2급NaNNaN3급NaNNaN3급NaNNaN4급NaNNaN5급NaNNaN6급NaNNaNNaN
4<NA><NA><NA>NaN남여계남여계남여계남여계남여계남여계남여계NaN
5합계<NA><NA>22312011661274114378366780452009293149401920305449742114221543290
6전라북도전주시소계47560122810101986814180044954399246164611074774719480
7<NA><NA>지체23530000110003021854872483826302744777512652895540
8<NA><NA>시각3790000000001737541918372523481291072360
9<NA><NA>청각4450000000005759116696613557971542753800
장애수당 수급 장애인 현황(전체)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25
188<NA><NA>지적750000000003941800000000000
189<NA><NA>뇌병변930000000001721381614306814127190
190<NA><NA>정신700000000003233650000000000
191<NA><NA>신장30000000000000001010000
192<NA>부안군심장30000000002130000000000
193<NA><NA>호흡기30000000004040000000000
194<NA><NA>간30000000000000002020000
195<NA><NA>안면10000000000110000000000
196<NA><NA>장루.요루50000000000002240110000
197<NA><NA>간질100000000001125381120000

Duplicate rows

Most frequently occurring

장애수당 수급 장애인 현황(전체)Unnamed: 1Unnamed: 2# duplicates
1<NA><NA>간질14
3<NA><NA>시각14
9<NA><NA>정신14
10<NA><NA>지적14
12<NA><NA>청각14
4<NA><NA>신장13
7<NA><NA>언어13
8<NA><NA>장루.요루13
11<NA><NA>지체13
2<NA><NA>뇌병변12