Overview

Dataset statistics

Number of variables3
Number of observations10000
Missing cells9996
Missing cells (%)33.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory322.3 KiB
Average record size in memory33.0 B

Variable types

DateTime2
Numeric1

Dataset

Description가축분뇨 전자인계관리시스템에서 관리하고있는 가축분뇨 중 분뇨의 운반인계서 중 운반하는 차량으로 등록된 정보입니다.
Author한국환경공단
URLhttps://www.data.go.kr/data/15041957/fileData.do

Alerts

수정일자 has 9996 (> 99.9%) missing valuesMissing
번호 is highly skewed (γ1 = -28.87358938)Skewed
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:32:46.611825
Analysis finished2023-12-12 11:32:47.319402
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록일자
Date

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 00:00:00
Maximum2021-05-01 00:00:00
2023-12-12T20:32:47.418858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:32:47.617619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

수정일자
Date

MISSING 

Distinct3
Distinct (%)75.0%
Missing9996
Missing (%)> 99.9%
Memory size156.2 KiB
Minimum2021-01-01 00:00:00
Maximum2021-05-01 00:00:00
2023-12-12T20:32:47.843613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:32:48.073785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

번호
Real number (ℝ)

SKEWED  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.1032849 × 109
Minimum2.0053093 × 109
Maximum2.1051953 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T20:32:48.306634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0053093 × 109
5-th percentile2.1018391 × 109
Q12.1029144 × 109
median2.1030303 × 109
Q32.1041072 × 109
95-th percentile2.1051823 × 109
Maximum2.1051953 × 109
Range99885991
Interquartile range (IQR)1192819.5

Descriptive statistics

Standard deviation2651807.6
Coefficient of variation (CV)0.0012607933
Kurtosis997.94568
Mean2.1032849 × 109
Median Absolute Deviation (MAD)1066803
Skewness-28.873589
Sum2.1032849 × 1013
Variance7.0320835 × 1012
MonotonicityNot monotonic
2023-12-12T20:32:48.744489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2105177379 1
 
< 0.1%
2102906936 1
 
< 0.1%
2101859930 1
 
< 0.1%
2101831647 1
 
< 0.1%
2104142187 1
 
< 0.1%
2103988869 1
 
< 0.1%
2102917715 1
 
< 0.1%
2103000807 1
 
< 0.1%
2101849963 1
 
< 0.1%
2101856300 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2005309304 1
< 0.1%
2012751514 1
< 0.1%
2012762242 1
< 0.1%
2012762654 1
< 0.1%
2012801090 1
< 0.1%
2012817432 1
< 0.1%
2012825103 1
< 0.1%
2101828526 1
< 0.1%
2101828532 1
< 0.1%
2101828534 1
< 0.1%
ValueCountFrequency (%)
2105195295 1
< 0.1%
2105195285 1
< 0.1%
2105195280 1
< 0.1%
2105195271 1
< 0.1%
2105195246 1
< 0.1%
2105195242 1
< 0.1%
2105195236 1
< 0.1%
2105195233 1
< 0.1%
2105195225 1
< 0.1%
2105195223 1
< 0.1%

Interactions

2023-12-12T20:32:46.866748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:32:48.904040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록일자수정일자번호
등록일자1.0001.0000.017
수정일자1.0001.000NaN
번호0.017NaN1.000

Missing values

2023-12-12T20:32:47.099483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:32:47.255995image/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

등록일자수정일자번호
419532021-05<NA>2105177379
442022021-02<NA>2102924884
526172021-02<NA>2102910815
168652021-03<NA>2103006935
390222021-01<NA>2101854917
981172021-05<NA>2105188970
676742021-01<NA>2101839159
118492021-02<NA>2102910364
976242021-01<NA>2101835738
380432021-04<NA>2104070387
등록일자수정일자번호
819472021-01<NA>2101884989
147222021-03<NA>2103992816
912952021-03<NA>2103038489
746282021-02<NA>2102966984
906032021-02<NA>2102948741
557292021-02<NA>2102975856
26352021-01<NA>2101831914
769942021-02<NA>2102971006
491552021-03<NA>2103045446
652552021-01<NA>2101895498