Dataset statistics
Number of variables | 9 |
---|---|
Number of observations | 200 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 15.6 KiB |
Average record size in memory | 79.7 B |
Variable types
DateTime | 1 |
---|---|
Numeric | 5 |
Categorical | 3 |
Dataset
Description | Sample |
---|---|
Author | 충북대학교 |
URL | https://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=CBUCUCUMBEROUTENV |
측정주소 has constant value "" | Constant |
위도값 has constant value "" | Constant |
경도값 has constant value "" | Constant |
온도값 is highly overall correlated with 풍향값 and 2 other fields | High correlation |
습도값 is highly overall correlated with 풍속값 | High correlation |
풍향값 is highly overall correlated with 온도값 and 1 other fields | High correlation |
풍속값 is highly overall correlated with 온도값 and 1 other fields | High correlation |
일사값 is highly overall correlated with 온도값 and 1 other fields | High correlation |
측정일시 has unique values | Unique |
풍향값 has 5 (2.5%) zeros | Zeros |
풍속값 has 22 (11.0%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-10 06:12:26.538740 |
---|---|
Analysis finished | 2023-12-10 06:12:34.240490 |
Duration | 7.7 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
측정일시
Date
UNIQUE
 
Distinct | 200 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
Minimum | 2021-01-01 00:00:00 |
---|---|
Maximum | 2021-01-01 16:35:00 |
온도값
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 127 |
---|---|
Distinct (%) | 63.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -214.0594 |
Minimum | -999 |
---|---|
Maximum | -1.22 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 200 |
Negative (%) | 100.0% |
Memory size | 1.9 KiB |
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 |
Range | 997.78 |
Interquartile range (IQR) | 3.54 |
Descriptive statistics
Standard deviation | 405.71896 |
---|---|
Coefficient of variation (CV) | -1.8953569 |
Kurtosis | 0.058960907 |
Mean | -214.0594 |
Median Absolute Deviation (MAD) | 1.635 |
Skewness | -1.4346987 |
Sum | -42811.88 |
Variance | 164607.88 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-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 |
Value | Count | Frequency (%) |
-999.0 | 42 | |
-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% |
Value | Count | Frequency (%) |
-1.22 | 2 | |
-1.27 | 1 | |
-1.34 | 2 | |
-1.94 | 2 | |
-2.1 | 1 | |
-2.24 | 2 | |
-2.3 | 2 | |
-2.34 | 1 | |
-2.39 | 2 | |
-2.42 | 2 |
습도값
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 19 |
---|---|
Distinct (%) | 9.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -144.275 |
Minimum | -999 |
---|---|
Maximum | 94 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 42 |
Negative (%) | 21.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | -999 |
---|---|
5-th percentile | -999 |
Q1 | 78 |
median | 81 |
Q3 | 84 |
95-th percentile | 89.05 |
Maximum | 94 |
Range | 1093 |
Interquartile range (IQR) | 6 |
Descriptive statistics
Standard deviation | 441.79796 |
---|---|
Coefficient of variation (CV) | -3.0621934 |
Kurtosis | 0.058776876 |
Mean | -144.275 |
Median Absolute Deviation (MAD) | 3 |
Skewness | -1.4345481 |
Sum | -28855 |
Variance | 195185.44 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-999 | 42 | |
81 | 35 | |
80 | 25 | |
83 | 17 | |
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 |
Value | Count | Frequency (%) |
-999 | 42 | |
77 | 3 | 1.5% |
78 | 8 | 4.0% |
79 | 8 | 4.0% |
80 | 25 | |
81 | 35 | |
82 | 10 | 5.0% |
83 | 17 | |
84 | 12 | 6.0% |
85 | 1 | 0.5% |
Value | Count | Frequency (%) |
94 | 3 | 1.5% |
93 | 1 | 0.5% |
92 | 2 | 1.0% |
91 | 2 | 1.0% |
90 | 2 | 1.0% |
89 | 5 | |
88 | 8 | |
87 | 11 | |
86 | 5 | |
85 | 1 | 0.5% |
풍향값
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 89 |
---|---|
Distinct (%) | 44.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -121.245 |
Minimum | -999 |
---|---|
Maximum | 354 |
Zeros | 5 |
Zeros (%) | 2.5% |
Negative | 42 |
Negative (%) | 21.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | -999 |
---|---|
5-th percentile | -999 |
Q1 | 4.5 |
median | 64 |
Q3 | 123 |
95-th percentile | 321 |
Maximum | 354 |
Range | 1353 |
Interquartile range (IQR) | 118.5 |
Descriptive statistics
Standard deviation | 460.93558 |
---|---|
Coefficient of variation (CV) | -3.8016874 |
Kurtosis | -0.062660536 |
Mean | -121.245 |
Median Absolute Deviation (MAD) | 59 |
Skewness | -1.3131171 |
Sum | -24249 |
Variance | 212461.61 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-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 |
Value | Count | Frequency (%) |
-999 | 42 | |
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% |
Value | Count | Frequency (%) |
354 | 7 | |
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
 
Distinct | 32 |
---|---|
Distinct (%) | 16.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -208.9225 |
Minimum | -999 |
---|---|
Maximum | 4.3 |
Zeros | 22 |
Zeros (%) | 11.0% |
Negative | 42 |
Negative (%) | 21.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | -999 |
---|---|
5-th percentile | -999 |
Q1 | 0 |
median | 0.85 |
Q3 | 1.4 |
95-th percentile | 2.6 |
Maximum | 4.3 |
Range | 1003.3 |
Interquartile range (IQR) | 1.4 |
Descriptive statistics
Standard deviation | 408.37104 |
---|---|
Coefficient of variation (CV) | -1.9546532 |
Kurtosis | 0.05902973 |
Mean | -208.9225 |
Median Absolute Deviation (MAD) | 0.85 |
Skewness | -1.4347546 |
Sum | -41784.5 |
Variance | 166766.91 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
-999.0 | 42 | |
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 |
Value | Count | Frequency (%) |
-999.0 | 42 | |
0.0 | 22 | |
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% |
Value | Count | Frequency (%) |
4.3 | 1 | 0.5% |
3.3 | 1 | 0.5% |
2.9 | 1 | 0.5% |
2.8 | 4 | |
2.7 | 1 | 0.5% |
2.6 | 3 | |
2.5 | 1 | 0.5% |
2.4 | 2 | |
2.3 | 1 | 0.5% |
2.2 | 1 | 0.5% |
일사값
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 63 |
---|---|
Distinct (%) | 31.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | -155.71885 |
Minimum | -999 |
---|---|
Maximum | 371.67 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 42 |
Negative (%) | 21.0% |
Memory size | 1.9 KiB |
Quantile statistics
Minimum | -999 |
---|---|
5-th percentile | -999 |
Q1 | 10.26 |
median | 10.26 |
Q3 | 89.74 |
95-th percentile | 233.8995 |
Maximum | 371.67 |
Range | 1370.67 |
Interquartile range (IQR) | 79.48 |
Descriptive statistics
Standard deviation | 442.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 |
Variance | 195559.16 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
10.26 | 58 | |
-999.0 | 42 | |
10.74 | 27 | |
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 |
Value | Count | Frequency (%) |
-999.0 | 42 | |
9.77 | 2 | 1.0% |
10.26 | 58 | |
10.74 | 27 | |
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% |
Value | Count | Frequency (%) |
371.67 | 1 | |
325.27 | 1 | |
264.22 | 1 | |
255.43 | 1 | |
254.46 | 1 | |
253.97 | 2 | |
246.15 | 1 | |
245.67 | 1 | |
242.25 | 1 | |
233.46 | 1 |
측정주소
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
경상북도 상주시 모동면 신천리 220-8 |
---|
Length
Max length | 22 |
---|---|
Median length | 22 |
Mean length | 22 |
Min length | 22 |
Unique
Unique | 0 ? |
---|---|
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
Value | Count | Frequency (%) |
경상북도 상주시 모동면 신천리 220-8 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
경상북도 | 200 | |
상주시 | 200 | |
모동면 | 200 | |
신천리 | 200 | |
220-8 | 200 |
위도값
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
36.2965 |
---|
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 7 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 36.2965 |
---|---|
2nd row | 36.2965 |
3rd row | 36.2965 |
4th row | 36.2965 |
5th row | 36.2965 |
Common Values
Value | Count | Frequency (%) |
36.2965 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
36.2965 | 200 |
경도값
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.7 KiB |
127.9644 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 127.9644 |
---|---|
2nd row | 127.9644 |
3rd row | 127.9644 |
4th row | 127.9644 |
5th row | 127.9644 |
Common Values
Value | Count | Frequency (%) |
127.9644 | 200 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
127.9644 | 200 |
온도값 | 습도값 | 풍향값 | 풍속값 | 일사값 | |
---|---|---|---|---|---|
온도값 | 1.000 | NaN | NaN | NaN | NaN |
습도값 | NaN | 1.000 | NaN | NaN | NaN |
풍향값 | NaN | NaN | 1.000 | NaN | 0.480 |
풍속값 | NaN | NaN | NaN | 1.000 | NaN |
일사값 | NaN | NaN | 0.480 | NaN | 1.000 |
온도값 | 습도값 | 풍향값 | 풍속값 | 일사값 | |
---|---|---|---|---|---|
온도값 | 1.000 | 0.382 | 0.694 | 0.556 | 0.794 |
습도값 | 0.382 | 1.000 | 0.419 | 0.714 | 0.216 |
풍향값 | 0.694 | 0.419 | 1.000 | 0.415 | 0.618 |
풍속값 | 0.556 | 0.714 | 0.415 | 1.000 | 0.411 |
일사값 | 0.794 | 0.216 | 0.618 | 0.411 | 1.000 |
측정일시 | 온도값 | 습도값 | 풍향값 | 풍속값 | 일사값 | 측정주소 | 위도값 | 경도값 | |
---|---|---|---|---|---|---|---|---|---|
0 | 2021-01-01 0:00 | -5.69 | 89 | 94 | 0.5 | 10.74 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
1 | 2021-01-01 0:05 | -5.61 | 89 | 66 | 0.7 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
2 | 2021-01-01 0:10 | -5.87 | 88 | 61 | 0.1 | 10.74 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
3 | 2021-01-01 0:15 | -5.44 | 88 | 63 | 0.5 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
4 | 2021-01-01 0:20 | -5.32 | 88 | 35 | 1.9 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
5 | 2021-01-01 0:25 | -5.77 | 87 | 99 | 0.5 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
6 | 2021-01-01 0:30 | -5.7 | 87 | 61 | 1.0 | 9.77 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
7 | 2021-01-01 0:35 | -5.76 | 87 | 73 | 1.1 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
8 | 2021-01-01 0:40 | -5.69 | 87 | 67 | 2.1 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
9 | 2021-01-01 0:45 | -5.66 | 87 | 51 | 1.0 | 10.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
측정일시 | 온도값 | 습도값 | 풍향값 | 풍속값 | 일사값 | 측정주소 | 위도값 | 경도값 | |
---|---|---|---|---|---|---|---|---|---|
190 | 2021-01-01 15:50 | -999.0 | -999 | -999 | -999.0 | -999.0 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
191 | 2021-01-01 15:55 | -999.0 | -999 | -999 | -999.0 | -999.0 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
192 | 2021-01-01 16:00 | -999.0 | -999 | -999 | -999.0 | -999.0 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
193 | 2021-01-01 16:05 | -999.0 | -999 | -999 | -999.0 | -999.0 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
194 | 2021-01-01 16:10 | -1.34 | 79 | 193 | 1.2 | 42.98 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
195 | 2021-01-01 16:15 | -1.34 | 79 | 193 | 1.2 | 42.98 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
196 | 2021-01-01 16:20 | -999.0 | -999 | -999 | -999.0 | -999.0 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
197 | 2021-01-01 16:25 | -1.22 | 80 | 321 | 1.0 | 73.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
198 | 2021-01-01 16:30 | -1.22 | 80 | 321 | 1.0 | 73.26 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |
199 | 2021-01-01 16:35 | -1.27 | 79 | 235 | 0.8 | 32.72 | 경상북도 상주시 모동면 신천리 220-8 | 36.2965 | 127.9644 |