Overview

Dataset statistics

Number of variables5
Number of observations544
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory21.9 KiB
Average record size in memory41.2 B

Variable types

Numeric1
Categorical2
Text2

Dataset

Description인천광역시 폐의약품 수거함 현황 데이터로(연번,관할,기관명칭,소재지(도로명주소),세부위치)등의 항목에 대한 정보를 제공합니다.
Author인천광역시
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15091229&srcSe=7661IVAWM27C61E190

Alerts

연번 is highly overall correlated with 관할High correlation
관할 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
세부위치 is highly overall correlated with 관할High correlation
세부위치 is highly imbalanced (58.5%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 07:56:19.604157
Analysis finished2024-01-28 07:56:20.235749
Duration0.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct544
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean272.5
Minimum1
Maximum544
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.9 KiB
2024-01-28T16:56:20.303332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile28.15
Q1136.75
median272.5
Q3408.25
95-th percentile516.85
Maximum544
Range543
Interquartile range (IQR)271.5

Descriptive statistics

Standard deviation157.18354
Coefficient of variation (CV)0.57682035
Kurtosis-1.2
Mean272.5
Median Absolute Deviation (MAD)136
Skewness0
Sum148240
Variance24706.667
MonotonicityStrictly increasing
2024-01-28T16:56:20.439293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
367 1
 
0.2%
361 1
 
0.2%
362 1
 
0.2%
363 1
 
0.2%
364 1
 
0.2%
365 1
 
0.2%
366 1
 
0.2%
368 1
 
0.2%
274 1
 
0.2%
Other values (534) 534
98.2%
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 (%)
544 1
0.2%
543 1
0.2%
542 1
0.2%
541 1
0.2%
540 1
0.2%
539 1
0.2%
538 1
0.2%
537 1
0.2%
536 1
0.2%
535 1
0.2%

관할
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
미추홀구
195 
서구
109 
연수구
55 
강화군
49 
동구
34 
Other values (5)
102 

Length

Max length4
Median length3
Mean length3.0441176
Min length2

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row중구
2nd row중구
3rd row중구
4th row중구
5th row중구

Common Values

ValueCountFrequency (%)
미추홀구 195
35.8%
서구 109
20.0%
연수구 55
 
10.1%
강화군 49
 
9.0%
동구 34
 
6.2%
중구 28
 
5.1%
계양구 27
 
5.0%
부평구 25
 
4.6%
남동구 21
 
3.9%
옹진군 1
 
0.2%

Length

2024-01-28T16:56:20.548223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T16:56:20.662191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미추홀구 195
35.8%
서구 109
20.0%
연수구 55
 
10.1%
강화군 49
 
9.0%
동구 34
 
6.2%
중구 28
 
5.1%
계양구 27
 
5.0%
부평구 25
 
4.6%
남동구 21
 
3.9%
옹진군 1
 
0.2%

기관명칭
Text

Distinct500
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2024-01-28T16:56:20.884574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length6.1691176
Min length3

Characters and Unicode

Total characters3356
Distinct characters287
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

Unique467 ?
Unique (%)85.8%

Sample

1st row중구보건소
2nd row국제도시보건과
3rd row용유보건지소
4th row무의보건진료소
5th row중구1청사 민원지적과
ValueCountFrequency (%)
행정복지센터 46
 
7.7%
중앙약국 4
 
0.7%
열린약국 4
 
0.7%
조은약국 3
 
0.5%
굿모닝약국 3
 
0.5%
백제약국 3
 
0.5%
행복한약국 3
 
0.5%
희망약국 3
 
0.5%
정성약국 3
 
0.5%
약국 3
 
0.5%
Other values (497) 524
87.5%
2024-01-28T16:56:21.216120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 412
 
12.3%
국 412
 
12.3%
지 113
 
3.4%
정 110
 
3.3%
동 109
 
3.2%
복 91
 
2.7%
터 89
 
2.7%
센 89
 
2.7%
행 89
 
2.7%
건 64
 
1.9%
Other values (277) 1778
53.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3197
95.3%
Decimal Number 82
 
2.4%
Space Separator 56
 
1.7%
Lowercase Letter 9
 
0.3%
Uppercase Letter 6
 
0.2%
Close Punctuation 2
 
0.1%
Dash Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 412
 
12.9%
국 412
 
12.9%
지 113
 
3.5%
정 110
 
3.4%
동 109
 
3.4%
복 91
 
2.8%
터 89
 
2.8%
센 89
 
2.8%
행 89
 
2.8%
건 64
 
2.0%
Other values (251) 1619
50.6%
Decimal Number
ValueCountFrequency (%)
2 23
28.0%
1 22
26.8%
3 14
17.1%
4 8
 
9.8%
5 6
 
7.3%
6 5
 
6.1%
0 2
 
2.4%
8 1
 
1.2%
7 1
 
1.2%
Lowercase Letter
ValueCountFrequency (%)
e 3
33.3%
s 1
 
11.1%
t 1
 
11.1%
o 1
 
11.1%
r 1
 
11.1%
w 1
 
11.1%
n 1
 
11.1%
Uppercase Letter
ValueCountFrequency (%)
W 1
16.7%
P 1
16.7%
I 1
16.7%
V 1
16.7%
H 1
16.7%
D 1
16.7%
Space Separator
ValueCountFrequency (%)
56
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3197
95.3%
Common 144
 
4.3%
Latin 15
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 412
 
12.9%
국 412
 
12.9%
지 113
 
3.5%
정 110
 
3.4%
동 109
 
3.4%
복 91
 
2.8%
터 89
 
2.8%
센 89
 
2.8%
행 89
 
2.8%
건 64
 
2.0%
Other values (251) 1619
50.6%
Common
ValueCountFrequency (%)
56
38.9%
2 23
16.0%
1 22
 
15.3%
3 14
 
9.7%
4 8
 
5.6%
5 6
 
4.2%
6 5
 
3.5%
) 2
 
