Overview

Dataset statistics

Number of variables5
Number of observations8973
Missing cells1316
Missing cells (%)2.9%
Duplicate rows2
Duplicate rows (%)< 0.1%
Total size in memory350.6 KiB
Average record size in memory40.0 B

Variable types

DateTime2
Text1
Categorical2

Dataset

Description충청남도 재난안전포털에서 제공하는 산사태 위기 경보 발령 정보입니다.(예보 발령일, 예보 발생지, 예보 발령상태, 예보 발령종류, 예보 해제일)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=31&beforeMenuCd=DOM_000000201001001000&publicdatapk=15118614

Alerts

Dataset has 2 (< 0.1%) duplicate rowsDuplicates
예보 해제일 has 1316 (14.7%) missing valuesMissing

Reproduction

Analysis started2024-01-09 21:21:34.689744
Analysis finished2024-01-09 21:21:35.113426
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

예보 발령일
Date

Distinct5124
Distinct (%)57.1%
Missing0
Missing (%)0.0%
Memory size70.2 KiB
Minimum2006-08-19 18:00:00
Maximum2023-08-09 13:55:00
2024-01-10T06:21:35.167251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:21:35.272108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예보 발생지
Text

Distinct305
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size70.2 KiB
2024-01-10T06:21:35.557906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length8
Mean length7.9663435
Min length3

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)0.4%

Sample

1st row경상북도 울릉군
2nd row강원도 양구군
3rd row강원도 양구군
4th row강원도 화천군
5th row강원도 춘천시
ValueCountFrequency (%)
경기도 1108
 
6.2%
경상북도 1003
 
5.6%
강원도 942
 
5.3%
전라남도 940
 
5.3%
경상남도 895
 
5.0%
서울특별시 724
 
4.1%
충청남도 709
 
4.0%
전라북도 667
 
3.7%
충청북도 635
 
3.6%
부산광역시 334
 
1.9%
Other values (264) 9863
55.3%
2024-01-10T06:21:35.943809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8847
 
12.4%
도 7137
 
10.0%
시 5267
 
7.4%
군 3878
 
5.4%
경 3127
 
4.4%
남 2989
 
4.2%
북 2463
 
3.4%
구 2103
 
2.9%
상 2003
 
2.8%
전 1784
 
2.5%
Other values (151) 31884
44.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 62635
87.6%
Space Separator 8847
 
12.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 7137
 
11.4%
시 5267
 
8.4%
군 3878
 
6.2%
경 3127
 
5.0%
남 2989
 
4.8%
북 2463
 
3.9%
구 2103
 
3.4%
상 2003
 
3.2%
전 1784
 
2.8%
청 1630
 
2.6%
Other values (150) 30254
48.3%
Space Separator
ValueCountFrequency (%)
8847
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 62635
87.6%
Common 8847
 
12.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 7137
 
11.4%
시 5267
 
8.4%
군 3878
 
6.2%
경 3127
 
5.0%
남 2989
 
4.8%
북 2463
 
3.9%
구 2103
 
3.4%
상 2003
 
3.2%
전 1784
 
2.8%
청 1630
 
2.6%
Other values (150) 30254
48.3%
Common
ValueCountFrequency (%)
8847
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 62635
87.6%
ASCII 8847
 
12.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8847
100.0%
Hangul
ValueCountFrequency (%)
도 7137
 
11.4%
시 5267
 
8.4%
군 3878
 
6.2%
경 3127
 
5.0%
남 2989
 
4.8%
북 2463
 
3.9%
구 2103
 
3.4%
상 2003
 
3.2%
전 1784
 
2.8%
청 1630
 
2.6%
Other values (150) 30254
48.3%

예보 발령상태
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size70.2 KiB
해제
6070 
자동해제
1587 
발령
1316 

Length

Max length4
Median length2
Mean length2.3537279
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row해제
2nd row해제
3rd row자동해제
4th row해제
5th row자동해제

