Overview

Dataset statistics

Number of variables5
Number of observations61
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory44.1 B

Variable types

Numeric2
Text2
DateTime1

Dataset

Description올림픽공원 스포츠센터에서 운영하는 온라인 깅습 동영상입니다.동영상 강습 제목, 내용, 등록일, 조회수, 링크주소 데이터
Author한국체육산업개발주식회사
URLhttps://www.data.go.kr/data/15119388/fileData.do

Alerts

순번 is highly overall correlated with 조회수High correlation
조회수 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique
조회수 has unique valuesUnique
링크주소 has unique valuesUnique

Reproduction

Analysis started2024-03-14 14:09:16.057843
Analysis finished2024-03-14 14:09:17.468234
Duration1.41 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean271.39344
Minimum5
Maximum346
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size677.0 B
2024-03-14T23:09:17.598784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile219
Q1238
median268
Q3308
95-th percentile343
Maximum346
Range341
Interquartile range (IQR)70

Descriptive statistics

Standard deviation53.159909
Coefficient of variation (CV)0.19587765
Kurtosis9.1988292
Mean271.39344
Median Absolute Deviation (MAD)36
Skewness-1.9030423
Sum16555
Variance2825.976
MonotonicityStrictly decreasing
2024-03-14T23:09:18.024224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
346 1
 
1.6%
237 1
 
1.6%
263 1
 
1.6%
262 1
 
1.6%
261 1
 
1.6%
260 1
 
1.6%
259 1
 
1.6%
258 1
 
1.6%
256 1
 
1.6%
254 1
 
1.6%
Other values (51) 51
83.6%
ValueCountFrequency (%)
5 1
1.6%
216 1
1.6%
218 1
1.6%
219 1
1.6%
220 1
1.6%
221 1
1.6%
222 1
1.6%
225 1
1.6%
228 1
1.6%
229 1
1.6%
ValueCountFrequency (%)
346 1
1.6%
345 1
1.6%
344 1
1.6%
343 1
1.6%
342 1
1.6%
341 1
1.6%
340 1
1.6%
339 1
1.6%
323 1
1.6%
322 1
1.6%

동영상제목
Text

Distinct60
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size616.0 B
2024-03-14T23:09:19.075330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length28
Mean length12.770492
Min length2

Characters and Unicode

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

Unique

Unique59 ?
Unique (%)96.7%

Sample

1st row프리 다이빙
2nd row어르신 아카데미
3rd row바디체인지
4th rowTRX
5th row스피닝
ValueCountFrequency (%)
러닝크루 5
 
3.2%
평영 4
 
2.6%
stroke 4
 
2.6%
올림픽수영장 4
 
2.6%
올림픽공원 3
 
1.9%
수영이지 3
 
1.9%
라인댄스 3
 
1.9%
올팍하면 3
 
1.9%
점핑트램폴린 3
 
1.9%
실시간 3
 
1.9%
Other values (109) 121
77.6%
2024-03-14T23:09:20.283470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
97
 
12.5%
영 23
 
3.0%
스 18
 
2.3%
e 16
 
2.1%
수 15
 
1.9%
라 15
 
1.9%
이 14
 
1.8%
) 13
 
