Overview

Dataset statistics

Number of variables10
Number of observations265
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.8 KiB
Average record size in memory80.5 B

Variable types

Text2
Categorical8

Dataset

Description2018년_추석명절_개방주차장_현황_전라북도
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=201922

Alerts

24일개방시간 is highly overall correlated with 관리기관 and 5 other fieldsHigh correlation
관리기관 is highly overall correlated with 전화번호 and 6 other fieldsHigh correlation
전화번호 is highly overall correlated with 관리기관 and 6 other fieldsHigh correlation
23일개방시간 is highly overall correlated with 관리기관 and 6 other fieldsHigh correlation
25일개방시간 is highly overall correlated with 관리기관 and 5 other fieldsHigh correlation
26일개방시간 is highly overall correlated with 관리기관 and 5 other fieldsHigh correlation
특이사항 is highly overall correlated with 관리기관 and 2 other fieldsHigh correlation
22일 토 개방시간 is highly overall correlated with 관리기관 and 5 other fieldsHigh correlation
특이사항 is highly imbalanced (86.1%)Imbalance

Reproduction

Analysis started2024-03-14 02:05:19.059373
Analysis finished2024-03-14 02:05:19.842963
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct263
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2024-03-14T11:05:19.990046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length14
Mean length9.0716981
Min length2

Characters and Unicode

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

Unique

Unique261 ?
Unique (%)98.5%

Sample

1st row건산천 제1주차장
2nd row건산천 제2주차장
3rd row삼천2동
4th row중화산2동
5th row서신동
ValueCountFrequency (%)
주차장 57
 
11.7%
16
 
3.3%
12
 
2.5%
고창읍 10
 
2.1%
공영주차장 9
 
1.9%
고창 8
 
1.6%
나운동 7
 
1.4%
6
 
1.2%
수송동 5
 
1.0%
봉동 5
 
1.0%
Other values (302) 351
72.2%
2024-03-14T11:05:20.340303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
224
 
9.3%
215
 
8.9%
170
 
7.1%
161
 
6.7%
85
 
3.5%
65
 
2.7%
42
 
1.7%
42
 
1.7%
40
 
1.7%
35
 
1.5%
Other values (272) 1325
55.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2102
87.4%
Space Separator 224
 
9.3%
Decimal Number 27
 
1.1%
Close Punctuation 21
 
0.9%
Open Punctuation 19
 
0.8%
Other Punctuation 6
 
0.2%
Uppercase Letter 5
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
215
 
10.2%
170
 
8.1%
161
 
7.7%
85
 
4.0%
65
 
3.1%
42
 
2.0%
42
 
2.0%
40
 
1.9%
35
 
1.7%
34
 
1.6%
Other values (255) 1213
57.7%
Other Punctuation
ValueCountFrequency (%)
@ 2
33.3%
. 1
16.7%
, 1
16.7%
· 1
16.7%
1
16.7%
Uppercase Letter
ValueCountFrequency (%)
T 1
20.0%
K 1
20.0%
C 1
20.0%
B 1
20.0%
M 1
20.0%
Decimal Number
ValueCountFrequency (%)
2 13
48.1%
1 10
37.0%
3 3
 
11.1%
4 1
 
3.7%
Space Separator
ValueCountFrequency (%)
224
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2102
87.4%
Common 297
 
12.4%
Latin 5
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
215
 
10.2%
170
 
8.1%
161
 
7.7%
85
 
4.0%
65
 
3.1%
42
 
2.0%
42
 
2.0%
40
 
1.9%
35
 
1.7%
34
 
1.6%
Other values (255) 1213
57.7%
Common
ValueCountFrequency (%)
224
75.4%
) 21
 
7.1%
( 19
 
6.4%
2 13
 
4.4%
1 10
 
3.4%
3 3
 
1.0%
@ 2
 
0.7%
. 1
 
0.3%
, 1
 
0.3%
· 1
 
0.3%
Other values (2) 2
 
0.7%
Latin
ValueCountFrequency (%)
T 1
20.0%
K 1
20.0%
C 1
20.0%
B 1
20.0%
M 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2102
87.4%
ASCII 300
 
12.5%
None 2
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
224
74.7%
) 21
 
