Overview

Dataset statistics

Number of variables16
Number of observations10000
Missing cells14912
Missing cells (%)9.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 MiB
Average record size in memory139.0 B

Variable types

Numeric3
Categorical10
Text2
DateTime1

Dataset

Description경기도 양주시 인터넷업무게시판 배분 현황에 관한 데이터로 생활환경, 지원내용, 배분현금, 배분현물 등의 내용을 포함하고 있습니다.
Author경기도 양주시
URLhttps://www.data.go.kr/data/15090088/fileData.do

Alerts

주소(동) is highly overall correlated with 입력부서 and 1 other fieldsHigh correlation
구분 is highly overall correlated with 배분현금 and 3 other fieldsHigh correlation
입력부서 is highly overall correlated with 주소(동) and 2 other fieldsHigh correlation
예금주관계 is highly overall correlated with 배분현물수량 and 1 other fieldsHigh correlation
입력담당자 is highly overall correlated with 번호 and 4 other fieldsHigh correlation
번호 is highly overall correlated with 배분현물품목단위 and 2 other fieldsHigh correlation
배분현금 is highly overall correlated with 구분High correlation
배분현물수량 is highly overall correlated with 예금주관계 and 1 other fieldsHigh correlation
배분현물품목단위 is highly overall correlated with 번호 and 5 other fieldsHigh correlation
사업명 is highly overall correlated with 번호 and 1 other fieldsHigh correlation
구분 is highly imbalanced (59.5%)Imbalance
유형 is highly imbalanced (54.7%)Imbalance
지원내용 is highly imbalanced (65.8%)Imbalance
예금주관계 is highly imbalanced (84.4%)Imbalance
배분현물품목단위 is highly imbalanced (78.1%)Imbalance
배분현금 has 8797 (88.0%) missing valuesMissing
배분현물품목 has 1319 (13.2%) missing valuesMissing
배분현물물품가액 has 4796 (48.0%) missing valuesMissing
배분현물수량 is highly skewed (γ1 = 25.96123355)Skewed
번호 has unique valuesUnique
배분현물수량 has 2011 (20.1%) zerosZeros

Reproduction

Analysis started2023-12-12 13:48:53.965123
Analysis finished2023-12-12 13:48:57.716617
Duration3.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10655.318
Minimum2
Maximum21331
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T22:48:57.800521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile1084.9
Q15270.5
median10647
Q316004.5
95-th percentile20230.25
Maximum21331
Range21329
Interquartile range (IQR)10734

Descriptive statistics

Standard deviation6168.1806
Coefficient of variation (CV)0.57888281
Kurtosis-1.2097727
Mean10655.318
Median Absolute Deviation (MAD)5369.5
Skewness-8.403428 × 10-5
Sum1.0655318 × 108
Variance38046451
MonotonicityNot monotonic
2023-12-12T22:48:57.967103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
12156 1
 
< 0.1%
8123 1
 
< 0.1%
7464 1
 
< 0.1%
1222 1
 
< 0.1%
10090 1
 
< 0.1%
15027 1
 
< 0.1%
685 1
 
< 0.1%
7956 1
 
< 0.1%
19467 1
 
< 0.1%
3698 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
3 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
12 1
< 0.1%
13 1
< 0.1%
15 1
< 0.1%
16 1
< 0.1%
ValueCountFrequency (%)
21331 1
< 0.1%
21330 1
< 0.1%
21327 1
< 0.1%
21324 1
< 0.1%
21323 1
< 0.1%
21320 1
< 0.1%
21318 1
< 0.1%
21313 1
< 0.1%
21311 1
< 0.1%
21308 1
< 0.1%

구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
개인
8704 
단체
1075 
 
221

Length

Max length2
Median length2
Mean length1.9779
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개인
2nd row개인
3rd row개인
4th row개인
5th row개인

Common Values

ValueCountFrequency (%)
개인 8704
87.0%
단체 1075
 
10.8%
221
 
2.2%

Length

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

Common Values (Plot)

2023-12-12T22:48:58.222106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개인 8704
89.0%
단체 1075
 
11.0%

유형
Categorical

