Overview

Dataset statistics

Number of variables5
Number of observations98
Missing cells8
Missing cells (%)1.6%
Duplicate rows1
Duplicate rows (%)1.0%
Total size in memory4.1 KiB
Average record size in memory42.3 B

Variable types

Numeric1
Text2
Categorical1
DateTime1

Dataset

Description광주광역시 광산소방서 관내 소방시설업체 등(공사업, 설계업, 방염업, 감리업) 등록현 황입니다. 상호, 소재지도로명주소, 업종 등의 항목을 제공합니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15052633/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (1.0%) duplicate rowsDuplicates
연번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 연번High correlation
연번 has 2 (2.0%) missing valuesMissing
상호 has 2 (2.0%) missing valuesMissing
소재지도로명주소 has 2 (2.0%) missing valuesMissing
데이터기준일자 has 2 (2.0%) missing valuesMissing

Reproduction

Analysis started2023-12-11 22:54:43.200111
Analysis finished2023-12-11 22:54:44.046649
Duration0.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct96
Distinct (%)100.0%
Missing2
Missing (%)2.0%
Infinite0
Infinite (%)0.0%
Mean48.5
Minimum1
Maximum96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1014.0 B
2023-12-12T07:54:44.131769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.75
Q124.75
median48.5
Q372.25
95-th percentile91.25
Maximum96
Range95
Interquartile range (IQR)47.5

Descriptive statistics

Standard deviation27.856777
Coefficient of variation (CV)0.57436653
Kurtosis-1.2
Mean48.5
Median Absolute Deviation (MAD)24
Skewness0
Sum4656
Variance776
MonotonicityStrictly increasing
2023-12-12T07:54:44.260728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
50 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
67 1
 
1.0%
66 1
 
1.0%
65 1
 
1.0%
64 1
 
1.0%
Other values (86) 86
87.8%
(Missing) 2
 
2.0%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%
90 1
1.0%
89 1
1.0%
88 1
1.0%
87 1
1.0%

상호
Text

MISSING 

Distinct83
Distinct (%)86.5%
Missing2
Missing (%)2.0%
Memory size916.0 B
2023-12-12T07:54:44.532482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length8.28125
Min length2

Characters and Unicode

Total characters795
Distinct characters133
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique77 ?
Unique (%)80.2%

Sample

1st row(유)우전
2nd row(주)일도엔지니어링
3rd row주식회사 대명기전
4th row(주)세민
5th row(주)가나통신전력공사
ValueCountFrequency (%)
주식회사 38
27.5%
우림이앤씨 4
 
2.9%
피치이앤씨 4
 
2.9%
거성엔지니어링 4
 
2.9%
엔지니어링그룹 3
 
2.2%
에이원 3
 
2.2%
대성이앤씨 2
 
1.4%
다경eng 2
 
1.4%
서진산전 1
 
0.7%
썬투에너지 1
 
0.7%
Other values (76) 76
55.1%
2023-12-12T07:54:44.927897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 68
 
8.6%
42
 
5.3%
사 42
 
5.3%
회 39
 
4.9%
식 38
 
4.8%
이 35
 
4.4%
) 31
 
