Overview

Dataset statistics

Number of variables8
Number of observations41
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory70.1 B

Variable types

Numeric2
Categorical4
Text1
DateTime1

Dataset

Description서울특별시 광진구 관내의 옐로우 카펫 설치 현황에 대한 데이터를 제공합니다. 시설명, 시설주소, 세부위치 등의 내용을 포함합니다.
Author서울특별시 광진구
URLhttps://www.data.go.kr/data/15034275/fileData.do

Alerts

수량 has constant value ""Constant
관리기관 has constant value ""Constant
전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 설치년도 and 1 other fieldsHigh correlation
설치년도 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
설치학교명 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-15 02:31:24.600356
Analysis finished2024-03-15 02:31:26.270465
Duration1.67 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21
Minimum1
Maximum41
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size497.0 B
2024-03-15T11:31:26.479069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q111
median21
Q331
95-th percentile39
Maximum41
Range40
Interquartile range (IQR)20

Descriptive statistics

Standard deviation11.979149
Coefficient of variation (CV)0.57043565
Kurtosis-1.2
Mean21
Median Absolute Deviation (MAD)10
Skewness0
Sum861
Variance143.5
MonotonicityStrictly increasing
2024-03-15T11:31:26.796629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
1 1
 
2.4%
32 1
 
2.4%
24 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
Other values (31) 31
75.6%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%
32 1
2.4%

설치학교명
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)41.5%
Missing0
Missing (%)0.0%
Memory size456.0 B
구남초등학교
10 
동의초등학교
6 
광장초등학교
4 
성동초등학교
4 
양진초등학교
3 
Other values (12)
14 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique10 ?
Unique (%)24.4%

Sample

1st row구남초등학교
2nd row광진초등학교
3rd row광장초등학교
4th row광장초등학교
5th row광장초등학교

Common Values

ValueCountFrequency (%)
구남초등학교 10
24.4%
동의초등학교 6
14.6%
광장초등학교 4
 
9.8%
성동초등학교 4
 
9.8%
양진초등학교 3
 
7.3%
광남초등학교 2
 
4.9%
용곡초등학교 2
 
4.9%
자양초등학교 1
 
2.4%
성자초등학교 1
 
2.4%
신자초등학교 1
 
2.4%
Other values (7) 7
17.1%

Length

2024-03-15T11:31:27.099129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
구남초등학교 10
24.4%
동의초등학교 6
14.6%
광장초등학교 4
 
9.8%
성동초등학교 4
 
9.8%
양진초등학교 3
 
7.3%
광남초등학교 2
 
4.9%
용곡초등학교 2
 
4.9%
경복초등학교 1
 
2.4%
세종초등학교 1
 
2.4%
동자초등학교 1
 
2.4%
Other values (7) 7
17.1%

도로명 주소
Text

Distinct26
Distinct (%)63.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
2024-03-15T11:31:27.850985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length20
Mean length17.926829
Min length15

Characters and Unicode

Total characters735
Distinct characters47
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

Unique21 ?
Unique (%)51.2%

Sample

1st row서울특별시 광진구 구의강변로 69
2nd row서울특별시 광진구 자양로40길 41
3rd row서울특별시 광진구 광장로 45
4th row서울특별시 광진구 광장로1길 1
5th row서울특별시 광진구 광장로3길 2
ValueCountFrequency (%)
서울특별시 41
25.0%
광진구 41
25.0%
구의강변로 10
 
6.1%
69 10
 
6.1%
워커힐로 3
 
1.8%
32 3
 
1.8%
자양로4길 3
 
1.8%
63 3
 
1.8%
군자로 2
 
1.2%
구의동 2
 
1.2%
Other values (39) 46
28.0%
2024-03-15T11:31:29.068444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
123
16.7%
구 53
 
7.2%
광 45
 
6.1%
서 41
 
5.6%
특 41
 
5.6%
별 41
 
5.6%
시 41
 
5.6%
진 41
 
