Overview

Dataset statistics

Number of variables4
Number of observations189
Missing cells20
Missing cells (%)2.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.0 KiB
Average record size in memory32.7 B

Variable types

Text3
DateTime1

Dataset

Description경상남도 거제시 교통카드판매(충전)소 현황(가맹점명, 주소, 위도, 경도, 전화번호, 기준일자)등에 대한 정보를 제공합니다.
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=3080039

Alerts

기준일 has constant value ""Constant
전화번호 has 20 (10.6%) missing valuesMissing
충전소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:25:59.126043
Analysis finished2023-12-10 23:25:59.452127
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

충전소명
Text

UNIQUE 

Distinct189
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-11T08:25:59.644002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length7.7037037
Min length3

Characters and Unicode

Total characters1456
Distinct characters196
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

Unique189 ?
Unique (%)100.0%

Sample

1st row21세기한일병원편의점
2nd rowA플러스할인마트
3rd rowCU 거제능포해안점
4th rowCU 거제성포점
5th rowCU 거제수양점
ValueCountFrequency (%)
훼미리마트 22
 
8.2%
거제 7
 
2.6%
하나로마트 7
 
2.6%
씨유 5
 
1.9%
신현농협 4
 
1.5%
훼미리 3
 
1.1%
cu 3
 
1.1%
위드미 3
 
1.1%
썬마트 3
 
1.1%
코사마트 3
 
1.1%
Other values (201) 207
77.5%
2023-12-11T08:26:00.139968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
110
 
7.6%
95
 
6.5%
93
 
6.4%
78
 
5.4%
52
 
3.6%
51
 
3.5%
36
 
2.5%
35
 
2.4%
31
 
2.1%
26
 
1.8%
Other values (186) 849
58.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1331
91.4%
Space Separator 78
 
5.4%
Decimal Number 22
 
1.5%
Uppercase Letter 19
 
1.3%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%
Lowercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
110
 
8.3%
95
 
7.1%
93
 
7.0%
52
 
3.9%
51
 
3.8%
36
 
2.7%
35
 
2.6%
31
 
2.3%
26
 
2.0%
26
 
2.0%
Other values (172) 776
58.3%
Uppercase Letter
ValueCountFrequency (%)
C 5
26.3%
U 5
26.3%
G 4
21.1%
S 4
21.1%
A 1
 
5.3%
Decimal Number
ValueCountFrequency (%)
2 10
45.5%
5 7
31.8%
1 4
 
18.2%
3 1
 
4.5%
Lowercase Letter
ValueCountFrequency (%)
s 1
50.0%
g 1
50.0%
Space Separator
ValueCountFrequency (%)
78
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1331
91.4%
Common 104
 
7.1%
Latin 21
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
110
 
8.3%
95
 
7.1%
93
 
7.0%
52
 
3.9%
51
 
3.8%
36
 
2.7%
35
 
2.6%
31
 
2.3%
26
 
2.0%
26
 
2.0%
Other values (172) 776
58.3%
Common
ValueCountFrequency (%)
78
75.0%
2 10
 
9.6%
5 7
 
6.7%
1 4
 
3.8%
) 2
 
1.9%
( 2
 
1.9%
3 1
 
1.0%
Latin
ValueCountFrequency (%)
C 5
23.8%
U 5
23.8%
G 4
19.0%
S 4
19.0%
A 1
 
4.8%
s 1
 
4.8%
g 1
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1331
91.4%
ASCII 125
 
8.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
110
 
8.3%
95
 
7.1%
93
 
7.0%
52
 
3.9%
51
 
3.8%
36
 
2.7%
35
 
2.6%
31
 
2.3%
26
 
2.0%
26
 
2.0%
Other values (172) 776
58.3%
ASCII
ValueCountFrequency (%)
78
62.4%
2 10
 
8.0%
5 7
 
5.6%
C 5
 
4.0%
U 5
 
4.0%
G 4
 
3.2%
S 4
 
3.2%
1 4
 
3.2%
) 2
 
1.6%
( 2
 
1.6%
Other values (4) 4
 
3.2%
Distinct181
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-11T08:26:00.471825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length41
Mean length26.349206
Min length5

Characters and Unicode

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

Unique

Unique173 ?
Unique (%)91.5%

Sample

1st row경상남도 거제시 사등면 지석리 580-4번지
2nd row 139 가람빌딩1층
3rd row경상남도 거제시능포동 능포로 227-0 (능포동) 514-12
4th row경상남도 거제시 사등면 석포로 127
5th row경상남도 거제시수양동 수양로 456-0 (수월동)
ValueCountFrequency (%)
경상남도 169
 
17.5%
거제시 105
 
10.9%
고현동 27
 
2.8%
사등면 18
 
1.9%
옥포동 16
 
1.7%
일운면 15
 
1.6%
1층 14
 
1.5%
아주동 13
 
1.3%
양정동 10
 
1.0%
거제시고현동 10
 
1.0%
Other values (360) 568
58.9%
2023-12-11T08:26:00.938884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
838
 
16.8%
1 229
 
4.6%
217
 
4.4%
217
 
4.4%
194
 
3.9%
178
 
3.6%
175
 
3.5%
174
 
3.5%
171
 
3.4%
170
 
3.4%
Other values (170) 2417
48.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2887
58.0%
Decimal Number 920
 
18.5%
Space Separator 838
 
16.8%
Dash Punctuation 154
 
3.1%
Close Punctuation 75
 
1.5%
Open Punctuation 75
 
1.5%
Other Punctuation 18
 
0.4%
Math Symbol 9
 
0.2%
Uppercase Letter 3
 
0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
217
 
7.5%
217
 
7.5%
194
 
6.7%
178
 
6.2%
175
 
6.1%
174
 
6.0%
171
 
5.9%
170
 
5.9%
96
 
3.3%
83
 
2.9%
Other values (149) 1212
42.0%
Decimal Number
ValueCountFrequency (%)
1 229
24.9%
0 147
16.0%
2 95
10.3%
4 80
 
8.7%
3 73
 
7.9%
5 71
 
7.7%
8 61
 
6.6%
9 61
 
6.6%
6 59
 
6.4%
7 44
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
T 1
33.3%
B 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 17
94.4%
. 1
 
5.6%
Space Separator
ValueCountFrequency (%)
838
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 154
100.0%
Close Punctuation
ValueCountFrequency (%)
) 75
100.0%
Open Punctuation
ValueCountFrequency (%)
( 75
100.0%
Math Symbol
ValueCountFrequency (%)
~ 9
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2887
58.0%
Common 2089
41.9%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
217
 
7.5%
217
 
7.5%
194
 
6.7%
178
 
6.2%
175
 
6.1%
174
 
6.0%
171
 
5.9%
170
 
5.9%
96
 
3.3%
83
 
2.9%
Other values (149) 1212
42.0%
Common
ValueCountFrequency (%)
838
40.1%
1 229
 
11.0%
- 154
 
7.4%
0 147
 
7.0%
2 95
 
4.5%
4 80
 
3.8%
) 75
 
3.6%
( 75
 
3.6%
3 73
 
3.5%
5 71
 
3.4%
Other values (7) 252
 
12.1%
Latin
ValueCountFrequency (%)
K 1
25.0%
T 1
25.0%
B 1
25.0%
e 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2887
58.0%
ASCII 2093
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
838
40.0%
1 229
 
10.9%
- 154
 
7.4%
0 147
 
7.0%
2 95
 
4.5%
4 80
 
3.8%
) 75
 
3.6%
( 75
 
3.6%
3 73
 
3.5%
5 71
 
3.4%
Other values (11) 256
 
12.2%
Hangul
ValueCountFrequency (%)
217
 
7.5%
217
 
7.5%
194
 
6.7%
178
 
6.2%
175
 
6.1%
174
 
6.0%
171
 
5.9%
170
 
5.9%
96
 
3.3%
83
 
2.9%
Other values (149) 1212
42.0%

전화번호
Text

MISSING 

Distinct122
Distinct (%)72.2%
Missing20
Missing (%)10.6%
Memory size1.6 KiB
2023-12-11T08:26:01.172885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.994083
Min length11

Characters and Unicode

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

Unique79 ?
Unique (%)46.7%

Sample

1st row055-634-0911
2nd row055-637-0688
3rd row055-682-2804
4th row055-681-7284
5th row055-681-9855
ValueCountFrequency (%)
055-634-0636 3
 
1.8%
055-681-6601 3
 
1.8%
055-635-2138 3
 
1.8%
055-634-5551 3
 
1.8%
055-636-6138 2
 
1.2%
055-636-5005 2
 
1.2%
055-682-1209 2
 
1.2%
055-635-1778 2
 
1.2%
055-687-6413 2
 
1.2%
055-681-0075 2
 
1.2%
Other values (112) 145
85.8%
2023-12-11T08:26:01.576892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 430
21.2%
- 338
16.7%
0 274
13.5%
6 261
12.9%
3 178
8.8%
8 152
 
7.5%
1 104
 
5.1%
4 85
 
4.2%
2 81
 
4.0%
7 79
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1689
83.3%
Dash Punctuation 338
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 430
25.5%
0 274
16.2%
6 261
15.5%
3 178
10.5%
8 152
 
9.0%
1 104
 
6.2%
4 85
 
5.0%
2 81
 
4.8%
7 79
 
4.7%
9 45
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 338
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2027
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 430
21.2%
- 338
16.7%
0 274
13.5%
6 261
12.9%
3 178
8.8%
8 152
 
7.5%
1 104
 
5.1%
4 85
 
4.2%
2 81
 
4.0%
7 79
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2027
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 430
21.2%
- 338
16.7%
0 274
13.5%
6 261
12.9%
3 178
8.8%
8 152
 
7.5%
1 104
 
5.1%
4 85
 
4.2%
2 81
 
4.0%
7 79
 
3.9%

기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2020-06-16 00:00:00
Maximum2020-06-16 00:00:00
2023-12-11T08:26:01.694468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:26:01.803035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-11T08:25:59.350140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:25:59.419719image/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

충전소명도로명주소(지번주소)전화번호기준일
021세기한일병원편의점경상남도 거제시 사등면 지석리 580-4번지055-634-09112020-06-16
1A플러스할인마트139 가람빌딩1층055-637-06882020-06-16
2CU 거제능포해안점경상남도 거제시능포동 능포로 227-0 (능포동) 514-12055-682-28042020-06-16
3CU 거제성포점경상남도 거제시 사등면 석포로 127<NA>2020-06-16
4CU 거제수양점경상남도 거제시수양동 수양로 456-0 (수월동)<NA>2020-06-16
5CU아주행복한점경상남도 거제시 아주동 273-3055-681-72842020-06-16
6GS25 거제대우서문점경상남도 거제시 아주동 742055-681-98552020-06-16
7GS25 대우남문점경상남도 거제시 아주동 445-2055-682-03282020-06-16
8GS25거제대우남문점경상남도 거제시아주동 거제대로 3441-0 (아주동)055-682-03282020-06-16
9gs25옥포주공점경상남도 거제시옥포2동 옥포중앙로 90-0 (옥포동)055-688-16962020-06-16
충전소명도로명주소(지번주소)전화번호기준일
179훼미리마트 아리랑호텔점부산광역시 동구 초량동 1204-1 훼미리마트 아리랑호텔점<NA>2020-06-16
180훼미리마트 아주원룸점경상남도 거제시 아주동 896-5055-682-47322020-06-16
181훼미리마트 옥포금산점경상남도 거제시 옥포동 540-18055-688-60522020-06-16
182훼미리마트 옥포주공점경상남도 거제시 옥포2동 501~532 510-10 주공사거리055-688-16962020-06-16
183훼미리마트 장평스마일점660-3055-638-08512020-06-16
184훼미리마트 해금강점997-5055-637-82202020-06-16
185훼미리마트고현운동장점경상남도 거제시 고현동 750055-633-50212020-06-16
186훼미리마트고현점206번지055-635-21382020-06-16
187훼미리마트옥포명성점경상남도 거제시 옥포동 544-15 (옥포농협하나로마트)055-688-35742020-06-16
188훼미리마트장승포점경상남도 거제시 능포동 710 문학상가 훼미리마트장승포점055-682-12092020-06-16