7.0%
( 19
 
6.3%
2 13
 
4.3%
1 10
 
3.3%
3 3
 
1.0%
@ 2
 
0.7%
. 1
 
0.3%
T 1
 
0.3%
K 1
 
0.3%
Other values (5) 5
 
1.7%
Hangul
ValueCountFrequency (%)
215
 
10.2%
170
 
8.1%
161
 
7.7%
85
 
4.0%
65
 
3.1%
42
 
2.0%
42
 
2.0%
40
 
1.9%
35
 
1.7%
34
 
1.6%
Other values (255) 1213
57.7%
None
ValueCountFrequency (%)
· 1
50.0%
1
50.0%

주소
Text

Distinct263
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2024-03-14T11:05:20.695713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length28
Mean length20.203774
Min length11

Characters and Unicode

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

Unique

Unique261 ?
Unique (%)98.5%

Sample

1st row전라북도 전주시 덕진구 진북동 434-34
2nd row전라북도 전주시 덕진구 태진로 125-22
3rd row전라북도 전주시 완산구 삼천동1가 632-5
4th row전라북도 전주시 완산구 중화산동2가 486-2
5th row전라북도 전주시 완산구 서신동 795
ValueCountFrequency (%)
전라북도 233
 
18.9%
군산시 54
 
4.4%
장수군 31
 
2.5%
익산시 29
 
2.4%
남원시 25
 
2.0%
읍내리 24
 
1.9%
고창군 21
 
1.7%
김제시 19
 
1.5%
무주읍 18
 
1.5%
무주군 18
 
1.5%
Other values (456) 759
61.7%
2024-03-14T11:05:21.146405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
969
 
18.1%
246
 
4.6%
242
 
4.5%
237
 
4.4%
234
 
4.4%
1 210
 
3.9%
- 188
 
3.5%
182
 
3.4%
2 148
 
2.8%
142
 
2.7%
Other values (154) 2556
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3117
58.2%
Decimal Number 1067
 
19.9%
Space Separator 969
 
18.1%
Dash Punctuation 188
 
3.5%
Open Punctuation 6
 
0.1%
Close Punctuation 6
 
0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
246
 
7.9%
242
 
7.8%
237
 
7.6%
234
 
7.5%
182
 
5.8%
142
 
4.6%
140
 
4.5%
121
 
3.9%
118
 
3.8%
117
 
3.8%
Other values (139) 1338
42.9%
Decimal Number
ValueCountFrequency (%)
1 210
19.7%
2 148
13.9%
3 125
11.7%
5 115
10.8%
8 93
8.7%
4 91
8.5%
6 85
8.0%
7 77
 
7.2%
9 63
 
5.9%
0 60
 
5.6%
Space Separator
ValueCountFrequency (%)
969
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 188
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3117
58.2%
Common 2237
41.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
246
 
7.9%
242
 
7.8%
237
 
7.6%
234
 
7.5%
182
 
5.8%
142
 
4.6%
140
 
4.5%
121
 
3.9%
118
 
3.8%
117
 
3.8%
Other values (139) 1338
42.9%
Common
ValueCountFrequency (%)
969
43.3%
1 210
 
9.4%
- 188
 
8.4%
2 148
 
6.6%
3 125
 
5.6%
5 115
 
5.1%
8 93
 
4.2%
4 91
 
4.1%
6 85
 
3.8%
7 77
 
3.4%
Other values (5) 136
 
6.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3117
58.2%
ASCII 2237
41.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
969
43.3%
1 210
 
9.4%
- 188
 
8.4%
2 148
 
6.6%
3 125
 
5.6%
5 115
 
5.1%
8 93
 
4.2%
4 91
 
4.1%
6 85
 
3.8%
7 77
 
3.4%
Other values (5) 136
 
6.1%
Hangul
ValueCountFrequency (%)
246
 
7.9%
242
 
7.8%
237
 
7.6%
234
 
7.5%
182
 
5.8%
142
 
4.6%
140
 
4.5%
121
 
3.9%
118
 
3.8%
117
 
3.8%
Other values (139) 1338
42.9%

관리기관
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
전라북도 군산시청
54 
전라북도 장수군청
31 
전라북도 익산시청
29 
남원시청 교통과
23 
전라북도 고창군청
21 
Other values (10)
107 

Length

Max length9
Median length9
Mean length8.690566
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전주시설관리공단
2nd row전주시설관리공단
3rd row전주시설관리공단
4th row전주시설관리공단
5th row전주시설관리공단

Common Values

ValueCountFrequency (%)
전라북도 군산시청 54
20.4%
전라북도 장수군청 31
11.7%
전라북도 익산시청 29
10.9%
남원시청 교통과 23
8.7%
전라북도 고창군청 21
 
7.9%
전라북도 김제시청 19
 
7.2%
전라북도 무주군 18
 
6.8%
전라북도 부안군 16
 
6.0%
전라북도 완주군청 14
 
5.3%
전라북도 순창군청 13
 
4.9%
Other values (5) 27
10.2%

Length

2024-03-14T11:05:21.481805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전라북도 222
42.8%
군산시청 54
 
10.4%
장수군청 31
 
6.0%
익산시청 29
 
5.6%
남원시청 23
 
4.4%
교통과 23
 
4.4%
고창군청 21
 
4.0%
김제시청 19
 
3.7%
무주군 18
 
3.5%
부안군 16
 
3.1%
Other values (9) 63
 
12.1%

전화번호
Categorical

HIGH CORRELATION 

Distinct47
Distinct (%)17.7%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
063-454-3812
54 
063-350-2364
31 
063-620-6578
23 
063-560-2572
21 
063-540-3874
19 
Other values (42)
117 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique30 ?
Unique (%)11.3%

Sample

1st row063-239-2613
2nd row063-239-2613
3rd row063-239-2613
4th row063-239-2613
5th row063-239-2613

Common Values

ValueCountFrequency (%)
063-454-3812 54
20.4%
063-350-2364 31
11.7%
063-620-6578 23
8.7%
063-560-2572 21
 
7.9%
063-540-3874 19
 
7.2%
063-320-2365 18
 
6.8%
063-290-2802 14
 
5.3%
063-650-1328 13
 
4.9%
063-239-2613 11
 
4.2%
063-859-5899 8
 
3.0%
Other values (37) 53
20.0%

Length

2024-03-14T11:05:21.576102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
063-454-3812 54
20.4%
063-350-2364 31
11.7%
063-620-6578 23
8.7%
063-560-2572 21
 
7.9%
063-540-3874 19
 
7.2%
063-320-2365 18
 
6.8%
063-290-2802 14
 
5.3%
063-650-1328 13
 
4.9%
063-239-2613 11
 
4.2%
063-859-5899 8
 
3.0%
Other values (37) 53
20.0%

22일 토 개방시간
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
0:00-24:00
136 
9:00-18:00
54 
9:00-0:00
25 
9:00-24:00
19 
12:00-24:00
18 
Other values (2)
 
13

Length

Max length11
Median length10
Mean length9.7698113
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
0:00-24:00 136
51.3%
9:00-18:00 54
 
20.4%
9:00-0:00 25
 
9.4%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
<NA> 9
 
3.4%
19:00-0:00 4
 
1.5%

Length

2024-03-14T11:05:21.668593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T11:05:21.756365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0:00-24:00 136
51.3%
9:00-18:00 54
 
20.4%
9:00-0:00 25
 
9.4%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
na 9
 
3.4%
19:00-0:00 4
 
1.5%

23일개방시간
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
0:00-24:00
145 
9:00-18:00
54 
9:00-0:00
24 
9:00-24:00
19 
12:00-24:00
18 

Length

Max length11
Median length10
Mean length9.9773585
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0:00-24:00
2nd row0:00-24:00
3rd row0:00-24:00
4th row0:00-24:00
5th row0:00-24:00

Common Values

ValueCountFrequency (%)
0:00-24:00 145
54.7%
9:00-18:00 54
 
20.4%
9:00-0:00 24
 
9.1%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
19:00-0:00 5
 
1.9%

Length

2024-03-14T11:05:21.858942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T11:05:21.993074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0:00-24:00 145
54.7%
9:00-18:00 54
 
20.4%
9:00-0:00 24
 
9.1%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
19:00-0:00 5
 
1.9%

24일개방시간
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
0:00-24:00
137 
9:00-18:00
54 
9:00-0:00
25 
9:00-24:00
19 
12:00-24:00
18 
Other values (2)
 
12

Length

Max length11
Median length10
Mean length9.7924528
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
0:00-24:00 137
51.7%
9:00-18:00 54
 
20.4%
9:00-0:00 25
 
9.4%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
<NA> 8
 
3.0%
19:00-0:00 4
 
1.5%

Length

2024-03-14T11:05:22.119564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T11:05:22.207415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0:00-24:00 137
51.7%
9:00-18:00 54
 
20.4%
9:00-0:00 25
 
9.4%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
na 8
 
3.0%
19:00-0:00 4
 
1.5%

25일개방시간
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
0:00-24:00
136 
9:00-18:00
54 
9:00-0:00
25 
9:00-24:00
19 
12:00-24:00
18 
Other values (2)
 
13

Length

Max length11
Median length10
Mean length9.7698113
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
0:00-24:00 136
51.3%
9:00-18:00 54
 
20.4%
9:00-0:00 25
 
9.4%
9:00-24:00 19
 
7.2%
12:00-24:00 18
 
6.8%
<NA> 9
 
3.4%
19:00-0:00 4
 
1.5%

Length

2024-03-14T11:05:22.312746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T11:05:22.413703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/