Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells1617
Missing cells (%)2.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory576.2 KiB
Average record size in memory59.0 B

Variable types

Numeric3
Text2
Categorical1

Dataset

Description인천광역시 중구 관내에 위치한 가로등 분전함, 등주, 위도, 경도에 관한 정보입니다.파일명 인천광역시_중구_가로등 현황내용 분전함, 등주, 위도, 경도 등
Author인천광역시 중구
URLhttps://www.data.go.kr/data/15059732/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
등주 has 1617 (16.2%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:29:48.406832
Analysis finished2023-12-12 12:29:51.055190
Duration2.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7868.3244
Minimum4
Maximum15753
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T21:29:51.135585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile807.95
Q13917.5
median7840
Q311796.25
95-th percentile14968.05
Maximum15753
Range15749
Interquartile range (IQR)7878.75

Descriptive statistics

Standard deviation4544.5804
Coefficient of variation (CV)0.57757918
Kurtosis-1.2029432
Mean7868.3244
Median Absolute Deviation (MAD)3937.5
Skewness0.0090081118
Sum78683244
Variance20653211
MonotonicityNot monotonic
2023-12-12T21:29:51.296622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
12515 1
 
< 0.1%
4342 1
 
< 0.1%
12462 1
 
< 0.1%
6820 1
 
< 0.1%
4830 1
 
< 0.1%
28 1
 
< 0.1%
7075 1
 
< 0.1%
15659 1
 
< 0.1%
12890 1
 
< 0.1%
9147 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
4 1
< 0.1%
6 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
13 1
< 0.1%
14 1
< 0.1%
15 1
< 0.1%
16 1
< 0.1%
17 1
< 0.1%
18 1
< 0.1%
ValueCountFrequency (%)
15753 1
< 0.1%
15751 1
< 0.1%
15749 1
< 0.1%
15748 1
< 0.1%
15747 1
< 0.1%
15744 1
< 0.1%
15743 1
< 0.1%
15741 1
< 0.1%
15739 1
< 0.1%
15738 1
< 0.1%

분전함
Text

Distinct718
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T21:29:51.626864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length10.7011
Min length4

Characters and Unicode

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

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st row제10호어린이공원
2nd row서해대로271번길1(YB300)
3rd row미단시티LP_21
4th row하늘대로3
5th row하늘달빛로2
ValueCountFrequency (%)
영종해안북로lp-1(yb6 115
 
1.1%
영종해안남로lp-2(yb2 112
 
1.1%
영종해안북로lp-3(yb4 111
 
1.1%
영종해안남로lp-1(yb3 110
 
1.1%
영종해안북로lp-2(yb5 103
 
1.0%
영종해안남로lp-3(yb1 100
 
1.0%
제35호근린공원lp_1 62
 
0.6%
공항서로lp-1(yb1204 53
 
0.5%
공항서로lp-2(yb1205 51
 
0.5%
운서지구lp-b(yb302 50
 
0.5%
Other values (709) 9154
91.3%
2023-12-12T21:29:52.081885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
로 8049
 
7.5%
1 7865
 
7.3%
2 5503
 
5.1%
( 5300
 
5.0%
) 5300
 
5.0%
B 5190
 
4.8%
Y 5120
 
4.8%
3 3234
 
3.0%
L 3128
 
2.9%
P 3094
 
2.9%
Other values (208) 55228
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 45659
42.7%
Decimal Number 30300
28.3%
Uppercase Letter 17119
 
16.0%
Open Punctuation 5300
 
5.0%
Close Punctuation 5300
 
5.0%
Dash Punctuation 2359
 
2.2%
Connector Punctuation 953
 
0.9%
Space Separator 21
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 8049
 
17.6%
대 2317
 
5.1%
길 2125
 
4.7%
번 1953
 
4.3%
영 1663
 
3.6%
종 1654
 
3.6%
해 1173
 
2.6%
하 1145
 
2.5%
서 1122
 
2.5%
남 903
 
2.0%
Other values (180) 23555
51.6%
Uppercase Letter
ValueCountFrequency (%)
B 5190
30.3%
Y 5120
29.9%
L 3128
18.3%
P 3094
18.1%
A 252
 
1.5%
C 113
 
0.7%
G 64
 
0.4%
D 63
 
0.4%
I 58
 
0.3%
E 28
 
0.2%
Other values (3) 9
 
0.1%
Decimal Number
ValueCountFrequency (%)
1 7865
26.0%
2 5503
18.2%
3 3234
10.7%
4 2535
 
8.4%
0 2152
 
7.1%
5 2111
 
7.0%
6 1885
 
6.2%
7 1702
 
5.6%
8 1672
 
5.5%
9 1641
 
5.4%
Open Punctuation
ValueCountFrequency (%)
( 5300
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5300
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2359
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 953
100.0%
Space Separator
ValueCountFrequency (%)
21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 45659
42.7%
Common 44233
41.3%
Latin 17119
 
16.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 8049
 
17.6%
대 2317
 
5.1%
길 2125
 
4.7%
번 1953
 
4.3%
영 1663
 
3.6%
종 1654
 
3.6%
해 1173
 
2.6%
하 1145
 
2.5%
서 1122
 
2.5%
남 903
 
2.0%
Other values (180) 23555
51.6%
Common
ValueCountFrequency (%)
1 7865
17.8%
2 5503
12.4%
( 5300
12.0%
) 5300
12.0%
3 3234
7.3%
4 2535
 
5.7%
- 2359
 
5.3%
0 2152
 
4.9%
5 2111
 
4.8%
6 1885
 
4.3%
Other values (5) 5989
13.5%
Latin
ValueCountFrequency (%)
B 5190
30.3%
Y 5120
29.9%
L 3128
18.3%
P 3094
18.1%
A 252
 
1.5%
C 113
 
0.7%
G 64
 
0.4%
D 63
 
0.4%
I 58
 
0.3%
E 28
 
0.2%
Other values (3) 9
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 61352
57.3%
Hangul 45659
42.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
로 8049
 
17.6%
대 2317
 
5.1%
길 2125
 
4.7%
번 1953
 
4.3%
영 1663
 
3.6%
종 1654
 
3.6%
해 1173
 
2.6%
하 1145
 
2.5%
서 1122
 
2.5%
남 903
 
2.0%
Other values (180) 23555
51.6%
ASCII
ValueCountFrequency (%)
1 7865
12.8%
2 5503
 
9.0%
( 5300
 
8.6%
) 5300
 
8.6%
B 5190
 
8.5%
Y 5120
 
8.3%
3 3234
 
5.3%
L 3128
 
5.1%
P 3094
 
5.0%
4 2535
 
4.1%
Other values (18) 15083
24.6%

등주
Text

MISSING 

Distinct889
Distinct (%)10.6%
Missing1617
Missing (%)16.2%
Memory size156.2 KiB
2023-12-12T21:29:52.530302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length2
Mean length2.2687582
Min length1

Characters and Unicode

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

Unique

Unique554 ?
Unique (%)6.6%

Sample

1st row7
2nd row좌8
3rd row18
4th row7
5th row2
ValueCountFrequency (%)
1 227
 
2.7%
4 199
 
2.3%
2 196
 
2.3%
8 195
 
2.3%
10 194
 
2.3%
5 191
 
2.2%
3 190
 
2.2%
9 189
 
2.2%
6 186
 
2.2%
13 173
 
2.0%
Other values (790) 6572
77.2%
2023-12-12T21:29:53.195843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 3428
18.0%
2 2365
12.4%
3 1728
9.1%
우 1645
8.6%
좌 1428
7.5%
4 1267
 
6.7%
5 1054
 
5.5%
0 941
 
4.9%
6 914
 
4.8%
8 833
 
4.4%
Other values (95) 3416
18.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 14116
74.2%
Other Letter 4184
 
22.0%
Dash Punctuation 416
 
2.2%
Uppercase Letter 148
 
0.8%
Space Separator 129
 
0.7%
Close Punctuation 12
 
0.1%
Open Punctuation 12
 
0.1%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
우 1645
39.3%
좌 1428
34.1%
로 163
 
3.9%
길 102
 
2.4%
번 100
 
2.4%
반 54
 
1.3%
대 44
 
1.1%
서 33
 
0.8%
부 32
 
0.8%
해 32
 
0.8%
Other values (70) 551
 
13.2%
Decimal Number
ValueCountFrequency (%)
1 3428
24.3%
2 2365
16.8%
3 1728
12.2%
4 1267
 
9.0%
5 1054
 
7.5%
0 941
 
6.7%
6 914
 
6.5%
8 833
 
5.9%
7 832
 
5.9%
9 754
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
A 45
30.4%
L 41
27.7%
B 21
14.2%
P 18
 
12.2%
C 9
 
6.1%
D 6
 
4.1%
E 6
 
4.1%
X 1
 
0.7%
R 1
 
0.7%
Lowercase Letter
ValueCountFrequency (%)
x 1
50.0%
p 1
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 416
100.0%
Space Separator
ValueCountFrequency (%)
129
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 14685
77.2%
Hangul 4184
 
22.0%
Latin 150
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
우 1645
39.3%
좌 1428
34.1%
로 163
 
3.9%
길 102
 
2.4%
번 100
 
2.4%
반 54
 
1.3%
대 44
 
1.1%
서 33
 
0.8%
부 32
 
0.8%
해 32
 
0.8%
Other values (70) 551
 
13.2%
Common
ValueCountFrequency (%)
1 3428
23.3%
2 2365
16.1%
3 1728
11.8%
4 1267
 
8.6%
5 1054
 
7.2%
0 941
 
6.4%
6 914
 
6.2%
8 833
 
5.7%
7 832
 
5.7%
9 754
 
5.1%
Other values (4) 569
 
3.9%
Latin
ValueCountFrequency (%)
A 45
30.0%
L 41
27.3%
B 21
14.0%
P 18
 
12.0%
C 9
 
6.0%
D 6
 
4.0%
E 6
 
4.0%
X 1
 
0.7%
x 1
 
0.7%
p 1
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 14835
78.0%
Hangul 4184
 
22.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 3428
23.1%
2 2365
15.9%
3 1728
11.6%
4 1267
 
8.5%
5 1054
 
7.1%
0 941
 
6.3%
6 914
 
6.2%
8 833
 
5.6%
7 832
 
5.6%
9 754
 
5.1%
Other values (15) 719
 
4.8%
Hangul
ValueCountFrequency (%)
우 1645
39.3%
좌 1428
34.1%
로 163
 
3.9%
길 102
 
2.4%
번 100
 
2.4%
반 54
 
1.3%
대 44
 
1.1%
서 33
 
0.8%
부 32
 
0.8%
해 32
 
0.8%
Other values (70) 551
 
13.2%

위도
Real number (ℝ)

Distinct9696
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.48035
Minimum37.372768
Maximum37.53283
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T21:29:53.394654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.372768
5-th percentile37.435712
Q137.470068
median37.483147
Q337.495222
95-th percentile37.523827
Maximum37.53283
Range0.1600625
Interquartile range (IQR)0.025154

Descriptive statistics

Standard deviation0.025510926
Coefficient of variation (CV)0.00068064803
Kurtosis1.4127092
Mean37.48035
Median Absolute Deviation (MAD)0.0124936
Skewness-0.71771564
Sum374803.5
Variance0.00065080736
MonotonicityNot monotonic
2023-12-12T21:29:53.632764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.481044 3
 
< 0.1%
37.498369 3
 
< 0.1%
37.477835 3
 
< 0.1%
37.482456 3
 
< 0.1%
37.481394 3
 
< 0.1%
37.490979 3
 
< 0.1%
37.47993 3
 
< 0.1%
37.490642 3
 
< 0.1%
37.482656 3
 
< 0.1%
37.481236 3
 
< 0.1%
Other values (9686) 9970
99.7%
ValueCountFrequency (%)
37.3727677 1
< 0.1%
37.3728279 1
< 0.1%
37.3728708 1
< 0.1%
37.3728916 1
< 0.1%
37.3729041 1
< 0.1%
37.3730157 1
< 0.1%
37.3730771 1
< 0.1%
37.3731308 1
< 0.1%
37.3732271 1
< 0.1%
37.3732549 1
< 0.1%
ValueCountFrequency (%)
37.5328302 1
< 0.1%
37.5326884 1
< 0.1%
37.5324615 1
< 0.1%
37.532161 1
< 0.1%
37.5321558 1
< 0.1%
37.5320406 1
< 0.1%
37.53194253 1
< 0.1%
37.5318359 1
< 0.1%
37.531263 1
< 0.1%
37.531182 1
< 0.1%

경도
Real number (ℝ)

Distinct9832
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.52896
Minimum126.3562
Maximum126.64337
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T21:29:53.844248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.3562
5-th percentile126.39455
Q1126.49982
median126.52482
Q3126.57151
95-th percentile126.62837
Maximum126.64337
Range0.2871701
Interquartile range (IQR)0.07168975

Descriptive statistics

Standard deviation0.066458446
Coefficient of variation (CV)0.00052524298
Kurtosis-0.15614477
Mean126.52896
Median Absolute Deviation (MAD)0.03525475
Skewness-0.41120171
Sum1265289.6
Variance0.0044167251
MonotonicityNot monotonic
2023-12-12T21:29:54.049568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.533081 3
 
< 0.1%
126.532865 3
 
< 0.1%
126.513934 3
 
< 0.1%
126.518275 3
 
< 0.1%
126.513731 3
 
< 0.1%
126.567908 2
 
< 0.1%
126.518136 2
 
< 0.1%
126.526757 2
 
< 0.1%
126.559551 2
 
< 0.1%
126.535878 2
 
< 0.1%
Other values (9822) 9975
99.8%
ValueCountFrequency (%)
126.3562004 1
< 0.1%
126.3562499 1
< 0.1%
126.356296 1
< 0.1%
126.3562981 1
< 0.1%
126.3564173 1
< 0.1%
126.3564666 1
< 0.1%
126.3567062 1
< 0.1%
126.3567454 1
< 0.1%
126.3570089 1
< 0.1%
126.3570908 1
< 0.1%
ValueCountFrequency (%)
126.6433705 1
< 0.1%
126.6429717 1
< 0.1%
126.6425496 1
< 0.1%
126.6421395 1
< 0.1%
126.6420643 1
< 0.1%
126.6419675 1
< 0.1%
126.6419226 1
< 0.1%
126.6419046 1
< 0.1%
126.6418865 1
< 0.1%
126.6418746 1
< 0.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-10-23
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-23
2nd row2023-10-23
3rd row2023-10-23
4th row2023-10-23
5th row2023-10-23

Common Values

ValueCountFrequency (%)
2023-10-23 10000
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:29:54.355753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-23 10000
100.0%

Interactions

2023-12-12T21:29:50.342215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:48.992263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:49.821025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:50.491024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:49.130455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:50.023173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:50.659494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:49.265286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:29:50.186377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:29:54.423757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도
순번1.0000.7970.881
위도0.7971.0000.843
경도0.8810.8431.000
2023-12-12T21:29:54.539433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도
순번1.0000.493-0.264
위도0.4931.000-0.099
경도-0.264-0.0991.000

Missing values

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

순번분전함등주위도경도데이터기준일자
1251412515제10호어린이공원737.492569126.5070342023-10-23
29052906서해대로271번길1(YB300)좌837.453166126.6243662023-10-23
87738774미단시티LP_211837.523042126.5071632023-10-23
1434314344하늘대로3737.476331126.5173732023-10-23
1387413875하늘달빛로2237.484766126.5607312023-10-23
659660축항대로8(YB73)우4837.45186126.6182532023-10-23
1389013891하늘달빛로21837.486836126.5576682023-10-23
28672868인중로174번길1(YB297)우637.46911126.6247972023-10-23
1421514216하늘대로113037.50145126.5607392023-10-23
1134611347영종진로1937.494444126.5749532023-10-23
순번분전함등주위도경도데이터기준일자
46704671자연대로LP-2(YB248)<NA>37.498161126.5458952023-10-23
33073308참외전로72번길1(개통불가)(YB202)<NA>37.478643126.627882023-10-23
56745675신도남로LP-7(YB710)우237.493806126.4903212023-10-23
1292012921제3호소공원737.505833126.4982632023-10-23
68856886영종해안북로LP-3(YB4)<NA>37.482538126.3928272023-10-23
1429714298하늘대로2537.471576126.5121442023-10-23
10731074제물량로2(YB120)좌937.463854126.6362082023-10-23
568569인중로5(YB35)좌2037.465486126.6316462023-10-23
76337634운북2(YB24)좌437.523424126.5024122023-10-23
41384139용유서로LP-A2(YB1223)우237.449889126.3890112023-10-23