Overview

Dataset statistics

Number of variables9
Number of observations440
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory31.1 KiB
Average record size in memory72.3 B

Variable types

Categorical4
Text2
DateTime3

Dataset

Description경기도 시흥시 그늘막쉼터현황 현황입니다. 행정동, 관리번호, 위치, 제품종류, 제품규격, 설치일자, 운영일자, 운영시작시각, 운영종료시각 현황으로 구성되어 있습니다.
URLhttps://www.data.go.kr/data/15104319/fileData.do

Alerts

운영일자 has constant value ""Constant
운영시작시각 has constant value ""Constant
운영종료시각 has constant value ""Constant
제품종류 is highly imbalanced (82.3%)Imbalance

Reproduction

Analysis started2023-12-12 09:40:35.798020
Analysis finished2023-12-12 09:40:37.055252
Duration1.26 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동
Categorical

Distinct27
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
배곧1동
53 
대야동
46 
은행동
45 
배곧2동
35 
능곡동
28 
Other values (22)
233 

Length

Max length4
Median length3
Mean length3.4045455
Min length3

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row신현동
2nd row신현동
3rd row은행동
4th row은행동
5th row은행동

Common Values

ValueCountFrequency (%)
배곧1동 53
12.0%
대야동 46
 
10.5%
은행동 45
 
10.2%
배곧2동 35
 
8.0%
능곡동 28
 
6.4%
장곡동 28
 
6.4%
정왕4동 20
 
4.5%
조남동 19
 
4.3%
목감동 18
 
4.1%
정왕본동 17
 
3.9%
Other values (17) 131
29.8%

Length

2023-12-12T18:40:37.155852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
배곧1동 53
12.0%
대야동 46
 
10.5%
은행동 45
 
10.2%
배곧2동 35
 
8.0%
능곡동 28
 
6.4%
장곡동 28
 
6.4%
정왕4동 20
 
4.5%
조남동 19
 
4.3%
목감동 18
 
4.1%
정왕본동 17
 
3.9%
Other values (17) 131
29.8%

관리번호
Text

Distinct95
Distinct (%)21.6%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-12T18:40:37.524456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length3.65
Min length1

Characters and Unicode

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

Unique45 ?
Unique (%)10.2%

Sample

1st row1-1
2nd row1-2
3rd row1-1
4th row1-2
5th row1-3
ValueCountFrequency (%)
1-1 17
 
3.9%
1-2 17
 
3.9%
1-3 15
 
3.4%
1-9 15
 
3.4%
1-11 15
 
3.4%
1-13 14
 
3.2%
1-7 14
 
3.2%
1-5 14
 
3.2%
1-12 14
 
3.2%
1-4 14
 
3.2%
Other values (85) 291
66.1%
2023-12-12T18:40:38.042873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 578
36.0%
- 434
27.0%
2 151
 
9.4%
3 109
 
6.8%
4 85
 
5.3%
5 57
 
3.5%
7 41
 
2.6%
6 41
 
2.6%
9 37
 
2.3%
8 37
 
2.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1172
73.0%
Dash Punctuation 434
 
27.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 578
49.3%
2 151
 
12.9%
3 109
 
9.3%
4 85
 
7.3%
5 57
 
4.9%
7 41
 
3.5%
6 41
 
3.5%
9 37
 
3.2%
8 37
 
3.2%
0 36
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 434
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1606
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 578
36.0%
- 434
27.0%
2 151
 
9.4%
3 109
 
6.8%
4 85
 
5.3%
5 57
 
3.5%
7 41
 
2.6%
6 41
 
2.6%
9 37
 
2.3%
8 37
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1606
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 578
36.0%
- 434
27.0%
2 151
 
9.4%
3 109
 
6.8%
4 85
 
5.3%
5 57
 
3.5%
7 41
 
2.6%
6 41
 
2.6%
9 37
 
2.3%
8 37
 
2.3%

위치
Text

Distinct388
Distinct (%)88.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-12T18:40:38.373127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length37
Mean length29.920455
Min length15

Characters and Unicode

Total characters13165
Distinct characters344
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique357 ?
Unique (%)81.1%

Sample

1st row경기도 시흥시 신현역 (한아름마트) 교차로 (포동 1-120)
2nd row경기도 시흥시 미산동 484-26(포리1교 인근 삼거리)
3rd row경기도 시흥시 은행 대우1차아파트 교차로(은행동 546)
4th row경기도 시흥시 맥도날드 횡단보도 (은행동 578)
5th row경기도 시흥시 은행사거리 (경동프라자) 교차로 (은행동 547-4)
ValueCountFrequency (%)
시흥시 437
 
16.9%
경기도 435
 
16.8%
앞 187
 
7.2%
정왕동 125
 
4.8%
사거리 72
 
2.8%
건너편 63
 
2.4%
대야동 46
 
1.8%
은행동 42
 
1.6%
교통섬 27
 
1.0%
조남동 25
 
1.0%
Other values (634) 1132
43.7%
2023-12-12T18:40:38.949808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2157
 
16.4%
시 924
 
