Overview

Dataset statistics

Number of variables5
Number of observations975
Missing cells105
Missing cells (%)2.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory38.2 KiB
Average record size in memory40.1 B

Variable types

Text3
DateTime2

Dataset

Description대전광역시 유성구 관내 부동산 중개업소 현황에 대한 데이터로 등록번호, 상호, 소재지도로명주소, 등록일자 등의 항목을 제공합니다.
Author대전광역시 유성구
URLhttps://www.data.go.kr/data/15012337/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
데이터기준일자 has 105 (10.8%) missing valuesMissing
등록번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:40:06.902490
Analysis finished2023-12-12 08:40:07.564570
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록번호
Text

UNIQUE 

Distinct975
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size7.7 KiB
2023-12-12T17:40:07.731986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length13.470769
Min length4

Characters and Unicode

Total characters13134
Distinct characters17
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

Unique975 ?
Unique (%)100.0%

Sample

1st row30200-2009-2515
2nd row30200-2015-00007
3rd row30200-2015-00017
4th row30200-2015-00022
5th row30200-2015-00030
ValueCountFrequency (%)
유성구 202
 
17.2%
3556 1
 
0.1%
3262 1
 
0.1%
2165 1
 
0.1%
3084호 1
 
0.1%
3110 1
 
0.1%
3180 1
 
0.1%
3183 1
 
0.1%
3200 1
 
0.1%
3226 1
 
0.1%
Other values (966) 966
82.1%
2023-12-12T17:40:08.202058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 4548
34.6%
2 2047
15.6%
- 1284
 
9.8%
3 1004
 
7.6%
1 984
 
7.5%
유 333
 
2.5%
구 333
 
2.5%
성 333
 
2.5%
5 305
 
2.3%
7 285
 
2.2%
Other values (7) 1678
 
12.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 10207
77.7%
Other Letter 1441
 
11.0%
Dash Punctuation 1284
 
9.8%
Space Separator 202
 
1.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 4548
44.6%
2 2047
20.1%
3 1004
 
9.8%
1 984
 
9.6%
5 305
 
3.0%
7 285
 
2.8%
8 278
 
2.7%
6 260
 
2.5%
9 252
 
2.5%
4 244
 
2.4%
Other Letter
ValueCountFrequency (%)
유 333
23.1%
구 333
23.1%
성 333
23.1%
호 227
15.8%
제 215
14.9%
Dash Punctuation
ValueCountFrequency (%)
- 1284
100.0%
Space Separator
ValueCountFrequency (%)
202
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 11693
89.0%
Hangul 1441
 
11.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 4548
38.9%
2 2047
17.5%
- 1284
 
11.0%
3 1004
 
8.6%
1 984
 
8.4%
5 305
 
2.6%
7 285
 
2.4%
8 278
 
2.4%
6 260
 
2.2%
9 252
 
2.2%
Other values (2) 446
 
3.8%
Hangul
ValueCountFrequency (%)
유 333
23.1%
구 333
23.1%
성 333
23.1%
호 227
15.8%
제 215
14.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 11693
89.0%
Hangul 1441
 
11.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 4548
38.9%
2 2047
17.5%
- 1284
 
11.0%
3 1004
 
8.6%
1 984
 
8.4%
5 305
 
2.6%
7 285
 
2.4%
8 278
 
2.4%
6 260
 
2.2%
9 252
 
2.2%
Other values (2) 446
 
3.8%
Hangul
ValueCountFrequency (%)
유 333
23.1%
구 333
23.1%
성 333
23.1%
호 227
15.8%
제 215
14.9%

상호
Text

Distinct972
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size7.7 KiB
2023-12-12T17:40:08.485129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length20
Mean length11.833846
Min length5

Characters and Unicode

Total characters11538
Distinct characters399
Distinct categories9 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique969 ?
Unique (%)99.4%

Sample

1st row성수공인중개사사무소
2nd row해랑숲공인중개사사무소
3rd row세종SK공인중개사사무소
4th row효성공인중개사사무소
5th row예미지죽동공인중개사사무소
ValueCountFrequency (%)
신도공인중개사사무소 2
 
0.2%
공인중개사 2
 
0.2%
공인중개사사무소 2
 
0.2%
사무소 2
 
0.2%
계룡공인중개사사무소 2
 
0.2%
대덕공인중개사사무소 2
 
0.2%
한양공인중개사사무소 2
 
