Overview

Dataset statistics

Number of variables5
Number of observations109
Missing cells56
Missing cells (%)10.3%
Duplicate rows1
Duplicate rows (%)0.9%
Total size in memory4.4 KiB
Average record size in memory41.2 B

Variable types

Categorical1
Text2
DateTime2

Dataset

Description제주특별자치도 내 언론사(신문,인터넷신문) 현황에 대한 데이터로 언론사 구분, 제호, 주소, 등록일자 등의 항목을 제공합니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15045462/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (0.9%) duplicate rowsDuplicates
제호 has 14 (12.8%) missing valuesMissing
주소 has 14 (12.8%) missing valuesMissing
등록일자 has 14 (12.8%) missing valuesMissing
데이터기준일자 has 14 (12.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 08:53:13.515010
Analysis finished2023-12-12 08:53:14.525200
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct6
Distinct (%)5.5%
Missing0
Missing (%)0.0%
Memory size1004.0 B
인터넷신문
80 
<NA>
14 
일반일간신문
 
6
일반주간신문
 
5
특수주간신문
 
3

Length

Max length10
Median length5
Mean length5.0458716
Min length4

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row일반일간신문
2nd row일반일간신문
3rd row일반일간신문
4th row일반일간신문
5th row일반일간신문

Common Values

ValueCountFrequency (%)
인터넷신문 80
73.4%
<NA> 14
 
12.8%
일반일간신문 6
 
5.5%
일반주간신문 5
 
4.6%
특수주간신문 3
 
2.8%
인터넷뉴스서비스사업 1
 
0.9%

Length

2023-12-12T17:53:14.614258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:53:14.752767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인터넷신문 80
73.4%
na 14
 
12.8%
일반일간신문 6
 
5.5%
일반주간신문 5
 
4.6%
특수주간신문 3
 
2.8%
인터넷뉴스서비스사업 1
 
0.9%

제호
Text

MISSING 

Distinct95
Distinct (%)100.0%
Missing14
Missing (%)12.8%
Memory size1004.0 B
2023-12-12T17:53:15.014079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length16
Mean length6.4315789
Min length4

Characters and Unicode

Total characters611
Distinct characters178
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique95 ?
Unique (%)100.0%

Sample

1st row뉴제주일보
2nd row제주일보
3rd row제주매일
4th row제주신문
5th row제민일보
ValueCountFrequency (%)
뉴스 3
 
2.8%
오코어 2
 
1.9%
제주연합방송 1
 
0.9%
아이엠피터뉴스 1
 
0.9%
뉴스n제주 1
 
0.9%
바다야뉴스 1
 
0.9%
라이브 1
 
0.9%
리맥스 1
 
0.9%
제주교통매거진 1
 
0.9%
제주팟닷컴 1
 
0.9%
Other values (94) 94
87.9%
2023-12-12T17:53:15.451353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
제 60
 
9.8%
주 58
 
9.5%
스 31
 
5.1%
뉴 25
 
4.1%
이 17
 
2.8%
문 14
 
2.3%
신 13
 
2.1%
12
 
2.0%
라 10
 
1.6%
리 10
 
1.6%
Other values (168) 361
59.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 529
86.6%
Lowercase Letter 42
 
6.9%
Uppercase Letter 21
 
3.4%
Space Separator 12
 
2.0%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%
Decimal Number 2
 
0.3%
Other Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 60
 
11.3%
주 58
 
11.0%
스 31
 
5.9%
뉴 25
 
4.7%
이 17
 
3.2%
문 14
 
2.6%
신 13
 
2.5%
라 10
 
1.9%
리 10
 
1.9%
일 10
 
1.9%
Other values (134) 281
53.1%
Lowercase Letter
ValueCountFrequency (%)
n 8
19.0%
e 6
14.3%
a 5
11.9%
t 4
9.5%
i 4
9.5%
o 3
 
7.1%
d 2
 
4.8%
b 2
 
4.8%
k 2
 
4.8%
y 1
 
2.4%
Other values (5) 5
11.9%
Uppercase Letter
ValueCountFrequency (%)
E 3
14.3%
I 3
14.3%
W 2
9.5%
N 2
9.5%
J 2
9.5%
V 2
9.5%
S 1
 
4.8%
D 1
 
4.8%
B 1
 
4.8%
T 1
 
4.8%
Other values (3) 3
14.3%
Decimal Number
ValueCountFrequency (%)
4 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 530
86.7%
Latin 63
 
10.3%
Common 18
 
2.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 60
 
11.3%
주 58
 
10.9%
스 31
 
5.8%
뉴 25
 
4.7%
이 17
 
3.2%
문 14
 
2.6%
신 13
 
2.5%
라 10
 
1.9%
리 10
 
1.9%
일 10
 
1.9%
Other values (135) 282
53.2%
Latin
ValueCountFrequency (%)
n 8
 
12.7%
e 6
 
9.5%
a 5
 
7.9%
t 4
 
6.3%
i 4
 
6.3%
E 3
 
4.8%
I 3
 
4.8%
o 3
 
4.8%
d 2
 
3.2%
W 2
 
3.2%
Other values (18) 23
36.5%
Common
ValueCountFrequency (%)
12
66.7%
) 2
 
