Overview

Dataset statistics

Number of variables10
Number of observations49
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory88.7 B

Variable types

Numeric4
DateTime2
Boolean1
Categorical3

Dataset

Description한국환경산업기술원 녹색경영기업금융지원시스템 기업 질문사항 게시글 데이터(등록일시, 수정일시, 조회수 등)입니다.
URLhttps://www.data.go.kr/data/15120541/fileData.do

Alerts

삭제여부 has constant value ""Constant
게시판Type has constant value ""Constant
번호 is highly overall correlated with 가상글No and 3 other fieldsHigh correlation
가상글No is highly overall correlated with 번호 and 1 other fieldsHigh correlation
상위글No 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
들여쓰기Step is highly overall correlated with 번호 and 2 other fieldsHigh correlation
정렬순서 is highly imbalanced (75.4%)Imbalance
들여쓰기Step is highly imbalanced (75.4%)Imbalance
번호 has unique valuesUnique
가상글No has unique valuesUnique
조회수 has 1 (2.0%) zerosZeros

Reproduction

Analysis started2023-12-12 15:04:09.269246
Analysis finished2023-12-12 15:04:11.184016
Duration1.91 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.428571
Minimum1
Maximum57
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-13T00:04:11.238756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.4
Q115
median28
Q341
95-th percentile53.6
Maximum57
Range56
Interquartile range (IQR)26

Descriptive statistics

Standard deviation16.077935
Coefficient of variation (CV)0.56555551
Kurtosis-1.0623796
Mean28.428571
Median Absolute Deviation (MAD)13
Skewness0.059011552
Sum1393
Variance258.5
MonotonicityNot monotonic
2023-12-13T00:04:11.343604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
1 1
 
2.0%
4 1
 
2.0%
21 1
 
2.0%
22 1
 
2.0%
23 1
 
2.0%
24 1
 
2.0%
25 1
 
2.0%
26 1
 
2.0%
40 1
 
2.0%
41 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
11 1
2.0%
12 1
2.0%
ValueCountFrequency (%)
57 1
2.0%
56 1
2.0%
54 1
2.0%
53 1
2.0%
52 1
2.0%
51 1
2.0%
49 1
2.0%
48 1
2.0%
45 1
2.0%
44 1
2.0%

등록일시
Date

Distinct17
Distinct (%)34.7%
Missing0
Missing (%)0.0%
Memory size524.0 B
Minimum2014-09-30 00:00:00
Maximum2022-08-01 00:00:00
2023-12-13T00:04:11.439351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:11.531101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)

수정일시
Date

Distinct17
Distinct (%)34.7%
Missing0
Missing (%)0.0%
Memory size524.0 B
Minimum2014-09-30 00:00:00
Maximum2022-08-01 00:00:00
2023-12-13T00:04:11.612694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:11.701354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)

삭제여부
Boolean

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size181.0 B
True
49 
ValueCountFrequency (%)
True 49
100.0%
2023-12-13T00:04:11.770952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

게시판Type
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
QNA
49 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
QNA 49
100.0%

Length

2023-12-13T00:04:11.842891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:04:11.913472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
qna 49
100.0%

가상글No
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.836735
Minimum1
Maximum51
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-13T00:04:11.993564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.4
Q115
median27
Q339
95-th percentile48.6
Maximum51
Range50
Interquartile range (IQR)24

Descriptive statistics

Standard deviation14.559285
Coefficient of variation (CV)0.54251329
Kurtosis-1.1280031
Mean26.836735
Median Absolute Deviation (MAD)12
Skewness-0.05847188
Sum1315
Variance211.97279
MonotonicityNot monotonic
2023-12-13T00:04:12.102555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
1 1
 
2.0%
4 1
 
2.0%
20 1
 
2.0%
21 1
 
2.0%
22 1
 
2.0%
23 1
 
2.0%
24 1
 
2.0%
25 1
 
2.0%
38 1
 
2.0%
39 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
11 1
2.0%
12 1
2.0%
ValueCountFrequency (%)
51 1
2.0%
50 1
2.0%
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%

상위글No
Real number (ℝ)

HIGH CORRELATION 

Distinct47
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.387755
Minimum1
Maximum57
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-13T00:04:12.205039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.4
Q114
median28
Q341
95-th percentile53.6
Maximum57
Range56
Interquartile range (IQR)27

Descriptive statistics

Standard deviation16.116524
Coefficient of variation (CV)0.56772802
Kurtosis-1.0726893
Mean28.387755
Median Absolute Deviation (MAD)14
Skewness0.059538068
Sum1391
Variance259.74235
MonotonicityNot monotonic
2023-12-13T00:04:12.307558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
14 2
 
4.1%
12 2
 
4.1%
1 1
 
2.0%
56 1
 
2.0%
21 1
 
2.0%
22 1
 
2.0%
23 1
 
2.0%
24 1
 
2.0%
25 1
 
2.0%
26 1
 
