Overview

Dataset statistics

Number of variables8
Number of observations148
Missing cells8
Missing cells (%)0.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.4 KiB
Average record size in memory64.9 B

Variable types

Categorical5
Text3

Dataset

Description대전시의 승용차 요일제 참여차량 할인 가맹점(시군구, 상호, 할인구분, 주소, 전화번호, 할인방법 등) 현황 입니다.
Author대전광역시
URLhttps://www.data.go.kr/data/15073561/fileData.do

Alerts

시도 has constant value ""Constant
할인방법 has constant value ""Constant
가맹점 상세조회 및 쿠폰발행 has constant value ""Constant
전화번호 has 8 (5.4%) missing valuesMissing
상호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:03:44.973888
Analysis finished2023-12-12 22:03:45.562603
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
대전광역시
148 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대전광역시
2nd row대전광역시
3rd row대전광역시
4th row대전광역시
5th row대전광역시

Common Values

ValueCountFrequency (%)
대전광역시 148
100.0%

Length

2023-12-13T07:03:45.642743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:45.767827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대전광역시 148
100.0%

시군구
Categorical

Distinct5
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
동구
55 
중구
36 
대덕구
27 
서구
17 
유성구
13 

Length

Max length3
Median length2
Mean length2.2702703
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row유성구
2nd row동구
3rd row서구
4th row대덕구
5th row유성구

Common Values

ValueCountFrequency (%)
동구 55
37.2%
중구 36
24.3%
대덕구 27
18.2%
서구 17
 
11.5%
유성구 13
 
8.8%

Length

2023-12-13T07:03:45.889226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:46.013695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동구 55
37.2%
중구 36
24.3%
대덕구 27
18.2%
서구 17
 
11.5%
유성구 13
 
8.8%

할인구분
Categorical

Distinct4
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
정비할인
63 
외식할인
60 
기타할인
23 
이,미용할인
 
2

Length

Max length6
Median length4
Mean length4.027027
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정비할인
2nd row정비할인
3rd row정비할인
4th row정비할인
5th row정비할인

Common Values

ValueCountFrequency (%)
정비할인 63
42.6%
외식할인 60
40.5%
기타할인 23
 
15.5%
이,미용할인 2
 
1.4%

Length

2023-12-13T07:03:46.180882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:46.322008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정비할인 63
42.6%
외식할인 60
40.5%
기타할인 23
 
15.5%
이,미용할인 2
 
1.4%

상호
Text

UNIQUE 

Distinct148
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-13T07:03:46.582147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length8
Mean length6.7297297
Min length2

Characters and Unicode

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

Unique

Unique148 ?
Unique (%)100.0%

Sample

1st row(주)서대전정비
2nd row(주)고속모터스
3rd row21세기모터스검사장
4th row삼우자동차정비(합)
5th row관저자동차공업사
ValueCountFrequency (%)
홈플러스 3
 
1.7%
꽃 2
 
1.1%
롯데마트 2
 
1.1%
신탄진점 2
 
1.1%
주)서대전정비 1
 
0.6%
행복한오리 1
 
0.6%
카페 1
 
0.6%
쉼 1
 
0.6%
조선건강원 1
 
0.6%
해맑은 1
 
0.6%
Other values (165) 165
91.7%
2023-12-13T07:03:47.039665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 36
 
3.6%
32
 
3.2%
대 27
 
2.7%
( 26
 
2.6%
동 23
 
2.3%
주 23
 
2.3%
) 23
 
2.3%
업 20
 
2.0%
점 19
 
1.9%
자 19
 
1.9%
Other values (254) 748
75.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 867
87.0%
Other Punctuation 37
 
3.7%
Space Separator 32
 
3.2%
Open Punctuation 26
 
2.6%
Close Punctuation 23
 
2.3%
Decimal Number 6
 
0.6%
Uppercase Letter 4
 
0.4%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 27
 
3.1%
동 23
 