11.1%
( 2
 
11.1%
4 1
 
5.6%
2 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 529
86.6%
ASCII 81
 
13.3%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
제 60
 
11.3%
주 58
 
11.0%
스 31
 
5.9%
뉴 25
 
4.7%
이 17
 
3.2%
문 14
 
2.6%
신 13
 
2.5%
라 10
 
1.9%
리 10
 
1.9%
일 10
 
1.9%
Other values (134) 281
53.1%
ASCII
ValueCountFrequency (%)
12
 
14.8%
n 8
 
9.9%
e 6
 
7.4%
a 5
 
6.2%
t 4
 
4.9%
i 4
 
4.9%
E 3
 
3.7%
I 3
 
3.7%
o 3
 
3.7%
d 2
 
2.5%
Other values (23) 31
38.3%
None
ValueCountFrequency (%)
㈜ 1
100.0%

주소
Text

MISSING 

Distinct89
Distinct (%)93.7%
Missing14
Missing (%)12.8%
Memory size1004.0 B
2023-12-12T17:53:15.827759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length25
Mean length20.463158
Min length17

Characters and Unicode

Total characters1944
Distinct characters97
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique83 ?
Unique (%)87.4%

Sample

1st row제주특별자치도 제주시 서사로 25
2nd row제주특별자치도 제주시 태성로3길 4
3rd row제주특별자치도 제주시 월광로 37
4th row제주특별자치도 제주시 도공로 9-1
5th row제주특별자치도 제주시 애월읍 평화로 2700
ValueCountFrequency (%)
제주특별자치도 95
24.2%
제주시 83
21.2%
서귀포시 12
 
3.1%
중앙로 6
 
1.5%
도령로 6
 
1.5%
애월읍 5
 
1.3%
첨단로 4
 
1.0%
서사로 4
 
1.0%
1 3
 
0.8%
일주서로 3
 
0.8%
Other values (149) 171
43.6%
2023-12-12T17:53:16.360898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
297
15.3%
주 182
 
9.4%
제 179
 
9.2%
도 109
 
5.6%
자 96
 
4.9%
별 95
 
4.9%
치 95
 
4.9%
특 95
 
4.9%
시 95
 
4.9%
로 75
 
3.9%
Other values (87) 626
32.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1332
68.5%
Space Separator 297
 
15.3%
Decimal Number 287
 
14.8%
Dash Punctuation 28
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 182
13.7%
제 179
13.4%
도 109
 
8.2%
자 96
 
7.2%
별 95
 
7.1%
치 95
 
7.1%
특 95
 
7.1%
시 95
 
7.1%
로 75
 
5.6%
길 33
 
2.5%
Other values (75) 278
20.9%
Decimal Number
ValueCountFrequency (%)
1 64
22.3%
3 41
14.3%
2 34
11.8%
5 31
10.8%
4 26
9.1%
6 23
 
8.0%
9 18
 
6.3%
7 18
 
6.3%
0 16
 
5.6%
8 16
 
5.6%
Space Separator
ValueCountFrequency (%)
297
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1332
68.5%
Common 612
31.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 182
13.7%
제 179
13.4%
도 109
 
8.2%
자 96
 
7.2%
별 95
 
7.1%
치 95
 
7.1%
특 95
 
7.1%
시 95
 
7.1%
로 75
 
5.6%
길 33
 
2.5%
Other values (75) 278
20.9%
Common
ValueCountFrequency (%)
297
48.5%
1 64
 
10.5%
3 41
 
6.7%
2 34
 
5.6%
5 31
 
5.1%
- 28
 
4.6%
4 26
 
4.2%
6 23
 
3.8%
9 18
 
2.9%
7 18
 
2.9%
Other values (2) 32
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1332
68.5%
ASCII 612
31.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
297
48.5%
1 64
 
10.5%
3 41
 
6.7%
2 34
 
5.6%
5 31
 
5.1%
- 28
 
4.6%
4 26
 
4.2%
6 23
 
3.8%
9 18
 
2.9%
7 18
 
2.9%
Other values (2) 32
 
5.2%
Hangul
ValueCountFrequency (%)
주 182
13.7%
제 179
13.4%
도 109
 
8.2%
자 96
 
7.2%
별 95
 
7.1%
치 95
 
7.1%
특 95
 
7.1%
시 95
 
7.1%
로 75
 
5.6%
길 33
 
2.5%
Other values (75) 278
20.9%

등록일자
Date

MISSING 

Distinct89
Distinct (%)93.7%
Missing14
Missing (%)12.8%
Memory size1004.0 B
Minimum1988-12-05 00:00:00
Maximum2023-09-04 00:00:00
2023-12-12T17:53:16.511951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:53:16.655463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)1.1%
Missing14
Missing (%)12.8%
Memory size1004.0 B
Minimum2023-10-05 00:00:00
Maximum2023-10-05 00:00:00
2023-12-12T17:53:16.820975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:53:16.945398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T17:53:17.059901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분제호주소등록일자
구분1.0001.0000.8921.000
제호1.0001.0001.0001.000
주소0.8921.0001.0000.986
등록일자1.0001.0000.9861.000

