Overview

Dataset statistics

Number of variables5
Number of observations22
Missing cells21
Missing cells (%)19.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1012.0 B
Average record size in memory46.0 B

Variable types

Text5

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-20438/S/1/datasetView.do

Alerts

Unnamed: 0 has constant value ""Constant
Unnamed: 0 has 21 (95.5%) missing valuesMissing
자치구 has unique valuesUnique
담당자 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-05-03 20:59:44.847998
Analysis finished2024-05-03 20:59:46.038933
Duration1.19 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing21
Missing (%)95.5%
Memory size308.0 B
2024-05-03T20:59:46.253784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length5
Min length5

Characters and Unicode

Total characters5
Distinct characters5
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row서울특별시
ValueCountFrequency (%)
서울특별시 1
100.0%
2024-05-03T20:59:47.120375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
서 1
20.0%
울 1
20.0%
특 1
20.0%
별 1
20.0%
시 1
20.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 1
20.0%
울 1
20.0%
특 1
20.0%
별 1
20.0%
시 1
20.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 1
20.0%
울 1
20.0%
특 1
20.0%
별 1
20.0%
시 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
서 1
20.0%
울 1
20.0%
특 1
20.0%
별 1
20.0%
시 1
20.0%

자치구
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-05-03T20:59:47.674039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.0454545
Min length2

Characters and Unicode

Total characters67
Distinct characters33
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row구로구
2nd row강남구
3rd row강동구
4th row강북구
5th row강서구
ValueCountFrequency (%)
구로구 1
 
4.5%
강남구 1
 
4.5%
중구 1
 
4.5%
종로구 1
 
4.5%
은평구 1
 
4.5%
용산구 1
 
4.5%
영등포구 1
 
4.5%
양천구 1
 
4.5%
송파구 1
 
4.5%
성북구 1
 
4.5%
Other values (12) 12
54.5%
2024-05-03T20:59:48.850845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
구 23
34.3%
강 4
 
6.0%
서 3
 
4.5%
동 3
 
4.5%
로 2
 
3.0%
천 2
 
3.0%
성 2
 
3.0%
북 2
 
3.0%
중 2
 
3.0%
종 1
 
1.5%
Other values (23) 23
34.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 67
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 23
34.3%
강 4
 
6.0%
서 3
 
4.5%
동 3
 
4.5%
로 2
 
3.0%
천 2
 
3.0%
성 2
 
3.0%
북 2
 
3.0%
중 2
 
3.0%
종 1
 
1.5%
Other values (23) 23
34.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 67
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 23
34.3%
강 4
 
6.0%
서 3
 
4.5%
동 3
 
4.5%
로 2
 
3.0%
천 2
 
3.0%
성 2
 
3.0%
북 2
 
3.0%
중 2
 
3.0%
종 1
 
1.5%
Other values (23) 23
34.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 67
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
구 23
34.3%
강 4
 
6.0%
서 3
 
4.5%
동 3
 
4.5%
로 2
 
3.0%
천 2
 
3.0%
성 2
 
3.0%
북 2
 
3.0%
중 2
 
3.0%
종 1
 
1.5%
Other values (23) 23
34.3%

담당부서
Text

Distinct21
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-05-03T20:59:49.293644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length12.181818
Min length8

Characters and Unicode

Total characters268
Distinct characters53
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique20 ?
Unique (%)90.9%

Sample

1st row스마트도시과 스마트전산팀
2nd row디저털도시과 공공데이터팀
3rd row스마트도시과 빅데이터팀
4th row디지털정보과 디지털정책팀
5th row정보통신과 전산운영팀
ValueCountFrequency (%)
스마트정보과 5
 
11.4%
전산운영팀 5
 
11.4%
정보화운영팀 3
 
6.8%
스마트도시과 3
 
6.8%
빅데이터팀 2
 
4.5%
의약과 2
 
4.5%
정보통신과 2
 
