Overview

Dataset statistics

Number of variables4
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1023.0 B
Average record size in memory37.9 B

Variable types

Numeric1
Categorical1
Text2

Dataset

Description광주광역시 남부소방서 관내 가스시설 현황입니다.- 상세내용: 관내 가스시설종류, 업체명, 주소 등 정보 데이터 제공
Author광주광역시
URLhttps://www.data.go.kr/data/15052474/fileData.do

Alerts

연번 is highly overall correlated with 가스시설구분High correlation
가스시설구분 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:48:47.967743
Analysis finished2023-12-12 10:48:48.544868
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14
Minimum1
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-12T19:48:48.648317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.3
Q17.5
median14
Q320.5
95-th percentile25.7
Maximum27
Range26
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.9372539
Coefficient of variation (CV)0.56694671
Kurtosis-1.2
Mean14
Median Absolute Deviation (MAD)7
Skewness0
Sum378
Variance63
MonotonicityStrictly increasing
2023-12-12T19:48:48.841186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1 1
 
3.7%
2 1
 
3.7%
27 1
 
3.7%
26 1
 
3.7%
25 1
 
3.7%
24 1
 
3.7%
23 1
 
3.7%
22 1
 
3.7%
21 1
 
3.7%
20 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
1 1
3.7%
2 1
3.7%
3 1
3.7%
4 1
3.7%
5 1
3.7%
6 1
3.7%
7 1
3.7%
8 1
3.7%
9 1
3.7%
10 1
3.7%
ValueCountFrequency (%)
27 1
3.7%
26 1
3.7%
25 1
3.7%
24 1
3.7%
23 1
3.7%
22 1
3.7%
21 1
3.7%
20 1
3.7%
19 1
3.7%
18 1
3.7%

가스시설구분
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)22.2%
Missing0
Missing (%)0.0%
Memory size348.0 B
LPG충전사업
8 
고압가스냉동제조
6 
LPG판매사업
4 
고압가스저장소
4 
고압가스판매
3 

Length

Max length8
Median length7
Mean length7.1851852
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowLPG판매사업
2nd rowLPG판매사업
3rd rowLPG판매사업
4th rowLPG판매사업
5th rowLPG충전사업

Common Values

ValueCountFrequency (%)
LPG충전사업 8
29.6%
고압가스냉동제조 6
22.2%
LPG판매사업 4
14.8%
고압가스저장소 4
14.8%
고압가스판매 3
 
11.1%
고압가스일반제조 2
 
7.4%

Length

2023-12-12T19:48:49.071885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:48:49.271266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
lpg충전사업 8
29.6%
고압가스냉동제조 6
22.2%
lpg판매사업 4
14.8%
고압가스저장소 4
14.8%
고압가스판매 3
 
11.1%
고압가스일반제조 2
 
7.4%

업체명
Text

Distinct24
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-12T19:48:49.559462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length10
Mean length7.7777778
Min length4

Characters and Unicode

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

Unique

Unique22 ?
Unique (%)81.5%

Sample

1st row대창가스
2nd row아주산소㈜
3rd row(유)동양가스
4th row(유)대중문화가스
5th row(주)도시산업
ValueCountFrequency (%)
아주산소㈜ 3
 
11.1%
대창가스 2
 
7.4%
재)빛고을노인복지재단 1
 
3.7%
미래아동병원 1
 
3.7%
주)콜드앤클린테크 1
 
