Overview

Dataset statistics

Number of variables5
Number of observations187
Missing cells136
Missing cells (%)14.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.6 KiB
Average record size in memory41.7 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description충청남도 천안시에 등록된 직업소개소 현황으로 업체명, 소재지, 등록일자 등의 항목을 공공데이터 정보로 제공합니다. (각 구청에서 등록한 데이터를 취합한 것으로 파일 내 데이터 기준일자가 다를 수 있음)
URLhttps://www.data.go.kr/data/3078558/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연락처 has 136 (72.7%) missing valuesMissing
연번 has unique valuesUnique
사업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:37:02.425388
Analysis finished2023-12-12 07:37:03.010188
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct187
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean94
Minimum1
Maximum187
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-12T16:37:03.105298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.3
Q147.5
median94
Q3140.5
95-th percentile177.7
Maximum187
Range186
Interquartile range (IQR)93

Descriptive statistics

Standard deviation54.126395
Coefficient of variation (CV)0.57581272
Kurtosis-1.2
Mean94
Median Absolute Deviation (MAD)47
Skewness0
Sum17578
Variance2929.6667
MonotonicityStrictly increasing
2023-12-12T16:37:03.258099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
130 1
 
0.5%
121 1
 
0.5%
122 1
 
0.5%
123 1
 
0.5%
124 1
 
0.5%
125 1
 
0.5%
126 1
 
0.5%
127 1
 
0.5%
128 1
 
0.5%
Other values (177) 177
94.7%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
187 1
0.5%
186 1
0.5%
185 1
0.5%
184 1
0.5%
183 1
0.5%
182 1
0.5%
181 1
0.5%
180 1
0.5%
179 1
0.5%
178 1
0.5%

사업소명
Text

UNIQUE 

Distinct187
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T16:37:03.512795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length20
Mean length7.368984
Min length2

Characters and Unicode

Total characters1378
Distinct characters245
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique187 ?
Unique (%)100.0%

Sample

1st row에스더블유티(주)
2nd row일가자 인력(천안점)
3rd row꿀벌인력
4th row영진인력개발
5th row홍익휴먼비즈
ValueCountFrequency (%)
직업소개소 5
 
2.3%
주식회사 5
 
2.3%
개미인력개발 4
 
1.8%
모아인력 2
 
