Overview

Dataset statistics

Number of variables6
Number of observations37
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory52.6 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description대구광역시 서구_가스사업자 현황_20240205
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15093581&dataSetDetailId=150935811c06c0e104bf0&provdMethod=FILE

Alerts

순번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-13 13:38:32.112447
Analysis finished2024-03-13 13:38:32.777029
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19
Minimum1
Maximum37
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2024-03-13T22:38:32.864233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.8
Q110
median19
Q328
95-th percentile35.2
Maximum37
Range36
Interquartile range (IQR)18

Descriptive statistics

Standard deviation10.824355
Coefficient of variation (CV)0.56970291
Kurtosis-1.2
Mean19
Median Absolute Deviation (MAD)9
Skewness0
Sum703
Variance117.16667
MonotonicityStrictly increasing
2024-03-13T22:38:33.346800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
1 1
 
2.7%
29 1
 
2.7%
22 1
 
2.7%
23 1
 
2.7%
24 1
 
2.7%
25 1
 
2.7%
26 1
 
2.7%
27 1
 
2.7%
28 1
 
2.7%
30 1
 
2.7%
Other values (27) 27
73.0%
ValueCountFrequency (%)
1 1
2.7%
2 1
2.7%
3 1
2.7%
4 1
2.7%
5 1
2.7%
6 1
2.7%
7 1
2.7%
8 1
2.7%
9 1
2.7%
10 1
2.7%
ValueCountFrequency (%)
37 1
2.7%
36 1
2.7%
35 1
2.7%
34 1
2.7%
33 1
2.7%
32 1
2.7%
31 1
2.7%
30 1
2.7%
29 1
2.7%
28 1
2.7%

업종
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size428.0 B
가스판매소
29 
가스충전소
8 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가스판매소
2nd row가스판매소
3rd row가스판매소
4th row가스판매소
5th row가스판매소

Common Values

ValueCountFrequency (%)
가스판매소 29
78.4%
가스충전소 8
 
21.6%

Length

2024-03-13T22:38:33.520119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:38:33.621177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가스판매소 29
78.4%
가스충전소 8
 
21.6%

상호
Text

Distinct36
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size428.0 B
2024-03-13T22:38:33.826750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length9
Mean length5.7297297
Min length4

Characters and Unicode

Total characters212
Distinct characters69
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

Unique35 ?
Unique (%)94.6%

Sample

1st row신라가스
2nd row영남종합화학
3rd row오성가스
4th row시민가스상사
5th row새흥구가스
ValueCountFrequency (%)
신진가스텍㈜ 2
 
5.1%
주)극동에어가스 1
 
2.6%
대서종합가스 1
 
2.6%
영남종합화학 1
 
2.6%
원일가스 1
 
2.6%
삼일종합가스 1
 
2.6%
그린가스텍 1
 
2.6%
화성가스 1
 
2.6%
동산종합가스 1
 
2.6%
대기에너지㈜ 1
 
2.6%
Other values (28) 28
71.8%
2024-03-13T22:38:34.414285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 30
 
14.2%
가 29
 
13.7%
대 9
 
4.2%
종 8
 
3.8%
합 8
 
3.8%
성 7
 
3.3%
㈜ 6
 
2.8%
일 5
 
2.4%
신 5
 
2.4%
에 4
 
1.9%
Other values (59) 101
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 191
90.1%
Uppercase Letter 11
 
5.2%
Other Symbol 6
 
2.8%
Space Separator 2
 
0.9%
Open Punctuation 1
 
0.5%
Close Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 30
 
15.7%
가 29
 
15.2%
대 9
 
4.7%
종 8
 
4.2%
합 8
 
4.2%
성 7
 
3.7%
일 5
 
2.6%
신 5
 
2.6%
에 4
 
2.1%
구 4
 
2.1%
Other values (49) 82
42.9%
Uppercase Letter
ValueCountFrequency (%)
G 3
27.3%
C 2
18.2%
L 2
18.2%
P 2
18.2%
I 1
 
9.1%
N 1
 
9.1%
Other Symbol
ValueCountFrequency (%)
㈜ 6
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 197
92.9%
Latin 11
 
5.2%
Common 4
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 30
 
15.2%
가 29
 
14.7%
대 9
 
4.6%
종 8
 
4.1%
합 8
 
4.1%
성 7
 
3.6%
㈜ 6
 
3.0%
일 5
 
2.5%
신 5
 
2.5%
에 4
 
2.0%
Other values (50) 86
43.7%
Latin
ValueCountFrequency (%)
G 3
27.3%
C 2
18.2%
L 2
18.2%
P 2
18.2%
I 1
 
9.1%
N 1
 
9.1%
Common
ValueCountFrequency (%)
2
50.0%
( 1
25.0%
) 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 191
90.1%
ASCII 15
 
7.1%
None 6
 
2.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 30
 
15.7%
가 29
 
15.2%
대 9
 
