Overview

Dataset statistics

Number of variables6
Number of observations177
Missing cells10
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.4 KiB
Average record size in memory48.7 B

Variable types

Text5
Categorical1

Dataset

Description등록번호, 상호, 소재지, 대표자 등의 기준으로 구분되어 기재되어있는 충청북도 제천시 부동산중개업소 현황에 대한 정보를 제공합니다.
Author충청북도 제천시
URLhttps://www.data.go.kr/data/15006917/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 10 (5.6%) missing valuesMissing
등록번호 has unique valuesUnique
중개업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:08:01.835024
Analysis finished2023-12-12 17:08:02.406180
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록번호
Text

UNIQUE 

Distinct177
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T02:08:02.619895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length14.983051
Min length10

Characters and Unicode

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

Unique

Unique177 ?
Unique (%)100.0%

Sample

1st row나-38060000-1
2nd row나-38060000-4
3rd row나-38060000-8
4th row나-38060000-12
5th row나-38060000-17
ValueCountFrequency (%)
나-38060000-1 1
 
0.6%
43150-2015-00029 1
 
0.6%
43150-2018-00002 1
 
0.6%
43150-2017-00014 1
 
0.6%
43150-2017-00017 1
 
0.6%
43150-2017-00020 1
 
0.6%
43150-2017-00022 1
 
0.6%
43150-2017-00026 1
 
0.6%
43150-2017-00029 1
 
0.6%
43150-2017-00031 1
 
0.6%
Other values (167) 167
94.4%
2023-12-13T02:08:03.058852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 961
36.2%
- 354
 
13.3%
1 264
 
10.0%
3 231
 
8.7%
2 192
 
7.2%
4 138
 
5.2%
5 134
 
5.1%
8 113
 
4.3%
6 113
 
4.3%
74
 
2.8%
Other values (4) 78
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2218
83.6%
Dash Punctuation 354
 
13.3%
Other Letter 80
 
3.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 961
43.3%
1 264
 
11.9%
3 231
 
10.4%
2 192
 
8.7%
4 138
 
6.2%
5 134
 
6.0%
8 113
 
5.1%
6 113
 
5.1%
7 41
 
1.8%
9 31
 
1.4%
Other Letter
ValueCountFrequency (%)
74
92.5%
5
 
6.2%
1
 
1.2%
Dash Punctuation
ValueCountFrequency (%)
- 354
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2572
97.0%
Hangul 80
 
3.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 961
37.4%
- 354
 
13.8%
1 264
 
10.3%
3 231
 
9.0%
2 192
 
7.5%
4 138
 
5.4%
5 134
 
5.2%
8 113
 
4.4%
6 113
 
4.4%
7 41
 
1.6%
Hangul
ValueCountFrequency (%)
74
92.5%
5
 
6.2%
1
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2572
97.0%
Hangul 80
 
3.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 961
37.4%
- 354
 
13.8%
1 264
 
10.3%
3 231
 
9.0%
2 192
 
7.5%
4 138
 
5.4%
5 134
 
5.2%
8 113
 
4.4%
6 113
 
4.4%
7 41
 
1.6%
Hangul
ValueCountFrequency (%)
74
92.5%
5
 
6.2%
1
 
1.2%

중개업소명
Text

UNIQUE 

Distinct177
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T02:08:03.300560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10
Mean length10.80791
Min length7

Characters and Unicode

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

Unique

Unique177 ?
Unique (%)100.0%

Sample

1st row한일부동산중개인사무소
2nd row복터부동산중개인사무소
3rd row삼덕부동산중개인사무소
4th row미광부동산중개인사무소
5th row역전부동산중개인사무소
ValueCountFrequency (%)
한일부동산중개인사무소 1
 
0.6%
복돼지공인중개사사무소 1
 
0.6%
강저롯데캐슬공인중개사사무소 1
 
0.6%
부동산닥터공인중개사사무소 1
 
0.6%
부동산투데이공인중개사사무소 1
 
0.6%
복이레공인중개사사무소 1
 
0.6%
신세계공인중개사사무소 1
 
0.6%
마루공인중개사사무소 1
 
0.6%
필승공인중개사사무소 1
 
0.6%
동산공인중개사사무소 1
 