0.9%
에스더블유티(주 1
 
0.5%
우정인력개발 1
 
0.5%
드림홈 1
 
0.5%
서비스 1
 
0.5%
도우리직업소개소 1
 
0.5%
세븐직업소개소 1
 
0.5%
Other values (200) 200
90.1%
2023-12-12T16:37:03.920716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
소 109
 
7.9%
인 92
 
6.7%
력 84
 
6.1%
개 80
 
5.8%
업 50
 
3.6%
직 48
 
3.5%
36
 
2.6%
사 26
 
1.9%
발 26
 
1.9%
천 23
 
1.7%
Other values (235) 804
58.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1282
93.0%
Space Separator 36
 
2.6%
Open Punctuation 19
 
1.4%
Close Punctuation 19
 
1.4%
Uppercase Letter 13
 
0.9%
Decimal Number 7
 
0.5%
Other Symbol 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
소 109
 
8.5%
인 92
 
7.2%
력 84
 
6.6%
개 80
 
6.2%
업 50
 
3.9%
직 48
 
3.7%
사 26
 
2.0%
발 26
 
2.0%
천 23
 
1.8%
주 20
 
1.6%
Other values (213) 724
56.5%
Uppercase Letter
ValueCountFrequency (%)
S 2
15.4%
K 2
15.4%
M 1
7.7%
Z 1
7.7%
I 1
7.7%
W 1
7.7%
E 1
7.7%
H 1
7.7%
T 1
7.7%
J 1
7.7%
Decimal Number
ValueCountFrequency (%)
0 2
28.6%
4 1
14.3%
1 1
14.3%
5 1
14.3%
6 1
14.3%
3 1
14.3%
Space Separator
ValueCountFrequency (%)
36
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1283
93.1%
Common 82
 
6.0%
Latin 13
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
소 109
 
8.5%
인 92
 
7.2%
력 84
 
6.5%
개 80
 
6.2%
업 50
 
3.9%
직 48
 
3.7%
사 26
 
2.0%
발 26
 
2.0%
천 23
 
1.8%
주 20
 
1.6%
Other values (214) 725
56.5%
Latin
ValueCountFrequency (%)
S 2
15.4%
K 2
15.4%
M 1
7.7%
Z 1
7.7%
I 1
7.7%
W 1
7.7%
E 1
7.7%
H 1
7.7%
T 1
7.7%
J 1
7.7%
Common
ValueCountFrequency (%)
36
43.9%
( 19
23.2%
) 19
23.2%
0 2
 
2.4%
4 1
 
1.2%
1 1
 
1.2%
5 1
 
1.2%
6 1
 
1.2%
& 1
 
1.2%
3 1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1282
93.0%
ASCII 95
 
6.9%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
소 109
 
8.5%
인 92
 
7.2%
력 84
 
6.6%
개 80
 
6.2%
업 50
 
3.9%
직 48
 
3.7%
사 26
 
2.0%
발 26
 
2.0%
천 23
 
1.8%
주 20
 
1.6%
Other values (213) 724
56.5%
ASCII
ValueCountFrequency (%)
36
37.9%
( 19
20.0%
) 19
20.0%
S 2
 
2.1%
K 2
 
2.1%
0 2
 
2.1%
4 1
 
1.1%
M 1
 
1.1%
1 1
 
1.1%
5 1
 
1.1%
Other values (11) 11
 
11.6%
None
ValueCountFrequency (%)
㈜ 1
100.0%

사업소소재지
Text

Distinct186
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-12T16:37:04.244727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length43
Mean length31.411765
Min length23

Characters and Unicode

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

Unique

Unique185 ?
Unique (%)98.9%

Sample

1st row충청남도 천안시 서북구 한들1로 171. D102호 (백석동)
2nd row충청남도 천안시 서북구 백석로 298. 402호 (성정동)
3rd row충청남도 천안시 서북구 두정로 240. 604호 (두정동)
4th row충청남도 천안시 서북구 봉정로 146. 201호 (성정동)
5th row충청남도 천안시 동남구 성불사길 36. 상가동 301호 (안서동. 부경파크빌2차아파트)
ValueCountFrequency (%)
충청남도 187
 
14.4%
천안시 187
 
14.4%
서북구 101
 
7.8%
동남구 86
 
6.6%
성정동 38
 
2.9%
2층 20
 
1.5%
성환읍 17
 
1.3%
1층 17
 
1.3%
봉정로 15
 
1.2%
충절로 14
 
1.1%
Other values (377) 616
47.5%
2023-12-12T16:37:04.752427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1111
 
18.9%
남 277
 
4.7%
1 237
 
4.0%
동 232
 
3.9%
천 225
 
3.8%
충 204
 
3.5%
안 198
 
3.4%
청 196
 
3.3%
시 190
 
3.2%
구 190
 
3.2%
Other values (210) 2814
47.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3466
59.0%
Space Separator 1111
 
18.9%
Decimal Number 848
 
14.4%
Close Punctuation 137
 
2.3%
Open Punctuation 137
 
2.3%
Other Punctuation 122
 
2.1%
Dash Punctuation 33
 
0.6%
Uppercase Letter 20
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 277
 
8.0%
동 232
 
6.7%
천 225
 
6.5%
충 204
 
5.9%
안 198
 
5.7%
청 196
 
5.7%
시 190
 
5.5%
구 190
 
5.5%
도 188
 
5.4%
로 124
 
3.6%
Other values (183) 1442
41.6%
Uppercase Letter
ValueCountFrequency (%)
S 4
20.0%
K 3
15.0%
D 2
10.0%
A 2
10.0%
L 2
10.0%
T 1
 
5.0%
G 1
 
5.0%
R 1
 
5.0%
C 1
 
5.0%
Y 1
 
5.0%
Other values (2) 2
10.0%
Decimal Number
ValueCountFrequency (%)
1 237
27.9%
2 134
15.8%
0 97
11.4%
3 88
 
10.4%
5 61
 
7.2%
6 57
 
6.7%
4 54
 
6.4%
7 53
 
6.2%
8 37
 
4.4%
9 30
 
3.5%
Space Separator
ValueCountFrequency (%)
1111
100.0%
Close Punctuation
ValueCountFrequency (%)
) 137
100.0%
Open Punctuation
ValueCountFrequency (%)
( 137
100.0%
Other Punctuation
ValueCountFrequency (%)
. 122
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 33
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3466
59.0%
Common 2388
40.7%
Latin 20
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 277
 
8.0%
동 232
 
6.7%
천 225
 
6.5%
충 204
 
5.9%
안 198
 
5.7%
청 196
 
5.7%
시 190
 
5.5%
구 190
 
5.5%
도 188
 
5.4%
로 124
 
3.6%
Other values (183) 1442
41.6%
Common
ValueCountFrequency (%)
1111
46.5%
1 237
 
9.9%
) 137
 
5.7%
( 137
 
5.7%
2 134
 
5.6%
. 122
 
5.1%
0 97
 
4.1%
3 88
 
3.7%
5 61
 
2.6%
6 57
 
2.4%
Other values (5) 207
 
8.7%
Latin
ValueCountFrequency (%)
S 4
20.0%
K 3
15.0%
D 2
10.0%
A 2
10.0%
L 2
10.0%
T 1
 
5.0%
G 1
 
5.0%
R 1
 
5.0%
C 1
 
5.0%
Y 1
 
5.0%
Other values (2) 2
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3466
59.0%
ASCII 2408
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1111
46.1%
1 237
 
9.8%
) 137
 