4.5%
의무2팀 1
 
2.3%
디지털운영팀 1
 
2.3%
홍보미디어과 1
 
2.3%
Other values (19) 19
43.2%
2024-05-03T20:59:50.333915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
22
 
8.2%
팀 22
 
8.2%
과 19
 
7.1%
정 17
 
6.3%
보 17
 
6.3%
스 13
 
4.9%
트 13
 
4.9%
마 13
 
4.9%
운 9
 
3.4%
영 9
 
3.4%
Other values (43) 114
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 245
91.4%
Space Separator 22
 
8.2%
Decimal Number 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팀 22
 
9.0%
과 19
 
7.8%
정 17
 
6.9%
보 17
 
6.9%
스 13
 
5.3%
트 13
 
5.3%
마 13
 
5.3%
운 9
 
3.7%
영 9
 
3.7%
전 7
 
2.9%
Other values (41) 106
43.3%
Space Separator
ValueCountFrequency (%)
22
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 245
91.4%
Common 23
 
8.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팀 22
 
9.0%
과 19
 
7.8%
정 17
 
6.9%
보 17
 
6.9%
스 13
 
5.3%
트 13
 
5.3%
마 13
 
5.3%
운 9
 
3.7%
영 9
 
3.7%
전 7
 
2.9%
Other values (41) 106
43.3%
Common
ValueCountFrequency (%)
22
95.7%
2 1
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 245
91.4%
ASCII 23
 
8.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
22
95.7%
2 1
 
4.3%
Hangul
ValueCountFrequency (%)
팀 22
 
9.0%
과 19
 
7.8%
정 17
 
6.9%
보 17
 
6.9%
스 13
 
5.3%
트 13
 
5.3%
마 13
 
5.3%
운 9
 
3.7%
영 9
 
3.7%
전 7
 
2.9%
Other values (41) 106
43.3%

담당자
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-05-03T20:59:51.086505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters66
Distinct characters43
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row소창호
2nd row박춘성
3rd row윤우경
4th row유영화
5th row이소연
ValueCountFrequency (%)
소창호 1
 
4.5%
박춘성 1
 
4.5%
이민정 1
 
4.5%
전경배 1
 
4.5%
김은회 1
 
4.5%
김우림 1
 
4.5%
이민준 1
 
4.5%
정은총 1
 
4.5%
최신혜 1
 
4.5%
조미혜 1
 
4.5%
Other values (12) 12
54.5%
2024-05-03T20:59:52.081236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
정 5
 
7.6%
김 4
 
6.1%
이 4
 
6.1%
은 3
 
4.5%
경 3
 
4.5%
소 2
 
3.0%
영 2
 
3.0%
혜 2
 
3.0%
남 2
 
3.0%
민 2
 
3.0%
Other values (33) 37
56.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 66
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 5
 
7.6%
김 4
 
6.1%
이 4
 
6.1%
은 3
 
4.5%
경 3
 
4.5%
소 2
 
3.0%
영 2
 
3.0%
혜 2
 
3.0%
남 2
 
3.0%
민 2
 
3.0%
Other values (33) 37
56.1%

Most occurring scripts

ValueCountFrequency (%)
Hangul 66
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 5
 
7.6%
김 4
 
6.1%
이 4
 
6.1%
은 3
 
4.5%
경 3
 
4.5%
소 2
 
3.0%
영 2
 
3.0%
혜 2
 
3.0%
남 2
 
3.0%
민 2
 
3.0%
Other values (33) 37
56.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 66
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
정 5
 
7.6%
김 4
 
6.1%
이 4
 
6.1%
은 3
 
4.5%
경 3
 
4.5%
소 2
 
3.0%
영 2
 
3.0%
혜 2
 
3.0%
남 2
 
3.0%
민 2
 
3.0%
Other values (33) 37
56.1%

전화번호
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-05-03T20:59:52.706415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.681818
Min length11

Characters and Unicode

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