3.9%
( 31
 
3.9%
지 24
 
3.0%
엔 23
 
2.9%
Other values (123) 422
53.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 674
84.8%
Space Separator 42
 
5.3%
Close Punctuation 31
 
3.9%
Open Punctuation 31
 
3.9%
Other Symbol 8
 
1.0%
Uppercase Letter 6
 
0.8%
Decimal Number 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 68
 
10.1%
사 42
 
6.2%
회 39
 
5.8%
식 38
 
5.6%
이 35
 
5.2%
지 24
 
3.6%
엔 23
 
3.4%
방 18
 
2.7%
전 17
 
2.5%
에 17
 
2.5%
Other values (114) 353
52.4%
Uppercase Letter
ValueCountFrequency (%)
G 2
33.3%
N 2
33.3%
E 2
33.3%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
9 1
33.3%
Space Separator
ValueCountFrequency (%)
42
100.0%
Close Punctuation
ValueCountFrequency (%)
) 31
100.0%
Open Punctuation
ValueCountFrequency (%)
( 31
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 682
85.8%
Common 107
 
13.5%
Latin 6
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 68
 
10.0%
사 42
 
6.2%
회 39
 
5.7%
식 38
 
5.6%
이 35
 
5.1%
지 24
 
3.5%
엔 23
 
3.4%
방 18
 
2.6%
전 17
 
2.5%
에 17
 
2.5%
Other values (115) 361
52.9%
Common
ValueCountFrequency (%)
42
39.3%
) 31
29.0%
( 31
29.0%
1 2
 
1.9%
9 1
 
0.9%
Latin
ValueCountFrequency (%)
G 2
33.3%
N 2
33.3%
E 2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 674
84.8%
ASCII 113
 
14.2%
None 8
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 68
 
10.1%
사 42
 
6.2%
회 39
 
5.8%
식 38
 
5.6%
이 35
 
5.2%
지 24
 
3.6%
엔 23
 
3.4%
방 18
 
2.7%
전 17
 
2.5%
에 17
 
2.5%
Other values (114) 353
52.4%
ASCII
ValueCountFrequency (%)
42
37.2%
) 31
27.4%
( 31
27.4%
G 2
 
1.8%
1 2
 
1.8%
N 2
 
1.8%
E 2
 
1.8%
9 1
 
0.9%
None
ValueCountFrequency (%)
㈜ 8
100.0%

소재지도로명주소
Text

MISSING 

Distinct78
Distinct (%)81.2%
Missing2
Missing (%)2.0%
Memory size916.0 B
2023-12-12T07:54:45.247906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length42.5
Mean length36.697917
Min length30

Characters and Unicode

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

Unique

Unique66 ?
Unique (%)68.8%

Sample

1st row(62390) 광주광역시 광산구 어등대로621번길 5 (소촌동)
2nd row(62319) 광주광역시 광산구 목련로273번안길 79 ,2층 203호(운남동)
3rd row(62244) 광주광역시 광산구 임방울대로 611-34 (도천동)
4th row(62395) 광주광역시 광산구 하남지실길 258 (산정동)
5th row(62393) 광주광역시 광산구 평동로1120번길 40 1층(송정동)
ValueCountFrequency (%)
광주광역시 96
 
16.0%
광산구 93
 
15.5%
도천동 10
 
1.7%
62244 8
 
1.3%
62252 6
 
1.0%
장신로 6
 
1.0%
261 6
 
1.0%
신창동,드림프라자 6
 
1.0%
62216 6
 
1.0%
하남산단6번로 6
 
1.0%
Other values (229) 356
59.4%
2023-12-12T07:54:45.737922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
510
 
14.5%
광 285
 
8.1%
2 233
 
6.6%
( 192
 
5.4%
) 192
 
5.4%
6 156
 
4.4%
산 136
 
3.9%
1 115
 
3.3%
동 112
 
3.2%
주 96
 
2.7%
Other values (110) 1496
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1617
45.9%
Decimal Number 944
26.8%
Space Separator 510
 
14.5%
Open Punctuation 192
 
5.4%
Close Punctuation 192
 
5.4%
Other Punctuation 35
 
1.0%
Dash Punctuation 33
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 285
17.6%
산 136
 
8.4%
동 112
 
6.9%
주 96
 
5.9%
역 96
 
5.9%
시 96
 
5.9%
구 93
 
5.8%
로 79
 
4.9%
길 51
 
3.2%
번 41
 
2.5%
Other values (95) 532
32.9%
Decimal Number
ValueCountFrequency (%)
2 233
24.7%
6 156
16.5%
1 115
12.2%
3 94
10.0%
4 80
 
8.5%
5 77
 
8.2%
7 58
 
6.1%
0 48
 
5.1%
8 42
 
4.4%
9 41
 
4.3%
Space Separator
ValueCountFrequency (%)
510
100.0%
Open Punctuation
ValueCountFrequency (%)
( 192
100.0%
Close Punctuation
ValueCountFrequency (%)
) 192
100.0%
Other Punctuation
ValueCountFrequency (%)
, 35
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 33
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1906
54.1%
Hangul 1617
45.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 285
17.6%
산 136
 
8.4%
동 112
 
6.9%
주 96
 
5.9%
역 96
 
5.9%
시 96
 
5.9%
구 93
 
5.8%
로 79
 
4.9%
길 51
 
3.2%
번 41
 
2.5%
Other values (95) 532
32.9%
Common
ValueCountFrequency (%)
510
26.8%
2 233
12.2%
( 192
 
10.1%
) 192
 
10.1%
6 156
 
8.2%
1 115
 
6.0%
3 94
 
4.9%
4 80
 
4.2%
5 77
 
4.0%
7 58
 
3.0%
Other values (5) 199
 
10.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1906
54.1%
Hangul 1617
45.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
510
26.8%
2 233
12.2%
( 192
 
10.1%
) 192
 
10.1%
6 156
 
8.2%
1 115
 
6.0%
3 94
 
4.9%
4 80
 
4.2%
5 77
 
4.0%
7 58
 
3.0%
Other values (5) 199
 
10.4%
Hangul
ValueCountFrequency (%)
광 285
17.6%
산 136
 
8.4%
동 112
 
6.9%
주 96
 
5.9%
역 96
 
5.9%
시 96
 
5.9%
구 93
 
5.8%
로 79
 
4.9%
길 51
 
3.2%
번 41
 
2.5%
Other values (95) 532
32.9%

업종
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size916.0 B
공사업
61 
관리업
13 
설계업
10 
감리업
8 
방염업
 
4

Length

Max length4
Median length3
Mean length3.0204082
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공사업
2nd row공사업
3rd row공사업
4th row공사업
5th row공사업

Common Values

ValueCountFrequency (%)
공사업 61
62.2%
관리업 13
 
13.3%
설계업 10
 
10.2%
감리업 8
 
8.2%
방염업 4
 
4.1%
<NA> 2
 
2.0%

Length

2023-12-12T07:54:45.894950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:54:46.040028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공사업 61
62.2%
관리업 13
 
13.3%
설계업 10
 
10.2%
감리업 8
 
8.2%
방염업 4
 
4.1%
na 2
 
2.0%

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)1.0%
Missing2
Missing (%)2.0%
Memory size916.0 B
Minimum2022-10-20 00:00:00
Maximum2022-10-20 00:00:00
2023-12-12T07:54:46.227336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:54:46.382694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T07:54:43.623748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T07:54:46.510369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호소재지도로명주소업종
연번1.0000.9850.9590.884
상호0.9851.0001.0000.000
소재지도로명주소0.9591.0001.0000.000
업종0.8840.0000.0001.000
2023-12-12T07:54:46.652226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.549
업종0.5491.000

