Overview

Dataset statistics

Number of variables7
Number of observations46
Missing cells1
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory60.9 B

Variable types

Numeric2
Text3
Categorical2

Dataset

Description경기도 성남시 험프형 횡단보도 설치현황에 관한 데이터로 연번, 설치장소, 설치주소, 설치연도, 관리기관 전화번호, 데이터기준일 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15042520/fileData.do

Alerts

관리기관전화번호 has constant value ""Constant
데이터기준일 has constant value ""Constant
연번 is highly overall correlated with 설치연도High correlation
설치연도 is highly overall correlated with 연번High correlation
설치도로명주소 has 1 (2.2%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:21:51.116733
Analysis finished2023-12-12 06:21:52.214521
Duration1.1 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct46
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.5
Minimum1
Maximum46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2023-12-12T15:21:52.316298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.25
Q112.25
median23.5
Q334.75
95-th percentile43.75
Maximum46
Range45
Interquartile range (IQR)22.5

Descriptive statistics

Standard deviation13.422618
Coefficient of variation (CV)0.57117522
Kurtosis-1.2
Mean23.5
Median Absolute Deviation (MAD)11.5
Skewness0
Sum1081
Variance180.16667
MonotonicityStrictly increasing
2023-12-12T15:21:52.486661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
1 1
 
2.2%
36 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
34 1
 
2.2%
Other values (36) 36
78.3%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
46 1
2.2%
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
Distinct42
Distinct (%)91.3%
Missing0
Missing (%)0.0%
Memory size500.0 B
2023-12-12T15:21:52.746722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length15
Mean length9.7173913
Min length5

Characters and Unicode

Total characters447
Distinct characters133
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

Unique39 ?
Unique (%)84.8%

Sample

1st row백현1교차로 앞
2nd row오리역광장에서 무지개숲길 앞
3rd row개나리교 앞
4th row탑어린이공원 앞(맛고을공영주차장)
5th row선지봉어린이공원 앞
ValueCountFrequency (%)
24
25.0%
사거리 4
 
4.2%
우리은행 3
 
3.1%
현대백화점 2
 
2.1%
동양정자파라곤 2
 
2.1%
선지봉어린이공원 2
 
2.1%
야탑사거리 2
 
2.1%
백현1교차로 1
 
1.0%
율동 1
 
1.0%
경로당 1
 
1.0%
Other values (54) 54
56.2%
2023-12-12T15:21:53.201667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
50
 
11.2%
32
 
7.2%
15
 
3.4%
14
 
3.1%
13
 
2.9%
8
 
1.8%
8
 
1.8%
1 7
 
1.6%
7
 
1.6%
7
 
1.6%
Other values (123) 286
64.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 354
79.2%
Space Separator 50
 
11.2%
Decimal Number 31
 
6.9%
Close Punctuation 4
 
0.9%
Open Punctuation 4
 
0.9%
Lowercase Letter 2
 
0.4%
Other Punctuation 1
 
0.2%
Math Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
32
 
9.0%
15
 
4.2%
14
 
4.0%
13
 
3.7%
8
 
2.3%
8
 
2.3%
7
 
2.0%
7
 
2.0%
7
 
2.0%
7
 
2.0%
Other values (109) 236
66.7%
Decimal Number
ValueCountFrequency (%)
1 7
22.6%
3 6
19.4%
5 5
16.1%
0 4
12.9%
2 4
12.9%
8 4
12.9%
6 1
 
3.2%
Lowercase Letter
ValueCountFrequency (%)
k 1
50.0%
a 1
50.0%
Space Separator
ValueCountFrequency (%)
50
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 354
79.2%
Common 91
 
20.4%
Latin 2
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
32
 
9.0%
15
 
4.2%
14
 
4.0%
13
 
3.7%
8
 
2.3%
8
 
2.3%
7
 
2.0%
7
 
2.0%
7
 
2.0%
7
 
2.0%
Other values (109) 236
66.7%
Common
ValueCountFrequency (%)
50
54.9%
1 7
 
7.7%
3 6
 
6.6%
5 5
 
5.5%
) 4
 
4.4%
0 4
 
4.4%
2 4
 
4.4%
8 4
 
