Overview

Dataset statistics

Number of variables8
Number of observations1830
Missing cells4
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory118.1 KiB
Average record size in memory66.1 B

Variable types

Numeric1
Text4
DateTime2
Categorical1

Dataset

Description경기도 양평군 가로등에 대한 데이터로 관리번호(지역+번호), 주소(지번), 설치일자, 등수, 위도, 경도의 정보를 제공합니다.
Author경기도 양평군
URLhttps://www.data.go.kr/data/3040624/fileData.do

Alerts

기준일자 has constant value ""Constant
등수 is highly imbalanced (71.9%)Imbalance
순 번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 20:08:53.179916
Analysis finished2024-03-14 20:08:54.860846
Duration1.68 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순 번
Real number (ℝ)

UNIQUE 

Distinct1830
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean915.5
Minimum1
Maximum1830
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2024-03-15T05:08:55.099141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile92.45
Q1458.25
median915.5
Q31372.75
95-th percentile1738.55
Maximum1830
Range1829
Interquartile range (IQR)914.5

Descriptive statistics

Standard deviation528.41981
Coefficient of variation (CV)0.57719259
Kurtosis-1.2
Mean915.5
Median Absolute Deviation (MAD)457.5
Skewness0
Sum1675365
Variance279227.5
MonotonicityStrictly increasing
2024-03-15T05:08:55.980479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
1231 1
 
0.1%
1229 1
 
0.1%
1228 1
 
0.1%
1227 1
 
0.1%
1226 1
 
0.1%
1225 1
 
0.1%
1224 1
 
0.1%
1223 1
 
0.1%
1222 1
 
0.1%
Other values (1820) 1820
99.5%
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 (%)
1830 1
0.1%
1829 1
0.1%
1828 1
0.1%
1827 1
0.1%
1826 1
0.1%
1825 1
0.1%
1824 1
0.1%
1823 1
0.1%
1822 1
0.1%
1821 1
0.1%

관리번호
Text

Distinct1825
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
2024-03-15T05:08:58.460951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length7.1005464
Min length3

Characters and Unicode

Total characters12994
Distinct characters145
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

Unique1820 ?
Unique (%)99.5%

Sample

1st row교평리1번
2nd row교평리2번
3rd row교평리3번
4th row교평리4번
5th row교평리6번
ValueCountFrequency (%)
양평읍 42
 
2.2%
양동역길4 2
 
0.1%
보룡길142 2
 
0.1%
남북로42 2
 
0.1%
관문길44-1 2
 
0.1%
중앙로167번길32-6 2
 
0.1%
옥천길015 1
 
0.1%
옥천길011 1
 
0.1%
옥천길012 1
 
0.1%
옥천길013 1
 
0.1%
Other values (1817) 1817
97.0%
2024-03-15T05:08:59.941800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1244
 
9.6%
2 863
 
6.6%
로 819
 
6.3%
- 790
 
6.1%
길 702
 
5.4%
0 658
 
5.1%
3 634
 
4.9%
4 504
 
3.9%
양 410
 
3.2%
5 368
 
2.8%
Other values (135) 6002
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6701
51.6%
Decimal Number 5460
42.0%
Dash Punctuation 790
 
6.1%
Space Separator 43
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 819
 
12.2%
길 702
 
10.5%
양 410
 
6.1%
리 331
 
4.9%
용 223
 
3.3%
중 217
 
3.2%
앙 204
 
3.0%
평 195
 
2.9%
시 189
 
2.8%
강 183
 
2.7%
Other values (123) 3228
48.2%
Decimal Number
ValueCountFrequency (%)
1 1244
22.8%
2 863
15.8%
0 658
12.1%
3 634
11.6%
4 504
9.2%
5 368
 
6.7%
6 350
 
6.4%
7 328
 
6.0%
8 290
 
5.3%
9 221
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 790
100.0%
Space Separator
ValueCountFrequency (%)
43
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6701
51.6%
Common 6293
48.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 819
 
12.2%
길 702
 
10.5%
양 410
 
6.1%
리 331
 
4.9%
용 223
 
3.3%
중 217
 
3.2%
앙 204
 
3.0%
평 195
 
2.9%
시 189
 
2.8%
강 183
 
2.7%
Other values (123) 3228
48.2%
Common
ValueCountFrequency (%)
1 1244
19.8%
2 863
13.7%
- 790
12.6%
0 658
10.5%
3 634
10.1%
4 504
8.0%
5 368
 
5.8%
6 350
 
5.6%
7 328
 
5.2%
8 290
 