1.7%
( 13
 
1.7%
r 12
 
1.5%
Other values (199) 543
69.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 435
55.8%
Lowercase Letter 127
 
16.3%
Space Separator 97
 
12.5%
Uppercase Letter 60
 
7.7%
Other Punctuation 17
 
2.2%
Close Punctuation 16
 
2.1%
Open Punctuation 16
 
2.1%
Decimal Number 8
 
1.0%
Dash Punctuation 2
 
0.3%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
영 23
 
5.3%
스 18
 
4.1%
수 15
 
3.4%
라 15
 
3.4%
이 14
 
3.2%
올 12
 
2.8%
시 11
 
2.5%
인 10
 
2.3%
실 9
 
2.1%
픽 8
 
1.8%
Other values (140) 300
69.0%
Lowercase Letter
ValueCountFrequency (%)
e 16
12.6%
r 12
 
9.4%
t 11
 
8.7%
n 10
 
7.9%
s 10
 
7.9%
o 9
 
7.1%
a 8
 
6.3%
i 7
 
5.5%
l 6
 
4.7%
k 6
 
4.7%
Other values (11) 32
25.2%
Uppercase Letter
ValueCountFrequency (%)
P 9
15.0%
E 6
10.0%
T 6
10.0%
R 6
10.0%
K 4
 
6.7%
O 4
 
6.7%
M 4
 
6.7%
S 4
 
6.7%
L 3
 
5.0%
Y 2
 
3.3%
Other values (10) 12
20.0%
Other Punctuation
ValueCountFrequency (%)
? 6
35.3%
! 5
29.4%
, 3
17.6%
/ 2
 
11.8%
& 1
 
5.9%
Decimal Number
ValueCountFrequency (%)
2 4
50.0%
1 2
25.0%
0 1
 
12.5%
4 1
 
12.5%
Close Punctuation
ValueCountFrequency (%)
) 13
81.2%
] 2
 
12.5%
】 1
 
6.2%
Open Punctuation
ValueCountFrequency (%)
( 13
81.2%
[ 2
 
12.5%
【 1
 
6.2%
Space Separator
ValueCountFrequency (%)
97
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 435
55.8%
Latin 187
24.0%
Common 157
 
20.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
영 23
 
5.3%
스 18
 
4.1%
수 15
 
3.4%
라 15
 
3.4%
이 14
 
3.2%
올 12
 
2.8%
시 11
 
2.5%
인 10
 
2.3%
실 9
 
2.1%
픽 8
 
1.8%
Other values (140) 300
69.0%
Latin
ValueCountFrequency (%)
e 16
 
8.6%
r 12
 
6.4%
t 11
 
5.9%
n 10
 
5.3%
s 10
 
5.3%
P 9
 
4.8%
o 9
 
4.8%
a 8
 
4.3%
i 7
 
3.7%
l 6
 
3.2%
Other values (31) 89
47.6%
Common
ValueCountFrequency (%)
97
61.8%
) 13
 
8.3%
( 13
 
8.3%
? 6
 
3.8%
! 5
 
3.2%
2 4
 
2.5%
, 3
 
1.9%
/ 2
 
1.3%
- 2
 
1.3%
] 2
 
1.3%
Other values (8) 10
 
6.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 435
55.8%
ASCII 342
43.9%
None 2
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
97
28.4%
e 16
 
4.7%
) 13
 
