Overview

Dataset statistics

Number of variables7
Number of observations44
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory59.0 B

Variable types

Text3
Categorical4

Dataset

Description전쟁, 가뭄, 수원지파괴 등 민방위사태 발생으로 상수도 공급중단 시 최소의 음용 및 생활용수를 주민에게 공급하고자 설치된 급수시설
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15037283/fileData.do

Alerts

급수시간(오전) has constant value ""Constant
급수시간(오후) has constant value ""Constant
급수시간(저녁) has constant value ""Constant
데이터기준일자 has constant value ""Constant
시설명 has unique valuesUnique
시설위치(도로명주소) has unique valuesUnique
시설위치(지번주소) has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:57:35.102277
Analysis finished2023-12-12 22:57:35.498179
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시설명
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2023-12-13T07:57:35.637721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length2
Mean length2.5227273
Min length2

Characters and Unicode

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

Unique

Unique44 ?
Unique (%)100.0%

Sample

1st row안복수
2nd row용화
3rd row고래재
4th row연자천
5th row산직골
ValueCountFrequency (%)
안복수 1
 
2.3%
용화 1
 
2.3%
정림 1
 
2.3%
만수 1
 
2.3%
신선암 1
 
2.3%
장갓골 1
 
2.3%
계룡 1
 
2.3%
관저 1
 
2.3%
뒷뜰 1
 
2.3%
버드내중학교 1
 
2.3%
Other values (34) 34
77.3%
2023-12-13T07:57:35.969405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
봉 4
 
3.6%
안 3
 
2.7%
새 3
 
2.7%
은 3
 
2.7%
골 3
 
2.7%
정 3
 
2.7%
수 3
 
2.7%
평 2
 
1.8%
구 2
 
1.8%
청 2
 
1.8%
Other values (74) 83
74.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 110
99.1%
Decimal Number 1
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
봉 4
 
3.6%
안 3
 
2.7%
새 3
 
2.7%
은 3
 
2.7%
골 3
 
2.7%
정 3
 
2.7%
수 3
 
2.7%
평 2
 
1.8%
구 2
 
1.8%
청 2
 
1.8%
Other values (73) 82
74.5%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 110
99.1%
Common 1
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
봉 4
 
3.6%
안 3
 
2.7%
새 3
 
2.7%
은 3
 
2.7%
골 3
 
2.7%
정 3
 
2.7%
수 3
 
2.7%
평 2
 
1.8%
구 2
 
1.8%
청 2
 
1.8%
Other values (73) 82
74.5%
Common
ValueCountFrequency (%)
1 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 110
99.1%
ASCII 1
 
0.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
봉 4
 
3.6%
안 3
 
2.7%
새 3
 
2.7%
은 3
 
2.7%
골 3
 
2.7%
정 3
 
2.7%
수 3
 
2.7%
평 2
 
1.8%
구 2
 
1.8%
청 2
 
1.8%
Other values (73) 82
74.5%
ASCII
ValueCountFrequency (%)
1 1
100.0%

시설위치(도로명주소)
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2023-12-13T07:57:36.224214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length28
Mean length23.363636
Min length19

Characters and Unicode

Total characters1028
Distinct characters97
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

Unique44 ?
Unique (%)100.0%

Sample

1st row대전광역시 서구 복수남로 12번길(복수동)
2nd row대전광역시 서구 용화7길 68(도마동)
3rd row대전광역시 서구 도솔로 182(도마동)
4th row대전광역시 서구 배재로 155-7(도마동)
5th row대전광역시 서구 배재로 91번길(도마동)
ValueCountFrequency (%)
대전광역시 44
23.9%
서구 44
23.9%
계룡로 3
 
1.6%
배재로 2
 
1.1%
동서대로 2
 
1.1%
괴정로 2
 
1.1%
가수원중로 2
 
1.1%
문정로 2
 
