Overview

Dataset statistics

Number of variables8
Number of observations173
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.0 KiB
Average record size in memory70.8 B

Variable types

Numeric2
Text1
Categorical5

Dataset

Description전주시설관리공단 시 지정게시대 현황 자료로 완산구, 덕진구 내 게시대 명칭, 면수, 기간, 금액 등에 대한 자료입니다.
Author전주시시설관리공단
URLhttps://www.data.go.kr/data/15003203/fileData.do

Alerts

기간 has constant value ""Constant
금액 has constant value ""Constant
가로 has constant value ""Constant
세로 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-12 17:36:15.077715
Analysis finished2023-12-12 17:36:16.016478
Duration0.94 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct173
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean87
Minimum1
Maximum173
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-13T02:36:16.116794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.6
Q144
median87
Q3130
95-th percentile164.4
Maximum173
Range172
Interquartile range (IQR)86

Descriptive statistics

Standard deviation50.084928
Coefficient of variation (CV)0.57568883
Kurtosis-1.2
Mean87
Median Absolute Deviation (MAD)43
Skewness0
Sum15051
Variance2508.5
MonotonicityStrictly increasing
2023-12-13T02:36:16.375458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
120 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
116 1
 
0.6%
117 1
 
0.6%
118 1
 
0.6%
119 1
 
0.6%
Other values (163) 163
94.2%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
173 1
0.6%
172 1
0.6%
171 1
0.6%
170 1
0.6%
169 1
0.6%
168 1
0.6%
167 1
0.6%
166 1
0.6%
165 1
0.6%
164 1
0.6%

게시대명칭
Text

UNIQUE 

Distinct173
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T02:36:17.065135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length18
Mean length14.630058
Min length8

Characters and Unicode

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

Unique

Unique173 ?
Unique (%)100.0%

Sample

1st row색장동 은석골동부로삼거리 정면
2nd row색장동 은석골동부로삼거리 측면
3rd row동서학동 좁은목약수터 사거리
4th row전동 싸전다리(전동)
5th row서서학동 싸전다리 전면
ValueCountFrequency (%)
효자동 33
 
6.6%
사거리 24
 
4.8%
서신동 18
 
3.6%
앞 16
 
3.2%
옆 15
 
3.0%
에코시티 11
 
2.2%
우아동 10
 
2.0%
팔복동 9
 
1.8%
송천동 9
 
1.8%
혁신동 9
 
1.8%
Other values (221) 349
69.4%
2023-12-13T02:36:17.706228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
330
 
13.0%
동 188
 
7.4%
리 97
 
3.8%
) 83
 
3.3%
거 83
 
3.3%
( 82
 
3.2%
사 62
 
2.4%
우 51
 
2.0%
아 48
 
1.9%
앞 38
 
1.5%
Other values (236) 1469
58.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1945
76.8%
Space Separator 330
 
13.0%
Close Punctuation 83
 
3.3%
Open Punctuation 82
 
3.2%
Decimal Number 57
 
2.3%
Uppercase Letter 26
 
1.0%
Other Punctuation 3
 
0.1%
Lowercase Letter 3
 
0.1%
Dash Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 188
 
9.7%
리 97
 
5.0%
거 83
 
4.3%
사 62
 
3.2%
우 51
 
2.6%
아 48
 
2.5%
앞 38
 
2.0%
옆 37
 
1.9%
효 36
 
1.9%
자 35
 
1.8%
Other values (209) 1270
65.3%
Uppercase Letter
ValueCountFrequency (%)
L 5
19.2%
T 4
15.4%
A 3
11.5%
B 2
 
7.7%
H 2
 
7.7%
P 2
 
7.7%
J 1
 
3.8%
C 1
 
3.8%
I 1
 
3.8%
X 1
 
3.8%
Other values (4) 4
15.4%
Decimal Number
ValueCountFrequency (%)
1 16
28.1%
0 11
19.3%
3 10
17.5%
2 9
15.8%
4 7
12.3%
5 4
 
7.0%
Lowercase Letter
ValueCountFrequency (%)
c 2
66.7%
k 1
33.3%
Space Separator
ValueCountFrequency (%)
330
100.0%
Close Punctuation
ValueCountFrequency (%)
) 83
100.0%
Open Punctuation
ValueCountFrequency (%)
( 82
100.0%
Other Punctuation
ValueCountFrequency (%)
@ 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1945
76.8%
Common 557
 
22.0%
Latin 29
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 188
 
9.7%
리 97
 
5.0%
거 83
 
4.3%
사 62
 
3.2%
우 51
 
2.6%
아 48
 
2.5%
앞 38
 
2.0%
옆 37
 
1.9%
효 36
 
1.9%
자 35
 
1.8%
Other values (209) 1270
65.3%
Latin
ValueCountFrequency (%)
L 5
17.2%
T 4
13.8%
A 3
10.3%
c 2
 
6.9%
B 2
 
6.9%
H 2
 
6.9%
P 2
 
6.9%
J 1
 
3.4%
C 1
 
3.4%
I 1
 
3.4%
Other values (6) 6
20.7%
Common
ValueCountFrequency (%)
330
59.2%
) 83
 
14.9%
( 82
 
14.7%
1 16
 
2.9%
0 11
 
2.0%
3 10
 
1.8%
2 9
 
1.6%
4 7
 
1.3%
5 4
 
0.7%
@ 3
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1945
76.8%
ASCII 586
 
23.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
330
56.3%
) 83
 
