Overview

Dataset statistics

Number of variables5
Number of observations2609
Missing cells0
Missing cells (%)0.0%
Duplicate rows269
Duplicate rows (%)10.3%
Total size in memory107.1 KiB
Average record size in memory42.1 B

Variable types

Categorical2
Numeric1
DateTime2

Dataset

Description충청북도 제천시의 급수공사 현황 자료입니다.공사접수년도, 공사주소(법정동), 연장M, 준공일, 데이터기준일로 구성되어 있습니다.
Author충청북도 제천시
URLhttps://www.data.go.kr/data/15122122/fileData.do

Alerts

데이터기준일 has constant value ""Constant
Dataset has 269 (10.3%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 09:54:50.510082
Analysis finished2023-12-12 09:54:51.283973
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공사접수년도
Categorical

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
2021
843 
2022
801 
2020
719 
2023
246 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023
2nd row2023
3rd row2023
4th row2023
5th row2023

Common Values

ValueCountFrequency (%)
2021 843
32.3%
2022 801
30.7%
2020 719
27.6%
2023 246
 
9.4%

Length

2023-12-12T18:54:51.374230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:54:51.502135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 843
32.3%
2022 801
30.7%
2020 719
27.6%
2023 246
 
9.4%

공사주소(법정동)
Categorical

Distinct37
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
백운면
563 
송학면
385 
봉양읍
382 
덕산면
181 
수산면
146 
Other values (32)
952 

Length

Max length5
Median length3
Mean length2.980069
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row한수면
2nd row왕암동
3rd row하소동
4th row자작동
5th row백운면

Common Values

ValueCountFrequency (%)
백운면 563
21.6%
송학면 385
14.8%
봉양읍 382
14.6%
덕산면 181
 
6.9%
수산면 146
 
5.6%
청풍면 88
 
3.4%
고암동 81
 
3.1%
신월동 73
 
2.8%
장락동 67
 
2.6%
금성면 66
 
2.5%
Other values (27) 577
22.1%

Length

2023-12-12T18:54:51.650527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
백운면 563
21.6%
송학면 385
14.8%
봉양읍 382
14.6%
덕산면 181
 
6.9%
수산면 146
 
5.6%
청풍면 88
 
3.4%
고암동 81
 
3.1%
신월동 73
 
2.8%
장락동 67
 
2.6%
금성면 66
 
2.5%
Other values (27) 577
22.1%

연장
Real number (ℝ)

Distinct76
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.4403986
Minimum1
Maximum160
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.1 KiB
2023-12-12T18:54:51.837799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q13
median3
Q34.5
95-th percentile13
Maximum160
Range159
Interquartile range (IQR)1.5

Descriptive statistics

Standard deviation9.6248951
Coefficient of variation (CV)1.7691525
Kurtosis103.25873
Mean5.4403986
Median Absolute Deviation (MAD)0
Skewness9.0640426
Sum14194
Variance92.638605
MonotonicityNot monotonic
2023-12-12T18:54:52.046444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3.0 1327
50.9%
4.0 349
 
13.4%
2.0 255
 
9.8%
5.0 162
 
6.2%
6.0 81
 
3.1%
7.0 59
 
2.3%
8.0 49
 
1.9%
10.0 49
 
1.9%
9.0 29
 
1.1%
11.0 27
 
1.0%
Other values (66) 222
 
8.5%
ValueCountFrequency (%)
1.0 3
 
0.1%
2.0 255
 
9.8%
2.5 11
 
0.4%
3.0 1327
50.9%
3.5 7
 
0.3%
4.0 349
 
13.4%
4.5 13
 
0.5%
5.0 162
 
6.2%
5.5 10
 
0.4%
6.0 81
 
3.1%
ValueCountFrequency (%)
160.0 1
< 0.1%
138.0 1
< 0.1%
131.0 1
< 0.1%
126.0 1
< 0.1%
125.0 1
< 0.1%
123.0 1
< 0.1%
115.0 1
< 0.1%
109.0 1
< 0.1%
100.0 2
0.1%
91.0 2
0.1%

준공일
Date

Distinct38
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
Minimum2020-05-06 00:00:00
Maximum2023-08-25 00:00:00
2023-12-12T18:54:52.221643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:54:52.352141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
Minimum2023-08-30 00:00:00
Maximum2023-08-30 00:00:00
2023-12-12T18:54:52.477472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:54:52.579597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T18:54:50.894340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:54:52.653727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공사접수년도공사주소(법정동)연장준공일
공사접수년도1.0000.3350.0281.000
공사주소(법정동)0.3351.0000.0000.640
연장0.0280.0001.0000.091
준공일1.0000.6400.0911.000
2023-12-12T18:54:52.765830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공사주소(법정동)공사접수년도
공사주소(법정동)1.0000.176
공사접수년도0.1761.000
2023-12-12T18:54:52.855912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연장공사접수년도공사주소(법정동)
연장1.0000.0180.000
공사접수년도0.0181.0000.176
공사주소(법정동)0.0000.1761.000

Missing values

2023-12-12T18:54:51.071684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:54:51.224458image/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

공사접수년도공사주소(법정동)연장준공일데이터기준일
02023한수면7.52023-08-252023-08-30
12023왕암동12.02023-08-252023-08-30
22023하소동8.02023-08-252023-08-30
32023자작동4.02023-08-252023-08-30
42023백운면5.02023-08-252023-08-30
52023덕산면7.02023-08-252023-08-30
62023백운면15.02023-08-252023-08-30
72023하소동4.02023-08-252023-08-30
82023청풍면3.02023-08-252023-08-30
92023송학면3.02023-08-252023-08-30
공사접수년도공사주소(법정동)연장준공일데이터기준일
25992020장락동8.02020-05-062023-08-30
26002020봉양읍3.02020-05-062023-08-30
26012020봉양읍4.02020-05-062023-08-30
26022020수산면3.02020-05-062023-08-30
26032020수산면3.02020-05-062023-08-30
26042020봉양읍2.02020-05-062023-08-30
26052020봉양읍4.02020-05-062023-08-30
26062020수산면4.02020-05-062023-08-30
26072020고명동14.02020-05-062023-08-30
26082020금성면3.02020-05-062023-08-30

Duplicate rows

Most frequently occurring

공사접수년도공사주소(법정동)연장준공일데이터기준일# duplicates
1152021백운면3.02021-12-202023-08-30162
1912022백운면3.02022-09-272023-08-3069
992021덕산면3.02021-12-202023-08-3058
2042022봉양읍3.02022-12-202023-08-3052
222020백운면3.02020-10-262023-08-3049
1392021송학면3.02021-12-202023-08-3041
2122022송학면2.02023-04-212023-08-3037
1922022백운면3.02022-10-262023-08-3035
962021덕산면3.02021-08-232023-08-3031
1882022백운면2.02022-11-212023-08-3028