Overview

Dataset statistics

Number of variables4
Number of observations632
Missing cells531
Missing cells (%)21.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.5 KiB
Average record size in memory33.2 B

Variable types

Numeric1
Text3

Dataset

Description인천광역시 계양구 관내 의료기기 판매업소 현황에 대한 데이터로, 순번, 영업소명, 영업소 소재지(도로명주소), 영업소 전화번호 등을 제공합니다.
Author인천광역시 계양구
URLhttps://www.data.go.kr/data/15039244/fileData.do

Alerts

영업소전화번호 has 531 (84.0%) missing valuesMissing
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 15:32:05.111500
Analysis finished2024-03-14 15:32:06.575600
Duration1.46 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct632
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean316.5
Minimum1
Maximum632
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.7 KiB
2024-03-15T00:32:06.799607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile32.55
Q1158.75
median316.5
Q3474.25
95-th percentile600.45
Maximum632
Range631
Interquartile range (IQR)315.5

Descriptive statistics

Standard deviation182.58697
Coefficient of variation (CV)0.57689405
Kurtosis-1.2
Mean316.5
Median Absolute Deviation (MAD)158
Skewness0
Sum200028
Variance33338
MonotonicityStrictly increasing
2024-03-15T00:32:07.511532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
426 1
 
0.2%
419 1
 
0.2%
420 1
 
0.2%
421 1
 
0.2%
422 1
 
0.2%
423 1
 
0.2%
424 1
 
0.2%
425 1
 
0.2%
427 1
 
0.2%
Other values (622) 622
98.4%
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 (%)
632 1
0.2%
631 1
0.2%
630 1
0.2%
629 1
0.2%
628 1
0.2%
627 1
0.2%
626 1
0.2%
625 1
0.2%
624 1
0.2%
623 1
0.2%
Distinct631
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2024-03-15T00:32:08.695339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length16
Mean length7.8860759
Min length1

Characters and Unicode

Total characters4984
Distinct characters462
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique630 ?
Unique (%)99.7%

Sample

1st row한국화장품
2nd row씨유 계양영안힐스점
3rd row에스유유통(su유통)
4th row아나덴 슈가링왁싱 인천계산점
5th row지에스(GS)25 인천효성점
ValueCountFrequency (%)
세븐일레븐 35
 
4.2%
주식회사 34
 
4.1%
gs25 13
 
1.6%
씨유 10
 
1.2%
지에스25 9
 
1.1%
작전점 9
 
1.1%
지에스(gs)25 7
 
0.8%
계양점 6
 
0.7%
계산점 4
 
0.5%
에치와이 4
 
0.5%
Other values (676) 705
84.3%
2024-03-15T00:32:10.531528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
204
 
4.1%
196
 
3.9%
163
 
3.3%
149
 
3.0%
126
 
2.5%
) 114
 