4.6%
Other values (2) 264
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6701
51.6%
ASCII 6293
48.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1244
19.8%
2 863
13.7%
- 790
12.6%
0 658
10.5%
3 634
10.1%
4 504
8.0%
5 368
 
5.8%
6 350
 
5.6%
7 328
 
5.2%
8 290
 
4.6%
Other values (2) 264
 
4.2%
Hangul
ValueCountFrequency (%)
로 819
 
12.2%
길 702
 
10.5%
양 410
 
6.1%
리 331
 
4.9%
용 223
 
3.3%
중 217
 
3.2%
앙 204
 
3.0%
평 195
 
2.9%
시 189
 
2.8%
강 183
 
2.7%
Other values (123) 3228
48.2%

주소
Text

Distinct1279
Distinct (%)69.9%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
2024-03-15T05:09:01.205873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length34
Mean length23.440984
Min length17

Characters and Unicode

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

Unique

Unique1022 ?
Unique (%)55.8%

Sample

1st row경기도 양평군 강상면 교평1리 470-21
2nd row경기도 양평군 강상면 교평1리 470-27
3rd row경기도 양평군 강상면 교평1리 470-27
4th row경기도 양평군 강상면 교평1리 478-6
5th row경기도 양평군 강상면 교평1리 477-2
ValueCountFrequency (%)
경기도 1830
18.5%
양평군 1830
18.5%
양평읍 859
 
8.7%
용문면 256
 
2.6%
양서면 152
 
1.5%
중앙로 130
 
1.3%
옥천면 124
 
1.3%
청운면 90
 
0.9%
강상면 90
 
0.9%
옥천리 82
 
0.8%
Other values (1609) 4455
45.0%
2024-03-15T05:09:02.790813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8107
18.9%
양 3417
 
8.0%
평 2995
 
7.0%
경 1920
 
4.5%
군 1877
 
4.4%
도 1876
 
4.4%
기 1853
 
4.3%
1 1442
 
3.4%
리 1102
 
2.6%
면 972
 
2.3%
Other values (403) 17336
40.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 27038
63.0%
Space Separator 8107
 
18.9%
Decimal Number 6495
 
15.1%
Dash Punctuation 963
 
2.2%
Uppercase Letter 156
 
0.4%
Open Punctuation 44
 
0.1%
Close Punctuation 44
 
0.1%
Other Punctuation 44
 
0.1%
Lowercase Letter 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 3417
 
12.6%
평 2995
 
11.1%
경 1920
 
7.1%
군 1877
 
6.9%
도 1876
 
6.9%
기 1853
 
6.9%
리 1102
 
4.1%
면 972
 
3.6%
읍 867
 
3.2%
로 562
 
2.1%
Other values (363) 9597
35.5%
Uppercase Letter
ValueCountFrequency (%)
C 50
32.1%
I 40
25.6%
U 11
 
7.1%
K 10
 
6.4%
S 9
 
5.8%
G 8
 
5.1%
T 5
 
3.2%
L 5
 
3.2%
P 4
 
2.6%
B 3
 
1.9%
Other values (7) 11
 
7.1%
Decimal Number
ValueCountFrequency (%)
1 1442
22.2%
2 811
12.5%
3 709
10.9%
7 591
9.1%
5 587
9.0%
4 575
 
8.9%
6 562
 
8.7%
8 476
 
7.3%
0 395
 
6.1%
9 347
 
5.3%
Lowercase Letter
ValueCountFrequency (%)
g 1
16.7%
l 1
16.7%
c 1
16.7%
a 1
16.7%
f 1
16.7%
e 1
16.7%
Other Punctuation
ValueCountFrequency (%)
. 39
88.6%
, 4
 
9.1%
& 1
 
