Overview

Dataset statistics

Number of variables3
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory732.0 B
Average record size in memory30.5 B

Variable types

Numeric1
Text1
Categorical1

Dataset

Description부산시설공단정책실명제등록정보_20200630
Author부산시설공단
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3041099

Alerts

등록번호 is highly overall correlated with 소관부서High correlation
소관부서 is highly overall correlated with 등록번호High correlation
등록번호 has unique valuesUnique
정 책 명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 17:08:08.037139
Analysis finished2023-12-10 17:08:08.644963
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2012.5
Minimum2001
Maximum2024
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-11T02:08:08.762877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2001
5-th percentile2002.15
Q12006.75
median2012.5
Q32018.25
95-th percentile2022.85
Maximum2024
Range23
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation7.0710678
Coefficient of variation (CV)0.0035135741
Kurtosis-1.2
Mean2012.5
Median Absolute Deviation (MAD)6
Skewness0
Sum48300
Variance50
MonotonicityStrictly increasing
2023-12-11T02:08:09.008036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
2001 1
 
4.2%
2014 1
 
4.2%
2024 1
 
4.2%
2023 1
 
4.2%
2022 1
 
4.2%
2021 1
 
4.2%
2020 1
 
4.2%
2019 1
 
4.2%
2018 1
 
4.2%
2017 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
2001 1
4.2%
2002 1
4.2%
2003 1
4.2%
2004 1
4.2%
2005 1
4.2%
2006 1
4.2%
2007 1
4.2%
2008 1
4.2%
2009 1
4.2%
2010 1
4.2%
ValueCountFrequency (%)
2024 1
4.2%
2023 1
4.2%
2022 1
4.2%
2021 1
4.2%
2020 1
4.2%
2019 1
4.2%
2018 1
4.2%
2017 1
4.2%
2016 1
4.2%
2015 1
4.2%

정 책 명
Text

UNIQUE 

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

Length

Max length28
Median length18
Mean length17.041667
Min length8

Characters and Unicode

Total characters409
Distinct characters129
Distinct categories4 ?
Distinct scripts3 ?
Distinct blocks3 ?
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번영로 구서IC 노면개선
4th row광안대교 강교도장 보수
5th row해상교량 강관파일 방식 보수
ValueCountFrequency (%)
광안대로 4
 
4.5%
정비공사 3
 
3.4%
노면개선 3
 
3.4%
보수 3
 
3.4%
태종대유원지 2
 
2.2%
화장실 2
 
2.2%
남포·광복지하도상가 2
 
2.2%
서면지하도상가 2
 
2.2%
중앙몰 2
 
2.2%
수배전설비 2
 
2.2%
Other values (59) 64
71.9%
2023-12-11T02:08:10.182364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
65
 
15.9%
11
 
2.7%
11
 
2.7%
9
 
2.2%
9
 
2.2%
9
 
2.2%
8
 
2.0%
8
 
2.0%
8
 
2.0%
8
 
2.0%
Other values (119) 263
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 338
82.6%
Space Separator 65
 
15.9%
Other Punctuation 4
 
1.0%
Uppercase Letter 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
11
 
3.3%
11
 
3.3%
9
 
2.7%
9
 
2.7%
9
 
2.7%
8
 
2.4%
8
 
2.4%
8
 
2.4%
8
 
2.4%
7
 
2.1%
Other values (115) 250
74.0%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
I 1
50.0%
Space Separator
ValueCountFrequency (%)
65
100.0%
Other Punctuation
ValueCountFrequency (%)
· 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 338
82.6%
Common 69
 
16.9%
Latin 2
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
11
 
3.3%
11
 
3.3%
9
 
2.7%
9
 
2.7%
9
 
2.7%
8
 
2.4%
8
 
2.4%
8
 
2.4%
8
 
2.4%
7
 
2.1%
Other values (115) 250
74.0%
Common
ValueCountFrequency (%)
65
94.2%
· 4
 
