Overview

Dataset statistics

Number of variables10
Number of observations9603
Missing cells48015
Missing cells (%)50.0%
Duplicate rows773
Duplicate rows (%)8.0%
Total size in memory806.6 KiB
Average record size in memory86.0 B

Variable types

Categorical4
Unsupported5
Text1

Dataset

Description파일 다운로드
Author종로구
URLhttps://data.seoul.go.kr/dataList/OA-11567/F/1/datasetView.do

Alerts

설치개수 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
관리기관명 has constant value ""Constant
Dataset has 773 (8.0%) duplicate rowsDuplicates
소재지도로명주소 has 9603 (100.0%) missing valuesMissing
위도 has 9603 (100.0%) missing valuesMissing
경도 has 9603 (100.0%) missing valuesMissing
설치년도 has 9603 (100.0%) missing valuesMissing
설치형태 has 9603 (100.0%) missing valuesMissing
소재지도로명주소 is an unsupported type, check if it needs cleaning or further analysisUnsupported
위도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
경도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
설치년도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
설치형태 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-04-18 06:26:52.170088
Analysis finished2024-04-18 06:26:54.918015
Duration2.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

보안등위치명
Categorical

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size75.2 KiB
평창동
1220 
종로1,2,3,4가동
1055 
혜화동
884 
청운효자동
799 
부암동
796 
Other values (12)
4849 

Length

Max length11
Median length3
Mean length4.5224409
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부암동
2nd row부암동
3rd row부암동
4th row부암동
5th row부암동

Common Values

ValueCountFrequency (%)
평창동 1220
12.7%
종로1,2,3,4가동 1055
11.0%
혜화동 884
 
9.2%
청운효자동 799
 
8.3%
부암동 796
 
8.3%
종로5,6,가동 555
 
5.8%
사직동 548
 
5.7%
창신2동 539
 
5.6%
이화동 532
 
5.5%
교남동 444
 
4.6%
Other values (7) 2231
23.2%

Length

2024-04-18T15:26:54.984439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
평창동 1220
12.7%
종로1,2,3,4가동 1055
11.0%
혜화동 884
 
9.2%
청운효자동 799
 
8.3%
부암동 796
 
8.3%
종로5,6,가동 555
 
5.8%
사직동 548
 
5.7%
창신2동 539
 
5.6%
이화동 532
 
5.5%
교남동 444
 
4.6%
Other values (7) 2231
23.2%

설치개수
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size75.2 KiB
1
9603 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 9603
100.0%

Length

2024-04-18T15:26:55.107729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T15:26:55.192401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9603
100.0%

소재지도로명주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9603
Missing (%)100.0%
Memory size84.5 KiB

소재지지번주소
Text

Distinct8618
Distinct (%)89.7%
Missing0
Missing (%)0.0%
Memory size75.2 KiB
2024-04-18T15:26:55.487338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length35
Mean length20.020306
Min length9

Characters and Unicode

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

Unique

Unique7843 ?
Unique (%)81.7%

Sample

1st row서울특별시 종로구 신영동 218-6
2nd row서울특별시 종로구 신영동 218-5 월편
3rd row서울특별시 종로구 신영동 232-1
4th row서울특별시 종로구 신영동 234-3 월편
5th row서울특별시 종로구 신영동 235-4
ValueCountFrequency (%)
서울특별시 9603
22.9%
종로구 9603
22.9%
평창동 922
 
2.2%
780
 
1.9%
창신2동 531
 
1.3%
월편 455
 
1.1%
부암동 433
 
1.0%
숭인2동 409
 
1.0%
창신1동 377
 
0.9%
명륜3가 367
 
0.9%
Other values (6380) 18373
43.9%
2024-04-18T15:26:55.933697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
32342
16.8%
로 9978
 
5.2%
구 9954
 
5.2%
종 9826
 
5.1%
서 9722
 
5.1%
시 9612
 
5.0%
별 9604
 
5.0%
특 9603
 
5.0%
울 9603
 
5.0%
1 9064
 
