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 1 other fieldsHigh correlation
습도값 is highly overall correlated with 온도값High correlation
일사값 is highly overall correlated with 온도값High correlation
측정일시 has unique valuesUnique
풍향값 has 3 (1.5%) zerosZeros
풍속값 has 73 (36.5%) zerosZeros

Reproduction

Analysis started2023-12-10 06:20:33.408319
Analysis finished2023-12-10 06:20:38.281001
Duration4.87 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:20:38.398808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:38.624102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

온도값
Real number (ℝ)

HIGH CORRELATION 

Distinct168
Distinct (%)84.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-5.0259
Minimum-10.3
Maximum0.31
Zeros1
Zeros (%)0.5%
Negative194
Negative (%)97.0%
Memory size1.9 KiB
2023-12-10T15:20:38.929167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-10.3
5-th percentile-9.9515
Q1-7.475
median-6.005
Q3-1.445
95-th percentile-0.1085
Maximum0.31
Range10.61
Interquartile range (IQR)6.03

Descriptive statistics

Standard deviation3.3495733
Coefficient of variation (CV)-0.66646239
Kurtosis-1.3452088
Mean-5.0259
Median Absolute Deviation (MAD)2.87
Skewness0.11064788
Sum-1005.18
Variance11.219641
MonotonicityNot monotonic
2023-12-10T15:20:39.209315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-10.0 3
 
1.5%
-1.25 3
 
1.5%
-5.85 3
 
1.5%
-6.17 2
 
1.0%
-6.32 2
 
1.0%
-6.09 2
 
1.0%
-0.27 2
 
1.0%
-6.33 2
 
1.0%
-3.32 2
 
1.0%
-1.19 2
 
1.0%
Other values (158) 177
88.5%
ValueCountFrequency (%)
-10.3 2
1.0%
-10.2 1
 
0.5%
-10.1 2
1.0%
-10.0 3
1.5%
-9.98 2
1.0%
-9.95 2
1.0%
-9.93 1
 
0.5%
-9.91 1
 
0.5%
-9.9 1
 
0.5%
-9.88 1
 
0.5%
ValueCountFrequency (%)
0.31 1
0.5%
0.24 1
0.5%
0.21 2
1.0%
0.12 1
0.5%
0.0 1
0.5%
-0.04 1
0.5%
-0.05 1
0.5%
-0.06 1
0.5%
-0.08 1
0.5%
-0.11 1
0.5%

습도값
Real number (ℝ)

HIGH CORRELATION 

Distinct121
Distinct (%)60.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean65.8195
Minimum49.7
Maximum76.3
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:20:39.531972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum49.7
5-th percentile54.065
Q162.1
median66.15
Q369.6
95-th percentile75.6
Maximum76.3
Range26.6
Interquartile range (IQR)7.5

Descriptive statistics

Standard deviation6.2798849
Coefficient of variation (CV)0.095410705
Kurtosis-0.24698011
Mean65.8195
Median Absolute Deviation (MAD)3.85
Skewness-0.45659734
Sum13163.9
Variance39.436955
MonotonicityNot monotonic
2023-12-10T15:20:39.968804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
69.6 5
 
2.5%
69.4 4
 
2.0%
68.9 4
 
2.0%
69.3 4
 
2.0%
69.0 4
 
2.0%
62.3 4
 
2.0%
74.9 4
 
2.0%
53.1 3
 
1.5%
64.8 3
 
1.5%
61.6 3
 
1.5%
Other values (111) 162
81.0%
ValueCountFrequency (%)
49.7 1
 
0.5%
50.1 1
 
0.5%
50.2 1
 
0.5%
52.2 1
 
0.5%
52.4 1
 
0.5%
52.7 1
 
0.5%
53.1 3
1.5%
53.4 1
 
0.5%
54.1 1
 
0.5%
54.5 2
1.0%
ValueCountFrequency (%)
76.3 2
1.0%
76.2 1
 
0.5%
76.1 1
 
0.5%
76.0 1
 
0.5%
75.9 1
 
0.5%
75.7 3
1.5%
75.6 2
1.0%
75.3 1
 
0.5%
75.2 2
1.0%
75.1 1
 
0.5%

풍향값
Real number (ℝ)

ZEROS 

