Overview

Dataset statistics

Number of variables6
Number of observations221
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.5 KiB
Average record size in memory48.6 B

Variable types

Text1
Categorical4
DateTime1

Dataset

Description경기도 고양시_수렵면허교부신청내역현황 데이터는 면허번호, 접수구분, 면허종별, 총기류, 수렵방법, 교부일자 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/3079750/fileData.do

Alerts

총기류 is highly overall correlated with 면허종별 and 1 other fieldsHigh correlation
면허종별 is highly overall correlated with 총기류 and 1 other fieldsHigh correlation
수렵방법 is highly overall correlated with 면허종별 and 1 other fieldsHigh correlation
면허종별 is highly imbalanced (73.4%)Imbalance
총기류 is highly imbalanced (64.1%)Imbalance
수렵방법 is highly imbalanced (80.6%)Imbalance
면허번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:40:45.612006
Analysis finished2023-12-12 17:40:45.986392
Duration0.37 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

면허번호
Text

UNIQUE 

Distinct221
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-13T02:40:46.194238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique

Unique221 ?
Unique (%)100.0%

Sample

1st row2023-00024
2nd row2023-00023
3rd row2023-00022
4th row2023-00021
5th row2023-00020
ValueCountFrequency (%)
2023-00024 1
 
0.5%
2019-00017 1
 
0.5%
2019-00015 1
 
0.5%
2019-00014 1
 
0.5%
2019-00013 1
 
0.5%
2019-00012 1
 
0.5%
2019-00011 1
 
0.5%
2019-00010 1
 
0.5%
2019-00008 1
 
0.5%
2019-00007 1
 
0.5%
Other values (211) 211
95.5%
2023-12-13T02:40:46.549395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 970
43.9%
2 462
20.9%
- 221
 
10.0%
1 194
 
8.8%
3 76
 
3.4%
9 64
 
2.9%
5 56
 
2.5%
8 46
 
2.1%
4 45
 
2.0%
6 44
 
2.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1989
90.0%
Dash Punctuation 221
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 970
48.8%
2 462
23.2%
1 194
 
9.8%
3 76
 
3.8%
9 64
 
3.2%
5 56
 
2.8%
8 46
 
2.3%
4 45
 
2.3%
6 44
 
2.2%
7 32
 
1.6%
Dash Punctuation
ValueCountFrequency (%)
- 221
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2210
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 970
43.9%
2 462
20.9%
- 221
 
10.0%
1 194
 
8.8%
3 76
 
3.4%
9 64
 
2.9%
5 56
 
2.5%
8 46
 
2.1%
4 45
 
2.0%
6 44
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2210
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 970
43.9%
2 462
20.9%
- 221
 
10.0%
1 194
 
8.8%
3 76
 
3.4%
9 64
 
2.9%
5 56
 
2.5%
8 46
 
2.1%
4 45
 
2.0%
6 44
 
2.0%

접수구분
Categorical

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
갱신
122 
신규
78 
변경
16 
재교부(분실)
 
5

Length

Max length7
Median length2
Mean length2.1131222
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row갱신
2nd row갱신
3rd row갱신
4th row신규
5th row신규

Common Values

ValueCountFrequency (%)
갱신 122
55.2%
신규 78
35.3%
변경 16
 
7.2%
재교부(분실) 5
 
2.3%

Length

2023-12-13T02:40:46.663289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:40:46.749693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
갱신 122
55.2%
신규 78
35.3%
변경 16
 
