Overview

Dataset statistics

Number of variables5
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory46.4 B

Variable types

DateTime1
Categorical3
Text1

Dataset

Description샘플 데이터
Author한양대
URLhttps://bigdata-region.kr/#/dataset/e53083b0-45ba-44f7-9196-43a03a540f66

Alerts

CHNNL_MNTRM_CREAT_PD has constant value ""Constant
CHNNL_MNTRM_FQ_CO is highly overall correlated with CHNNL_MNTRM_SCOREHigh correlation
CHNNL_MNTRM_SCORE is highly overall correlated with CHNNL_MNTRM_FQ_COHigh correlation
CHNNL_MNTRM_EXTRC_MYNGS_NM has unique valuesUnique

Reproduction

Analysis started2023-12-10 14:24:53.713014
Analysis finished2023-12-10 14:24:54.006413
Duration0.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

CHNNL_MNTRM_CREAT_PD
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2020-09-01 00:00:00
Maximum2020-09-01 00:00:00
2023-12-10T23:24:54.045856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:24:54.128054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

CHNNL_MNTRM_CHNNL_ID
Categorical

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
20 
https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA
10 

Length

Max length56
Median length56
Mean length56
Min length56

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
2nd rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
3rd rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
4th rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw
5th rowhttps://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw

Common Values

ValueCountFrequency (%)
https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw 20
66.7%
https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA 10
33.3%

Length

2023-12-10T23:24:54.227415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:24:54.328433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
https://www.youtube.com/channel/uc-8r1d-kqrzy_7-eve_w9nw 20
66.7%
https://www.youtube.com/channel/uc-9oz6oofrznaouq48-lava 10
33.3%

CHNNL_MNTRM_EXTRC_MYNGS_NM
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T23:24:54.783570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3.5
Mean length2.0333333
Min length1

Characters and Unicode

Total characters61
Distinct characters36
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row도
2nd row물
3rd row수돗물
4th row수돗
5th row하수
ValueCountFrequency (%)
도 1
 
3.3%
물 1
 
3.3%
채널 1
 
3.3%
동영상 1
 
3.3%
레시피 1
 
3.3%
동 1
 
3.3%
부부 1
 
3.3%
다이어트 1
 
3.3%
요리 1
 
3.3%
램 1
 
3.3%
Other values (20) 20
66.7%
2023-12-10T23:24:55.131696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
수 5
 
8.2%
부 4
 
6.6%
상 4
 
6.6%
회 3
 
4.9%
협 3
 
4.9%
도 2
 
3.3%
의 2
 
3.3%
영 2
 
3.3%
동 2
 
3.3%
공 2
 
3.3%
Other values (26) 32
52.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 61
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
수 5
 
8.2%
부 4
 
6.6%
상 4
 
6.6%
회 3
 
4.9%
협 3
 
4.9%
도 2
 
3.3%
의 2
 
3.3%
영 2
 
3.3%
동 2
 
3.3%
공 2
 
3.3%
Other values (26) 32
52.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 61
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
수 5
 
8.2%
부 4
 
6.6%
상 4
 
6.6%
회 3
 
4.9%
협 3
 
4.9%
도 2
 
3.3%
의 2
 
3.3%
영 2
 
3.3%
동 2
 
3.3%
공 2
 
3.3%
Other values (26) 32
52.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 61
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
수 5
 
8.2%
부 4
 
6.6%
상 4
 
6.6%
회 3
 
4.9%
협 3
 
4.9%
도 2
 
3.3%
의 2
 
3.3%
영 2
 
3.3%
동 2
 
3.3%
공 2
 
3.3%
Other values (26) 32
52.5%

CHNNL_MNTRM_FQ_CO
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
4
9 
3
8 
2
7 
7
4 
5
2 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row7
2nd row7
3rd row7
4th row7
5th row5

Common Values

ValueCountFrequency (%)
4 9
30.0%
3 8
26.7%
2 7
23.3%
7 4
13.3%
5 2
 
6.7%

Length

2023-12-10T23:24:55.260517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:24:55.362507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
4 9
30.0%
3 8
26.7%
2 7
23.3%
7 4
13.3%
5 2
 
6.7%

CHNNL_MNTRM_SCORE
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
18
11 
20
7 
17
6 
19
4 
16
2 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20
2nd row20
3rd row20
4th row20
5th row19

Common Values

ValueCountFrequency (%)
18 11
36.7%
20 7
23.3%
17 6
20.0%
19 4
 
13.3%
16 2
 
6.7%

Length

2023-12-10T23:24:55.469642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:24:55.570283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
18 11
36.7%
20 7
23.3%
17 6
20.0%
19 4
 
13.3%
16 2
 
6.7%

Correlations

2023-12-10T23:24:55.652288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
CHNNL_MNTRM_CHNNL_IDCHNNL_MNTRM_EXTRC_MYNGS_NMCHNNL_MNTRM_FQ_COCHNNL_MNTRM_SCORE
CHNNL_MNTRM_CHNNL_ID1.0001.0000.3140.197
CHNNL_MNTRM_EXTRC_MYNGS_NM1.0001.0001.0001.000
CHNNL_MNTRM_FQ_CO0.3141.0001.0000.943
CHNNL_MNTRM_SCORE0.1971.0000.9431.000
2023-12-10T23:24:55.779603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
CHNNL_MNTRM_SCORECHNNL_MNTRM_CHNNL_IDCHNNL_MNTRM_FQ_CO
CHNNL_MNTRM_SCORE1.0000.2180.662
CHNNL_MNTRM_CHNNL_ID0.2181.0000.357
CHNNL_MNTRM_FQ_CO0.6620.3571.000
2023-12-10T23:24:55.883642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
CHNNL_MNTRM_CHNNL_IDCHNNL_MNTRM_FQ_COCHNNL_MNTRM_SCORE
CHNNL_MNTRM_CHNNL_ID1.0000.3570.218
CHNNL_MNTRM_FQ_CO0.3571.0000.662
CHNNL_MNTRM_SCORE0.2180.6621.000

Missing values

2023-12-10T23:24:53.882704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:24:53.969956image/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

CHNNL_MNTRM_CREAT_PDCHNNL_MNTRM_CHNNL_IDCHNNL_MNTRM_EXTRC_MYNGS_NMCHNNL_MNTRM_FQ_COCHNNL_MNTRM_SCORE
02020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw도720
12020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw물720
22020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw수돗물720
32020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw수돗720
42020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw하수519
52020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw홍보519
62020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw회418
72020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw환경418
82020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw협의418
92020-09-01https://www.youtube.com/channel/UC-8R1d-KQrZy_7-EvE_w9Nw상하수도418
CHNNL_MNTRM_CREAT_PDCHNNL_MNTRM_CHNNL_IDCHNNL_MNTRM_EXTRC_MYNGS_NMCHNNL_MNTRM_FQ_COCHNNL_MNTRM_SCORE
202020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA블420
212020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA램420
222020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA요리420
232020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA다이어트319
242020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA부부319
252020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA동218
262020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA레시피218
272020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA동영상218
282020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA채널218
292020-09-01https://www.youtube.com/channel/UC-9oz6OofrZnaOUQ48-LavA영상218