3.8%
( 13
 
3.8%
r 12
 
3.5%
t 11
 
3.2%
n 10
 
2.9%
s 10
 
2.9%
P 9
 
2.6%
o 9
 
2.6%
Other values (47) 142
41.5%
Hangul
ValueCountFrequency (%)
영 23
 
5.3%
스 18
 
4.1%
수 15
 
3.4%
라 15
 
3.4%
이 14
 
3.2%
올 12
 
2.8%
시 11
 
2.5%
인 10
 
2.3%
실 9
 
2.1%
픽 8
 
1.8%
Other values (140) 300
69.0%
None
ValueCountFrequency (%)
】 1
50.0%
【 1
50.0%

등록일
Date

Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size616.0 B
Minimum2022-05-31 00:00:00
Maximum2022-06-29 00:00:00
2024-03-14T23:09:20.476587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:09:20.657842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

조회수
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean939.47541
Minimum35
Maximum3503
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size677.0 B
2024-03-14T23:09:20.876685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35
5-th percentile84
Q1293
median583
Q31441
95-th percentile2706
Maximum3503
Range3468
Interquartile range (IQR)1148

Descriptive statistics

Standard deviation893.8433
Coefficient of variation (CV)0.9514281
Kurtosis1.0885659
Mean939.47541
Median Absolute Deviation (MAD)309
Skewness1.3565169
Sum57308
Variance798955.85
MonotonicityNot monotonic
2024-03-14T23:09:21.178838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3203 1
 
1.6%
201 1
 
1.6%
887 1
 
1.6%
2147 1
 
1.6%
1929 1
 
1.6%
3491 1
 
1.6%
881 1
 
1.6%
850 1
 
1.6%
2022 1
 
1.6%
425 1
 
1.6%
Other values (51) 51
83.6%
ValueCountFrequency (%)
35 1
1.6%
57 1
1.6%
69 1
1.6%
84 1
1.6%
108 1
1.6%
201 1
1.6%
211 1
1.6%
231 1
1.6%
253 1
1.6%
256 1
1.6%
ValueCountFrequency (%)
3503 1
1.6%
3491 1
1.6%
3203 1
1.6%
2706 1
1.6%
2535 1
1.6%
2353 1
1.6%
2147 1
1.6%
2022 1
1.6%
2019 1
1.6%
1994 1
1.6%

링크주소
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size616.0 B
2024-03-14T23:09:22.015986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length116
Median length116
Mean length115.96721
Min length114

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st rowhttps://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=346&siteCg=OSC1001&sportCg=OSC2001
2nd rowhttps://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=345&siteCg=OSC1001&sportCg=OSC2034
3rd rowhttps://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=344&siteCg=OSC1001&sportCg=OSC2010
4th rowhttps://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=343&siteCg=OSC1001&sportCg=OSC2010
5th rowhttps://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=342&siteCg=OSC1001&sportCg=OSC2006
ValueCountFrequency (%)
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=346&sitecg=osc1001&sportcg=osc2001 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=267&sitecg=osc1001&sportcg=osc2010 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=263&sitecg=osc1001&sportcg=osc2057 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=262&sitecg=osc1001&sportcg=osc2024 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=261&sitecg=osc1001&sportcg=osc2022 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=260&sitecg=osc1001&sportcg=osc2001 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=259&sitecg=osc1001&sportcg=osc2056 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=258&sitecg=osc1001&sportcg=osc2015 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=256&sitecg=osc1001&sportcg=osc2055 1
 
1.6%
https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listno=254&sitecg=osc1001&sportcg=osc2053 1
 
1.6%
Other values (51) 51
83.6%
2024-03-14T23:09:23.122147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 779
 
11.0%
s 488
 
6.9%
o 488
 
6.9%
t 427
 
6.0%
i 366
 
5.2%
= 305
 
4.3%
p 305
 
4.3%
e 305
 
4.3%
r 244
 
3.4%
& 244
 
3.4%
Other values (30) 3123
44.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 4026
56.9%
Decimal Number 1340
 
18.9%
Other Punctuation 793
 
11.2%
Uppercase Letter 549
 
7.8%
Math Symbol 305
 
4.3%
Connector Punctuation 61
 
0.9%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
s 488
12.1%
o 488
12.1%
t 427
10.6%
i 366
9.1%
p 305
 
7.6%
e 305
 
7.6%
r 244
 
6.1%
w 244
 
6.1%
n 183
 
4.5%
c 122
 
3.0%
Other values (9) 854
21.2%
Decimal Number
ValueCountFrequency (%)
0 779
58.1%
2 184
 
13.7%
1 165
 
12.3%
6 77
 
5.7%
3 39
 
2.9%
5 33
 
2.5%
4 27
 
2.0%
8 15
 
1.1%
7 11
 
0.8%
9 10
 
0.7%
Other Punctuation
ValueCountFrequency (%)
& 244
30.8%
/ 244
30.8%
. 183
23.1%
? 61
 
7.7%
: 61
 
7.7%
Uppercase Letter
ValueCountFrequency (%)
C 244
44.4%
S 122
22.2%
O 122
22.2%
N 61
 
11.1%
Math Symbol
ValueCountFrequency (%)
= 305
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 61
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 4575
64.7%
Common 2499
35.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
s 488
 
10.7%
o 488
 
10.7%
t 427
 
9.3%
i 366
 
8.0%
p 305
 
6.7%
e 305
 
6.7%
r 244
 
5.3%
C 244
 
5.3%
w 244
 
5.3%
n 183
 
4.0%
Other values (13) 1281
28.0%
Common
ValueCountFrequency (%)
0 779
31.2%
= 305
 
12.2%
& 244
 
9.8%
/ 244
 
9.8%
2 184
 
7.4%
. 183
 
7.3%
1 165
 
6.6%
6 77
 
3.1%
_ 61
 
2.4%
? 61
 
2.4%
Other values (7) 196
 
7.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7074
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 779
 
11.0%
s 488
 
6.9%
o 488
 
6.9%
t 427
 
6.0%
i 366
 
5.2%
= 305
 
4.3%
p 305
 
4.3%
e 305
 
4.3%
r 244
 
3.4%
& 244
 
3.4%
Other values (30) 3123
44.1%

Interactions

2024-03-14T23:09:16.877880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:09:16.419798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:09:17.036262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:09:16.718665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T23:09:23.269976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번동영상제목등록일조회수링크주소
순번1.0000.9410.8720.6101.000
동영상제목0.9411.0000.9050.9301.000
등록일0.8720.9051.0000.6511.000
조회수0.6100.9300.6511.0001.000
링크주소1.0001.0001.0001.0001.000
2024-03-14T23:09:23.433225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번조회수
순번1.0000.673
조회수0.6731.000

Missing values

2024-03-14T23:09:17.238011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T23:09:17.402056image/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

순번동영상제목등록일조회수링크주소
0346프리 다이빙2022-06-293203https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=346&siteCg=OSC1001&sportCg=OSC2001
1345어르신 아카데미2022-06-291305https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=345&siteCg=OSC1001&sportCg=OSC2034
2344바디체인지2022-06-291475https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=344&siteCg=OSC1001&sportCg=OSC2010
3343TRX2022-06-291855https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=343&siteCg=OSC1001&sportCg=OSC2010
4342스피닝2022-06-291441https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=342&siteCg=OSC1001&sportCg=OSC2006
5341온라인PT2022-06-291074https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=341&siteCg=OSC1001&sportCg=OSC2004
6340접영2022-06-292353https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=340&siteCg=OSC1001&sportCg=OSC2001
7339평영2022-06-291713https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=339&siteCg=OSC1001&sportCg=OSC2001
8323배영 + 잠영(돌핀, 평영)2022-06-291151https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=323&siteCg=OSC1001&sportCg=OSC2001
9322자유형 1인칭 시점 ASMR2022-06-291450https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=322&siteCg=OSC1001&sportCg=OSC2001
순번동영상제목등록일조회수링크주소
51229올림픽수영장 올팍하면 수영이지 1탄2022-06-2869https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=229&siteCg=OSC1001&sportCg=OSC2001
52228올림픽수영장 온라인 수강신청 방법2022-06-28311https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=228&siteCg=OSC1001&sportCg=OSC2048
53225WE SUPPORT K-POP, OLYMPICPARK2022-06-28211https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=225&siteCg=OSC1001&sportCg=OSC2048
54222올림픽공원 러닝크루 강습 스포영상!?2022-06-28284https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=222&siteCg=OSC1001&sportCg=OSC2005
55221올림픽공원 러닝크루 접수 시작!2022-06-28321https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=221&siteCg=OSC1001&sportCg=OSC2005
56220올림픽공원 러닝크루2022-06-28326https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=220&siteCg=OSC1001&sportCg=OSC2005
57219올림픽수영장 [실시간라이브 접수시작!]2022-06-28283https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=219&siteCg=OSC1001&sportCg=OSC2038
58218라인댄스 [실시간 라이브]2022-06-28256https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=218&siteCg=OSC1001&sportCg=OSC2015
59216방방도 운동이었어 【점핑트램폴린 실시간 라이브】2022-06-28293https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=216&siteCg=OSC1001&sportCg=OSC2054
605박태환의 수영교실2022-05-31253https://www.ksponco.or.kr/onlinesports/view?mid=b60200000000&c_type=videos&listNo=5&siteCg=OSC1001&sportCg=OSC2001