Overview

Dataset statistics

Number of variables6
Number of observations524
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.2 KiB
Average record size in memory49.3 B

Variable types

Numeric1
Categorical4
Text1

Dataset

Description인천광역시 미추홀구에 설치된 제설함에 대한 데이터로 관리부서, 전화번호, 도로명주소, 배치물품 등의 정보를 제공합니다.
Author인천광역시 미추홀구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15127345&srcSe=7661IVAWM27C61E190

Alerts

구분 has constant value ""Constant
관리부서 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
배치물품 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
전화번호 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
연번 is highly overall correlated with 관리부서 and 2 other fieldsHigh correlation
연번 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2024-04-06 09:38:41.614658
Analysis finished2024-04-06 09:38:43.978502
Duration2.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct524
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean262.5
Minimum1
Maximum524
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.7 KiB
2024-04-06T18:38:44.067027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile27.15
Q1131.75
median262.5
Q3393.25
95-th percentile497.85
Maximum524
Range523
Interquartile range (IQR)261.5

Descriptive statistics

Standard deviation151.41004
Coefficient of variation (CV)0.57680015
Kurtosis-1.2
Mean262.5
Median Absolute Deviation (MAD)131
Skewness0
Sum137550
Variance22925
MonotonicityStrictly increasing
2024-04-06T18:38:44.218760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
362 1
 
0.2%
360 1
 
0.2%
359 1
 
0.2%
358 1
 
0.2%
357 1
 
0.2%
356 1
 
0.2%
355 1
 
0.2%
354 1
 
0.2%
353 1
 
0.2%
Other values (514) 514
98.1%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
524 1
0.2%
523 1
0.2%
522 1
0.2%
521 1
0.2%
520 1
0.2%
519 1
0.2%
518 1
0.2%
517 1
0.2%
516 1
0.2%
515 1
0.2%

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
제설함
524 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제설함
2nd row제설함
3rd row제설함
4th row제설함
5th row제설함

Common Values

ValueCountFrequency (%)
제설함 524
100.0%

Length

2024-04-06T18:38:44.388316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T18:38:44.506559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제설함 524
100.0%

관리부서
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
도화2.3동
41 
용현1.4동
41 
숭의4동
40 
문학동
39 
주안8동
37 
Other values (16)
326 

Length

Max length6
Median length4
Mean length4.2862595
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row숭의1.3동
2nd row숭의1.3동
3rd row숭의1.3동
4th row숭의1.3동
5th row숭의1.3동

Common Values

ValueCountFrequency (%)
도화2.3동 41
 
7.8%
용현1.4동 41
 
7.8%
숭의4동 40
 
7.6%
문학동 39
 
7.4%
주안8동 37
 
7.1%
학익1동 35
 
6.7%
도화1동 35
 
6.7%
용현3동 30
 
5.7%
주안2동 29
 
5.5%
주안6동 27
 
5.2%
Other values (11) 170
32.4%

Length

2024-04-06T18:38:44.619388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
도화2.3동 41
 
7.8%
용현1.4동 41
 
7.8%
숭의4동 40
 
7.6%
문학동 39
 
7.4%
주안8동 37
 
7.1%
학익1동 35
 
6.7%
도화1동 35
 
6.7%
용현3동 30
 
5.7%
주안2동 29
 
5.5%
학익2동 27
 
5.2%
Other values (11) 170
32.4%

전화번호
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
032-728-6701
41 
032-728-6161
41 
032-728-6147
40 
032-728-6506
39 
032-728-6467
37 
Other values (16)
326 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row032-728-6105
2nd row032-728-6105
3rd row032-728-6105
4th row032-728-6105
5th row032-728-6105

Common Values

ValueCountFrequency (%)
032-728-6701 41
 
7.8%
032-728-6161 41
 
7.8%
032-728-6147 40
 
7.6%
032-728-6506 39
 
7.4%
032-728-6467 37
 
7.1%
032-728-6246 35
 
6.7%
032-728-6281 35
 
6.7%
032-728-6204 30
 
5.7%
032-728-6345 29
 
5.5%
032-728-6425 27
 
5.2%
Other values (11) 170
32.4%

Length

2024-04-06T18:38:44.746154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
032-728-6701 41
 
7.8%
032-728-6161 41
 
7.8%
032-728-6147 40
 
7.6%
032-728-6506 39
 
7.4%
032-728-6467 37
 
