Overview

Dataset statistics

Number of variables17
Number of observations598
Missing cells580
Missing cells (%)5.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory82.5 KiB
Average record size in memory141.2 B

Variable types

Categorical8
Text3
Numeric5
Boolean1

Dataset

Description전라북도 정읍시 보조사업정보중(회계구분, 부서명, 정책사업명, 단위사업명, 세부사업명, 통계목명, 배정부서명, 재배정부서명, 현액구분, 예산액, 재배정여부, 국비여부, 지급액, 반납액, 실지급액, 재원별예산합계)등의 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15085486/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
예산액 is highly overall correlated with 지급액 and 2 other fieldsHigh correlation
지급액 is highly overall correlated with 예산액 and 3 other fieldsHigh correlation
반납액 is highly overall correlated with 지급액 and 1 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 반납액High correlation
현액구분 is highly imbalanced (86.3%)Imbalance
반납액 has 580 (97.0%) missing valuesMissing
지급액 has 140 (23.4%) zerosZeros
실지급액 has 140 (23.4%) zerosZeros

Reproduction

Analysis started2023-12-12 03:16:41.944587
Analysis finished2023-12-12 03:16:47.402149
Duration5.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계연도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2022년
598 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022년
2nd row2022년
3rd row2022년
4th row2022년
5th row2022년

Common Values

ValueCountFrequency (%)
2022년 598
100.0%

Length

2023-12-12T12:16:47.913094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:16:48.029811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022년 598
100.0%

부서명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
농수산유통과
72 
축산과
68 
여성가족과
49 
노인장애인과
47 
공동체과
36 
Other values (26)
326 

Length

Max length11
Median length8
Mean length4.9715719
Min length3

Unique

Unique3 ?
Unique (%)0.5%

Sample

1st row기획예산실
2nd row교육체육청소년과
3rd row교육체육청소년과
4th row문화예술과
5th row문화예술과

Common Values

ValueCountFrequency (%)
농수산유통과 72
 
12.0%
축산과 68
 
11.4%
여성가족과 49
 
8.2%
노인장애인과 47
 
7.9%
공동체과 36
 
6.0%
문화예술과 34
 
5.7%
교육체육청소년과 29
 
4.8%
환경과 27
 
4.5%
농업정책과 27
 
4.5%
기술지원과 26
 
4.3%
Other values (21) 183
30.6%

Length

2023-12-12T12:16:48.156903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
농수산유통과 72
 
12.0%
축산과 68
 
11.4%
여성가족과 49
 
8.2%
노인장애인과 47
 
7.9%
공동체과 36
 
6.0%
문화예술과 34
 
5.7%
교육체육청소년과 29
 
4.8%
환경과 27
 
4.5%
농업정책과 27
 
4.5%
기술지원과 26
 
4.3%
Other values (21) 183
30.6%

정책사업명
Text

Distinct59
Distinct (%)9.9%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2023-12-12T12:16:48.509133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length15
Mean length10.269231
Min length4

Characters and Unicode

Total characters6141
Distinct characters165
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

Unique13 ?
Unique (%)2.2%

Sample

1st row시정의 종합기획 조정
2nd row시민과 함께하는 생활체육
3rd row시민과 함께하는 생활체육
4th row문화유산 보존 및 전승
5th row문화유산 보존 및 전승
ValueCountFrequency (%)
육성 104
 
6.2%
농산물 76
 
4.6%
유통관리 76
 
4.6%
생산 76
 
4.6%
친환경 68
 
4.1%
축산업 68
 
4.1%
및 56
 
3.4%
복지 47
 
2.8%
증진 47
 
2.8%
강화 40
 
2.4%
Other values (115) 1006
60.5%
2023-12-12T12:16:49.039247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1066
 
17.4%
산 254
 
4.1%
성 163
 
2.7%
화 158
 
2.6%
업 156
 
2.5%
육 149
 
2.4%
경 141
 
2.3%
농 130
 
2.1%
지 123
 
2.0%
생 115
 
1.9%
Other values (155) 3686
60.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5075
82.6%
Space Separator 1066
 
17.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 254
 
5.0%
성 163
 
3.2%
화 158
 
3.1%
업 156
 
3.1%
육 149
 
2.9%
경 141
 
2.8%
농 130
 
2.6%
지 123
 
2.4%
생 115
 
2.3%
관 114
 
2.2%
Other values (154) 3572
70.4%
Space Separator
ValueCountFrequency (%)
1066
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5075
82.6%
Common 1066
 
17.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 254
 
5.0%
성 163
 
3.2%
화 158
 
3.1%
업 156
 
3.1%
육 149
 
2.9%
경 141
 
2.8%
농 130
 
2.6%
지 123
 
