Overview

Dataset statistics

Number of variables7
Number of observations36
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory63.7 B

Variable types

Categorical4
Numeric3

Dataset

Description가평군은 노인인구 증가율이 높아 심뇌혈관질환(고혈압, 당뇨병 등) 등 만성질환 환자가 증가하고 있습니다. 환자의 지속적 투약 및 관리가 이루어질 수 있도록 가평군은 65세 이상 고혈압, 당뇨 질환 보유자에게 약제비를 지원하고 있습니다. 해당 데이터는 읍면동을 기준으로 해당 기간에 약제비를 지원한 금액과 지원받은 총 인원 현황 데이터 입니다. (*노인약제비지원시스템을 이용하여 데이터를 산출하였습니다)
URLhttps://www.data.go.kr/data/15117974/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
기준연도 has constant value ""Constant
총청구액 is highly overall correlated with 총사용인원 and 1 other fieldsHigh correlation
총사용인원 is highly overall correlated with 총청구액 and 1 other fieldsHigh correlation
읍면동명 is highly overall correlated with 총청구액 and 1 other fieldsHigh correlation
총사용인원 has unique valuesUnique
총청구액 has 12 (33.3%) zerosZeros

Reproduction

Analysis started2023-12-12 20:50:02.456459
Analysis finished2023-12-12 20:50:04.210244
Duration1.75 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
경기도
36 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 36
100.0%

Length

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

Common Values (Plot)

2023-12-13T05:50:04.377295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 36
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
가평군
36 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평군
2nd row가평군
3rd row가평군
4th row가평군
5th row가평군

Common Values

ValueCountFrequency (%)
가평군 36
100.0%

Length

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

Common Values (Plot)

2023-12-13T05:50:04.607697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평군 36
100.0%

읍면동명
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
가평읍
6 
설악면
6 
청평면
6 
상면
6 
조종면
6 

Length

Max length3
Median length3
Mean length2.6666667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평읍
2nd row가평읍
3rd row가평읍
4th row가평읍
5th row가평읍

Common Values

ValueCountFrequency (%)
가평읍 6
16.7%
설악면 6
16.7%
청평면 6
16.7%
상면 6
16.7%
조종면 6
16.7%
북면 6
16.7%

Length

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

Common Values (Plot)

2023-12-13T05:50:04.824446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평읍 6
16.7%
설악면 6
16.7%
청평면 6
16.7%
상면 6
16.7%
조종면 6
16.7%
북면 6
16.7%

기준연도
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023
36 

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 36
100.0%

Length

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

Common Values (Plot)

2023-12-13T05:50:05.082326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 36
100.0%

기준월
Real number (ℝ)

Distinct6
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.5
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-13T05:50:05.171430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3.5
Q35
95-th percentile6
Maximum6
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7320508
Coefficient of variation (CV)0.49487166
Kurtosis-1.2770053
Mean3.5
Median Absolute Deviation (MAD)1.5
Skewness0
Sum126
Variance3
MonotonicityNot monotonic
2023-12-13T05:50:05.276020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
1 6
16.7%
2 6
16.7%
3 6
16.7%
4 6
16.7%
5 6
16.7%
6 6
16.7%
ValueCountFrequency (%)
1 6
16.7%
2 6
16.7%
3 6
16.7%
4 6
16.7%
5 6
16.7%
6 6
16.7%
ValueCountFrequency (%)
6 6
16.7%
5 6
16.7%
4 6
16.7%
3 6
16.7%
2 6
16.7%
1 6
16.7%

총청구액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct25
Distinct (%)69.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10935917
Minimum0
Maximum27016460
Zeros12
Zeros (%)33.3%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-13T05:50:05.407843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median10440120
Q318329272
95-th percentile26756740
Maximum27016460
Range27016460
Interquartile range (IQR)18329272

Descriptive statistics

Standard deviation9570896.8
Coefficient of variation (CV)0.87518009
Kurtosis-1.1584017
Mean10935917
Median Absolute Deviation (MAD)9429220
Skewness0.28926474
Sum3.9369301 × 108
Variance9.1602065 × 1013
MonotonicityNot monotonic
2023-12-13T05:50:05.541086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
0 12
33.3%
25668560 1
 
