Overview

Dataset statistics

Number of variables13
Number of observations141
Missing cells110
Missing cells (%)6.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.0 KiB
Average record size in memory108.9 B

Variable types

Text5
Categorical5
Numeric3

Dataset

Description대전광역시 불법주정차 단속구간 어린이보호구역 주민신고제(관리번호, 시군구명, 시군구코드, 우편번호, 주소, 연락처, 위도, 경도, 위치, 학교이름, 대표이미지, 기준일자, 기타)
URLhttps://www.data.go.kr/data/15076801/fileData.do

Alerts

시군구명 is highly overall correlated with 우편번호 and 5 other fieldsHigh correlation
대표이미지 is highly overall correlated with 시군구명 and 2 other fieldsHigh correlation
시군구코드 is highly overall correlated with 우편번호 and 5 other fieldsHigh correlation
연락처 is highly overall correlated with 우편번호 and 4 other fieldsHigh correlation
우편번호 is highly overall correlated with 위도 and 4 other fieldsHigh correlation
위도 is highly overall correlated with 우편번호High correlation
경도 is highly overall correlated with 시군구명 and 1 other fieldsHigh correlation
기준일자 is highly overall correlated with 우편번호 and 3 other fieldsHigh correlation
기타 has 110 (78.0%) missing valuesMissing
관리번호 has unique valuesUnique
우편번호 has unique valuesUnique
주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique
위치 has unique valuesUnique
학교이름 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:20:35.021795
Analysis finished2023-12-12 12:20:37.626269
Duration2.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T21:20:37.823512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length20
Min length20

Characters and Unicode

Total characters2820
Distinct characters16
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique141 ?
Unique (%)100.0%

Sample

1st row3680000_SCHOOL_00014
2nd row3680000_SCHOOL_00010
3rd row3680000_SCHOOL_00001
4th row3680000_SCHOOL_00002
5th row3680000_SCHOOL_00003
ValueCountFrequency (%)
3680000_school_00014 1
 
0.7%
3650000_school_00131 1
 
0.7%
3650000_school_00134 1
 
0.7%
3650000_school_00135 1
 
0.7%
3650000_school_00136 1
 
0.7%
3650000_school_00137 1
 
0.7%
3650000_school_00139 1
 
0.7%
3650000_school_00140 1
 
0.7%
3650000_school_00133 1
 
0.7%
3670000_school_00092 1
 
0.7%
Other values (131) 131
92.9%
2023-12-12T21:20:38.284868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 978
34.7%
_ 282
 
10.0%
O 282
 
10.0%
6 201
 
7.1%
3 175
 
6.2%
S 141
 
5.0%
C 141
 
5.0%
H 141
 
5.0%
L 141
 
5.0%
1 77
 
2.7%
Other values (6) 261
 
9.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1692
60.0%
Uppercase Letter 846
30.0%
Connector Punctuation 282
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 978
57.8%
6 201
 
11.9%
3 175
 
10.3%
1 77
 
4.6%
7 64
 
3.8%
5 51
 
3.0%
4 49
 
2.9%
8 39
 
2.3%
2 34
 
2.0%
9 24
 
1.4%
Uppercase Letter
ValueCountFrequency (%)
O 282
33.3%
S 141
16.7%
C 141
16.7%
H 141
16.7%
L 141
16.7%
Connector Punctuation
ValueCountFrequency (%)
_ 282
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1974
70.0%
Latin 846
30.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 978
49.5%
_ 282
 
14.3%
6 201
 
10.2%
3 175
 
8.9%
1 77
 
3.9%
7 64
 
3.2%
5 51
 
2.6%
4 49
 
2.5%
8 39
 
2.0%
2 34
 
1.7%
Latin
ValueCountFrequency (%)
O 282
33.3%
S 141
16.7%
C 141
16.7%
H 141
16.7%
L 141
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2820
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 978
34.7%
_ 282
 
10.0%
O 282
 
10.0%
6 201
 
7.1%
3 175
 
6.2%
S 141
 
5.0%
C 141
 
5.0%
H 141
 
5.0%
L 141
 
5.0%
1 77
 
2.7%
Other values (6) 261
 
9.3%

시군구명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
유성구
40 
서구
36 
중구
27 
동구
23 
대덕구
15 

Length

Max length3
Median length2
Mean length2.3900709
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대덕구
2nd row대덕구
3rd row대덕구
4th row대덕구
5th row대덕구

Common Values

