Overview

Dataset statistics

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

Variable types

Numeric2
Categorical3
DateTime2

Dataset

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

Alerts

시설종류 has constant value ""Constant
연번 is highly overall correlated with 연도High correlation
연도 is highly overall correlated with 연번High correlation
위반사항 is highly overall correlated with 조치사항High correlation
조치사항 is highly overall correlated with 위반사항High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-23 05:48:17.658264
Analysis finished2024-03-23 05:48:18.871395
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25
Minimum1
Maximum49
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2024-03-23T14:48:18.969581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.4
Q113
median25
Q337
95-th percentile46.6
Maximum49
Range48
Interquartile range (IQR)24

Descriptive statistics

Standard deviation14.28869
Coefficient of variation (CV)0.57154761
Kurtosis-1.2
Mean25
Median Absolute Deviation (MAD)12
Skewness0
Sum1225
Variance204.16667
MonotonicityStrictly increasing
2024-03-23T14:48:19.202507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
1 1
 
2.0%
38 1
 
2.0%
28 1
 
2.0%
29 1
 
2.0%
30 1
 
2.0%
31 1
 
2.0%
32 1
 
2.0%
33 1
 
2.0%
34 1
 
2.0%
35 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
ValueCountFrequency (%)
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%
41 1
2.0%
40 1
2.0%

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)16.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2019.3673
Minimum2016
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2024-03-23T14:48:19.379224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2016
5-th percentile2016
Q12018
median2020
Q32020
95-th percentile2023
Maximum2023
Range7
Interquartile range (IQR)2

Descriptive statistics

Standard deviation2.068553
Coefficient of variation (CV)0.001024357
Kurtosis-0.59889902
Mean2019.3673
Median Absolute Deviation (MAD)1
Skewness-0.16385844
Sum98949
Variance4.2789116
MonotonicityIncreasing
2024-03-23T14:48:19.516951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2020 19
38.8%
2016 8
16.3%
2018 5
 
10.2%
2019 5
 
10.2%
2022 4
 
8.2%
2023 4
 
8.2%
2017 2
 
4.1%
2021 2
 
4.1%
ValueCountFrequency (%)
2016 8
16.3%
2017 2
 
4.1%
2018 5
 
10.2%
2019 5
 
10.2%
2020 19
38.8%
2021 2
 
4.1%
2022 4
 
8.2%
2023 4
 
8.2%
ValueCountFrequency (%)
2023 4
 
8.2%
2022 4
 
8.2%
2021 2
 
4.1%
2020 19
38.8%
2019 5
 
10.2%
2018 5
 
10.2%
2017 2
 
4.1%
2016 8
16.3%

시설종류
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
약국
49 

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 (%)
약국 49
100.0%

Length

2024-03-23T14:48:19.674911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T14:48:20.158644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
약국 49
100.0%

점검일
Date

Distinct33
Distinct (%)67.3%
Missing0
Missing (%)0.0%
Memory size524.0 B
Minimum2016-02-01 00:00:00
Maximum2023-02-14 00:00:00
2024-03-23T14:48:20.299396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:48:20.477438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)

위반사항
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)34.7%
Missing0
Missing (%)0.0%
Memory size524.0 B
무자격자 의약품 판매
10 
유효기간 경과 의약품 약국내 진열 저장
9 
복약지도 미실시
4 
면허대여
4 
유효기간 경과한 의약품 판매
4 
Other values (12)
18 

Length

Max length42
Median length17
Mean length15.408163
Min length4

Unique

Unique9 ?
Unique (%)18.4%

Sample

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

Common Values

ValueCountFrequency (%)
무자격자 의약품 판매 10
20.4%
유효기간 경과 의약품 약국내 진열 저장 9
18.4%
복약지도 미실시 4
 
8.2%
면허대여 4
 
8.2%
유효기간 경과한 의약품 판매 4
 
8.2%
마약류저장시설 점검부를 작성, 비치하지 않았으며 이를 2년간 보존하지 아니함 4
 
8.2%
약사 명찰 미패용 3
 
6.1%
무자격자 의약품 조제 2
 
4.1%
명찰 미착용 1
 
2.0%
무자격자 의약품 판매(2차) 1
 
2.0%
Other values (7) 7
14.3%

Length

2024-03-23T14:48:20.681445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
의약품 30
15.2%
판매 17
 
8.6%
유효기간 15
 
7.6%
무자격자 14
 
7.1%
경과 12
 
6.1%
진열 10
 
5.1%
약국내 9
 
4.6%
저장 9
 
4.6%
비치하지 4
 
2.0%
명찰 4
 
2.0%
Other values (31) 73
37.1%

조치사항
Categorical

HIGH CORRELATION 

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

Length

Max length28
Median length24
Mean length13.142857
Min length2

Unique

Unique12 ?
Unique (%)24.5%

Sample

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

Common Values

ValueCountFrequency (%)
시정명령+고발 8
16.3%
경고 7
14.3%
시정명령 6
12.2%
업무정지 1일에 갈음한 과징금 57만원+고발 4
 
8.2%
자격정지 3개월 의뢰 4
 
8.2%
업무정지 5일에 갈음한 과징금 285만원 부과 3
 
6.1%
업무정지 30일에 갈음한 과징금 1,710만원 부과 3
 
6.1%
업무정지 10일에 갈음한 과징금 570만원 부과 2
 
4.1%
고발+업무정지 1개월 1
 
2.0%
업무정지 5일에 갈음한 과징금 285만원,고발 1
 
2.0%
Other values (10) 10
20.4%

Length

2024-03-23T14:48:20.896295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
업무정지 17
 
12.1%
갈음한 17
 
12.1%
과징금 16
 
11.3%
부과 10
 
7.1%
시정명령+고발 8
 
5.7%
경고 7
 
5.0%
시정명령 6
 
4.3%
1일에 5
 
3.5%
5일에 5
 
3.5%
10일에 4
 
2.8%
Other values (21) 46
32.6%

데이터기준일자
Date

Distinct3
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
Minimum2021-09-07 00:00:00
Maximum2024-02-21 00:00:00
2024-03-23T14:48:21.033884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:48:21.186063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

Interactions

2024-03-23T14:48:18.250416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:48:18.004610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:48:18.402102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T14:48:18.121133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T14:48:21.298469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도점검일위반사항조치사항데이터기준일자
연번1.0000.9370.7870.6620.7770.835
연도0.9371.0001.0000.8580.6891.000
점검일0.7871.0001.0000.9950.9721.000
위반사항0.6620.8580.9951.0000.9290.521
조치사항0.7770.6890.9720.9291.0000.000
데이터기준일자0.8351.0001.0000.5210.0001.000
2024-03-23T14:48:21.450828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조치사항위반사항
조치사항1.0000.584
위반사항0.5841.000
2024-03-23T14:48:21.603133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도위반사항조치사항
연번1.0000.9670.2800.265
연도0.9671.0000.4660.389
위반사항0.2800.4661.0000.584
조치사항0.2650.3890.5841.000

Missing values

2024-03-23T14:48:18.623690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T14:48:18.818208image/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
연번연도시설종류점검일위반사항조치사항데이터기준일자
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
45462023약국2023-02-14약사 명찰 미패용시정명령2024-02-21
46472023약국2022-05-04무자격자 의약품 판매업무정지 5일에 갈음한 과징금 285만원 부과2024-02-21
47482023약국2022-12-02유효기간 경과 의약품 약국내 진열 저장시정명령2024-02-21
48492023약국2022-12-07무자격자 의약품 조제 및 판매업무정지 30일에 갈음한 과징금 1,710만원 부과2024-02-21