Overview

Dataset statistics

Number of variables5
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 memory35.3 B

Variable types

Categorical2
Text2
Boolean1

Alerts

로그 아이디 has constant value ""Constant
장치 아이디 has constant value ""Constant
전원 여부 is highly imbalanced (59.8%)Imbalance
장치 번호 has unique valuesUnique
기록 시각 has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:56:35.561393
Analysis finished2023-12-10 10:56:36.140388
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

로그 아이디
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
5efd36a629af7dd94c0a6392 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:56:36.474526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5efd36a629af7dd94c0a6392 100
100.0%

장치 아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Dawon-B540-2ef43250f0b6
100 

Length

Max length23
Median length23
Mean length23
Min length23

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDawon-B540-2ef43250f0b6
2nd rowDawon-B540-2ef43250f0b6
3rd rowDawon-B540-2ef43250f0b6
4th rowDawon-B540-2ef43250f0b6
5th rowDawon-B540-2ef43250f0b6

Common Values

ValueCountFrequency (%)
Dawon-B540-2ef43250f0b6 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T19:56:36.971640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
dawon-b540-2ef43250f0b6 100
100.0%

장치 번호
Text

UNIQUE 

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

Length

Max length24
Median length24
Mean length24
Min length24

Characters and Unicode

Total characters2400
Distinct characters16
Distinct categories2 ?
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 row5f869246e5c454655cad6612
2nd row5f869246e5c454655cad6613
3rd row5f869246e5c454655cad6614
4th row5f869246e5c454655cad6615
5th row5f869246e5c454655cad6616
ValueCountFrequency (%)
5f869246e5c454655cad6612 1
 
1.0%
5f869246e5c454655cad6650 1
 
1.0%
5f869246e5c454655cad665b 1
 
1.0%
5f869246e5c454655cad665a 1
 
1.0%
5f869246e5c454655cad6659 1
 
1.0%
5f869246e5c454655cad6658 1
 
1.0%
5f869246e5c454655cad6657 1
 
1.0%
5f869246e5c454655cad6656 1
 
1.0%
5f869246e5c454655cad6655 1
 
1.0%
5f869246e5c454655cad6654 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T19:56:37.916171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 523
21.8%
6 522
21.8%
4 323
13.5%
c 206
 
8.6%
2 123
 
5.1%
f 106
 
4.4%
8 106
 
4.4%
9 106
 
4.4%
e 106
 
4.4%
a 106
 
4.4%
Other values (6) 173
 
7.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1764
73.5%
Lowercase Letter 636
 
26.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 523
29.6%
6 522
29.6%
4 323
18.3%
2 123
 
7.0%
8 106
 
6.0%
9 106
 
6.0%
3 23
 
1.3%
1 20
 
1.1%
7 12
 
0.7%
0 6
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
c 206
32.4%
f 106
16.7%
e 106
16.7%
a 106
16.7%
d 106
16.7%
b 6
 
0.9%

Most occurring scripts

ValueCountFrequency (%)
Common 1764
73.5%
Latin 636
 
26.5%

Most frequent character per script

Common
ValueCountFrequency (%)
5 523
29.6%
6 522
29.6%
4 323
18.3%
2 123
 
7.0%
8 106
 
6.0%
9 106
 
6.0%
3 23
 
1.3%
1 20
 
1.1%
7 12
 
0.7%
0 6
 
0.3%
Latin
ValueCountFrequency (%)
c 206
32.4%
f 106
16.7%
e 106
16.7%
a 106
16.7%
d 106
16.7%
b 6
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 523
21.8%
6 522
21.8%
4 323
13.5%
c 206
 
8.6%
2 123
 
5.1%
f 106
 
4.4%
8 106
 
4.4%
9 106
 
4.4%
e 106
 
4.4%
a 106
 
4.4%
Other values (6) 173
 
7.2%

기록 시각
Text

UNIQUE 

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

Length

Max length56
Median length56
Mean length56
Min length56

Characters and Unicode

Total characters5600
Distinct characters32
Distinct categories8 ?
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 rowSat Aug 01 2020 00:00:07 GMT+0900 (Korean Standard Time)
2nd rowSat Aug 01 2020 00:00:17 GMT+0900 (Korean Standard Time)
3rd rowSat Aug 01 2020 00:01:07 GMT+0900 (Korean Standard Time)
4th rowSat Aug 01 2020 00:01:17 GMT+0900 (Korean Standard Time)
5th rowSat Aug 01 2020 00:01:27 GMT+0900 (Korean Standard Time)
ValueCountFrequency (%)
sat 100
11.1%
gmt+0900 100
11.1%
time 100
11.1%
standard 100
11.1%
korean 100
11.1%
aug 100
11.1%
2020 100
11.1%
01 100
11.1%
00:25:37 1
 
0.1%
00:00:17 1
 
0.1%
Other values (98) 98
10.9%
2023-12-10T19:56:39.372977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 857
15.3%
800
 
14.3%
a 400
 
7.1%
2 255
 
4.6%
S 200
 
3.6%
T 200
 
3.6%
t 200
 
3.6%
d 200
 
3.6%
n 200
 
3.6%
e 200
 
