Overview

Dataset statistics

Number of variables5
Number of observations127
Missing cells5
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.2 KiB
Average record size in memory42.0 B

Variable types

Numeric1
Text3
DateTime1

Dataset

Description경기도 광주시의 건축사사무소에 대한 현황에 대한 데이터로 사무소명, 주소, 전화번호, 데이터기준일자 등을 제공합니다.
Author경기도 광주시
URLhttps://www.data.go.kr/data/3079588/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 5 (3.9%) missing valuesMissing
연번 has unique valuesUnique
사무소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:10:54.143379
Analysis finished2023-12-12 00:10:54.548754
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64
Minimum1
Maximum127
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-12T09:10:54.622941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.3
Q132.5
median64
Q395.5
95-th percentile120.7
Maximum127
Range126
Interquartile range (IQR)63

Descriptive statistics

Standard deviation36.805797
Coefficient of variation (CV)0.57509057
Kurtosis-1.2
Mean64
Median Absolute Deviation (MAD)32
Skewness0
Sum8128
Variance1354.6667
MonotonicityStrictly increasing
2023-12-12T09:10:54.769556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
2 1
 
0.8%
95 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
89 1
 
0.8%
88 1
 
0.8%
Other values (117) 117
92.1%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
127 1
0.8%
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%
120 1
0.8%
119 1
0.8%
118 1
0.8%

사무소명
Text

UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T09:10:55.078078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length9.7716535
Min length7

Characters and Unicode

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

Unique

Unique127 ?
Unique (%)100.0%

Sample

1st row삼보건축사사무소
2nd row경안 건축사사무소
3rd row가람 건축사사무소
4th row신형 건축사사무소
5th row우정 건축사사무소
ValueCountFrequency (%)
건축사사무소 58
29.1%
주식회사 4
 
2.0%
종합건축사사무소 3
 
1.5%
삼보건축사사무소 1
 
0.5%
유타 1
 
0.5%
group 1
 
0.5%
스타일 1
 
0.5%
랩 1
 
0.5%
철주 1
 
0.5%
디에이원 1
 
0.5%
Other values (127) 127
63.8%
2023-12-12T09:10:55.541844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 261
21.0%
건 133
10.7%
축 131
 
10.6%
무 129
 
10.4%
소 128
 
10.3%
73
 
5.9%
주 16
 
1.3%
이 15
 
1.2%
합 13
 
1.0%
종 12
 
1.0%
Other values (140) 330
26.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1128
90.9%
Space Separator 73
 
5.9%
Uppercase Letter 12
 
1.0%
Open Punctuation 10
 
0.8%
Close Punctuation 10
 
0.8%
Decimal Number 3
 
0.2%
Other Punctuation 2
 
0.2%
Lowercase Letter 2
 
0.2%
Other Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 261
23.1%
건 133
11.8%
축 131
11.6%
무 129
11.4%
소 128
11.3%
주 16
 
1.4%
이 15
 
1.3%
합 13
 
1.2%
종 12
 
1.1%
에 11
 
1.0%
Other values (119) 279
24.7%
Uppercase Letter
ValueCountFrequency (%)
T 2
16.7%
U 2
16.7%
P 1
8.3%
D 1
8.3%
O 1
8.3%
R 1
8.3%
G 1
8.3%
L 1
8.3%
S 1
8.3%
A 1
8.3%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
5 1
33.3%
0 1
33.3%
Other Punctuation
ValueCountFrequency (%)
& 1
50.0%
, 1
50.0%
Lowercase Letter
ValueCountFrequency (%)
j 1
50.0%
m 1
50.0%
Space Separator
ValueCountFrequency (%)
73
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1129
91.0%
Common 98
 
7.9%
Latin 14
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 261
23.1%
건 133
11.8%
축 131
11.6%
무 129
11.4%
소 128
11.3%
주 16
 
1.4%
이 15
 
1.3%
합 13
 
1.2%
종 12
 
1.1%
에 11
 
1.0%
Other values (120) 280
24.8%
Latin
ValueCountFrequency (%)
T 2
14.3%
U 2
14.3%
P 1
7.1%
D 1
7.1%
O 1
7.1%
j 1
7.1%
m 1
7.1%
R 1
7.1%
G 1
7.1%
L 1
7.1%
Other values (2) 2
14.3%
Common
ValueCountFrequency (%)
73
74.5%
( 10
 
10.2%
) 10
 
10.2%
1 1
 
1.0%
& 1
 
1.0%
5 1
 
1.0%
0 1
 
1.0%
, 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1128
90.9%
ASCII 112
 
9.0%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 261
23.1%
건 133
11.8%
축 131
11.6%
무 129
11.4%
소 128
11.3%
주 16
 
