Overview

Dataset statistics

Number of variables7
Number of observations45
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory60.9 B

Variable types

Numeric2
Categorical4
DateTime1

Dataset

Description남동구 연도별 약국 지도점검 결과 현황 데이터를 연번,연도,시설종류,점검일,위반사항,조치사항,데이터기준일자 등으로 제공합니다.
Author인천광역시 남동구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15087425&srcSe=7661IVAWM27C61E190

Alerts

시설종류 has constant value ""Constant
연번 is highly overall correlated with 연도 and 1 other fieldsHigh correlation
연도 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
위반사항 is highly overall correlated with 연도 and 2 other fieldsHigh correlation
조치사항 is highly overall correlated with 위반사항High correlation
데이터기준일자 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
데이터기준일자 is highly imbalanced (56.7%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-18 05:56:54.022330
Analysis finished2024-03-18 05:56:54.998711
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23
Minimum1
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2024-03-18T14:56:55.082097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.2
Q112
median23
Q334
95-th percentile42.8
Maximum45
Range44
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.133926
Coefficient of variation (CV)0.57104024
Kurtosis-1.2
Mean23
Median Absolute Deviation (MAD)11
Skewness0
Sum1035
Variance172.5
MonotonicityStrictly increasing
2024-03-18T14:56:55.248499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
1 1
 
2.2%
35 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
36 1
2.2%

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)15.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2019.0444
Minimum2016
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2024-03-18T14:56:55.361217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2016
5-th percentile2016
Q12018
median2020
Q32020
95-th percentile2022
Maximum2022
Range6
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.8334711
Coefficient of variation (CV)0.00090808851
Kurtosis-0.72989836
Mean2019.0444
Median Absolute Deviation (MAD)1
Skewness-0.4388608
Sum90857
Variance3.3616162
MonotonicityIncreasing
2024-03-18T14:56:55.781679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
2020 19
42.2%
2016 8
17.8%
2018 5
 
11.1%
2019 5
 
11.1%
2022 4
 
8.9%
2017 2
 
4.4%
2021 2
 
4.4%
ValueCountFrequency (%)
2016 8
17.8%
2017 2
 
4.4%
2018 5
 
11.1%
2019 5
 
11.1%
2020 19
42.2%
2021 2
 
4.4%
2022 4
 
8.9%
ValueCountFrequency (%)
2022 4
 
8.9%
2021 2
 
4.4%
2020 19
42.2%
2019 5
 
11.1%
2018 5
 
11.1%
2017 2
 
4.4%
2016 8
17.8%

시설종류
Categorical

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size492.0 B
약국
45 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row약국
2nd row약국
3rd row약국
4th row약국
5th row약국

Common Values

ValueCountFrequency (%)
약국 45
100.0%

Length

2024-03-18T14:56:55.930495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T14:56:56.050663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 45
100.0%

점검일
Date

Distinct29
Distinct (%)64.4%
Missing0
Missing (%)0.0%
Memory size492.0 B
Minimum2016-02-01 00:00:00
Maximum2022-10-26 00:00:00
2024-03-18T14:56:56.167820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T14:56:56.319940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)

위반사항
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)35.6%
Missing0
Missing (%)0.0%
Memory size492.0 B
무자격자 의약품 판매
9 
유효기간 경과 의약품 약국내 진열 저장
8 
복약지도 미실시
4 
면허대여
4 
마약류저장시설 점검부를 작성, 비치하지 않았으며 이를 2년간 보존하지 아니함
4 
Other values (11)
16 

Length

Max length42
Median length17
Mean length15.511111
Min length4

Unique

Unique8 ?
Unique (%)17.8%

Sample

1st row복약지도 미실시
2nd row무자격자 의약품 판매
3rd row무자격자 의약품 판매(2차)
4th row불특정 다수인에게 경품류 제공
5th row면허대여

Common Values

ValueCountFrequency (%)
무자격자 의약품 판매 9
20.0%
유효기간 경과 의약품 약국내 진열 저장 8
17.8%
복약지도 미실시 4
8.9%
면허대여 4
8.9%
마약류저장시설 점검부를 작성, 비치하지 않았으며 이를 2년간 보존하지 아니함 4
8.9%
유효기간 경과한 의약품 판매 4
8.9%
무자격자 의약품 조제 2
 
4.4%
약사 명찰 미패용 2
 
4.4%
무자격자 의약품 판매(2차) 1
 
2.2%
불특정 다수인에게 경품류 제공 1
 
2.2%
Other values (6) 6
13.3%

Length

2024-03-18T14:56:56.480892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
의약품 27
 
15.0%
판매 15
 
8.3%
유효기간 14
 
7.8%
무자격자 12
 
6.7%
경과 11
 
6.1%
진열 9
 
5.0%
약국내 8
 
4.4%
저장 8
 
4.4%
비치하지 4
 
2.2%
아니함 4
 
2.2%
Other values (30) 68
37.8%

조치사항
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)44.4%
Missing0
Missing (%)0.0%
Memory size492.0 B
시정명령, 고발
8 
경고
7 
업무정지 1일에 갈음한 과징금 57만원, 고발
4 
자격정지 3개월 의뢰
4 
시정명령
4 
Other values (15)
18 

Length

