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 온도값 and 2 other fieldsHigh correlation
풍속값 is highly overall correlated with 온도값 and 2 other fieldsHigh correlation
일사값 is highly overall correlated with 온도값 and 2 other fieldsHigh correlation
측정일시 has unique valuesUnique
풍향값 has 13 (6.5%) zerosZeros
풍속값 has 67 (33.5%) zerosZeros

Reproduction

Analysis started2023-12-10 06:32:12.409232
Analysis finished2023-12-10 06:32:17.565577
Duration5.16 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:32:17.696161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:18.053931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

온도값
Real number (ℝ)

HIGH CORRELATION 

Distinct170
Distinct (%)85.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-4.37535
Minimum-10.7
Maximum3.69
Zeros0
Zeros (%)0.0%
Negative131
Negative (%)65.5%
Memory size1.9 KiB
2023-12-10T15:32:18.294552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-10.7
5-th percentile-9.9035
Q1-8.765
median-7.2
Q30.855
95-th percentile2.522
Maximum3.69
Range14.39
Interquartile range (IQR)9.62

Descriptive statistics

Standard deviation4.8268651
Coefficient of variation (CV)-1.1031952
Kurtosis-1.6494293
Mean-4.37535
Median Absolute Deviation (MAD)2.665
Skewness0.27627367
Sum-875.07
Variance23.298627
MonotonicityNot monotonic
2023-12-10T15:32:18.625878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-7.79 4
 
2.0%
0.49 3
 
1.5%
-9.04 3
 
1.5%
-8.85 3
 
1.5%
-7.75 2
 
1.0%
0.96 2
 
1.0%
-10.5 2
 
1.0%
-7.18 2
 
1.0%
-10.6 2
 
1.0%
1.75 2
 
1.0%
Other values (160) 175
87.5%
ValueCountFrequency (%)
-10.7 1
0.5%
-10.6 2
1.0%
-10.5 2
1.0%
-10.4 2
1.0%
-10.2 1
0.5%
-10.0 1
0.5%
-9.97 1
0.5%
-9.9 1
0.5%
-9.88 1
0.5%
-9.85 1
0.5%
ValueCountFrequency (%)
3.69 1
0.5%
3.34 1
0.5%
3.33 1
0.5%
3.26 1
0.5%
3.08 1
0.5%
2.97 1
0.5%
2.82 1
0.5%
2.72 1
0.5%
2.71 1
0.5%
2.56 1
0.5%

습도값
Real number (ℝ)

HIGH CORRELATION 

Distinct39
Distinct (%)19.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean77.175
Minimum58
Maximum96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:32:18.867959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum58
5-th percentile60
Q164
median78
Q390
95-th percentile94
Maximum96
Range38
Interquartile range (IQR)26

Descriptive statistics

Standard deviation12.245577
Coefficient of variation (CV)0.15867284
Kurtosis-1.4993347
Mean77.175
Median Absolute Deviation (MAD)12
Skewness-0.042797261
Sum15435
Variance149.95415
MonotonicityNot monotonic
2023-12-10T15:32:19.187002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
90 16
 
8.0%
91 12
 
6.0%
63 12
 
6.0%
60 10
 
5.0%
79 9
 
4.5%
61 9
 
4.5%
92 9
 
4.5%
64 9
 
4.5%
93 7
 
3.5%
62 7
 
3.5%
Other values (29) 100
50.0%
ValueCountFrequency (%)
58 1
 
0.5%
59 5
2.5%
60 10
5.0%
61 9
4.5%
62 7
3.5%
63 12
6.0%
64 9
4.5%
65 4
 
2.0%
66 3
 
1.5%
67 4
 
2.0%
ValueCountFrequency (%)
96 4
 
2.0%
95 3
 
1.5%
94 6
 
3.0%
93 7
3.5%
92 9
4.5%
91 12
6.0%
90 16
8.0%
89 3
 
1.5%
88 1
 
0.5%
87 5
 
2.5%

풍향값
Real number (ℝ)

ZEROS 

Distinct91
Distinct (%)45.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201.115
Minimum0
Maximum359
Zeros13
Zeros (%)6.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:32:19.601092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q185.25
median155
Q3331
95-th percentile355
Maximum359
Range359
Interquartile range (IQR)245.75

Descriptive statistics

Standard deviation128.60391
Coefficient of variation (CV)0.63945461
Kurtosis-1.5489665
Mean201.115
Median Absolute Deviation (MAD)142
Skewness-0.14453211
Sum40223
Variance16538.967
MonotonicityNot monotonic
2023-12-10T15:32:19.948215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
155 25
 
