Overview

Dataset statistics

Number of variables5
Number of observations467
Missing cells2
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory18.8 KiB
Average record size in memory41.3 B

Variable types

Numeric1
Text2
DateTime2

Dataset

Description인천광역시 서구관내에 위치한 안전상비 의약품 판매업소 현황(점포명, 소재지(도로명))에 관한 데이터 파일 입니다.
Author인천광역시 서구
URLhttps://www.data.go.kr/data/15068798/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:41:07.262174
Analysis finished2023-12-12 10:41:07.798177
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct467
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean234
Minimum1
Maximum467
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.2 KiB
2023-12-12T19:41:07.885760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile24.3
Q1117.5
median234
Q3350.5
95-th percentile443.7
Maximum467
Range466
Interquartile range (IQR)233

Descriptive statistics

Standard deviation134.95555
Coefficient of variation (CV)0.57673311
Kurtosis-1.2
Mean234
Median Absolute Deviation (MAD)117
Skewness0
Sum109278
Variance18213
MonotonicityStrictly increasing
2023-12-12T19:41:08.044225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
309 1
 
0.2%
321 1
 
0.2%
320 1
 
0.2%
319 1
 
0.2%
318 1
 
0.2%
317 1
 
0.2%
316 1
 
0.2%
315 1
 
0.2%
314 1
 
0.2%
Other values (457) 457
97.9%
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 (%)
467 1
0.2%
466 1
0.2%
465 1
0.2%
464 1
0.2%
463 1
0.2%
462 1
0.2%
461 1
0.2%
460 1
0.2%
459 1
0.2%
458 1
0.2%
Distinct464
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2023-12-12T19:41:08.221840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length16
Mean length10.205567
Min length5

Characters and Unicode

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

Unique

Unique461 ?
Unique (%)98.7%

Sample

1st rowGS25루원타운점
2nd row지에스25청라호반1차
3rd row씨유완정본점
4th row지에스25청라베르디움
5th row지에스25루원스타
ValueCountFrequency (%)
씨유 44
 
7.5%
지에스25 25
 
4.3%
주)코리아세븐 17
 
2.9%
세븐일레븐 14
 
2.4%
이마트24 6
 
1.0%
지에스(gs)25 6
 
1.0%
gs25 3
 
0.5%
씨유당하금호점 2
 
0.3%
청라대광점 2
 
0.3%
서구연희점 2
 
0.3%
Other values (462) 464
79.3%
2023-12-12T19:41:08.568715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
397
 
8.3%
2 182
 
3.8%
180
 
3.8%
5 156
 
3.3%
146
 
3.1%
143
 
3.0%
142
 
3.0%
123
 
2.6%
118
 
2.5%
114
 
2.4%
Other values (271) 3065
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3909
82.0%
Decimal Number 386
 
8.1%
Uppercase Letter 226
 
4.7%
Space Separator 118
 
2.5%
Open Punctuation 63
 
1.3%
Close Punctuation 62
 
1.3%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
397
 
10.2%
180
 
4.6%
146
 
3.7%
143
 
3.7%
142
 
3.6%
123
 
3.1%
114
 
2.9%
109
 
2.8%
98
 
2.5%
86
 
2.2%
Other values (249) 2371
60.7%
Uppercase Letter
ValueCountFrequency (%)
S 75
33.2%
G 69
30.5%
C 33
14.6%
U 32
14.2%
R 7
 
3.1%
K 5
 
2.2%
B 1
 
0.4%
Y 1
 
0.4%
L 1
 
0.4%
P 1
 
0.4%
Decimal Number
ValueCountFrequency (%)
2 182
47.2%
5 156
40.4%
4 29
 
7.5%
3 7
 
1.8%
6 6
 
1.6%
1 6
 
