Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.0 KiB
Average record size in memory61.3 B

Variable types

Categorical5
Numeric2

Alerts

anals_trget_year has constant value ""Constant
anals_trget_mt has constant value ""Constant
lbrry_nm is highly overall correlated with lbrry_cd and 1 other fieldsHigh correlation
area_nm is highly overall correlated with lbrry_cd and 1 other fieldsHigh correlation
lbrry_cd is highly overall correlated with lbrry_nm and 1 other fieldsHigh correlation
area_nm is highly imbalanced (78.9%)Imbalance
lon_rate has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:07:26.820965
Analysis finished2023-12-10 10:07:28.493234
Duration1.67 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

anals_trget_year
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2021
100 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2021 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:07:28.836858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 100
100.0%

anals_trget_mt
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
11
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
11 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:07:29.191524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11 100
100.0%

lbrry_nm
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
아리랑도서관
7 
서경로꿈마루도서관
7 
정릉도서관
7 
달빛마루도서관
7 
청수도서관
7 
Other values (11)
65 

Length

Max length9
Median length8
Mean length7.09
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성북정보도서관
2nd row서창도서관
3rd row성북정보도서관
4th row성북정보도서관
5th row성북정보도서관

Common Values

ValueCountFrequency (%)
아리랑도서관 7
 
7.0%
서경로꿈마루도서관 7
 
7.0%
정릉도서관 7
 
7.0%
달빛마루도서관 7
 
7.0%
청수도서관 7
 
7.0%
종암동새날도서관 7
 
7.0%
월곡꿈그림도서관 7
 
7.0%
아리랑어린이도서관 7
 
7.0%
장위행복누림도서관 7
 
7.0%
성북길빛도서관 7
 
7.0%
Other values (6) 30
30.0%

Length

2023-12-10T19:07:29.370549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
아리랑도서관 7
 
7.0%
서경로꿈마루도서관 7
 
7.0%
정릉도서관 7
 
7.0%
달빛마루도서관 7
 
7.0%
청수도서관 7
 
7.0%
종암동새날도서관 7
 
7.0%
월곡꿈그림도서관 7
 
7.0%
아리랑어린이도서관 7
 
7.0%
장위행복누림도서관 7
 
7.0%
성북길빛도서관 7
 
7.0%
Other values (6) 30
30.0%

area_nm
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
서울특별시
95 
인천광역시
 
3
경기도
 
2

Length

Max length5
Median length5
Mean length4.96
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시
2nd row인천광역시
3rd row서울특별시
4th row서울특별시
5th row서울특별시

Common Values

ValueCountFrequency (%)
서울특별시 95
95.0%
인천광역시 3
 
3.0%
경기도 2
 
2.0%

Length

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

Common Values (Plot)

2023-12-10T19:07:29.972658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 95
95.0%
인천광역시 3
 
3.0%
경기도 2
 
2.0%

lbrry_cd
Real number (ℝ)

HIGH CORRELATION 

Distinct16
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1049.8
Minimum100
Maximum31402
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:07:30.145017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum100
5-th percentile100
Q1103
median107
Q3113
95-th percentile124.25
Maximum31402
Range31302
Interquartile range (IQR)10

Descriptive statistics

Standard deviation5364.794
Coefficient of variation (CV)5.110301
Kurtosis29.896045
Mean1049.8
Median Absolute Deviation (MAD)4
Skewness5.5944156
Sum104980
Variance28781014
MonotonicityNot monotonic
2023-12-10T19:07:30.465682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
107 7
 
7.0%
110 7
 
7.0%
115 7
 
7.0%
102 7
 
7.0%
103 7
 
7.0%
114 7
 
7.0%
105 7
 
7.0%
106 7
 
7.0%
113 7
 
7.0%
108 7
 
7.0%
Other values (6) 30
30.0%
ValueCountFrequency (%)
100 6
6.0%
101 6
6.0%
102 7
7.0%
103 7
7.0%
104 6
6.0%
105 7
7.0%
106 7
7.0%
107 7
7.0%
108 7
7.0%
109 7
7.0%
ValueCountFrequency (%)
31402 3
3.0%
300 2
 
2.0%
115 7
7.0%
114 7
7.0%
113 7
7.0%
110 7
7.0%
109 7
7.0%
108 7
7.0%
107 7
7.0%
106 7
7.0%

