gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	58
Missing cells	275
Missing cells (%)	79.0%
Duplicate rows	1
Duplicate rows (%)	1.7%
Total size in memory	3.0 KiB
Average record size in memory	53.3 B

Variable types

Text	3
Unsupported	3

Dataset

Description	샘플 데이터
Author	MBN
URL	https://kdx.kr/data/view/163

Alerts

Dataset has 1 (1.7%) duplicate rows	Duplicates
`RSTRC_VID_ESSN_NO` has 25 (43.1%) missing values	Missing
`VID_SJ_CN` has 38 (65.5%) missing values	Missing
`VID_CN` has 38 (65.5%) missing values	Missing
`REG_DATE` has 58 (100.0%) missing values	Missing
`VOD_CRS_NM` has 58 (100.0%) missing values	Missing
`Unnamed: 5` has 58 (100.0%) missing values	Missing
`REG_DATE` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`VOD_CRS_NM` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Unnamed: 5` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-12-11 22:09:12.919547
Analysis finished	2023-12-11 22:09:14.650093
Duration	1.73 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

RSTRC_VID_ESSN_NO
Text

MISSING

Distinct	33
Distinct (%)	100.0%
Missing	25
Missing (%)	43.1%
Memory size	596.0 B

Length

Max length	37
Median length	32
Mean length	21.727273
Min length	7

Characters and Unicode

Total characters	717
Distinct characters	159
Distinct categories	5 ?
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	33 ?
Unique (%)	100.0%

Sample

1st row	1010501
2nd row	그러나 이런 꿈들이 무조건 길몽은 아니다?!
3rd row	조상 꿈 해석의 포인트가 되는 것은 과연 무엇일까?
4th row	1010502
5th row	돼지 꿈 중에서도 특히 이런 돼지 꿈이 대박이다?

Value	Count	Frequency (%)
돼지	5	2.7%
꿈	5	2.7%
수	4	2.2%
과연	4	2.2%
이런	3	1.6%
하는데	3	1.6%
실제	3	1.6%
것은	3	1.6%
중에서도	3	1.6%
아이의	2	1.1%
Other values (134)	147	80.8%

Most occurring characters

Value	Count	Frequency (%)
	152	21.2%
이	25	3.5%
0	25	3.5%
1	25	3.5%
는	18	2.5%
은	15	2.1%
꿈	15	2.1%
몽	15	2.1%
.	12	1.7%
다	11	1.5%
Other values (149)	404	56.3%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	461	64.3%
Space Separator	152	21.2%
Decimal Number	71	9.9%
Other Punctuation	31	4.3%
Math Symbol	2	0.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
이	25	5.4%
는	18	3.9%
은	15	3.3%
꿈	15	3.3%
몽	15	3.3%
다	11	2.4%
의	10	2.2%
길	9	2.0%
하	9	2.0%
들	8	1.7%
Other values (136)	326	70.7%

Decimal Number

Value	Count	Frequency (%)
0	25	35.2%
1	25	35.2%
5	11	15.5%
2	5	7.0%
8	2	2.8%
7	1	1.4%
6	1	1.4%
9	1	1.4%

Other Punctuation

Value	Count	Frequency (%)
.	12	38.7%
?	11	35.5%
!	8	25.8%

Space Separator

Value	Count	Frequency (%)
	152	100.0%

Math Symbol

Value	Count	Frequency (%)
~	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	461	64.3%
Common	256	35.7%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
이	25	5.4%
는	18	3.9%
은	15	3.3%
꿈	15	3.3%
몽	15	3.3%
다	11	2.4%
의	10	2.2%
길	9	2.0%
하	9	2.0%
들	8	1.7%
Other values (136)	326	70.7%

Common

Value	Count	Frequency (%)
	152	59.4%
0	25	9.8%
1	25	9.8%
.	12	4.7%
?	11	4.3%
5	11	4.3%
!	8	3.1%
2	5	2.0%
8	2	0.8%
~	2	0.8%
Other values (3)	3	1.2%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	461	64.3%
ASCII	256	35.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	152	59.4%
0	25	9.8%
1	25	9.8%
.	12	4.7%
?	11	4.3%
5	11	4.3%
!	8	3.1%
2	5	2.0%
8	2	0.8%
~	2	0.8%
Other values (3)	3	1.2%

Hangul

Value	Count	Frequency (%)
이	25	5.4%
는	18	3.9%
은	15	3.3%
꿈	15	3.3%
몽	15	3.3%
다	11	2.4%
의	10	2.2%
길	9	2.0%
하	9	2.0%
들	8	1.7%
Other values (136)	326	70.7%

VID_SJ_CN
Text

MISSING

Distinct	11
Distinct (%)	55.0%
Missing	38
Missing (%)	65.5%
Memory size	596.0 B

Length

Max length	31
Median length	30
Mean length	16.95
Min length	8

Characters and Unicode

Total characters	339
Distinct characters	116
Distinct categories	5 ?
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	10 ?
Unique (%)	50.0%

Sample

1st row	길몽인 줄 알았던 조상 꿈, 무조건 길몽은 아니다?!
2nd row	20160104
3rd row	새해맞이 꿈 풀이, 이런 돼지 꿈이 대박이다?
4th row	20160104
5th row	많은 동물 중 왜 하필 돼지 꿈이 길몽일까?

Value	Count	Frequency (%)
20160104	10	12.2%
꿈이	3	3.7%
길몽은	2	2.4%
내	2	2.4%
있다	2	2.4%
돼지	2	2.4%
풀이	2	2.4%
꿈	2	2.4%
할까	1	1.2%
태어날	1	1.2%
Other values (55)	55	67.1%

Most occurring characters

Value	Count	Frequency (%)
	62	18.3%
0	30	8.8%
1	21	6.2%
2	10	2.9%
6	10	2.9%
4	10	2.9%
이	10	2.9%
?	8	2.4%
몽	7	2.1%
!	6	1.8%
Other values (106)	165	48.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	178	52.5%
Decimal Number	81	23.9%
Space Separator	62	18.3%
Other Punctuation	17	5.0%
Math Symbol	1	0.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
이	10	5.6%
몽	7	3.9%
다	6	3.4%
꿈	6	3.4%
는	5	2.8%
을	5	2.8%
길	5	2.8%
게	4	2.2%
해	3	1.7%
은	3	1.7%
Other values (96)	124	69.7%

Decimal Number

Value	Count	Frequency (%)
0	30	37.0%
1	21	25.9%
2	10	12.3%
6	10	12.3%
4	10	12.3%

Other Punctuation

Value	Count	Frequency (%)
?	8	47.1%
!	6	35.3%
,	3	17.6%

Space Separator

Value	Count	Frequency (%)
	62	100.0%

Math Symbol

Value	Count	Frequency (%)
~	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	178	52.5%
Common	161	47.5%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
이	10	5.6%
몽	7	3.9%
다	6	3.4%
꿈	6	3.4%
는	5	2.8%
을	5	2.8%
길	5	2.8%
게	4	2.2%
해	3	1.7%
은	3	1.7%
Other values (96)	124	69.7%

Common

Value	Count	Frequency (%)
	62	38.5%
0	30	18.6%
1	21	13.0%
2	10	6.2%
6	10	6.2%
4	10	6.2%
?	8	5.0%
!	6	3.7%
,	3	1.9%
~	1	0.6%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	178	52.5%
ASCII	161	47.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	62	38.5%
0	30	18.6%
1	21	13.0%
2	10	6.2%
6	10	6.2%
4	10	6.2%
?	8	5.0%
!	6	3.7%
,	3	1.9%
~	1	0.6%

Hangul

Value	Count	Frequency (%)
이	10	5.6%
몽	7	3.9%
다	6	3.4%
꿈	6	3.4%
는	5	2.8%
을	5	2.8%
길	5	2.8%
게	4	2.2%
해	3	1.7%
은	3	1.7%
Other values (96)	124	69.7%

VID_CN
Text

MISSING

Distinct	20
Distinct (%)	100.0%
Missing	38
Missing (%)	65.5%
Memory size	596.0 B

Length

Max length	82
Median length	60
Mean length	54.25
Min length	20

Characters and Unicode

Total characters	1085
Distinct characters	143
Distinct categories	8 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

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

Unique

Unique	20 ?
Unique (%)	100.0%

Sample

1st row	흔히 길몽이라 알려진 조상 꿈과 돼지 꿈!
2nd row	http://www.mbn.co.kr/player/movieContents.mbn?content_cls_cd=21&content_id=1010501
3rd row	꿈에서 보기만 해도 행복해지는 돼지!
4th row	http://www.mbn.co.kr/player/movieContents.mbn?content_cls_cd=21&content_id=1010502
5th row	많은 사람이 길몽이라 알고 있는 돼지 꿈.

Value	Count	Frequency (%)
돼지	3	3.6%
길몽이라	2	2.4%
꿈	2	2.4%
사람이	2	2.4%
흔히	1	1.2%
http://www.mbn.co.kr/player/moviecontents.mbn?content_cls_cd=21&content_id=1010525	1	1.2%
http://www.mbn.co.kr/player/moviecontents.mbn?content_cls_cd=21&content_id=1010526	1	1.2%
악몽	1	1.2%
괴롭히는	1	1.2%
잠자리를	1	1.2%
Other values (69)	69	82.1%

Most occurring characters

Value	Count	Frequency (%)
t	80	7.4%
n	80	7.4%
	64	5.9%
e	50	4.6%
o	50	4.6%
c	50	4.6%
.	42	3.9%
/	40	3.7%
1	35	3.2%
m	30	2.8%
Other values (133)	564	52.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	560	51.6%
Other Letter	188	17.3%
Other Punctuation	121	11.2%
Decimal Number	91	8.4%
Space Separator	64	5.9%
Connector Punctuation	30	2.8%
Math Symbol	21	1.9%
Uppercase Letter	10	0.9%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
는	7	3.7%
한	6	3.2%
이	6	3.2%
꿈	6	3.2%
다	6	3.2%
지	5	2.7%
몽	5	2.7%
에	4	2.1%
상	4	2.1%
의	4	2.1%
Other values (94)	135	71.8%

Lowercase Letter

Value	Count	Frequency (%)
t	80	14.3%
n	80	14.3%
e	50	8.9%
o	50	8.9%
c	50	8.9%
m	30	5.4%
w	30	5.4%
r	20	3.6%
p	20	3.6%
b	20	3.6%
Other values (9)	130	23.2%

Decimal Number

Value	Count	Frequency (%)
1	35	38.5%
0	25	27.5%
2	15	16.5%
5	11	12.1%
8	2	2.2%
7	1	1.1%
6	1	1.1%
9	1	1.1%

Other Punctuation

Value	Count	Frequency (%)
.	42	34.7%
/	40	33.1%
?	12	9.9%
:	10	8.3%
&	10	8.3%
!	5	4.1%
,	2	1.7%

Math Symbol

Value	Count	Frequency (%)
=	20	95.2%
~	1	4.8%

Space Separator

Value	Count	Frequency (%)
	64	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	30	100.0%

Uppercase Letter

Value	Count	Frequency (%)
C	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	570	52.5%
Common	327	30.1%
Hangul	188	17.3%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
는	7	3.7%
한	6	3.2%
이	6	3.2%
꿈	6	3.2%
다	6	3.2%
지	5	2.7%
몽	5	2.7%
에	4	2.1%
상	4	2.1%
의	4	2.1%
Other values (94)	135	71.8%

Latin

Value	Count	Frequency (%)
t	80	14.0%
n	80	14.0%
e	50	8.8%
o	50	8.8%
c	50	8.8%
m	30	5.3%
w	30	5.3%
r	20	3.5%
p	20	3.5%
b	20	3.5%
Other values (10)	140	24.6%

Common

Value	Count	Frequency (%)
	64	19.6%
.	42	12.8%
/	40	12.2%
1	35	10.7%
_	30	9.2%
0	25	7.6%
=	20	6.1%
2	15	4.6%
?	12	3.7%
5	11	3.4%
Other values (9)	33	10.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	897	82.7%
Hangul	188	17.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	80	8.9%
n	80	8.9%
	64	7.1%
e	50	5.6%
o	50	5.6%
c	50	5.6%
.	42	4.7%
/	40	4.5%
1	35	3.9%
m	30	3.3%
Other values (29)	376	41.9%

Hangul

Value	Count	Frequency (%)
는	7	3.7%
한	6	3.2%
이	6	3.2%
꿈	6	3.2%
다	6	3.2%
지	5	2.7%
몽	5	2.7%
에	4	2.1%
상	4	2.1%
의	4	2.1%
Other values (94)	135	71.8%

REG_DATE
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	58
Missing (%)	100.0%
Memory size	654.0 B

VOD_CRS_NM
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	58
Missing (%)	100.0%
Memory size	654.0 B

Unnamed: 5
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	58
Missing (%)	100.0%
Memory size	654.0 B

Phik (φk)

Heatmap
Table

	RSTRC_VID_ESSN_NO	VID_SJ_CN	VID_CN
RSTRC_VID_ESSN_NO	1.000	1.000	1.000
VID_SJ_CN	1.000	1.000	1.000
VID_CN	1.000	1.000	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

	RSTRC_VID_ESSN_NO	VID_SJ_CN	VID_CN	REG_DATE	VOD_CRS_NM	Unnamed: 5
0	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
1	1010501	길몽인 줄 알았던 조상 꿈, 무조건 길몽은 아니다?!	흔히 길몽이라 알려진 조상 꿈과 돼지 꿈!	<NA>	<NA>	<NA>
2	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
3	그러나 이런 꿈들이 무조건 길몽은 아니다?!	<NA>	<NA>	<NA>	<NA>	<NA>
4	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
5	조상 꿈 해석의 포인트가 되는 것은 과연 무엇일까?	20160104	http://www.mbn.co.kr/player/movieContents.mbn?content_cls_cd=21&content_id=1010501	<NA>	<NA>	<NA>
6	1010502	새해맞이 꿈 풀이, 이런 돼지 꿈이 대박이다?	꿈에서 보기만 해도 행복해지는 돼지!	<NA>	<NA>	<NA>
7	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
8	돼지 꿈 중에서도 특히 이런 돼지 꿈이 대박이다?	<NA>	<NA>	<NA>	<NA>	<NA>
9	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>

	RSTRC_VID_ESSN_NO	VID_SJ_CN	VID_CN	REG_DATE	VOD_CRS_NM	Unnamed: 5
48	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
49	그런데 이런 길몽도 효력과 효능이 제각각이라고 하는데...	20160104	http://www.mbn.co.kr/player/movieContents.mbn?content_cls_cd=21&content_id=1010527	<NA>	<NA>	<NA>
50	1010528	다른 사람의 길몽, 비싸게 주고 사세요~	다른 사람이 꾼 길몽, 최대한 빠르고 비싸게 사는 게 좋다고 하는데~	<NA>	<NA>	<NA>
51	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
52	그중에서도 태몽은 꼭 돈을 주고 사야 한다?	<NA>	<NA>	<NA>	<NA>	<NA>
53	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
54	꿈을 꾼 후 내용을 발설하는 것은 그 운이 달아난다?	<NA>	<NA>	<NA>	<NA>	<NA>
55	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>
56	꿈 내용을 얘기하지 말라는 것은 모두 속설이라고 하는데...	20160104	http://www.mbn.co.kr/player/movieContents.mbn?content_cls_cd=21&content_id=1010528	<NA>	<NA>	<NA>
57	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>

Most frequently occurring

	RSTRC_VID_ESSN_NO	VID_SJ_CN	VID_CN	# duplicates
0	<NA>	<NA>	<NA>	25

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Space Separator

Math Symbol

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Space Separator

Math Symbol

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Decimal Number

Other Punctuation

Math Symbol

Space Separator

Connector Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring