Overview

Dataset statistics

Number of variables6
Number of observations1929
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory90.6 KiB
Average record size in memory48.1 B

Variable types

Text3
DateTime2
Categorical1

Dataset

Description제주특별자치도 내 소재하고 있는 부동산 중개업소의 등록번호, 상호명, 소재지, 등록일자, 상태 등 정보를 제공합니다.자세한 정보는 국가공간정보포털 (www.nsdi.go.kr/) 참고
Author제주특별자치도
URLhttps://www.data.go.kr/data/15010288/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
상태 is highly imbalanced (93.1%)Imbalance
등록번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:18:12.427984
Analysis finished2023-12-12 12:18:13.134469
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록번호
Text

UNIQUE 

Distinct1929
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2023-12-12T21:18:13.328738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length14.642302
Min length9

Characters and Unicode

Total characters28245
Distinct characters15
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

Unique1929 ?
Unique (%)100.0%

Sample

1st row50130-2018-00099
2nd row가-4404-426
3rd row50130-2022-00007
4th row50130-2017-00011
5th row50130-2018-00034
ValueCountFrequency (%)
50130-2018-00099 1
 
0.1%
50110-2016-00079 1
 
0.1%
50110-2018-00172 1
 
0.1%
50110-2019-00016 1
 
0.1%
50110-2022-00144 1
 
0.1%
가-4402-284 1
 
0.1%
가-4402-1042 1
 
0.1%
50110-2017-00119 1
 
0.1%
50110-2021-00142 1
 
0.1%
가-4402-573 1
 
0.1%
Other values (1919) 1919
99.5%
2023-12-12T21:18:13.895114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 9182
32.5%
1 4832
17.1%
- 3860
13.7%
2 3236
 
11.5%
5 1999
 
7.1%
4 1519
 
5.4%
3 850
 
3.0%
7 588
 
2.1%
6 579
 
2.0%
8 565
 
2.0%
Other values (5) 1035
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 23905
84.6%
Dash Punctuation 3860
 
13.7%
Other Letter 480
 
1.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 9182
38.4%
1 4832
20.2%
2 3236
 
13.5%
5 1999
 
8.4%
4 1519
 
6.4%
3 850
 
3.6%
7 588
 
2.5%
6 579
 
2.4%
8 565
 
2.4%
9 555
 
2.3%
Other Letter
ValueCountFrequency (%)
가 471
98.1%
나 7
 
1.5%
호 1
 
0.2%
라 1
 
0.2%
Dash Punctuation
ValueCountFrequency (%)
- 3860
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 27765
98.3%
Hangul 480
 
1.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 9182
33.1%
1 4832
17.4%
- 3860
13.9%
2 3236
 
11.7%
5 1999
 
7.2%
4 1519
 
5.5%
3 850
 
3.1%
7 588
 
2.1%
6 579
 
2.1%
8 565
 
2.0%
Hangul
ValueCountFrequency (%)
가 471
98.1%
나 7
 
1.5%
호 1
 
0.2%
라 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 27765
98.3%
Hangul 480
 
1.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 9182
33.1%
1 4832
17.4%
- 3860
13.9%
2 3236
 
11.7%
5 1999
 
7.2%
4 1519
 
5.5%
3 850
 
3.1%
7 588
 
2.1%
6 579
 
2.1%
8 565
 
2.0%
Hangul
ValueCountFrequency (%)
가 471
98.1%
나 7
 
1.5%
호 1
 
0.2%
라 1
 
0.2%

상호명
Text

Distinct1859
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2023-12-12T21:18:14.257372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length23
Mean length11.280456
Min length7

Characters and Unicode

Total characters21760
Distinct characters556
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1789 ?
Unique (%)92.7%

Sample

1st row제주도중문공인중개사사무소
2nd row평화부동산공인중개사사무소
3rd row가을공인중개사사무소
4th row해오름부동산공인중개사사무소
5th row혜안공인중개사사무소
ValueCountFrequency (%)
사무소 17
 
0.9%
공인중개사 16
 
0.8%
공인중개사사무소 5
 
0.3%
자연공인중개사사무소 2
 
0.1%
한라공인중개사사무소 2
 
0.1%
미듬공인중개사사무소 2
 
0.1%
이도공인중개사사무소 2
 
0.1%
대복공인중개사사무소 2
 
0.1%
우정공인중개사사무소 2
 
0.1%
가나공인중개사사무소 2
 
0.1%
Other values (1855) 1920
97.4%
2023-12-12T21:18:14.787426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 3584
16.5%
중 1952
 
9.0%
개 1939
 
8.9%
소 1831
 
8.4%
무 1827
 
8.4%
인 1787
 
8.2%
공 1749
 
8.0%
제 556
 
2.6%
주 551
 
2.5%
산 333
 
1.5%
Other values (546) 5651
26.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21404
98.4%
Uppercase Letter 110
 
0.5%
Decimal Number 75
 
0.3%
Lowercase Letter 57
 
0.3%
Space Separator 43
 
0.2%
Open Punctuation 26
 
0.1%
Close Punctuation 26
 
0.1%
Dash Punctuation 10
 
< 0.1%
Other Punctuation 7
 
< 0.1%
Modifier Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 3584
16.7%
중 1952
 
9.1%
개 1939
 
9.1%
소 1831
 
8.6%
무 1827
 
8.5%
인 1787
 
8.3%
공 1749
 
8.2%
제 556
 
2.6%
주 551
 
2.6%
산 333
 
1.6%
Other values (488) 5295
24.7%
Uppercase Letter
ValueCountFrequency (%)
J 16
14.5%
K 13
 
11.8%
L 8
 
7.3%
T 8
 
7.3%
O 7
 
6.4%
R 5
 
4.5%
I 5
 
4.5%
P 5
 
4.5%
H 5
 
4.5%
B 5
 
4.5%
Other values (13) 33
30.0%
Lowercase Letter
ValueCountFrequency (%)
e 23
40.4%
j 7
 
12.3%
i 4
 
7.0%
u 4
 
7.0%
h 4
 
7.0%
o 2
 
3.5%
c 2
 
3.5%
t 1
 
1.8%
y 1
 
1.8%
v 1
 
1.8%
Other values (8) 8
 
14.0%
Decimal Number
ValueCountFrequency (%)
1 26
34.7%
4 12
16.0%
6 9
 
12.0%
3 7
 
9.3%
2 7
 
9.3%
5 5
 
6.7%
8 3
 
4.0%
0 3
 
4.0%
9 2
 
2.7%
7 1
 
1.3%
Space Separator
ValueCountFrequency (%)
43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%
Other Punctuation
ValueCountFrequency (%)
& 7
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 21373
98.2%
Common 188
 
0.9%
Latin 167
 
0.8%
Han 32
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 3584
16.8%
중 1952
 
9.1%
개 1939
 
9.1%
소 1831
 
8.6%
무 1827
 
8.5%
인 1787
 
8.4%
공 1749
 
8.2%
제 556
 
2.6%
주 551
 
2.6%
산 333
 
1.6%
Other values (459) 5264
24.6%
Latin
ValueCountFrequency (%)
e 23
 
13.8%
J 16
 
9.6%
K 13
 
7.8%
L 8
 
4.8%
T 8
 
4.8%
j 7
 
4.2%
O 7
 
4.2%
R 5
 
3.0%
I 5
 
3.0%
P 5
 
3.0%
Other values (31) 70
41.9%
Han
ValueCountFrequency (%)
秀 2
 
6.2%
成 2
 
6.2%
新 1
 
3.1%
山 1
 
3.1%
廣 1
 
3.1%
瑞 1
 
3.1%
耽 1
 
3.1%
探 1
 
3.1%
那 1
 
3.1%
精 1
 
3.1%
Other values (20) 20
62.5%
Common
ValueCountFrequency (%)
43
22.9%
( 26
13.8%
) 26
13.8%
1 26
13.8%
4 12
 
6.4%
- 10
 
5.3%
6 9
 
4.8%
& 7
 
3.7%
3 7
 
3.7%
2 7
 
3.7%
Other values (6) 15
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 21372
98.2%
ASCII 355
 
1.6%
CJK 31
 
0.1%
CJK Compat Ideographs 1
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 3584
16.8%
중 1952
 
9.1%
개 1939
 
9.1%
소 1831
 
8.6%
무 1827
 
8.5%
인 1787
 
8.4%
공 1749
 
8.2%
제 556
 
2.6%
주 551
 
2.6%
산 333
 
1.6%
Other values (458) 5263
24.6%
ASCII
ValueCountFrequency (%)
43
 
12.1%
( 26
 
7.3%
) 26
 
7.3%
1 26
 
7.3%
e 23
 
6.5%
J 16
 
4.5%
K 13
 
3.7%
4 12
 
3.4%
- 10
 
2.8%
6 9
 
2.5%
Other values (47) 151
42.5%
CJK
ValueCountFrequency (%)
秀 2
 
6.5%
成 2
 
6.5%
新 1
 
3.2%
山 1
 
3.2%
廣 1
 
3.2%
瑞 1
 
3.2%
耽 1
 
3.2%
探 1
 
3.2%
那 1
 
3.2%
精 1
 
3.2%
Other values (19) 19
61.3%
CJK Compat Ideographs
ValueCountFrequency (%)
金 1
100.0%
None
ValueCountFrequency (%)
㈜ 1
100.0%

소재지
Text

Distinct1161
Distinct (%)60.2%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
2023-12-12T21:18:15.335770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length30
Mean length20.722136
Min length17

Characters and Unicode

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

Unique

Unique795 ?
Unique (%)41.2%

Sample

1st row제주특별자치도 서귀포시 1100로 178
2nd row제주특별자치도 서귀포시 516로 143
3rd row제주특별자치도 서귀포시 516로97번길 2
4th row제주특별자치도 서귀포시 516로97번길 2
5th row제주특별자치도 서귀포시 516로97번길 2
ValueCountFrequency (%)
제주특별자치도 1929
23.8%
제주시 1509
 
18.6%
서귀포시 420
 
5.2%
대정읍 81
 
1.0%
일주동로 77
 
0.9%
성산읍 55
 
0.7%
애월읍 53
 
0.7%
일주서로 45
 
0.6%
과원로 44
 
0.5%
안덕면 41
 
0.5%
Other values (1045) 3863
47.6%
2023-12-12T21:18:16.057383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6188
15.5%
주 3570
 
8.9%
제 3451
 
8.6%
도 1986
 
5.0%
시 1968
 
4.9%
특 1929
 
4.8%
별 1929
 
4.8%
자 1929
 
4.8%
치 1929
 
4.8%
로 1480
 
3.7%
Other values (182) 13614
34.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 27882
69.8%
Space Separator 6188
 
15.5%
Decimal Number 5664
 
14.2%
Dash Punctuation 239
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 3570
12.8%
제 3451
12.4%
도 1986
 
7.1%
시 1968
 
7.1%
특 1929
 
6.9%
별 1929
 
6.9%
자 1929
 
6.9%
치 1929
 
6.9%
로 1480
 
5.3%
길 784
 
2.8%
Other values (170) 6927
24.8%
Decimal Number
ValueCountFrequency (%)
1 1176
20.8%
2 808
14.3%
3 653
11.5%
4 626
11.1%
5 512
9.0%
7 424
 
7.5%
6 411
 
7.3%
8 379
 
6.7%
9 341
 
6.0%
0 334
 
5.9%
Space Separator
ValueCountFrequency (%)
6188
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 239
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 27882
69.8%
Common 12091
30.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 3570
12.8%
제 3451
12.4%
도 1986
 
7.1%
시 1968
 
7.1%
특 1929
 
6.9%
별 1929
 
6.9%
자 1929
 
6.9%
치 1929
 
6.9%
로 1480
 
5.3%
길 784
 
2.8%
Other values (170) 6927
24.8%
Common
ValueCountFrequency (%)
6188
51.2%
1 1176
 
9.7%
2 808
 
6.7%
3 653
 
5.4%
4 626
 
5.2%
5 512
 
4.2%
7 424
 
3.5%
6 411
 
3.4%
8 379
 
3.1%
9 341
 
2.8%
Other values (2) 573
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 27882
69.8%
ASCII 12091
30.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6188
51.2%
1 1176
 
9.7%
2 808
 
6.7%
3 653
 
5.4%
4 626
 
5.2%
5 512
 
