Overview

Dataset statistics

Number of variables6
Number of observations67
Missing cells29
Missing cells (%)7.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory50.0 B

Variable types

Categorical2
Text3
DateTime1

Dataset

Description예천군 내 부동산 중개사무소 정보를 제공합니다. (사무소 명칭, 사무실 전화번호, 사무실 도로명주소, 기준일자) 등
Author경상북도 예천군
URLhttps://www.data.go.kr/data/15013861/fileData.do

Alerts

시도 has constant value ""Constant
시군구 has constant value ""Constant
기준일자 has constant value ""Constant
사무소전화번호 has 29 (43.3%) missing valuesMissing
사무소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:26:23.423150
Analysis finished2023-12-12 12:26:23.876287
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
경상북도
67 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경상북도
2nd row경상북도
3rd row경상북도
4th row경상북도
5th row경상북도

Common Values

ValueCountFrequency (%)
경상북도 67
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:26:24.069856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경상북도 67
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
예천군
67 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row예천군
2nd row예천군
3rd row예천군
4th row예천군
5th row예천군

Common Values

ValueCountFrequency (%)
예천군 67
100.0%

Length

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

Common Values (Plot)

2023-12-12T21:26:24.344923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
예천군 67
100.0%

사무소명
Text

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-12T21:26:24.590874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length11.850746
Min length10

Characters and Unicode

Total characters794
Distinct characters110
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

Unique67 ?
Unique (%)100.0%

Sample

1st row신라공인중개사사무소
2nd row고려공인중개사사무소
3rd row토지부동산 공인중개사 사무소
4th row행운공인중개사사무소
5th row금탑공인중개사사무소
ValueCountFrequency (%)
공인중개사사무소 2
 
2.8%
신라공인중개사사무소 1
 
1.4%
서진부동산공인중개사사무소 1
 
1.4%
땅나라부동산중개사무소 1
 
1.4%
서울공인중개사사무소 1
 
1.4%
한미공인중개사사무소 1
 
1.4%
호반2차공인중개사사무소 1
 
1.4%
대주부동산공인중개사사무소 1
 
1.4%
천하부동산공인중개사사무소 1
 
1.4%
경북도청신도시부동산공인중개사사무소 1
 
1.4%
Other values (61) 61
84.7%
2023-12-12T21:26:25.041684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 131
16.5%
중 68
 
8.6%
소 68
 
8.6%
개 67
 
8.4%
무 67
 
8.4%
공 64
 
8.1%
인 63
 
7.9%
동 26
 
3.3%
산 25
 
3.1%
부 25
 
3.1%
Other values (100) 190
23.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 780
98.2%
Decimal Number 6
 
0.8%
Space Separator 5
 
0.6%
Uppercase Letter 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 131
16.8%
중 68
 
8.7%
소 68
 
8.7%
개 67
 
8.6%
무 67
 
8.6%
공 64
 
8.2%
인 63
 
8.1%
동 26
 
3.3%
산 25
 
3.2%
부 25
 
3.2%
Other values (93) 176
22.6%
Decimal Number
ValueCountFrequency (%)
1 4
66.7%
2 1
 
16.7%
4 1
 
16.7%
Uppercase Letter
ValueCountFrequency (%)
P 1
33.3%
I 1
33.3%
V 1
33.3%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 780
98.2%
Common 11
 
1.4%
Latin 3
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 131
16.8%
중 68
 
8.7%
소 68
 
8.7%
개 67
 
8.6%
무 67
 
8.6%
공 64
 
8.2%
인 63
 
8.1%
동 26
 
3.3%
산 25
 
3.2%
부 25
 
3.2%
Other values (93) 176
22.6%
Common
ValueCountFrequency (%)
5
45.5%
1 4
36.4%
2 1
 
9.1%
4 1
 
9.1%
Latin
ValueCountFrequency (%)
P 1
33.3%
I 1
33.3%
V 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 780
98.2%
ASCII 14
 
1.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 131
16.8%
중 68
 
8.7%
소 68
 
8.7%
개 67
 
8.6%
무 67
 
8.6%
공 64
 
8.2%
인 63
 
8.1%
동 26
 
3.3%
산 25
 
3.2%
부 25
 
3.2%
Other values (93) 176
22.6%
ASCII
ValueCountFrequency (%)
5
35.7%
1 4
28.6%
2 1
 
7.1%
P 1
 
7.1%
I 1
 
7.1%
V 1
 
7.1%
4 1
 
7.1%

사무소전화번호
Text

MISSING 