2.3%
Space Separator
ValueCountFrequency (%)
8107
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 963
100.0%
Open Punctuation
ValueCountFrequency (%)
( 44
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 27038
63.0%
Common 15697
36.6%
Latin 162
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 3417
 
12.6%
평 2995
 
11.1%
경 1920
 
7.1%
군 1877
 
6.9%
도 1876
 
6.9%
기 1853
 
6.9%
리 1102
 
4.1%
면 972
 
3.6%
읍 867
 
3.2%
로 562
 
2.1%
Other values (363) 9597
35.5%
Latin
ValueCountFrequency (%)
C 50
30.9%
I 40
24.7%
U 11
 
6.8%
K 10
 
6.2%
S 9
 
5.6%
G 8
 
4.9%
T 5
 
3.1%
L 5
 
3.1%
P 4
 
2.5%
B 3
 
1.9%
Other values (13) 17
 
10.5%
Common
ValueCountFrequency (%)
8107
51.6%
1 1442
 
9.2%
- 963
 
6.1%
2 811
 
5.2%
3 709
 
4.5%
7 591
 
3.8%
5 587
 
3.7%
4 575
 
3.7%
6 562
 
3.6%
8 476
 
3.0%
Other values (7) 874
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 27038
63.0%
ASCII 15859
37.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8107
51.1%
1 1442
 
9.1%
- 963
 
6.1%
2 811
 
5.1%
3 709
 
4.5%
7 591
 
3.7%
5 587
 
3.7%
4 575
 
3.6%
6 562
 
3.5%
8 476
 
3.0%
Other values (30) 1036
 
6.5%
Hangul
ValueCountFrequency (%)
양 3417
 
12.6%
평 2995
 
11.1%
경 1920
 
7.1%
군 1877
 
6.9%
도 1876
 
6.9%
기 1853
 
6.9%
리 1102
 
4.1%
면 972
 
3.6%
읍 867
 
3.2%
로 562
 
2.1%
Other values (363) 9597
35.5%

설치일자
Date

Distinct194
Distinct (%)10.6%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
Minimum2006-10-01 00:00:00
Maximum2022-10-27 00:00:00
2024-03-15T05:09:03.230895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:09:03.669014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

등수
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
1
1741 
2
 
89

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 1741
95.1%
2 89
 
4.9%

Length

2024-03-15T05:09:04.090145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T05:09:04.415255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1741
95.1%
2 89
 
4.9%

위도
Text

Distinct1804
Distinct (%)98.7%
Missing2
Missing (%)0.1%
Memory size14.4 KiB
2024-03-15T05:09:06.021103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length9.7248359
Min length1

Characters and Unicode

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

Unique

Unique1781 ?
Unique (%)97.4%

Sample

1st row37.48148347
2nd row37.48101199
3rd row37.48052467
4th row37.48002627
5th row37.47911255
ValueCountFrequency (%)
37.491462 3
 
0.2%
37.4944486 2
 
0.1%
37.510795 2
 
0.1%
37.4918 2
 
0.1%
37.502716 2
 
0.1%
37.41972733 2
 
0.1%
37.502903 2
 
0.1%
37.48817187 2
 
0.1%
37.489909 2
 
0.1%
37.491041 2
 
0.1%
Other values (1793) 1805
98.8%
2024-03-15T05:09:07.940138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 2812
15.8%
3 2773
15.6%
4 2269
12.8%
. 1826
10.3%
5 1504
8.5%
8 1408
7.9%
9 1399
7.9%
1 1023
 
5.8%
2 978
 
5.5%
6 950
 
5.3%
Other values (2) 835
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 15949
89.7%
Other Punctuation 1826
 
10.3%
Space Separator 2
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 2812
17.6%
3 2773
17.4%
4 2269
14.2%
5 1504
9.4%
8 1408
8.8%
9 1399
8.8%
1 1023
 
6.4%
2 978
 
6.1%
6 950
 
6.0%
0 833
 
5.2%
Other Punctuation
ValueCountFrequency (%)
. 1826
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 17777
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
7 2812
15.8%
3 2773
15.6%
4 2269
12.8%
. 1826
10.3%
5 1504
8.5%
8 1408
7.9%
9 1399
7.9%
1 1023
 
5.8%
2 978
 
5.5%
6 950
 
5.3%
Other values (2) 835
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 17777
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7 2812
15.8%
3 2773
15.6%
4 2269
12.8%
. 1826
10.3%
5 1504
8.5%
8 1408
7.9%
9 1399
7.9%
1 1023
 
5.8%
2 978
 
5.5%
6 950
 
5.3%
Other values (2) 835
 
4.7%

경도
Text

Distinct1817
Distinct (%)99.4%
Missing2
Missing (%)0.1%
Memory size14.4 KiB
2024-03-15T05:09:09.269832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length10.313457
Min length1

Characters and Unicode

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

Unique

Unique1806 ?
Unique (%)98.8%

Sample

1st row127.484971
2nd row127.4851432
3rd row127.4853351
4th row127.4854789
5th row127.4858347
ValueCountFrequency (%)
127.6716852 2
 
0.1%
127.493119 2
 
0.1%
127.685813 2
 
0.1%
127.7528915 2
 
0.1%
127.4880433 2
 
0.1%
127.588744 2
 
0.1%
127.4988626 2
 
0.1%
127.5122492 2
 
0.1%
127.474491 2
 
0.1%
127.505141 2
 
0.1%
Other values (1806) 1806
98.9%
2024-03-15T05:09:10.688583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 2925
15.5%
1 2790
14.8%
2 2788
14.8%
. 1824
9.7%
4 1730
9.2%
5 1336
7.1%
9 1262
6.7%
3 1137
 
6.0%
8 1105
 
5.9%
6 1104
 
5.9%
Other values (2) 852
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 17027
90.3%
Other Punctuation 1824
 
9.7%
Space Separator 2
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 2925
17.2%
1 2790
16.4%
2 2788
16.4%
4 1730
10.2%
5 1336
7.8%
9 1262
7.4%
3 1137
 
6.7%
8 1105
 
6.5%
6 1104
 
6.5%
0 850
 
5.0%
Other Punctuation
ValueCountFrequency (%)
. 1824
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 18853
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
7 2925
15.5%
1 2790
14.8%
2 2788
14.8%
. 1824
9.7%
4 1730
9.2%
5 1336
7.1%
9 1262
6.7%
3 1137
 
6.0%
8 1105
 
5.9%
6 1104
 
5.9%
Other values (2) 852
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 18853
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7 2925
15.5%
1 2790
14.8%
2 2788
14.8%
. 1824
9.7%
4 1730
9.2%
5 1336
7.1%
9 1262
6.7%
3 1137
 
6.0%
8 1105
 
5.9%
6 1104
 
5.9%
Other values (2) 852
 
4.5%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
Minimum2024-01-30 00:00:00
Maximum2024-01-30 00:00:00
2024-03-15T05:09:11.040349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T05:09:11.347636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T05:08:53.888296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T05:09:11.556316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순 번등수
순 번1.0000.336
등수0.3361.000
2024-03-15T05:09:11.789450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순 번등수
순 번1.0000.257
등수0.2571.000

Missing values

2024-03-15T05:08:54.245309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T05:08:54.464365image/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.
2024-03-15T05:08:54.744230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

순 번관리번호주소설치일자등수위도경도기준일자
01교평리1번경기도 양평군 강상면 교평1리 470-212006-10-01137.48148347127.4849712024-01-30
12교평리2번경기도 양평군 강상면 교평1리 470-272007-10-07137.48101199127.48514322024-01-30
23교평리3번경기도 양평군 강상면 교평1리 470-272007-10-07137.48052467127.48533512024-01-30
34교평리4번경기도 양평군 강상면 교평1리 478-62007-10-07137.48002627127.48547892024-01-30
45교평리6번경기도 양평군 강상면 교평1리 477-22007-10-07137.47911255127.48583472024-01-30
56교평리7번경기도 양평군 강상면 교평1리 553-22007-10-07137.47868168127.48599022024-01-30
67교평리8번경기도 양평군 강상면 교평1리 562-22007-10-07137.47819438127.48617362024-01-30
78다대2리28경기도 양평군 청운면 다대2리 265-52007-12-03137.563518127.7213152024-01-30
89다대2리29경기도 양평군 청운면 다대2리 265-102007-12-03137.563837127.7219232024-01-30
910다대2리30경기도 양평군 청운면 다대2리 265-102007-12-03137.564125127.7222232024-01-30
순 번관리번호주소설치일자등수위도경도기준일자
18201821어수길3경기도 양평군 용문면 다문리 758-82022-10-13137.4803229127.58870052024-01-30
18211822어수길7경기도 양평군 용문면 다문리 838-22022-10-13137.47990213127.58860962024-01-30
18221823어수길9경기도 양평군 용문면 다문리 802-52022-10-13137.47966097127.58863882024-01-30
18231824시민로24번길19-22경기도 양평군 양평읍 양근리 6682022-10-26137.48825186127.49752042024-01-30
1824182553-37경기도 양평군 양평읍 양근리 6962022-10-27137.48765468127.49758432024-01-30
18251826남북로51-10경기도 양평군 양평읍 양근리 7182022-10-27137.48745718127.49848192024-01-30
18261827남북로53-33경기도 양평군 양평읍 양근리 6982022-10-27137.4877084127.49712952024-01-30
18271828남북로53-41경기도 양평군 양평읍 양근리 6942022-10-27137.4876055127.49803062024-01-30
18281829남북로53-45경기도 양평군 양평읍 양근리 6932022-10-27137.48751657127.49828722024-01-30
18291830시민로24번길47-1경기도 양평군 양평읍 양근리 7032022-10-27137.48681429127.49709822024-01-30