ValueCountFrequency (%)
유성구 40
28.4%
서구 36
25.5%
중구 27
19.1%
동구 23
16.3%
대덕구 15
 
10.6%

Length

2023-12-12T21:20:38.463999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:20:38.600171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유성구 40
28.4%
서구 36
25.5%
중구 27
19.1%
동구 23
16.3%
대덕구 15
 
10.6%

시군구코드
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
3670000
40 
3660000
36 
3650000
27 
3640000
23 
3680000
15 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3680000
2nd row3680000
3rd row3680000
4th row3680000
5th row3680000

Common Values

ValueCountFrequency (%)
3670000 40
28.4%
3660000 36
25.5%
3650000 27
19.1%
3640000 23
16.3%
3680000 15
 
10.6%

Length

2023-12-12T21:20:38.737100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:20:38.883980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3670000 40
28.4%
3660000 36
25.5%
3650000 27
19.1%
3640000 23
16.3%
3680000 15
 
10.6%

우편번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34683.454
Minimum34005
Maximum35416
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-12T21:20:39.046280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34005
5-th percentile34035
Q134209
median34659
Q335201
95-th percentile35373
Maximum35416
Range1411
Interquartile range (IQR)992

Descriptive statistics

Standard deviation469.47853
Coefficient of variation (CV)0.013536095
Kurtosis-1.4346518
Mean34683.454
Median Absolute Deviation (MAD)455
Skewness0.089690204
Sum4890367
Variance220410.09
MonotonicityNot monotonic
2023-12-12T21:20:39.205626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
34349 1
 
0.7%
35042 1
 
0.7%
34885 1
 
0.7%
34907 1
 
0.7%
35070 1
 
0.7%
34899 1
 
0.7%
34849 1
 
0.7%
34803 1
 
0.7%
34816 1
 
0.7%
35036 1
 
0.7%
Other values (131) 131
92.9%
ValueCountFrequency (%)
34005 1
0.7%
34006 1
0.7%
34008 1
0.7%
34020 1
0.7%
34021 1
0.7%
34022 1
0.7%
34031 1
0.7%
34035 1
0.7%
34049 1
0.7%
34053 1
0.7%
ValueCountFrequency (%)
35416 1
0.7%
35412 1
0.7%
35404 1
0.7%
35396 1
0.7%
35387 1
0.7%
35384 1
0.7%
35381 1
0.7%
35373 1
0.7%
35372 1
0.7%
35371 1
0.7%

주소
Text

UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T21:20:39.664897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length22
Mean length17.695035
Min length14

Characters and Unicode

Total characters2495
Distinct characters118
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

Unique141 ?
Unique (%)100.0%

Sample

1st row대전광역시 대덕구 신탄진로 189
2nd row대전광역시 대덕구 중리로64번길 45
3rd row대전광역시 대덕구 송촌로 67
4th row대전광역시 대덕구 대화로 242-36
5th row대전광역시 대덕구 한남로150번길 27
ValueCountFrequency (%)
대전광역시 141
25.0%
유성구 40
 
7.1%
서구 36
 
6.4%
중구 27
 
4.8%
동구 23
 
4.1%
대덕구 15
 
2.7%
45 3
 
0.5%
12 3
 
0.5%
관저로 3
 
0.5%
61 3
 
0.5%
Other values (228) 271
48.0%
2023-12-12T21:20:40.246301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
424
17.0%
182
 
7.3%
147
 
5.9%
143
 
5.7%
141
 
5.7%
141
 
5.7%
141
 
5.7%
96
 
3.8%
1 92
 
3.7%
80
 
3.2%
Other values (108) 908
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1582
63.4%
Decimal Number 472
 
18.9%
Space Separator 424
 
17.0%
Dash Punctuation 17
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
182
11.5%
147
 
9.3%
143
 
9.0%
141
 
8.9%
141
 
8.9%
141
 
8.9%
96
 
6.1%
80
 
5.1%
45
 
2.8%
42
 
2.7%
Other values (96) 424
26.8%
Decimal Number
ValueCountFrequency (%)
1 92
19.5%
2 65
13.8%
5 51
10.8%
6 49
10.4%
3 44
9.3%
0 41
8.7%
4 40
8.5%
9 35
 
7.4%
8 29
 
6.1%
7 26
 
5.5%
Space Separator
ValueCountFrequency (%)
424
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1582
63.4%
Common 913
36.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
182
11.5%
147
 
9.3%
143
 
9.0%
141
 