4.7%
종 8
 
4.2%
합 8
 
4.2%
성 7
 
3.7%
일 5
 
2.6%
신 5
 
2.6%
에 4
 
2.1%
구 4
 
2.1%
Other values (49) 82
42.9%
None
ValueCountFrequency (%)
㈜ 6
100.0%
ASCII
ValueCountFrequency (%)
G 3
20.0%
2
13.3%
C 2
13.3%
L 2
13.3%
P 2
13.3%
( 1
 
6.7%
I 1
 
6.7%
) 1
 
6.7%
N 1
 
6.7%

소재지
Text

Distinct35
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size428.0 B
2024-03-13T22:38:34.738239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length14.324324
Min length12

Characters and Unicode

Total characters530
Distinct characters55
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

Unique33 ?
Unique (%)89.2%

Sample

1st row달구벌대로363길 7-1(내당동)
2nd row큰장로 51-1(내당동)
3rd row평리로 286(내당동)
4th row당산로41동길 37(내당동)
5th row통학로 244(비산동)
ValueCountFrequency (%)
와룡로 4
 
5.3%
국채보상로 4
 
5.3%
와룡로70길 2
 
2.7%
430(이현동 2
 
2.7%
평리로 2
 
2.7%
8(중리동 2
 
2.7%
와룡로100길 2
 
2.7%
통학로 2
 
2.7%
121(평리동 1
 
1.3%
346(중리동 1
 
1.3%
Other values (53) 53
70.7%
2024-03-13T22:38:35.258453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
39
 
7.4%
동 38
 
7.2%
( 37
 
7.0%
로 37
 
7.0%
) 37
 
7.0%
1 31
 
5.8%
길 20
 
3.8%
리 18
 
3.4%
6 15
 
2.8%
2 14
 
2.6%
Other values (45) 244
46.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 277
52.3%
Decimal Number 132
24.9%
Space Separator 39
 
7.4%
Open Punctuation 37
 
7.0%
Close Punctuation 37
 
7.0%
Dash Punctuation 8
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 38
 
13.7%
로 37
 
13.4%
길 20
 
7.2%
리 18
 
6.5%
산 12
 
4.3%
상 9
 
3.2%
와 9
 
3.2%
평 9
 
3.2%
이 9
 
3.2%
룡 9
 
3.2%
Other values (31) 107
38.6%
Decimal Number
ValueCountFrequency (%)
1 31
23.5%
6 15
11.4%
2 14
10.6%
3 14
10.6%
4 13
9.8%
7 12
 
9.1%
5 11
 
8.3%
0 11
 
8.3%
8 9
 
6.8%
9 2
 
1.5%
Space Separator
ValueCountFrequency (%)
39
100.0%
Open Punctuation
ValueCountFrequency (%)
( 37
100.0%
Close Punctuation
ValueCountFrequency (%)
) 37
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 277
52.3%
Common 253
47.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 38
 
13.7%
로 37
 
13.4%
길 20
 
7.2%
리 18
 
6.5%
산 12
 
4.3%
상 9
 
3.2%
와 9
 
3.2%
평 9
 
3.2%
이 9
 
3.2%
룡 9
 
3.2%
Other values (31) 107
38.6%
Common
ValueCountFrequency (%)
39
15.4%
( 37
14.6%
) 37
14.6%
1 31
12.3%
6 15
 
5.9%
2 14
 
5.5%
3 14
 
5.5%
4 13
 
5.1%
7 12
 
4.7%
5 11
 
4.3%
Other values (4) 30
11.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 277
52.3%
ASCII 253
47.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
39
15.4%
( 37
14.6%
) 37
14.6%
1 31
12.3%
6 15
 
5.9%
2 14
 
5.5%
3 14
 
5.5%
4 13
 
5.1%
7 12
 
4.7%
5 11
 
4.3%
Other values (4) 30
11.9%
Hangul
ValueCountFrequency (%)
동 38
 
13.7%
로 37
 
13.4%
길 20
 
7.2%
리 18
 
6.5%
산 12
 
4.3%
상 9
 
3.2%
와 9
 
3.2%
평 9
 
3.2%
이 9
 
3.2%
룡 9
 
3.2%
Other values (31) 107
38.6%

전화번호
Text

Distinct36
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size428.0 B
2024-03-13T22:38:35.506502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length12
Mean length12.702703
Min length12

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)94.6%

Sample

1st row053-553-3399
2nd row053-571-5556
3rd row053-552-1160
4th row053-565-1986
5th row053-558-3338
ValueCountFrequency (%)
053-567-0034 2
 
5.4%
053-553-3399 1
 
2.7%
053-557-0031 1
 
2.7%
053-571-5556 1
 
2.7%
053-555-1600+053-565-6800 1
 
2.7%
053-553-3131 1
 
2.7%
053-555-6939 1
 
2.7%
053-552-0066 1
 
2.7%
053-554-0123 1
 
2.7%
053-557-1771 1
 
2.7%
Other values (26) 26
70.3%
2024-03-13T22:38:35.936870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 114
24.3%
- 78
16.6%
0 70
14.9%
3 64
13.6%
1 35
 
7.4%
6 30
 
6.4%
7 19
 
4.0%
2 19
 
4.0%
8 16
 
3.4%
9 12
 
2.6%
Other values (2) 13
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 390
83.0%
Dash Punctuation 78
 
16.6%
Math Symbol 2
 
0.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 114
29.2%
0 70
17.9%
3 64
16.4%
1 35
 
9.0%
6 30
 
7.7%
7 19
 
4.9%
2 19
 
4.9%
8 16
 
4.1%
9 12
 
3.1%
4 11
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 78
100.0%
Math Symbol
ValueCountFrequency (%)
+ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 470
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 114
24.3%
- 78
16.6%
0 70
14.9%
3 64
13.6%
1 35
 
7.4%
6 30
 
6.4%
7 19
 
4.0%
2 19
 
4.0%
8 16
 
3.4%
9 12
 
2.6%
Other values (2) 13
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 470
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 114
24.3%
- 78
16.6%
0 70
14.9%
3 64
13.6%
1 35
 
7.4%
6 30
 
6.4%
7 19
 
4.0%
2 19
 
4.0%
8 16
 
3.4%
9 12
 
2.6%
Other values (2) 13
 
2.8%

가스종류
Categorical

Distinct5
Distinct (%)13.5%
Missing0
Missing (%)0.0%
Memory size428.0 B
LPG
22 
고압, LPG
12 
고압
 
1
CNG
 
1
고압
 
1

Length

Max length7
Median length3
Mean length4.2702703
Min length2

Unique

Unique3 ?
Unique (%)8.1%

Sample

1st rowLPG
2nd row고압, LPG
3rd rowLPG
4th rowLPG
5th rowLPG

Common Values

ValueCountFrequency (%)
LPG 22
59.5%
고압, LPG 12
32.4%
고압 1
 
2.7%
CNG 1
 
2.7%
고압 1
 
2.7%

Length

2024-03-13T22:38:36.120551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:38:36.271793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
lpg 34
69.4%
고압 14
28.6%
cng 1
 
2.0%

Interactions

2024-03-13T22:38:32.459092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:38:36.367581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업종상호소재지전화번호가스종류
순번1.0001.0000.9390.8600.9390.444
업종1.0001.0000.0000.1520.0000.312
상호0.9390.0001.0001.0001.0000.000
소재지0.8600.1521.0001.0001.0000.000
전화번호0.9390.0001.0001.0001.0000.000
가스종류0.4440.3120.0000.0000.0001.000
2024-03-13T22:38:36.490507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가스종류업종
가스종류1.0000.361
업종0.3611.000
2024-03-13T22:38:36.642828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번업종가스종류
순번1.0000.8780.216
업종0.8781.0000.361
가스종류0.2160.3611.000

Missing values

2024-03-13T22:38:32.605918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:38:32.731173image/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가스판매소신라가스달구벌대로363길 7-1(내당동)053-553-3399LPG
12가스판매소영남종합화학큰장로 51-1(내당동)053-571-5556고압, LPG
23가스판매소오성가스평리로 286(내당동)053-552-1160LPG
34가스판매소시민가스상사당산로41동길 37(내당동)053-565-1986LPG
45가스판매소새흥구가스통학로 244(비산동)053-558-3338LPG
56가스판매소대영가스평리로 432(내당동)053-556-6700LPG
67가스판매소경일가스달서천로61안길 33-1(비산동)053-324-5544LPG
78가스판매소아진가스서대구로62길 77(비산동)053-354-1354LPG
89가스판매소육일가스국채보상로69길 14-1(비산동)053-571-6161LPG
910가스판매소보성종합가스문화로66길 2(비산동)053-557-7711+053-558-1131고압, LPG
순번업종상호소재지전화번호가스종류
2728가스판매소(주)극동에어가스국채보상로 38-11(중리동)053-557-1771고압, LPG
2829가스판매소경동가스텍와룡로100길 58(이현동)053-588-2750고압, LPG
2930가스충전소화성가스㈜와룡로 346(중리동)053-565-0221LPG
3031가스충전소경북산소㈜와룡로 100길 54(이현동)053-562-1614고압, LPG
3132가스충전소신대한LPG서대구로 121(평리동)053-566-2609LPG
3233가스충전소청구LPG충전소국채보상로 92(중리동)053-552-1123LPG
3334가스충전소서대구IC충전소북비산로 48(이현동)053-566-0009LPG
3435가스충전소대기에너지㈜국채보상로 25(이현동)053-552-3000LPG
3536가스충전소대성에너지㈜ 상리CNG충전소가르뱅이로10길 31(상리동)053-606-1123CNG
3637가스충전소신진가스텍㈜와룡로 430(이현동)053-567-0034고압