Overview

Dataset statistics

Number of variables4
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1023.0 B
Average record size in memory37.9 B

Variable types

Numeric1
Text2
DateTime1

Dataset

Description경상북도 구미시의 인터넷방송홈페이지DB 내에 동영상정보 데이터로 게시물번호, 영상URL, 콘텐츠제목 등을 제공하고 있습니다.
Author경상북도 구미시
URLhttps://www.data.go.kr/data/15039958/fileData.do

Alerts

연번 has unique valuesUnique
콘텐츠제목 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:33:44.420156
Analysis finished2023-12-12 12:33:45.174275
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14
Minimum1
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-12T21:33:45.224848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.3
Q17.5
median14
Q320.5
95-th percentile25.7
Maximum27
Range26
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.9372539
Coefficient of variation (CV)0.56694671
Kurtosis-1.2
Mean14
Median Absolute Deviation (MAD)7
Skewness0
Sum378
Variance63
MonotonicityStrictly increasing
2023-12-12T21:33:45.330127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1 1
 
3.7%
2 1
 
3.7%
27 1
 
3.7%
26 1
 
3.7%
25 1
 
3.7%
24 1
 
3.7%
23 1
 
3.7%
22 1
 
3.7%
21 1
 
3.7%
20 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
1 1
3.7%
2 1
3.7%
3 1
3.7%
4 1
3.7%
5 1
3.7%
6 1
3.7%
7 1
3.7%
8 1
3.7%
9 1
3.7%
10 1
3.7%
ValueCountFrequency (%)
27 1
3.7%
26 1
3.7%
25 1
3.7%
24 1
3.7%
23 1
3.7%
22 1
3.7%
21 1
3.7%
20 1
3.7%
19 1
3.7%
18 1
3.7%

콘텐츠제목
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-12T21:33:45.513392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length19
Mean length16
Min length8

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row구미시 도시브랜드 홍보영상(30초ver)
2nd row구미시 도시브랜드 홍보영상
3rd row꿀벌응애 방제약품 선택 방법 및 사용요령1
4th row꿀벌응애 방제약품 선택 방법 및 사용요령2
5th row감사원 적극행정 홍보영상
ValueCountFrequency (%)
홍보영상 6
 
7.6%
2021 4
 
5.1%
구미시 3
 
3.8%
방법 2
 
2.5%
시정 2
 
2.5%
및 2
 
2.5%
도시브랜드 2
 
2.5%
선택 2
 
2.5%
방제약품 2
 
2.5%
꿀벌응애 2
 
2.5%
Other values (50) 52
65.8%
2023-12-12T21:33:45.818403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
52
 
12.0%
상 17
 
3.9%
시 15
 
3.5%
영 15
 
3.5%
미 13
 
3.0%
구 12
 
2.8%
2 12
 
2.8%
기 9
 
2.1%
정 9
 
2.1%
홍 9
 
2.1%
Other values (124) 269
62.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 325
75.2%
Space Separator 52
 
12.0%
Decimal Number 31
 
7.2%
Connector Punctuation 6
 
1.4%
Close Punctuation 6
 
1.4%
Open Punctuation 6
 
1.4%
Uppercase Letter 3
 
0.7%
Lowercase Letter 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 17
 
5.2%
시 15
 
4.6%
영 15
 
4.6%
미 13
 
4.0%
구 12
 
3.7%
기 9
 
2.8%
정 9
 
2.8%
홍 9
 
2.8%
보 9
 
2.8%
편 8
 
2.5%
Other values (107) 209
64.3%
Decimal Number
ValueCountFrequency (%)
2 12
38.7%
0 8
25.8%
1 6
19.4%
3 2
 
6.5%
9 1
 
3.2%
5 1
 
3.2%
7 1
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
F 1
33.3%
A 1
33.3%
S 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
r 1
33.3%
e 1
33.3%
v 1
33.3%
Space Separator
ValueCountFrequency (%)
52
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 325
75.2%
Common 101
 
23.4%
Latin 6
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 17
 
5.2%
시 15
 
4.6%
영 15
 
4.6%
미 13
 
4.0%
구 12
 
3.7%
기 9
 
2.8%
정 9
 
2.8%
홍 9
 
