Overview

Dataset statistics

Number of variables15
Number of observations101
Missing cells202
Missing cells (%)13.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.7 KiB
Average record size in memory128.3 B

Variable types

Categorical12
Unsupported2
Numeric1

Alerts

BRDCST_DE has constant value ""Constant
CHNNEL_NM has constant value ""Constant
PROGRM_BEGIN_TIME has constant value ""Constant
PROGRM_END_TIME has constant value ""Constant
PROGRM_NM has constant value ""Constant
PROGRM_BRDCST_AREA_NM has constant value ""Constant
PROGRM_TIME 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
PROGRM_DC has 101 (100.0%) missing valuesMissing
BRDCST_TME_NM has 101 (100.0%) missing valuesMissing
PROGRM_DC is an unsupported type, check if it needs cleaning or further analysisUnsupported
BRDCST_TME_NM is an unsupported type, check if it needs cleaning or further analysisUnsupported
AUDE_CO has 70 (69.3%) zerosZeros

Reproduction

Analysis started2023-12-10 09:57:33.347182
Analysis finished2023-12-10 09:57:34.687932
Duration1.34 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

BRDCST_DE
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
20210701
101 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20210701 101
100.0%

Length

2023-12-10T18:57:34.839648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:35.046152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20210701 101
100.0%

CHNNEL_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
KBS1
101 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KBS1 101
100.0%

Length

2023-12-10T18:57:35.246853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:35.464115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kbs1 101
100.0%

PROGRM_BEGIN_TIME
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
50005
101 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
50005 101
100.0%

Length

2023-12-10T18:57:35.782188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:35.986012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
50005 101
100.0%

PROGRM_END_TIME
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
50900
101 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
50900 101
100.0%

Length

2023-12-10T18:57:36.190887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:36.450250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
50900 101
100.0%

PROGRM_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
생활의발견스페셜<KBS1>
101 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row생활의발견스페셜<KBS1>
2nd row생활의발견스페셜<KBS1>
3rd row생활의발견스페셜<KBS1>
4th row생활의발견스페셜<KBS1>
5th row생활의발견스페셜<KBS1>

Common Values

ValueCountFrequency (%)
생활의발견스페셜<KBS1> 101
100.0%

Length

2023-12-10T18:57:36.658340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:36.885198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활의발견스페셜<kbs1 101
100.0%

PROGRM_DC
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

BRDCST_TME_NM
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

PROGRM_BRDCST_AREA_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
전국
101 

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 (%)
전국 101
100.0%

Length

2023-12-10T18:57:37.554383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:37.740628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전국 101
100.0%

PROGRM_TIME
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
855
101 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
855 101
100.0%

Length

2023-12-10T18:57:38.023964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:38.208140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
855 101
100.0%

PROGRM_GENRE_LCLAS_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
정보
101 

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 (%)
정보 101
100.0%

Length

2023-12-10T18:57:38.474376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:38.742053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정보 101
100.0%

PROGRM_GENRE_MLSFC_NM
Categorical

CONSTANT 

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

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 (%)
생활정보 101
100.0%

Length

2023-12-10T18:57:38.985694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:39.244224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활정보 101
100.0%

PROGRM_GENRE_SCLAS_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size940.0 B
생활정보(가사)
101 

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 (%)
생활정보(가사) 101
100.0%

Length

