Overview

Dataset statistics

Number of variables8
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory74.0 B

Variable types

Text3
Numeric2
Categorical2
DateTime1

Dataset

Description대구광역시 달서구_옐로우카펫_20210705
Author대구광역시 달서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15084274&dataSetDetailId=15084274192bb812633c4&provdMethod=FILE

Alerts

데이터기준일자 has constant value ""Constant
설치학교명 has unique valuesUnique
도로명주소 has unique valuesUnique
지번주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2024-04-21 23:57:11.882449
Analysis finished2024-04-21 23:57:13.727420
Duration1.84 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치학교명
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-04-22T08:57:13.838858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters66
Distinct characters30
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row대진초
2nd row성남초
3rd row와룡초
4th row월배초
5th row호산초
ValueCountFrequency (%)
대진초 1
 
4.5%
성남초 1
 
4.5%
송현초 1
 
4.5%
대서초 1
 
4.5%
대곡초 1
 
4.5%
노전초 1
 
4.5%
성당초 1
 
4.5%
장기초 1
 
4.5%
학산초 1
 
4.5%
한실초 1
 
4.5%
Other values (12) 12
54.5%
2024-04-22T08:57:14.114170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
22
33.3%
4
 
6.1%
3
 
4.5%
3
 
4.5%
3
 
4.5%
3
 
4.5%
2
 
3.0%
2
 
3.0%
2
 
3.0%
2
 
3.0%
Other values (20) 20
30.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 66
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
22
33.3%
4
 
6.1%
3
 
4.5%
3
 
4.5%
3
 
4.5%
3
 
4.5%
2
 
3.0%
2
 
3.0%
2
 
3.0%
2
 
3.0%
Other values (20) 20
30.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 66
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
22
33.3%
4
 
6.1%
3
 
4.5%
3
 
4.5%
3
 
4.5%
3
 
4.5%
2
 
3.0%
2
 
3.0%
2
 
3.0%
2
 
3.0%
Other values (20) 20
30.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 66
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
22
33.3%
4
 
6.1%
3
 
4.5%
3
 
4.5%
3
 
4.5%
3
 
4.5%
2
 
3.0%
2
 
3.0%
2
 
3.0%
2
 
3.0%
Other values (20) 20
30.3%

도로명주소
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-04-22T08:57:14.296574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20
Mean length17.545455
Min length15

Characters and Unicode

Total characters386
Distinct characters45
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

Unique22 ?
Unique (%)100.0%

Sample

1st row대구광역시 달서구 상화로 70
2nd row대구광역시 달서구 성당로47길 35
3rd row대구광역시 달서구 선원남로 22
4th row대구광역시 달서구 월배로 131
5th row대구광역시 달서구 달서대로109길 116
ValueCountFrequency (%)
대구광역시 22
25.0%
달서구 22
25.0%
선원남로 3
 
3.4%
장기로 2
 
2.3%
송현로 2
 
2.3%
대명천로 1
 
1.1%
용산로 1
 
1.1%
260 1
 
1.1%
한실로6길 1
 
1.1%
108 1
 
1.1%
Other values (32) 32
36.4%
2024-04-22T08:57:14.636889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
66
17.1%
45
11.7%
25
 
6.5%
24
 
6.2%
23
 
6.0%
22
 
5.7%
22
 
5.7%
22
 
5.7%
22
 
5.7%
1 14
 
3.6%
Other values (35) 101
26.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 256
66.3%
Space Separator 66
 
17.1%
Decimal Number 64
 
16.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
45
17.6%
25
9.8%
24
9.4%
23
9.0%
22
8.6%
22
8.6%
22
8.6%
22
8.6%
6
 
2.3%
4
 
1.6%
Other values (24) 41
16.0%
Decimal Number
ValueCountFrequency (%)
1 14
21.9%
0 8
12.5%
3 7
10.9%
2 7
10.9%
8 6
9.4%
6 6
9.4%
9 5
 
7.8%
7 4
 
6.2%
5 4
 
6.2%
4 3
 