1.6%
Lowercase Letter
ValueCountFrequency (%)
s 1
50.0%
k 1
50.0%
Space Separator
ValueCountFrequency (%)
118
100.0%
Open Punctuation
ValueCountFrequency (%)
( 63
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3909
82.0%
Common 629
 
13.2%
Latin 228
 
4.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
397
 
10.2%
180
 
4.6%
146
 
3.7%
143
 
3.7%
142
 
3.6%
123
 
3.1%
114
 
2.9%
109
 
2.8%
98
 
2.5%
86
 
2.2%
Other values (249) 2371
60.7%
Latin
ValueCountFrequency (%)
S 75
32.9%
G 69
30.3%
C 33
14.5%
U 32
14.0%
R 7
 
3.1%
K 5
 
2.2%
s 1
 
0.4%
k 1
 
0.4%
B 1
 
0.4%
Y 1
 
0.4%
Other values (3) 3
 
1.3%
Common
ValueCountFrequency (%)
2 182
28.9%
5 156
24.8%
118
18.8%
( 63
 
10.0%
) 62
 
9.9%
4 29
 
4.6%
3 7
 
1.1%
6 6
 
1.0%
1 6
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3909
82.0%
ASCII 857
 
18.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
397
 
10.2%
180
 
4.6%
146
 
3.7%
143
 
3.7%
142
 
3.6%
123
 
3.1%
114
 
2.9%
109
 
2.8%
98
 
2.5%
86
 
2.2%
Other values (249) 2371
60.7%
ASCII
ValueCountFrequency (%)
2 182
21.2%
5 156
18.2%
118
13.8%
S 75
8.8%
G 69
 
8.1%
( 63
 
7.4%
) 62
 
7.2%
C 33
 
3.9%
U 32
 
3.7%
4 29
 
3.4%
Other values (12) 38
 
4.4%
Distinct463
Distinct (%)99.6%
Missing2
Missing (%)0.4%
Memory size3.8 KiB
2023-12-12T19:41:09.201653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length65
Median length53
Mean length35.621505
Min length21

Characters and Unicode

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

Unique

Unique461 ?
Unique (%)99.1%

Sample

1st row인천광역시 서구 염곡로464번길 23, 엔시티타워 108호 (가정동)
2nd row인천광역시 서구 청라라임로 109, 호반베르디움 105,106호 (청라동, 호반베르디움)
3rd row인천광역시 서구 독정로 111, 근린생활시설1동 1,2호 (당하동)
4th row인천광역시 서구 청라에메랄드로76번길 14, 상가동 102,105,106호 (청라동, 호반베르디움)
5th row인천광역시 서구 서곶로 50, 판매3동 B230,231호 (가정동, 루원시티 대성베르힐 더 센트로)
ValueCountFrequency (%)
서구 465
 
14.4%
인천광역시 464
 
14.4%
1층 153
 
4.7%
가좌동 68
 
2.1%
석남동 50
 
1.5%
청라동 43
 
1.3%
마전동 40
 
1.2%
당하동 38
 
1.2%
가정동 36
 
1.1%
101호 35
 
1.1%
Other values (894) 1840
56.9%
2023-12-12T19:41:09.726960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2767
 
16.7%
1 966
 
5.8%
, 603
 
3.6%
586
 
3.5%
514
 
3.1%
501
 
3.0%
495
 
3.0%
480
 
2.9%
475
 
2.9%
472
 
2.8%
Other values (313) 8705
52.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9101
54.9%
Decimal Number 2956
 
17.8%
Space Separator 2767
 
16.7%
Other Punctuation 610
 
3.7%
Close Punctuation 467
 
2.8%
Open Punctuation 467
 
2.8%
Uppercase Letter 96
 
0.6%
Dash Punctuation 53
 
0.3%
Lowercase Letter 41
 
0.2%
Math Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
586
 
6.4%
514
 
5.6%
501
 
5.5%
495
 
5.4%
480
 
5.3%
475
 
5.2%
472
 
5.2%
468
 
5.1%
466
 
5.1%
292
 
3.2%
Other values (274) 4352
47.8%
Uppercase Letter
ValueCountFrequency (%)
B 26
27.1%
K 11
11.5%
E 8
 
8.3%
S 8
 
8.3%
W 7
 
7.3%
L 7
 
7.3%
V 7
 
7.3%
I 7
 
7.3%
A 5
 
5.2%
J 3
 
3.1%
Other values (4) 7
 
7.3%
Decimal Number
ValueCountFrequency (%)
1 966
32.7%
0 425
14.4%
2 359
 
12.1%
3 295
 
10.0%
4 198
 
6.7%
5 166
 
5.6%
8 150
 
5.1%
6 145
 
4.9%
7 143
 
4.8%
9 109
 
3.7%
Lowercase Letter
ValueCountFrequency (%)
e 14
34.1%
a 7
17.1%
r 7
17.1%
s 6
14.6%
d 6
14.6%
t 1
 
2.4%
Other Punctuation
ValueCountFrequency (%)
, 603
98.9%
' 6
 
1.0%
. 1
 
0.2%
Space Separator
ValueCountFrequency (%)
2767
100.0%
Close Punctuation
ValueCountFrequency (%)
) 467
100.0%
Open Punctuation
ValueCountFrequency (%)
( 467
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 53
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%
Letter Number
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9101
54.9%
Common 7324
44.2%
Latin 139
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
586
 
6.4%
514
 
5.6%
501
 
5.5%
495
 
5.4%
480
 
5.3%
475
 
5.2%
472
 
5.2%
468
 
5.1%
466
 
5.1%
292
 
3.2%
Other values (274) 4352
47.8%
Latin
ValueCountFrequency (%)
B 26
18.7%
e 14
 
10.1%
K 11
 
7.9%
E 8
 
5.8%
S 8
 
5.8%
W 7
 
5.0%
L 7
 
5.0%
a 7
 
5.0%
r 7
 
5.0%
V 7
 
5.0%
Other values (11) 37
26.6%
Common
ValueCountFrequency (%)
2767
37.8%
1 966
 
13.2%
, 603
 
8.2%
) 467
 
