Overview

Dataset statistics

Number of variables14
Number of observations432
Missing cells432
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory49.1 KiB
Average record size in memory116.3 B

Variable types

Categorical11
Numeric1
Text1
Unsupported1

Dataset

Description범죄발생 및 검거 현황(충남청)
Author충청남도
URLhttps://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=2848

Alerts

통계표ID has constant value ""Constant
기관코드 has constant value ""Constant
수록주기 has constant value ""Constant
통계표명 has constant value ""Constant
분류명1 has constant value ""Constant
항목ID is highly overall correlated with 항목명 and 2 other fieldsHigh correlation
단위 영문명 is highly overall correlated with 항목명 and 2 other fieldsHigh correlation
단위명 is highly overall correlated with 항목명 and 2 other fieldsHigh correlation
항목명 is highly overall correlated with 항목ID and 2 other fieldsHigh correlation
분류값 ID1 is highly overall correlated with 분류값 명1High correlation
분류값 명1 is highly overall correlated with 분류값 ID1High correlation
분류값 영문명1 has 432 (100.0%) missing valuesMissing
분류값 영문명1 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-14 06:42:07.704303
Analysis finished2024-01-14 06:42:08.612113
Duration0.91 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

통계표ID
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
DT_13204_2011_N223
432 

Length

Max length18
Median length18
Mean length18
Min length18

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDT_13204_2011_N223
2nd rowDT_13204_2011_N223
3rd rowDT_13204_2011_N223
4th rowDT_13204_2011_N223
5th rowDT_13204_2011_N223

Common Values

ValueCountFrequency (%)
DT_13204_2011_N223 432
100.0%

Length

2024-01-14T15:42:08.671722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:08.757852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
dt_13204_2011_n223 432
100.0%

기관코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
132
432 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row132
2nd row132
3rd row132
4th row132
5th row132

Common Values

ValueCountFrequency (%)
132 432
100.0%

Length

2024-01-14T15:42:08.849490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:08.945092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
132 432
100.0%

수록주기
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
A
432 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowA
2nd rowA
3rd rowA
4th rowA
5th rowA

Common Values

ValueCountFrequency (%)
A 432
100.0%

Length

2024-01-14T15:42:09.066561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:09.158256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
a 432
100.0%

항목명
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
발생건수
54 
검거건수
54 
발생건수 대비 검거건수
54 
검거인원
54 
남자검거인원
54 
Other values (3)
162 

Length

Max length12
Median length6
Mean length5.625
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row발생건수
2nd row검거건수
3rd row발생건수 대비 검거건수
4th row검거인원
5th row남자검거인원

Common Values

ValueCountFrequency (%)
발생건수 54
12.5%
검거건수 54
12.5%
발생건수 대비 검거건수 54
12.5%
검거인원 54
12.5%
남자검거인원 54
12.5%
여자검거인원 54
12.5%
불상검거인원 54
12.5%
법인체 54
12.5%

Length

2024-01-14T15:42:09.255978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:09.365252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
발생건수 108
20.0%
검거건수 108
20.0%
대비 54
10.0%
검거인원 54
10.0%
남자검거인원 54
10.0%
여자검거인원 54
10.0%
불상검거인원 54
10.0%
법인체 54
10.0%

항목ID
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
AA
54 
BB
54 
CC
54 
DD
54 
DD1
54 
Other values (3)
162 

Length

Max length3
Median length2.5
Mean length2.5
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowAA
2nd rowBB
3rd rowCC
4th rowDD
5th rowDD1

Common Values

ValueCountFrequency (%)
AA 54
12.5%
BB 54
12.5%
CC 54
12.5%
DD 54
12.5%
DD1 54
12.5%
DD2 54
12.5%
DD3 54
12.5%
DD4 54
12.5%

Length

2024-01-14T15:42:09.569781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:09.735996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
aa 54
12.5%
bb 54
12.5%
cc 54
12.5%
dd 54
12.5%
dd1 54
12.5%
dd2 54
12.5%
dd3 54
12.5%
dd4 54
12.5%

단위명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
명
216 
건
108 
%
54 
개
54 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건
2nd row건
3rd row%
4th row명
5th row명

Common Values

ValueCountFrequency (%)
명 216
50.0%
건 108
25.0%
% 54
 
12.5%
개 54
 
12.5%

Length

2024-01-14T15:42:09.863940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:09.962569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
명 216
50.0%
건 108
25.0%
54
 
12.5%
개 54
 
12.5%

분류값 ID1
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean111161.06
Minimum101
Maximum200011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.9 KiB
2024-01-14T15:42:10.060725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum101
5-th percentile101
Q1106
median200001.5
Q3200006
95-th percentile200011
Maximum200011
Range199910
Interquartile range (IQR)199900

Descriptive statistics

Standard deviation99446.611
Coefficient of variation (CV)0.89461737
Kurtosis-1.9587404
Mean111161.06
Median Absolute Deviation (MAD)9
Skewness-0.22438667
Sum48021576
Variance9.8896284 × 109
MonotonicityNot monotonic
2024-01-14T15:42:10.189286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
101 24
 
