Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 100 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 6.2 KiB |
Average record size in memory | 63.3 B |
Variable types
Categorical | 3 |
---|---|
Numeric | 3 |
Text | 1 |
Dataset
Description | Sample |
---|---|
Author | 국민체육진흥공단 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=3dfe2c8f-e7bc-41ba-aebf-1e9eeb96a6a3 |
mbr_no has constant value "" | Constant |
tms is highly overall correlated with race_day | High correlation |
race_day is highly overall correlated with tms | High correlation |
stnd_year is highly imbalanced (80.6%) | Imbalance |
start_photo_url has unique values | Unique |
Reproduction
Analysis started | 2023-12-10 10:01:51.737304 |
---|---|
Analysis finished | 2023-12-10 10:01:54.976059 |
Duration | 3.24 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
stnd_year
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
2019 | |
---|---|
2021 | 3 |
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2019 |
---|---|
2nd row | 2021 |
3rd row | 2019 |
4th row | 2019 |
5th row | 2019 |
Common Values
Value | Count | Frequency (%) |
2019 | 97 | |
2021 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2019 | 97 | |
2021 | 3 | 3.0% |
tms
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 38 |
---|---|
Distinct (%) | 38.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 31.62 |
Minimum | 10 |
---|---|
Maximum | 51 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 10 |
---|---|
5-th percentile | 12 |
Q1 | 23.75 |
median | 34 |
Q3 | 41 |
95-th percentile | 47.05 |
Maximum | 51 |
Range | 41 |
Interquartile range (IQR) | 17.25 |
Descriptive statistics
Standard deviation | 11.210367 |
---|---|
Coefficient of variation (CV) | 0.35453405 |
Kurtosis | -0.90519734 |
Mean | 31.62 |
Median Absolute Deviation (MAD) | 8 |
Skewness | -0.38416175 |
Sum | 3162 |
Variance | 125.67232 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
42 | 7 | 7.0% |
30 | 7 | 7.0% |
40 | 6 | 6.0% |
12 | 6 | 6.0% |
25 | 5 | 5.0% |
41 | 5 | 5.0% |
39 | 5 | 5.0% |
36 | 4 | 4.0% |
34 | 4 | 4.0% |
16 | 3 | 3.0% |
Other values (28) | 48 |
Value | Count | Frequency (%) |
10 | 1 | 1.0% |
11 | 2 | 2.0% |
12 | 6 | |
13 | 2 | 2.0% |
14 | 1 | 1.0% |
15 | 1 | 1.0% |
16 | 3 | |
18 | 2 | 2.0% |
20 | 1 | 1.0% |
21 | 3 |
Value | Count | Frequency (%) |
51 | 2 | 2.0% |
49 | 2 | 2.0% |
48 | 1 | 1.0% |
47 | 2 | 2.0% |
46 | 1 | 1.0% |
45 | 2 | 2.0% |
44 | 1 | 1.0% |
43 | 3 | |
42 | 7 | |
41 | 5 |
mbr_no
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
1 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 100 |
day_ord
Categorical
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
3 | |
---|---|
2 | |
1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 3 |
---|---|
2nd row | 3 |
3rd row | 2 |
4th row | 3 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
3 | 42 | |
2 | 33 | |
1 | 25 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
3 | 42 | |
2 | 33 | |
1 | 25 |
race_no
Real number (ℝ)
Distinct | 18 |
---|---|
Distinct (%) | 18.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 8.09 |
Minimum | 1 |
---|---|
Maximum | 18 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 1 |
Q1 | 3.75 |
median | 8 |
Q3 | 12 |
95-th percentile | 15.05 |
Maximum | 18 |
Range | 17 |
Interquartile range (IQR) | 8.25 |
Descriptive statistics
Standard deviation | 4.7802096 |
---|---|
Coefficient of variation (CV) | 0.59087882 |
Kurtosis | -1.1634106 |
Mean | 8.09 |
Median Absolute Deviation (MAD) | 4 |
Skewness | 0.11588956 |
Sum | 809 |
Variance | 22.850404 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
12 | 10 | 10.0% |
3 | 9 | 9.0% |
2 | 8 | 8.0% |
13 | 8 | 8.0% |
1 | 8 | 8.0% |
10 | 7 | 7.0% |
8 | 7 | 7.0% |
6 | 6 | 6.0% |
15 | 6 | 6.0% |
9 | 6 | 6.0% |
Other values (8) | 25 |
Value | Count | Frequency (%) |
1 | 8 | |
2 | 8 | |
3 | 9 | |
4 | 5 | |
5 | 5 | |
6 | 6 | |
7 | 5 | |
8 | 7 | |
9 | 6 | |
10 | 7 |
Value | Count | Frequency (%) |
18 | 1 | 1.0% |
17 | 2 | 2.0% |
16 | 2 | 2.0% |
15 | 6 | |
14 | 3 | 3.0% |
13 | 8 | |
12 | 10 | |
11 | 2 | 2.0% |
10 | 7 | |
9 | 6 |
race_day
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 68 |
---|---|
Distinct (%) | 68.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 794.23 |
Minimum | 310 |
---|---|
Maximum | 1229 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 310 |
---|---|
5-th percentile | 322.95 |
Q1 | 614.25 |
median | 823 |
Q3 | 1018 |
95-th percentile | 1201.35 |
Maximum | 1229 |
Range | 919 |
Interquartile range (IQR) | 403.75 |
Descriptive statistics
Standard deviation | 268.53891 |
---|---|
Coefficient of variation (CV) | 0.33811228 |
Kurtosis | -0.9696588 |
Mean | 794.23 |
Median Absolute Deviation (MAD) | 201 |
Skewness | -0.34922106 |
Sum | 79423 |
Variance | 72113.149 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
421 | 3 | 3.0% |
728 | 3 | 3.0% |
1027 | 3 | 3.0% |
1025 | 3 | 3.0% |
1018 | 3 | 3.0% |
1012 | 3 | 3.0% |
323 | 3 | 3.0% |
1102 | 2 | 2.0% |
1013 | 2 | 2.0% |
901 | 2 | 2.0% |
Other values (58) | 73 |
Value | Count | Frequency (%) |
310 | 1 | 1.0% |
315 | 1 | 1.0% |
316 | 1 | 1.0% |
322 | 2 | |
323 | 3 | |
324 | 1 | 1.0% |
330 | 1 | 1.0% |
331 | 1 | 1.0% |
406 | 1 | 1.0% |
414 | 1 | 1.0% |
Value | Count | Frequency (%) |
1229 | 2 | |
1215 | 2 | |
1208 | 1 | |
1201 | 1 | |
1129 | 1 | |
1124 | 1 | |
1116 | 2 | |
1108 | 1 | |
1102 | 2 | |
1101 | 1 |
start_photo_url
Text
UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
Length
Max length | 79 |
---|---|
Median length | 79 |
Mean length | 79 |
Min length | 79 |
Characters and Unicode
Total characters | 7900 |
---|---|
Distinct characters | 35 |
Distinct categories | 5 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 100 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1576382470484.jpg |
---|---|
2nd row | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1632638346705.jpg |
3rd row | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1553937470685.jpg |
4th row | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1553415847183.jpg |
5th row | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1553235106031.jpg |
Value | Count | Frequency (%) |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1576382470484.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1575020684761.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1553331155197.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1554017562893.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1554538148868.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1555224113151.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1555828727793.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1555822825839.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1556960357580.jpg | 1 | 1.0% |
http://www.kcycle.or.kr/contents/popup/judgephotopopup.do?img=1557032593919.jpg | 1 | 1.0% |
Other values (90) | 90 |
Most occurring characters
Value | Count | Frequency (%) |
p | 700 | 8.9% |
o | 700 | 8.9% |
/ | 500 | 6.3% |
. | 500 | 6.3% |
t | 500 | 6.3% |
u | 300 | 3.8% |
w | 300 | 3.8% |
c | 300 | 3.8% |
g | 300 | 3.8% |
e | 300 | 3.8% |
Other values (25) | 3500 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 5100 | |
Decimal Number | 1300 | 16.5% |
Other Punctuation | 1200 | 15.2% |
Uppercase Letter | 200 | 2.5% |
Math Symbol | 100 | 1.3% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
p | 700 | |
o | 700 | |
t | 500 | 9.8% |
u | 300 | 5.9% |
w | 300 | 5.9% |
c | 300 | 5.9% |
g | 300 | 5.9% |
e | 300 | 5.9% |
h | 200 | 3.9% |
d | 200 | 3.9% |
Other values (9) | 1300 |
Decimal Number
Value | Count | Frequency (%) |
5 | 215 | |
1 | 190 | |
6 | 137 | |
7 | 136 | |
3 | 116 | |
2 | 109 | |
0 | 104 | |
8 | 103 | |
4 | 96 | |
9 | 94 |
Other Punctuation
Value | Count | Frequency (%) |
/ | 500 | |
. | 500 | |
: | 100 | 8.3% |
? | 100 | 8.3% |
Uppercase Letter
Value | Count | Frequency (%) |
P | 200 |
Math Symbol
Value | Count | Frequency (%) |
= | 100 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 5300 | |
Common | 2600 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
p | 700 | |
o | 700 | |
t | 500 | 9.4% |
u | 300 | 5.7% |
w | 300 | 5.7% |
c | 300 | 5.7% |
g | 300 | 5.7% |
e | 300 | 5.7% |
h | 200 | 3.8% |
P | 200 | 3.8% |
Other values (10) | 1500 |
Common
Value | Count | Frequency (%) |
/ | 500 | |
. | 500 | |
5 | 215 | |
1 | 190 | 7.3% |
6 | 137 | 5.3% |
7 | 136 | 5.2% |
3 | 116 | 4.5% |
2 | 109 | 4.2% |
0 | 104 | 4.0% |
8 | 103 | 4.0% |
Other values (5) | 490 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 7900 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
p | 700 | 8.9% |
o | 700 | 8.9% |
/ | 500 | 6.3% |
. | 500 | 6.3% |
t | 500 | 6.3% |
u | 300 | 3.8% |
w | 300 | 3.8% |
c | 300 | 3.8% |
g | 300 | 3.8% |
e | 300 | 3.8% |
Other values (25) | 3500 |
stnd_year | tms | day_ord | race_no | race_day | start_photo_url | |
---|---|---|---|---|---|---|
stnd_year | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
tms | 0.000 | 1.000 | 0.205 | 0.000 | 0.998 | 1.000 |
day_ord | 0.000 | 0.205 | 1.000 | 0.000 | 0.298 | 1.000 |
race_no | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 |
race_day | 0.000 | 0.998 | 0.298 | 0.000 | 1.000 | 1.000 |
start_photo_url | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
day_ord | stnd_year | |
---|---|---|
day_ord | 1.000 | 0.000 |
stnd_year | 0.000 | 1.000 |
tms | race_no | race_day | stnd_year | day_ord | |
---|---|---|---|---|---|
tms | 1.000 | -0.134 | 0.999 | 0.000 | 0.116 |
race_no | -0.134 | 1.000 | -0.130 | 0.000 | 0.000 |
race_day | 0.999 | -0.130 | 1.000 | 0.000 | 0.161 |
stnd_year | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
day_ord | 0.116 | 0.000 | 0.161 | 0.000 | 1.000 |
stnd_year | tms | mbr_no | day_ord | race_no | race_day | start_photo_url | |
---|---|---|---|---|---|---|---|
0 | 2019 | 49 | 1 | 3 | 2 | 1215 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1576382470484.jpg |
1 | 2021 | 39 | 1 | 3 | 1 | 926 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1632638346705.jpg |
2 | 2019 | 13 | 1 | 2 | 13 | 330 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1553937470685.jpg |
3 | 2019 | 12 | 1 | 3 | 11 | 324 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1553415847183.jpg |
4 | 2019 | 12 | 1 | 1 | 5 | 322 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1553235106031.jpg |
5 | 2019 | 11 | 1 | 2 | 2 | 316 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1552712618502.jpg |
6 | 2019 | 36 | 1 | 2 | 6 | 907 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1567840815455.jpg |
7 | 2021 | 28 | 1 | 1 | 6 | 709 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1625819854387.jpg |
8 | 2019 | 37 | 1 | 3 | 3 | 922 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1569128707150.jpg |
9 | 2019 | 39 | 1 | 2 | 10 | 1005 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1570262740120.jpg |
stnd_year | tms | mbr_no | day_ord | race_no | race_day | start_photo_url | |
---|---|---|---|---|---|---|---|
90 | 2019 | 35 | 1 | 2 | 12 | 831 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1567245093448.jpg |
91 | 2019 | 34 | 1 | 2 | 8 | 824 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1566634165737.jpg |
92 | 2019 | 33 | 1 | 3 | 6 | 818 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1566108378521.jpg |
93 | 2019 | 32 | 1 | 2 | 1 | 810 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1565414357431.jpg |
94 | 2019 | 31 | 1 | 3 | 2 | 804 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1564893239804.jpg |
95 | 2019 | 31 | 1 | 2 | 13 | 803 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1564827372512.jpg |
96 | 2019 | 30 | 1 | 3 | 11 | 728 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1564301256581.jpg |
97 | 2019 | 30 | 1 | 2 | 3 | 727 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1564207420410.jpg |
98 | 2019 | 30 | 1 | 1 | 4 | 726 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1564122568365.jpg |
99 | 2019 | 30 | 1 | 1 | 8 | 726 | http://www.kcycle.or.kr/contents/popup/judgePhotoPopup.do?img=1564128529000.jpg |