Overview

Dataset statistics

Number of variables6
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory54.5 B

Variable types

Numeric1
Text2
Categorical2
DateTime1

Dataset

Description안성시 저수조 청소업체 현황입니다.
Author경기도 안성시
URLhttps://www.data.go.kr/data/15079877/fileData.do

Alerts

관리기관 전화번호 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
번호 has unique valuesUnique
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:21:20.433878
Analysis finished2023-12-12 05:21:20.868418
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.5
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T14:21:20.933246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.15
Q16.75
median12.5
Q318.25
95-th percentile22.85
Maximum24
Range23
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation7.0710678
Coefficient of variation (CV)0.56568542
Kurtosis-1.2
Mean12.5
Median Absolute Deviation (MAD)6
Skewness0
Sum300
Variance50
MonotonicityStrictly increasing
2023-12-12T14:21:21.110627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1 1
 
4.2%
14 1
 
4.2%
24 1
 
4.2%
23 1
 
4.2%
22 1
 
4.2%
21 1
 
4.2%
20 1
 
4.2%
19 1
 
4.2%
18 1
 
4.2%
17 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
1 1
4.2%
2 1
4.2%
3 1
4.2%
4 1
4.2%
5 1
4.2%
6 1
4.2%
7 1
4.2%
8 1
4.2%
9 1
4.2%
10 1
4.2%
ValueCountFrequency (%)
24 1
4.2%
23 1
4.2%
22 1
4.2%
21 1
4.2%
20 1
4.2%
19 1
4.2%
18 1
4.2%
17 1
4.2%
16 1
4.2%
15 1
4.2%

업소명
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-12T14:21:21.299628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length7.4166667
Min length3

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)100.0%

Sample

1st row(주)금강건설
2nd row(주)늘푸른코리아
3rd row(주)동명산업
4th row(주)안성지하수
5th row(주)지하수닥터
ValueCountFrequency (%)
주식회사 2
 
7.7%
주)금강건설 1
 
