Overview

Dataset statistics

Number of variables7
Number of observations213
Missing cells177
Missing cells (%)11.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.0 KiB
Average record size in memory57.6 B

Variable types

Numeric1
Categorical4
Text2

Dataset

Description해남군 쓰레기 상습 불법 투기 지역의 지번 항목을 제공합니다. 수시 단속하여 깨끗한 해남 만들기 추진에 이용하고 있습니다.
URLhttps://www.data.go.kr/data/15101518/fileData.do

Alerts

시군구명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
관할기관명 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
투기위치 has 177 (83.1%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:07:55.539358
Analysis finished2023-12-12 20:07:56.385790
Duration0.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct213
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean107
Minimum1
Maximum213
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-13T05:07:56.488279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile11.6
Q154
median107
Q3160
95-th percentile202.4
Maximum213
Range212
Interquartile range (IQR)106

Descriptive statistics

Standard deviation61.631972
Coefficient of variation (CV)0.57599974
Kurtosis-1.2
Mean107
Median Absolute Deviation (MAD)53
Skewness0
Sum22791
Variance3798.5
MonotonicityStrictly increasing
2023-12-13T05:07:56.700693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
135 1
 
0.5%
137 1
 
0.5%
138 1
 
0.5%
139 1
 
0.5%
140 1
 
0.5%
141 1
 
0.5%
142 1
 
0.5%
143 1
 
0.5%
144 1
 
0.5%
Other values (203) 203
95.3%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
213 1
0.5%
212 1
0.5%
211 1
0.5%
210 1
0.5%
209 1
0.5%
208 1
0.5%
207 1
0.5%
206 1
0.5%
205 1
0.5%
204 1
0.5%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
해남군
213 

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 (%)
해남군 213
100.0%

Length

2023-12-13T05:07:56.873692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:07:57.014936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해남군 213
100.0%

투기위치
Text

MISSING 

Distinct29
Distinct (%)80.6%
Missing177
Missing (%)83.1%
Memory size1.8 KiB
2023-12-13T05:07:57.277264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length10
Mean length6.8888889
Min length3

Characters and Unicode

Total characters248
Distinct characters103
Distinct categories4 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)77.8%

Sample

1st row성민교회 앞
2nd row서림공원
3rd row제일빌라 앞
4th row5일시장 주차장
5th row동외교
ValueCountFrequency (%)
9
 
13.6%
공동집하장 8
 
12.1%
주차장 2
 
3.0%
입구 2
 
3.0%
부근 2
 
3.0%
2
 
3.0%
5일시장 2
 
3.0%
성민교회 1
 
1.5%
다우아파트 1
 
1.5%
평동떡방앗간 1
 
1.5%
Other values (36) 36
54.5%
2023-12-13T05:07:57.755314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
30
 
12.1%
16
 
6.5%
12
 
4.8%
11
 
4.4%
11
 
4.4%
9
 
3.6%
9
 
3.6%
8
 
3.2%
4
 
1.6%
3
 
1.2%
Other values (93) 135
54.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 215
86.7%
Space Separator 30
 
12.1%
Decimal Number 2
 
0.8%
Letter Number 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
16
 
7.4%
12
 
5.6%
11
 
5.1%
11
 
5.1%
9
 
4.2%
9
 
4.2%
8
 
3.7%
4
 
1.9%
3
 
1.4%
3
 
1.4%
Other values (90) 129
60.0%
Space Separator
ValueCountFrequency (%)
30
100.0%
Decimal Number
ValueCountFrequency (%)
5 2
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 215
86.7%
Common 32
 
12.9%
Latin 1
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
16
 
7.4%
12
 
5.6%
11
 
5.1%
11
 
5.1%
9
 
4.2%
9
 
4.2%
8
 
3.7%
4
 
1.9%
3
 
1.4%
3
 
1.4%
Other values (90) 129
60.0%
Common
ValueCountFrequency (%)
30
93.8%
5 2
 
6.2%
Latin
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 215
86.7%
ASCII 32
 
12.9%
Number Forms 1
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
30
93.8%
5 2
 
6.2%
Hangul
ValueCountFrequency (%)
16
 
7.4%
12
 
5.6%
11
 
5.1%
11
 
5.1%
9
 
4.2%
9
 
4.2%
8
 
3.7%
4
 
1.9%
3
 
1.4%
3
 
1.4%
Other values (90) 129
60.0%
Number Forms
ValueCountFrequency (%)
1
100.0%
Distinct208
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-13T05:07:58.183254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length12.530516
Min length7

Characters and Unicode

Total characters2669
Distinct characters121
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique203 ?
Unique (%)95.3%

Sample

1st row해남읍 고도리 95-20
2nd row해남읍 고도리 142-4
3rd row해남읍 구교리 886
4th row해남읍 구교리 910
5th row해남읍 구교리 917-3
ValueCountFrequency (%)
해남읍 42
 
6.5%
황산면 18
 
2.8%
산이면 18
 
2.8%
삼산면 16
 
2.5%
화산면 16
 
2.5%
북평면 16
 
2.5%
옥천면 14
 
2.2%
문내면 13
 
2.0%
북일면 12
 
1.9%
마산면 11
 
1.7%
Other values (322) 468
72.7%
2023-12-13T05:07:58.777984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
449
16.8%
208
 
7.8%
171
 
6.4%
1 163
 
6.1%
- 141
 
5.3%
124
 
4.6%
2 100
 
3.7%
4 90
 
3.4%
6 76
 
2.8%
3 75
 
2.8%
Other values (111) 1072
40.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1295
48.5%
Decimal Number 784
29.4%
Space Separator 449
 
16.8%
Dash Punctuation 141
 
5.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
208
 
16.1%
171
 
13.2%
124
 
9.6%
57
 
4.4%
55
 
4.2%
43
 
3.3%
31
 
2.4%
28
 
2.2%
27
 
2.1%
23
 
1.8%
Other values (99) 528
40.8%
Decimal Number
ValueCountFrequency (%)
1 163
20.8%
2 100
12.8%
4 90
11.5%
6 76
9.7%
3 75
9.6%
5 61
 
7.8%
8 57
 
7.3%
9 55
 
7.0%
0 54
 
6.9%
7 53
 
6.8%
Space Separator
ValueCountFrequency (%)
449
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 141
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1374
51.5%
Hangul 1295
48.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
208
 
16.1%
171
 
13.2%
124
 
9.6%
57
 
4.4%
55
 
4.2%
43
 
3.3%
31
 
2.4%
28
 
2.2%
27
 
2.1%
23
 
1.8%
Other values (99) 528
40.8%
Common
ValueCountFrequency (%)
449
32.7%
1 163
 
11.9%
- 141
 
10.3%
2 100
 
7.3%
4 90
 
6.6%
6 76
 
5.5%
3 75
 
5.5%
5 61
 
4.4%
8 57
 
4.1%
9 55
 
4.0%
Other values (2) 107
 
7.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1374
51.5%
Hangul 1295
48.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
449
32.7%
1 163
 
11.9%
- 141
 
10.3%
2 100
 
7.3%
4 90
 
6.6%
6 76
 
5.5%
3 75
 
5.5%
5 61
 
4.4%
8 57
 
4.1%
9 55
 
4.0%
Other values (2) 107
 
7.8%
Hangul
ValueCountFrequency (%)
208
 
16.1%
171
 
13.2%
124
 
9.6%
57
 
4.4%
55
 
4.2%
43
 
3.3%
31
 
2.4%
28
 
2.2%
27
 
2.1%
23
 
1.8%
Other values (99) 528
40.8%

관할기관명
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
해남읍
42 
황산면
18 
산이면
18 
화산면
17 
북평면
16 
Other values (9)
102 

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 (%)
해남읍 42
19.7%
황산면 18
8.5%
산이면 18
8.5%
화산면 17
8.0%
북평면 16
 
7.5%
삼산면 15
 
7.0%
옥천면 14
 
6.6%
문내면 13
 
6.1%
북일면 12
 
5.6%
송지면 11
 
5.2%
Other values (4) 37
17.4%

Length

2023-12-13T05:07:58.909028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
해남읍 42
19.7%
황산면 18
8.5%
산이면 18
8.5%
화산면 17
8.0%
북평면 16
 
7.5%
삼산면 15
 
7.0%
옥천면 14
 
6.6%
문내면 13
 
6.1%
북일면 12
 
5.6%
송지면 11
 
