Overview

Dataset statistics

Number of variables3
Number of observations2094
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory55.3 KiB
Average record size in memory27.1 B

Variable types

Numeric3

Dataset

Description공간id,일련번호,침수단계
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-21172/S/1/datasetView.do

Alerts

일련번호 is highly overall correlated with 침수단계High correlation
침수단계 is highly overall correlated with 일련번호High correlation
공간id has unique valuesUnique
일련번호 has unique valuesUnique

Reproduction

Analysis started2024-05-11 07:58:45.628920
Analysis finished2024-05-11 07:58:49.824553
Duration4.2 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공간id
Real number (ℝ)

UNIQUE 

Distinct2094
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean142163.22
Minimum140973
Maximum143210
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.5 KiB
2024-05-11T07:58:50.110188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum140973
5-th percentile141221.65
Q1141640.25
median142163.5
Q3142686.75
95-th percentile143105.35
Maximum143210
Range2237
Interquartile range (IQR)1046.5

Descriptive statistics

Standard deviation605.13819
Coefficient of variation (CV)0.0042566437
Kurtosis-1.1945386
Mean142163.22
Median Absolute Deviation (MAD)523.5
Skewness-0.0032944555
Sum2.9768979 × 108
Variance366192.23
MonotonicityNot monotonic
2024-05-11T07:58:50.893727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
142336 1
 
< 0.1%
141681 1
 
< 0.1%
141679 1
 
< 0.1%
141668 1
 
< 0.1%
141678 1
 
< 0.1%
141677 1
 
< 0.1%
141676 1
 
< 0.1%
141675 1
 
< 0.1%
141674 1
 
< 0.1%
141673 1
 
< 0.1%
Other values (2084) 2084
99.5%
ValueCountFrequency (%)
140973 1
< 0.1%
140974 1
< 0.1%
140975 1
< 0.1%
140976 1
< 0.1%
141121 1
< 0.1%
141122 1
< 0.1%
141123 1
< 0.1%
141124 1
< 0.1%
141125 1
< 0.1%
141126 1
< 0.1%
ValueCountFrequency (%)
143210 1
< 0.1%
143209 1
< 0.1%
143208 1
< 0.1%
143207 1
< 0.1%
143206 1
< 0.1%
143205 1
< 0.1%
143204 1
< 0.1%
143203 1
< 0.1%
143202 1
< 0.1%
143201 1
< 0.1%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2094
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1048.2053
Minimum1
Maximum2095
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.5 KiB
2024-05-11T07:58:51.455543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile105.65
Q1524.25
median1048.5
Q31571.75
95-th percentile1990.35
Maximum2095
Range2094
Interquartile range (IQR)1047.5

Descriptive statistics

Standard deviation604.99018
Coefficient of variation (CV)0.57716761
Kurtosis-1.200112
Mean1048.2053
Median Absolute Deviation (MAD)524
Skewness-0.00084753348
Sum2194942
Variance366013.12
MonotonicityNot monotonic
2024-05-11T07:58:52.187934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1278 1
 
< 0.1%
703 1
 
< 0.1%
701 1
 
< 0.1%
689 1
 
< 0.1%
699 1
 
< 0.1%
698 1
 
< 0.1%
697 1
 
< 0.1%
696 1
 
< 0.1%
695 1
 
< 0.1%
694 1
 
< 0.1%
Other values (2084) 2084
99.5%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2095 1
< 0.1%
2094 1
< 0.1%
2093 1
< 0.1%
2092 1
< 0.1%
2091 1
< 0.1%
2090 1
< 0.1%
2089 1
< 0.1%
2088 1
< 0.1%
2087 1
< 0.1%
2086 1
< 0.1%

침수단계
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.8638968
Minimum1
Maximum8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.5 KiB
2024-05-11T07:58:52.653639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q33
95-th percentile6
Maximum8
Range7
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.2942983
Coefficient of variation (CV)0.45193608
Kurtosis2.1902474
Mean2.8638968
Median Absolute Deviation (MAD)1
Skewness1.2466282
Sum5997
Variance1.6752081
MonotonicityNot monotonic
2024-05-11T07:58:53.130322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3 784
37.4%
2 683
32.6%
4 213
 
10.2%
1 203
 
9.7%
5 103
 
4.9%
6 60
 
2.9%
7 35
 
1.7%
8 13
 
0.6%
ValueCountFrequency (%)
1 203
 
9.7%
2 683
32.6%
3 784
37.4%
4 213
 
10.2%
5 103
 
4.9%
6 60
 
2.9%
7 35
 
1.7%
8 13
 
0.6%
ValueCountFrequency (%)
8 13
 
0.6%
7 35
 
1.7%
6 60
 
2.9%
5 103
 
4.9%
4 213
 
10.2%
3 784
37.4%
2 683
32.6%
1 203
 
9.7%

Interactions

2024-05-11T07:58:48.186294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:46.047605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:47.124299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:48.622050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:46.386452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:47.455814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:49.055629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:46.747838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:58:47.858396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T07:58:53.483679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공간id일련번호침수단계
공간id1.0000.9450.801
일련번호0.9451.0000.906
침수단계0.8010.9061.000
2024-05-11T07:58:54.162329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공간id일련번호침수단계
공간id1.000-0.294-0.298
일련번호-0.2941.0000.954
침수단계-0.2980.9541.000

Missing values

2024-05-11T07:58:49.457946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T07:58:49.719588image/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

공간id일련번호침수단계
014233612783
114233712793
214233812803
314233912813
414234012823
514234112833
614234212843
714234312853
814234412863
914234512873
공간id일련번호침수단계
208414200515673
208514200615683
208614200715693
208714200815703
208814200915713
208914201015723
209014201115733
209114201215743
209214201315753
209314201415763