Overview

Dataset statistics

Number of variables9
Number of observations168
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.4 KiB
Average record size in memory75.8 B

Variable types

Numeric3
Text2
Categorical4

Dataset

Description서울특별시 강북구 관내에 설치된 제설함 현황 정보(도로명 주소 위치정보, 위치공간정보, 평면 X, Y 좌표, 관리기관 등) 입니다
URLhttps://www.data.go.kr/data/3079445/fileData.do

Alerts

규격 has constant value ""Constant
관리기관 has constant value ""Constant
전화번호 has constant value ""Constant
데이터기준일 has constant value ""Constant
연번 is highly overall correlated with 위치공간정보(평면X좌표)High correlation
위치공간정보(평면X좌표) is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
관리번호 has unique valuesUnique
위치공간정보(평면X좌표) has unique valuesUnique

Reproduction

Analysis started2023-12-12 13:49:34.666877
Analysis finished2023-12-12 13:49:36.499272
Duration1.83 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct168
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean84.5
Minimum1
Maximum168
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-12T22:49:36.608288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.35
Q142.75
median84.5
Q3126.25
95-th percentile159.65
Maximum168
Range167
Interquartile range (IQR)83.5

Descriptive statistics

Standard deviation48.641546
Coefficient of variation (CV)0.5756396
Kurtosis-1.2
Mean84.5
Median Absolute Deviation (MAD)42
Skewness0
Sum14196
Variance2366
MonotonicityStrictly increasing
2023-12-12T22:49:36.758393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
117 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
116 1
 
0.6%
Other values (158) 158
94.0%
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 (%)
168 1
0.6%
167 1
0.6%
166 1
0.6%
165 1
0.6%
164 1
0.6%
163 1
0.6%
162 1
0.6%
161 1
0.6%
160 1
0.6%
159 1
0.6%

관리번호
Text

UNIQUE 

Distinct168
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T22:49:37.149647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

Total characters1008
Distinct characters13
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

Unique168 ?
Unique (%)100.0%

Sample

1st row강북-001
2nd row강북-002
3rd row강북-003
4th row강북-004
5th row강북-005
ValueCountFrequency (%)
강북-001 1
 
0.6%
강북-115 1
 
0.6%
강북-125 1
 
0.6%
강북-108 1
 
0.6%
강북-109 1
 
0.6%
강북-110 1
 
0.6%
강북-111 1
 
0.6%
강북-112 1
 
0.6%
강북-113 1
 
0.6%
강북-114 1
 
0.6%
Other values (158) 158
94.0%
2023-12-12T22:49:37.656436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
강 168
16.7%
북 168
16.7%
- 168
16.7%
0 134
13.3%
1 106
10.5%
2 37
 
3.7%
3 37
 
3.7%
4 37
 
3.7%
5 37
 
3.7%
6 36
 
3.6%
Other values (3) 80
7.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 504
50.0%
Other Letter 336
33.3%
Dash Punctuation 168
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 134
26.6%
1 106
21.0%
2 37
 
7.3%
3 37
 
7.3%
4 37
 
7.3%
5 37
 
7.3%
6 36
 
7.1%
7 27
 
5.4%
8 27
 
5.4%
9 26
 
5.2%
Other Letter
ValueCountFrequency (%)
강 168
50.0%
북 168
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 168
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 672
66.7%
Hangul 336
33.3%

Most frequent character per script

Common
ValueCountFrequency (%)
- 168
25.0%
0 134
19.9%
1 106
15.8%
2 37
 
5.5%
3 37
 
5.5%
4 37
 
5.5%
5 37
 
5.5%
6 36
 
5.4%
7 27
 
4.0%
8 27
 
4.0%
Hangul
ValueCountFrequency (%)
강 168
50.0%
북 168
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 672
66.7%
Hangul 336
33.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
강 168
50.0%
북 168
50.0%
ASCII
ValueCountFrequency (%)
- 168
25.0%
0 134
19.9%
1 106
15.8%
2 37
 