1.4%
- 2
 
1.4%
0 2
 
1.4%
Other values (3) 4
 
2.8%
Latin
ValueCountFrequency (%)
e 3
20.0%
s 1
 
6.7%
t 1
 
6.7%
o 1
 
6.7%
r 1
 
6.7%
W 1
 
6.7%
P 1
 
6.7%
I 1
 
6.7%
V 1
 
6.7%
w 1
 
6.7%
Other values (3) 3
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3197
95.3%
ASCII 159
 
4.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 412
 
12.9%
국 412
 
12.9%
지 113
 
3.5%
정 110
 
3.4%
동 109
 
3.4%
복 91
 
2.8%
터 89
 
2.8%
센 89
 
2.8%
행 89
 
2.8%
건 64
 
2.0%
Other values (251) 1619
50.6%
ASCII
ValueCountFrequency (%)
56
35.2%
2 23
14.5%
1 22
 
13.8%
3 14
 
8.8%
4 8
 
5.0%
5 6
 
3.8%
6 5
 
3.1%
e 3
 
1.9%
) 2
 
1.3%
- 2
 
1.3%
Other values (16) 18
 
11.3%

소재지(도로명주소)
Text

Distinct542
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2024-01-28T16:56:21.549443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length44
Mean length26.15625
Min length9

Characters and Unicode

Total characters14229
Distinct characters297
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

Unique540 ?
Unique (%)99.3%

Sample

1st row인천광역시 중구 참외전로72번길 21(전동, 중구보건소)
2nd row인천광역시 중구 운남서로 100-1
3rd row인천광역시 중구 마시란로 308-13
4th row인천광역시 중구 대무의로 310-11(무의동 246-7)
5th row인천광역시 중구 신포로27번길 80
ValueCountFrequency (%)
인천광역시 484
 
16.9%
미추홀구 196
 
6.8%
서구 109
 