5.7%
( 137
 
5.7%
2 134
 
5.6%
. 122
 
5.1%
0 97
 
4.0%
3 88
 
3.7%
5 61
 
2.5%
6 57
 
2.4%
Other values (17) 227
 
9.4%
Hangul
ValueCountFrequency (%)
남 277
 
8.0%
동 232
 
6.7%
천 225
 
6.5%
충 204
 
5.9%
안 198
 
5.7%
청 196
 
5.7%
시 190
 
5.5%
구 190
 
5.5%
도 188
 
5.4%
로 124
 
3.6%
Other values (183) 1442
41.6%

연락처
Text

MISSING 

Distinct51
Distinct (%)100.0%
Missing136
Missing (%)72.7%
Memory size1.6 KiB
2023-12-12T16:37:05.064871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.039216
Min length12

Characters and Unicode

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

Unique51 ?
Unique (%)100.0%

Sample

1st row041-562-2283
2nd row041-574-0042
3rd row041-575-7120
4th row041-907-7774
5th row041-522-0302
ValueCountFrequency (%)
041-562-2283 1
 
2.0%
041-566-1989 1
 
2.0%
041-578-8133 1
 
2.0%
041-522-1159 1
 
2.0%
041-551-8111 1
 
2.0%
041-554-3454 1
 
2.0%
041-578-1234 1
 
2.0%
041-522-5854 1
 
2.0%
041-559-5724 1
 
2.0%
041-553-1193 1
 
2.0%
Other values (41) 41
80.4%
2023-12-12T16:37:05.489662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 102
16.6%
5 91
14.8%
1 84
13.7%
0 81
13.2%
4 77
12.5%
2 42
6.8%
7 41
6.7%
6 27
 
4.4%
8 24
 
3.9%
3 23
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 512
83.4%
Dash Punctuation 102
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 91
17.8%
1 84
16.4%
0 81
15.8%
4 77
15.0%
2 42
8.2%
7 41
8.0%
6 27
 
5.3%
8 24
 
4.7%
3 23
 
4.5%
9 22
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 102
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 614
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 102
16.6%
5 91
14.8%
1 84
13.7%
0 81
13.2%
4 77
12.5%
2 42
6.8%
7 41
6.7%
6 27
 
4.4%
8 24
 
3.9%
3 23
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 614
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 102
16.6%
5 91
14.8%
1 84
13.7%
0 81
13.2%
4 77
12.5%
2 42
6.8%
7 41
6.7%
6 27
 
4.4%
8 24
 
3.9%
3 23
 
3.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-08-23 00:00:00
Maximum2023-08-23 00:00:00
2023-12-12T16:37:05.657970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:37:05.772269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T16:37:02.742903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:37:05.855318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연락처
연번1.0001.000
연락처1.0001.000

Missing values

2023-12-12T16:37:02.868193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:37:02.961181image/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에스더블유티(주)충청남도 천안시 서북구 한들1로 171. D102호 (백석동)<NA>2023-08-23
12일가자 인력(천안점)충청남도 천안시 서북구 백석로 298. 402호 (성정동)<NA>2023-08-23
23꿀벌인력충청남도 천안시 서북구 두정로 240. 604호 (두정동)<NA>2023-08-23
34영진인력개발충청남도 천안시 서북구 봉정로 146. 201호 (성정동)<NA>2023-08-23
45홍익휴먼비즈충청남도 천안시 동남구 성불사길 36. 상가동 301호 (안서동. 부경파크빌2차아파트)041-562-22832023-08-23
56산모피아충청남도 천안시 서북구 월봉7길 49. 410호 (쌍용동. 효명리츠빌)041-574-00422023-08-23
67모아인력충청남도 천안시 서북구 성정로 91 (성정동)<NA>2023-08-23
78(사)충남장애인복지정보화협회충청남도 천안시 동남구 서부대로 257-13. 2층 (신방동)041-575-71202023-08-23
89정성인력 천안원성점충청남도 천안시 동남구 충절로 174. 제일빌딩 2층 (원성동)<NA>2023-08-23
910모아인력 직산충청남도 천안시 서북구 직산읍 봉주로 20. 103호<NA>2023-08-23
연번사업소명사업소소재지연락처데이터기준일자
177178현대건축인력공사충청남도 천안시 동남구 충무로 506 (구성동)041-554-34082023-08-23
178179한길인력개발충청남도 천안시 서북구 성정15길 19 (성정동)<NA>2023-08-23
179180쌍용직업소개소충청남도 천안시 동남구 순천향3길 15. 쌍용인력개발 (쌍용동)041-574-22962023-08-23
180181대성인력직업소개소충청남도 천안시 서북구 성환읍 신방로 467<NA>2023-08-23
181182한일직업소개소충청남도 천안시 동남구 신용로 7 (다가동)041-573-99522023-08-23
182183유진파출직업소개소충청남도 천안시 동남구 쌍용대로 94-5 (봉명동)041-575-52512023-08-23
183184직산인력직업소개소충청남도 천안시 서북구 직산읍 삼은4길 1<NA>2023-08-23
184185정토건설직업소개소충청남도 천안시 서북구 백석로 236. 3층 (성정동)<NA>2023-08-23
185186삼은직업소개소충청남도 천안시 서북구 직산읍 삼은3길 25<NA>2023-08-23
186187수정파출부직업소개소충청남도 천안시 서북구 봉정로 130 (성정동)<NA>2023-08-23