Overview

Dataset statistics

Number of variables6
Number of observations34
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory51.9 B

Variable types

Text1
Categorical3
DateTime2

Dataset

Description제주특별자치도 서귀포시 관내 도시가스공사계획 현황에 관한 데이터로 공사명, 상호, 전화번호, 공사기간 등 정보를 제공합니다.
Author제주특별자치도 서귀포시
URLhttps://www.data.go.kr/data/15053150/fileData.do

Alerts

상호 has constant value ""Constant
전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant

Reproduction

Analysis started2023-12-12 18:03:36.965486
Analysis finished2023-12-12 18:03:37.280551
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공사명
Text

Distinct32
Distinct (%)94.1%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-13T03:03:37.430981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length29
Mean length25.294118
Min length10

Characters and Unicode

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

Unique

Unique30 ?
Unique (%)88.2%

Sample

1st row서귀포시 제2강정교 매달기 구간 도시가스 본관 매설공사
2nd row서귀포시 혁신도시~구시가지 구간 도시가스 본관 매설공사
3rd row하원정압기 설치공사
4th row하원로29 하원마을복지회관 구간 도시가스 공급관 매설 공사
5th row민군복합관광미항 진입로 2구간 도시가스 배관공사
ValueCountFrequency (%)
도시가스 28
15.9%
매설공사 14
 
8.0%
구간 13
 
7.4%
배관공사 12
 
6.8%
서귀포시 12
 
6.8%
본관 11
 
6.2%
민군복합관광미항 5
 
2.8%
공급관 5
 
2.8%
설치공사 5
 
2.8%
강정동 4
 
2.3%
Other values (51) 67
38.1%
2023-12-13T03:03:37.806115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
143
 
16.6%
시 46
 
5.3%
공 40
 
4.7%
관 39
 
4.5%
도 34
 
4.0%
사 34
 
4.0%
가 31
 
3.6%
스 30
 
3.5%
구 24
 
2.8%
설 21
 
2.4%
Other values (88) 418
48.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 657
76.4%
Space Separator 143
 
16.6%
Decimal Number 29
 
3.4%
Uppercase Letter 12
 
1.4%
Math Symbol 5
 
0.6%
Open Punctuation 4
 
0.5%
Close Punctuation 4
 
0.5%
Other Punctuation 4
 
0.5%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 46
 
7.0%
공 40
 
6.1%
관 39
 
5.9%
도 34
 
5.2%
사 34
 
5.2%
가 31
 
4.7%
스 30
 
4.6%
구 24
 
3.7%
설 21
 
3.2%
간 20
 
3.0%
Other values (66) 338
51.4%
Decimal Number
ValueCountFrequency (%)
1 8
27.6%
2 6
20.7%
3 3
 
10.3%
5 3
 
10.3%
6 3
 
10.3%
0 2
 
6.9%
4 2
 
6.9%
9 1
 
3.4%
7 1
 
3.4%
Uppercase Letter
ValueCountFrequency (%)
L 3
25.0%
G 3
25.0%
N 3
25.0%
A 1
 
8.3%
B 1
 
8.3%
C 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
, 3
75.0%
· 1
 
25.0%
Space Separator
ValueCountFrequency (%)
143
100.0%
Math Symbol
ValueCountFrequency (%)
~ 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 657
76.4%
Common 191
 
22.2%
Latin 12
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 46
 
7.0%
공 40
 
6.1%
관 39
 
5.9%
도 34
 
5.2%
사 34
 
5.2%
가 31
 
4.7%
스 30
 
4.6%
구 24
 
3.7%
설 21
 
3.2%
간 20
 
3.0%
Other values (66) 338
51.4%
Common
ValueCountFrequency (%)
143
74.9%
1 8
 
4.2%
2 6
 
3.1%
~ 5
 
2.6%
( 4
 
2.1%
) 4
 
2.1%
, 3
 
1.6%
3 3
 
1.6%
5 3
 
1.6%
6 3
 
1.6%
Other values (6) 9
 
4.7%
Latin
ValueCountFrequency (%)
L 3
25.0%
G 3
25.0%
N 3
25.0%
A 1
 
8.3%
B 1
 
8.3%
C 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 657
76.4%
ASCII 202
 
23.5%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
143
70.8%
1 8
 
4.0%
2 6
 
3.0%
~ 5
 
2.5%
( 4
 
2.0%
) 4
 
2.0%
, 3
 
1.5%
3 3
 
1.5%
5 3
 
1.5%
L 3
 
1.5%
Other values (11) 20
 
9.9%
Hangul
ValueCountFrequency (%)
시 46
 
7.0%
공 40
 
6.1%
관 39
 
5.9%
도 34
 
5.2%
사 34
 
5.2%
가 31
 
4.7%
스 30
 
4.6%
구 24
 
3.7%
설 21
 
3.2%
간 20
 
3.0%
Other values (66) 338
51.4%
None
ValueCountFrequency (%)
· 1
100.0%