3.7%
기독병원(기숙사 1
 
3.7%
광주기독병원 1
 
3.7%
빛고을전남대학교병원(64 1
 
3.7%
빛고을전남대학교병원(63 1
 
3.7%
빛고을시민문화관(광주문화재단 1
 
3.7%
Other values (14) 14
51.9%
2023-12-12T19:48:50.082627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 9
 
4.3%
소 9
 
4.3%
대 9
 
4.3%
( 9
 
4.3%
) 9
 
4.3%
전 8
 
3.8%
스 6
 
2.9%
충 6
 
2.9%
L 5
 
2.4%
광 5
 
2.4%
Other values (66) 135
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 168
80.0%
Uppercase Letter 15
 
7.1%
Open Punctuation 9
 
4.3%
Close Punctuation 9
 
4.3%
Other Symbol 5
 
2.4%
Decimal Number 4
 
1.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 9
 
5.4%
소 9
 
5.4%
대 9
 
5.4%
전 8
 
4.8%
스 6
 
3.6%
충 6
 
3.6%
광 5
 
3.0%
남 5
 
3.0%
원 5
 
3.0%
병 5
 
3.0%
Other values (57) 101
60.1%
Uppercase Letter
ValueCountFrequency (%)
L 5
33.3%
G 5
33.3%
P 5
33.3%
Decimal Number
ValueCountFrequency (%)
6 2
50.0%
3 1
25.0%
4 1
25.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 173
82.4%
Common 22
 
10.5%
Latin 15
 
7.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 9
 
5.2%
소 9
 
5.2%
대 9
 
5.2%
전 8
 
4.6%
스 6
 
3.5%
충 6
 
3.5%
광 5
 
2.9%
남 5
 
2.9%
원 5
 
2.9%
병 5
 
2.9%
Other values (58) 106
61.3%
Common
ValueCountFrequency (%)
( 9
40.9%
) 9
40.9%
6 2
 
9.1%
3 1
 
4.5%
4 1
 
4.5%
Latin
ValueCountFrequency (%)
L 5
33.3%
G 5
33.3%
P 5
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 168
80.0%
ASCII 37
 
17.6%
None 5
 
2.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 9
 
5.4%
소 9
 
5.4%
대 9
 
5.4%
전 8
 
4.8%
스 6
 
3.6%
충 6
 
3.6%
광 5
 
3.0%
남 5
 
3.0%
원 5
 
3.0%
병 5
 
3.0%
Other values (57) 101
60.1%
ASCII
ValueCountFrequency (%)
( 9
24.3%
) 9
24.3%
L 5
13.5%
G 5
13.5%
P 5
13.5%
6 2
 
5.4%
3 1
 
2.7%
4 1
 
2.7%
None
ValueCountFrequency (%)
㈜ 5
100.0%

주소
Text

Distinct22
Distinct (%)81.5%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-12T19:48:50.717845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length8.8148148
Min length5

Characters and Unicode

Total characters238
Distinct characters34
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

Unique18 ?
Unique (%)66.7%

Sample

1st row서문대로479번길 12
2nd row송암로58번길 46
3rd row서문대로 487
4th row효덕로 103
5th row송암로24번나길 14-22
ValueCountFrequency (%)
서문대로 4
 
7.1%
송암로58번길 3
 
5.4%
덕남길 3
 
5.4%
12 3
 
5.4%
46 3
 
5.4%
송암로24번나길 3
 
5.4%
송암로 2
 
3.6%
80 2
 
3.6%
서문대로473번길 2
 
3.6%
양림로 2
 
3.6%
Other values (26) 29
51.8%
2023-12-12T19:48:51.150291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
29
 
12.2%
로 23
 
9.7%
2 16
 
6.7%
4 16
 
6.7%
길 14
 
5.9%
7 14
 
5.9%
3 11
 
4.6%
1 10
 
4.2%
번 10
 
4.2%
대 9
 
3.8%
Other values (24) 86
36.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 115
48.3%
Decimal Number 92
38.7%
Space Separator 29
 
12.2%
Dash Punctuation 2
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 23
20.0%
길 14
12.2%
번 10
8.7%
대 9
 
7.8%
암 8
 
7.0%
송 8
 
7.0%
문 7
 
6.1%
서 7
 
6.1%
남 5
 
4.3%
덕 5
 
4.3%
Other values (12) 19
16.5%
Decimal Number
ValueCountFrequency (%)
2 16
17.4%
4 16
17.4%
7 14
15.2%
3 11
12.0%
1 10
10.9%
8 8
8.7%
0 6
 
6.5%
6 4
 
4.3%
5 4
 
4.3%
9 3
 
3.3%
Space Separator
ValueCountFrequency (%)
29
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 123
51.7%
Hangul 115
48.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 23
20.0%
길 14
12.2%
번 10
8.7%
대 9
 
7.8%
암 8
 
7.0%
송 8
 
7.0%
문 7
 
6.1%
서 7
 
6.1%
남 5
 
4.3%
덕 5
 
4.3%
Other values (12) 19
16.5%
Common
ValueCountFrequency (%)
29
23.6%
2 16
13.0%
4 16
13.0%
7 14
11.4%
3 11
 
8.9%
1 10
 
8.1%
8 8
 
6.5%
0 6
 
4.9%
6 4
 
3.3%
5 4
 
3.3%
Other values (2) 5
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 123
51.7%
Hangul 115
48.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
29
23.6%
2 16
13.0%
4 16
13.0%
7 14
11.4%
3 11
 
8.9%
1 10
 
8.1%
8 8
 
6.5%
0 6
 
4.9%
6 4
 
3.3%
5 4
 
3.3%
Other values (2) 5
 
4.1%
Hangul
ValueCountFrequency (%)
로 23
20.0%
길 14
12.2%
번 10
8.7%
대 9
 
7.8%
암 8
 
7.0%
송 8
 
7.0%
문 7
 
6.1%
서 7
 
6.1%
남 5
 
4.3%
덕 5
 
4.3%
Other values (12) 19
16.5%

Interactions

2023-12-12T19:48:48.196297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:48:51.280958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번가스시설구분업체명주소
연번1.0000.8920.7670.956
가스시설구분0.8921.0000.0000.000
업체명0.7670.0001.0000.990
주소0.9560.0000.9901.000
2023-12-12T19:48:51.398743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번가스시설구분
연번1.0000.740
가스시설구분0.7401.000

Missing values

2023-12-12T19:48:48.341770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:48:48.476735image/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

연번가스시설구분업체명주소
01LPG판매사업대창가스서문대로479번길 12
12LPG판매사업아주산소㈜송암로58번길 46
23LPG판매사업(유)동양가스서문대로 487
34LPG판매사업(유)대중문화가스효덕로 103
45LPG충전사업(주)도시산업송암로24번나길 14-22
56LPG충전사업㈜반디지에스송암로 28
67LPG충전사업대광충전소송암로24번나길 14-20
78LPG충전사업광주LPG충전소송암로 106
89LPG충전사업송암에너지㈜송암로24번나길 43
910LPG충전사업효천LPG충전소서문대로 297 외3
연번가스시설구분업체명주소
1718고압가스저장소덕남정수장덕남1길 27
1819고압가스저장소빛고을시민문화관(광주문화재단)천변좌로338번길 7
1920고압가스저장소빛고을전남대학교병원(63)덕남길 80
2021고압가스저장소빛고을전남대학교병원(64)덕남길 80
2122고압가스냉동제조광주기독병원양림로 37
2223고압가스냉동제조기독병원(기숙사)양림로 37
2324고압가스냉동제조(주)콜드앤클린테크서문대로 424
2425고압가스냉동제조미래아동병원대남대로 131
2526고압가스냉동제조(재)빛고을노인복지재단덕남길 7
2627고압가스냉동제조호남신학대학교제중로 77