Overview

Dataset statistics

Number of variables8
Number of observations21
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory75.3 B

Variable types

Numeric2
Categorical4
Text1
DateTime1

Dataset

Description광주광역시 광산구내 의료급여수급자이면서 장애등록이 있는 대상자가 필요시 신청하여 지급받은 전동보조기기 동별 현황
Author광주광역시 광산구
URLhttps://www.data.go.kr/data/15102997/fileData.do

Alerts

시군구 has constant value ""Constant
데이터기준일자 has constant value ""Constant
2019년 is highly overall correlated with 2020년 and 2 other fieldsHigh correlation
2020년 is highly overall correlated with 2019년 and 2 other fieldsHigh correlation
2021년 is highly overall correlated with 2019년 and 2 other fieldsHigh correlation
2022년 is highly overall correlated with 2019년 and 2 other fieldsHigh correlation
연번 has unique valuesUnique
행정동명 has unique valuesUnique
2019년 has 9 (42.9%) zerosZeros

Reproduction

Analysis started2023-12-12 13:34:25.386948
Analysis finished2023-12-12 13:34:26.314676
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11
Minimum1
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-12T22:34:26.369258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median11
Q316
95-th percentile20
Maximum21
Range20
Interquartile range (IQR)10

Descriptive statistics

Standard deviation6.2048368
Coefficient of variation (CV)0.56407607
Kurtosis-1.2
Mean11
Median Absolute Deviation (MAD)5
Skewness0
Sum231
Variance38.5
MonotonicityStrictly increasing
2023-12-12T22:34:26.511793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1 1
 
4.8%
2 1
 
4.8%
21 1
 
4.8%
20 1
 
4.8%
19 1
 
4.8%
18 1
 
4.8%
17 1
 
4.8%
16 1
 
4.8%
15 1
 
4.8%
14 1
 
4.8%
Other values (11) 11
52.4%
ValueCountFrequency (%)
1 1
4.8%
2 1
4.8%
3 1
4.8%
4 1
4.8%
5 1
4.8%
6 1
4.8%
7 1
4.8%
8 1
4.8%
9 1
4.8%
10 1
4.8%
ValueCountFrequency (%)
21 1
4.8%
20 1
4.8%
19 1
4.8%
18 1
4.8%
17 1
4.8%
16 1
4.8%
15 1
4.8%
14 1
4.8%
13 1
4.8%
12 1
4.8%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
광주광역시 광산구
21 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주광역시 광산구
2nd row광주광역시 광산구
3rd row광주광역시 광산구
4th row광주광역시 광산구
5th row광주광역시 광산구

Common Values

ValueCountFrequency (%)
광주광역시 광산구 21
100.0%

Length

2023-12-12T22:34:26.674212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:34:26.780102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시 21
50.0%
광산구 21
50.0%

행정동명
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-12T22:34:26.943709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.2380952
Min length2

Characters and Unicode

Total characters68
Distinct characters30
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

Unique21 ?
Unique (%)100.0%

Sample

1st row송정1동
2nd row송정2동
3rd row도산동
4th row신흥동
5th row어룡동
ValueCountFrequency (%)
송정1동 1
 
4.8%
첨단2동 1
 
4.8%
삼도동 1
 
4.8%
동곡동 1
 
4.8%
임곡동 1
 
4.8%
평동 1
 
4.8%
신창동 1
 
4.8%
신가동 1
 
4.8%
수완동 1
 
4.8%
비아동 1
 
4.8%
Other values (11) 11
52.4%
2023-12-12T22:34:27.692019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 22
32.4%
곡 4
 
5.9%
1 3
 
4.4%
2 3
 
4.4%
신 3
 
4.4%
송 2
 
2.9%
월 2
 
2.9%
단 2
 
2.9%
첨 2
 
2.9%
정 2
 
2.9%
Other values (20) 23
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 62
91.2%
Decimal Number 6
 
8.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 22
35.5%
곡 4
 
6.5%
신 3
 
4.8%
송 2
 
3.2%
월 2
 
3.2%
단 2
 
3.2%
첨 2
 
3.2%
정 2
 
3.2%
남 2
 
3.2%
산 2
 
3.2%
Other values (18) 19
30.6%
Decimal Number
ValueCountFrequency (%)
1 3
50.0%
2 3
50.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 62
91.2%
Common 6
 
8.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 22
35.5%
곡 4
 
6.5%
신 3
 
4.8%
송 2
 
3.2%
월 2
 
3.2%
단 2
 
3.2%
첨 2
 
3.2%
정 2
 
3.2%
남 2
 
3.2%
산 2
 
3.2%
Other values (18) 19
30.6%
Common
ValueCountFrequency (%)
1 3
50.0%
2 3
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 62
91.2%
ASCII 6
 
8.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 22
35.5%
곡 4
 
6.5%
신 3
 
4.8%
송 2
 
3.2%
월 2
 
3.2%
단 2
 
3.2%
첨 2
 
3.2%
정 2
 
3.2%
남 2
 
3.2%
산 2
 
3.2%
Other values (18) 19
30.6%
ASCII
ValueCountFrequency (%)
1 3
50.0%
2 3
50.0%