2.0%
Other values (37) 37
75.5%
ValueCountFrequency (%)
1 1
2.0%
2 1
2.0%
3 1
2.0%
4 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
11 1
2.0%
12 2
4.1%
ValueCountFrequency (%)
57 1
2.0%
56 1
2.0%
54 1
2.0%
53 1
2.0%
52 1
2.0%
51 1
2.0%
49 1
2.0%
48 1
2.0%
45 1
2.0%
44 1
2.0%

정렬순서
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
1
47 
2
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 47
95.9%
2 2
 
4.1%

Length

2023-12-13T00:04:12.402509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:04:12.472490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 47
95.9%
2 2
 
4.1%

들여쓰기Step
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
0
47 
1
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 47
95.9%
1 2
 
4.1%

Length

2023-12-13T00:04:12.558850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:04:12.630036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 47
95.9%
1 2
 
4.1%

조회수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct10
Distinct (%)20.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.244898
Minimum0
Maximum24
Zeros1
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-13T00:04:12.699744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q11
median2
Q33
95-th percentile11.4
Maximum24
Range24
Interquartile range (IQR)2

Descriptive statistics

Standard deviation4.9054842
Coefficient of variation (CV)1.511753
Kurtosis12.38236
Mean3.244898
Median Absolute Deviation (MAD)1
Skewness3.4504386
Sum159
Variance24.063776
MonotonicityNot monotonic
2023-12-13T00:04:13.103394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
1 22
44.9%
2 12
24.5%
3 4
 
8.2%
5 3
 
6.1%
24 2
 
4.1%
6 2
 
4.1%
0 1
 
2.0%
9 1
 
2.0%
13 1
 
2.0%
4 1
 
2.0%
ValueCountFrequency (%)
0 1
 
2.0%
1 22
44.9%
2 12
24.5%
3 4
 
8.2%
4 1
 
2.0%
5 3
 
6.1%
6 2
 
4.1%
9 1
 
2.0%
13 1
 
2.0%
24 2
 
4.1%
ValueCountFrequency (%)
24 2
 
4.1%
13 1
 
2.0%
9 1
 
2.0%
6 2
 
4.1%
5 3
 
6.1%
4 1
 
2.0%
3 4
 
8.2%
2 12
24.5%
1 22
44.9%
0 1
 
2.0%

Interactions

2023-12-13T00:04:10.655782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:09.563062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:09.921816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.309442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.724507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:09.650454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.051089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.390097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.804311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:09.739703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.141051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.476653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.891577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:09.826931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.227849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:04:10.563762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:04:13.185928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호등록일시수정일시가상글No상위글No정렬순서들여쓰기Step조회수
번호1.0000.9420.9420.9781.0000.7630.7630.459
등록일시0.9421.0001.0000.9660.9470.5270.5270.627
수정일시0.9421.0001.0000.9660.9470.5270.5270.627
가상글No0.9780.9660.9661.0000.9760.6240.6240.458
상위글No1.0000.9470.9470.9761.0000.2140.2140.409
정렬순서0.7630.5270.5270.6240.2141.0000.9130.909
들여쓰기Step0.7630.5270.5270.6240.2140.9131.0000.909
조회수0.4590.6270.6270.4580.4090.9090.9091.000
2023-12-13T00:04:13.296537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정렬순서들여쓰기Step
정렬순서1.0000.733
들여쓰기Step0.7331.000
2023-12-13T00:04:13.384381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호가상글No상위글No조회수정렬순서들여쓰기Step
번호1.0001.0001.000-0.0760.5450.545
가상글No1.0001.0001.000-0.0760.4370.437
상위글No1.0001.0001.000-0.0770.1360.136
조회수-0.076-0.076-0.0771.0000.6990.699
정렬순서0.5450.4370.1360.6991.0000.733
들여쓰기Step0.5450.4370.1360.6990.7331.000

Missing values

2023-12-13T00:04:11.022932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:04:11.138925image/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

번호등록일시수정일시삭제여부게시판Type가상글No상위글No정렬순서들여쓰기Step조회수
012014-09-302014-09-30YQNA111024
172016-04-012016-04-01YQNA77102
282016-04-012016-04-01YQNA88101
392016-04-012016-04-01YQNA99100
4102016-04-012016-04-01YQNA1010102
5112016-04-012016-04-01YQNA1111101
6162018-03-132018-03-13YQNA1616101
7272018-08-302018-08-31YQNA2627105
8282019-02-272019-02-27YQNA2728105
9292019-02-272019-02-27YQNA2829101
번호등록일시수정일시삭제여부게시판Type가상글No상위글No정렬순서들여쓰기Step조회수
39132017-08-082017-12-05YQNA13122113
40422020-04-092020-04-09YQNA4042102
41432020-04-092020-04-09YQNA4143101
4222014-09-302014-09-30YQNA22101
43142018-01-092018-01-09YQNA1414105
44182018-03-132018-03-13YQNA1718102
45192018-03-132018-03-13YQNA1819103
46392019-10-082019-10-08YQNA3739102
47532022-07-292022-07-29YQNA4853104
48542022-07-292022-07-29YQNA4954101