Overview

Dataset statistics

Number of variables4
Number of observations184
Missing cells63
Missing cells (%)8.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.9 KiB
Average record size in memory32.7 B

Variable types

Text3
DateTime1

Dataset

Description경상북도 김천시의 부동산 중개업소 현황 데이터로, 부동산중개업소명, 지번주소, 전화번호, 등록년월일 정보를 제공합니다.
Author경상북도 김천시
URLhttps://www.data.go.kr/data/3044158/fileData.do

Alerts

데이터기준일 has constant value ""Constant
전화 has 63 (34.2%) missing valuesMissing
상호명 has unique valuesUnique

Reproduction

Analysis started2024-04-17 17:33:39.163647
Analysis finished2024-04-17 17:33:39.460736
Duration0.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

UNIQUE 

Distinct184
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-04-18T02:33:39.580175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length16
Mean length10.940217
Min length7

Characters and Unicode

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

Unique

Unique184 ?
Unique (%)100.0%

Sample

1st row원탑공인중개사사무소
2nd row뉴코아루공인중개사사무소
3rd row한양공인중개사사무소
4th row박현주공인중개사사무소
5th row효천공인중개사사무소
ValueCountFrequency (%)
사무소 4
 
2.1%
원탑공인중개사사무소 1
 
0.5%
파랑새공인중개사사무소 1
 
0.5%
우정공인중개사사무소 1
 
0.5%
대한부동산중개사무소 1
 
0.5%
카카오공인중개사사무소 1
 
0.5%
부부공인중개사사무소 1
 
0.5%
터공인중개사사무소 1
 
0.5%
김천한솔부동산공인중개사사무소 1
 
0.5%
건국공인중개사사무소 1
 
0.5%
Other values (175) 175
93.1%
2024-04-18T02:33:39.828748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 360
17.9%
중 186
 
9.2%
개 185
 
9.2%
무 182
 
9.0%
소 181
 
9.0%
인 178
 
8.8%
공 174
 
8.6%
동 25
 
1.2%
부 22
 
1.1%
산 21
 
1.0%
Other values (204) 499
24.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1990
98.9%
Uppercase Letter 14
 
0.7%
Space Separator 4
 
0.2%
Decimal Number 3
 
0.1%
Other Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 360
18.1%
중 186
 
9.3%
개 185
 
9.3%
무 182
 
9.1%
소 181
 
9.1%
인 178
 
8.9%
공 174
 
8.7%
동 25
 
1.3%
부 22
 
1.1%
산 21
 
1.1%
Other values (187) 476
23.9%
Uppercase Letter
ValueCountFrequency (%)
W 2
14.3%
E 2
14.3%
C 1
7.1%
S 1
7.1%
I 1
7.1%
K 1
7.1%
N 1
7.1%
A 1
7.1%
B 1
7.1%
L 1
7.1%
Other values (2) 2
14.3%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
2 1
33.3%
Other Punctuation
ValueCountFrequency (%)
/ 1
50.0%
& 1
50.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1990
98.9%
Latin 14
 
0.7%
Common 9
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 360
18.1%
중 186
 
9.3%
개 185
 
9.3%
무 182
 
9.1%
소 181
 
9.1%
인 178
 
8.9%
공 174
 
8.7%
동 25
 
1.3%
부 22
 
1.1%
산 21
 
1.1%
Other values (187) 476
23.9%
Latin
ValueCountFrequency (%)
W 2
14.3%
E 2
14.3%
C 1
7.1%
S 1
7.1%
I 1
7.1%
K 1
7.1%
N 1
7.1%
A 1
7.1%
B 1
7.1%
L 1
7.1%
Other values (2) 2
14.3%
Common
ValueCountFrequency (%)
4
44.4%
1 2
22.2%
/ 1
 
11.1%
2 1
 
11.1%
& 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1990
98.9%
ASCII 23
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 360
18.1%
중 186
 
9.3%
개 185
 
9.3%
무 182
 
9.1%
소 181
 
9.1%
인 178
 
8.9%
공 174
 
8.7%
동 25
 
1.3%
부 22
 
1.1%
산 21
 
1.1%
Other values (187) 476
23.9%
ASCII
ValueCountFrequency (%)
4
17.4%
W 2
 
8.7%
1 2
 
8.7%
E 2
 
8.7%
C 1
 
4.3%
S 1
 
