Overview

Dataset statistics

Number of variables10
Number of observations154
Missing cells927
Missing cells (%)60.2%
Duplicate rows2
Duplicate rows (%)1.3%
Total size in memory12.8 KiB
Average record size in memory84.9 B

Variable types

Text4
Categorical3
Numeric1
Unsupported2

Dataset

Description샘플 데이터
AuthorMBN
URLhttps://kdx.kr/data/view/26943

Alerts

Dataset has 2 (1.3%) duplicate rowsDuplicates
MDA_CGR_NM is highly overall correlated with STD_YEAR and 2 other fieldsHigh correlation
WRT_DATE is highly overall correlated with STD_YEAR and 2 other fieldsHigh correlation
ATCH_IMG_NM is highly overall correlated with STD_YEAR and 2 other fieldsHigh correlation
STD_YEAR is highly overall correlated with MDA_CGR_NM and 2 other fieldsHigh correlation
MDA_CGR_NM is highly imbalanced (77.7%)Imbalance
ATCH_IMG_NM is highly imbalanced (86.1%)Imbalance
WRT_DATE is highly imbalanced (91.5%)Imbalance
MBN_MDA_SP_CD has 55 (35.7%) missing valuesMissing
MDA_ART_ESSN_NO has 139 (90.3%) missing valuesMissing
STD_YEAR has 137 (89.0%) missing valuesMissing
ART_SJ_CN has 144 (93.5%) missing valuesMissing
ART_CN has 144 (93.5%) missing valuesMissing
JRNL_NM has 154 (100.0%) missing valuesMissing
Unnamed: 9 has 154 (100.0%) missing valuesMissing
JRNL_NM is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 21:15:52.971080
Analysis finished2023-12-11 21:15:53.985366
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

MBN_MDA_SP_CD
Text

MISSING 

Distinct87
Distinct (%)87.9%
Missing55
Missing (%)35.7%
Memory size1.3 KiB
2023-12-12T06:15:54.160044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length311
Median length79
Mean length48.919192
Min length1

Characters and Unicode

Total characters4843
Distinct characters485
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique85 ?
Unique (%)85.9%

Sample

1st rowMBN
2nd rowMBN
3rd rowMBN
4th rowMBN
5th row 김 의원은 "좌파독재의 도구인 공수처법이 통과됐다"며 "문재인 좌파독재 정권에 헌법이 무참히 짓밟히는 현장을 무기력하게 지켜볼 수밖에 없었다, 참담하다"고 토로했습니다.
ValueCountFrequency (%)
41
 
3.7%
mbn 13
 
1.2%
10
 
0.9%
기자 9
 
0.8%
인터뷰 9
 
0.8%
검찰 8
 
0.7%
7
 
0.6%
지난해 7
 
0.6%
조국 7
 
0.6%
5
 
0.4%
Other values (813) 1006
89.7%
2023-12-12T06:15:54.550810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1147
 
23.7%
105
 
2.2%
101
 
2.1%
" 92
 
1.9%
. 73
 
1.5%
66
 
1.4%
58
 
1.2%
58
 
1.2%
55
 
1.1%
54
 
1.1%
Other values (475) 3034
62.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3281
67.7%
Space Separator 1147
 
23.7%
Other Punctuation 234
 
4.8%
Uppercase Letter 51
 
1.1%
Decimal Number 32
 
0.7%
Close Punctuation 26
 
0.5%
Open Punctuation 26
 
0.5%
Lowercase Letter 20
 
0.4%
Dash Punctuation 12
 
0.2%
Other Symbol 11
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
105
 
3.2%
101
 
3.1%
66
 
2.0%
58
 
1.8%
58
 
1.8%
55
 
1.7%
54
 
1.6%
51
 
1.6%
44
 
1.3%
43
 
1.3%
Other values (426) 2646
80.6%
Other Punctuation
ValueCountFrequency (%)
" 92
39.3%
. 73
31.2%
, 28
 
12.0%
: 16
 
6.8%
/ 10
 
4.3%
' 6
 
2.6%
! 4
 
1.7%
2
 
0.9%
? 1
 