8.9%
141
 
8.9%
141
 
8.9%
96
 
6.1%
80
 
5.1%
45
 
2.8%
42
 
2.7%
Other values (96) 424
26.8%
Common
ValueCountFrequency (%)
424
46.4%
1 92
 
10.1%
2 65
 
7.1%
5 51
 
5.6%
6 49
 
5.4%
3 44
 
4.8%
0 41
 
4.5%
4 40
 
4.4%
9 35
 
3.8%
8 29
 
3.2%
Other values (2) 43
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1582
63.4%
ASCII 913
36.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
424
46.4%
1 92
 
10.1%
2 65
 
7.1%
5 51
 
5.6%
6 49
 
5.4%
3 44
 
4.8%
0 41
 
4.5%
4 40
 
4.4%
9 35
 
3.8%
8 29
 
3.2%
Other values (2) 43
 
4.7%
Hangul
ValueCountFrequency (%)
182
11.5%
147
 
9.3%
143
 
9.0%
141
 
8.9%
141
 
8.9%
141
 
8.9%
96
 
6.1%
80
 
5.1%
45
 
2.8%
42
 
2.7%
Other values (96) 424
26.8%

연락처
Categorical

HIGH CORRELATION 

Distinct30
Distinct (%)21.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
042-288-4124
31 
042-611-2576
29 
042-606-6885
27 
042-444-3333
23 
042-581-5400
Other values (25)
26 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique24 ?
Unique (%)17.0%

Sample

1st row042-608-5294
2nd row042-608-5290
3rd row042-608-5281
4th row042-608-5282
5th row042-608-5283

Common Values

ValueCountFrequency (%)
042-288-4124 31
22.0%
042-611-2576 29
20.6%
042-606-6885 27
19.1%
042-444-3333 23
16.3%
042-581-5400 5
 
3.5%
042-608-5294 2
 
1.4%
042-608-5293 1
 
0.7%
042-608-5284 1
 
0.7%
042-608-5290 1
 
0.7%
042-611-2574 1
 
0.7%
Other values (20) 20
14.2%

Length

2023-12-12T21:20:40.410632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
042-288-4124 31
22.0%
042-611-2576 29
20.6%
042-606-6885 27
19.1%
042-444-3333 23
16.3%
042-581-5400 5
 
3.5%
042-608-5294 2
 
1.4%
042-611-2585 1
 
0.7%
042-611-2582 1
 
0.7%
042-611-2583 1
 
0.7%
042-611-2584 1
 
0.7%
Other values (20) 20
14.2%

위도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.346173
Minimum36.229201
Maximum36.451712
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-12T21:20:40.551841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.229201
5-th percentile36.298217
Q136.317309
median36.341718
Q336.365898
95-th percentile36.423885
Maximum36.451712
Range0.22251058
Interquartile range (IQR)0.04858899

Descriptive statistics

Standard deviation0.039406721
Coefficient of variation (CV)0.0010842055
Kurtosis0.49787075
Mean36.346173
Median Absolute Deviation (MAD)0.02440856
Skewness0.53392571
Sum5124.8103
Variance0.0015528896
MonotonicityNot monotonic
2023-12-12T21:20:40.713747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36.39734209 1
 
0.7%
36.31550009 1
 
0.7%
36.32365964 1
 
0.7%
36.32503838 1
 
0.7%
36.30100731 1
 
0.7%
36.32169526 1
 
0.7%
36.33140144 1
 
0.7%
36.3410454 1
 
0.7%
36.33454449 1
 
0.7%
36.30861975 1
 
0.7%
Other values (131) 131
92.9%
ValueCountFrequency (%)
36.22920101 1
0.7%
36.2669009 1
0.7%
36.27884682 1
0.7%
36.28729874 1
0.7%
36.2952576 1
0.7%
36.29528674 1
0.7%
36.29747179 1
0.7%
36.29821713 1
0.7%
36.29836509 1
0.7%
36.2986577 1
0.7%
ValueCountFrequency (%)
36.45171159 1
0.7%
36.44950467 1
0.7%
36.44563804 1
0.7%
36.44085264 1
0.7%
36.43393127 1
0.7%
36.43221313 1
0.7%
36.42887292 1
0.7%
36.42388454 1
0.7%
36.42198748 1
0.7%
36.42178032 1
0.7%