2.4%
생 115
 
2.3%
관 114
 
2.2%
Other values (154) 3572
70.4%
Common
ValueCountFrequency (%)
1066
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5075
82.6%
ASCII 1066
 
17.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1066
100.0%
Hangul
ValueCountFrequency (%)
산 254
 
5.0%
성 163
 
3.2%
화 158
 
3.1%
업 156
 
3.1%
육 149
 
2.9%
경 141
 
2.8%
농 130
 
2.6%
지 123
 
2.4%
생 115
 
2.3%
관 114
 
2.2%
Other values (154) 3572
70.4%

단위사업명
Text

Distinct130
Distinct (%)21.7%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2023-12-12T12:16:49.431533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length17
Mean length10.135452
Min length4

Characters and Unicode

Total characters6061
Distinct characters236
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique36 ?
Unique (%)6.0%

Sample

1st row자치법무 및 의정활동 지원
2nd row체육활동육성
3rd row체육활동육성
4th row전통문화유산 보존 및 전승
5th row전통문화유산 보존 및 전승
ValueCountFrequency (%)
지원 86
 
6.2%
및 82
 
5.9%
육성 45
 
3.2%
관리 25
 
1.8%
조성 24
 
1.7%
활성화 22
 
1.6%
장애인 19
 
1.4%
지역문화발굴 18
 
1.3%
식품산업 18
 
1.3%
원예특작산업육성 18
 
1.3%
Other values (224) 1039
74.4%
2023-12-12T12:16:50.057401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
798
 
13.2%
지 276
 
4.6%
성 211
 
3.5%
원 176
 
2.9%
업 156
 
2.6%
육 141
 
2.3%
산 122
 
2.0%
기 110
 
1.8%
화 107
 
1.8%
사 102
 
1.7%
Other values (226) 3862
63.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5204
85.9%
Space Separator 798
 
13.2%
Other Punctuation 14
 
0.2%
Lowercase Letter 14
 
0.2%
Open Punctuation 12
 
0.2%
Close Punctuation 12
 
0.2%
Uppercase Letter 7
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 276
 
5.3%
성 211
 
4.1%
원 176
 
3.4%
업 156
 
3.0%
육 141
 
2.7%
산 122
 
2.3%
기 110
 
2.1%
화 107
 
2.1%
사 102
 
2.0%
활 91
 
1.7%
Other values (218) 3712
71.3%
Other Punctuation
ValueCountFrequency (%)
. 12
85.7%
· 2
 
14.3%
Lowercase Letter
ValueCountFrequency (%)
c 7
50.0%
o 7
50.0%
Space Separator
ValueCountFrequency (%)
798
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Uppercase Letter
ValueCountFrequency (%)
E 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5204
85.9%
Common 836
 
13.8%
Latin 21
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 276
 
5.3%
성 211
 
4.1%
원 176
 
3.4%
업 156
 
3.0%
육 141
 
2.7%
산 122
 
2.3%
기 110
 
2.1%
화 107
 
2.1%
사 102
 
2.0%
활 91
 
1.7%
Other values (218) 3712
71.3%
Common
ValueCountFrequency (%)
798
95.5%
( 12
 
1.4%
. 12
 
1.4%
) 12
 
1.4%
· 2
 
0.2%
Latin
ValueCountFrequency (%)
c 7
33.3%
E 7
33.3%
o 7
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5204
85.9%
ASCII 855
 
14.1%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
798
93.3%
( 12
 
1.4%
. 12
 
1.4%
) 12
 
1.4%
c 7
 
0.8%
E 7
 
0.8%
o 7
 
0.8%
Hangul
ValueCountFrequency (%)
지 276
 
5.3%
성 211
 
4.1%
원 176
 
3.4%
업 156
 
3.0%
육 141
 
2.7%
산 122
 
2.3%
기 110
 
2.1%
화 107
 
2.1%
사 102
 
2.0%
활 91
 
1.7%
Other values (218) 3712
71.3%
None
ValueCountFrequency (%)
· 2
100.0%

세부사업명
Text

Distinct511
Distinct (%)85.5%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2023-12-12T12:16:50.428293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length33
Mean length13.712375
Min length4

Characters and Unicode

Total characters8200
Distinct characters411
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique442 ?
Unique (%)73.9%

Sample

1st row시 의정 활동 협력
2nd row체육단체 운영지원
3rd row체육행사 개최지원
4th row도지정문화재 보수 및 지원
5th row도지정문화재 보수 및 지원
ValueCountFrequency (%)
지원 116
 
7.8%
운영 45
 
3.0%
지원사업 32
 
2.1%
및 26
 
1.7%
육성 18
 
1.2%
장애인 15
 
1.0%
운영지원 11
 
