Overview

Dataset statistics

Number of variables10
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.8 KiB
Average record size in memory90.3 B

Variable types

Numeric2
Categorical7
DateTime1

Alerts

노드 아이디 has constant value ""Constant
co 측정값 has constant value ""Constant
PM10 측정값 is highly overall correlated with 시퀀스 and 5 other fieldsHigh correlation
온도 is highly overall correlated with 시퀀스 and 4 other fieldsHigh correlation
시퀀스 is highly overall correlated with co2 측정값 and 5 other fieldsHigh correlation
co2 측정값 is highly overall correlated with 시퀀스 and 5 other fieldsHigh correlation
PM1.0 측정값 is highly overall correlated with 시퀀스 and 3 other fieldsHigh correlation
PM2.5 측정값 is highly overall correlated with 시퀀스 and 5 other fieldsHigh correlation
습도 is highly overall correlated with 시퀀스 and 4 other fieldsHigh correlation
시퀀스 has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:31:58.554851
Analysis finished2023-12-10 13:32:00.189546
Duration1.63 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시퀀스
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33949512
Minimum33942896
Maximum33956170
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:32:00.322003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum33942896
5-th percentile33943320
Q133946578
median33949705
Q333952999
95-th percentile33954959
Maximum33956170
Range13274
Interquartile range (IQR)6421

Descriptive statistics

Standard deviation3885.4651
Coefficient of variation (CV)0.00011444833
Kurtosis-1.2230527
Mean33949512
Median Absolute Deviation (MAD)3234
Skewness-0.11616739
Sum3.3949512 × 109
Variance15096839
MonotonicityStrictly increasing
2023-12-10T22:32:00.544175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
33942896 1
 
1.0%
33951861 1
 
1.0%
33952976 1
 
1.0%
33952884 1
 
1.0%
33952791 1
 
1.0%
33952698 1
 
1.0%
33952585 1
 
1.0%
33952486 1
 
1.0%
33952377 1
 
1.0%
33952253 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
33942896 1
1.0%
33942952 1
1.0%
33943034 1
1.0%
33943145 1
1.0%
33943239 1
1.0%
33943324 1
1.0%
33943403 1
1.0%
33943517 1
1.0%
33943613 1
1.0%
33943696 1
1.0%
ValueCountFrequency (%)
33956170 1
1.0%
33955970 1
1.0%
33955707 1
1.0%
33955498 1
1.0%
33955218 1
1.0%
33954945 1
1.0%
33954746 1
1.0%
33954655 1
1.0%
33954561 1
1.0%
33954467 1
1.0%

노드 아이디
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201101 100
100.0%

Length

2023-12-10T22:32:00.744636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:00.872160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201101 100
100.0%

co 측정값
Categorical

CONSTANT 

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

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0.3000000119
2nd row0.3000000119
3rd row0.3000000119
4th row0.3000000119
5th row0.3000000119

Common Values

ValueCountFrequency (%)
0.3000000119 100
100.0%

Length

2023-12-10T22:32:01.003409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:01.131027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.3000000119 100
100.0%

co2 측정값
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean424.82
Minimum419
Maximum430
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:32:01.257725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum419
5-th percentile419
Q1421
median426
Q3429
95-th percentile430
Maximum430
Range11
Interquartile range (IQR)8

Descriptive statistics

Standard deviation4.2244598
Coefficient of variation (CV)0.009944117
Kurtosis-1.6286661
Mean424.82
Median Absolute Deviation (MAD)4
Skewness-0.085225307
Sum42482
Variance17.846061
MonotonicityNot monotonic
2023-12-10T22:32:01.421715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
430 19
19.0%
426 18
18.0%
429 18
18.0%
419 16
16.0%
422 15
15.0%
421 8
8.0%
420 6
 
6.0%
ValueCountFrequency (%)
419 16
16.0%
420 6
 
6.0%
421 8
8.0%
422 15
15.0%
426 18
18.0%
429 18
18.0%
430 19
19.0%
ValueCountFrequency (%)
430 19
19.0%
429 18
18.0%
426 18
18.0%
422 15
15.0%
421 8
8.0%
420 6
 
6.0%
419 16
16.0%

PM1.0 측정값
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
13
68 
11
26 
12
 
6

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
13 68
68.0%
11 26
 
26.0%
12 6
 
6.0%

Length

2023-12-10T22:32:01.600340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:01.755797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
13 68
68.0%
11 26
 
26.0%
12 6
 
6.0%

PM2.5 측정값
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
16
49 
17
25 
15
18 
14
8 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
16 49
49.0%
17 25
25.0%
15 18
 
18.0%
14 8
 
8.0%

Length

2023-12-10T22:32:01.991709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:02.152606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
16 49
49.0%
17 25
25.0%
15 18
 
18.0%
14 8
 
8.0%

PM10 측정값
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
18
37 
15
26 
17
19 
16
18 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
18 37
37.0%
15 26
26.0%
17 19
19.0%
16 18
18.0%