0.4%
@ 1
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
r 3
15.0%
c 3
15.0%
k 3
15.0%
o 2
10.0%
m 2
10.0%
b 2
10.0%
n 2
10.0%
h 1
 
5.0%
a 1
 
5.0%
g 1
 
5.0%
Decimal Number
ValueCountFrequency (%)
1 10
31.2%
4 6
18.8%
2 4
 
12.5%
5 3
 
9.4%
8 3
 
9.4%
3 2
 
6.2%
0 2
 
6.2%
7 1
 
3.1%
6 1
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
N 17
33.3%
B 15
29.4%
M 15
29.4%
S 4
 
7.8%
Close Punctuation
ValueCountFrequency (%)
) 13
50.0%
5
 
19.2%
] 4
 
15.4%
4
 
15.4%
Open Punctuation
ValueCountFrequency (%)
( 13
50.0%
5
 
19.2%
4
 
15.4%
[ 4
 
15.4%
Math Symbol
ValueCountFrequency (%)
+ 1
33.3%
< 1
33.3%
> 1
33.3%
Other Symbol
ValueCountFrequency (%)
10
90.9%
1
 
9.1%
Space Separator
ValueCountFrequency (%)
1147
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3274
67.6%
Common 1491
30.8%
Latin 71
 
1.5%
Han 7
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
105
 
3.2%
101
 
3.1%
66
 
2.0%
58
 
1.8%
58
 
1.8%
55
 
1.7%
54
 
1.6%
51
 
1.6%
44
 
1.3%
43
 
1.3%
Other values (419) 2639
80.6%
Common
ValueCountFrequency (%)
1147
76.9%
" 92
 
6.2%
. 73
 
4.9%
, 28
 
1.9%
: 16
 
1.1%
) 13
 
0.9%
( 13
 
0.9%
- 12
 
0.8%
1 10
 
0.7%
10
 
0.7%
Other values (25) 77
 
5.2%
Latin
ValueCountFrequency (%)
N 17
23.9%
B 15
21.1%
M 15
21.1%
S 4
 
5.6%
r 3
 
4.2%
c 3
 
4.2%
k 3
 
4.2%
o 2
 
2.8%
m 2
 
2.8%
b 2
 
2.8%
Other values (4) 5
 
7.0%
Han
ValueCountFrequency (%)
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3274
67.6%
ASCII 1531
31.6%
None 18
 
0.4%
Geometric Shapes 10
 
0.2%
CJK 7
 
0.1%
Punctuation 2
 
< 0.1%
Enclosed Alphanum 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1147
74.9%
" 92
 
6.0%
. 73
 
4.8%
, 28
 
1.8%
N 17
 
1.1%
: 16
 
1.0%
B 15
 
1.0%
M 15
 
1.0%
) 13
 
0.8%
( 13
 
0.8%
Other values (32) 102
 
6.7%
Hangul
ValueCountFrequency (%)
105
 
3.2%
101
 
3.1%
66
 
2.0%
58
 
1.8%
58
 
1.8%
55
 
1.7%
54
 
1.6%
51
 
1.6%
44
 
1.3%
43
 
1.3%
Other values (419) 2639
80.6%
Geometric Shapes
ValueCountFrequency (%)
10
100.0%
None
ValueCountFrequency (%)
5
27.8%
5
27.8%
4
22.2%
4
22.2%
Punctuation
ValueCountFrequency (%)
2
100.0%
Enclosed Alphanum
ValueCountFrequency (%)
1
100.0%
CJK
ValueCountFrequency (%)
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%

MDA_ART_ESSN_NO
Text

MISSING 

Distinct12
Distinct (%)80.0%
Missing139
Missing (%)90.3%
Memory size1.3 KiB
2023-12-12T06:15:54.669072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length76
Median length7
Mean length12.133333
Min length7

Characters and Unicode

Total characters182
Distinct characters31
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11 ?
Unique (%)73.3%

Sample

1st row4023123
2nd row4023124
3rd row4023125
4th row4023130
5th row4023131
ValueCountFrequency (%)
4
26.7%
4023123 1
 
6.7%
4023124 1
 
6.7%
4023125 1
 
6.7%
4023130 1
 
6.7%
4023131 1
 
6.7%
4023146 1
 
6.7%
4023172 1
 
6.7%
http://img.mbn.co.kr/filewww/news/other/2020/01/01/020320020300.jpg 1
 
6.7%
4023183 1
 
6.7%
Other values (2) 2
13.3%
2023-12-12T06:15:54.900136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
, 45
24.7%
0 22
12.1%
2 19
10.4%
3 16
 
8.8%
1 13
 
7.1%
4 12
 
6.6%
/ 9
 
4.9%
w 4
 
2.2%
. 4
 
2.2%
8 4
 
2.2%
Other values (21) 34
18.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 90
49.5%
Other Punctuation 59
32.4%
Lowercase Letter 33
 
18.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
w 4
12.1%
t 3
 
9.1%
e 3
 
9.1%
n 2
 
6.1%
r 2
 
6.1%
o 2
 
6.1%
p 2
 
6.1%
m 2
 
6.1%
g 2
 
6.1%
i 2
 
6.1%
Other values (8) 9
27.3%
Decimal Number
ValueCountFrequency (%)
0 22
24.4%
2 19
21.1%
3 16
17.8%
1 13
14.4%
4 12
13.3%
8 4
 
4.4%
5 2
 
2.2%
6 1
 
1.1%
7 1
 
1.1%
Other Punctuation
ValueCountFrequency (%)
, 45
76.3%
/ 9
 
15.3%
. 4
 
6.8%
: 1
 
1.7%

Most occurring scripts

ValueCountFrequency (%)
Common 149
81.9%
Latin 33
 
18.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 4
12.1%
t 3
 
9.1%
e 3
 
9.1%
n 2
 
6.1%
r 2
 
6.1%
o 2
 
6.1%
p 2
 
6.1%
m 2
 
6.1%
g 2
 
6.1%
i 2
 
6.1%
Other values (8) 9
27.3%
Common
ValueCountFrequency (%)
, 45
30.2%
0 22
14.8%
2 19
12.8%
3 16
 
10.7%
1 13
 
8.7%
4 12
 
8.1%
/ 9
 
6.0%
. 4
 
2.7%
8 4
 
2.7%
5 2
 
1.3%
Other values (3) 3
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 182
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
, 45
24.7%
0 22
12.1%
2 19
10.4%
3 16
 
8.8%
1 13
 
7.1%
4 12
 
6.6%
/ 9
 
4.9%
w 4
 
2.2%
. 4
 
2.2%
8 4
 
2.2%
Other values (21) 34
18.7%

MDA_CGR_NM
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct7
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
<NA>
139 
mbn00006
 
10
황재헌
 
1
이석희
 
1
최중락
 
1
Other values (2)
 
2

Length

Max length8
Median length4
Mean length4.2272727
Min length3

Unique

Unique5 ?
Unique (%)3.2%

Sample

1st row<NA>
2nd rowmbn00006
3rd rowmbn00006
4th rowmbn00006
5th rowmbn00006

Common Values

ValueCountFrequency (%)
<NA> 139
90.3%
mbn00006 10
 
6.5%
황재헌 1
 
0.6%
이석희 1
 
0.6%
최중락 1
 
0.6%
선한빛 1
 
0.6%
조창훈 1
 
0.6%

Length

2023-12-12T06:15:55.016929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T06:15:55.105247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 139
90.3%
mbn00006 10
 
6.5%
황재헌 1
 
0.6%
이석희 1
 
0.6%
최중락 1
 
0.6%
선한빛 1
 
0.6%
조창훈 1
 
0.6%

STD_YEAR
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct8
Distinct (%)47.1%
Missing137
Missing (%)89.0%
Infinite0
Infinite (%)0.0%
Mean8.3176887 × 1012
Minimum2020
Maximum2.0200101 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-12T06:15:55.189607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2020
5-th percentile2020
Q12020
median2020
Q32.0200101 × 1013
95-th percentile2.0200101 × 1013
Maximum2.0200101 × 1013
Range2.0200101 × 1013
Interquartile range (IQR)2.0200101 × 1013

Descriptive statistics

Standard deviation1.0247504 × 1013
Coefficient of variation (CV)1.2320135
Kurtosis-2.1093878
Mean8.3176887 × 1012
Median Absolute Deviation (MAD)0
Skewness0.3942443
Sum1.4140071 × 1014
Variance1.0501135 × 1026
MonotonicityNot monotonic
2023-12-12T06:15:55.273808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2020 10
 
6.5%
20200101071535 1
 
0.6%
20200101071713 1
 
0.6%
20200101080035 1
 
0.6%
20200101093912 1
 
0.6%
20200101100100 1
 
0.6%
20200101100250 1
 
0.6%
20200101100425 1
 
0.6%
(Missing) 137
89.0%
ValueCountFrequency (%)
2020 10
6.5%
20200101071535 1
 
0.6%
20200101071713 1
 
0.6%
20200101080035 1
 
0.6%
20200101093912 1
 
0.6%
20200101100100 1
 
0.6%
20200101100250 1
 
0.6%
20200101100425 1
 
0.6%
ValueCountFrequency (%)
20200101100425 1
 
0.6%
20200101100250 1
 
0.6%
20200101100100 1
 
0.6%
20200101093912 1
 
0.6%
20200101080035 1
 
0.6%
20200101071713 1
 
0.6%
20200101071535 1
 
0.6%
2020 10
6.5%

ART_SJ_CN
Text

MISSING 

Distinct10
Distinct (%)100.0%
Missing144
Missing (%)93.5%
Memory size1.3 KiB
2023-12-12T06:15:55.476295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length34.5
Mean length34.9
Min length25

Characters and Unicode

Total characters349
Distinct characters141
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10 ?
Unique (%)100.0%

Sample

1st row[속보] 김정은 "미국, 시간 끌수록 북한 위력 앞에 속수무책 당할 것"
2nd row[속보] 북한 김정은 "머지않아 새 전략무기 목격하게 될 것"
3rd row[속보] 북한 김정은 "억제력 강화, 미국 입장따라 상향조정…적대정책 철회까지 전략무기개발 계속진행"
4th row김도읍 자유한국당 의원 내년 총선 불출마 선언
5th row김정은 "미국, 시간 끌수록 북한 위력 앞에 속수무책 당할 것"
ValueCountFrequency (%)
북한 4
 
4.8%
김정은 4
 
4.8%
속보 3
 
3.6%
미국 3
 
3.6%
3
 
3.6%
시간 2
 
2.4%
끌수록 2
 
2.4%
위력 2
 
2.4%
앞에 2
 
2.4%
속수무책 2
 
2.4%
Other values (55) 56
67.5%
2023-12-12T06:15:55.813142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
73
 
20.9%
" 16
 
4.6%
7
 
2.0%
7
 
2.0%
6
 
1.7%
6
 
1.7%
6
 
1.7%
5
 
1.4%
5
 
1.4%
5
 
1.4%
Other values (131) 213
61.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 235
67.3%
Space Separator 73
 
20.9%
Other Punctuation 28
 
8.0%
Decimal Number 7
 
2.0%
Open Punctuation 3
 
0.9%
Close Punctuation 3
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7
 
3.0%
7
 
3.0%
6
 
2.6%
6
 
2.6%
6
 
2.6%
5
 
2.1%
5
 
2.1%
5
 
2.1%
5
 
2.1%
5
 
2.1%
Other values (118) 178
75.7%
Other Punctuation
ValueCountFrequency (%)
" 16
57.1%
4
 
14.3%
' 4
 
14.3%
, 3
 
10.7%
· 1
 
3.6%
Decimal Number
ValueCountFrequency (%)
1 3
42.9%
4 1
 
14.3%
9 1
 
14.3%
0 1
 
14.3%
2 1
 
14.3%
Space Separator
ValueCountFrequency (%)
73
100.0%
Open Punctuation
ValueCountFrequency (%)
[ 3
100.0%
Close Punctuation
ValueCountFrequency (%)
] 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 235
67.3%
Common 114
32.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7
 
3.0%
7
 
3.0%
6
 
2.6%
6
 
2.6%
6
 
2.6%
5
 
2.1%
5
 
2.1%
5
 
2.1%
5
 
2.1%
5
 
2.1%
Other values (118) 178
75.7%
Common
ValueCountFrequency (%)
73
64.0%
" 16
 
14.0%
4
 
3.5%
' 4
 
3.5%
[ 3
 
2.6%
1 3
 
2.6%
, 3
 
2.6%
] 3
 
2.6%
· 1
 
0.9%
4 1
 
0.9%
Other values (3) 3
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 235
67.3%
ASCII 109
31.2%
Punctuation 4
 
1.1%
None 1
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
73
67.0%
" 16
 
14.7%
' 4
 
3.7%
[ 3
 
2.8%
1 3
 
2.8%
, 3
 
2.8%
] 3
 
2.8%
4 1
 
0.9%
9 1
 
0.9%
0 1
 
0.9%
Hangul
ValueCountFrequency (%)
7
 
3.0%
7
 
3.0%
6
 
2.6%
6
 
2.6%
6
 
2.6%
5
 
2.1%
5
 
2.1%
5
 
2.1%
5
 
2.1%
5
 
2.1%
Other values (118) 178
75.7%
Punctuation
ValueCountFrequency (%)
4
100.0%
None
ValueCountFrequency (%)
· 1
100.0%

ART_CN
Text

MISSING 

Distinct7
Distinct (%)70.0%
Missing144
Missing (%)93.5%
Memory size1.3 KiB
2023-12-12T06:15:55.997874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length133
Median length57.5
Mean length38.4
Min length8

Characters and Unicode

Total characters384
Distinct characters147
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique6 ?
Unique (%)60.0%

Sample

1st row김정은 "미국, 시간 끌수록 북한 위력 앞에 속수무책 당할 것"
2nd row북한 김정은 "머지않아 새 전략무기 목격하게 될 것"
3rd row북한 김정은 "억제력 강화, 미국 입장따라 상향조정…적대정책 철회까지 전략무기개발 계속진행"
4th row(이런 가운데) 자유한국당 김도읍 의원이 공수처법 저지 실패에 책임을 지고 내년 총선에 불출마하겠다고 선언했습니다.
5th row<!------------ PHOTO_POS_0 ------------>
ValueCountFrequency (%)
4
 
5.1%
4
 
5.1%
앵커멘트 4
 
5.1%
4
 
5.1%
김정은 3
 
3.8%
북한 3
 
3.8%
2
 
2.6%
미국 2
 
2.6%
photo_pos_0 2
 
2.6%
대표은 1
 
1.3%
Other values (49) 49
62.8%
2023-12-12T06:15:56.289877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
68
 
17.7%
- 48
 
12.5%
" 8
 
2.1%
O 6
 
1.6%
6
 
1.6%
5
 
1.3%
5
 
1.3%
5
 
1.3%
4
 
1.0%
4
 
1.0%
Other values (137) 225
58.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 214
55.7%
Space Separator 68
 
17.7%
Dash Punctuation 48
 
12.5%
Uppercase Letter 16
 
4.2%
Other Punctuation 15
 
3.9%
Open Punctuation 6
 
1.6%
Close Punctuation 6
 
1.6%
Connector Punctuation 4
 
1.0%
Math Symbol 4
 
1.0%
Decimal Number 3
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
6
 
2.8%
5
 
2.3%
5
 
2.3%
5
 
2.3%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
Other values (116) 169
79.0%
Other Punctuation
ValueCountFrequency (%)
" 8
53.3%
. 2
 
13.3%
! 2
 
13.3%
, 2
 
13.3%
1
 
6.7%
Uppercase Letter
ValueCountFrequency (%)
O 6
37.5%
P 4
25.0%
H 2
 
12.5%
T 2
 
12.5%
S 2
 
12.5%
Open Punctuation
ValueCountFrequency (%)
4
66.7%
( 2
33.3%
Close Punctuation
ValueCountFrequency (%)
4
66.7%
) 2
33.3%
Decimal Number
ValueCountFrequency (%)
0 2
66.7%
1 1
33.3%
Math Symbol
ValueCountFrequency (%)
< 2
50.0%
> 2
50.0%
Space Separator
ValueCountFrequency (%)
68
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 214
55.7%
Common 154
40.1%
Latin 16
 
4.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
6
 
2.8%
5
 
2.3%
5
 
2.3%
5
 
2.3%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
Other values (116) 169
79.0%
Common
ValueCountFrequency (%)
68
44.2%
- 48
31.2%
" 8
 
5.2%
_ 4
 
2.6%
4
 
2.6%
4
 
2.6%
) 2
 
1.3%
( 2
 
1.3%
0 2
 
1.3%
. 2
 
1.3%
Other values (6) 10
 
6.5%
Latin
ValueCountFrequency (%)
O 6
37.5%
P 4
25.0%
H 2
 
12.5%
T 2
 
12.5%
S 2
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 214
55.7%
ASCII 161
41.9%
None 8
 
2.1%
Punctuation 1
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
68
42.2%
- 48
29.8%
" 8
 
5.0%
O 6
 
3.7%
P 4
 
2.5%
_ 4
 
2.5%
) 2
 
1.2%
( 2
 
1.2%
0 2
 
1.2%
. 2
 
1.2%
Other values (8) 15
 
9.3%
Hangul
ValueCountFrequency (%)
6
 
2.8%
5
 
2.3%
5
 
2.3%
5
 
2.3%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
4
 
1.9%
Other values (116) 169
79.0%
None
ValueCountFrequency (%)
4
50.0%
4
50.0%
Punctuation
ValueCountFrequency (%)
1
100.0%

ATCH_IMG_NM
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
<NA>
151 
,,,,,,,,,
 
3

Length

Max length9
Median length4
Mean length4.0974026
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row,,,,,,,,,
3rd row,,,,,,,,,
4th row,,,,,,,,,
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 151
98.1%
,,,,,,,,, 3
 
1.9%

Length

2023-12-12T06:15:56.403397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T06:15:56.479624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 151
98.1%
3
 
1.9%

JRNL_NM
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing154
Missing (%)100.0%
Memory size1.5 KiB

WRT_DATE
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
<NA>
151 
20200101062259
 
1
20200101062328
 
1
20200101062900
 
1

Length

Max length14
Median length4
Mean length4.1948052
Min length4

Unique

Unique3 ?
Unique (%)1.9%

Sample

1st row<NA>
2nd row20200101062259
3rd row20200101062328
4th row20200101062900
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 151
98.1%
20200101062259 1
 
0.6%
20200101062328 1
 
0.6%
20200101062900 1
 
0.6%

Length

2023-12-12T06:15:56.562397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T06:15:56.646277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 151
98.1%
20200101062259 1
 
0.6%
20200101062328 1
 
0.6%
20200101062900 1
 
0.6%

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing154
Missing (%)100.0%
Memory size1.5 KiB

Interactions

2023-12-12T06:15:53.594536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T06:15:56.706481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
MBN_MDA_SP_CDMDA_ART_ESSN_NOMDA_CGR_NMSTD_YEARART_SJ_CNART_CNWRT_DATE
MBN_MDA_SP_CD1.0000.0001.000NaNNaNNaNNaN
MDA_ART_ESSN_NO0.0001.0000.000NaN1.0001.0001.000
MDA_CGR_NM1.0000.0001.000NaNNaNNaNNaN
STD_YEARNaNNaNNaN1.000NaNNaNNaN
ART_SJ_CNNaN1.000NaNNaN1.0001.0001.000
ART_CNNaN1.000NaNNaN1.0001.0001.000
WRT_DATENaN1.000NaNNaN1.0001.0001.000
2023-12-12T06:15:56.794732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
MDA_CGR_NMWRT_DATEATCH_IMG_NM
MDA_CGR_NM1.0001.0001.000
WRT_DATE1.0001.0001.000
ATCH_IMG_NM1.0001.0001.000
2023-12-12T06:15:56.867701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
STD_YEARMDA_CGR_NMATCH_IMG_NMWRT_DATE
STD_YEAR1.0000.8321.0001.000
MDA_CGR_NM0.8321.0001.0001.000
ATCH_IMG_NM1.0001.0001.0001.000
WRT_DATE1.0001.0001.0001.000

Missing values

2023-12-12T06:15:53.689984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T06:15:53.799736image/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.
2023-12-12T06:15:53.907972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

MBN_MDA_SP_CDMDA_ART_ESSN_NOMDA_CGR_NMSTD_YEARART_SJ_CNART_CNATCH_IMG_NMJRNL_NMWRT_DATEUnnamed: 9
0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
1MBN4023123mbn000062020[속보] 김정은 "미국, 시간 끌수록 북한 위력 앞에 속수무책 당할 것"김정은 "미국, 시간 끌수록 북한 위력 앞에 속수무책 당할 것",,,,,,,,,<NA>20200101062259<NA>
2MBN4023124mbn000062020[속보] 북한 김정은 "머지않아 새 전략무기 목격하게 될 것"북한 김정은 "머지않아 새 전략무기 목격하게 될 것",,,,,,,,,<NA>20200101062328<NA>
3MBN4023125mbn000062020[속보] 북한 김정은 "억제력 강화, 미국 입장따라 상향조정…적대정책 철회까지 전략무기개발 계속진행"북한 김정은 "억제력 강화, 미국 입장따라 상향조정…적대정책 철회까지 전략무기개발 계속진행",,,,,,,,,<NA>20200101062900<NA>
4MBN4023130mbn000062020김도읍 자유한국당 의원 내년 총선 불출마 선언(이런 가운데) 자유한국당 김도읍 의원이 공수처법 저지 실패에 책임을 지고 내년 총선에 불출마하겠다고 선언했습니다.<NA><NA><NA><NA>
5김 의원은 "좌파독재의 도구인 공수처법이 통과됐다"며 "문재인 좌파독재 정권에 헌법이 무참히 짓밟히는 현장을 무기력하게 지켜볼 수밖에 없었다, 참담하다"고 토로했습니다.<NA><NA><NA><NA><NA><NA><NA><NA><NA>
6한국당 의원 가운데 공수처법 저지 실패에 대한 책임을 지겠다며 총선 불출마를 선언한 것은 김 의원이 처음입니다.<NA><NA>20200101071535<NA><NA><NA><NA><NA><NA>
7MBN4023131mbn000062020김정은 "미국, 시간 끌수록 북한 위력 앞에 속수무책 당할 것"<!------------ PHOTO_POS_0 ------------><NA><NA><NA><NA>
8김정은 북한 국무위원장은 "미국이 시간을 끌면 끌수록, 조미(북미)관계의 결산을 주저하면 할수록 예측할 수 없이 강대해지는 조선민주주의인민공화국의 위력 앞에 속수무책으로 당할 수밖에 없게 되어있으며 더욱더 막다른 처지에 빠져들게 되어있다"고 말했다고 조선중앙방송이 1일 보도했습니다.<NA><NA><NA><NA><NA><NA><NA><NA><NA>
9<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
MBN_MDA_SP_CDMDA_ART_ESSN_NOMDA_CGR_NMSTD_YEARART_SJ_CNART_CNATCH_IMG_NMJRNL_NMWRT_DATEUnnamed: 9
144<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
145신년사에서 협치를 외쳤던 문 의장은 결국 자신의 처지를 하소연하는 말로 한 해를 마무리해야 했습니다.<NA><NA><NA><NA><NA><NA><NA><NA><NA>
146<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
147▶ 인터뷰 : 문희상 / 국회의장 (지난달 27일)<NA><NA><NA><NA><NA><NA><NA><NA><NA>
148- "문희상이는 하루에도 열두 번씩 요새 죽습니다. 이미 죽었어요."<NA><NA><NA><NA><NA><NA><NA><NA><NA>
149<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
150MBN뉴스 조창훈입니다. [ chang@mbn.co.kr ]<NA><NA><NA><NA><NA><NA><NA><NA><NA>
151<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
152영상편집 : 송현주,,,,,,,,,조창훈20200101100425<NA><NA><NA><NA><NA><NA>
153<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

MBN_MDA_SP_CDMDA_ART_ESSN_NOMDA_CGR_NMSTD_YEARART_SJ_CNART_CNATCH_IMG_NMWRT_DATE# duplicates
1<NA><NA><NA><NA><NA><NA><NA><NA>55
0【 기자 】<NA><NA><NA><NA><NA><NA><NA>4