Overview

Dataset statistics

Number of variables14
Number of observations23
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.9 KiB
Average record size in memory130.7 B

Variable types

Categorical11
Text1
Numeric2

Dataset

Description대전광역시 서구 행정동별 의약품등 제조업소 및 판매업소 현황(제조업소_의약품, 제조업소_의약외품, 제조업소_화장품, 제조업소_의료기기, 판매업소_약국, 판매업소_한약국, 판매업소_의약품도매상, 판매업소_한약도매상, 판매업소_한약업사, 판매업소_의료기기판매업,판매업소_의료기기입대업, 판매업소_의료기기수리업 ) 데이터입니다.
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15095168/fileData.do

Alerts

기준연도 has constant value ""Constant
제조업소_의약품 has constant value ""Constant
제조업소_의약외품 has constant value ""Constant
제조업소_화장품 has constant value ""Constant
제조업소_의료기기 has constant value ""Constant
판매업소_의료기기판매업 is highly overall correlated with 판매업소_한약업사High correlation
판매업소_한약도매상 is highly overall correlated with 판매업소_한약업사High correlation
판매업소_한약업사 is highly overall correlated with 판매업소_의료기기판매업 and 1 other fieldsHigh correlation
판매업소_의료기기임대업 is highly imbalanced (74.2%)Imbalance
행정동 has unique valuesUnique

Reproduction

Analysis started2023-12-12 16:12:27.802508
Analysis finished2023-12-12 16:12:29.095847
Duration1.29 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준연도
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023
23 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023 23
100.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:29.313680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 23
100.0%

행정동
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2023-12-13T01:12:29.520210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length3.4782609
Min length2

Characters and Unicode

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

Unique

Unique23 ?
Unique (%)100.0%

Sample

1st row복수동
2nd row도마1동
3rd row도마2동
4th row정림동
5th row변동
ValueCountFrequency (%)
복수동 1
 
4.3%
내동 1
 
4.3%
관저2동 1
 
4.3%
관저1동 1
 
4.3%
가수원동 1
 
4.3%
만년동 1
 
4.3%
월평3동 1
 
4.3%
월평2동 1
 
4.3%
월평1동 1
 
4.3%
갈마2동 1
 
4.3%
Other values (13) 13
56.5%
2023-12-13T01:12:29.904268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 23
28.7%
1 5
 
6.2%
2 5
 
6.2%
마 4
 
5.0%
산 3
 
3.8%
둔 3
 
3.8%
평 3
 
3.8%
월 3
 
3.8%
저 2
 
2.5%
갈 2
 
2.5%
Other values (21) 27
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68
85.0%
Decimal Number 12
 
15.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 23
33.8%
마 4
 
5.9%
산 3
 
4.4%
둔 3
 
4.4%
평 3
 
4.4%
월 3
 
4.4%
저 2
 
2.9%
갈 2
 
2.9%
정 2
 
2.9%
수 2
 
2.9%
Other values (18) 21
30.9%
Decimal Number
ValueCountFrequency (%)
1 5
41.7%
2 5
41.7%
3 2
 
16.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68
85.0%
Common 12
 
15.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 23
33.8%
마 4
 
5.9%
산 3
 
4.4%
둔 3
 
4.4%
평 3
 
4.4%
월 3
 
4.4%
저 2
 
2.9%
갈 2
 
2.9%
정 2
 
2.9%
수 2
 
2.9%
Other values (18) 21
30.9%
Common
ValueCountFrequency (%)
1 5
41.7%
2 5
41.7%
3 2
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68
85.0%
ASCII 12
 
15.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 23
33.8%
마 4
 
5.9%
산 3
 
4.4%
둔 3
 
4.4%
평 3
 
4.4%
월 3
 
4.4%
저 2
 
2.9%
갈 2
 
2.9%
정 2
 
2.9%
수 2
 
2.9%
Other values (18) 21
30.9%
ASCII
ValueCountFrequency (%)
1 5
41.7%
2 5
41.7%
3 2
 
16.7%

제조업소_의약품
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
23 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 23
100.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:30.142654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 23
100.0%

제조업소_의약외품
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
23 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 23
100.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:30.351200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 23
100.0%

제조업소_화장품
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
23 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 23
100.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:30.560138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 23
100.0%

제조업소_의료기기
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
23 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 23
100.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:30.775959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 23
100.0%

판매업소_약국
Real number (ℝ)

