Overview

Dataset statistics

Number of variables4
Number of observations274
Missing cells151
Missing cells (%)13.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.0 KiB
Average record size in memory33.5 B

Variable types

Numeric1
Text3

Dataset

Description부산광역시해운대구_안전상비의약품판매업현황_20221017
Author부산광역시 해운대구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3075597

Alerts

전화번호 has 151 (55.1%) missing valuesMissing
순번 has unique valuesUnique
판매점포명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 17:00:20.026762
Analysis finished2023-12-10 17:00:20.920078
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct274
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean137.5
Minimum1
Maximum274
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.5 KiB
2023-12-11T02:00:21.029469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.65
Q169.25
median137.5
Q3205.75
95-th percentile260.35
Maximum274
Range273
Interquartile range (IQR)136.5

Descriptive statistics

Standard deviation79.241193
Coefficient of variation (CV)0.57629959
Kurtosis-1.2
Mean137.5
Median Absolute Deviation (MAD)68.5
Skewness0
Sum37675
Variance6279.1667
MonotonicityStrictly increasing
2023-12-11T02:00:21.253662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
182 1
 
0.4%
188 1
 
0.4%
187 1
 
0.4%
186 1
 
0.4%
185 1
 
0.4%
184 1
 
0.4%
183 1
 
0.4%
181 1
 
0.4%
207 1
 
0.4%
Other values (264) 264
96.4%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
274 1
0.4%
273 1
0.4%
272 1
0.4%
271 1
0.4%
270 1
0.4%
269 1
0.4%
268 1
0.4%
267 1
0.4%
266 1
0.4%
265 1
0.4%

판매점포명
Text

UNIQUE 

Distinct274
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-11T02:00:21.636918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length11.120438
Min length6

Characters and Unicode

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

Unique

Unique274 ?
Unique (%)100.0%

Sample

1st row씨유 해운대우동롯데점
2nd row미니스톱 부산팔레드시즈점
3rd row(주)코리아세븐 부산반여재반로점
4th rowGS25 반여점
5th row세븐일레븐 해운대월드마크점
ValueCountFrequency (%)
씨유 71
 
14.0%
gs25 48
 
9.5%
세븐일레븐 35
 
6.9%
주)코리아세븐 20
 
3.9%
지에스(gs)25 15
 
3.0%
cu 10
 
2.0%
이마트24 9
 
1.8%
미니스톱 7
 
1.4%
지에스25 6
 
1.2%
재송시영점 2
 
0.4%
Other values (275) 284
56.0%
2023-12-11T02:00:22.277241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 261
 
8.6%
233
 
7.6%
2 101
 
3.3%
븐 94
 
3.1%
씨 93
 
3.1%
유 90
 
3.0%
해 90
 
3.0%
5 85
 
2.8%
운 83
 
2.7%
S 81
 
2.7%
Other values (234) 1836
60.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2337
76.7%
Space Separator 233
 
7.6%
Decimal Number 199
 
6.5%
Uppercase Letter 194
 
6.4%
Open Punctuation 42
 
1.4%
Close Punctuation 42
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 261
 
11.2%
븐 94
 
4.0%
씨 93
 
4.0%
유 90
 
3.9%
해 90
 
3.9%
운 83
 
3.6%
대 75
 
3.2%
스 67
 
2.9%
세 58
 
2.5%
산 55
 
2.4%
Other values (217) 1371
58.7%
Uppercase Letter
ValueCountFrequency (%)
S 81
41.8%
G 77
39.7%
C 15
 
7.7%
U 15
 
7.7%
K 2
 
1.0%
W 1
 
0.5%
I 1
 
0.5%
H 1
 
0.5%
R 1
 
0.5%
Decimal Number
ValueCountFrequency (%)
2 101
50.8%
5 85
42.7%
4 11
 
5.5%
9 1
 
0.5%
1 1
 
0.5%
Space Separator
ValueCountFrequency (%)
233
100.0%
Open Punctuation
ValueCountFrequency (%)
( 42
100.0%
Close Punctuation
ValueCountFrequency (%)
) 42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2337
76.7%
Common 516
 
16.9%
Latin 194
 
6.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 261
 
11.2%
븐 94
 
4.0%
씨 93
 
4.0%
유 90
 
3.9%
해 90
 
3.9%
운 83
 
3.6%
대 75
 
3.2%
스 67
 
2.9%
세 58
 
2.5%
산 55
 
2.4%
Other values (217) 1371
58.7%
Latin
ValueCountFrequency (%)
S 81
41.8%
G 77
39.7%
C 15
 
7.7%
U 15
 
7.7%
K 2
 
1.0%
W 1
 
0.5%
I 1
 
0.5%
H 1
 
0.5%
R 1
 
0.5%
Common
ValueCountFrequency (%)
233
45.2%
2 101
19.6%
5 85
 
16.5%
( 42
 
8.1%
) 42
 
8.1%
4 11
 
2.1%
9 1
 
0.2%
1 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2337
76.7%
ASCII 710
 