5.5%
3 37
 
5.5%
4 37
 
5.5%
5 37
 
5.5%
6 36
 
5.4%
7 27
 
4.0%
8 27
 
4.0%

규격
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
1200*700*800
168 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1200*700*800
2nd row1200*700*800
3rd row1200*700*800
4th row1200*700*800
5th row1200*700*800

Common Values

ValueCountFrequency (%)
1200*700*800 168
100.0%

Length

2023-12-12T22:49:37.825588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:49:37.976100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1200*700*800 168
100.0%

도로명 주소
Text

Distinct162
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T22:49:38.312615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length22
Mean length18.291667
Min length15

Characters and Unicode

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

Unique

Unique156 ?
Unique (%)92.9%

Sample

1st row서울특별시 강북구 인수봉로 102
2nd row서울특별시 강북구 인수봉로 116
3rd row서울특별시 강북구 인수봉로 124
4th row서울특별시 강북구 덕릉로 1
5th row서울특별시 강북구 삼각산로 76
ValueCountFrequency (%)
서울특별시 168
24.9%
강북구 168
24.9%
도봉로 23
 
3.4%
인수봉로 19
 
2.8%
삼양로 18
 
2.7%
오현로 13
 
1.9%
월계로 10
 
1.5%
솔샘로 10
 
1.5%
삼양로19길 8
 
1.2%
40 5
 
0.7%
Other values (169) 233
34.5%
2023-12-12T22:49:38.884689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
557
18.1%
서 168
 
5.5%
울 168
 
5.5%
북 168
 
5.5%
강 168
 
5.5%
구 168
 
5.5%
시 168
 
5.5%
별 168
 
5.5%
특 168
 
5.5%
로 166
 
5.4%
Other values (40) 1006
32.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1935
63.0%
Decimal Number 567
 
18.5%
Space Separator 557
 
18.1%
Dash Punctuation 9
 
0.3%
Other Punctuation 5
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 168
8.7%
울 168
8.7%
북 168
8.7%
강 168
8.7%
구 168
8.7%
시 168
8.7%
별 168
8.7%
특 168
8.7%
로 166
8.6%
길 54
 
2.8%
Other values (27) 371
19.2%
Decimal Number
ValueCountFrequency (%)
1 124
21.9%
2 77
13.6%
3 70
12.3%
5 56
9.9%
9 54
9.5%
4 52
9.2%
7 42
 
7.4%
0 35
 
6.2%
8 29
 
5.1%
6 28
 
4.9%
Space Separator
ValueCountFrequency (%)
557
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Punctuation
ValueCountFrequency (%)
. 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1935
63.0%
Common 1138
37.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 168
8.7%
울 168
8.7%
북 168
8.7%
강 168
8.7%
구 168
8.7%
시 168
8.7%
별 168
8.7%
특 168
8.7%
로 166
8.6%
길 54
 
2.8%
Other values (27) 371
19.2%
Common
ValueCountFrequency (%)
557
48.9%
1 124
 
10.9%
2 77
 
6.8%
3 70
 
6.2%
5 56
 
4.9%
9 54
 
4.7%
4 52
 
4.6%
7 42
 
3.7%
0 35
 
3.1%
8 29
 
2.5%
Other values (3) 42
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1935
63.0%
ASCII 1138
37.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
557
48.9%
1 124
 
10.9%
2 77
 
6.8%
3 70
 
6.2%
5 56
 
4.9%
9 54
 
4.7%
4 52
 
4.6%
7 42
 
3.7%
0 35
 
3.1%
8 29
 
2.5%
Other values (3) 42
 
3.7%
Hangul
ValueCountFrequency (%)
서 168
8.7%
울 168
8.7%
북 168
8.7%
강 168
8.7%
구 168
8.7%
시 168
8.7%
별 168
8.7%
특 168
8.7%
로 166
8.6%
길 54
 
2.8%
Other values (27) 371
19.2%

