Overview

Dataset statistics

Number of variables4
Number of observations54
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory35.4 B

Variable types

Numeric1
Text1
DateTime2

Dataset

Description광주광역시 동구 침수피해 현황 데이터입니다.해당 데이터는 2021, 2023년 피해현황 데이터입니다.(2022년 데이터 미보유)데이터는 침수피해 위치와 피해일자로 구성되어 있습니다.
Author광주광역시 동구
URLhttps://www.data.go.kr/data/15124569/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique
침수주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:17:39.922218
Analysis finished2023-12-12 20:17:40.307913
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27.5
Minimum1
Maximum54
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size618.0 B
2023-12-13T05:17:40.695383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.65
Q114.25
median27.5
Q340.75
95-th percentile51.35
Maximum54
Range53
Interquartile range (IQR)26.5

Descriptive statistics

Standard deviation15.732133
Coefficient of variation (CV)0.57207755
Kurtosis-1.2
Mean27.5
Median Absolute Deviation (MAD)13.5
Skewness0
Sum1485
Variance247.5
MonotonicityStrictly increasing
2023-12-13T05:17:40.843884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.9%
42 1
 
1.9%
31 1
 
1.9%
32 1
 
1.9%
33 1
 
1.9%
34 1
 
1.9%
35 1
 
1.9%
36 1
 
1.9%
37 1
 
1.9%
38 1
 
1.9%
Other values (44) 44
81.5%
ValueCountFrequency (%)
1 1
1.9%
2 1
1.9%
3 1
1.9%
4 1
1.9%
5 1
1.9%
6 1
1.9%
7 1
1.9%
8 1
1.9%
9 1
1.9%
10 1
1.9%
ValueCountFrequency (%)
54 1
1.9%
53 1
1.9%
52 1
1.9%
51 1
1.9%
50 1
1.9%
49 1
1.9%
48 1
1.9%
47 1
1.9%
46 1
1.9%
45 1
1.9%

침수주소
Text

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023-12-13T05:17:41.073844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18.5
Mean length16.444444
Min length10

Characters and Unicode

Total characters888
Distinct characters43
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique54 ?
Unique (%)100.0%

Sample

1st row지산동 76-5일원
2nd row소태동 197 일원
3rd row소태동 634-1 일원
4th row소태동 678-49 일원
5th row소태동 982 일원
ValueCountFrequency (%)
광주광역시 44
21.4%
동구 44
21.4%
계림동 17
 
8.3%
일원 9
 
4.4%
소태동 6
 
2.9%
동명동 4
 
1.9%
대인동 4
 
1.9%
용산동 4
 
1.9%
지산동 3
 
1.5%
내남동 3
 
1.5%
Other values (63) 68
33.0%
2023-12-13T05:17:41.427559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
152
17.1%
동 96
 
10.8%
광 88
 
9.9%
구 44
 
5.0%
시 44
 
5.0%
1 44
 
5.0%
주 44
 
5.0%
역 44
 
5.0%
- 32
 
3.6%
2 31
 
3.5%
Other values (33) 269
30.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 496
55.9%
Decimal Number 208
23.4%
Space Separator 152
 
17.1%
Dash Punctuation 32
 
3.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 96
19.4%
광 88
17.7%
구 44
8.9%
시 44
8.9%
주 44
8.9%
역 44
8.9%
림 18
 
3.6%
계 17
 
3.4%
원 10
 
2.0%
일 10
 
2.0%
Other values (21) 81
16.3%
Decimal Number
ValueCountFrequency (%)
1 44
21.2%
2 31
14.9%
4 27
13.0%
8 19
9.1%
3 18
8.7%
5 16
 
7.7%
6 15
 
7.2%
7 15
 
7.2%
0 13
 
6.2%
9 10
 
4.8%
Space Separator
ValueCountFrequency (%)
152
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 32
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 496
55.9%
Common 392
44.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 96
19.4%
광 88
17.7%
구 44
8.9%
시 44
8.9%
주 44
8.9%
역 44
8.9%
림 18
 
3.6%
계 17
 
3.4%
원 10
 
2.0%
일 10
 
2.0%
Other values (21) 81
16.3%
Common
ValueCountFrequency (%)
152
38.8%
1 44
 
11.2%
- 32
 
8.2%
2 31
 
7.9%
4 27
 
6.9%
8 19
 
4.8%
3 18
 
4.6%
5 16
 
4.1%
6 15
 
3.8%
7 15
 
3.8%
Other values (2) 23
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 496
55.9%
ASCII 392
44.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
152
38.8%
1 44
 
11.2%
- 32
 
8.2%
2 31
 
7.9%
4 27
 
6.9%
8 19
 
4.8%
3 18
 
4.6%
5 16
 
4.1%
6 15
 
3.8%
7 15
 
3.8%
Other values (2) 23
 
5.9%
Hangul
ValueCountFrequency (%)
동 96
19.4%
광 88
17.7%
구 44
8.9%
시 44
8.9%
주 44
8.9%
역 44
8.9%
림 18
 
3.6%
계 17
 
3.4%
원 10
 
2.0%
일 10
 
2.0%
Other values (21) 81
16.3%

침수일
Date

Distinct16
Distinct (%)29.6%
Missing0
Missing (%)0.0%
Memory size564.0 B
Minimum2023-06-27 00:00:00
Maximum2023-08-06 00:00:00
2023-12-13T05:17:41.545369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:17:41.649279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size564.0 B
Minimum2023-10-23 00:00:00
Maximum2023-10-23 00:00:00
2023-12-13T05:17:41.749511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:17:41.835420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T05:17:40.050632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:17:41.918137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번침수주소침수일
연번1.0001.0000.739
침수주소1.0001.0001.000
침수일0.7391.0001.000

Missing values

2023-12-13T05:17:40.180853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:17:40.273175image/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

연번침수주소침수일데이터기준일자
01지산동 76-5일원2023-08-062023-10-23
12소태동 197 일원2023-08-062023-10-23
23소태동 634-1 일원2023-08-062023-10-23
34소태동 678-49 일원2023-08-062023-10-23
45소태동 982 일원2023-08-062023-10-23
56용연동 381 일원2023-08-062023-10-23
67운림동 838-39 일원2023-08-062023-10-23
78내남동 248 일원2023-08-062023-10-23
89용산동 218-7 일원2023-08-062023-10-23
910용산동 474 일원2023-08-062023-10-23
연번침수주소침수일데이터기준일자
4445광주광역시 동구 소태동 208-62023-07-142023-10-23
4546광주광역시 동구 계림동 321-82023-07-102023-10-23
4647광주광역시 동구 용산동 5682023-06-272023-10-23
4748광주광역시 동구 계림동 11102023-06-282023-10-23
4849광주광역시 동구 지산동 67-72023-06-282023-10-23
4950광주광역시 동구 계림동 524-82023-06-282023-10-23
5051광주광역시 동구 계림동 321-32023-06-292023-10-23
5152광주광역시 동구 계림동 287-42023-07-142023-10-23
5253광주광역시 동구 충장로4가 25-12023-06-282023-10-23
5354광주광역시 동구 동명동 3-22023-06-282023-10-23