Overview

Dataset statistics

Number of variables5
Number of observations35
Missing cells2
Missing cells (%)1.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory43.8 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description안양시 목욕장업 현황 데이터화 기존 테이터를 2023년 07월13일 기준실행 (업종명 업소명 영업소 주소 소재지 전화) 하여 현행화하여 실태 파악 하였습니다.
URLhttps://www.data.go.kr/data/15055424/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준 has constant value ""Constant
소재지전화 has 2 (5.7%) missing valuesMissing
업소명 has unique valuesUnique
영업소 주소(도로명) has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:50:03.034704
Analysis finished2023-12-12 08:50:03.500209
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
목욕장업
35 

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 (%)
목욕장업 35
100.0%

Length

2023-12-12T17:50:03.597880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:50:03.736941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
목욕장업 35
100.0%

업소명
Text

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
2023-12-12T17:50:04.018254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length6.5714286
Min length2

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)100.0%

Sample

1st row안양한증원
2nd row안양수리산한증원
3rd row현대목욕탕
4th row천옥대중사우나
5th row창박골 한증원
ValueCountFrequency (%)
안양한증원 1
 
2.4%
천지목욕탕 1
 
2.4%
주)로히 1
 
2.4%
안양온천 1
 
2.4%
오성대중사우나 1
 
2.4%
산동사우나 1
 
2.4%
샤크존사우나 1
 
2.4%
사우나파크 1
 
2.4%
도도스포츠센타 1
 
2.4%
삼진목욕탕 1
 
2.4%
Other values (32) 32
76.2%
2023-12-12T17:50:04.476096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 19
 
8.3%
우 18
 
7.8%
나 18
 
7.8%
목 8
 
3.5%
욕 8
 
3.5%
탕 8
 
3.5%
7
 
3.0%
안 5
 
2.2%
한 5
 
2.2%
증 5
 
2.2%
Other values (92) 129
56.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 216
93.9%
Space Separator 7
 
3.0%
Uppercase Letter 3
 
1.3%
Decimal Number 2
 
0.9%
Close Punctuation 1
 
0.4%
Open Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 19
 
8.8%
우 18
 
8.3%
나 18
 
8.3%
목 8
 
3.7%
욕 8
 
3.7%
탕 8
 
3.7%
안 5
 
2.3%
한 5
 
2.3%
증 5
 
2.3%
양 5
 
2.3%
Other values (84) 117
54.2%
Uppercase Letter
ValueCountFrequency (%)
F 1
33.3%
N 1
33.3%
U 1
33.3%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
4 1
50.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 216
93.9%
Common 11
 
4.8%
Latin 3
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 19
 
8.8%
우 18
 
8.3%
나 18
 
8.3%
목 8
 
3.7%
욕 8
 
3.7%
탕 8
 
3.7%
안 5
 
2.3%
한 5
 
2.3%
증 5
 
2.3%
양 5
 
2.3%
Other values (84) 117
54.2%
Common
ValueCountFrequency (%)
7
63.6%
2 1
 
9.1%
) 1
 
9.1%
( 1
 
9.1%
4 1
 
9.1%
Latin
ValueCountFrequency (%)
F 1
33.3%
N 1
33.3%
U 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 216
93.9%
ASCII 14
 
6.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 19
 
8.8%
우 18
 
8.3%
나 18
 
8.3%
목 8
 
3.7%
욕 8
 
3.7%
탕 8
 
3.7%
안 5
 
2.3%
한 5
 
2.3%
증 5
 
2.3%
양 5
 
2.3%
Other values (84) 117
54.2%
ASCII
ValueCountFrequency (%)
7
50.0%
2 1
 
7.1%
) 1
 
7.1%
F 1
 