위치공간정보(평면X좌표)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct168
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201951.78
Minimum200044.12
Maximum204342.22
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-12T22:49:39.079286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum200044.12
5-th percentile200683.99
Q1201141
median201838.82
Q3202656.99
95-th percentile203530.04
Maximum204342.22
Range4298.1
Interquartile range (IQR)1515.9875

Descriptive statistics

Standard deviation964.12137
Coefficient of variation (CV)0.0047740176
Kurtosis-0.73129905
Mean201951.78
Median Absolute Deviation (MAD)740.07
Skewness0.39652337
Sum33927899
Variance929530.01
MonotonicityNot monotonic
2023-12-12T22:49:39.255644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
201143.81 1
 
0.6%
200481.94 1
 
0.6%
201633.53 1
 
0.6%
201592.21 1
 
0.6%
201555.41 1
 
0.6%
201498.82 1
 
0.6%
201262.37 1
 
0.6%
201063.01 1
 
0.6%
201178.44 1
 
0.6%
200514.32 1
 
0.6%
Other values (158) 158
94.0%
ValueCountFrequency (%)
200044.12 1
0.6%
200217.51 1
0.6%
200390.41 1
0.6%
200481.94 1
0.6%
200514.32 1
0.6%
200539.16 1
0.6%
200549.4 1
0.6%
200592.09 1
0.6%
200679.27 1
0.6%
200692.77 1
0.6%
ValueCountFrequency (%)
204342.22 1
0.6%
204192.45 1
0.6%
204100.09 1
0.6%
204092.82 1
0.6%
203958.91 1
0.6%
203957.2 1
0.6%
203883.11 1
0.6%
203572.67 1
0.6%
203535.65 1
0.6%
203519.63 1
0.6%

위치공간정보(평면Y좌표)
Real number (ℝ)

Distinct167
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean458980.78
Minimum456654.56
Maximum463743.95
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-12T22:49:39.420852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum456654.56
5-th percentile457133.87
Q1457790.47
median458722.73
Q3459797.08
95-th percentile462211.09
Maximum463743.95
Range7089.39
Interquartile range (IQR)2006.6075

Descriptive statistics

Standard deviation1474.4416
Coefficient of variation (CV)0.0032124256
Kurtosis1.0929297
Mean458980.78
Median Absolute Deviation (MAD)972.335
Skewness1.0350526
Sum77108771
Variance2173978.1
MonotonicityNot monotonic
2023-12-12T22:49:39.604436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
459366.43 2
 
1.2%
458798.44 1
 
0.6%
463312.25 1
 
0.6%
458875.94 1
 
0.6%
459384.57 1
 
0.6%
460154.97 1
 
0.6%
460986.5 1
 
0.6%
462757.15 1
 
0.6%
462466.42 1
 
0.6%
463656.47 1
 
0.6%
Other values (157) 157
93.5%
ValueCountFrequency (%)
456654.56 1
0.6%
456823.83 1
0.6%
456916.68 1
0.6%
456987.97 1
0.6%
456995.26 1
0.6%
457012.46 1
0.6%
457085.72 1
0.6%
457123.15 1
0.6%
457127.5 1
0.6%
457145.7 1
0.6%
ValueCountFrequency (%)
463743.95 1
0.6%
463656.47 1
0.6%
463312.25 1
0.6%
463188.57 1
0.6%
462757.15 1
0.6%
462652.01 1
0.6%
462493.71 1
0.6%
462466.42 1
0.6%
462367.54 1
0.6%
461920.54 1
0.6%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
서울특별시 강북구청 (도로관리과)
168 

Length

Max length18
Median length18
Mean length18
Min length18

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 강북구청 (도로관리과)
2nd row서울특별시 강북구청 (도로관리과)
3rd row서울특별시 강북구청 (도로관리과)
4th row서울특별시 강북구청 (도로관리과)
5th row서울특별시 강북구청 (도로관리과)

Common Values

ValueCountFrequency (%)
서울특별시 강북구청 (도로관리과) 168
100.0%

