gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	600
Missing cells	279
Missing cells (%)	2.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	85.1 KiB
Average record size in memory	145.2 B

Variable types

Categorical	7
Text	1
Numeric	8
Boolean	1

Dataset

Description	Sample
Author	LG유플러스
URL	https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=839ad790-f0d7-11eb-8e60-2bcdc8456bfb

Alerts

`BASE_YM` has constant value ""	Constant
`GENRE_LCLAS_NM` is highly overall correlated with `BRDCST_TY_NM` and 1 other fields	High correlation
`BRDCST_TY_NM` is highly overall correlated with `GENRE_LCLAS_NM` and 1 other fields	High correlation
`GENRE_MLSFC_NM` is highly overall correlated with `BRDCST_TY_NM` and 1 other fields	High correlation
`AVRG_WTCHNG_CO` is highly overall correlated with `AVRG_WTCHNG_TIME_CO` and 4 other fields	High correlation
`AVRG_WTCHNG_TIME_CO` is highly overall correlated with `AVRG_WTCHNG_CO` and 4 other fields	High correlation
`DAWN_AVRG_WTCHNG_TIME_CO` is highly overall correlated with `AVRG_WTCHNG_CO` and 1 other fields	High correlation
`AM_AVRG_WTCHNG_TIME_CO` is highly overall correlated with `AVRG_WTCHNG_CO` and 2 other fields	High correlation
`PM_AVRG_WTCHNG_TIME_CO` is highly overall correlated with `AVRG_WTCHNG_CO` and 2 other fields	High correlation
`EVENING_AVRG_WTCHNG_TIME_CO` is highly overall correlated with `AVRG_WTCHNG_CO` and 1 other fields	High correlation
`DAWN_AVRG_WTCHNG_TIME_CO` has 83 (13.8%) missing values	Missing
`AM_AVRG_WTCHNG_TIME_CO` has 67 (11.2%) missing values	Missing
`PM_AVRG_WTCHNG_TIME_CO` has 44 (7.3%) missing values	Missing
`EVENING_AVRG_WTCHNG_TIME_CO` has 7 (1.2%) missing values	Missing
`AVRG_VOD_PRCHS_PRICE` has 76 (12.7%) missing values	Missing
`DAWN_AVRG_WTCHNG_TIME_CO` has 51 (8.5%) zeros	Zeros
`AM_AVRG_WTCHNG_TIME_CO` has 60 (10.0%) zeros	Zeros
`PM_AVRG_WTCHNG_TIME_CO` has 54 (9.0%) zeros	Zeros
`EVENING_AVRG_WTCHNG_TIME_CO` has 21 (3.5%) zeros	Zeros
`AVRG_VOD_PRCHS_PRICE` has 473 (78.8%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 09:45:52.658857
Analysis finished	2023-12-10 09:46:10.400500
Duration	17.74 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

BASE_YM
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

202011	600

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
202011	600	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
202011	600	100.0%

CTPRVN_NM
Categorical

Distinct	16
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

경기도	175
서울시	118
부산시	49
인천시	40
경남	34
Other values (11)	184

Length

Max length	7
Median length	3
Mean length	2.81
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	대전시
2nd row	경남
3rd row	전북
4th row	서울시
5th row	강원도

Common Values

Value	Count	Frequency (%)
경기도	175	29.2%
서울시	118	19.7%
부산시	49	8.2%
인천시	40	6.7%
경남	34	5.7%
전북	28	4.7%
경북	28	4.7%
대전시	18	3.0%
충남	18	3.0%
대구시	17	2.8%
Other values (6)	75	12.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
경기도	175	29.2%
서울시	118	19.7%
부산시	49	8.2%
인천시	40	6.7%
경남	34	5.7%
전북	28	4.7%
경북	28	4.7%
대전시	18	3.0%
충남	18	3.0%
대구시	17	2.8%
Other values (6)	75	12.5%

SIGNGU_NM
Text

Distinct	141
Distinct (%)	23.5%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

Length

Max length	9
Median length	3
Mean length	3.79
Min length	2

Characters and Unicode

Total characters	2274
Distinct characters	118
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	25 ?
Unique (%)	4.2%

Sample

1st row	유성구
2nd row	거제시
3rd row	김제시
4th row	중랑구
5th row	춘천시

Value	Count	Frequency (%)
북구	24	3.3%
서구	21	2.9%
고양시	21	2.9%
수원시	18	2.5%
중구	15	2.1%
남구	14	1.9%
전주시	13	1.8%
창원시	13	1.8%
용인시	11	1.5%
남양주시	11	1.5%
Other values (140)	560	77.7%

Most occurring characters

Value	Count	Frequency (%)
구	406	17.9%
시	318	14.0%
	121	5.3%
산	75	3.3%
주	73	3.2%
서	65	2.9%
양	60	2.6%
원	53	2.3%
남	52	2.3%
동	52	2.3%
Other values (108)	999	43.9%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	2153	94.7%
Space Separator	121	5.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
구	406	18.9%
시	318	14.8%
산	75	3.5%
주	73	3.4%
서	65	3.0%
양	60	2.8%
원	53	2.5%
남	52	2.4%
동	52	2.4%
성	43	2.0%
Other values (107)	956	44.4%

Space Separator

Value	Count	Frequency (%)
	121	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	2153	94.7%
Common	121	5.3%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
구	406	18.9%
시	318	14.8%
산	75	3.5%
주	73	3.4%
서	65	3.0%
양	60	2.8%
원	53	2.5%
남	52	2.4%
동	52	2.4%
성	43	2.0%
Other values (107)	956	44.4%

Common

Value	Count	Frequency (%)
	121	100.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	2153	94.7%
ASCII	121	5.3%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
구	406	18.9%
시	318	14.8%
산	75	3.5%
주	73	3.4%
서	65	3.0%
양	60	2.8%
원	53	2.5%
남	52	2.4%
동	52	2.4%
성	43	2.0%
Other values (107)	956	44.4%

ASCII

Value	Count	Frequency (%)
	121	100.0%

SEXDSTN_FLAG_CD
Categorical

Distinct	2
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

M	336
F	264

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	F
5th row	F

Common Values

Value	Count	Frequency (%)
M	336	56.0%
F	264	44.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	336	56.0%
f	264	44.0%

AGRDE_CO
Real number (ℝ)

Distinct	7
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.81

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	7
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.1844428
Coefficient of variation (CV)	0.31087739
Kurtosis	-0.24265867
Mean	3.81
Median Absolute Deviation (MAD)	1
Skewness	-0.015010631
Sum	2286
Variance	1.4029048
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	210	35.0%
3	141	23.5%
5	120	20.0%
2	74	12.3%
6	38	6.3%
1	12	2.0%
7	5	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12	2.0%
2	74	12.3%
3	141	23.5%
4	210	35.0%
5	120	20.0%
6	38	6.3%
7	5	0.8%

Value	Count	Frequency (%)
7	5	0.8%
6	38	6.3%
5	120	20.0%
4	210	35.0%
3	141	23.5%
2	74	12.3%
1	12	2.0%

FAMILY_TY_NM
Categorical

Distinct	8
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

시니어_성인자녀	117
<NA>	98
키즈맘_초등생	95
키즈맘_중고등생	86
키즈맘_미취학	69
Other values (3)	135

Length

Max length	8
Median length	7
Mean length	6.4533333
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	키즈맘_중고등생
2nd row	시니어_독립자녀
3rd row	키즈맘_미취학
4th row	시니어_성인자녀
5th row	키즈맘_초등생

Common Values

Value	Count	Frequency (%)
시니어_성인자녀	117	19.5%
<NA>	98	16.3%
키즈맘_초등생	95	15.8%
키즈맘_중고등생	86	14.3%
키즈맘_미취학	69	11.5%
1인가구	54	9.0%
시니어_독립자녀	42	7.0%
2인가구	39	6.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
시니어_성인자녀	117	19.5%
na	98	16.3%
키즈맘_초등생	95	15.8%
키즈맘_중고등생	86	14.3%
키즈맘_미취학	69	11.5%
1인가구	54	9.0%
시니어_독립자녀	42	7.0%
2인가구	39	6.5%

BRDCST_TY_NM
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

VOD	310
LINEAR_TV	290

Length

Max length	9
Median length	3
Mean length	5.9
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LINEAR_TV
2nd row	LINEAR_TV
3rd row	LINEAR_TV
4th row	LINEAR_TV
5th row	VOD

Common Values

Value	Count	Frequency (%)
VOD	310	51.7%
LINEAR_TV	290	48.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
vod	310	51.7%
linear_tv	290	48.3%

GENRE_LCLAS_NM
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

영화	219
스포츠	75
연예/오락	71
방송	70
시사/교양	66
Other values (11)	99

Length

Max length	8
Median length	2
Mean length	3.2366667
Min length	2

Unique

Unique	3 ?
Unique (%)	0.5%

Sample

1st row	스포츠
2nd row	영화
3rd row	시사/교양
4th row	시사/교양
5th row	영화

Common Values

Value	Count	Frequency (%)
영화	219	36.5%
스포츠	75	12.5%
연예/오락	71	11.8%
방송	70	11.7%
시사/교양	66	11.0%
TV 드라마	33	5.5%
라이프	15	2.5%
해외시리즈	13	2.2%
TV 애니메이션	8	1.3%
뮤직	8	1.3%
Other values (6)	22	3.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
영화	219	34.2%
스포츠	75	11.7%
연예/오락	71	11.1%
방송	70	10.9%
시사/교양	66	10.3%
tv	41	6.4%
드라마	33	5.1%
라이프	15	2.3%
해외시리즈	13	2.0%
애니메이션	8	1.2%
Other values (7)	30	4.7%

GENRE_MLSFC_NM
Categorical

HIGH CORRELATION

Distinct	43
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Memory size	4.8 KiB

기타	119
드라마	84
액션	41
스릴러	37
코미디	33
Other values (38)	286

Length

Max length	10
Median length	6
Mean length	2.9033333
Min length	1

Unique

Unique	11 ?
Unique (%)	1.8%

Sample

1st row	축구
2nd row	기타
3rd row	뉴스/시사
4th row	뉴스/시사
5th row	드라마

Common Values

Value	Count	Frequency (%)
기타	119	19.8%
드라마	84	14.0%
액션	41	6.8%
스릴러	37	6.2%
코미디	33	5.5%
로맨스	31	5.2%
TV 드라마	29	4.8%
연예오락	29	4.8%
뉴스/시사	26	4.3%
야구	25	4.2%
Other values (33)	146	24.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
기타	119	18.8%
드라마	113	17.9%
액션	41	6.5%
스릴러	37	5.9%
코미디	33	5.2%
로맨스	31	4.9%
tv	29	4.6%
연예오락	29	4.6%
뉴스/시사	26	4.1%
야구	25	4.0%
Other values (34)	149	23.6%

HLDY_AT
Boolean

Distinct	2
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	732.0 B

False	356
True	244

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	356	59.3%
True	244	40.7%

AVRG_WTCHNG_CO
Real number (ℝ)

HIGH CORRELATION

Distinct	49
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.9833333

Minimum	1
Maximum	75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	5
Q3	11
95-th percentile	28
Maximum	75
Range	74
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	10.006662
Coefficient of variation (CV)	1.1139141
Kurtosis	9.4124267
Mean	8.9833333
Median Absolute Deviation (MAD)	2
Skewness	2.7463534
Sum	5390
Variance	100.13328
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
3	122	20.3%
4	83	13.8%
2	70	11.7%
5	52	8.7%
6	37	6.2%
7	25	4.2%
8	21	3.5%
10	20	3.3%
11	14	2.3%
12	13	2.2%
Other values (39)	143	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.3%
2	70	11.7%
3	122	20.3%
4	83	13.8%
5	52	8.7%
6	37	6.2%
7	25	4.2%
8	21	3.5%
9	13	2.2%
10	20	3.3%

Value	Count	Frequency (%)
75	1	0.2%
64	1	0.2%
61	1	0.2%
55	2	0.3%
51	2	0.3%
50	2	0.3%
49	1	0.2%
47	1	0.2%
45	1	0.2%
41	1	0.2%

AVRG_WTCHNG_TIME_CO
Real number (ℝ)

HIGH CORRELATION

Distinct	206
Distinct (%)	34.4%
Missing	2
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	81.289298

Minimum	0
Maximum	917
Zeros	1
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	19
median	39
Q3	92
95-th percentile	292.3
Maximum	917
Range	917
Interquartile range (IQR)	73

Descriptive statistics

Standard deviation	111.76418
Coefficient of variation (CV)	1.3748941
Kurtosis	14.648595
Mean	81.289298
Median Absolute Deviation (MAD)	26
Skewness	3.2071319
Sum	48611
Variance	12491.231
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	15	2.5%
4	14	2.3%
29	13	2.2%
16	12	2.0%
30	12	2.0%
28	12	2.0%
24	11	1.8%
11	10	1.7%
22	10	1.7%
13	10	1.7%
Other values (196)	479	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.2%
1	7	1.2%
2	5	0.8%
3	9	1.5%
4	14	2.3%
5	6	1.0%
6	9	1.5%
7	8	1.3%
8	4	0.7%
9	7	1.2%

Value	Count	Frequency (%)
917	1	0.2%
888	1	0.2%
782	1	0.2%
646	1	0.2%
580	1	0.2%
538	1	0.2%
507	1	0.2%
499	1	0.2%
466	1	0.2%
458	1	0.2%

DAWN_AVRG_WTCHNG_TIME_CO
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	158
Distinct (%)	30.6%
Missing	83
Missing (%)	13.8%
Infinite	0
Infinite (%)	0.0%
Mean	58.500967

Minimum	0
Maximum	982
Zeros	51
Zeros (%)	8.5%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	24
Q3	60
95-th percentile	243.2
Maximum	982
Range	982
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	102.6624
Coefficient of variation (CV)	1.7548838
Kurtosis	24.542171
Mean	58.500967
Median Absolute Deviation (MAD)	22
Skewness	4.2539961
Sum	30245
Variance	10539.568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	51	8.5%
1	22	3.7%
2	17	2.8%
3	15	2.5%
15	12	2.0%
4	11	1.8%
9	11	1.8%
10	11	1.8%
19	10	1.7%
21	10	1.7%
Other values (148)	347	57.8%
(Missing)	83	13.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	51	8.5%
1	22	3.7%
2	17	2.8%
3	15	2.5%
4	11	1.8%
5	9	1.5%
6	6	1.0%
7	8	1.3%
8	4	0.7%
9	11	1.8%

Value	Count	Frequency (%)
982	1	0.2%
690	1	0.2%
681	1	0.2%
661	1	0.2%
638	1	0.2%
623	1	0.2%
591	1	0.2%
463	1	0.2%
404	1	0.2%
338	1	0.2%

AM_AVRG_WTCHNG_TIME_CO
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	132
Distinct (%)	24.8%
Missing	67
Missing (%)	11.2%
Infinite	0
Infinite (%)	0.0%
Mean	40.739212

Minimum	0
Maximum	725
Zeros	60
Zeros (%)	10.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	17
Q3	44
95-th percentile	148.4
Maximum	725
Range	725
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	70.262381
Coefficient of variation (CV)	1.7246868
Kurtosis	27.668254
Mean	40.739212
Median Absolute Deviation (MAD)	15
Skewness	4.3897691
Sum	21714
Variance	4936.8022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60	10.0%
2	23	3.8%
3	21	3.5%
1	16	2.7%
6	15	2.5%
13	15	2.5%
4	13	2.2%
9	12	2.0%
7	11	1.8%
5	11	1.8%
Other values (122)	336	56.0%
(Missing)	67	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60	10.0%
1	16	2.7%
2	23	3.8%
3	21	3.5%
4	13	2.2%
5	11	1.8%
6	15	2.5%
7	11	1.8%
8	7	1.2%
9	12	2.0%

Value	Count	Frequency (%)
725	1	0.2%
517	1	0.2%
477	1	0.2%
433	1	0.2%
418	1	0.2%
376	1	0.2%
305	1	0.2%
282	1	0.2%
277	1	0.2%
254	1	0.2%

PM_AVRG_WTCHNG_TIME_CO
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	141
Distinct (%)	25.4%
Missing	44
Missing (%)	7.3%
Infinite	0
Infinite (%)	0.0%
Mean	41.077338

Minimum	0
Maximum	659
Zeros	54
Zeros (%)	9.0%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	22
Q3	51
95-th percentile	152.25
Maximum	659
Range	659
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	59.357911
Coefficient of variation (CV)	1.4450282
Kurtosis	26.954391
Mean	41.077338
Median Absolute Deviation (MAD)	19
Skewness	3.9840542
Sum	22839
Variance	3523.3616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	54	9.0%
2	21	3.5%
1	19	3.2%
4	18	3.0%
3	16	2.7%
5	13	2.2%
17	13	2.2%
9	13	2.2%
8	11	1.8%
11	11	1.8%
Other values (131)	367	61.2%
(Missing)	44	7.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	54	9.0%
1	19	3.2%
2	21	3.5%
3	16	2.7%
4	18	3.0%
5	13	2.2%
6	6	1.0%
7	4	0.7%
8	11	1.8%
9	13	2.2%

Value	Count	Frequency (%)
659	1	0.2%
411	1	0.2%
372	1	0.2%
334	1	0.2%
268	1	0.2%
258	1	0.2%
252	1	0.2%
226	1	0.2%
225	1	0.2%
224	1	0.2%

EVENING_AVRG_WTCHNG_TIME_CO
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	169
Distinct (%)	28.5%
Missing	7
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%
Mean	54.485666

Minimum	0
Maximum	552
Zeros	21
Zeros (%)	3.5%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	11
median	29
Q3	65
95-th percentile	204.4
Maximum	552
Range	552
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	71.720791
Coefficient of variation (CV)	1.316324
Kurtosis	9.9134552
Mean	54.485666
Median Absolute Deviation (MAD)	22
Skewness	2.7022442
Sum	32310
Variance	5143.8718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21	3.5%
2	19	3.2%
5	17	2.8%
1	16	2.7%
3	16	2.7%
18	14	2.3%
7	13	2.2%
4	12	2.0%
26	12	2.0%
25	12	2.0%
Other values (159)	441	73.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21	3.5%
1	16	2.7%
2	19	3.2%
3	16	2.7%
4	12	2.0%
5	17	2.8%
6	10	1.7%
7	13	2.2%
8	8	1.3%
9	11	1.8%

Value	Count	Frequency (%)
552	1	0.2%
517	1	0.2%
405	1	0.2%
382	1	0.2%
381	1	0.2%
335	1	0.2%
325	1	0.2%
321	1	0.2%
310	1	0.2%
296	1	0.2%

AVRG_VOD_PRCHS_PRICE
Real number (ℝ)

MISSING ZEROS

Distinct	44
Distinct (%)	8.4%
Missing	76
Missing (%)	12.7%
Infinite	0
Infinite (%)	0.0%
Mean	40.534351

Minimum	0
Maximum	945
Zeros	473
Zeros (%)	78.8%
Negative	0
Negative (%)	0.0%
Memory size	5.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	355.05
Maximum	945
Range	945
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	151.96273
Coefficient of variation (CV)	3.7489863
Kurtosis	16.470512
Mean	40.534351
Median Absolute Deviation (MAD)	0
Skewness	4.10665
Sum	21240
Variance	23092.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	473	78.8%
666	2	0.3%
87	2	0.3%
857	2	0.3%
714	2	0.3%
600	2	0.3%
36	2	0.3%
500	2	0.3%
750	2	0.3%
127	1	0.2%
Other values (34)	34	5.7%
(Missing)	76	12.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	473	78.8%
24	1	0.2%
36	2	0.3%
39	1	0.2%
45	1	0.2%
63	1	0.2%
84	1	0.2%
87	2	0.3%
101	1	0.2%
107	1	0.2%

Value	Count	Frequency (%)
945	1	0.2%
916	1	0.2%
875	1	0.2%
857	2	0.3%
800	1	0.2%
750	2	0.3%
714	2	0.3%
712	1	0.2%
677	1	0.2%
666	2	0.3%

Heatmap
Table

	CTPRVN_NM	SEXDSTN_FLAG_CD	AGRDE_CO	FAMILY_TY_NM	BRDCST_TY_NM	GENRE_LCLAS_NM	GENRE_MLSFC_NM	HLDY_AT	AVRG_WTCHNG_CO	AVRG_WTCHNG_TIME_CO	DAWN_AVRG_WTCHNG_TIME_CO	AM_AVRG_WTCHNG_TIME_CO	PM_AVRG_WTCHNG_TIME_CO	EVENING_AVRG_WTCHNG_TIME_CO	AVRG_VOD_PRCHS_PRICE
CTPRVN_NM	1.000	0.000	0.095	0.147	0.000	0.000	0.000	0.065	0.056	0.171	0.106	0.000	0.166	0.333	0.000
SEXDSTN_FLAG_CD	0.000	1.000	0.133	0.114	0.006	0.399	0.370	0.000	0.000	0.000	0.000	0.057	0.000	0.026	0.104
AGRDE_CO	0.095	0.133	1.000	0.721	0.149	0.240	0.213	0.000	0.330	0.348	0.482	0.163	0.000	0.104	0.015
FAMILY_TY_NM	0.147	0.114	0.721	1.000	0.000	0.104	0.202	0.000	0.000	0.160	0.083	0.073	0.055	0.076	0.102
BRDCST_TY_NM	0.000	0.006	0.149	0.000	1.000	0.993	1.000	0.000	0.208	0.069	0.179	0.000	0.133	0.117	0.396
GENRE_LCLAS_NM	0.000	0.399	0.240	0.104	0.993	1.000	0.990	0.000	0.464	0.495	0.356	0.355	0.384	0.401	0.000
GENRE_MLSFC_NM	0.000	0.370	0.213	0.202	1.000	0.990	1.000	0.083	0.463	0.560	0.000	0.294	0.000	0.480	0.000
HLDY_AT	0.065	0.000	0.000	0.000	0.000	0.000	0.083	1.000	0.188	0.217	0.172	0.060	0.065	0.112	0.000
AVRG_WTCHNG_CO	0.056	0.000	0.330	0.000	0.208	0.464	0.463	0.188	1.000	0.935	0.787	0.674	0.602	0.720	0.000
AVRG_WTCHNG_TIME_CO	0.171	0.000	0.348	0.160	0.069	0.495	0.560	0.217	0.935	1.000	0.849	0.766	0.711	0.819	0.393
DAWN_AVRG_WTCHNG_TIME_CO	0.106	0.000	0.482	0.083	0.179	0.356	0.000	0.172	0.787	0.849	1.000	0.898	0.643	0.653	0.319
AM_AVRG_WTCHNG_TIME_CO	0.000	0.057	0.163	0.073	0.000	0.355	0.294	0.060	0.674	0.766	0.898	1.000	0.762	0.631	0.196
PM_AVRG_WTCHNG_TIME_CO	0.166	0.000	0.000	0.055	0.133	0.384	0.000	0.065	0.602	0.711	0.643	0.762	1.000	0.484	0.122
EVENING_AVRG_WTCHNG_TIME_CO	0.333	0.026	0.104	0.076	0.117	0.401	0.480	0.112	0.720	0.819	0.653	0.631	0.484	1.000	0.000
AVRG_VOD_PRCHS_PRICE	0.000	0.104	0.015	0.102	0.396	0.000	0.000	0.000	0.000	0.393	0.319	0.196	0.122	0.000	1.000

Heatmap
Table

	GENRE_LCLAS_NM	BRDCST_TY_NM	SEXDSTN_FLAG_CD	FAMILY_TY_NM	CTPRVN_NM	HLDY_AT	GENRE_MLSFC_NM
GENRE_LCLAS_NM	1.000	0.917	0.310	0.046	0.000	0.000	0.862
BRDCST_TY_NM	0.917	1.000	0.003	0.000	0.000	0.000	0.965
SEXDSTN_FLAG_CD	0.310	0.003	1.000	0.121	0.000	0.000	0.299
FAMILY_TY_NM	0.046	0.000	0.121	1.000	0.066	0.000	0.078
CTPRVN_NM	0.000	0.000	0.000	0.066	1.000	0.050	0.000
HLDY_AT	0.000	0.000	0.000	0.000	0.050	1.000	0.066
GENRE_MLSFC_NM	0.862	0.965	0.299	0.078	0.000	0.066	1.000

Heatmap
Table

	AGRDE_CO	AVRG_WTCHNG_CO	AVRG_WTCHNG_TIME_CO	DAWN_AVRG_WTCHNG_TIME_CO	AM_AVRG_WTCHNG_TIME_CO	PM_AVRG_WTCHNG_TIME_CO	EVENING_AVRG_WTCHNG_TIME_CO	AVRG_VOD_PRCHS_PRICE	CTPRVN_NM	SEXDSTN_FLAG_CD	FAMILY_TY_NM	BRDCST_TY_NM	GENRE_LCLAS_NM	GENRE_MLSFC_NM	HLDY_AT
AGRDE_CO	1.000	0.131	0.137	0.077	0.004	0.011	0.091	-0.113	0.043	0.141	0.325	0.159	0.111	0.084	0.000
AVRG_WTCHNG_CO	0.131	1.000	0.859	0.561	0.581	0.622	0.684	-0.022	0.021	0.000	0.000	0.158	0.201	0.173	0.143
AVRG_WTCHNG_TIME_CO	0.137	0.859	1.000	0.703	0.620	0.697	0.832	0.050	0.067	0.000	0.081	0.052	0.217	0.222	0.165
DAWN_AVRG_WTCHNG_TIME_CO	0.077	0.561	0.703	1.000	0.432	0.467	0.486	0.100	0.036	0.000	0.044	0.133	0.168	0.000	0.129
AM_AVRG_WTCHNG_TIME_CO	0.004	0.581	0.620	0.432	1.000	0.551	0.390	0.089	0.000	0.056	0.037	0.000	0.153	0.107	0.059
PM_AVRG_WTCHNG_TIME_CO	0.011	0.622	0.697	0.467	0.551	1.000	0.500	0.102	0.058	0.000	0.018	0.100	0.179	0.000	0.048
EVENING_AVRG_WTCHNG_TIME_CO	0.091	0.684	0.832	0.486	0.390	0.500	1.000	0.104	0.142	0.025	0.039	0.116	0.174	0.188	0.111
AVRG_VOD_PRCHS_PRICE	-0.113	-0.022	0.050	0.100	0.089	0.102	0.104	1.000	0.000	0.079	0.051	0.302	0.000	0.000	0.000
CTPRVN_NM	0.043	0.021	0.067	0.036	0.000	0.058	0.142	0.000	1.000	0.000	0.066	0.000	0.000	0.000	0.050
SEXDSTN_FLAG_CD	0.141	0.000	0.000	0.000	0.056	0.000	0.025	0.079	0.000	1.000	0.121	0.003	0.310	0.299	0.000
FAMILY_TY_NM	0.325	0.000	0.081	0.044	0.037	0.018	0.039	0.051	0.066	0.121	1.000	0.000	0.046	0.078	0.000
BRDCST_TY_NM	0.159	0.158	0.052	0.133	0.000	0.100	0.116	0.302	0.000	0.003	0.000	1.000	0.917	0.965	0.000
GENRE_LCLAS_NM	0.111	0.201	0.217	0.168	0.153	0.179	0.174	0.000	0.000	0.310	0.046	0.917	1.000	0.862	0.000
GENRE_MLSFC_NM	0.084	0.173	0.222	0.000	0.107	0.000	0.188	0.000	0.000	0.299	0.078	0.965	0.862	1.000	0.066
HLDY_AT	0.000	0.143	0.165	0.129	0.059	0.048	0.111	0.000	0.050	0.000	0.000	0.000	0.000	0.066	1.000

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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	BASE_YM	CTPRVN_NM	SIGNGU_NM	SEXDSTN_FLAG_CD	AGRDE_CO	FAMILY_TY_NM	BRDCST_TY_NM	GENRE_LCLAS_NM	GENRE_MLSFC_NM	HLDY_AT	AVRG_WTCHNG_CO	AVRG_WTCHNG_TIME_CO	DAWN_AVRG_WTCHNG_TIME_CO	AM_AVRG_WTCHNG_TIME_CO	PM_AVRG_WTCHNG_TIME_CO	EVENING_AVRG_WTCHNG_TIME_CO	AVRG_VOD_PRCHS_PRICE
0	202011	대전시	유성구	M	5	키즈맘_중고등생	LINEAR_TV	스포츠	축구	Y	5	25	45	0	11	11	0
1	202011	경남	거제시	M	5	시니어_독립자녀	LINEAR_TV	영화	기타	N	5	54	21	0	21	57	0
2	202011	전북	김제시	M	3	키즈맘_미취학	LINEAR_TV	시사/교양	뉴스/시사	N	20	194	<NA>	46	132	216	0
3	202011	서울시	중랑구	F	3	시니어_성인자녀	LINEAR_TV	시사/교양	뉴스/시사	N	19	149	54	209	0	49	0
4	202011	강원도	춘천시	F	3	키즈맘_초등생	VOD	영화	드라마	Y	4	19	28	17	12	13	<NA>
5	202011	인천시	서구	F	4	키즈맘_초등생	VOD	영화	코미디	Y	7	53	14	32	42	65	<NA>
6	202011	강원도	원주시	F	2	1인가구	LINEAR_TV	TV 드라마	TV 드라마	N	2	23	12	13	4	29	0
7	202011	충북	괴산군	M	5	시니어_독립자녀	VOD	영화	코미디	N	4	28	<NA>	0	30	18	0
8	202011	경기도	김포시	M	5	<NA>	VOD	방송	연예오락	N	5	85	0	91	51	50	<NA>
9	202011	경북	포항시 북구	M	2	시니어_성인자녀	VOD	영화	액션	N	4	64	86	35	2	25	0

	BASE_YM	CTPRVN_NM	SIGNGU_NM	SEXDSTN_FLAG_CD	AGRDE_CO	FAMILY_TY_NM	BRDCST_TY_NM	GENRE_LCLAS_NM	GENRE_MLSFC_NM	HLDY_AT	AVRG_WTCHNG_CO	AVRG_WTCHNG_TIME_CO	DAWN_AVRG_WTCHNG_TIME_CO	AM_AVRG_WTCHNG_TIME_CO	PM_AVRG_WTCHNG_TIME_CO	EVENING_AVRG_WTCHNG_TIME_CO	AVRG_VOD_PRCHS_PRICE
590	202011	부산시	북구	M	4	<NA>	VOD	방송	연예오락	Y	9	153	131	109	82	79	<NA>
591	202011	경기도	남양주시	F	4	키즈맘_중고등생	LINEAR_TV	연예/오락	연예정보	Y	3	11	6	9	4	20	0
592	202011	경기도	남양주시	M	4	<NA>	VOD	영화	극장판 애니	Y	3	57	<NA>	0	33	108	<NA>
593	202011	서울시	강동구	F	3	1인가구	LINEAR_TV	시사/교양	기타	Y	5	53	32	136	26	4	0
594	202011	서울시	송파구	M	5	키즈맘_미취학	VOD	영화	드라마	N	6	34	16	51	17	16	0
595	202011	경기도	오산시	M	3	키즈맘_미취학	VOD	해외시리즈	미국	N	23	194	36	32	6	252	0
596	202011	인천시	부평구	M	5	키즈맘_미취학	LINEAR_TV	연예/오락	기타	N	32	175	228	15	112	70	0
597	202011	경기도	안산시 단원구	M	4	키즈맘_초등생	VOD	라이프	스포츠	Y	4	10	1	8	19	5	0
598	202011	서울시	강서구	M	6	시니어_성인자녀	LINEAR_TV	스포츠	배구	N	2	3	<NA>	7	0	2	0
599	202011	경기도	고양시 일산서구	M	4	키즈맘_미취학	LINEAR_TV	스포츠	기타	N	4	11	16	1	5	14	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values

Length

Interactions

Correlations

Missing values

Sample