Overview

Dataset statistics

Number of variables7
Number of observations161
Missing cells153
Missing cells (%)13.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.4 KiB
Average record size in memory59.8 B

Variable types

Numeric3
Categorical2
Text2

Dataset

Description서울올림픽기념국민체육진흥공단에 배치된 2021년 공공데이터 청년인턴(일경험 수련생)을 통해 수집된 올림픽공원 내 편의시설(자판기, 쓰레기통, 간이편의점 등) 정보를 제공하는 데이터 입니다.
Author서울올림픽기념국민체육진흥공단
URLhttps://www.data.go.kr/data/15089799/fileData.do

Alerts

순번 is highly overall correlated with 위치High correlation
위도 is highly overall correlated with 위치High correlation
경도 is highly overall correlated with 위치High correlation
위치 is highly overall correlated with 순번 and 2 other fieldsHigh correlation
비고 has 153 (95.0%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:35:40.976752
Analysis finished2023-12-12 15:35:42.996305
Duration2.02 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct161
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean81
Minimum1
Maximum161
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T00:35:43.076505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9
Q141
median81
Q3121
95-th percentile153
Maximum161
Range160
Interquartile range (IQR)80

Descriptive statistics

Standard deviation46.620811
Coefficient of variation (CV)0.57556557
Kurtosis-1.2
Mean81
Median Absolute Deviation (MAD)40
Skewness0
Sum13041
Variance2173.5
MonotonicityStrictly increasing
2023-12-13T00:35:43.287473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
122 1
 
0.6%
104 1
 
0.6%
105 1
 
0.6%
106 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
Other values (151) 151
93.8%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
161 1
0.6%
160 1
0.6%
159 1
0.6%
158 1
0.6%
157 1
0.6%
156 1
0.6%
155 1
0.6%
154 1
0.6%
153 1
0.6%
152 1
0.6%

구분
Categorical

Distinct7
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
쓰레기통
106 
자판기
22 
화장실
15 
음수대
 
7
간이편의점
 
6
Other values (2)
 
5

Length

Max length6
Median length4
Mean length3.7888199
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row쓰레기통
2nd row쓰레기통
3rd row쓰레기통
4th row자판기
5th row쓰레기통

Common Values

ValueCountFrequency (%)
쓰레기통 106
65.8%
자판기 22
 
13.7%
화장실 15
 
9.3%
음수대 7
 
4.3%
간이편의점 6
 
3.7%
흡연구역 3
 
1.9%
식음료판매점 2
 
1.2%

Length

2023-12-13T00:35:43.485200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:35:43.651088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
쓰레기통 106
65.8%
자판기 22
 
13.7%
화장실 15
 
9.3%
음수대 7
 
4.3%
간이편의점 6
 
3.7%
흡연구역 3
 
1.9%
식음료판매점 2
 
1.2%

위치
Categorical

HIGH CORRELATION 

Distinct36
Distinct (%)22.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
88마당
21 
평화의 광장
12 
만남의광장
11 
SK핸드볼경기장(올림픽펜싱경기장)
10 
가족놀이동산
 
8
Other values (31)
99 

Length

Max length20
Median length18
Mean length7.2173913
Min length3

Unique

Unique4 ?
Unique (%)2.5%

Sample

1st row올림픽홀(뮤즈라이브)
2nd row올림픽홀(뮤즈라이브)
3rd row올림픽홀(뮤즈라이브)
4th row올림픽홀(뮤즈라이브)
5th row올림픽테니스장

Common Values

ValueCountFrequency (%)
88마당 21
 
13.0%
평화의 광장 12
 
7.5%
만남의광장 11
 
6.8%
SK핸드볼경기장(올림픽펜싱경기장) 10
 
6.2%
가족놀이동산 8
 
5.0%
KSPO DOME(올림픽 체조경기장) 8
 
5.0%
백제집자리전시관 7
 
4.3%
나홀로나무 6
 
3.7%
곰말다리 5
 
3.1%
올림픽수영경기장 5
 
3.1%
Other values (26) 68
42.2%

Length

2023-12-13T00:35:43.840667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
88마당 21
 
10.9%
광장 12
 
6.2%
평화의 12
 
6.2%
만남의광장 11
 
5.7%
sk핸드볼경기장(올림픽펜싱경기장 10
 
5.2%
가족놀이동산 8
 
4.2%
kspo 8
 
4.2%
dome(올림픽 8
 
4.2%
체조경기장 8
 
4.2%
백제집자리전시관 7
 
3.6%
Other values (31) 87
45.3%

상세위치
Text

Distinct75
Distinct (%)46.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-13T00:35:44.159341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length6.2670807
Min length1

Characters and Unicode

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

Unique

Unique49 ?
Unique (%)30.4%

Sample

1st row1-3게이트 앞
2nd row1-1게이트 앞
3rd rowticket box근처
4th rowticket box 근처
5th row실외 테니스장
ValueCountFrequency (%)
47
 
15.6%
앞 37
 
12.3%
부근 19
 
6.3%
근처 14
 
4.7%
방향 10
 
3.3%
옆 8
 
2.7%
등나무 7
 
2.3%
북2문 7
 
2.3%
입구 6
 
2.0%
광장 5
 
1.7%
Other values (84) 141
46.8%
2023-12-13T00:35:44.695912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
144
 
14.3%
- 71
 
7.0%
앞 39
 
3.9%
이 35
 
3.5%
근 34
 
3.4%
2 31
 
3.1%
트 28
 
2.8%
장 25
 
2.5%
게 23
 
2.3%
부 22
 
2.2%
Other values (159) 557
55.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 628
62.2%
Space Separator 144
 
14.3%
Lowercase Letter 84
 
8.3%
Decimal Number 79
 
7.8%
Dash Punctuation 71
 
7.0%
Uppercase Letter 2
 
0.2%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
앞 39
 
6.2%
이 35
 
5.6%
근 34
 
5.4%
트 28
 
4.5%
장 25
 
4.0%
게 23
 
3.7%
부 22
 
3.5%
처 15
 
2.4%
문 12
 
1.9%
구 11
 
1.8%
Other values (133) 384
61.1%
Lowercase Letter
ValueCountFrequency (%)
e 18
21.4%
r 15
17.9%
t 11
13.1%
c 10
11.9%
s 6
 
7.1%
o 5
 
6.0%
a 4
 
4.8%
n 4
 
4.8%
p 3
 
3.6%
b 2
 
2.4%
Other values (3) 6
 
7.1%
Decimal Number
ValueCountFrequency (%)
2 31
39.2%
3 14
17.7%
1 13
16.5%
8 8
 
10.1%
4 4
 
5.1%
6 4
 
5.1%
0 4
 
5.1%
5 1
 
1.3%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
U 1
50.0%
Space Separator
ValueCountFrequency (%)
144
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 71
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 628
62.2%
Common 295
29.2%
Latin 86
 
8.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
앞 39
 
6.2%
이 35
 
5.6%
근 34
 
5.4%
트 28
 
4.5%
장 25
 
4.0%
게 23
 
3.7%
부 22
 
3.5%
처 15
 
2.4%
문 12
 
1.9%
구 11
 
1.8%
Other values (133) 384
61.1%
Latin
ValueCountFrequency (%)
e 18
20.9%
r 15
17.4%
t 11
12.8%
c 10
11.6%
s 6
 
7.0%
o 5
 
5.8%
a 4
 
4.7%
n 4
 
4.7%
p 3
 
3.5%
b 2
 
2.3%
Other values (5) 8
9.3%
Common
ValueCountFrequency (%)
144
48.8%
- 71
24.1%
2 31
 
10.5%
3 14
 
4.7%
1 13
 
4.4%
8 8
 
2.7%
4 4
 
1.4%
6 4
 
1.4%
0 4
 
1.4%
5 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 628
62.2%
ASCII 381
37.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
144
37.8%
- 71
18.6%
2 31
 
8.1%
e 18
 
4.7%
r 15
 
3.9%
3 14
 
3.7%
1 13
 
3.4%
t 11
 
2.9%
c 10
 
2.6%
8 8
 
2.1%
Other values (16) 46
 
12.1%
Hangul
ValueCountFrequency (%)
앞 39
 
6.2%
이 35
 
5.6%
근 34
 
5.4%
트 28
 
4.5%
장 25
 
4.0%
게 23
 
3.7%
부 22
 
3.5%
처 15
 
2.4%
문 12
 
1.9%
구 11
 
1.8%
Other values (133) 384
61.1%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct145
Distinct (%)90.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.518951
Minimum37.512786
Maximum37.524488
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T00:35:44.882927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.512786
5-th percentile37.514703
Q137.517414
median37.5185
Q337.520716
95-th percentile37.523483
Maximum37.524488
Range0.0117026
Interquartile range (IQR)0.003302

Descriptive statistics

Standard deviation0.0026304916
Coefficient of variation (CV)7.0111012 × 10-5
Kurtosis-0.23693322
Mean37.518951
Median Absolute Deviation (MAD)0.0016017
Skewness0.018615681
Sum6040.5511
Variance6.9194862 × 10-6
MonotonicityNot monotonic
2023-12-13T00:35:45.055236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.5225958 3
 
1.9%
37.5225617 2
 
1.2%
37.516695 2
 
1.2%
37.5202725 2
 
1.2%
37.519968 2
 
1.2%
37.5230441 2
 
1.2%
37.5236514 2
 
1.2%
37.5210939 2
 
1.2%
37.5179041 2
 
1.2%
37.5213231 2
 
1.2%
Other values (135) 140
87.0%
ValueCountFrequency (%)
37.5127856 2
1.2%
37.5128944 1
0.6%
37.5129723 1
0.6%
37.5131425 1
0.6%
37.5133037 1
0.6%
37.5140784 1
0.6%
37.51437 1
0.6%
37.5147028 1
0.6%
37.51478 1
0.6%
37.5149914 1
0.6%
ValueCountFrequency (%)
37.5244882 1
0.6%
37.5243715 1
0.6%
37.5241598 1
0.6%
37.5241457 1
0.6%
37.5241181 1
0.6%
37.5237958 1
0.6%
37.5236514 2
1.2%
37.5234828 1
0.6%
37.5234448 1
0.6%
37.5232842 1
0.6%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct145
Distinct (%)90.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.12388
Minimum127.11564
Maximum127.13064
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T00:35:45.215810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.11564
5-th percentile127.11656
Q1127.12118
median127.12522
Q3127.12685
95-th percentile127.12909
Maximum127.13064
Range0.0150086
Interquartile range (IQR)0.0056719

Descriptive statistics

Standard deviation0.0040152799
Coefficient of variation (CV)3.1585568 × 10-5
Kurtosis-0.86766779
Mean127.12388
Median Absolute Deviation (MAD)0.0022637
Skewness-0.56822963
Sum20466.944
Variance1.6122473 × 10-5
MonotonicityNot monotonic
2023-12-13T00:35:45.397330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.1267617 3
 
1.9%
127.1271355 3
 
1.9%
127.124339 2
 
1.2%
127.1253049 2
 
1.2%
127.126092 2
 
1.2%
127.1172217 2
 
1.2%
127.1223323 2
 
1.2%
127.123316 2
 
1.2%
127.1179141 2
 
1.2%
127.1261166 2
 
1.2%
Other values (135) 139
86.3%
ValueCountFrequency (%)
127.1156362 1
0.6%
127.1158136 1
0.6%
127.1160302 1
0.6%
127.1163051 1
0.6%
127.1163108 1
0.6%
127.1163949 2
1.2%
127.116518 1
0.6%
127.1165565 1
0.6%
127.1166712 1
0.6%
127.1169116 1
0.6%
ValueCountFrequency (%)
127.1306448 1
0.6%
127.1303589 1
0.6%
127.1301771 1
0.6%
127.1300162 1
0.6%
127.1297426 1
0.6%
127.1296685 1
0.6%
127.1293664 1
0.6%
127.1291294 1
0.6%
127.1290855 1
0.6%
127.128882 1
0.6%

비고
Text

MISSING 

Distinct6
Distinct (%)75.0%
Missing153
Missing (%)95.0%
Memory size1.4 KiB
2023-12-13T00:35:45.606174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length7
Mean length6.125
Min length1

Characters and Unicode

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

Unique

Unique5 ?
Unique (%)62.5%

Sample

1st row영업일 유동적
2nd row코로나19로 사용불가
3rd row영업일 유동적
4th row
5th row여자화장실
ValueCountFrequency (%)
영업일 3
25.0%
유동적 3
25.0%
여자화장실 2
16.7%
코로나19로 1
 
8.3%
사용불가 1
 
8.3%
상시 1
 
8.3%
영업 1
 
8.3%
2023-12-13T00:35:46.228466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7
14.3%
영 4
 
8.2%
업 4
 
8.2%
일 3
 
6.1%
유 3
 
6.1%
동 3
 
6.1%
적 3
 
6.1%
로 2
 
4.1%
실 2
 
4.1%
장 2
 
4.1%
Other values (13) 16
32.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 40
81.6%
Space Separator 7
 
14.3%
Decimal Number 2
 
4.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 4
 
10.0%
업 4
 
10.0%
일 3
 
7.5%
유 3
 
7.5%
동 3
 
7.5%
적 3
 
7.5%
로 2
 
5.0%
실 2
 
5.0%
장 2
 
5.0%
화 2
 
5.0%
Other values (10) 12
30.0%
Decimal Number
ValueCountFrequency (%)
9 1
50.0%
1 1
50.0%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 40
81.6%
Common 9
 
18.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 4
 
10.0%
업 4
 
10.0%
일 3
 
7.5%
유 3
 
7.5%
동 3
 
7.5%
적 3
 
7.5%
로 2
 
5.0%
실 2
 
5.0%
장 2
 
5.0%
화 2
 
5.0%
Other values (10) 12
30.0%
Common
ValueCountFrequency (%)
7
77.8%
9 1
 
11.1%
1 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 40
81.6%
ASCII 9
 
18.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7
77.8%
9 1
 
11.1%
1 1
 
11.1%
Hangul
ValueCountFrequency (%)
영 4
 
10.0%
업 4
 
10.0%
일 3
 
7.5%
유 3
 
7.5%
동 3
 
7.5%
적 3
 
7.5%
로 2
 
5.0%
실 2
 
5.0%
장 2
 
5.0%
화 2
 
5.0%
Other values (10) 12
30.0%

Interactions

2023-12-13T00:35:42.327186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:41.572378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:41.985559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:42.487255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:41.723012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:42.096747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:42.606753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:41.858180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:42.196924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:35:46.318374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분위치상세위치위도경도비고
순번1.0000.0000.9650.9260.8640.8740.000
구분0.0001.0000.0000.5560.0000.0000.848
위치0.9650.0001.0000.9790.9610.9530.718
상세위치0.9260.5560.9791.0000.8850.8180.569
위도0.8640.0000.9610.8851.0000.8060.629
경도0.8740.0000.9530.8180.8061.0000.897
비고0.0000.8480.7180.5690.6290.8971.000
2023-12-13T00:35:46.421338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위치구분
위치1.0000.000
구분0.0001.000
2023-12-13T00:35:46.502733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위도경도구분위치
순번1.0000.385-0.3850.0000.709
위도0.3851.000-0.3350.0000.705
경도-0.385-0.3351.0000.0000.676
구분0.0000.0000.0001.0000.000
위치0.7090.7050.6760.0001.000

Missing values

2023-12-13T00:35:42.769522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:35:42.944004image/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

순번구분위치상세위치위도경도비고
01쓰레기통올림픽홀(뮤즈라이브)1-3게이트 앞37.51478127.12699<NA>
12쓰레기통올림픽홀(뮤즈라이브)1-1게이트 앞37.515061127.127135<NA>
23쓰레기통올림픽홀(뮤즈라이브)ticket box근처37.515388127.127135<NA>
34자판기올림픽홀(뮤즈라이브)ticket box 근처37.515388127.127135<NA>
45쓰레기통올림픽테니스장실외 테니스장37.514703127.128413<NA>
56화장실실내테니스장실내 테니스장 근처37.514078127.127641<NA>
67쓰레기통장미광장광장 근처37.513304127.127759<NA>
78쓰레기통장미광장광장 입구 근처37.512894127.128181<NA>
89쓰레기통장미광장광장 근처37.512786127.127032<NA>
910자판기장미광장광장 근처37.512786127.127032<NA>
순번구분위치상세위치위도경도비고
151152쓰레기통평화의 광장sports 360 부근37.518016127.115814<NA>
152153쓰레기통평화의 광장sports 360 부근37.518188127.116518<NA>
153154간이편의점평화의 광장sports 360 부근37.51812127.117022<NA>
154155쓰레기통평화의 광장career center 뒤37.519346127.116311<NA>
155156화장실평화의 광장career center 뒤37.519223127.11603<NA>
156157쓰레기통평화의 광장놀이터 맞은편37.519532127.116395<NA>
157158자판기몽촌해자놀이터 맞은편37.519532127.116395<NA>
158159음수대몽촌해자체육진흥공단 본사 부근37.520037127.116557<NA>
159160쓰레기통몽촌해자-37.519813127.116671<NA>
160161쓰레기통들꽃마루-37.512972127.126723<NA>