Overview

Dataset statistics

Number of variables5
Number of observations198
Missing cells0
Missing cells (%)0.0%
Duplicate rows4
Duplicate rows (%)2.0%
Total size in memory7.9 KiB
Average record size in memory40.7 B

Variable types

Categorical4
Text1

Dataset

Description경찰박물관에 전시중인 기념메달, 기념패 정보대분류-기념품류,중분류-기념품,소분류-기념메달, 기념패유물명, 년도
Author경찰청
URLhttps://www.data.go.kr/data/15063441/fileData.do

Alerts

대분류 has constant value ""Constant
중분류 has constant value ""Constant
Dataset has 4 (2.0%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 00:55:03.098648
Analysis finished2023-12-12 00:55:03.576527
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대분류
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
기념품류
198 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기념품류
2nd row기념품류
3rd row기념품류
4th row기념품류
5th row기념품류

Common Values

ValueCountFrequency (%)
기념품류 198
100.0%

Length

2023-12-12T09:55:03.654533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:55:03.771826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기념품류 198
100.0%

중분류
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
기념품
198 

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 (%)
기념품 198
100.0%

Length

2023-12-12T09:55:03.916098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:55:04.359610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기념품 198
100.0%

소분류
Categorical

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
기념패
175 
기념메달
23 

Length

Max length4
Median length3
Mean length3.1161616
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기념메달
2nd row기념메달
3rd row기념메달
4th row기념메달
5th row기념메달

Common Values

ValueCountFrequency (%)
기념패 175
88.4%
기념메달 23
 
11.6%

Length

2023-12-12T09:55:04.508638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:55:04.649153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기념패 175
88.4%
기념메달 23
 
11.6%

유물명
Text

Distinct144
Distinct (%)72.7%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-12T09:55:05.076936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length19
Mean length11.565657
Min length2

Characters and Unicode

Total characters2290
Distinct characters226
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique116 ?
Unique (%)58.6%

Sample

1st row(구)경찰대학 우등상 메달
2nd row일본 경시청 경찰학교 문진
3rd row통일주체국민회의 함여장
4th row일본 후쿠오카현 경찰본부장 문진
5th row바레인 내무부 문진
ValueCountFrequency (%)
기념패 127
21.9%
경찰 42
 
7.2%
중화민국 34
 
5.9%
문진 14
 
2.4%
중국 13
 
2.2%
방문 12
 
2.1%
일본 12
 
2.1%
국가안전보장패 10
 
1.7%
대만성 8
 
1.4%
내정부 7
 
1.2%
Other values (178) 301
51.9%
2023-12-12T09:55:05.745928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
383
 
16.7%
패 163
 
7.1%
기 150
 
6.6%
념 140
 
6.1%
경 121
 
5.3%
국 98
 
4.3%
찰 94
 
4.1%
중 57
 
2.5%
대 46
 
2.0%
민 44
 
1.9%
Other values (216) 994
43.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1876
81.9%
Space Separator 383
 
16.7%
Uppercase Letter 18
 
0.8%
Decimal Number 9
 
0.4%
Open Punctuation 2
 
0.1%
Close Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
패 163
 
8.7%
기 150
 
8.0%
념 140
 
7.5%
경 121
 
6.4%
국 98
 
5.2%
찰 94
 
5.0%
중 57
 
3.0%
대 46
 
2.5%
민 44
 
2.3%
화 36
 
1.9%
Other values (193) 927
49.4%
Uppercase Letter
ValueCountFrequency (%)
A 4
22.2%
N 2
11.1%
I 2
11.1%
M 1
 
5.6%
Y 1
 
5.6%
E 1
 
5.6%
D 1
 
5.6%
L 1
 
5.6%
C 1
 
5.6%
O 1
 
5.6%
Other values (3) 3
16.7%
Decimal Number
ValueCountFrequency (%)
1 3
33.3%
2 3
33.3%
3 1
 
11.1%
0 1
 
11.1%
7 1
 
11.1%
Open Punctuation
ValueCountFrequency (%)
( 1
50.0%
[ 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 1
50.0%
] 1
50.0%
Space Separator
ValueCountFrequency (%)
383
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1876
81.9%
Common 396
 
17.3%
Latin 18
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
패 163
 
8.7%
기 150
 
8.0%
념 140
 
7.5%
경 121
 
6.4%
국 98
 
5.2%
찰 94
 
5.0%
중 57
 
3.0%
대 46
 
2.5%
민 44
 
2.3%
화 36
 
1.9%
Other values (193) 927
49.4%
Latin
ValueCountFrequency (%)
A 4
22.2%
N 2
11.1%
I 2
11.1%
M 1
 
5.6%
Y 1
 
5.6%
E 1
 
5.6%
D 1
 
5.6%
L 1
 
5.6%
C 1
 
5.6%
O 1
 
5.6%
Other values (3) 3
16.7%
Common
ValueCountFrequency (%)
383
96.7%
1 3
 
0.8%
2 3
 
0.8%
3 1
 
0.3%
( 1
 
0.3%
) 1
 
0.3%
] 1
 
0.3%
0 1
 
0.3%
[ 1
 
0.3%
7 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1876
81.9%
ASCII 414
 
18.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
383
92.5%
A 4
 
1.0%
1 3
 
0.7%
2 3
 
0.7%
N 2
 
0.5%
I 2
 
0.5%
M 1
 
0.2%
Y 1
 
0.2%
E 1
 
0.2%
D 1
 
0.2%
Other values (13) 13
 
3.1%
Hangul
ValueCountFrequency (%)
패 163
 
8.7%
기 150
 
8.0%
념 140
 
7.5%
경 121
 
6.4%
국 98
 
5.2%
찰 94
 
5.0%
중 57
 
3.0%
대 46
 
2.5%
민 44
 
2.3%
화 36
 
1.9%
Other values (193) 927
49.4%

년도
Categorical

Distinct40
Distinct (%)20.2%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
미상
27 
1985
16 
1984
15 
1980
14 
1999
 
10
Other values (35)
116 

Length

Max length4
Median length4
Mean length3.7272727
Min length2

Unique

Unique10 ?
Unique (%)5.1%

Sample

1st row1972
2nd row1972
3rd row1977
4th row1980
5th row1980

Common Values

ValueCountFrequency (%)
미상 27
 
13.6%
1985 16
 
8.1%
1984 15
 
7.6%
1980 14
 
7.1%
1999 10
 
5.1%
1986 9
 
4.5%
1987 9
 
4.5%
1992 7
 
3.5%
2000 6
 
3.0%
1993 6
 
3.0%
Other values (30) 79
39.9%

Length

2023-12-12T09:55:05.937643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
미상 27
 
13.6%
1985 16
 
8.1%
1984 15
 
7.6%
1980 14
 
7.1%
1999 10
 
5.1%
1986 9
 
4.5%
1987 9
 
4.5%
1992 7
 
3.5%
2000 6
 
3.0%
1993 6
 
3.0%
Other values (30) 79
39.9%

Correlations

2023-12-12T09:55:06.056171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소분류년도
소분류1.0000.040
년도0.0401.000
2023-12-12T09:55:06.157341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
년도소분류
년도1.0000.000
소분류0.0001.000
2023-12-12T09:55:06.280554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소분류년도
소분류1.0000.000
년도0.0001.000

Missing values

2023-12-12T09:55:03.402002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:55:03.527314image/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

대분류중분류소분류유물명년도
0기념품류기념품기념메달(구)경찰대학 우등상 메달1972
1기념품류기념품기념메달일본 경시청 경찰학교 문진1972
2기념품류기념품기념메달통일주체국민회의 함여장1977
3기념품류기념품기념메달일본 후쿠오카현 경찰본부장 문진1980
4기념품류기념품기념메달바레인 내무부 문진1980
5기념품류기념품기념메달일본 경찰대학교 문진1980
6기념품류기념품기념메달통일주체국민회의 대의원 재임 기장1980
7기념품류기념품기념메달10년협력치안유공기념 메달1984
8기념품류기념품기념메달일본 경찰대학교 문진1985
9기념품류기념품기념메달서울경찰기동대 하계 야영훈련 기념 벽메달1986
대분류중분류소분류유물명년도
188기념품류기념품기념패기념패미상
189기념품류기념품기념패파키스탄 경찰 기념패미상
190기념품류기념품기념패브라질 경찰 기념패미상
191기념품류기념품기념패홍콩 경찰 기념패미상
192기념품류기념품기념패산둥성 공안부 기념패미상
193기념품류기념품기념패베트남 경찰 기념패미상
194기념품류기념품기념패파키스탄 경찰 기념패미상
195기념품류기념품기념패싱가폴 경찰 기념패미상
196기념품류기념품기념패영국 버밍엄 경찰 기념패미상
197기념품류기념품기념패상패미상

Duplicate rows

Most frequently occurring

대분류중분류소분류유물명년도# duplicates
3기념품류기념품기념패파키스탄 경찰 기념패미상3
0기념품류기념품기념패싱가폴 경찰 기념패미상2
1기념품류기념품기념패중화민국 중앙경관학교 기념패19802
2기념품류기념품기념패추대패19812