4.4%
( 4
 
4.4%
, 1
 
1.1%
Other values (2) 2
 
2.2%
Latin
ValueCountFrequency (%)
k 1
50.0%
a 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 354
79.2%
ASCII 93
 
20.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
50
53.8%
1 7
 
7.5%
3 6
 
6.5%
5 5
 
5.4%
) 4
 
4.3%
0 4
 
4.3%
2 4
 
4.3%
8 4
 
4.3%
( 4
 
4.3%
k 1
 
1.1%
Other values (4) 4
 
4.3%
Hangul
ValueCountFrequency (%)
32
 
9.0%
15
 
4.2%
14
 
4.0%
13
 
3.7%
8
 
2.3%
8
 
2.3%
7
 
2.0%
7
 
2.0%
7
 
2.0%
7
 
2.0%
Other values (109) 236
66.7%

설치도로명주소
Text

MISSING 

Distinct43
Distinct (%)95.6%
Missing1
Missing (%)2.2%
Memory size500.0 B
2023-12-12T15:21:53.477876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length22
Mean length19.955556
Min length11

Characters and Unicode

Total characters898
Distinct characters71
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

Unique41 ?
Unique (%)91.1%

Sample

1st row경기도 성남시 분당구 백현로
2nd row경기도 성남시 분당구 구미로 9번길 16
3rd row경기도 성남시 분당구 판교역로192번길
4th row경기도 성남시 분당구 야탑로111번길
5th row경기도 성남시 분당구 선지봉로, 선지봉로16번길
ValueCountFrequency (%)
경기도 45
20.5%
성남시 45
20.5%
분당구 33
15.0%
수정구 7
 
3.2%
성남대로 5
 
2.3%
중원구 5
 
2.3%
정자일로 5
 
2.3%
야탑로 2
 
0.9%
산성대로 2
 
0.9%
양현로 2
 
0.9%
Other values (62) 69
31.4%
2023-12-12T15:21:53.844931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
176
19.6%
52
 
5.8%
51
 
5.7%
47
 
5.2%
46
 
5.1%
46
 
5.1%
45
 
5.0%
45
 
5.0%
45
 
5.0%
35
 
3.9%
Other values (61) 310
34.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 614
68.4%
Space Separator 176
 
19.6%
Decimal Number 107
 
11.9%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
52
 
8.5%
51
 
8.3%
47
 
7.7%
46
 
7.5%
46
 
7.5%
45
 
7.3%
45
 
7.3%
45
 
7.3%
35
 
5.7%
35
 
5.7%
Other values (49) 167
27.2%
Decimal Number
ValueCountFrequency (%)
1 24
22.4%
2 16
15.0%
0 13
12.1%
3 12
11.2%
4 12
11.2%
6 10
9.3%
9 6
 
5.6%
8 5
 
4.7%
5 5
 
4.7%
7 4
 
3.7%
Space Separator
ValueCountFrequency (%)
176
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 614
68.4%
Common 284
31.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
52
 
8.5%
51
 
8.3%
47
 
7.7%
46
 
7.5%
46
 
7.5%
45
 
7.3%
45
 
7.3%
45
 
7.3%
35
 
5.7%
35
 
5.7%
Other values (49) 167
27.2%
Common
ValueCountFrequency (%)
176
62.0%
1 24
 
8.5%
2 16
 
5.6%
0 13
 
4.6%
3 12
 
4.2%
4 12
 
4.2%
6 10
 
3.5%
9 6
 
2.1%
8 5
 
1.8%
5 5
 
1.8%
Other values (2) 5
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 614
68.4%
ASCII 284
31.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
176
62.0%
1 24
 
8.5%
2 16
 
5.6%
0 13
 
4.6%
3 12
 
4.2%
4 12
 
4.2%
6 10
 
3.5%
9 6
 
2.1%
8 5
 
1.8%
5 5
 
1.8%
Other values (2) 5
 
1.8%
Hangul
ValueCountFrequency (%)
52
 
8.5%
51
 
8.3%
47
 
7.7%
46
 
7.5%
46
 
7.5%
45
 
7.3%
45
 
7.3%
45
 
7.3%
35
 
5.7%
35
 
5.7%
Other values (49) 167
27.2%
Distinct44
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size500.0 B
2023-12-12T15:21:54.061918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length25
Mean length20.847826
Min length18

Characters and Unicode

Total characters959
Distinct characters59
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

Unique42 ?
Unique (%)91.3%

Sample

1st row경기도 성남시 분당구 백현동 472-11
2nd row경기도 성남시 분당구 구미동 197-9
3rd row경기도 성남시 분당구 삼평동 664-1
4th row경기도 성남시 분당구 야탑동 488-7
5th row경기도 성남시 분당구 분당동 179
ValueCountFrequency (%)
경기도 46
19.4%
성남시 46
19.4%
분당구 34
14.3%
수정구 8
 
3.4%
정자동 6
 
2.5%
서현동 5
 
2.1%
백현동 5
 
2.1%
야탑동 4
 
1.7%
중원구 4
 
1.7%
이매동 4
 
1.7%
Other values (61) 75
31.6%
2023-12-12T15:21:54.435385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
192
20.0%
47
 
4.9%
47
 
4.9%
46
 
4.8%
46
 
4.8%
46
 
4.8%
46
 
4.8%
46
 
4.8%
46
 
4.8%
1 38
 
4.0%
Other values (49) 359
37.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 579
60.4%
Space Separator 192
 
20.0%
Decimal Number 162
 
16.9%
Dash Punctuation 24
 
2.5%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
47
 
8.1%
47
 
8.1%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
36
 
6.2%
36
 
6.2%
Other values (35) 137
23.7%
Decimal Number
ValueCountFrequency (%)
1 38
23.5%
5 20
12.3%
3 16
9.9%
7 16
9.9%
2 16
9.9%
4 16
9.9%
8 12
 
7.4%
6 11
 
6.8%
9 10
 
6.2%
0 7
 
4.3%
Space Separator
ValueCountFrequency (%)
192
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 579
60.4%
Common 380
39.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
47
 
8.1%
47
 
8.1%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
36
 
6.2%
36
 
6.2%
Other values (35) 137
23.7%
Common
ValueCountFrequency (%)
192
50.5%
1 38
 
10.0%
- 24
 
6.3%
5 20
 
5.3%
3 16
 
4.2%
7 16
 
4.2%
2 16
 
4.2%
4 16
 
4.2%
8 12
 
3.2%
6 11
 
2.9%
Other values (4) 19
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 579
60.4%
ASCII 380
39.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
192
50.5%
1 38
 
10.0%
- 24
 
6.3%
5 20
 
5.3%
3 16
 
4.2%
7 16
 
4.2%
2 16
 
4.2%
4 16
 
4.2%
8 12
 
3.2%
6 11
 
2.9%
Other values (4) 19
 
5.0%
Hangul
ValueCountFrequency (%)
47
 
8.1%
47
 
8.1%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
46
 
7.9%
36
 
6.2%
36
 
6.2%
Other values (35) 137
23.7%

설치연도
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)15.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2020
Minimum2017
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size546.0 B
2023-12-12T15:21:54.544989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2017
5-th percentile2017
Q12018
median2020
Q32022
95-th percentile2023
Maximum2023
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation2.0330601
Coefficient of variation (CV)0.0010064654
Kurtosis-1.4183495
Mean2020
Median Absolute Deviation (MAD)2
Skewness0.14929173
Sum92920
Variance4.1333333
MonotonicityDecreasing
2023-12-12T15:21:54.672298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
2018 11
23.9%
2022 8
17.4%
2023 7
15.2%
2019 7
15.2%
2020 5
10.9%
2021 4
 