3.8%
1층 99
 
3.5%
주안동 78
 
2.7%
연수구 55
 
1.9%
강화군 49
 
1.7%
용현동 45
 
1.6%
중구 28
 
1.0%
계양구 27
 
0.9%
Other values (840) 1695
59.2%
2024-01-28T16:56:21.969068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2377
 
16.7%
인 565
 
4.0%
1 561
 
3.9%
로 538
 
3.8%
천 501
 
3.5%
시 496
 
3.5%
역 485
 
3.4%
동 485
 
3.4%
광 484
 
3.4%
구 469
 
3.3%
Other values (287) 7268
51.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8485
59.6%
Space Separator 2377
 
16.7%
Decimal Number 2165
 
15.2%
Open Punctuation 420
 
3.0%
Close Punctuation 419
 
2.9%
Other Punctuation 277
 
1.9%
Dash Punctuation 70
 
0.5%
Uppercase Letter 15
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 565
 
6.7%
로 538
 
6.3%
천 501
 
5.9%
시 496
 
5.8%
역 485
 
5.7%
동 485
 
5.7%
광 484
 
5.7%
구 469
 
5.5%
미 222
 
2.6%
홀 221
 
2.6%
Other values (261) 4019
47.4%
Decimal Number
ValueCountFrequency (%)
1 561
25.9%
2 257
11.9%
3 247
11.4%
0 211
 
9.7%
4 189
 
8.7%
5 155
 
7.2%
7 146
 
6.7%
6 145
 
6.7%
8 132
 
6.1%
9 122
 
5.6%
Uppercase Letter
ValueCountFrequency (%)
A 3
20.0%
S 2
13.3%
M 2
13.3%
C 2
13.3%
E 1
 
6.7%
N 1
 
6.7%
I 1
 
6.7%
P 1
 
6.7%
B 1
 
6.7%
Y 1
 
6.7%
Space Separator
ValueCountFrequency (%)
2377
100.0%
Open Punctuation
ValueCountFrequency (%)
( 420
100.0%
Close Punctuation
ValueCountFrequency (%)
) 419
100.0%
Other Punctuation
ValueCountFrequency (%)
, 277
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 70
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8485
59.6%
Common 5729
40.3%
Latin 15
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 565
 
6.7%
로 538
 
6.3%
천 501
 
5.9%
시 496
 
5.8%
역 485
 
5.7%
동 485
 
5.7%
광 484
 
5.7%
구 469
 
5.5%
미 222
 
2.6%
홀 221
 
2.6%
Other values (261) 4019
47.4%
Common
ValueCountFrequency (%)
2377
41.5%
1 561
 
9.8%
( 420
 
7.3%
) 419
 
7.3%
, 277
 
4.8%
2 257
 
4.5%
3 247
 
4.3%
0 211
 
3.7%
4 189
 
3.3%
5 155
 
2.7%
Other values (6) 616
 
10.8%
Latin
ValueCountFrequency (%)
A 3
20.0%
S 2
13.3%
M 2
13.3%
C 2
13.3%
E 1
 
6.7%
N 1
 
6.7%
I 1
 
6.7%
P 1
 
6.7%
B 1
 
6.7%
Y 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8485
59.6%
ASCII 5744
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2377
41.4%
1 561
 
9.8%
( 420
 
7.3%
) 419
 
7.3%
, 277
 
4.8%
2 257
 
4.5%
3 247
 
4.3%
0 211
 
3.7%
4 189
 
3.3%
5 155
 
2.7%
Other values (16) 631
 
11.0%
Hangul
ValueCountFrequency (%)
인 565
 
6.7%
로 538
 
6.3%
천 501
 
5.9%
시 496
 
5.8%
역 485
 
5.7%
동 485
 
5.7%
광 484
 
5.7%
구 469
 
5.5%
미 222
 
2.6%
홀 221
 
2.6%
Other values (261) 4019
47.4%