5.6%
울 41
 
5.6%
로 39
 
5.3%
Other values (37) 229
31.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 500
68.0%
Space Separator 123
 
16.7%
Decimal Number 111
 
15.1%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 53
10.6%
광 45
9.0%
서 41
8.2%
특 41
8.2%
별 41
8.2%
시 41
8.2%
진 41
8.2%
울 41
8.2%
로 39
 
7.8%
길 16
 
3.2%
Other values (25) 101
20.2%
Decimal Number
ValueCountFrequency (%)
6 26
23.4%
4 18
16.2%
1 16
14.4%
3 13
11.7%
9 10
 
9.0%
5 9
 
8.1%
2 7
 
6.3%
7 6
 
5.4%
0 5
 
4.5%
8 1
 
0.9%
Space Separator
ValueCountFrequency (%)
123
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 500
68.0%
Common 235
32.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 53
10.6%
광 45
9.0%
서 41
8.2%
특 41
8.2%
별 41
8.2%
시 41
8.2%
진 41
8.2%
울 41
8.2%
로 39
 
7.8%
길 16
 
3.2%
Other values (25) 101
20.2%
Common
ValueCountFrequency (%)
123
52.3%
6 26
 
11.1%
4 18
 
7.7%
1 16
 
6.8%
3 13
 
5.5%
9 10
 
4.3%
5 9
 
3.8%
2 7
 
3.0%
7 6
 
2.6%
0 5
 
2.1%
Other values (2) 2
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 500
68.0%
ASCII 235
32.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
123
52.3%
6 26
 
11.1%
4 18
 
7.7%
1 16
 
6.8%
3 13
 
5.5%
9 10
 
4.3%
5 9
 
3.8%
2 7
 
3.0%
7 6
 
2.6%
0 5
 
2.1%
Other values (2) 2
 
0.9%
Hangul
ValueCountFrequency (%)
구 53
10.6%
광 45
9.0%
서 41
8.2%
특 41
8.2%
별 41
8.2%
시 41
8.2%
진 41
8.2%
울 41
8.2%
로 39
 
7.8%
길 16
 
3.2%
Other values (25) 101
20.2%

설치년도
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)14.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2018.4146
Minimum2016
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size497.0 B
2024-03-15T11:31:29.368599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2016
5-th percentile2016
Q12017
median2019
Q32019
95-th percentile2022
Maximum2022
Range6
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.7885135
Coefficient of variation (CV)0.00088609816
Kurtosis-0.23322921
Mean2018.4146
Median Absolute Deviation (MAD)2
Skewness0.62899144
Sum82755
Variance3.1987805
MonotonicityNot monotonic
2024-03-15T11:31:29.559571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2019 15
36.6%
2017 12
29.3%
2016 5
 
12.2%
2022 5
 
12.2%
2018 2
 
4.9%
2020 2
 
4.9%
ValueCountFrequency (%)
2016 5
 
12.2%
2017 12
29.3%
2018 2
 
4.9%
2019 15
36.6%
2020 2
 
4.9%
2022 5
 
12.2%
ValueCountFrequency (%)
2022 5
 
12.2%
2020 2
 
4.9%
2019 15
36.6%
2018 2
 
4.9%
2017 12
29.3%
2016 5
 
12.2%

수량
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
1
41 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 41
100.0%

Length

2024-03-15T11:31:29.905141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:31:30.215933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 41
100.0%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
서울특별시 광진구청 교통행정과
41 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 광진구청 교통행정과
2nd row서울특별시 광진구청 교통행정과
3rd row서울특별시 광진구청 교통행정과
4th row서울특별시 광진구청 교통행정과
5th row서울특별시 광진구청 교통행정과

Common Values

ValueCountFrequency (%)
서울특별시 광진구청 교통행정과 41
100.0%

Length

2024-03-15T11:31:30.543252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:31:30.862913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 41
33.3%
광진구청 41
33.3%
교통행정과 41
33.3%