0.6%
Other values (168) 168
94.4%
2023-12-13T02:08:03.683186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
337
17.6%
179
9.4%
179
9.4%
177
9.3%
176
9.2%
169
8.8%
157
 
8.2%
44
 
2.3%
42
 
2.2%
41
 
2.1%
Other values (188) 412
21.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1902
99.4%
Decimal Number 6
 
0.3%
Uppercase Letter 4
 
0.2%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
337
17.7%
179
9.4%
179
9.4%
177
9.3%
176
9.3%
169
8.9%
157
 
8.3%
44
 
2.3%
42
 
2.2%
41
 
2.2%
Other values (181) 401
21.1%
Decimal Number
ValueCountFrequency (%)
1 4
66.7%
2 1
 
16.7%
4 1
 
16.7%
Uppercase Letter
ValueCountFrequency (%)
K 2
50.0%
S 1
25.0%
O 1
25.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1902
99.4%
Common 7
 
0.4%
Latin 4
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
337
17.7%
179
9.4%
179
9.4%
177
9.3%
176
9.3%
169
8.9%
157
 
8.3%
44
 
2.3%
42
 
2.2%
41
 
2.2%
Other values (181) 401
21.1%
Common
ValueCountFrequency (%)
1 4
57.1%
2 1
 
14.3%
4 1
 
14.3%
1
 
14.3%
Latin
ValueCountFrequency (%)
K 2
50.0%
S 1
25.0%
O 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1902
99.4%
ASCII 11
 
0.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
337
17.7%
179
9.4%
179
9.4%
177
9.3%
176
9.3%
169
8.9%
157
 
8.3%
44
 
2.3%
42
 
2.2%
41
 
2.2%
Other values (181) 401
21.1%
ASCII
ValueCountFrequency (%)
1 4
36.4%
K 2
18.2%
2 1
 
9.1%
4 1
 
9.1%
S 1
 
9.1%
1
 
9.1%
O 1
 
9.1%
Distinct172
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T02:08:04.024791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length41
Mean length24.954802
Min length18

Characters and Unicode

Total characters4417
Distinct characters158
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

Unique167 ?
Unique (%)94.4%

Sample

1st row충청북도 제천시 의림대로 49(명동)
2nd row충청북도 제천시 숭문로 3(서부동)
3rd row충청북도 제천시 내토로 459(화산동)
4th row충청북도 제천시 의림대로 25(영천동)
5th row충청북도 제천시 의림대로 37(영천동)
ValueCountFrequency (%)
충청북도 177
21.5%
제천시 177
21.5%
의림대로 15
 
1.8%
청전대로 7
 
0.8%
용두천로 7
 
0.8%
내토로 7
 
0.8%
의병대로 6
 
0.7%
칠성로 6
 
0.7%
청풍호로 6
 
0.7%
상가동 6
 
0.7%
Other values (317) 410
49.8%
2023-12-13T02:08:04.501589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
647
 
14.6%
227
 
5.1%
211
 
4.8%
189
 
4.3%
185
 
4.2%
181
 
4.1%
178
 
4.0%
177
 
4.0%
177
 
4.0%
172
 
3.9%
Other values (148) 2073
46.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2722
61.6%
Space Separator 647
 
14.6%
Decimal Number 641
 
14.5%
Open Punctuation 158
 
3.6%
Close Punctuation 158
 
3.6%
Other Punctuation 72
 
1.6%
Dash Punctuation 18
 
0.4%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
227
 
8.3%
211
 
7.8%
189
 
6.9%
185
 
6.8%
181
 
6.6%
178
 
6.5%
177
 
6.5%
177
 
6.5%
172
 
6.3%
61
 
2.2%
Other values (131) 964
35.4%
Decimal Number
ValueCountFrequency (%)
1 152
23.7%
2 112
17.5%
4 69
10.8%
3 67
10.5%
6 57
 
8.9%
0 55
 
8.6%
5 37
 
5.8%
9 33
 
5.1%
8 33
 
5.1%
7 26
 
4.1%
Other Punctuation
ValueCountFrequency (%)
, 69
95.8%
@ 3
 
4.2%
Space Separator
ValueCountFrequency (%)
647
100.0%
Open Punctuation
ValueCountFrequency (%)
( 158
100.0%
Close Punctuation
ValueCountFrequency (%)
) 158
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2722
61.6%
Common 1694
38.4%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
227
 
