Overview

Dataset statistics

Number of variables11
Number of observations1872
Missing cells12
Missing cells (%)0.1%
Duplicate rows309
Duplicate rows (%)16.5%
Total size in memory161.0 KiB
Average record size in memory88.1 B

Variable types

DateTime4
Categorical4
Text3

Dataset

Description제주특별자치도의 2020년 구조활동현황에 대한 자료로 신고년월일,신고시각,출동년월일,출동시각,발생장소_시,발생장소_구,발생장소_동,발생장소_리,번지,사고원인,사고원인코드명_사고종별의 항목을 제공함
Author소방청
URLhttps://www.data.go.kr/data/15083676/fileData.do

Alerts

발생장소_시 has constant value ""Constant
Dataset has 309 (16.5%) duplicate rowsDuplicates
사고원인코드명_사고종별 is highly overall correlated with 사고원인High correlation
사고원인 is highly overall correlated with 사고원인코드명_사고종별High correlation

Reproduction

Analysis started2023-12-12 06:23:51.528277
Analysis finished2023-12-12 06:23:52.684924
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

신고년월일
Date

Distinct349
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
Minimum2020-01-01 00:00:00
Maximum2020-12-31 00:00:00
2023-12-12T15:23:52.802801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:23:52.961559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

신고시각
Date

Distinct824
Distinct (%)44.0%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
Minimum2023-12-12 00:01:00
Maximum2023-12-12 23:58:00
2023-12-12T15:23:53.121436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:23:53.290910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

출동년월일
Date

Distinct349
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
Minimum2020-01-01 00:00:00
Maximum2020-12-31 00:00:00
2023-12-12T15:23:53.455666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:23:53.688659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

출동시각
Date

Distinct841
Distinct (%)44.9%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
Minimum2023-12-12 00:03:00
Maximum2023-12-12 23:59:00
2023-12-12T15:23:53.883972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:23:54.034105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발생장소_시
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
제주특별자치도
1872 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주특별자치도
2nd row제주특별자치도
3rd row제주특별자치도
4th row제주특별자치도
5th row제주특별자치도

Common Values

ValueCountFrequency (%)
제주특별자치도 1872
100.0%

Length

2023-12-12T15:23:54.197757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:23:54.324690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주특별자치도 1872
100.0%

발생장소_구
Categorical

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
제주시
1127 
서귀포시
745 

Length

Max length4
Median length3
Mean length3.3979701
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서귀포시
2nd row제주시
3rd row제주시
4th row제주시
5th row제주시

Common Values

ValueCountFrequency (%)
제주시 1127
60.2%
서귀포시 745
39.8%

Length

2023-12-12T15:23:54.445445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:23:54.574560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주시 1127
60.2%
서귀포시 745
39.8%

발생장소_동
Text

Distinct71
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
2023-12-12T15:23:54.810488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.1362179
Min length2

Characters and Unicode

Total characters5871
Distinct characters76
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row하원동
2nd row아라일동
3rd row우도면
4th row우도면
5th row조천읍
ValueCountFrequency (%)
애월읍 238
 
12.7%
구좌읍 132
 
7.1%
조천읍 131
 
7.0%
남원읍 126
 
6.7%
안덕면 100
 
5.3%
한림읍 91
 
4.9%
대정읍 89
 
4.8%
성산읍 74
 
4.0%
표선면 66
 
3.5%
노형동 60
 
3.2%
Other values (61) 765
40.9%
2023-12-12T15:23:55.236611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
읍 881
 
15.0%
동 815
 
13.9%
월 245
 
4.2%
애 238
 
4.1%
면 201
 
3.4%
이 193
 
3.3%
일 165
 
2.8%
천 135
 
2.3%
원 135
 
2.3%
구 132
 
2.2%
Other values (66) 2731
46.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5871
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
읍 881
 
15.0%
동 815
 
13.9%
월 245
 
4.2%
애 238
 
4.1%
면 201
 
3.4%
이 193
 
3.3%
일 165
 
2.8%
천 135
 
2.3%
원 135
 
2.3%
구 132
 
