Overview

Dataset statistics

Number of variables3
Number of observations32
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory932.0 B
Average record size in memory29.1 B

Variable types

Text1
Numeric1
DateTime1

Dataset

Description공주시 관내 설치된 스마트 워터 미터기 위치 정보로 읍면동에 설치된 스마트워터미터기의 설치 수량에 대한 정보, 읍면동, 설치수량, 데이터 기준일을 포함하고 있습니다.
Author충청남도 공주시
URLhttps://www.data.go.kr/data/15103938/fileData.do

Alerts

기준일 has constant value ""Constant
읍면동 has unique valuesUnique

Reproduction

Analysis started2023-12-12 03:51:57.492024
Analysis finished2023-12-12 03:51:57.894261
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

읍면동
Text

UNIQUE 

Distinct32
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size388.0 B
2023-12-12T12:51:58.117396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9375
Min length2

Characters and Unicode

Total characters94
Distinct characters48
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique32 ?
Unique (%)100.0%

Sample

1st row반죽동
2nd row봉황동
3rd row중학동
4th row중동
5th row산성동
ValueCountFrequency (%)
반죽동 1
 
3.1%
봉황동 1
 
3.1%
이인면 1
 
3.1%
유구읍 1
 
3.1%
월송동 1
 
3.1%
우성면 1
 
3.1%
신풍면 1
 
3.1%
사곡면 1
 
3.1%
봉정동 1
 
3.1%
계룡면 1
 
3.1%
Other values (22) 22
68.8%
2023-12-12T12:51:58.641884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
23
24.5%
8
 
8.5%
4
 
4.3%
3
 
3.2%
3
 
3.2%
3
 
3.2%
3
 
3.2%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (38) 41
43.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 94
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
23
24.5%
8
 
8.5%
4
 
4.3%
3
 
3.2%
3
 
3.2%
3
 
3.2%
3
 
3.2%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (38) 41
43.6%

Most occurring scripts

ValueCountFrequency (%)
Hangul 94
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
23
24.5%
8
 
8.5%
4
 
4.3%
3
 
3.2%
3
 
3.2%
3
 
3.2%
3
 
3.2%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (38) 41
43.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 94
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
23
24.5%
8
 
8.5%
4
 
4.3%
3
 
3.2%
3
 
3.2%
3
 
3.2%
3
 
3.2%
2
 
2.1%
2
 
2.1%
2
 
2.1%
Other values (38) 41
43.6%

수량
Real number (ℝ)

Distinct25
Distinct (%)78.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean100.96875
Minimum1
Maximum2199
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size420.0 B
2023-12-12T12:51:58.860865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q17
median20.5
Q348.25
95-th percentile113.35
Maximum2199
Range2198
Interquartile range (IQR)41.25

Descriptive statistics

Standard deviation384.38014
Coefficient of variation (CV)3.8069219
Kurtosis31.441287
Mean100.96875
Median Absolute Deviation (MAD)16
Skewness5.5858385
Sum3231
Variance147748.1
MonotonicityNot monotonic
2023-12-12T12:51:59.120602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
7 3
 
9.4%
8 3
 
9.4%
15 2
 
6.2%
2 2
 
6.2%
45 2
 
6.2%
22 1
 
3.1%
52 1
 
3.1%
33 1
 
3.1%
2199 1
 
3.1%
99 1
 
3.1%
Other values (15) 15
46.9%
ValueCountFrequency (%)
1 1
 
3.1%
2 2
6.2%
4 1
 
3.1%
5 1
 
3.1%
6 1
 
3.1%
7 3
9.4%
8 3
9.4%
10 1
 
3.1%
15 2
6.2%
20 1
 
3.1%
ValueCountFrequency (%)
2199 1
3.1%
126 1
3.1%
103 1
3.1%
99 1
3.1%
88 1
3.1%
83 1
3.1%
69 1
3.1%
52 1
3.1%
47 1
3.1%
45 2
6.2%

기준일
Date

CONSTANT 

Distinct1
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size388.0 B
Minimum2022-08-12 00:00:00
Maximum2022-08-12 00:00:00
2023-12-12T12:51:59.285762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:51:59.465482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T12:51:57.601777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:51:59.579040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
읍면동수량
읍면동1.0001.000
수량1.0001.000

Missing values

2023-12-12T12:51:57.744635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:51:57.853636image/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반죽동452022-08-12
1봉황동202022-08-12
2중학동212022-08-12
3중동422022-08-12
4산성동832022-08-12
5교동222022-08-12
6금성동452022-08-12
7옥룡동1032022-08-12
8금학동82022-08-12
9태봉동62022-08-12
읍면동수량기준일
22검상동52022-08-12
23계룡면882022-08-12
24봉정동22022-08-12
25사곡면322022-08-12
26신풍면152022-08-12
27우성면992022-08-12
28월송동72022-08-12
29유구읍21992022-08-12
30이인면152022-08-12
31탄천면332022-08-12