2.3%
( 114
 
2.3%
106
 
2.1%
88
 
1.8%
84
 
1.7%
Other values (452) 3640
73.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4122
82.7%
Uppercase Letter 230
 
4.6%
Space Separator 204
 
4.1%
Decimal Number 132
 
2.6%
Close Punctuation 114
 
2.3%
Open Punctuation 114
 
2.3%
Lowercase Letter 55
 
1.1%
Other Punctuation 8
 
0.2%
Dash Punctuation 3
 
0.1%
Other Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
196
 
4.8%
163
 
4.0%
149
 
3.6%
126
 
3.1%
106
 
2.6%
88
 
2.1%
84
 
2.0%
82
 
2.0%
82
 
2.0%
80
 
1.9%
Other values (396) 2966
72.0%
Uppercase Letter
ValueCountFrequency (%)
S 54
23.5%
G 43
18.7%
C 24
10.4%
U 16
 
7.0%
D 11
 
4.8%
M 10
 
4.3%
J 9
 
3.9%
K 9
 
3.9%
L 7
 
3.0%
E 7
 
3.0%
Other values (12) 40
17.4%
Lowercase Letter
ValueCountFrequency (%)
e 9
16.4%
a 6
10.9%
i 5
9.1%
g 5
9.1%
l 4
 
7.3%
r 4
 
7.3%
d 3
 
5.5%
c 3
 
5.5%
h 3
 
5.5%
u 3
 
5.5%
Other values (6) 10
18.2%
Decimal Number
ValueCountFrequency (%)
2 57
43.2%
5 51
38.6%
1 8
 
6.1%
4 7
 
5.3%
9 3
 
2.3%
0 2
 
1.5%
3 2
 
1.5%
7 1
 
0.8%
6 1
 
0.8%
Other Punctuation
ValueCountFrequency (%)
. 4
50.0%
& 2
25.0%
1
 
12.5%
/ 1
 
12.5%
Space Separator
ValueCountFrequency (%)
204
100.0%
Close Punctuation
ValueCountFrequency (%)
) 114
100.0%
Open Punctuation
ValueCountFrequency (%)
( 114
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Other Symbol
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4124
82.7%
Common 575
 
11.5%
Latin 285
 
5.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
196
 
4.8%
163
 
4.0%
149
 
3.6%
126
 
3.1%
106
 
2.6%
88
 
2.1%
84
 
2.0%
82
 
2.0%
82
 
2.0%
80
 
1.9%
Other values (397) 2968
72.0%
Latin
ValueCountFrequency (%)
S 54
18.9%
G 43
15.1%
C 24
 
8.4%
U 16
 
5.6%
D 11
 
3.9%
M 10
 
3.5%
J 9
 
3.2%
e 9
 
3.2%
K 9
 
3.2%
L 7
 
2.5%
Other values (28) 93
32.6%
Common
ValueCountFrequency (%)
204
35.5%
) 114
19.8%
( 114
19.8%
2 57
 
9.9%
5 51
 
8.9%
1 8
 
1.4%
4 7
 
1.2%
. 4
 
0.7%
- 3
 
0.5%
9 3
 
0.5%
Other values (7) 10
 
1.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4122
82.7%
ASCII 859
 
17.2%
None 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
204
23.7%
) 114
13.3%
( 114
13.3%
2 57
 
6.6%
S 54
 
6.3%
5 51
 
5.9%
G 43
 
5.0%
C 24
 
2.8%
U 16
 
1.9%
D 11
 
1.3%
Other values (44) 171
19.9%
Hangul
ValueCountFrequency (%)
196
 
4.8%
163
 
4.0%
149
 
3.6%
126
 
3.1%
106
 
2.6%
88
 
2.1%
84
 
2.0%
82
 
2.0%
82
 
2.0%
80
 
1.9%
Other values (396) 2966
72.0%
None
ValueCountFrequency (%)
2
66.7%
1
33.3%
Distinct624
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
2024-03-15T00:32:12.172091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length48
Mean length36.261076
Min length21

Characters and Unicode

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

Unique

Unique616 ?
Unique (%)97.5%

Sample

1st row인천광역시 계양구 경명대로 1074, 삼환1빌딩 3층 304,305호 (계산동)
2nd row인천광역시 계양구 계양대로97번길 6, 1층 1호 (작전동, 영안빌라)
3rd row인천광역시 계양구 오조산로 41, 대우마이빌 11층 1101호 (계산동)
4th row인천광역시 계양구 계산새로 71, 하이베라스 B동 2층 207호 (계산동)
5th row인천광역시 계양구 아나지로 75, 효성다섬프라자 1층 107호 (효성동)
ValueCountFrequency (%)
인천광역시 632
 
14.2%
계양구 632
 
14.2%
계산동 202
 
4.5%
1층 152
 
3.4%
작전동 149
 
3.3%
효성동 74
 
1.7%
일부호 50
 
1.1%
계양대로 43
 
1.0%
장제로 43
 
1.0%
2층 41
 
0.9%
Other values (975) 2448
54.8%
2024-03-15T00:32:14.151247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3835
 
16.7%
1048
 
4.6%
1 1035
 
4.5%
833
 
3.6%
808
 
3.5%
, 777
 
3.4%
( 646
 
2.8%
) 646
 
2.8%
641
 
2.8%
640
 
2.8%
Other values (282) 12008
52.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12915
56.4%
Decimal Number 3868
 
16.9%
Space Separator 3835
 
16.7%
Other Punctuation 786
 
3.4%
Open Punctuation 646
 
2.8%
Close Punctuation 646
 
2.8%
Dash Punctuation 102
 
0.4%
Uppercase Letter 95
 
0.4%
Lowercase Letter 16
 
0.1%
Math Symbol 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1048
 
8.1%
833
 
6.4%
808
 
6.3%
641
 
5.0%
640
 
5.0%
639
 
4.9%
637
 
4.9%
633
 
4.9%
632
 
4.9%
607
 
4.7%
Other values (240) 5797
44.9%
Uppercase Letter
ValueCountFrequency (%)
B 21
22.1%
A 12
12.6%
D 8
 
8.4%
E 7
 
7.4%
S 6
 
6.3%
O 6
 
6.3%
M 5
 
5.3%
P 4
 
4.2%
L 4
 
4.2%
C 4
 
4.2%
Other values (8) 18
18.9%
Decimal Number
ValueCountFrequency (%)
1 1035
26.8%
0 508
13.1%
2 467
12.1%
3 365
 
9.4%
5 339
 
8.8%
4 280
 
7.2%
7 271
 
7.0%
6 231
 
6.0%
8 204
 
5.3%
9 168
 
4.3%
Lowercase Letter
ValueCountFrequency (%)
e 5
31.2%
x 2
 
12.5%
l 2
 
12.5%
p 2
 
12.5%
i 2
 
12.5%
d 2
 
12.5%
c 1
 
6.2%
Other Punctuation
ValueCountFrequency (%)
, 777
98.9%
. 9
 
1.1%
Space Separator
ValueCountFrequency (%)
3835
100.0%
Open Punctuation
ValueCountFrequency (%)
( 646
100.0%
Close Punctuation
ValueCountFrequency (%)
) 646
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 102
100.0%
Math Symbol
ValueCountFrequency (%)
~ 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12915
56.4%
Common 9891
43.2%
Latin 111
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1048
 
8.1%
833
 
6.4%
808
 
6.3%
641
 
5.0%
640
 
5.0%
639
 
4.9%
637
 
4.9%
633
 
4.9%
632
 
4.9%
607
 
4.7%
Other values (240) 5797
44.9%
Latin
ValueCountFrequency (%)
B 21
18.9%
A 12
 
10.8%
D 8
 
7.2%
E 7
 
6.3%
S 6
 
5.4%
O 6
 
5.4%
e 5
 
4.5%
M 5
 
4.5%
P 4
 
3.6%
L 4
 
3.6%
Other values (15) 33
29.7%
Common
ValueCountFrequency (%)
3835
38.8%
1 1035
 
10.5%
, 777
 
7.9%
( 646
 
6.5%
) 646
 
6.5%
0 508
 
5.1%
2 467
 
4.7%
3 365
 
3.7%
5 339
 
3.4%
4 280
 
2.8%
Other values (7) 993
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12915
56.4%
ASCII 10002
43.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3835
38.3%
1 1035
 
10.3%
, 777
 
7.8%
( 646
 
6.5%
) 646
 
6.5%
0 508
 
5.1%
2 467
 
4.7%
3 365
 
3.6%
5 339
 
3.4%
4 280
 
2.8%
Other values (32) 1104
 
11.0%
Hangul
ValueCountFrequency (%)
1048
 
8.1%
833
 
6.4%
808
 
6.3%
641
 
5.0%
640
 
5.0%
639
 
4.9%
637
 
4.9%
633
 
4.9%
632
 
4.9%
607
 
4.7%
Other values (240) 5797
44.9%

영업소전화번호
Text

MISSING 

Distinct99
Distinct (%)98.0%
Missing531
Missing (%)84.0%
Memory size5.1 KiB
2024-03-15T00:32:16.246326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.019802
Min length9

Characters and Unicode

Total characters1214
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique97 ?
Unique (%)96.0%

Sample

1st row032-721-7986
2nd row070-8624-4349
3rd row032-542-6871
4th row032-288-7000
5th row032-555-9207
ValueCountFrequency (%)
02-2164-0859 2
 
2.0%
032-542-7237 2
 
2.0%
032-551-7989 1
 
1.0%
032-554-3581 1
 
1.0%
032-540-9379 1
 
1.0%
032-553-1975 1
 
1.0%
032-545-2825 1
 
1.0%
032-250-2080 1
 
1.0%
032-543-1094 1
 
1.0%
032-562-7128 1
 
1.0%
Other values (89) 89
88.1%
2024-03-15T00:32:18.653433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 200
16.5%
0 177
14.6%
5 172
14.2%
2 168
13.8%
3 131
10.8%
4 76
 
6.3%
1 66
 
5.4%
7 64
 
5.3%
8 55
 
4.5%
6 54
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1014
83.5%
Dash Punctuation 200
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 177
17.5%
5 172
17.0%
2 168
16.6%
3 131
12.9%
4 76
7.5%
1 66
 
6.5%
7 64
 
6.3%
8 55
 
5.4%
6 54
 
5.3%
9 51
 
5.0%
Dash Punctuation
ValueCountFrequency (%)
- 200
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1214
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 200
16.5%
0 177
14.6%
5 172
14.2%
2 168
13.8%
3 131
10.8%
4 76
 
6.3%
1 66
 
5.4%
7 64
 
5.3%
8 55
 
4.5%
6 54
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1214
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 200
16.5%
0 177
14.6%
5 172
14.2%
2 168
13.8%
3 131
10.8%
4 76
 
6.3%
1 66
 
5.4%
7 64
 
5.3%
8 55
 
4.5%
6 54
 
4.4%

Interactions

2024-03-15T00:32:05.836102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T00:32:19.169728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업소전화번호
순번1.0000.988
영업소전화번호0.9881.000

Missing values

2024-03-15T00:32:06.160960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T00:32:06.456470image/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한국화장품인천광역시 계양구 경명대로 1074, 삼환1빌딩 3층 304,305호 (계산동)<NA>
12씨유 계양영안힐스점인천광역시 계양구 계양대로97번길 6, 1층 1호 (작전동, 영안빌라)<NA>
23에스유유통(su유통)인천광역시 계양구 오조산로 41, 대우마이빌 11층 1101호 (계산동)<NA>
34아나덴 슈가링왁싱 인천계산점인천광역시 계양구 계산새로 71, 하이베라스 B동 2층 207호 (계산동)<NA>
45지에스(GS)25 인천효성점인천광역시 계양구 아나지로 75, 효성다섬프라자 1층 107호 (효성동)<NA>
56하이옥시 파트너스인천광역시 계양구 오조산로7번길 6-8, 유영엠프레스 7층 701호 (작전동)<NA>
67뷰티헬스잡화점인천광역시 계양구 봉오대로676번길 13-5, 1층 가호 (작전동)<NA>
78한우리메디칼인천광역시 계양구 계양대로 123, 더드림병원 1층 일부호 (작전동)<NA>
89쇼피나라인천광역시 계양구 계양문화로 142, 308동 201호 (용종동, 초정마을두산.쌍용아파트)<NA>
910한자리데코인천광역시 계양구 오조산로 91, 새롬2차프라자 2층 203,204,205호-38호 (용종동)<NA>
순번영업소명영업소소재지(도로명)영업소전화번호
622623㈜제일에스에프인천광역시 계양구 계양문화로 44, 라이즈빌 1111호 (계산동)032-547-1434
623624한빛에벤에셀인천광역시 계양구 아나지로247번길 11, 모닝프라자 3층 303호 (효성동)032-552-7690
624625금강보청기계양센터인천광역시 계양구 계양대로 85-1, 2층 (작전동)032-543-0815
625626김정문알로에작전지부인천광역시 계양구 효서로 344, 경민메디칼프라자 301호 (작전동)032-543-0543
626627시그니아독일보청기인천광역시 계양구 계양대로 82, 3층 301호 (작전동)<NA>
627628금호의료기인천광역시 계양구 계양대로 137 (작전동)032-554-3121
628629홈플러스(주) 작전점인천광역시 계양구 계양대로 27 (작전동, (1층,3층))032-540-8123
629630(주)다우메디칼인천광역시 계양구 병방로 23, 4층 (병방동)032-554-3581
630631김정문알로에인천광역시 계양구 안남로 499, 102(1부)호 (효성동)<NA>
631632㈜인스코인천광역시 계양구 계양대로 195, 2층 (계산동)032-548-6600