7.1%
( 1
 
7.1%
N 1
 
7.1%
U 1
 
7.1%
4 1
 
7.1%

영업소 주소(도로명)
Text

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
2023-12-12T17:50:04.873229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length41
Mean length32.457143
Min length23

Characters and Unicode

Total characters1136
Distinct characters89
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

Unique35 ?
Unique (%)100.0%

Sample

1st row경기도 안양시 만안구 병목안로 251-3 (안양동)
2nd row경기도 안양시 만안구 병목안로 224 (안양동)
3rd row경기도 안양시 만안구 석천로 162 (석수동)
4th row경기도 안양시 만안구 장내로 94 (안양동)
5th row경기도 안양시 만안구 창박로 37 (안양동)
ValueCountFrequency (%)
안양시 36
 
15.1%
경기도 35
 
14.7%
동안구 20
 
8.4%
만안구 15
 
6.3%
안양동 12
 
5.0%
관양동 6
 
2.5%
지하1층 4
 
1.7%
경수대로 4
 
1.7%
호계동 3
 
1.3%
관악대로 3
 
1.3%
Other values (84) 100
42.0%
2023-12-12T17:50:05.442890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
203
17.9%
안 96
 
8.5%
양 60
 
5.3%
동 57
 
5.0%
경 41
 
3.6%
1 41
 
3.6%
시 37
 
3.3%
도 36
 
3.2%
) 35
 
3.1%
구 35
 
3.1%
Other values (79) 495
43.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 669
58.9%
Space Separator 203
 
17.9%
Decimal Number 159
 
14.0%
Close Punctuation 35
 
3.1%
Open Punctuation 35
 
3.1%
Other Punctuation 24
 
2.1%
Uppercase Letter 6
 
0.5%
Dash Punctuation 4
 
0.4%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
안 96
14.3%
양 60
 
9.0%
동 57
 
8.5%
경 41
 
6.1%
시 37
 
5.5%
도 36
 
5.4%
구 35
 
5.2%
기 35
 
5.2%
로 35
 
5.2%
층 19
 
2.8%
Other values (59) 218
32.6%
Decimal Number
ValueCountFrequency (%)
1 41
25.8%
2 24
15.1%
3 23
14.5%
4 20
12.6%
0 11
 
6.9%
5 10
 
6.3%
8 9
 
5.7%
9 8
 
5.0%
6 7
 
4.4%
7 6
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
B 3
50.0%
I 1
 
16.7%
Z 1
 
16.7%
C 1
 
16.7%
Space Separator
ValueCountFrequency (%)
203
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 669
58.9%
Common 461
40.6%
Latin 6
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
안 96
14.3%
양 60
 
9.0%
동 57
 
8.5%
경 41
 
6.1%
시 37
 
5.5%
도 36
 
5.4%
구 35
 
5.2%
기 35
 
5.2%
로 35
 
5.2%
층 19
 
2.8%
Other values (59) 218
32.6%
Common
ValueCountFrequency (%)
203
44.0%
1 41
 
8.9%
) 35
 
7.6%
( 35
 
7.6%
2 24
 
5.2%
, 24
 
5.2%
3 23
 
5.0%
4 20
 
4.3%
0 11
 
2.4%
5 10
 
2.2%
Other values (6) 35
 
7.6%
Latin
ValueCountFrequency (%)
B 3
50.0%
I 1
 
16.7%
Z 1
 
16.7%
C 1
 
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 669
58.9%
ASCII 467
41.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
203
43.5%
1 41
 
8.8%
) 35
 
