Overview

Dataset statistics

Number of variables5
Number of observations26
Missing cells11
Missing cells (%)8.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory45.1 B

Variable types

Text3
Categorical1
DateTime1

Dataset

Description공주시 직업소개소 현황에 대한 데이터로 직업소개소의 도로명주소, 전화번호, 비용지불 유무, 데이터의 기준이 되는 날짜를 안내하고 있습니다.
Author충청남도 공주시
URLhttps://www.data.go.kr/data/3084528/fileData.do

Alerts

데이터기준일 has constant value ""Constant
비용지불여부 is highly imbalanced (76.5%)Imbalance
전화번호 has 11 (42.3%) missing valuesMissing
직업소개소명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:19:27.034854
Analysis finished2023-12-12 00:19:27.776674
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

직업소개소명
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-12T09:19:27.960661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length10
Mean length7.4230769
Min length4

Characters and Unicode

Total characters193
Distinct characters69
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

Unique26 ?
Unique (%)100.0%

Sample

1st row그린에이치알인력직업소개소
2nd row무조건OK인력사무소
3rd row교동인력개발
4th row충청인력
5th row행복직업소개소
ValueCountFrequency (%)
그린에이치알인력직업소개소 1
 
3.8%
무조건ok인력사무소 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 (16) 16
61.5%
2023-12-12T09:19:28.423024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
소 25
 
13.0%
인 18
 
9.3%
력 17
 
8.8%
개 16
 
8.3%
직 12
 
6.2%
업 12
 
6.2%
성 4
 
2.1%
발 3
 
1.6%
주 3
 
1.6%
건 3
 
1.6%
Other values (59) 80
41.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 191
99.0%
Uppercase Letter 2
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
소 25
 
13.1%
인 18
 
9.4%
력 17
 
8.9%
개 16
 
8.4%
직 12
 
6.3%
업 12
 
6.3%
성 4
 
2.1%
발 3
 
1.6%
주 3
 
1.6%
건 3
 
1.6%
Other values (57) 78
40.8%
Uppercase Letter
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 191
99.0%
Latin 2
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
소 25
 
13.1%
인 18
 
9.4%
력 17
 
8.9%
개 16
 
8.4%
직 12
 
6.3%
업 12
 
6.3%
성 4
 
2.1%
발 3
 
1.6%
주 3
 
1.6%
건 3
 
1.6%
Other values (57) 78
40.8%
Latin
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 191
99.0%
ASCII 2
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
소 25
 
13.1%
인 18
 
9.4%
력 17
 
8.9%
개 16
 
8.4%
직 12
 
6.3%
업 12
 
6.3%
성 4
 
2.1%
발 3
 
1.6%
주 3
 
1.6%
건 3
 
1.6%
Other values (57) 78
40.8%
ASCII
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%

소재지도로명주소
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-12T09:19:28.712548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length25
Mean length22.807692
Min length19

Characters and Unicode

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

Unique

Unique26 ?
Unique (%)100.0%

Sample

1st row충청남도 공주시 대통1길 1 1층 (봉황동)
2nd row충청남도 공주시 의당면 의당로 275
3rd row충청남도 공주시 용당길 34(교동)
4th row충청남도 공주시 유구읍 유구초교길 7-4
5th row충청남도 공주시 번영1로 138(신관동)
ValueCountFrequency (%)
충청남도 26
19.5%
공주시 26
19.5%
신관동 5
 
3.8%
무령로 4
 
3.0%
중동 4
 
3.0%
1층 4
 
3.0%
웅진로 3
 
2.3%
번영2로 2
 
1.5%
대통1길 2
 
1.5%
옥룡동 2
 
1.5%
Other values (53) 55
41.4%
2023-12-12T09:19:29.176800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
107
18.0%
1 27
 
4.6%
충 26
 
4.4%
청 26
 
4.4%
남 26
 
4.4%
도 26
 
4.4%
공 26
 
4.4%
주 26
 
4.4%
시 26
 
4.4%
동 22
 
3.7%
Other values (65) 255
43.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 350
59.0%
Space Separator 107
 
18.0%
Decimal Number 88
 
14.8%
Close Punctuation 20
 
3.4%
Open Punctuation 20
 
3.4%
Dash Punctuation 8
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
충 26
 
7.4%
청 26
 
7.4%
남 26
 
7.4%
도 26
 
7.4%
공 26
 
7.4%
주 26
 
7.4%
시 26
 
7.4%
동 22
 
6.3%
로 16
 
4.6%
길 10
 
2.9%
Other values (51) 120
34.3%
Decimal Number
ValueCountFrequency (%)
1 27
30.7%
2 13
14.8%
4 11
12.5%
7 8
 
9.1%
5 8
 
9.1%
3 8
 
9.1%
8 7
 
8.0%
0 3
 
3.4%
6 2
 
2.3%
9 1
 
1.1%
Space Separator
ValueCountFrequency (%)
107
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 350
59.0%
Common 243
41.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
충 26
 
7.4%
청 26
 
7.4%
남 26
 
7.4%
도 26
 
7.4%
공 26
 
7.4%
주 26
 
7.4%
시 26
 
7.4%
동 22
 
6.3%
로 16
 
4.6%
길 10
 
2.9%
Other values (51) 120
34.3%
Common
ValueCountFrequency (%)
107
44.0%
1 27
 
11.1%
) 20
 
8.2%
( 20
 
8.2%
2 13
 
5.3%
4 11
 
4.5%
- 8
 
3.3%
7 8
 
3.3%
5 8
 
3.3%
3 8
 
3.3%
Other values (4) 13
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 350
59.0%
ASCII 243
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
107
44.0%
1 27
 
11.1%
) 20
 