4.7%
Space Separator
ValueCountFrequency (%)
66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 256
66.3%
Common 130
33.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
45
17.6%
25
9.8%
24
9.4%
23
9.0%
22
8.6%
22
8.6%
22
8.6%
22
8.6%
6
 
2.3%
4
 
1.6%
Other values (24) 41
16.0%
Common
ValueCountFrequency (%)
66
50.8%
1 14
 
10.8%
0 8
 
6.2%
3 7
 
5.4%
2 7
 
5.4%
8 6
 
4.6%
6 6
 
4.6%
9 5
 
3.8%
7 4
 
3.1%
5 4
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 256
66.3%
ASCII 130
33.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
66
50.8%
1 14
 
10.8%
0 8
 
6.2%
3 7
 
5.4%
2 7
 
5.4%
8 6
 
4.6%
6 6
 
4.6%
9 5
 
3.8%
7 4
 
3.1%
5 4
 
3.1%
Hangul
ValueCountFrequency (%)
45
17.6%
25
9.8%
24
9.4%
23
9.0%
22
8.6%
22
8.6%
22
8.6%
22
8.6%
6
 
2.3%
4
 
1.6%
Other values (24) 41
16.0%

지번주소
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2024-04-22T08:57:14.813427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length18.5
Min length17

Characters and Unicode

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

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row대구광역시 달서구 대곡동 1025
2nd row대구광역시 달서구 두류동 812-1
3rd row대구광역시 달서구 이곡동 1191-1
4th row대구광역시 달서구 진천동 57-1
5th row대구광역시 달서구 호산동 357-57
ValueCountFrequency (%)
대구광역시 22
25.0%
달서구 22
25.0%
월성동 4
 
4.5%
이곡동 3
 
3.4%
상인동 2
 
2.3%
도원동 2
 
2.3%
대곡동 2
 
2.3%
용산동 2
 
2.3%
860-1 1
 
1.1%
송현동 1
 
1.1%
Other values (27) 27
30.7%
2024-04-22T08:57:15.125583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
66
16.2%
44
 
10.8%
24
 
5.9%
1 23
 
5.7%
22
 
5.4%
22
 
5.4%
22
 
5.4%
22
 
5.4%
22
 
5.4%
22
 
5.4%
Other values (33) 118
29.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 242
59.5%
Decimal Number 86
 
21.1%
Space Separator 66
 
16.2%
Dash Punctuation 13
 
3.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
44
18.2%
24
9.9%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
5
 
2.1%
4
 
1.7%
Other values (21) 33
13.6%
Decimal Number
ValueCountFrequency (%)
1 23
26.7%
5 10
11.6%
3 9
 
10.5%
0 8
 
9.3%
8 8
 
9.3%
7 7
 
8.1%
2 6
 
7.0%
4 6
 
7.0%
6 5
 
5.8%
9 4
 
4.7%
Space Separator
ValueCountFrequency (%)
66
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 242
59.5%
Common 165
40.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
44
18.2%
24
9.9%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
5
 
2.1%
4
 
1.7%
Other values (21) 33
13.6%
Common
ValueCountFrequency (%)
66
40.0%
1 23
 
13.9%
- 13
 
7.9%
5 10
 
6.1%
3 9
 
5.5%
0 8
 
4.8%
8 8
 
4.8%
7 7
 
4.2%
2 6
 
3.6%
4 6
 
3.6%
Other values (2) 9
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 242
59.5%
ASCII 165
40.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
66
40.0%
1 23
 
13.9%
- 13
 
7.9%
5 10
 
6.1%
3 9
 
5.5%
0 8
 
4.8%
8 8
 
4.8%
7 7
 
4.2%
2 6
 
3.6%
4 6
 
3.6%
Other values (2) 9
 
5.5%
Hangul
ValueCountFrequency (%)
44
18.2%
24
9.9%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
22
9.1%
5
 
2.1%
4
 
1.7%
Other values (21) 33
13.6%

위도
Real number (ℝ)

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.832656
Minimum35.798314
Maximum35.861089
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2024-04-22T08:57:15.260962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.798314
5-th percentile35.803461
Q135.817334
median35.829898
Q335.851238
95-th percentile35.857857
Maximum35.861089
Range0.0627749
Interquartile range (IQR)0.03390341

