Overview

Dataset statistics

Number of variables4
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.4 KiB
Average record size in memory34.3 B

Variable types

Categorical1
Text2
Numeric1

Alerts

center_nm is highly imbalanced (80.6%)Imbalance
url has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:12:31.764210
Analysis finished2023-12-10 10:12:32.773819
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

center_nm
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
올팍축구장
97 
일산올림픽스포츠센터
 
3

Length

Max length10
Median length5
Mean length5.15
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row올팍축구장
2nd row일산올림픽스포츠센터
3rd row올팍축구장
4th row올팍축구장
5th row올팍축구장

Common Values

ValueCountFrequency (%)
올팍축구장 97
97.0%
일산올림픽스포츠센터 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T19:12:33.120344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
올팍축구장 97
97.0%
일산올림픽스포츠센터 3
 
3.0%

title
Text

Distinct98
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T19:12:33.670823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length29.5
Mean length20.5
Min length9

Characters and Unicode

Total characters2050
Distinct characters279
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

Unique96 ?
Unique (%)96.0%

Sample

1st row올팍축구장 이용료(회비) 인상 안내
2nd row2019년도 하반기 고객제안제도 결과 안내
3rd row8월 축구 수강 등록 이벤트
4th row2월 회원등록 이벤트 안내
5th row스포츠센터 온라인 예약시스템 설문조사
ValueCountFrequency (%)
안내 38
 
8.1%
올팍축구장 19
 
4.0%
홈페이지 16
 
3.4%
중단 16
 
3.4%
서비스 15
 
3.2%
일시 14
 
3.0%
이벤트 9
 
1.9%
개최 6
 
1.3%
올림픽공원 5
 
1.1%
정부3.0 5
 
1.1%
Other values (253) 328
69.6%
2023-12-10T19:12:34.674038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
371
 
18.1%
67
 
3.3%
63
 
3.1%
1 44
 
2.1%
39
 
1.9%
38
 
1.9%
38
 
1.9%
36
 
1.8%
36
 
1.8%
35
 
1.7%
Other values (269) 1283
62.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1416
69.1%
Space Separator 371
 
18.1%
Decimal Number 155
 
7.6%
Other Punctuation 44
 
2.1%
Close Punctuation 18
 
0.9%
Open Punctuation 18
 
0.9%
Uppercase Letter 11
 
0.5%
Lowercase Letter 8
 
0.4%
Math Symbol 6
 
0.3%
Dash Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
67
 
4.7%
63
 
4.4%
39
 
2.8%
38
 
2.7%
38
 
2.7%
36
 
2.5%
36
 
2.5%
35
 
2.5%
30
 
2.1%
30
 
2.1%
Other values (235) 1004
70.9%
Decimal Number
ValueCountFrequency (%)
1 44
28.4%
0 30
19.4%
2 28
18.1%
3 15
 
9.7%
9 11
 
7.1%
7 7
 
4.5%
8 7
 
4.5%
5 5
 
3.2%
6 5
 
3.2%
4 3
 
1.9%
Other Punctuation
ValueCountFrequency (%)
. 29
65.9%
! 8
 
18.2%
, 2
 
4.5%
" 2
 
4.5%
? 2
 
4.5%
' 1
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
C 3
27.3%
F 3
27.3%
O 2
18.2%
L 2
18.2%
K 1
 
9.1%
Lowercase Letter
ValueCountFrequency (%)
k 2
25.0%
r 2
25.0%
a 2
25.0%
p 2
25.0%
Math Symbol
ValueCountFrequency (%)
~ 4
66.7%
> 1
 
16.7%
< 1
 
16.7%
Close Punctuation
ValueCountFrequency (%)
) 17
94.4%
1
 
5.6%
Open Punctuation
ValueCountFrequency (%)
( 17
94.4%
1
 
5.6%
Space Separator
ValueCountFrequency (%)
371
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1416
69.1%
Common 615
30.0%
Latin 19
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
67
 
4.7%
63
 
4.4%
39
 
2.8%
38
 
2.7%
38
 
2.7%
36
 
2.5%
36
 
2.5%
35
 
2.5%
30
 
2.1%
30
 
2.1%
Other values (235) 1004
70.9%
Common
ValueCountFrequency (%)
371
60.3%
1 44
 
7.2%
0 30
 
4.9%
. 29
 
4.7%
2 28
 
4.6%
) 17
 