0.2%
신성푸르지오공인중개사사무소 1
 
0.1%
오투그랑공인중개사사무소 1
 
0.1%
스마트리치공인중개사사무소 1
 
0.1%
Other values (966) 966
98.3%
2023-12-12T17:40:08.952798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 1906
16.5%
중 979
 
8.5%
개 977
 
8.5%
인 969
 
8.4%
소 954
 
8.3%
무 949
 
8.2%
공 943
 
8.2%
동 135
 
1.2%
부 124
 
1.1%
산 112
 
1.0%
Other values (389) 3490
30.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11343
98.3%
Decimal Number 71
 
0.6%
Uppercase Letter 63
 
0.5%
Lowercase Letter 31
 
0.3%
Space Separator 8
 
0.1%
Close Punctuation 7
 
0.1%
Open Punctuation 7
 
0.1%
Dash Punctuation 4
 
< 0.1%
Other Punctuation 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 1906
16.8%
중 979
 
8.6%
개 977
 
8.6%
인 969
 
8.5%
소 954
 
8.4%
무 949
 
8.4%
공 943
 
8.3%
동 135
 
1.2%
부 124
 
1.1%
산 112
 
1.0%
Other values (349) 3295
29.0%
Uppercase Letter
ValueCountFrequency (%)
K 15
23.8%
S 8
12.7%
T 6
 
9.5%
N 5
 
7.9%
B 4
 
6.3%
P 4
 
6.3%
R 3
 
4.8%
A 3
 
4.8%
C 3
 
4.8%
E 3
 
4.8%
Other values (6) 9
14.3%
Lowercase Letter
ValueCountFrequency (%)
e 13
41.9%
h 5
 
16.1%
a 3
 
9.7%
w 3
 
9.7%
s 3
 
9.7%
n 1
 
3.2%
p 1
 
3.2%
y 1
 
3.2%
m 1
 
3.2%
Decimal Number
ValueCountFrequency (%)
1 35
49.3%
4 12
 
16.9%
2 10
 
14.1%
5 5
 
7.0%
7 4
 
5.6%
3 2
 
2.8%
8 2
 
2.8%
9 1
 
1.4%
Other Punctuation
ValueCountFrequency (%)
. 2
50.0%
& 1
25.0%
/ 1
25.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11342
98.3%
Common 101
 
0.9%
Latin 94
 
0.8%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 1906
16.8%
중 979
 
8.6%
개 977
 
8.6%
인 969
 
8.5%
소 954
 
8.4%
무 949
 
8.4%
공 943
 
8.3%
동 135
 
1.2%
부 124
 
1.1%
산 112
 
1.0%
Other values (348) 3294
29.0%
Latin
ValueCountFrequency (%)
K 15
16.0%
e 13
13.8%
S 8
 
8.5%
T 6
 
6.4%
N 5
 
5.3%
h 5
 
5.3%
B 4
 
4.3%
P 4
 
4.3%
R 3
 
3.2%
a 3
 
3.2%
Other values (15) 28
29.8%
Common
ValueCountFrequency (%)
1 35
34.7%
4 12
 
11.9%
2 10
 
9.9%
8
 
7.9%
) 7
 
6.9%
( 7
 
6.9%
5 5
 
5.0%
- 4
 
4.0%
7 4
 
4.0%
3 2
 
2.0%
Other values (5) 7
 
6.9%
Han
ValueCountFrequency (%)
美 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11342
98.3%
ASCII 195
 
1.7%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 1906
16.8%
중 979
 
8.6%
개 977
 
8.6%
인 969
 
8.5%
소 954
 
8.4%
무 949
 
8.4%
공 943
 
8.3%
동 135
 
1.2%
부 124
 
1.1%
산 112
 
1.0%
Other values (348) 3294
29.0%
ASCII
ValueCountFrequency (%)
1 35
17.9%
K 15
 
7.7%
e 13
 
6.7%
4 12
 
6.2%
2 10
 
5.1%
8
 
4.1%
S 8
 
4.1%
) 7
 