Distinct14
Distinct (%)60.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10.73913
Minimum2
Maximum44
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size339.0 B
2023-12-13T01:12:30.882719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile3
Q14
median9
Q313
95-th percentile28.9
Maximum44
Range42
Interquartile range (IQR)9

Descriptive statistics

Standard deviation9.8452452
Coefficient of variation (CV)0.91676373
Kurtosis5.4208414
Mean10.73913
Median Absolute Deviation (MAD)5
Skewness2.1551366
Sum247
Variance96.928854
MonotonicityNot monotonic
2023-12-13T01:12:31.022406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
3 4
17.4%
12 2
8.7%
10 2
8.7%
4 2
8.7%
9 2
8.7%
5 2
8.7%
14 2
8.7%
30 1
 
4.3%
19 1
 
4.3%
44 1
 
4.3%
Other values (4) 4
17.4%
ValueCountFrequency (%)
2 1
 
4.3%
3 4
17.4%
4 2
8.7%
5 2
8.7%
6 1
 
4.3%
8 1
 
4.3%
9 2
8.7%
10 2
8.7%
12 2
8.7%
14 2
8.7%
ValueCountFrequency (%)
44 1
4.3%
30 1
4.3%
19 1
4.3%
18 1
4.3%
14 2
8.7%
12 2
8.7%
10 2
8.7%
9 2
8.7%
8 1
4.3%
6 1
4.3%

판매업소_한약국
Categorical

Distinct3
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
16 
2
4 
1
3 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row2
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 16
69.6%
2 4
 
17.4%
1 3
 
13.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:31.293015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 16
69.6%
2 4
 
17.4%
1 3
 
13.0%

판매업소_의약품도매상
Categorical

Distinct4
Distinct (%)17.4%
Missing0
Missing (%)0.0%
Memory size316.0 B
2
8 
1
7 
0
5 
3
3 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row2
3rd row1
4th row2
5th row2

Common Values

ValueCountFrequency (%)
2 8
34.8%
1 7
30.4%
0 5
21.7%
3 3
 
13.0%

Length

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

Common Values (Plot)

2023-12-13T01:12:31.569622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 8
34.8%
1 7
30.4%
0 5
21.7%
3 3
 
13.0%

판매업소_한약도매상
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
18 
1
3 
3
2 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row1
3rd row3
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 18
78.3%
1 3
 
13.0%
3 2
 
8.7%

Length

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

Common Values (Plot)

2023-12-13T01:12:31.778579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 18
78.3%
1 3
 
13.0%
3 2
 
8.7%

판매업소_한약업사
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
18 
1
5 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row1
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 18
78.3%
1 5
 
21.7%

Length

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

Common Values (Plot)

2023-12-13T01:12:32.002195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 18
78.3%
1 5
 
21.7%

판매업소_의료기기판매업
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)78.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.608696
Minimum2
Maximum116
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size339.0 B
2023-12-13T01:12:32.107306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile8.1
Q115
median25
Q356.5
95-th percentile111.4
Maximum116
Range114
Interquartile range (IQR)41.5

Descriptive statistics

Standard deviation31.813004
Coefficient of variation (CV)0.84589489
Kurtosis1.3648648
Mean37.608696
Median Absolute Deviation (MAD)15
Skewness1.3465492
Sum865
Variance1012.0672
MonotonicityNot monotonic
2023-12-13T01:12:32.242349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
20 2
 
8.7%
60 2
 
8.7%
116 2
 
8.7%
25 2
 
8.7%
15 2
 
8.7%
12 1
 
4.3%
30 1
 
4.3%
2 1
 
4.3%
33 1
 
4.3%
53 1
 
4.3%
Other values (8) 8
34.8%
ValueCountFrequency (%)
2 1
4.3%
8 1
4.3%
9 1
4.3%
10 1
4.3%
12 1
4.3%
15 2
8.7%
20 2
8.7%
22 1
4.3%
25 2
8.7%
28 1
4.3%
ValueCountFrequency (%)
116 2
8.7%
70 1
4.3%
65 1
4.3%
60 2
8.7%
53 1
4.3%
51 1
4.3%
33 1
4.3%
30 1
4.3%
28 1
4.3%
25 2
8.7%

판매업소_의료기기임대업
Categorical

IMBALANCE 

Distinct2
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
22 
1
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)4.3%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 22
95.7%
1 1
 
4.3%

Length

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

Common Values (Plot)

2023-12-13T01:12:32.472622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 22
95.7%
1 1
 
4.3%

판매업소_의료기기수리업
Categorical

