Overview

Dataset statistics

Number of variables6
Number of observations41
Missing cells1
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory52.2 B

Variable types

Numeric1
Text3
Categorical2

Dataset

Description강원도 원주시에 위치한 의약품 공급업체에 대한 데이터로 영업소명, 영업소의 소재지, KGSP 적격유무등 다양한 데이터를 제공합니다.
Author강원도 원주시
URLhttps://www.data.go.kr/data/15041798/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
순번 is highly overall correlated with KGSP 적격여부High correlation
KGSP 적격여부 is highly overall correlated with 순번High correlation
영업소전화번호 has 1 (2.4%) missing valuesMissing
순번 has unique valuesUnique
영업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:21:51.035121
Analysis finished2023-12-12 20:21:51.610437
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21
Minimum1
Maximum41
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size501.0 B
2023-12-13T05:21:51.688596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q111
median21
Q331
95-th percentile39
Maximum41
Range40
Interquartile range (IQR)20

Descriptive statistics

Standard deviation11.979149
Coefficient of variation (CV)0.57043565
Kurtosis-1.2
Mean21
Median Absolute Deviation (MAD)10
Skewness0
Sum861
Variance143.5
MonotonicityStrictly increasing
2023-12-13T05:21:51.848268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
1 1
 
2.4%
32 1
 
2.4%
24 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
Other values (31) 31
75.6%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%
32 1
2.4%

영업소명
Text

UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size460.0 B
2023-12-13T05:21:52.107944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length7.4634146
Min length3

Characters and Unicode

Total characters306
Distinct characters79
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique41 ?
Unique (%)100.0%

Sample

1st row주식회사 예로팜
2nd row주식회사 제이제이팜
3rd row(주)소소팜
4th row(주)월드팜코리아
5th row이루다팜
ValueCountFrequency (%)
주식회사 8
 
15.4%
경희학원 1
 
1.9%
가온약품 1
 
1.9%
주)에스씨팜 1
 
1.9%
중원메디팜 1
 
1.9%
의림약업사 1
 
1.9%
주)위너스팜 1
 
1.9%
주)일송메디칼 1
 
1.9%
주)제인팜 1
 
1.9%
주)정수약품 1
 
1.9%
Other values (35) 35
67.3%
2023-12-13T05:21:52.509912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 34
 
11.1%
( 21
 
6.9%
) 21
 
6.9%
약 18
 
5.9%
팜 16
 
5.2%
사 13
 
4.2%
11
 
3.6%
품 10
 
3.3%
식 9
 
2.9%
회 9
 
2.9%
Other values (69) 144
47.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 253
82.7%
Open Punctuation 21
 
6.9%
Close Punctuation 21
 
6.9%
Space Separator 11
 
3.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 34
 
13.4%
약 18
 
7.1%
팜 16
 
6.3%
사 13
 
5.1%
품 10
 
4.0%
식 9
 
3.6%
회 9
 
3.6%
원 9
 
3.6%
이 7
 
2.8%
제 7
 
2.8%
Other values (66) 121
47.8%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Space Separator
ValueCountFrequency (%)
11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 253
82.7%
Common 53
 
17.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 34
 
13.4%
약 18
 
7.1%
팜 16
 
6.3%
사 13
 
5.1%
품 10
 
4.0%
식 9
 
3.6%
회 9
 
3.6%
원 9
 
3.6%
이 7
 
2.8%
제 7
 
2.8%
Other values (66) 121
47.8%
Common
ValueCountFrequency (%)
( 21
39.6%
) 21
39.6%
11
20.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 253
82.7%
ASCII 53
 
17.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 34
 
13.4%
약 18
 
7.1%
팜 16
 
6.3%
사 13
 
5.1%
품 10
 
4.0%
식 9
 
3.6%
회 9
 
3.6%
원 9
 
3.6%
이 7
 
2.8%
제 7
 
2.8%
Other values (66) 121
47.8%
ASCII
ValueCountFrequency (%)
( 21
39.6%
) 21
39.6%
11
20.8%

영업소소재지(도로명)
Text

Distinct37
Distinct (%)90.2%
Missing0
Missing (%)0.0%
Memory size460.0 B
2023-12-13T05:21:52.836677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length30
Mean length25.097561
Min length20

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)85.4%

Sample

1st row강원도 원주시 송삼길 129, 204호 (무실동)
2nd row강원도 원주시 장전길 82, 2층 (태장동)
3rd row강원도 원주시 장전길 82, 2층 (태장동)
4th row강원도 원주시 장전길 82, 2층 (태장동)
5th row강원도 원주시 송삼길 129, 305호 (무실동)
ValueCountFrequency (%)
강원도 41
 
