Overview

Dataset statistics

Number of variables6
Number of observations1178
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory58.8 KiB
Average record size in memory51.1 B

Variable types

Categorical2
DateTime1
Numeric3

Dataset

Description한국지역난방공사의 기상관측 정보로 지사명, 주소명, 일자, 최고기온, 최저기온, 평균기온 정보를 나타냅니다.
URLhttps://www.data.go.kr/data/15082997/fileData.do

Alerts

지사 is highly overall correlated with 주소명High 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 15 (1.3%) zerosZeros

Reproduction

Analysis started2023-12-12 19:10:47.630279
Analysis finished2023-12-12 19:10:49.530025
Duration1.9 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지사
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
파주
 
59
고양
 
59
평택
 
59
삼송
 
59
상암
 
59
Other values (15)
883 

Length

Max length4
Median length2
Mean length2.3005093
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row파주
2nd row파주
3rd row파주
4th row파주
5th row파주

Common Values

ValueCountFrequency (%)
파주 59
 
5.0%
고양 59
 
5.0%
평택 59
 
5.0%
삼송 59
 
5.0%
상암 59
 
5.0%
중앙 59
 
5.0%
서울남부 59
 
5.0%
판교 59
 
5.0%
분당 59
 
5.0%
용인 59
 
5.0%
Other values (10) 588
49.9%

Length

2023-12-13T04:10:49.940745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
파주 59
 
5.0%
고양 59
 
5.0%
동탄 59
 
5.0%
광주전남 59
 
5.0%
세종 59
 
5.0%
김해 59
 
5.0%
대구 59
 
5.0%
청주 59
 
5.0%
광교 59
 
5.0%
화성서부 59
 
5.0%
Other values (10) 588
49.9%

주소명
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
경기도 파주시 교하읍 청석로 380
 
59
경기도 고양시 일산동구 경의로 149
 
59
경기도 평택시 진위면 진위2산단로 15-40
 
59
경기도 고양시 덕양구 동축로 16
 
59
서울 마포구 하늘공원로 84
 
59
Other values (15)
883 

Length

Max length25
Median length20
Mean length18.601019
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 파주시 교하읍 청석로 380
2nd row경기도 파주시 교하읍 청석로 380
3rd row경기도 파주시 교하읍 청석로 380
4th row경기도 파주시 교하읍 청석로 380
5th row경기도 파주시 교하읍 청석로 380

Common Values

ValueCountFrequency (%)
경기도 파주시 교하읍 청석로 380 59
 
5.0%
경기도 고양시 일산동구 경의로 149 59
 
5.0%
경기도 평택시 진위면 진위2산단로 15-40 59
 
5.0%
경기도 고양시 덕양구 동축로 16 59
 
5.0%
서울 마포구 하늘공원로 84 59
 
5.0%
서울 마포구 토정로 56 59
 
5.0%
서울시 강남구 양재대로 781 59
 
5.0%
경기도 성남시 분당구 판교로 228번길 88 59
 
5.0%
경기도 성남시 분당구 분당로 368 59
 
5.0%
경기도 용인시 수지구 만헌로 11 59
 
5.0%
Other values (10) 588
49.9%

Length

2023-12-13T04:10:50.148770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 648
 
11.7%
16 118
 
2.1%
분당구 118
 
2.1%
성남시 118
 
2.1%
마포구 118
 
2.1%
서울 118
 
2.1%
화성시 118
 
2.1%
고양시 118
 
2.1%
영통구 117
 
2.1%
경남 117
 
2.1%
Other values (64) 3828
69.1%

일자
Date

Distinct59
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2022-01-01 00:00:00
Maximum2022-02-28 00:00:00
2023-12-13T04:10:50.301701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:50.459654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

최고
Real number (ℝ)

HIGH CORRELATION 

Distinct184
Distinct (%)15.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.7084041
Minimum-6.8
Maximum19.5
Zeros8
Zeros (%)0.7%
Negative139
Negative (%)11.8%
Memory size10.5 KiB
2023-12-13T04:10:50.599045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-6.8
5-th percentile-1.4
Q11.8
median4.4
Q37.6
95-th percentile11.415
Maximum19.5
Range26.3
Interquartile range (IQR)5.8