경도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.38884
Minimum127.26465
Maximum127.49379
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2023-12-12T21:20:40.871525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.26465
5-th percentile127.31349
Q1127.35361
median127.39147
Q3127.42226
95-th percentile127.45683
Maximum127.49379
Range0.2291441
Interquartile range (IQR)0.068652

Descriptive statistics

Standard deviation0.045130627
Coefficient of variation (CV)0.00035427456
Kurtosis-0.53416103
Mean127.38884
Median Absolute Deviation (MAD)0.0315265
Skewness-0.22956788
Sum17961.827
Variance0.0020367735
MonotonicityNot monotonic
2023-12-12T21:20:41.022487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.4222609 1
 
0.7%
127.4202326 1
 
0.7%
127.3898461 1
 
0.7%
127.4048626 1
 
0.7%
127.4483941 1
 
0.7%
127.3998923 1
 
0.7%
127.4143494 1
 
0.7%
127.4108557 1
 
0.7%
127.4082704 1
 
0.7%
127.4458202 1
 
0.7%
Other values (131) 131
92.9%
ValueCountFrequency (%)
127.2646482 1
0.7%
127.2966928 1
0.7%
127.3004504 1
0.7%
127.3031686 1
0.7%
127.3105773 1
0.7%
127.3122813 1
0.7%
127.3131217 1
0.7%
127.3134893 1
0.7%
127.3145079 1
0.7%
127.3168695 1
0.7%
ValueCountFrequency (%)
127.4937923 1
0.7%
127.4743283 1
0.7%
127.4703552 1
0.7%
127.4637485 1
0.7%
127.4614342 1
0.7%
127.4585738 1
0.7%
127.4572058 1
0.7%
127.4568253 1
0.7%
127.4558813 1
0.7%
127.4499135 1
0.7%

위치
Text

UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T21:20:41.243621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length192
Median length190
Mean length115.99291
Min length46

Characters and Unicode

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

Unique

Unique141 ?
Unique (%)100.0%

Sample