Descriptive statistics

Standard deviation0.019975636
Coefficient of variation (CV)0.00055747014
Kurtosis-1.3195244
Mean35.832656
Median Absolute Deviation (MAD)0.018452475
Skewness-0.14691693
Sum788.31844
Variance0.00039902603
MonotonicityNot monotonic
2024-04-22T08:57:15.389605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
35.80662752 1
 
4.5%
35.86108928 1
 
4.5%
35.81216502 1
 
4.5%
35.82868866 1
 
4.5%
35.82006652 1
 
4.5%
35.80329395 1
 
4.5%
35.80817238 1
 
4.5%
35.84055698 1
 
4.5%
35.84438835 1
 
4.5%
35.83110683 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
35.79831438 1
4.5%
35.80329395 1
4.5%
35.80662752 1
4.5%
35.80817238 1
4.5%
35.81216502 1
4.5%
35.81642334 1
4.5%
35.82006652 1
4.5%
35.82408537 1
4.5%
35.82413686 1
4.5%
35.82857432 1
4.5%
ValueCountFrequency (%)
35.86108928 1
4.5%
35.85789855 1
4.5%
35.85706992 1
4.5%
35.85684832 1
4.5%
35.85332922 1
4.5%
35.85196007 1
4.5%
35.84906997 1
4.5%
35.84457103 1
4.5%
35.84438835 1
4.5%
35.84055698 1
4.5%

경도
Real number (ℝ)

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.52932
Minimum128.47889
Maximum128.57229
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2024-04-22T08:57:15.498013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.47889
5-th percentile128.50245
Q1128.52179
median128.52882
Q3128.53792
95-th percentile128.54993
Maximum128.57229
Range0.0934017
Interquartile range (IQR)0.01612605

Descriptive statistics

Standard deviation0.018742811
Coefficient of variation (CV)0.00014582518
Kurtosis2.2135064
Mean128.52932
Median Absolute Deviation (MAD)0.00844375
Skewness-0.40789324
Sum2827.645
Variance0.00035129297
MonotonicityNot monotonic
2024-04-22T08:57:15.601099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
128.5217528 1
 
4.5%
128.5312563 1
 
4.5%
128.5492651 1
 
4.5%
128.5448303 1
 
4.5%
128.5499616 1
 
4.5%
128.5357496 1
 
4.5%
128.5312015 1
 
4.5%
128.5472916 1
 
4.5%
128.5290634 1
 
4.5%
128.5260862 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
128.4788885 1
4.5%
128.5018556 1
4.5%
128.5137344 1
4.5%
128.5144445 1
4.5%
128.5189229 1
4.5%
128.5217528 1
4.5%
128.5219079 1
4.5%
128.5260862 1
4.5%
128.5281536 1
4.5%
128.5283129 1
4.5%
ValueCountFrequency (%)
128.5722902 1
4.5%
128.5499616 1
4.5%
128.5492651 1
4.5%
128.5472916 1
4.5%
128.5448303 1
4.5%
128.5386403 1
4.5%
128.5357496 1
4.5%
128.5328132 1
4.5%
128.5312563 1
4.5%
128.5312015 1
4.5%

수량
Categorical

Distinct4
Distinct (%)18.2%
Missing0
Missing (%)0.0%
Memory size308.0 B
1
14 
2
3
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)4.5%

Sample

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

Common Values

ValueCountFrequency (%)
1 14
63.6%
2 4
 
18.2%
3 3
 
13.6%
4 1
 
4.5%

Length

2024-04-22T08:57:15.699643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T08:57:15.799614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 14
63.6%
2 4
 
18.2%
3 3
 
13.6%
4 1
 
4.5%

설치연도
Categorical

Distinct3
Distinct (%)13.6%
Missing0
Missing (%)0.0%
Memory size308.0 B
2020
10 
2021
2019

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 10
45.5%
2021 7
31.8%
2019 5
22.7%

