Overview

Dataset statistics

Number of variables3
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory332.0 KiB
Average record size in memory34.0 B

Variable types

Text1
Numeric2

Dataset

Description서울특별시(도로사업소, 서울시설공단) 관리 가로등 위치 정보입니다. 가로등의 위도, 경도 정보를 제공합니다.
Author서울특별시
URLhttps://www.data.go.kr/data/15107934/fileData.do

Alerts

위도 is highly skewed (γ1 = -35.25566249)Skewed
경도 is highly skewed (γ1 = 35.31819645)Skewed
관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:54:51.897030
Analysis finished2023-12-12 19:54:53.110041
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T04:54:53.299249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length8.4919
Min length6

Characters and Unicode

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

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st row가양대교램프_01-39
2nd row강_25-88
3rd row이수고가_01-70
4th row강_36-35
5th row올_24-10
ValueCountFrequency (%)
아천ic 80
 
0.8%
암사ic 16
 
0.2%
천호대교 5
 
< 0.1%
03-01 2
 
< 0.1%
03-06 2
 
< 0.1%
구리암사북단경관상류-06 1
 
< 0.1%
올_14a-03 1
 
< 0.1%
올_72-01 1
 
< 0.1%
강_50_1-44 1
 
< 0.1%
동_04-02 1
 
< 0.1%
Other values (9991) 9991
98.9%
2023-12-13T04:54:53.793165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 10000
 
11.8%
_ 7598
 
8.9%
0 7163
 
8.4%
1 6269
 
7.4%
2 4951
 
5.8%
3 3827
 
4.5%
4 3262
 
3.8%
교 2793
 
3.3%
5 2716
 
3.2%
6 2288
 
2.7%
Other values (177) 34052
40.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 35638
42.0%
Other Letter 30197
35.6%
Dash Punctuation 10000
 
11.8%
Connector Punctuation 7598
 
8.9%
Uppercase Letter 1385
 
1.6%
Space Separator 101
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 2793
 
9.2%
단 2148
 
7.1%
올 2136
 
7.1%
대 1883
 
6.2%
강 1821
 
6.0%
북 1284
 
4.3%
남 1267
 
4.2%
동 1093
 
3.6%
가 851
 
2.8%
하 781
 
2.6%
Other values (157) 14140
46.8%
Decimal Number
ValueCountFrequency (%)
0 7163
20.1%
1 6269
17.6%
2 4951
13.9%
3 3827
10.7%
4 3262
9.2%
5 2716
 
7.6%
6 2288
 
6.4%
7 2087
 
5.9%
8 1647
 
4.6%
9 1428
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
A 513
37.0%
C 319
23.0%
I 294
21.2%
P 93
 
6.7%
L 93
 
6.7%
B 62
 
4.5%
D 11
 
0.8%
Dash Punctuation
ValueCountFrequency (%)
- 10000
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 7598
100.0%
Space Separator
ValueCountFrequency (%)
101
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 53337
62.8%
Hangul 30197
35.6%
Latin 1385
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 2793
 
9.2%
단 2148
 
7.1%
올 2136
 
7.1%
대 1883
 
6.2%
강 1821
 
6.0%
북 1284
 
4.3%
남 1267
 
4.2%
동 1093
 
3.6%
가 851
 
2.8%
하 781
 
2.6%
Other values (157) 14140
46.8%
Common
ValueCountFrequency (%)
- 10000
18.7%
_ 7598
14.2%
0 7163
13.4%
1 6269
11.8%
2 4951
9.3%
3 3827
 
7.2%
4 3262
 
6.1%
5 2716
 
5.1%
6 2288
 
4.3%
7 2087
 
3.9%
Other values (3) 3176
 
6.0%
Latin
ValueCountFrequency (%)
A 513
37.0%
C 319
23.0%
I 294
21.2%
P 93
 
6.7%
L 93
 
6.7%
B 62
 
4.5%
D 11
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 54722
64.4%
Hangul 30197
35.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 10000
18.3%
_ 7598
13.9%
0 7163
13.1%
1 6269
11.5%
2 4951
9.0%
3 3827
 
7.0%
4 3262
 
6.0%
5 2716
 
5.0%
6 2288
 
4.2%
7 2087
 
3.8%
Other values (10) 4561
8.3%
Hangul
ValueCountFrequency (%)
교 2793
 
9.2%
단 2148
 
7.1%
올 2136
 
7.1%
대 1883
 
6.2%
강 1821
 
6.0%
북 1284
 
4.3%
남 1267
 
4.2%
동 1093
 
3.6%
가 851
 
2.8%
하 781
 
2.6%
Other values (157) 14140
46.8%

위도
Real number (ℝ)

SKEWED 

Distinct9531
Distinct (%)95.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.514932
Minimum0
Maximum37.689025
Zeros8
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T04:54:54.005315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile37.491885
Q137.519992
median37.537765
Q337.566083
95-th percentile37.615137
Maximum37.689025
Range37.689025
Interquartile range (IQR)0.04609125