1.4%
이 15
 
1.3%
합 13
 
1.2%
종 12
 
1.1%
에 11
 
1.0%
Other values (119) 279
24.7%
ASCII
ValueCountFrequency (%)
73
65.2%
( 10
 
8.9%
) 10
 
8.9%
T 2
 
1.8%
U 2
 
1.8%
1 1
 
0.9%
P 1
 
0.9%
D 1
 
0.9%
O 1
 
0.9%
& 1
 
0.9%
Other values (10) 10
 
8.9%
None
ValueCountFrequency (%)
㈜ 1
100.0%

도로명주소
Text

Distinct126
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T09:10:55.835728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length37
Mean length26.622047
Min length16

Characters and Unicode

Total characters3381
Distinct characters137
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

Unique125 ?
Unique (%)98.4%

Sample

1st row경기도 광주시 중앙로 150-0, 1층
2nd row경기도 광주시 순암로 82-0, 영인빌딩 201호
3rd row경기도 광주시 중앙로 343-0
4th row경기도 광주시 중앙로319번길 4-10, 101호
5th row경기도 광주시 수하길19번길 12-8
ValueCountFrequency (%)
경기도 127
 
17.8%
광주시 127
 
17.8%
중앙로 36
 
5.0%
2층 25
 
3.5%
3층 21
 
2.9%
오포읍 13
 
1.8%
201호 8
 
1.1%
송정동 8
 
1.1%
순암로 8
 
1.1%
회안대로 7
 
1.0%
Other values (222) 333
46.7%
2023-12-12T09:10:56.276896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
588
 
17.4%
0 190
 
5.6%
2 147
 
4.3%
광 137
 
4.1%
주 136
 
4.0%
경 129
 
3.8%
도 128
 
3.8%
시 127
 
3.8%
기 127
 
3.8%
1 126
 
3.7%
Other values (127) 1546
45.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1700
50.3%
Decimal Number 788
23.3%
Space Separator 588
 
17.4%
Dash Punctuation 120
 
3.5%
Other Punctuation 112
 
3.3%
Close Punctuation 29
 
0.9%
Open Punctuation 29
 
0.9%
Uppercase Letter 14
 
0.4%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 137
 
8.1%
주 136
 
8.0%
경 129
 
7.6%
도 128
 
7.5%
시 127
 
7.5%
기 127
 
7.5%
로 111
 
6.5%
층 70
 
4.1%
호 54
 
3.2%
중 49
 
2.9%
Other values (105) 632
37.2%
Decimal Number
ValueCountFrequency (%)
0 190
24.1%
2 147
18.7%
1 126
16.0%
3 104
13.2%
9 41
 
5.2%
8 40
 
5.1%
4 40
 
5.1%
5 37
 
4.7%
6 33
 
4.2%
7 30
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
B 4
28.6%
J 3
21.4%
M 3
21.4%
F 3
21.4%
A 1
 
7.1%
Other Punctuation
ValueCountFrequency (%)
, 111
99.1%
. 1
 