4.3%
/ 1
 
4.3%
I 1
 
4.3%
K 1
 
4.3%
N 1
 
4.3%
Other values (7) 7
30.4%

주소
Text

Distinct177
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-04-18T02:33:40.055726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length40
Mean length24.320652
Min length16

Characters and Unicode

Total characters4475
Distinct characters175
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

Unique171 ?
Unique (%)92.9%

Sample

1st row경상북도 김천시 송설로 142 상가 1-2호
2nd row경상북도 김천시 무실7길 45 401동 107호
3rd row경상북도 김천시 혁신1로 81 106호
4th row경상북도 김천시 용전3로 7 102호
5th row경상북도 김천시 김천로 27-1 2층
ValueCountFrequency (%)
경상북도 184
 
19.2%
김천시 184
 
19.2%
영남대로 15
 
1.6%
율곡동 14
 
1.5%
시청로 11
 
1.1%
아포읍 10
 
1.0%
상가동 10
 
1.0%
1층 9
 
0.9%
신음동 9
 
0.9%
자산로 8
 
0.8%
Other values (282) 505
52.7%
2024-04-18T02:33:40.393685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
849
19.0%
1 236
 
5.3%
상 216
 
4.8%
시 205
 
4.6%
김 192
 
4.3%
천 192
 
4.3%
도 186
 
4.2%
경 185
 
4.1%
북 184
 
4.1%
로 127
 
2.8%
Other values (165) 1903
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2629
58.7%
Space Separator 849
 
19.0%
Decimal Number 793
 
17.7%
Close Punctuation 70
 
1.6%
Open Punctuation 70
 
1.6%
Other Punctuation 32
 
0.7%
Dash Punctuation 28
 
0.6%
Lowercase Letter 3
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 216
 
8.2%
시 205
 
7.8%
김 192
 
7.3%
천 192
 
7.3%
도 186
 
7.1%
경 185
 
7.0%
북 184
 
7.0%
로 127
 
4.8%
동 99
 
3.8%
호 67
 
2.5%
Other values (146) 976
37.1%
Decimal Number
ValueCountFrequency (%)
1 236
29.8%
0 101
12.7%
2 94
 
11.9%
4 79
 
10.0%
3 69
 
8.7%
6 53
 
6.7%
5 50
 
6.3%
8 47
 
5.9%
7 39
 
4.9%
9 25
 
3.2%
Other Punctuation
ValueCountFrequency (%)
, 31
96.9%
. 1
 
3.1%
Lowercase Letter
ValueCountFrequency (%)
c 2
66.7%
k 1
33.3%
Space Separator
ValueCountFrequency (%)
849
100.0%
Close Punctuation
ValueCountFrequency (%)
) 70
100.0%
Open Punctuation
ValueCountFrequency (%)
( 70
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2629
58.7%
Common 1842
41.2%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 216
 
8.2%
시 205
 
7.8%
김 192
 
7.3%
천 192
 
7.3%
도 186
 
7.1%
경 185
 
7.0%
북 184
 
7.0%
로 127
 
4.8%
동 99
 
3.8%
호 67
 
2.5%
Other values (146) 976
37.1%
Common
ValueCountFrequency (%)
849
46.1%
1 236
 
12.8%
0 101
 
5.5%
2 94
 
5.1%
4 79
 
4.3%
) 70
 
3.8%
( 70
 
3.8%
3 69
 
3.7%
6 53
 
2.9%
5 50
 
2.7%
Other values (6) 171
 
9.3%
Latin
ValueCountFrequency (%)
c 2
50.0%
k 1
25.0%
A 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2629
58.7%
ASCII 1846
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
849
46.0%
1 236
 
12.8%
0 101
 
5.5%
2 94
 
5.1%
4 79
 
4.3%
) 70
 