Distinct112
Distinct (%)56.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean178.82
Minimum0
Maximum285
Zeros3
Zeros (%)1.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:20:40.243181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile97
Q1154.5
median179.5
Q3220.25
95-th percentile255.05
Maximum285
Range285
Interquartile range (IQR)65.75

Descriptive statistics

Standard deviation51.16863
Coefficient of variation (CV)0.28614602
Kurtosis1.0583302
Mean178.82
Median Absolute Deviation (MAD)34.5
Skewness-0.57850328
Sum35764
Variance2618.2287
MonotonicityNot monotonic
2023-12-10T15:20:41.037112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
161 11
 
5.5%
172 8
 
4.0%
182 7
 
3.5%
157 6
 
3.0%
227 4
 
2.0%
231 4
 
2.0%
135 3
 
1.5%
190 3
 
1.5%
180 3
 
1.5%
175 3
 
1.5%
Other values (102) 148
74.0%
ValueCountFrequency (%)
0 3
1.5%
67 1
 
0.5%
68 1
 
0.5%
71 1
 
0.5%
86 1
 
0.5%
88 1
 
0.5%
96 1
 
0.5%
97 2
1.0%
101 1
 
0.5%
102 1
 
0.5%
ValueCountFrequency (%)
285 1
0.5%
284 1
0.5%
283 1
0.5%
276 2
1.0%
271 1
0.5%
265 1
0.5%
264 1
0.5%
258 1
0.5%
256 1
0.5%
255 1
0.5%

풍속값
Real number (ℝ)

ZEROS 

Distinct20
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.4575
Minimum0
Maximum1.9
Zeros73
Zeros (%)36.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:20:41.272605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.3
Q30.7
95-th percentile1.605
Maximum1.9
Range1.9
Interquartile range (IQR)0.7

Descriptive statistics

Standard deviation0.52240625
Coefficient of variation (CV)1.1418716
Kurtosis0.55526993
Mean0.4575
Median Absolute Deviation (MAD)0.3
Skewness1.1668784
Sum91.5
Variance0.27290829
MonotonicityNot monotonic
2023-12-10T15:20:41.481083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
0.0 73
36.5%
0.3 21
 
10.5%
0.4 17
 
8.5%
0.7 10
 
5.0%
0.6 10
 
5.0%
0.5 9
 
4.5%
0.1 8
 
4.0%
0.9 7
 
3.5%
1.1 6
 
3.0%
1.0 6
 
3.0%
Other values (10) 33
16.5%
ValueCountFrequency (%)
0.0 73
36.5%
0.1 8
 
4.0%
0.2 5
 
2.5%
0.3 21
 
10.5%
0.4 17
 
8.5%
0.5 9
 
4.5%
0.6 10
 
5.0%
0.7 10
 
5.0%
0.8 5
 
2.5%
0.9 7
 
3.5%
ValueCountFrequency (%)
1.9 5
2.5%
1.8 3
1.5%
1.7 2
 
1.0%
1.6 1
 
0.5%
1.5 4
2.0%
1.4 1
 
0.5%
1.3 5
2.5%
1.2 2
 
1.0%
1.1 6
3.0%
1.0 6
3.0%

일사값
Real number (ℝ)

HIGH CORRELATION 

Distinct149
Distinct (%)74.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1029.9611
Minimum926.01
Maximum1263
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:20:41.738146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum926.01
5-th percentile940.1455
Q1956.6575
median975.82
Q31092.1825
95-th percentile1205.86
Maximum1263
Range336.99
Interquartile range (IQR)135.525

Descriptive statistics

Standard deviation96.116275
Coefficient of variation (CV)0.093320292
Kurtosis-0.75405869
Mean1029.9611
Median Absolute Deviation (MAD)31.01
Skewness0.88627018
Sum205992.23
Variance9238.3383
MonotonicityNot monotonic
2023-12-10T15:20:42.089299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
950.92 5
 
2.5%
951.89 5
 
2.5%
968.01 3
 
1.5%
984.13 3
 
1.5%
986.08 3
 
1.5%
939.68 3
 
1.5%
973.38 3
 
1.5%
975.34 3
 
1.5%
945.05 3
 
1.5%
966.06 3
 
1.5%
Other values (139) 166
83.0%
ValueCountFrequency (%)
926.01 1
 
0.5%
933.33 1
 