7.2%
재교부(분실 5
 
2.3%

면허종별
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
1종
211 
2종
 
10

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1종
2nd row1종
3rd row1종
4th row1종
5th row1종

Common Values

ValueCountFrequency (%)
1종 211
95.5%
2종 10
 
4.5%

Length

2023-12-13T02:40:46.833105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:40:46.927022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1종 211
95.5%
2종 10
 
4.5%

총기류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
엽총및공기총
194 
엽총
 
12
활등
 
10
공기총
 
5

Length

Max length6
Median length6
Mean length5.5339367
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row엽총및공기총
2nd row엽총및공기총
3rd row엽총및공기총
4th row엽총및공기총
5th row엽총및공기총

Common Values

ValueCountFrequency (%)
엽총및공기총 194
87.8%
엽총 12
 
5.4%
활등 10
 
4.5%
공기총 5
 
2.3%

Length

2023-12-13T02:40:47.019069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:40:47.111018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
엽총및공기총 194
87.8%
엽총 12
 
5.4%
활등 10
 
4.5%
공기총 5
 
2.3%

수렵방법
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
엽총및공기총에의한수렵
210 
활등에의한수렵
 
10
기타에의한수렵
 
1

Length

Max length11
Median length11
Mean length10.800905
Min length7

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row엽총및공기총에의한수렵
2nd row엽총및공기총에의한수렵
3rd row엽총및공기총에의한수렵
4th row엽총및공기총에의한수렵
5th row엽총및공기총에의한수렵

Common Values

ValueCountFrequency (%)
엽총및공기총에의한수렵 210
95.0%
활등에의한수렵 10
 
4.5%
기타에의한수렵 1
 
0.5%

Length

2023-12-13T02:40:47.219121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:40:47.538813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
엽총및공기총에의한수렵 210
95.0%
활등에의한수렵 10
 
4.5%
기타에의한수렵 1
 
0.5%

교부일자
Date

Distinct179
Distinct (%)81.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
Minimum2012-01-26 00:00:00
Maximum2023-08-24 00:00:00
2023-12-13T02:40:47.639080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:40:47.777335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2023-12-13T02:40:47.899291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
접수구분면허종별총기류수렵방법
접수구분1.0000.0000.3620.000
면허종별0.0001.0001.0001.000
총기류0.3621.0001.0000.673
수렵방법0.0001.0000.6731.000
2023-12-13T02:40:48.001379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
총기류면허종별수렵방법접수구분
총기류1.0000.9950.7010.148
면허종별0.9951.0000.9980.000
수렵방법0.7010.9981.0000.000
접수구분0.1480.0000.0001.000
2023-12-13T02:40:48.098459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
접수구분면허종별총기류수렵방법
접수구분1.0000.0000.1480.000
면허종별0.0001.0000.9950.998
총기류0.1480.9951.0000.701
수렵방법0.0000.9980.7011.000

Missing values

2023-12-13T02:40:45.848164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:40:45.947455image/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

면허번호접수구분면허종별총기류수렵방법교부일자
02023-00024갱신1종엽총및공기총엽총및공기총에의한수렵2023-08-24
12023-00023갱신1종엽총및공기총엽총및공기총에의한수렵2023-08-22
22023-00022갱신1종엽총및공기총엽총및공기총에의한수렵2023-08-17
32023-00021신규1종엽총및공기총엽총및공기총에의한수렵2023-08-10
42023-00020신규1종엽총및공기총엽총및공기총에의한수렵2023-08-02
52023-00019변경1종엽총및공기총엽총및공기총에의한수렵2023-07-26
62023-00018신규1종엽총및공기총엽총및공기총에의한수렵2023-07-03
72023-00017갱신1종엽총및공기총엽총및공기총에의한수렵2023-06-26
82023-00016신규1종엽총및공기총엽총및공기총에의한수렵2023-06-20
92023-00015갱신1종엽총및공기총엽총및공기총에의한수렵2023-06-09
면허번호접수구분면허종별총기류수렵방법교부일자
2112015-00042신규1종엽총및공기총기타에의한수렵2015-09-25
2122015-00031갱신1종엽총및공기총엽총및공기총에의한수렵2015-06-30
2132015-00030신규1종엽총및공기총엽총및공기총에의한수렵2015-06-22
2142015-00029변경1종엽총및공기총엽총및공기총에의한수렵2015-06-19
2152015-00026변경1종엽총및공기총엽총및공기총에의한수렵2016-04-18
2162015-00021재교부(분실)1종엽총및공기총엽총및공기총에의한수렵2015-09-24
2172015-00011갱신1종엽총및공기총엽총및공기총에의한수렵2015-03-25
2182014-00041갱신1종엽총및공기총엽총및공기총에의한수렵2014-11-06
2192012-00036갱신1종엽총및공기총엽총및공기총에의한수렵2017-11-07
2202012-00002갱신1종엽총및공기총엽총및공기총에의한수렵2012-01-26