4.2%
7 424
 
3.5%
6 411
 
3.4%
8 379
 
3.1%
9 341
 
2.8%
Other values (2) 573
 
4.7%
Hangul
ValueCountFrequency (%)
주 3570
12.8%
제 3451
12.4%
도 1986
 
7.1%
시 1968
 
7.1%
특 1929
 
6.9%
별 1929
 
6.9%
자 1929
 
6.9%
치 1929
 
6.9%
로 1480
 
5.3%
길 784
 
2.8%
Other values (170) 6927
24.8%

등록일자
Date

Distinct1106
Distinct (%)57.3%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
Minimum1984-06-15 00:00:00
Maximum2022-11-17 00:00:00
2023-12-12T21:18:16.289804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:18:16.523445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상태
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
영업
1913 
휴업
 
16

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업
2nd row영업
3rd row영업
4th row영업
5th row영업

Common Values

ValueCountFrequency (%)
영업 1913
99.2%
휴업 16
 
0.8%

Length

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

Common Values (Plot)

2023-12-12T21:18:16.850181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 1913
99.2%
휴업 16
 
0.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size15.2 KiB
Minimum2022-11-16 00:00:00
Maximum2022-11-16 00:00:00
2023-12-12T21:18:16.978545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:18:17.133920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T21:18:12.948883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:18:13.074707image/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

등록번호상호명소재지등록일자상태데이터기준일자
050130-2018-00099제주도중문공인중개사사무소제주특별자치도 서귀포시 1100로 1782011-11-18영업2022-11-16
1가-4404-426평화부동산공인중개사사무소제주특별자치도 서귀포시 516로 1432012-12-28영업2022-11-16
250130-2022-00007가을공인중개사사무소제주특별자치도 서귀포시 516로97번길 22022-01-18영업2022-11-16
350130-2017-00011해오름부동산공인중개사사무소제주특별자치도 서귀포시 516로97번길 22017-01-11영업2022-11-16
450130-2018-00034혜안공인중개사사무소제주특별자치도 서귀포시 516로97번길 22018-03-20영업2022-11-16
550130-2019-00114명문부동산중개사무소제주특별자치도 서귀포시 고근산로 322019-12-26영업2022-11-16
650130-2020-00069브릿지공인중개사사무소제주특별자치도 서귀포시 김정문화로 492020-12-07영업2022-11-16
750130-2017-00119114부동산공인중개사사무소제주특별자치도 서귀포시 김정문화로 602017-11-03영업2022-11-16
850130-2018-00012김진이공인중개사사무소제주특별자치도 서귀포시 김정문화로 602018-01-19영업2022-11-16
950130-2015-00055착한부동산공인중개사사무소제주특별자치도 서귀포시 김정문화로 642015-09-14영업2022-11-16
등록번호상호명소재지등록일자상태데이터기준일자
191950110-2021-00166흥운공인중개사사무소제주특별자치도 제주시 화삼로 1672021-12-14영업2022-11-16
192050110-2015-00002삼화지구공인중개사사무소제주특별자치도 제주시 화삼로 322015-01-05영업2022-11-16
192150110-2018-00119굿모닝공인중개사사무소제주특별자치도 제주시 화삼로 892018-03-20영업2022-11-16
1922가-4402-1624웰컴제주부동산공인중개사사무소제주특별자치도 제주시 화삼로1길 142014-10-24영업2022-11-16
192350110-2017-00015삼화드림부동산중개사무소제주특별자치도 제주시 화삼북로 1362017-01-05영업2022-11-16
1924가-4402-1491올레공인중개사사무소제주특별자치도 제주시 화삼북로 1362013-12-13영업2022-11-16
192550110-2016-00262삼화뉴타운공인중개사사무소제주특별자치도 제주시 화삼북로 72016-11-08영업2022-11-16
192650110-2017-00023현대봉공인중개사사무소제주특별자치도 제주시 화삼북로 872017-01-05영업2022-11-16
192750110-2022-00114하루부동산공인중개사사무소제주특별자치도 제주시 화삼북로 872022-05-25영업2022-11-16
192850110-2021-00009삼화골드공인중개사사무소제주특별자치도 제주시 화삼북로 902021-01-08영업2022-11-16