Overview

Dataset statistics

Number of variables5
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory43.3 B

Variable types

Categorical4
Numeric1

Alerts

Survey_Date_YY has constant value ""Constant

Reproduction

Analysis started2023-12-10 10:07:20.461152
Analysis finished2023-12-10 10:07:21.645516
Duration1.18 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Survey_Date_YY
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2017
100 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017
2nd row2017
3rd row2017
4th row2017
5th row2017

Common Values

ValueCountFrequency (%)
2017 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:07:21.960439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017 100
100.0%

Country_CD
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
au
71 
gb
29 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowau
2nd rowau
3rd rowau
4th rowau
5th rowau

Common Values

ValueCountFrequency (%)
au 71
71.0%
gb 29
29.0%

Length

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

Common Values (Plot)

2023-12-10T19:07:22.755529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
au 71
71.0%
gb 29
29.0%

Artist_NM
Categorical

Distinct12
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
bts
45 
blackpink
11 
exo
8 
mamamoo
6 
twice
6 
Other values (7)
24 

Length

Max length9
Median length3
Mean length4.55
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st rowblackpink
2nd rowblackpink
3rd rowblackpink
4th rowblackpink
5th rowblackpink

Common Values

ValueCountFrequency (%)
bts 45
45.0%
blackpink 11
 
11.0%
exo 8
 
8.0%
mamamoo 6
 
6.0%
twice 6
 
6.0%
got7 5
 
5.0%
nct 5
 
5.0%
seventeen 5
 
5.0%
day6 3
 
3.0%
jhope 3
 
3.0%
Other values (2) 3
 
3.0%

Length

2023-12-10T19:07:22.968577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts 45
45.0%
blackpink 11
 
11.0%
exo 8
 
8.0%
mamamoo 6
 
6.0%
twice 6
 
6.0%
got7 5
 
5.0%
nct 5
 
5.0%
seventeen 5
 
5.0%
day6 3
 
3.0%
jhope 3
 
3.0%
Other values (2) 3
 
3.0%

Country_Artist_KEY_W
Categorical

Distinct46
Distinct (%)46.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
youtube
11 
amp
8 
kpop
7 
bts
 
6
jackson
 
5
Other values (41)
63 

Length

Max length10
Median length8
Mean length5.43
Min length3

Unique

Unique21 ?
Unique (%)21.0%

Sample

1st rowblackpink
2nd rowyoutube
3rd rowblackpinks
4th rowmbc
5th rowblinks

Common Values

ValueCountFrequency (%)
youtube 11
 
11.0%
amp 8
 
8.0%
kpop 7
 
7.0%
bts 6
 
6.0%
jackson 5
 
5.0%
btstwt 3
 
3.0%
music 3
 
3.0%
blackpink 2
 
2.0%
blackpinks 2
 
2.0%
artist 2
 
2.0%
Other values (36) 51
51.0%

Length

2023-12-10T19:07:23.252768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
youtube 11
 
11.0%
amp 8
 
8.0%
kpop 7
 
7.0%
bts 6
 
6.0%
jackson 5
 
5.0%
btstwt 3
 
3.0%
music 3
 
3.0%
jungkook 2
 
2.0%
bangtan 2
 
2.0%
armys 2
 
2.0%
Other values (36) 51
51.0%

Keyword_FQ
Real number (ℝ)

Distinct60
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean140.45
Minimum1
Maximum4680
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:07:23.522837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median24.5
Q383
95-th percentile337.6
Maximum4680
Range4679
Interquartile range (IQR)77

Descriptive statistics

Standard deviation517.71681
Coefficient of variation (CV)3.6861289
Kurtosis61.937663
Mean140.45
Median Absolute Deviation (MAD)22.5
Skewness7.4552991
Sum14045
Variance268030.69
MonotonicityNot monotonic
2023-12-10T19:07:23.830942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 9
 
9.0%
6 6
 
6.0%
3 4
 
4.0%
10 3
 
3.0%
23 3
 
3.0%
11 3
 
3.0%
7 3
 
3.0%
5 3
 
3.0%
21 3
 
3.0%
117 2
 
2.0%
Other values (50) 61
61.0%
ValueCountFrequency (%)
1 2
 
2.0%
2 9
9.0%
3 4
4.0%
4 2
 
2.0%
5 3
 
3.0%
6 6
6.0%
7 3
 
3.0%
8 2
 
2.0%
9 1
 
1.0%
10 3
 
3.0%
ValueCountFrequency (%)
4680 1
1.0%
1807 1
1.0%
1441 1
1.0%
598 1
1.0%
368 1
1.0%
336 1
1.0%
295 1
1.0%
289 1
1.0%
251 1
1.0%
250 1
1.0%

Interactions

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

Correlations

2023-12-10T19:07:24.015516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Country_CDArtist_NMCountry_Artist_KEY_WKeyword_FQ
Country_CD1.0000.6240.0000.241
Artist_NM0.6241.0000.0000.000
Country_Artist_KEY_W0.0000.0001.0000.000
Keyword_FQ0.2410.0000.0001.000
2023-12-10T19:07:24.235901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Artist_NMCountry_CDCountry_Artist_KEY_W
Artist_NM1.0000.4630.000
Country_CD0.4631.0000.000
Country_Artist_KEY_W0.0000.0001.000
2023-12-10T19:07:24.472475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Keyword_FQCountry_CDArtist_NMCountry_Artist_KEY_W
Keyword_FQ1.0000.1580.0000.000
Country_CD0.1581.0000.4630.000
Artist_NM0.0000.4631.0000.000
Country_Artist_KEY_W0.0000.0000.0001.000

Missing values

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

Survey_Date_YYCountry_CDArtist_NMCountry_Artist_KEY_WKeyword_FQ
02017aublackpinkblackpink117
12017aublackpinkyoutube24
22017aublackpinkblackpinks10
32017aublackpinkmbc8
42017aublackpinkblinks6
52017aublackpinkikon6
62017aubtsbts1807
72017aubtsyoutube368
82017aubtsbtstwt180
92017aubtskpop124
Survey_Date_YYCountry_CDArtist_NMCountry_Artist_KEY_WKeyword_FQ
902017gbbtsjimin94
912017gbbtsbillboard75
922017gbbtsamas73
932017gbbtsexo72
942017gbbtsmbc65
952017gbbtscomeback64
962017gbbtsmelon63
972017gbbtssong61
982017gbbtsjungkook60
992017gbbtsjhope56