Distinct37
Distinct (%)97.4%
Missing29
Missing (%)43.3%
Memory size668.0 B
2023-12-12T21:26:25.373394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique36 ?
Unique (%)94.7%

Sample

1st row054-655-8477
2nd row054-652-7774
3rd row054-652-1185
4th row054-654-3337
5th row054-655-2244
ValueCountFrequency (%)
054-652-1122 2
 
5.3%
054-654-8289 1
 
2.6%
054-655-8477 1
 
2.6%
054-655-5949 1
 
2.6%
054-654-4642 1
 
2.6%
054-650-0880 1
 
2.6%
054-652-7755 1
 
2.6%
054-654-0055 1
 
2.6%
054-655-5922 1
 
2.6%
054-652-9977 1
 
2.6%
Other values (27) 27
71.1%
2023-12-12T21:26:25.824742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 99
21.7%
- 76
16.7%
0 62
13.6%
4 59
12.9%
6 45
9.9%
2 32
 
7.0%
1 22
 
4.8%
3 21
 
4.6%
7 16
 
3.5%
9 13
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 380
83.3%
Dash Punctuation 76
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 99
26.1%
0 62
16.3%
4 59
15.5%
6 45
11.8%
2 32
 
8.4%
1 22
 
5.8%
3 21
 
5.5%
7 16
 
4.2%
9 13
 
3.4%
8 11
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 76
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 456
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 99
21.7%
- 76
16.7%
0 62
13.6%
4 59
12.9%
6 45
9.9%
2 32
 
7.0%
1 22
 
4.8%
3 21
 
4.6%
7 16
 
3.5%
9 13
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 456
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 99
21.7%
- 76
16.7%
0 62
13.6%
4 59
12.9%
6 45
9.9%
2 32
 
7.0%
1 22
 
4.8%
3 21
 
4.6%
7 16
 
3.5%
9 13
 
2.9%

사무소주소
Text

Distinct64
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-12T21:26:26.079288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length42
Mean length28.835821
Min length18

Characters and Unicode

Total characters1932
Distinct characters102
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

Unique61 ?
Unique (%)91.0%

Sample

1st row경상북도 예천군 예천읍 충효로 160
2nd row경상북도 예천군 예천읍 효자로 91, 2층
3rd row경상북도 예천군 예천읍 양궁로 9
4th row경상북도 예천군 예천읍 효자로 31, 제상가3층 제3011호
5th row경상북도 예천군 예천읍 군청앞길 3
ValueCountFrequency (%)
예천군 67
 
16.0%
경상북도 65
 
15.5%
호명면 35
 
8.3%
예천읍 28
 
6.7%
상가동 16
 
3.8%
행복로 11
 
2.6%
검무로 8
 
1.9%
양지로 7
 
1.7%
229 6
 
1.4%
시장로 6
 
1.4%
Other values (109) 171
40.7%
2023-12-12T21:26:26.599659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
353
18.3%
천 97
 
5.0%
예 95
 
4.9%
1 95
 
4.9%
상 85
 
4.4%
도 79
 
4.1%
호 77
 
4.0%
경 74
 
3.8%
북 74
 
3.8%
군 69
 
3.6%
Other values (92) 834
43.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1170
60.6%
Space Separator 353
 
18.3%
Decimal Number 322
 
16.7%
Other Punctuation 37
 
1.9%
Close Punctuation 18
 
0.9%
Open Punctuation 18
 
0.9%
Dash Punctuation 12
 
0.6%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 97
 
8.3%
예 95
 
8.1%
상 85
 
7.3%
도 79
 
6.8%
호 77
 
6.6%
경 74
 
6.3%
북 74
 
6.3%
군 69
 
5.9%
로 59
 
5.0%
면 38
 
3.2%
Other values (75) 423
36.2%
Decimal Number
ValueCountFrequency (%)
1 95
29.5%
2 69
21.4%
0 38
 
11.8%
7 25
 
7.8%
3 22
 
6.8%
4 18
 
5.6%
5 17
 
5.3%
9 16
 
5.0%
6 15
 
4.7%
8 7
 
2.2%
Uppercase Letter
ValueCountFrequency (%)
J 1
50.0%
M 1
50.0%
Space Separator
ValueCountFrequency (%)
353
100.0%
Other Punctuation
ValueCountFrequency (%)
, 37
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1170
60.6%
Common 760
39.3%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 97
 
8.3%
예 95
 
8.1%
상 85
 
7.3%
도 79
 
6.8%
호 77
 
6.6%
경 74
 
6.3%
북 74
 