IMBALANCE 

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기초생활수급자
6231 
차상위계층
1765 
기타(저소득가정, 중위소득 80%이하)
1724 
노인시설
 
123
특례수급자
 
70
Other values (5)
 
87

Length

Max length21
Median length7
Mean length8.996
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row기타(저소득가정, 중위소득 80%이하)
2nd row기초생활수급자
3rd row기초생활수급자
4th row기초생활수급자
5th row기초생활수급자

Common Values

ValueCountFrequency (%)
기초생활수급자 6231
62.3%
차상위계층 1765
 
17.6%
기타(저소득가정, 중위소득 80%이하) 1724
 
17.2%
노인시설 123
 
1.2%
특례수급자 70
 
0.7%
드림스타트 44
 
0.4%
<NA> 24
 
0.2%
기부식품제공사업장 16
 
0.2%
여성시설 2
 
< 0.1%
아동시설 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-12T22:48:58.473138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기초생활수급자 6231
46.3%
차상위계층 1765
 
13.1%
기타(저소득가정 1724
 
12.8%
중위소득 1724
 
12.8%
80%이하 1724
 
12.8%
노인시설 123
 
0.9%
특례수급자 70
 
0.5%
드림스타트 44
 
0.3%
na 24
 
0.2%
기부식품제공사업장 16
 
0.1%
Other values (2) 3
 
< 0.1%

생활환경
Categorical

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
기타
3057 
독거노인
2933 
수급자
1857 
장애인
782 
한부모가정
759 
Other values (5)
612 

Length

Max length6
Median length5
Mean length3.1718
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row독거노인
2nd row장애인
3rd row수급자
4th row독거노인
5th row차상위

Common Values

ValueCountFrequency (%)
기타 3057
30.6%
독거노인 2933
29.3%
수급자 1857
18.6%
장애인 782
 
7.8%
한부모가정 759
 
7.6%
차상위 381
 
3.8%
<NA> 143
 
1.4%
소년소녀가장 35
 
0.4%
가정위탁 30
 
0.3%
다문화가족 23
 
0.2%

Length

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

Common Values (Plot)

2023-12-12T22:48:58.758757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 3057
30.6%
독거노인 2933
29.3%
수급자 1857
18.6%
장애인 782
 
7.8%
한부모가정 759
 
7.6%
차상위 381
 
3.8%
na 143
 
1.4%
소년소녀가장 35
 
0.4%
가정위탁 30
 
0.3%
다문화가족 23
 
0.2%

지원내용
Categorical

IMBALANCE 

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
현물 지원
7506 
생계비지원
2149 
의료비지원
 
138
<NA>
 
110
주거환경개선
 
43
Other values (3)
 
54

Length

Max length6
Median length5
Mean length4.9933
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생계비지원
2nd row생계비지원
3rd row현물 지원
4th row현물 지원
5th row현물 지원

Common Values

ValueCountFrequency (%)
현물 지원 7506
75.1%
생계비지원 2149
 
21.5%
의료비지원 138
 
1.4%
<NA> 110
 
1.1%
주거환경개선 43
 
0.4%
주거비지원 26
 
0.3%
교육비지원 23
 
0.2%
차상위계층 5
 
0.1%

Length

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

Common Values (Plot)

2023-12-12T22:48:59.096978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
현물 7506
42.9%
지원 7506
42.9%
생계비지원 2149
 
12.3%
의료비지원 138
 
0.8%
na 110
 
0.6%
주거환경개선 43
 
0.2%
주거비지원 26
 
0.1%
교육비지원 23
 
0.1%
차상위계층 5
 
< 0.1%

주소(동)
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
양주2동
3308 
회천1동
1531 
회천2동
1449 
양주1동
1016 
회천4동
672 
Other values (7)
2024 

Length

Max length4
Median length4
Mean length3.7851
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row양주1동
2nd row<NA>
3rd row회천2동
4th row양주2동
5th row양주2동

Common Values

ValueCountFrequency (%)
양주2동 3308
33.1%
회천1동 1531
15.3%
회천2동 1449
14.5%
양주1동 1016
 
10.2%
회천4동 672
 
6.7%
백석읍 571
 
5.7%
광적면 441
 
4.4%
남면 302
 
3.0%
은현면 279
 
2.8%
장흥면 254
 
2.5%
Other values (2) 177
 
1.8%

Length

2023-12-12T22:48:59.229851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
양주2동 3308
33.1%
회천1동 1531
15.3%
회천2동 1449
14.5%
양주1동 1016
 
10.2%
회천4동 672
 
6.7%
백석읍 571
 
5.7%
광적면 441
 
4.4%
남면 302
 
3.0%
은현면 279
 
2.8%
장흥면 254
 
2.5%
Other values (2) 177
 
1.8%

배분현금
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct13
Distinct (%)1.1%
Missing8797
Missing (%)88.0%
Infinite0
Infinite (%)0.0%
Mean69717.373
Minimum10000
Maximum1853520
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T22:48:59.380938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10000
5-th percentile50000
Q150000
median50000
Q350000
95-th percentile100000
Maximum1853520
Range1843520
Interquartile range (IQR)0

Descriptive statistics

Standard deviation91745.401
Coefficient of variation (CV)1.3159618
Kurtosis143.16523
Mean69717.373
Median Absolute Deviation (MAD)0
Skewness9.8302048
Sum83870000
Variance8.4172185 × 109
MonotonicityNot monotonic
2023-12-12T22:48:59.550310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
50000 1046
 
10.5%
100000 99
 
1.0%
200000 21
 
0.2%
500000 19
 
0.2%
300000 5
 
0.1%
250000 5
 
0.1%
1000000 2
 
< 0.1%
1853520 1
 
< 0.1%
600000 1
 
< 0.1%
350000 1
 
< 0.1%
Other values (3) 3
 
< 0.1%
(Missing) 8797
88.0%
ValueCountFrequency (%)
10000 1
 
< 0.1%
50000 1046
10.5%
100000 99
 
1.0%
146480 1
 
< 0.1%
200000 21
 
0.2%
250000 5
 
0.1%
260000 1
 
< 0.1%
300000 5
 
0.1%
350000 1
 
< 0.1%
500000 19
 
0.2%
ValueCountFrequency (%)
1853520 1
 
< 0.1%
1000000 2
 
< 0.1%
600000 1
 
< 0.1%
500000 19
0.2%
350000 1
 
< 0.1%
300000 5
 
0.1%
260000 1
 
< 0.1%
250000 5
 
0.1%
200000 21
0.2%
146480 1
 
< 0.1%

예금주관계
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
8867 
본인
1042 
배우자
 
34
모
 
19
자녀
 
17
Other values (8)
 
21

Length

Max length4
Median length4
Mean length3.7737
Min length1

Unique

Unique3 ?
Unique (%)< 0.1%

Sample

1st row본인
2nd row본인
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 8867
88.7%
본인 1042
 
10.4%
배우자 34
 
0.3%
모 19
 
0.2%
자녀 17
 
0.2%
자 8
 
0.1%
조모 4
 
< 0.1%
부 2
 
< 0.1%
처 2
 
< 0.1%
언니 2
 
< 0.1%
Other values (3) 3
 
< 0.1%

Length

2023-12-12T22:48:59.703770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 8867
88.7%
본인 1042
 
10.4%
배우자 34
 
0.3%
모 19
 
0.2%
자녀 17
 
0.2%
자 8
 
0.1%
조모 4
 
< 0.1%
부 2
 
< 0.1%
처 2
 
< 0.1%
언니 2
 
< 0.1%
Other values (3) 3
 
< 0.1%

배분현물품목
Text

MISSING 

Distinct59
Distinct (%)0.7%
Missing1319
Missing (%)13.2%
Memory size156.2 KiB
2023-12-12T22:48:59.893544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length20
Mean length3.7734132
Min length1

Characters and Unicode

Total characters32757
Distinct characters132
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11 ?
Unique (%)0.1%

Sample

1st row즉석/조리식품
2nd row김치
3rd row양말(셋트)
4th row라면
5th row김치
ValueCountFrequency (%)
쌀10kg 2082
22.6%
김치 943
10.2%
라면 695
 
7.5%
기타 672
 
7.3%
수건 609
 
6.6%
선물셋트 561
 
6.1%
빵 529
 
5.7%
김/떡세트 414
 
4.5%
즉석/조리식품 327
 
3.5%
고기류 247
 
2.7%
Other values (57) 2141
23.2%
2023-12-12T22:49:00.292133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
쌀 2304
 
7.0%
g 2166
 
6.6%
k 2166
 
6.6%
0 2122
 
6.5%
1 2083
 
6.4%
김 1441
 
4.4%
트 1086
 
3.3%
기 950
 
2.9%
치 943
 
2.9%
품 805
 
2.5%
Other values (122) 16691
51.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21788
66.5%
Lowercase Letter 4344
 
13.3%
Decimal Number 4288
 
13.1%
Other Punctuation 912
 
2.8%
Space Separator 539
 
1.6%
Open Punctuation 426
 
1.3%
Close Punctuation 426
 
1.3%
Uppercase Letter 34
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
쌀 2304
 
10.6%
김 1441
 
6.6%
트 1086
 
5.0%
기 950
 
4.4%
치 943
 
4.3%
품 805
 
3.7%
라 696
 
3.2%
면 695
 
3.2%
타 672
 
3.1%
수 640
 
2.9%
Other values (104) 11556
53.0%
Lowercase Letter
ValueCountFrequency (%)
g 2166
49.9%
k 2166
49.9%
s 4
 
0.1%
m 4
 
0.1%
o 4
 
0.1%
Decimal Number
ValueCountFrequency (%)
0 2122
49.5%
1 2083
48.6%
2 65
 
1.5%
4 18
 
0.4%
Uppercase Letter
ValueCountFrequency (%)
E 10
29.4%
D 10
29.4%
L 10
29.4%
M 4
 
11.8%
Other Punctuation
ValueCountFrequency (%)
/ 741
81.2%
, 171
 
18.8%
Space Separator
ValueCountFrequency (%)
539
100.0%
Open Punctuation
ValueCountFrequency (%)
( 426
100.0%
Close Punctuation
ValueCountFrequency (%)
) 426
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 21788
66.5%
Common 6591
 
20.1%
Latin 4378
 
13.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
쌀 2304
 
10.6%
김 1441
 
6.6%
트 1086
 
5.0%
기 950
 
4.4%
치 943
 
4.3%
품 805
 
3.7%
라 696
 
3.2%
면 695
 
3.2%
타 672
 
3.1%
수 640
 
2.9%
Other values (104) 11556
53.0%
Latin
ValueCountFrequency (%)
g 2166
49.5%
k 2166
49.5%
E 10
 
0.2%
D 10
 
0.2%
L 10
 
0.2%
s 4
 
0.1%
m 4
 
0.1%
o 4
 
0.1%
M 4
 
0.1%
Common
ValueCountFrequency (%)
0 2122
32.2%
1 2083
31.6%
/ 741
 
11.2%
539
 
8.2%
( 426
 
6.5%
) 426
 
6.5%
, 171
 
2.6%
2 65
 
1.0%
4 18
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 21788
66.5%
ASCII 10969
33.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
쌀 2304
 
10.6%
김 1441
 
6.6%
트 1086
 
5.0%
기 950
 
4.4%
치 943
 
4.3%
품 805
 
3.7%
라 696
 
3.2%
면 695
 
3.2%
타 672
 
3.1%
수 640
 
2.9%
Other values (104) 11556
53.0%
ASCII
ValueCountFrequency (%)
g 2166
19.7%
k 2166
19.7%
0 2122
19.3%
1 2083
19.0%
/ 741
 
6.8%
539
 
4.9%
( 426
 
3.9%
) 426
 
3.9%
, 171
 
1.6%
2 65
 
0.6%
Other values (8) 64
 
0.6%

배분현물품목단위
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct31
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
8465 
10kg
 
629
5kg
 
299
1.5kg
 
129
명절(전)
 
120
Other values (26)
 
358

Length

Max length11
Median length4
Mean length3.9837
Min length1

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 8465
84.7%
10kg 629
 
6.3%
5kg 299
 
3.0%
1.5kg 129
 
1.3%
명절(전) 120
 
1.2%
6L 56
 
0.6%
10 39
 
0.4%
박스 36
 
0.4%
양곡 4kg 33
 
0.3%
1 21
 
0.2%
Other values (21) 173
 
1.7%

Length

2023-12-12T22:49:00.441600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 8465
84.2%
10kg 653
 
6.5%
5kg 306
 
3.0%
1.5kg 129
 
1.3%
명절(전 120
 
1.2%
6l 56
 
0.6%
양곡 52
 
0.5%
10 39
 
0.4%
박스 36
 
0.4%
4kg 36
 
0.4%
Other values (19) 162
 
1.6%

배분현물수량
Real number (ℝ)

HIGH CORRELATION  SKEWED  ZEROS 

Distinct28
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.016
Minimum0
Maximum536
Zeros2011
Zeros (%)20.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T22:49:00.578850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median1
Q31
95-th percentile4
Maximum536
Range536
Interquartile range (IQR)0

Descriptive statistics

Standard deviation14.526171
Coefficient of variation (CV)7.205442
Kurtosis802.86452
Mean2.016
Median Absolute Deviation (MAD)0
Skewness25.961234
Sum20160
Variance211.00964
MonotonicityNot monotonic
2023-12-12T22:49:00.983968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
1 6839
68.4%
0 2011
 
20.1%
2 376
 
3.8%
4 197
 
2.0%
5 185
 
1.8%
3 124
 
1.2%
10 67
 
0.7%
20 42
 
0.4%
6 39
 
0.4%
50 19
 
0.2%
Other values (18) 101
 
1.0%
ValueCountFrequency (%)
0 2011
 
20.1%
1 6839
68.4%
2 376
 
3.8%
3 124
 
1.2%
4 197
 
2.0%
5 185
 
1.8%
6 39
 
0.4%
7 3
 
< 0.1%
8 1
 
< 0.1%
10 67
 
0.7%
ValueCountFrequency (%)
536 3
 
< 0.1%
500 1
 
< 0.1%
300 4
 
< 0.1%
250 1
 
< 0.1%
200 11
0.1%
167 1
 
< 0.1%
60 4
 
< 0.1%
50 19
0.2%
40 12
0.1%
35 1
 
< 0.1%

배분현물물품가액
Text

MISSING 

Distinct231
Distinct (%)4.4%
Missing4796
Missing (%)48.0%
Memory size156.2 KiB
2023-12-12T22:49:01.247415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length5
Mean length4.7888163
Min length1

Characters and Unicode

Total characters24921
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique95 ?
Unique (%)1.8%

Sample

1st row10000
2nd row15408
3rd row6470
4th row7000
5th row13890
ValueCountFrequency (%)
30000 471
 
9.1%
10000 417
 
8.0%
25000 397
 
7.6%
19500 293
 
5.6%
8000 289
 
5.6%
20000 276
 
5.3%
50000 262
 
5.0%
15000 215
 
4.1%
7000 195
 
3.7%
45000 156
 
3.0%
Other values (220) 2232
42.9%
2023-12-12T22:49:01.629280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 14942
60.0%
1 2135
 
8.6%
5 1964
 
7.9%
2 1484
 
6.0%
3 988
 
4.0%
9 857
 
3.4%
7 746
 
3.0%
8 719
 
2.9%
4 599
 
2.4%
6 486
 
2.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 24920
> 99.9%
Space Separator 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 14942
60.0%
1 2135
 
8.6%
5 1964
 
7.9%
2 1484
 
6.0%
3 988
 
4.0%
9 857
 
3.4%
7 746
 
3.0%
8 719
 
2.9%
4 599
 
2.4%
6 486
 
2.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 24921
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 14942
60.0%
1 2135
 
8.6%
5 1964
 
7.9%
2 1484
 
6.0%
3 988
 
4.0%
9 857
 
3.4%
7 746
 
3.0%
8 719
 
2.9%
4 599
 
2.4%
6 486
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24921
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 14942
60.0%
1 2135
 
8.6%
5 1964
 
7.9%
2 1484
 
6.0%
3 988
 
4.0%
9 857
 
3.4%
7 746
 
3.0%
8 719
 
2.9%
4 599
 
2.4%
6 486
 
2.0%

배분일자
Date

Distinct500
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum1905-07-11 00:00:00
Maximum2020-12-08 00:00:00
2023-12-12T22:49:01.768234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:49:01.900980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업명
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반 나눔
3725 
2020 추석명절 감동나눔
1150 
2017 추석명절 감동나눔
837 
2020 설명절 감동나눔
762 
2018 추석명절 감동나눔
681 
Other values (16)
2845 

Length

Max length23
Median length21
Mean length9.5752
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019 설명절 감동나눔
2nd row2020 설명절 감동나눔
3rd row일반 나눔
4th row일반 나눔
5th row일반 나눔

Common Values

ValueCountFrequency (%)
일반 나눔 3725
37.2%
2020 추석명절 감동나눔 1150
 
11.5%
2017 추석명절 감동나눔 837
 
8.4%
2020 설명절 감동나눔 762
 
7.6%
2018 추석명절 감동나눔 681
 
6.8%
2019 설명절 감동나눔 514
 
5.1%
2019 추석명절 감동나눔 512
 
5.1%
기타 455
 
4.5%
2018 설명절 감동나눔 234
 
2.3%
민관협력사업 205
 
2.1%
Other values (11) 925
 
9.2%

Length

2023-12-12T22:49:02.048984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
감동나눔 4819
19.6%
일반 3725
15.1%
나눔 3725
15.1%
추석명절 3180
12.9%
2020 1959
8.0%
설명절 1510
 
6.1%
2019 1026
 
4.2%
2018 950
 
3.9%
2017 837
 
3.4%
기타 455
 
1.8%
Other values (20) 2416
9.8%

입력부서
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
양주2동
3310 
회천1동
1472 
회천2동
1379 
양주1동
989 
회천4동
640 
Other values (13)
2210 

Length

Max length13
Median length4
Mean length4.0076
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row양주1동
2nd row양주2동
3rd row회천2동
4th row양주2동
5th row양주2동

Common Values

ValueCountFrequency (%)
양주2동 3310
33.1%
회천1동 1472
14.7%
회천2동 1379
13.8%
양주1동 989
 
9.9%
회천4동 640
 
6.4%
백석읍 501
 
5.0%
광적면 391
 
3.9%
남면 272
 
2.7%
은현면 257
 
2.6%
장흥면 237
 
2.4%
Other values (8) 552
 
5.5%

Length

2023-12-12T22:49:02.169666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
양주2동 3310
33.1%
회천1동 1472
14.7%
회천2동 1379
13.8%
양주1동 989
 
9.9%
회천4동 640
 
6.4%
백석읍 501
 
5.0%
광적면 391
 
3.9%
남면 272
 
2.7%
은현면 257
 
2.6%
장흥면 237
 
2.4%
Other values (8) 552
 
5.5%

입력담당자
Categorical

HIGH CORRELATION 

Distinct39
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
유민아
1472 
신다빈
1319 
김평화
1009 
오송환
913 
신예선
657 
Other values (34)
4630 

Length

Max length4
Median length3
Mean length3.0545
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고예은
2nd row신다빈
3rd row임지연
4th row조아영
5th row권윤희

Common Values

ValueCountFrequency (%)
유민아 1472
14.7%
신다빈 1319
13.2%
김평화 1009
 
10.1%
오송환 913
 
9.1%
신예선 657
 
6.6%
고예은 624
 
6.2%
유정관 361
 
3.6%
조아영 322
 
3.2%
한보슬 322
 
3.2%
김소연 281
 
2.8%
Other values (29) 2720
27.2%

Length

2023-12-12T22:49:02.300686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
유민아 1472
14.7%
신다빈 1319
13.2%
김평화 1009
 
10.1%
오송환 913
 
9.1%
신예선 657
 
6.6%
고예은 624
 
6.2%
유정관 361
 
3.6%
조아영 322
 
3.2%
한보슬 322
 
3.2%
김소연 281
 
2.8%
Other values (29) 2720
27.2%

Interactions

2023-12-12T22:48:56.750767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.043458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.372913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.853096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.123134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.496276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.953025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.252707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:48:56.635180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:49:02.413743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호구분유형생활환경지원내용주소(동)배분현금예금주관계배분현물품목배분현물품목단위배분현물수량사업명입력부서입력담당자
번호1.0000.4400.3180.4480.3750.6430.5310.4040.8040.9200.0870.8990.7520.915
구분0.4401.0000.4970.3630.2870.457NaNNaN0.5750.7720.0000.3850.5760.882
유형0.3180.4971.0000.4600.2800.2510.2780.2260.6630.7550.0000.3820.7860.837
생활환경0.4480.3630.4601.0000.2400.3510.2470.2670.5490.7710.0860.5320.5980.701
지원내용0.3750.2870.2800.2401.0000.3040.5590.5480.7060.5390.3230.7040.3510.579
주소(동)0.6430.4570.2510.3510.3041.0000.1720.1620.7190.8540.1500.6730.9880.993
배분현금0.531NaN0.2780.2470.5590.1721.0000.660NaNNaNNaN0.7140.1310.659
예금주관계0.404NaN0.2260.2670.5480.1620.6601.0001.000NaNNaN0.7020.1600.416
배분현물품목0.8040.5750.6630.5490.7060.719NaN1.0001.0000.9830.7510.9190.8270.905
배분현물품목단위0.9200.7720.7550.7710.5390.854NaNNaN0.9831.000NaN0.9050.9190.957
배분현물수량0.0870.0000.0000.0860.3230.150NaNNaN0.751NaN1.0000.0430.1890.763
사업명0.8990.3850.3820.5320.7040.6730.7140.7020.9190.9050.0431.0000.7070.874
입력부서0.7520.5760.7860.5980.3510.9880.1310.1600.8270.9190.1890.7071.0001.000
입력담당자0.9150.8820.8370.7010.5790.9930.6590.4160.9050.9570.7630.8741.0001.000
2023-12-12T22:49:02.568203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업명유형주소(동)구분배분현물품목단위지원내용생활환경입력부서예금주관계입력담당자
사업명1.0000.1610.3170.2200.5950.3970.2420.2910.2670.420
유형0.1611.0000.1160.2520.4120.1510.2460.3850.1060.492
주소(동)0.3170.1161.0000.3020.4960.1550.1660.9360.0690.936
구분0.2200.2520.3021.0000.5070.2010.1720.3231.0000.656
배분현물품목단위0.5950.4120.4960.5071.0000.2960.4120.597NaN0.689
지원내용0.3970.1510.1550.2010.2961.0000.1280.1650.3400.278
생활환경0.2420.2460.1660.1720.4120.1281.0000.2400.1320.339
입력부서0.2910.3850.9360.3230.5970.1650.2401.0000.0680.999
예금주관계0.2670.1060.0691.000NaN0.3400.1320.0681.0000.171
입력담당자0.4200.4920.9360.6560.6890.2780.3390.9990.1711.000
2023-12-12T22:49:02.709444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호배분현금배분현물수량구분유형생활환경지원내용주소(동)예금주관계배분현물품목단위사업명입력부서입력담당자
번호1.000-0.282-0.1370.2950.1500.2220.2000.3400.1840.5800.5300.4080.622
배분현금-0.2821.000-0.0851.0000.1820.1490.4120.0960.4400.0000.3610.0720.387
배분현물수량-0.137-0.0851.0000.0000.0000.0430.1990.0771.0001.0000.0200.0760.450
구분0.2951.0000.0001.0000.2520.1720.2010.3021.0000.5070.2200.3230.656
유형0.1500.1820.0000.2521.0000.2460.1510.1160.1060.4120.1610.3850.492
생활환경0.2220.1490.0430.1720.2461.0000.1280.1660.1320.4120.2420.2400.339
지원내용0.2000.4120.1990.2010.1510.1281.0000.1550.3400.2960.3970.1650.278
주소(동)0.3400.0960.0770.3020.1160.1660.1551.0000.0690.4960.3170.9360.936
예금주관계0.1840.4401.0001.0000.1060.1320.3400.0691.0000.0000.2670.0680.171
배분현물품목단위0.5800.0001.0000.5070.4120.4120.2960.4960.0001.0000.5950.5970.689
사업명0.5300.3610.0200.2200.1610.2420.3970.3170.2670.5951.0000.2910.420
입력부서0.4080.0720.0760.3230.3850.2400.1650.9360.0680.5970.2911.0000.999
입력담당자0.6220.3870.4500.6560.4920.3390.2780.9360.1710.6890.4200.9991.000

Missing values

2023-12-12T22:48:57.122679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:48:57.379244image/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.
2023-12-12T22:48:57.580958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

번호구분유형생활환경지원내용주소(동)배분현금예금주관계배분현물품목배분현물품목단위배분현물수량배분현물물품가액배분일자사업명입력부서입력담당자
1215512156개인기타(저소득가정, 중위소득 80%이하)독거노인생계비지원양주1동50000본인<NA><NA>0<NA>2019-01-252019 설명절 감동나눔양주1동고예은
1637416375개인기초생활수급자장애인생계비지원<NA>50000본인<NA><NA>0<NA>2020-01-222020 설명절 감동나눔양주2동신다빈
1751117512개인기초생활수급자수급자현물 지원회천2동<NA><NA>즉석/조리식품<NA>1100002020-01-16일반 나눔회천2동임지연
1805018051개인기초생활수급자독거노인현물 지원양주2동<NA><NA>김치<NA>0<NA>2020-07-08일반 나눔양주2동조아영
67506751개인기초생활수급자차상위현물 지원양주2동<NA><NA>양말(셋트)<NA>1154082018-02-20일반 나눔양주2동권윤희
32223223단체기초생활수급자기타현물 지원양주2동<NA><NA>라면<NA>1<NA>2019-01-22일반 나눔양주2동오송환
1805218053개인기타(저소득가정, 중위소득 80%이하)독거노인현물 지원양주2동<NA><NA>김치<NA>0<NA>2020-07-08일반 나눔양주2동조아영
1689216893개인기타(저소득가정, 중위소득 80%이하)<NA>현물 지원회천4동<NA><NA>기타<NA>1<NA>2019-12-04<NA>회천4동장인영
1077510776개인차상위계층독거노인의료비지원회천1동100000본인<NA><NA>0<NA>2017-09-132017 추석명절 감동나눔회천1동유민아
1591415915단체노인시설기타현물 지원양주2동<NA><NA>선물셋트소박스(스낵바)2<NA>2020-01-212020 설명절 감동나눔양주2동신다빈
번호구분유형생활환경지원내용주소(동)배분현금예금주관계배분현물품목배분현물품목단위배분현물수량배분현물물품가액배분일자사업명입력부서입력담당자
1898118982개인기초생활수급자기타생계비지원회천2동50000본인<NA><NA>0<NA>2020-09-282020 추석명절 감동나눔회천2동김평화
1662516626개인기초생활수급자기타현물 지원광적면<NA><NA>사랑의 감동꾸러미(식료품, 생필품 등)<NA>0<NA>2020-03-27기타광적면유정관
1326913270개인기초생활수급자독거노인<NA>회천2동<NA><NA>김치<NA>1<NA>2018-09-20일반 나눔회천2동김경미
79397940개인기초생활수급자다문화가족현물 지원양주2동<NA><NA>빵<NA>480002018-12-27일반 나눔양주2동신예선
677678개인차상위계층장애인현물 지원백석읍<NA><NA>쌀10kg<NA>1195002017-09-292017 추석명절 감동나눔장애인단체나현철4
2097320974개인차상위계층기타현물 지원양주2동<NA><NA>선물셋트<NA>1<NA>2020-12-012020 의료나눔 희망박스(생필품)지원사업양주2동신다빈
950951개인차상위계층장애인현물 지원회천1동<NA><NA>쌀10kg<NA>1195002017-09-292017 추석명절 감동나눔장애인단체나현철4
2095620957개인차상위계층기타현물 지원양주2동<NA><NA>선물셋트<NA>1<NA>2020-12-012020 의료나눔 희망박스(생필품)지원사업양주2동신다빈
1995619957개인기초생활수급자수급자생계비지원양주2동<NA><NA>김/떡세트<NA>2<NA>2020-09-212020 추석명절 감동나눔양주2동신다빈
1804918050개인기초생활수급자독거노인현물 지원양주2동<NA><NA>김치<NA>0<NA>2020-07-08일반 나눔양주2동조아영