0.7%
조성 11
 
0.7%
활성화 10
 
0.7%
사업 9
 
0.6%
Other values (869) 1201
80.4%
2023-12-12T12:16:51.059342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
896
 
10.9%
지 408
 
5.0%
원 325
 
4.0%
업 301
 
3.7%
사 278
 
3.4%
( 156
 
1.9%
) 156
 
1.9%
기 122
 
1.5%
성 122
 
1.5%
전 116
 
1.4%
Other values (401) 5320
64.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6880
83.9%
Space Separator 896
 
10.9%
Open Punctuation 156
 
1.9%
Close Punctuation 156
 
1.9%
Uppercase Letter 71
 
0.9%
Dash Punctuation 15
 
0.2%
Other Punctuation 14
 
0.2%
Decimal Number 9
 
0.1%
Lowercase Letter 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 408
 
5.9%
원 325
 
4.7%
업 301
 
4.4%
사 278
 
4.0%
기 122
 
1.8%
성 122
 
1.8%
전 116
 
1.7%
시 115
 
1.7%
농 111
 
1.6%
화 108
 
1.6%
Other values (369) 4874
70.8%
Uppercase Letter
ValueCountFrequency (%)
C 14
19.7%
P 12
16.9%
T 7
9.9%
A 6
8.5%
I 5
 
7.0%
G 5
 
7.0%
D 3
 
4.2%
F 3
 
4.2%
M 3
 
4.2%
H 3
 
4.2%
Other values (6) 10
14.1%
Other Punctuation
ValueCountFrequency (%)
, 5
35.7%
· 4
28.6%
. 3
21.4%
/ 1
 
7.1%
& 1
 
7.1%
Decimal Number
ValueCountFrequency (%)
1 4
44.4%
0 3
33.3%
6 1
 
11.1%
9 1
 
11.1%
Lowercase Letter
ValueCountFrequency (%)
x 1
33.3%
o 1
33.3%
p 1
33.3%
Space Separator
ValueCountFrequency (%)
896
100.0%
Open Punctuation
ValueCountFrequency (%)
( 156
100.0%
Close Punctuation
ValueCountFrequency (%)
) 156
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6880
83.9%
Common 1246
 
15.2%
Latin 74
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 408
 
5.9%
원 325
 
4.7%
업 301
 
4.4%
사 278
 
4.0%
기 122
 
1.8%
성 122
 
1.8%
전 116
 
1.7%
시 115
 
1.7%
농 111
 
1.6%
화 108
 
1.6%
Other values (369) 4874
70.8%
Latin
ValueCountFrequency (%)
C 14
18.9%
P 12
16.2%
T 7
9.5%
A 6
8.1%
I 5
 
6.8%
G 5
 
6.8%
D 3
 
4.1%
F 3
 
4.1%
M 3
 
4.1%
H 3
 
4.1%
Other values (9) 13
17.6%
Common
ValueCountFrequency (%)
896
71.9%
( 156
 
12.5%
) 156
 
12.5%
- 15
 
1.2%
, 5
 
0.4%
1 4
 
0.3%
· 4
 
0.3%
0 3
 
0.2%
. 3
 
0.2%
/ 1
 
0.1%
Other values (3) 3
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6878
83.9%
ASCII 1316
 
16.0%
None 4
 
< 0.1%
Compat Jamo 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
896
68.1%
( 156
 
11.9%
) 156
 
11.9%
- 15
 
1.1%
C 14
 
1.1%
P 12
 
0.9%
T 7
 
0.5%
A 6
 
0.5%
I 5
 
0.4%
G 5
 
0.4%
Other values (21) 44
 
3.3%
Hangul
ValueCountFrequency (%)
지 408
 
5.9%
원 325
 
4.7%
업 301
 
4.4%
사 278
 
4.0%
기 122
 
1.8%
성 122
 
1.8%
전 116
 
1.7%
시 115
 
1.7%
농 111
 
1.6%
화 108
 
1.6%
Other values (368) 4872
70.8%
None
ValueCountFrequency (%)
· 4
100.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 2
100.0%

통계목명
Categorical

Distinct8
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
민간경상사업보조
185 
민간자본사업보조(이전재원)
158 
민간자본사업보조(자체재원)
85 
민간위탁금
76 
사회복지사업보조
52 
Other values (3)
42 

Length

Max length14
Median length13
Mean length10.322742
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row민간경상사업보조
2nd row민간단체법정운영비보조
3rd row민간경상사업보조
4th row민간경상사업보조
5th row민간자본사업보조(이전재원)

Common Values

ValueCountFrequency (%)
민간경상사업보조 185
30.9%
민간자본사업보조(이전재원) 158
26.4%
민간자본사업보조(자체재원) 85
14.2%
민간위탁금 76
12.7%
사회복지사업보조 52
 
