Overview

Dataset statistics

Number of variables5
Number of observations361
Missing cells21
Missing cells (%)1.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.9 KiB
Average record size in memory42.4 B

Variable types

Numeric2
Text2
Categorical1

Dataset

Description미추홀구 가로등제어함현황에 대한 데이터로 제어함명칭,설치위치,가로등주 수량,등기구 수량 등의 항목을 제공합니다.
Author인천광역시 미추홀구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15060169&srcSe=7661IVAWM27C61E190

Alerts

설치위치 has 21 (5.8%) missing valuesMissing
연번 has unique valuesUnique
제어함명 has unique valuesUnique

Reproduction

Analysis started2024-03-13 06:13:25.523038
Analysis finished2024-03-13 06:13:26.352155
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct361
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean181
Minimum1
Maximum361
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2024-03-13T15:13:26.458757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile19
Q191
median181
Q3271
95-th percentile343
Maximum361
Range360
Interquartile range (IQR)180

Descriptive statistics

Standard deviation104.35596
Coefficient of variation (CV)0.57655227
Kurtosis-1.2
Mean181
Median Absolute Deviation (MAD)90
Skewness0
Sum65341
Variance10890.167
MonotonicityStrictly increasing
2024-03-13T15:13:26.643323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
249 1
 
0.3%
247 1
 
0.3%
246 1
 
0.3%
245 1
 
0.3%
244 1
 
0.3%
243 1
 
0.3%
242 1
 
0.3%
241 1
 
0.3%
240 1
 
0.3%
Other values (351) 351
97.2%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
361 1
0.3%
360 1
0.3%
359 1
0.3%
358 1
0.3%
357 1
0.3%
356 1
0.3%
355 1
0.3%
354 1
0.3%
353 1
0.3%
352 1
0.3%

제어함명
Text

UNIQUE 

Distinct361
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2024-03-13T15:13:26.911378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length9.4792244
Min length5

Characters and Unicode

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

Unique

Unique361 ?
Unique (%)100.0%

Sample

1st row간석역남광장_1
2nd row경원대로1_2
3rd row경원대로10_11
4th row경원대로11_12
5th row경원대로2_3
ValueCountFrequency (%)
간석역남광장_1 1
 
0.3%
염전로307번길1_237 1
 
0.3%
염전로261번길1_236 1
 
0.3%
염전로202번길1_339 1
 
0.3%
염전로2_219 1
 
0.3%
염전로17_234 1
 
0.3%
염전로16_233 1
 
0.3%
염전로15_232 1
 
0.3%
염전로144번안길1_235 1
 
0.3%
염전로14_231 1
 
0.3%
Other values (354) 354
97.3%
2024-03-13T15:13:27.248027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 357
 
10.4%
1 354
 
10.3%
로 315
 
9.2%
2 255
 
7.5%
3 198
 
5.8%
4 121
 
3.5%
5 109
 
3.2%
7 104
 
3.0%
6 104
 
3.0%
0 92
 
2.7%
Other values (123) 1413
41.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1515
44.3%
Other Letter 1509
44.1%
Connector Punctuation 357
 
10.4%
Uppercase Letter 14
 
0.4%
Open Punctuation 7
 
0.2%
Other Punctuation 7
 
0.2%
Close Punctuation 7
 
0.2%
Dash Punctuation 3
 
0.1%
Space Separator 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 315
20.9%
길 80
 
5.3%
번 64
 
4.2%
인 55
 
3.6%
대 54
 
3.6%
소 40
 
2.7%
홀 36
 
2.4%
주 35
 
2.3%
석 34
 
2.3%
하 32
 
2.1%
Other values (105) 764
50.6%
Decimal Number
ValueCountFrequency (%)
1 354
23.4%
2 255
16.8%
3 198
13.1%
4 121
 
8.0%
5 109
 
7.2%
7 104
 
6.9%
6 104
 
6.9%
0 92
 
6.1%
9 89
 
5.9%
8 89
 
5.9%
Uppercase Letter
ValueCountFrequency (%)
C 7
50.0%
I 7
50.0%
Connector Punctuation
ValueCountFrequency (%)
_ 357
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Other Punctuation
ValueCountFrequency (%)
# 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1899
55.5%
Hangul 1509
44.1%
Latin 14
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 315
20.9%
길 80
 
5.3%
번 64
 
4.2%
인 55
 
3.6%
대 54
 
3.6%
소 40
 