2023-12-10T18:57:39.450013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:39.773813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
생활정보(가사 101
100.0%

AREA_NM
Categorical

Distinct7
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size940.0 B
전국
15 
서울
15 
경기·인천
15 
부산
15 
대전
15 
Other values (2)
26 

Length

Max length5
Median length2
Mean length2.4455446
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
전국 15
14.9%
서울 15
14.9%
경기·인천 15
14.9%
부산 15
14.9%
대전 15
14.9%
대구 15
14.9%
광주 11
10.9%

Length

2023-12-10T18:57:40.091944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:57:40.386297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전국 15
14.9%
서울 15
14.9%
경기·인천 15
14.9%
부산 15
14.9%
대전 15
14.9%
대구 15
14.9%
광주 11
10.9%

ANALS_TRGET_NM
Categorical

Distinct15
Distinct (%)14.9%
Missing0
Missing (%)0.0%
Memory size940.0 B
개인
7 
개인 성/연령(10세 단위)(4-9세 남자)
7 
개인 성/연령(10세 단위)(4-9세 여자)
7 
개인 성/연령(10세 단위)(10대 남자)
7 
개인 성/연령(10세 단위)(10대 여자)
7 
Other values (10)
66 

Length

Max length26
Median length23
Mean length22.039604
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개인
2nd row개인 성/연령(10세 단위)(4-9세 남자)
3rd row개인 성/연령(10세 단위)(4-9세 여자)
4th row개인 성/연령(10세 단위)(10대 남자)
5th row개인 성/연령(10세 단위)(10대 여자)

Common Values

ValueCountFrequency (%)
개인 7
 
6.9%
개인 성/연령(10세 단위)(4-9세 남자) 7
 
6.9%
개인 성/연령(10세 단위)(4-9세 여자) 7
 
6.9%
개인 성/연령(10세 단위)(10대 남자) 7
 
6.9%
개인 성/연령(10세 단위)(10대 여자) 7
 
6.9%
개인 성/연령(10세 단위)(20대 남자) 7
 
6.9%
개인 성/연령(10세 단위)(20대 여자) 7
 
6.9%
개인 성/연령(10세 단위)(30대 남자) 7
 
6.9%
개인 성/연령(10세 단위)(30대 여자) 7
 
6.9%
개인 성/연령(10세 단위)(40대 남자) 7
 
6.9%
Other values (5) 31
30.7%

Length

2023-12-10T18:57:40.811823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
개인 101
25.6%
성/연령(10세 94
23.8%
남자 47
11.9%
여자 47
11.9%
단위)(4-9세 14
 
3.5%
단위)(10대 14
 
3.5%
단위)(20대 14
 
3.5%
단위)(30대 14
 
3.5%
단위)(40대 14
 
3.5%
단위)(50대 12
 
3.0%
Other values (2) 24
 
6.1%

AUDE_CO
Real number (ℝ)

ZEROS 

Distinct30
Distinct (%)29.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4579307
Minimum0
Maximum106.069
Zeros70
Zeros (%)69.3%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:57:41.097644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31.088
95-th percentile15.162
Maximum106.069
Range106.069
Interquartile range (IQR)1.088

Descriptive statistics

Standard deviation11.943714
Coefficient of variation (CV)3.4540061
Kurtosis56.282908
Mean3.4579307
Median Absolute Deviation (MAD)0
Skewness6.9400356
Sum349.251
Variance142.65229
MonotonicityNot monotonic
2023-12-10T18:57:41.407861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
0.0 70
69.3%
6.412 2
 
2.0%
1.088 2
 
2.0%
106.069 1
 
1.0%
10.463 1
 
1.0%
4.137 1
 
1.0%
5.204 1
 
1.0%
0.323 1
 
1.0%
0.242 1
 
1.0%
0.74 1
 
1.0%
Other values (20) 20
 
19.8%
ValueCountFrequency (%)
0.0 70
69.3%
0.242 1
 
1.0%
0.323 1
 
1.0%
0.625 1
 
1.0%
0.74 1
 
1.0%
1.088 2
 
2.0%
2.354 1
 
1.0%
2.358 1
 
1.0%
2.621 1
 
1.0%
2.629 1
 
1.0%
ValueCountFrequency (%)
106.069 1
1.0%
44.076 1
1.0%
20.43 1
1.0%
17.406 1
1.0%
16.21 1
1.0%
15.162 1
1.0%
13.926 1
1.0%
13.732 1
1.0%
11.153 1
1.0%
10.463 1
1.0%

Interactions

2023-12-10T18:57:33.734049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:57:41.628076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
AREA_NMANALS_TRGET_NMAUDE_CO
AREA_NM1.0000.0000.000
ANALS_TRGET_NM0.0001.0000.421
AUDE_CO0.0000.4211.000
2023-12-10T18:57:41.807247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ANALS_TRGET_NMAREA_NM
ANALS_TRGET_NM1.0000.000
AREA_NM0.0001.000
2023-12-10T18:57:42.030228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
AUDE_COAREA_NMANALS_TRGET_NM
AUDE_CO1.0000.0000.234
AREA_NM0.0001.0000.000
ANALS_TRGET_NM0.2340.0001.000

Missing values

2023-12-10T18:57:33.989594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:57:34.478723image/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

BRDCST_DECHNNEL_NMPROGRM_BEGIN_TIMEPROGRM_END_TIMEPROGRM_NMPROGRM_DCBRDCST_TME_NMPROGRM_BRDCST_AREA_NMPROGRM_TIMEPROGRM_GENRE_LCLAS_NMPROGRM_GENRE_MLSFC_NMPROGRM_GENRE_SCLAS_NMAREA_NMANALS_TRGET_NMAUDE_CO
020210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인106.069
120210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(4-9세 남자)0.0
220210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(4-9세 여자)6.412
320210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(10대 남자)0.0
420210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(10대 여자)0.0
520210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(20대 남자)0.0
620210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(20대 여자)1.088
720210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(30대 남자)13.732
820210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(30대 여자)7.065
920210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)전국개인 성/연령(10세 단위)(40대 남자)7.834
BRDCST_DECHNNEL_NMPROGRM_BEGIN_TIMEPROGRM_END_TIMEPROGRM_NMPROGRM_DCBRDCST_TME_NMPROGRM_BRDCST_AREA_NMPROGRM_TIMEPROGRM_GENRE_LCLAS_NMPROGRM_GENRE_MLSFC_NMPROGRM_GENRE_SCLAS_NMAREA_NMANALS_TRGET_NMAUDE_CO
9120210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(4-9세 남자)0.0
9220210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(4-9세 여자)0.0
9320210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(10대 남자)0.0
9420210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(10대 여자)0.0
9520210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(20대 남자)0.0
9620210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(20대 여자)0.0
9720210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(30대 남자)0.0
9820210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(30대 여자)0.0
9920210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(40대 남자)0.0
10020210701KBS15000550900생활의발견스페셜<KBS1><NA><NA>전국855정보생활정보생활정보(가사)광주개인 성/연령(10세 단위)(40대 여자)0.0