Overview

Dataset statistics

Number of variables7
Number of observations36
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory62.7 B

Variable types

Text3
Numeric3
DateTime1

Dataset

Description부산광역시_사상구_공공기관현황_20230410
Author부산광역시 사상구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15025564

Alerts

데이터기준일자 has constant value ""Constant
위도 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:05:29.828529
Analysis finished2023-12-10 17:05:32.064263
Duration2.24 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정공공기관명
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-11T02:05:32.269334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17
Mean length9.5833333
Min length5

Characters and Unicode

Total characters345
Distinct characters88
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

Unique36 ?
Unique (%)100.0%

Sample

1st row부산광역시 사상구청
2nd row부산광역시 부산도서관
3rd row부산광역시 사상도서관
4th row부산광역시 사상구보건소
5th row부산사상경찰서
ValueCountFrequency (%)
부산광역시 7
 
15.9%
모라1동행정복지센터 1
 
2.3%
사상구종합사회복지관 1
 
2.3%
모라3동행정복지센터 1
 
2.3%
학장사회복지관 1
 
2.3%
사상구장애인복지관 1
 
2.3%
다누림센터 1
 
2.3%
국제화센터 1
 
2.3%
삼락동행정복지센터 1
 
2.3%
덕포1동행정복지센터 1
 
2.3%
Other values (28) 28
63.6%
2023-12-11T02:05:32.812977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
지 21
 
6.1%
부 20
 
5.8%
산 18
 
5.2%
복 17
 
4.9%
사 16
 
4.6%
센 15
 
4.3%
터 15
 
4.3%
동 14
 
4.1%
정 12
 
3.5%
행 12
 
3.5%
Other values (78) 185
53.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 330
95.7%
Space Separator 8
 
2.3%
Decimal Number 7
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 21
 
6.4%
부 20
 
6.1%
산 18
 
5.5%
복 17
 
5.2%
사 16
 
4.8%
센 15
 
4.5%
터 15
 
4.5%
동 14
 
4.2%
정 12
 
3.6%
행 12
 
3.6%
Other values (74) 170
51.5%
Decimal Number
ValueCountFrequency (%)
1 3
42.9%
3 2
28.6%
2 2
28.6%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 330
95.7%
Common 15
 
4.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 21
 
6.4%
부 20
 
6.1%
산 18
 
5.5%
복 17
 
5.2%
사 16
 
4.8%
센 15
 
4.5%
터 15
 
4.5%
동 14
 
4.2%
정 12
 
3.6%
행 12
 
3.6%
Other values (74) 170
51.5%
Common
ValueCountFrequency (%)
8
53.3%
1 3
 
20.0%
3 2
 
13.3%
2 2
 
13.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 330
95.7%
ASCII 15
 
4.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
지 21
 
6.4%
부 20
 
6.1%
산 18
 
5.5%
복 17
 
5.2%
사 16
 
4.8%
센 15
 
4.5%
터 15
 
4.5%
동 14
 
4.2%
정 12
 
3.6%
행 12
 
3.6%
Other values (74) 170
51.5%
ASCII
ValueCountFrequency (%)
8
53.3%
1 3
 
20.0%
3 2
 
13.3%
2 2
 
13.3%

도로명주소
Text

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-11T02:05:33.172009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length27.5
Mean length23.444444
Min length13

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)94.4%

Sample

1st row부산광역시 사상구 학감대로 242 (감전동)
2nd row부산광역시 사상구 사상로310번길 33 (덕포동)
3rd row부산광역시 사상구 덕상로72번길 9 (덕포동)
4th row부산광역시 사상구 학감대로 242 (감전동)
5th row부산광역시 사상구 학감대로 264 (감전동)
ValueCountFrequency (%)
사상구 36
21.4%
부산광역시 35
20.8%
덕포동 6
 
3.6%
학감대로 5
 
3.0%
감전동 5
 
3.0%
모라동 4
 
2.4%
백양대로 3
 
1.8%
학장동 3
 
1.8%
주례동 3
 
1.8%
모라로192번길 2
 
1.2%
Other values (58) 66
39.3%
2023-12-11T02:05:33.836916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
132
 
15.6%
상 43
 
5.1%
사 40
 
4.7%
산 37
 
4.4%
시 37
 
4.4%
로 36
 
4.3%
구 36
 