5.2%
Other values (4) 37
17.4%

관리기관전화번호
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
061-531-7352
42 
061-531-3467
18 
061-531-3514
18 
061-531-3066
17 
061-531-3216
16 
Other values (9)
102 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row061-531-7352
2nd row061-531-7352
3rd row061-531-7352
4th row061-531-7352
5th row061-531-7352

Common Values

ValueCountFrequency (%)
061-531-7352 42
19.7%
061-531-3467 18
8.5%
061-531-3514 18
8.5%
061-531-3066 17
8.0%
061-531-3216 16
 
7.5%
061-531-3014 15
 
7.0%
061-531-3316 14
 
6.6%
061-531-3564 13
 
6.1%
061-531-3266 12
 
5.6%
061-531-3163 11
 
5.2%
Other values (4) 37
17.4%

Length

2023-12-13T05:07:59.027980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
061-531-7352 42
19.7%
061-531-3467 18
8.5%
061-531-3514 18
8.5%
061-531-3066 17
8.0%
061-531-3216 16
 
7.5%
061-531-3014 15
 
7.0%
061-531-3316 14
 
6.6%
061-531-3564 13
 
6.1%
061-531-3266 12
 
5.6%
061-531-3163 11
 
5.2%
Other values (4) 37
17.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-07-01
213 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-01
2nd row2023-07-01
3rd row2023-07-01
4th row2023-07-01
5th row2023-07-01

Common Values

ValueCountFrequency (%)
2023-07-01 213
100.0%

Length

2023-12-13T05:07:59.152369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:07:59.260486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-01 213
100.0%

Interactions

2023-12-13T05:07:55.788081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:07:59.326312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번투기위치관할기관명관리기관전화번호
연번1.0000.0000.9580.958
투기위치0.0001.0000.0000.000
관할기관명0.9580.0001.0001.000
관리기관전화번호0.9580.0001.0001.000
2023-12-13T05:07:59.425135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관할기관명관리기관전화번호
관할기관명1.0001.000
관리기관전화번호1.0001.000
2023-12-13T05:07:59.504686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관할기관명관리기관전화번호
연번1.0000.8190.819
관할기관명0.8191.0001.000
관리기관전화번호0.8191.0001.000

Missing values

2023-12-13T05:07:56.212414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:07:56.337850image/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

연번시군구명투기위치지번주소관할기관명관리기관전화번호데이터기준일자
01해남군<NA>해남읍 고도리 95-20해남읍061-531-73522023-07-01
12해남군성민교회 앞해남읍 고도리 142-4해남읍061-531-73522023-07-01
23해남군<NA>해남읍 구교리 886해남읍061-531-73522023-07-01
34해남군<NA>해남읍 구교리 910해남읍061-531-73522023-07-01
45해남군<NA>해남읍 구교리 917-3해남읍061-531-73522023-07-01
56해남군<NA>해남읍 구교리 25해남읍061-531-73522023-07-01
67해남군서림공원해남읍 구교리 334-4해남읍061-531-73522023-07-01
78해남군<NA>해남읍 남외리 121-22해남읍061-531-73522023-07-01
89해남군제일빌라 앞해남읍 남동리 76해남읍061-531-73522023-07-01
910해남군<NA>해남읍 남외리 4-1해남읍061-531-73522023-07-01
연번시군구명투기위치지번주소관할기관명관리기관전화번호데이터기준일자
203204해남군<NA>화원면 구림리 산10-1화원면061-531-36152023-07-01
204205해남군<NA>화원면 구림리 167-9화원면061-531-36152023-07-01
205206해남군<NA>화원면 금평리 32-1화원면061-531-36152023-07-01
206207해남군<NA>화원면 매월리 434-8화원면061-531-36152023-07-01
207208해남군<NA>화원면 성산리 81화원면061-531-36152023-07-01
208209해남군<NA>화원면 인지리 947화원면061-531-36152023-07-01
209210해남군<NA>화원면 금평리 140-2화원면061-531-36152023-07-01
210211해남군<NA>화원면 청용새길 64-2화원면061-531-36152023-07-01
211212해남군<NA>화원면 청용리 481-46화원면061-531-36152023-07-01
212213해남군<NA>화원면 후산리 1061화원면061-531-36152023-07-01