Overview

Dataset statistics

Number of variables6
Number of observations33
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory55.0 B

Variable types

Numeric3
DateTime1
Text2

Dataset

Description한국환경산업기술원 녹색금융지원시스템 메뉴별 게시글 데이터(등록자 비식별화, 제목, 조회수 등) 2023년도 정보 입니다.
URLhttps://www.data.go.kr/data/15120420/fileData.do

Alerts

연번 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
연번 has unique valuesUnique
등록자 has unique valuesUnique
글번호 has unique valuesUnique
제목 has unique valuesUnique
조회수 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:12:43.562843
Analysis finished2023-12-12 05:12:45.182040
Duration1.62 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201.12121
Minimum1
Maximum305
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2023-12-12T14:12:45.263892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.4
Q122
median288
Q3296
95-th percentile303.4
Maximum305
Range304
Interquartile range (IQR)274

Descriptive statistics

Standard deviation122.13613
Coefficient of variation (CV)0.60727623
Kurtosis-1.139749
Mean201.12121
Median Absolute Deviation (MAD)17
Skewness-0.82347698
Sum6637
Variance14917.235
MonotonicityStrictly increasing
2023-12-12T14:12:45.437349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 1
 
3.0%
297 1
 
3.0%
291 1
 
3.0%
292 1
 
3.0%
293 1
 
3.0%
294 1
 
3.0%
295 1
 
3.0%
296 1
 
3.0%
298 1
 
3.0%
2 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
2 1
3.0%
11 1
3.0%
12 1
3.0%
15 1
3.0%
16 1
3.0%
19 1
3.0%
20 1
3.0%
22 1
3.0%
181 1
3.0%
ValueCountFrequency (%)
305 1
3.0%
304 1
3.0%
303 1
3.0%
301 1
3.0%
300 1
3.0%
299 1
3.0%
298 1
3.0%
297 1
3.0%
296 1
3.0%
295 1
3.0%
Distinct23
Distinct (%)69.7%
Missing0
Missing (%)0.0%
Memory size396.0 B
Minimum2014-05-29 00:00:00
Maximum2023-06-23 00:00:00
2023-12-12T14:12:45.581478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:46.040108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

등록자
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-12T14:12:46.302826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st rowV00000000014237
2nd rowV00000000014238
3rd rowV00000000014239
4th rowV00000000014240
5th rowV00000000014241
ValueCountFrequency (%)
v00000000014237 1
 
3.0%
v00000000014254 1
 
3.0%
v00000000014268 1
 
3.0%
v00000000014267 1
 
3.0%
v00000000014266 1
 
3.0%
v00000000014265 1
 
3.0%
v00000000014264 1
 
3.0%
v00000000014263 1
 
3.0%
v00000000014262 1
 
3.0%
v00000000014261 1
 
3.0%
Other values (23) 23
69.7%
2023-12-12T14:12:46.694452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 300
60.6%
4 46
 
9.3%
1 36
 
7.3%
2 36
 
7.3%
V 33
 
6.7%
5 13
 
2.6%
6 13
 
2.6%
3 6
 
1.2%
7 4
 
0.8%
8 4
 
0.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 462
93.3%
Uppercase Letter 33
 
6.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 300
64.9%
4 46
 
10.0%
1 36
 
7.8%
2 36
 
7.8%
5 13
 
2.8%
6 13
 
2.8%
3 6
 
1.3%
7 4
 
0.9%
8 4
 
0.9%
9 4
 
0.9%
Uppercase Letter
ValueCountFrequency (%)
V 33
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 462
93.3%
Latin 33
 
6.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 300
64.9%
4 46
 
10.0%
1 36
 
7.8%
2 36
 
7.8%
5 13
 
2.8%
6 13
 
2.8%
3 6
 
1.3%
7 4
 
0.9%
8 4
 
0.9%
9 4
 
0.9%
Latin
ValueCountFrequency (%)
V 33
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 495
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 300
60.6%
4 46
 
9.3%
1 36
 
7.3%
2 36
 
7.3%
V 33
 
6.7%
5 13
 
2.6%
6 13
 
2.6%
3 6
 
1.2%
7 4
 
0.8%
8 4
 
0.8%

글번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean119.12121
Minimum1
Maximum192
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2023-12-12T14:12:46.892938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.4
Q122
median175
Q3183
95-th percentile190.4
Maximum192
Range191
Interquartile range (IQR)161

Descriptive statistics

Standard deviation74.620187
Coefficient of variation (CV)0.62642233
Kurtosis-1.5101
Mean119.12121
Median Absolute Deviation (MAD)17
Skewness-0.51931875
Sum3931
Variance5568.1723
MonotonicityStrictly increasing
2023-12-12T14:12:47.046689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 1
 