전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
02-450-7928
41 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-450-7928
2nd row02-450-7928
3rd row02-450-7928
4th row02-450-7928
5th row02-450-7928

Common Values

ValueCountFrequency (%)
02-450-7928 41
100.0%

Length

2024-03-15T11:31:31.203045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:31:31.576535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-450-7928 41
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
Minimum2024-01-02 00:00:00
Maximum2024-01-02 00:00:00
2024-03-15T11:31:31.852989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T11:31:32.059487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T11:31:25.422078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T11:31:24.909360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T11:31:25.606319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T11:31:25.258563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T11:31:32.274886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설치학교명도로명 주소설치년도
연번1.0000.8510.8740.967
설치학교명0.8511.0001.0000.911
도로명 주소0.8741.0001.0000.926
설치년도0.9670.9110.9261.000
2024-03-15T11:31:32.529690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설치년도설치학교명
연번1.0000.7870.502
설치년도0.7871.0000.634
설치학교명0.5020.6341.000

Missing values

2024-03-15T11:31:25.818646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T11:31:26.110997image/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구남초등학교서울특별시 광진구 구의강변로 6920161서울특별시 광진구청 교통행정과02-450-79282024-01-02
12광진초등학교서울특별시 광진구 자양로40길 4120191서울특별시 광진구청 교통행정과02-450-79282024-01-02
23광장초등학교서울특별시 광진구 광장로 4520161서울특별시 광진구청 교통행정과02-450-79282024-01-02
34광장초등학교서울특별시 광진구 광장로1길 120161서울특별시 광진구청 교통행정과02-450-79282024-01-02
45광장초등학교서울특별시 광진구 광장로3길 220161서울특별시 광진구청 교통행정과02-450-79282024-01-02
56광장초등학교서울특별시 광진구 광장로 5620161서울특별시 광진구청 교통행정과02-450-79282024-01-02
67성자초등학교서울특별시 광진구 뚝섬로56길 720171서울특별시 광진구청 교통행정과02-450-79282024-01-02
78양남초등학교서울특별시 광진구 뚝섬로64길 7120171서울특별시 광진구청 교통행정과02-450-79282024-01-02
89신양초등학교서울특별시 광진구 능동로 4220171서울특별시 광진구청 교통행정과02-450-79282024-01-02
910동자초등학교서울특별시 광진구 뚝섬로 56120171서울특별시 광진구청 교통행정과02-450-79282024-01-02
연번설치학교명도로명 주소설치년도수량관리기관전화번호데이터기준일자
3132광남초등학교서울특별시 광진구 아차산로70길 3520191서울특별시 광진구청 교통행정과02-450-79282024-01-02
3233신자초등학교서울특별시 광진구 뚝섬로46길 6420191서울특별시 광진구청 교통행정과02-450-79282024-01-02
3334양진초등학교서울특별시 광진구 워커힐로 3220201서울특별시 광진구청 교통행정과02-450-79282024-01-02
3435양진초등학교서울특별시 광진구 워커힐로 3220201서울특별시 광진구청 교통행정과02-450-79282024-01-02
3536성동초등학교서울특별시 광진구 뚝섬로66길 420171서울특별시 광진구청 교통행정과02-450-79282024-01-02
3637성동초등학교서울특별시 광진구 자양로4길 6320221서울특별시 광진구청 교통행정과02-450-79282024-01-02
3738성동초등학교서울특별시 광진구 자양로4길 6320221서울특별시 광진구청 교통행정과02-450-79282024-01-02
3839성동초등학교서울특별시 광진구 자양로4길 6320221서울특별시 광진구청 교통행정과02-450-79282024-01-02
3940용곡초등학교서울특별시 광진구 용마산로 16320221서울특별시 광진구청 교통행정과02-450-79282024-01-02
4041용곡초등학교서울특별시 광진구 용마산로 17420221서울특별시 광진구청 교통행정과02-450-79282024-01-02