2.2%
Other values (66) 2731
46.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5871
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
읍 881
 
15.0%
동 815
 
13.9%
월 245
 
4.2%
애 238
 
4.1%
면 201
 
3.4%
이 193
 
3.3%
일 165
 
2.8%
천 135
 
2.3%
원 135
 
2.3%
구 132
 
2.2%
Other values (66) 2731
46.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5871
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
읍 881
 
15.0%
동 815
 
13.9%
월 245
 
4.2%
애 238
 
4.1%
면 201
 
3.4%
이 193
 
3.3%
일 165
 
2.8%
천 135
 
2.3%
원 135
 
2.3%
구 132
 
2.2%
Other values (66) 2731
46.5%

발생장소_리
Text

Distinct164
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
2023-12-12T15:23:55.546228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.1538462
Min length2

Characters and Unicode

Total characters5904
Distinct characters136
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

Unique10 ?
Unique (%)0.5%

Sample

1st row하원동
2nd row아라일동
3rd row연평리
4th row연평리
5th row교래리
ValueCountFrequency (%)
노형동 60
 
3.2%
이호일동 50
 
2.7%
건입동 40
 
2.1%
교래리 39
 
2.1%
연동 38
 
2.0%
강정동 35
 
1.9%
함덕리 35
 
1.9%
광령리 31
 
1.7%
색달동 31
 
1.7%
서귀동 30
 
1.6%
Other values (154) 1483
79.2%
2023-12-12T15:23:56.018059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
리 1082
 
18.3%
동 859
 
14.5%
이 193
 
3.3%
일 179
 
3.0%
도 133
 
2.3%
하 105
 
1.8%
성 100
 
1.7%
신 95
 
1.6%
서 79
 
1.3%
화 78
 
1.3%
Other values (126) 3001
50.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5885
99.7%
Decimal Number 19
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 1082
 
18.4%
동 859
 
14.6%
이 193
 
3.3%
일 179
 
3.0%
도 133
 
2.3%
하 105
 
1.8%
성 100
 
1.7%
신 95
 
1.6%
서 79
 
1.3%
화 78
 
1.3%
Other values (124) 2982
50.7%
Decimal Number
ValueCountFrequency (%)
1 14
73.7%
2 5
 
26.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5885
99.7%
Common 19
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 1082
 
18.4%
동 859
 
14.6%
이 193
 
3.3%
일 179
 
3.0%
도 133
 
2.3%
하 105
 
1.8%
성 100
 
1.7%
신 95
 
1.6%
서 79
 
1.3%
화 78
 
1.3%
Other values (124) 2982
50.7%
Common
ValueCountFrequency (%)
1 14
73.7%
2 5
 
26.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5885
99.7%
ASCII 19
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
리 1082
 
18.4%
동 859
 
14.6%
이 193
 
3.3%
일 179
 
3.0%
도 133
 
2.3%
하 105
 
1.8%
성 100
 
1.7%
신 95
 
1.6%
서 79
 
1.3%
화 78
 
1.3%
Other values (124) 2982
50.7%
ASCII
ValueCountFrequency (%)
1 14
73.7%
2 5
 
26.3%

번지
Text

Distinct1225
Distinct (%)65.9%
Missing12
Missing (%)0.6%
Memory size14.8 KiB
2023-12-12T15:23:56.371493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length5.0913978
Min length1

Characters and Unicode

Total characters9470
Distinct characters13
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

Unique716 ?
Unique (%)38.5%

Sample

1st row산1-4
2nd row산67-18
3rd row산20
4th row1747-4
5th row산137-2
ValueCountFrequency (%)
산 7
 
0.4%
산1 6
 
0.3%
산-1 6
 
0.3%
224 5
 
0.3%
1956-38 5
 
0.3%
375-43 5
 
0.3%
산76 5
 
0.3%
산35 5
 
0.3%
347-9 4
 
0.2%
2659-1 4
 
0.2%
Other values (1215) 1810
97.2%
2023-12-12T15:23:56.943445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1561
16.5%
- 1463
15.4%
2 1050
11.1%
3 929
9.8%
4 752
7.9%
5 696
7.3%
6 633
6.7%
7 582
 