3.6%
( 7
 
3.6%
T 6
 
3.1%
Other values (30) 74
37.9%
CJK
ValueCountFrequency (%)
美 1
100.0%

소재지주소
Text

Distinct906
Distinct (%)92.9%
Missing0
Missing (%)0.0%
Memory size7.7 KiB
2023-12-12T17:40:09.283198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length45
Mean length34.908718
Min length16

Characters and Unicode

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

Unique

Unique843 ?
Unique (%)86.5%

Sample

1st row대전광역시 유성구 은구비서로 25(지족동)
2nd row대전광역시 유성구 지족로 240, 상가동 104호(지족동, 노은해랑숲마을5단지아파트)
3rd row대전광역시 유성구 은구비남로 13, 111호(지족동, SK허브)
4th row대전광역시 유성구 엑스포로123번길 65-38, 204동 123호(도룡동, 스마트시티)
5th row대전광역시 유성구 죽동로 321, 단지내상가 106호(죽동, 예미지아파트)
ValueCountFrequency (%)
대전광역시 975
 
17.3%
유성구 975
 
17.3%
상가동 204
 
3.6%
상가 44
 
0.8%
상대복용로29번길 32
 
0.6%
1층 28
 
0.5%
101호 25
 
0.4%
지족동 24
 
0.4%
51 24
 
0.4%
1층(구암동 24
 
0.4%
Other values (1346) 3268
58.1%
2023-12-12T17:40:09.756968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4648
 
13.7%
1 1656
 
4.9%
대 1420
 
4.2%
동 1327
 
3.9%
, 1239
 
3.6%
성 1123
 
3.3%
구 1112
 
3.3%
시 1077
 
3.2%
유 1077
 
3.2%
전 1056
 
3.1%
Other values (290) 18301
53.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 20193
59.3%
Decimal Number 5691
 
16.7%
Space Separator 4648
 
13.7%
Other Punctuation 1254
 
3.7%
Open Punctuation 975
 
2.9%
Close Punctuation 975
 
2.9%
Dash Punctuation 215
 
0.6%
Uppercase Letter 73
 
0.2%
Lowercase Letter 12
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 1420
 
7.0%
동 1327
 
6.6%
성 1123
 
5.6%
구 1112
 
5.5%
시 1077
 
5.3%
유 1077
 
5.3%
전 1056
 
5.2%
광 981
 
4.9%
역 975
 
4.8%
로 948
 
4.7%
Other values (255) 9097
45.1%
Uppercase Letter
ValueCountFrequency (%)
B 15
20.5%
C 11
15.1%
S 8
11.0%
K 8
11.0%
A 7
9.6%
D 5
 
6.8%
V 4
 
5.5%
W 4
 
5.5%
E 3
 
4.1%
T 2
 
2.7%
Other values (4) 6
 
8.2%
Decimal Number
ValueCountFrequency (%)
1 1656
29.1%
2 764
13.4%
0 733
12.9%
3 492
 
8.6%
5 467
 
8.2%
6 417
 
7.3%
4 378
 
6.6%
7 279
 
4.9%
9 264
 
4.6%
8 241
 
4.2%
Lowercase Letter
ValueCountFrequency (%)
n 4
33.3%
a 2
16.7%
o 2
16.7%
t 2
16.7%
w 2
16.7%
Other Punctuation
ValueCountFrequency (%)
, 1239
98.8%
@ 15
 
1.2%
Space Separator
ValueCountFrequency (%)
4648
100.0%
Open Punctuation
ValueCountFrequency (%)
( 975
100.0%
Close Punctuation
ValueCountFrequency (%)
) 975
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 215
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 20193
59.3%
Common 13758
40.4%
Latin 85
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 1420
 
7.0%
동 1327
 
6.6%
성 1123
 
5.6%
구 1112
 
5.5%
시 1077
 
5.3%
유 1077
 
5.3%
전 1056
 
5.2%
광 981
 
4.9%
역 975
 
4.8%
로 948
 
4.7%
Other values (255) 9097
45.1%
Latin
ValueCountFrequency (%)
B 15
17.6%
C 11
12.9%
S 8
9.4%
K 8
9.4%
A 7
8.2%
D 5
 
5.9%
V 4
 
4.7%
n 4
 
4.7%
W 4
 
4.7%
E 3
 
3.5%
Other values (9) 16
18.8%
Common
ValueCountFrequency (%)
4648
33.8%
1 1656
 
12.0%
, 1239
 
9.0%
( 975
 
7.1%
) 975
 
7.1%
2 764
 
5.6%
0 733
 
5.3%
3 492
 
3.6%
5 467
 
3.4%
6 417
 
3.0%
Other values (6) 1392
 
10.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 20193
59.3%
ASCII 13843
40.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4648
33.6%
1 1656
 
12.0%
, 1239
 
9.0%
( 975
 
7.0%
) 975
 
7.0%
2 764
 
5.5%
0 733
 
5.3%
3 492
 
3.6%
5 467
 
3.4%
6 417
 
3.0%
Other values (25) 1477
 
10.7%
Hangul
ValueCountFrequency (%)
대 1420
 
7.0%
동 1327
 
6.6%
성 1123
 
5.6%
구 1112
 
5.5%
시 1077
 
5.3%
유 1077
 
5.3%
전 1056
 
5.2%
광 981
 
4.9%
역 975
 
4.8%
로 948
 
4.7%
Other values (255) 9097
45.1%

등록일자
Date

Distinct781
Distinct (%)80.1%
Missing0
Missing (%)0.0%
Memory size7.7 KiB
Minimum1984-05-29 00:00:00
Maximum2022-08-17 00:00:00
2023-12-12T17:40:09.893248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:40:10.091028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)0.1%
Missing105
Missing (%)10.8%
Memory size7.7 KiB
Minimum2022-08-18 00:00:00
Maximum2022-08-18 00:00:00
2023-12-12T17:40:10.232116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:40:10.332381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T17:40:07.376207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:40:07.498871image/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

등록번호상호소재지주소등록일자데이터기준일자
030200-2009-2515성수공인중개사사무소대전광역시 유성구 은구비서로 25(지족동)2009-11-112022-08-18
130200-2015-00007해랑숲공인중개사사무소대전광역시 유성구 지족로 240, 상가동 104호(지족동, 노은해랑숲마을5단지아파트)2014-10-082022-08-18
230200-2015-00017세종SK공인중개사사무소대전광역시 유성구 은구비남로 13, 111호(지족동, SK허브)2015-01-282022-08-18
330200-2015-00022효성공인중개사사무소대전광역시 유성구 엑스포로123번길 65-38, 204동 123호(도룡동, 스마트시티)2015-01-302022-08-18
430200-2015-00030예미지죽동공인중개사사무소대전광역시 유성구 죽동로 321, 단지내상가 106호(죽동, 예미지아파트)2010-12-022022-08-18
530200-2015-00035올래공인중개사사무소대전광역시 유성구 덕명로81번길 3, 1층(덕명동)2015-02-232022-08-18
630200-2015-00040테크노밸리공인중개사사무소대전광역시 유성구 테크노중앙로 62, 상가동 101호(관평동, 새롬빌딩)2015-02-252022-08-18
730200-2015-00042송림공인중개사사무소대전광역시 유성구 노은로426번길 15, 상가동 101호(하기동, 송림마을6단지)2015-03-022022-08-18
830200-2015-00048신천하제일공인중개사사무소대전광역시 유성구 엑스포로 465, 1층(전민동)2015-03-102022-08-18
930200-2015-00051누리공인중개사사무소대전광역시 유성구 유성대로719번길 13(장대동)2015-03-202022-08-18
등록번호상호소재지주소등록일자데이터기준일자
965유성구제85호시티공인중개사사무소대전광역시 유성구 어은로 57, 202호 (어은동, 한빛프라자)1997-03-052022-08-18
966유성구제870호이상호부동산컨설팅공인중개사사무소대전광역시 유성구 유성대로654번길 150, 102호 (구암동)2003-04-232022-08-18
967유성구제878월드코아공인중개사사무소대전광역시 유성구 은구비로 36, 102-B호2003-05-152022-08-18
968유성구제890호김윤길공인중개사사무소대전광역시 유성구 대학로 225(어은동)2003-05-282022-08-18
969유성구제905호도룡미소SK써브공인중개사사무소대전광역시 유성구 가정로 306-6, B103호(도룡동, 도룡 SK VIEW)2003-06-092022-08-18
970유성구제907호준호공인중개사대전광역시 유성구 구암동 589-82002-12-182022-08-18
971유성구제909호RG 공인중개사대전광역시 유성구 송강동 187-82003-06-112022-08-18
972유성구제967호왕선공인중개사대전광역시 유성구 노은동 552-3 열매마을11단지상가104호2003-08-212022-08-18
973유성구제985호대덕공인중개사사무소대전광역시 유성구 가정로 87, 1층 (신성동)2001-09-182022-08-18
974유성구제995호현대열매공인중개사대전광역시 유성구 지족동 880 열매마을6단지 상가 103호2003-09-252022-08-18