Overview

Dataset statistics

Number of variables14
Number of observations100
Missing cells100
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.6 KiB
Average record size in memory118.3 B

Variable types

Categorical12
Unsupported1
Numeric1

Alerts

progrm_brdcst_area_cd has constant value ""Constant
progrm_genre_lclas_nm has constant value ""Constant
progrm_genre_mlsfc_nm has constant value ""Constant
progrm_genre_sclas_nm has constant value ""Constant
date_de is highly overall correlated with chnnel_cd and 5 other fieldsHigh correlation
chnnel_cd is highly overall correlated with date_de and 4 other fieldsHigh correlation
progrm_begin_tm_tm is highly overall correlated with date_de and 4 other fieldsHigh correlation
progrm_nm_nm is highly overall correlated with date_de and 4 other fieldsHigh correlation
progrm_dc_dc is highly overall correlated with date_de and 4 other fieldsHigh correlation
progrm_end_tm_tm is highly overall correlated with date_de and 4 other fieldsHigh correlation
progrm_brdcst_area_rciv_cd is highly overall correlated with date_deHigh correlation
date_de is highly imbalanced (80.6%)Imbalance
seq_sn has 100 (100.0%) missing valuesMissing
seq_sn is an unsupported type, check if it needs cleaning or further analysisUnsupported
aude_co_co has 64 (64.0%) zerosZeros

Reproduction

Analysis started2023-12-10 10:00:13.971099
Analysis finished2023-12-10 10:00:15.914413
Duration1.94 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

date_de
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20211002
97 
20211031
 
3

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20211002
2nd row20211031
3rd row20211002
4th row20211002
5th row20211002

Common Values

ValueCountFrequency (%)
20211002 97
97.0%
20211031 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:16.212618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20211002 97
97.0%
20211031 3
 
3.0%

chnnel_cd
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
공영쇼핑
61 
현대홈쇼핑
36 
CJ오쇼핑
 
3

Length

Max length5
Median length4
Mean length4.39
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공영쇼핑
2nd rowCJ오쇼핑
3rd row공영쇼핑
4th row공영쇼핑
5th row공영쇼핑

Common Values

ValueCountFrequency (%)
공영쇼핑 61
61.0%
현대홈쇼핑 36
36.0%
CJ오쇼핑 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:16.637138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공영쇼핑 61
61.0%
현대홈쇼핑 36
36.0%
cj오쇼핑 3
 
3.0%

progrm_begin_tm_tm
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
225506
61 
240006
36 
213506
 
3

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row225506
2nd row213506
3rd row225506
4th row225506
5th row225506

Common Values

ValueCountFrequency (%)
225506 61
61.0%
240006 36
36.0%
213506 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:17.055063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
225506 61
61.0%
240006 36
36.0%
213506 3
 
3.0%

progrm_end_tm_tm
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
235459
61 
245959
36 
223959
 
3

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row235459
2nd row223959
3rd row235459
4th row235459
5th row235459

Common Values

ValueCountFrequency (%)
235459 61
61.0%
245959 36
36.0%
223959 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:17.647608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
235459 61
61.0%
245959 36
36.0%
223959 3
 
3.0%

progrm_nm_nm
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
소개방송
61 
트렌드세터데이
36 
WEEKLYBEST5부
 
3

Length

Max length12
Median length4
Mean length5.32
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row소개방송
2nd rowWEEKLYBEST5부
3rd row소개방송
4th row소개방송
5th row소개방송

Common Values

ValueCountFrequency (%)
소개방송 61
61.0%
트렌드세터데이 36
36.0%
WEEKLYBEST5부 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:18.137845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소개방송 61
61.0%
트렌드세터데이 36
36.0%
weeklybest5부 3
 
3.0%

progrm_dc_dc
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제주여행2박3일패키지
61 
용평리조트이용권
36 
제주신화월드숙박권
 
3

Length

Max length11
Median length11
Mean length9.86
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주여행2박3일패키지
2nd row제주신화월드숙박권
3rd row제주여행2박3일패키지
4th row제주여행2박3일패키지
5th row제주여행2박3일패키지

Common Values

ValueCountFrequency (%)
제주여행2박3일패키지 61
61.0%
용평리조트이용권 36
36.0%
제주신화월드숙박권 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:18.552882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주여행2박3일패키지 61
61.0%
용평리조트이용권 36
36.0%
제주신화월드숙박권 3
 
3.0%

seq_sn
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

progrm_brdcst_area_cd
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전국
2nd row전국
3rd row전국
4th row전국
5th row전국

Common Values