6.1%
8 522
 
5.5%
0 505
 
5.3%
Other values (3) 777
8.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7731
81.6%
Dash Punctuation 1463
 
15.4%
Other Letter 274
 
2.9%
Space Separator 2
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1561
20.2%
2 1050
13.6%
3 929
12.0%
4 752
9.7%
5 696
9.0%
6 633
8.2%
7 582
 
7.5%
8 522
 
6.8%
0 505
 
6.5%
9 501
 
6.5%
Dash Punctuation
ValueCountFrequency (%)
- 1463
100.0%
Other Letter
ValueCountFrequency (%)
산 274
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 9196
97.1%
Hangul 274
 
2.9%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1561
17.0%
- 1463
15.9%
2 1050
11.4%
3 929
10.1%
4 752
8.2%
5 696
7.6%
6 633
6.9%
7 582
 
6.3%
8 522
 
5.7%
0 505
 
5.5%
Other values (2) 503
 
5.5%
Hangul
ValueCountFrequency (%)
산 274
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 9196
97.1%
Hangul 274
 
2.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1561
17.0%
- 1463
15.9%
2 1050
11.4%
3 929
10.1%
4 752
8.2%
5 696
7.6%
6 633
6.9%
7 582
 
6.3%
8 522
 
5.7%
0 505
 
5.5%
Other values (2) 503
 
5.5%
Hangul
ValueCountFrequency (%)
산 274
100.0%

사고원인
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
교통
1041 
수난
490 
산악
175 
추락
166 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row산악
2nd row산악
3rd row수난
4th row수난
5th row산악

Common Values

ValueCountFrequency (%)
교통 1041
55.6%
수난 490
26.2%
산악 175
 
9.3%
추락 166
 
8.9%

Length

2023-12-12T15:23:57.105615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:23:57.246619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교통 1041
55.6%
수난 490
26.2%
산악 175
 
9.3%
추락 166
 
8.9%

사고원인코드명_사고종별
Categorical

HIGH CORRELATION 

Distinct32
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size14.8 KiB
차대차
431 
기타 수난
314 
차대시설물
196 
승용차
182 
기타 추락
118 
Other values (27)
631 

Length

Max length9
Median length7
Mean length4.213141
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row기타산악
2nd row개인질환
3rd row선박조난
4th row선박조난
5th row개인질환

Common Values

ValueCountFrequency (%)
차대차 431
23.0%
기타 수난 314
16.8%
차대시설물 196
10.5%
승용차 182
9.7%
기타 추락 118
 
6.3%
기타 교통 72
 
3.8%
일반조난 72
 
3.8%
기타산악 68
 
3.6%
수상표류 51
 
2.7%
차대사람 50
 
2.7%
Other values (22) 318
17.0%

Length

2023-12-12T15:23:57.395158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 504
19.8%
차대차 431
16.9%
수난 314
12.3%
차대시설물 196
 
7.7%
승용차 182
 
7.1%
추락 166
 
6.5%
교통 72
 
2.8%
일반조난 72
 
2.8%
기타산악 68
 
2.7%
익수 61
 
2.4%
Other values (28) 480
18.9%

Correlations

2023-12-12T15:23:57.492454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발생장소_구발생장소_동사고원인사고원인코드명_사고종별
발생장소_구1.0000.9990.0850.116
발생장소_동0.9991.0000.5610.674
사고원인0.0850.5611.0001.000
사고원인코드명_사고종별0.1160.6741.0001.000
2023-12-12T15:23:57.624695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사고원인코드명_사고종별발생장소_구사고원인
사고원인코드명_사고종별1.0000.0910.992
발생장소_구0.0911.0000.056
사고원인0.9920.0561.000
2023-12-12T15:23:57.742209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발생장소_구사고원인사고원인코드명_사고종별
발생장소_구1.0000.0560.091
사고원인0.0561.0000.992
사고원인코드명_사고종별0.0910.9921.000

Missing values

