Overview

Dataset statistics

Number of variables7
Number of observations736
Missing cells0
Missing cells (%)0.0%
Duplicate rows92
Duplicate rows (%)12.5%
Total size in memory40.4 KiB
Average record size in memory56.2 B

Variable types

Categorical5
DateTime2

Dataset

Description보령시립도서관(중앙도서관, 죽정도서관) 자원봉사 신청에 대한 데이터로 신청 도서관, 신청일, 신청시간 등의 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=414&beforeMenuCd=DOM_000000201001001000&publicdatapk=15039886

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 92 (12.5%) duplicate rowsDuplicates
신청시간4 is highly overall correlated with 도서관구분 and 1 other fieldsHigh correlation
신청시간3 is highly overall correlated with 도서관구분 and 3 other fieldsHigh correlation
신청시간1 is highly overall correlated with 도서관구분 and 2 other fieldsHigh correlation
도서관구분 is highly overall correlated with 신청시간1 and 3 other fieldsHigh correlation
신청시간2 is highly overall correlated with 도서관구분 and 2 other fieldsHigh correlation

Reproduction

Analysis started2024-01-09 22:13:20.808730
Analysis finished2024-01-09 22:13:21.139343
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

도서관구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
중앙도서관
486 
죽정도서관
250 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row중앙도서관
2nd row중앙도서관
3rd row죽정도서관
4th row죽정도서관
5th row죽정도서관

Common Values

ValueCountFrequency (%)
중앙도서관 486
66.0%
죽정도서관 250
34.0%

Length

2024-01-10T07:13:21.188033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:13:21.262123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중앙도서관 486
66.0%
죽정도서관 250
34.0%

신청일
Date

Distinct296
Distinct (%)40.2%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
Minimum2019-01-02 00:00:00
Maximum2020-07-26 00:00:00
2024-01-10T07:13:21.346235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:13:21.449119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

신청시간1
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
<NA>
409 
13:00~14:00
327 

Length

Max length11
Median length4
Mean length7.1100543
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row13:00~14:00
4th row13:00~14:00
5th row13:00~14:00

Common Values

ValueCountFrequency (%)
<NA> 409
55.6%
13:00~14:00 327
44.4%

Length

2024-01-10T07:13:21.545471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:13:21.624645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 409
55.6%
13:00~14:00 327
44.4%

신청시간2
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
14:00~15:00
397 
<NA>
339 

Length

Max length11
Median length11
Mean length7.7758152
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row14:00~15:00
4th row14:00~15:00
5th row<NA>

Common Values

ValueCountFrequency (%)
14:00~15:00 397
53.9%
<NA> 339
46.1%

Length

2024-01-10T07:13:21.706828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:13:21.787475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
14:00~15:00 397
53.9%
na 339
46.1%

신청시간3
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
<NA>
448 
15:00~16:00
288 

Length

Max length11
Median length4
Mean length6.7391304
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row15:00~16:00
2nd row15:00~16:00
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 448
60.9%
15:00~16:00 288
39.1%

Length

2024-01-10T07:13:21.874627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:13:21.956421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 448
60.9%
15:00~16:00 288
39.1%

신청시간4
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
<NA>
539 
16:00~17:00
197 

Length

Max length11
Median length4
Mean length5.8736413
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row16:00~17:00
2nd row16:00~17:00
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 539
73.2%
16:00~17:00 197
 
26.8%

Length

2024-01-10T07:13:22.046665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:13:22.127935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 539
73.2%
16:00~17:00 197
 
