Overview

Dataset statistics

Number of variables3
Number of observations2722
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory69.2 KiB
Average record size in memory26.0 B

Variable types

Text1
Numeric2

Dataset

Description서울특별시 광진구 관내의 가로등 위치 정보 관련 데이터이며, 가로등 관리번호, 위도 및 경도 등의 정보를 제공합니다.
Author서울특별시 광진구
URLhttps://www.data.go.kr/data/15070592/fileData.do

Reproduction

Analysis started2023-12-12 21:20:41.036117
Analysis finished2023-12-12 21:20:41.604584
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

Distinct2687
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
2023-12-13T06:20:41.763156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length7.777737
Min length6

Characters and Unicode

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

Unique

Unique2652 ?
Unique (%)97.4%

Sample

1st row로데오거리1-1
2nd row로데오거리1-16
3rd row중곡제방길1
4th row중곡제방길10
5th row중곡제방길11
ValueCountFrequency (%)
광나루로 26
 
0.9%
천호대로138길 12
 
0.4%
천호대로 10
 
0.4%
아차산로 10
 
0.4%
구천면로 6
 
0.2%
능동로10길 5
 
0.2%
광나루로6-10 2
 
0.1%
광나루로6-4 2
 
0.1%
광나루로6-3 2
 
0.1%
광나루로6-2 2
 
0.1%
Other values (2684) 2716
97.2%
2023-12-13T06:20:42.436363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 2670
 
12.6%
1 2635
 
12.4%
로 2503
 
11.8%
2 1070
 
5.1%
3 689
 
3.3%
4 630
 
3.0%
산 563
 
2.7%
7 529
 
2.5%
6 518
 
2.4%
5 509
 
2.4%
Other values (82) 8855
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10654
50.3%
Decimal Number 7770
36.7%
Dash Punctuation 2670
 
12.6%
Space Separator 71
 
0.3%
Open Punctuation 3
 
< 0.1%
Close Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 2503
23.5%
산 563
 
5.3%
아 507
 
4.8%
동 471
 
4.4%
차 463
 
4.3%
대 326
 
3.1%
길 317
 
3.0%
능 312
 
2.9%
천 310
 
2.9%
호 294
 
2.8%
Other values (68) 4588
43.1%
Decimal Number
ValueCountFrequency (%)
1 2635
33.9%
2 1070
13.8%
3 689
 
8.9%
4 630
 
8.1%
7 529
 
6.8%
6 518
 
6.7%
5 509
 
6.6%
0 432
 
5.6%
8 412
 
5.3%
9 346
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 2670
100.0%
Space Separator
ValueCountFrequency (%)
71
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10654
50.3%
Common 10517
49.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 2503
23.5%
산 563
 
5.3%
아 507
 
4.8%
동 471
 
4.4%
차 463
 
4.3%
대 326
 
3.1%
길 317
 
3.0%
능 312
 
2.9%
천 310
 
2.9%
호 294
 
2.8%
Other values (68) 4588
43.1%
Common
ValueCountFrequency (%)
- 2670
25.4%
1 2635
25.1%
2 1070
10.2%
3 689
 
6.6%
4 630
 
6.0%
7 529
 
5.0%
6 518
 
4.9%
5 509
 
4.8%
0 432
 
4.1%
8 412
 
3.9%
Other values (4) 423
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10654
50.3%
ASCII 10517
49.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 2670
25.4%
1 2635
25.1%
2 1070
10.2%
3 689
 
6.6%
4 630
 
6.0%
7 529
 
5.0%
6 518
 
4.9%
5 509
 
4.8%
0 432
 
4.1%
8 412
 
3.9%
Other values (4) 423
 
4.0%
Hangul
ValueCountFrequency (%)
로 2503
23.5%
산 563
 
5.3%
아 507
 
4.8%
동 471
 
4.4%
차 463
 
4.3%
대 326
 
3.1%
길 317
 
3.0%
능 312
 
2.9%
천 310
 
2.9%
호 294
 
2.8%
Other values (68) 4588
43.1%

위도
Real number (ℝ)

Distinct2716
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.547682
Minimum37.529004
Maximum37.571695
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.1 KiB
2023-12-13T06:20:42.567194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.529004
5-th percentile37.532397
Q137.538016
median37.546704
Q337.55606
95-th percentile37.567301
Maximum37.571695
Range0.0426917
Interquartile range (IQR)0.018044525

Descriptive statistics

