Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory59.3 B

Variable types

DateTime1
Categorical4
Text1
Numeric1

Alerts

Survey_Base_Date_DE has constant value ""Constant
Country_CD has constant value ""Constant
FILE_NAME has constant value ""Constant
BASE_YMD has constant value ""Constant
Music_RN has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:17:19.672235
Analysis finished2023-12-10 10:17:20.545652
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Survey_Base_Date_DE
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2020-01-07 00:00:00
Maximum2020-01-07 00:00:00
2023-12-10T19:17:20.626663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:17:20.729391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Country_CD
Categorical

CONSTANT 

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

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 100
100.0%

Length

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

Common Values (Plot)

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

Music_NM
Categorical

Distinct37
Distinct (%)37.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
BTS
20 
BIGBANG
9 
BLACKPINK
7 
EXO
6 
TWICE
 
5
Other values (32)
53 

Length

Max length29
Median length19
Mean length6.55
Min length2

Unique

Unique20 ?
Unique (%)20.0%

Sample

1st rowRed Velvet
2nd rowBLACKPINK
3rd rowMAMAMOO
4th rowPSY
5th rowBTS

Common Values

ValueCountFrequency (%)
BTS 20
20.0%
BIGBANG 9
 
9.0%
BLACKPINK 7
 
7.0%
EXO 6
 
6.0%
TWICE 5
 
5.0%
Red Velvet 4
 
4.0%
MAMAMOO 4
 
4.0%
PSY 4
 
4.0%
SHINee 4
 
4.0%
TAEYANG 3
 
3.0%
Other values (27) 34
34.0%

Length

2023-12-10T19:17:21.064844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts 20
 
16.3%
bigbang 9
 
7.3%
blackpink 8
 
6.5%
exo 6
 
4.9%
twice 5
 
4.1%
red 4
 
3.3%
velvet 4
 
3.3%
mamamoo 4
 
3.3%
psy 4
 
3.3%
shinee 4
 
3.3%
Other values (40) 55
44.7%

Artist_NM
Text

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

Length

Max length45
Median length25
Mean length11.53
Min length2

Characters and Unicode

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

Unique

Unique93 ?
Unique (%)93.0%

Sample

1st rowPsycho
2nd rowKill This Love
3rd rowHip
4th rowGangnam Style
5th rowBoy With Luv (feat. Halsey)
ValueCountFrequency (%)
boy 5
 
2.2%
feat 5
 
2.2%
love 4
 
1.8%
4
 
1.8%
i 4
 
1.8%
you 4
 
1.8%
right 4
 
1.8%
if 3
 
1.3%
with 3
 
1.3%
bang 3
 
1.3%
Other values (155) 184
82.5%
2023-12-10T19:17:22.041198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
123
 
10.7%
e 74
 
6.4%
o 59
 
5.1%
i 54
 
4.7%
a 48
 
4.2%
r 41
 
3.6%
n 39
 
3.4%
t 37
 
3.2%
s 36
 
3.1%
l 31
 
2.7%
Other values (57) 611
53.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 609
52.8%
Uppercase Letter 368
31.9%
Space Separator 123
 
10.7%
Other Punctuation 19
 
1.6%
Open Punctuation 13
 
1.1%
Close Punctuation 13
 
1.1%
Dash Punctuation 5
 
0.4%
Decimal Number 2
 
0.2%
Math Symbol 1
 
0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
B 28
 
7.6%
O 27
 
7.3%
D 25
 
6.8%
E 25
 
6.8%
S 24
 
6.5%
A 23
 
6.2%
L 21
 
5.7%
I 20
 
5.4%
R 19
 
5.2%
T 17
 
4.6%
Other values (16) 139
37.8%
Lowercase Letter
ValueCountFrequency (%)
e 74
12.2%
o 59
 
9.7%
i 54
 
8.9%
a 48
 
7.9%
r 41
 
6.7%
n 39
 
6.4%
t 37
 
6.1%
s 36
 
5.9%
l 31
 
5.1%
u 26
 
4.3%
Other values (14) 164
26.9%
Other Punctuation
ValueCountFrequency (%)
. 9
47.4%
, 3
 
15.8%
& 2
 
10.5%
# 1
 
5.3%
' 1
 
5.3%
/ 1
 
5.3%
: 1
 
5.3%
! 1
 
5.3%
Open Punctuation
ValueCountFrequency (%)
( 12
92.3%
[ 1
 
7.7%
Close Punctuation
ValueCountFrequency (%)
) 12
92.3%
] 1
 
