Overview

Dataset statistics

Number of variables4
Number of observations36
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory37.7 B

Variable types

Categorical2
Numeric2

Dataset

Description공무원연금공단의 기관장 업무추진비에 대한 데이터입니다. 2022년도를 기준으로 1월부터 12월까지의 자료가 있습니다.
URLhttps://www.data.go.kr/data/15110985/fileData.do

Alerts

건수 is highly overall correlated with 집행금액 High correlation
집행금액 is highly overall correlated with 건수High correlation
건수 has 10 (27.8%) zerosZeros
집행금액 has 10 (27.8%) zerosZeros

Reproduction

Analysis started2023-12-12 10:15:43.967522
Analysis finished2023-12-12 10:15:44.752148
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집행월
Categorical

Distinct12
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size420.0 B
01월
3 
02월
3 
03월
3 
04월
3 
05월
3 
Other values (7)
21 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row01월
2nd row01월
3rd row01월
4th row02월
5th row02월

Common Values

ValueCountFrequency (%)
01월 3
8.3%
02월 3
8.3%
03월 3
8.3%
04월 3
8.3%
05월 3
8.3%
06월 3
8.3%
07월 3
8.3%
08월 3
8.3%
09월 3
8.3%
10월 3
8.3%
Other values (2) 6
16.7%

Length

2023-12-12T19:15:44.856842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
01월 3
8.3%
02월 3
8.3%
03월 3
8.3%
04월 3
8.3%
05월 3
8.3%
06월 3
8.3%
07월 3
8.3%
08월 3
8.3%
09월 3
8.3%
10월 3
8.3%
Other values (2) 6
16.7%

집행내역
Categorical

Distinct3
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size420.0 B
주요 업무 추진 관련 회의, 행사 등
12 
직원 사기진작(위로, 격려 등)
12 
경조사비 등
12 

Length

Max length20
Median length17
Mean length14.333333
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주요 업무 추진 관련 회의, 행사 등
2nd row직원 사기진작(위로, 격려 등)
3rd row경조사비 등
4th row주요 업무 추진 관련 회의, 행사 등
5th row직원 사기진작(위로, 격려 등)

Common Values

ValueCountFrequency (%)
주요 업무 추진 관련 회의, 행사 등 12
33.3%
직원 사기진작(위로, 격려 등) 12
33.3%
경조사비 등 12
33.3%

Length

2023-12-12T19:15:45.027388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:15:45.169930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
등 36
23.1%
주요 12
 
7.7%
업무 12
 
7.7%
추진 12
 
7.7%
관련 12
 
7.7%
회의 12
 
7.7%
행사 12
 
7.7%
직원 12
 
7.7%
사기진작(위로 12
 
7.7%
격려 12
 
7.7%

건수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct15
Distinct (%)41.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.3333333
Minimum0
Maximum18
Zeros10
Zeros (%)27.8%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-12T19:15:45.298883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median5
Q38.25
95-th percentile13.75
Maximum18
Range18
Interquartile range (IQR)8.25

Descriptive statistics

Standard deviation4.8579831
Coefficient of variation (CV)0.91087184
Kurtosis0.09591685
Mean5.3333333
Median Absolute Deviation (MAD)4.5
Skewness0.76961643
Sum192
Variance23.6
MonotonicityNot monotonic
2023-12-12T19:15:45.714520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0 10
27.8%
5 5
13.9%
10 3
 
8.3%
3 3
 
8.3%
6 3
 
8.3%
7 2
 
5.6%
4 2
 
5.6%
11 1
 
2.8%
18 1
 
2.8%
12 1
 
2.8%
Other values (5) 5
13.9%
ValueCountFrequency (%)
0 10
27.8%
1 1
 
2.8%
3 3
 
8.3%
4 2
 
5.6%
5 5
13.9%
6 3
 
8.3%
7 2
 
5.6%
8 1
 
2.8%
9 1
 
2.8%
10 3
 
8.3%
ValueCountFrequency (%)
18 1
 
2.8%
16 1
 
2.8%
13 1
 
2.8%
12 1
 
2.8%
11 1
 
2.8%
10 3
8.3%
9 1
 
2.8%
8 1
 
2.8%
7 2
5.6%
6 3
8.3%

집행금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct26
Distinct (%)72.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean777797.78
Minimum0
Maximum2400000
Zeros10
Zeros (%)27.8%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-12T19:15:45.866701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median675000
Q31315617.5
95-th percentile2145550
Maximum2400000
Range2400000
Interquartile range (IQR)1315617.5

Descriptive statistics

Standard deviation730601.77
Coefficient of variation (CV)0.93932098
Kurtosis-0.44548035
Mean777797.78
Median Absolute Deviation (MAD)675000
Skewness0.73413674
Sum28000720
Variance5.3377895 × 1011
MonotonicityNot monotonic
2023-12-12T19:15:46.042011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
0 10
27.8%
600000 2
 
5.6%
1563350 1
 
2.8%
800000 1
 
2.8%
727430 1
 
2.8%
850000 1
 
2.8%
2400000 1
 
2.8%
700000 1
 
2.8%
1362470 1
 
2.8%
307000 1
 
2.8%
Other values (16) 16
44.4%
ValueCountFrequency (%)
0 10
27.8%
177000 1
 
2.8%
307000 1
 
2.8%
390500 1
 
2.8%
457800 1
 
2.8%
510580 1
 
2.8%
600000 2
 
5.6%
650000 1
 
2.8%
700000 1
 
2.8%
727430 1
 
2.8%
ValueCountFrequency (%)
2400000 1
2.8%
2350000 1
2.8%
2077400 1
2.8%
1892400 1
2.8%
1850000 1
2.8%
1563350 1
2.8%
1500000 1
2.8%
1494000 1
2.8%
1362470 1
2.8%
1300000 1
2.8%

Interactions

2023-12-12T19:15:44.350174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:15:44.115130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:15:44.452023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:15:44.224334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:15:46.158402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
집행월집행내역건수집행금액
집행월1.0000.0000.2160.000
집행내역0.0001.0000.6250.735
건수0.2160.6251.0000.784
집행금액0.0000.7350.7841.000
2023-12-12T19:15:46.261479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
집행월집행내역
집행월1.0000.000
집행내역0.0001.000
2023-12-12T19:15:46.382336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건수집행금액집행월집행내역
건수1.0000.9150.0000.363
집행금액0.9151.0000.0000.391
집행월0.0000.0001.0000.000
집행내역0.3630.3910.0001.000

Missing values

2023-12-12T19:15:44.591789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:15:44.693730image/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

집행월집행내역건수집행금액
001월주요 업무 추진 관련 회의, 행사 등00
101월직원 사기진작(위로, 격려 등)00
201월경조사비 등101850000
302월주요 업무 추진 관련 회의, 행사 등3177000
402월직원 사기진작(위로, 격려 등)11757400
502월경조사비 등6650000
603월주요 업무 추진 관련 회의, 행사 등5457800
703월직원 사기진작(위로, 격려 등)181892400
803월경조사비 등122350000
904월주요 업무 추진 관련 회의, 행사 등6390500
집행월집행내역건수집행금액
2609월경조사비 등132400000
2710월주요 업무 추진 관련 회의, 행사 등00
2810월직원 사기진작(위로, 격려 등)00
2910월경조사비 등7850000
3011월주요 업무 추진 관련 회의, 행사 등00
3111월직원 사기진작(위로, 격려 등)1727430
3211월경조사비 등5800000
3312월주요 업무 추진 관련 회의, 행사 등00
3412월직원 사기진작(위로, 격려 등)00
3512월경조사비 등5600000