8.7%
2017 4
 
8.7%
ValueCountFrequency (%)
2017 4
 
8.7%
2018 11
23.9%
2019 7
15.2%
2020 5
10.9%
2021 4
 
8.7%
2022 8
17.4%
2023 7
15.2%
ValueCountFrequency (%)
2023 7
15.2%
2022 8
17.4%
2021 4
 
8.7%
2020 5
10.9%
2019 7
15.2%
2018 11
23.9%
2017 4
 
8.7%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
031-729-3673
46 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-729-3673
2nd row031-729-3673
3rd row031-729-3673
4th row031-729-3673
5th row031-729-3673

Common Values

ValueCountFrequency (%)
031-729-3673 46
100.0%

Length

2023-12-12T15:21:54.814583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:21:54.920615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-729-3673 46
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size500.0 B
2023-06-23
46 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023-06-23 46
100.0%

Length

2023-12-12T15:21:55.379289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:21:55.526773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-23 46
100.0%

Interactions

2023-12-12T15:21:51.758092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:21:51.528863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:21:51.852916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:21:51.627234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:21:55.620113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설치장소설치도로명주소설치지번주소설치연도
연번1.0000.9361.0000.9660.925
설치장소0.9361.0000.9550.9931.000
설치도로명주소1.0000.9551.0000.9980.905
설치지번주소0.9660.9930.9981.0001.000
설치연도0.9251.0000.9051.0001.000
2023-12-12T15:21:55.757579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설치연도
연번1.000-0.986
설치연도-0.9861.000