17.4%
원주시 41
 
17.4%
2층 8
 
3.4%
태장동 7
 
3.0%
무실동 7
 
3.0%
판부면 6
 
2.5%
장전길 4
 
1.7%
송삼길 4
 
1.7%
단계동 4
 
1.7%
82 4
 
1.7%
Other values (89) 110
46.6%
2023-12-13T05:21:53.315600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
195
19.0%
원 95
 
9.2%
주 43
 
4.2%
시 42
 
4.1%
강 41
 
4.0%
도 41
 
4.0%
2 37
 
3.6%
1 37
 
3.6%
동 31
 
3.0%
) 30
 
2.9%
Other values (94) 437
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 572
55.6%
Space Separator 195
 
19.0%
Decimal Number 166
 
16.1%
Close Punctuation 30
 
2.9%
Open Punctuation 30
 
2.9%
Other Punctuation 24
 
2.3%
Dash Punctuation 12
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 95
16.6%
주 43
 
7.5%
시 42
 
7.3%
강 41
 
7.2%
도 41
 
7.2%
동 31
 
5.4%
길 27
 
4.7%
층 15
 
2.6%
로 15
 
2.6%
호 11
 
1.9%
Other values (79) 211
36.9%
Decimal Number
ValueCountFrequency (%)
2 37
22.3%
1 37
22.3%
3 18
10.8%
0 15
9.0%
4 14
 
8.4%
5 12
 
7.2%
6 10
 
6.0%
9 10
 
6.0%
8 8
 
4.8%
7 5
 
3.0%
Space Separator
ValueCountFrequency (%)
195
100.0%
Close Punctuation
ValueCountFrequency (%)
) 30
100.0%
Open Punctuation
ValueCountFrequency (%)
( 30
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 572
55.6%
Common 457
44.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 95
16.6%
주 43
 
7.5%
시 42
 
7.3%
강 41
 
7.2%
도 41
 
7.2%
동 31
 
5.4%
길 27
 
4.7%
층 15
 
2.6%
로 15
 
2.6%
호 11
 
1.9%
Other values (79) 211
36.9%
Common
ValueCountFrequency (%)
195
42.7%
2 37
 
8.1%
1 37
 
8.1%
) 30
 
6.6%
( 30
 
6.6%
, 24
 
5.3%
3 18
 
3.9%
0 15
 
3.3%
4 14
 
3.1%
- 12
 
2.6%
Other values (5) 45
 
9.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 572
55.6%
ASCII 457
44.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
195
42.7%
2 37
 
8.1%
1 37
 
8.1%
) 30
 