1st row[1822018.2403,993022.9098],[1822309.0853,993115.8448]
2nd row[1818609.9130,993432.1890],[1818625.7880,993588.2931]
3rd row[1818230.7550,994677.0105],[1818234.6027,994689.9526],[1818153.4522,994637.4846],[1818148.9049,994656.3731]
4th row[1818450.1255,991982.3156],[1818495.8984,991977.2886],[1818495.8984,991977.2886],[1818498.0151,991981.5219]
5th row[1816784.6340,992127.1989],[1816696.1872,992217.4146]
ValueCountFrequency (%)
1822018.2403,993022.9098],[1822309.0853,993115.8448 1
 
0.7%
1811414.7529,989722.2363],[1811246.1923,989679.6870],[1811421.1628,989696.3503],[1811253.3969,989656.8243 1
 
0.7%
1814208.5114,992009.7224],[1814378.9106,992076.9651],[1814191.3763,992021.5893],[1814362.7480,992096.1760 1
 
0.7%
1818324.77625887,985575.633819939],[1818330.41526678,985566.772521786],[1818216.56101172,985517.095547291],[1818224.07968894,985505.81753146 1
 
0.7%
1815226.6659,991699.9270],[1815140.1593,991752.3759],[1815212.3617,991681.5358],[1815143.5651,991723.7674 1
 
0.7%
1814044.2252,990176.5942],[1813923.4940,990123.8698],[1814025.0670,990177.5987],[1813920.0039,990133.5603 1
 
0.7%
1814205.4549,991373.2089],[1814060.4628,991440.8337],[1814198.1244,991348.2779],[1814145.6142,991364.8998 1
 
0.7%
1811645.1071,995338.9179],[1811504.4754,995300.0309],[1811646.0926,995323.1501],[1811520.4427,995289.1507 1
 
0.7%
1813859.3078,990883.7889],[1813681.0763,990943.3904],[1813747.9021,990904.0700],[1813717.7177,990911.9643 1
 
0.7%
1814726.2995,992255.4831],[1814746.1666,992413.2742],[1814718.0208,992258.3679],[1814738.7625,992410.3894 1
 
0.7%
Other values (136) 136
93.2%
2023-12-12T21:20:41.631381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1993
12.2%
9 1897
11.6%
8 1867
11.4%
. 1194
 
7.3%
2 1172
 
7.2%
4 1059
 
6.5%
, 1053
 
6.4%
5 1027
 
6.3%
3 1020
 
6.2%
6 974
 
6.0%
Other values (5) 3099
18.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 12909
78.9%
Other Punctuation 2247
 
13.7%
Open Punctuation 597
 
3.7%
Close Punctuation 597
 
3.7%
Space Separator 5
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1993
15.4%
9 1897
14.7%
8 1867
14.5%
2 1172
9.1%
4 1059
8.2%
5 1027
8.0%
3 1020
7.9%
6 974
7.5%
0 967
7.5%
7 933
7.2%
Other Punctuation
ValueCountFrequency (%)
. 1194
53.1%
, 1053
46.9%
Open Punctuation
ValueCountFrequency (%)
[ 597
100.0%
Close Punctuation
ValueCountFrequency (%)
] 597
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 16355
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1993
12.2%
9 1897
11.6%
8 1867
11.4%
. 1194
 
7.3%
2 1172
 
7.2%
4 1059
 
6.5%
, 1053
 
6.4%
5 1027
 
6.3%
3 1020
 
6.2%
6 974
 
6.0%
Other values (5) 3099
18.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 16355
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1993
12.2%
9 1897
11.6%
8 1867
11.4%
. 1194
 
7.3%
2 1172
 
7.2%
4 1059
 
6.5%
, 1053
 
6.4%
5 1027
 
6.3%
3 1020
 
6.2%
6 974
 
6.0%
Other values (5) 3099
18.9%

학교이름
Text

UNIQUE 

Distinct141
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T21:20:41.903631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length6
Mean length5.7730496
Min length3

Characters and Unicode

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

Unique

Unique141 ?
Unique (%)100.0%

Sample

1st row와동초등학교
2nd row중원초등학교
3rd row대양초등학교
4th row대화초등학교
5th row동도초등학교
ValueCountFrequency (%)
와동초등학교 1
 
0.7%
석교초 1
 
0.7%
신평초 1
 
0.7%
오류초 1
 
0.7%
옥계초 1
 
0.7%
원평초 1
 
0.7%
중앙초 1
 
0.7%
중촌초 1
 
0.7%
선화초 1
 
0.7%
장대초등학교 1
 
0.7%
Other values (131) 131
92.9%
2023-12-12T21:20:42.412527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
140
17.2%
116
14.3%
114
14.0%
112
13.8%
34
 
4.2%
23
 
2.8%
17
 
2.1%
10
 
1.2%
9
 
1.1%
8
 
1.0%
Other values (104) 231
28.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 814
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
140
17.2%
116
14.3%
114
14.0%
112
13.8%
34
 
4.2%
23
 
2.8%
17
 
2.1%
10
 
1.2%
9
 
1.1%
8
 
1.0%
Other values (104) 231
28.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 814
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
140
17.2%
116
14.3%
114
14.0%
112
13.8%
34
 
4.2%
23
 
2.8%
17
 
2.1%
10
 
1.2%
9
 
1.1%
8
 
1.0%
Other values (104) 231
28.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 814
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
140
17.2%
116
14.3%
114
14.0%
112
13.8%
34
 
4.2%
23
 
2.8%
17
 
2.1%
10
 
1.2%
9
 
1.1%
8
 
1.0%
Other values (104) 231
28.4%

대표이미지
Categorical

HIGH CORRELATION 

Distinct32
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
1,2
45 
1, 2, 3
26 
1
25 
1,2,3
10 
<NA>
Other values (27)
28 

Length

Max length7
Median length5
Mean length3.4326241
Min length1

Unique

Unique26 ?
Unique (%)18.4%

Sample

1st row14
2nd row10
3rd row1
4th row2
5th row3

Common Values

ValueCountFrequency (%)
1,2 45
31.9%
1, 2, 3 26
18.4%
1 25
17.7%
1,2,3 10
 
7.1%
<NA> 7
 
5.0%
1, 2 2
 
1.4%
7 1
 
0.7%
12 1
 
0.7%
11 1
 
0.7%
9 1
 
0.7%
Other values (22) 22
15.6%

Length

2023-12-12T21:20:42.611736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1 53
27.2%
1,2 45
23.1%
2 29
14.9%
3 27
13.8%
1,2,3 10
 
5.1%
na 7
 
3.6%
110 1
 
0.5%
107 1
 
0.5%
108 1
 
0.5%
109 1
 
0.5%
Other values (20) 20
 
10.3%

기준일자
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2020-04-14
65 
2020-02-25
60 
2018-08-31
16 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-04-14
2nd row2020-04-14
3rd row2020-04-14
4th row2020-04-14
5th row2020-04-14

Common Values

ValueCountFrequency (%)
2020-04-14 65
46.1%
2020-02-25 60
42.6%
2018-08-31 16
 
11.3%

Length

2023-12-12T21:20:42.821846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:20:42.959535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-04-14 65
46.1%
2020-02-25 60
42.6%
2018-08-31 16
 
11.3%

기타
Text

MISSING 

Distinct30
Distinct (%)96.8%
Missing110
Missing (%)78.0%
Memory size1.2 KiB
2023-12-12T21:20:43.291631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length38
Mean length35.677419
Min length8

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)93.5%