7.1%
032-728-6246 35
 
6.7%
032-728-6281 35
 
6.7%
032-728-6204 30
 
5.7%
032-728-6345 29
 
5.5%
032-728-6264 27
 
5.2%
Other values (11) 170
32.4%

도로명주소
Text

UNIQUE 

Distinct524
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2024-04-06T18:38:45.051712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length36
Mean length25.685115
Min length17

Characters and Unicode

Total characters13459
Distinct characters309
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

Unique524 ?
Unique (%)100.0%

Sample

1st row인천광역시 미추홀구 석정로102번길 9-29
2nd row인천광역시 미추홀구 석정로 118-15
3rd row인천광역시 미추홀구 석정로126번길 13
4th row인천광역시 미추홀구 석정로140번길 8-1
5th row인천광역시 미추홀구 석정로140번길 24
ValueCountFrequency (%)
미추홀구 525
 
19.8%
인천광역시 524
 
19.8%
앞 92
 
3.5%
옆 33
 
1.2%
맞은편 16
 
0.6%
부근 16
 
0.6%
수봉로 15
 
0.6%
14 13
 
0.5%
경원대로 12
 
0.5%
29 12
 
0.5%
Other values (805) 1390
52.5%
2024-04-06T18:38:45.622488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2172
 
16.1%
인 642
 
4.8%
홀 558
 
4.1%
구 544
 
4.0%
미 539
 
4.0%
추 536
 
4.0%
천 532
 
4.0%
광 527
 
3.9%
시 526
 
3.9%
역 525
 
3.9%
Other values (299) 6358
47.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8761
65.1%
Decimal Number 2256
 
16.8%
Space Separator 2172
 
16.1%
Dash Punctuation 125
 
0.9%
Other Punctuation 46
 
0.3%
Open Punctuation 37
 
0.3%
Close Punctuation 37
 
0.3%
Uppercase Letter 25
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 642
 
7.3%
홀 558
 
6.4%
구 544
 
6.2%
미 539
 
6.2%
추 536
 
6.1%
천 532
 
6.1%
광 527
 
6.0%
시 526
 
6.0%
역 525
 
6.0%
길 502
 
5.7%
Other values (271) 3330
38.0%
Uppercase Letter
ValueCountFrequency (%)
A 4
16.0%
S 4
16.0%
G 3
12.0%
P 2
8.0%
I 2
8.0%
C 2
8.0%
B 2
8.0%
U 2
8.0%
H 1
 
4.0%
T 1
 
4.0%
Other values (2) 2
8.0%
Decimal Number
ValueCountFrequency (%)
1 406
18.0%
2 302
13.4%
3 282
12.5%
4 233
10.3%
5 225
10.0%
6 197
8.7%
8 172
7.6%
7 165
7.3%
9 140
 
6.2%
0 134
 
5.9%
Other Punctuation
ValueCountFrequency (%)
, 44
95.7%
@ 2
 
4.3%
Space Separator
ValueCountFrequency (%)
2172
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 125
100.0%
Open Punctuation
ValueCountFrequency (%)
( 37
100.0%
Close Punctuation
ValueCountFrequency (%)
) 37
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8761
65.1%
Common 4673
34.7%
Latin 25
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 642
 
7.3%
홀 558
 
6.4%
구 544
 
6.2%
미 539
 
6.2%
추 536
 
6.1%
천 532
 
6.1%
광 527
 
6.0%
시 526
 
6.0%
역 525
 
6.0%
길 502
 
5.7%
Other values (271) 3330
38.0%
Common
ValueCountFrequency (%)
2172
46.5%
1 406
 
8.7%
2 302
 
6.5%
3 282
 
6.0%
4 233
 
5.0%
5 225
 
4.8%
6 197
 
4.2%
8 172
 
3.7%
7 165
 
3.5%
9 140
 
3.0%
Other values (6) 379
 
8.1%
Latin
ValueCountFrequency (%)
A 4
16.0%
S 4
16.0%
G 3
12.0%
P 2
8.0%
I 2
8.0%
C 2
8.0%
B 2
8.0%
U 2
8.0%
H 1
 
4.0%
T 1
 
4.0%
Other values (2) 2
8.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8761
65.1%
ASCII 4698
34.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2172
46.2%
1 406
 
8.6%
2 302
 
6.4%
3 282
 
6.0%
4 233
 
5.0%
5 225
 
4.8%
6 197
 
