Overview

Dataset statistics

Number of variables4
Number of observations32
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory38.1 B

Variable types

Categorical1
Text1
Numeric2

Dataset

Description한국가스공사 본사 사회공헌 사업의 현황입니다. 사업명과 해당 연도의 계획 및 해당 연도의 실적을 확인할 수 있습니다.
URLhttps://www.data.go.kr/data/15118131/fileData.do

Alerts

22년 계획(백만원) is highly overall correlated with 22년 실적(백만원)High correlation
22년 실적(백만원) is highly overall correlated with 22년 계획(백만원)High correlation
사업명 has unique valuesUnique
22년 계획(백만원) has 1 (3.1%) zerosZeros
22년 실적(백만원) has 5 (15.6%) zerosZeros

Reproduction

Analysis started2023-12-12 14:05:13.100139
Analysis finished2023-12-12 14:05:13.794926
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct4
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size388.0 B
나눔
11 
상생
9 
에너지
6 
미래
6 

Length

Max length3
Median length2
Mean length2.1875
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row에너지
2nd row에너지
3rd row에너지
4th row에너지
5th row에너지

Common Values

ValueCountFrequency (%)
나눔 11
34.4%
상생 9
28.1%
에너지 6
18.8%
미래 6
18.8%

Length

2023-12-12T23:05:13.902066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:05:14.017972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
나눔 11
34.4%
상생 9
28.1%
에너지 6
18.8%
미래 6
18.8%

사업명
Text

UNIQUE 

Distinct32
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size388.0 B
2023-12-12T23:05:14.293358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length18
Mean length14.03125
Min length7

Characters and Unicode

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

Unique

Unique32 ?
Unique (%)100.0%

Sample

1st row열효율 개선사업
2nd row그린뉴딜 창업기업 지원사업
3rd row경력보유여성 사회 재진출 (지역문제해결플랫폼 연계)
4th row에너지 전환마을 (지역문제해결플랫폼 연계)
5th row글로벌 사회공헌
ValueCountFrequency (%)
사업 6
 
5.7%
지원사업 5
 
4.7%
및 3
 
2.8%
활성화 3
 
2.8%
혁신도시 2
 
1.9%
개선사업 2
 
1.9%
사회공헌 2
 
1.9%
소상공인 2
 
1.9%
연계 2
 
1.9%
지역문제해결플랫폼 2
 
1.9%
Other values (75) 77
72.6%
2023-12-12T23:05:14.705537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
74
 
16.5%
사 28
 
6.2%
업 23
 
5.1%
지 13
 
2.9%
원 10
 
2.2%
인 8
 
1.8%
회 8
 
1.8%
공 8
 
1.8%
기 6
 
1.3%
장 5
 
1.1%
Other values (157) 266
59.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 362
80.6%
Space Separator 74
 
16.5%
Uppercase Letter 4
 
0.9%
Close Punctuation 3
 
0.7%
Open Punctuation 3
 
0.7%
Lowercase Letter 2
 
0.4%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 28
 
7.7%
업 23
 
6.4%
지 13
 
3.6%
원 10
 
2.8%
인 8
 
2.2%
회 8
 
2.2%
공 8
 
2.2%
기 6
 
1.7%
장 5
 
1.4%
성 5
 
1.4%
Other values (150) 248
68.5%
Uppercase Letter
ValueCountFrequency (%)
G 2
50.0%
L 2
50.0%
Space Separator
ValueCountFrequency (%)
74
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Lowercase Letter
ValueCountFrequency (%)
n 2
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 362
80.6%
Common 81
 
18.0%
Latin 6
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 28
 
7.7%
업 23
 
6.4%
지 13
 
3.6%
원 10
 
2.8%
인 8
 
2.2%
회 8
 
2.2%
공 8
 
2.2%
기 6
 
1.7%
장 5
 
1.4%
성 5
 
1.4%
Other values (150) 248
68.5%
Common
ValueCountFrequency (%)
74
91.4%
) 3
 
3.7%
( 3
 
3.7%
. 1
 
1.2%
Latin
ValueCountFrequency (%)
G 2
33.3%
L 2
33.3%
n 2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 362
80.6%
ASCII 87
 
19.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
74
85.1%
) 3
 