4.7%
Other values (338) 72947
37.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 111840
58.2%
Decimal Number 39583
 
20.6%
Space Separator 32342
 
16.8%
Dash Punctuation 7809
 
4.1%
Close Punctuation 296
 
0.2%
Open Punctuation 296
 
0.2%
Uppercase Letter 57
 
< 0.1%
Other Punctuation 23
 
< 0.1%
Lowercase Letter 8
 
< 0.1%
Modifier Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 9978
8.9%
구 9954
8.9%
종 9826
8.8%
서 9722
8.7%
시 9612
8.6%
별 9604
8.6%
특 9603
8.6%
울 9603
8.6%
동 8952
 
8.0%
창 2093
 
1.9%
Other values (306) 22893
20.5%
Decimal Number
ValueCountFrequency (%)
1 9064
22.9%
2 6349
16.0%
3 4799
12.1%
4 3513
 
8.9%
5 3392
 
8.6%
6 3049
 
7.7%
0 2447
 
6.2%
7 2348
 
5.9%
8 2325
 
5.9%
9 2297
 
5.8%
Uppercase Letter
ValueCountFrequency (%)
A 26
45.6%
P 8
 
14.0%
T 8
 
14.0%
B 6
 
10.5%
C 6
 
10.5%
M 1
 
1.8%
Y 1
 
1.8%
D 1
 
1.8%
Other Punctuation
ValueCountFrequency (%)
. 13
56.5%
, 6
26.1%
* 2
 
8.7%
/ 1
 
4.3%
? 1
 