5.8%
Latin
ValueCountFrequency (%)
C 1
50.0%
I 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 338
82.6%
ASCII 67
 
16.4%
None 4
 
1.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
65
97.0%
C 1
 
1.5%
I 1
 
1.5%
Hangul
ValueCountFrequency (%)
11
 
3.3%
11
 
3.3%
9
 
2.7%
9
 
2.7%
9
 
2.7%
8
 
2.4%
8
 
2.4%
8
 
2.4%
8
 
2.4%
7
 
2.1%
Other values (115) 250
74.0%
None
ValueCountFrequency (%)
· 4
100.0%

소관부서
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)41.7%
Missing0
Missing (%)0.0%
Memory size324.0 B
교량시설팀
상가기획팀
공원기획팀
도로시설팀
교량기전팀
Other values (5)

Length

Max length11
Median length5
Mean length5.625
Min length5

Unique

Unique5 ?
Unique (%)20.8%

Sample

1st row도로시설팀
2nd row도로시설팀
3rd row도로시설팀
4th row교량시설팀
5th row교량시설팀

Common Values

ValueCountFrequency (%)
교량시설팀 5
20.8%
상가기획팀 4
16.7%
공원기획팀 4
16.7%
도로시설팀 3
12.5%
교량기전팀 3
12.5%
자갈치시장사업소 1
 
4.2%
한마음스포츠센터사업소 1
 
4.2%
남부지하도상가사업소 1
 
4.2%
플랫폼시설팀 1
 
4.2%
장사시설팀 1
 
4.2%

Length

2023-12-11T02:08:10.453410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T02:08:10.694056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교량시설팀 5
20.8%
상가기획팀 4
16.7%
공원기획팀 4
16.7%
도로시설팀 3
12.5%
교량기전팀 3
12.5%
자갈치시장사업소 1
 
4.2%
한마음스포츠센터사업소 1
 
4.2%
남부지하도상가사업소 1
 
4.2%
플랫폼시설팀 1
 
4.2%
장사시설팀 1
 
4.2%

Interactions

2023-12-11T02:08:08.271632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T02:08:10.867148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록번호정 책 명소관부서
등록번호1.0001.0000.944
정 책 명1.0001.0001.000
소관부서0.9441.0001.000
2023-12-11T02:08:11.019742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록번호소관부서
등록번호1.0000.604
소관부서0.6041.000

Missing values

2023-12-11T02:08:08.455530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:08:08.593042image/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

등록번호정 책 명소관부서
02001동서로 노면개선도로시설팀
12002번영로 노면개선도로시설팀
22003번영로 구서IC 노면개선도로시설팀
32004광안대교 강교도장 보수교량시설팀
42005해상교량 강관파일 방식 보수교량시설팀
52006광안대로 노후 포장 보수교량시설팀
62007광안대로 시설물 정비교량시설팀
72008광안대로 교각 탄산화 방지교량시설팀
82009광안대로 돌발상황 관리시스템 구축교량기전팀
92010광안대교 해상경보 시스템 구축교량기전팀
등록번호정 책 명소관부서
142015부전몰 스크류냉동기 제작·구매상가기획팀
152016서면지하도상가 중앙몰 수배전설비 제작·설치상가기획팀
162017서면지하도상가 중앙몰 수배전설비 교체 전기공사상가기획팀
172018남포·광복지하도상가 공공보도 노후 간접조명 교체공사상가기획팀
182019부산유라시아플랫폼 야간경관 조성플랫폼시설팀
192020태종대유원지 의료지원단 참전기념비 정비공사공원기획팀
202021태종대유원지 등대 진입로 정비공사공원기획팀
212022중앙공원 충혼탑 화장실 신축공사공원기획팀
222023어린이대공원 산림유역 관리사업공원기획팀
232024영락공원 화장로 설비 정비사업장사시설팀