6.3%
군 69
 
5.9%
로 59
 
5.0%
면 38
 
3.2%
Other values (75) 423
36.2%
Common
ValueCountFrequency (%)
353
46.4%
1 95
 
12.5%
2 69
 
9.1%
0 38
 
5.0%
, 37
 
4.9%
7 25
 
3.3%
3 22
 
2.9%
4 18
 
2.4%
) 18
 
2.4%
( 18
 
2.4%
Other values (5) 67
 
8.8%
Latin
ValueCountFrequency (%)
J 1
50.0%
M 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1170
60.6%
ASCII 762
39.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
353
46.3%
1 95
 
12.5%
2 69
 
9.1%
0 38
 
5.0%
, 37
 
4.9%
7 25
 
3.3%
3 22
 
2.9%
4 18
 
2.4%
) 18
 
2.4%
( 18
 
2.4%
Other values (7) 69
 
9.1%
Hangul
ValueCountFrequency (%)
천 97
 
8.3%
예 95
 
8.1%
상 85
 
7.3%
도 79
 
6.8%
호 77
 
6.6%
경 74
 
6.3%
북 74
 
6.3%
군 69
 
5.9%
로 59
 
5.0%
면 38
 
3.2%
Other values (75) 423
36.2%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
Minimum2023-11-17 00:00:00
Maximum2023-11-17 00:00:00
2023-12-12T21:26:26.733711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:26:26.852630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T21:26:26.946273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사무소명사무소전화번호사무소주소
사무소명1.0001.0001.000
사무소전화번호1.0001.0001.000
사무소주소1.0001.0001.000

Missing values

2023-12-12T21:26:23.710676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:26:23.831463image/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경상북도예천군신라공인중개사사무소054-655-8477경상북도 예천군 예천읍 충효로 1602023-11-17
1경상북도예천군고려공인중개사사무소054-652-7774경상북도 예천군 예천읍 효자로 91, 2층2023-11-17
2경상북도예천군토지부동산 공인중개사 사무소054-652-1185경상북도 예천군 예천읍 양궁로 92023-11-17
3경상북도예천군행운공인중개사사무소<NA>경상북도 예천군 예천읍 효자로 31, 제상가3층 제3011호2023-11-17
4경상북도예천군금탑공인중개사사무소054-654-3337경상북도 예천군 예천읍 군청앞길 32023-11-17
5경상북도예천군성신공인중개사사무소054-655-2244경상북도 예천군 예천읍 중앙로 81-12023-11-17
6경상북도예천군좋은부동산이주현공인중개사사무소054-652-7222경상북도 예천군 예천읍 시장로 117-22023-11-17
7경상북도예천군드림공인중개사사무소054-655-5797경상북도 예천군 예천읍 대심2길 72023-11-17
8경상북도예천군그린공인중개사사무소054-654-0894경상북도 예천군 예천읍 중앙로 762023-11-17
9경상북도예천군예천공인중개사사무소054-654-5082경상북도 예천군 예천읍 충효로 162-12023-11-17
시도시군구사무소명사무소전화번호사무소주소기준일자
57경상북도예천군VIP 공인중개사사무소054-655-8456경상북도 예천군 호명면 행복로 229, 우방아이유쉘센트럴 상가1층 115호2023-11-17
58경상북도예천군누리공인중개사사무소<NA>경상북도 예천군 예천읍 시장로 79, 2층2023-11-17
59경상북도예천군하늘공인중개사사무소<NA>경상북도 예천군 호명면 검무로 27 상가동 103호(경북도청신도시우방아이유쉘센텀)2023-11-17
60경상북도예천군대신공인중개사사무소<NA>경상북도 예천군 호명면 서당마길 15-32023-11-17
61경상북도예천군현대 부동산중개사무소<NA>경북 예천군 역전길 10, 102호2023-11-17
62경상북도예천군보라보라부동산공인중개사사무소<NA>경북 예천군 호명면 검무로 27 상가동 101호2023-11-17
63경상북도예천군금당부동산공인중개사사무소<NA>경상북도 예천군 예천읍 효자로 90-22023-11-17
64경상북도예천군호민지부동산공인중개사사무소<NA>경상북도 예천군 호명면 행복로 229 ,상가동 117호2023-11-17
65경상북도예천군미소공인중개사사무소<NA>경상북도 예천군 호명면 검무로 17, 117호2023-11-17
66경상북도예천군골드공인중개사사무소054-652-1122경상북도 예천군 호명면 새움3로 52 (JM골드스퀘어), 상가동 105호2023-11-17