Length

2024-04-22T08:57:15.910006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T08:57:15.998122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 10
45.5%
2021 7
31.8%
2019 5
22.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
Minimum2021-07-05 00:00:00
Maximum2021-07-05 00:00:00
2024-04-22T08:57:16.080073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T08:57:16.157630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-22T08:57:13.347622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T08:57:13.143219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T08:57:13.432927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-22T08:57:13.257323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-22T08:57:16.223492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치학교명도로명주소지번주소위도경도수량설치연도
설치학교명1.0001.0001.0001.0001.0001.0001.000
도로명주소1.0001.0001.0001.0001.0001.0001.000
지번주소1.0001.0001.0001.0001.0001.0001.000
위도1.0001.0001.0001.0000.0000.5870.000
경도1.0001.0001.0000.0001.0000.2370.659
수량1.0001.0001.0000.5870.2371.0000.000
설치연도1.0001.0001.0000.0000.6590.0001.000
2024-04-22T08:57:16.314835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수량설치연도
수량1.0000.000
설치연도0.0001.000
2024-04-22T08:57:16.392122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도수량설치연도
위도1.000-0.2920.2890.000
경도-0.2921.0000.2370.490
수량0.2890.2371.0000.000
설치연도0.0000.4900.0001.000

Missing values

2024-04-22T08:57:13.535274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-22T08:57:13.661282image/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대진초대구광역시 달서구 상화로 70대구광역시 달서구 대곡동 102535.806628128.521753220192021-07-05
1성남초대구광역시 달서구 성당로47길 35대구광역시 달서구 두류동 812-135.853329128.57229120192021-07-05
2와룡초대구광역시 달서구 선원남로 22대구광역시 달서구 이곡동 1191-135.85707128.501856120192021-07-05
3월배초대구광역시 달서구 월배로 131대구광역시 달서구 진천동 57-135.816423128.528313220192021-07-05
4호산초대구광역시 달서구 달서대로109길 116대구광역시 달서구 호산동 357-5735.84907128.478889320192021-07-05
5본리초대구광역시 달서구 장기로 198대구광역시 달서구 감삼동 33835.844571128.53864420202021-07-05
6성서초대구광역시 달서구 달구벌대로 1339대구광역시 달서구 이곡동 727-135.85196128.514444320202021-07-05
7이곡초대구광역시 달서구 선원남로 120대구광역시 달서구 이곡동 1304-435.856848128.513734120202021-07-05
8조암초대구광역시 달서구 조암로5길 19대구광역시 달서구 월성동 57235.824085128.528154120202021-07-05
9월암초대구광역시 달서구 조암로6길 55대구광역시 달서구 월성동 75535.828574128.521908120202021-07-05
설치학교명도로명주소지번주소위도경도수량설치연도데이터기준일자
12용전초대구광역시 달서구 용산로 260대구광역시 달서구 용산동 91335.861089128.531256120202021-07-05
13한실초대구광역시 달서구 한실로6길 108대구광역시 달서구 대곡동 110635.798314128.528569120202021-07-05
14학산초대구광역시 달서구 월성로 76대구광역시 달서구 월성동 82-135.831107128.526086220202021-07-05
15장기초대구광역시 달서구 장기로 280대구광역시 달서구 장기동 813-335.844388128.529063320212021-07-05
16성당초대구광역시 달서구 대명천로 118대구광역시 달서구 본리동 166-135.840557128.547292120212021-07-05
17노전초대구광역시 달서구 한실로 43대구광역시 달서구 도원동 1428-335.808172128.531202120212021-07-05
18대곡초대구광역시 달서구 도원남로 60대구광역시 달서구 도원동 145835.803294128.53575120212021-07-05
19대서초대구광역시 달서구 송현로 9대구광역시 달서구 상인동 860-135.820067128.549962120212021-07-05
20송현초대구광역시 달서구 송현로 128대구광역시 달서구 송현동 190835.828689128.54483120212021-07-05
21월곡초대구광역시 달서구 상인로 40대구광역시 달서구 상인동 156035.812165128.549265120212021-07-05