3.0%
184 1
 
3.0%
178 1
 
3.0%
179 1
 
3.0%
180 1
 
3.0%
181 1
 
3.0%
182 1
 
3.0%
183 1
 
3.0%
185 1
 
3.0%
2 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
2 1
3.0%
11 1
3.0%
12 1
3.0%
15 1
3.0%
16 1
3.0%
19 1
3.0%
20 1
3.0%
22 1
3.0%
69 1
3.0%
ValueCountFrequency (%)
192 1
3.0%
191 1
3.0%
190 1
3.0%
188 1
3.0%
187 1
3.0%
186 1
3.0%
185 1
3.0%
184 1
3.0%
183 1
3.0%
182 1
3.0%

제목
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-12T14:12:47.330790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length31
Mean length23.090909
Min length11

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row서비스안정화 작업 공지
2nd row<저작권 정책 안내>
3rd row복지 부정수급 10대 분야 신고기간 운영 안내
4th row2013년도 반부패 경쟁력 평가 결과_한국환경산업기술원 최상위기관
5th row[녹색금융 교육, 제1강] 녹색금융의 이해
ValueCountFrequency (%)
녹색금융 14
 
9.5%
안내 7
 
4.7%
esg 4
 
2.7%
3
 
2.0%
부정수급 3
 
2.0%
환경정책자금 3
 
2.0%
반부패 2
 
1.4%
전산실 2
 
1.4%
동향보고(7월 2
 
1.4%
2017년도 2
 
1.4%
Other values (97) 106
71.6%
2023-12-12T14:12:47.847406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
117
 
15.4%
. 23
 
3.0%
1 23
 
3.0%
22
 
2.9%
20
 
2.6%
2 20
 
2.6%
18
 
2.4%
18
 
2.4%
18
 
2.4%
5 16
 
2.1%
Other values (146) 467
61.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 431
56.6%
Space Separator 117
 
15.4%
Decimal Number 103
 
13.5%
Other Punctuation 34
 
4.5%
Uppercase Letter 21
 
2.8%
Close Punctuation 20
 
2.6%
Open Punctuation 20
 
2.6%
Math Symbol 12
 
1.6%
Initial Punctuation 1
 
0.1%
Final Punctuation 1
 
0.1%
Other values (2) 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
22
 
5.1%
20
 
4.6%
18
 
4.2%
18
 
4.2%
18
 
4.2%
14
 
3.2%
13
 
3.0%
12
 
2.8%
12
 
2.8%
10
 
2.3%
Other values (113) 274
63.6%
Decimal Number
ValueCountFrequency (%)
1 23
22.3%
2 20
19.4%
5 16
15.5%
0 11
10.7%
7 9
 
8.7%
4 8
 
7.8%
9 4
 
3.9%
6 4
 
3.9%
8 4
 
3.9%
3 4
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
G 6
28.6%
E 5
23.8%
S 4
19.0%
O 2
 
9.5%
N 2
 
9.5%
K 1
 
4.8%
H 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
. 23
67.6%
, 6
 
17.6%
' 4
 
11.8%
· 1
 
2.9%
Math Symbol
ValueCountFrequency (%)
~ 10
83.3%
< 1
 
8.3%
> 1
 
8.3%
Close Punctuation
ValueCountFrequency (%)
) 16
80.0%
] 4
 