Unique22 ?
Unique (%)100.0%

Sample

1st row02-860-2186
2nd row02-3423-7943
3rd row02-3425-8744
4th row02-901-7204
5th row02-2600-6687
ValueCountFrequency (%)
02-860-2186 1
 
4.5%
02-3423-7943 1
 
4.5%
02-3396-6383 1
 
4.5%
02-2148-1745 1
 
4.5%
02-351-6373 1
 
4.5%
02-2199-6634 1
 
4.5%
02-2670-4249 1
 
4.5%
02-2620-3249 1
 
4.5%
02-2147-3536 1
 
4.5%
02-2241-4534 1
 
4.5%
Other values (12) 12
54.5%
2024-05-03T20:59:53.919493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 51
19.8%
- 44
17.1%
0 35
13.6%
3 26
10.1%
4 19
 
7.4%
6 18
 
7.0%
1 15
 
5.8%
7 14
 
5.4%
8 12
 
4.7%
5 12
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 213
82.9%
Dash Punctuation 44
 
17.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 51
23.9%
0 35
16.4%
3 26
12.2%
4 19
 
8.9%
6 18
 
8.5%
1 15
 
7.0%
7 14
 
6.6%
8 12
 
5.6%
5 12
 
5.6%
9 11
 
5.2%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 257
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 51
19.8%
- 44
17.1%
0 35
13.6%
3 26
10.1%
4 19
 
7.4%
6 18
 
7.0%
1 15
 
5.8%
7 14
 
5.4%
8 12
 
4.7%
5 12
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 257
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 51
19.8%
- 44
17.1%
0 35
13.6%
3 26
10.1%
4 19
 
7.4%
6 18
 
7.0%
1 15
 
5.8%
7 14
 
5.4%
8 12
 
4.7%
5 12
 
4.7%

Correlations

2024-05-03T20:59:54.266356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자치구담당부서담당자전화번호
자치구1.0001.0001.0001.000
담당부서1.0001.0001.0001.000
담당자1.0001.0001.0001.000
전화번호1.0001.0001.0001.000

Missing values

2024-05-03T20:59:45.544318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-03T20:59:45.863255image/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

Unnamed: 0자치구담당부서담당자전화번호
0서울특별시구로구스마트도시과 스마트전산팀소창호02-860-2186
1<NA>강남구디저털도시과 공공데이터팀박춘성02-3423-7943
2<NA>강동구스마트도시과 빅데이터팀윤우경02-3425-8744
3<NA>강북구디지털정보과 디지털정책팀유영화02-901-7204
4<NA>강서구정보통신과 전산운영팀이소연02-2600-6687
5<NA>관악구스마트정보과 전산운영팀이문남02-879-5283
6<NA>광진구스마트정보담당관 스마트데이터팀김대용02-450-7236
7<NA>금천구소통담당관 정보화운영팀김도익02-2627-1115
8<NA>노원구미디어홍보담당관 전산운영팀남량경02-2116-3432
9<NA>동작구교육미래과 디지털정보팀정연훈02-820-1522
Unnamed: 0자치구담당부서담당자전화번호
12<NA>성동구정보통신과 정보기획팀신은섭02-2286-6379
13<NA>성북구홍보전산과 정보화운영팀조미혜02-2241-4534
14<NA>송파구의약과 의무2팀최신혜02-2147-3536
15<NA>양천구스마트정보과 디지털운영팀정은총02-2620-3249
16<NA>영등포구홍보미디어과 전산운영팀이민준02-2670-4249
17<NA>용산구스마트정보과 스마트지원팀김우림02-2199-6634
18<NA>은평구스마트정보과 전산운영팀김은회02-351-6373
19<NA>종로구스마트도시과 스마트기반사업팀전경배02-2148-1745
20<NA>중구의약과 정신건강팀이민정02-3396-6383
21<NA>중랑구행정지원과 정보화운영팀안서영02-2094-0395