Overview

Dataset statistics

Number of variables7
Number of observations297
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)0.3%
Total size in memory16.7 KiB
Average record size in memory57.4 B

Variable types

Categorical6
DateTime1

Dataset

Description작은도서관 운영일지2022-09월(작은도서관운영일,요일,작은도서관명,자료실운영일시,열림실운영일시,신규회원,일지등록일)정보를 제공합니다.
Author전라남도 여수시
URLhttps://www.data.go.kr/data/15094009/fileData.do

Alerts

Dataset has 1 (0.3%) duplicate rowsDuplicates
열람실운영시간 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 요일High correlation
요일 is highly overall correlated with 일지High correlation
도서관 is highly overall correlated with 자료실운영시간 and 1 other fieldsHigh correlation
신규회원 is highly imbalanced (90.2%)Imbalance

Reproduction

Analysis started2023-12-12 00:44:02.283203
Analysis finished2023-12-12 00:44:02.921243
Duration0.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일지
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2022-09-27
 
17
2022-09-20
 
15
2022-09-28
 
15
2022-09-23
 
15
2022-09-13
 
15
Other values (21)
220 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique3 ?
Unique (%)1.0%

Sample

1st row2022-09-01
2nd row2022-09-01
3rd row2022-09-01
4th row2022-09-01
5th row2022-09-01

Common Values

ValueCountFrequency (%)
2022-09-27 17
 
5.7%
2022-09-20 15
 
5.1%
2022-09-28 15
 
5.1%
2022-09-23 15
 
5.1%
2022-09-13 15
 
5.1%
2022-09-15 15
 
5.1%
2022-09-21 15
 
5.1%
2022-09-01 15
 
5.1%
2022-09-29 14
 
4.7%
2022-09-07 14
 
4.7%
Other values (16) 147
49.5%

Length

2023-12-12T09:44:03.277855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-09-27 17
 
5.7%
2022-09-28 15
 
5.1%
2022-09-23 15
 
5.1%
2022-09-13 15
 
5.1%
2022-09-15 15
 
5.1%
2022-09-21 15
 
5.1%
2022-09-01 15
 
5.1%
2022-09-20 15
 
5.1%
2022-09-29 14
 
4.7%
2022-09-07 14
 
4.7%
Other values (16) 147
49.5%

도서관
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
웅천지웰
23 
웅천글꽃
23 
학마을
23 
소망
22 
지웰2차
20 
Other values (11)
186 

Length

Max length8
Median length5
Mean length3.4006734
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광림
2nd row지웰2차
3rd row로얄골드빌
4th row웅천지웰
5th row웅천글꽃

Common Values

ValueCountFrequency (%)
웅천지웰 23
 
7.7%
웅천글꽃 23
 
7.7%
학마을 23
 
7.7%
소망 22
 
7.4%
지웰2차 20
 
6.7%
한려 20
 
6.7%
신기부영 20
 
6.7%
힐스테이트 행복 20
 
6.7%
여수중부 20
 
6.7%
현천 20
 
6.7%
Other values (6) 86
29.0%

Length

2023-12-12T09:44:03.425857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
웅천지웰 23
 
7.3%
학마을 23
 
7.3%
웅천글꽃 23
 
7.3%
소망 22
 
6.9%
힐스테이트 20
 
6.3%
현천 20
 
6.3%
여수중부 20
 
6.3%
행복 20
 
6.3%
신기부영 20
 
6.3%
한려 20
 
6.3%
Other values (7) 106
33.4%

요일
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
목
70 
화
60 
수
57 
금
55 
월
40 
Other values (2)
15 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row목
2nd row목
3rd row목
4th row목
5th row목

Common Values

ValueCountFrequency (%)
목 70
23.6%
화 60
20.2%
수 57
19.2%
금 55
18.5%
월 40
13.5%
토 12
 
4.0%
일 3
 
1.0%

Length

2023-12-12T09:44:03.567281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:44:03.676192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
목 70
23.6%
화 60
20.2%
수 57
19.2%
금 55
18.5%
월 40
13.5%
토 12
 
4.0%
일 3
 
1.0%

자료실운영시간
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
10:00~18:00
112 
11:00~18:00
40 
15:00~23:00
23 
09:00~19:00
21 
14:00~17:00
20 
Other values (10)
81 

Length

Max length12
Median length11
Mean length11.003367
Min length11

Unique

Unique4 ?
Unique (%)1.3%

Sample

1st row10:00~18:00
2nd row13:00~18:300
3rd row10:00~18:00
4th row11:00~18:00
5th row11:00~18:00

Common Values

ValueCountFrequency (%)
10:00~18:00 112
37.7%
11:00~18:00 40
 
13.5%
15:00~23:00 23
 
7.7%
09:00~19:00 21
 
7.1%
14:00~17:00 20
 
6.7%
10:00~19:00 20
 
6.7%
10:00~18:30 19
 
6.4%
10:30~18:30 17
 
5.7%
13:00~18:00 11
 
3.7%
13:00~18:30 7
 
2.4%
Other values (5) 7
 
2.4%

Length

2023-12-12T09:44:03.832369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
10:00~18:00 112
37.7%
11:00~18:00 40
 
13.5%
15:00~23:00 23
 
7.7%
09:00~19:00 21
 
7.1%
14:00~17:00 20
 
6.7%
10:00~19:00 20
 
6.7%
10:00~18:30 19
 
6.4%
10:30~18:30 17
 
5.7%
13:00~18:00 11
 
3.7%
13:00~18:30 7
 
2.4%
Other values (5) 7
 
2.4%