Sample

1st row학교 기준 서/북쪽 청사로, 동쪽 월평동로 신고구간
2nd row학교 기준 동쪽 둔산로 74번길 정문구간, 로드뷰 측정구간임
3rd row삼천중학교와 접함, 로드뷰 측정구간
4th row로드뷰 측정구간, 남서쪽 월평서로 정문구간
5th row계룡로 342번길 남,북 구간 주차라인 있음
ValueCountFrequency (%)
정문 13
 
5.5%
양측 7
 
2.9%
로드뷰 5
 
2.1%
황색복선 5
 
2.1%
복선 5
 
2.1%
후문 5
 
2.1%
정문양측 5
 
2.1%
동쪽 4
 
1.7%
측정구간 4
 
1.7%
교차로까지 4
 
1.7%
Other values (146) 181
76.1%
2023-12-12T21:20:43.775519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
207
 
18.7%
46
 
4.2%
, 39
 
3.5%
30
 
2.7%
29
 
2.6%
21
 
1.9%
21
 
1.9%
21
 
1.9%
21
 
1.9%
20
 
1.8%
Other values (171) 651
58.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 787
71.2%
Space Separator 207
 
18.7%
Other Punctuation 48
 
4.3%
Decimal Number 46
 
4.2%
Math Symbol 14
 
1.3%
Open Punctuation 2
 
0.2%
Close Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
46
 
5.8%
30
 
3.8%
29
 
3.7%
21
 
2.7%
21
 
2.7%
21
 
2.7%
21
 
2.7%
20
 
2.5%
18
 
2.3%
16
 
2.0%
Other values (154) 544
69.1%
Decimal Number
ValueCountFrequency (%)
1 10
21.7%
2 7
15.2%
3 6
13.0%
7 6
13.0%
4 5
10.9%
5 4
 
8.7%
6 4
 
8.7%
0 2
 
4.3%
8 2
 
4.3%
Other Punctuation
ValueCountFrequency (%)
, 39
81.2%
/ 7
 
14.6%
: 1
 
2.1%
. 1
 
2.1%
Space Separator
ValueCountFrequency (%)
207
100.0%
Math Symbol
ValueCountFrequency (%)
~ 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 787
71.2%
Common 319
28.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
46
 
5.8%
30
 
3.8%
29
 
3.7%
21
 
2.7%
21
 
2.7%
21
 
2.7%
21
 
2.7%
20
 
2.5%
18
 
2.3%
16
 
2.0%
Other values (154) 544
69.1%
Common
ValueCountFrequency (%)
207
64.9%
, 39
 
12.2%
~ 14
 
4.4%
1 10
 
3.1%
/ 7
 
2.2%
2 7
 
2.2%
3 6
 
1.9%
7 6
 
1.9%
4 5
 
1.6%
5 4
 
1.3%
Other values (7) 14
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 787
71.2%
ASCII 319
28.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
207
64.9%
, 39
 
12.2%
~ 14
 
4.4%
1 10
 
3.1%
/ 7
 
2.2%
2 7
 
2.2%
3 6
 
1.9%
7 6
 
1.9%
4 5
 
1.6%
5 4
 
1.3%
Other values (7) 14
 
4.4%
Hangul
ValueCountFrequency (%)
46
 
5.8%
30
 
3.8%
29
 
3.7%
21
 
2.7%
21
 
2.7%
21
 
2.7%
21
 
2.7%
20
 
2.5%
18
 
2.3%
16
 
2.0%
Other values (154) 544
69.1%

Interactions