Common Values

ValueCountFrequency (%)
해제 6070
67.6%
자동해제 1587
 
17.7%
발령 1316
 
14.7%

Length

2024-01-10T06:21:36.063119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:21:36.158673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해제 6070
67.6%
자동해제 1587
 
17.7%
발령 1316
 
14.7%

예보 발령종류
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size70.2 KiB
산사태주의보
6031 
산사태경보
2942 

Length

Max length6
Median length6
Mean length5.6721275
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row산사태주의보
2nd row산사태주의보
3rd row산사태경보
4th row산사태주의보
5th row산사태주의보

Common Values

ValueCountFrequency (%)
산사태주의보 6031
67.2%
산사태경보 2942
32.8%

Length

2024-01-10T06:21:36.246155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:21:36.322738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
산사태주의보 6031
67.2%
산사태경보 2942
32.8%

예보 해제일
Date

MISSING 

Distinct3922
Distinct (%)51.2%
Missing1316
Missing (%)14.7%
Memory size70.2 KiB
Minimum2006-08-21 00:00:00
Maximum2023-08-07 18:24:00
2024-01-10T06:21:36.431233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:21:36.569178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2024-01-10T06:21:36.637583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예보 발령상태예보 발령종류
예보 발령상태1.0000.097
예보 발령종류0.0971.000
2024-01-10T06:21:36.719927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예보 발령상태예보 발령종류
예보 발령상태1.0000.160
예보 발령종류0.1601.000
2024-01-10T06:21:36.809221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예보 발령상태예보 발령종류
예보 발령상태1.0000.160
예보 발령종류0.1601.000

Missing values

2024-01-10T06:21:35.000295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:21:35.076989image/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

예보 발령일예보 발생지예보 발령상태예보 발령종류예보 해제일
02006-08-19 18:00경상북도 울릉군해제산사태주의보2006-08-21 0:00
12007-08-04 10:00강원도 양구군해제산사태주의보2007-08-04 17:00
22007-08-09 13:00강원도 양구군자동해제산사태경보2007-08-14 13:00
32008-07-20 12:00강원도 화천군해제산사태주의보2008-07-21 12:00
42008-07-24 7:00강원도 춘천시자동해제산사태주의보2008-07-29 7:00
52008-07-24 7:00강원도 철원군해제산사태주의보2008-07-24 12:00
62008-07-24 7:00강원도 양구군해제산사태주의보2008-07-24 11:00
72008-07-24 9:00강원도 인제군해제산사태주의보2008-07-24 17:00
82008-07-24 10:00강원도 속초시해제산사태주의보2008-07-24 20:00
92008-07-24 10:00강원도 화천군해제산사태주의보2008-07-25 9:00
예보 발령일예보 발생지예보 발령상태예보 발령종류예보 해제일
89632023-07-26 7:37전라남도 순천시발령산사태주의보<NA>
89642023-07-26 8:54경기도 포천시발령산사태주의보<NA>
89652023-07-26 9:01경기도 연천군발령산사태주의보<NA>
89662023-07-26 17:37세종특별자치시발령산사태주의보<NA>
89672023-07-26 20:40경상북도 예천군발령산사태주의보<NA>
89682023-08-06 20:33강원특별자치도 고성군발령산사태경보<NA>
89692023-08-07 0:42강원특별자치도 양양군발령산사태주의보<NA>
89702023-08-07 16:57경상북도 문경시발령산사태주의보<NA>
89712023-08-07 17:02경상북도 영주시해제산사태주의보2023-08-07 18:24
89722023-08-09 13:55경상북도 예천군발령산사태주의보<NA>

Duplicate rows

Most frequently occurring

예보 발령일예보 발생지예보 발령상태예보 발령종류예보 해제일# duplicates
12023-07-14 13:28충청남도 청양군발령산사태주의보<NA>3
02021-08-24 12:55경상북도 안동시해제산사태주의보2021-08-24 16:122