2.8%
보 9
 
2.8%
편 8
 
2.5%
Other values (107) 209
64.3%
Common
ValueCountFrequency (%)
52
51.5%
2 12
 
11.9%
0 8
 
7.9%
_ 6
 
5.9%
) 6
 
5.9%
( 6
 
5.9%
1 6
 
5.9%
3 2
 
2.0%
9 1
 
1.0%
5 1
 
1.0%
Latin
ValueCountFrequency (%)
F 1
16.7%
r 1
16.7%
e 1
16.7%
v 1
16.7%
A 1
16.7%
S 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 325
75.2%
ASCII 107
 
24.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
52
48.6%
2 12
 
11.2%
0 8
 
7.5%
_ 6
 
5.6%
) 6
 
5.6%
( 6
 
5.6%
1 6
 
5.6%
3 2
 
1.9%
9 1
 
0.9%
5 1
 
0.9%
Other values (7) 7
 
6.5%
Hangul
ValueCountFrequency (%)
상 17
 
5.2%
시 15
 
4.6%
영 15
 
4.6%
미 13
 
4.0%
구 12
 
3.7%
기 9
 
2.8%
정 9
 
2.8%
홍 9
 
2.8%
보 9
 
2.8%
편 8
 
2.5%
Other values (107) 209
64.3%

영상(URL)
Text

Distinct26
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-12T21:33:46.095783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length59
Mean length59
Min length59

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)92.6%

Sample

1st rowhttps://www.gumi.go.kr/video/222/BBS_202308251023270330.mp4
2nd rowhttps://www.gumi.go.kr/video/222/BBS_202308140619321810.mp4
3rd rowhttps://www.gumi.go.kr/video/222/BBS_202305190438475020.mp4
4th rowhttps://www.gumi.go.kr/video/222/BBS_202305190439346860.mp4
5th rowhttps://www.gumi.go.kr/video/222/BBS_202304190238430880.mp4
ValueCountFrequency (%)
https://www.gumi.go.kr/video/222/bbs_202304120308446290.mp4 2
 
7.4%
https://www.gumi.go.kr/video/222/bbs_202308251023270330.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202012200415499870.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_201906251152420990.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202001070547521031.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202001070611288901.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202001070214155590.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202001070550563651.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202001070550021741.mp4 1
 
3.7%
https://www.gumi.go.kr/video/222/bbs_202001070549079001.mp4 1
 
3.7%
Other values (16) 16
59.3%
2023-12-12T21:33:46.576222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 171
 
10.7%
0 145
 
9.1%
/ 135
 
8.5%
. 108
 
6.8%
w 81
 
5.1%
4 63
 
4.0%
1 63
 
4.0%
g 54
 
3.4%
B 54
 
3.4%
m 54
 
3.4%
Other values (21) 665
41.7%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 621
39.0%
Decimal Number 594
37.3%
Other Punctuation 270
16.9%
Uppercase Letter 81
 
5.1%
Connector Punctuation 27
 
1.7%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
w 81
13.0%
g 54
 
8.7%
m 54
 
8.7%
i 54
 
8.7%
o 54
 
8.7%
p 54
 
8.7%
t 54
 
8.7%
h 27
 
4.3%
v 27
 
4.3%
e 27
 
4.3%
Other values (5) 135
21.7%
Decimal Number
ValueCountFrequency (%)
2 171
28.8%
0 145
24.4%
4 63
 
10.6%
1 63
 
10.6%
3 37
 
6.2%
5 30
 
5.1%
9 26
 
4.4%
7 25
 
4.2%
8 21
 
3.5%
6 13
 
2.2%
Other Punctuation
ValueCountFrequency (%)
/ 135
50.0%
. 108
40.0%
: 27
 
10.0%
Uppercase Letter
ValueCountFrequency (%)
B 54
66.7%
S 27
33.3%
Connector Punctuation
ValueCountFrequency (%)
_ 27
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 891
55.9%
Latin 702
44.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
w 81
11.5%
g 54
 
7.7%
B 54
 
7.7%
m 54
 
7.7%
i 54
 
7.7%
o 54
 
7.7%
p 54
 
7.7%
t 54
 
7.7%
S 27
 