Missing values

2023-12-12T17:53:14.195216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:53:14.313733image/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-12T17:53:14.439944image/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

구분제호주소등록일자데이터기준일자
0일반일간신문뉴제주일보제주특별자치도 제주시 서사로 252020-07-162023-10-05
1일반일간신문제주일보제주특별자치도 제주시 태성로3길 42013-09-242023-10-05
2일반일간신문제주매일제주특별자치도 제주시 월광로 372012-05-092023-10-05
3일반일간신문제주신문제주특별자치도 제주시 도공로 9-12007-02-122023-10-05
4일반일간신문제민일보제주특별자치도 제주시 애월읍 평화로 27001990-05-302023-10-05
5일반일간신문한라일보제주특별자치도 제주시 서사로 1541988-12-052023-10-05
6일반주간신문제주주간제주특별자치도 제주시 서광로 36-12013-10-282023-10-05
7일반주간신문제주광장제주특별자치도 제주시 서사로 982012-11-192023-10-05
8일반주간신문제주위클리제주특별자치도 제주시 서광로 36-12009-01-282023-10-05
9일반주간신문제주관광신문제주특별자치도 제주시 일주서로 78102003-08-212023-10-05
구분제호주소등록일자데이터기준일자
99<NA><NA><NA><NA><NA>
100<NA><NA><NA><NA><NA>
101<NA><NA><NA><NA><NA>
102<NA><NA><NA><NA><NA>
103<NA><NA><NA><NA><NA>
104<NA><NA><NA><NA><NA>
105<NA><NA><NA><NA><NA>
106<NA><NA><NA><NA><NA>
107<NA><NA><NA><NA><NA>
108<NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

구분제호주소등록일자데이터기준일자# duplicates
0<NA><NA><NA><NA><NA>14