Descriptive statistics

Standard deviation4.0558093
Coefficient of variation (CV)0.86139789
Kurtosis-0.33974795
Mean4.7084041
Median Absolute Deviation (MAD)2.9
Skewness0.27012257
Sum5546.5
Variance16.449589
MonotonicityNot monotonic
2023-12-13T04:10:50.744519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.1 20
 
1.7%
0.9 18
 
1.5%
3.4 17
 
1.4%
5.4 16
 
1.4%
4.3 15
 
1.3%
2.6 15
 
1.3%
2.8 15
 
1.3%
2.2 15
 
1.3%
6.3 14
 
1.2%
7.3 13
 
1.1%
Other values (174) 1020
86.6%
ValueCountFrequency (%)
-6.8 1
 
0.1%
-4.5 1
 
0.1%
-4.4 1
 
0.1%
-4.2 3
0.3%
-4.1 1
 
0.1%
-3.7 2
0.2%
-3.5 1
 
0.1%
-3.4 2
0.2%
-3.2 1
 
0.1%
-3.1 1
 
0.1%
ValueCountFrequency (%)
19.5 1
0.1%
17.5 1
0.1%
16.8 1
0.1%
16.4 1
0.1%
16.1 1
0.1%
15.9 2
0.2%
15.6 1
0.1%
15.2 1
0.1%
14.9 1
0.1%
14.6 1
0.1%

최저
Real number (ℝ)

HIGH CORRELATION 

Distinct167
Distinct (%)14.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-5.3286078
Minimum-33.6
Maximum6.5
Zeros6
Zeros (%)0.5%
Negative1073
Negative (%)91.1%
Memory size10.5 KiB
2023-12-13T04:10:50.915777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-33.6
5-th percentile-10.415
Q1-8.075
median-5.8
Q3-2.8
95-th percentile1.5
Maximum6.5
Range40.1
Interquartile range (IQR)5.275

Descriptive statistics

Standard deviation3.7021092
Coefficient of variation (CV)-0.69476106
Kurtosis2.3160071
Mean-5.3286078
Median Absolute Deviation (MAD)2.5
Skewness0.047795234
Sum-6277.1
Variance13.705613
MonotonicityNot monotonic
2023-12-13T04:10:51.083758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-7.4 18
 
1.5%
-7.0 18
 
1.5%
-5.8 18
 
1.5%
-7.7 17
 
1.4%
-8.5 17
 
1.4%
-9.3 17
 
1.4%
-6.8 16
 
1.4%
-7.5 16
 
1.4%
-8.2 16
 
1.4%
-7.9 16
 
1.4%
Other values (157) 1009
85.7%
ValueCountFrequency (%)
-33.6 1
 
0.1%
-13.4 1
 
0.1%
-13.1 2
0.2%
-12.9 1
 
0.1%
-12.7 2
0.2%
-12.6 1
 
0.1%
-12.3 2
0.2%
-12.2 1
 
0.1%
-12.1 3
0.3%
-11.9 2
0.2%
ValueCountFrequency (%)
6.5 1
0.1%
6.4 1
0.1%
5.1 1
0.1%
5.0 1
0.1%
4.4 1
0.1%
4.0 1
0.1%
3.9 1
0.1%
3.7 2
0.2%
3.4 2
0.2%
3.3 2
0.2%

평균
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct160
Distinct (%)13.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.55093379
Minimum-8.2
Maximum9.6
Zeros15
Zeros (%)1.3%
Negative692
Negative (%)58.7%
Memory size10.5 KiB
2023-12-13T04:10:51.241532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-8.2
5-th percentile-5.7
Q1-3.2
median-0.9
Q32
95-th percentile5.6
Maximum9.6
Range17.8
Interquartile range (IQR)5.2

Descriptive statistics

Standard deviation3.4797367
Coefficient of variation (CV)-6.3160706
Kurtosis-0.57578725
Mean-0.55093379
Median Absolute Deviation (MAD)2.5
Skewness0.33330362
Sum-649
Variance12.108568
MonotonicityNot monotonic
2023-12-13T04:10:51.402384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-2.0 20
 
