Overview

Dataset statistics

Number of variables8
Number of observations255
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory17.1 KiB
Average record size in memory68.5 B

Variable types

DateTime1
Categorical3
Numeric4

Dataset

Description광주광역시 시군구별 보훈대상자 인원현황 자료1. 적용 대상 국가유공자는 「국가유공자 등 예우 및 지원에 관한 법률」 제4조 참조2. 참전유공자는 「참전유공자예우 및 단체설립에 관한 법률」제2조에 의거 등록된 대상자 현황<참고>* 제적(국적상실), 등급기준 미달자, 단순 수훈자, 희생자력 제외* 합계는 등록대상별 현황의 합계임 (실인원이 아님)* (고엽제후유증)은 국가유공자예우법상 "전몰·전상·순직·공상군경"에 포함(중복합산을 하지 않음)
Author국가보훈부
URLhttps://www.data.go.kr/data/15098577/fileData.do

Alerts

기준년월 has constant value ""Constant
지역명 has constant value ""Constant
순서 is highly overall correlated with 대상구분High correlation
합계 is highly overall correlated with 본인 and 1 other fieldsHigh correlation
본인 is highly overall correlated with 합계High correlation
유족 is highly overall correlated with 합계High correlation
대상구분 is highly overall correlated with 순서High correlation
합계 has 40 (15.7%) zerosZeros
본인 has 116 (45.5%) zerosZeros
유족 has 84 (32.9%) zerosZeros

Reproduction

Analysis started2024-03-16 04:11:03.144318
Analysis finished2024-03-16 04:11:19.495663
Duration16.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년월
Date

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
Minimum2023-12-31 00:00:00
Maximum2023-12-31 00:00:00
2024-03-16T13:11:19.598345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:19.799315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

지역명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
광주광역시
255 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
광주광역시 255
100.0%

Length

2024-03-16T13:11:20.102255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:11:20.372933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시 255
100.0%

시군구명
Categorical

Distinct5
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
광산구
51 
남구(광주)
51 
동구(광주)
51 
북구(광주)
51 
서구(광주)
51 

Length

Max length6
Median length6
Mean length5.4
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
광산구 51
20.0%
남구(광주) 51
20.0%
동구(광주) 51
20.0%
북구(광주) 51
20.0%
서구(광주) 51
20.0%

Length