8.2%
( 20
 
8.2%
2 13
 
5.3%
4 11
 
4.5%
- 8
 
3.3%
7 8
 
3.3%
5 8
 
3.3%
3 8
 
3.3%
Other values (4) 13
 
5.3%
Hangul
ValueCountFrequency (%)
충 26
 
7.4%
청 26
 
7.4%
남 26
 
7.4%
도 26
 
7.4%
공 26
 
7.4%
주 26
 
7.4%
시 26
 
7.4%
동 22
 
6.3%
로 16
 
4.6%
길 10
 
2.9%
Other values (51) 120
34.3%

전화번호
Text

MISSING 

Distinct15
Distinct (%)100.0%
Missing11
Missing (%)42.3%
Memory size340.0 B
2023-12-12T09:19:29.415050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.066667
Min length12

Characters and Unicode

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

Unique

Unique15 ?
Unique (%)100.0%

Sample

1st row041-853-1082
2nd row041-858-5111
3rd row041-858 -0315
4th row041-858-5020
5th row041-855-1181
ValueCountFrequency (%)
041-853-1082 1
 
5.6%
041-858-5111 1
 
5.6%
041-854-8123 1
 
5.6%
041-857-0020 1
 
5.6%
041-858-3344 1
 
5.6%
041-858-5353 1
 
5.6%
041-858-1900 1
 
5.6%
8089 1
 
5.6%
853 1
 
5.6%
041 1
 
5.6%
Other values (8) 8
44.4%
2023-12-12T09:19:29.843967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 30
16.6%
- 28
15.5%
0 27
14.9%
1 27
14.9%
5 23
12.7%
4 21
11.6%
3 8
 
4.4%
2 5
 
2.8%
7 4
 
2.2%
3
 
1.7%
Other values (2) 5
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 150
82.9%
Dash Punctuation 28
 
15.5%
Space Separator 3
 
1.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 30
20.0%
0 27
18.0%
1 27
18.0%
5 23
15.3%
4 21
14.0%
3 8
 
5.3%
2 5
 
3.3%
7 4
 
2.7%
6 3
 
2.0%
9 2
 
1.3%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 181
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
8 30
16.6%
- 28
15.5%
0 27
14.9%
1 27
14.9%
5 23
12.7%
4 21
11.6%
3 8
 
4.4%
2 5
 
2.8%
7 4
 
2.2%
3
 
1.7%
Other values (2) 5
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 181
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 30
16.6%
- 28
15.5%
0 27
14.9%
1 27
14.9%
5 23
12.7%
4 21
11.6%
3 8
 
4.4%
2 5
 
2.8%
7 4
 
2.2%
3
 
1.7%
Other values (2) 5
 
2.8%

비용지불여부
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size340.0 B
유료
25 
무료
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)3.8%

Sample

1st row유료
2nd row유료
3rd row유료
4th row유료
5th row유료

Common Values

ValueCountFrequency (%)
유료 25
96.2%
무료 1
 
3.8%

Length

2023-12-12T09:19:30.011157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:19:30.128742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유료 25
96.2%
무료 1
 
3.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
Minimum2022-11-11 00:00:00
Maximum2022-11-11 00:00:00
2023-12-12T09:19:30.207781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:19:30.320702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T09:19:30.416754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
직업소개소명소재지도로명주소전화번호비용지불여부
직업소개소명1.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
비용지불여부1.0001.0001.0001.000

Missing values

2023-12-12T09:19:27.619494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:19:27.728304image/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그린에이치알인력직업소개소충청남도 공주시 대통1길 1 1층 (봉황동)<NA>유료2022-11-11
1무조건OK인력사무소충청남도 공주시 의당면 의당로 275<NA>유료2022-11-11
2교동인력개발충청남도 공주시 용당길 34(교동)<NA>유료2022-11-11
3충청인력충청남도 공주시 유구읍 유구초교길 7-4<NA>유료2022-11-11
4행복직업소개소충청남도 공주시 번영1로 138(신관동)<NA>유료2022-11-11
5우상인력개발충청남도 공주시 관골1길 51(신관동)041-853-1082유료2022-11-11
6천리마인력충청남도 공주시 계룡면 신원사로 144<NA>유료2022-11-11
7중앙인력충청남도 공주시 번영3로 15 2층 (신관동)041-858-5111유료2022-11-11
8주식회사보물개발충청남도 공주시 정안면 정안중앙길 228 1층<NA>유료2022-11-11
9장마루인력충청남도 공주시 탄천면 장마루로 943<NA>유료2022-11-11
직업소개소명소재지도로명주소전화번호비용지불여부데이터기준일
16세종인력직업소개소충청남도 공주시 무령로 274 (중동)041-857-4646유료2022-11-11
17한성인력직업소개소충청남도 공주시 웅진로 138-1 (중동)<NA>유료2022-11-11
18충남남부장애인종합복지관직업재활센터충청남도 공주시 계룡면 영규대사로 747041-856-7071무료2022-11-11
19대한직업소개소충청남도 공주시 번영2로 48-2 (신관동)041 853 8089유료2022-11-11
20대우인력직업소개소충청남도 공주시 국고개길 47 (중동)041-858-1900유료2022-11-11
21신강북인력소개소충청남도 공주시 전막1길 16-15 (신관동)041-858-5353유료2022-11-11
22공주인력충청남도 공주시 대통1길 53 1층 (반죽동)041-858-3344유료2022-11-11
23신관직업소개소충청남도 공주시 번영1로 45 지하 1층 (신관동)041-857-0020유료2022-11-11
24개미직업소개소충청남도 공주시 매산동길 28 (신관동)041-854-8123유료2022-11-11
25화성직업소개소충청남도 공주시 무령로 265-1 (산성동)041-858-1888유료2022-11-11