Overview

Dataset statistics

Number of variables6
Number of observations26
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory57.1 B

Variable types

Text1
Numeric4
DateTime1

Dataset

Description충청북도 충주시 기초생활수급자 현황(읍면동, 생계급여, 의료급여, 주거급여, 교육급여, 데이터 기준일)에 관한 데이터
URLhttps://www.data.go.kr/data/15113469/fileData.do

Alerts

데이터기준일 has constant value ""Constant
생계급여 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 생계급여 and 2 other fieldsHigh correlation
교육급여 is highly overall correlated with 생계급여 and 2 other fieldsHigh correlation
읍면동 has unique valuesUnique
의료급여 has unique valuesUnique
주거급여 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:00:52.461108
Analysis finished2023-12-12 21:00:54.488476
Duration2.03 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

읍면동
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-13T06:00:54.615005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length3
Mean length3.6923077
Min length3

Characters and Unicode

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

Unique

Unique26 ?
Unique (%)100.0%

Sample

1st row충주시
2nd row주덕읍
3rd row살미면
4th row수안보면
5th row대소원면
ValueCountFrequency (%)
충주시 1
 
3.8%
주덕읍 1
 
3.8%
연수동 1
 
3.8%
칠금.금릉동 1
 
3.8%
봉방동 1
 
3.8%
달천동 1
 
3.8%
호암.직동 1
 
3.8%
문화동 1
 
3.8%
지현동 1
 
3.8%
용산동 1
 
3.8%
Other values (16) 16
61.5%
2023-12-13T06:00:54.984832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13
 
13.5%
12
 
12.5%
. 5
 
5.2%
3
 
3.1%
3
 
3.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (45) 50
52.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 90
93.8%
Other Punctuation 5
 
5.2%
Decimal Number 1
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
13
 
14.4%
12
 
13.3%
3
 
3.3%
3
 
3.3%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
Other values (43) 47
52.2%
Other Punctuation
ValueCountFrequency (%)
. 5
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 90
93.8%
Common 6
 
6.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
13
 
14.4%
12
 
13.3%
3
 
3.3%
3
 
3.3%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
Other values (43) 47
52.2%
Common
ValueCountFrequency (%)
. 5
83.3%
2 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 90
93.8%
ASCII 6
 
6.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
13
 
14.4%
12
 
13.3%
3
 
3.3%
3
 
3.3%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
2
 
2.2%
Other values (43) 47
52.2%
ASCII
ValueCountFrequency (%)
. 5
83.3%
2 1
 
16.7%

생계급여
Real number (ℝ)

HIGH CORRELATION 

Distinct24
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean309.96154
Minimum79
Maximum2141
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2023-12-13T06:00:55.099346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum79
5-th percentile84.75
Q1109
median199
Q3356.25
95-th percentile606
Maximum2141
Range2062
Interquartile range (IQR)247.25

Descriptive statistics

Standard deviation402.58798
Coefficient of variation (CV)1.298832
Kurtosis18.437755
Mean309.96154
Median Absolute Deviation (MAD)104
Skewness4.0454151
Sum8059
Variance162077.08
MonotonicityNot monotonic
2023-12-13T06:00:55.229099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
164 2
 
7.7%
97 2
 
7.7%
462 1
 
3.8%
648 1
 
3.8%
2141 1
 
3.8%
236 1
 
3.8%
361 1
 
3.8%
148 1
 
3.8%
480 1
 
3.8%
456 1
 
3.8%
Other values (14) 14
53.8%
ValueCountFrequency (%)
79 1
3.8%
83 1
3.8%
90 1
3.8%
93 1
3.8%
97 2
7.7%
100 1
3.8%
136 1
3.8%
145 1
3.8%
148 1
3.8%
164 2
7.7%
ValueCountFrequency (%)
2141 1
3.8%
648 1
3.8%
480 1
3.8%
462 1
3.8%
456 1
3.8%
361 1
3.8%
357 1
3.8%
354 1
3.8%
311 1
3.8%
243 1
3.8%

의료급여
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean273.34615
Minimum58
Maximum1968
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2023-12-13T06:00:55.360616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum58
5-th percentile63.5
Q185.75
median182
Q3303
95-th percentile543.25
Maximum1968
Range1910
Interquartile range (IQR)217.25

Descriptive statistics

Standard deviation374.41046
Coefficient of variation (CV)1.3697301
Kurtosis18.02133
Mean273.34615
Median Absolute Deviation (MAD)102.5
Skewness3.9862467
Sum7107
Variance140183.2
MonotonicityNot monotonic
2023-12-13T06:00:55.478268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
526 1
 
3.8%
183 1
 
3.8%
81 1
 
3.8%
1968 1
 
3.8%
204 1
 
3.8%
311 1
 
3.8%
128 1
 
3.8%
412 1
 
3.8%
428 1
 
3.8%
223 1
 