2023-12-12T15:23:52.401680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:23:52.591898image/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

신고년월일신고시각출동년월일출동시각발생장소_시발생장소_구발생장소_동발생장소_리번지사고원인사고원인코드명_사고종별
02020-02-1411:042020-02-1411:30제주특별자치도서귀포시하원동하원동산1-4산악기타산악
12020-01-3112:012020-01-3112:24제주특별자치도제주시아라일동아라일동산67-18산악개인질환
22020-03-0413:502020-03-0413:51제주특별자치도제주시우도면연평리산20수난선박조난
32020-03-0809:502020-03-0810:00제주특별자치도제주시우도면연평리1747-4수난선박조난
42020-03-2107:152020-03-2107:36제주특별자치도제주시조천읍교래리산137-2산악개인질환
52020-04-3017:102020-04-3017:24제주특별자치도제주시추자면영흥리364-13수난기타 수난
62020-03-0513:492020-03-0514:10제주특별자치도제주시우도면연평리1442수난선박조난
72020-09-2214:232020-09-2214:39제주특별자치도서귀포시색달동색달동2950-32수난무동력수상레져
82020-02-1918:342020-02-1918:34제주특별자치도제주시조천읍와흘리2945교통차대시설물
92020-02-0414:582020-02-0414:59제주특별자치도제주시봉개동봉개동1439-3교통차대차
신고년월일신고시각출동년월일출동시각발생장소_시발생장소_구발생장소_동발생장소_리번지사고원인사고원인코드명_사고종별
18622020-05-2315:442020-05-2315:45제주특별자치도서귀포시표선면성읍리3146-7교통차대시설물
18632020-05-2700:562020-05-2700:59제주특별자치도서귀포시표선면성읍리2875-3교통차대시설물
18642020-03-1417:372020-03-1417:37제주특별자치도서귀포시표선면가시리산63산악일반조난
18652020-02-1708:382020-02-1708:39제주특별자치도서귀포시표선면가시리622-1교통승용차
18662020-02-1715:412020-02-1715:42제주특별자치도제주시구좌읍송당리2614-4교통승용차
18672020-02-1707:482020-02-1707:49제주특별자치도제주시구좌읍송당리산126-16교통승용차
18682020-11-0921:172020-11-0921:19제주특별자치도서귀포시표선면성읍리2163-6추락기타 추락
18692020-12-3015:432020-12-3015:46제주특별자치도서귀포시표선면성읍리1908-2교통승용차
18702020-08-2423:172020-08-2423:19제주특별자치도서귀포시표선면하천리2004-2교통차대시설물
18712020-08-2321:502020-08-2321:51제주특별자치도제주시구좌읍덕천리산11-3추락기타 추락

Duplicate rows

Most frequently occurring

신고년월일신고시각출동년월일출동시각발생장소_시발생장소_구발생장소_동발생장소_리번지사고원인사고원인코드명_사고종별# duplicates
2712020-11-1818:272020-11-1818:28제주특별자치도제주시조천읍교래리777-1교통승용차4
102020-01-1012:552020-01-1012:56제주특별자치도제주시애월읍하귀1리271-4수난기타 수난3
472020-03-1101:182020-03-1101:19제주특별자치도제주시노형동노형동919-2교통차대차3
492020-03-1207:062020-03-1207:06제주특별자치도서귀포시남원읍위미리1535-3교통차대차3
942020-05-1913:292020-05-1913:30제주특별자치도제주시외도일동외도일동643-2추락공사장 추락3
1162020-06-1815:392020-06-1815:40제주특별자치도제주시이호일동이호일동1788-8수난기타 수난3
1402020-07-1500:092020-07-1500:09제주특별자치도제주시애월읍고내리84추락기타 추락3
1452020-07-1812:182020-07-1812:19제주특별자치도제주시조천읍함덕리154수난어패류 채취 익수3
1742020-08-1213:472020-08-1213:48제주특별자치도제주시구좌읍하도리산0-5교통차대차3
1852020-08-1618:162020-08-1618:17제주특별자치도제주시이호일동이호일동1800수난기타 수난3