2.7%
홀 36
 
2.4%
주 35
 
2.3%
석 34
 
2.3%
하 32
 
2.1%
Other values (105) 764
50.6%
Common
ValueCountFrequency (%)
_ 357
18.8%
1 354
18.6%
2 255
13.4%
3 198
10.4%
4 121
 
6.4%
5 109
 
5.7%
7 104
 
5.5%
6 104
 
5.5%
0 92
 
4.8%
9 89
 
4.7%
Other values (6) 116
 
6.1%
Latin
ValueCountFrequency (%)
C 7
50.0%
I 7
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1913
55.9%
Hangul 1509
44.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 357
18.7%
1 354
18.5%
2 255
13.3%
3 198
10.4%
4 121
 
6.3%
5 109
 
5.7%
7 104
 
5.4%
6 104
 
5.4%
0 92
 
4.8%
9 89
 
4.7%
Other values (8) 130
 
6.8%
Hangul
ValueCountFrequency (%)
로 315
20.9%
길 80
 
5.3%
번 64
 
4.2%
인 55
 
3.6%
대 54
 
3.6%
소 40
 
2.7%
홀 36
 
2.4%
주 35
 
2.3%
석 34
 
2.3%
하 32
 
2.1%
Other values (105) 764
50.6%

설치위치
Text

MISSING 

Distinct334
Distinct (%)98.2%
Missing21
Missing (%)5.8%
Memory size2.9 KiB
2024-03-13T15:13:27.551441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length9.9176471
Min length3

Characters and Unicode

Total characters3372
Distinct characters113
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

Unique328 ?
Unique (%)96.5%

Sample

1st row주6 주안로213번길15
2nd row관 경원대로658번길5-47
3rd row문 505
4th row문 521
5th row관 주승로179
ValueCountFrequency (%)
용5 32
 
4.3%
학1 26
 
3.5%
주5 24
 
3.2%
도3 20
 
2.7%
도1 20
 
2.7%
주6 16
 
2.2%
학2 15
 
2.0%
주1 15
 
2.0%
숭1 14
 
1.9%
도 14
 
1.9%
Other values (379) 544
73.5%
2024-03-13T15:13:27.974788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
401
 
11.9%
로 264
 
7.8%
1 261
 
7.7%
2 203
 
6.0%
3 175
 
5.2%
5 172
 
5.1%
4 156
 
4.6%
주 144
 
4.3%
6 108
 
3.2%
7 97
 
2.9%
Other values (103) 1391
41.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1526
45.3%
Decimal Number 1372
40.7%
Space Separator 401
 
11.9%
Dash Punctuation 63
 
1.9%
Open Punctuation 5
 
0.1%
Close Punctuation 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 264
 
17.3%
주 144
 
9.4%
길 71
 
4.7%
용 70
 
4.6%
도 62
 
4.1%
번 54
 
3.5%
인 51
 
3.3%
학 48
 
3.1%
대 42
 
2.8%
숭 41
 
2.7%
Other values (89) 679
44.5%
Decimal Number
ValueCountFrequency (%)
1 261
19.0%
2 203
14.8%
3 175
12.8%
5 172
12.5%
4 156
11.4%
6 108
7.9%
7 97
 
7.1%
8 82
 
6.0%
9 66
 
4.8%
0 52
 
3.8%
Space Separator
ValueCountFrequency (%)
401
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 63
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1846
54.7%
Hangul 1526
45.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 264
 
17.3%
주 144
 
9.4%
길 71
 
4.7%
용 70
 
4.6%
도 62
 
4.1%
번 54
 
3.5%
인 51
 
3.3%
학 48
 
3.1%
대 42
 
2.8%
숭 41
 
2.7%
Other values (89) 679
44.5%
Common
ValueCountFrequency (%)
401
21.7%
1 261
14.1%
2 203
11.0%
3 175
9.5%
5 172
9.3%
4 156
 
8.5%
6 108
 
5.9%
7 97
 
5.3%
8 82
 
4.4%
9 66
 
3.6%
Other values (4) 125
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1846
54.7%
Hangul 1526
45.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
401
21.7%
1 261
14.1%
2 203
11.0%
3 175
9.5%
5 172
9.3%
4 156
 
8.5%
6 108
 
5.9%
7 97
 
5.3%
8 82
 
4.4%
9 66
 
3.6%
Other values (4) 125
 
6.8%
Hangul
ValueCountFrequency (%)
로 264
 