23.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 261
 
11.2%
븐 94
 
4.0%
씨 93
 
4.0%
유 90
 
3.9%
해 90
 
3.9%
운 83
 
3.6%
대 75
 
3.2%
스 67
 
2.9%
세 58
 
2.5%
산 55
 
2.4%
Other values (217) 1371
58.7%
ASCII
ValueCountFrequency (%)
233
32.8%
2 101
14.2%
5 85
 
12.0%
S 81
 
11.4%
G 77
 
10.8%
( 42
 
5.9%
) 42
 
5.9%
C 15
 
2.1%
U 15
 
2.1%
4 11
 
1.5%
Other values (7) 8
 
1.1%

전화번호
Text

MISSING 

Distinct123
Distinct (%)100.0%
Missing151
Missing (%)55.1%
Memory size2.3 KiB
2023-12-11T02:00:22.727712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.01626
Min length12

Characters and Unicode

Total characters1478
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

Unique123 ?
Unique (%)100.0%

Sample

1st row051-746-1496
2nd row051-543-0015
3rd row051-532-1708
4th row051-747-3362
5th row051-781-5083
ValueCountFrequency (%)
051-543-6636 1
 
0.8%
051-783-4549 1
 
0.8%
051-744-4587 1
 
0.8%
051-701-3312 1
 
0.8%
051-702-3111 1
 
0.8%
051-746-2921 1
 
0.8%
051-731-4914 1
 
0.8%
051-746-8851 1
 
0.8%
051-747-5508 1
 
0.8%
051-704-2832 1
 
0.8%
Other values (113) 113
91.9%
2023-12-11T02:00:23.398088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 246
16.6%
1 223
15.1%
0 201
13.6%
5 198
13.4%
7 167
11.3%
4 111
7.5%
3 91
 
6.2%
6 69
 
4.7%
2 69
 
4.7%
8 61
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1232
83.4%
Dash Punctuation 246
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 223
18.1%
0 201
16.3%
5 198
16.1%
7 167
13.6%
4 111
9.0%
3 91
7.4%
6 69
 
5.6%
2 69
 
5.6%
8 61
 
5.0%
9 42
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 246
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1478
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 246
16.6%
1 223
15.1%
0 201
13.6%
5 198
13.4%
7 167
11.3%
4 111
7.5%
3 91
 
6.2%
6 69
 
4.7%
2 69
 
4.7%
8 61
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1478
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 246
16.6%
1 223
15.1%
0 201
13.6%
5 198
13.4%
7 167
11.3%
4 111
7.5%
3 91
 
6.2%
6 69
 
4.7%
2 69
 
4.7%
8 61
 
4.1%

소재지(도로명)
Text

Distinct273
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-11T02:00:23.871729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length45
Mean length36.547445
Min length22

Characters and Unicode

Total characters10014
Distinct characters246
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

Unique272 ?
Unique (%)99.3%

Sample

1st row부산광역시 해운대구 해운대로483번길 10, 101호 (우동, 롯데아파트)
2nd row부산광역시 해운대구 해운대해변로298번길 24, 팔레드시즈 상가동 1-31호 (중동)
3rd row부산광역시 해운대구 재반로 208, 1층 (반여동)
4th row부산광역시 해운대구 재반로 257, 엘지25시 (반여동)
5th row부산광역시 해운대구 마린시티1로 137, 대우월드마크해운대 106호 (우동)
ValueCountFrequency (%)
부산광역시 274
 
15.3%
해운대구 274
 
15.3%
우동 70
 
3.9%
중동 55
 
3.1%
1층 51
 
2.8%
좌동 50
 
2.8%
재송동 32
 
1.8%
반여동 32
 
1.8%
101호 26
 
1.4%
해운대로 20
 
1.1%
Other values (535) 911
50.8%
2023-12-11T02:00:24.510672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1521
 
15.2%
1 535
 
5.3%
해 404
 
4.0%
대 400
 
4.0%
운 396
 
4.0%
동 368
 
3.7%
, 327
 
3.3%
시 302
 
3.0%
산 287
 
2.9%
구 285
 
2.8%
Other values (236) 5189
51.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5908
59.0%
Decimal Number 1644
 
16.4%
Space Separator 1521
 
15.2%
Other Punctuation 327
 
3.3%
Close Punctuation 274
 
2.7%
Open Punctuation 274
 
2.7%
Dash Punctuation 42
 
0.4%
Math Symbol 12
 
0.1%
Uppercase Letter 12
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
해 404
 
6.8%
대 400
 
6.8%
운 396
 
6.7%
동 368
 
6.2%
시 302
 
5.1%
산 287
 
4.9%
구 285
 
4.8%
광 278
 
4.7%
부 276
 
4.7%
역 274
 
4.6%
Other values (214) 2638
44.7%
Decimal Number
ValueCountFrequency (%)
1 535
32.5%
0 228
13.9%
2 221
13.4%
3 139
 
8.5%
4 104
 
6.3%
5 93
 
5.7%
7 91
 
