Overview

Dataset statistics

Number of variables5
Number of observations71
Missing cells26
Missing cells (%)7.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.9 KiB
Average record size in memory41.9 B

Variable types

Text4
Categorical1

Dataset

Description전라북도 정읍시 소재한 부동산 중개업소 현황중(상호, 허가번호, 소재지도로명주소, 전화번호 )등의 자료를 제공합니다.
Author전라북도 정읍시
URLhttps://www.data.go.kr/data/3080120/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 26 (36.6%) missing valuesMissing
상호 has unique valuesUnique
허가번호 has unique valuesUnique
소재지도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:12:12.189604
Analysis finished2023-12-12 11:12:15.821362
Duration3.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

UNIQUE 

Distinct71
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size700.0 B
2023-12-12T20:12:16.137895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10
Mean length10.56338
Min length7

Characters and Unicode

Total characters750
Distinct characters107
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

Unique71 ?
Unique (%)100.0%

Sample

1st row공인중개사금강사무소
2nd row동신공인중개사사무소
3rd row신태인공인중개사사무소
4th row청미래공인중개사사무소
5th row대한공인중개사김인옥사무소
ValueCountFrequency (%)
사무소 7
 
8.6%
공인중개사 3
 
3.7%
공인중개사금강사무소 1
 
1.2%
풍전공인중개사사무소 1
 
1.2%
한솔공인중개사사무소 1
 
1.2%
신흥공인중개사사무소 1
 
1.2%
조아공인중개사사무소 1
 
1.2%
좋은터공인중개사사무소 1
 
1.2%
정읍제일부동산공인중개사사무소 1
 
1.2%
토지박사부동산중개 1
 
1.2%
Other values (63) 63
77.8%
2023-12-12T20:12:16.902566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 133
17.7%
개 73
9.7%
중 71
9.5%
인 69
9.2%
무 69
9.2%
소 69
9.2%
공 62
 
8.3%
동 15
 
2.0%
부 13
 
1.7%
산 12
 
1.6%
Other values (97) 164
21.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 736
98.1%
Space Separator 10
 
1.3%
Uppercase Letter 2
 
0.3%
Lowercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 133
18.1%
개 73
9.9%
중 71
9.6%
인 69
9.4%
무 69
9.4%
소 69
9.4%
공 62
8.4%
동 15
 
2.0%
부 13
 
1.8%
산 12
 
1.6%
Other values (92) 150
20.4%
Uppercase Letter
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%
Lowercase Letter
ValueCountFrequency (%)
n 1
50.0%
i 1
50.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 736
98.1%
Common 10
 
1.3%
Latin 4
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 133
18.1%
개 73
9.9%
중 71
9.6%
인 69
9.4%
무 69
9.4%
소 69
9.4%
공 62
8.4%
동 15
 
2.0%
부 13
 
1.8%
산 12
 
1.6%
Other values (92) 150
20.4%
Latin
ValueCountFrequency (%)
O 1
25.0%
K 1
25.0%
n 1
25.0%
i 1
25.0%
Common
ValueCountFrequency (%)
10
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 736
98.1%
ASCII 14
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 133
18.1%
개 73
9.9%
중 71
9.6%
인 69
9.4%
무 69
9.4%
소 69
9.4%
공 62
8.4%
동 15
 
2.0%
부 13
 
1.8%
산 12
 
1.6%
Other values (92) 150
20.4%
ASCII
ValueCountFrequency (%)
10
71.4%
O 1
 
7.1%
K 1
 
7.1%
n 1
 
7.1%
i 1
 
7.1%

허가번호
Text

UNIQUE 

Distinct71
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size700.0 B
2023-12-12T20:12:17.331631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length12.873239
Min length7

Characters and Unicode

Total characters914
Distinct characters13
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

Unique71 ?
Unique (%)100.0%

Sample

1st row가1717-11
2nd row가1717-38
3rd row가1717-56
4th row가1717-64
5th row가1717-72
ValueCountFrequency (%)
가1717-11 1
 
1.4%
45180-2019-00005 1
 
1.4%
45180-2019-00002 1
 
1.4%
45180-2019-00001 1
 
1.4%
45180-2018-00015 1
 
1.4%
45180-2018-00014 1
 
1.4%
45180-2018-00013 1
 
1.4%
45180-2018-00011 1
 
1.4%
45180-2018-00006 1
 
1.4%
45180-2017-00004 1
 
1.4%
Other values (61) 61
85.9%
2023-12-12T20:12:18.105612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 254
27.8%
1 177
19.4%
- 113
12.4%
7 74
 
8.1%
2 60
 
6.6%
8 58
 
6.3%
5 57
 
6.2%
4 50
 
5.5%
가 24
 
2.6%
9 20
 
2.2%
Other values (3) 27
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 772
84.5%
Dash Punctuation 113
 
12.4%
Other Letter 29
 
