Overview

Dataset statistics

Number of variables4
Number of observations144
Missing cells0
Missing cells (%)0.0%
Duplicate rows8
Duplicate rows (%)5.6%
Total size in memory4.8 KiB
Average record size in memory33.9 B

Variable types

Categorical3
Text1

Dataset

Description광주광역시 남구의 2021년부터 2023년까지의 침수피해 현황입니다. 데이터 작성일 기준은 2023년 10월 18일 입니다.
Author광주광역시 남구
URLhttps://www.data.go.kr/data/15124530/fileData.do

Alerts

데이터작성일자 has constant value ""Constant
Dataset has 8 (5.6%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 05:53:22.593612
Analysis finished2023-12-12 05:53:22.882977
Duration0.29 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

피해연도
Categorical

Distinct3
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023
118 
2022
14 
2021
12 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021
2nd row2021
3rd row2021
4th row2021
5th row2021

Common Values

ValueCountFrequency (%)
2023 118
81.9%
2022 14
 
9.7%
2021 12
 
8.3%

Length

2023-12-12T14:53:22.956578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:53:23.085363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 118
81.9%
2022 14
 
9.7%
2021 12
 
8.3%

구분
Categorical

Distinct3
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
농경지
66 
소상공인
51 
주택
27 

Length

Max length4
Median length3
Mean length3.1666667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row농경지
2nd row농경지
3rd row농경지
4th row농경지
5th row농경지

Common Values

ValueCountFrequency (%)
농경지 66
45.8%
소상공인 51
35.4%
주택 27
18.8%

Length

2023-12-12T14:53:23.251726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:53:23.378090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
농경지 66
45.8%
소상공인 51
35.4%
주택 27
18.8%

도로명주소
Text

Distinct130
Distinct (%)90.3%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T14:53:23.744698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length24
Mean length18.756944
Min length15

Characters and Unicode

Total characters2701
Distinct characters56
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

Unique119 ?
Unique (%)82.6%

Sample

1st row광주광역시 남구 구소동 753
2nd row광주광역시 남구 구소동 752
3rd row광주광역시 남구 덕남동 360-1
4th row광주광역시 남구 덕남동 294-2
5th row광주광역시 남구 이장동 857-9
ValueCountFrequency (%)
광주광역시 144
24.4%
남구 144
24.4%
백운동 17
 
2.9%
주월동 15
 
2.5%
진월동 13
 
2.2%
봉선동 13
 
2.2%
구소동 11
 
1.9%
화장동 11
 
1.9%
1132-2 10
 
1.7%
월산동 8
 
1.4%
Other values (147) 204
34.6%
2023-12-12T14:53:24.190750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
512
19.0%
광 288
 
10.7%
주 159
 
5.9%
구 155
 
5.7%
남 148
 
5.5%
동 144
 
5.3%
시 144
 
5.3%
역 144
 
5.3%
1 122
 
4.5%
- 115
 
4.3%
Other values (46) 770
28.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1451
53.7%
Decimal Number 623
23.1%
Space Separator 512
 
19.0%
Dash Punctuation 115
 
4.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 288
19.8%
주 159
11.0%
구 155
10.7%
남 148
10.2%
동 144
9.9%
시 144
9.9%
역 144
9.9%
월 38
 
2.6%
장 22
 
1.5%
운 17
 
1.2%
Other values (34) 192
13.2%
Decimal Number
ValueCountFrequency (%)
1 122
19.6%
3 103
16.5%
2 81
13.0%
7 64
10.3%
4 53
8.5%
5 49
7.9%
6 47
 
7.5%
0 40
 
6.4%
9 32
 
5.1%
8 32
 
5.1%
Space Separator
ValueCountFrequency (%)
512
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 115
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1451
53.7%
Common 1250
46.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 288
19.8%
주 159
11.0%
구 155
10.7%
남 148
10.2%
동 144
9.9%
시 144
9.9%
역 144
9.9%
월 38
 
2.6%
장 22
 
1.5%
운 17
 
1.2%
Other values (34) 192
13.2%
Common
ValueCountFrequency (%)
512
41.0%
1 122
 
9.8%
- 115
 
9.2%
3 103
 
8.2%
2 81
 
6.5%
7 64
 
5.1%
4 53
 
4.2%
5 49
 
3.9%
6 47
 
3.8%
0 40
 
3.2%
Other values (2) 64
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1451
53.7%
ASCII 1250
46.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
512
41.0%
1 122
 
9.8%
- 115
 
9.2%
3 103
 
8.2%
2 81
 
6.5%
7 64
 
5.1%
4 53
 
4.2%
5 49
 
3.9%
6 47
 
3.8%
0 40
 
3.2%
Other values (2) 64
 
5.1%
Hangul
ValueCountFrequency (%)
광 288
19.8%
주 159
11.0%
구 155
10.7%
남 148
10.2%
동 144
9.9%
시 144
9.9%
역 144
9.9%
월 38
 
2.6%
장 22
 
1.5%
운 17
 
1.2%
Other values (34) 192
13.2%

데이터작성일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-10-18
144 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-18
2nd row2023-10-18
3rd row2023-10-18
4th row2023-10-18
5th row2023-10-18

Common Values

ValueCountFrequency (%)
2023-10-18 144
100.0%

Length

2023-12-12T14:53:24.348492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:53:24.450878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-18 144
100.0%

Correlations

2023-12-12T14:53:24.520253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
피해연도구분
피해연도1.0000.686
구분0.6861.000
2023-12-12T14:53:24.615412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
피해연도구분
피해연도1.0000.343
구분0.3431.000
2023-12-12T14:53:24.694364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
피해연도구분
피해연도1.0000.343
구분0.3431.000

Missing values

2023-12-12T14:53:22.740447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:53:22.833591image/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

피해연도구분도로명주소데이터작성일자
02021농경지광주광역시 남구 구소동 7532023-10-18
12021농경지광주광역시 남구 구소동 7522023-10-18
22021농경지광주광역시 남구 덕남동 360-12023-10-18
32021농경지광주광역시 남구 덕남동 294-22023-10-18
42021농경지광주광역시 남구 이장동 857-92023-10-18
52021농경지광주광역시 남구 대지동 738-82023-10-18
62021농경지광주광역시 남구 대지동 738-72023-10-18
72021농경지광주광역시 남구 신장동 270-2023-10-18
82021농경지광주광역시 남구 지석동 416-152023-10-18
92021농경지광주광역시 남구 지석동 416-162023-10-18
피해연도구분도로명주소데이터작성일자
1342023주택광주광역시 남구 주월동 426-102023-10-18
1352023주택광주광역시 남구 주월동 443-252023-10-18
1362023소상공인광주광역시 남구 봉선동 475-62023-10-18
1372023주택광주광역시 남구 서동 31-20 1층2023-10-18
1382023주택광주광역시 남구 사동 88-3 1층2023-10-18
1392023주택광주광역시 남구 사동 164-3 1층2023-10-18
1402023농경지광주광역시 남구 구소동 700-22023-10-18
1412023농경지광주광역시 남구 대지동 753-42023-10-18
1422023농경지광주광역시 남구 칠석동 945-42023-10-18
1432023농경지광주광역시 남구 도금동 306-12023-10-18

Duplicate rows

Most frequently occurring

피해연도구분도로명주소데이터작성일자# duplicates
62023소상공인광주광역시 남구 진월동 377-252023-10-184
32023소상공인광주광역시 남구 진월동 375-12023-10-183
02023소상공인광주광역시 남구 백운동 210-82023-10-182
12023소상공인광주광역시 남구 백운동 633-42023-10-182
22023소상공인광주광역시 남구 주월동 941-1392023-10-182
42023소상공인광주광역시 남구 진월동 375-32023-10-182
52023소상공인광주광역시 남구 진월동 377-202023-10-182
72023주택광주광역시 남구 백운동 634-302023-10-182