5.6%
200003 24
 
5.6%
200011 24
 
5.6%
200010 24
 
5.6%
200009 24
 
5.6%
200007 24
 
5.6%
200006 24
 
5.6%
200005 24
 
5.6%
200004 24
 
5.6%
200002 24
 
5.6%
Other values (8) 192
44.4%
ValueCountFrequency (%)
101 24
5.6%
102 24
5.6%
103 24
5.6%
105 24
5.6%
106 24
5.6%
107 24
5.6%
108 24
5.6%
109 24
5.6%
200001 24
5.6%
200002 24
5.6%
ValueCountFrequency (%)
200011 24
5.6%
200010 24
5.6%
200009 24
5.6%
200007 24
5.6%
200006 24
5.6%
200005 24
5.6%
200004 24
5.6%
200003 24
5.6%
200002 24
5.6%
200001 24
5.6%

단위 영문명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
Person
216 
case
108 
%
54 
number
54 

Length

Max length6
Median length6
Mean length4.875
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowcase
2nd rowcase
3rd row%
4th rowPerson
5th rowPerson

Common Values

ValueCountFrequency (%)
Person 216
50.0%
case 108
25.0%
% 54
 
12.5%
number 54
 
12.5%

Length

2024-01-14T15:42:10.310432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:10.419836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
person 216
50.0%
case 108
25.0%
54
 
12.5%
number 54
 
12.5%

수치값
Text

Distinct155
Distinct (%)35.9%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
2024-01-14T15:42:10.728006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length4
Mean length1.8657407
Min length1

Characters and Unicode

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

Unique

Unique106 ?
Unique (%)24.5%

Sample

1st row7
2nd row7
3rd row100
4th row7
5th row5
ValueCountFrequency (%)
158
36.6%
1 18
 
4.2%
5 8
 
1.9%
100 7
 
1.6%
11 6
 
1.4%
48 5
 
1.2%
25 5
 
1.2%
2 5
 
1.2%
28 5
 
1.2%
31 5
 
1.2%
Other values (145) 210
48.6%
2024-01-14T15:42:11.216570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 158
19.6%
1 106
13.2%
2 99
12.3%
5 79
9.8%
3 59
 
7.3%
9 52
 
6.5%
8 50
 
6.2%
4 48
 
6.0%
6 48
 
6.0%
0 42
 
5.2%
Other values (2) 65
8.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 617
76.6%
Dash Punctuation 158
 
19.6%
Other Punctuation 31
 
3.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 106
17.2%
2 99
16.0%
5 79
12.8%
3 59
9.6%
9 52
8.4%
8 50
8.1%
4 48
7.8%
6 48
7.8%
0 42
 
6.8%
7 34
 
5.5%
Dash Punctuation
ValueCountFrequency (%)
- 158
100.0%
Other Punctuation
ValueCountFrequency (%)
. 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 806
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 158
19.6%
1 106
13.2%
2 99
12.3%
5 79
9.8%
3 59
 
7.3%
9 52
 
6.5%
8 50
 
6.2%
4 48
 
6.0%
6 48
 
6.0%
0 42
 
5.2%
Other values (2) 65
8.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 806
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 158
19.6%
1 106
13.2%
2 99
12.3%
5 79
9.8%
3 59
 
7.3%
9 52
 
6.5%
8 50
 
6.2%
4 48
 
6.0%
6 48
 
6.0%
0 42
 
5.2%
Other values (2) 65
8.1%

분류값 명1
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
살인기수
 
24
살인미수등
 
24
강도
 
24
방화
 
24
강간
 
24
Other values (13)
312 

Length

Max length12
Median length9.5
Mean length5.8333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row살인기수
2nd row살인기수
3rd row살인기수
4th row살인기수
5th row살인기수

Common Values

ValueCountFrequency (%)
살인기수 24
 
5.6%
살인미수등 24
 
5.6%
강도 24
 
5.6%
방화 24
 
5.6%
강간 24
 
5.6%
유사강간 24
 
5.6%
강제추행 24
 
5.6%
기타 강간·강제추행 등 24
 
5.6%
절도 24
 
5.6%
특가법(절도) 24
 
5.6%
Other values (8) 192
44.4%

Length

2024-01-14T15:42:11.361603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
살인기수 24
 
5.0%
살인미수등 24
 
