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.2 KiB
Average record size in memory53.3 B

Variable types

Categorical3
DateTime1
Numeric2

Dataset

Description샘플 데이터
Author순천향대학교 산학협력단
URLhttps://www.bigdata-environment.kr/user/data_market/detail.do?id=a75212a0-31ef-11ea-ad66-1b2f93f3f455

Alerts

기기 ID has constant value ""Constant
위도 has constant value ""Constant
경도 has constant value ""Constant
초미세먼지 is highly overall correlated with 미세먼지High correlation
미세먼지 is highly overall correlated with 초미세먼지High correlation
데이터 발생 일시 has unique valuesUnique

Reproduction

Analysis started2023-12-10 12:56:51.626787
Analysis finished2023-12-10 12:56:52.570373
Duration0.94 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기기 ID
Categorical

CONSTANT 

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1912LYS134 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T21:56:52.788983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1912lys134 100
100.0%

데이터 발생 일시
Date

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2020-04-01 00:00:00
Maximum2020-04-01 16:30:00
2023-12-10T21:56:52.915544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:56:53.142400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위도
Categorical

CONSTANT 

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

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row36.9143
2nd row36.9143
3rd row36.9143
4th row36.9143
5th row36.9143

Common Values

ValueCountFrequency (%)
36.9143 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T21:56:53.483864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
36.9143 100
100.0%

경도
Categorical

CONSTANT 

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

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row127.0626
2nd row127.0626
3rd row127.0626
4th row127.0626
5th row127.0626

Common Values

ValueCountFrequency (%)
127.0626 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T21:56:53.735952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
127.0626 100
100.0%

초미세먼지
Real number (ℝ)

HIGH CORRELATION 

Distinct19
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.91
Minimum7
Maximum26
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:56:53.836431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile9.95
Q111
median14
Q319
95-th percentile22.1
Maximum26
Range19
Interquartile range (IQR)8

Descriptive statistics

Standard deviation4.438343
Coefficient of variation (CV)0.29767559
Kurtosis-0.57659848
Mean14.91
Median Absolute Deviation (MAD)3
Skewness0.56111102
Sum1491
Variance19.698889
MonotonicityNot monotonic
2023-12-10T21:56:53.960272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
11 23
23.0%
12 12
12.0%
15 10
10.0%
20 9
 
9.0%
16 6
 
6.0%
19 5
 
5.0%
13 5
 
5.0%
17 4
 
4.0%
21 4
 
4.0%
14 3
 
3.0%
Other values (9) 19
19.0%
ValueCountFrequency (%)
7 2
 
2.0%
8 1
 
1.0%
9 2
 
2.0%
10 3
 
3.0%
11 23
23.0%
12 12
12.0%
13 5
 
5.0%
14 3
 
3.0%
15 10
10.0%
16 6
 
6.0%
ValueCountFrequency (%)
26 1
 
1.0%
25 2
 
2.0%
24 2
 
2.0%
22 3
 
3.0%
21 4
4.0%
20 9
9.0%
19 5
5.0%
18 3
 
3.0%
17 4
4.0%
16 6
6.0%

미세먼지
Real number (ℝ)

HIGH CORRELATION 

Distinct20
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19.24
Minimum12
Maximum32
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:56:54.098672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12
5-th percentile13
Q115
median18
Q323.25
95-th percentile28.05
Maximum32
Range20
Interquartile range (IQR)8.25

Descriptive statistics

Standard deviation5.0614806
Coefficient of variation (CV)0.26307072
Kurtosis-0.71152826
Mean19.24
Median Absolute Deviation (MAD)3.5
Skewness0.61401329
Sum1924
Variance25.618586
MonotonicityNot monotonic
2023-12-10T21:56:54.269403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
15 16
16.0%
14 10
 
10.0%
19 9
 
9.0%
17 8
 
8.0%
25 7
 
7.0%
16 7
 
7.0%
22 5
 
5.0%
24 5
 
5.0%
13 4
 
4.0%
28 4
 
4.0%
Other values (10) 25
25.0%
ValueCountFrequency (%)
12 3
 
3.0%
13 4
 
4.0%
14 10
10.0%
15 16
16.0%
16 7
7.0%
17 8
8.0%
18 4
 
4.0%
19 9
9.0%
20 3
 
3.0%
21 3
 
3.0%
ValueCountFrequency (%)
32 1
 
1.0%
30 2
 
2.0%
29 2
 
2.0%
28 4
4.0%
27 2
 
2.0%
26 2
 
2.0%
25 7
7.0%
24 5
5.0%
23 3
3.0%
22 5
5.0%

Interactions

2023-12-10T21:56:52.035775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:56:51.771878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:56:52.179002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:56:51.897026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:56:54.429384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터 발생 일시초미세먼지미세먼지
데이터 발생 일시1.0001.0001.000
초미세먼지1.0001.0000.923
미세먼지1.0000.9231.000
2023-12-10T21:56:54.534127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
초미세먼지미세먼지
초미세먼지1.0000.961
미세먼지0.9611.000

Missing values

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

기기 ID데이터 발생 일시위도경도초미세먼지미세먼지
01912LYS1342020-04-01 10:2036.9143127.06261519
11912LYS1342020-04-01 16:1036.9143127.0626812
21912LYS1342020-04-01 5:0036.9143127.06261217
31912LYS1342020-04-01 10:1036.9143127.06261619
41912LYS1342020-04-01 13:3036.9143127.06262428
51912LYS1342020-04-01 16:0036.9143127.0626913
61912LYS1342020-04-01 2:2036.9143127.06261215
71912LYS1342020-04-01 4:5036.9143127.06261215
81912LYS1342020-04-01 7:3036.9143127.06262127
91912LYS1342020-04-01 10:0036.9143127.06261519
기기 ID데이터 발생 일시위도경도초미세먼지미세먼지
901912LYS1342020-04-01 8:5036.9143127.06261924
911912LYS1342020-04-01 9:0036.9143127.06261825
921912LYS1342020-04-01 9:2036.9143127.06261418
931912LYS1342020-04-01 9:3036.9143127.06261520
941912LYS1342020-04-01 10:3036.9143127.06261518
951912LYS1342020-04-01 10:4036.9143127.06261518
961912LYS1342020-04-01 11:0036.9143127.06261620
971912LYS1342020-04-01 11:1036.9143127.06261722
981912LYS1342020-04-01 16:3036.9143127.0626712
991912LYS1342020-04-01 16:2036.9143127.0626713