5.5%
6 83
 
5.0%
8 81
 
4.9%
9 69
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
A 4
33.3%
C 3
25.0%
E 2
16.7%
P 1
 
8.3%
S 1
 
8.3%
H 1
 
8.3%
Space Separator
ValueCountFrequency (%)
1521
100.0%
Other Punctuation
ValueCountFrequency (%)
, 327
100.0%
Close Punctuation
ValueCountFrequency (%)
) 274
100.0%
Open Punctuation
ValueCountFrequency (%)
( 274
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 42
100.0%
Math Symbol
ValueCountFrequency (%)
~ 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5908
59.0%
Common 4094
40.9%
Latin 12
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
해 404
 
6.8%
대 400
 
6.8%
운 396
 
6.7%
동 368
 
6.2%
시 302
 
5.1%
산 287
 
4.9%
구 285
 
4.8%
광 278
 
4.7%
부 276
 
4.7%
역 274
 
4.6%
Other values (214) 2638
44.7%
Common
ValueCountFrequency (%)
1521
37.2%
1 535
 
13.1%
, 327
 
8.0%
) 274
 
6.7%
( 274
 
6.7%
0 228
 
5.6%
2 221
 
5.4%
3 139
 
3.4%
4 104
 
2.5%
5 93
 
2.3%
Other values (6) 378
 
9.2%
Latin
ValueCountFrequency (%)
A 4
33.3%
C 3
25.0%
E 2
16.7%
P 1
 
8.3%
S 1
 
8.3%
H 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5908
59.0%
ASCII 4106
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1521
37.0%
1 535
 
13.0%
, 327
 
8.0%
) 274
 
6.7%
( 274
 
6.7%
0 228
 
5.6%
2 221
 
5.4%
3 139
 
3.4%
4 104
 
2.5%
5 93
 
2.3%
Other values (12) 390
 
9.5%
Hangul
ValueCountFrequency (%)
해 404
 
6.8%
대 400
 
6.8%
운 396
 
6.7%
동 368
 
6.2%
시 302
 
5.1%
산 287
 
4.9%
구 285
 
4.8%
광 278
 
4.7%
부 276
 
4.7%
역 274
 
4.6%
Other values (214) 2638
44.7%

Interactions

2023-12-11T02:00:20.425252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-11T02:00:20.704973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:00:20.865285image/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씨유 해운대우동롯데점<NA>부산광역시 해운대구 해운대로483번길 10, 101호 (우동, 롯데아파트)
12미니스톱 부산팔레드시즈점<NA>부산광역시 해운대구 해운대해변로298번길 24, 팔레드시즈 상가동 1-31호 (중동)
23(주)코리아세븐 부산반여재반로점<NA>부산광역시 해운대구 재반로 208, 1층 (반여동)
34GS25 반여점<NA>부산광역시 해운대구 재반로 257, 엘지25시 (반여동)
45세븐일레븐 해운대월드마크점<NA>부산광역시 해운대구 마린시티1로 137, 대우월드마크해운대 106호 (우동)
56GS25 해운래미안점<NA>부산광역시 해운대구 좌동순환로412번길 5, 1층 (중동)
67세븐일레븐 반여선수촌2호점<NA>부산광역시 해운대구 선수촌로 122, 븐신싱기1동 101,102호 (반여동, 아시아선수촌아파트)
78씨유 해운대마리안느점<NA>부산광역시 해운대구 해운대해변로 310, 호텔마리안느 1층 (중동)
89(주)코리아세븐 부산꿈에그린점<NA>부산광역시 해운대구 센텀동로 26, 한화꿈에그린센텀 A동 103-A2호 (우동)
910GS25 해운제니스점051-746-1496부산광역시 해운대구 마린시티2로 33, 104동 121호 (우동, 해운대두산위브더제니스)
순번판매점포명전화번호소재지(도로명)
264265GS25 해운대9점051-783-5711부산광역시 해운대구 재반로 208 (반여동)
265266GS25 아델리스점051-742-9948부산광역시 해운대구 마린시티3로 51, 101호 (우동, 아델리스상가)
266267GS25 해운우동점051-742-9457부산광역시 해운대구 중동1로 15-2 (우동)
267268씨유 센텀월드마크점<NA>부산광역시 해운대구 센텀동로 25, 131호 (우동, 센텀월드마크상가)
268269GS25 좌동화목051-704-5575부산광역시 해운대구 대천로 187, 102호 (좌동, 화목상가)
269270GS25 해운제이드051-746-0316부산광역시 해운대구 해운대해변로197번길 18 (우동)
270271GS25 해운온천점051-746-6925부산광역시 해운대구 중동2로 12 (중동)
271272GS2 문탠로드점051-746-2554부산광역시 해운대구 달맞이길62번길 2 (중동)
272273세븐일레븐 재송센트럴시티점070-4412-8987부산광역시 해운대구 재반로 118, 102호 (재송동)
273274세븐일레븐 부산재송제일점<NA>부산광역시 해운대구 재반로 123 (재송동)