3.8%
광일개발(주 1
 
3.8%
한백건설(주 1
 
3.8%
태정건설(주 1
 
3.8%
천년지하수(주 1
 
3.8%
지니건설(주 1
 
3.8%
에코원 1
 
3.8%
이레씨엔씨(주 1
 
3.8%
시온펌프시스템 1
 
3.8%
Other values (15) 15
57.7%
2023-12-12T14:21:21.691185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 21
 
11.8%
) 19
 
10.7%
( 19
 
10.7%
설 11
 
6.2%
건 10
 
5.6%
지 5
 
2.8%
이 3
 
1.7%
수 3
 
1.7%
하 3
 
1.7%
온 2
 
1.1%
Other values (67) 82
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 137
77.0%
Close Punctuation 19
 
10.7%
Open Punctuation 19
 
10.7%
Space Separator 2
 
1.1%
Other Punctuation 1
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 21
 
15.3%
설 11
 
8.0%
건 10
 
7.3%
지 5
 
3.6%
이 3
 
2.2%
수 3
 
2.2%
하 3
 
2.2%
온 2
 
1.5%
성 2
 
1.5%
경 2
 
1.5%
Other values (63) 75
54.7%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 137
77.0%
Common 41
 
23.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 21
 
15.3%
설 11
 
8.0%
건 10
 
7.3%
지 5
 
3.6%
이 3
 
2.2%
수 3
 
2.2%
하 3
 
2.2%
온 2
 
1.5%
성 2
 
1.5%
경 2
 
1.5%
Other values (63) 75
54.7%
Common
ValueCountFrequency (%)
) 19
46.3%
( 19
46.3%
2
 
4.9%
/ 1
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 137
77.0%
ASCII 41
 
23.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 21
 
15.3%
설 11
 
8.0%
건 10
 
7.3%
지 5
 
3.6%
이 3
 
2.2%
수 3
 
2.2%
하 3
 
2.2%
온 2
 
1.5%
성 2
 
1.5%
경 2
 
1.5%
Other values (63) 75
54.7%
ASCII
ValueCountFrequency (%)
) 19
46.3%
( 19
46.3%
2
 
4.9%
/ 1
 
2.4%

소재지
Text

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-12T14:21:21.984387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length24
Mean length22
Min length17

Characters and Unicode

Total characters528
Distinct characters75
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

Unique22 ?
Unique (%)91.7%

Sample

1st row경기도 안성시 비봉로 11 (가사동)
2nd row경기도 안성시 보개원삼로 55 (가사동)
3rd row경기도 안성시 대덕면 서동대로 4789-41
4th row경기도 안성시 장기2길 4 (신흥동)
5th row경기도 안성시 비봉로 11 (가사동)
ValueCountFrequency (%)
경기도 24
19.2%
안성시 24
19.2%
가사동 4
 
3.2%
대덕면 4
 
3.2%
2층 2
 
1.6%
봉산동 2
 
1.6%
안성맞춤대로 2
 
1.6%
3층 2
 
1.6%
계동 2
 
1.6%
양성면 2
 
1.6%
Other values (53) 57
45.6%
2023-12-12T14:21:22.505792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
107
20.3%
성 28
 
5.3%
기 27
 
5.1%
도 27
 
5.1%
안 26
 
4.9%
시 25
 
4.7%
경 24
 
4.5%
동 19
 
3.6%
1 16
 
3.0%
( 13
 
2.5%
Other values (65) 216
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 305
57.8%
Space Separator 107
 
20.3%
Decimal Number 75
 
14.2%
Open Punctuation 13
 
2.5%
Close Punctuation 13
 
2.5%
Dash Punctuation 9
 
1.7%
Other Punctuation 6
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 28
 
9.2%
기 27
 
8.9%
도 27
 
8.9%
안 26
 
8.5%
시 25
 
8.2%
경 24
 
7.9%
동 19
 
6.2%
로 11
 
3.6%
길 9
 
3.0%
면 8
 
2.6%
Other values (50) 101
33.1%
Decimal Number
ValueCountFrequency (%)
1 16
21.3%
2 12
16.0%
4 12
16.0%
9 9
12.0%
6 7
9.3%
5 4
 
5.3%
7 4
 
5.3%
8 4
 
5.3%
3 4
 
5.3%
0 3
 
4.0%
Space Separator
ValueCountFrequency (%)
107
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 305
57.8%
Common 223
42.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 28
 
9.2%
기 27
 
8.9%
도 27
 
8.9%
안 26
 
8.5%
시 25
 
8.2%
경 24
 
7.9%
동 19
 
6.2%
로 11
 
3.6%
길 9
 
3.0%
면 8
 
2.6%
Other values (50) 101
33.1%
Common
ValueCountFrequency (%)
107
48.0%
1 16
 
7.2%
( 13
 
5.8%
) 13
 
5.8%
2 12
 
5.4%
4 12
 
5.4%
- 9
 
4.0%
9 9
 
4.0%
6 7
 
3.1%
, 6
 
2.7%
Other values (5) 19
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 305
57.8%
ASCII 223
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
107
48.0%
1 16
 
7.2%
( 13
 
5.8%
) 13
 
5.8%
2 12
 
5.4%
4 12
 
5.4%
- 9
 
4.0%
9 9
 
4.0%
6 7
 
3.1%
, 6
 
2.7%
Other values (5) 19
 
8.5%
Hangul
ValueCountFrequency (%)
성 28
 
9.2%
기 27
 
8.9%
도 27
 
8.9%
안 26
 
8.5%
시 25
 
8.2%
경 24
 
7.9%
동 19
 
6.2%
로 11
 
3.6%
길 9
 
3.0%
면 8
 
2.6%
Other values (50) 101
33.1%

관리기관 전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
031-678-5422
24 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-678-5422
2nd row031-678-5422
3rd row031-678-5422
4th row031-678-5422
5th row031-678-5422

Common Values

ValueCountFrequency (%)
031-678-5422 24
100.0%

Length

2023-12-12T14:21:22.721014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:21:22.854839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-678-5422 24
100.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
안성시청
24 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row안성시청
2nd row안성시청
3rd row안성시청
4th row안성시청
5th row안성시청

Common Values

ValueCountFrequency (%)
안성시청 24
100.0%

Length

2023-12-12T14:21:22.971275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:21:23.091393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
안성시청 24
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum2021-03-15 00:00:00
Maximum2021-03-15 00:00:00
2023-12-12T14:21:23.192133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:21:23.336787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T14:21:20.609320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:21:23.435517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호업소명소재지
번호1.0001.0000.919
업소명1.0001.0001.000
소재지0.9191.0001.000

Missing values

2023-12-12T14:21:20.714037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:21:20.825730image/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(주)금강건설경기도 안성시 비봉로 11 (가사동)031-678-5422안성시청2021-03-15
12(주)늘푸른코리아경기도 안성시 보개원삼로 55 (가사동)031-678-5422안성시청2021-03-15
23(주)동명산업경기도 안성시 대덕면 서동대로 4789-41031-678-5422안성시청2021-03-15
34(주)안성지하수경기도 안성시 장기2길 4 (신흥동)031-678-5422안성시청2021-03-15
45(주)지하수닥터경기도 안성시 비봉로 11 (가사동)031-678-5422안성시청2021-03-15
56(주)창대건설경기도 안성시 아양1로 22-4, 2층 (아양동)031-678-5422안성시청2021-03-15
67(주)청솔환경건설경기도 안성시 대덕면 만세로 460-3031-678-5422안성시청2021-03-15
78(주)청지기경기도 안성시 가사동 79-6031-678-5422안성시청2021-03-15
89(주)케이원건설경기도 안성시 혜산로 10, 1층 1호 (연지동)031-678-5422안성시청2021-03-15
910(주)타이거/극동환경경기도 안성시 공도읍 승두리 62031-678-5422안성시청2021-03-15
번호업소명소재지관리기관 전화번호관리기관명데이터기준일자
1415미랜드경기도 안성시 물방아거리길 12 (인지동)031-678-5422안성시청2021-03-15
1516부성건설 주식회사경기도 안성시 중앙로 472, 2층 (봉산동)031-678-5422안성시청2021-03-15
1617시온펌프시스템경기도 안성시 안성맞춤대로 924-9, 3층 (도기동)031-678-5422안성시청2021-03-15
1718이레씨엔씨(주)경기도 안성시 시청길 9, 3층 (봉산동)031-678-5422안성시청2021-03-15
1819주식회사 에코원경기도 안성시 안성맞춤대로 817 (계동)031-678-5422안성시청2021-03-15
1920지니건설(주)경기도 안성시 양성면 이화길 186031-678-5422안성시청2021-03-15
2021천년지하수(주)경기도 안성시 원곡면 오동길 49031-678-5422안성시청2021-03-15
2122태정건설(주)경기도 안성시 대덕면 당촌1길 54-2031-678-5422안성시청2021-03-15
2223한백건설(주)경기도 안성시 계동1길 16-9 (계동)031-678-5422안성시청2021-03-15
2324황우건설(주)경기도 안성시 보개면 보개원삼로 389031-678-5422안성시청2021-03-15