12.5%
355 25
 
12.5%
0 13
 
6.5%
134 7
 
3.5%
309 4
 
2.0%
297 4
 
2.0%
351 4
 
2.0%
295 4
 
2.0%
60 3
 
1.5%
331 3
 
1.5%
Other values (81) 108
54.0%
ValueCountFrequency (%)
0 13
6.5%
5 1
 
0.5%
6 3
 
1.5%
8 1
 
0.5%
9 1
 
0.5%
12 1
 
0.5%
14 1
 
0.5%
18 3
 
1.5%
34 1
 
0.5%
38 2
 
1.0%
ValueCountFrequency (%)
359 3
 
1.5%
355 25
12.5%
353 2
 
1.0%
351 4
 
2.0%
350 1
 
0.5%
346 2
 
1.0%
342 1
 
0.5%
340 1
 
0.5%
339 2
 
1.0%
338 1
 
0.5%

풍속값
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct31
Distinct (%)15.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.735
Minimum0
Maximum3.5
Zeros67
Zeros (%)33.5%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:32:20.248213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.6
Q31.1
95-th percentile2.405
Maximum3.5
Range3.5
Interquartile range (IQR)1.1

Descriptive statistics

Standard deviation0.8003611
Coefficient of variation (CV)1.0889267
Kurtosis0.93926203
Mean0.735
Median Absolute Deviation (MAD)0.6
Skewness1.1977588
Sum147
Variance0.64057789
MonotonicityNot monotonic
2023-12-10T15:32:20.522574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
0.0 67
33.5%
0.6 14
 
7.0%
0.8 11
 
5.5%
0.4 10
 
5.0%
0.5 9
 
4.5%
0.7 8
 
4.0%
0.9 8
 
4.0%
1.1 7
 
3.5%
1.5 6
 
3.0%
1.2 6
 
3.0%
Other values (21) 54
27.0%
ValueCountFrequency (%)
0.0 67
33.5%
0.1 2
 
1.0%
0.2 5
 
2.5%
0.3 5
 
2.5%
0.4 10
 
5.0%
0.5 9
 
4.5%
0.6 14
 
7.0%
0.7 8
 
4.0%
0.8 11
 
5.5%
0.9 8
 
4.0%
ValueCountFrequency (%)
3.5 1
 
0.5%
3.3 1
 
0.5%
3.0 1
 
0.5%
2.9 1
 
0.5%
2.8 2
1.0%
2.7 1
 
0.5%
2.6 1
 
0.5%
2.5 2
1.0%
2.4 3
1.5%
2.2 3
1.5%

일사값
Real number (ℝ)

HIGH CORRELATION 

Distinct111
Distinct (%)55.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean259.9724
Minimum3.91
Maximum915.26
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:32:20.745374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.91
5-th percentile4.4
Q14.88
median63.735
Q3550.065
95-th percentile780.6065
Maximum915.26
Range911.35
Interquartile range (IQR)545.185

Descriptive statistics

Standard deviation301.54901
Coefficient of variation (CV)1.159927
Kurtosis-1.1959634
Mean259.9724
Median Absolute Deviation (MAD)59.335
Skewness0.65999028
Sum51994.48
Variance90931.808
MonotonicityNot monotonic
2023-12-10T15:32:21.430113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4.88 41
20.5%
5.37 23
 
11.5%
4.4 21
 
10.5%
5.86 3
 
1.5%
9.77 2
 
1.0%
355.56 2
 
1.0%
86.94 2
 
1.0%
644.2 2
 
1.0%
696.46 2
 
1.0%
561.17 1
 
0.5%
Other values (101) 101
50.5%
ValueCountFrequency (%)
3.91 1
 
0.5%
4.4 21
10.5%
4.88 41
20.5%
5.37 23
11.5%
5.86 3
 
1.5%
6.35 1
 
0.5%
7.33 1
 
0.5%
9.77 2
 
1.0%
12.21 1
 
0.5%
15.14 1
 
0.5%
ValueCountFrequency (%)
915.26 1
0.5%
881.56 1
0.5%
865.93 1
0.5%
849.82 1
0.5%
818.07 1
0.5%
817.09 1
0.5%
801.47 1
0.5%
792.67 1
0.5%
785.84 1
0.5%
783.39 1
0.5%

측정주소
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
인천광역시 계양구 동양동 26-4
200 

Length