열람실운영시간
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
10:00~18:00
93 
11:00~18:00
40 
15:00~23:00
23 
10:00~23:00
20 
09:00~19:00
20 
Other values (11)
101 

Length

Max length12
Median length11
Mean length11
Min length10

Unique

Unique4 ?
Unique (%)1.3%

Sample

1st row10:00~18:00
2nd row13:00~18:30
3rd row10:00~18:00
4th row11:00~18:00
5th row11:00~18:00

Common Values

ValueCountFrequency (%)
10:00~18:00 93
31.3%
11:00~18:00 40
13.5%
15:00~23:00 23
 
7.7%
10:00~23:00 20
 
6.7%
09:00~19:00 20
 
6.7%
10:00~19:00 20
 
6.7%
10:00~18:30 19
 
6.4%
14:00~19:00 19
 
6.4%
10:30~18:30 17
 
5.7%
13:00~18:00 11
 
3.7%
Other values (6) 15
 
5.1%

Length

2023-12-12T09:44:03.984859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
10:00~18:00 93
31.3%
11:00~18:00 40
13.5%
15:00~23:00 23
 
7.7%
10:00~23:00 20
 
6.7%
09:00~19:00 20
 
6.7%
10:00~19:00 20
 
6.7%
10:00~18:30 19
 
6.4%
14:00~19:00 19
 
6.4%
10:30~18:30 17
 
5.7%
13:00~18:00 11
 
3.7%
Other values (6) 15
 
5.1%

신규회원
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
291 
1
 
5
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.3%

Sample

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

Common Values

ValueCountFrequency (%)
0 291
98.0%
1 5
 
1.7%
2 1
 
0.3%

Length

2023-12-12T09:44:04.119056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:44:04.219382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 291
98.0%
1 5
 
1.7%
2 1
 
0.3%

등록일
Date

Distinct275
Distinct (%)92.6%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
Minimum2022-09-01 17:42:00
Maximum2022-10-06 15:30:00
2023-12-12T09:44:04.360041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:44:04.552725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2023-12-12T09:44:04.671113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일지도서관요일자료실운영시간열람실운영시간신규회원
일지1.0000.0000.9980.0000.0000.000
도서관0.0001.0000.0000.9520.9870.395
요일0.9980.0001.0000.4820.4770.000
자료실운영시간0.0000.9520.4821.0000.9900.396
열람실운영시간0.0000.9870.4770.9901.0000.332
신규회원0.0000.3950.0000.3960.3321.000
2023-12-12T09:44:04.809410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
열람실운영시간자료실운영시간신규회원일지요일도서관
열람실운영시간1.0000.9220.1870.0000.2370.749
자료실운영시간0.9221.0000.1930.0000.2380.729
신규회원0.1870.1931.0000.0000.0000.229
일지0.0000.0000.0001.0000.9600.000
요일0.2370.2380.0000.9601.0000.000
도서관0.7490.7290.2290.0000.0001.000
2023-12-12T09:44:04.939042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일지도서관요일자료실운영시간열람실운영시간신규회원
일지1.0000.0000.9600.0000.0000.000
도서관0.0001.0000.0000.7290.7490.229
요일0.9600.0001.0000.2380.2370.000
자료실운영시간0.0000.7290.2381.0000.9220.193
열람실운영시간0.0000.7490.2370.9221.0000.187
신규회원0.0000.2290.0000.1930.1871.000

Missing values

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

일지도서관요일자료실운영시간열람실운영시간신규회원등록일
02022-09-01광림목10:00~18:0010:00~18:0002022-09-01 17:42
12022-09-01지웰2차목13:00~18:30013:00~18:3002022-09-01 17:51
22022-09-01로얄골드빌목10:00~18:0010:00~18:0002022-09-01 17:55
32022-09-01웅천지웰목11:00~18:0011:00~18:0002022-09-01 17:58
42022-09-01웅천글꽃목11:00~18:0011:00~18:0002022-09-01 17:59
52022-09-01한려목10:00~18:0010:00~23:0002022-09-01 18:00
62022-09-01신기부영목10:00~18:0010:00~18:0002022-09-01 18:01
72022-09-01개도목10:00~18:0010:00~18:0002022-09-01 18:16
82022-09-01민들레목10:30~18:3010:30~18:3002022-09-01 18:21
92022-09-01주은금호목10:00~18:3010:00~18:3002022-09-01 18:35
일지도서관요일자료실운영시간열람실운영시간신규회원등록일
2872022-09-30신기부영금10:00~18:0010:00~18:0002022-09-30 17:58
2882022-09-30한려금10:00~18:1110:00~23:0002022-09-30 18:01
2892022-09-30웅천글꽃금11:00~18:0011:00~18:0002022-09-30 18:02
2902022-09-30민들레금10:30~18:3010:30~18:3002022-09-30 18:15
2912022-09-30주은금호금10:00~18:3010:00~18:3002022-09-30 18:30
2922022-09-30소망금09:00~19:0009:00~19:0002022-09-30 18:53
2932022-09-30학마을금15:00~23:0015:00~23:0002022-09-30 22:55
2942022-09-30힐스테이트 행복금14:00~17:0014:00~19:0002022-10-04 14:08
2952022-09-30로얄골드빌금10:00~18:0010:00~18:0002022-10-06 10:21
2962022-09-30여수중부금10:00~19:0010:00~19:0002022-10-06 15:30

Duplicate rows

Most frequently occurring

일지도서관요일자료실운영시간열람실운영시간신규회원등록일# duplicates
02022-09-27개도화10:00~18:0010:00~18:0002022-09-27 18:403