4.3%
Lowercase Letter
ValueCountFrequency (%)
a 2
25.0%
p 2
25.0%
c 2
25.0%
t 2
25.0%
Space Separator
ValueCountFrequency (%)
32342
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7809
100.0%
Close Punctuation
ValueCountFrequency (%)
) 296
100.0%
Open Punctuation
ValueCountFrequency (%)
( 296
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 111840
58.2%
Common 80350
41.8%
Latin 65
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 9978
8.9%
구 9954
8.9%
종 9826
8.8%
서 9722
8.7%
시 9612
8.6%
별 9604
8.6%
특 9603
8.6%
울 9603
8.6%
동 8952
 
8.0%
창 2093
 
1.9%
Other values (306) 22893
20.5%
Common
ValueCountFrequency (%)
32342
40.3%
1 9064
 
11.3%
- 7809
 
9.7%
2 6349
 
7.9%
3 4799
 
6.0%
4 3513
 
4.4%
5 3392
 
4.2%
6 3049
 
3.8%
0 2447
 
3.0%
7 2348
 
2.9%
Other values (10) 5238
 
6.5%
Latin
ValueCountFrequency (%)
A 26
40.0%
P 8
 
12.3%
T 8
 
12.3%
B 6
 
9.2%
C 6
 
9.2%
a 2
 
3.1%
p 2
 
3.1%
c 2
 
3.1%
t 2
 
3.1%
M 1
 
1.5%
Other values (2) 2
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 111840
58.2%
ASCII 80415
41.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
32342
40.2%
1 9064
 
11.3%
- 7809
 
9.7%
2 6349
 
7.9%
3 4799
 
6.0%
4 3513
 
4.4%
5 3392
 
4.2%
6 3049
 
3.8%
0 2447
 
3.0%
7 2348
 
2.9%
Other values (22) 5303
 
6.6%
Hangul
ValueCountFrequency (%)
로 9978
8.9%
구 9954
8.9%
종 9826
8.8%
서 9722
8.7%
시 9612
8.6%
별 9604
8.6%
특 9603
8.6%
울 9603
8.6%
동 8952
 
8.0%
창 2093
 
1.9%
Other values (306) 22893
20.5%

위도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9603
Missing (%)100.0%
Memory size84.5 KiB

경도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9603
Missing (%)100.0%
Memory size84.5 KiB

설치년도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9603
Missing (%)100.0%
Memory size84.5 KiB

설치형태
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9603
Missing (%)100.0%
Memory size84.5 KiB

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size75.2 KiB
02-2148-3193
9603 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-2148-3193
2nd row02-2148-3193
3rd row02-2148-3193
4th row02-2148-3193
5th row02-2148-3193

Common Values

ValueCountFrequency (%)
02-2148-3193 9603
100.0%

Length

2024-04-18T15:26:56.056282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T15:26:56.134292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-2148-3193 9603
100.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size75.2 KiB
서울특별시 종로구청
9603 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시 종로구청
2nd row서울특별시 종로구청
3rd row서울특별시 종로구청
4th row서울특별시 종로구청
5th row서울특별시 종로구청

Common Values

ValueCountFrequency (%)
서울특별시 종로구청 9603
100.0%

Length

2024-04-18T15:26:56.218267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T15:26:56.301390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 9603
50.0%
종로구청 9603
50.0%

Missing values

2024-04-18T15:26:54.853554image/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부암동1<NA>서울특별시 종로구 신영동 218-6<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
1부암동1<NA>서울특별시 종로구 신영동 218-5 월편<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
2부암동1<NA>서울특별시 종로구 신영동 232-1<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
3부암동1<NA>서울특별시 종로구 신영동 234-3 월편<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
4부암동1<NA>서울특별시 종로구 신영동 235-4<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
5부암동1<NA>서울특별시 종로구 신영동 236-2<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
6부암동1<NA>서울특별시 종로구 신영동 239-2<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
7부암동1<NA>서울특별시 종로구 신영동 239-8 월편<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
8부암동1<NA>서울특별시 종로구 신영동 239-7<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9부암동1<NA>서울특별시 종로구 신영동 235-1<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
보안등위치명설치개수소재지도로명주소소재지지번주소위도경도설치년도설치형태관리기관전화번호관리기관명
9593숭인1동1<NA>서울특별시 종로구 숭인2동 181-160<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9594숭인1동1<NA>서울특별시 종로구 숭인1동 72-80<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9595숭인1동1<NA>서울특별시 종로구 숭인1동 72-161<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9596숭인1동1<NA>서울특별시 종로구 숭인1동 72-95<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9597숭인1동1<NA>서울특별시 종로구 숭인1동 199<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9598숭인1동1<NA>서울특별시 종로구 숭인1동 72-243<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9599숭인1동1<NA>서울특별시 종로구 숭인1동 72-203<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9600숭인1동1<NA>서울특별시 종로구 숭인1동 72-199 앞<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9601숭인1동1<NA>서울특별시 종로구 숭인1동 72-193<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청
9602숭인1동1<NA>서울특별시 종로구 숭인1동 72-193<NA><NA><NA><NA>02-2148-3193서울특별시 종로구청

Duplicate rows

Most frequently occurring

보안등위치명설치개수소재지지번주소관리기관전화번호관리기관명# duplicates
549청운효자동1서울특별시 종로구 옥인동 산 3-14 (인왕산약수터길)02-2148-3193서울특별시 종로구청11
396종로1,2,3,4가동1서울특별시 종로구 장사동 175-4 앞(세운상가)02-2148-3193서울특별시 종로구청9
550청운효자동1서울특별시 종로구 옥인동 석굴암약수터02-2148-3193서울특별시 종로구청9
42교남동1서울특별시 종로구 행촌동210-112702-2148-3193서울특별시 종로구청8
408종로1,2,3,4가동1서울특별시 종로구 훈정동 종묘공원외곽담02-2148-3193서울특별시 종로구청8
686평창동1서울특별시 종로구 평창동 산6-420 선지수도원산길02-2148-3193서울특별시 종로구청7
751혜화동1서울특별시 종로구 와룡공원02-2148-3193서울특별시 종로구청7
752혜화동1서울특별시 종로구 와룡공원 길02-2148-3193서울특별시 종로구청7
66무악동1서울특별시 종로구 무악동 산2-2402-2148-3193서울특별시 종로구청6
141사직동1서울특별시 종로구 도렴동02-2148-3193서울특별시 종로구청6