1.7%
-2.4 18
 
1.5%
-1.4 18
 
1.5%
-2.3 17
 
1.4%
-2.9 17
 
1.4%
-2.7 17
 
1.4%
-4.6 17
 
1.4%
-0.7 17
 
1.4%
-1.5 15
 
1.3%
-0.4 15
 
1.3%
Other values (150) 1007
85.5%
ValueCountFrequency (%)
-8.2 1
 
0.1%
-8.0 1
 
0.1%
-7.7 1
 
0.1%
-7.5 1
 
0.1%
-7.4 1
 
0.1%
-7.1 2
0.2%
-7.0 1
 
0.1%
-6.9 3
0.3%
-6.8 3
0.3%
-6.7 1
 
0.1%
ValueCountFrequency (%)
9.6 1
0.1%
9.4 1
0.1%
8.8 1
0.1%
8.7 1
0.1%
8.5 1
0.1%
8.3 1
0.1%
8.2 1
0.1%
8.1 1
0.1%
7.9 2
0.2%
7.7 1
0.1%

Interactions

2023-12-13T04:10:48.918749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:47.977375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:48.436220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:49.050211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:48.103868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:48.581118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:49.185025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:48.280388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:10:48.757703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:10:51.526047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지사주소명일자최고최저평균
지사1.0001.0000.0000.4650.4680.461
주소명1.0001.0000.0000.4650.4680.461
일자0.0000.0001.0000.8240.7400.845
최고0.4650.4650.8241.0000.5320.880
최저0.4680.4680.7400.5321.0000.769
평균0.4610.4610.8450.8800.7691.000
2023-12-13T04:10:51.636926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지사주소명
지사1.0001.000
주소명1.0001.000
2023-12-13T04:10:51.727691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
최고최저평균지사주소명
최고1.0000.6780.9030.1630.163
최저0.6781.0000.8980.2370.237
평균0.9030.8981.0000.1620.162
지사0.1630.2370.1621.0001.000
주소명0.1630.2370.1621.0001.000

Missing values

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

지사주소명일자최고최저평균
0파주경기도 파주시 교하읍 청석로 3802022-01-013.1-13.1-5.8
1파주경기도 파주시 교하읍 청석로 3802022-01-023.3-8.6-1.8
2파주경기도 파주시 교하읍 청석로 3802022-01-032.3-11.3-4.1
3파주경기도 파주시 교하읍 청석로 3802022-01-042.2-7.9-3.4
4파주경기도 파주시 교하읍 청석로 3802022-01-050.9-10.6-4.9
5파주경기도 파주시 교하읍 청석로 3802022-01-064.5-9.3-4.0
6파주경기도 파주시 교하읍 청석로 3802022-01-075.1-10.4-4.6
7파주경기도 파주시 교하읍 청석로 3802022-01-084.3-9.5-0.8
8파주경기도 파주시 교하읍 청석로 3802022-01-095.6-5.3-0.7
9파주경기도 파주시 교하읍 청석로 3802022-01-103.1-7.7-2.0
지사주소명일자최고최저평균
1168평택경기도 평택시 진위면 진위2산단로 15-402022-02-193.2-4.9-0.7
1169평택경기도 평택시 진위면 진위2산단로 15-402022-02-20-1.7-6.9-4.0
1170평택경기도 평택시 진위면 진위2산단로 15-402022-02-214.4-7.3-1.9
1171평택경기도 평택시 진위면 진위2산단로 15-402022-02-220.5-6.5-3.5
1172평택경기도 평택시 진위면 진위2산단로 15-402022-02-23-1.5-8.0-4.8
1173평택경기도 평택시 진위면 진위2산단로 15-402022-02-242.4-10.0-3.0
1174평택경기도 평택시 진위면 진위2산단로 15-402022-02-259.1-7.01.4
1175평택경기도 평택시 진위면 진위2산단로 15-402022-02-2610.1-0.15.0
1176평택경기도 평택시 진위면 진위2산단로 15-402022-02-279.7-0.74.0
1177평택경기도 평택시 진위면 진위2산단로 15-402022-02-2812.4-3.05.1