2024-03-16T13:11:20.562604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-16T13:11:20.814773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광산구 51
20.0%
남구(광주 51
20.0%
동구(광주 51
20.0%
북구(광주 51
20.0%
서구(광주 51
20.0%

순서
Real number (ℝ)

HIGH CORRELATION 

Distinct51
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26
Minimum1
Maximum51
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-03-16T13:11:21.077437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q113
median26
Q339
95-th percentile49
Maximum51
Range50
Interquartile range (IQR)26

Descriptive statistics

Standard deviation14.748549
Coefficient of variation (CV)0.56725187
Kurtosis-1.2009038
Mean26
Median Absolute Deviation (MAD)13
Skewness0
Sum6630
Variance217.51969
MonotonicityNot monotonic
2024-03-16T13:11:21.286900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 5
 
2.0%
2 5
 
2.0%
29 5
 
2.0%
30 5
 
2.0%
31 5
 
2.0%
32 5
 
2.0%
33 5
 
2.0%
34 5
 
2.0%
35 5
 
2.0%
36 5
 
2.0%
Other values (41) 205
80.4%
ValueCountFrequency (%)
1 5
2.0%
2 5
2.0%
3 5
2.0%
4 5
2.0%
5 5
2.0%
6 5
2.0%
7 5
2.0%
8 5
2.0%
9 5
2.0%
10 5
2.0%
ValueCountFrequency (%)
51 5
2.0%
50 5
2.0%
49 5
2.0%
48 5
2.0%
47 5
2.0%
46 5
2.0%
45 5
2.0%
44 5
2.0%
43 5
2.0%
42 5
2.0%

대상구분
Categorical

HIGH CORRELATION 

Distinct49
Distinct (%)19.2%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
건국포장
 
10
대통령표창
 
10
6·18자유상이자
 
5
고엽제후유증
 
5
지원순직군경
 
5
Other values (44)
220 

Length

Max length15
Median length11
Mean length7
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row[순국선열]
2nd row건국훈장
3rd row건국포장
4th row대통령표창
5th row[애국지사]

Common Values

ValueCountFrequency (%)
건국포장 10
 
3.9%
대통령표창 10
 
3.9%
6·18자유상이자 5
 
2.0%
고엽제후유증 5
 
2.0%
지원순직군경 5
 
2.0%
보국수훈자 5
 
2.0%
[애국지사] 5
 
2.0%
건국훈장 5
 
2.0%
[전몰·전상·순직·공상군경] 5
 
2.0%
전몰군경 5
 
2.0%
Other values (39) 195
76.5%

Length

2024-03-16T13:11:21.496204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
건국포장 10
 
3.6%
행불자 10
 
3.6%
또는 10
 
3.6%
건국훈장 10
 
3.6%
대통령표창 10
 
3.6%
5·18부상자 5
 
1.8%
참전유공자 5
 
1.8%
순국선열 5
 
1.8%
6.25및월남전쟁 5
 
1.8%
지원공상공무원 5
 
1.8%
Other values (40) 200
72.7%

합계
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct122
Distinct (%)47.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean162.61569
Minimum0
Maximum2529
Zeros40
Zeros (%)15.7%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-03-16T13:11:21.696168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median15
Q3143
95-th percentile899.3
Maximum2529
Range2529
Interquartile range (IQR)141

Descriptive statistics

Standard deviation338.35829
Coefficient of variation (CV)2.0807236
Kurtosis14.349905
Mean162.61569
Median Absolute Deviation (MAD)15
Skewness3.3998365
Sum41467
Variance114486.33
MonotonicityNot monotonic
2024-03-16T13:11:21.910050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 40
 
15.7%
1 19
 
7.5%
2 16
 
6.3%
3 11
 
4.3%
5 7
 
2.7%
6 7
 
2.7%
4 5
 
2.0%
8 5
 
2.0%
7 4
 
1.6%
15 4
 
1.6%
Other values (112) 137
53.7%
ValueCountFrequency (%)
0 40
15.7%
1 19
7.5%
2 16
 
6.3%
3 11
 
4.3%
4 5
 
2.0%
5 7
 
2.7%
6 7
 
2.7%
7 4
 
1.6%
8 5
 
2.0%
9 1
 
0.4%
ValueCountFrequency (%)
2529 1
0.4%
1800 1
0.4%
1640 1
0.4%
1542 1
0.4%
1353 1
0.4%
1331 1
0.4%
1319 1
0.4%
1049 1
0.4%
1031 1
0.4%
928 1
0.4%

본인
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct90
Distinct (%)35.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean107.72549
Minimum0
Maximum1542
Zeros116
Zeros (%)45.5%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-03-16T13:11:22.394155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q357.5
95-th percentile668.1
Maximum1542
Range1542
Interquartile range (IQR)57.5

Descriptive statistics

Standard deviation242.48197
Coefficient of variation (CV)2.2509248
Kurtosis10.650812
Mean107.72549
Median Absolute Deviation (MAD)1
Skewness3.1180455
Sum27470
Variance58797.507
MonotonicityNot monotonic
2024-03-16T13:11:22.635455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 116
45.5%
1 13
 
5.1%
2 8
 
3.1%
13 4
 
1.6%
20 4
 
1.6%
5 4
 
1.6%
10 4
 
1.6%
18 3
 
1.2%
7 3
 
1.2%
22 3
 
1.2%
Other values (80) 93
36.5%
ValueCountFrequency (%)
0 116
45.5%
1 13
 
5.1%
2 8
 
3.1%
3 2
 
0.8%
4 2
 
0.8%
5 4
 
1.6%
6 1
 
0.4%
7 3
 
1.2%
8 2
 
0.8%
10 4
 
1.6%
ValueCountFrequency (%)
1542 1
0.4%
1353 1
0.4%
1062 1
0.4%
1049 1
0.4%
1031 1
0.4%
917 1
0.4%
904 1
0.4%
900 1
0.4%
899 1
0.4%
807 1
0.4%

유족
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct80
Distinct (%)31.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54.890196
Minimum0
Maximum1467
Zeros84
Zeros (%)32.9%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-03-16T13:11:22.856471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median3
Q329.5
95-th percentile231.4
Maximum1467
Range1467
Interquartile range (IQR)29.5

Descriptive statistics

Standard deviation160.53634
Coefficient of variation (CV)2.9246815
Kurtosis34.441485
Mean54.890196
Median Absolute Deviation (MAD)3
Skewness5.3538357
Sum13997
Variance25771.917
MonotonicityNot monotonic
2024-03-16T13:11:23.088141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 84
32.9%
1 26
 
10.2%
2 16
 
6.3%
3 9
 
3.5%
5 8
 
3.1%
4 6
 
2.4%
6 5
 
2.0%
10 5
 
2.0%
7 4
 
1.6%
8 4
 
1.6%
Other values (70) 88
34.5%
ValueCountFrequency (%)
0 84
32.9%
1 26
 
10.2%
2 16
 
6.3%
3 9
 
3.5%
4 6
 
2.4%
5 8
 
3.1%
6 5
 
2.0%
7 4
 
1.6%
8 4
 
1.6%
10 5
 
2.0%
ValueCountFrequency (%)
1467 1
0.4%
1003 1
0.4%
946 1
0.4%
804 1
0.4%
761 1
0.4%
608 1
0.4%
508 1
0.4%
443 1
0.4%
395 1
0.4%
361 1
0.4%

Interactions

2024-03-16T13:11:18.308198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:10.996134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:16.428598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:17.158045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:18.495307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:14.697687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:16.661222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:17.336589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:18.686188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:15.492676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:16.823541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:17.677465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:18.900716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:16.116547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:17.008516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T13:11:18.079403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-16T13:11:23.274570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명순서대상구분합계본인유족
시군구명1.0000.0000.0000.0000.0300.000
순서0.0001.0000.9980.3940.4000.344
대상구분0.0000.9981.0000.6660.7090.631
합계0.0000.3940.6661.0000.9660.851
본인0.0300.4000.7090.9661.0000.662
유족0.0000.3440.6310.8510.6621.000
2024-03-16T13:11:23.410362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대상구분시군구명
대상구분1.0000.000
시군구명0.0001.000
2024-03-16T13:11:23.520309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순서합계본인유족시군구명대상구분
순서1.0000.0580.327-0.3450.0000.894
합계0.0581.0000.7720.6090.0000.281
본인0.3270.7721.0000.1880.0130.313
유족-0.3450.6090.1881.0000.0000.268
시군구명0.0000.0000.0130.0001.0000.000
대상구분0.8940.2810.3130.2680.0001.000

Missing values

2024-03-16T13:11:19.147949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-16T13:11:19.389704image/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

기준년월지역명시군구명순서대상구분합계본인유족
02023-12-31광주광역시광산구1[순국선열]101
12023-12-31광주광역시광산구2건국훈장101
22023-12-31광주광역시광산구3건국포장000
32023-12-31광주광역시광산구4대통령표창000
42023-12-31광주광역시광산구5[애국지사]28028
52023-12-31광주광역시광산구6건국훈장16016
62023-12-31광주광역시광산구7건국포장404
72023-12-31광주광역시광산구8대통령표창808
82023-12-31광주광역시광산구9[전몰·전상·순직·공상군경]18007971003
92023-12-31광주광역시광산구10전몰군경1510151
기준년월지역명시군구명순서대상구분합계본인유족
2452023-12-31광주광역시서구(광주)42고엽제후유증2세110
2462023-12-31광주광역시서구(광주)43[5·18민주유공자]39829999
2472023-12-31광주광역시서구(광주)445·18사망자 또는 행불자12012
2482023-12-31광주광역시서구(광주)455·18부상자27921069
2492023-12-31광주광역시서구(광주)465·18희생자1078918
2502023-12-31광주광역시서구(광주)47[특수임무유공자]871
2512023-12-31광주광역시서구(광주)48특수임무사망자 또는 행불자000
2522023-12-31광주광역시서구(광주)49특수임무부상자321
2532023-12-31광주광역시서구(광주)50특수임무공로자550
2542023-12-31광주광역시서구(광주)51중·장기복무제대군인6576570