Descriptive statistics

Standard deviation1.0621862
Coefficient of variation (CV)0.028313692
Kurtosis1242.6835
Mean37.514932
Median Absolute Deviation (MAD)0.021061
Skewness-35.255662
Sum375149.32
Variance1.1282396
MonotonicityNot monotonic
2023-12-13T04:54:54.239511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 8
 
0.1%
37.538375 3
 
< 0.1%
37.516696 3
 
< 0.1%
37.532415 3
 
< 0.1%
37.537544 3
 
< 0.1%
37.517259 3
 
< 0.1%
37.531118 3
 
< 0.1%
37.517773 3
 
< 0.1%
37.565251 3
 
< 0.1%
37.547795 3
 
< 0.1%
Other values (9521) 9965
99.7%
ValueCountFrequency (%)
0.0 8
0.1%
37.464033 1
 
< 0.1%
37.465221 1
 
< 0.1%
37.466134 1
 
< 0.1%
37.466516 1
 
< 0.1%
37.466611 1
 
< 0.1%
37.467057 1
 
< 0.1%
37.467464 1
 
< 0.1%
37.467611 1
 
< 0.1%
37.467668 1
 
< 0.1%
ValueCountFrequency (%)
37.689025 1
< 0.1%
37.688861 1
< 0.1%
37.688641 1
< 0.1%
37.688404 1
< 0.1%
37.688197 1
< 0.1%
37.688171 1
< 0.1%
37.68793 1
< 0.1%
37.687666 1
< 0.1%
37.686886 1
< 0.1%
37.685676 1
< 0.1%

경도
Real number (ℝ)

SKEWED 

Distinct9795
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3858.1363
Minimum126.79834
Maximum4664046.1
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T04:54:54.454277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.79834
5-th percentile126.85503
Q1126.92004
median127.01864
Q3127.07285
95-th percentile127.12048
Maximum4664046.1
Range4663919.3
Interquartile range (IQR)0.1528095

Descriptive statistics

Standard deviation131869.37
Coefficient of variation (CV)34.179552
Kurtosis1245.6241
Mean3858.1363
Median Absolute Deviation (MAD)0.074784
Skewness35.318196
Sum38581363
Variance1.7389531 × 1010
MonotonicityNot monotonic
2023-12-13T04:54:54.643770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4664046.125 8
 
0.1%
127.038824 3
 
< 0.1%
127.034899 3
 
< 0.1%
127.097637 3
 
< 0.1%
127.055702 3
 
< 0.1%
127.03452 2
 
< 0.1%
127.070957 2
 
< 0.1%
127.070105 2
 
< 0.1%
127.109482 2
 
< 0.1%
127.035452 2
 
< 0.1%
Other values (9785) 9970
99.7%
ValueCountFrequency (%)
126.798345 1
< 0.1%
126.798363 1
< 0.1%
126.798449 1
< 0.1%
126.798571 1
< 0.1%
126.798606 1
< 0.1%
126.798665 1
< 0.1%
126.798708 1
< 0.1%
126.798771 1
< 0.1%
126.798864 1
< 0.1%
126.798874 1
< 0.1%
ValueCountFrequency (%)
4664046.125 8
0.1%
127.16844 1
 
< 0.1%
127.168258 1
 
< 0.1%
127.168156 1
 
< 0.1%
127.168143 1
 
< 0.1%
127.167814 1
 
< 0.1%
127.167729 1
 
< 0.1%
127.167645 1
 
< 0.1%
127.16729 1
 
< 0.1%
127.166826 1
 
< 0.1%

Interactions

2023-12-13T04:54:52.672531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:54:52.378155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:54:52.800603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:54:52.519506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:54:54.763674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.995
경도0.9951.000
2023-12-13T04:54:54.873189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.010
경도-0.0101.000

Missing values

2023-12-13T04:54:52.955132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:54:53.057019image/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

관리번호위도경도
304가양대교램프_01-3937.564249126.858325
9119강_25-8837.523817126.955297
6033이수고가_01-7037.499433126.985221
9662강_36-3537.543581127.025775
15485올_24-1037.517883126.941053
13484동_36-1737.68555127.054815
4774여의샛강다리-1337.519092126.919271
8771강_18-1037.541483126.93775
10543강_48-9837.5342127.095386
13654북부_02-5037.607573127.050758
관리번호위도경도
6942탄천1교-1737.500759127.084744
8587강_14-1137.542656126.91465
12789동_18-1437.54951127.063844
4150숯내교-0437.479198127.115425
949광평교-2637.488405127.104921
16930올_54A-8937.519601127.063833
4792여의샛강다리경관-0337.518311126.918023
14050아천IC 01-1937.572629127.131238
3080사평지하차도-0237.502345127.004274
5838응봉교남단_02-1137.549895127.0358