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 (56.4%)Imbalance
장치 번호 has unique valuesUnique
기록 시각 has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:56:29.260810
Analysis finished2023-12-10 10:56:30.520710
Duration1.26 second
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:30.649003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:30.821324image/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:31.113246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:31.331758image/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:31.718855image/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 row5f86b7a6aadf2274705bd2ca
2nd row5f86b7a6aadf2274705bd2cb
3rd row5f86b7a6aadf2274705bd2cc
4th row5f86b7a6aadf2274705bd2cd
5th row5f86b7a6aadf2274705bd2ce
ValueCountFrequency (%)
5f86b7a6aadf2274705bd2ca 1
 
1.0%
5f86b7a6aadf2274705bd308 1
 
1.0%
5f86b7a6aadf2274705bd313 1
 
1.0%
5f86b7a6aadf2274705bd312 1
 
1.0%
5f86b7a6aadf2274705bd311 1
 
1.0%
5f86b7a6aadf2274705bd310 1
 
1.0%
5f86b7a6aadf2274705bd30f 1
 
1.0%
5f86b7a6aadf2274705bd30e 1
 
1.0%
5f86b7a6aadf2274705bd30d 1
 
1.0%
5f86b7a6aadf2274705bd30c 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T19:56:32.391211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
a 307
12.8%
7 306
12.8%
2 274
11.4%
d 223
9.3%
f 222
9.2%
b 207
8.6%
5 206
8.6%
6 206
8.6%
0 122
 
5.1%
8 106
 
4.4%
Other values (6) 221
9.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1406
58.6%
Lowercase Letter 994
41.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 306
21.8%
2 274
19.5%
5 206
14.7%
6 206
14.7%
0 122
 
8.7%
8 106
 
7.5%
4 106
 
7.5%
3 52
 
3.7%
1 22
 
1.6%
9 6
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
a 307
30.9%
d 223
22.4%
f 222
22.3%
b 207
20.8%
e 22
 
2.2%
c 13
 
1.3%

Most occurring scripts

ValueCountFrequency (%)
Common 1406
58.6%
Latin 994
41.4%

Most frequent character per script

Common
ValueCountFrequency (%)
7 306
21.8%
2 274
19.5%
5 206
14.7%
6 206
14.7%
0 122
 
8.7%
8 106
 
7.5%
4 106
 
7.5%
3 52
 
3.7%
1 22
 
1.6%
9 6
 
0.4%
Latin
ValueCountFrequency (%)
a 307
30.9%
d 223
22.4%
f 222
22.3%
b 207
20.8%
e 22
 
2.2%
c 13
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 307
12.8%
7 306
12.8%
2 274
11.4%
d 223
9.3%
f 222
9.2%
b 207
8.6%
5 206
8.6%
6 206
8.6%
0 122
 
5.1%
8 106
 
4.4%
Other values (6) 221
9.2%

기록 시각
Text

UNIQUE 

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

Length

Max length56
Median length56
Mean length56
Min length56

Characters and Unicode

Total characters5600
Distinct characters31
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 rowTue Sep 01 2020 00:00:04 GMT+0900 (Korean Standard Time)
2nd rowTue Sep 01 2020 00:00:14 GMT+0900 (Korean Standard Time)
3rd rowTue Sep 01 2020 00:00:24 GMT+0900 (Korean Standard Time)
4th rowTue Sep 01 2020 00:00:34 GMT+0900 (Korean Standard Time)
5th rowTue Sep 01 2020 00:00:44 GMT+0900 (Korean Standard Time)
ValueCountFrequency (%)
tue 100
11.1%
gmt+0900 100
11.1%
time 100
11.1%
standard 100
11.1%
korean 100
11.1%
sep 100
11.1%
2020 100
11.1%
01 100
11.1%
00:13:54 1
 
0.1%
00:00:14 1
 
0.1%
Other values (98) 98
10.9%
2023-12-10T19:56:33.888964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 879
15.7%
800
14.3%
e 400
 
7.1%
T 300
 
5.4%
a 300
 
5.4%
2 224
 
4.0%
S 200
 
3.6%
r 200
 
3.6%
d 200
 
3.6%
n 200
 
3.6%
Other values (21) 1897
33.9%

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%
Open Punctuation 100
 
1.8%
Math Symbol 100
 
1.8%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 400
21.1%
a 300
15.8%
r 200
10.5%
d 200
10.5%
n 200
10.5%
m 100
 