Missing values

2023-12-12T15:21:52.004123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:21:52.146042image/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교차로 앞경기도 성남시 분당구 백현로경기도 성남시 분당구 백현동 472-112023031-729-36732023-06-23
12오리역광장에서 무지개숲길 앞경기도 성남시 분당구 구미로 9번길 16경기도 성남시 분당구 구미동 197-92023031-729-36732023-06-23
23개나리교 앞경기도 성남시 분당구 판교역로192번길경기도 성남시 분당구 삼평동 664-12023031-729-36732023-06-23
34탑어린이공원 앞(맛고을공영주차장)경기도 성남시 분당구 야탑로111번길경기도 성남시 분당구 야탑동 488-72023031-729-36732023-06-23
45선지봉어린이공원 앞경기도 성남시 분당구 선지봉로, 선지봉로16번길경기도 성남시 분당구 분당동 1792023031-729-36732023-06-23
56선지봉어린이공원 앞경기도 성남시 분당구 선지봉로16번길경기도 성남시 분당구 분당동 1792023031-729-36732023-06-23
67현대백화점 건너편경기도 성남시 분당구 분당내곡간고속화도로경기도 성남시 분당구 백현동 541-1(백현동 542 앞)2023031-729-36732023-06-23
78현대백화점 앞경기도 성남시 분당구 분당내곡간고속화도로경기도 성남시 분당구 백현동 541-12022031-729-36732023-06-23
89상탑초등학교(야탑5교앞)경기도 성남시 분당구 야탑로 야탑5교 앞경기도 성남시 분당구 야탑동 197-22022031-729-36732023-06-23
910서당초등학교(우리은행앞,삼환종합상가 앞)경기도 성남시 분당구 돌마로 476번길경기도 성남시 분당구 서현동 353-32022031-729-36732023-06-23
연번설치장소설치도로명주소설치지번주소설치연도관리기관전화번호데이터기준일
3637수진역 사거리경기도 성남시 중원구 산성대로 200경기도 성남시 수정구 수진동 2205-12018031-729-36732023-06-23
3738야탑사거리경기도 성남시 중원구 양현로 413 앞경기도 성남시 중원구 여수동 1882018031-729-36732023-06-23
3839야탑사거리경기도 성남시 중원구 성남대로 1000경기도 성남시 중원구 여수동 6002018031-729-36732023-06-23
3940우리은행 사거리경기도 성남시 수정구 성남대로 311경기도 성남시 수정구 신흥동 24722018031-729-36732023-06-23
4041우리은행 사거리경기도 성남시 수정구 성남대로 321경기도 성남시 수정구 신흥동 2465-52018031-729-36732023-06-23
4142우리은행 사거리경기도 성남시 중원구 성남대로 322경기도 성남시 중원구 중앙동 3642018031-729-36732023-06-23
4243영진교회 앞경기도 성남시 분당구 양현로 94경기도 성남시 분당구 이매동 129-22017031-729-36732023-06-23
4344운중동 888경기도 성남시 분당구 산운로 32번길 1경기도 성남시 분당구 운중동 8882017031-729-36732023-06-23
4445동양정자파라곤 105동경기도 성남시 분당구 정자일로 230경기도 성남시 분당구 정자동 13-12017031-729-36732023-06-23
4546동양정자파라곤 106동경기도 성남시 분당구 정자일로 230경기도 성남시 분당구 정자동 13-12017031-729-36732023-06-23