17.3%
주 144
 
9.4%
길 71
 
4.7%
용 70
 
4.6%
도 62
 
4.1%
번 54
 
3.5%
인 51
 
3.3%
학 48
 
3.1%
대 42
 
2.8%
숭 41
 
2.7%
Other values (89) 679
44.5%

가로등주
Categorical

Distinct37
Distinct (%)10.2%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
12
26 
11
 
25
14
 
20
18
 
20
9
 
18
Other values (32)
252 

Length

Max length4
Median length2
Mean length1.8060942
Min length1

Unique

Unique6 ?
Unique (%)1.7%

Sample

1st row6
2nd row19
3rd row20
4th row10
5th row33

Common Values

ValueCountFrequency (%)
12 26
 
7.2%
11 25
 
6.9%
14 20
 
5.5%
18 20
 
5.5%
9 18
 
5.0%
17 18
 
5.0%
16 18
 
5.0%
10 18
 
5.0%
15 17
 
4.7%
8 16
 
4.4%
Other values (27) 165
45.7%

Length

2024-03-13T15:13:28.151636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
12 26
 
7.3%
11 25
 
7.0%
14 20
 
5.6%
18 20
 
5.6%
9 18
 
5.0%
17 18
 
5.0%
16 18
 
5.0%
10 18
 
5.0%
15 17
 
4.7%
8 16
 
4.5%
Other values (26) 162
45.3%

가로등기구
Real number (ℝ)

Distinct61
Distinct (%)16.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.180055
Minimum3
Maximum318
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2024-03-13T15:13:28.301743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile7
Q113
median20
Q333
95-th percentile50
Maximum318
Range315
Interquartile range (IQR)20

Descriptive statistics

Standard deviation23.538933
Coefficient of variation (CV)0.93482452
Kurtosis75.331465
Mean25.180055
Median Absolute Deviation (MAD)9
Skewness6.9638292
Sum9090
Variance554.08138
MonotonicityNot monotonic
2024-03-13T15:13:28.483332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10 17
 
4.7%
17 15
 
4.2%
11 15
 
4.2%
19 15
 
4.2%
13 14
 
3.9%
28 13
 
3.6%
18 12
 
3.3%
22 11
 
3.0%
9 11
 
3.0%
8 10
 
2.8%
Other values (51) 228
63.2%
ValueCountFrequency (%)
3 1
 
0.3%
4 2
 
0.6%
5 7
1.9%
6 8
2.2%
7 9
2.5%
8 10
2.8%
9 11
3.0%
10 17
4.7%
11 15
4.2%
12 9
2.5%
ValueCountFrequency (%)
318 1
0.3%
204 1
0.3%
113 1
0.3%
98 1
0.3%
96 1
0.3%
72 1
0.3%
64 1
0.3%
60 1
0.3%
58 2
0.6%
56 1
0.3%

Interactions

2024-03-13T15:13:25.976861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T15:13:25.763644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T15:13:26.070600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T15:13:25.873502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T15:13:28.617238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번가로등주가로등기구
연번1.0000.3760.090
가로등주0.3761.0000.753
가로등기구0.0900.7531.000
2024-03-13T15:13:28.733625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번가로등기구가로등주
연번1.000-0.0150.137
가로등기구-0.0151.0000.447
가로등주0.1370.4471.000

Missing values

2024-03-13T15:13:26.208787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T15:13:26.299947image/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주6 주안로213번길15612
12경원대로1_2관 경원대로658번길5-471932
23경원대로10_11문 5052040
34경원대로11_12문 5211019
45경원대로2_3관 주승로1793347
56경원대로3_4주8 경원대로744번길41828
67경원대로4_5주4 경원대로8261115
78경원대로5_6주6 경원대로8742636
89경원대로6_7주6 경원대로8691517
910경원대로7_8주4 경원대로8091719
연번제어함명설치위치가로등주가로등기구
351352한나루로1_330학1 한나루로 34859
352353한나루로2_331학2 한나루로 3671835
353354한나루로3_332주2 한나루로 5481428
354355한나루로357번길1_338학1 한나루로357번길63-662550
355356한나루로4_333도1 한나루로 5911225
356357한나루로464번길1_364주3 주안동 73755
357358한나루로5_334주2 한나루로 5111736
358359한나루로6_335학2 한나루로 427-11836
359360한나루로7_336학1 한나루로 3671420
360361한나루로8_337학1 721-5713