8.3%
211
 
7.8%
189
 
6.9%
185
 
6.8%
181
 
6.6%
178
 
6.5%
177
 
6.5%
177
 
6.5%
172
 
6.3%
61
 
2.2%
Other values (131) 964
35.4%
Common
ValueCountFrequency (%)
647
38.2%
( 158
 
9.3%
) 158
 
9.3%
1 152
 
9.0%
2 112
 
6.6%
, 69
 
4.1%
4 69
 
4.1%
3 67
 
4.0%
6 57
 
3.4%
0 55
 
3.2%
Other values (6) 150
 
8.9%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2722
61.6%
ASCII 1695
38.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
647
38.2%
( 158
 
9.3%
) 158
 
9.3%
1 152
 
9.0%
2 112
 
6.6%
, 69
 
4.1%
4 69
 
4.1%
3 67
 
4.0%
6 57
 
3.4%
0 55
 
3.2%
Other values (7) 151
 
8.9%
Hangul
ValueCountFrequency (%)
227
 
8.3%
211
 
7.8%
189
 
6.9%
185
 
6.8%
181
 
6.6%
178
 
6.5%
177
 
6.5%
177
 
6.5%
172
 
6.3%
61
 
2.2%
Other values (131) 964
35.4%
Distinct153
Distinct (%)86.4%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T02:08:04.852605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9943503
Min length2

Characters and Unicode

Total characters530
Distinct characters108
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

Unique139 ?
Unique (%)78.5%

Sample

1st row안*륜
2nd row안*천
3rd row오*조
4th row신*원
5th row주*규
ValueCountFrequency (%)
김*수 7
 
4.0%
이*숙 4
 
2.3%
김*선 3
 
1.7%
김*경 3
 
1.7%
김*환 3
 
1.7%
이*호 2
 
1.1%
박*영 2
 
1.1%
김*영 2
 
1.1%
김*일 2
 
1.1%
박*길 2
 
1.1%
Other values (143) 147
83.1%
2023-12-13T02:08:05.301448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 177
33.4%
39
 
7.4%
22
 
4.2%
16
 
3.0%
13
 
2.5%
12
 
2.3%
10
 
1.9%
9
 
1.7%
8
 
1.5%
8
 
1.5%
Other values (98) 216
40.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 353
66.6%
Other Punctuation 177
33.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
39
 
11.0%
22
 
6.2%
16
 
4.5%
13
 
3.7%
12
 
3.4%
10
 
2.8%
9
 
2.5%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (97) 209
59.2%
Other Punctuation
ValueCountFrequency (%)
* 177
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 353
66.6%
Common 177
33.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
39
 
11.0%
22
 
6.2%
16
 
4.5%
13
 
3.7%
12
 
3.4%
10
 
2.8%
9
 
2.5%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (97) 209
59.2%
Common
ValueCountFrequency (%)
* 177
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 353
66.6%
ASCII 177
33.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
* 177
100.0%
Hangul
ValueCountFrequency (%)
39
 
11.0%
22
 
6.2%
16
 
4.5%
13
 
3.7%
12
 
3.4%
10
 
2.8%
9
 
2.5%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (97) 209
59.2%

전화번호
Text

MISSING 

Distinct161
Distinct (%)96.4%
Missing10
Missing (%)5.6%
Memory size1.5 KiB
2023-12-13T02:08:05.504110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.005988
Min length12

Characters and Unicode

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

Unique158 ?
Unique (%)94.6%

Sample

1st row043-647-3202
2nd row043-647-0111
3rd row043-647-3369
4th row043-645-9112
5th row043-647-4613
ValueCountFrequency (%)
043-645-2360 3
 
1.8%
043-644-7885 3
 
1.8%
043-645-8955 3
 
1.8%
043-644-9714 1
 
0.6%
043-648-7300 1
 
0.6%
043-647-3202 1
 
0.6%
043-643-2489 1
 
0.6%
043-643-5907 1
 
0.6%
043-648-4080 1
 
0.6%
043-653-8945 1
 
0.6%
Other values (151) 151
90.4%
2023-12-13T02:08:05.846599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 387
19.3%
- 334
16.7%
0 273
13.6%
3 233
11.6%
6 218
10.9%
5 125
 
6.2%
8 98
 
4.9%
2 96
 
