Overview

Dataset statistics

Number of variables8
Number of observations878
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory55.9 KiB
Average record size in memory65.1 B

Variable types

Numeric1
Text1
DateTime3
Categorical3

Dataset

Description남양주시 수렵면허 현황에 대한 데이터로 면허번호, 교부일자, 면허구분, 유효기간시작일, 만료일, 종별 항목을 제공합니다.
Author경기도 남양주시
URLhttps://www.data.go.kr/data/3074186/fileData.do

Alerts

데이터 기준일 has constant value ""Constant
종별 is highly imbalanced (83.7%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 17:34:52.635463
Analysis finished2024-03-14 17:34:53.875583
Duration1.24 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct878
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean439.5
Minimum1
Maximum878
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.8 KiB
2024-03-15T02:34:54.123966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile44.85
Q1220.25
median439.5
Q3658.75
95-th percentile834.15
Maximum878
Range877
Interquartile range (IQR)438.5

Descriptive statistics

Standard deviation253.60106
Coefficient of variation (CV)0.57702176
Kurtosis-1.2
Mean439.5
Median Absolute Deviation (MAD)219.5
Skewness0
Sum385881
Variance64313.5
MonotonicityStrictly increasing
2024-03-15T02:34:54.823372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
591 1
 
0.1%
580 1
 
0.1%
581 1
 
0.1%
582 1
 
0.1%
583 1
 
0.1%
584 1
 
0.1%
585 1
 
0.1%
586 1
 
0.1%
587 1
 
0.1%
Other values (868) 868
98.9%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
878 1
0.1%
877 1
0.1%
876 1
0.1%
875 1
0.1%
874 1
0.1%
873 1
0.1%
872 1
0.1%
871 1
0.1%
870 1
0.1%
869 1
0.1%

면허 번호
Text

Distinct872
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
2024-03-15T02:34:56.325180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters8780
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

Unique866 ?
Unique (%)98.6%

Sample

1st row1998-00005
2nd row1999-00009
3rd row1999-00017
4th row1999-00024
5th row1999-00025
ValueCountFrequency (%)
2014-00013 2
 
0.2%
2008-00040 2
 
0.2%
2008-00023 2
 
0.2%
2012-00016 2
 
0.2%
2010-00022 2
 
0.2%
2021-00005 2
 
0.2%
2018-00008 1
 
0.1%
2018-00012 1
 
0.1%
2018-00011 1
 
0.1%
2018-00010 1
 
0.1%
Other values (862) 862
98.2%
2024-03-15T02:34:58.126925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 3981
45.3%
2 1461
 
16.6%
- 878
 
10.0%
1 815
 
9.3%
4 292
 
3.3%
3 279
 
3.2%
5 278
 
3.2%
6 211
 
2.4%
7 209
 
2.4%
9 208
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7902
90.0%
Dash Punctuation 878
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 3981
50.4%
2 1461
 
18.5%
1 815
 
10.3%
4 292
 
3.7%
3 279
 
3.5%
5 278
 
3.5%
6 211
 
2.7%
7 209
 
2.6%
9 208
 
2.6%
8 168
 
2.1%
Dash Punctuation
ValueCountFrequency (%)
- 878
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 8780
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 3981
45.3%
2 1461
 
16.6%
- 878
 
10.0%
1 815
 
9.3%
4 292
 
3.3%
3 279
 
3.2%
5 278
 
3.2%
6 211
 
2.4%
7 209
 
2.4%
9 208
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8780
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 3981
45.3%
2 1461
 
16.6%
- 878
 
10.0%
1 815
 
9.3%
4 292
 
3.3%
3 279
 
3.2%
5 278
 
3.2%
6 211
 
2.4%
7 209
 
2.4%
9 208
 
2.4%

교부일
Date

Distinct648
Distinct (%)73.8%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
Minimum1998-11-20 00:00:00
Maximum2024-01-20 00:00:00
2024-03-15T02:34:58.530701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:34:59.011741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

구분
Categorical

Distinct5
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
갱신
499 
신규
258 
변경
67 
재교부(분실)
53 
재교부(훼손)
 
1

Length

Max length7
Median length2
Mean length2.3075171
Min length2

Unique

Unique1 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
갱신 499
56.8%
신규 258
29.4%
변경 67
 
7.6%
재교부(분실) 53
 
6.0%
재교부(훼손) 1
 
0.1%

Length

2024-03-15T02:34:59.446273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:34:59.749350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
갱신 499
56.8%
신규 258
29.4%
변경 67
 
7.6%
재교부(분실 53
 
6.0%
재교부(훼손 1
 
0.1%

유효기간 시작일
Date

Distinct648
Distinct (%)73.8%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
Minimum1998-11-20 00:00:00
Maximum2024-01-20 00:00:00
2024-03-15T02:35:00.106428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:35:00.557531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

유효기간 만료인
Date

Distinct649
Distinct (%)73.9%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
Minimum2003-11-19 00:00:00
Maximum2029-01-19 00:00:00
2024-03-15T02:35:00.896550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:35:01.290654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

종별
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
1종
857 
2종
 
21

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종 857
97.6%
2종 21
 
2.4%

Length

2024-03-15T02:35:01.705634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:35:02.024257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1종 857
97.6%
2종 21
 
2.4%

데이터 기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.0 KiB
2024-01-24
878 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-24
2nd row2024-01-24
3rd row2024-01-24
4th row2024-01-24
5th row2024-01-24

Common Values

ValueCountFrequency (%)
2024-01-24 878
100.0%

Length

2024-03-15T02:35:02.375358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T02:35:02.541162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-24 878
100.0%

Interactions

2024-03-15T02:34:52.926912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T02:35:02.649050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분종별
연번1.0000.3200.000
구분0.3201.0000.066
종별0.0000.0661.000
2024-03-15T02:35:02.806314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분종별
구분1.0000.081
종별0.0811.000
2024-03-15T02:35:02.942893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분종별
연번1.0000.1380.000
구분0.1381.0000.081
종별0.0000.0811.000

Missing values

2024-03-15T02:34:53.280264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T02:34:53.741134image/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

연번면허 번호교부일구분유효기간 시작일유효기간 만료인종별데이터 기준일
011998-000051998-11-20신규1998-11-202003-11-191종2024-01-24
121999-000091999-12-31신규1999-12-312004-12-301종2024-01-24
231999-000171999-10-28신규1999-10-282004-10-271종2024-01-24
341999-000241999-12-02신규1999-12-022004-12-011종2024-01-24
451999-000251999-12-28신규1999-12-282004-12-271종2024-01-24
561999-000351999-12-23신규1999-12-232004-12-221종2024-01-24
671999-000391999-10-22신규1999-10-222004-10-211종2024-01-24
781999-000411999-01-29신규1999-01-292004-01-281종2024-01-24
892000-000062000-10-19신규2000-10-192005-10-181종2024-01-24
9102000-000172000-10-19신규2000-10-192005-10-181종2024-01-24
연번면허 번호교부일구분유효기간 시작일유효기간 만료인종별데이터 기준일
8688692023-000262023-08-28갱신2023-08-282028-08-271종2024-01-24
8698702023-000272023-10-23갱신2023-10-232028-10-221종2024-01-24
8708712023-000282023-10-04신규2023-10-042028-10-031종2024-01-24
8718722023-000292023-10-17신규2023-10-172028-10-161종2024-01-24
8728732023-000302023-10-30신규2023-10-302028-10-291종2024-01-24
8738742023-000312023-10-31신규2023-10-312028-10-301종2024-01-24
8748752023-000322023-11-07신규2023-11-072028-11-061종2024-01-24
8758762023-000332023-11-08신규2023-11-082028-11-072종2024-01-24
8768772023-000342023-08-01갱신2023-08-012028-07-311종2024-01-24
8778782024-000012024-01-20신규2024-01-202029-01-191종2024-01-24