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

Variable types

Categorical3
DateTime1
Numeric2

Dataset

Description샘플 데이터
Author순천향대학교 산학협력단
URLhttps://www.bigdata-environment.kr/user/data_market/detail.do?id=6ea74040-4078-11eb-bdda-25af7f339cc7

Alerts

장비ID has constant value ""Constant
위도 has constant value ""Constant
경도 has constant value ""Constant
초미세먼지값(ug/m3) is highly overall correlated with 미세먼지값(ug/m3)High correlation
미세먼지값(ug/m3) is highly overall correlated with 초미세먼지값(ug/m3)High correlation
데이터발생일시 has unique valuesUnique

Reproduction

Analysis started2023-12-10 11:28:51.111129
Analysis finished2023-12-10 11:28:52.005488
Duration0.89 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
64969
100 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
64969 100
100.0%

Length

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

Common Values (Plot)

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

데이터발생일시
Date

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2020-10-19 11:25:00
Maximum2020-10-19 14:49:00
2023-12-10T20:28:52.337541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:28:52.490328image/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.772892
100 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
36.772892 100
100.0%

Length

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

Common Values (Plot)

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

경도
Categorical

CONSTANT 

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
127.021792 100
100.0%

Length

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

Common Values (Plot)

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

초미세먼지값(ug/m3)
Real number (ℝ)

HIGH CORRELATION 

Distinct96
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean72.9836
Minimum61.04
Maximum89.53
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:28:53.161734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum61.04
5-th percentile65.682
Q168.7775
median71.83
Q376.895
95-th percentile82.6855
Maximum89.53
Range28.49
Interquartile range (IQR)8.1175

Descriptive statistics

Standard deviation5.667703
Coefficient of variation (CV)0.077657214
Kurtosis0.060895524
Mean72.9836
Median Absolute Deviation (MAD)3.89
Skewness0.5602596
Sum7298.36
Variance32.122858
MonotonicityNot monotonic
2023-12-10T20:28:53.353455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
70.58 2
 
2.0%
67.42 2
 
2.0%
77.45 2
 
2.0%
71.4 2
 
2.0%
61.04 1
 
1.0%
66.34 1
 
1.0%
73.39 1
 
1.0%
71.37 1
 
1.0%
71.81 1
 
1.0%
68.83 1
 
1.0%
Other values (86) 86
86.0%
ValueCountFrequency (%)
61.04 1
1.0%
61.96 1
1.0%
63.62 1
1.0%
64.6 1
1.0%
64.96 1
1.0%
65.72 1
1.0%
66.04 1
1.0%
66.18 1
1.0%
66.34 1
1.0%
66.87 1
1.0%
ValueCountFrequency (%)
89.53 1
1.0%
87.89 1
1.0%
85.41 1
1.0%
84.12 1
1.0%
82.98 1
1.0%
82.67 1
1.0%
82.62 1
1.0%
82.05 1
1.0%
82.0 1
1.0%
81.04 1
1.0%

미세먼지값(ug/m3)
Real number (ℝ)

HIGH CORRELATION 

Distinct98
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean82.4139
Minimum70.3
Maximum99.24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T20:28:53.547053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum70.3
5-th percentile73.9775
Q177.0575
median81.785
Q387.7275
95-th percentile91.7645
Maximum99.24
Range28.94
Interquartile range (IQR)10.67

Descriptive statistics

Standard deviation6.2533086
Coefficient of variation (CV)0.075876868
Kurtosis-0.62758408
Mean82.4139
Median Absolute Deviation (MAD)5.145
Skewness0.36435017
Sum8241.39
Variance39.103868
MonotonicityNot monotonic
2023-12-10T20:28:54.028106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
78.62 2
 
2.0%
76.53 2
 
2.0%
71.0 1
 
1.0%
75.33 1
 
1.0%
83.57 1
 
1.0%
80.93 1
 
1.0%
79.68 1
 
1.0%
84.47 1
 
1.0%
79.19 1
 
1.0%
74.7 1
 
1.0%
Other values (88) 88
88.0%
ValueCountFrequency (%)
70.3 1
1.0%
71.0 1
1.0%
72.25 1
1.0%
73.31 1
1.0%
73.93 1
1.0%
73.98 1
1.0%
74.43 1
1.0%
74.59 1
1.0%
74.7 1
1.0%
75.33 1
1.0%
ValueCountFrequency (%)
99.24 1
1.0%
97.17 1
1.0%
94.41 1
1.0%
93.48 1
1.0%
92.61 1
1.0%
91.72 1
1.0%
91.52 1
1.0%
91.37 1
1.0%
91.05 1
1.0%
90.89 1
1.0%

Interactions

2023-12-10T20:28:51.457245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:28:51.247490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:28:51.587045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T20:28:51.352084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T20:28:54.156398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터발생일시초미세먼지값(ug/m3)미세먼지값(ug/m3)
데이터발생일시1.0001.0001.000
초미세먼지값(ug/m3)1.0001.0000.983
미세먼지값(ug/m3)1.0000.9831.000
2023-12-10T20:28:54.270299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
초미세먼지값(ug/m3)미세먼지값(ug/m3)
초미세먼지값(ug/m3)1.0000.970
미세먼지값(ug/m3)0.9701.000

Missing values

2023-12-10T20:28:51.753599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T20:28:51.939269image/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데이터발생일시위도경도초미세먼지값(ug/m3)미세먼지값(ug/m3)
0649692020-10-19 11:2736.772892127.02179261.0471.0
1649692020-10-19 11:2936.772892127.02179261.9670.3
2649692020-10-19 11:3136.772892127.02179263.6272.25
3649692020-10-19 11:3336.772892127.02179269.8278.62
4649692020-10-19 11:3536.772892127.02179267.6478.62
5649692020-10-19 11:3736.772892127.02179271.4381.09
6649692020-10-19 11:3936.772892127.02179264.9673.31
7649692020-10-19 11:4136.772892127.02179269.3579.59
8649692020-10-19 11:4336.772892127.02179268.1875.77
9649692020-10-19 11:4536.772892127.02179271.9181.33
장비ID데이터발생일시위도경도초미세먼지값(ug/m3)미세먼지값(ug/m3)
90649692020-10-19 14:3336.772892127.02179282.091.52
91649692020-10-19 14:3536.772892127.02179285.4193.48
92649692020-10-19 14:3736.772892127.02179282.0590.47
93649692020-10-19 14:3936.772892127.02179287.8997.17
94649692020-10-19 14:4136.772892127.02179277.5787.68
95649692020-10-19 14:4336.772892127.02179284.1294.41
96649692020-10-19 14:4536.772892127.02179289.5399.24
97649692020-10-19 14:4736.772892127.02179282.6292.61
98649692020-10-19 14:4936.772892127.02179281.0491.72
99649692020-10-19 11:2536.772892127.02179264.673.93