Overview

Dataset statistics

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

Variable types

Text3
Categorical1
DateTime1

Dataset

Description경기도_고양시_개인하수처리시설현황(업체명, 업종, 등록일, 주소, 전화번호 등)에 대한 데이터로 개인하수처리시설관련 업체면, 등록일, 주소, 전화번호 등을 알수 있습니다
Author경기도 고양시
URLhttps://www.data.go.kr/data/15106588/fileData.do

Reproduction

Analysis started2024-04-29 23:01:48.319603
Analysis finished2024-04-29 23:01:50.557006
Duration2.24 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

Distinct25
Distinct (%)78.1%
Missing0
Missing (%)0.0%
Memory size388.0 B
2024-04-30T08:01:50.683730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length6.40625
Min length4

Characters and Unicode

Total characters205
Distinct characters66
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique19 ?
Unique (%)59.4%

Sample

1st row(주)문화환경건설연구소
2nd row신원환경
3rd row세원환경
4th row벽산개발
5th row(합)일산위생공사
ValueCountFrequency (%)
우주환경㈜ 3
 
9.4%
강인건설환경㈜ 2
 
6.2%
주)신우환경 2
 
6.2%
하이테크환경㈜ 2
 
6.2%
㈜문화환경건설연구소 2
 
6.2%
㈜물사랑이엔지 2
 
6.2%
㈜세화엔스텍 1
 
3.1%
㈜동인엔지니어링 1
 
3.1%
㈜뉴엔텍 1
 