3.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 254
32.9%
1 177
22.9%
7 74
 
9.6%
2 60
 
7.8%
8 58
 
7.5%
5 57
 
7.4%
4 50
 
6.5%
9 20
 
2.6%
6 15
 
1.9%
3 7
 
0.9%
Other Letter
ValueCountFrequency (%)
가 24
82.8%
나 5
 
17.2%
Dash Punctuation
ValueCountFrequency (%)
- 113
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 885
96.8%
Hangul 29
 
3.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 254
28.7%
1 177
20.0%
- 113
12.8%
7 74
 
8.4%
2 60
 
6.8%
8 58
 
6.6%
5 57
 
6.4%
4 50
 
5.6%
9 20
 
2.3%
6 15
 
1.7%
Hangul
ValueCountFrequency (%)
가 24
82.8%
나 5
 
17.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 885
96.8%
Hangul 29
 
3.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 254
28.7%
1 177
20.0%
- 113
12.8%
7 74
 
8.4%
2 60
 
6.8%
8 58
 
6.6%
5 57
 
6.4%
4 50
 
5.6%
9 20
 
2.3%
6 15
 
1.7%
Hangul
ValueCountFrequency (%)
가 24
82.8%
나 5
 
17.2%

소재지도로명주소
Text

UNIQUE 

Distinct71
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size700.0 B
2023-12-12T20:12:18.835417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length28
Mean length18.394366
Min length15

Characters and Unicode

Total characters1306
Distinct characters83
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

Unique71 ?
Unique (%)100.0%

Sample

1st row전라북도 정읍시 충정로 136
2nd row전라북도 정읍시 중앙로 259
3rd row전라북도 정읍시 신태인읍 신태인중앙로 59, 1층 1호
4th row전라북도 정읍시 신태인읍 신태인중앙로 9
5th row전라북도 정읍시 수성2로 15
ValueCountFrequency (%)
전라북도 71
23.2%
정읍시 71
23.2%
충정로 15
 
4.9%
중앙로 10
 
3.3%
샘골로 8
 
2.6%
학산로 6
 
2.0%
1층 3
 
1.0%
수성2로 3
 
1.0%
174 2
 
0.7%
정읍남로 2
 
0.7%
Other values (102) 115
37.6%
2023-12-12T20:12:19.939853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
235
18.0%
정 92
 
7.0%
읍 78
 
6.0%
북 73
 
5.6%
도 72
 
5.5%
시 72
 
5.5%
전 71
 
5.4%
라 71
 
5.4%
1 65
 
5.0%
로 60
 
4.6%
Other values (73) 417
31.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 810
62.0%
Space Separator 235
 
18.0%
Decimal Number 227
 
17.4%
Dash Punctuation 18
 
1.4%
Other Punctuation 10
 
0.8%
Close Punctuation 3
 
0.2%
Open Punctuation 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 92
11.4%
읍 78
9.6%
북 73
 
9.0%
도 72
 
8.9%
시 72
 
8.9%
전 71
 
8.8%
라 71
 
8.8%
로 60
 
7.4%
중 17
 
2.1%
충 15
 
1.9%
Other values (58) 189
23.3%
Decimal Number
ValueCountFrequency (%)
1 65
28.6%
2 25
 
11.0%
9 21
 
9.3%
3 20
 
8.8%
0 19
 
8.4%
6 17
 
7.5%
4 17
 
7.5%
5 15
 
6.6%
8 14
 
6.2%
7 14
 
6.2%
Space Separator
ValueCountFrequency (%)
235
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Other Punctuation
ValueCountFrequency (%)
, 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 810
62.0%
Common 496
38.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 92
11.4%
읍 78
9.6%
북 73
 
9.0%
도 72
 
8.9%
시 72
 
8.9%
전 71
 
8.8%
라 71
 
8.8%
로 60
 
7.4%
중 17
 
2.1%
충 15
 
1.9%
Other values (58) 189
23.3%
Common
ValueCountFrequency (%)
235
47.4%
1 65
 
13.1%
2 25
 
5.0%
9 21
 
4.2%
3 20
 
4.0%
0 19
 
3.8%
- 18
 
3.6%
6 17
 
3.4%
4 17
 
3.4%
5 15
 
3.0%
Other values (5) 44
 
8.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 810
62.0%
ASCII 496
38.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
235
47.4%
1 65
 
13.1%
2 25
 
5.0%
9 21
 
4.2%
3 20
 
4.0%
0 19
 
3.8%
- 18
 
3.6%
6 17
 
3.4%
4 17
 
3.4%
5 15
 
3.0%
Other values (5) 44
 
8.9%
Hangul
ValueCountFrequency (%)
정 92
11.4%
읍 78
9.6%
북 73
 
9.0%
도 72
 
8.9%
시 72
 
8.9%
전 71
 
8.8%
라 71
 
8.8%
로 60
 
7.4%
중 17
 