1.1%
9번길(둔산동 2
 
1.1%
333번길(월평동 1
 
0.5%
Other values (80) 80
43.5%
2023-12-13T07:57:36.578584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
140
 
13.6%
대 49
 
4.8%
서 48
 
4.7%
역 45
 
4.4%
동 45
 
4.4%
광 44
 
4.3%
시 44
 
4.3%
구 44
 
4.3%
전 44
 
4.3%
( 42
 
4.1%
Other values (87) 483
47.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 668
65.0%
Space Separator 140
 
13.6%
Decimal Number 130
 
12.6%
Open Punctuation 42
 
4.1%
Close Punctuation 42
 
4.1%
Other Punctuation 3
 
0.3%
Dash Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 49
 
7.3%
서 48
 
7.2%
역 45
 
6.7%
동 45
 
6.7%
광 44
 
6.6%
시 44
 
6.6%
구 44
 
6.6%
전 44
 
6.6%
로 41
 
6.1%
길 27
 
4.0%
Other values (72) 237
35.5%
Decimal Number
ValueCountFrequency (%)
1 24
18.5%
2 18
13.8%
4 17
13.1%
3 15
11.5%
8 15
11.5%
5 15
11.5%
6 10
7.7%
9 8
 
6.2%
7 5
 
3.8%
0 3
 
2.3%
Space Separator
ValueCountFrequency (%)
140
100.0%
Open Punctuation
ValueCountFrequency (%)
( 42
100.0%
Close Punctuation
ValueCountFrequency (%)
) 42
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 668
65.0%
Common 360
35.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 49
 
7.3%
서 48
 
7.2%
역 45
 
6.7%
동 45
 
6.7%
광 44
 
6.6%
시 44
 
6.6%
구 44
 
6.6%
전 44
 
6.6%
로 41
 
6.1%
길 27
 
4.0%
Other values (72) 237
35.5%
Common
ValueCountFrequency (%)
140
38.9%
( 42
 
11.7%
) 42
 
11.7%
1 24
 
6.7%
2 18
 
5.0%
4 17
 
4.7%
3 15
 
4.2%
8 15
 
4.2%
5 15
 
4.2%
6 10
 
2.8%
Other values (5) 22
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 668
65.0%
ASCII 360
35.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
140
38.9%
( 42
 
11.7%
) 42
 
11.7%
1 24
 
6.7%
2 18
 
5.0%
4 17
 
4.7%
3 15
 
4.2%
8 15
 
4.2%
5 15
 
4.2%
6 10
 
2.8%
Other values (5) 22
 
6.1%
Hangul
ValueCountFrequency (%)
대 49
 
7.3%
서 48
 
7.2%
역 45
 
6.7%
동 45
 
6.7%
광 44
 
6.6%
시 44
 
6.6%
구 44
 
6.6%
전 44
 
6.6%
로 41
 
6.1%
길 27
 
4.0%
Other values (72) 237
35.5%

시설위치(지번주소)
Text

UNIQUE 

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size484.0 B
2023-12-13T07:57:36.812281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length20
Mean length17.477273
Min length14

Characters and Unicode

Total characters769
Distinct characters52
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

Unique44 ?
Unique (%)100.0%

Sample

1st row대전광역시 서구 복수동 689
2nd row대전광역시 서구 도마동 45-1
3rd row대전광역시 서구 도마동 413-3
4th row대전광역시 서구 도마동 211
5th row대전광역시 서구 도마동 544-4
ValueCountFrequency (%)
대전광역시 44
24.7%
서구 44
24.7%
도마동 6
 
3.4%
가수원동 4
 
2.2%
내동 4
 
2.2%
월평1동 4
 
2.2%
둔산동 3
 
1.7%
탄방동 3
 
1.7%
관저2동 3
 
1.7%
관저1동 2
 
1.1%
Other values (56) 61
34.3%
2023-12-13T07:57:37.199032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
135
17.6%
1 49
 
6.4%
대 44
 
5.7%
동 44
 
5.7%
광 44
 
5.7%
역 44
 
5.7%
시 44
 
5.7%
서 44
 
5.7%
구 44
 
5.7%
전 44
 
5.7%
Other values (42) 233
30.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 446
58.0%
Decimal Number 168
 
21.8%
Space Separator 135
 
17.6%
Dash Punctuation 20
 
2.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 44
9.9%
동 44
9.9%
광 44
9.9%
역 44
9.9%
시 44
9.9%
서 44
9.9%
구 44
9.9%
전 44
9.9%
마 10
 
2.2%
도 10
 
2.2%
Other values (30) 74
16.6%
Decimal Number
ValueCountFrequency (%)
1 49
29.2%
2 22
13.1%
6 18
 
10.7%
3 15
 
8.9%
8 13
 
7.7%
9 12
 
7.1%
4 12
 
7.1%
5 11
 
6.5%
7 9
 
5.4%
0 7
 
4.2%
Space Separator
ValueCountFrequency (%)
135
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 446
58.0%
Common 323
42.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 44
9.9%
동 44
9.9%
광 44
9.9%
역 44
9.9%
시 44
9.9%
서 44
9.9%
구 44
9.9%
전 44
9.9%
마 10
 
2.2%
도 10
 
2.2%
Other values (30) 74
16.6%
Common
ValueCountFrequency (%)
135
41.8%
1 49
 
15.2%
2 22
 
6.8%
- 20
 
6.2%
6 18
 
5.6%
3 15
 
4.6%
8 13
 
4.0%
9 12
 
3.7%
4 12
 
3.7%
5 11
 
3.4%
Other values (2) 16
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 446
58.0%
ASCII 323
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
135
41.8%
1 49
 
15.2%
2 22
 
6.8%
- 20
 
6.2%
6 18
 
5.6%
3 15
 
4.6%
8 13
 
4.0%
9 12
 
3.7%
4 12
 
3.7%
5 11
 
3.4%
Other values (2) 16
 
5.0%
Hangul
ValueCountFrequency (%)
대 44
9.9%
동 44
9.9%
광 44
9.9%
역 44
9.9%
시 44
9.9%
서 44
9.9%
구 44
9.9%
전 44
9.9%
마 10
 
2.2%
도 10
 
2.2%
Other values (30) 74
16.6%

급수시간(오전)
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
버튼급수
44 

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 (%)
버튼급수 44
100.0%

Length

2023-12-13T07:57:37.340196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:57:37.749354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
버튼급수 44
100.0%

급수시간(오후)
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
버튼급수
44 

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 (%)
버튼급수 44
100.0%

Length

2023-12-13T07:57:37.832442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:57:37.923797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
버튼급수 44
100.0%

급수시간(저녁)
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
버튼급수
44 

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 (%)
버튼급수 44
100.0%

Length

2023-12-13T07:57:38.037229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:57:38.154277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
버튼급수 44
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size484.0 B
2023-11-30
44 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-30
2nd row2023-11-30
3rd row2023-11-30
4th row2023-11-30
5th row2023-11-30

Common Values

ValueCountFrequency (%)
2023-11-30 44
100.0%

Length

2023-12-13T07:57:38.258725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:57:38.408717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-30 44
100.0%

Correlations

2023-12-13T07:57:38.472861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설명시설위치(도로명주소)시설위치(지번주소)
시설명1.0001.0001.000
시설위치(도로명주소)1.0001.0001.000
시설위치(지번주소)1.0001.0001.000

Missing values

2023-12-13T07:57:35.339902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:57:35.457257image/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안복수대전광역시 서구 복수남로 12번길(복수동)대전광역시 서구 복수동 689버튼급수버튼급수버튼급수2023-11-30
1용화대전광역시 서구 용화7길 68(도마동)대전광역시 서구 도마동 45-1버튼급수버튼급수버튼급수2023-11-30
2고래재대전광역시 서구 도솔로 182(도마동)대전광역시 서구 도마동 413-3버튼급수버튼급수버튼급수2023-11-30
3연자천대전광역시 서구 배재로 155-7(도마동)대전광역시 서구 도마동 211버튼급수버튼급수버튼급수2023-11-30
4산직골대전광역시 서구 배재로 91번길(도마동)대전광역시 서구 도마동 544-4버튼급수버튼급수버튼급수2023-11-30
5평화대전광역시 서구 아랫강변4길 68(용문동)대전광역시 서구 용문동 232-1버튼급수버튼급수버튼급수2023-11-30
6한가람대전광역시 서구 계룡로 583번길(탄방동)대전광역시 서구 탄방동 780버튼급수버튼급수버튼급수2023-11-30
7새말대전광역시 서구 문정로 10번길 39(탄방동)대전광역시 서구 탄방동 626버튼급수버튼급수버튼급수2023-11-30
8개나리대전광역시 서구 제비네8길(도마동)대전광역시 서구 도마동 165-1버튼급수버튼급수버튼급수2023-11-30
9탄방대전광역시 서구 계룡로615번길 82대전광역시 서구 탄방동 68-1버튼급수버튼급수버튼급수2023-11-30
시설명시설위치(도로명주소)시설위치(지번주소)급수시간(오전)급수시간(오후)급수시간(저녁)데이터기준일자
34지치울대전광역시 서구 괴정로 16번길 5(괴정동)대전광역시 서구 괴정동 123-6버튼급수버튼급수버튼급수2023-11-30
35안골대전광역시 서구 동서대로 1047번길 16(내동)대전광역시 서구 내동 16-1버튼급수버튼급수버튼급수2023-11-30
36한마음대전광역시 서구 신갈마로 113번길(갈마동)대전광역시 서구 도마1동 392-6버튼급수버튼급수버튼급수2023-11-30
37새뜸대전광역시 서구 월평새뜸로4번길 49-26(월평동)대전광역시 서구 월평1동 1308버튼급수버튼급수버튼급수2023-11-30
38반달대전광역시 서구 계룡로 333번길(월평동)대전광역시 서구 월평1동 801버튼급수버튼급수버튼급수2023-11-30
39은평대전광역시 서구 월평중로 55(월평동)대전광역시 서구 월평동 313버튼급수버튼급수버튼급수2023-11-30
40만년대전광역시 서구 만년로 19(만년동)대전광역시 서구 만년동 7버튼급수버튼급수버튼급수2023-11-30
41옥녀봉대전광역시 서구 도안북로 158(도안동)대전광역시 서구 도안동 971버튼급수버튼급수버튼급수2023-11-30
42도안대전광역시 서구 도안동로 123(도안동)대전광역시 서구 도안동 1370버튼급수버튼급수버튼급수2023-11-30
43봉우재대전광역시 서구 봉우로 48번길(관저동)대전광역시 서구 관저1동 1662버튼급수버튼급수버튼급수2023-11-30