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

Categorical5
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:02:06.732480
Analysis finished2023-12-10 10:02:07.642401
Duration0.91 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Survey_Base_Date_DE
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2020-01-07
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-01-07
2nd row2020-01-07
3rd row2020-01-07
4th row2020-01-07
5th row2020-01-07

Common Values

ValueCountFrequency (%)
2020-01-07 100
100.0%

Length

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

Common Values (Plot)

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

Country_CD
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
us 100
100.0%

Length

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

Common Values (Plot)

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

Music_NM
Categorical

Distinct34
Distinct (%)34.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
BTS
36 
ATEEZ
11 
Younha
5 
BLACKPINK
 
4
Red Velvet
 
3
Other values (29)
41 

Length

Max length29
Median length19
Mean length5.65
Min length2

Unique

Unique20 ?
Unique (%)20.0%

Sample

1st rowYounha
2nd rowATEEZ
3rd rowATEEZ
4th rowRed Velvet
5th rowATEEZ

Common Values

ValueCountFrequency (%)
BTS 36
36.0%
ATEEZ 11
 
11.0%
Younha 5
 
5.0%
BLACKPINK 4
 
4.0%
Red Velvet 3
 
3.0%
MAMAMOO 3
 
3.0%
Stray Kids 3
 
3.0%
EXO 3
 
3.0%
TWICE 2
 
2.0%
j-hope 2
 
2.0%
Other values (24) 28
28.0%

Length

2023-12-10T19:02:08.487902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bts 36
29.3%
ateez 11
 
8.9%
younha 5
 
4.1%
blackpink 4
 
3.3%
x 4
 
3.3%
kids 3
 
2.4%
exo 3
 
2.4%
nct 3
 
2.4%
stray 3
 
2.4%
red 3
 
2.4%
Other values (35) 48
39.0%

Artist_NM
Text

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

Length

Max length51
Median length37
Mean length13.61
Min length2

Characters and Unicode

Total characters1361
Distinct characters72
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 rowWinter Flower (feat. RM)
2nd rowAnswer
3rd rowHorizon
4th rowPsycho
5th rowPrecious
ValueCountFrequency (%)
feat 9
 
3.7%
love 6
 
2.5%
6
 
2.5%
go 4
 
1.6%
you 3
 
1.2%
flower 3
 
1.2%
full 3
 
1.2%
length 3
 
1.2%
edition 3
 
1.2%
dope 2
 
0.8%
Other values (181) 202
82.8%
2023-12-10T19:02:10.152969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
144
 
10.6%
e 108
 
7.9%
o 82
 
6.0%
a 72
 
5.3%
i 66
 
4.8%
t 64
 
4.7%
n 59
 
4.3%
r 55
 
4.0%
s 37
 
2.7%
l 37
 
2.7%
Other values (62) 637
46.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 819
60.2%
Uppercase Letter 311
 
22.9%
Space Separator 144
 
10.6%
Other Punctuation 27
 
2.0%
Open Punctuation 20
 
1.5%
Close Punctuation 20
 
1.5%
Decimal Number 14
 
1.0%
Dash Punctuation 2
 
0.1%
Final Punctuation 2
 
0.1%
Other Letter 2
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 108
13.2%
o 82
 
10.0%
a 72
 
8.8%
i 66
 
8.1%
t 64
 
7.8%
n 59
 
7.2%
r 55
 
6.7%
s 37
 
4.5%
l 37
 
4.5%
u 32
 
3.9%
Other values (14) 207
25.3%
Uppercase Letter
ValueCountFrequency (%)
A 27
 
8.7%
L 27
 
8.7%
D 26
 
8.4%
S 24
 
7.7%
O 20
 
6.4%
M 17
 
5.5%
F 16
 
5.1%
E 16
 
5.1%
B 15
 
4.8%
H 13
 
4.2%
Other values (14) 110
35.4%
Decimal Number
ValueCountFrequency (%)
1 4
28.6%
2 2
14.3%
3 2
14.3%
4 2
14.3%
9 1
 
7.1%
6 1
 
7.1%
7 1
 
7.1%
0 1
 
7.1%
Other Punctuation
ValueCountFrequency (%)
. 12
44.4%
: 4
 
14.8%
? 3
 