2019년
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct7
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3333333
Minimum0
Maximum20
Zeros9
Zeros (%)42.9%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-12T22:34:27.821840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile6
Maximum20
Range20
Interquartile range (IQR)3

Descriptive statistics

Standard deviation4.4083255
Coefficient of variation (CV)1.8892823
Kurtosis13.998869
Mean2.3333333
Median Absolute Deviation (MAD)1
Skewness3.5154088
Sum49
Variance19.433333
MonotonicityNot monotonic
2023-12-12T22:34:27.935902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9
42.9%
1 4
19.0%
3 3
 
14.3%
4 2
 
9.5%
20 1
 
4.8%
6 1
 
4.8%
2 1
 
4.8%
ValueCountFrequency (%)
0 9
42.9%
1 4
19.0%
2 1
 
4.8%
3 3
 
14.3%
4 2
 
9.5%
6 1
 
4.8%
20 1
 
4.8%
ValueCountFrequency (%)
20 1
 
4.8%
6 1
 
4.8%
4 2
 
9.5%
3 3
 
14.3%
2 1
 
4.8%
1 4
19.0%
0 9
42.9%

2020년
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)23.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0
11 
1
5 
2
3 
19
 
1
7
 
1

Length

Max length2
Median length1
Mean length1.047619
Min length1

Unique

Unique2 ?
Unique (%)9.5%

Sample

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

Common Values

ValueCountFrequency (%)
0 11
52.4%
1 5
23.8%
2 3
 
14.3%
19 1
 
4.8%
7 1
 
4.8%

Length

2023-12-12T22:34:28.098490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:34:28.218670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 11
52.4%
1 5
23.8%
2 3
 
14.3%
19 1
 
4.8%
7 1
 
4.8%

2021년
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)23.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
0
14 
1
3 
5
2 
15
 
1
2
 
1

Length

Max length2
Median length1
Mean length1.047619
Min length1

Unique

Unique2 ?
Unique (%)9.5%

Sample

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

Common Values

ValueCountFrequency (%)
0 14
66.7%
1 3
 
14.3%
5 2
 
9.5%
15 1
 
4.8%
2 1
 
4.8%

Length

2023-12-12T22:34:28.354536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:34:28.496196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 14
66.7%
1 3
 
14.3%
5 2
 
9.5%
15 1
 
4.8%
2 1
 
4.8%

2022년
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
0
14 
1
4 
3
2 
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)4.8%

Sample

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

Common Values

ValueCountFrequency (%)
0 14
66.7%
1 4
 
19.0%
3 2
 
9.5%
4 1
 
4.8%

Length

2023-12-12T22:34:28.602750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:34:28.713319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 14
66.7%
1 4
 
19.0%
3 2
 
9.5%
4 1
 
4.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
Minimum2022-07-31 00:00:00
Maximum2022-07-31 00:00:00
2023-12-12T22:34:28.849010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:28.948711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T22:34:25.838536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:25.645781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:25.945025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:25.751519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:34:29.027416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번행정동명2019년2020년2021년2022년
연번1.0001.0000.4140.0000.7830.238
행정동명1.0001.0001.0001.0001.0001.000
2019년0.4141.0001.0000.9400.8930.807
2020년0.0001.0000.9401.0000.9100.731
2021년0.7831.0000.8930.9101.0000.811
2022년0.2381.0000.8070.7310.8111.000
2023-12-12T22:34:29.167597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2021년2020년2022년
2021년1.0000.5800.748
2020년0.5801.0000.648
2022년0.7480.6481.000
2023-12-12T22:34:29.253632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번2019년2020년2021년2022년
연번1.000-0.1270.0000.0000.176
2019년-0.1271.0000.7820.6200.690
2020년0.0000.7821.0000.5800.648
2021년0.0000.6200.5801.0000.748
2022년0.1760.6900.6480.7481.000

Missing values

2023-12-12T22:34:26.118362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:34:26.266114image/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

연번시군구행정동명2019년2020년2021년2022년데이터기준일자
01광주광역시 광산구송정1동02002022-07-31
12광주광역시 광산구송정2동01012022-07-31
23광주광역시 광산구도산동32112022-07-31
34광주광역시 광산구신흥동10102022-07-31
45광주광역시 광산구어룡동40012022-07-31
56광주광역시 광산구우산동20191542022-07-31
67광주광역시 광산구월곡1동10002022-07-31
78광주광역시 광산구월곡2동00002022-07-31
89광주광역시 광산구운남동31002022-07-31
910광주광역시 광산구하남동42532022-07-31
연번시군구행정동명2019년2020년2021년2022년데이터기준일자
1112광주광역시 광산구첨단2동01102022-07-31
1213광주광역시 광산구비아동10002022-07-31
1314광주광역시 광산구수완동67532022-07-31
1415광주광역시 광산구신가동20012022-07-31
1516광주광역시 광산구신창동01202022-07-31
1617광주광역시 광산구평동00002022-07-31
1718광주광역시 광산구임곡동00002022-07-31
1819광주광역시 광산구동곡동00002022-07-31
1920광주광역시 광산구삼도동11002022-07-31
2021광주광역시 광산구본량동30002022-07-31