Max length28
Median length25
Mean length13.422222
Min length2

Unique

Unique12 ?
Unique (%)26.7%

Sample

1st row경고, 과태료
2nd row고발, 업무정지 10일
3rd row고발, 업무정지 1개월
4th row고발, 업무정지 3일
5th row자격정지 3개월 의뢰

Common Values

ValueCountFrequency (%)
시정명령, 고발 8
17.8%
경고 7
15.6%
업무정지 1일에 갈음한 과징금 57만원, 고발 4
 
8.9%
자격정지 3개월 의뢰 4
 
8.9%
시정명령 4
 
8.9%
업무정지 5일에 갈음한 과징금 285만원 부과 2
 
4.4%
업무정지 10일에 갈음한 과징금 570만원 부과 2
 
4.4%
업무정지 30일에 갈음한 과징금 1,710만원 부과 2
 
4.4%
고발, 업무정지 1개월 1
 
2.2%
업무정지 5일에 갈음한 과징금 285만원,고발 1
 
2.2%
Other values (10) 10
22.2%

Length

2024-03-18T14:56:56.654743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고발 18
12.2%
업무정지 18
12.2%
갈음한 15
 
10.1%
과징금 14
 
9.5%
시정명령 13
 
8.8%
경고 9
 
6.1%
부과 8
 
5.4%
1일에 5
 
3.4%
57만원 5
 
3.4%
570만원 4
 
2.7%
Other values (15) 39
26.4%

데이터기준일자
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size492.0 B
2021-09-07
41 
2023-03-16
 
4

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-09-07
2nd row2021-09-07
3rd row2021-09-07
4th row2021-09-07
5th row2021-09-07

Common Values

ValueCountFrequency (%)
2021-09-07 41
91.1%
2023-03-16 4
 
8.9%

Length

2024-03-18T14:56:56.808908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T14:56:56.925170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-09-07 41
91.1%
2023-03-16 4
 
8.9%

Interactions

2024-03-18T14:56:54.580706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T14:56:54.381856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T14:56:54.677229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T14:56:54.479964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T14:56:57.018454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도점검일위반사항조치사항데이터기준일자
연번1.0000.8820.7690.6980.7770.971
연도0.8821.0001.0000.8210.7911.000
점검일0.7691.0001.0000.9940.9721.000
위반사항0.6980.8210.9941.0000.9420.807
조치사항0.7770.7910.9720.9421.0000.000
데이터기준일자0.9711.0001.0000.8070.0001.000
2024-03-18T14:56:57.142437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위반사항조치사항데이터기준일자
위반사항1.0000.6050.537
조치사항0.6051.0000.000
데이터기준일자0.5370.0001.000
2024-03-18T14:56:57.258646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도위반사항조치사항데이터기준일자
연번1.0000.9570.2750.2720.768
연도0.9571.0000.5280.4690.940
위반사항0.2750.5281.0000.6050.537
조치사항0.2720.4690.6051.0000.000
데이터기준일자0.7680.9400.5370.0001.000

Missing values

2024-03-18T14:56:54.827785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T14:56:54.949272image/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

연번연도시설종류점검일위반사항조치사항데이터기준일자
012016약국2016-02-01복약지도 미실시경고, 과태료2021-09-07
122016약국2016-05-04무자격자 의약품 판매고발, 업무정지 10일2021-09-07
232016약국2016-06-09무자격자 의약품 판매(2차)고발, 업무정지 1개월2021-09-07
342016약국2016-05-20불특정 다수인에게 경품류 제공고발, 업무정지 3일2021-09-07
452016약국2016-02-04면허대여자격정지 3개월 의뢰2021-09-07
562016약국2016-02-05면허대여자격정지 3개월 의뢰2021-09-07
672016약국2016-05-17면허대여자격정지 3개월 의뢰2021-09-07
782016약국2016-05-17면허대여자격정지 3개월 의뢰2021-09-07
892017약국2017-02-14복약지도 미실시경고, 과태료 30만원 부과2021-09-07
9102017약국2017-08-30유통기한 경과 의약품 진열시정명령2021-09-07
연번연도시설종류점검일위반사항조치사항데이터기준일자
35362020약국2020-04-17유효기간 경과 의약품 약국내 진열 저장시정명령, 고발2021-09-07
36372020약국2020-05-19유효기간 경과 의약품 약국내 진열 저장시정명령, 고발2021-09-07
37382020약국2020-07-10무자격자 의약품 판매업무정지 5일에 갈음한 과징금 285만원,고발2021-09-07
38392020약국2020-08-31복약지도 미실시경고2021-09-07
39402021약국2021-02-01무자격자 의약품 판매업무정지 10일에 갈음한 과징금 570만원 부과2021-09-07
40412021약국2021-03-03무자격자 의약품 조제업무정지 30일에 갈음한 과징금 1,710만원 부과2021-09-07
41422022약국2022-01-14무자격자 의약품 조제업무정지 30일에 갈음한 과징금 1,710만원 부과2023-03-16
42432022약국2022-02-14유효기간 경과 의약품 약국내 진열 저장시정명령, 고발2023-03-16
43442022약국2022-10-24약사 명찰 미패용시정명령2023-03-16
44452022약국2022-10-26약사 명찰 미패용시정명령2023-03-16