Overview

Dataset statistics

Number of variables9
Number of observations58
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory77.3 B

Variable types

Numeric1
Categorical6
Text1
DateTime1

Dataset

Description대구광역시 북구 관내 현수막지정게시대 현황(용도구분, 게시대명, 소재지주소, 게시대 수, 게시면 수 등) 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15060100/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 overall correlated with 게시면수High correlation
게시면수 is highly overall correlated with 소재지주소High correlation
연번 has unique valuesUnique
게시대명 has unique valuesUnique

Reproduction

Analysis started2023-12-13 00:00:10.711714
Analysis finished2023-12-13 00:00:11.179802
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.5
Minimum1
Maximum58
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size654.0 B
2023-12-13T09:00:11.241261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.85
Q115.25
median29.5
Q343.75
95-th percentile55.15
Maximum58
Range57
Interquartile range (IQR)28.5

Descriptive statistics

Standard deviation16.886879
Coefficient of variation (CV)0.57243656
Kurtosis-1.2
Mean29.5
Median Absolute Deviation (MAD)14.5
Skewness0
Sum1711
Variance285.16667
MonotonicityStrictly increasing
2023-12-13T09:00:11.345916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.7%
45 1
 
1.7%
33 1
 
1.7%
34 1
 
1.7%
35 1
 
1.7%
36 1
 
1.7%
37 1
 
1.7%
38 1
 
1.7%
39 1
 
1.7%
40 1
 
1.7%
Other values (48) 48
82.8%
ValueCountFrequency (%)
1 1
1.7%
2 1
1.7%
3 1
1.7%
4 1
1.7%
5 1
1.7%
6 1
1.7%
7 1
1.7%
8 1
1.7%
9 1
1.7%
10 1
1.7%
ValueCountFrequency (%)
58 1
1.7%
57 1
1.7%
56 1
1.7%
55 1
1.7%
54 1
1.7%
53 1
1.7%
52 1
1.7%
51 1
1.7%
50 1
1.7%
49 1
1.7%

용도구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
현수막 지정게시대
58 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row현수막 지정게시대
2nd row현수막 지정게시대
3rd row현수막 지정게시대
4th row현수막 지정게시대
5th row현수막 지정게시대

Common Values

ValueCountFrequency (%)
현수막 지정게시대 58
100.0%

Length

2023-12-13T09:00:11.444369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:00:11.511436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
현수막 58
50.0%
지정게시대 58
50.0%

게시대명
Text

UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size596.0 B
2023-12-13T09:00:11.683102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length13
Mean length9.1896552
Min length3

Characters and Unicode

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

Unique

Unique58 ?
Unique (%)100.0%

Sample

1st row거동교
2nd row검단유성아파트 앞
3rd row경대교 동쪽
4th row경대교 서쪽
5th row경대후문 앞
ValueCountFrequency (%)
앞 11
 
8.7%
좌측 8
 
6.3%
우측 8
 
6.3%
옆 7
 
5.6%
국우성당 4
 
3.2%
성북교 3
 
2.4%
서쪽 3
 
2.4%
맞은편 3
 
2.4%
남쪽 2
 
1.6%
동천교 2
 
1.6%
Other values (64) 75
59.5%
2023-12-13T09:00:11.990526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
69
 
12.9%
교 25
 
4.7%
측 20
 
3.8%
동 14
 
2.6%
우 14
 
2.6%
( 13
 
2.4%
) 13
 
2.4%
앞 12
 
2.3%
대 11
 
2.1%
구 11
 
2.1%
Other values (122) 331
62.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 411
77.1%
Space Separator 69
 
12.9%
Decimal Number 19
 
3.6%
Open Punctuation 13
 
2.4%
Close Punctuation 13
 
2.4%
Uppercase Letter 6
 
1.1%
Dash Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 25
 
6.1%
측 20
 
4.9%
동 14
 
3.4%
우 14
 