2.8%
25363610 1
 
2.8%
12140420 1
 
2.8%
12657470 1
 
2.8%
12024820 1
 
2.8%
12280310 1
 
2.8%
11718140 1
 
2.8%
11790450 1
 
2.8%
18383250 1
 
2.8%
Other values (15) 15
41.7%
ValueCountFrequency (%)
0 12
33.3%
8718000 1
 
2.8%
8879400 1
 
2.8%
8906500 1
 
2.8%
8958400 1
 
2.8%
9023800 1
 
2.8%
9162100 1
 
2.8%
11718140 1
 
2.8%
11790450 1
 
2.8%
12024820 1
 
2.8%
ValueCountFrequency (%)
27016460 1
2.8%
26785870 1
2.8%
26747030 1
2.8%
25967800 1
2.8%
25668560 1
2.8%
25363610 1
2.8%
18858440 1
2.8%
18479660 1
2.8%
18383250 1
2.8%
18311280 1
2.8%

총사용인원
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1024.1667
Minimum545
Maximum1876
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-13T05:50:05.688226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum545
5-th percentile569.25
Q1719.75
median829
Q31393.75
95-th percentile1848.5
Maximum1876
Range1331
Interquartile range (IQR)674

Descriptive statistics

Standard deviation446.24161
Coefficient of variation (CV)0.4357119
Kurtosis-0.76262276
Mean1024.1667
Median Absolute Deviation (MAD)182.5
Skewness0.8683349
Sum36870
Variance199131.57
MonotonicityNot monotonic
2023-12-13T05:50:05.820587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
1783 1
 
2.8%
707 1
 
2.8%
698 1
 
2.8%
723 1
 
2.8%
710 1
 
2.8%
770 1
 
2.8%
773 1
 
2.8%
799 1
 
2.8%
785 1
 
2.8%
823 1
 
2.8%
Other values (26) 26
72.2%
ValueCountFrequency (%)
545 1
2.8%
558 1
2.8%
573 1
2.8%
576 1
2.8%
583 1
2.8%
595 1
2.8%
698 1
2.8%
707 1
2.8%
710 1
2.8%
723 1
2.8%
ValueCountFrequency (%)
1876 1
2.8%
1859 1
2.8%
1845 1
2.8%
1816 1
2.8%
1783 1
2.8%
1767 1
2.8%
1415 1
2.8%
1403 1
2.8%
1402 1
2.8%
1391 1
2.8%

Interactions

2023-12-13T05:50:03.322545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:02.648869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:02.981797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:03.772086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:02.756103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:03.094609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:03.883257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:02.873514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:50:03.206283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:50:05.906886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동명기준월총청구액총사용인원
읍면동명1.0000.0001.0000.969
기준월0.0001.0000.0000.000
총청구액1.0000.0001.0000.989
총사용인원0.9690.0000.9891.000
2023-12-13T05:50:05.989769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준월총청구액총사용인원읍면동명
기준월1.0000.0560.0750.000
총청구액0.0561.0000.9230.984
총사용인원0.0750.9231.0000.955
읍면동명0.0000.9840.9551.000

Missing values

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

시도명시군구명읍면동명기준연도기준월총청구액총사용인원
0경기도가평군가평읍20231256685601783
1경기도가평군가평읍20232253636101767
2경기도가평군가평읍20233267470301859
3경기도가평군가평읍20234259678001816
4경기도가평군가평읍20235270164601876
5경기도가평군가평읍20236267858701845
6경기도가평군설악면202319023800854
7경기도가평군설악면202328718000835
8경기도가평군설악면202338958400858
9경기도가평군설악면202348879400836
시도명시군구명읍면동명기준연도기준월총청구액총사용인원
26경기도가평군조종면2023312280310799
27경기도가평군조종면2023412024820785
28경기도가평군조종면2023512657470823
29경기도가평군조종면2023612140420789
30경기도가평군북면202310558
31경기도가평군북면202320545
32경기도가평군북면202330595
33경기도가평군북면202340573
34경기도가평군북면202350583
35경기도가평군북면202360576