wkday_nm
Categorical

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
목
15 
금
15 
토
15 
일
14 
화
14 
Other values (2)
27 

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 (%)
목 15
15.0%
금 15
15.0%
토 15
15.0%
일 14
14.0%
화 14
14.0%
월 14
14.0%
수 13
13.0%

Length

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

Common Values (Plot)

2023-12-10T19:07:31.091080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
목 15
15.0%
금 15
15.0%
토 15
15.0%
일 14
14.0%
화 14
14.0%
월 14
14.0%
수 13
13.0%

lon_rate
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.23113
Minimum0.231
Maximum24.394
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:07:31.369613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.231
5-th percentile0.6555
Q113.1815
median15.178
Q317.73625
95-th percentile21.2478
Maximum24.394
Range24.163
Interquartile range (IQR)4.55475

Descriptive statistics

Standard deviation5.8276387
Coefficient of variation (CV)0.40949937
Kurtosis1.1171077
Mean14.23113
Median Absolute Deviation (MAD)2.3185
Skewness-1.2369111
Sum1423.113
Variance33.961373
MonotonicityNot monotonic
2023-12-10T19:07:31.705986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20.817 1
 
1.0%
0.87 1
 
1.0%
13.057 1
 
1.0%
13.276 1
 
1.0%
17.444 1
 
1.0%
7.68 1
 
1.0%
17.254 1
 
1.0%
17.549 1
 
1.0%
18.036 1
 
1.0%
15.425 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
0.231 1
1.0%
0.4 1
1.0%
0.449 1
1.0%
0.622 1
1.0%
0.646 1
1.0%
0.656 1
1.0%
0.666 1
1.0%
0.87 1
1.0%
0.91 1
1.0%
0.927 1
1.0%
ValueCountFrequency (%)
24.394 1
1.0%
23.915 1
1.0%
22.102 1
1.0%
21.534 1
1.0%
21.51 1
1.0%
21.234 1
1.0%
21.209 1
1.0%
21.086 1
1.0%
20.817 1
1.0%
20.503 1
1.0%

Interactions

2023-12-10T19:07:27.530706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:07:27.179818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:07:27.726276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:07:27.353969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:07:31.880197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
lbrry_nmarea_nmlbrry_cdwkday_nmlon_rate
lbrry_nm1.0001.0001.0000.0000.000
area_nm1.0001.0001.0000.0000.509
lbrry_cd1.0001.0001.0000.0000.516
wkday_nm0.0000.0000.0001.0000.710
lon_rate0.0000.5090.5160.7101.000
2023-12-10T19:07:32.093887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
lbrry_nmwkday_nmarea_nm
lbrry_nm1.0000.0000.931
wkday_nm0.0001.0000.000
area_nm0.9310.0001.000
2023-12-10T19:07:32.285263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
lbrry_cdlon_ratelbrry_nmarea_nmwkday_nm
lbrry_cd1.000-0.0200.9260.9950.000
lon_rate-0.0201.0000.0000.3650.479
lbrry_nm0.9260.0001.0000.9310.000
area_nm0.9950.3650.9311.0000.000
wkday_nm0.0000.4790.0000.0001.000

Missing values

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

anals_trget_yearanals_trget_mtlbrry_nmarea_nmlbrry_cdwkday_nmlon_rate
0202111성북정보도서관서울특별시100일20.817
1202111서창도서관인천광역시31402목10.942
2202111성북정보도서관서울특별시100화15.329
3202111성북정보도서관서울특별시100수14.414
4202111성북정보도서관서울특별시100목11.257
5202111성북정보도서관서울특별시100금13.514
6202111성북정보도서관서울특별시100토17.719
7202111서창도서관인천광역시31402금10.106
8202111해오름도서관서울특별시101월0.656
9202111해오름도서관서울특별시101화19.734
anals_trget_yearanals_trget_mtlbrry_nmarea_nmlbrry_cdwkday_nmlon_rate
90202111성북길빛도서관서울특별시114토15.11
91202111글빛도서관서울특별시115일18.915
92202111글빛도서관서울특별시115월0.231
93202111글빛도서관서울특별시115화21.234
94202111글빛도서관서울특별시115수15.801
95202111글빛도서관서울특별시115목13.287
96202111글빛도서관서울특별시115금12.745
97202111글빛도서관서울특별시115토17.788
98202111의왕시중앙도서관경기도300일23.915
99202111의왕시중앙도서관경기도300월1.111