3.4%
앞 12
 
2.9%
대 11
 
2.7%
구 11
 
2.7%
좌 10
 
2.4%
지 9
 
2.2%
옆 9
 
2.2%
Other values (109) 276
67.2%
Decimal Number
ValueCountFrequency (%)
1 8
42.1%
2 7
36.8%
9 2
 
10.5%
3 1
 
5.3%
4 1
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
I 2
33.3%
C 2
33.3%
L 1
16.7%
H 1
16.7%
Space Separator
ValueCountFrequency (%)
69
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 411
77.1%
Common 116
 
21.8%
Latin 6
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 25
 
6.1%
측 20
 
4.9%
동 14
 
3.4%
우 14
 
3.4%
앞 12
 
2.9%
대 11
 
2.7%
구 11
 
2.7%
좌 10
 
2.4%
지 9
 
2.2%
옆 9
 
2.2%
Other values (109) 276
67.2%
Common
ValueCountFrequency (%)
69
59.5%
( 13
 
11.2%
) 13
 
11.2%
1 8
 
6.9%
2 7
 
6.0%
- 2
 
1.7%
9 2
 
1.7%
3 1
 
0.9%
4 1
 
0.9%
Latin
ValueCountFrequency (%)
I 2
33.3%
C 2
33.3%
L 1
16.7%
H 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 411
77.1%
ASCII 122
 
22.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
69
56.6%
( 13
 
10.7%
) 13
 
10.7%
1 8
 
6.6%
2 7
 
5.7%
- 2
 
1.6%
I 2
 
1.6%
C 2
 
1.6%
9 2
 
1.6%
3 1
 
0.8%
Other values (3) 3
 
2.5%
Hangul
ValueCountFrequency (%)
교 25
 
6.1%
측 20
 
4.9%
동 14
 
3.4%
우 14
 
3.4%
앞 12
 
2.9%
대 11
 
2.7%
구 11
 
2.7%
좌 10
 
2.4%
지 9
 
2.2%
옆 9
 
2.2%
Other values (109) 276
67.2%

소재지주소
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)29.3%
Missing0
Missing (%)0.0%
Memory size596.0 B
서변동
7 
산격동
7 
구암동
7 
국우동
7 
읍내동
6 
Other values (12)
24 

Length

Max length5
Median length3
Mean length3.0344828
Min length3

Unique

Unique8 ?
Unique (%)13.8%

Sample

1st row읍내동
2nd row검단동
3rd row대현동
4th row침산동
5th row산격동

Common Values

ValueCountFrequency (%)
서변동 7
12.1%
산격동 7
12.1%
구암동 7
12.1%
국우동 7
12.1%
읍내동 6
10.3%
침산동 5
8.6%
태전동 5
8.6%
동천동 3
5.2%
사수동 3
5.2%
검단동 1
 
1.7%
Other values (7) 7
12.1%

Length

2023-12-13T09:00:12.103335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서변동 7
12.1%
산격동 7
12.1%
구암동 7
12.1%
국우동 7
12.1%
읍내동 6
10.3%
침산동 5
8.6%
태전동 5
8.6%
사수동 3
5.2%
동천동 3
5.2%
검단동 1
 
1.7%
Other values (7) 7
12.1%

게시대수
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
1
58 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 58
100.0%

Length

2023-12-13T09:00:12.214183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:00:12.294331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 58
100.0%

게시면수
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size596.0 B
5
51 
4
7 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5
2nd row5
3rd row5
4th row5
5th row4

Common Values

ValueCountFrequency (%)
5 51
87.9%
4 7
 
12.1%

Length

2023-12-13T09:00:12.379524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:00:12.459020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5 51
87.9%
4 7
 
12.1%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
(사)옥외광고협회
58 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row(사)옥외광고협회
2nd row(사)옥외광고협회
3rd row(사)옥외광고협회
4th row(사)옥외광고협회
5th row(사)옥외광고협회