3.4%
( 3
 
3.4%
G 2
 
2.3%
L 2
 
2.3%
n 2
 
2.3%
. 1
 
1.1%
Hangul
ValueCountFrequency (%)
사 28
 
7.7%
업 23
 
6.4%
지 13
 
3.6%
원 10
 
2.8%
인 8
 
2.2%
회 8
 
2.2%
공 8
 
2.2%
기 6
 
1.7%
장 5
 
1.4%
성 5
 
1.4%
Other values (150) 248
68.5%

22년 계획(백만원)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct19
Distinct (%)59.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean214.75
Minimum0
Maximum2700
Zeros1
Zeros (%)3.1%
Negative0
Negative (%)0.0%
Memory size420.0 B
2023-12-12T23:05:14.825427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile10
Q133.75
median57.5
Q3154.75
95-th percentile835
Maximum2700
Range2700
Interquartile range (IQR)121

Descriptive statistics

Standard deviation497.70324
Coefficient of variation (CV)2.3175937
Kurtosis21.320601
Mean214.75
Median Absolute Deviation (MAD)41
Skewness4.4202379
Sum6872
Variance247708.52
MonotonicityNot monotonic
2023-12-12T23:05:14.965074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
50 6
18.8%
10 3
 
9.4%
150 3
 
9.4%
200 3
 
9.4%
30 3
 
9.4%
2700 1
 
3.1%
700 1
 
3.1%
74 1
 
3.1%
112 1
 
3.1%
75 1
 
3.1%
Other values (9) 9
28.1%
ValueCountFrequency (%)
0 1
 
3.1%
10 3
9.4%
23 1
 
3.1%
30 3
9.4%
35 1
 
3.1%
50 6
18.8%
55 1
 
3.1%
60 1
 
3.1%
74 1
 
3.1%
75 1
 
3.1%
ValueCountFrequency (%)
2700 1
 
3.1%
1000 1
 
3.1%
700 1
 
3.1%
320 1
 
3.1%
200 3
9.4%
169 1
 
3.1%
150 3
9.4%
112 1
 
3.1%
79 1
 
3.1%
75 1
 
3.1%

22년 실적(백만원)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct21
Distinct (%)65.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean181.53125
Minimum0
Maximum2210
Zeros5
Zeros (%)15.6%
Negative0
Negative (%)0.0%
Memory size420.0 B
2023-12-12T23:05:15.123231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q110
median49.5
Q3150
95-th percentile828.95
Maximum2210
Range2210
Interquartile range (IQR)140

Descriptive statistics

Standard deviation424.4896
Coefficient of variation (CV)2.338383
Kurtosis17.718554
Mean181.53125
Median Absolute Deviation (MAD)45
Skewness4.0154206
Sum5809
Variance180191.42
MonotonicityNot monotonic
2023-12-12T23:05:15.282434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 5
15.6%
50 3
 
9.4%
30 3
 
9.4%
10 2
 
6.2%
200 2
 
6.2%
150 2
 
6.2%
2210 1
 
3.1%
42 1
 
3.1%
6 1
 
3.1%
56 1
 
3.1%
Other values (11) 11
34.4%
ValueCountFrequency (%)
0 5
15.6%
3 1
 
3.1%
6 1
 
3.1%
10 2
 
6.2%
20 1
 
3.1%
30 3
9.4%
40 1
 
3.1%
42 1
 
3.1%
49 1
 
3.1%
50 3
9.4%
ValueCountFrequency (%)
2210 1
3.1%
989 1
3.1%
698 1
3.1%
292 1
3.1%
200 2
6.2%
198 1
3.1%
150 2
6.2%
112 1
3.1%
79 1
3.1%
56 1
3.1%

Interactions

2023-12-12T23:05:13.461780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:05:13.280476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:05:13.550058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:05:13.358895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:05:15.381182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분사업명22년 계획(백만원)22년 실적(백만원)
구분1.0001.0000.2440.244
사업명1.0001.0001.0001.000
22년 계획(백만원)0.2441.0001.0001.000
22년 실적(백만원)0.2441.0001.0001.000
2023-12-12T23:05:15.497413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
22년 계획(백만원)22년 실적(백만원)구분
22년 계획(백만원)1.0000.7860.186
22년 실적(백만원)0.7861.0000.186
구분0.1860.1861.000

Missing values

2023-12-12T23:05:13.652637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:05:13.757146image/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

구분사업명22년 계획(백만원)22년 실적(백만원)
0에너지열효율 개선사업27002210
1에너지그린뉴딜 창업기업 지원사업1000989
2에너지경력보유여성 사회 재진출 (지역문제해결플랫폼 연계)1010
3에너지에너지 전환마을 (지역문제해결플랫폼 연계)1010
4에너지글로벌 사회공헌500
5에너지혁신도시 활성화 연계협력사업500
6미래LnG 장학사업320292
7미래LnG 멘토링 사업3520
8미래학교 농구부 활성화 사업5050
9미래탄소중립학교 숲 조성사업7979
구분사업명22년 계획(백만원)22년 실적(백만원)
22나눔임직원 참여 걸음기부 캠페인 사업5050
23나눔재난 극복을 위한 사회공헌사업16942
24나눔이재민 구호키트 제작 사업5049
25나눔행복둥지 주거환경 개선사업6040
26나눔내 집앞 한등 밝히기753
27나눔사업소 온누리펀드 매칭그랜트112112
28나눔법인카드 포인트 사회환원7456
29나눔김장나눔 행사3030
30나눔연탄나눔 행사3030
31나눔혁신도시 공공기관 공동 사회공헌106