Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.1 KiB
Average record size in memory52.3 B

Variable types

Text2
Categorical1
Numeric3

Alerts

기록 시각 has constant value ""Constant
로그 아이디 has unique valuesUnique
건물 아이디 has unique valuesUnique

Reproduction

Analysis started2023-12-10 11:13:54.729156
Analysis finished2023-12-10 11:13:56.948732
Duration2.22 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

로그 아이디
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T20:13:57.215981image/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 row612e4402f0c312001395700d
2nd row612e4402f0c312001395700e
3rd row612e4402f0c312001395700f
4th row612e4402f0c3120013957010
5th row612e4402f0c3120013957011
ValueCountFrequency (%)
612e4402f0c312001395700d 1
 
1.0%
612e4402f0c312001395704c 1
 
1.0%
612e4402f0c3120013957057 1
 
1.0%
612e4402f0c3120013957056 1
 
1.0%
612e4402f0c3120013957055 1
 
1.0%
612e4402f0c3120013957054 1
 
1.0%
612e4402f0c3120013957053 1
 
1.0%
612e4402f0c3120013957052 1
 
1.0%
612e4402f0c3120013957051 1
 
1.0%
612e4402f0c3120013957050 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T20:13:57.859291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 510
21.2%
1 323
13.5%
2 321
13.4%
4 222
9.2%
3 222
9.2%
6 122
 
5.1%
5 122
 
5.1%
7 108
 
4.5%
e 107
 
4.5%
f 107
 
4.5%
Other values (6) 236
9.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2062
85.9%
Lowercase Letter 338
 
14.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 510
24.7%
1 323
15.7%
2 321
15.6%
4 222
10.8%
3 222
10.8%
6 122
 
5.9%
5 122
 
5.9%
7 108
 
5.2%
9 106
 
5.1%
8 6
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
e 107
31.7%
f 107
31.7%
c 106
31.4%
d 7
 
2.1%
b 6
 
1.8%
a 5
 
1.5%

Most occurring scripts

ValueCountFrequency (%)
Common 2062
85.9%
Latin 338
 
14.1%

Most frequent character per script

Common
ValueCountFrequency (%)
0 510
24.7%
1 323
15.7%
2 321
15.6%
4 222
10.8%
3 222
10.8%
6 122
 
5.9%
5 122
 
5.9%
7 108
 
5.2%
9 106
 
5.1%
8 6
 
0.3%
Latin
ValueCountFrequency (%)
e 107
31.7%
f 107
31.7%
c 106
31.4%
d 7
 
2.1%
b 6
 
1.8%
a 5
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 510
21.2%
1 323
13.5%
2 321
13.4%
4 222
9.2%
3 222
9.2%
6 122
 
5.1%
5 122
 
5.1%
7 108
 
4.5%
e 107
 
4.5%
f 107
 
4.5%
Other values (6) 236
9.8%

건물 아이디
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T20:13:58.260557image/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 row5f8d465df61d2e318b09fcf5
2nd row5f06a30c153b58ec1eb3ea35
3rd row5f06a21a153b58ec1eb3ea2d
4th row5f06a427153b58ec1eb3ea41
5th row5f06a5d8153b58ec1eb3ea55
ValueCountFrequency (%)
5f8d465df61d2e318b09fcf5 1
 
1.0%
5fe0dc75bd7e0e14d572ac47 1
 
1.0%
5ffea37bb25c2071dcef5e22 1
 
1.0%
60056c64909d6d64d11626be 1
 
1.0%
5ffea3abb25c2071dcef6036 1
 
1.0%
608bc77831eca70f778cf055 1
 
1.0%
5ffea525b25c2071dcef7049 1
 
1.0%
6049cbd2138958233d84b949 1
 
1.0%
5ffc1757e0a2b843dc462671 1
 
1.0%
5ffe6c99b25c2071dced112f 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T20:13:59.182894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 277
11.5%
e 233
 
9.7%
1 186
 
7.8%
f 185
 
7.7%
b 179
 
7.5%
3 171
 
7.1%
0 151
 
6.3%
6 143
 
6.0%
a 143
 
6.0%
c 140
 
5.8%
Other values (6) 592
24.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1438
59.9%
Lowercase Letter 962
40.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 277
19.3%
1 186
12.9%
3 171
11.9%
0 151
10.5%
6 143
9.9%
8 123
8.6%
2 111
7.7%
7 109
 
7.6%
4 88
 
6.1%
9 79
 