2.7%
주 23
 
2.7%
업 20
 
2.3%
점 19
 
2.2%
자 19
 
2.2%
공 19
 
2.2%
스 19
 
2.2%
전 18
 
2.1%
사 18
 
2.1%
Other values (243) 662
76.4%
Uppercase Letter
ValueCountFrequency (%)
S 2
50.0%
G 1
25.0%
I 1
25.0%
Other Punctuation
ValueCountFrequency (%)
. 36
97.3%
· 1
 
2.7%
Decimal Number
ValueCountFrequency (%)
1 4
66.7%
2 2
33.3%
Space Separator
ValueCountFrequency (%)
32
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 867
87.0%
Common 125
 
12.6%
Latin 4
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 27
 
3.1%
동 23
 
2.7%
주 23
 
2.7%
업 20
 
2.3%
점 19
 
2.2%
자 19
 
2.2%
공 19
 
2.2%
스 19
 
2.2%
전 18
 
2.1%
사 18
 
2.1%
Other values (243) 662
76.4%
Common
ValueCountFrequency (%)
. 36
28.8%
32
25.6%
( 26
20.8%
) 23
18.4%
1 4
 
3.2%
2 2
 
1.6%
· 1
 
0.8%
- 1
 
0.8%
Latin
ValueCountFrequency (%)
S 2
50.0%
G 1
25.0%
I 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 867
87.0%
ASCII 128
 
12.9%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 36
28.1%
32
25.0%
( 26
20.3%
) 23
18.0%
1 4
 
3.1%
2 2
 
1.6%
S 2
 
1.6%
G 1
 
0.8%
- 1
 
0.8%
I 1
 
0.8%
Hangul
ValueCountFrequency (%)
대 27
 
3.1%
동 23
 
2.7%
주 23
 
2.7%
업 20
 
2.3%
점 19
 
2.2%
자 19
 
2.2%
공 19
 
2.2%
스 19
 
2.2%
전 18
 
2.1%
사 18
 
2.1%
Other values (243) 662
76.4%
None
ValueCountFrequency (%)
· 1
100.0%

주소
Text

Distinct139
Distinct (%)93.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-13T07:03:47.468259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length19
Mean length17.885135
Min length14

Characters and Unicode

Total characters2647
Distinct characters108
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

Unique132 ?
Unique (%)89.2%

Sample

1st row대전광역시 유성구 계백로 933-60
2nd row대전광역시 동구 합내로 73
3rd row대전광역시 서구 대덕대로 69-11
4th row대전광역시 대덕구 대화로 101
5th row대전광역시 유성구 계백로 937
ValueCountFrequency (%)
대전광역시 148
25.6%
동구 55
 
9.5%
중구 36
 
6.2%
대덕구 27
 
4.7%
서구 17
 
2.9%
유성구 13
 
2.3%
대전로 6
 
1.0%
계백로 6
 
1.0%
옥천로 6
 
1.0%
1 5
 
0.9%
Other values (207) 258
44.7%
2023-12-13T07:03:48.037346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
429
16.2%
대 223
 
8.4%
전 161
 
6.1%
시 149
 
5.6%
광 148
 
5.6%
역 148
 
5.6%
구 148
 
5.6%
로 145
 
5.5%
1 103
 
3.9%
동 74
 
2.8%
Other values (98) 919
34.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1711
64.6%
Decimal Number 484
 
18.3%
Space Separator 429
 
16.2%
Dash Punctuation 23
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 223
13.0%
전 161
 
9.4%
시 149
 
8.7%
광 148
 
8.6%
역 148
 
8.6%
구 148
 
8.6%
로 145
 
8.5%
동 74
 
4.3%
길 51
 
3.0%
번 51
 
3.0%
Other values (86) 413
24.1%
Decimal Number
ValueCountFrequency (%)
1 103
21.3%
2 66
13.6%
7 51
10.5%
4 48
9.9%
3 48
9.9%
6 45
9.3%
5 39
 