11.1%
' 3
 
11.1%
& 2
 
7.4%
, 2
 
7.4%
/ 1
 
3.7%
Open Punctuation
ValueCountFrequency (%)
( 17
85.0%
[ 3
 
15.0%
Close Punctuation
ValueCountFrequency (%)
) 17
85.0%
] 3
 
15.0%
Other Letter
ValueCountFrequency (%)
轉 1
50.0%
起 1
50.0%
Space Separator
ValueCountFrequency (%)
144
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1130
83.0%
Common 229
 
16.8%
Han 2
 
0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 108
 
9.6%
o 82
 
7.3%
a 72
 
6.4%
i 66
 
5.8%
t 64
 
5.7%
n 59
 
5.2%
r 55
 
4.9%
s 37
 
3.3%
l 37
 
3.3%
u 32
 
2.8%
Other values (38) 518
45.8%
Common
ValueCountFrequency (%)
144
62.9%
( 17
 
7.4%
) 17
 
7.4%
. 12
 
5.2%
: 4
 
1.7%
1 4
 
1.7%
? 3
 
1.3%
] 3
 
1.3%
[ 3
 
1.3%
' 3
 
1.3%
Other values (12) 19
 
8.3%
Han
ValueCountFrequency (%)
轉 1
50.0%
起 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1357
99.7%
Punctuation 2
 
0.1%
CJK 2
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
144
 
10.6%
e 108
 
8.0%
o 82
 
6.0%
a 72
 
5.3%
i 66
 
4.9%
t 64
 
4.7%
n 59
 
4.3%
r 55
 
4.1%
s 37
 
2.7%
l 37
 
2.7%
Other values (59) 633
46.6%
Punctuation
ValueCountFrequency (%)
’ 2
100.0%
CJK
ValueCountFrequency (%)
轉 1
50.0%
起 1
50.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:02:10.704317image/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:02:11.306870image/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_us_2019
100 

Length

Max length22
Median length22
Mean length22
Min length22

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
KC_music_chart_us_2019 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:02:12.394406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
kc_music_chart_us_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:02:12.755272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Interactions

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

Correlations

2023-12-10T19:02:13.082084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Music_NMArtist_NMMusic_RN
Music_NM1.0001.0000.136
Artist_NM1.0001.0000.870
Music_RN0.1360.8701.000
2023-12-10T19:02:13.236953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Music_RNMusic_NM
Music_RN1.0000.000
Music_NM0.0001.000

Missing values

2023-12-10T19:02:07.326032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:02:07.574198image/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-07usYounhaWinter Flower (feat. RM)1KC_music_chart_us_20192019
12020-01-07usATEEZAnswer2KC_music_chart_us_20192019
22020-01-07usATEEZHorizon3KC_music_chart_us_20192019
32020-01-07usRed VelvetPsycho4KC_music_chart_us_20192019
42020-01-07usATEEZPrecious5KC_music_chart_us_20192019
52020-01-07usBTSBoy With Luv (feat. Halsey)6KC_music_chart_us_20192019
62020-01-07usATEEZStar 11177KC_music_chart_us_20192019
72020-01-07usBLACKPINKKill This Love8KC_music_chart_us_20192019
82020-01-07usMAMAMOOHip9KC_music_chart_us_20192019
92020-01-07usBTSMake It Right10KC_music_chart_us_20192019
Survey_Base_Date_DECountry_CDMusic_NMArtist_NMMusic_RNFILE_NAMEBASE_YMD
902020-01-07usBTSMagic Shop91KC_music_chart_us_20192019
912020-01-07usCHUNG HASnapping92KC_music_chart_us_20192019
922020-01-07usSEVENTEENFear93KC_music_chart_us_20192019
932020-01-07usRed VelvetIn & Out94KC_music_chart_us_20192019
942020-01-07usYoonmiraeFlower95KC_music_chart_us_20192019
952020-01-07usTOMORROW X TOGETHERNew Rules96KC_music_chart_us_20192019
962020-01-07usStray KidsAstronaut97KC_music_chart_us_20192019
972020-01-07usBTSDope98KC_music_chart_us_20192019
982020-01-07usEXOMonster99KC_music_chart_us_20192019
992020-01-07usBTSGo Go100KC_music_chart_us_20192019