Common Values

ValueCountFrequency (%)
(사)옥외광고협회 58
100.0%

Length

2023-12-13T09:00:12.563668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:00:12.654441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사)옥외광고협회 58
100.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
053-604-4380
58 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row053-604-4380
2nd row053-604-4380
3rd row053-604-4380
4th row053-604-4380
5th row053-604-4380

Common Values

ValueCountFrequency (%)
053-604-4380 58
100.0%

Length

2023-12-13T09:00:12.744045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:00:12.833363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
053-604-4380 58
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
Minimum2023-04-29 00:00:00
Maximum2023-04-29 00:00:00
2023-12-13T09:00:12.908290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:00:12.984784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T09:00:10.943928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T09:00:13.044600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번게시대명소재지주소게시면수
연번1.0001.0000.7030.234
게시대명1.0001.0001.0001.000
소재지주소0.7031.0001.0000.841
게시면수0.2341.0000.8411.000
2023-12-13T09:00:13.124261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소재지주소게시면수
소재지주소1.0000.677
게시면수0.6771.000
2023-12-13T09:00:13.209353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소재지주소게시면수
연번1.0000.3300.157
소재지주소0.3301.0000.677
게시면수0.1570.6771.000

Missing values

2023-12-13T09:00:11.039700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T09:00:11.140203image/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현수막 지정게시대거동교읍내동15(사)옥외광고협회053-604-43802023-04-29
12현수막 지정게시대검단유성아파트 앞검단동15(사)옥외광고협회053-604-43802023-04-29
23현수막 지정게시대경대교 동쪽대현동15(사)옥외광고협회053-604-43802023-04-29
34현수막 지정게시대경대교 서쪽침산동15(사)옥외광고협회053-604-43802023-04-29
45현수막 지정게시대경대후문 앞산격동14(사)옥외광고협회053-604-43802023-04-29
56현수막 지정게시대관음동 1229번지 선(1)(해원사옆 우측)읍내동15(사)옥외광고협회053-604-43802023-04-29
67현수막 지정게시대관음동 1229번지 선(2)(해원사옆 좌측)읍내동15(사)옥외광고협회053-604-43802023-04-29
78현수막 지정게시대구민운동장 맞은편국우동15(사)옥외광고협회053-604-43802023-04-29
89현수막 지정게시대국우성당 옆 1 (좌측)국우동15(사)옥외광고협회053-604-43802023-04-29
910현수막 지정게시대국우성당 옆 2 (좌측중앙)국우동15(사)옥외광고협회053-604-43802023-04-29
연번용도구분게시대명소재지주소게시대수게시면수관리기관명관리기관전화번호데이터기준일자
4849현수막 지정게시대칠곡초등학교앞읍내동15(사)옥외광고협회053-604-43802023-04-29
4950현수막 지정게시대칠곡한국통신 옆구암동15(사)옥외광고협회053-604-43802023-04-29
5051현수막 지정게시대침산교 서쪽침산동15(사)옥외광고협회053-604-43802023-04-29
5152현수막 지정게시대침산변전소 옆침산동15(사)옥외광고협회053-604-43802023-04-29
5253현수막 지정게시대태암교 앞구암동15(사)옥외광고협회053-604-43802023-04-29
5354현수막 지정게시대태전대백아파트 건너편(1) - 우측태전동15(사)옥외광고협회053-604-43802023-04-29
5455현수막 지정게시대태전대백아파트 건너편(2) - 좌측태전동14(사)옥외광고협회053-604-43802023-04-29
5556현수막 지정게시대팔거교동호동14(사)옥외광고협회053-604-43802023-04-29
5657현수막 지정게시대팔달초중학교 삼거리팔달동15(사)옥외광고협회053-604-43802023-04-29
5758현수막 지정게시대함지공원 앞국우동15(사)옥외광고협회053-604-43802023-04-29