2023-12-12T21:20:36.583447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:35.851542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:36.220534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:36.688658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:35.978009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:36.335939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:36.780105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:36.128307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:20:36.467854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:20:43.916366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명시군구코드우편번호연락처위도경도대표이미지기준일자기타
시군구명1.0001.0000.9991.0000.7570.9210.9240.778NaN
시군구코드1.0001.0000.9991.0000.7570.9210.9240.778NaN
우편번호0.9990.9991.0000.9280.8610.8560.7620.8541.000
연락처1.0001.0000.9281.0000.6640.8250.9970.941NaN
위도0.7570.7570.8610.6641.0000.5670.5440.5141.000
경도0.9210.9210.8560.8250.5671.0000.6390.6011.000
대표이미지0.9240.9240.7620.9970.5440.6391.0000.7591.000
기준일자0.7780.7780.8540.9410.5140.6010.7591.0001.000
기타NaNNaN1.000NaN1.0001.0001.0001.0001.000
2023-12-12T21:20:44.067946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명기준일자대표이미지시군구코드연락처
시군구명1.0000.7840.6611.0000.903
기준일자0.7841.0000.4790.7840.679
대표이미지0.6610.4791.0000.6610.922
시군구코드1.0000.7840.6611.0000.903
연락처0.9030.6790.9220.9031.000
2023-12-12T21:20:44.190722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
우편번호위도경도시군구명시군구코드연락처대표이미지기준일자
우편번호1.000-0.6770.0760.9480.9480.5570.3540.755
위도-0.6771.000-0.0830.4050.4050.2490.1990.350
경도0.076-0.0831.0000.6150.6150.3870.2550.434
시군구명0.9480.4050.6151.0001.0000.9030.6610.784
시군구코드0.9480.4050.6151.0001.0000.9030.6610.784
연락처0.5570.2490.3870.9030.9031.0000.9220.679
대표이미지0.3540.1990.2550.6610.6610.9221.0000.479
기준일자0.7550.3500.4340.7840.7840.6790.4791.000

Missing values

2023-12-12T21:20:37.295809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:20:37.534760image/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

