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:15.608894
Analysis finished2023-12-10 11:09:16.670724
Duration1.06 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:16.744023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:09:16.839614image/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:16.974774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:09:17.093652image/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:17.200810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:09:17.319049image/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:17.442029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T20:09:17.577419image/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-04-01 00:00:00
Maximum2019-04-05 03:00:00
2023-12-10T20:09:17.736941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:17.924125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

미세먼지
Real number (ℝ)

HIGH CORRELATION 

Distinct94
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.5935
Minimum18.36
Maximum39.2
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:09:18.137836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum18.36
5-th percentile20.6615
Q126.2475
median29.635
Q333.5075
95-th percentile37.6395
Maximum39.2
Range20.84
Interquartile range (IQR)7.26

Descriptive statistics

Standard deviation5.0746063
Coefficient of variation (CV)0.17147706
Kurtosis-0.60751407
Mean29.5935
Median Absolute Deviation (MAD)3.6
Skewness-0.10904198
Sum2959.35
Variance25.751629
MonotonicityNot monotonic
2023-12-10T20:09:18.324907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
29.28 2
 
2.0%
29.42 2
 
2.0%
29.85 2
 
2.0%
25.38 2
 
2.0%
29.98 2
 
2.0%
20.5 2
 
2.0%
29.47 1
 
1.0%
34.4 1
 
1.0%
35.97 1
 
1.0%
37.42 1
 
1.0%
Other values (84) 84
84.0%
ValueCountFrequency (%)
18.36 1
1.0%
19.52 1
1.0%
19.55 1
1.0%
20.5 2
2.0%
20.67 1
1.0%
21.08 1
1.0%
21.17 1
1.0%
21.35 1
1.0%
21.73 1
1.0%
22.4 1
1.0%
ValueCountFrequency (%)
39.2 1
1.0%
38.57 1
1.0%
38.47 1
1.0%
37.93 1
1.0%
37.82 1
1.0%
37.63 1
1.0%
37.42 1
1.0%
37.41 1
1.0%
37.12 1
1.0%
36.98 1
1.0%

초미세먼지
Real number (ℝ)

HIGH CORRELATION 

Distinct95
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.0337
Minimum8.17
Maximum28.97
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:09:18.491627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8.17
5-th percentile11.709
Q114.9175
median17.88
Q321.2475
95-th percentile25.079
Maximum28.97
Range20.8
Interquartile range (IQR)6.33

Descriptive statistics

Standard deviation4.1630735
Coefficient of variation (CV)0.23084966
Kurtosis-0.3226058
Mean18.0337
Median Absolute Deviation (MAD)3.19
Skewness0.21864107
Sum1803.37
Variance17.331181
MonotonicityNot monotonic
2023-12-10T20:09:18.768483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19.28 2
 
2.0%
14.39 2
 
2.0%
20.95 2
 
2.0%
14.93 2
 
2.0%
14.47 2
 
2.0%
16.07 1
 
1.0%
21.33 1
 
1.0%
22.37 1
 
1.0%
23.58 1
 
1.0%
24.86 1
 
1.0%
Other values (85) 85
85.0%
ValueCountFrequency (%)
8.17 1
1.0%
10.7 1
1.0%
10.83 1
1.0%
11.05 1
1.0%
11.5 1
1.0%
11.72 1
1.0%
11.8 1
1.0%
12.47 1
1.0%
12.63 1
1.0%
12.7 1
1.0%
ValueCountFrequency (%)
28.97 1
1.0%
27.65 1
1.0%
27.0 1
1.0%
25.58 1
1.0%
25.25 1
1.0%
25.07 1
1.0%
24.86 1
1.0%
23.9 1
1.0%
23.58 1
1.0%
23.43 1
1.0%

Interactions

2023-12-10T20:09:16.263761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:15.762857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:16.364981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:09:15.862007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T20:09:18.919294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터 측정 일시미세먼지초미세먼지
데이터 측정 일시1.0001.0001.000
미세먼지1.0001.0000.814
초미세먼지1.0000.8141.000
2023-12-10T20:09:19.045768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
미세먼지초미세먼지
미세먼지1.0000.865
초미세먼지0.8651.000

Missing values

2023-12-10T20:09:16.494283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:09:16.622094image/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-04-01 1:0029.4720.59
1V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 2:0029.820.9
2V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 3:0028.2615.53
3V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 4:0028.1812.7
4V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 5:0029.4217.12
5V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 6:0030.3220.95
6V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 7:0029.8516.7
7V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 8:0032.4515.13
8V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 9:0026.513.07
9V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 10:0023.3311.72
기기 ID데이터 측정 위치위도경도데이터 측정 일시미세먼지초미세먼지
90V10O1610251대치1동 대치지구대옆37.492127.0572019-04-04 19:0030.0816.05
91V10O1610251대치1동 대치지구대옆37.492127.0572019-04-04 20:0025.2715.07
92V10O1610251대치1동 대치지구대옆37.492127.0572019-04-04 21:0022.414.93
93V10O1610251대치1동 대치지구대옆37.492127.0572019-04-04 22:0023.9315.47
94V10O1610251대치1동 대치지구대옆37.492127.0572019-04-04 23:0021.1714.39
95V10O1610251대치1동 대치지구대옆37.492127.0572019-04-05 0:0019.5513.75
96V10O1610251대치1동 대치지구대옆37.492127.0572019-04-05 1:0021.7314.97
97V10O1610251대치1동 대치지구대옆37.492127.0572019-04-05 2:0023.614.88
98V10O1610251대치1동 대치지구대옆37.492127.0572019-04-05 3:0027.7619.92
99V10O1610251대치1동 대치지구대옆37.492127.0572019-04-01 0:0029.6821.77