Overview

Dataset statistics

Number of variables2
Number of observations54
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 KiB
Average record size in memory19.4 B

Variable types

DateTime1
Numeric1

Dataset

Description대구광역시 상수도사업본부에서 2019년 1월부터 2023년 6월까지 월별로 검침값이 등록된 전수를 포함하고 있습니다.
URLhttps://www.data.go.kr/data/15116802/fileData.do

Alerts

납기년월 has unique valuesUnique
검침전수 has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:50:32.286760
Analysis finished2023-12-11 23:50:32.487548
Duration0.2 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

납기년월
Date

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size564.0 B
Minimum2019-01-01 00:00:00
Maximum2023-06-01 00:00:00
2023-12-12T08:50:32.541641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:50:32.647558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

검침전수
Real number (ℝ)

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean298710.44
Minimum294792
Maximum306893
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size618.0 B
2023-12-12T08:50:32.764256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum294792
5-th percentile294901.75
Q1295431.75
median297394.5
Q3301251
95-th percentile306005.1
Maximum306893
Range12101
Interquartile range (IQR)5819.25

Descriptive statistics

Standard deviation3706.522
Coefficient of variation (CV)0.012408411
Kurtosis-0.55685559
Mean298710.44
Median Absolute Deviation (MAD)2298
Skewness0.79992588
Sum16130364
Variance13738305
MonotonicityNot monotonic
2023-12-12T08:50:32.881292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
306893 1
 
1.9%
294849 1
 
1.9%
296874 1
 
1.9%
296666 1
 
1.9%
296542 1
 
1.9%
296377 1
 
1.9%
296291 1
 
1.9%
296001 1
 
1.9%
295824 1
 
1.9%
295684 1
 
1.9%
Other values (44) 44
81.5%
ValueCountFrequency (%)
294792 1
1.9%
294849 1
1.9%
294853 1
1.9%
294928 1
1.9%
294973 1
1.9%
294990 1
1.9%
295002 1
1.9%
295080 1
1.9%
295113 1
1.9%
295197 1
1.9%
ValueCountFrequency (%)
306893 1
1.9%
306574 1
1.9%
306308 1
1.9%
305842 1
1.9%
305380 1
1.9%
304982 1
1.9%
304448 1
1.9%
303633 1
1.9%
303050 1
1.9%
302494 1
1.9%

Interactions

2023-12-12T08:50:32.336186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:50:32.948752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
납기년월검침전수
납기년월1.0001.000
검침전수1.0001.000

Missing values

2023-12-12T08:50:32.418902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:50:32.466103image/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

납기년월검침전수
02019-01306893
12019-02306574
22019-03306308
32019-04305842
42019-05305380
52019-06304982
62019-07304448
72019-08303633
82019-09303050
92019-10302494
납기년월검침전수
442022-09294928
452022-10294973
462022-11295002
472022-12295080
482023-01295113
492023-02295197
502023-03295214
512023-04295355
522023-05295485
532023-06295631