14.2%
( 82
 
14.0%
1 16
 
2.7%
0 11
 
1.9%
3 10
 
1.7%
2 9
 
1.5%
4 7
 
1.2%
L 5
 
0.9%
5 4
 
0.7%
Other values (17) 29
 
4.9%
Hangul
ValueCountFrequency (%)
동 188
 
9.7%
리 97
 
5.0%
거 83
 
4.3%
사 62
 
3.2%
우 51
 
2.6%
아 48
 
2.5%
앞 38
 
2.0%
옆 37
 
1.9%
효 36
 
1.9%
자 35
 
1.8%
Other values (209) 1270
65.3%

면수
Real number (ℝ)

Distinct6
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.7687861
Minimum2
Maximum7
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-13T02:36:17.848591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile4.6
Q15
median6
Q36
95-th percentile7
Maximum7
Range5
Interquartile range (IQR)1

Descriptive statistics

Standard deviation0.87852759
Coefficient of variation (CV)0.15228985
Kurtosis1.2779748
Mean5.7687861
Median Absolute Deviation (MAD)1
Skewness-0.62266842
Sum998
Variance0.77181073
MonotonicityNot monotonic
2023-12-13T02:36:17.977139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
6 75
43.4%
5 54
31.2%
7 35
20.2%
4 7
 
4.0%
3 1
 
0.6%
2 1
 
0.6%
ValueCountFrequency (%)
2 1
 
0.6%
3 1
 
0.6%
4 7
 
4.0%
5 54
31.2%
6 75
43.4%
7 35
20.2%
ValueCountFrequency (%)
7 35
20.2%
6 75
43.4%
5 54
31.2%
4 7
 
4.0%
3 1
 
0.6%
2 1
 
0.6%

기간
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
7
173 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
7 173
100.0%

Length

2023-12-13T02:36:18.095128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:36:18.207632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7 173
100.0%

금액
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
6000
173 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
6000 173
100.0%

Length

2023-12-13T02:36:18.325829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:36:18.443383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
6000 173
100.0%

행정동
Categorical

HIGH CORRELATION 

Distinct39
Distinct (%)22.5%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
서신동
18 
효자동3가
17 
효자동2가
12 
장동
11 
송천동2가
 
10
Other values (34)
105 

Length

Max length6
Median length5
Mean length4.265896
Min length2

Unique

Unique7 ?
Unique (%)4.0%

Sample

1st row색장동
2nd row색장동
3rd row동서학동
4th row전동
5th row서서학동

Common Values

ValueCountFrequency (%)
서신동 18
 
10.4%
효자동3가 17
 
9.8%
효자동2가 12
 
6.9%
장동 11
 
6.4%
송천동2가 10
 
5.8%
호성동1가 6
 
3.5%
인후동1가 6
 
3.5%
송천동1가 6
 
3.5%
만성동 5
 
2.9%
팔복동1가 5
 
2.9%
Other values (29) 77
44.5%

Length

2023-12-13T02:36:18.567139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서신동 18
 
10.4%
효자동3가 17
 
9.8%
효자동2가 12
 
6.9%
장동 11
 
6.4%
송천동2가 10
 
5.8%
호성동1가 6
 
3.5%
인후동1가 6
 
3.5%
송천동1가 6
 
3.5%
만성동 5
 
2.9%
팔복동1가 5
 
2.9%
Other values (29) 77
44.5%

가로
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
595
173 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
595 173
100.0%

Length

2023-12-13T02:36:18.716788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:36:18.870503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
595 173
100.0%

세로
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
70
173 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
70 173
100.0%

Length

2023-12-13T02:36:19.009673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:36:19.137543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
70 173
100.0%

Interactions

2023-12-13T02:36:15.503115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:36:15.312105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:36:15.604652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:36:15.419428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:36:19.217633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면수행정동
연번1.0000.2040.946
면수0.2041.0000.730
행정동0.9460.7301.000
2023-12-13T02:36:19.321635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면수행정동
연번1.000-0.1720.635
면수-0.1721.0000.371
행정동0.6350.3711.000

Missing values

2023-12-13T02:36:15.773956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:36:15.954120image/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

연번게시대명칭면수기간금액행정동가로세로
01색장동 은석골동부로삼거리 정면476000색장동59570
12색장동 은석골동부로삼거리 측면676000색장동59570
23동서학동 좁은목약수터 사거리776000동서학동59570
34전동 싸전다리(전동)476000전동59570
45서서학동 싸전다리 전면576000서서학동59570
56서서학동 싸전다리 후면376000서서학동59570
67남노송동 풍남초교사거리(좌)776000남노송동59570
78남노송동 풍남초교사거리(우)776000남노송동59570
89다가동 다가교(우)676000다가동1가59570
910다가동 다가교(좌)676000다가동1가59570
연번게시대명칭면수기간금액행정동가로세로
163164에코시티 초포초등학교 사거리576000송천동2가59570
164165에코시티 데시앙14블록 (완주쪽)576000송천동2가59570
165166만성동 우리노인복지병원 삼거리676000만성동59570
166167장동 화개네거리676000장동59570
167168혁신도시 국민연금 입구3거리676000만성동59570
168169동산동 경제통상진흥원 4거리676000팔복동1가59570
169170에코시티 신협3거리 맞은편676000송천동2가59570
170171한국 농수산대학 3거리 후문676000만성동59570
171172효자동 바위백위공원 맞은편676000효자동2가59570
172173덕진동 종합경기장(구)전교조옆(우)476000덕진동1가59570