0.9%
Space Separator
ValueCountFrequency (%)
588
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 120
100.0%
Close Punctuation
ValueCountFrequency (%)
) 29
100.0%
Open Punctuation
ValueCountFrequency (%)
( 29
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1700
50.3%
Common 1666
49.3%
Latin 15
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 137
 
8.1%
주 136
 
8.0%
경 129
 
7.6%
도 128
 
7.5%
시 127
 
7.5%
기 127
 
7.5%
로 111
 
6.5%
층 70
 
4.1%
호 54
 
3.2%
중 49
 
2.9%
Other values (105) 632
37.2%
Common
ValueCountFrequency (%)
588
35.3%
0 190
 
11.4%
2 147
 
8.8%
1 126
 
7.6%
- 120
 
7.2%
, 111
 
6.7%
3 104
 
6.2%
9 41
 
2.5%
8 40
 
2.4%
4 40
 
2.4%
Other values (6) 159
 
9.5%
Latin
ValueCountFrequency (%)
B 4
26.7%
J 3
20.0%
M 3
20.0%
F 3
20.0%
A 1
 
6.7%
c 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1700
50.3%
ASCII 1681
49.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
588
35.0%
0 190
 
11.3%
2 147
 
8.7%
1 126
 
7.5%
- 120
 
7.1%
, 111
 
6.6%
3 104
 
6.2%
9 41
 
2.4%
8 40
 
2.4%
4 40
 
2.4%
Other values (12) 174
 
10.4%
Hangul
ValueCountFrequency (%)
광 137
 
8.1%
주 136
 
8.0%
경 129
 
7.6%
도 128
 
7.5%
시 127
 
7.5%
기 127
 
7.5%
로 111
 
6.5%
층 70
 
4.1%
호 54
 
3.2%
중 49
 
2.9%
Other values (105) 632
37.2%

전화번호
Text

MISSING 

Distinct116
Distinct (%)95.1%
Missing5
Missing (%)3.9%
Memory size1.1 KiB
2023-12-12T09:10:56.532773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.016393
Min length9

Characters and Unicode

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

Unique110 ?
Unique (%)90.2%

Sample

1st row031-765-2836
2nd row031-763-8844
3rd row031-763-3666
4th row031-766-0303
5th row031-763-9911
ValueCountFrequency (%)
031-763-8844 2
 
1.6%
031-764-7103 2
 
1.6%
031-765-1934 2
 
1.6%
031-765-4545 2
 
1.6%
031-765-2836 2
 
1.6%
031-762-1932 2
 
1.6%
031-797-1540 1
 
0.8%
031-764-0860 1
 
0.8%
070-7797-0331 1
 
0.8%
031-766-4769 1
 
0.8%
Other values (106) 106
86.9%
2023-12-12T09:10:56.940460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 243
16.6%
7 205
14.0%
0 202
13.8%
1 181
12.3%
3 174
11.9%
6 151
10.3%
9 75
 
5.1%
8 74
 
5.0%
4 63
 
4.3%
5 51
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1223
83.4%
Dash Punctuation 243
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 205
16.8%
0 202
16.5%
1 181
14.8%
3 174
14.2%
6 151
12.3%
9 75
 
6.1%
8 74
 
6.1%
4 63
 
5.2%
5 51
 
4.2%
2 47
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 243
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1466
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 243
16.6%
7 205
14.0%
0 202
13.8%
1 181
12.3%
3 174
11.9%
6 151
10.3%
9 75
 
5.1%
8 74
 
5.0%
4 63
 
4.3%
5 51
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1466
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 243
16.6%
7 205
14.0%
0 202
13.8%
1 181
12.3%
3 174
11.9%
6 151
10.3%
9 75
 
5.1%
8 74
 
5.0%
4 63
 
4.3%
5 51
 
3.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Minimum2022-10-06 00:00:00
Maximum2022-10-06 00:00:00
2023-12-12T09:10:57.068589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:10:57.175307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T09:10:54.332148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T09:10:54.432032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:10:54.515053image/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

연번사무소명도로명주소전화번호데이터기준일자
01삼보건축사사무소경기도 광주시 중앙로 150-0, 1층031-765-28362022-10-06
12경안 건축사사무소경기도 광주시 순암로 82-0, 영인빌딩 201호031-763-88442022-10-06
23가람 건축사사무소경기도 광주시 중앙로 343-0031-763-36662022-10-06
34신형 건축사사무소경기도 광주시 중앙로319번길 4-10, 101호031-766-03032022-10-06
45우정 건축사사무소경기도 광주시 수하길19번길 12-8031-763-99112022-10-06
56서진종합 건축사사무소경기도 광주시 중앙로 326-1, 3층031-766-81812022-10-06
67케이에스 건축사사무소경기도 광주시 청석로 274-0, 301호031-765-50972022-10-06
78우일 건축사사무소경기도 광주시 중앙로 208-0031-763-80172022-10-06
89건축사사무소 동산건축경기도 광주시 중앙로 182-0, 2층031-768-47412022-10-06
910다림 건축사사무소경기도 광주시 광주대로105번길 19-1031-765-11882022-10-06
연번사무소명도로명주소전화번호데이터기준일자
117118디자인랩건축사사무소경기도 광주시 역동로87번길 5-0, 2층031-763-51012022-10-06
118119시온건축사사무소경기도 광주시 오포읍 오포로859번길 30-0, 2층 201호070-4495-78152022-10-06
119120현신건축사사무소경기도 광주시 중앙로 350-0, 동진빌딩B동 2층031-764-10022022-10-06
120121채움건축사사무소경기도 광주시 중앙로 364, 4층<NA>2022-10-06
121122모안건축사사무소경기도 광주시 곤지암읍 광여로 63, 3층<NA>2022-10-06
122123아르테건축사사무소경기도 광주시 회안대로 871, 지상빌딩 2층031-764-71032022-10-06
123124㈜알이비에이 건축사사무소경기도 광주시 초월읍 현산로 116, 102호<NA>2022-10-06
124125UDA건축사사무소경기도 광주시 행정타운로 6, 3층 4호031-797-98932022-10-06
125126진원건축사사무소경기도 광주시 중앙로 327-10, 401호031-766-80902022-10-06
126127건축사사무소 담터경기도 광주시 남한산성면 회안대로 1430, 302호<NA>2022-10-06