2.8%
( 17
 
2.8%
3 15
 
2.4%
9 11
 
1.8%
! 8
 
1.3%
Other values (15) 45
 
7.3%
Latin
ValueCountFrequency (%)
C 3
15.8%
F 3
15.8%
O 2
10.5%
L 2
10.5%
k 2
10.5%
r 2
10.5%
a 2
10.5%
p 2
10.5%
K 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1416
69.1%
ASCII 632
30.8%
None 2
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
371
58.7%
1 44
 
7.0%
0 30
 
4.7%
. 29
 
4.6%
2 28
 
4.4%
) 17
 
2.7%
( 17
 
2.7%
3 15
 
2.4%
9 11
 
1.7%
! 8
 
1.3%
Other values (22) 62
 
9.8%
Hangul
ValueCountFrequency (%)
67
 
4.7%
63
 
4.4%
39
 
2.8%
38
 
2.7%
38
 
2.7%
36
 
2.5%
36
 
2.5%
35
 
2.5%
30
 
2.1%
30
 
2.1%
Other values (235) 1004
70.9%
None
ValueCountFrequency (%)
1
50.0%
1
50.0%

hit
Real number (ℝ)

Distinct95
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean921.8
Minimum8
Maximum3265
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:12:35.433588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8
5-th percentile74.7
Q1507.5
median856
Q31189.5
95-th percentile2007
Maximum3265
Range3257
Interquartile range (IQR)682

Descriptive statistics

Standard deviation604.29752
Coefficient of variation (CV)0.65556251
Kurtosis2.7223325
Mean921.8
Median Absolute Deviation (MAD)347
Skewness1.2183339
Sum92180
Variance365175.49
MonotonicityNot monotonic
2023-12-10T19:12:35.735460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
494 2
 
2.0%
606 2
 
2.0%
733 2
 
2.0%
810 2
 
2.0%
856 2
 
2.0%
1699 1
 
1.0%
1490 1
 
1.0%
627 1
 
1.0%
1113 1
 
1.0%
1215 1
 
1.0%
Other values (85) 85
85.0%
ValueCountFrequency (%)
8 1
1.0%
24 1
1.0%
39 1
1.0%
65 1
1.0%
69 1
1.0%
75 1
1.0%
111 1
1.0%
134 1
1.0%
144 1
1.0%
149 1
1.0%
ValueCountFrequency (%)
3265 1
1.0%
2983 1
1.0%
2629 1
1.0%
2267 1
1.0%
2102 1
1.0%
2002 1
1.0%
1699 1
1.0%
1667 1
1.0%
1655 1
1.0%
1620 1
1.0%

url
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T19:12:36.306122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length84
Median length84
Mean length84
Min length84

Characters and Unicode

Total characters8400
Distinct characters35
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

Unique100 ?
Unique (%)100.0%

Sample

1st rowhttp://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9387&act=view
2nd rowhttp://sports.ksponco.or.kr/board.es?mid=a60401000000&bid=0034&list_no=9752&act=view
3rd rowhttp://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=7416&act=view
4th rowhttp://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9509&act=view
5th rowhttp://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9546&act=view
ValueCountFrequency (%)
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9387&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9474&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9477&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9478&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9531&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9479&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9480&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9534&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9469&act=view 1
 
1.0%
http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9470&act=view 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T19:12:37.121935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1018
 
12.1%
o 600
 
7.1%
t 500
 
6.0%
s 500
 
6.0%
r 400
 
4.8%
. 400
 
4.8%
= 400
 
4.8%
i 400
 
4.8%
p 300
 
3.6%
& 300
 
3.6%
Other values (25) 3582
42.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 4800
57.1%
Decimal Number 1900
 
22.6%
Other Punctuation 1200
 
14.3%
Math Symbol 400
 
4.8%
Connector Punctuation 100
 
1.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 600
12.5%
t 500
10.4%
s 500
10.4%
r 400
 
8.3%
i 400
 
8.3%
p 300
 
6.2%
a 300
 
6.2%
d 300
 
6.2%
b 200
 
4.2%
e 200
 
4.2%
Other values (8) 1100
22.9%
Decimal Number
ValueCountFrequency (%)
0 1018
53.6%
4 256
 
13.5%
1 223
 
11.7%
9 200
 
10.5%
5 74
 
3.9%
7 34
 
1.8%
8 27
 
1.4%
3 25
 
1.3%
2 25
 
1.3%
6 18
 
0.9%
Other Punctuation
ValueCountFrequency (%)
. 400
33.3%
& 300
25.0%
/ 300
25.0%
? 100
 
8.3%
: 100
 
8.3%
Math Symbol
ValueCountFrequency (%)
= 400
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 4800
57.1%
Common 3600
42.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 600
12.5%
t 500
10.4%
s 500
10.4%
r 400
 
8.3%
i 400
 
8.3%
p 300
 
6.2%
a 300
 
6.2%
d 300
 
6.2%
b 200
 
4.2%
e 200
 
4.2%
Other values (8) 1100
22.9%
Common
ValueCountFrequency (%)
0 1018
28.3%
. 400
 
11.1%
= 400
 
11.1%
& 300
 
8.3%
/ 300
 
8.3%
4 256
 
7.1%
1 223
 
6.2%
9 200
 
5.6%
_ 100
 
2.8%
? 100
 
2.8%
Other values (7) 303
 
8.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1018
 
12.1%
o 600
 
7.1%
t 500
 
6.0%
s 500
 
6.0%
r 400
 
4.8%
. 400
 
4.8%
= 400
 
4.8%
i 400
 
4.8%
p 300
 
3.6%
& 300
 
3.6%
Other values (25) 3582
42.6%

Interactions

2023-12-10T19:12:32.289972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:12:37.296333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
center_nmtitlehiturl
center_nm1.0001.0000.4731.000
title1.0001.0000.9841.000
hit0.4730.9841.0001.000
url1.0001.0001.0001.000
2023-12-10T19:12:37.456425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
hitcenter_nm
hit1.0000.456
center_nm0.4561.000

Missing values

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

center_nmtitlehiturl
0올팍축구장올팍축구장 이용료(회비) 인상 안내1699http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9387&act=view
1일산올림픽스포츠센터2019년도 하반기 고객제안제도 결과 안내2102http://sports.ksponco.or.kr/board.es?mid=a60401000000&bid=0034&list_no=9752&act=view
2올팍축구장8월 축구 수강 등록 이벤트961http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=7416&act=view
3올팍축구장2월 회원등록 이벤트 안내606http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9509&act=view
4올팍축구장스포츠센터 온라인 예약시스템 설문조사354http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9546&act=view
5올팍축구장홈페이지 서비스 일시 중단 안내(3.16)24http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9512&act=view
6올팍축구장조이올팍 야외콘서트 안내778http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=7461&act=view
7일산올림픽스포츠센터2019 연말연시 이웃사랑나눔 물품모음행사 안내1485http://sports.ksponco.or.kr/board.es?mid=a60401000000&bid=0034&list_no=9753&act=view
8올팍축구장미사리 경정공원 영화관람1008http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=7462&act=view
9올팍축구장카드 자동이체 시행 안내810http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=8620&act=view
center_nmtitlehiturl
90올팍축구장올팍축구장 기본방역 수칙 안내813http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9540&act=view
91올팍축구장올팍축구장 사회적 거리두기 2.5단계 격상에 따른 휴관안내731http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9532&act=view
92올팍축구장올팍축구장 재개관 안내1065http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9514&act=view
93올팍축구장추석명절 금품수수 금지 안내1184http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9159&act=view
94올팍축구장홈페이지 서비스 일시 중단 안내(10.7)75http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9551&act=view
95올팍축구장회원안내실 변경 운영 안내364http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9538&act=view
96올팍축구장홈페이지 서비스 일시 중단 안내(7.20)39http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9519&act=view
97올팍축구장21년 올팍축구장 여름방학 특강운영 안내494http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9545&act=view
98올팍축구장올팍축구장 후불제 주차 시행 안내1206http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9240&act=view
99올팍축구장홈페이지 내 실시간 등록현황 등 서비스 일시 중단 안내(11.17)69http://sports.ksponco.or.kr/board.es?mid=a40401000000&bid=0019&list_no=9556&act=view