6.4%
( 467
 
6.4%
0 425
 
5.8%
2 359
 
4.9%
3 295
 
4.0%
4 198
 
2.7%
5 166
 
2.3%
Other values (8) 611
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9101
54.9%
ASCII 7461
45.0%
Number Forms 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2767
37.1%
1 966
 
12.9%
, 603
 
8.1%
) 467
 
6.3%
( 467
 
6.3%
0 425
 
5.7%
2 359
 
4.8%
3 295
 
4.0%
4 198
 
2.7%
5 166
 
2.2%
Other values (28) 748
 
10.0%
Hangul
ValueCountFrequency (%)
586
 
6.4%
514
 
5.6%
501
 
5.5%
495
 
5.4%
480
 
5.3%
475
 
5.2%
472
 
5.2%
468
 
5.1%
466
 
5.1%
292
 
3.2%
Other values (274) 4352
47.8%
Number Forms
ValueCountFrequency (%)
2
100.0%
Distinct374
Distinct (%)80.1%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
Minimum2013-07-26 00:00:00
Maximum2023-10-13 00:00:00
2023-12-12T19:41:09.925931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:41:10.106062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
Minimum2023-10-16 00:00:00
Maximum2023-10-16 00:00:00
2023-12-12T19:41:10.257109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:41:10.383757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T19:41:07.568898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T19:41:07.666784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:41:07.762306image/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

연번판매점포명소재지(도로명)처리일자데이터기준일자
01GS25루원타운점인천광역시 서구 염곡로464번길 23, 엔시티타워 108호 (가정동)2023-10-112023-10-16
12지에스25청라호반1차인천광역시 서구 청라라임로 109, 호반베르디움 105,106호 (청라동, 호반베르디움)2023-09-272023-10-16
23씨유완정본점인천광역시 서구 독정로 111, 근린생활시설1동 1,2호 (당하동)2023-09-212023-10-16
34지에스25청라베르디움인천광역시 서구 청라에메랄드로76번길 14, 상가동 102,105,106호 (청라동, 호반베르디움)2023-09-182023-10-16
45지에스25루원스타인천광역시 서구 서곶로 50, 판매3동 B230,231호 (가정동, 루원시티 대성베르힐 더 센트로)2023-09-132023-10-16
56지에스25마전가현로인천광역시 서구 가현로 109, 1층 (마전동)2023-09-132023-10-16
67씨유가좌중앙인천광역시 서구 원적로57번길 14, 평화상가 1층 (가좌동)2023-09-132023-10-16
78지에스25루원베르힐인천광역시 서구 서곶로 50, 판매1동 A103,104호 (가정동, 루원시티 대성베르힐 더 센트로)2023-09-072023-10-16
89(주)코리아세븐 가정청담프라자점인천광역시 서구 염곡로498번안길 28, 청담프라자 104호 (가정동)2023-08-242023-10-16
910씨유 청라본점인천광역시 서구 에코로 65, 청라국제도시역 푸르지오시티 1층 125,126호 (청라동)2023-08-232023-10-16
연번판매점포명소재지(도로명)처리일자데이터기준일자
457458GS25석남길주점인천광역시 서구 길주로 101 (석남동)2013-08-062023-10-16
458459GS25가정점인천광역시 서구 가정로 388 (가정동)2013-08-062023-10-16
459460세븐일레븐신현주공점인천광역시 서구 원창로 180 (신현동)2013-08-062023-10-16
460461미니스톱인천연희점인천광역시 서구 승학로287번길 2 (연희동)2013-08-052023-10-16
461462지에스(GS)25경서드림점인천광역시 서구 도요지로 21 (경서동)2023-06-022023-10-16
462463GS25검암제일점인천광역시 서구 검암로 21 (검암동)2021-04-212023-10-16
463464세븐일레븐검단마전점<NA>2014-06-052023-10-16
464465세븐일레븐인천검암서해점인천광역시 서구 승학로495번길 1 (검암동)2015-11-242023-10-16
465466CU인천신현점인천광역시 서구 새오개로 67 (신현동)2013-08-012023-10-16
466467CU서구서곶점인천광역시 서구 대평로56번길 17 (연희동)2013-07-262023-10-16