Overview

Dataset statistics

Number of variables6
Number of observations52
Missing cells22
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory53.5 B

Variable types

Categorical3
Numeric2
Text1

Dataset

Description1. 개요 연도별 예금보험공사 사회공헌활동 실시 내역 2. 내용 예금보험공사 사회공헌활동에 관한 내용으로 연도별 실시내역의 데이터 3. 단위 (회) 실시횟수 (명) 참여자
URLhttps://www.data.go.kr/data/15078091/fileData.do

Alerts

실시횟수 is highly overall correlated with 참여자High correlation
참여자 is highly overall correlated with 실시횟수High correlation
활동명 is highly overall correlated with 활동내용High correlation
활동내용 is highly overall correlated with 활동명High correlation
실시횟수 has 1 (1.9%) missing valuesMissing
참여자 has 20 (38.5%) missing valuesMissing
활동시설명 has 1 (1.9%) missing valuesMissing

Reproduction

Analysis started2023-12-12 00:52:44.549376
Analysis finished2023-12-12 00:52:45.855340
Duration1.31 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Categorical

Distinct5
Distinct (%)9.6%
Missing0
Missing (%)0.0%
Memory size548.0 B
2018
15 
2019
11 
2022
10 
2020
2021

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2018
2nd row2018
3rd row2018
4th row2018
5th row2018

Common Values

ValueCountFrequency (%)
2018 15
28.8%
2019 11
21.2%
2022 10
19.2%
2020 8
15.4%
2021 8
15.4%

Length

2023-12-12T09:52:45.942827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:52:46.085524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2018 15
28.8%
2019 11
21.2%
2022 10
19.2%
2020 8
15.4%
2021 8
15.4%

활동명
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)38.5%
Missing0
Missing (%)0.0%
Memory size548.0 B
불우이웃돕기 등
행복예감 직거래장터
예보꿈나무 장학사업
1부서 1시설 돕기
농어촌경제활성화지원
Other values (15)
28 

Length

Max length14
Median length11
Mean length9.7884615
Min length4

Unique

Unique7 ?
Unique (%)13.5%

Sample

1st row불우이웃돕기 등
2nd row예보꿈나무 장학사업
3rd row사랑의 빵 만들기
4th row아동보육시설 봉사활동
5th row마이크로크레딧 사업

Common Values

ValueCountFrequency (%)
불우이웃돕기 등 5
 
9.6%
행복예감 직거래장터 5
 
9.6%
예보꿈나무 장학사업 5
 
9.6%
1부서 1시설 돕기 5
 
9.6%
농어촌경제활성화지원 4
 
7.7%
전통시장 활성화 4
 
7.7%
예보 숲 가꾸기(식목행사) 3
 
5.8%
국가유공자, 국군장병 돕기 3
 
5.8%
청계천 정화활동 3
 
5.8%
아동보육시설 봉사활동 2
 
3.8%
Other values (10) 13
25.0%

Length

2023-12-12T09:52:46.249044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
돕기 10
 
8.8%
불우이웃돕기 5
 
4.4%
국가유공자 5
 
4.4%
행복예감 5
 
4.4%
직거래장터 5
 
4.4%
예보꿈나무 5
 
4.4%
장학사업 5
 
4.4%
1부서 5
 
4.4%
1시설 5
 
4.4%
5
 
4.4%
Other values (29) 58
51.3%

실시횟수
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct23
Distinct (%)45.1%
Missing1
Missing (%)1.9%
Infinite0
Infinite (%)0.0%
Mean50.745098
Minimum1
Maximum591
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2023-12-12T09:52:46.403083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q334.5
95-th percentile231
Maximum591
Range590
Interquartile range (IQR)33.5

Descriptive statistics

Standard deviation106.71773
Coefficient of variation (CV)2.1030155
Kurtosis12.707842
Mean50.745098
Median Absolute Deviation (MAD)1
Skewness3.2041011
Sum2588
Variance11388.674
MonotonicityNot monotonic
2023-12-12T09:52:46.581286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
1 15
28.8%
2 11
21.2%
6 3
 
5.8%
212 2
 
3.8%
4 2
 
3.8%
9 1
 
1.9%
47 1
 
1.9%
22 1
 
1.9%
181 1
 
1.9%
59 1
 
1.9%
Other values (13) 13
25.0%
ValueCountFrequency (%)
1 15
28.8%
2 11
21.2%
3 1
 
