Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.0 KiB
Average record size in memory61.3 B

Variable types

Categorical4
DateTime1
Numeric2

Dataset

Description샘플 데이터
Author순천향대학교 산학협력단
URLhttps://www.bigdata-environment.kr/user/data_market/detail.do?id=29aac690-8f68-11ea-b4d5-2f798fa59107

Alerts

기기 ID has constant value ""Constant
데이터 측정 위치 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 11:09:06.576504
Analysis finished2023-12-10 11:09:07.963762
Duration1.39 second
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
V10O1610251
100 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
V10O1610251 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T20:09:08.193191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
v10o1610251 100
100.0%

데이터 측정 위치
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
대치1동 대치지구대옆
100 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대치1동 대치지구대옆
2nd row대치1동 대치지구대옆
3rd row대치1동 대치지구대옆
4th row대치1동 대치지구대옆
5th row대치1동 대치지구대옆

Common Values

ValueCountFrequency (%)
대치1동 대치지구대옆 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T20:09:08.495947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대치1동 100
50.0%
대치지구대옆 100
50.0%

위도
Categorical

CONSTANT 

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

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row37.492
2nd row37.492
3rd row37.492
4th row37.492
5th row37.492

Common Values

ValueCountFrequency (%)
37.492 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T20:09:08.775923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
37.492 100
100.0%

경도
Categorical

CONSTANT 

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

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
127.057 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T20:09:09.049185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
127.057 100
100.0%

데이터 측정 일시
Date

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2019-06-01 00:00:00
Maximum2019-06-05 03:00:00
2023-12-10T20:09:09.215038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:09.451849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

미세먼지
Real number (ℝ)

HIGH CORRELATION 

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27.1181
Minimum17.98
Maximum45.47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:09:09.649822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum17.98
5-th percentile19.43
Q123.2725
median26.105
Q329.785
95-th percentile37.543
Maximum45.47
Range27.49
Interquartile range (IQR)6.5125

Descriptive statistics

Standard deviation5.7564381
Coefficient of variation (CV)0.21227291
Kurtosis1.2099489
Mean27.1181
Median Absolute Deviation (MAD)2.995
Skewness1.0209616
Sum2711.81
Variance33.136579
MonotonicityNot monotonic
2023-12-10T20:09:09.809864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
27.63 2
 
2.0%
18.47 1
 
1.0%
32.78 1
 
1.0%
24.08 1
 
1.0%
22.65 1
 
1.0%
24.47 1
 
1.0%
36.28 1
 
1.0%
45.47 1
 
1.0%
45.38 1
 
1.0%
37.54 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
17.98 1
1.0%
18.38 1
1.0%
18.47 1
1.0%
18.58 1
1.0%
18.67 1
1.0%
19.47 1
1.0%
19.48 1
1.0%
19.81 1
1.0%
20.08 1
1.0%
20.46 1
1.0%
ValueCountFrequency (%)
45.47 1
1.0%
45.38 1
1.0%
42.18 1
1.0%
41.57 1
1.0%
37.6 1
1.0%
37.54 1
1.0%
36.95 1
1.0%
36.28 1
1.0%
35.85 1
1.0%
35.78 1
1.0%

초미세먼지
Real number (ℝ)

HIGH CORRELATION 

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.8376
Minimum10.07
Maximum30.47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:09:09.975950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10.07
5-th percentile11.694
Q113.72
median16.165
Q319.0925
95-th percentile23.7325
Maximum30.47
Range20.4
Interquartile range (IQR)5.3725

Descriptive statistics

Standard deviation4.1211615
Coefficient of variation (CV)0.24475944
Kurtosis0.77983829
Mean16.8376
Median Absolute Deviation (MAD)2.59
Skewness0.88166006
Sum1683.76
Variance16.983972
MonotonicityNot monotonic
2023-12-10T20:09:10.156072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
18.07 2
 
2.0%
10.51 1
 
1.0%
22.08 1
 
1.0%
15.53 1
 
1.0%
13.32 1
 
1.0%
15.21 1
 
1.0%
22.05 1
 
1.0%
28.44 1
 
1.0%
30.47 1
 
1.0%
24.73 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
10.07 1
1.0%
10.51 1
1.0%
10.73 1
1.0%
11.27 1
1.0%
11.58 1
1.0%
11.7 1
1.0%
11.76 1
1.0%
11.81 1
1.0%
11.82 1
1.0%
11.83 1
1.0%
ValueCountFrequency (%)
30.47 1
1.0%
28.44 1
1.0%
27.77 1
1.0%
25.42 1
1.0%
24.73 1
1.0%
23.68 1
1.0%
23.12 1
1.0%
22.98 1
1.0%
22.87 1
1.0%
22.78 1
1.0%

Interactions

2023-12-10T20:09:07.050855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:06.788329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:07.193660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:06.906881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T20:09:10.283134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터 측정 일시미세먼지초미세먼지
데이터 측정 일시1.0001.0001.000
미세먼지1.0001.0000.956
초미세먼지1.0000.9561.000
2023-12-10T20:09:10.410856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
미세먼지초미세먼지
미세먼지1.0000.864
초미세먼지0.8641.000

Missing values

2023-12-10T20:09:07.727644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:09:07.895700image/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데이터 측정 위치위도경도데이터 측정 일시미세먼지초미세먼지
0V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 1:0018.4710.51
1V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 2:0019.4810.73
2V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 3:0021.6512.84
3V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 4:0022.4812.18
4V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 5:0018.3812.29
5V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 6:0018.6713.86
6V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 7:0020.5714.5
7V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 8:0029.918.98
8V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 9:0027.6319.6
9V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 10:0029.7822.47
기기 ID데이터 측정 위치위도경도데이터 측정 일시미세먼지초미세먼지
90V10O1610251대치1동 대치지구대옆37.492127.0572019-06-04 19:0024.8216.27
91V10O1610251대치1동 대치지구대옆37.492127.0572019-06-04 20:0026.017.23
92V10O1610251대치1동 대치지구대옆37.492127.0572019-06-04 21:0028.2817.25
93V10O1610251대치1동 대치지구대옆37.492127.0572019-06-04 22:0033.3819.52
94V10O1610251대치1동 대치지구대옆37.492127.0572019-06-04 23:0027.7619.73
95V10O1610251대치1동 대치지구대옆37.492127.0572019-06-05 0:0024.718.43
96V10O1610251대치1동 대치지구대옆37.492127.0572019-06-05 1:0027.2419.36
97V10O1610251대치1동 대치지구대옆37.492127.0572019-06-05 2:0033.0823.12
98V10O1610251대치1동 대치지구대옆37.492127.0572019-06-05 3:0032.0522.78
99V10O1610251대치1동 대치지구대옆37.492127.0572019-06-01 0:0018.5811.27