Overview

Dataset statistics

Number of variables30
Number of observations21
Missing cells310
Missing cells (%)49.2%
Duplicate rows1
Duplicate rows (%)4.8%
Total size in memory5.1 KiB
Average record size in memory246.3 B

Variable types

Text1
Unsupported29

Dataset

Description공공데이터요보호아동발생및조치현황
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202194

Alerts

Dataset has 1 (4.8%) duplicate rowsDuplicates
2017년 보호대상아동 발생 및 보호조치 현황 has 4 (19.0%) missing valuesMissing
Unnamed: 1 has 4 (19.0%) missing valuesMissing
Unnamed: 2 has 9 (42.9%) missing valuesMissing
Unnamed: 3 has 3 (14.3%) missing valuesMissing
Unnamed: 4 has 18 (85.7%) missing valuesMissing
Unnamed: 5 has 15 (71.4%) missing valuesMissing
Unnamed: 6 has 17 (81.0%) missing valuesMissing
Unnamed: 7 has 17 (81.0%) missing valuesMissing
Unnamed: 8 has 10 (47.6%) missing valuesMissing
Unnamed: 9 has 16 (76.2%) missing valuesMissing
Unnamed: 10 has 11 (52.4%) missing valuesMissing
Unnamed: 11 has 17 (81.0%) missing valuesMissing
Unnamed: 12 has 9 (42.9%) missing valuesMissing
Unnamed: 13 has 3 (14.3%) missing valuesMissing
Unnamed: 14 has 5 (23.8%) missing valuesMissing
Unnamed: 15 has 6 (28.6%) missing valuesMissing
Unnamed: 16 has 3 (14.3%) missing valuesMissing
Unnamed: 17 has 5 (23.8%) missing valuesMissing
Unnamed: 18 has 13 (61.9%) missing valuesMissing
Unnamed: 19 has 3 (14.3%) missing valuesMissing
Unnamed: 20 has 3 (14.3%) missing valuesMissing
Unnamed: 21 has 12 (57.1%) missing valuesMissing
Unnamed: 22 has 18 (85.7%) missing valuesMissing
Unnamed: 23 has 18 (85.7%) missing valuesMissing
Unnamed: 24 has 12 (57.1%) missing valuesMissing
Unnamed: 25 has 3 (14.3%) missing valuesMissing
Unnamed: 26 has 18 (85.7%) missing valuesMissing
Unnamed: 27 has 12 (57.1%) missing valuesMissing
Unnamed: 28 has 8 (38.1%) missing valuesMissing
Unnamed: 29 has 18 (85.7%) 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
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
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 02:33:54.890720
Analysis finished2024-03-14 02:33:54.985782
Duration0.1 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2017년 보호대상아동 발생 및 보호조치 현황
Text

MISSING 

Distinct17
Distinct (%)100.0%
Missing4
Missing (%)19.0%
Memory size300.0 B
2024-03-14T11:33:55.080966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length3
Mean length4.5882353
Min length3

Characters and Unicode

Total characters78
Distinct characters41
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique17 ?
Unique (%)100.0%

Sample

1st row(2017.1.1 ~2017.12.31. )
2nd row구분 시·도
3rd row합 계
4th row고창군
5th row정읍시
ValueCountFrequency (%)
2017.1.1 1
 
4.8%
시·도 1
 
4.8%
무주군 1
 
4.8%
장수군 1
 
4.8%
순창군 1
 
4.8%
부안군 1
 
4.8%
진안군 1
 
4.8%
김제시 1
 
4.8%
임실군 1
 
4.8%
전주시 1
 
4.8%
Other values (11) 11
52.4%
2024-03-14T11:33:55.327002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
군 9
 
11.5%
시 7
 
9.0%
1 6
 
7.7%
. 5
 
6.4%
4
 
5.1%
주 3
 
3.8%
3
 
3.8%
2 3
 
3.8%
안 2
 
2.6%
산 2
 
2.6%
Other values (31) 34
43.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 48
61.5%
Decimal Number 14
 
17.9%
Other Punctuation 6
 
7.7%
Control 4
 
5.1%
Space Separator 3
 
3.8%
Open Punctuation 1
 
1.3%
Close Punctuation 1
 
1.3%
Math Symbol 1
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 9
18.8%
시 7
 
14.6%
주 3
 
6.2%
안 2
 
4.2%
산 2
 
4.2%
창 2
 
4.2%
임 1
 
2.1%
전 1
 
2.1%
도 1
 
2.1%
실 1
 
2.1%
Other values (19) 19
39.6%
Decimal Number
ValueCountFrequency (%)
1 6
42.9%
2 3
21.4%
7 2
 
14.3%
0 2
 
14.3%
3 1
 
7.1%
Other Punctuation
ValueCountFrequency (%)
. 5
83.3%
· 1
 
16.7%
Control
ValueCountFrequency (%)
4
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 48
61.5%
Common 30
38.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 9
18.8%
시 7
 
14.6%
주 3
 
6.2%
안 2
 
4.2%
산 2
 
4.2%
창 2
 
4.2%
임 1
 
2.1%
전 1
 