4.3%
부 36
 
4.3%
광 36
 
4.3%
역 35
 
4.1%
Other values (45) 376
44.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 523
62.0%
Decimal Number 138
 
16.4%
Space Separator 132
 
15.6%
Open Punctuation 24
 
2.8%
Close Punctuation 24
 
2.8%
Dash Punctuation 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
상 43
 
8.2%
사 40
 
7.6%
산 37
 
7.1%
시 37
 
7.1%
로 36
 
6.9%
구 36
 
6.9%
부 36
 
6.9%
광 36
 
6.9%
역 35
 
6.7%
동 26
 
5.0%
Other values (31) 161
30.8%
Decimal Number
ValueCountFrequency (%)
1 30
21.7%
2 26
18.8%
9 17
12.3%
3 14
10.1%
5 11
 
8.0%
7 10
 
7.2%
0 9
 
6.5%
6 8
 
5.8%
4 7
 
5.1%
8 6
 
4.3%
Space Separator
ValueCountFrequency (%)
132
100.0%
Open Punctuation
ValueCountFrequency (%)
( 24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 523
62.0%
Common 321
38.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
상 43
 
8.2%
사 40
 
7.6%
산 37
 
7.1%
시 37
 
7.1%
로 36
 
6.9%
구 36
 
6.9%
부 36
 
6.9%
광 36
 
6.9%
역 35
 
6.7%
동 26
 
5.0%
Other values (31) 161
30.8%
Common
ValueCountFrequency (%)
132
41.1%
1 30
 
9.3%
2 26
 
8.1%
( 24
 
7.5%
) 24
 
7.5%
9 17
 
5.3%
3 14
 
4.4%
5 11
 
3.4%
7 10
 
3.1%
0 9
 
2.8%
Other values (4) 24
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 523
62.0%
ASCII 321
38.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
132
41.1%
1 30
 
9.3%
2 26
 
8.1%
( 24
 
7.5%
) 24
 
7.5%
9 17
 
5.3%
3 14
 
4.4%
5 11
 
3.4%
7 10
 
3.1%
0 9
 
2.8%
Other values (4) 24
 
7.5%
Hangul
ValueCountFrequency (%)
상 43
 
8.2%
사 40
 
7.6%
산 37
 
7.1%
시 37
 
7.1%
로 36
 
6.9%
구 36
 
6.9%
부 36
 
6.9%
광 36
 
6.9%
역 35
 
6.7%
동 26
 
5.0%
Other values (31) 161
30.8%

전화번호
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-11T02:05:34.191093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique36 ?
Unique (%)100.0%

Sample

1st row051-310-4000
2nd row051-310-5400
3rd row051-310-7971
4th row051-310-4791
5th row051-329-0230
ValueCountFrequency (%)
051-310-4000 1
 
2.8%
051-310-5400 1
 
2.8%
051-310-3060 1
 
2.8%
051-311-4017 1
 
2.8%
051-302-5523 1
 
2.8%
051-319-7330 1
 
2.8%
051-366-0505 1
 
2.8%
051-310-3020 1
 
2.8%
051-310-3040 1
 
2.8%
051-310-3080 1
 
2.8%
Other values (26) 26
72.2%
2023-12-11T02:05:34.751318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 100
23.1%
1 81
18.8%
- 72
16.7%
3 58
13.4%
5 47
10.9%
2 21
 
4.9%
4 15
 
3.5%
9 10
 
2.3%
6 10
 
2.3%
7 9
 
2.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 360
83.3%
Dash Punctuation 72
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 100
27.8%
1 81
22.5%
3 58
16.1%
5 47
13.1%
2 21
 
5.8%
4 15
 
4.2%
9 10
 
2.8%
6 10
 
2.8%
7 9
 
2.5%
8 9
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 432
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 100
23.1%
1 81
18.8%
- 72
16.7%
3 58
13.4%
5 47
10.9%
2 21
 
4.9%
4 15
 
3.5%
9 10
 
2.3%
6 10
 
2.3%
7 9
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 432
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 100
23.1%
1 81
18.8%
- 72
16.7%
3 58
13.4%
5 47
10.9%
2 21
 
4.9%
4 15
 
3.5%
9 10
 
2.3%
6 10
 
2.3%
7 9
 
2.1%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.161859
Minimum35.128681
Maximum35.187073
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-11T02:05:34.969292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.128681
5-th percentile35.134998
Q135.147329
median35.157878
Q335.178338
95-th percentile35.184912
Maximum35.187073
Range0.058392
Interquartile range (IQR)0.0310085

Descriptive statistics

Standard deviation0.017872747
Coefficient of variation (CV)0.00050829926
Kurtosis-1.2769173
Mean35.161859
Median Absolute Deviation (MAD)0.0166135
Skewness-0.1495949
Sum1265.8269
Variance0.00031943508
MonotonicityNot monotonic
2023-12-11T02:05:35.202137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
35.152547 2
 
5.6%
35.172725 1
 
2.8%
35.184901 1
 
2.8%
35.147255 1
 
2.8%
35.177602 1
 
2.8%
35.177006 1
 
2.8%
35.187073 1
 
2.8%
35.184653 1
 
2.8%
35.170362 1
 
2.8%
35.174457 1
 
2.8%
Other values (25) 25
69.4%
ValueCountFrequency (%)
35.128681 1
2.8%
35.12869 1
2.8%
35.137101 1
2.8%
35.138111 1
2.8%
35.140076 1
2.8%
35.144099 1
2.8%
35.14567 1
2.8%
35.146038 1
2.8%
35.147255 1
2.8%
35.147354 1
2.8%
ValueCountFrequency (%)
35.187073 1
2.8%
35.184944 1
2.8%
35.184901 1
2.8%
35.184653 1
2.8%
35.183724 1
2.8%
35.183319 1
2.8%
35.181196 1
2.8%
35.180911 1
2.8%
35.179033 1
2.8%
35.178106 1
2.8%

경도
Real number (ℝ)

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.98917
Minimum128.96428
Maximum129.01042
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-11T02:05:35.802159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.96428
5-th percentile128.97131
Q1128.98528
median128.98995
Q3128.9948
95-th percentile129.00132
Maximum129.01042
Range0.046138
Interquartile range (IQR)0.009513

Descriptive statistics

Standard deviation0.0093804796
Coefficient of variation (CV)7.2723003 × 10-5
Kurtosis1.0103072
Mean128.98917
Median Absolute Deviation (MAD)0.004792
Skewness-0.55704466
Sum4643.61
Variance8.7993397 × 10-5
MonotonicityNot monotonic
2023-12-11T02:05:36.058849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
128.991451 2
 
5.6%
128.985296 1
 
2.8%
129.000936 1
 
2.8%
128.994844 1
 
2.8%
128.990845 1
 
2.8%
128.977641 1
 
2.8%
128.990081 1
 
2.8%
128.996058 1
 
2.8%
128.983248 1
 
2.8%
128.982968 1
 
2.8%
Other values (25) 25
69.4%
ValueCountFrequency (%)
128.96428 1
2.8%
128.968648 1
2.8%
128.972202 1
2.8%
128.977641 1
2.8%
128.978753 1
2.8%
128.979409 1
2.8%
128.982968 1
2.8%
128.983248 1
2.8%
128.985241 1
2.8%
128.985296 1
2.8%
ValueCountFrequency (%)
129.010418 1
2.8%
129.001419 1
2.8%
129.001293 1
2.8%
129.000936 1
2.8%
128.999351 1
2.8%
128.997873 1
2.8%
128.996969 1
2.8%
128.996058 1
2.8%
128.994844 1
2.8%
128.994779 1
2.8%

우편번호
Real number (ℝ)

HIGH CORRELATION 

Distinct28
Distinct (%)77.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46976
Minimum46910
Maximum47054
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-11T02:05:36.301994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum46910
5-th percentile46924.5
Q146938
median46979
Q347015.25
95-th percentile47042.5
Maximum47054
Range144
Interquartile range (IQR)77.25

Descriptive statistics

Standard deviation42.197495
Coefficient of variation (CV)0.00089827773
Kurtosis-1.2064184
Mean46976
Median Absolute Deviation (MAD)41
Skewness0.24367861
Sum1691136
Variance1780.6286
MonotonicityNot monotonic
2023-12-11T02:05:36.545640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
46938 4
 
11.1%
46985 3
 
8.3%
47016 2
 
5.6%
46934 2
 
5.6%
46935 2
 
5.6%
46911 1
 
2.8%
47023 1
 
2.8%
47039 1
 
2.8%
47015 1
 
2.8%
47007 1
 
2.8%
Other values (18) 18
50.0%
ValueCountFrequency (%)
46910 1
 
2.8%
46911 1
 
2.8%
46929 1
 
2.8%
46931 1
 
2.8%
46934 2
5.6%
46935 2
5.6%
46938 4
11.1%
46943 1
 
2.8%
46946 1
 
2.8%
46949 1
 
2.8%
ValueCountFrequency (%)
47054 1
2.8%
47053 1
2.8%
47039 1
2.8%
47032 1
2.8%
47030 1
2.8%
47023 1
2.8%
47022 1
2.8%
47016 2
5.6%
47015 1
2.8%
47007 1
2.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
Minimum2023-04-10 00:00:00
Maximum2023-04-10 00:00:00
2023-12-11T02:05:36.745918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:36.919238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T02:05:31.199624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:30.245904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:30.735065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:31.417989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:30.401056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:30.888669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:31.587737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:30.569779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:05:31.030881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T02:05:37.053115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정공공기관명도로명주소전화번호위도경도우편번호
행정공공기관명1.0001.0001.0001.0001.0001.000
도로명주소1.0001.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
위도1.0001.0001.0001.0000.8410.977
경도1.0001.0001.0000.8411.0000.908
우편번호1.0001.0001.0000.9770.9081.000
2023-12-11T02:05:37.226344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도우편번호
위도1.0000.141-0.947
경도0.1411.000-0.016
우편번호-0.947-0.0161.000

Missing values

2023-12-11T02:05:31.805597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:05:31.996995image/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부산광역시 사상구청부산광역시 사상구 학감대로 242 (감전동)051-310-400035.152547128.991451469852023-04-10
1부산광역시 부산도서관부산광역시 사상구 사상로310번길 33 (덕포동)051-310-540035.172725128.985296469492023-04-10
2부산광역시 사상도서관부산광역시 사상구 덕상로72번길 9 (덕포동)051-310-797135.178106128.989808469382023-04-10
3부산광역시 사상구보건소부산광역시 사상구 학감대로 242 (감전동)051-310-479135.152547128.991451469852023-04-10
4부산사상경찰서부산광역시 사상구 학감대로 264 (감전동)051-329-023035.154368128.991364469852023-04-10
5부산북부소방서부산광역시 사상구 삼덕로 17 (삼락동)051-302-011935.174527128.978753469102023-04-10
6부산사상우체국부산광역시 사상구 사상로 165 (괘법동)051-320-333135.160326128.985871469742023-04-10
7부산 북부산세무서부산광역시 사상구 학감대로 263 (감전동)051-310-620035.154657128.99028469842023-04-10
8부산지방노동청북부지청부산광역시 사상구 백양대로 804 (덕포동)051-309-150035.179033128.988908469382023-04-10
9부산광역시 청소년수련관부산광역시 사상구 덕상로 129 (모라동)051-316-221435.183319128.990563469312023-04-10
행정공공기관명도로명주소전화번호위도경도우편번호데이터기준일자
26모라3동행정복지센터부산광역시 사상구 모라로110번길 99051-310-306035.184653128.996058469342023-04-10
27덕포1동행정복지센터부산광역시 사상구 사상로292번길 12051-310-308035.170362128.983248469542023-04-10
28덕포2동행정복지센터부산광역시 사상구 사상로333번길 17051-310-310035.174457128.982968469462023-04-10
29괘법동행정복지센터부산광역시 사상구 광장로97번길 6051-310-312035.163759128.987197469672023-04-10
30감전동행정복지센터부산광역시 사상구 새벽시장로56번길 20051-310-314035.154204128.979409469892023-04-10
31주례1동행정복지센터부산광역시 사상구 가야대로255번길 17-8051-310-316035.151393129.001293470022023-04-10
32주례2동행정복지센터부산광역시 사상구 주례로10번길 15051-310-318035.150064129.010418470072023-04-10
33주례3동행정복지센터부산광역시 사상구 냉정로 10051-310-320035.147354129.001419470152023-04-10
34엄궁동행정복지센터부산광역시 사상구 엄궁북로 15051-310-324035.12869128.972202470392023-04-10
35학장동행정복지센터부산광역시 사상구 학감대로147번길 11051-310-322035.144099128.98731470232023-04-10