Overview

Dataset statistics

Number of variables26
Number of observations200
Missing cells501
Missing cells (%)9.6%
Duplicate rows15
Duplicate rows (%)7.5%
Total size in memory40.8 KiB
Average record size in memory208.7 B

Variable types

Text2
Categorical1
Unsupported23

Alerts

Dataset has 15 (7.5%) duplicate rowsDuplicates
장애수당 수급 장애인 현황(전체) has 195 (97.5%) missing valuesMissing
Unnamed: 1 has 178 (89.0%) missing valuesMissing
Unnamed: 3 has 6 (3.0%) missing valuesMissing
Unnamed: 4 has 4 (2.0%) missing valuesMissing
Unnamed: 5 has 6 (3.0%) missing valuesMissing
Unnamed: 6 has 6 (3.0%) missing valuesMissing
Unnamed: 7 has 5 (2.5%) missing valuesMissing
Unnamed: 8 has 6 (3.0%) missing valuesMissing
Unnamed: 9 has 6 (3.0%) missing valuesMissing
Unnamed: 10 has 5 (2.5%) missing valuesMissing
Unnamed: 11 has 6 (3.0%) missing valuesMissing
Unnamed: 12 has 6 (3.0%) missing valuesMissing
Unnamed: 13 has 4 (2.0%) missing valuesMissing
Unnamed: 14 has 6 (3.0%) missing valuesMissing
Unnamed: 15 has 6 (3.0%) missing valuesMissing
Unnamed: 16 has 5 (2.5%) missing valuesMissing
Unnamed: 17 has 6 (3.0%) missing valuesMissing
Unnamed: 18 has 6 (3.0%) missing valuesMissing
Unnamed: 19 has 5 (2.5%) missing valuesMissing
Unnamed: 20 has 6 (3.0%) missing valuesMissing
Unnamed: 21 has 6 (3.0%) missing valuesMissing
Unnamed: 22 has 4 (2.0%) missing valuesMissing
Unnamed: 23 has 6 (3.0%) missing valuesMissing
Unnamed: 24 has 6 (3.0%) missing valuesMissing
Unnamed: 25 has 6 (3.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 00:36:26.390972
Analysis finished2024-03-14 00:36:26.511927
Duration0.12 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

MISSING 

Distinct4
Distinct (%)80.0%
Missing195
Missing (%)97.5%
Memory size1.7 KiB
2024-03-14T09:36:26.564143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length4
Mean length4.6
Min length2

Characters and Unicode

Total characters23
Distinct characters16
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(2013년 12월)
2nd row전라북도
3rd row시도
4th row합계
5th row전라북도
ValueCountFrequency (%)
전라북도 2
33.3%
2013년 1
16.7%
12월 1
16.7%
시도 1
16.7%
합계 1
16.7%
2024-03-14T09:36:26.810261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
도 3
13.0%
전 2
 
8.7%
라 2
 
8.7%
북 2
 
8.7%
2 2
 
8.7%
1 2
 
8.7%
( 1
 
4.3%
0 1
 
4.3%
3 1
 
4.3%
년 1
 
4.3%
Other values (6) 6
26.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14
60.9%
Decimal Number 6
26.1%
Open Punctuation 1
 
4.3%
Space Separator 1
 
4.3%
Close Punctuation 1
 
4.3%

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 (%)
2 2
33.3%
1 2
33.3%
0 1
16.7%
3 1
16.7%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14
60.9%
Common 9
39.1%

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 (%)
2 2
22.2%
1 2
22.2%
( 1
11.1%
0 1
11.1%
3 1
11.1%
1
11.1%
) 1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14
60.9%
ASCII 9
39.1%

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 (%)
2 2
22.2%
1 2
22.2%
( 1
11.1%
0 1
11.1%
3 1
11.1%
1
11.1%
) 1
11.1%

Unnamed: 1
Text

MISSING 

Distinct15
Distinct (%)68.2%
Missing178
Missing (%)89.0%
Memory size1.7 KiB
2024-03-14T09:36:26.979506image/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-14T09:36:27.257415image/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.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
정신
14 
지체
14 
시각
14 
청각
14 
언어
14 
Other values (13)
130 

Length

Max length5
Median length2
Mean length2.365
Min length1

Unique

Unique2 ?
Unique (%)1.0%

Sample

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

Common Values

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 (8) 61
30.5%

Length

2024-03-14T09:36:27.366426image/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) 62
30.8%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)2.5%
Memory size1.7 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)2.5%
Memory size1.7 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)2.5%
Memory size1.7 KiB

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)2.5%
Memory size1.7 KiB

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.0%
Memory size1.7 KiB

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)3.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(2013년 12월)<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2<NA><NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3전라북도<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN(단위: 명)NaNNaNNaN
4시도시군구장애 유형합계중증NaNNaNNaNNaNNaNNaNNaNNaN경증NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN해당\n없음
5<NA><NA><NA>NaN1급NaNNaN2급NaNNaN3급NaNNaN3급NaNNaN4급NaNNaN5급NaNNaN6급NaNNaNNaN
6<NA><NA><NA>NaN남여계남여계남여계남여계남여계남여계남여계NaN
7합계<NA><NA>2284845949131014468371781852079307751561972314151132171220043710
8전라북도전주시소계48652572810101986814180044954399246164611074774719480
9<NA><NA>지체24230000110003021854872483826302744777512652895540
장애수당 수급 장애인 현황(전체)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
190<NA><NA>지적800000000003941800000000000
191<NA><NA>뇌병변1010000000001721381614306814127190
192<NA><NA>정신650000000003233650000000000
193<NA><NA>신장10000000000000001010000
194<NA>부안군심장30000000002130000000000
195<NA><NA>호흡기40000000004040000000000
196<NA><NA>간20000000000000002020000
197<NA><NA>안면10000000000110000000000
198<NA><NA>장루.요루50000000000002240110000
199<NA><NA>간질120000000001125381120000

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