7.0%
동 536
 
4.1%
도 482
 
3.7%
흥 473
 
3.6%
경 446
 
3.4%
기 442
 
3.4%
( 424
 
3.2%
) 423
 
3.2%
1 389
 
3.0%
Other values (334) 6469
49.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7825
59.4%
Space Separator 2159
 
16.4%
Decimal Number 2026
 
15.4%
Open Punctuation 424
 
3.2%
Close Punctuation 423
 
3.2%
Dash Punctuation 228
 
1.7%
Uppercase Letter 62
 
0.5%
Lowercase Letter 7
 
0.1%
Other Punctuation 5
 
< 0.1%
Math Symbol 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 924
 
11.8%
동 536
 
6.8%
도 482
 
6.2%
흥 473
 
6.0%
경 446
 
5.7%
기 442
 
5.6%
앞 193
 
2.5%
정 168
 
2.1%
리 149
 
1.9%
왕 147
 
1.9%
Other values (295) 3865
49.4%
Uppercase Letter
ValueCountFrequency (%)
L 10
16.1%
G 7
11.3%
H 7
11.3%
A 7
11.3%
S 5
8.1%
T 5
8.1%
P 5
8.1%
B 4
 
6.5%
C 4
 
6.5%
K 3
 
4.8%
Other values (5) 5
8.1%
Decimal Number
ValueCountFrequency (%)
1 389
19.2%
2 286
14.1%
6 228
11.3%
4 185
9.1%
0 183
9.0%
7 177
8.7%
3 170
8.4%
5 159
7.8%
8 159
7.8%
9 90
 
4.4%
Lowercase Letter
ValueCountFrequency (%)
o 2
28.6%
f 1
14.3%
a 1
14.3%
c 1
14.3%
d 1
14.3%
g 1
14.3%
Space Separator
ValueCountFrequency (%)
2157
99.9%
　 2
 
0.1%
Open Punctuation
ValueCountFrequency (%)
( 424
100.0%
Close Punctuation
ValueCountFrequency (%)
) 423
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 228
100.0%
Other Punctuation
ValueCountFrequency (%)
, 5
100.0%
Math Symbol
ValueCountFrequency (%)
~ 5
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7825
59.4%
Common 5271
40.0%
Latin 69
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 924
 
11.8%
동 536
 
6.8%
도 482
 
6.2%
흥 473
 
6.0%
경 446
 
5.7%
기 442
 
5.6%
앞 193
 
2.5%
정 168
 
2.1%
리 149
 
1.9%
왕 147
 
1.9%
Other values (295) 3865
49.4%
Latin
ValueCountFrequency (%)
L 10
14.5%
G 7
10.1%
H 7
10.1%
A 7
10.1%
S 5
7.2%
T 5
7.2%
P 5
7.2%
B 4
 
5.8%
C 4
 
5.8%
K 3
 
4.3%
Other values (11) 12
17.4%
Common
ValueCountFrequency (%)
2157
40.9%
( 424
 
8.0%
) 423
 
8.0%
1 389
 
7.4%
2 286
 
5.4%
6 228
 
4.3%
- 228
 
4.3%
4 185
 
3.5%
0 183
 
3.5%
7 177
 
3.4%
Other values (8) 591
 
11.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7825
59.4%
ASCII 5338
40.5%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2157
40.4%
( 424
 
7.9%
) 423
 
7.9%
1 389
 
7.3%
2 286
 
5.4%
6 228
 
4.3%
- 228
 
4.3%
4 185
 
3.5%
0 183
 
3.4%
7 177
 
3.3%
Other values (28) 658
 
12.3%
Hangul
ValueCountFrequency (%)
시 924
 
11.8%
동 536
 
6.8%
도 482
 
6.2%
흥 473
 
6.0%
경 446
 
5.7%
기 442
 
5.6%
앞 193
 
2.5%
정 168
 
2.1%
리 149
 
1.9%
왕 147
 
1.9%
Other values (295) 3865
49.4%
None
ValueCountFrequency (%)
　 2
100.0%

제품종류
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
8각댄싱
422 
스마트그늘막
 
13
스마트 그늘막
 
5

Length

Max length7
Median length4
Mean length4.0931818
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row8각댄싱
2nd row8각댄싱
3rd row8각댄싱
4th row8각댄싱
5th row8각댄싱

Common Values

ValueCountFrequency (%)
8각댄싱 422
95.9%
스마트그늘막 13
 
3.0%
스마트 그늘막 5
 
1.1%

Length

2023-12-12T18:40:39.144973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:40:39.324891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
8각댄싱 422
94.8%
스마트그늘막 13
 
2.9%
스마트 5
 
1.1%
그늘막 5
 
1.1%

제품규격
Categorical

Distinct5
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
4M
286 
5M
91 
3M
45 
3.5M
 
14
<NA>
 
4

Length

Max length4
Median length2
Mean length2.0818182
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row5M
2nd row4M
3rd row5M
4th row5M
5th row5M

Common Values

ValueCountFrequency (%)
4M 286
65.0%
5M 91
 
20.7%
3M 45
 