2.1%
도 1
 
2.1%
실 1
 
2.1%
Other values (19) 19
39.6%
Common
ValueCountFrequency (%)
1 6
20.0%
. 5
16.7%
4
13.3%
3
10.0%
2 3
10.0%
7 2
 
6.7%
0 2
 
6.7%
( 1
 
3.3%
· 1
 
3.3%
) 1
 
3.3%
Other values (2) 2
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 48
61.5%
ASCII 29
37.2%
None 1
 
1.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
군 9
18.8%
시 7
 
14.6%
주 3
 
6.2%
안 2
 
4.2%
산 2
 
4.2%
창 2
 
4.2%
임 1
 
2.1%
전 1
 
2.1%
도 1
 
2.1%
실 1
 
2.1%
Other values (19) 19
39.6%
ASCII
ValueCountFrequency (%)
1 6
20.7%
. 5
17.2%
4
13.8%
3
10.3%
2 3
10.3%
7 2
 
6.9%
0 2
 
6.9%
( 1
 
3.4%
) 1
 
3.4%
3 1
 
3.4%
None
ValueCountFrequency (%)
· 1
100.0%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)19.0%
Memory size300.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)42.9%
Memory size300.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)85.7%
Memory size300.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing15
Missing (%)71.4%
Memory size300.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)81.0%
Memory size300.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)81.0%
Memory size300.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10
Missing (%)47.6%
Memory size300.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)76.2%
Memory size300.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)52.4%
Memory size300.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)81.0%
Memory size300.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)42.9%
Memory size300.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)23.8%
Memory size300.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)28.6%
Memory size300.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)23.8%
Memory size300.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)61.9%
Memory size300.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)57.1%
Memory size300.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)85.7%
Memory size300.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)85.7%
Memory size300.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)57.1%
Memory size300.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)85.7%
Memory size300.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)57.1%
Memory size300.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing8
Missing (%)38.1%
Memory size300.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)85.7%
Memory size300.0 B

Sample

2017년 보호대상아동 발생 및 보호조치 현황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: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29
0(2017.1.1 ~2017.12.31. )NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구분 시·도총아동\n발생수귀가및\n연고자\n인 도보호대상아동의 발생원인NaNNaNNaNNaNNaNNaNNaNNaNNaN성별NaNNaN장애여부NaNNaN보호대상아동의 조치내용NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2<NA>NaNNaN계유기미혼부모·\n혼외자미아비행·\n가출·\n부랑학대부모\n빈곤·\n실직부모\n사망부모\n질병부모\n이혼\n등계남여계비장애장애계시설입소NaNNaNNaNNaN가정보호NaNNaNNaNNaN
3<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN소계양육\n시설 \n등일시\n보호\n시설장애\n아동\n시설공동\n생활\n가정소계소년\n소녀\n가정입양가정\n위탁입양\n전 \n위탁
4<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
5합 계①②③④⑤⑥⑦⑧⑨⑩⑪⑫⑬⑭⑮⑯⑰⑱⑲⑳㉑㉒㉓㉔㉕㉖㉗㉘㉙
6<NA>2875423301442136325247233108125233227623314876007285018670
7고창군20NaN20NaNNaNNaNNaN20NaNNaNNaNNaN20101020191202020NaNNaNNaN0NaNNaNNaNNaN
8정읍시15213NaNNaNNaNNaN3NaN2NaN81349131301355NaNNaNNaN8NaN17NaN
9익산시361026NaN24NaN19NaNNaNNaN1267192626NaN26188NaNNaN108NaN62NaN
2017년 보호대상아동 발생 및 보호조치 현황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: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29
11완주군15312NaNNaNNaNNaN614NaN11275121111277NaNNaNNaN5NaNNaN5NaN
12전주시74074NaN11NaNNaN39NaN4NaN2074324274731744915NaNNaN3425NaN718NaN
13무주군110NaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaN0NaNNaN00NaNNaNNaNNaN0NaNNaNNaNNaN
14임실군624NaNNaNNaNNaNNaNNaN1NaN342244NaN40NaNNaNNaNNaN4NaNNaN4NaN
15김제시7NaN7NaN1NaNNaNNaNNaN4NaN275277NaN70NaNNaNNaNNaN7NaN16NaN
16진안군312NaNNaNNaNNaN2NaNNaNNaNNaN21122NaN22NaNNaNNaN20NaNNaNNaNNaN
17부안군10NaN10NaNNaNNaNNaNNaNNaNNaNNaN1010371010NaN100NaNNaNNaNNaN10NaNNaN10NaN
18순창군1NaN1NaNNaNNaNNaNNaNNaNNaNNaN111NaN11NaN11NaNNaNNaN10NaNNaNNaNNaN
19장수군1NaN1NaNNaNNaNNaNNaNNaN1NaNNaN11011NaN10NaNNaNNaNNaN1NaN01NaN
20군산시471235NaNNaNNaN2282NaN2135161935323352721NaNNaN68NaN35NaN

Duplicate rows

Most frequently occurring

2017년 보호대상아동 발생 및 보호조치 현황# duplicates
0<NA>4