3.8%
( 70
 
3.8%
3 69
 
3.7%
6 53
 
2.9%
5 50
 
2.7%
Other values (9) 175
 
9.5%
Hangul
ValueCountFrequency (%)
상 216
 
8.2%
시 205
 
7.8%
김 192
 
7.3%
천 192
 
7.3%
도 186
 
7.1%
경 185
 
7.0%
북 184
 
7.0%
로 127
 
4.8%
동 99
 
3.8%
호 67
 
2.5%
Other values (146) 976
37.1%

전화
Text

MISSING 

Distinct121
Distinct (%)100.0%
Missing63
Missing (%)34.2%
Memory size1.6 KiB
2024-04-18T02:33:40.589247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique121 ?
Unique (%)100.0%

Sample

1st row054-434-0779
2nd row054-439-0511
3rd row054-435-7508
4th row054-439-7900
5th row054-437-9100
ValueCountFrequency (%)
054-431-8959 1
 
0.8%
054-435-2931 1
 
0.8%
054-437-8986 1
 
0.8%
054-435-5086 1
 
0.8%
054-435-2241 1
 
0.8%
054-432-4959 1
 
0.8%
054-435-1114 1
 
0.8%
054-436-6789 1
 
0.8%
054-437-6780 1
 
0.8%
054-436-5285 1
 
0.8%
Other values (111) 111
91.7%
2024-04-18T02:33:41.094521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 305
21.0%
- 242
16.7%
0 192
13.2%
5 191
13.2%
3 175
12.1%
8 65
 
4.5%
6 60
 
4.1%
7 59
 
4.1%
9 55
 
3.8%
2 55
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1210
83.3%
Dash Punctuation 242
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 305
25.2%
0 192
15.9%
5 191
15.8%
3 175
14.5%
8 65
 
5.4%
6 60
 
5.0%
7 59
 
4.9%
9 55
 
4.5%
2 55
 
4.5%
1 53
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 242
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1452
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 305
21.0%
- 242
16.7%
0 192
13.2%
5 191
13.2%
3 175
12.1%
8 65
 
4.5%
6 60
 
4.1%
7 59
 
4.1%
9 55
 
3.8%
2 55
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1452
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 305
21.0%
- 242
16.7%
0 192
13.2%
5 191
13.2%
3 175
12.1%
8 65
 
4.5%
6 60
 
4.1%
7 59
 
4.1%
9 55
 
3.8%
2 55
 
3.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-09-26 00:00:00
Maximum2023-09-26 00:00:00
2024-04-18T02:33:41.189168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T02:33:41.263517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-04-18T02:33:39.372057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-18T02:33:39.431766image/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원탑공인중개사사무소경상북도 김천시 송설로 142 상가 1-2호<NA>2023-09-26
1뉴코아루공인중개사사무소경상북도 김천시 무실7길 45 401동 107호054-434-07792023-09-26
2한양공인중개사사무소경상북도 김천시 혁신1로 81 106호054-439-05112023-09-26
3박현주공인중개사사무소경상북도 김천시 용전3로 7 102호054-435-75082023-09-26
4효천공인중개사사무소경상북도 김천시 김천로 27-1 2층<NA>2023-09-26
5부용공인중개사사무소경상북도 김천시 혁신5로 45<NA>2023-09-26
6봄봄공인중개사사무소경상북도 김천시 혁신4로 54 114동 109호054-439-79002023-09-26
7한신더휴공인중개사사무소경상북도 김천시 혁신4로 54 114동 109호<NA>2023-09-26
8왕공인중개사사무소경상북도 김천시 농소면 용시길 221<NA>2023-09-26
9황금부동산공인중개사사무소경상북도 김천시 김천로 221<NA>2023-09-26
상호명주소전화데이터기준일
174일송공인중개사사무소경상북도 김천시 자산로 106 1층054-435-00122023-09-26
175천지공인중개사경상북도 김천시 영남대로 2089 (덕곡동)054-436-88832023-09-26
176동양공인중개사사무소경상북도 김천시 시민로 31 (부곡동)054-433-82082023-09-26
177엣지공인중개사사무소경상북도 김천시 용전1로 8 상가동 1층 104호(율곡동, 사랑으로 부영1단지)<NA>2023-09-26
178정성부동산중개사사무소경상북도 김천시 혁신1로 75 제2층 223호<NA>2023-09-26
179천상부동산중개경상북도 김천시 혁신로 185 113호(율곡동, 메타폴리스)<NA>2023-09-26
180태양공인중개사사무소경상북도 김천시 구농고길 21054-436-63432023-09-26
181뉴코끼리공인중개사사무소경상북도 김천시 아포대로 46-2 (덕곡동)<NA>2023-09-26
182김천농협농지중개사무소경상북도 김천시 자산로 147 평화동054-420-23252023-09-26
183성광공인중개사사무소경상북도 김천시 김천로 35054-434-53002023-09-26