Length

2023-12-10T22:32:02.335853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:02.463393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
18 37
37.0%
15 26
26.0%
17 19
19.0%
16 18
18.0%

온도
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
25.200000763
81 
25.299999237
19 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row25.200000763
2nd row25.200000763
3rd row25.200000763
4th row25.200000763
5th row25.200000763

Common Values

ValueCountFrequency (%)
25.200000763 81
81.0%
25.299999237 19
 
19.0%

Length

2023-12-10T22:32:02.616091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:02.771640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
25.200000763 81
81.0%
25.299999237 19
 
19.0%

습도
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
40.0
73 
39.900001526
27 

Length

Max length12
Median length4
Mean length6.16
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row39.900001526
2nd row39.900001526
3rd row39.900001526
4th row39.900001526
5th row39.900001526

Common Values

ValueCountFrequency (%)
40.0 73
73.0%
39.900001526 27
 
27.0%

Length

2023-12-10T22:32:02.974933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:32:03.163370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
40.0 73
73.0%
39.900001526 27
 
27.0%

기록 시간
Date

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2022-05-11 17:35:59
Maximum2022-05-11 17:39:16
2023-12-10T22:32:03.327790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:32:03.585485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-10T22:31:59.511313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:31:59.066629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:31:59.653719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:31:59.306343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:32:03.792229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시퀀스co2 측정값PM1.0 측정값PM2.5 측정값PM10 측정값온도습도기록 시간
시퀀스1.0000.9930.9280.9270.9350.9490.9971.000
co2 측정값0.9931.0001.0000.8840.8340.4800.5671.000
PM1.0 측정값0.9281.0001.0000.7170.6930.1850.0401.000
PM2.5 측정값0.9270.8840.7171.0000.9640.9660.9801.000
PM10 측정값0.9350.8340.6930.9641.0001.0000.9701.000
온도0.9490.4800.1850.9661.0001.0000.9331.000
습도0.9970.5670.0400.9800.9700.9331.0001.000
기록 시간1.0001.0001.0001.0001.0001.0001.0001.000
2023-12-10T22:32:03.985211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
PM1.0 측정값PM10 측정값온도습도PM2.5 측정값
PM1.0 측정값1.0000.7240.3020.0650.753
PM10 측정값0.7241.0000.9900.8340.743
온도0.3020.9901.0000.7650.825
습도0.0650.8340.7651.0000.864
PM2.5 측정값0.7530.7430.8250.8641.000
2023-12-10T22:32:04.163415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시퀀스co2 측정값PM1.0 측정값PM2.5 측정값PM10 측정값온도습도
시퀀스1.000-0.5510.8690.8100.8180.7670.915
co2 측정값-0.5511.0000.7590.8410.8040.6020.704
PM1.0 측정값0.8690.7591.0000.7530.7240.3020.065
PM2.5 측정값0.8100.8410.7531.0000.7430.8250.864
PM10 측정값0.8180.8040.7240.7431.0000.9900.834
온도0.7670.6020.3020.8250.9901.0000.765
습도0.9150.7040.0650.8640.8340.7651.000

Missing values

2023-12-10T22:31:59.847068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:32:00.105904image/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

시퀀스노드 아이디co 측정값co2 측정값PM1.0 측정값PM2.5 측정값PM10 측정값온도습도기록 시간
0339428962011010.342111141525.20000139.9000022022-05-11 17:35:59
1339429522011010.342111141525.20000139.9000022022-05-11 17:36:01
2339430342011010.342111141525.20000139.9000022022-05-11 17:36:03
3339431452011010.342111141525.20000139.9000022022-05-11 17:36:05
4339432392011010.342111141525.20000139.9000022022-05-11 17:36:07
5339433242011010.342111141525.20000139.9000022022-05-11 17:36:09
6339434032011010.342111141525.20000139.9000022022-05-11 17:36:11
7339435172011010.342111141525.20000139.9000022022-05-11 17:36:13
8339436132011010.343013171725.29999939.9000022022-05-11 17:36:15
9339436962011010.343013171725.29999939.9000022022-05-11 17:36:17
시퀀스노드 아이디co 측정값co2 측정값PM1.0 측정값PM2.5 측정값PM10 측정값온도습도기록 시간
90339544672011010.342213161825.20000140.02022-05-11 17:39:00
91339545612011010.342213161825.20000140.02022-05-11 17:39:02
92339546552011010.342213161825.20000140.02022-05-11 17:39:04
93339547462011010.342213161825.20000140.02022-05-11 17:39:06
94339549452011010.342012171825.20000140.02022-05-11 17:39:08
95339552182011010.342012171825.20000140.02022-05-11 17:39:10
96339554982011010.342012171825.20000140.02022-05-11 17:39:12
97339557072011010.342012171825.20000140.02022-05-11 17:39:14
98339559702011010.342012171825.20000140.02022-05-11 17:39:16
99339561702011010.342012171825.20000140.02022-05-11 17:39:16