3.8%
h 27
 
3.8%
Other values (7) 189
26.9%
Common
ValueCountFrequency (%)
2 171
19.2%
0 145
16.3%
/ 135
15.2%
. 108
12.1%
4 63
 
7.1%
1 63
 
7.1%
3 37
 
4.2%
5 30
 
3.4%
_ 27
 
3.0%
: 27
 
3.0%
Other values (4) 85
9.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1593
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 171
 
10.7%
0 145
 
9.1%
/ 135
 
8.5%
. 108
 
6.8%
w 81
 
5.1%
4 63
 
4.0%
1 63
 
4.0%
g 54
 
3.4%
B 54
 
3.4%
m 54
 
3.4%
Other values (21) 665
41.7%

등록일자
Date

Distinct16
Distinct (%)59.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2019-04-30 00:00:00
Maximum2023-08-25 00:00:00
2023-12-12T21:33:46.731316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:33:46.926179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

Interactions

2023-12-12T21:33:44.632635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:33:47.049034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번콘텐츠제목영상(URL)등록일자
연번1.0001.0000.9000.811
콘텐츠제목1.0001.0001.0001.000
영상(URL)0.9001.0001.0000.741
등록일자0.8111.0000.7411.000

Missing values

2023-12-12T21:33:45.051419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:33:45.143910image/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

연번콘텐츠제목영상(URL)등록일자
01구미시 도시브랜드 홍보영상(30초ver)https://www.gumi.go.kr/video/222/BBS_202308251023270330.mp42023-08-25
12구미시 도시브랜드 홍보영상https://www.gumi.go.kr/video/222/BBS_202308140619321810.mp42023-08-14
23꿀벌응애 방제약품 선택 방법 및 사용요령1https://www.gumi.go.kr/video/222/BBS_202305190438475020.mp42023-05-19
34꿀벌응애 방제약품 선택 방법 및 사용요령2https://www.gumi.go.kr/video/222/BBS_202305190439346860.mp42023-05-19
45감사원 적극행정 홍보영상https://www.gumi.go.kr/video/222/BBS_202304190238430880.mp42023-04-19
56아프리카돼지열병 대비 농장방역수칙https://www.gumi.go.kr/video/222/BBS_202304120308446290.mp42023-04-12
67본인서명확인제도 홍보동영상https://www.gumi.go.kr/video/222/BBS_202206301032448230.mp42022-06-30
78아프리카돼지열병(ASF) 발생양상https://www.gumi.go.kr/video/222/BBS_202304120308446290.mp42022-02-25
89마늘 경작 신고https://www.gumi.go.kr/video/222/BBS_202111120123296730.mp42021-11-12
9102021 시정기획영상물(구미사랑상품권편)https://www.gumi.go.kr/video/222/BBS_202107190412157410.mp42021-07-19
연번콘텐츠제목영상(URL)등록일자
1718내 손으로 만드는 행복한 마을 내 삶을 바꾸는 주민자치https://www.gumi.go.kr/video/222/BBS_202004131127550920.mp42020-04-13
1819시정 기획 영상_무자막버전https://www.gumi.go.kr/video/222/BBS_202001070719307930.mp42020-01-07
1920행복구미운동_시민편https://www.gumi.go.kr/video/222/BBS_202001070549079001.mp42020-01-07
2021행복구미운동_기업편https://www.gumi.go.kr/video/222/BBS_202001070550021741.mp42020-01-07
2122행복구미운동_기관편https://www.gumi.go.kr/video/222/BBS_202001070550563651.mp42020-01-07
2223농촌융복합산업을 선도하는 도농복합도시 구미https://www.gumi.go.kr/video/222/BBS_202001070214155590.mp42020-01-07
2324구미시 우수 농특산물https://www.gumi.go.kr/video/222/BBS_202001070611288901.mp42020-01-07
2425시정 기획 영상_자막버전https://www.gumi.go.kr/video/222/BBS_202001070547521031.mp42020-01-03
25262019 홍보영상https://www.gumi.go.kr/video/222/BBS_201906251152420990.mp42019-06-25
2627구미빵 베이쿠미 홍보영상https://www.gumi.go.kr/video/222/BBS_201904300205128320.mp42019-04-30