5.5%
Lowercase Letter
ValueCountFrequency (%)
e 233
24.2%
f 185
19.2%
b 179
18.6%
a 143
14.9%
c 140
14.6%
d 82
 
8.5%

Most occurring scripts

ValueCountFrequency (%)
Common 1438
59.9%
Latin 962
40.1%

Most frequent character per script

Common
ValueCountFrequency (%)
5 277
19.3%
1 186
12.9%
3 171
11.9%
0 151
10.5%
6 143
9.9%
8 123
8.6%
2 111
7.7%
7 109
 
7.6%
4 88
 
6.1%
9 79
 
5.5%
Latin
ValueCountFrequency (%)
e 233
24.2%
f 185
19.2%
b 179
18.6%
a 143
14.9%
c 140
14.6%
d 82
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2400
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 277
11.5%
e 233
 
9.7%
1 186
 
7.8%
f 185
 
7.7%
b 179
 
7.5%
3 171
 
7.1%
0 151
 
6.3%
6 143
 
6.0%
a 143
 
6.0%
c 140
 
5.8%
Other values (6) 592
24.7%

기록 시각
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)
100 

Length

Max length56
Median length56
Mean length56
Min length56

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)
2nd rowWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)
3rd rowWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)
4th rowWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)
5th rowWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)

Common Values

ValueCountFrequency (%)
Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time) 100
100.0%

Length

2023-12-10T20:13:59.449623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:13:59.688546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
wed 100
11.1%
sep 100
11.1%
01 100
11.1%
2021 100
11.1%
00:00:15 100
11.1%
gmt+0900 100
11.1%
korean 100
11.1%
standard 100
11.1%
time 100
11.1%

온도(℃)
Real number (ℝ)

Distinct14
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.018
Minimum17.7
Maximum22.7
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:13:59.880220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum17.7
5-th percentile18.2
Q118.4
median18.8
Q319.1
95-th percentile22.7
Maximum22.7
Range5
Interquartile range (IQR)0.7

Descriptive statistics

Standard deviation1.046242
Coefficient of variation (CV)0.055013248
Kurtosis6.9863793
Mean19.018
Median Absolute Deviation (MAD)0.4
Skewness2.6052611
Sum1901.8
Variance1.0946222
MonotonicityNot monotonic
2023-12-10T20:14:00.096316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
18.8 22
22.0%
18.4 16
16.0%
18.2 13
13.0%
19.1 13
13.0%
19.3 10
10.0%
18.9 6
 
6.0%
22.7 6
 
6.0%
18.6 4
 
4.0%
19.4 3
 
3.0%
17.9 2
 
2.0%
Other values (4) 5
 
5.0%
ValueCountFrequency (%)
17.7 1
 
1.0%
17.9 2
 
2.0%
18.2 13
13.0%
18.4 16
16.0%
18.6 4
 
4.0%
18.8 22
22.0%
18.9 6
 
6.0%
19.1 13
13.0%
19.3 10
10.0%
19.4 3
 
3.0%
ValueCountFrequency (%)
22.7 6
 
6.0%
20.4 2
 
2.0%
19.9 1
 
1.0%
19.5 1
 
1.0%
19.4 3
 
3.0%
19.3 10
10.0%
19.1 13
13.0%
18.9 6
 
6.0%
18.8 22
22.0%
18.6 4
 
4.0%

습도(%)
Real number (ℝ)

Distinct10
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean96.91
Minimum91
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:14:00.278315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum91
5-th percentile91
Q195.75
median97
Q3100
95-th percentile100
Maximum100
Range9
Interquartile range (IQR)4.25

Descriptive statistics

Standard deviation2.8287664
Coefficient of variation (CV)0.029189623
Kurtosis-0.60170982
Mean96.91
Median Absolute Deviation (MAD)2.5
Skewness-0.62521494
Sum9691
Variance8.0019192
MonotonicityNot monotonic
2023-12-10T20:14:00.455757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
100 30
30.0%
96 17
17.0%
98 15
15.0%
97 10
 
10.0%
91 7
 
7.0%
93 6
 
6.0%
95 5
 
5.0%
94 4
 
4.0%
92 3
 
3.0%
99 3
 
3.0%
ValueCountFrequency (%)
91 7
 
7.0%
92 3
 
3.0%
93 6
 
6.0%
94 4
 
4.0%
95 5
 
5.0%
96 17
17.0%
97 10
 
10.0%
98 15
15.0%
99 3
 
3.0%
100 30
30.0%
ValueCountFrequency (%)
100 30
30.0%
99 3
 
3.0%
98 15
15.0%
97 10
 