20.0%
Open Punctuation
ValueCountFrequency (%)
( 16
80.0%
[ 4
 
20.0%
Space Separator
ValueCountFrequency (%)
117
100.0%
Initial Punctuation
ValueCountFrequency (%)
1
100.0%
Final Punctuation
ValueCountFrequency (%)
1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 431
56.6%
Common 310
40.7%
Latin 21
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
22
 
5.1%
20
 
4.6%
18
 
4.2%
18
 
4.2%
18
 
4.2%
14
 
3.2%
13
 
3.0%
12
 
2.8%
12
 
2.8%
10
 
2.3%
Other values (113) 274
63.6%
Common
ValueCountFrequency (%)
117
37.7%
. 23
 
7.4%
1 23
 
7.4%
2 20
 
6.5%
5 16
 
5.2%
) 16
 
5.2%
( 16
 
5.2%
0 11
 
3.5%
~ 10
 
3.2%
7 9
 
2.9%
Other values (16) 49
15.8%
Latin
ValueCountFrequency (%)
G 6
28.6%
E 5
23.8%
S 4
19.0%
O 2
 
9.5%
N 2
 
9.5%
K 1
 
4.8%
H 1
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 431
56.6%
ASCII 328
43.0%
Punctuation 2
 
0.3%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
117
35.7%
. 23
 
7.0%
1 23
 
7.0%
2 20
 
6.1%
5 16
 
4.9%
) 16
 
4.9%
( 16
 
4.9%
0 11
 
3.4%
~ 10
 
3.0%
7 9
 
2.7%
Other values (20) 67
20.4%
Hangul
ValueCountFrequency (%)
22
 
5.1%
20
 
4.6%
18
 
4.2%
18
 
4.2%
18
 
4.2%
14
 
3.2%
13
 
3.0%
12
 
2.8%
12
 
2.8%
10
 
2.3%
Other values (113) 274
63.6%
Punctuation
ValueCountFrequency (%)
1
50.0%
1
50.0%
None
ValueCountFrequency (%)
· 1
100.0%

조회수
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean138.9697
Minimum7
Maximum813
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2023-12-12T14:12:48.017757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile26.4
Q153
median117
Q3164
95-th percentile298
Maximum813
Range806
Interquartile range (IQR)111

Descriptive statistics

Standard deviation141.10202
Coefficient of variation (CV)1.0153438
Kurtosis16.578009
Mean138.9697
Median Absolute Deviation (MAD)56
Skewness3.5988291
Sum4586
Variance19909.78
MonotonicityNot monotonic
2023-12-12T14:12:48.179497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
123 1
 
3.0%
98 1
 
3.0%
53 1
 
3.0%
47 1
 
3.0%
48 1
 
3.0%
36 1
 
3.0%
51 1
 
3.0%
54 1
 
3.0%
109 1
 
3.0%
117 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
7 1
3.0%
12 1
3.0%
36 1
3.0%
38 1
3.0%
45 1
3.0%
47 1
3.0%
48 1
3.0%
51 1
3.0%
53 1
3.0%
54 1
3.0%
ValueCountFrequency (%)
813 1
3.0%
307 1
3.0%
292 1
3.0%
228 1
3.0%
178 1
3.0%
176 1
3.0%
172 1
3.0%
171 1
3.0%
164 1
3.0%
160 1
3.0%

Interactions

2023-12-12T14:12:44.634584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:43.866615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:44.268803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:44.738502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:43.995059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:44.385765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:44.850049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:44.150010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:12:44.515011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:12:48.278474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번등록일시등록자글번호제목조회수
연번1.0001.0001.0001.0001.0000.692
등록일시1.0001.0001.0001.0001.0000.973
등록자1.0001.0001.0001.0001.0001.000
글번호1.0001.0001.0001.0001.0000.728
제목1.0001.0001.0001.0001.0001.000
조회수0.6920.9731.0000.7281.0001.000
2023-12-12T14:12:48.406527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번글번호조회수
연번1.0001.000-0.546
글번호1.0001.000-0.546
조회수-0.546-0.5461.000

Missing values

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

연번등록일시등록자글번호제목조회수
012014-05-29V000000000142371서비스안정화 작업 공지123
122014-06-30V000000000142382<저작권 정책 안내>117
2112014-10-01V0000000001423911복지 부정수급 10대 분야 신고기간 운영 안내151
3122014-10-02V00000000014240122013년도 반부패 경쟁력 평가 결과_한국환경산업기술원 최상위기관160
4152015-01-08V0000000001424115[녹색금융 교육, 제1강] 녹색금융의 이해164
5162015-01-08V0000000001424216[녹색금융 교육, 제2강] 녹색금융과 녹색산업147
6192015-01-20V00000000014243192015년도 환경정책자금 융자공고176
7202015-02-03V0000000001424420[작업공지] 서버 정기점검 및 전산실 전원 작업132
8222015-09-17V0000000001424522[2015.7.1-9.30] 국고보조금 부정수급 집중신고기간 운영안내172
91812017-03-31V00000000014246692017년도 2분기 환경정책자금 융자 공고171
연번등록일시등록자글번호제목조회수
232952020-09-23V00000000014260182녹색금융 동향보고(5.29~6.5)51
242962020-09-23V00000000014261183녹색금융 동향보고(6.6~6.12)54
252972020-09-23V00000000014262184녹색금융 동향보고(7월, 국내)98
262982020-09-23V00000000014263185녹색금융 동향보고(7월, 해외)109
272992020-12-30V00000000014264186환경부, 금융위원회, ‘한국형 녹색채권 안내서’ 발간112
283002021-02-01V00000000014265187녹색금융 동향 소식지228
293012022-08-22V00000000014266188정전관련 웹사이트 서비스 일시 중단 안내96
303032023-05-02V00000000014267190제2회 ESG ON 세미나 개최91
313042023-06-12V00000000014268191제3회 ESG ON 세미나 개최 안내12
323052023-06-23V00000000014269192제1회 ESG 전문인력 양성과정 안내 및 홍보 요청7