3.1%
우리종합환경(협 1
 
3.1%
Other values (15) 15
46.9%
2024-04-30T08:01:51.025551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
환 23
 
11.2%
경 23
 
11.2%
㈜ 20
 
9.8%
우 7
 
3.4%
엔 7
 
3.4%
( 6
 
2.9%
) 6
 
2.9%
주 6
 
2.9%
화 5
 
2.4%
건 5
 
2.4%
Other values (56) 97
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 173
84.4%
Other Symbol 20
 
9.8%
Open Punctuation 6
 
2.9%
Close Punctuation 6
 
2.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
환 23
 
13.3%
경 23
 
13.3%
우 7
 
4.0%
엔 7
 
4.0%
주 6
 
3.5%
화 5
 
2.9%
건 5
 
2.9%
설 5
 
2.9%
이 5
 
2.9%
신 4
 
2.3%
Other values (53) 83
48.0%
Other Symbol
ValueCountFrequency (%)
㈜ 20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 193
94.1%
Common 12
 
5.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
환 23
 
11.9%
경 23
 
11.9%
㈜ 20
 
10.4%
우 7
 
3.6%
엔 7
 
3.6%
주 6
 
3.1%
화 5
 
2.6%
건 5
 
2.6%
설 5
 
2.6%
이 5
 
2.6%
Other values (54) 87
45.1%
Common
ValueCountFrequency (%)
( 6
50.0%
) 6
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 173
84.4%
None 20
 
9.8%
ASCII 12
 
5.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
환 23
 
13.3%
경 23
 
13.3%
우 7
 
4.0%
엔 7
 
4.0%
주 6
 
3.5%
화 5
 
2.9%
건 5
 
2.9%
설 5
 
2.9%
이 5
 
2.9%
신 4
 
2.3%
Other values (53) 83
48.0%
None
ValueCountFrequency (%)
㈜ 20
100.0%
ASCII
ValueCountFrequency (%)
( 6
50.0%
) 6
50.0%

업종
Categorical

Distinct3
Distinct (%)9.4%
Missing0
Missing (%)0.0%
Memory size388.0 B
분뇨수집 운반
12 
설계시공업
10 
관리업
10 

Length

Max length7
Median length5
Mean length5.125
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row분뇨수집 운반
2nd row분뇨수집 운반
3rd row분뇨수집 운반
4th row분뇨수집 운반
5th row분뇨수집 운반

Common Values

ValueCountFrequency (%)
분뇨수집 운반 12
37.5%
설계시공업 10
31.2%
관리업 10
31.2%

Length

2024-04-30T08:01:51.188179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:01:51.308007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
분뇨수집 12
27.3%
운반 12
27.3%
설계시공업 10
22.7%
관리업 10
22.7%

등록일
Date

Distinct28
Distinct (%)87.5%
Missing0
Missing (%)0.0%
Memory size388.0 B
Minimum1993-01-14 00:00:00
Maximum2022-05-13 00:00:00
2024-04-30T08:01:51.426676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T08:01:51.571914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

주소
Text

Distinct24
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Memory size388.0 B
2024-04-30T08:01:51.814486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length44
Mean length30.9375
Min length25

Characters and Unicode

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

Unique

Unique18 ?
Unique (%)56.2%

Sample

1st row경기도 고양시 덕양구 원당로33번길 57(주교동)
2nd row경기도 고양시 일산동구 성석로 240-18(성석동)
3rd row경기도 고양시 일산서구 송포로 207, 701동 1103호(가좌동)
4th row경기도 고양시 일산동구 공릉천로257번길 14(사리현동)
5th row경기도 고양시 덕양구 토당로168번길 7-27(토당동)
ValueCountFrequency (%)
경기도 32
17.9%
고양시 32
17.9%
덕양구 18
 
10.1%
일산동구 11
 
6.1%
고양시청로 5
 
2.8%
원당로33번길 3
 
1.7%
57(주교동 3
 
1.7%
13-2(주교동 3
 
1.7%
26(주교동 2
 
1.1%
14(사리현동 2
 
1.1%
Other values (59) 68
38.0%
2024-04-30T08:01:52.175870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
147
 
14.8%
양 56
 
5.7%
동 53
 
5.4%
시 39
 
3.9%
고 38
 
3.8%
경 33
 
3.3%
( 32
 
3.2%
도 32
 
3.2%
구 32
 
3.2%
기 32
 
3.2%
Other values (95) 496
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 586
59.2%
Decimal Number 159
 
16.1%
Space Separator 147
 
14.8%
Open Punctuation 32
 
3.2%
Close Punctuation 32
 
3.2%
Other Punctuation 17
 
1.7%
Dash Punctuation 11
 
1.1%
Uppercase Letter 4
 
0.4%
Lowercase Letter 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 56
 
9.6%
동 53
 
9.0%
시 39
 
6.7%
고 38
 
6.5%
경 33
 
5.6%
도 32
 
5.5%
구 32
 
5.5%
기 32
 
5.5%
로 29
 
4.9%
산 18
 
3.1%
Other values (74) 224
38.2%
Decimal Number
ValueCountFrequency (%)
2 29
18.2%
1 28
17.6%
3 25
15.7%
0 19
11.9%
4 15
9.4%
5 12
7.5%
6 10
 
6.3%
7 9
 
5.7%
8 7
 
4.4%
9 5
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
D 1
25.0%
M 1
25.0%
C 1
25.0%
A 1
25.0%
Lowercase Letter
ValueCountFrequency (%)
s 1
50.0%
t 1
50.0%
Space Separator
ValueCountFrequency (%)
147
100.0%
Open Punctuation
ValueCountFrequency (%)
( 32
100.0%
Close Punctuation
ValueCountFrequency (%)
) 32
100.0%
Other Punctuation
ValueCountFrequency (%)
, 17
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 586
59.2%
Common 398
40.2%
Latin 6
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 56
 
9.6%
동 53
 
9.0%
시 39
 
6.7%
고 38
 
6.5%
경 33
 
5.6%
도 32
 
5.5%
구 32
 
5.5%
기 32
 
5.5%
로 29
 
4.9%
산 18
 
3.1%
Other values (74) 224
38.2%
Common
ValueCountFrequency (%)
147
36.9%
( 32
 
8.0%
) 32
 
8.0%
2 29
 
7.3%
1 28
 
7.0%
3 25
 
6.3%
0 19
 
4.8%
, 17
 
4.3%
4 15
 
3.8%
5 12
 
3.0%
Other values (5) 42
 
10.6%
Latin
ValueCountFrequency (%)
D 1
16.7%
M 1
16.7%
C 1
16.7%
s 1
16.7%
A 1
16.7%
t 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 586
59.2%
ASCII 404
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
147
36.4%
( 32
 
7.9%
) 32
 
7.9%
2 29
 
7.2%
1 28
 
6.9%
3 25
 
6.2%
0 19
 
4.7%
, 17
 
4.2%
4 15
 
3.7%
5 12
 
3.0%
Other values (11) 48
 
11.9%
Hangul
ValueCountFrequency (%)
양 56
 
9.6%
동 53
 
9.0%
시 39
 
6.7%
고 38
 
6.5%
경 33
 
5.6%
도 32
 
5.5%
구 32
 
5.5%
기 32
 
5.5%
로 29
 
4.9%
산 18
 
3.1%
Other values (74) 224
38.2%

전화번호
Text

Distinct24
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Memory size388.0 B
2024-04-30T08:01:52.388994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.875
Min length11

Characters and Unicode

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

Unique

Unique18 ?
Unique (%)56.2%

Sample

1st row031-967-8800
2nd row031-963-5313
3rd row031-965-0068
4th row031-964-7400
5th row031-975-3030
ValueCountFrequency (%)
031-967-8800 3
 
9.4%
031-969-3322 3
 
9.4%
02-359-6211 2
 
6.2%
031-906-3742 2
 
6.2%
031-922-0681 2
 
6.2%
02-359-1995 2
 
6.2%
031-979-6644 1
 
3.1%
031-969-9527 1
 
3.1%
031-979-5336 1
 
3.1%
031-938-0641 1
 
3.1%
Other values (14) 14
43.8%
2024-04-30T08:01:52.807525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 64
16.8%
0 59
15.5%
3 52
13.7%
9 46
12.1%
1 44
11.6%
6 32
8.4%
2 25
 
6.6%
5 18
 
4.7%
8 16
 
4.2%
7 13
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 316
83.2%
Dash Punctuation 64
 
16.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 59
18.7%
3 52
16.5%
9 46
14.6%
1 44
13.9%
6 32
10.1%
2 25
7.9%
5 18
 
5.7%
8 16
 
5.1%
7 13
 
4.1%
4 11
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 380
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 64
16.8%
0 59
15.5%
3 52
13.7%
9 46
12.1%
1 44
11.6%
6 32
8.4%
2 25
 
6.6%
5 18
 
4.7%
8 16
 
4.2%
7 13
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 380
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 64
16.8%
0 59
15.5%
3 52
13.7%
9 46
12.1%
1 44
11.6%
6 32
8.4%
2 25
 
6.6%
5 18
 
4.7%
8 16
 
4.2%
7 13
 
3.4%

Correlations

2024-04-30T08:01:52.918713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명업종등록일주소전화번호
업체명1.0000.0000.9251.0001.000
업종0.0001.0000.9380.0000.000
등록일0.9250.9381.0000.9110.911
주소1.0000.0000.9111.0001.000
전화번호1.0000.0000.9111.0001.000

Missing values

2024-04-30T08:01:50.398484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-30T08:01:50.517535image/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(주)문화환경건설연구소분뇨수집 운반1993-01-14경기도 고양시 덕양구 원당로33번길 57(주교동)031-967-8800
1신원환경분뇨수집 운반1998-11-04경기도 고양시 일산동구 성석로 240-18(성석동)031-963-5313
2세원환경분뇨수집 운반1998-01-19경기도 고양시 일산서구 송포로 207, 701동 1103호(가좌동)031-965-0068
3벽산개발분뇨수집 운반1998-11-04경기도 고양시 일산동구 공릉천로257번길 14(사리현동)031-964-7400
4(합)일산위생공사분뇨수집 운반1998-11-04경기도 고양시 덕양구 토당로168번길 7-27(토당동)031-975-3030
5광일환경분뇨수집 운반1998-12-15경기도 고양시 덕양구 고양대로1384번길 30, 903동 201호(성사동, 신원당9단지)031-963-6006
6(유)고양환경분뇨수집 운반1999-01-23경기도 고양시 일산동구 사리현로 201(사리현동)031-962-4800
7우주환경㈜분뇨수집 운반1999-02-22경기도 고양시 덕양구 고양시청로 13-2(주교동)031-969-3322
8경화환경㈜분뇨수집 운반1999-03-11경기도 고양시 덕양구 공릉천로257번길 14(사리현동)02-3158-2456
9원당환경㈜분뇨수집 운반1999-03-20경기도 고양시 일산동구 위시티3로 53-10, 302호(식사동)031-965-0015
업체명업종등록일주소전화번호
22㈜문화환경건설연구소관리업2001-04-07경기도 고양시 덕양구 원당로33번길 57(주교동)031-967-8800
23우주환경㈜관리업2002-12-18경기도 고양시 덕양구 고양시청로 13-2(주교동)031-969-3322
24㈜새롬환경기술관리업2003-10-21경기도 고양시 일산동구 일산로 138, 부대동 504호(백석동, 일산테크노타운)031-938-0641
25하이테크환경㈜관리업2004-01-27경기도 고양시 덕양구 서오릉로 532(용두동)02-359-6211
26(주)신우환경관리업2008-09-18경기도 고양시 덕양구 동헌로 321-44(대자동)02-359-1995
27강인건설환경㈜관리업2009-09-22경기도 고양시 덕양구 고양시청로 26(주교동)031-922-0681
28우리종합환경(협)관리업2016-09-29경기도 고양시 일산동구 공릉천로405번길 62-32(지영동)031-979-5336
29㈜뉴엔텍관리업2017-07-06경기도 고양시 덕양구 삼원로 83, 821호(원흥동)031-969-9527
30㈜물사랑이엔지관리업2018-02-08경기도 고양시 일산동구 노첨길 112, 가동(장항동)031-906-3742
31바른관리㈜관리업2022-05-13경기도 고양시 향동로128, 429호(향동동, DMC스타비즈st)02-6929-0654