Standard deviation0.010873759
Coefficient of variation (CV)0.00028959867
Kurtosis-0.88522395
Mean37.547682
Median Absolute Deviation (MAD)0.00892415
Skewness0.3574414
Sum102204.79
Variance0.00011823863
MonotonicityNot monotonic
2023-12-13T06:20:42.704196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5362181 2
 
0.1%
37.538499 2
 
0.1%
37.5366842 2
 
0.1%
37.549261 2
 
0.1%
37.5466988 2
 
0.1%
37.5317972 2
 
0.1%
37.5406162 1
 
< 0.1%
37.5407455 1
 
< 0.1%
37.5406448 1
 
< 0.1%
37.5405297 1
 
< 0.1%
Other values (2706) 2706
99.4%
ValueCountFrequency (%)
37.5290035 1
< 0.1%
37.529362 1
< 0.1%
37.5295672 1
< 0.1%
37.5297923 1
< 0.1%
37.5298311 1
< 0.1%
37.5298832 1
< 0.1%
37.5299024 1
< 0.1%
37.5299561 1
< 0.1%
37.5299942 1
< 0.1%
37.5300138 1
< 0.1%
ValueCountFrequency (%)
37.5716952 1
< 0.1%
37.5716814 1
< 0.1%
37.571652 1
< 0.1%
37.5716372 1
< 0.1%
37.5716348 1
< 0.1%
37.5716273 1
< 0.1%
37.5715885 1
< 0.1%
37.571553 1
< 0.1%
37.5715306 1
< 0.1%
37.5715206 1
< 0.1%

경도
Real number (ℝ)

Distinct2713
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.08471
Minimum127.0604
Maximum127.11367
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.1 KiB
2023-12-13T06:20:42.838504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.0604
5-th percentile127.06771
Q1127.07599
median127.08359
Q3127.09314
95-th percentile127.10579
Maximum127.11367
Range0.0532681
Interquartile range (IQR)0.01714935

Descriptive statistics

Standard deviation0.011547431
Coefficient of variation (CV)9.0864053 × 10-5
Kurtosis-0.61274666
Mean127.08471
Median Absolute Deviation (MAD)0.00840715
Skewness0.31221869
Sum345924.57
Variance0.00013334317
MonotonicityNot monotonic
2023-12-13T06:20:42.974702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.0741027 2
 
0.1%
127.0959373 2
 
0.1%
127.1021188 2
 
0.1%
127.0871754 2
 
0.1%
127.1017672 2
 
0.1%
127.079541 2
 
0.1%
127.0769594 2
 
0.1%
127.0836007 2
 
0.1%
127.0778197 2
 
0.1%
127.1033099 1
 
< 0.1%
Other values (2703) 2703
99.3%
ValueCountFrequency (%)
127.0603974 1
< 0.1%
127.0604075 1
< 0.1%
127.0604658 1
< 0.1%
127.0605817 1
< 0.1%
127.0606103 1
< 0.1%
127.0607638 1
< 0.1%
127.0607712 1
< 0.1%
127.060967 1
< 0.1%
127.0609695 1
< 0.1%
127.0610957 1
< 0.1%
ValueCountFrequency (%)
127.1136655 1
< 0.1%
127.113434 1
< 0.1%
127.1132173 1
< 0.1%
127.1129133 1
< 0.1%
127.1125709 1
< 0.1%
127.1122452 1
< 0.1%
127.1122233 1
< 0.1%
127.1122111 1
< 0.1%
127.1121336 1
< 0.1%
127.1120663 1
< 0.1%

Interactions

2023-12-13T06:20:41.341782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:20:41.187449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:20:41.418151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:20:41.262170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:20:43.059372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.696
경도0.6961.000
2023-12-13T06:20:43.133196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.037
경도0.0371.000

Missing values

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

관리번호위도경도
0로데오거리1-137.539513127.070008
1로데오거리1-1637.540853127.066288
2중곡제방길137.571695127.079518
3중곡제방길1037.570218127.079153
4중곡제방길1137.570053127.079086
5중곡제방길11-137.569776127.079118
6중곡제방길1237.569809127.078993
7중곡제방길1337.569649127.078935
8중곡제방길1437.569512127.078873
9중곡제방길1537.569376127.0788
관리번호위도경도
2712하우스스토리1-1337.530287127.089374
2713하우스스토리1-1337.530304127.089614
2714하우스스토리1-237.530014127.088962
2715하우스스토리1-337.53019127.089054
2716하우스스토리1-437.530233127.089164
2717하우스스토리1-537.530094127.089264
2718하우스스토리1-637.529902127.089319
2719하우스스토리1-737.529831127.089568
2720하우스스토리1-837.529883127.090268
2721하우스스토리1-937.530091127.090447