5.3%
i 100
 
5.3%
t 100
 
5.3%
o 100
 
5.3%
u 100
 
5.3%
Decimal Number
ValueCountFrequency (%)
0 879
54.9%
2 224
 
14.0%
1 180
 
11.2%
4 128
 
8.0%
9 106
 
6.6%
5 28
 
1.8%
3 22
 
1.4%
6 12
 
0.8%
7 12
 
0.8%
8 9
 
0.6%
Uppercase Letter
ValueCountFrequency (%)
T 300
37.5%
S 200
25.0%
K 100
 
12.5%
M 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%
Open Punctuation
ValueCountFrequency (%)
( 100
100.0%
Math Symbol
ValueCountFrequency (%)
+ 100
100.0%

Most occurring scripts

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

Most frequent character per script

Latin
ValueCountFrequency (%)
e 400
14.8%
T 300
11.1%
a 300
11.1%
S 200
 
7.4%
r 200
 
7.4%
d 200
 
7.4%
n 200
 
7.4%
m 100
 
3.7%
i 100
 
3.7%
t 100
 
3.7%
Other values (6) 600
22.2%
Common
ValueCountFrequency (%)
0 879
30.3%
800
27.6%
2 224
 
7.7%
: 200
 
6.9%
1 180
 
6.2%
4 128
 
4.4%
9 106
 
3.7%
) 100
 
3.4%
( 100
 
3.4%
+ 100
 
3.4%
Other values (5) 83
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5600
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 879
15.7%
800
14.3%
e 400
 
7.1%
T 300
 
5.4%
a 300
 
5.4%
2 224
 
4.0%
S 200
 
3.6%
r 200
 
3.6%
d 200
 
3.6%
n 200
 
3.6%
Other values (21) 1897
33.9%

전원 여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
False
91 
True
 
9
ValueCountFrequency (%)
False 91
91.0%
True 9
 
9.0%
2023-12-10T19:56:34.121535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:56:34.267862image/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:30.240278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:56:30.416222image/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-2ef43250f0b65f86b7a6aadf2274705bd2caTue Sep 01 2020 00:00:04 GMT+0900 (Korean Standard Time)False
15efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2cbTue Sep 01 2020 00:00:14 GMT+0900 (Korean Standard Time)False
25efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2ccTue Sep 01 2020 00:00:24 GMT+0900 (Korean Standard Time)False
35efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2cdTue Sep 01 2020 00:00:34 GMT+0900 (Korean Standard Time)False
45efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2ceTue Sep 01 2020 00:00:44 GMT+0900 (Korean Standard Time)False
55efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2cfTue Sep 01 2020 00:00:54 GMT+0900 (Korean Standard Time)False
65efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2d0Tue Sep 01 2020 00:01:04 GMT+0900 (Korean Standard Time)False
75efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2d1Tue Sep 01 2020 00:01:14 GMT+0900 (Korean Standard Time)False
85efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2d2Tue Sep 01 2020 00:01:24 GMT+0900 (Korean Standard Time)False
95efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd2d3Tue Sep 01 2020 00:01:34 GMT+0900 (Korean Standard Time)False
로그 아이디장치 아이디장치 번호기록 시각전원 여부
905efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd324Tue Sep 01 2020 00:16:54 GMT+0900 (Korean Standard Time)False
915efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd325Tue Sep 01 2020 00:17:04 GMT+0900 (Korean Standard Time)False
925efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd326Tue Sep 01 2020 00:17:14 GMT+0900 (Korean Standard Time)False
935efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd327Tue Sep 01 2020 00:17:24 GMT+0900 (Korean Standard Time)False
945efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd328Tue Sep 01 2020 00:17:34 GMT+0900 (Korean Standard Time)False
955efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd329Tue Sep 01 2020 00:17:44 GMT+0900 (Korean Standard Time)True
965efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd32aTue Sep 01 2020 00:17:54 GMT+0900 (Korean Standard Time)False
975efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd32bTue Sep 01 2020 00:18:04 GMT+0900 (Korean Standard Time)False
985efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd32cTue Sep 01 2020 00:18:14 GMT+0900 (Korean Standard Time)False
995efd36a629af7dd94c0a6392Dawon-B540-2ef43250f0b65f86b7a6aadf2274705bd32dTue Sep 01 2020 00:18:24 GMT+0900 (Korean Standard Time)False