5.0%
절도(상습 24
 
5.0%
특가법(단체등의조직 24
 
5.0%
불법사용 24
 
5.0%
특수절도(상습 24
 
5.0%
특수절도 24
 
5.0%
야간주거침입절도(상습 24
 
5.0%
야간주거침입절도 24
 
5.0%
특가법(절도 24
 
5.0%
Other values (10) 240
50.0%

수록시점
Categorical

Distinct3
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
2020
144 
2021
144 
2022
144 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020
2nd row2020
3rd row2020
4th row2020
5th row2020

Common Values

ValueCountFrequency (%)
2020 144
33.3%
2021 144
33.3%
2022 144
33.3%

Length

2024-01-14T15:42:11.470458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:11.571471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 144
33.3%
2021 144
33.3%
2022 144
33.3%

분류값 영문명1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing432
Missing (%)100.0%
Memory size3.9 KiB

통계표명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
범죄 발생 및 검거 현황(충남청)
432 

Length

Max length18
Median length18
Mean length18
Min length18

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row범죄 발생 및 검거 현황(충남청)
2nd row범죄 발생 및 검거 현황(충남청)
3rd row범죄 발생 및 검거 현황(충남청)
4th row범죄 발생 및 검거 현황(충남청)
5th row범죄 발생 및 검거 현황(충남청)

Common Values

ValueCountFrequency (%)
범죄 발생 및 검거 현황(충남청) 432
100.0%

Length

2024-01-14T15:42:11.714381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:11.820754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
범죄 432
20.0%
발생 432
20.0%
및 432
20.0%
검거 432
20.0%
현황(충남청 432
20.0%

분류명1
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
죄종별
432 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row죄종별
2nd row죄종별
3rd row죄종별
4th row죄종별
5th row죄종별

Common Values

ValueCountFrequency (%)
죄종별 432
100.0%

Length

2024-01-14T15:42:11.911287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T15:42:12.020920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
죄종별 432
100.0%

Interactions

2024-01-14T15:42:08.192058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-14T15:42:12.111344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
항목명항목ID단위명분류값 ID1단위 영문명분류값 명1수록시점
항목명1.0001.0001.0000.0001.0000.0000.000
항목ID1.0001.0001.0000.0001.0000.0000.000
단위명1.0001.0001.0000.0001.0000.0000.000
분류값 ID10.0000.0000.0001.0000.0001.0000.000
단위 영문명1.0001.0001.0000.0001.0000.0000.000
분류값 명10.0000.0000.0001.0000.0001.0000.000
수록시점0.0000.0000.0000.0000.0000.0001.000
2024-01-14T15:42:12.238215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
항목ID단위 영문명분류값 명1단위명수록시점항목명
항목ID1.0000.9950.0000.9950.0001.000
단위 영문명0.9951.0000.0001.0000.0000.995
분류값 명10.0000.0001.0000.0000.0000.000
단위명0.9951.0000.0001.0000.0000.995
수록시점0.0000.0000.0000.0001.0000.000
항목명1.0000.9950.0000.9950.0001.000
2024-01-14T15:42:12.354458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분류값 ID1항목명항목ID단위명단위 영문명분류값 명1수록시점
분류값 ID11.0000.0000.0000.0000.0000.9810.000
항목명0.0001.0001.0000.9950.9950.0000.000
항목ID0.0001.0001.0000.9950.9950.0000.000
단위명0.0000.9950.9951.0001.0000.0000.000
단위 영문명0.0000.9950.9951.0001.0000.0000.000
분류값 명10.9810.0000.0000.0000.0001.0000.000
수록시점0.0000.0000.0000.0000.0000.0001.000

Missing values

2024-01-14T15:42:08.377989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-14T15:42:08.543427image/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

통계표ID기관코드수록주기항목명항목ID단위명분류값 ID1단위 영문명수치값분류값 명1수록시점분류값 영문명1통계표명분류명1
0DT_13204_2011_N223132A발생건수AA건101case7살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
1DT_13204_2011_N223132A검거건수BB건101case7살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
2DT_13204_2011_N223132A발생건수 대비 검거건수CC%101%100살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
3DT_13204_2011_N223132A검거인원DD명101Person7살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
4DT_13204_2011_N223132A남자검거인원DD1명101Person5살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
5DT_13204_2011_N223132A여자검거인원DD2명101Person2살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
6DT_13204_2011_N223132A불상검거인원DD3명101Person-살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
7DT_13204_2011_N223132A법인체DD4개101number-살인기수2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
8DT_13204_2011_N223132A발생건수AA건102case28살인미수등2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
9DT_13204_2011_N223132A검거건수BB건102case28살인미수등2020<NA>범죄 발생 및 검거 현황(충남청)죄종별
통계표ID기관코드수록주기항목명항목ID단위명분류값 ID1단위 영문명수치값분류값 명1수록시점분류값 영문명1통계표명분류명1
422DT_13204_2011_N223132A불상검거인원DD3명200010Person-절도(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
423DT_13204_2011_N223132A법인체DD4개200010number-절도(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
424DT_13204_2011_N223132A발생건수AA건200011case-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
425DT_13204_2011_N223132A검거건수BB건200011case-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
426DT_13204_2011_N223132A발생건수 대비 검거건수CC%200011%-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
427DT_13204_2011_N223132A검거인원DD명200011Person-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
428DT_13204_2011_N223132A남자검거인원DD1명200011Person-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
429DT_13204_2011_N223132A여자검거인원DD2명200011Person-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
430DT_13204_2011_N223132A불상검거인원DD3명200011Person-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별
431DT_13204_2011_N223132A법인체DD4개200011number-불법사용(상습)2022<NA>범죄 발생 및 검거 현황(충남청)죄종별