8.1%
8 32
 
6.6%
0 28
 
5.8%
9 24
 
5.0%
Space Separator
ValueCountFrequency (%)
429
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1711
64.6%
Common 936
35.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 223
13.0%
전 161
 
9.4%
시 149
 
8.7%
광 148
 
8.6%
역 148
 
8.6%
구 148
 
8.6%
로 145
 
8.5%
동 74
 
4.3%
길 51
 
3.0%
번 51
 
3.0%
Other values (86) 413
24.1%
Common
ValueCountFrequency (%)
429
45.8%
1 103
 
11.0%
2 66
 
7.1%
7 51
 
5.4%
4 48
 
5.1%
3 48
 
5.1%
6 45
 
4.8%
5 39
 
4.2%
8 32
 
3.4%
0 28
 
3.0%
Other values (2) 47
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1711
64.6%
ASCII 936
35.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
429
45.8%
1 103
 
11.0%
2 66
 
7.1%
7 51
 
5.4%
4 48
 
5.1%
3 48
 
5.1%
6 45
 
4.8%
5 39
 
4.2%
8 32
 
3.4%
0 28
 
3.0%
Other values (2) 47
 
5.0%
Hangul
ValueCountFrequency (%)
대 223
13.0%
전 161
 
9.4%
시 149
 
8.7%
광 148
 
8.6%
역 148
 
8.6%
구 148
 
8.6%
로 145
 
8.5%
동 74
 
4.3%
길 51
 
3.0%
번 51
 
3.0%
Other values (86) 413
24.1%

전화번호
Text

MISSING 

Distinct139
Distinct (%)99.3%
Missing8
Missing (%)5.4%
Memory size1.3 KiB
2023-12-13T07:03:48.302568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.978571
Min length9

Characters and Unicode

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

Unique138 ?
Unique (%)98.6%

Sample

1st row042-545-7183
2nd row042-627-4972
3rd row042-527-0203
4th row042-627-5600
5th row042-544-2222
ValueCountFrequency (%)
042-825-7465 2
 
1.4%
042-285-5060 1
 
0.7%
042-285-0393 1
 
0.7%
042-634-2511 1
 
0.7%
042-624-0079 1
 
0.7%
042-623-9633 1
 
0.7%
042-222-8852 1
 
0.7%
042-545-7181 1
 
0.7%
042-633-6887 1
 
0.7%
042-623-2050 1
 
0.7%
Other values (129) 129
92.1%
2023-12-13T07:03:48.714171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 308
18.4%
- 279
16.6%
0 228
13.6%
4 219
13.1%
5 114
 
6.8%
3 105
 
6.3%
8 99
 
5.9%
6 98
 
5.8%
7 86
 
5.1%
1 78
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1398
83.4%
Dash Punctuation 279
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 308
22.0%
0 228
16.3%
4 219
15.7%
5 114
 
8.2%
3 105
 
7.5%
8 99
 
7.1%
6 98
 
7.0%
7 86
 
6.2%
1 78
 
5.6%
9 63
 
4.5%
Dash Punctuation
ValueCountFrequency (%)
- 279
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1677
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 308
18.4%
- 279
16.6%
0 228
13.6%
4 219
13.1%
5 114
 
6.8%
3 105
 
6.3%
8 99
 
5.9%
6 98
 
5.8%
7 86
 
5.1%
1 78
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1677
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 308
18.4%
- 279
16.6%
0 228
13.6%
4 219
13.1%
5 114
 
6.8%
3 105
 
6.3%
8 99
 
5.9%
6 98
 
5.8%
7 86
 
5.1%
1 78
 
4.7%

할인방법
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
쿠폰발행
148 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row쿠폰발행
2nd row쿠폰발행
3rd row쿠폰발행
4th row쿠폰발행
5th row쿠폰발행

Common Values