7.7%
Decimal Number
ValueCountFrequency (%)
9 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
123
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 977
84.7%
Common 176
 
15.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 74
 
7.6%
o 59
 
6.0%
i 54
 
5.5%
a 48
 
4.9%
r 41
 
4.2%
n 39
 
4.0%
t 37
 
3.8%
s 36
 
3.7%
l 31
 
3.2%
B 28
 
2.9%
Other values (40) 530
54.2%
Common
ValueCountFrequency (%)
123
69.9%
( 12
 
6.8%
) 12
 
6.8%
. 9
 
5.1%
- 5
 
2.8%
, 3
 
1.7%
& 2
 
1.1%
# 1
 
0.6%
[ 1
 
0.6%
] 1
 
0.6%
Other values (7) 7
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1153
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
123
 
10.7%
e 74
 
6.4%
o 59
 
5.1%
i 54
 
4.7%
a 48
 
4.2%
r 41
 
3.6%
n 39
 
3.4%
t 37
 
3.2%
s 36
 
3.1%
l 31
 
2.7%
Other values (57) 611
53.0%

Music_RN
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50.5
Minimum1
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:17:22.224407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.95
Q125.75
median50.5
Q375.25
95-th percentile95.05
Maximum100
Range99
Interquartile range (IQR)49.5

Descriptive statistics

Standard deviation29.011492
Coefficient of variation (CV)0.57448499
Kurtosis-1.2
Mean50.5
Median Absolute Deviation (MAD)25
Skewness0
Sum5050
Variance841.66667
MonotonicityStrictly increasing
2023-12-10T19:17:22.445711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
65 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%

FILE_NAME
Categorical

CONSTANT 

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

Length

Max length22
Median length22
Mean length22
Min length22

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KC_music_chart_au_2019 100
100.0%

Length

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

Common Values (Plot)

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

BASE_YMD
Categorical

CONSTANT 

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

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2019 100
100.0%

Length

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

Common Values (Plot)

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

Interactions

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

Correlations

2023-12-10T19:17:23.039254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Music_NMArtist_NMMusic_RN
Music_NM1.0001.0000.466
Artist_NM1.0001.0000.870
Music_RN0.4660.8701.000
2023-12-10T19:17:23.142019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Music_RNMusic_NM
Music_RN1.0000.139
Music_NM0.1391.000

Missing values

2023-12-10T19:17:20.007513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:17:20.463317image/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_Base_Date_DECountry_CDMusic_NMArtist_NMMusic_RNFILE_NAMEBASE_YMD
02020-01-07auRed VelvetPsycho1KC_music_chart_au_20192019
12020-01-07auBLACKPINKKill This Love2KC_music_chart_au_20192019
22020-01-07auMAMAMOOHip3KC_music_chart_au_20192019
32020-01-07auPSYGangnam Style4KC_music_chart_au_20192019
42020-01-07auBTSBoy With Luv (feat. Halsey)5KC_music_chart_au_20192019
52020-01-07auK/DA, Madison Beer & (G)I-DLEPOP/STARS (feat. Jaira Burns)6KC_music_chart_au_20192019
62020-01-07auBTSMake It Right (feat. Lauv)7KC_music_chart_au_20192019
72020-01-07auPSYGangnam Style8KC_music_chart_au_20192019
82020-01-07auStray KidsMixtape : Gone Days9KC_music_chart_au_20192019
92020-01-07auBTSHOME10KC_music_chart_au_20192019
Survey_Base_Date_DECountry_CDMusic_NMArtist_NMMusic_RNFILE_NAMEBASE_YMD
902020-01-07auGOT7If You Do91KC_music_chart_au_20192019
912020-01-07auBlock BNillili Mambo92KC_music_chart_au_20192019
922020-01-07auEXO-KMama93KC_music_chart_au_20192019
932020-01-07auBTSMIC Drop94KC_music_chart_au_20192019
942020-01-07auTWICELike OOH-AHH95KC_music_chart_au_20192019
952020-01-07auBTSBoyz with Fun96KC_music_chart_au_20192019
962020-01-07auTAEYANGWedding Dress (English Version)97KC_music_chart_au_20192019
972020-01-07auG-DRAGONOne of a Kind98KC_music_chart_au_20192019
982020-01-07auf(x)Electric Shock99KC_music_chart_au_20192019
992020-01-07auTWICECHEER UP100KC_music_chart_au_20192019