Missing values

2023-12-12T07:54:43.723444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:54:43.815118image/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.
2023-12-12T07:54:43.958914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

연번상호소재지도로명주소업종데이터기준일자
01(유)우전(62390) 광주광역시 광산구 어등대로621번길 5 (소촌동)공사업2022-10-20
12(주)일도엔지니어링(62319) 광주광역시 광산구 목련로273번안길 79 ,2층 203호(운남동)공사업2022-10-20
23주식회사 대명기전(62244) 광주광역시 광산구 임방울대로 611-34 (도천동)공사업2022-10-20
34(주)세민(62395) 광주광역시 광산구 하남지실길 258 (산정동)공사업2022-10-20
45(주)가나통신전력공사(62393) 광주광역시 광산구 평동로1120번길 40 1층(송정동)공사업2022-10-20
56(주)성원이앤지(62464) 광주광역시 광산구 진곡산단5번로 57-10 (진곡동)공사업2022-10-20
67(주)가경소방전력공사(62272) 광주광역시 광산구 월봉안길 3 (산월동)공사업2022-10-20
78(주)영재에프에스(62316) 광주광역시 광산구 풍영철길로 188-25 2층(운남동)공사업2022-10-20
89(주)한백(62241) 광주광역시 광산구 비아로 23 (도천동)공사업2022-10-20
910대흥설비(주)(62365) 광주광역시 광산구 우산로107번길 16 (우산동)공사업2022-10-20
연번상호소재지도로명주소업종데이터기준일자
8889㈜광진소방(62355) 광주광역시 광산구 풍영철길로 115, 409호(우산동)관리업2022-10-20
8990주식회사 에프원방재(62332) 광주광역시 광산구 산정공원로93번길 28-9 (산정동)관리업2022-10-20
9091㈜영재에프에스(62316) 광주광역시 광산구 풍영철길로 188-25, 2층 (운남동)관리업2022-10-20
9192늘푸른방재㈜(62449) 광주광역시 광산구 남동길 42 (도산동)관리업2022-10-20
9293㈜성원소방이엔지(62232) 광주광역시 광산구 하남마항로29번길 37 (하남동)관리업2022-10-20
9394덕성전기 주식회사(62377) 광주광역시 광산구 금봉로54번길 15 (소촌동)관리업2022-10-20
9495㈜서광방재이앤씨(62243) 광주광역시 광산구 하남산단8번로 177 (도천동)관리업2022-10-20
9596엔지니어링그룹 에이원(62251) 광주광역시 광산구 왕버들로 287, 2층 (신창동)관리업2022-10-20
96<NA><NA><NA><NA><NA>
97<NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

연번상호소재지도로명주소업종데이터기준일자# duplicates
0<NA><NA><NA><NA><NA>2