Distinct4
Distinct (%)17.4%
Missing0
Missing (%)0.0%
Memory size316.0 B
0
11 
1
8 
2
3 
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)4.3%

Sample

1st row0
2nd row1
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 11
47.8%
1 8
34.8%
2 3
 
13.0%
3 1
 
4.3%

Length

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

Common Values (Plot)

2023-12-13T01:12:32.673560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 11
47.8%
1 8
34.8%
2 3
 
13.0%
3 1
 
4.3%

Interactions

2023-12-13T01:12:28.421488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:12:28.234427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:12:28.516599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:12:28.314195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:12:32.752280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동판매업소_약국판매업소_한약국판매업소_의약품도매상판매업소_한약도매상판매업소_한약업사판매업소_의료기기판매업판매업소_의료기기임대업판매업소_의료기기수리업
행정동1.0001.0001.0001.0001.0001.0001.0001.0001.000
판매업소_약국1.0001.0000.3270.4210.4500.0000.5620.0000.603
판매업소_한약국1.0000.3271.0000.0000.4720.2060.5640.0000.000
판매업소_의약품도매상1.0000.4210.0001.0000.0000.5260.1700.2930.609
판매업소_한약도매상1.0000.4500.4720.0001.0000.5090.0000.0000.000
판매업소_한약업사1.0000.0000.2060.5260.5091.0000.7690.0000.000
판매업소_의료기기판매업1.0000.5620.5640.1700.0000.7691.0000.0000.446
판매업소_의료기기임대업1.0000.0000.0000.2930.0000.0000.0001.0000.000
판매업소_의료기기수리업1.0000.6030.0000.6090.0000.0000.4460.0001.000
2023-12-13T01:12:32.885832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
판매업소_의료기기수리업판매업소_한약국판매업소_의약품도매상판매업소_한약도매상판매업소_의료기기임대업판매업소_한약업사
판매업소_의료기기수리업1.0000.0000.2650.0000.0000.000
판매업소_한약국0.0001.0000.0000.1750.0000.323
판매업소_의약품도매상0.2650.0001.0000.0000.1690.332
판매업소_한약도매상0.0000.1750.0001.0000.0000.752
판매업소_의료기기임대업0.0000.0000.1690.0001.0000.000
판매업소_한약업사0.0000.3230.3320.7520.0001.000
2023-12-13T01:12:32.994468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
판매업소_약국판매업소_의료기기판매업판매업소_한약국판매업소_의약품도매상판매업소_한약도매상판매업소_한약업사판매업소_의료기기임대업판매업소_의료기기수리업
판매업소_약국1.0000.4480.1760.2540.2840.0000.0000.411
판매업소_의료기기판매업0.4481.0000.2370.0000.0000.5110.0000.267
판매업소_한약국0.1760.2371.0000.0000.1750.3230.0000.000
판매업소_의약품도매상0.2540.0000.0001.0000.0000.3320.1690.265
판매업소_한약도매상0.2840.0000.1750.0001.0000.7520.0000.000
판매업소_한약업사0.0000.5110.3230.3320.7521.0000.0000.000
판매업소_의료기기임대업0.0000.0000.0000.1690.0000.0001.0000.000
판매업소_의료기기수리업0.4110.2670.0000.2650.0000.0000.0001.000

Missing values

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

기준연도행정동제조업소_의약품제조업소_의약외품제조업소_화장품제조업소_의료기기판매업소_약국판매업소_한약국판매업소_의약품도매상판매업소_한약도매상판매업소_한약업사판매업소_의료기기판매업판매업소_의료기기임대업판매업소_의료기기수리업
02023복수동0000301001200
12023도마1동00001222112501
22023도마2동00001001301000
32023정림동00001002002000
42023변동0000402002200
52023용문동0000303016002
62023탄방동000030020011603
72023둔산1동00001922005100
82023둔산2동000044031111601
92023둔산3동000092100900
기준연도행정동제조업소_의약품제조업소_의약외품제조업소_화장품제조업소_의료기기판매업소_약국판매업소_한약국판매업소_의약품도매상판매업소_한약도매상판매업소_한약업사판매업소_의료기기판매업판매업소_의료기기임대업판매업소_의료기기수리업
132023갈마1동0000802002802
142023갈마2동0000503003002
152023월평1동0000610117000
162023월평2동00001201006001
172023월평3동000030000801
182023만년동0000401005300
192023가수원동00001411003300
202023관저1동00001402001500
212023관저2동00001820002500
222023기성동000020100201