10.0%
96 17
17.0%
95 5
 
5.0%
94 4
 
4.0%
93 6
 
6.0%
92 3
 
3.0%
91 7
 
7.0%

초미세먼지
Real number (ℝ)

Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.69
Minimum5
Maximum61
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:14:00.663611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile9
Q113
median21
Q326.25
95-th percentile53.1
Maximum61
Range56
Interquartile range (IQR)13.25

Descriptive statistics

Standard deviation12.919092
Coefficient of variation (CV)0.54533945
Kurtosis1.4748876
Mean23.69
Median Absolute Deviation (MAD)8
Skewness1.3755244
Sum2369
Variance166.90293
MonotonicityNot monotonic
2023-12-10T20:14:00.861322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
13 25
25.0%
25 19
19.0%
17 13
13.0%
21 12
12.0%
30 10
 
10.0%
46 6
 
6.0%
9 5
 
5.0%
61 4
 
4.0%
38 2
 
2.0%
5 1
 
1.0%
Other values (3) 3
 
3.0%
ValueCountFrequency (%)
5 1
 
1.0%
9 5
 
5.0%
13 25
25.0%
17 13
13.0%
21 12
12.0%
25 19
19.0%
30 10
 
10.0%
38 2
 
2.0%
42 1
 
1.0%
46 6
 
6.0%
ValueCountFrequency (%)
61 4
 
4.0%
55 1
 
1.0%
53 1
 
1.0%
46 6
 
6.0%
42 1
 
1.0%
38 2
 
2.0%
30 10
10.0%
25 19
19.0%
21 12
12.0%
17 13
13.0%

Interactions

2023-12-10T20:13:56.178020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:55.161355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:55.585468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:56.323233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:55.293039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:55.732806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:56.466390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:55.440425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:13:55.865319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T20:14:01.011249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그 아이디건물 아이디온도(℃)습도(%)초미세먼지
로그 아이디1.0001.0001.0001.0001.000
건물 아이디1.0001.0001.0001.0001.000
온도(℃)1.0001.0001.0000.8120.705
습도(%)1.0001.0000.8121.0000.903
초미세먼지1.0001.0000.7050.9031.000
2023-12-10T20:14:01.180409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도(℃)습도(%)초미세먼지
온도(℃)1.0000.357-0.141
습도(%)0.3571.000-0.325
초미세먼지-0.141-0.3251.000

Missing values

2023-12-10T20:13:56.646869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:13:56.843322image/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

로그 아이디건물 아이디기록 시각온도(℃)습도(%)초미세먼지
0612e4402f0c312001395700d5f8d465df61d2e318b09fcf5Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.610025
1612e4402f0c312001395700e5f06a30c153b58ec1eb3ea35Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)19.310013
2612e4402f0c312001395700f5f06a21a153b58ec1eb3ea2dWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.89617
3612e4402f0c31200139570105f06a427153b58ec1eb3ea41Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.99338
4612e4402f0c31200139570115f06a5d8153b58ec1eb3ea55Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)19.410013
5612e4402f0c31200139570125f069fed153b58ec1eb3ea1bWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.2989
6612e4402f0c31200139570135f06a658153b58ec1eb3ea59Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)19.310013
7612e4402f0c31200139570145f06a446153b58ec1eb3ea43Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.49113
8612e4402f0c31200139570155f06a3e8153b58ec1eb3ea3dWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.89617
9612e4402f0c31200139570165f06a24e153b58ec1eb3ea2fWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)17.99230
로그 아이디건물 아이디기록 시각온도(℃)습도(%)초미세먼지
90612e4402f0c312001395706860ee6fc6b563352c84991f7fWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)22.79761
91612e4402f0c31200139570695f06a627153b58ec1eb3ea57Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)19.410017
92612e4402f0c312001395706a600e4d9a871aeb705049561eWed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.8999
93612e4402f0c312001395706b5ffeaa06b25c2071dcefa4b8Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.49821
94612e4402f0c312001395706c60ee7060b563352c84991f81Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)22.79761
95612e4402f0c312001395706d60ee72c8b563352c849921e2Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)22.79761
96612e4402f0c312001395706e60ee70edb563352c84991f82Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)22.79753
97612e4402f0c312001395706f6080f46544b0f006fe65ad19Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)19.310013
98612e4402f0c31200139570705ffea500b25c2071dcef6ea0Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)18.29846
99612e4402f0c31200139570715f06c71f153b58ec1eb3eb56Wed Sep 01 2021 00:00:15 GMT+0900 (Korean Standard Time)19.310013