1.9%
4 2
 
3.8%
6 3
 
5.8%
9 1
 
1.9%
12 1
 
1.9%
15 1
 
1.9%
16 1
 
1.9%
17 1
 
1.9%
ValueCountFrequency (%)
591 1
1.9%
266 1
1.9%
250 1
1.9%
212 2
3.8%
208 1
1.9%
181 1
1.9%
131 1
1.9%
118 1
1.9%
107 1
1.9%
59 1
1.9%

참여자
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct27
Distinct (%)84.4%
Missing20
Missing (%)38.5%
Infinite0
Infinite (%)0.0%
Mean325.65625
Minimum5
Maximum3605
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2023-12-12T09:52:46.750525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile9.3
Q120
median63.5
Q3187
95-th percentile1582.95
Maximum3605
Range3600
Interquartile range (IQR)167

Descriptive statistics

Standard deviation729.64859
Coefficient of variation (CV)2.2405484
Kurtosis13.86566
Mean325.65625
Median Absolute Deviation (MAD)49.5
Skewness3.5716076
Sum10421
Variance532387.07
MonotonicityNot monotonic
2023-12-12T09:52:46.920735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
20 5
 
9.6%
30 2
 
3.8%
136 1
 
1.9%
3605 1
 
1.9%
41 1
 
1.9%
91 1
 
1.9%
6 1
 
1.9%
5 1
 
1.9%
12 1
 
1.9%
1245 1
 
1.9%
Other values (17) 17
32.7%
(Missing) 20
38.5%
ValueCountFrequency (%)
5 1
 
1.9%
6 1
 
1.9%
12 1
 
1.9%
16 1
 
1.9%
20 5
9.6%
30 2
 
3.8%
33 1
 
1.9%
37 1
 
1.9%
41 1
 
1.9%
52 1
 
1.9%
ValueCountFrequency (%)
3605 1
1.9%
1996 1
1.9%
1245 1
1.9%
823 1
1.9%
514 1
1.9%
443 1
1.9%
233 1
1.9%
199 1
1.9%
183 1
1.9%
145 1
1.9%

활동시설명
Text

MISSING 

Distinct27
Distinct (%)52.9%
Missing1
Missing (%)1.9%
Memory size548.0 B
2023-12-12T09:52:47.145035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length7.1568627
Min length3

Characters and Unicode

Total characters365
Distinct characters94
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

Unique17 ?
Unique (%)33.3%

Sample

1st row만덕사회종합복지관 등
2nd row사회복지공동모금회 등
3rd row남산원 등
4th row남산원
5th row사회연대은행
ValueCountFrequency (%)
28
30.1%
통인시장 5
 
5.4%
국가보훈처 5
 
5.4%
사회복지공동모금회 5
 
5.4%
모두 4
 
4.3%
남산원 4
 
4.3%
다문화도서관 4
 
4.3%
가평군 3
 
3.2%
청계천 3
 
3.2%
나눔의 3
 
3.2%
Other values (24) 29
31.2%
2023-12-12T09:52:47.519154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
42
 
11.5%
29
 
7.9%
16
 
4.4%
12
 
3.3%
11
 
3.0%
9
 
2.5%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
1.9%
Other values (84) 215
58.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 323
88.5%
Space Separator 42
 
11.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
29
 
9.0%
16
 
5.0%
12
 
3.7%
11
 
3.4%
9
 
2.8%
8
 
2.5%
8
 
2.5%
8
 
2.5%
7
 
2.2%
7
 
2.2%
Other values (83) 208
64.4%
Space Separator
ValueCountFrequency (%)
42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 323
88.5%
Common 42
 
11.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
29
 
9.0%
16
 
5.0%
12
 
3.7%
11
 
3.4%
9
 
2.8%
8
 
2.5%
8
 
2.5%
8
 
2.5%
7
 
2.2%
7
 
2.2%
Other values (83) 208
64.4%
Common
ValueCountFrequency (%)
42
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 323
88.5%
ASCII 42
 
11.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
42
100.0%
Hangul
ValueCountFrequency (%)
29
 
9.0%
16
 
5.0%
12
 
3.7%
11
 
3.4%
9
 
2.8%
8
 
2.5%
8
 
2.5%
8
 
2.5%
7
 
2.2%
7
 
2.2%
Other values (83) 208
64.4%