2.1%
충 15
 
1.9%
Other values (58) 189
23.3%

전화번호
Text

MISSING 

Distinct45
Distinct (%)100.0%
Missing26
Missing (%)36.6%
Memory size700.0 B
2023-12-12T20:12:20.302518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row063-535-5243
2nd row063-571-8600
3rd row063-571-5713
4th row063-536-8589
5th row063-536-8864
ValueCountFrequency (%)
063-538-7275 1
 
2.2%
063-536-3455 1
 
2.2%
063-244-2244 1
 
2.2%
063-533-7770 1
 
2.2%
063-535-1888 1
 
2.2%
063-538-9311 1
 
2.2%
063-532-0089 1
 
2.2%
063-536-0913 1
 
2.2%
063-533-1472 1
 
2.2%
063-538-8007 1
 
2.2%
Other values (35) 35
77.8%
2023-12-12T20:12:20.901614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 104
19.3%
- 90
16.7%
5 73
13.5%
0 72
13.3%
6 65
12.0%
7 28
 
5.2%
8 26
 
4.8%
1 26
 
4.8%
4 24
 
4.4%
2 18
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 450
83.3%
Dash Punctuation 90
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 104
23.1%
5 73
16.2%
0 72
16.0%
6 65
14.4%
7 28
 
6.2%
8 26
 
5.8%
1 26
 
5.8%
4 24
 
5.3%
2 18
 
4.0%
9 14
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 540
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 104
19.3%
- 90
16.7%
5 73
13.5%
0 72
13.3%
6 65
12.0%
7 28
 
5.2%
8 26
 
4.8%
1 26
 
4.8%
4 24
 
4.4%
2 18
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 540
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 104
19.3%
- 90
16.7%
5 73
13.5%
0 72
13.3%
6 65
12.0%
7 28
 
5.2%
8 26
 
4.8%
1 26
 
4.8%
4 24
 
4.4%
2 18
 
3.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size700.0 B
2021-12-16
71 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-12-16
2nd row2021-12-16
3rd row2021-12-16
4th row2021-12-16
5th row2021-12-16

Common Values

ValueCountFrequency (%)
2021-12-16 71
100.0%

Length

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

Common Values (Plot)

2023-12-12T20:12:21.347653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-12-16 71
100.0%

Correlations

2023-12-12T20:12:21.452518image/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-12T20:12:15.468632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:12:15.720861image/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공인중개사금강사무소가1717-11전라북도 정읍시 충정로 136<NA>2021-12-16
1동신공인중개사사무소가1717-38전라북도 정읍시 중앙로 259063-535-52432021-12-16
2신태인공인중개사사무소가1717-56전라북도 정읍시 신태인읍 신태인중앙로 59, 1층 1호063-571-86002021-12-16
3청미래공인중개사사무소가1717-64전라북도 정읍시 신태인읍 신태인중앙로 9063-571-57132021-12-16
4대한공인중개사김인옥사무소가1717-72전라북도 정읍시 수성2로 15063-536-85892021-12-16
5비전공인중개사 사무소가1717-77전라북도 정읍시 정인1길 23(수성동)<NA>2021-12-16
6참사랑공인중개사사무소가1717-79전라북도 정읍시 충정로 90<NA>2021-12-16
7길부동산중개사무소가1717-86전라북도 정읍시 수성2로 14063-536-88642021-12-16
8영훈공인중개사 사무소가1717-88전라북도 정읍시 충정로 231063-534-82822021-12-16
9정읍부동산중개사사무소가1717-89전라북도 정읍시 중앙로 61063-535-35202021-12-16
상호허가번호소재지도로명주소전화번호데이터기준일자
61드림공인중개사사무소45180-2020-00002전라북도 정읍시 학산로 103-18063-533-77442021-12-16
62수아공인중개사사무소45180-2020-00003전라북도 정읍시 수성택지4길 11-12, 101호063-536-49002021-12-16
63호원공인중개사사무소45180-2020-00004전라북도 정읍시 수성로 89063-537-72662021-12-16
64마트공인중개사사무소45180-2020-00005전라북도 정읍시 충정로 41<NA>2021-12-16
65칠보부동산중개인사무소나1717-9전라북도 정읍시 충정로 253-4<NA>2021-12-16
66개미부동산중개인사무소나1717-22전라북도 정읍시 충정로 212063-536-60002021-12-16
67홈런공인중개사사무소나1717-25전라북도 정읍시 학산로 112-1, 홈런공인중개사사무소063-536-25002021-12-16
68영원부동산중개인사무소나1717-41전라북도 정읍시 영원면 금곡1길 6063-536-27592021-12-16
69정읍뜰중개인사무소나1717-42전라북도 정읍시 초산로 19063-531-16002021-12-16
70대동부동산중개인사무소45180-2015-00005전라북도 정읍시 중앙로 17063-535-88712021-12-16