ValueCountFrequency (%)
쿠폰발행 148
100.0%

Length

2023-12-13T07:03:48.859219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:48.967753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
쿠폰발행 148
100.0%

가맹점 상세조회 및 쿠폰발행
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
http://carfree.daejeon.go.kr/benefit/discountStore.do
148 

Length

Max length53
Median length53
Mean length53
Min length53

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhttp://carfree.daejeon.go.kr/benefit/discountStore.do
2nd rowhttp://carfree.daejeon.go.kr/benefit/discountStore.do
3rd rowhttp://carfree.daejeon.go.kr/benefit/discountStore.do
4th rowhttp://carfree.daejeon.go.kr/benefit/discountStore.do
5th rowhttp://carfree.daejeon.go.kr/benefit/discountStore.do

Common Values

ValueCountFrequency (%)
http://carfree.daejeon.go.kr/benefit/discountStore.do 148
100.0%

Length

2023-12-13T07:03:49.076675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:03:49.208041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
http://carfree.daejeon.go.kr/benefit/discountstore.do 148
100.0%

Correlations

2023-12-13T07:03:49.267319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구할인구분
시군구1.0000.348
할인구분0.3481.000
2023-12-13T07:03:49.350244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구할인구분
시군구1.0000.289
할인구분0.2891.000
2023-12-13T07:03:49.434006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구할인구분
시군구1.0000.289
할인구분0.2891.000

Missing values

2023-12-13T07:03:45.360091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:03:45.501486image/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대전광역시유성구정비할인(주)서대전정비대전광역시 유성구 계백로 933-60042-545-7183쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
1대전광역시동구정비할인(주)고속모터스대전광역시 동구 합내로 73042-627-4972쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
2대전광역시서구정비할인21세기모터스검사장대전광역시 서구 대덕대로 69-11042-527-0203쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
3대전광역시대덕구정비할인삼우자동차정비(합)대전광역시 대덕구 대화로 101042-627-5600쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
4대전광역시유성구정비할인관저자동차공업사대전광역시 유성구 계백로 937042-544-2222쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
5대전광역시서구정비할인빛나는자동차공업사(...대전광역시 서구 도산로 365042-523-9301쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
6대전광역시동구외식할인한성식당대전광역시 동구 우암로 366042-673-1645쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
7대전광역시대덕구정비할인삼성자동차공업(주)대전광역시 대덕구 신일동로33번길 85042-936-7777쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
8대전광역시동구외식할인정일품 활어회대전광역시 동구 계족로 521042-624-0608쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
9대전광역시동구외식할인예뫼골대전광역시 동구 곤룡로 8042-273-0588쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
시도시군구할인구분상호주소전화번호할인방법가맹점 상세조회 및 쿠폰발행
138대전광역시동구외식할인행복오리대전광역시 동구 가양로 126042-637-9252쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
139대전광역시동구정비할인신용카센터대전광역시 동구 가양로 138-2042-623-5108쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
140대전광역시중구기타할인대전아쿠아리움대전광역시 중구 보문산공원로 469042-226-2100쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
141대전광역시동구외식할인해와솔대전광역시 동구 대전로 624042-271-3921쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
142대전광역시중구외식할인봉구스밥버거대전광역시 중구 대흥로 125042-222-0945쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
143대전광역시동구정비할인이레자동차공업사대전광역시 동구 대전로 723-8042-284-4972쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
144대전광역시중구정비할인오토오아시스 태평점대전광역시 중구 수침로 91042-528-1115쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
145대전광역시동구기타할인중앙장식대전광역시 동구 흥룡로 37042-626-5198쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
146대전광역시대덕구외식할인청정 제주 똥도야지대전광역시 대덕구 중리남로 41-1042-632-3949쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do
147대전광역시대덕구이,미용할인경 미용실대전광역시 대덕구 덕암북로22번길 52<NA>쿠폰발행http://carfree.daejeon.go.kr/benefit/discountStore.do