Overview

Dataset statistics

Number of variables3
Number of observations199
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.0 KiB
Average record size in memory25.7 B

Variable types

Categorical1
Numeric1
DateTime1

Dataset

Description경상북도 경주시_도로와지하시설물 관리시스템 상수민원접수대장2003년도내용입니다구분,관리번호,민원일자
Author경상북도 경주시
URLhttps://www.data.go.kr/data/15093321/fileData.do

Alerts

구분 has constant value ""Constant
관리번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:50:11.077496
Analysis finished2023-12-12 09:50:11.750838
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
상수민원접수처리대장
199 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상수민원접수처리대장
2nd row상수민원접수처리대장
3rd row상수민원접수처리대장
4th row상수민원접수처리대장
5th row상수민원접수처리대장

Common Values

ValueCountFrequency (%)
상수민원접수처리대장 199
100.0%

Length

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

Common Values (Plot)

2023-12-12T18:50:11.947072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수민원접수처리대장 199
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct199
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.003001 × 108
Minimum2.003 × 108
Maximum2.003002 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-12T18:50:12.065793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.003 × 108
5-th percentile2.0030001 × 108
Q12.0030005 × 108
median2.003001 × 108
Q32.0030015 × 108
95-th percentile2.0030019 × 108
Maximum2.003002 × 108
Range198
Interquartile range (IQR)99

Descriptive statistics

Standard deviation57.590508
Coefficient of variation (CV)2.8752112 × 10-7
Kurtosis-1.2
Mean2.003001 × 108
Median Absolute Deviation (MAD)50
Skewness0
Sum3.985972 × 1010
Variance3316.6667
MonotonicityStrictly increasing
2023-12-12T18:50:12.248020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
200300001 1
 
0.5%
200300138 1
 
0.5%
200300128 1
 
0.5%
200300129 1
 
0.5%
200300130 1
 
0.5%
200300131 1
 
0.5%
200300132 1
 
0.5%
200300133 1
 
0.5%
200300134 1
 
0.5%
200300135 1
 
0.5%
Other values (189) 189
95.0%
ValueCountFrequency (%)
200300001 1
0.5%
200300002 1
0.5%
200300003 1
0.5%
200300004 1
0.5%
200300005 1
0.5%
200300006 1
0.5%
200300007 1
0.5%
200300008 1
0.5%
200300009 1
0.5%
200300010 1
0.5%
ValueCountFrequency (%)
200300199 1
0.5%
200300198 1
0.5%
200300197 1
0.5%
200300196 1
0.5%
200300195 1
0.5%
200300194 1
0.5%
200300193 1
0.5%
200300192 1
0.5%
200300191 1
0.5%
200300190 1
0.5%

민원일자
Date

Distinct18
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2003-01-02 00:00:00
Maximum2003-01-22 00:00:00
2023-12-12T18:50:12.389651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:50:12.497583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

Interactions

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

Correlations

2023-12-12T18:50:12.595675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호민원일자
관리번호1.0000.972
민원일자0.9721.000

Missing values

2023-12-12T18:50:11.621946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:50:11.720894image/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상수민원접수처리대장2003000012003-01-02
1상수민원접수처리대장2003000022003-01-02
2상수민원접수처리대장2003000032003-01-02
3상수민원접수처리대장2003000042003-01-02
4상수민원접수처리대장2003000052003-01-02
5상수민원접수처리대장2003000062003-01-02
6상수민원접수처리대장2003000072003-01-03
7상수민원접수처리대장2003000082003-01-03
8상수민원접수처리대장2003000092003-01-03
9상수민원접수처리대장2003000102003-01-04
구분관리번호민원일자
189상수민원접수처리대장2003001902003-01-20
190상수민원접수처리대장2003001912003-01-21
191상수민원접수처리대장2003001922003-01-21
192상수민원접수처리대장2003001932003-01-21
193상수민원접수처리대장2003001942003-01-21
194상수민원접수처리대장2003001952003-01-21
195상수민원접수처리대장2003001962003-01-22
196상수민원접수처리대장2003001972003-01-22
197상수민원접수처리대장2003001982003-01-22
198상수민원접수처리대장2003001992003-01-22