활동내용
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)38.5%
Missing0
Missing (%)0.0%
Memory size548.0 B
<NA>
장학금 지급
우리 농산물의 홍보 및 판매
전통시장 활성화
도서관 행사 준비 및 도서정리 등
Other values (15)
26 

Length

Max length18
Median length15
Mean length9.0769231
Min length4

Unique

Unique8 ?
Unique (%)15.4%

Sample

1st row<NA>
2nd row장학금 지급
3rd row제빵 후 완성 제품 후원
4th row원내 환경정리 등
5th row창업자금 대출 자금 지원

Common Values

ValueCountFrequency (%)
<NA> 7
13.5%
장학금 지급 5
9.6%
우리 농산물의 홍보 및 판매 5
9.6%
전통시장 활성화 5
9.6%
도서관 행사 준비 및 도서정리 등 4
 
7.7%
배식 도우미 3
 
5.8%
나무심기 3
 
5.8%
방한용품 전달 3
 
5.8%
정화활동 3
 
5.8%
제빵 후 완성 제품 후원 2
 
3.8%
Other values (10) 12
23.1%

Length

2023-12-12T09:52:47.746604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
13
 
8.8%
8
 
5.4%
na 7
 
4.7%
지급 5
 
3.4%
우리 5
 
3.4%
농산물의 5
 
3.4%
홍보 5
 
3.4%
판매 5
 
3.4%
전통시장 5
 
3.4%
활성화 5
 
3.4%
Other values (44) 85
57.4%

Interactions

2023-12-12T09:52:45.209917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:52:45.016177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:52:45.317235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:52:45.115128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T09:52:47.873839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도활동명실시횟수참여자활동시설명활동내용
연도1.0000.0000.0000.2490.0000.000
활동명0.0001.0000.0000.0000.9710.990
실시횟수0.0000.0001.0001.0000.5280.000
참여자0.2490.0001.0001.0000.0000.000
활동시설명0.0000.9710.5280.0001.0000.989
활동내용0.0000.9900.0000.0000.9891.000
2023-12-12T09:52:48.005891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도활동내용활동명
연도1.0000.0000.000
활동내용0.0001.0000.878
활동명0.0000.8781.000
2023-12-12T09:52:48.113837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
실시횟수참여자연도활동명활동내용
실시횟수1.0000.8200.0000.0000.000
참여자0.8201.0000.1510.0000.000
연도0.0000.1511.0000.0000.000
활동명0.0000.0000.0001.0000.878
활동내용0.0000.0000.0000.8781.000

Missing values

2023-12-12T09:52:45.460350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:52:45.605320image/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-12T09:52:45.743898image/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

연도활동명실시횟수참여자활동시설명활동내용
02018불우이웃돕기 등9<NA>만덕사회종합복지관 등<NA>
12018예보꿈나무 장학사업130사회복지공동모금회 등장학금 지급
22018사랑의 빵 만들기6116남산원 등제빵 후 완성 제품 후원
32018아동보육시설 봉사활동12127남산원원내 환경정리 등
42018마이크로크레딧 사업1<NA>사회연대은행창업자금 대출 자금 지원
52018소상공인 경영환경 개선사업1<NA>사회연대은행소상공인 컨설팅
62018무료급식봉사활동16136나눔의 둥지배식 도우미
720181부서 1시설 돕기107443다문화도서관 모두 등도서관 행사 준비 및 도서정리 등
82018사랑의 집 고치기252해비타트주거환경 개선 활동 참여
92018국가유공자 돕기4<NA>국가보훈처연탄 및 방한용품 전달
연도활동명실시횟수참여자활동시설명활동내용
422022불우이웃돕기 등181<NA>남산원 등<NA>
432022동해안 산불 피해지역 지원1<NA>대한적십자사<NA>
4420221부서 1시설 돕기2212신당종합사회복지관도시락 배달 등
452022무료급식15나눔의 둥지배식 도우미
462022예보 숲 가꾸기(식목행사)16노을공원나무심기
472022전통시장 가는날4791통인시장 등전통시장 활성화
482022청계천 정화활동641청계천정화활동
492022행복예감 직거래장터1<NA>청산농협 등우리 농산물의 홍보 및 판매
502022예보꿈나무 장학사업120사회복지공동모금회 등장학금 지급
512022국가유공자, 국군장병 돕기2<NA>국가보훈처방한용품 전달