10.2%
3.5M 14
 
3.2%
<NA> 4
 
0.9%

Length

2023-12-12T18:40:39.516741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:40:39.701764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
4m 286
65.0%
5m 91
 
20.7%
3m 45
 
10.2%
3.5m 14
 
3.2%
na 4
 
0.9%

설치일자
Date

Distinct31
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2018-05-01 00:00:00
Maximum2023-10-18 00:00:00
2023-12-12T18:40:39.865830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:40:40.048939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)

운영일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
평일
440 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row평일
2nd row평일
3rd row평일
4th row평일
5th row평일

Common Values

ValueCountFrequency (%)
평일 440
100.0%

Length

2023-12-12T18:40:40.244231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:40:40.401443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
평일 440
100.0%

운영시작시각
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2023-12-12 09:00:00
Maximum2023-12-12 09:00:00
2023-12-12T18:40:40.519678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:40:40.652003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

운영종료시각
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
Minimum2023-12-12 18:00:00
Maximum2023-12-12 18:00:00
2023-12-12T18:40:40.781321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:40:40.924137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T18:40:41.034095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동관리번호제품종류제품규격설치일자
행정동1.0000.0000.3960.4550.730
관리번호0.0001.0000.4210.1480.000
제품종류0.3960.4211.0000.3350.334
제품규격0.4550.1480.3351.0000.786
설치일자0.7300.0000.3340.7861.000
2023-12-12T18:40:41.172943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제품규격행정동제품종류
제품규격1.0000.2480.323
행정동0.2481.0000.194
제품종류0.3230.1941.000
2023-12-12T18:40:41.303642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동제품종류제품규격
행정동1.0000.1940.248
제품종류0.1941.0000.323
제품규격0.2480.3231.000

Missing values

2023-12-12T18:40:36.762460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:40:36.975387image/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신현동1-1경기도 시흥시 신현역 (한아름마트) 교차로 (포동 1-120)8각댄싱5M2023-06-18평일09:0018:00
1신현동1-2경기도 시흥시 미산동 484-26(포리1교 인근 삼거리)8각댄싱4M2023-08-19평일09:0018:00
2은행동1-1경기도 시흥시 은행 대우1차아파트 교차로(은행동 546)8각댄싱5M2023-06-18평일09:0018:00
3은행동1-2경기도 시흥시 맥도날드 횡단보도 (은행동 578)8각댄싱5M2023-06-18평일09:0018:00
4은행동1-3경기도 시흥시 은행사거리 (경동프라자) 교차로 (은행동 547-4)8각댄싱5M2023-06-18평일09:0018:00
5은행동1-4경기도 시흥시 은행동 38-15 (은계 센트럴타운 인근 사거리)8각댄싱3M2023-07-19평일09:0018:00
6은행동1-5경기도 시흥시 은행동 38-15 (은계 센트럴타운 인근 사거리)8각댄싱4M2023-07-19평일09:0018:00
7은행동1-6경기도 시흥시 은행동 38-15 (은계 센트럴타운 인근 사거리)8각댄싱4M2023-07-19평일09:0018:00
8은행동1-7경기도 시흥시 은행동 38-15 (은계 센트럴타운 인근 사거리)8각댄싱3M2023-07-19평일09:0018:00
9은행동1-8경기도 시흥시 은행동 32-18 (은계 네이처포레 인근 사거리)8각댄싱4M2023-07-19평일09:0018:00
행정동관리번호위치제품종류제품규격설치일자운영일자운영시작시각운영종료시각
430정왕3동1-16경기도 시흥시 정왕동1864(주공1단지 107동앞)8각댄싱3.5M2023-06-01평일09:0018:00
431정왕3동1-17경기도 시흥시 정왕동1853-1(통근집 건너편)8각댄싱3.5M2023-06-01평일09:0018:00
432정왕4동1-19경기도 시흥시 정왕동 1877-7(세종아파트 101동 앞)8각댄싱4M2023-06-01평일09:0018:00
433정왕4동1-20경기도 시흥시 정왕동1876-3(부성파스텔 101동 앞)스마트 그늘막3M2023-06-01평일09:0018:00
434정왕4동1-21경기도 시흥시 정왕동 1876-4(모아아파트 108동,113동 사이)8각댄싱4M2023-06-01평일09:0018:00
435정왕본동1-18경기도 시흥시 정왕동 876-462(정왕역 파리바게트 앞)8각댄싱4M2022-09-01평일09:0018:00
436정왕본동1-20경기도 시흥시 정왕동 1802-1(소방서 건너편)스마트 그늘막3M2023-06-01평일09:0018:00
437죽율동1-21경기도 시흥시 죽율동 276-1(죽율체육공원 앞)8각댄싱4M2023-06-01평일09:0018:00
438하상동1-15경기도 시흥시 하상동249-4(이삭자동차정비센터 앞 교통섬)8각댄싱5M2023-06-01평일09:0018:00
439하중동1-16경기도 시흥시 하중동 534-2(샛말대우 102동 앞)스마트 그늘막3M2023-06-01평일09:0018:00