Overview

Dataset statistics

Number of variables5
Number of observations1031
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory41.4 KiB
Average record size in memory41.1 B

Variable types

Numeric1
Categorical2
Text1
DateTime1

Dataset

Description광주광역시 북부소방서 관내 소방용수시설 현황에 대한 데이터로 광주광역시 북구 내 소방용수시설 갯수, 종별, 동별, 새주소 현황을 제공합니다.
URLhttps://www.data.go.kr/data/15054973/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 동별High correlation
동별 is highly overall correlated with 연번High correlation
소방용수시설구분 is highly imbalanced (51.0%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:42:29.058997
Analysis finished2023-12-12 14:42:29.571994
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1031
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean516
Minimum1
Maximum1031
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.2 KiB
2023-12-12T23:42:29.706352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile52.5
Q1258.5
median516
Q3773.5
95-th percentile979.5
Maximum1031
Range1030
Interquartile range (IQR)515

Descriptive statistics

Standard deviation297.76837
Coefficient of variation (CV)0.57707048
Kurtosis-1.2
Mean516
Median Absolute Deviation (MAD)258
Skewness0
Sum531996
Variance88666
MonotonicityStrictly increasing
2023-12-12T23:42:30.153104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
710 1
 
0.1%
680 1
 
0.1%
681 1
 
0.1%
682 1
 
0.1%
683 1
 
0.1%
684 1
 
0.1%
685 1
 
0.1%
686 1
 
0.1%
687 1
 
0.1%
Other values (1021) 1021
99.0%
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 (%)
1031 1
0.1%
1030 1
0.1%
1029 1
0.1%
1028 1
0.1%
1027 1
0.1%
1026 1
0.1%
1025 1
0.1%
1024 1
0.1%
1023 1
0.1%
1022 1
0.1%

소방용수시설구분
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
지상식
746 
지하식
263 
저수조
 
12
급수탑
 
10

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row지하식
2nd row지하식
3rd row지하식
4th row지하식
5th row지상식

Common Values

ValueCountFrequency (%)
지상식 746
72.4%
지하식 263
 
25.5%
저수조 12
 
1.2%
급수탑 10
 
1.0%

Length

2023-12-12T23:42:30.279878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:42:30.405445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
지상식 746
72.4%
지하식 263
 
25.5%
저수조 12
 
1.2%
급수탑 10
 
1.0%

동별
Categorical

HIGH CORRELATION 

Distinct49
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
일곡동
83 
용봉동
 
63
신안동
 
56
연제동
 
52
문흥동
 
52
Other values (44)
725 

Length

Max length6
Median length3
Mean length3.2880698
Min length2

Unique

Unique7 ?
Unique (%)0.7%

Sample

1st row문흥동
2nd row문흥동
3rd row문흥동
4th row문흥동
5th row문흥동

Common Values

ValueCountFrequency (%)
일곡동 83
 
8.1%
용봉동 63
 
6.1%
신안동 56
 
5.4%
연제동 52
 
5.0%
문흥동 52
 
5.0%
양산동 48
 
4.7%
두암3동 39
 
3.8%
운암동 39
 
3.8%
삼각동 37
 
3.6%
임동 37
 
3.6%
Other values (39) 525
50.9%

Length

2023-12-12T23:42:30.531012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
일곡동 83
 
8.1%
용봉동 63
 
6.1%
신안동 56
 
5.4%
연제동 52
 
5.0%
문흥동 52
 
5.0%
양산동 48
 
4.7%
두암3동 39
 
3.8%
운암동 39
 
3.8%
삼각동 37
 
3.6%
임동 37
 
3.6%
Other values (37) 525
50.9%

소재지도로명주소
Text

Distinct982
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
2023-12-12T23:42:30.936491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length25
Mean length18.367604
Min length13

Characters and Unicode

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

Unique

Unique945 ?
Unique (%)91.7%

Sample

1st row광주광역시 북구 서하로 355번길 17
2nd row광주광역시 북구 대천로 157번길 53
3rd row광주광역시 북구 서하로 355번길 46
4th row광주광역시 북구 부남길 29
5th row광주광역시 북구 문산로74번길 121
ValueCountFrequency (%)
북구 1206
27.6%
광주광역시 1026
23.5%
설죽로 52
 
1.2%
동문대로 32
 
0.7%
우치로 31
 
0.7%
서하로 28
 
0.6%
군왕로 24
 
0.6%
첨단연신로 23
 
0.5%
양일로 22
 
0.5%
하서로 22
 
0.5%
Other values (852) 1896
43.5%
2023-12-12T23:42:31.509949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3423
18.1%
광 2062
 
10.9%
북 1247
 
6.6%
구 1211
 
6.4%
주 1042
 
5.5%
역 1031
 
5.4%
시 1031
 
5.4%
로 957
 
5.1%
1 690
 
3.6%
2 446
 
2.4%
Other values (147) 5797
30.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12021
63.5%
Space Separator 3423
 
18.1%
Decimal Number 3344
 
17.7%
Dash Punctuation 147
 
0.8%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 2062
17.2%
북 1247
10.4%
구 1211
10.1%
주 1042
8.7%
역 1031
8.6%
시 1031
8.6%
로 957
 
8.0%
길 436
 
3.6%
번 376
 
3.1%
대 150
 
1.2%
Other values (133) 2478
20.6%
Decimal Number
ValueCountFrequency (%)
1 690
20.6%
2 446
13.3%
3 400
12.0%
5 295
8.8%
4 278
8.3%
0 272
 
8.1%
7 251
 
7.5%
8 244
 
7.3%
9 238
 
7.1%
6 230
 
6.9%
Space Separator
ValueCountFrequency (%)
3423
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 147
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12021
63.5%
Common 6916
36.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 2062
17.2%
북 1247
10.4%
구 1211
10.1%
주 1042
8.7%
역 1031
8.6%
시 1031
8.6%
로 957
 
8.0%
길 436
 
3.6%
번 376
 
3.1%
대 150
 
1.2%
Other values (133) 2478
20.6%
Common
ValueCountFrequency (%)
3423
49.5%
1 690
 
10.0%
2 446
 
6.4%
3 400
 
5.8%
5 295
 
4.3%
4 278
 
4.0%
0 272
 
3.9%
7 251
 
3.6%
8 244
 
3.5%
9 238
 
3.4%
Other values (4) 379
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12021
63.5%
ASCII 6916
36.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3423
49.5%
1 690
 
10.0%
2 446
 
6.4%
3 400
 
5.8%
5 295
 
4.3%
4 278
 
4.0%
0 272
 
3.9%
7 251
 
3.6%
8 244
 
3.5%
9 238
 
3.4%
Other values (4) 379
 
5.5%
Hangul
ValueCountFrequency (%)
광 2062
17.2%
북 1247
10.4%
구 1211
10.1%
주 1042
8.7%
역 1031
8.6%
시 1031
8.6%
로 957
 
8.0%
길 436
 
3.6%
번 376
 
3.1%
대 150
 
1.2%
Other values (133) 2478
20.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
Minimum2023-03-13 00:00:00
Maximum2023-03-13 00:00:00
2023-12-12T23:42:31.628122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:31.728711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T23:42:29.303637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:42:31.811831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소방용수시설구분동별
연번1.0000.2290.990
소방용수시설구분0.2291.0000.164
동별0.9900.1641.000
2023-12-12T23:42:31.902321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소방용수시설구분동별
소방용수시설구분1.0000.081
동별0.0811.000
2023-12-12T23:42:31.991149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소방용수시설구분동별
연번1.0000.1360.887
소방용수시설구분0.1361.0000.081
동별0.8870.0811.000

Missing values

2023-12-12T23:42:29.418283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:42:29.526883image/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지하식문흥동광주광역시 북구 서하로 355번길 172023-03-13
12지하식문흥동광주광역시 북구 대천로 157번길 532023-03-13
23지하식문흥동광주광역시 북구 서하로 355번길 462023-03-13
34지하식문흥동광주광역시 북구 부남길 292023-03-13
45지상식문흥동광주광역시 북구 문산로74번길 1212023-03-13
56지상식문흥동광주광역시 북구 동문대로 2552023-03-13
67지상식문흥동광주광역시 북구 대천로 157번길 802023-03-13
78지상식문흥동광주광역시 북구 능안로 28-12023-03-13
89지상식문흥동광주광역시 북구 문산로 992023-03-13
910지상식문흥동광주광역시 북구 문산로 992023-03-13
연번소방용수시설구분동별소재지도로명주소데이터기준일자
10211022지상식오룡동광주광역시 북구 첨단과기로208번길 52023-03-13
10221023지상식오룡동광주광역시 북구 첨단과기로 2402023-03-13
10231024지상식오룡동광주광역시 북구 첨단과기로 2352023-03-13
10241025지상식오룡동광주광역시 북구 첨단과기로 2402023-03-13
10251026지상식오룡동광주광역시 북구 북구 오룡동 1110-32023-03-13
10261027지상식오룡동광주광역시 북구 북구 오룡동 1110-192023-03-13
10271028지상식오룡동광주광역시 북구 북구 오룡동 1112-12023-03-13
10281029지상식오룡동광주광역시 북구 첨단과기로208번길 342023-03-13
10291030지상식오룡동광주광역시 북구 추암로 302023-03-13
10301031지상식오룡동광주광역시 북구 북구 오룡동 1109-102023-03-13