Overview

Dataset statistics

Number of variables5
Number of observations336
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.6 KiB
Average record size in memory41.4 B

Variable types

Numeric1
Text1
Categorical3

Dataset

Description대구광역시_자전거 공기주입기_20230731
Author대구광역시
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3072244&dataSetDetailId=30722441d1cdcc5ce4f1&provdMethod=FILE

Alerts

관리기관 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
전화번호 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
연번 is highly overall correlated with 관리기관 and 1 other fieldsHigh correlation
타입 is highly imbalanced (79.7%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-08-27 14:53:56.611134
Analysis finished2023-08-27 14:54:01.051799
Duration4.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct336
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean168.5
Minimum1
Maximum336
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2023-08-27T23:54:01.444886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile17.75
Q184.75
median168.5
Q3252.25
95-th percentile319.25
Maximum336
Range335
Interquartile range (IQR)167.5

Descriptive statistics

Standard deviation97.139076
Coefficient of variation (CV)0.57649303
Kurtosis-1.2
Mean168.5
Median Absolute Deviation (MAD)84
Skewness0
Sum56616
Variance9436
MonotonicityStrictly increasing
2023-08-27T23:54:02.447042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
223 1
 
0.3%
231 1
 
0.3%
230 1
 
0.3%
229 1
 
0.3%
228 1
 
0.3%
227 1
 
0.3%
226 1
 
0.3%
225 1
 
0.3%
224 1
 
0.3%
Other values (326) 326
97.0%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
336 1
0.3%
335 1
0.3%
334 1
0.3%
333 1
0.3%
332 1
0.3%
331 1
0.3%
330 1
0.3%
329 1
0.3%
328 1
0.3%
327 1
0.3%

설치위치
Text

Distinct332
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2023-08-27T23:54:03.496237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length42
Mean length30.764881
Min length16

Characters and Unicode

Total characters10337
Distinct characters327
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

Unique328 ?
Unique (%)97.6%

Sample

1st row대구광역시 달성군 다사읍 매곡리 91 강창교 파크골프장 부근 금호강자전거길
2nd row대구광역시 달성군 다사읍 서재리 675-1 금호강자전거길
3rd row대구광역시 달성군 다사읍 세천야구장 부근 금호강자전거길
4th row대구광역시 달성군 다사읍 와룡대교 밑 금호강자전거길
5th row대구광역시 서구 비산동 팔달교 부근 금호강자전거길
ValueCountFrequency (%)
대구광역시 336
 
15.1%
도시철도 106
 
4.8%
앞 82
 
3.7%
달서구 80
 
3.6%
출입구 79
 
3.6%
서구 61
 
2.7%
2호선 47
 
2.1%
수성구 46
 
2.1%
1호선 41
 
1.8%
동구 34
 
1.5%
Other values (617) 1308
58.9%
2023-08-27T23:54:04.825346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1901
 
18.4%
구 823
 
8.0%
대 480
 
4.6%
시 458
 
4.4%
동 446
 
4.3%
역 445
 
4.3%
광 345
 
3.3%
도 249
 
2.4%
서 187
 
1.8%
성 148
 
1.4%
Other values (317) 4855
47.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7815
75.6%
Space Separator 1901
 
18.4%
Decimal Number 387
 
3.7%
Close Punctuation 96
 
0.9%
Open Punctuation 95
 
0.9%
Uppercase Letter 15
 
0.1%
Dash Punctuation 12
 
0.1%
Math Symbol 9
 
0.1%
Other Punctuation 7
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 823
 
10.5%
대 480
 
6.1%
시 458
 
5.9%
동 446
 
5.7%
역 445
 
5.7%
광 345
 
4.4%
도 249
 
3.2%
서 187
 
2.4%
성 148
 
1.9%
호 132
 
1.7%
Other values (289) 4102
52.5%
Decimal Number
ValueCountFrequency (%)
2 110
28.4%
1 107
27.6%
3 65
16.8%
4 35
 
9.0%
5 16
 
4.1%
6 13
 
3.4%
7 13
 
3.4%
9 11
 
2.8%
8 9
 
2.3%
0 8
 
2.1%
Uppercase Letter
ValueCountFrequency (%)
C 3
20.0%
W 2
13.3%
S 2
13.3%
K 2
13.3%
I 1
 
6.7%
F 1
 
6.7%
U 1
 
6.7%
T 1
 
6.7%
G 1
 
6.7%
B 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
, 3
42.9%
? 2
28.6%
. 2
28.6%
Space Separator
ValueCountFrequency (%)
1901
100.0%
Close Punctuation
ValueCountFrequency (%)
) 96
100.0%
Open Punctuation
ValueCountFrequency (%)
( 95
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Math Symbol
ValueCountFrequency (%)
~ 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7815
75.6%
Common 2507
 
24.3%
Latin 15
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 823
 
10.5%
대 480
 
6.1%
시 458
 
5.9%
동 446
 
5.7%
역 445
 
5.7%
광 345
 
4.4%
도 249
 
3.2%
서 187
 
2.4%
성 148
 
1.9%
호 132
 
1.7%
Other values (289) 4102
52.5%
Common
ValueCountFrequency (%)
1901
75.8%
2 110
 
4.4%
1 107
 
4.3%
) 96
 