4.8%
9 83
 
4.1%
7 83
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1671
83.3%
Dash Punctuation 334
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 387
23.2%
0 273
16.3%
3 233
13.9%
6 218
13.0%
5 125
 
7.5%
8 98
 
5.9%
2 96
 
5.7%
9 83
 
5.0%
7 83
 
5.0%
1 75
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 334
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2005
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 387
19.3%
- 334
16.7%
0 273
13.6%
3 233
11.6%
6 218
10.9%
5 125
 
6.2%
8 98
 
4.9%
2 96
 
4.8%
9 83
 
4.1%
7 83
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2005
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 387
19.3%
- 334
16.7%
0 273
13.6%
3 233
11.6%
6 218
10.9%
5 125
 
6.2%
8 98
 
4.9%
2 96
 
4.8%
9 83
 
4.1%
7 83
 
4.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2022-01-07
177 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-01-07
2nd row2022-01-07
3rd row2022-01-07
4th row2022-01-07
5th row2022-01-07

Common Values

ValueCountFrequency (%)
2022-01-07 177
100.0%

Length

2023-12-13T02:08:05.996914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:08:06.080328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-01-07 177
100.0%

Missing values

2023-12-13T02:08:02.227006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:08:02.355944image/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나-38060000-1한일부동산중개인사무소충청북도 제천시 의림대로 49(명동)안*륜043-647-32022022-01-07
1나-38060000-4복터부동산중개인사무소충청북도 제천시 숭문로 3(서부동)안*천043-647-01112022-01-07
2나-38060000-8삼덕부동산중개인사무소충청북도 제천시 내토로 459(화산동)오*조043-647-33692022-01-07
3나-38060000-12미광부동산중개인사무소충청북도 제천시 의림대로 25(영천동)신*원043-645-91122022-01-07
4나-38060000-17역전부동산중개인사무소충청북도 제천시 의림대로 37(영천동)주*규043-647-46132022-01-07
5가-38060000-20백운부동산중개인사무소충청북도 제천시 백운면 구학산로3길 24-1안*혁043-647-62192022-01-07
6가-38060000-28금강부동산중개인사무소충청북도 제천시 성봉로4길 3-10(청전동)이*규043-645-79162022-01-07
7가-38060000-44하우징컨설팅부동산중개인사무소충청북도 제천시 청전대로12길 3(청전동)강*순043-643-99742022-01-07
8가-38060000-41대도부동산중개인사무소충청북도 제천시 용두천로19길 2(중앙로2가)홍*식043-652-70462022-01-07
9가-38060000-42송학부동산중개인사무소충청북도 제천시 송학면 옥천길 1권*수043-644-43902022-01-07
등록번호중개업소명사무소주소(도로명)대표자전화번호데이터기준일자
16743150-2021-00007미당창공인중개사사무소충청북도 제천시 봉양읍 용두대로36길 5-13장*현<NA>2022-01-07
16843150-2021-00008킹덤공인중개사사무소충청북도 제천시 칠성로 26(청전동)김*범043-644-26262022-01-07
16943150-2021-00009두리공인중개사사무소충청북도 제천시 의병대로 247, 1층(신백동)최*애<NA>2022-01-07
17043150-2021-00010청풍부동산공인중개사사무소충청북도 제천시 금성면 청풍호로 1029이*호<NA>2022-01-07
17143150-2021-00011배리굿공인중개사사무소충청북도 제천시 원뜰로 25, 근린생활시설동 지하 1층 B14호(천남동, 제천 신원아침도시 더퍼스트)김*영043-920-03062022-01-07
17243150-2021-00012백송공인중개사사무소충청북도 제천시 내토로 291, 102호(천남동)김*임043-644-97142022-01-07
17343150-2021-00013해성공인중개사사무소충청북도 제천시 의림대로 324, 1층(청전동)장*옥043-647-00042022-01-07
17443150-2021-00014홍대공인중개사사무소충청북도 제천시 청전대로 122(청전동)조*형<NA>2022-01-07
17543150-2021-00015유성공인중개사사무소충청북도 제천시 용두천로 158, 1층(교동)성*원<NA>2022-01-07
17643150-2022-00001대경공인중개사사무소충청북도 제천시 신죽하로 83-5, 서진상가 104호(장락동)정*재043-643-00702022-01-07