Overview

Dataset statistics

Number of variables8
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory70.5 B

Variable types

Categorical7
Text1

Dataset

Description서울특별시 강남구의 옐로카펫 위치 현황으로 학교명, 설치위치, 설치년도, 관리기관명, 관리기관전화번호 등 자료입니다
Author서울특별시 강남구
URLhttps://www.data.go.kr/data/15038053/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일 has constant value ""Constant
설치위치 is highly imbalanced (58.6%)Imbalance
학교명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:31:30.324564
Analysis finished2023-12-12 08:31:30.640042
Duration0.32 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
서울특별시
24 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시
2nd row서울특별시
3rd row서울특별시
4th row서울특별시
5th row서울특별시

Common Values

ValueCountFrequency (%)
서울특별시 24
100.0%

Length

2023-12-12T17:31:30.708338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:31.073800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 24
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
강남구
24 

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 (%)
강남구 24
100.0%

Length

2023-12-12T17:31:31.159625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:31.246201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강남구 24
100.0%

학교명
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-12-12T17:31:31.389400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length6.0416667
Min length6

Characters and Unicode

Total characters145
Distinct characters39
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

Unique24 ?
Unique (%)100.0%

Sample

1st row일원초등학교
2nd row자곡초등학교
3rd row대진초등학교
4th row논현초등학교
5th row대왕초등학교
ValueCountFrequency (%)
일원초등학교 1
 
4.2%
자곡초등학교 1
 
4.2%
대치초등학교 1
 
4.2%
포이초등학교 1
 
4.2%
도성초등학교 1
 
4.2%
언북초등학교 1
 
4.2%
세명초등학교 1
 
4.2%
청담초등학교 1
 
4.2%
율현초등학교 1
 
4.2%
영희초등학교 1
 
4.2%
Other values (14) 14
58.3%
2023-12-12T17:31:31.725868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
초 24
16.6%
등 24
16.6%
학 24
16.6%
교 24
16.6%
대 6
 
4.1%
구 3
 
2.1%
일 2
 
1.4%
현 2
 
1.4%
청 2
 
1.4%
도 2
 
1.4%
Other values (29) 32
22.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 145
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
초 24
16.6%
등 24
16.6%
학 24
16.6%
교 24
16.6%
대 6
 
4.1%
구 3
 
2.1%
일 2
 
1.4%
현 2
 
1.4%
청 2
 
1.4%
도 2
 
1.4%
Other values (29) 32
22.1%

Most occurring scripts

ValueCountFrequency (%)
Hangul 145
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
초 24
16.6%
등 24
16.6%
학 24
16.6%
교 24
16.6%
대 6
 
4.1%
구 3
 
2.1%
일 2
 
1.4%
현 2
 
1.4%
청 2
 
1.4%
도 2
 
1.4%
Other values (29) 32
22.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 145
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
초 24
16.6%
등 24
16.6%
학 24
16.6%
교 24
16.6%
대 6
 
4.1%
구 3
 
2.1%
일 2
 
1.4%
현 2
 
1.4%
청 2
 
1.4%
도 2
 
1.4%
Other values (29) 32
22.1%

설치위치
Categorical

IMBALANCE 

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
학교정문 옆
22 
학교정문 앞
 
2

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row학교정문 옆
2nd row학교정문 앞
3rd row학교정문 앞
4th row학교정문 옆
5th row학교정문 옆

Common Values

ValueCountFrequency (%)
학교정문 옆 22
91.7%
학교정문 앞 2
 
8.3%

Length

2023-12-12T17:31:31.874072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:31.963825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
학교정문 24
50.0%
옆 22
45.8%
앞 2
 
4.2%

설치년도
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
2020
18 
2019
6 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 18
75.0%
2019 6
 
25.0%

Length

2023-12-12T17:31:32.066027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:32.161920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 18
75.0%
2019 6
 
25.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
서울특별시 강남구청
24 

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 (%)
서울특별시 강남구청 24
100.0%

Length

2023-12-12T17:31:32.306263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:32.401782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 24
50.0%
강남구청 24
50.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
02-3423-6402
24 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row02-3423-6402
2nd row02-3423-6402
3rd row02-3423-6402
4th row02-3423-6402
5th row02-3423-6402

Common Values

ValueCountFrequency (%)
02-3423-6402 24
100.0%

Length

2023-12-12T17:31:32.522704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:32.632336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
02-3423-6402 24
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
2022-07-11
24 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-07-11
2nd row2022-07-11
3rd row2022-07-11
4th row2022-07-11
5th row2022-07-11

Common Values

ValueCountFrequency (%)
2022-07-11 24
100.0%

Length

2023-12-12T17:31:32.729549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:31:32.826528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-07-11 24
100.0%

Correlations

2023-12-12T17:31:32.884295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
학교명설치위치설치년도
학교명1.0001.0001.000
설치위치1.0001.0000.437
설치년도1.0000.4371.000
2023-12-12T17:31:32.979415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치위치설치년도
설치위치1.0000.285
설치년도0.2851.000
2023-12-12T17:31:33.081258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치위치설치년도
설치위치1.0000.285
설치년도0.2851.000

Missing values

2023-12-12T17:31:30.480484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:31:30.595808image/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서울특별시강남구일원초등학교학교정문 옆2019서울특별시 강남구청02-3423-64022022-07-11
1서울특별시강남구자곡초등학교학교정문 앞2019서울특별시 강남구청02-3423-64022022-07-11
2서울특별시강남구대진초등학교학교정문 앞2019서울특별시 강남구청02-3423-64022022-07-11
3서울특별시강남구논현초등학교학교정문 옆2019서울특별시 강남구청02-3423-64022022-07-11
4서울특별시강남구대왕초등학교학교정문 옆2019서울특별시 강남구청02-3423-64022022-07-11
5서울특별시강남구구룡초등학교학교정문 옆2019서울특별시 강남구청02-3423-64022022-07-11
6서울특별시강남구개일초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
7서울특별시강남구대도초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
8서울특별시강남구대청초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
9서울특별시강남구대모초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
시도명시군구명학교명설치위치설치년도관리기관명관리기관전화번호데이터기준일
14서울특별시강남구언주초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
15서울특별시강남구영희초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
16서울특별시강남구율현초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
17서울특별시강남구청담초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
18서울특별시강남구세명초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
19서울특별시강남구언북초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
20서울특별시강남구도성초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
21서울특별시강남구포이초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
22서울특별시강남구대치초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11
23서울특별시강남구압구정초등학교학교정문 옆2020서울특별시 강남구청02-3423-64022022-07-11