Overview

Dataset statistics

Number of variables11
Number of observations2040
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory189.4 KiB
Average record size in memory95.1 B

Variable types

Numeric2
Categorical8
DateTime1

Dataset

Description창원시 도서관사업소의 자원봉사활동 신청 게시판의 원글번호, 원글의코멘트갯수, 카테고리, 자원봉사일, 봉사인원, 링크1클릭수, 링크2클릭수, 조회수, 추천수, 비추천수, 작성자홈페이지, 작성일시, 시작일, 종료일, 봉사부서, 승인여부, 봉사시작시간, 종료시간 정보
Author경상남도 창원시
URLhttps://www.data.go.kr/data/15088808/fileData.do

Alerts

링크1클릭수 has constant value ""Constant
링크2클릭수 has constant value ""Constant
추천수 has constant value ""Constant
비추천수 has constant value ""Constant
일련번호 is highly overall correlated with 조회수 and 1 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 봉사부서High correlation
봉사인원 is highly overall correlated with 카테고리High correlation
봉사부서 is highly overall correlated with 자원봉사일High correlation
일련번호 has unique valuesUnique
조회수 has 720 (35.3%) zerosZeros

Reproduction

Analysis started2023-12-12 10:31:32.030774
Analysis finished2023-12-12 10:31:33.243013
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2040
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1020.5
Minimum1
Maximum2040
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.1 KiB
2023-12-12T19:31:33.354590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile102.95
Q1510.75
median1020.5
Q31530.25
95-th percentile1938.05
Maximum2040
Range2039
Interquartile range (IQR)1019.5

Descriptive statistics

Standard deviation589.04159
Coefficient of variation (CV)0.57720881
Kurtosis-1.2
Mean1020.5
Median Absolute Deviation (MAD)510
Skewness0
Sum2081820
Variance346970
MonotonicityStrictly increasing
2023-12-12T19:31:33.516792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1357 1
 
< 0.1%
1370 1
 
< 0.1%
1369 1
 
< 0.1%
1368 1
 
< 0.1%
1367 1
 
< 0.1%
1366 1
 
< 0.1%
1365 1
 
< 0.1%
1364 1
 
< 0.1%
1363 1
 
< 0.1%
Other values (2030) 2030
99.5%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2040 1
< 0.1%
2039 1
< 0.1%
2038 1
< 0.1%
2037 1
< 0.1%
2036 1
< 0.1%
2035 1
< 0.1%
2034 1
< 0.1%
2033 1
< 0.1%
2032 1
< 0.1%
2031 1
< 0.1%

카테고리
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
hp
408 
mg
312 
sn
305 
ss
298 
hw
254 
Other values (3)
463 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
hp 408
20.0%
mg 312
15.3%
sn 305
15.0%
ss 298
14.6%
hw 254
12.5%
uc 213
10.4%
gh 184
9.0%
ns 66
 
3.2%

Length

2023-12-12T19:31:33.683983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:33.815059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
hp 408
20.0%
mg 312
15.3%
sn 305
15.0%
ss 298
14.6%
hw 254
12.5%
uc 213
10.4%
gh 184
9.0%
ns 66
 
3.2%

자원봉사일
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
오후
901 
오전
867 
off
272 

Length

Max length3
Median length2
Mean length2.1333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row오전
2nd row오전
3rd row오전
4th row오전
5th row오전

Common Values

ValueCountFrequency (%)
오후 901
44.2%
오전 867
42.5%
off 272
 
13.3%

Length

2023-12-12T19:31:33.994905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:34.129945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
오후 901
44.2%
오전 867
42.5%
off 272
 
13.3%

봉사인원
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
1
1041 
2
507 
<NA>
272 
0
216 
4
 
2

Length

Max length4
Median length1
Mean length1.4
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 1041
51.0%
2 507
24.9%
<NA> 272
 
13.3%
0 216
 
10.6%
4 2
 
0.1%
6 2
 
0.1%

Length

2023-12-12T19:31:34.287663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:34.441321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1041
51.0%
2 507
24.9%
na 272
 
13.3%
0 216
 
10.6%
4 2
 
0.1%
6 2
 
0.1%

링크1클릭수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
0
2040 

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 2040
100.0%

Length

2023-12-12T19:31:34.595348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:34.710093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 2040
100.0%

링크2클릭수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
0
2040 

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 2040
100.0%

Length

2023-12-12T19:31:34.823846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:34.924322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 2040
100.0%

조회수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct27
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.9220588
Minimum0
Maximum36
Zeros720
Zeros (%)35.3%
Negative0
Negative (%)0.0%
Memory size18.1 KiB
2023-12-12T19:31:35.053116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q35
95-th percentile10
Maximum36
Range36
Interquartile range (IQR)5

Descriptive statistics