관리번호시군구명시군구코드우편번호주소연락처위도경도위치학교이름대표이미지기준일자기타
03680000_SCHOOL_00014대덕구368000034349대전광역시 대덕구 신탄진로 189042-608-529436.397342127.422261[1822018.2403,993022.9098],[1822309.0853,993115.8448]와동초등학교142020-04-14<NA>
13680000_SCHOOL_00010대덕구368000034389대전광역시 대덕구 중리로64번길 45042-608-529036.365804127.428021[1818609.9130,993432.1890],[1818625.7880,993588.2931]중원초등학교102020-04-14<NA>
23680000_SCHOOL_00001대덕구368000034423대전광역시 대덕구 송촌로 67042-608-528136.361311127.440307[1818230.7550,994677.0105],[1818234.6027,994689.9526],[1818153.4522,994637.4846],[1818148.9049,994656.3731]대양초등학교12020-04-14<NA>
33680000_SCHOOL_00002대덕구368000034375대전광역시 대덕구 대화로 242-36042-608-528236.362564127.411168[1818450.1255,991982.3156],[1818495.8984,991977.2886],[1818495.8984,991977.2886],[1818498.0151,991981.5219]대화초등학교22020-04-14<NA>
43680000_SCHOOL_00003대덕구368000034442대전광역시 대덕구 한남로150번길 27042-608-528336.348054127.412141[1816784.6340,992127.1989],[1816696.1872,992217.4146]동도초등학교32020-04-14<NA>
53680000_SCHOOL_00004대덕구368000034432대전광역시 대덕구 동산초교로63번길 50042-608-528436.350572127.421316[1816856.0633, 992968.8785],[1816850.2424,992968.8785],[1816857.1216,993094.2910],[1816850.7716,993094.8201]동산초등학교42020-04-14<NA>
63680000_SCHOOL_00005대덕구368000034399대전광역시 대덕구 선비마을로 155042-608-528536.369031127.43771[1819060.5351,994418.2712],[1819057.3510,994433.1303],[1819155.3499,994418.2712],[1819152.1658,994450.4658]매봉초등학교52020-04-14<NA>
73680000_SCHOOL_00006대덕구368000034323대전광역시 대덕구 대덕대로1486번길 117042-608-528636.445638127.412323[1827596.4831,992338.9159],[1827607.0664,992192.8659],[1827593.5727,992339.7096],[1827606.0081,992338.9159]목상초등학교62020-04-14<NA>
83680000_SCHOOL_00007대덕구368000034398대전광역시 대덕구 계족로664번길 74042-608-528736.369748127.432014[1819151.6594,994005.4721],[1819153.7822,994023.1614],[1818975.4736,994045.8038],[1818979.0114,994066.3234]법동초등학교72020-04-14<NA>
93680000_SCHOOL_00008대덕구368000034304대전광역시 대덕구 대덕대로 1585042-608-528836.451712127.422997[1828268.8459,993176.2455],[1828269.5534,993191.8122],[1828107.8716, 993178.0144],[1828108.2254,993193.2274]새여울초등학교82020-04-14<NA>
관리번호시군구명시군구코드우편번호주소연락처위도경도위치학교이름대표이미지기준일자기타
1313660000_SCHOOL_00061서구366000035359대전광역시 서구 관저동로 161042-288-412436.306558127.339911[1812180.647,985682.596],[811982.527,985680.564],[812178.262,985707.452],[811978.8,985704.7]관저초등학교1,2,32020-04-14정문 관저동로 남측방향 ~ 관저중학교 정문 만나기까지
1323660000_SCHOOL_00062서구366000035317대전광역시 서구 유등로 373042-288-412436.32494127.386017[1814076.171,989749.921],[814127.225,989629.525],[814072.645,989748.792],[814123.445,989627.481]변동초등학교1,2,32020-04-14정문양측, 중반2길 서,남동방향 교차로까지
1333660000_SCHOOL_00063서구366000035340대전광역시 서구 도림1길 15042-288-412436.312099127.37356[1812655.803,988669.769],[812654.533,988726.665],[812781.251,988543.854],[812776.945,988703.173]삼육초등학교1,22020-04-14정문 도람1길, 후문~ 도림2길 동쪽방향만 복선, 서쪽은 황색실선, 정문 바로 앞에 주차구역 있음
1343660000_SCHOOL_00064서구366000035371대전광역시 서구 관저로 45042-288-412436.298217127.326376[1811245.606,984513.711],[811141.06,984437.709],[811131.431,984457.999],[811208.464,984514.055]금동초등학교<NA>2020-04-14학교 입구가 골목길로 약간 들어가서 있음, 바로 옆 교회와 아파트입구, 황색복선 희한, 주정차허용구간과겹침
1353660000_SCHOOL_00070서구366000035412대전광역시 서구 복수동로 26042-288-412436.301929127.37805[1811510.922,989029.083],[811696.441,989111.035],[811669.263,989127.545],[811523.594,989121.449]신계초등학교1,2,32020-02-25정문 교회쪽 버스정류장(맞은편 복선은 삼거리까지:로드뷰 참조)~ 학교옆 오르막길 위측 횡단보도까지
1363660000_SCHOOL_00071서구366000035355대전광역시 서구 원도안로 200042-288-412436.321581127.344663[1813891.514,986017.072],[813756.743,986002.391],[813884.637,985997.233],[813757.404,985986.124]도안초등학교1,22020-02-25정문양측 원도안로 남/북방향 교차로까지, 맞은편 차선은 맞은편 교차로까지
1373660000_SCHOOL_00072서구366000035384대전광역시 서구 관저남로 60042-288-412436.295258127.34169[1810898.873,985789.387],[810879.823,985681.945],[810916.579,985794.888],[810893.452,985693.18]선유초등학교1,22020-02-25정문~ 관저남로 서쪽 삼거리까지, 동쪽은 바로 아파트 입구가 붙어있음
1383660000_SCHOOL_00073서구366000035216대전광역시 서구 갈마역로 125042-288-412436.361825127.373578[1818304.535,988715.183],[818197.338,988713.442],[818302.795,988736.761],[818198.382,988733.977]성룡초등학교<NA>2020-02-25갈마역로 남,북방향 황색복선 없음, 성천/성룡 초등학교 대로변출입구인데 복선없음, 사면 다 둘러침
1393660000_SCHOOL_00074서구366000035266대전광역시 서구 대덕대로112번길 10042-288-412436.343074127.374969[1816122.033,988741.244],[816046.341,988973.4]둔원초등학교1,22020-02-25후문이 대로변과 근접함, ~갈마로 147번길 동쪽~ 괴정로 11번길 동쪽~ 둔원중학교 모서리까지, 둔원중학교 접함
1403660000_SCHOOL_00041서구366000035211대전광역시 서구 갈마역로 139042-288-412436.36333127.373412[1818450.016,988475.731],[818449.705,988713.549],[818456.309,988475.805],[818457.325,988713.041]성천초등학교<NA>2020-04-14갈마역로 남,북방향 황색복선 없음, 성천/성룡 초등학교 대로변출입구인데 복선없음, 남선중학교와 접해있음