Overview

Dataset statistics

Number of variables11
Number of observations49
Missing cells197
Missing cells (%)36.5%
Duplicate rows2
Duplicate rows (%)4.1%
Total size in memory4.5 KiB
Average record size in memory93.7 B

Variable types

Text1
Categorical1
Unsupported9

Dataset

Description살인, 강도, 강간, 절도, 폭력 등 전남 5대범죄 현황
Author경찰청 전라남도경찰청
URLhttps://www.data.go.kr/data/15048934/fileData.do

Alerts

Dataset has 2 (4.1%) duplicate rowsDuplicates
조회기간 : 2019.01.01 ~ 2019.12.31 has 26 (53.1%) missing valuesMissing
Unnamed: 2 has 4 (8.2%) missing valuesMissing
총괄 has 49 (100.0%) missing valuesMissing
Unnamed: 4 has 4 (8.2%) missing valuesMissing
Unnamed: 5 has 49 (100.0%) missing valuesMissing
Unnamed: 6 has 4 (8.2%) missing valuesMissing
Unnamed: 7 has 4 (8.2%) missing valuesMissing
Unnamed: 8 has 4 (8.2%) missing valuesMissing
Unnamed: 9 has 49 (100.0%) missing valuesMissing
Unnamed: 10 has 4 (8.2%) missing valuesMissing
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
총괄 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

Reproduction

Analysis started2023-12-12 04:37:43.655652
Analysis finished2023-12-12 04:37:44.209277
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조회기간 : 2019.01.01 ~ 2019.12.31
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing26
Missing (%)53.1%
Memory size524.0 B
2023-12-12T13:37:44.367161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length7
Mean length8
Min length7

Characters and Unicode

Total characters184
Distinct characters44
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

Unique23 ?
Unique (%)100.0%

Sample

1st row 관서명 구분
2nd row전남지방경찰청계
3rd row전남목포경찰서
4th row전남여수경찰서
5th row전남순천경찰서
ValueCountFrequency (%)
관서명 1
 
4.2%
구분 1
 
4.2%
전남화순경찰서 1
 
4.2%
전남진도경찰서 1
 
4.2%
전남무안경찰서 1
 
4.2%
전남완도경찰서 1
 
4.2%
전남곡성경찰서 1
 
4.2%
전남담양경찰서 1
 
4.2%
전남강진경찰서 1
 
4.2%
전남장성경찰서 1
 
4.2%
Other values (14) 14
58.3%
2023-12-12T13:37:44.723704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
24
13.0%
남 23
12.5%
서 22
12.0%
전 22
12.0%
경 22
12.0%
찰 22
12.0%
성 3
 
1.6%
진 2
 
1.1%
영 2
 
1.1%
장 2
 
1.1%
Other values (34) 40
21.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 160
87.0%
Space Separator 24
 
13.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 23
14.4%
서 22
13.8%
전 22
13.8%
경 22
13.8%
찰 22
13.8%
성 3
 
1.9%
진 2
 
1.2%
영 2
 
1.2%
장 2
 
1.2%
흥 2
 
1.2%
Other values (33) 38
23.8%
Space Separator
ValueCountFrequency (%)
24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 160
87.0%
Common 24
 
13.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 23
14.4%
서 22
13.8%
전 22
13.8%
경 22
13.8%
찰 22
13.8%
성 3
 
1.9%
진 2
 
1.2%
영 2
 
1.2%
장 2
 
1.2%
흥 2
 
1.2%
Other values (33) 38
23.8%
Common
ValueCountFrequency (%)
24
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 160
87.0%
ASCII 24
 
13.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
24
100.0%
Hangul
ValueCountFrequency (%)
남 23
14.4%
서 22
13.8%
전 22
13.8%
경 22
13.8%
찰 22
13.8%
성 3
 
1.9%
진 2
 
1.2%
영 2
 
1.2%
장 2
 
1.2%
흥 2
 
1.2%
Other values (33) 38
23.8%

Unnamed: 1
Categorical

Distinct3
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
발 생 건 수
22 
검 거 건 수
22 
<NA>
5 

Length

Max length10
Median length10
Mean length9.3877551
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row발 생 건 수
3rd row검 거 건 수
4th row<NA>
5th row발 생 건 수

Common Values

ValueCountFrequency (%)
발 생 건 수 22
44.9%
검 거 건 수 22
44.9%
<NA> 5
 
10.2%

Length

2023-12-12T13:37:44.894269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:37:45.062286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건 44
24.3%
수 44
24.3%
발 22
12.2%
생 22
12.2%
검 22
12.2%
거 22
12.2%
na 5
 
2.8%

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.2%
Memory size524.0 B

총괄
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing49
Missing (%)100.0%
Memory size573.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.2%
Memory size524.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing49
Missing (%)100.0%
Memory size573.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.2%
Memory size524.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.2%
Memory size524.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.2%
Memory size524.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing49
Missing (%)100.0%
Memory size573.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)8.2%
Memory size524.0 B

Correlations

2023-12-12T13:37:45.137641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조회기간 : 2019.01.01 ~ 2019.12.31Unnamed: 1
조회기간 : 2019.01.01 ~ 2019.12.311.000NaN
Unnamed: 1NaN1.000

Missing values

2023-12-12T13:37:43.817389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:37:43.970084image/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.
2023-12-12T13:37:44.115434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

조회기간 : 2019.01.01 ~ 2019.12.31Unnamed: 1Unnamed: 2총괄Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10
0관서명 구분<NA>소계<NA>살인<NA>강도강간절도<NA>폭력
1전남지방경찰청계발 생 건 수16651<NA>25<NA>277405668<NA>10191
2<NA>검 거 건 수13664<NA>28<NA>287193642<NA>9247
3<NA><NA>NaN<NA>NaN<NA>NaNNaNNaN<NA>NaN
4전남목포경찰서발 생 건 수3457<NA>4<NA>81651226<NA>2054
5<NA>검 거 건 수2704<NA>6<NA>9147697<NA>1845
6전남여수경찰서발 생 건 수2971<NA>1<NA>387902<NA>1978
7<NA>검 거 건 수2374<NA>1<NA>376547<NA>1747
8전남순천경찰서발 생 건 수2598<NA>4<NA>1123782<NA>1688
9<NA>검 거 건 수2174<NA>4<NA>0114509<NA>1547
조회기간 : 2019.01.01 ~ 2019.12.31Unnamed: 1Unnamed: 2총괄Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10
39<NA>검 거 건 수149<NA>0<NA>1847<NA>93
40<NA><NA>NaN<NA>NaN<NA>NaNNaNNaN<NA>NaN
41전남완도경찰서발 생 건 수472<NA>1<NA>121148<NA>301
42<NA>검 거 건 수370<NA>1<NA>12074<NA>274
43전남무안경찰서발 생 건 수442<NA>1<NA>128187<NA>225
44<NA>검 거 건 수354<NA>1<NA>121132<NA>199
45전남진도경찰서발 생 건 수288<NA>0<NA>018111<NA>159
46<NA>검 거 건 수237<NA>0<NA>01074<NA>153
47전남구례경찰서발 생 건 수218<NA>0<NA>0575<NA>138
48<NA>검 거 건 수184<NA>0<NA>0258<NA>124

Duplicate rows

Most frequently occurring

조회기간 : 2019.01.01 ~ 2019.12.31Unnamed: 1# duplicates
0<NA>검 거 건 수22
1<NA><NA>4