3.8%
( 95
 
3.8%
3 65
 
2.6%
4 35
 
1.4%
5 16
 
0.6%
6 13
 
0.5%
7 13
 
0.5%
Other values (8) 56
 
2.2%
Latin
ValueCountFrequency (%)
C 3
20.0%
W 2
13.3%
S 2
13.3%
K 2
13.3%
I 1
 
6.7%
F 1
 
6.7%
U 1
 
6.7%
T 1
 
6.7%
G 1
 
6.7%
B 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7815
75.6%
ASCII 2522
 
24.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1901
75.4%
2 110
 
4.4%
1 107
 
4.2%
) 96
 
3.8%
( 95
 
3.8%
3 65
 
2.6%
4 35
 
1.4%
5 16
 
0.6%
6 13
 
0.5%
7 13
 
0.5%
Other values (18) 71
 
2.8%
Hangul
ValueCountFrequency (%)
구 823
 
10.5%
대 480
 
6.1%
시 458
 
5.9%
동 446
 
5.7%
역 445
 
5.7%
광 345
 
4.4%
도 249
 
3.2%
서 187
 
2.4%
성 148
 
1.9%
호 132
 
1.7%
Other values (289) 4102
52.5%

타입
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
태양광
320 
수동식
 
10
전기식
 
6

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 (%)
태양광 320
95.2%
수동식 10
 
3.0%
전기식 6
 
1.8%

Length

2023-08-27T23:54:05.232047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-08-27T23:54:05.553644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
태양광 320
95.2%
수동식 10
 
3.0%
전기식 6
 
1.8%

관리기관
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
달서구청
77 
서구청
60 
수성구청
45 
중구청
34 
동구청
32 
Other values (4)
88 

Length

Max length6
Median length3
Mean length3.5357143
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도시관리본부
2nd row도시관리본부
3rd row도시관리본부
4th row도시관리본부
5th row도시관리본부

Common Values

ValueCountFrequency (%)
달서구청 77
22.9%
서구청 60
17.9%
수성구청 45
13.4%
중구청 34
10.1%
동구청 32
9.5%
남구청 31
9.2%
북구청 23
 
6.8%
달성군청 22
 
6.5%
도시관리본부 12
 
3.6%

Length

2023-08-27T23:54:05.988474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-08-27T23:54:06.689652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
달서구청 77
22.9%
서구청 60
17.9%
수성구청 45
13.4%
중구청 34
10.1%
동구청 32
9.5%
남구청 31
9.2%
북구청 23
 
6.8%
달성군청 22
 
6.5%
도시관리본부 12
 
3.6%

전화번호
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
053-667-3084
77 
053-663-3015
60 
053-666-2914
45 
053-661-2986
34 
053-662-3594
32 
Other values (6)
88 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row053-803-1599
2nd row053-803-1599
3rd row053-803-1599
4th row053-803-1599
5th row053-803-1599

Common Values

ValueCountFrequency (%)
053-667-3084 77
22.9%
053-663-3015 60
17.9%
053-666-2914 45
13.4%
053-661-2986 34
10.1%
053-662-3594 32
9.5%
053-664-3007 31
9.2%
053-668-2916 21
 
6.2%
053-665-2918 20
 
6.0%
053-803-1599 12
 
3.6%
053-665-3034 3
 
0.9%

Length

2023-08-27T23:54:07.506215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
053-667-3084 77
22.9%
053-663-3015 60
17.9%
053-666-2914 45
13.4%
053-661-2986 34
10.1%
053-662-3594 32
9.5%
053-664-3007 31
9.2%
053-668-2916 21
 
6.2%
053-665-2918 20
 
6.0%
053-803-1599 12
 
3.6%
053-665-3034 3
 
0.9%

Interactions

2023-08-27T23:53:59.756973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-08-27T23:54:07.716810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번타입관리기관전화번호
연번1.0000.2690.9390.930
타입0.2691.0000.3960.519
관리기관0.9390.3961.0001.000
전화번호0.9300.5191.0001.000
2023-08-27T23:54:08.057987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
타입관리기관전화번호
타입1.0000.1880.351
관리기관0.1881.0000.997
전화번호0.3510.9971.000
2023-08-27T23:54:08.361446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번타입관리기관전화번호
연번1.0000.1640.7950.747
타입0.1641.0000.1880.351
관리기관0.7950.1881.0000.997
전화번호0.7470.3510.9971.000

Missing values

2023-08-27T23:54:00.574231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-08-27T23:54:00.885458image/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대구광역시 달성군 다사읍 매곡리 91 강창교 파크골프장 부근 금호강자전거길태양광도시관리본부053-803-1599
12대구광역시 달성군 다사읍 서재리 675-1 금호강자전거길태양광도시관리본부053-803-1599
23대구광역시 달성군 다사읍 세천야구장 부근 금호강자전거길태양광도시관리본부053-803-1599
34대구광역시 달성군 다사읍 와룡대교 밑 금호강자전거길태양광도시관리본부053-803-1599
45대구광역시 서구 비산동 팔달교 부근 금호강자전거길태양광도시관리본부053-803-1599
56대구광역시 북구 검단동 금호제2교 부근 금호강자전거길태양광도시관리본부053-803-1599
67대구광역시 동구 검사동 아양교 부근 제방 - 금호강2초소 금호강자전거길태양광도시관리본부053-803-1599
78대구광역시 수성구 고모동 팔현파크골프장 부근 금호강자전거길태양광도시관리본부053-803-1599
89대구광역시 동구 율하동 박주영축구장 부근 금호강자전거길태양광도시관리본부053-803-1599
910대구광역시 달성군 구지면 도동리 362 부근 낙동강자전거길태양광도시관리본부053-803-1599
연번설치위치타입관리기관전화번호
326327대구광역시 달성군 유가읍 비슬타워 북편(버스정류장 옆)태양광달성군청053-668-2916
327328대구광역시 달성군 현풍읍 도동터널 진출구 쉼터태양광달성군청053-668-2916
328329대구광역시 달성군 현풍읍 제일풍경채 맞은편태양광달성군청053-668-2916
329330대구광역시 달성군 현풍읍 행정복지센터 주차장태양광달성군청053-668-2916
330331대구광역시 달성군 현풍읍 현풍중앙로 14길 11(현풍북카페 앞)태양광달성군청053-668-2916
331332대구광역시 달성군 현풍읍 현풍파출소 맞은편(현풍교 옆)태양광달성군청053-668-2916
332333대구광역시 달성군 화원읍 도시철도 1호선 설화명곡역 4번 출입구태양광달성군청053-668-2916
333334대구광역시 달성군 화원읍 도시철도 1호선 설화명곡역 7번 출입구(명곡교)태양광달성군청053-668-2916
334335대구광역시 달성군 화원읍 도시철도 1호선 화원역 3번 출입구태양광달성군청053-668-2916
335336대구광역시 달성군 화원읍 도시철도 1호선 화원역 4번 출입구태양광달성군청053-668-2916