Length

2023-12-12T22:49:39.742461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:49:39.843842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 168
33.3%
강북구청 168
33.3%
도로관리과 168
33.3%

전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
02-901-5853
168 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-901-5853
2nd row02-901-5853
3rd row02-901-5853
4th row02-901-5853
5th row02-901-5853

Common Values

ValueCountFrequency (%)
02-901-5853 168
100.0%

Length

2023-12-12T22:49:39.950144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:49:40.062386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-901-5853 168
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-05-26
168 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-05-26
2nd row2023-05-26
3rd row2023-05-26
4th row2023-05-26
5th row2023-05-26

Common Values

ValueCountFrequency (%)
2023-05-26 168
100.0%

Length

2023-12-12T22:49:40.160369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:49:40.249671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-05-26 168
100.0%

Interactions

2023-12-12T22:49:35.789350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:34.834644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:35.122974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:35.933397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:34.939416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:35.564959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:36.044186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:35.025844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:35.674414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:49:40.325719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위치공간정보(평면X좌표)위치공간정보(평면Y좌표)
연번1.0000.7920.653
위치공간정보(평면X좌표)0.7921.0000.699
위치공간정보(평면Y좌표)0.6530.6991.000
2023-12-12T22:49:40.446912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위치공간정보(평면X좌표)위치공간정보(평면Y좌표)
연번1.0000.526-0.086
위치공간정보(평면X좌표)0.5261.000-0.468
위치공간정보(평면Y좌표)-0.086-0.4681.000

Missing values

2023-12-12T22:49:36.186341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:49:36.395561image/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

연번관리번호규격도로명 주소위치공간정보(평면X좌표)위치공간정보(평면Y좌표)관리기관전화번호데이터기준일
01강북-0011200*700*800서울특별시 강북구 인수봉로 102201143.81458798.44서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
12강북-0021200*700*800서울특별시 강북구 인수봉로 116201192.57458946.3서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
23강북-0031200*700*800서울특별시 강북구 인수봉로 124201219.52459366.43서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
34강북-0041200*700*800서울특별시 강북구 덕릉로 1201205.66459366.43서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
45강북-0051200*700*800서울특별시 강북구 삼각산로 76201101.66460036.74서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
56강북-0061200*700*800서울특별시 강북구 4.19로 47200802.18460818.85서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
67강북-0071200*700*800서울특별시 강북구 4.19로 82200539.16460656.51서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
78강북-0081200*700*800서울특별시 강북구 4.19로 97200390.41460528.74서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
89강북-0091200*700*800서울특별시 강북구 4.19로 123200217.51460294.03서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
910강북-0101200*700*800서울특별시 강북구 4.19로 35200905.2460840.79서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
연번관리번호규격도로명 주소위치공간정보(평면X좌표)위치공간정보(평면Y좌표)관리기관전화번호데이터기준일
158159강북-1591200*700*800서울특별시 강북구 오현로 32202981.76457427.63서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
159160강북-1601200*700*800서울특별시 강북구 오현로 117203319.98458105.2서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
160161강북-1611200*700*800서울특별시 강북구 오현로 156203256.16458530.29서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
161162강북-1621200*700*800서울특별시 강북구 오현로 186203440.73458740.58서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
162163강북-1631200*700*800서울특별시 강북구 오현로 194203519.63458818.23서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
163164강북-1641200*700*800서울특별시 강북구 오현로 189203467.51458792.68서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
164165강북-1651200*700*800서울특별시 강북구 오현로 175203349.03458674.62서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
165166강북-1661200*700*800서울특별시 강북구 오현로 163203273.55458592.53서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
166167강북-1671200*700*800서울특별시 강북구 오현로 63203164.35457641.48서울특별시 강북구청 (도로관리과)02-901-58532023-05-26
167168강북-1681200*700*800서울특별시 강북구 오현로 31202975.19457449.13서울특별시 강북구청 (도로관리과)02-901-58532023-05-26