6.6%
( 30
 
6.6%
, 24
 
5.3%
3 18
 
3.9%
0 15
 
3.3%
4 14
 
3.1%
- 12
 
2.6%
Other values (5) 45
 
9.8%
Hangul
ValueCountFrequency (%)
원 95
16.6%
주 43
 
7.5%
시 42
 
7.3%
강 41
 
7.2%
도 41
 
7.2%
동 31
 
5.4%
길 27
 
4.7%
층 15
 
2.6%
로 15
 
2.6%
호 11
 
1.9%
Other values (79) 211
36.9%

영업소전화번호
Text

MISSING 

Distinct39
Distinct (%)97.5%
Missing1
Missing (%)2.4%
Memory size460.0 B
2023-12-13T05:21:53.582078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.025
Min length12

Characters and Unicode

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

Unique38 ?
Unique (%)95.0%

Sample

1st row033-762-4950
2nd row033-900-7272
3rd row033-900-4377
4th row033-900-5252
5th row033-761-0301
ValueCountFrequency (%)
033-766-1420 2
 
5.0%
033-762-4950 1
 
2.5%
033-763-4411 1
 
2.5%
033-743-2151 1
 
2.5%
033-748-3997 1
 
2.5%
033-765-1192 1
 
2.5%
033-762-8997 1
 
2.5%
033-744-1610 1
 
2.5%
033-764-0076 1
 
2.5%
033-764-4491 1
 
2.5%
Other values (29) 29
72.5%
2023-12-13T05:21:54.012001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 104
21.6%
- 80
16.6%
0 78
16.2%
7 52
10.8%
6 27
 
5.6%
4 27
 
5.6%
1 26
 
5.4%
5 24
 
5.0%
2 23
 
4.8%
9 20
 
4.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 401
83.4%
Dash Punctuation 80
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 104
25.9%
0 78
19.5%
7 52
13.0%
6 27
 
6.7%
4 27
 
6.7%
1 26
 
6.5%
5 24
 
6.0%
2 23
 
5.7%
9 20
 
5.0%
8 20
 
5.0%
Dash Punctuation
ValueCountFrequency (%)
- 80
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 481
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 104
21.6%
- 80
16.6%
0 78
16.2%
7 52
10.8%
6 27
 
5.6%
4 27
 
5.6%
1 26
 
5.4%
5 24
 
5.0%
2 23
 
4.8%
9 20
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 481
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 104
21.6%
- 80
16.6%
0 78
16.2%
7 52
10.8%
6 27
 
5.6%
4 27
 
5.6%
1 26
 
5.4%
5 24
 
5.0%
2 23
 
4.8%
9 20
 
4.2%

KGSP 적격여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size460.0 B
<NA>
25 
KGSP 적격업소
16 

Length

Max length9
Median length4
Mean length5.9512195
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th rowKGSP 적격업소
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 25
61.0%
KGSP 적격업소 16
39.0%

Length

2023-12-13T05:21:54.221822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:21:54.400378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 25
43.9%
kgsp 16
28.1%
적격업소 16
28.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size460.0 B
2023-02-02
41 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-02-02
2nd row2023-02-02
3rd row2023-02-02
4th row2023-02-02
5th row2023-02-02

Common Values

ValueCountFrequency (%)
2023-02-02 41
100.0%

Length

2023-12-13T05:21:54.568042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:21:54.702135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-02-02 41
100.0%

Interactions

2023-12-13T05:21:51.301268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:21:54.792191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업소명영업소소재지(도로명)영업소전화번호
순번1.0001.0000.9250.932
영업소명1.0001.0001.0001.000
영업소소재지(도로명)0.9251.0001.0001.000
영업소전화번호0.9321.0001.0001.000
2023-12-13T05:21:54.909767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번KGSP 적격여부
순번1.0001.000
KGSP 적격여부1.0001.000

Missing values

2023-12-13T05:21:51.437898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:21:51.558469image/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

순번영업소명영업소소재지(도로명)영업소전화번호KGSP 적격여부데이터기준일자
01주식회사 예로팜강원도 원주시 송삼길 129, 204호 (무실동)033-762-4950<NA>2023-02-02
12주식회사 제이제이팜강원도 원주시 장전길 82, 2층 (태장동)033-900-7272<NA>2023-02-02
23(주)소소팜강원도 원주시 장전길 82, 2층 (태장동)033-900-4377<NA>2023-02-02
34(주)월드팜코리아강원도 원주시 장전길 82, 2층 (태장동)033-900-5252KGSP 적격업소2023-02-02
45이루다팜강원도 원주시 송삼길 129, 305호 (무실동)033-761-0301<NA>2023-02-02
56주식회사 나우리강원도 원주시 송삼길 129, 208호 (무실동)033-764-3003<NA>2023-02-02
67주식회사 세준약품강원도 원주시 판부면 오성마을길 43-10, 101호033-763-2008<NA>2023-02-02
78와이디메디칼강원도 원주시 서원대로 117, 2층 (단계동)<NA><NA>2023-02-02
89라온약품강원도 원주시 양지로 80, 6층 506호 (반곡동)033-732-1232<NA>2023-02-02
910(주)예일메디칼강원도 원주시 예술관길 13, 상가동 202호 (명륜동, 원주 삼성아파트)070-5056-3939<NA>2023-02-02
순번영업소명영업소소재지(도로명)영업소전화번호KGSP 적격여부데이터기준일자
3132(주)케이씨팜강원도 원주시 일산로 61, 2층 (원동)033-764-6900KGSP 적격업소2023-02-02
3233(주)동원약품 원주지점강원도 원주시 판부면 용수골길 138033-745-0508KGSP 적격업소2023-02-02
3334(주)드림팜강원도 원주시 시청로 33-1 (무실동)033-735-8555KGSP 적격업소2023-02-02
3435백제약품(주)원주지점강원도 원주시 판부면 오성마을길 61033-810-0103KGSP 적격업소2023-02-02
3536동양약품(주)강원도 원주시 평원초교길 2 (단계동)033-747-4003KGSP 적격업소2023-02-02
3637삼아제약(주)강원도 원주시 문막읍 동화공단로 49033-769-8530KGSP 적격업소2023-02-02
3738(주)제일약업강원도 원주시 평원안길 16 (평원동)033-742-3883<NA>2023-02-02
3839영진한약도매업사강원도 원주시 중앙로 164 (중앙동)033-742-0058<NA>2023-02-02
3940원주약업사강원도 원주시 개봉교길 13 (개운동)033-764-4491<NA>2023-02-02
4041천일약업사강원도 원주시 북원로2425번길 75 (우산동)033-748-1809<NA>2023-02-02