Overview

Dataset statistics

Number of variables9
Number of observations200
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.6 KiB
Average record size in memory79.7 B

Variable types

DateTime1
Numeric5
Categorical3

Alerts

측정주소 has constant value ""Constant
위도값 has constant value ""Constant
경도값 has constant value ""Constant
온도값 is highly overall correlated with 풍향값 and 2 other fieldsHigh correlation
습도값 is highly overall correlated with 풍속값High correlation
풍향값 is highly overall correlated with 온도값 and 1 other fieldsHigh correlation
풍속값 is highly overall correlated with 온도값 and 1 other fieldsHigh correlation
일사값 is highly overall correlated with 온도값 and 1 other fieldsHigh correlation
측정일시 has unique valuesUnique
풍향값 has 5 (2.5%) zerosZeros
풍속값 has 22 (11.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:12:26.538740
Analysis finished2023-12-10 06:12:34.240490
Duration7.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

측정일시
Date

UNIQUE 

Distinct200
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2021-01-01 00:00:00
Maximum2021-01-01 16:35:00
2023-12-10T15:12:34.373926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:34.591649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

온도값
Real number (ℝ)

HIGH CORRELATION 

Distinct127
Distinct (%)63.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-214.0594
Minimum-999
Maximum-1.22
Zeros0
Zeros (%)0.0%
Negative200
Negative (%)100.0%
Memory size1.9 KiB
2023-12-10T15:12:34.802915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-999
5-th percentile-999
Q1-8.75
median-5.8
Q3-5.21
95-th percentile-2.297
Maximum-1.22
Range997.78
Interquartile range (IQR)3.54

Descriptive statistics

Standard deviation405.71896
Coefficient of variation (CV)-1.8953569
Kurtosis0.058960907
Mean-214.0594
Median Absolute Deviation (MAD)1.635
Skewness-1.4346987
Sum-42811.88
Variance164607.88
MonotonicityNot monotonic
2023-12-10T15:12:35.013325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-999.0 42
 
21.0%
-5.69 3
 
1.5%
-5.48 3
 
1.5%
-5.66 3
 
1.5%
-5.87 3
 
1.5%
-4.82 2
 
1.0%
-6.04 2
 
1.0%
-6.47 2
 
1.0%
-7.43 2
 
1.0%
-2.39 2
 
1.0%
Other values (117) 136
68.0%
ValueCountFrequency (%)
-999.0 42
21.0%
-10.2 1
 
0.5%
-10.1 1
 
0.5%
-9.96 1
 
0.5%
-9.9 1
 
0.5%
-9.31 1
 
0.5%
-9.25 1
 
0.5%
-9.19 1
 
0.5%
-9.02 1
 
0.5%
-8.66 1
 
0.5%
ValueCountFrequency (%)
-1.22 2
1.0%
-1.27 1
0.5%
-1.34 2
1.0%
-1.94 2
1.0%
-2.1 1
0.5%
-2.24 2
1.0%
-2.3 2
1.0%
-2.34 1
0.5%
-2.39 2
1.0%
-2.42 2
1.0%

습도값
Real number (ℝ)

HIGH CORRELATION 

Distinct19
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-144.275
Minimum-999
Maximum94
Zeros0
Zeros (%)0.0%
Negative42
Negative (%)21.0%
Memory size1.9 KiB
2023-12-10T15:12:35.197956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-999
5-th percentile-999
Q178
median81
Q384
95-th percentile89.05
Maximum94
Range1093
Interquartile range (IQR)6

Descriptive statistics

Standard deviation441.79796
Coefficient of variation (CV)-3.0621934
Kurtosis0.058776876
Mean-144.275
Median Absolute Deviation (MAD)3
Skewness-1.4345481
Sum-28855
Variance195185.44
MonotonicityNot monotonic
2023-12-10T15:12:35.380055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
-999 42
21.0%
81 35
17.5%
80 25
12.5%
83 17
8.5%
84 12
 
6.0%
87 11
 
5.5%
82 10
 
5.0%
88 8
 
4.0%
78 8
 
4.0%
79 8
 
4.0%
Other values (9) 24
12.0%
ValueCountFrequency (%)
-999 42
21.0%
77 3
 
1.5%
78 8
 
4.0%
79 8
 
4.0%
80 25
12.5%
81 35
17.5%
82 10
 
5.0%
83 17
8.5%
84 12
 
6.0%
85 1
 
0.5%
ValueCountFrequency (%)
94 3
 
1.5%
93 1
 
0.5%
92 2
 
1.0%
91 2
 
1.0%
90 2
 
1.0%
89 5
2.5%
88 8
4.0%
87 11
5.5%
86 5
2.5%
85 1
 
0.5%

풍향값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct89
Distinct (%)44.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-121.245
Minimum-999
Maximum354
Zeros5
Zeros (%)2.5%
Negative42
Negative (%)21.0%
Memory size1.9 KiB
2023-12-10T15:12:35.590346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-999
5-th percentile-999
Q14.5
median64
Q3123
95-th percentile321
Maximum354
Range1353
Interquartile range (IQR)118.5

Descriptive statistics

Standard deviation460.93558
Coefficient of variation (CV)-3.8016874
Kurtosis-0.062660536
Mean-121.245
Median Absolute Deviation (MAD)59
Skewness-1.3131171
Sum-24249
Variance212461.61
MonotonicityNot monotonic
2023-12-10T15:12:35.825430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-999 42
 
21.0%
40 7
 
3.5%
354 7
 
3.5%
94 5
 
2.5%
0 5
 
2.5%
100 3
 
1.5%
203 3
 
1.5%
174 3
 
1.5%
173 3
 
1.5%
123 3
 
1.5%
Other values (79) 119
59.5%
ValueCountFrequency (%)
-999 42
21.0%
0 5
 
2.5%
2 1
 
0.5%
3 2
 
1.0%
5 1
 
0.5%
10 2
 
1.0%
11 1
 
0.5%
12 2
 
1.0%
14 1
 
0.5%
15 2
 
1.0%
ValueCountFrequency (%)
354 7
3.5%
352 1
 
0.5%
334 1
 
0.5%
321 2
 
1.0%
319 1
 
0.5%
272 1
 
0.5%
235 1
 
0.5%
231 2
 
1.0%
222 1
 
0.5%
218 2
 
1.0%

풍속값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct32
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-208.9225
Minimum-999
Maximum4.3
Zeros22
Zeros (%)11.0%
Negative42
Negative (%)21.0%
Memory size1.9 KiB
2023-12-10T15:12:35.982948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-999
5-th percentile-999
Q10
median0.85
Q31.4
95-th percentile2.6
Maximum4.3
Range1003.3
Interquartile range (IQR)1.4

Descriptive statistics

Standard deviation408.37104
Coefficient of variation (CV)-1.9546532
Kurtosis0.05902973
Mean-208.9225
Median Absolute Deviation (MAD)0.85
Skewness-1.4347546
Sum-41784.5
Variance166766.91
MonotonicityNot monotonic
2023-12-10T15:12:36.167850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
-999.0 42
21.0%
0.0 22
 
11.0%
0.9 15
 
7.5%
1.0 13
 
6.5%
1.1 9
 
4.5%
1.8 8
 
4.0%
0.5 7
 
3.5%
1.2 7
 
3.5%
0.8 6
 
3.0%
0.6 6
 
3.0%
Other values (22) 65
32.5%
ValueCountFrequency (%)
-999.0 42
21.0%
0.0 22
11.0%
0.1 5
 
2.5%
0.2 3
 
1.5%
0.3 3
 
1.5%
0.5 7
 
3.5%
0.6 6
 
3.0%
0.7 6
 
3.0%
0.8 6
 
3.0%
0.9 15
 
7.5%
ValueCountFrequency (%)
4.3 1
 
0.5%
3.3 1
 
0.5%
2.9 1
 
0.5%
2.8 4
2.0%
2.7 1
 
0.5%
2.6 3
1.5%
2.5 1
 
0.5%
2.4 2
1.0%
2.3 1
 
0.5%
2.2 1
 
0.5%

일사값
Real number (ℝ)

HIGH CORRELATION 

Distinct63
Distinct (%)31.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-155.71885
Minimum-999
Maximum371.67
Zeros0
Zeros (%)0.0%
Negative42
Negative (%)21.0%
Memory size1.9 KiB
2023-12-10T15:12:36.411236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-999
5-th percentile-999
Q110.26
median10.26
Q389.74
95-th percentile233.8995
Maximum371.67
Range1370.67
Interquartile range (IQR)79.48

Descriptive statistics

Standard deviation442.22072
Coefficient of variation (CV)-2.8398663
Kurtosis-0.051741212
Mean-155.71885
Median Absolute Deviation (MAD)46.155
Skewness-1.322992
Sum-31143.77
Variance195559.16
MonotonicityNot monotonic
2023-12-10T15:12:36.641882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10.26 58
29.0%
-999.0 42
21.0%
10.74 27
13.5%
139.68 4
 
2.0%
12.7 2
 
1.0%
73.26 2
 
1.0%
42.98 2
 
1.0%
170.45 2
 
1.0%
151.89 2
 
1.0%
253.97 2
 
1.0%
Other values (53) 57
28.5%
ValueCountFrequency (%)
-999.0 42
21.0%
9.77 2
 
1.0%
10.26 58
29.0%
10.74 27
13.5%
11.23 1
 
0.5%
12.7 2
 
1.0%
15.63 1
 
0.5%
19.05 1
 
0.5%
23.93 1
 
0.5%
29.3 1
 
0.5%
ValueCountFrequency (%)
371.67 1
0.5%
325.27 1
0.5%
264.22 1
0.5%
255.43 1
0.5%
254.46 1
0.5%
253.97 2
1.0%
246.15 1
0.5%
245.67 1
0.5%
242.25 1
0.5%
233.46 1
0.5%

측정주소
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
경상북도 상주시 모동면 신천리 220-8
200 

Length

Max length22
Median length22
Mean length22
Min length22

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경상북도 상주시 모동면 신천리 220-8
2nd row경상북도 상주시 모동면 신천리 220-8
3rd row경상북도 상주시 모동면 신천리 220-8
4th row경상북도 상주시 모동면 신천리 220-8
5th row경상북도 상주시 모동면 신천리 220-8

Common Values

ValueCountFrequency (%)
경상북도 상주시 모동면 신천리 220-8 200
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:12:37.134511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경상북도 200
20.0%
상주시 200
20.0%
모동면 200
20.0%
신천리 200
20.0%
220-8 200
20.0%

위도값
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
36.2965
200 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
36.2965 200
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:12:37.745603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
36.2965 200
100.0%

경도값
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
127.9644
200 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
127.9644 200
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:12:38.766207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
127.9644 200
100.0%

Interactions

2023-12-10T15:12:33.134661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:27.108645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:28.697302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:30.698637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:32.358762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:33.280315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:27.348549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:29.066230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:31.107409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:32.504353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:33.409469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:27.494733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:29.582293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:31.720201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:32.640189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:33.554779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:27.930397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:29.904721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:31.935313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:32.840369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:33.714180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:28.288629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:30.318064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:32.135694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:12:32.956208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:12:39.150338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도값습도값풍향값풍속값일사값
온도값1.000NaNNaNNaNNaN
습도값NaN1.000NaNNaNNaN
풍향값NaNNaN1.000NaN0.480
풍속값NaNNaNNaN1.000NaN
일사값NaNNaN0.480NaN1.000
2023-12-10T15:12:39.729511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도값습도값풍향값풍속값일사값
온도값1.0000.3820.6940.5560.794
습도값0.3821.0000.4190.7140.216
풍향값0.6940.4191.0000.4150.618
풍속값0.5560.7140.4151.0000.411
일사값0.7940.2160.6180.4111.000

Missing values

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

측정일시온도값습도값풍향값풍속값일사값측정주소위도값경도값
02021-01-01 0:00-5.6989940.510.74경상북도 상주시 모동면 신천리 220-836.2965127.9644
12021-01-01 0:05-5.6189660.710.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
22021-01-01 0:10-5.8788610.110.74경상북도 상주시 모동면 신천리 220-836.2965127.9644
32021-01-01 0:15-5.4488630.510.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
42021-01-01 0:20-5.3288351.910.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
52021-01-01 0:25-5.7787990.510.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
62021-01-01 0:30-5.787611.09.77경상북도 상주시 모동면 신천리 220-836.2965127.9644
72021-01-01 0:35-5.7687731.110.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
82021-01-01 0:40-5.6987672.110.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
92021-01-01 0:45-5.6687511.010.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
측정일시온도값습도값풍향값풍속값일사값측정주소위도값경도값
1902021-01-01 15:50-999.0-999-999-999.0-999.0경상북도 상주시 모동면 신천리 220-836.2965127.9644
1912021-01-01 15:55-999.0-999-999-999.0-999.0경상북도 상주시 모동면 신천리 220-836.2965127.9644
1922021-01-01 16:00-999.0-999-999-999.0-999.0경상북도 상주시 모동면 신천리 220-836.2965127.9644
1932021-01-01 16:05-999.0-999-999-999.0-999.0경상북도 상주시 모동면 신천리 220-836.2965127.9644
1942021-01-01 16:10-1.34791931.242.98경상북도 상주시 모동면 신천리 220-836.2965127.9644
1952021-01-01 16:15-1.34791931.242.98경상북도 상주시 모동면 신천리 220-836.2965127.9644
1962021-01-01 16:20-999.0-999-999-999.0-999.0경상북도 상주시 모동면 신천리 220-836.2965127.9644
1972021-01-01 16:25-1.22803211.073.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
1982021-01-01 16:30-1.22803211.073.26경상북도 상주시 모동면 신천리 220-836.2965127.9644
1992021-01-01 16:35-1.27792350.832.72경상북도 상주시 모동면 신천리 220-836.2965127.9644