26.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
Minimum2020-09-28 00:00:00
Maximum2020-09-28 00:00:00
2024-01-10T07:13:22.199737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:13:22.270106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-01-10T07:13:22.320398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도서관구분
도서관구분1.000
2024-01-10T07:13:22.383554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청시간4신청시간3신청시간1도서관구분신청시간2
신청시간41.0001.000NaN1.000NaN
신청시간31.0001.0001.0001.0001.000
신청시간1NaN1.0001.0001.0001.000
도서관구분1.0001.0001.0001.0001.000
신청시간2NaN1.0001.0001.0001.000
2024-01-10T07:13:22.467451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도서관구분신청시간1신청시간2신청시간3신청시간4
도서관구분1.0001.0001.0001.0001.000
신청시간11.0001.0001.0001.0000.000
신청시간21.0001.0001.0001.000NaN
신청시간31.0001.0001.0001.0001.000
신청시간41.0000.000NaN1.0001.000

Missing values

2024-01-10T07:13:21.016738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:13:21.103769image/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신청시간3신청시간4데이터기준일자
0중앙도서관2019-01-02<NA><NA>15:00~16:0016:00~17:002020-09-28
1중앙도서관2019-01-03<NA><NA>15:00~16:0016:00~17:002020-09-28
2죽정도서관2019-01-0513:00~14:0014:00~15:00<NA><NA>2020-09-28
3죽정도서관2019-01-1213:00~14:0014:00~15:00<NA><NA>2020-09-28
4죽정도서관2019-01-1913:00~14:00<NA><NA><NA>2020-09-28
5중앙도서관2019-01-03<NA><NA><NA>16:00~17:002020-09-28
6중앙도서관2019-01-02<NA><NA><NA>16:00~17:002020-09-28
7중앙도서관2019-01-07<NA><NA><NA>16:00~17:002020-09-28
8중앙도서관2019-01-0713:00~14:0014:00~15:00<NA><NA>2020-09-28
9죽정도서관2019-01-13<NA>14:00~15:00<NA><NA>2020-09-28
도서관구분신청일신청시간1신청시간2신청시간3신청시간4데이터기준일자
726중앙도서관2020-07-20<NA><NA>15:00~16:0016:00~17:002020-09-28
727중앙도서관2020-07-21<NA><NA>15:00~16:0016:00~17:002020-09-28
728중앙도서관2020-07-22<NA><NA>15:00~16:0016:00~17:002020-09-28
729중앙도서관2020-07-23<NA><NA><NA>16:00~17:002020-09-28
730죽정도서관2020-07-25<NA>14:00~15:0015:00~16:00<NA>2020-09-28
731중앙도서관2020-07-25<NA>14:00~15:0015:00~16:00<NA>2020-09-28
732중앙도서관2020-07-25<NA><NA>15:00~16:0016:00~17:002020-09-28
733중앙도서관2020-07-26<NA><NA>15:00~16:00<NA>2020-09-28
734죽정도서관2020-07-2613:00~14:0014:00~15:00<NA><NA>2020-09-28
735중앙도서관2020-07-26<NA><NA><NA>16:00~17:002020-09-28

Duplicate rows

Most frequently occurring

도서관구분신청일신청시간1신청시간2신청시간3신청시간4데이터기준일자# duplicates
80중앙도서관2019-11-1313:00~14:0014:00~15:00<NA><NA>2020-09-283
0죽정도서관2019-01-13<NA>14:00~15:00<NA><NA>2020-09-282
1죽정도서관2019-02-01<NA><NA>15:00~16:0016:00~17:002020-09-282
2죽정도서관2019-02-08<NA><NA>15:00~16:0016:00~17:002020-09-282
3죽정도서관2019-03-18<NA>14:00~15:00<NA><NA>2020-09-282
4죽정도서관2019-03-3013:00~14:0014:00~15:00<NA><NA>2020-09-282
5죽정도서관2019-04-0713:00~14:0014:00~15:00<NA><NA>2020-09-282
6죽정도서관2019-04-21<NA><NA>15:00~16:0016:00~17:002020-09-282
7죽정도서관2019-05-1813:00~14:00<NA><NA><NA>2020-09-282
8죽정도서관2019-05-26<NA><NA>15:00~16:0016:00~17:002020-09-282