0.5%
934.31 1
 
0.5%
934.8 1
 
0.5%
935.29 1
 
0.5%
935.78 1
 
0.5%
936.26 1
 
0.5%
939.68 3
1.5%
940.17 1
 
0.5%
941.15 2
1.0%
ValueCountFrequency (%)
1263.0 1
 
0.5%
1244.44 1
 
0.5%
1240.05 1
 
0.5%
1222.47 1
 
0.5%
1221.98 1
 
0.5%
1217.58 1
 
0.5%
1213.19 1
 
0.5%
1211.72 1
 
0.5%
1207.33 1
 
0.5%
1205.86 3
1.5%

측정주소
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
세종특별자치시 연동면 예양리 842-9 10번지
200 

Length

Max length26
Median length26
Mean length26
Min length26

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세종특별자치시 연동면 예양리 842-9 10번지
2nd row세종특별자치시 연동면 예양리 842-9 10번지
3rd row세종특별자치시 연동면 예양리 842-9 10번지
4th row세종특별자치시 연동면 예양리 842-9 10번지
5th row세종특별자치시 연동면 예양리 842-9 10번지

Common Values

ValueCountFrequency (%)
세종특별자치시 연동면 예양리 842-9 10번지 200
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:20:42.529870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
세종특별자치시 200
20.0%
연동면 200
20.0%
예양리 200
20.0%
842-9 200
20.0%
10번지 200
20.0%

위도값
Categorical

CONSTANT 

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

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
36.5719 200
100.0%

Length

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

Common Values (Plot)

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

경도값
Categorical

CONSTANT 

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

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
127.3205 200
100.0%

Length

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

Common Values (Plot)

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

Interactions

2023-12-10T15:20:37.146387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:33.744100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:34.606379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:35.418916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:36.228566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:37.300767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:33.917497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:34.762884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:35.572250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:36.384603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:37.440869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:34.102907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:34.903551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:35.739299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:36.582413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:37.612958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:34.277087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:35.086366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:35.902946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:36.767612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:37.762752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:34.440628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:35.246848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:36.073539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:20:36.962176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:20:43.552966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도값습도값풍향값풍속값일사값
온도값1.0000.9220.6990.6770.851
습도값0.9221.0000.5250.4960.695
풍향값0.6990.5251.0000.4180.424
풍속값0.6770.4960.4181.0000.271
일사값0.8510.6950.4240.2711.000
2023-12-10T15:20:43.774928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도값습도값풍향값풍속값일사값
온도값1.000-0.574-0.0130.4410.752
습도값-0.5741.0000.072-0.325-0.367
풍향값-0.0130.0721.0000.295-0.235
풍속값0.441-0.3250.2951.0000.211
일사값0.752-0.367-0.2350.2111.000

Missing values

2023-12-10T15:20:37.962049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:20:38.186045image/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-6.0869.12650.9970.45세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
12021-01-01 0:05-6.0469.12310.4954.33세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
22021-01-01 0:10-5.9469.01860.1987.06세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
32021-01-01 0:15-6.0169.41910.3944.57세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
42021-01-01 0:20-5.9168.91990.7970.45세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
52021-01-01 0:25-5.7969.41160.5951.89세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
62021-01-01 0:30-5.7668.62261.1990.48세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
72021-01-01 0:35-5.8569.31931.3988.03세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
82021-01-01 0:40-5.7769.32351.9961.17세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
92021-01-01 0:45-5.7869.32310.5954.82세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
측정일시온도값습도값풍향값풍속값일사값측정주소위도값경도값
1902021-01-01 15:50-0.1161.31870.31072.04세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1912021-01-01 15:55-0.2361.62000.01055.92세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1922021-01-01 16:00-0.0862.41850.41092.06세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1932021-01-01 16:05-0.0563.01690.01054.95세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1942021-01-01 16:10-0.2763.21720.61079.37세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1952021-01-01 16:15-0.4964.72410.91181.93세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1962021-01-01 16:20-0.6265.91950.91144.32세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1972021-01-01 16:25-0.7667.22551.51116.97세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1982021-01-01 16:30-0.7567.72380.71170.7세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205
1992021-01-01 16:35-0.6667.41920.31161.42세종특별자치시 연동면 예양리 842-9 10번지36.5719127.3205