4.2%
8 172
 
3.7%
7 165
 
3.5%
9 140
 
3.0%
Other values (18) 404
 
8.6%
Hangul
ValueCountFrequency (%)
인 642
 
7.3%
홀 558
 
6.4%
구 544
 
6.2%
미 539
 
6.2%
추 536
 
6.1%
천 532
 
6.1%
광 527
 
6.0%
시 526
 
6.0%
역 525
 
6.0%
길 502
 
5.7%
Other values (271) 3330
38.0%

배치물품
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
<NA>
324 
염화칼슘 2포
56 
염화칼슘 2포, 막삽 1개
47 
염화칼슘 3포
 
27
염화칼슘5포
 
22
Other values (3)
48 

Length

Max length14
Median length4
Mean length6.0362595
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row염화칼슘5포
2nd row염화칼슘5포
3rd row염화칼슘5포
4th row염화칼슘5포
5th row염화칼슘5포

Common Values

ValueCountFrequency (%)
<NA> 324
61.8%
염화칼슘 2포 56
 
10.7%
염화칼슘 2포, 막삽 1개 47
 
9.0%
염화칼슘 3포 27
 
5.2%
염화칼슘5포 22
 
4.2%
염화칼슘 5포 20
 
3.8%
염화칼슘 4포, 막삽 1개 16
 
3.1%
염화칼슘 2포, 막삽 12
 
2.3%

Length

2024-04-06T18:38:45.756449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T18:38:45.887690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 324
38.6%
염화칼슘 178
21.2%
2포 115
 
13.7%
막삽 75
 
8.9%
1개 63
 
7.5%
3포 27
 
3.2%
염화칼슘5포 22
 
2.6%
5포 20
 
2.4%
4포 16
 
1.9%

Interactions

2024-04-06T18:38:43.615274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T18:38:45.992051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관리부서전화번호배치물품
연번1.0000.9850.9850.865
관리부서0.9851.0001.0001.000
전화번호0.9851.0001.0001.000
배치물품0.8651.0001.0001.000
2024-04-06T18:38:46.128834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리부서배치물품전화번호
관리부서1.0000.9921.000
배치물품0.9921.0000.992
전화번호1.0000.9921.000
2024-04-06T18:38:46.226329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관리부서전화번호배치물품
연번1.0000.8980.8980.692
관리부서0.8981.0001.0000.992
전화번호0.8981.0001.0000.992
배치물품0.6920.9920.9921.000

Missing values

2024-04-06T18:38:43.805302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T18:38:43.925249image/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동032-728-6105인천광역시 미추홀구 석정로102번길 9-29염화칼슘5포
12제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로 118-15염화칼슘5포
23제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로126번길 13염화칼슘5포
34제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로140번길 8-1염화칼슘5포
45제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로140번길 24염화칼슘5포
56제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로92번길 89염화칼슘5포
67제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로126번길 29염화칼슘5포
78제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로102번길 19염화칼슘5포
89제설함숭의1.3동032-728-6105인천광역시 미추홀구 새천년로5번길 61염화칼슘5포
910제설함숭의1.3동032-728-6105인천광역시 미추홀구 석정로 95-9염화칼슘5포
연번구분관리부서전화번호도로명주소배치물품
514515제설함문학동032-728-6506인천광역시 미추홀구 소성로 277번길 18(광역수사대 담장 옆)<NA>
515516제설함문학동032-728-6506인천광역시 미추홀구 소성로282번길 18<NA>
516517제설함문학동032-728-6506인천광역시 미추홀구 문학길 48 (더 리치타운)<NA>
517518제설함문학동032-728-6506인천광역시 미추홀구 문학길 70번길(와이파이 빌라 뒤편)<NA>
518519제설함문학동032-728-6506인천광역시 미추홀구 문학길 104번길 (성원예가)<NA>
519520제설함문학동032-728-6506인천광역시 미추홀구 승학길 26번길 39<NA>
520521제설함문학동032-728-6506인천광역시 미추홀구 소성로 282번길 55 (신선사 앞)<NA>
521522제설함문학동032-728-6506인천광역시 미추홀구 소성로 278번길 문학메아리터널 입구<NA>
522523제설함문학동032-728-6506인천광역시 미추홀구 소성로 294번길23 SH품안애<NA>
523524제설함문학동032-728-6506인천광역시 미추홀구 문학길70번길 17-15<NA>