Standard deviation3.7856112
Coefficient of variation (CV)1.2955287
Kurtosis7.9304653
Mean2.9220588
Median Absolute Deviation (MAD)1
Skewness2.1441471
Sum5961
Variance14.330852
MonotonicityNot monotonic
2023-12-12T19:31:35.194181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0 720
35.3%
1 345
16.9%
2 163
 
8.0%
4 147
 
7.2%
3 141
 
6.9%
5 114
 
5.6%
6 97
 
4.8%
7 83
 
4.1%
8 54
 
2.6%
10 45
 
2.2%
Other values (17) 131
 
6.4%
ValueCountFrequency (%)
0 720
35.3%
1 345
16.9%
2 163
 
8.0%
3 141
 
6.9%
4 147
 
7.2%
5 114
 
5.6%
6 97
 
4.8%
7 83
 
4.1%
8 54
 
2.6%
9 35
 
1.7%
ValueCountFrequency (%)
36 1
 
< 0.1%
33 1
 
< 0.1%
28 1
 
< 0.1%
23 2
0.1%
22 1
 
< 0.1%
21 1
 
< 0.1%
20 2
0.1%
19 1
 
< 0.1%
18 4
0.2%
17 4
0.2%

추천수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
0
2040 

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 2040
100.0%

Length

2023-12-12T19:31:35.348207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:35.438750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 2040
100.0%

비추천수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
0
2040 

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 2040
100.0%

Length

2023-12-12T19:31:35.548950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:35.657472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 2040
100.0%

시작일
Date

Distinct126
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
Minimum2020-01-02 00:00:00
Maximum2020-09-27 00:00:00
2023-12-12T19:31:35.782659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:35.929479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

봉사부서
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size16.1 KiB
어린이실
857 
종합자료실
695 
off
272 
대출실
206 
일반자료실
 
10

Length

Max length5
Median length4
Mean length4.1112745
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대출실
2nd row대출실
3rd row대출실
4th row대출실
5th row대출실

Common Values

ValueCountFrequency (%)
어린이실 857
42.0%
종합자료실 695
34.1%
off 272
 
13.3%
대출실 206
 
10.1%
일반자료실 10
 
0.5%

Length

2023-12-12T19:31:36.097255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:31:36.221918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
어린이실 857
42.0%
종합자료실 695
34.1%
off 272
 
13.3%
대출실 206
 
10.1%
일반자료실 10
 
0.5%

Interactions

2023-12-12T19:31:32.698505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:32.426819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:32.815553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:31:32.567705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:31:36.329195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호카테고리자원봉사일봉사인원조회수봉사부서
일련번호1.0000.8020.2140.7840.4850.554
카테고리0.8021.0000.0750.7180.2940.500
자원봉사일0.2140.0751.0000.0030.4160.718
봉사인원0.7840.7180.0031.0000.3470.170
조회수0.4850.2940.4160.3471.0000.238
봉사부서0.5540.5000.7180.1700.2381.000
2023-12-12T19:31:36.434428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자원봉사일봉사인원카테고리봉사부서
자원봉사일1.0000.0040.0470.706
봉사인원0.0041.0000.5490.139
카테고리0.0470.5491.0000.336
봉사부서0.7060.1390.3361.000
2023-12-12T19:31:36.526120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호조회수카테고리자원봉사일봉사인원봉사부서
일련번호1.000-0.5340.5520.1300.4400.262
조회수-0.5341.0000.1480.2010.2090.139
카테고리0.5520.1481.0000.0470.5490.336
자원봉사일0.1300.2010.0471.0000.0040.706
봉사인원0.4400.2090.5490.0041.0000.139
봉사부서0.2620.1390.3360.7060.1391.000

Missing values

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

일련번호카테고리자원봉사일봉사인원링크1클릭수링크2클릭수조회수추천수비추천수시작일봉사부서
01hp오전1005002020-01-12대출실
12hp오전1006002020-01-13대출실
23hp오전1005002020-01-14대출실
34hp오전1005002020-01-15대출실
45hp오전1003002020-01-16대출실
56hp오전1005002020-01-19대출실
67hp오전1006002020-01-20대출실
78hp오전1005002020-01-21대출실
89hp오전1004002020-01-22대출실
910hp오전1005002020-01-23대출실
일련번호카테고리자원봉사일봉사인원링크1클릭수링크2클릭수조회수추천수비추천수시작일봉사부서
20302031hpoff<NA>000002020-09-04off
20312032hp오후1001002020-09-05어린이실
20322033hp오후1001002020-09-06어린이실
20332034hpoff<NA>000002020-09-11off
20342035hp오후1001002020-09-12어린이실
20352036hp오후1001002020-09-13어린이실
20362037hpoff<NA>000002020-09-18off
20372038hp오후1002002020-09-20어린이실
20382039hpoff<NA>000002020-09-25off
20392040hp오후1002002020-09-27어린이실