3.6%
Other values (22) 2088
37.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1900
33.9%
Decimal Number 1600
28.6%
Space Separator 800
14.3%
Uppercase Letter 800
14.3%
Other Punctuation 200
 
3.6%
Close Punctuation 100
 
1.8%
Math Symbol 100
 
1.8%
Open Punctuation 100
 
1.8%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 400
21.1%
t 200
10.5%
d 200
10.5%
n 200
10.5%
e 200
10.5%
r 200
10.5%
u 100
 
5.3%
m 100
 
5.3%
i 100
 
5.3%
g 100
 
5.3%
Decimal Number
ValueCountFrequency (%)
0 857
53.6%
2 255
 
15.9%
1 151
 
9.4%
9 108
 
6.8%
7 108
 
6.8%
3 42
 
2.6%
5 32
 
2.0%
4 31
 
1.9%
8 10
 
0.6%
6 6
 
0.4%
Uppercase Letter
ValueCountFrequency (%)
S 200
25.0%
T 200
25.0%
M 100
12.5%
A 100
12.5%
K 100
12.5%
G 100
12.5%
Space Separator
ValueCountFrequency (%)
800
100.0%
Other Punctuation
ValueCountFrequency (%)
: 200
100.0%
Close Punctuation
ValueCountFrequency (%)
) 100
100.0%
Math Symbol
ValueCountFrequency (%)
+ 100
100.0%
Open Punctuation
ValueCountFrequency (%)
( 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2900
51.8%
Latin 2700
48.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 400
14.8%
S 200
 
7.4%
T 200
 
7.4%
t 200
 
7.4%
d 200
 
7.4%
n 200
 
7.4%
e 200
 
7.4%
r 200
 
7.4%
M 100
 
3.7%
u 100
 
3.7%
Other values (7) 700
25.9%
Common
ValueCountFrequency (%)
0 857
29.6%
800
27.6%
2 255
 
8.8%
: 200
 
6.9%
1 151
 
5.2%
9 108
 
3.7%
7 108
 
3.7%
) 100
 
3.4%
+ 100
 
3.4%
( 100
 
3.4%
Other values (5) 121
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5600
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 857
15.3%
800
 
14.3%
a 400
 
7.1%
2 255
 
4.6%
S 200
 
3.6%
T 200
 
3.6%
t 200
 
3.6%
d 200
 
3.6%
n 200
 
3.6%
e 200
 
3.6%
Other values (22) 2088
37.3%

전원 여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
False
92 
True
 
8
ValueCountFrequency (%)
False 92
92.0%
True 8
 
8.0%
2023-12-10T19:56:39.607070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:56:39.715082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
장치 번호기록 시각전원 여부
장치 번호1.0001.0001.000
기록 시각1.0001.0001.000
전원 여부1.0001.0001.000

Missing values

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

로그 아이디장치 아이디장치 번호기록 시각전원 여부
05efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6612Sat Aug 01 2020 00:00:07 GMT+0900 (Korean Standard Time)False
15efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6613Sat Aug 01 2020 00:00:17 GMT+0900 (Korean Standard Time)False
25efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6614Sat Aug 01 2020 00:01:07 GMT+0900 (Korean Standard Time)True
35efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6615Sat Aug 01 2020 00:01:17 GMT+0900 (Korean Standard Time)False
45efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6616Sat Aug 01 2020 00:01:27 GMT+0900 (Korean Standard Time)True
55efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6617Sat Aug 01 2020 00:01:37 GMT+0900 (Korean Standard Time)False
65efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6618Sat Aug 01 2020 00:02:27 GMT+0900 (Korean Standard Time)False
75efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6619Sat Aug 01 2020 00:02:37 GMT+0900 (Korean Standard Time)False
85efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad661aSat Aug 01 2020 00:02:47 GMT+0900 (Korean Standard Time)False
95efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad661bSat Aug 01 2020 00:02:57 GMT+0900 (Korean Standard Time)False
로그 아이디장치 아이디장치 번호기록 시각전원 여부
905efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad666cSat Aug 01 2020 00:31:37 GMT+0900 (Korean Standard Time)False
915efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad666dSat Aug 01 2020 00:32:27 GMT+0900 (Korean Standard Time)False
925efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad666eSat Aug 01 2020 00:32:37 GMT+0900 (Korean Standard Time)False
935efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad666fSat Aug 01 2020 00:33:07 GMT+0900 (Korean Standard Time)False
945efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6670Sat Aug 01 2020 00:33:17 GMT+0900 (Korean Standard Time)False
955efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6671Sat Aug 01 2020 00:33:27 GMT+0900 (Korean Standard Time)False
965efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6672Sat Aug 01 2020 00:33:37 GMT+0900 (Korean Standard Time)False
975efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6673Sat Aug 01 2020 00:33:47 GMT+0900 (Korean Standard Time)False
985efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6674Sat Aug 01 2020 00:34:27 GMT+0900 (Korean Standard Time)False
995efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f869246e5c454655cad6675Sat Aug 01 2020 00:34:37 GMT+0900 (Korean Standard Time)False