8.7%
사회복지시설법정운영비보조 24
 
4.0%
민간단체법정운영비보조 13
 
2.2%
민간행사사업보조 5
 
0.8%

Length

2023-12-12T12:16:51.286674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:16:51.450944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
민간경상사업보조 185
30.9%
민간자본사업보조(이전재원 158
26.4%
민간자본사업보조(자체재원 85
14.2%
민간위탁금 76
12.7%
사회복지사업보조 52
 
8.7%
사회복지시설법정운영비보조 24
 
4.0%
민간단체법정운영비보조 13
 
2.2%
민간행사사업보조 5
 
0.8%

배정부서명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
농수산유통과
72 
축산과
68 
여성가족과
49 
노인장애인과
47 
공동체과
36 
Other values (26)
326 

Length

Max length11
Median length8
Mean length4.9715719
Min length3

Unique

Unique3 ?
Unique (%)0.5%

Sample

1st row기획예산실
2nd row교육체육청소년과
3rd row교육체육청소년과
4th row문화예술과
5th row문화예술과

Common Values

ValueCountFrequency (%)
농수산유통과 72
 
12.0%
축산과 68
 
11.4%
여성가족과 49
 
8.2%
노인장애인과 47
 
7.9%
공동체과 36
 
6.0%
문화예술과 34
 
5.7%
교육체육청소년과 29
 
4.8%
환경과 27
 
4.5%
농업정책과 27
 
4.5%
기술지원과 26
 
4.3%
Other values (21) 183
30.6%

Length

2023-12-12T12:16:51.677238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
농수산유통과 72
 
12.0%
축산과 68
 
11.4%
여성가족과 49
 
8.2%
노인장애인과 47
 
7.9%
공동체과 36
 
6.0%
문화예술과 34
 
5.7%
교육체육청소년과 29
 
4.8%
환경과 27
 
4.5%
농업정책과 27
 
4.5%
기술지원과 26
 
4.3%
Other values (21) 183
30.6%

재배정부서명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
농수산유통과
72 
축산과
68 
여성가족과
49 
노인장애인과
47 
공동체과
36 
Other values (26)
326 

Length

Max length11
Median length8
Mean length4.9715719
Min length3

Unique

Unique3 ?
Unique (%)0.5%

Sample

1st row기획예산실
2nd row교육체육청소년과
3rd row교육체육청소년과
4th row문화예술과
5th row문화예술과

Common Values

ValueCountFrequency (%)
농수산유통과 72
 
12.0%
축산과 68
 
11.4%
여성가족과 49
 
8.2%
노인장애인과 47
 
7.9%
공동체과 36
 
6.0%
문화예술과 34
 
5.7%
교육체육청소년과 29
 
4.8%
환경과 27
 
4.5%
농업정책과 27
 
4.5%
기술지원과 26
 
4.3%
Other values (21) 183
30.6%

Length

2023-12-12T12:16:51.906879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
농수산유통과 72
 
12.0%
축산과 68
 
11.4%
여성가족과 49
 
8.2%
노인장애인과 47
 
7.9%
공동체과 36
 
6.0%
문화예술과 34
 
5.7%
교육체육청소년과 29
 
4.8%
환경과 27
 
4.5%
농업정책과 27
 
4.5%
기술지원과 26
 
4.3%
Other values (21) 183
30.6%

현액구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct7
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
당해예산
569 
성립전예산
 
11
사고
 
9
명시
 
4
기금계획변경
 
2
Other values (2)
 
3

Length

Max length6
Median length4
Mean length3.9799331
Min length2

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row당해예산
2nd row당해예산
3rd row당해예산
4th row당해예산
5th row당해예산

Common Values

ValueCountFrequency (%)
당해예산 569
95.2%
성립전예산 11
 
1.8%
사고 9
 
1.5%
명시 4
 
0.7%
기금계획변경 2
 
0.3%
변경사용 2
 
0.3%
예비비 1
 
0.2%

Length

2023-12-12T12:16:52.115602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:16:52.309756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
당해예산 569
95.2%
성립전예산 11
 
1.8%
사고 9
 
1.5%
명시 4
 
0.7%
기금계획변경 2
 
0.3%
변경사용 2
 
0.3%
예비비 1
 
0.2%

예산액
Real number (ℝ)

HIGH CORRELATION 

Distinct442
Distinct (%)73.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4720228 × 108
Minimum300000
Maximum1.7765816 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.4 KiB
2023-12-12T12:16:52.536964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum300000
5-th percentile4404600
Q129662500
median90000000
Q32.088675 × 108
95-th percentile1.3262235 × 109
Maximum1.7765816 × 1010
Range1.7765516 × 1010
Interquartile range (IQR)1.79205 × 108

Descriptive statistics

Standard deviation1.1407708 × 109
Coefficient of variation (CV)3.2856088
Kurtosis109.01232
Mean3.4720228 × 108
Median Absolute Deviation (MAD)70600000
Skewness9.0699969
Sum2.0762696 × 1011
Variance1.3013581 × 1018
MonotonicityNot monotonic
2023-12-12T12:16:52.767327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
50000000 13
 
2.2%
40000000 11
 
1.8%
100000000 9
 
1.5%
140000000 8
 
1.3%
150000000 7
 
1.2%
30000000 7
 
1.2%
20000000 7
 
1.2%
5000000 6
 
1.0%
200000000 6
 
1.0%
10000000 6
 
1.0%
Other values (432) 518
86.6%
ValueCountFrequency (%)
300000 1
0.2%
720000 2
0.3%
800000 1
0.2%
1310000 1
0.2%
1400000 1
0.2%
1500000 1
0.2%
1620000 1
0.2%
1800000 1
0.2%
2000000 1
0.2%
2160000 1
0.2%
ValueCountFrequency (%)
17765816000 1
0.2%
9809000000 1
0.2%
8758141000 1
0.2%
7148468000 1
0.2%
6394901000 1
0.2%
6164330000 1
0.2%
5814732000 1
0.2%
5416000000 1
0.2%
4600000000 1
0.2%
4485139000 1
0.2%

재배정여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size730.0 B
False
598 
ValueCountFrequency (%)
False 598
100.0%
2023-12-12T12:16:52.947632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

국비여부
Categorical

Distinct3
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
없음
463 
일부
129 
전액
 
6

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row없음
2nd row없음
3rd row없음
4th row없음
5th row없음

Common Values

ValueCountFrequency (%)
없음 463
77.4%
일부 129
 
21.6%
전액 6
 
1.0%

Length

2023-12-12T12:16:53.095481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:16:53.229435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
없음 463
77.4%
일부 129
 
21.6%
전액 6
 
1.0%

지급액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct389
Distinct (%)65.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.8691459 × 108
Minimum0
Maximum1.7759066 × 1010
Zeros140
Zeros (%)23.4%
Negative0
Negative (%)0.0%
Memory size5.4 KiB
2023-12-12T12:16:53.406222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11800000
median31050000
Q31.3244919 × 108
95-th percentile7.1186696 × 108
Maximum1.7759066 × 1010
Range1.7759066 × 1010
Interquartile range (IQR)1.3064919 × 108

Descriptive statistics

Standard deviation8.4313379 × 108
Coefficient of variation (CV)4.510797
Kurtosis320.54277
Mean1.8691459 × 108
Median Absolute Deviation (MAD)31050000
Skewness16.115782
Sum1.1177493 × 1011
Variance7.1087459 × 1017
MonotonicityNot monotonic
2023-12-12T12:16:53.656002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 140
 
23.4%
20000000 8
 
1.3%
60000000 5
 
0.8%
10000000 5
 
0.8%
150000000 5
 
0.8%
50000000 5
 
0.8%
28000000 4
 
0.7%
30000000 3
 
0.5%
36000000 3
 
0.5%
45000000 3
 
0.5%
Other values (379) 417
69.7%
ValueCountFrequency (%)
0 140
23.4%
88960 1
 
0.2%
300000 1
 
0.2%
541200 1
 
0.2%
720000 1
 
0.2%
800000 1
 
0.2%
930000 1
 
0.2%
1254420 1
 
0.2%
1400000 1
 
0.2%
1458000 1
 
0.2%
ValueCountFrequency (%)
17759066000 1
0.2%
5609752130 1
0.2%
3778474630 1
0.2%
3149296710 1
0.2%
2659291910 1
0.2%
2579672000 1
0.2%
2516575220 1
0.2%
2463230000 1
0.2%
2365735920 1
0.2%
1934200000 1
0.2%

반납액
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct18
Distinct (%)100.0%
Missing580
Missing (%)97.0%
Infinite0
Infinite (%)0.0%
Mean-52641302
Minimum-6.4 × 108
Maximum-17110
Zeros0
Zeros (%)0.0%
Negative18
Negative (%)3.0%
Memory size5.4 KiB
2023-12-12T12:16:53.852826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-6.4 × 108
5-th percentile-2.4475 × 108
Q1-6920050
median-606000
Q3-210000
95-th percentile-26876.5
Maximum-17110
Range6.3998289 × 108
Interquartile range (IQR)6710050

Descriptive statistics

Standard deviation1.5326288 × 108
Coefficient of variation (CV)-2.9114569
Kurtosis14.518361
Mean-52641302
Median Absolute Deviation (MAD)533670
Skewness-3.723974
Sum-9.4754343 × 108
Variance2.3489511 × 1016
MonotonicityNot monotonic
2023-12-12T12:16:54.023065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
-400000 1
 
0.2%
-175000000 1
 
0.2%
-640000000 1
 
0.2%
-28600 1
 
0.2%
-17110 1
 
0.2%
-3440170 1
 
0.2%
-1065510 1
 
0.2%
-91200000 1
 
0.2%
-8080010 1
 
0.2%
-156000 1
 
0.2%
Other values (8) 8
 
1.3%
(Missing) 580
97.0%
ValueCountFrequency (%)
-640000000 1
0.2%
-175000000 1
0.2%
-91200000 1
0.2%
-23992450 1
0.2%
-8080010 1
0.2%
-3440170 1
0.2%
-2024000 1
0.2%
-1065510 1
0.2%
-652000 1
0.2%
-560000 1
0.2%
ValueCountFrequency (%)
-17110 1
0.2%
-28600 1
0.2%
-116060 1
0.2%
-156000 1
0.2%
-200000 1
0.2%
-240000 1
0.2%
-371520 1
0.2%
-400000 1
0.2%
-560000 1
0.2%
-652000 1
0.2%

실지급액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct390
Distinct (%)65.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.8533007 × 108
Minimum0
Maximum1.7759066 × 1010
Zeros140
Zeros (%)23.4%
Negative0
Negative (%)0.0%
Memory size5.4 KiB
2023-12-12T12:16:54.242726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11800000
median31050000
Q31.3114 × 108
95-th percentile7.1135093 × 108
Maximum1.7759066 × 1010
Range1.7759066 × 1010
Interquartile range (IQR)1.2934 × 108

Descriptive statistics

Standard deviation8.4164181 × 108
Coefficient of variation (CV)4.5413127
Kurtosis322.94999
Mean1.8533007 × 108
Median Absolute Deviation (MAD)31050000
Skewness16.199807
Sum1.1082738 × 1011
Variance7.0836093 × 1017
MonotonicityNot monotonic
2023-12-12T12:16:54.494337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 140
 
23.4%
20000000 8
 
1.3%
60000000 5
 
0.8%
50000000 5
 
0.8%
10000000 5
 
0.8%
150000000 5
 
0.8%
28000000 4
 
0.7%
30000000 3
 
0.5%
36000000 3
 
0.5%
35000000 3
 
0.5%
Other values (380) 417
69.7%
ValueCountFrequency (%)
0 140
23.4%
88960 1
 
0.2%
300000 1
 
0.2%
541200 1
 
0.2%
720000 1
 
0.2%
800000 1
 
0.2%
930000 1
 
0.2%
1254420 1
 
0.2%
1400000 1
 
0.2%
1458000 1
 
0.2%
ValueCountFrequency (%)
17759066000 1
0.2%
5609752130 1
0.2%
3778474630 1
0.2%
3149296710 1
0.2%
2635299460 1
0.2%
2579672000 1
0.2%
2516575220 1
0.2%
2463230000 1
0.2%
2365735920 1
0.2%
1934200000 1
0.2%

재원별예산합계
Real number (ℝ)

HIGH CORRELATION 

Distinct442
Distinct (%)73.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4720228 × 108
Minimum300000
Maximum1.7765816 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.4 KiB
2023-12-12T12:16:54.745065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum300000
5-th percentile4404600
Q129662500
median90000000
Q32.088675 × 108
95-th percentile1.3262235 × 109
Maximum1.7765816 × 1010
Range1.7765516 × 1010
Interquartile range (IQR)1.79205 × 108

Descriptive statistics

Standard deviation1.1407708 × 109
Coefficient of variation (CV)3.2856088
Kurtosis109.01232
Mean3.4720228 × 108
Median Absolute Deviation (MAD)70600000
Skewness9.0699969
Sum2.0762696 × 1011
Variance1.3013581 × 1018
MonotonicityNot monotonic
2023-12-12T12:16:55.041108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
50000000 13
 
2.2%
40000000 11
 
1.8%
100000000 9
 
1.5%
140000000 8
 
1.3%
150000000 7
 
1.2%
30000000 7
 
1.2%
20000000 7
 
1.2%
5000000 6
 
1.0%
200000000 6
 
1.0%
10000000 6
 
1.0%
Other values (432) 518
86.6%
ValueCountFrequency (%)
300000 1
0.2%
720000 2
0.3%
800000 1
0.2%
1310000 1
0.2%
1400000 1
0.2%
1500000 1
0.2%
1620000 1
0.2%
1800000 1
0.2%
2000000 1
0.2%
2160000 1
0.2%
ValueCountFrequency (%)
17765816000 1
0.2%
9809000000 1
0.2%
8758141000 1
0.2%
7148468000 1
0.2%
6394901000 1
0.2%
6164330000 1
0.2%
5814732000 1
0.2%
5416000000 1
0.2%
4600000000 1
0.2%
4485139000 1
0.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2022-12-31
598 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-12-31
2nd row2022-12-31
3rd row2022-12-31
4th row2022-12-31
5th row2022-12-31

Common Values

ValueCountFrequency (%)
2022-12-31 598
100.0%

Length

2023-12-12T12:16:55.234353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:16:55.378427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-12-31 598
100.0%

Interactions

2023-12-12T12:16:46.152513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:43.428704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.075777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.790331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.431298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:46.294098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:43.555586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.206668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.898848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.584662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:46.425690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:43.699425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.359387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.010313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.740782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:46.537928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:43.800490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.519100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.143177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.858128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:46.673357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:43.936913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:44.665945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:45.269381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:16:46.000742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:16:55.491475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서명정책사업명통계목명배정부서명재배정부서명현액구분예산액국비여부지급액반납액실지급액재원별예산합계
부서명1.0001.0000.7391.0001.0000.3830.4040.3790.0000.5850.0000.404
정책사업명1.0001.0000.8111.0001.0000.2740.7350.5090.8140.4710.8140.735
통계목명0.7390.8111.0000.7390.7390.0810.1300.2630.1390.6280.1390.130
배정부서명1.0001.0000.7391.0001.0000.3830.4040.3790.0000.5850.0000.404
재배정부서명1.0001.0000.7391.0001.0000.3830.4040.3790.0000.5850.0000.404
현액구분0.3830.2740.0810.3830.3831.0000.0000.4520.000NaN0.0000.000
예산액0.4040.7350.1300.4040.4040.0001.0000.1280.8490.0000.8491.000
국비여부0.3790.5090.2630.3790.3790.4520.1281.0000.0490.0000.0490.128
지급액0.0000.8140.1390.0000.0000.0000.8490.0491.0000.0001.0000.849
반납액0.5850.4710.6280.5850.585NaN0.0000.0000.0001.0000.0000.000
실지급액0.0000.8140.1390.0000.0000.0000.8490.0491.0000.0001.0000.849
재원별예산합계0.4040.7350.1300.4040.4040.0001.0000.1280.8490.0000.8491.000
2023-12-12T12:16:55.704823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서명재배정부서명국비여부현액구분통계목명배정부서명
부서명1.0001.0000.2020.1660.3891.000
재배정부서명1.0001.0000.2020.1660.3891.000
국비여부0.2020.2021.0000.3400.1720.202
현액구분0.1660.1660.3401.0000.0430.166
통계목명0.3890.3890.1720.0431.0000.389
배정부서명1.0001.0000.2020.1660.3891.000
2023-12-12T12:16:55.863184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예산액지급액반납액실지급액재원별예산합계부서명통계목명배정부서명재배정부서명현액구분국비여부
예산액1.0000.613-0.3090.6141.0000.1770.0700.1770.1770.0000.086
지급액0.6131.000-0.5461.0000.6130.0000.0850.0000.0000.0000.036
반납액-0.309-0.5461.000-0.368-0.3090.0000.3450.0000.0001.0000.000
실지급액0.6141.000-0.3681.0000.6140.0000.0850.0000.0000.0000.036
재원별예산합계1.0000.613-0.3090.6141.0000.1770.0700.1770.1770.0000.086
부서명0.1770.0000.0000.0000.1771.0000.3891.0001.0000.1660.202
통계목명0.0700.0850.3450.0850.0700.3891.0000.3890.3890.0430.172
배정부서명0.1770.0000.0000.0000.1771.0000.3891.0001.0000.1660.202
재배정부서명0.1770.0000.0000.0000.1771.0000.3891.0001.0000.1660.202
현액구분0.0000.0001.0000.0000.0000.1660.0430.1660.1661.0000.340
국비여부0.0860.0360.0000.0360.0860.2020.1720.2020.2020.3401.000

Missing values

2023-12-12T12:16:46.909804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:16:47.252717image/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

회계연도부서명정책사업명단위사업명세부사업명통계목명배정부서명재배정부서명현액구분예산액재배정여부국비여부지급액반납액실지급액재원별예산합계데이터기준일자
02022년기획예산실시정의 종합기획 조정자치법무 및 의정활동 지원시 의정 활동 협력민간경상사업보조기획예산실기획예산실당해예산5000000N없음0<NA>050000002022-12-31
12022년교육체육청소년과시민과 함께하는 생활체육체육활동육성체육단체 운영지원민간단체법정운영비보조교육체육청소년과교육체육청소년과당해예산483030000N없음483030000<NA>4830300004830300002022-12-31
22022년교육체육청소년과시민과 함께하는 생활체육체육활동육성체육행사 개최지원민간경상사업보조교육체육청소년과교육체육청소년과당해예산1177168000N없음192500000<NA>19250000011771680002022-12-31
32022년문화예술과문화유산 보존 및 전승전통문화유산 보존 및 전승도지정문화재 보수 및 지원민간경상사업보조문화예술과문화예술과당해예산48200000N없음33950000<NA>33950000482000002022-12-31
42022년문화예술과문화유산 보존 및 전승전통문화유산 보존 및 전승도지정문화재 보수 및 지원민간자본사업보조(이전재원)문화예술과문화예술과당해예산124000000N없음117510000<NA>1175100001240000002022-12-31
52022년문화예술과문화유산 보존 및 전승전통문화유산 보존 및 전승향토문화유산 보존 관리민간경상사업보조문화예술과문화예술과당해예산205470000N없음170220000<NA>1702200002054700002022-12-31
62022년사회복지과호국보훈관리백정기의사기념관 관리백정기의사기념관 운영 및 활성화사회복지사업보조사회복지과사회복지과당해예산30050000N없음12050000<NA>12050000300500002022-12-31
72022년문화예술과문화유산 보존 및 전승전통문화유산 보존 및 전승전통사찰 보존 지원민간자본사업보조(이전재원)문화예술과문화예술과당해예산592000000N일부0<NA>05920000002022-12-31
82022년상하수도사업소하수도관리마을하수도 유지관리마을하수도시설 유지관리민간위탁금상하수도사업소상하수도사업소당해예산1000000000N없음501549000<NA>50154900010000000002022-12-31
92022년문화예술과문화예술 진흥지역문화발굴 및 창달문화예술사업지원민간경상사업보조문화예술과문화예술과당해예산288010000N없음249210000<NA>2492100002880100002022-12-31
회계연도부서명정책사업명단위사업명세부사업명통계목명배정부서명재배정부서명현액구분예산액재배정여부국비여부지급액반납액실지급액재원별예산합계데이터기준일자
5882022년여성가족과아동보육지원지역아동센터 운영지역아동센터 인건비 추가지원사회복지시설법정운영비보조여성가족과여성가족과당해예산76028000N없음0<NA>0760280002022-12-31
5892022년보건위생과식의약품 안전망 구축식품.의약품 안전관리의료 및 분만취약지 지원민간경상사업보조보건위생과보건위생과성립전예산262500000N일부262500000<NA>2625000002625000002022-12-31
5902022년건강증진과시민 맞춤형 건강서비스 제공체계적인 감염병관리체계 구축재택치료 단기외래진료센터 확충민간자본사업보조(이전재원)건강증진과건강증진과성립전예산150000000N전액150000000<NA>1500000001500000002022-12-31
5912022년여성가족과아동보육지원어린이집 지원0세반 운영비 지원사회복지사업보조여성가족과여성가족과성립전예산7050000N없음0<NA>070500002022-12-31
5922022년문화예술과문화유산 보존 및 전승전통문화유산 보존 및 전승미래 무형문화유산 발굴육성(정읍 내동마을 제웅인형 소몰이 당산제)민간경상사업보조문화예술과문화예술과성립전예산49000000N전액49000000<NA>49000000490000002022-12-31
5932022년농수산유통과농산물 생산 유통관리식품산업 육성향토산업육성사업(전환사업)민간경상사업보조농수산유통과농수산유통과성립전예산200000000N없음200000000<NA>2000000002000000002022-12-31
5942022년농수산유통과농산물 생산 유통관리식품산업 육성향토산업육성사업(전환사업)민간자본사업보조(이전재원)농수산유통과농수산유통과성립전예산500000000N없음0<NA>05000000002022-12-31
5952022년농수산유통과농산물 생산 유통관리식품산업 육성로컬푸드직매장 생산소비 교류활동 지원사업(전환사업)민간경상사업보조농수산유통과농수산유통과성립전예산9000000N없음9000000<NA>900000090000002022-12-31
5962022년성장전략실신성장 발전 기반 구축인구청년정책 개발청년마루 조성 및 지원사업민간위탁금성장전략실성장전략실성립전예산25000000N없음25000000<NA>25000000250000002022-12-31
5972022년지역경제과고용 촉진 및 안정고용촉진및생활안정지역산업맞춤형 일자리창출 지원사업민간경상사업보조지역경제과지역경제과성립전예산144000000N없음144000000<NA>1440000001440000002022-12-31