3.8%
Other values (16) 16
61.5%
ValueCountFrequency (%)
58 1
3.8%
63 1
3.8%
65 1
3.8%
67 1
3.8%
71 1
3.8%
80 1
3.8%
81 1
3.8%
100 1
3.8%
108 1
3.8%
109 1
3.8%
ValueCountFrequency (%)
1968 1
3.8%
549 1
3.8%
526 1
3.8%
428 1
3.8%
412 1
3.8%
311 1
3.8%
309 1
3.8%
285 1
3.8%
269 1
3.8%
223 1
3.8%

주거급여
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean393.07692
Minimum89
Maximum2875
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2023-12-13T06:00:55.629750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum89
5-th percentile91.75
Q1136.25
median232
Q3440.75
95-th percentile864
Maximum2875
Range2786
Interquartile range (IQR)304.5

Descriptive statistics

Standard deviation549.01249
Coefficient of variation (CV)1.396705
Kurtosis17.939406
Mean393.07692
Median Absolute Deviation (MAD)129
Skewness3.9877142
Sum10220
Variance301414.71
MonotonicityNot monotonic
2023-12-13T06:00:55.745893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
140 1
 
3.8%
262 1
 
3.8%
135 1
 
3.8%
2875 1
 
3.8%
422 1
 
3.8%
453 1
 
3.8%
185 1
 
3.8%
648 1
 
3.8%
579 1
 
3.8%
327 1
 
3.8%
Other values (16) 16
61.5%
ValueCountFrequency (%)
89 1
3.8%
91 1
3.8%
94 1
3.8%
102 1
3.8%
104 1
3.8%
106 1
3.8%
135 1
3.8%
140 1
3.8%
143 1
3.8%
160 1
3.8%
ValueCountFrequency (%)
2875 1
3.8%
936 1
3.8%
648 1
3.8%
579 1
3.8%
561 1
3.8%
453 1
3.8%
447 1
3.8%
422 1
3.8%
417 1
3.8%
327 1
3.8%

교육급여
Real number (ℝ)

HIGH CORRELATION 

Distinct22
Distinct (%)84.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58.423077
Minimum3
Maximum326
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size366.0 B
2023-12-13T06:00:55.864476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile5.25
Q110.5
median29
Q383.25
95-th percentile177
Maximum326
Range323
Interquartile range (IQR)72.75

Descriptive statistics

Standard deviation73.153632
Coefficient of variation (CV)1.2521359
Kurtosis6.5347296
Mean58.423077
Median Absolute Deviation (MAD)23.5
Skewness2.3181342
Sum1519
Variance5351.4538
MonotonicityNot monotonic
2023-12-13T06:00:55.974912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
12 3
 
11.5%
8 2
 
7.7%
61 2
 
7.7%
107 1
 
3.8%
27 1
 
3.8%
326 1
 
3.8%
120 1
 
3.8%
6 1
 
3.8%
108 1
 
3.8%
86 1
 
3.8%
Other values (12) 12
46.2%
ValueCountFrequency (%)
3 1
 
3.8%
5 1
 
3.8%
6 1
 
3.8%
7 1
 
3.8%
8 2
7.7%
10 1
 
3.8%
12 3
11.5%
13 1
 
3.8%
26 1
 
3.8%
27 1
 
3.8%
ValueCountFrequency (%)
326 1
3.8%
196 1
3.8%
120 1
3.8%
112 1
3.8%
108 1
3.8%
107 1
3.8%
86 1
3.8%
75 1
3.8%
61 2
7.7%
54 1
3.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
Minimum2022-12-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-13T06:00:56.102042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:56.197091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T06:00:53.898194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:52.660001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.047987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.474036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.979709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:52.754722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.154581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.569325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:54.100556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:52.856019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.269059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.708924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:54.216146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:52.948571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.366275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:00:53.811945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:00:56.289590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동생계급여의료급여주거급여교육급여
읍면동1.0001.0001.0001.0001.000
생계급여1.0001.0000.9930.9170.963
의료급여1.0000.9931.0000.8630.897
주거급여1.0000.9170.8631.0000.878
교육급여1.0000.9630.8970.8781.000
2023-12-13T06:00:56.400211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
생계급여의료급여주거급여교육급여
생계급여1.0000.9800.8800.680
의료급여0.9801.0000.8780.679
주거급여0.8800.8781.0000.855
교육급여0.6800.6790.8551.000

Missing values

2023-12-13T06:00:54.330273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:00:54.451518image/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충주시46252614082022-12-31
1주덕읍216194289312022-12-31
2살미면93588932022-12-31
3수안보면164135202102022-12-31
4대소원면354269447612022-12-31
5신니면1008010252022-12-31
6노은면9063106122022-12-31
7앙성면19618116072022-12-31
8중앙탑면136109281752022-12-31
9금가면79719182022-12-31
읍면동생계급여의료급여주거급여교육급여데이터기준일
16교현2동3573095611072022-12-31
17용산동3112854171122022-12-31
18지현동243223327542022-12-31
19문화동456428579862022-12-31
20호암.직동4804126481082022-12-31
21달천동14812818562022-12-31
22봉방동361311453612022-12-31
23칠금.금릉동2362044221202022-12-31
24연수동2141196828753262022-12-31
25목행.용탄동9781135272022-12-31