gimi9 Pandas Profiling

Dataset statistics

Number of variables	15
Number of observations	1076
Missing cells	1
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	136.7 KiB
Average record size in memory	130.1 B

Variable types

Text	3
Categorical	2
Numeric	10

Dataset

Description	2014년도 광진정보도서관 도서대출 현황 자료
Author	광진구시설관리공단
URL	https://www.data.go.kr/data/15044589/fileData.do

Alerts

`Unnamed: 2` is highly overall correlated with `Unnamed: 3` and 10 other fields	High correlation
`Unnamed: 13` is highly overall correlated with `Unnamed: 2`	High correlation
`Unnamed: 3` is highly overall correlated with `Unnamed: 4` and 9 other fields	High correlation
`Unnamed: 4` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 5` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 6` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 7` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 8` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 9` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 10` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 11` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 12` is highly overall correlated with `Unnamed: 3` and 9 other fields	High correlation
`Unnamed: 13` is highly imbalanced (98.9%)	Imbalance
`Unnamed: 3` is highly skewed (γ1 = 32.72338645)	Skewed
`Unnamed: 4` is highly skewed (γ1 = 32.72857966)	Skewed
`Unnamed: 5` is highly skewed (γ1 = 32.69731247)	Skewed
`Unnamed: 6` is highly skewed (γ1 = 32.72749441)	Skewed
`Unnamed: 7` is highly skewed (γ1 = 32.71058426)	Skewed
`Unnamed: 8` is highly skewed (γ1 = 32.72820222)	Skewed
`Unnamed: 9` is highly skewed (γ1 = 32.70552487)	Skewed
`Unnamed: 10` is highly skewed (γ1 = 32.70855405)	Skewed
`Unnamed: 11` is highly skewed (γ1 = 32.72287163)	Skewed
`Unnamed: 12` is highly skewed (γ1 = 32.71133123)	Skewed
`Unnamed: 0` has unique values	Unique
`Unnamed: 3` has 56 (5.2%) zeros	Zeros
`Unnamed: 4` has 103 (9.6%) zeros	Zeros
`Unnamed: 5` has 295 (27.4%) zeros	Zeros
`Unnamed: 6` has 12 (1.1%) zeros	Zeros
`Unnamed: 7` has 47 (4.4%) zeros	Zeros
`Unnamed: 8` has 54 (5.0%) zeros	Zeros
`Unnamed: 9` has 137 (12.7%) zeros	Zeros
`Unnamed: 10` has 112 (10.4%) zeros	Zeros
`Unnamed: 12` has 38 (3.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 05:49:28.091688
Analysis finished	2023-12-12 05:49:41.330941
Duration	13.24 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

Unnamed: 0
Text

UNIQUE

Distinct	1076
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

Length

Max length	4
Median length	3
Mean length	2.9674721
Min length	1

Characters and Unicode

Total characters	3193
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1076 ?
Unique (%)	100.0%

Sample

1st row	번호
2nd row	1
3rd row	2
4th row	3
5th row	4

Value	Count	Frequency (%)
번호	1	0.1%
722	1	0.1%
738	1	0.1%
709	1	0.1%
710	1	0.1%
711	1	0.1%
712	1	0.1%
713	1	0.1%
714	1	0.1%
715	1	0.1%
Other values (1066)	1066	99.1%

Most occurring characters

Value	Count	Frequency (%)
1	393	12.3%
3	318	10.0%
2	318	10.0%
4	318	10.0%
5	317	9.9%
6	317	9.9%
7	312	9.8%
8	307	9.6%
9	307	9.6%
0	282	8.8%
Other values (4)	4	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3189	99.9%
Other Letter	4	0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	393	12.3%
3	318	10.0%
2	318	10.0%
4	318	10.0%
5	317	9.9%
6	317	9.9%
7	312	9.8%
8	307	9.6%
9	307	9.6%
0	282	8.8%

Other Letter

Value	Count	Frequency (%)
번	1	25.0%
호	1	25.0%
합	1	25.0%
계	1	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3189	99.9%
Hangul	4	0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	393	12.3%
3	318	10.0%
2	318	10.0%
4	318	10.0%
5	317	9.9%
6	317	9.9%
7	312	9.8%
8	307	9.6%
9	307	9.6%
0	282	8.8%

Hangul

Value	Count	Frequency (%)
번	1	25.0%
호	1	25.0%
합	1	25.0%
계	1	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3189	99.9%
Hangul	4	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	393	12.3%
3	318	10.0%
2	318	10.0%
4	318	10.0%
5	317	9.9%
6	317	9.9%
7	312	9.8%
8	307	9.6%
9	307	9.6%
0	282	8.8%

Hangul

Value	Count	Frequency (%)
번	1	25.0%
호	1	25.0%
합	1	25.0%
계	1	25.0%

Unnamed: 1
Text

Distinct	359
Distinct (%)	33.4%
Missing	1
Missing (%)	0.1%
Memory size	8.5 KiB

Length

Max length	10
Median length	10
Mean length	9.9925581
Min length	2

Characters and Unicode

Total characters	10742
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	일자
2nd row	2014-01-01
3rd row	2014-01-01
4th row	2014-01-01
5th row	2014-01-02

Value	Count	Frequency (%)
2014-06-29	3	0.3%
2014-01-01	3	0.3%
2014-09-01	3	0.3%
2014-08-31	3	0.3%
2014-08-30	3	0.3%
2014-08-29	3	0.3%
2014-08-28	3	0.3%
2014-08-27	3	0.3%
2014-08-26	3	0.3%
2014-08-25	3	0.3%
Other values (349)	1045	97.2%

Most occurring characters

Value	Count	Frequency (%)
0	2412	22.5%
-	2148	20.0%
1	1998	18.6%
2	1680	15.6%
4	1272	11.8%
3	249	2.3%
5	198	1.8%
7	198	1.8%
8	198	1.8%
6	195	1.8%
Other values (3)	194	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8592	80.0%
Dash Punctuation	2148	20.0%
Other Letter	2	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2412	28.1%
1	1998	23.3%
2	1680	19.6%
4	1272	14.8%
3	249	2.9%
5	198	2.3%
7	198	2.3%
8	198	2.3%
6	195	2.3%
9	192	2.2%

Other Letter

Value	Count	Frequency (%)
일	1	50.0%
자	1	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2148	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10740	> 99.9%
Hangul	2	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2412	22.5%
-	2148	20.0%
1	1998	18.6%
2	1680	15.6%
4	1272	11.8%
3	249	2.3%
5	198	1.8%
7	198	1.8%
8	198	1.8%
6	195	1.8%

Hangul

Value	Count	Frequency (%)
일	1	50.0%
자	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10740	> 99.9%
Hangul	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2412	22.5%
-	2148	20.0%
1	1998	18.6%
2	1680	15.6%
4	1272	11.8%
3	249	2.3%
5	198	1.8%
7	198	1.8%
8	198	1.8%
6	195	1.8%

Hangul

Value	Count	Frequency (%)
일	1	50.0%
자	1	50.0%

Unnamed: 2
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

구의3동도서관	358
광진정보도서관	358
서울특별시	358
소속기관	1
<NA>	1

Length

Max length	7
Median length	7
Mean length	6.3289963
Min length	4

Unique

Unique	2 ?
Unique (%)	0.2%

Sample

1st row	소속기관
2nd row	구의3동도서관
3rd row	광진정보도서관
4th row	서울특별시
5th row	구의3동도서관

Common Values

Value	Count	Frequency (%)
구의3동도서관	358	33.3%
광진정보도서관	358	33.3%
서울특별시	358	33.3%
소속기관	1	0.1%
<NA>	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
구의3동도서관	358	33.3%
광진정보도서관	358	33.3%
서울특별시	358	33.3%
소속기관	1	0.1%
na	1	0.1%

Unnamed: 3
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	168
Distinct (%)	15.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.053903

Minimum	0
Maximum	41455
Zeros	56
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	9
Q3	78
95-th percentile	143
Maximum	41455
Range	41455
Interquartile range (IQR)	74

Descriptive statistics

Standard deviation	1263.6175
Coefficient of variation (CV)	16.399136
Kurtosis	1072.5371
Mean	77.053903
Median Absolute Deviation (MAD)	7
Skewness	32.723386
Sum	82910
Variance	1596729.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	74	6.9%
1	73	6.8%
4	64	5.9%
3	62	5.8%
0	56	5.2%
6	49	4.6%
5	48	4.5%
7	45	4.2%
8	42	3.9%
9	37	3.4%
Other values (158)	526	48.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	56	5.2%
1	73	6.8%
2	74	6.9%
3	62	5.8%
4	64	5.9%
5	48	4.5%
6	49	4.6%
7	45	4.2%
8	42	3.9%
9	37	3.4%

Value	Count	Frequency (%)
41455	1	0.1%
264	1	0.1%
228	1	0.1%
212	1	0.1%
206	1	0.1%
204	1	0.1%
197	1	0.1%
190	1	0.1%
186	2	0.2%
183	1	0.1%

Unnamed: 4
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	136
Distinct (%)	12.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.775093

Minimum	0
Maximum	33723
Zeros	103
Zeros (%)	9.6%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	9
Q3	66
95-th percentile	111
Maximum	33723
Range	33723
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	1027.8759
Coefficient of variation (CV)	16.373945
Kurtosis	1072.765
Mean	62.775093
Median Absolute Deviation (MAD)	8
Skewness	32.72858
Sum	67546
Variance	1056528.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	103	9.6%
1	97	9.0%
2	77	7.2%
3	57	5.3%
4	40	3.7%
7	39	3.6%
5	36	3.3%
6	34	3.2%
9	31	2.9%
8	31	2.9%
Other values (126)	531	49.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	103	9.6%
1	97	9.0%
2	77	7.2%
3	57	5.3%
4	40	3.7%
5	36	3.3%
6	34	3.2%
7	39	3.6%
8	31	2.9%
9	31	2.9%

Value	Count	Frequency (%)
33723	1	0.1%
183	1	0.1%
163	1	0.1%
158	1	0.1%
143	1	0.1%
140	1	0.1%
139	1	0.1%
137	2	0.2%
136	2	0.2%
135	2	0.2%

Unnamed: 5
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	51
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.910781

Minimum	0
Maximum	8998
Zeros	295
Zeros (%)	27.4%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	16
95-th percentile	32
Maximum	8998
Range	8998
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	274.34201
Coefficient of variation (CV)	16.222906
Kurtosis	1071.3826
Mean	16.910781
Median Absolute Deviation (MAD)	2
Skewness	32.697312
Sum	18196
Variance	75263.54
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	295	27.4%
1	171	15.9%
2	98	9.1%
3	51	4.7%
4	44	4.1%
5	24	2.2%
7	23	2.1%
20	21	2.0%
17	18	1.7%
22	18	1.7%
Other values (41)	313	29.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	295	27.4%
1	171	15.9%
2	98	9.1%
3	51	4.7%
4	44	4.1%
5	24	2.2%
6	16	1.5%
7	23	2.1%
8	12	1.1%
9	10	0.9%

Value	Count	Frequency (%)
8998	1	0.1%
200	1	0.1%
51	1	0.1%
49	1	0.1%
48	2	0.2%
47	3	0.3%
44	1	0.1%
43	3	0.3%
42	3	0.3%
41	2	0.2%

Unnamed: 6
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	268
Distinct (%)	24.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	178.47398

Minimum	0
Maximum	95869
Zeros	12
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	9
median	24
Q3	188
95-th percentile	332.25
Maximum	95869
Range	95869
Interquartile range (IQR)	179

Descriptive statistics

Standard deviation	2922.1159
Coefficient of variation (CV)	16.372784
Kurtosis	1072.7173
Mean	178.47398
Median Absolute Deviation (MAD)	18
Skewness	32.727494
Sum	192038
Variance	8538761.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	40	3.7%
7	38	3.5%
6	38	3.5%
9	35	3.3%
5	33	3.1%
3	31	2.9%
4	31	2.9%
13	24	2.2%
2	21	2.0%
11	20	1.9%
Other values (258)	765	71.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12	1.1%
1	15	1.4%
2	21	2.0%
3	31	2.9%
4	31	2.9%
5	33	3.1%
6	38	3.5%
7	38	3.5%
8	40	3.7%
9	35	3.3%

Value	Count	Frequency (%)
95869	1	0.1%
490	1	0.1%
438	1	0.1%
424	1	0.1%
421	1	0.1%
415	1	0.1%
413	1	0.1%
411	1	0.1%
399	1	0.1%
393	1	0.1%

Unnamed: 7
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	222
Distinct (%)	20.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	105.60409

Minimum	0
Maximum	56615
Zeros	47
Zeros (%)	4.4%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	4.75
median	12
Q3	91.25
95-th percentile	216.25
Maximum	56615
Range	56615
Interquartile range (IQR)	86.5

Descriptive statistics

Standard deviation	1725.9337
Coefficient of variation (CV)	16.343436
Kurtosis	1071.9749
Mean	105.60409
Median Absolute Deviation (MAD)	10
Skewness	32.710584
Sum	113630
Variance	2978847.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	59	5.5%
4	59	5.5%
3	58	5.4%
5	51	4.7%
0	47	4.4%
2	46	4.3%
6	41	3.8%
7	40	3.7%
8	39	3.6%
9	33	3.1%
Other values (212)	603	56.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	47	4.4%
1	59	5.5%
2	46	4.3%
3	58	5.4%
4	59	5.5%
5	51	4.7%
6	41	3.8%
7	40	3.7%
8	39	3.6%
9	33	3.1%

Value	Count	Frequency (%)
56615	1	0.1%
400	1	0.1%
381	1	0.1%
353	1	0.1%
345	1	0.1%
335	1	0.1%
334	1	0.1%
307	1	0.1%
303	1	0.1%
296	1	0.1%

Unnamed: 8
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	175
Distinct (%)	16.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88.962825

Minimum	0
Maximum	47612
Zeros	54
Zeros (%)	5.0%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.75
Q1	4
median	14
Q3	91.25
95-th percentile	155.25
Maximum	47612
Range	47612
Interquartile range (IQR)	87.25

Descriptive statistics

Standard deviation	1451.2079
Coefficient of variation (CV)	16.31252
Kurtosis	1072.7476
Mean	88.962825
Median Absolute Deviation (MAD)	12
Skewness	32.728202
Sum	95724
Variance	2106004.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	67	6.2%
2	65	6.0%
3	58	5.4%
0	54	5.0%
4	41	3.8%
8	38	3.5%
7	33	3.1%
5	32	3.0%
6	30	2.8%
13	27	2.5%
Other values (165)	631	58.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	54	5.0%
1	67	6.2%
2	65	6.0%
3	58	5.4%
4	41	3.8%
5	32	3.0%
6	30	2.8%
7	33	3.1%
8	38	3.5%
9	24	2.2%

Value	Count	Frequency (%)
47612	1	0.1%
500	1	0.1%
225	1	0.1%
206	1	0.1%
198	1	0.1%
195	2	0.2%
192	1	0.1%
190	1	0.1%
187	1	0.1%
184	2	0.2%

Unnamed: 9
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	123
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.239777

Minimum	0
Maximum	29419
Zeros	137
Zeros (%)	12.7%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	7
Q3	55
95-th percentile	103
Maximum	29419
Range	29419
Interquartile range (IQR)	53

Descriptive statistics

Standard deviation	896.88811
Coefficient of variation (CV)	16.236273
Kurtosis	1071.7458
Mean	55.239777
Median Absolute Deviation (MAD)	6
Skewness	32.705525
Sum	59438
Variance	804408.29
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	137	12.7%
1	118	11.0%
2	72	6.7%
3	58	5.4%
4	57	5.3%
6	42	3.9%
7	36	3.3%
9	35	3.3%
5	34	3.2%
8	27	2.5%
Other values (113)	460	42.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	137	12.7%
1	118	11.0%
2	72	6.7%
3	58	5.4%
4	57	5.3%
5	34	3.2%
6	42	3.9%
7	36	3.3%
8	27	2.5%
9	35	3.3%

Value	Count	Frequency (%)
29419	1	0.1%
600	1	0.1%
142	1	0.1%
133	2	0.2%
131	1	0.1%
130	1	0.1%
129	2	0.2%
124	1	0.1%
123	2	0.2%
122	1	0.1%

Unnamed: 10
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	180
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	89.667286

Minimum	0
Maximum	47891
Zeros	112
Zeros (%)	10.4%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	8
Q3	92
95-th percentile	169
Maximum	47891
Range	47891
Interquartile range (IQR)	89

Descriptive statistics

Standard deviation	1459.9991
Coefficient of variation (CV)	16.282405
Kurtosis	1071.8846
Mean	89.667286
Median Absolute Deviation (MAD)	7
Skewness	32.708554
Sum	96482
Variance	2131597.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	112	10.4%
1	81	7.5%
4	63	5.9%
2	63	5.9%
3	58	5.4%
5	54	5.0%
6	41	3.8%
7	40	3.7%
8	32	3.0%
9	28	2.6%
Other values (170)	504	46.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	112	10.4%
1	81	7.5%
2	63	5.9%
3	58	5.4%
4	63	5.9%
5	54	5.0%
6	41	3.8%
7	40	3.7%
8	32	3.0%
9	28	2.6%

Value	Count	Frequency (%)
47891	1	0.1%
700	1	0.1%
240	1	0.1%
230	2	0.2%
228	1	0.1%
225	1	0.1%
223	1	0.1%
221	1	0.1%
220	2	0.2%
219	1	0.1%

Unnamed: 11
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	439
Distinct (%)	40.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	605.22862

Minimum	0
Maximum	325213
Zeros	2
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	33
median	63
Q3	644.5
95-th percentile	1111.25
Maximum	325213
Range	325213
Interquartile range (IQR)	611.5

Descriptive statistics

Standard deviation	9913.0628
Coefficient of variation (CV)	16.379038
Kurtosis	1072.5147
Mean	605.22862
Median Absolute Deviation (MAD)	42
Skewness	32.722872
Sum	651226
Variance	98268814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	16	1.5%
30	15	1.4%
27	15	1.4%
33	14	1.3%
36	14	1.3%
18	14	1.3%
34	13	1.2%
48	13	1.2%
43	13	1.2%
38	13	1.2%
Other values (429)	936	87.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	0.2%
1	1	0.1%
2	2	0.2%
3	6	0.6%
4	3	0.3%
5	1	0.1%
6	3	0.3%
7	6	0.6%
8	3	0.3%
9	8	0.7%

Value	Count	Frequency (%)
325213	1	0.1%
1892	1	0.1%
1653	1	0.1%
1643	1	0.1%
1568	1	0.1%
1550	1	0.1%
1542	1	0.1%
1528	1	0.1%
1506	1	0.1%
1488	1	0.1%

Unnamed: 12
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	236
Distinct (%)	21.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	130.67472

Minimum	0
Maximum	69853
Zeros	38
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	9.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	14
Q3	127.5
95-th percentile	252
Maximum	69853
Range	69853
Interquartile range (IQR)	122.5

Descriptive statistics

Standard deviation	2129.4727
Coefficient of variation (CV)	16.295981
Kurtosis	1072.0069
Mean	130.67472
Median Absolute Deviation (MAD)	12
Skewness	32.711331
Sum	140606
Variance	4534654.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	64	5.9%
1	54	5.0%
2	52	4.8%
5	50	4.6%
4	43	4.0%
0	38	3.5%
8	37	3.4%
7	37	3.4%
6	35	3.3%
9	34	3.2%
Other values (226)	632	58.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38	3.5%
1	54	5.0%
2	52	4.8%
3	64	5.9%
4	43	4.0%
5	50	4.6%
6	35	3.3%
7	37	3.4%
8	37	3.4%
9	34	3.2%

Value	Count	Frequency (%)
69853	1	0.1%
900	1	0.1%
414	1	0.1%
378	1	0.1%
351	1	0.1%
350	1	0.1%
347	1	0.1%
345	1	0.1%
344	1	0.1%
343	1	0.1%

Unnamed: 13
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

0	1075
미분류	1

Length

Max length	3
Median length	1
Mean length	1.0018587
Min length	1

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	미분류
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1075	99.9%
미분류	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1075	99.9%
미분류	1	0.1%

Unnamed: 14
Text

Distinct	580
Distinct (%)	53.9%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

Length

Max length	6
Median length	4
Mean length	2.9488848
Min length	1

Characters and Unicode

Total characters	3173
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	392 ?
Unique (%)	36.4%

Sample

1st row	합계
2nd row	16
3rd row	768
4th row	34
5th row	58

Value	Count	Frequency (%)
70	12	1.1%
61	12	1.1%
46	10	0.9%
58	9	0.8%
62	9	0.8%
48	9	0.8%
65	9	0.8%
75	8	0.7%
29	8	0.7%
129	8	0.7%
Other values (570)	982	91.3%

Most occurring characters

Value	Count	Frequency (%)
1	658	20.7%
2	459	14.5%
6	285	9.0%
8	277	8.7%
7	269	8.5%
5	264	8.3%
3	262	8.3%
4	253	8.0%
9	244	7.7%
0	200	6.3%
Other values (2)	2	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3171	99.9%
Other Letter	2	0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	658	20.8%
2	459	14.5%
6	285	9.0%
8	277	8.7%
7	269	8.5%
5	264	8.3%
3	262	8.3%
4	253	8.0%
9	244	7.7%
0	200	6.3%

Other Letter

Value	Count	Frequency (%)
합	1	50.0%
계	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3171	99.9%
Hangul	2	0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	658	20.8%
2	459	14.5%
6	285	9.0%
8	277	8.7%
7	269	8.5%
5	264	8.3%
3	262	8.3%
4	253	8.0%
9	244	7.7%
0	200	6.3%

Hangul

Value	Count	Frequency (%)
합	1	50.0%
계	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3171	99.9%
Hangul	2	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	658	20.8%
2	459	14.5%
6	285	9.0%
8	277	8.7%
7	269	8.5%
5	264	8.3%
3	262	8.3%
4	253	8.0%
9	244	7.7%
0	200	6.3%

Hangul

Value	Count	Frequency (%)
합	1	50.0%
계	1	50.0%

Heatmap
Table

	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 13
Unnamed: 2	1.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.000
Unnamed: 3	NaN	1.000	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.000
Unnamed: 4	NaN	0.706	1.000	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.000
Unnamed: 5	NaN	0.706	0.706	1.000	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.000
Unnamed: 6	NaN	0.706	0.706	0.706	1.000	0.706	0.706	0.706	0.706	0.706	0.706	0.000
Unnamed: 7	NaN	0.706	0.706	0.706	0.706	1.000	0.706	0.706	0.706	0.706	0.706	0.000
Unnamed: 8	NaN	0.706	0.706	0.706	0.706	0.706	1.000	0.706	0.706	0.706	0.706	0.000
Unnamed: 9	NaN	0.706	0.706	0.706	0.706	0.706	0.706	1.000	0.706	0.706	0.706	0.000
Unnamed: 10	NaN	0.706	0.706	0.706	0.706	0.706	0.706	0.706	1.000	0.706	0.706	0.000
Unnamed: 11	NaN	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.706	1.000	0.706	0.000
Unnamed: 12	NaN	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.706	0.706	1.000	0.000
Unnamed: 13	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000

Heatmap
Table

	Unnamed: 2	Unnamed: 13
Unnamed: 2	1.000	0.999
Unnamed: 13	0.999	1.000

Heatmap
Table

	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 2	Unnamed: 13
Unnamed: 3	1.000	0.862	0.807	0.874	0.833	0.858	0.840	0.796	0.861	0.854	1.000	0.000
Unnamed: 4	0.862	1.000	0.853	0.912	0.840	0.892	0.885	0.816	0.888	0.887	1.000	0.000
Unnamed: 5	0.807	0.853	1.000	0.848	0.800	0.838	0.830	0.781	0.825	0.831	1.000	0.000
Unnamed: 6	0.874	0.912	0.848	1.000	0.884	0.915	0.897	0.836	0.914	0.901	1.000	0.000
Unnamed: 7	0.833	0.840	0.800	0.884	1.000	0.855	0.845	0.808	0.880	0.873	1.000	0.000
Unnamed: 8	0.858	0.892	0.838	0.915	0.855	1.000	0.896	0.811	0.891	0.881	1.000	0.000
Unnamed: 9	0.840	0.885	0.830	0.897	0.845	0.896	1.000	0.819	0.876	0.882	1.000	0.000
Unnamed: 10	0.796	0.816	0.781	0.836	0.808	0.811	0.819	1.000	0.844	0.817	1.000	0.000
Unnamed: 11	0.861	0.888	0.825	0.914	0.880	0.891	0.876	0.844	1.000	0.902	1.000	0.000
Unnamed: 12	0.854	0.887	0.831	0.901	0.873	0.881	0.882	0.817	0.902	1.000	1.000	0.000
Unnamed: 2	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	0.999
Unnamed: 13	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.999	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Unnamed: 0	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 13	Unnamed: 14
0	번호	일자	소속기관	0	100	200	300	400	500	600	700	800	900	미분류	합계
1	1	2014-01-01	구의3동도서관	1	1	0	2	0	2	0	0	10	0	0	16
2	2	2014-01-01	광진정보도서관	41	26	12	91	34	47	31	24	385	77	0	768
3	3	2014-01-01	서울특별시	3	3	2	1	1	0	2	0	16	6	0	34
4	4	2014-01-02	구의3동도서관	2	2	13	8	3	1	0	7	17	5	0	58
5	5	2014-01-02	광진정보도서관	106	112	38	278	194	147	103	141	1342	306	0	2767
6	6	2014-01-02	서울특별시	10	13	9	32	10	13	7	11	64	19	0	188
7	7	2014-01-03	구의3동도서관	1	0	0	5	4	2	0	0	35	1	0	48
8	8	2014-01-03	광진정보도서관	135	100	29	290	143	128	92	131	1047	260	0	2355
9	9	2014-01-03	서울특별시	8	8	11	17	17	3	8	5	75	11	0	163

	Unnamed: 0	Unnamed: 1	Unnamed: 2	Unnamed: 3	Unnamed: 4	Unnamed: 5	Unnamed: 6	Unnamed: 7	Unnamed: 8	Unnamed: 9	Unnamed: 10	Unnamed: 11	Unnamed: 12	Unnamed: 14
1066	1066	2014-12-22	구의3동도서관	1	3	0	7	2	4	6	0	10	1	34
1067	1067	2014-12-22	광진정보도서관	102	64	11	179	107	93	83	101	686	136	1562
1068	1068	2014-12-22	서울특별시	6	6	4	15	25	12	3	7	48	12	138
1069	1069	2014-12-23	구의3동도서관	0	0	0	2	0	2	1	0	21	4	30
1070	1070	2014-12-23	광진정보도서관	52	38	5	97	74	48	25	47	382	54	822
1071	1071	2014-12-23	서울특별시	8	9	2	24	22	8	3	4	36	5	121
1072	1072	2014-12-24	구의3동도서관	2	0	0	6	3	3	0	7	20	2	43
1073	1073	2014-12-24	광진정보도서관	86	74	13	179	114	81	62	107	746	164	1626
1074	1074	2014-12-24	서울특별시	10	12	2	25	18	17	4	9	52	19	168
1075	합계	<NA>	<NA>	41455	33723	8998	95869	56615	47612	29419	47891	325213	69853	756648

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Letter

Most occurring scripts

Most frequent character per script

Common

Hangul

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Hangul

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Letter

Most occurring scripts

Most frequent character per script

Common

Hangul

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Interactions

Correlations

Missing values

Sample