Max length18
Median length18
Mean length18
Min length18

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천광역시 계양구 동양동 26-4
2nd row인천광역시 계양구 동양동 26-4
3rd row인천광역시 계양구 동양동 26-4
4th row인천광역시 계양구 동양동 26-4
5th row인천광역시 계양구 동양동 26-4

Common Values

ValueCountFrequency (%)
인천광역시 계양구 동양동 26-4 200
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:32:21.854563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 200
25.0%
계양구 200
25.0%
동양동 200
25.0%
26-4 200
25.0%

위도값
Categorical

CONSTANT 

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

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row37.5636
2nd row37.5636
3rd row37.5636
4th row37.5636
5th row37.5636

Common Values

ValueCountFrequency (%)
37.5636 200
100.0%

Length

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

Common Values (Plot)

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

경도값
Categorical

CONSTANT 

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

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row126.7696
2nd row126.7696
3rd row126.7696
4th row126.7696
5th row126.7696

Common Values

ValueCountFrequency (%)
126.7696 200
100.0%

Length

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

Common Values (Plot)

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

Interactions

2023-12-10T15:32:16.305308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:12.929184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:13.801324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:14.643234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:15.440542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:16.488616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:13.099044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:13.967307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:14.807106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:15.627983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:16.660221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:13.300035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:14.122169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:14.974513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:15.811864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:16.839571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:13.470457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:14.312181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:15.127450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:16.000127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:17.009961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:13.649894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:14.493632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:15.289852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:32:16.152654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:32:22.722129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도값습도값풍향값풍속값일사값
온도값1.0000.9050.6840.6900.868
습도값0.9051.0000.6260.6960.836
풍향값0.6840.6261.0000.5370.523
풍속값0.6900.6960.5371.0000.688
일사값0.8680.8360.5230.6881.000
2023-12-10T15:32:22.915391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온도값습도값풍향값풍속값일사값
온도값1.000-0.924-0.3130.6530.847
습도값-0.9241.0000.180-0.604-0.866
풍향값-0.3130.1801.000-0.288-0.170
풍속값0.653-0.604-0.2881.0000.609
일사값0.847-0.866-0.1700.6091.000

Missing values

2023-12-10T15:32:17.205295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:32:17.475817image/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-7.98791540.74.4인천광역시 계양구 동양동 26-437.5636126.7696
12021-01-01 0:05-7.89791550.54.88인천광역시 계양구 동양동 26-437.5636126.7696
22021-01-01 0:10-7.85791550.35.37인천광역시 계양구 동양동 26-437.5636126.7696
32021-01-01 0:15-7.92791550.04.88인천광역시 계양구 동양동 26-437.5636126.7696
42021-01-01 0:20-7.97791550.04.88인천광역시 계양구 동양동 26-437.5636126.7696
52021-01-01 0:25-7.87791550.05.37인천광역시 계양구 동양동 26-437.5636126.7696
62021-01-01 0:30-7.79791550.04.88인천광역시 계양구 동양동 26-437.5636126.7696
72021-01-01 0:35-7.6781550.04.88인천광역시 계양구 동양동 26-437.5636126.7696
82021-01-01 0:40-7.46771550.04.4인천광역시 계양구 동양동 26-437.5636126.7696
92021-01-01 0:45-7.57781550.04.88인천광역시 계양구 동양동 26-437.5636126.7696
측정일시온도값습도값풍향값풍속값일사값측정주소위도값경도값
1902021-01-01 15:501.48701102.2302.32인천광역시 계양구 동양동 26-437.5636126.7696
1912021-01-01 15:550.9173391.9149.94인천광역시 계양구 동양동 26-437.5636126.7696
1922021-01-01 16:001.1373601.0118.68인천광역시 계양구 동양동 26-437.5636126.7696
1932021-01-01 16:051.1171561.6111.84인천광역시 계양구 동양동 26-437.5636126.7696
1942021-01-01 16:100.7471882.1243.71인천광역시 계양구 동양동 26-437.5636126.7696
1952021-01-01 16:150.6373602.486.94인천광역시 계양구 동양동 26-437.5636126.7696
1962021-01-01 16:200.3275721.986.94인천광역시 계양구 동양동 26-437.5636126.7696
1972021-01-01 16:250.2776661.390.35인천광역시 계양구 동양동 26-437.5636126.7696
1982021-01-01 16:300.1876762.291.33인천광역시 계양구 동양동 26-437.5636126.7696
1992021-01-01 16:350.1477821.476.68인천광역시 계양구 동양동 26-437.5636126.7696