7.5%
( 35
 
7.5%
2 24
 
5.1%
, 24
 
5.1%
3 23
 
4.9%
4 20
 
4.3%
0 11
 
2.4%
5 10
 
2.1%
Other values (10) 41
 
8.8%
Hangul
ValueCountFrequency (%)
안 96
14.3%
양 60
 
9.0%
동 57
 
8.5%
경 41
 
6.1%
시 37
 
5.5%
도 36
 
5.4%
구 35
 
5.2%
기 35
 
5.2%
로 35
 
5.2%
층 19
 
2.8%
Other values (59) 218
32.6%

소재지전화
Text

MISSING 

Distinct33
Distinct (%)100.0%
Missing2
Missing (%)5.7%
Memory size412.0 B
2023-12-12T17:50:05.710596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.060606
Min length12

Characters and Unicode

Total characters398
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

Unique33 ?
Unique (%)100.0%

Sample

1st row031-466-3508
2nd row031-449-0487
3rd row031-472-9911
4th row031-449-8500
5th row031-445-7054
ValueCountFrequency (%)
031-464-7123 1
 
3.0%
031-384-6511 1
 
3.0%
031-386-3800 1
 
3.0%
031-457-0517 1
 
3.0%
031-464-5000 1
 
3.0%
031-423-4546 1
 
3.0%
031-446-1212 1
 
3.0%
031-452-5000 1
 
3.0%
031-387-2500 1
 
3.0%
031-421-7371 1
 
3.0%
Other values (23) 23
69.7%
2023-12-12T17:50:06.156870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 66
16.6%
0 62
15.6%
4 60
15.1%
1 58
14.6%
3 52
13.1%
5 26
 
6.5%
2 19
 
4.8%
7 15
 
3.8%
8 15
 
3.8%
6 13
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 332
83.4%
Dash Punctuation 66
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 62
18.7%
4 60
18.1%
1 58
17.5%
3 52
15.7%
5 26
7.8%
2 19
 
5.7%
7 15
 
4.5%
8 15
 
4.5%
6 13
 
3.9%
9 12
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 398
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 66
16.6%
0 62
15.6%
4 60
15.1%
1 58
14.6%
3 52
13.1%
5 26
 
6.5%
2 19
 
4.8%
7 15
 
3.8%
8 15
 
3.8%
6 13
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 398
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 66
16.6%
0 62
15.6%
4 60
15.1%
1 58
14.6%
3 52
13.1%
5 26
 
6.5%
2 19
 
4.8%
7 15
 
3.8%
8 15
 
3.8%
6 13
 
3.3%

데이터기준
Date

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum2023-07-12 00:00:00
Maximum2023-07-12 00:00:00
2023-12-12T17:50:06.286781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:50:06.395646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T17:50:06.473203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명영업소 주소(도로명)소재지전화
업소명1.0001.0001.000
영업소 주소(도로명)1.0001.0001.000
소재지전화1.0001.0001.000

Missing values

2023-12-12T17:50:03.310031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:50:03.448543image/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목욕장업안양한증원경기도 안양시 만안구 병목안로 251-3 (안양동)031-466-35082023-07-12
1목욕장업안양수리산한증원경기도 안양시 만안구 병목안로 224 (안양동)031-449-04872023-07-12
2목욕장업현대목욕탕경기도 안양시 만안구 석천로 162 (석수동)031-472-99112023-07-12
3목욕장업천옥대중사우나경기도 안양시 만안구 장내로 94 (안양동)031-449-85002023-07-12
4목욕장업창박골 한증원경기도 안양시 만안구 창박로 37 (안양동)031-445-70542023-07-12
5목욕장업신안목욕탕경기도 안양시 만안구 안양로 414 (안양동)031-448-99112023-07-12
6목욕장업호정사우나경기도 안양시 만안구 만안로 49 (안양동)031-444-45882023-07-12
7목욕장업샘터힐링사우나경기도 안양시 만안구 장내로 125 (안양동)031-446-12342023-07-12
8목욕장업송림사우나경기도 안양시 만안구 만안로111번길 36 (안양동)031-441-21472023-07-12
9목욕장업안양월드사우나경기도 안양시 만안구 안양로329번길 108, 지하1층+지하2층 (안양동)031-464-71232023-07-12
업종명업소명영업소 주소(도로명)소재지전화데이터기준
25목욕장업도도스포츠센타경기도 안양시 동안구 관악대로 183 (비산동,지하2층)031-386-38002023-07-12
26목욕장업포유FUN케어센터경기도 안양시 동안구 관악대로 346 (관양동,지하2층)031-421-73712023-07-12
27목욕장업초원 사우나경기도 안양시 동안구 관평로 138, 초원세경아파트 상가B동 B1호 (평촌동)031-384-45652023-07-12
28목욕장업평촌본사우나경기도 안양시 동안구 흥안대로456번길 11 (평촌동,지하1층)031-421-45542023-07-12
29목욕장업대영사우나경기도 안양시 동안구 엘에스로 45 (호계동,6층)031-459-61002023-07-12
30목욕장업덕유불한증막사우나경기도 안양시 동안구 경수대로 428 (호계동,덕유파크 지하1층)031-454-03302023-07-12
31목욕장업청림사우나경기도 안양시 동안구 흥안대로 94, 지하1층 101호일부호 (호계동, 리치밸리)031-429-37292023-07-12
32목욕장업미네랄해수사우나경기도 안양시 동안구 흥안대로 313, 안양시 농수산물도매시장 관리동 지하1층 (평촌동)<NA>2023-07-12
33목욕장업면역공방경기도 안양시 동안구 평촌대로 450-4, 일부 1층 (비산동)031-381-33112023-07-12
34목욕장업자마이카 피트니스 앤 스파경기도 안양시 동안구 평촌대로243번길 30, 샤크존 2층 C101-145호 (비산동)<NA>2023-07-12