상호
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size404.0 B
(주)제주도시가스
34 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row(주)제주도시가스
2nd row(주)제주도시가스
3rd row(주)제주도시가스
4th row(주)제주도시가스
5th row(주)제주도시가스

Common Values

ValueCountFrequency (%)
(주)제주도시가스 34
100.0%

Length

2023-12-13T03:03:37.942013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:03:38.036198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주)제주도시가스 34
100.0%

전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size404.0 B
1600-3437
34 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1600-3437
2nd row1600-3437
3rd row1600-3437
4th row1600-3437
5th row1600-3437

Common Values

ValueCountFrequency (%)
1600-3437 34
100.0%

Length

2023-12-13T03:03:38.129867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:03:38.223253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1600-3437 34
100.0%

공사기간시작
Date

Distinct27
Distinct (%)79.4%
Missing0
Missing (%)0.0%
Memory size404.0 B
Minimum2009-04-01 00:00:00
Maximum2023-06-23 00:00:00
2023-12-13T03:03:38.316383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:03:38.441179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)

공사기간끝
Date

Distinct21
Distinct (%)61.8%
Missing0
Missing (%)0.0%
Memory size404.0 B
Minimum2010-10-09 00:00:00
Maximum2023-12-31 00:00:00
2023-12-13T03:03:38.579124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:03:38.683788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-09-01
34 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-01
2nd row2023-09-01
3rd row2023-09-01
4th row2023-09-01
5th row2023-09-01

Common Values

ValueCountFrequency (%)
2023-09-01 34
100.0%

Length

2023-12-13T03:03:38.794701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:03:38.879088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-01 34
100.0%

Correlations

2023-12-13T03:03:38.931051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공사명공사기간시작공사기간끝
공사명1.0000.9831.000
공사기간시작0.9831.0001.000
공사기간끝1.0001.0001.000

Missing values

2023-12-13T03:03:37.147146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:03:37.242000image/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

공사명상호전화번호공사기간시작공사기간끝데이터기준일자
0서귀포시 제2강정교 매달기 구간 도시가스 본관 매설공사(주)제주도시가스1600-34372023-06-232023-12-312023-09-01
1서귀포시 혁신도시~구시가지 구간 도시가스 본관 매설공사(주)제주도시가스1600-34372022-09-272023-08-202023-09-01
2하원정압기 설치공사(주)제주도시가스1600-34372022-05-112022-11-102023-09-01
3하원로29 하원마을복지회관 구간 도시가스 공급관 매설 공사(주)제주도시가스1600-34372022-04-252022-10-102023-09-01
4민군복합관광미항 진입로 2구간 도시가스 배관공사(주)제주도시가스1600-34372020-12-082023-12-312023-09-01
5서호동1604번지 구간 도시가스 공급관 매설공사(주)제주도시가스1600-34372021-12-102022-05-102023-09-01
6민군복합관광미항 진입로1구간 도시가스 배관공사(주)제주도시가스1600-34372020-11-012021-04-302023-09-01
7서귀포시 LNG 연결 매달기구간 도시가스 배관공사(주)제주도시가스1600-34372020-08-102021-03-102023-09-01
8서귀포시 LNG 연결 2구간 도시가스 배관공사(주)제주도시가스1600-34372020-08-102021-03-102023-09-01
9서귀포시 LNG 연결 1구간 도시가스 배관공사(주)제주도시가스1600-34372020-08-102021-03-102023-09-01
공사명상호전화번호공사기간시작공사기간끝데이터기준일자
24서귀포시 제조소내 구간 도시가스 본관 매설공사(주)제주도시가스1600-34372015-01-012015-04-302023-09-01
25강정동 3305번지~용흥교 구간 도시가스 본관 매설공사(주)제주도시가스1600-34372015-01-012015-04-302023-09-01
26제주도시가스 서귀포 제조소 건설공사(주)제주도시가스1600-34372014-11-012015-06-302023-09-01
27서귀포 강정지구~용흥교 도시가스 본관 매설공사(주)제주도시가스1600-34372013-01-012013-12-312023-09-01
28예래동 진입로(2) 도시가스 본관 매설공사(주)제주도시가스1600-34372009-10-102010-10-092023-09-01
29예래동 진입로(1) 도시가스 본관 매설공사(주)제주도시가스1600-34372010-01-202010-10-312023-09-01
30예래휴양단지내 예래1,2교 도시가스 본관 매설공사(주)제주도시가스1600-34372011-10-012011-11-302023-09-01
31예래휴양단지 A,B,C 구간 도시가스 본관 매설공사(주)제주도시가스1600-34372011-05-202011-11-302023-09-01
32서귀포혁신도시내 도시가스 본관 공급관 매설공사(주)제주도시가스1600-34372009-04-012012-12-312023-09-01
33서귀포 강정지구 도시가스 본관 공급관 매설공사(주)제주도시가스1600-34372012-07-162013-12-312023-09-01