ValueCountFrequency (%)
전국 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:18.951976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전국 100
100.0%

progrm_genre_lclas_nm
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정보
2nd row정보
3rd row정보
4th row정보
5th row정보

Common Values

ValueCountFrequency (%)
정보 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:19.413516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정보 100
100.0%

progrm_genre_mlsfc_nm
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
생활정보
100 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활정보
2nd row생활정보
3rd row생활정보
4th row생활정보
5th row생활정보

Common Values

ValueCountFrequency (%)
생활정보 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:19.913123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활정보 100
100.0%

progrm_genre_sclas_nm
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
생활정보(기타)
100 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활정보(기타)
2nd row생활정보(기타)
3rd row생활정보(기타)
4th row생활정보(기타)
5th row생활정보(기타)

Common Values

ValueCountFrequency (%)
생활정보(기타) 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:20.899630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활정보(기타 100
100.0%

progrm_brdcst_area_rciv_cd
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
경기·인천
8 
부산
8 
대전
8 
대구
8 
광주
8 
Other values (11)
60 

Length

Max length5
Median length2
Mean length2.87
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전국
2nd row제주도
3rd row전국
4th row전국
5th row서울

Common Values

ValueCountFrequency (%)
경기·인천 8
 
8.0%
부산 8
 
8.0%
대전 8
 
8.0%
대구 8
 
8.0%
광주 8
 
8.0%
강원도 8
 
8.0%
전국 7
 
7.0%
제주도 7
 
7.0%
서울 7
 
7.0%
울산 7
 
7.0%
Other values (6) 24
24.0%

Length

2023-12-10T19:00:21.184771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기·인천 8
 
8.0%
부산 8
 
8.0%
대전 8
 
8.0%
대구 8
 
8.0%
광주 8
 
8.0%
강원도 8
 
8.0%
전국 7
 
7.0%
제주도 7
 
7.0%
서울 7
 
7.0%
울산 7
 
7.0%
Other values (6) 24
24.0%

aude_mesureunit_cd
Categorical

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
유료매체가입가구
26 
가구
25 
개인
25 
유료매체가입개인
24 

Length

Max length8
Median length5
Mean length5
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가구
2nd row개인
3rd row유료매체가입가구
4th row유료매체가입개인
5th row가구

Common Values

ValueCountFrequency (%)
유료매체가입가구 26
26.0%
가구 25
25.0%
개인 25
25.0%
유료매체가입개인 24
24.0%

Length

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

Common Values (Plot)

2023-12-10T19:00:21.801956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유료매체가입가구 26
26.0%
가구 25
25.0%
개인 25
25.0%
유료매체가입개인 24
24.0%

aude_co_co
Real number (ℝ)

ZEROS 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.5
Minimum0
Maximum14
Zeros64
Zeros (%)64.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:00:22.116741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile10
Maximum14
Range14
Interquartile range (IQR)1

Descriptive statistics

Standard deviation3.1797973
Coefficient of variation (CV)2.1198649
Kurtosis5.0520259
Mean1.5
Median Absolute Deviation (MAD)0
Skewness2.446689
Sum150
Variance10.111111
MonotonicityNot monotonic
2023-12-10T19:00:22.363334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
0 64
64.0%
1 18
 
18.0%
10 5
 
5.0%
5 4
 
4.0%
12 2
 
2.0%
7 2
 
2.0%
3 2
 
2.0%
2 2
 
2.0%
14 1
 
1.0%
ValueCountFrequency (%)
0 64
64.0%
1 18
 
18.0%
2 2
 
2.0%
3 2
 
2.0%
5 4
 
4.0%
7 2
 
2.0%
10 5
 
5.0%
12 2
 
2.0%
14 1
 
1.0%
ValueCountFrequency (%)
14 1
 
1.0%
12 2
 
2.0%
10 5
 
5.0%
7 2
 
2.0%
5 4
 
4.0%
3 2
 
2.0%
2 2
 
2.0%
1 18
 
18.0%
0 64
64.0%

Interactions

2023-12-10T19:00:15.096783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:00:22.559188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
date_dechnnel_cdprogrm_begin_tm_tmprogrm_end_tm_tmprogrm_nm_nmprogrm_dc_dcprogrm_brdcst_area_rciv_cdaude_mesureunit_cdaude_co_co
date_de1.0001.0001.0001.0001.0001.0000.6920.0000.000
chnnel_cd1.0001.0001.0001.0001.0001.0000.6440.0000.207
progrm_begin_tm_tm1.0001.0001.0001.0001.0001.0000.6440.0000.207
progrm_end_tm_tm1.0001.0001.0001.0001.0001.0000.6440.0000.207
progrm_nm_nm1.0001.0001.0001.0001.0001.0000.6440.0000.207
progrm_dc_dc1.0001.0001.0001.0001.0001.0000.6440.0000.207
progrm_brdcst_area_rciv_cd0.6920.6440.6440.6440.6440.6441.0000.0000.828
aude_mesureunit_cd0.0000.0000.0000.0000.0000.0000.0001.0000.000
aude_co_co0.0000.2070.2070.2070.2070.2070.8280.0001.000
2023-12-10T19:00:22.819342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
date_deprogrm_brdcst_area_rciv_cdchnnel_cdprogrm_begin_tm_tmprogrm_nm_nmprogrm_dc_dcaude_mesureunit_cdprogrm_end_tm_tm
date_de1.0000.5120.9950.9950.9950.9950.0000.995
progrm_brdcst_area_rciv_cd0.5121.0000.4170.4170.4170.4170.0000.417
chnnel_cd0.9950.4171.0001.0001.0001.0000.0001.000
progrm_begin_tm_tm0.9950.4171.0001.0001.0001.0000.0001.000
progrm_nm_nm0.9950.4171.0001.0001.0001.0000.0001.000
progrm_dc_dc0.9950.4171.0001.0001.0001.0000.0001.000
aude_mesureunit_cd0.0000.0000.0000.0000.0000.0001.0000.000
progrm_end_tm_tm0.9950.4171.0001.0001.0001.0000.0001.000
2023-12-10T19:00:23.108239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
aude_co_codate_dechnnel_cdprogrm_begin_tm_tmprogrm_end_tm_tmprogrm_nm_nmprogrm_dc_dcprogrm_brdcst_area_rciv_cdaude_mesureunit_cd
aude_co_co1.0000.0000.1270.1270.1270.1270.1270.4270.000
date_de0.0001.0000.9950.9950.9950.9950.9950.5120.000
chnnel_cd0.1270.9951.0001.0001.0001.0001.0000.4170.000
progrm_begin_tm_tm0.1270.9951.0001.0001.0001.0001.0000.4170.000
progrm_end_tm_tm0.1270.9951.0001.0001.0001.0001.0000.4170.000
progrm_nm_nm0.1270.9951.0001.0001.0001.0001.0000.4170.000
progrm_dc_dc0.1270.9951.0001.0001.0001.0001.0000.4170.000
progrm_brdcst_area_rciv_cd0.4270.5120.4170.4170.4170.4170.4171.0000.000
aude_mesureunit_cd0.0000.0000.0000.0000.0000.0000.0000.0001.000

Missing values

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

date_dechnnel_cdprogrm_begin_tm_tmprogrm_end_tm_tmprogrm_nm_nmprogrm_dc_dcseq_snprogrm_brdcst_area_cdprogrm_genre_lclas_nmprogrm_genre_mlsfc_nmprogrm_genre_sclas_nmprogrm_brdcst_area_rciv_cdaude_mesureunit_cdaude_co_co
020211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)전국가구12
120211031CJ오쇼핑213506223959WEEKLYBEST5부제주신화월드숙박권<NA>전국정보생활정보생활정보(기타)제주도개인0
220211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)전국유료매체가입가구12
320211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)전국유료매체가입개인14
420211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)서울가구7
520211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)서울개인10
620211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)서울유료매체가입가구7
720211031CJ오쇼핑213506223959WEEKLYBEST5부제주신화월드숙박권<NA>전국정보생활정보생활정보(기타)제주도유료매체가입가구0
820211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)경기·인천가구3
920211002공영쇼핑225506235459소개방송제주여행2박3일패키지<NA>전국정보생활정보생활정보(기타)경기·인천개인2
date_dechnnel_cdprogrm_begin_tm_tmprogrm_end_tm_tmprogrm_nm_nmprogrm_dc_dcseq_snprogrm_brdcst_area_cdprogrm_genre_lclas_nmprogrm_genre_mlsfc_nmprogrm_genre_sclas_nmprogrm_brdcst_area_rciv_cdaude_mesureunit_cdaude_co_co
9020211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)광주유료매체가입가구1
9120211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)광주유료매체가입개인0
9220211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)울산가구1
9320211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)울산개인0
9420211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)울산유료매체가입가구1
9520211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)울산유료매체가입개인0
9620211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)강원도가구0
9720211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)강원도개인0
9820211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)강원도유료매체가입가구0
9920211002현대홈쇼핑240006245959트렌드세터데이용평리조트이용권<NA>전국정보생활정보생활정보(기타)강원도유료매체가입개인0