세부위치
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct35
Distinct (%)6.4%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
약국 내
361 
센터 내
45 
약국 내부
 
33
대기실
 
26
약국
 
16
Other values (30)
63 

Length

Max length18
Median length4
Mean length4.6672794
Min length2

Unique

Unique24 ?
Unique (%)4.4%

Sample

1st row보건소 내 1층
2nd row국제도시보건과 내
3rd row보건지소 내
4th row보건진료소 내
5th row민원지적과 내

Common Values

ValueCountFrequency (%)
약국 내 361
66.4%
센터 내 45
 
8.3%
약국 내부 33
 
6.1%
대기실 26
 
4.8%
약국 16
 
2.9%
1층 민원실내 13
 
2.4%
행정복지센터 1층 민원실 내 11
 
2.0%
행정복지센터 1층 입구 8
 
1.5%
2층 민원실내 3
 
0.6%
행정복지센터 2층 민원실 내 2
 
0.4%
Other values (25) 26
 
4.8%

Length

2024-01-28T16:56:22.100549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
내 427
39.0%
약국 410
37.4%
센터 45
 
4.1%
1층 42
 
3.8%
내부 33
 
3.0%
대기실 26
 
2.4%
행정복지센터 22
 
2.0%
민원실내 19
 
1.7%
민원실 19
 
1.7%
보건소 9
 
0.8%
Other values (24) 43
 
3.9%

Interactions

2024-01-28T16:56:20.016015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T16:56:22.171755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관할세부위치
연번1.0000.9670.811
관할0.9671.0000.965
세부위치0.8110.9651.000
2024-01-28T16:56:22.248479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관할세부위치
관할1.0000.756
세부위치0.7561.000
2024-01-28T16:56:22.330925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관할세부위치
연번1.0000.6870.426
관할0.6871.0000.756
세부위치0.4260.7561.000

Missing values

2024-01-28T16:56:20.116542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T16:56:20.198017image/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중구중구보건소인천광역시 중구 참외전로72번길 21(전동, 중구보건소)보건소 내 1층
12중구국제도시보건과인천광역시 중구 운남서로 100-1국제도시보건과 내
23중구용유보건지소인천광역시 중구 마시란로 308-13보건지소 내
34중구무의보건진료소인천광역시 중구 대무의로 310-11(무의동 246-7)보건진료소 내
45중구중구1청사 민원지적과인천광역시 중구 신포로27번길 80민원지적과 내
56중구신흥동 행정복지센터인천광역시 중구 제물량로80번길 3-14센터 내
67중구도원동 행정복지센터인천광역시 중구 도원로 42센터 내
78중구율목동 행정복지센터인천광역시 중구 서해대로483번길 3센터 내
89중구동인천동 행정복지센터인천광역시 중구 참외전로72번길 25센터 내
910중구개항동 행정복지센터인천광역시 중구 차이나타운로44번길 13-2센터 내
연번관할기관명칭소재지(도로명주소)세부위치
534535강화군황청보건진료소인천광역시 강화군 내가면 황청리 179-49대기실
535536강화군신삼보건진료소인천광역시 강화군 하점면 고려산로 506-2대기실
536537강화군인화보건진료소인천광역시 강화군 양사면 서사길105번길 47대기실
537538강화군매음보건진료소인천광역시 강화군 삼산면 삼산남로 498-8대기실
538539강화군하리보건진료소인천광역시 강화군 삼산면 삼산북로 790대기실
539540강화군서검보건진료소인천광역시 강화군 삼산면 서검길153번길 8대기실
540541강화군상용보건진료소인천광역시 강화군 교동면 교동동로 208-3대기실
541542강화군난정보건진료소인천광역시 강화군 교동면 교동서로378번길 56-28대기실
542543강화군삼선보건진료소인천광역시 강화군 교동면 교동북로 220대기실
543544옹진군옹진군보건소인천시 미추홀구 매소홀로 120보건소 민원실